Venkata Gonuguntla
Hounslow
Summary
A skilled Data Engineer and SQL DBA & SQL Developer with over 6.7 years of experience in database management, data warehousing, and business intelligence, specializing in SQL Server, Azure Data Solutions, and Power BI. Seeking career advancement with an esteemed organization to leverage my expertise in SQL database administration, ETL processes, and Azure data platforms to deliver high-performance, scalable data solutions. Adept at designing and developing data pipelines, ensuring data quality and accuracy, and optimizing performance for data-driven decision-making and business growth.
Overview
9
9
years of professional experience
1
1
Certification
Work History
Data Warehouse Developer
Capita
01.2024 - 11.2024
- Developed, modelled, and maintained data pipelines to ingest, store, process, and present data, ensuring data quality, accuracy, and consistency
- Collaborated with data architects to align data pipelines with the overall data architecture strategy
- Performed data transformation tasks, including cleansing, enrichment, and aggregation for analytics and reporting
- Integrated data from structured and unstructured sources, ensuring compatibility with data models and business requirements
- Implemented data quality checks and validation processes to identify and resolve data anomalies and errors
- Utilized U-SQL in Azure Data Lake and managed data loading into Azure Synapse Analytics via Polybase and ADF
- Developed parameterized, linked, and interactive drill-down and drill-through reports in SSRS
- Transitioned SSIS packages to Azure Data Factory, automating ETL processes
Senior Data Engineer
Pure One Solutions
09.2022 - 12.2023
- Designed and optimized data pipelines for retrieval, ingestion, presentation, and semantics in an Azure environment
- Created and optimized stored procedures and views for Tableau reporting datasets
- Configured and managed database systems, integrating cross-server data and automating processes via SQL Server Agent
- Enhanced database security and performance, implementing role-based security and monitoring to prevent deadlocks and CPU overuse
- Migrated SQL Server 2014 to 2016, transforming data from multiple sources into Dim and Fact Tables in the data warehouse
- Developed SSIS packages with Slowly Changing Dimensions (SCD) and Lookup transformations for robust ETL workflows
SQL Developer
Altruista Health
03.2016 - 07.2020
- Developed SQL procedures and functions for data processing, enhancing data handling and accessibility
- Created advanced reports and visualizations in SQL Server Reporting Services (SSRS) with cascaded parameters for multi-dataset reporting
- Managed SQL Server performance and security, implementing robust backup and recovery plans and optimizing server operations
- Growth Path: Associate SQL DBA (03/2016-04/2017) | SQL Server Developer (05/2017-08/2019) | SQL Developer (09/2019-07/2020)
Education
Master’s degree - advanced computer science
University of Hertfordshire
Hatfield, London01.2023
Bachelor of Technology - Electronics and Communication Engineering (ECE)
Jawaharlal Nehru Technological University
Kakinada, India01.2014
Skills
- Database Management
- Database Development
- Microsoft SQL Server
- Database Design
- Business Intelligence
- SQL Server Reporting Services (SSRS)
- SQL Server Analysis Services (SSAS)
- Power BI
- Report Writing
- Data Visualization
- Interactive Reports
- Dashboards
- Data Integration
- ETL Processes
- SQL Server Integration Services (SSIS)
- Data Extraction
- Data Transformation
- Data Loading
- Cloud Technologies
- Azure Data Factory
- Azure Data Lake
- Azure SQL Data Warehouse
- Data Security
- Data Compliance
- Database Security Measures
- Data Masking
- Data Encryption
- Performance Optimization
- Query Optimization
Certification
- Microsoft Certified : Azure Data Fundamentals.
Timeline
Data Warehouse Developer
Capita
01.2024 - 11.2024
Senior Data Engineer
Pure One Solutions
09.2022 - 12.2023
SQL Developer
Altruista Health
03.2016 - 07.2020
Bachelor of Technology - Electronics and Communication Engineering (ECE)
Jawaharlal Nehru Technological University
Master’s degree - advanced computer science
University of Hertfordshire
Similar Profiles
Rowan WardRowan Ward
Tools Operations Manager (ITSM) at CapitaTools Operations Manager (ITSM) at Capita
Thomas StaleyThomas Staley
Customer service representative at CapitaCustomer service representative at Capita
Alastair MortonAlastair Morton
Customer service advisor at CapitaCustomer service advisor at Capita
Vinod KommineniVinod Kommineni
Network Administrator at CapitaNetwork Administrator at Capita
Mohammed Lateef UddinMohammed Lateef Uddin
Accountant at Khpalwaak LtdAccountant at Khpalwaak Ltd