Hemanth Kumar Pethakamsetty
Hyderabad
Summary
Lead Data Engineer with around 11 years of expertise in Data Administration, Business Intelligence, and Data Warehouse projects. Demonstrated ability to gather requirements, perform data analysis, and document processes effectively. Proven track record in managing operational and development teams while designing and maintaining ETL processes across Finance and Healthcare sectors. Experienced in building large-scale data lakehouse solutions with Databricks and Snowflake, and proficient in creating Power BI dashboards while overseeing Software Development Life Cycle phases using Agile and Waterfall methodologies.
Overview
10
10
years of professional experience
1
1
Certification
Work History
Lead Data Engineer
Providence India
Hyderabad
11.2022 - Current
- Directed a team of 8 in executing migration projects to Azure SQL from on-premises systems.
- Designed and implemented data pipelines to enhance data processing efficiency.
- Ensured data quality and integrity across all integrated systems.
- Facilitated team meetings to review project status and address challenges.
- Conducted root cause analysis on failed jobs by troubleshooting underlying system issues.
- Developed SQL scripts for querying, updating, and managing databases, optimizing performance.
- Managed Azure infrastructure while effectively controlling associated costs.
Data Engineering Consultant
Optum
Hyderabad
11.2019 - 11.2022
- Developed Azure Data Factory pipelines to meet business requirements using blob storage and ingesting data into Azure Synapse Analytics.
- Conducted system evaluations to ensure alignment with industry standards and regulations.
- Mentored junior engineers, fostering skill development and knowledge sharing within the team.
- Processed fixed-width files with derived column activity, loading them into ADLS and Azure Synapse Analytics via copy activity.
- Created Power BI dashboards and reports based on functional specifications and development standards for various projects.
- Designed and implemented data solutions, including partitioning, normalization, denormalization, aggregations, and ETL processes for data warehousing.
- Migrated legacy SSRS reports to Power BI to enhance reporting capabilities.
- Collaborated with business teams to gather reporting and analytics requirements for improved decision-making.
- Developed new database schemas and reviewed existing objects to optimize storage efficiency and access.
- Conducted data analysis to identify integrity issues within databases and other data repositories.
Senior Database Engineer
Berkadia Services India
Hyderabad
04.2015 - 11.2019
- Migrated databases, SSIS packages, reports, and SQL agent jobs from SQL Server 2008R2 to SQL Server 2012 across DEV, UAT, and PRD environments.
- Executed SQL modifications based on new application requirements and ensured comprehensive software installation and database backups.
- Installed, configured, and maintained SQL Server instances in accordance with application team requests.
- Developed T-SQL scripts, stored procedures, tables, views, functions, triggers, and indexes for optimized database functionality.
- Created advanced SQL queries to generate 40 data sample reports while ensuring proper data filters and stratifications.
- Automated daily operations including critical SQL server alerts and repetitive tasks to enhance operational efficiency.
- Conducted QA testing involving documentation of processes, creation of test scenarios, and execution using T-SQL scripts to meet UI specifications.
- Produced sub-reports, drill-down reports, summary reports, and parameterized reports within SSRS.
Education
Bachelor of Technology - Information & Technology
DADI INSTITUTE OF ENGINEERING & TECHNOLOGY
Vishakapatnam03-2014
Skills
- SQL Server and Transact-SQL
- Data integration and transformation
- Cloud data services
- Business intelligence and reporting
- Web development technologies
- Scripting languages and automation
- IT service management tools
- Database administration expertise
- Integrated development environments
- Data analytics platforms
- Data warehousing solutions
- Programming proficiency
- Team leadership skills
Websites
Certification
- SnowPro Core Certified
- MCSA: SQL Server 2012/2014 - administering Microsoft SQL Server
- ITIL Foundation certified
- IBM DB2 Fundamentals certified
Awards
Employee of the Year Award, Berkadia Services, 2018
Timeline
Lead Data Engineer
Providence India
11.2022 - Current
Data Engineering Consultant
Optum
11.2019 - 11.2022
Senior Database Engineer
Berkadia Services India
04.2015 - 11.2019
Bachelor of Technology - Information & Technology
DADI INSTITUTE OF ENGINEERING & TECHNOLOGY