KOLLA PAVANI

ETL Developer

Bangalore

Summary

Proactive Product Specialist experienced in software development and data integration. Achieved improved data accuracy and reporting reliability through implementation of ETL pipelines and data validation logic. Focused on delivering business intelligence reporting solutions by optimizing SQL performance and collaborating with business teams.

Overview

Languages

years of professional experience

Work History

Product Specialist – Tech

Cognizant Solution Technology PVT LTD

02.2022 - Current

Developed product training materials that enhanced team knowledge and improved customer support quality.
Resolved production issues quickly and efficiently, minimizing downtime and maintaining high levels of user satisfaction.
Optimized in-application SQL statements to streamline data retrieval and processing.
Managed data quality issues during ETL processes, directing qualitative failures to team lead for amelioration.
Resolved production issues, minimizing downtime and ensuring high user satisfaction.
Wrote and optimized in-application SQL statements.
Reduced processing time for ETL tasks through the implementation of parallel execution strategies.
Optimized resource allocation through effective workload balancing techniques, improving system performance during peak usage times.

Analyst

Acuity Knowledge Partners

04.2018 - 02.2022

Enhanced team collaboration through clear communication of complex findings via visualizations and reports, fostering informed decision-making.
Enhanced data accuracy by meticulously validating and updating customer information in database.
Reduced errors in data entry, instituting rigorous quality control checks.
Enhanced data accuracy by meticulously validating and updating customer information in the database.
Optimized operational efficiency by redesigning workflow processes.
Optimized operational efficiency by redesigning workflow processes, streamlining tasks for better team productivity.

Education

Bachelor of Science - Electrical, Electronics And Communications Engineering

KMM Institute of Technology

Tirupati, India

04.2001 -

Skills

SQL Server expertise

ETL process management

Data interpretation

Report development using SSRS

Python

Projects

Encounter Data Management:

Playing key role in designing, building, and maintaining the data pipeline infrastructure that enables organizations to gather, process, and analyses large volumes of data from various sources.
Design and develop optimized SQL Server stored procedures, functions, views and triggers to be used during ETL process and improved overall performance.
Troubleshoot and resolve issues like database performance, database capacity, replication, and other data-related issues.
Discovers, review, analysis and evaluates client’s environment for determining specific requirements for implementations and custom enhancements.
Interaction with client on the Requirement Gathering process and prepare Design of components.
Gained Knowledge on Healthcare basics, Medical Management, Care Advance Enterprise [CAE].
Preparation of impact analysis documents of the requirements.
Creation/ modification of tables, views, Functions and Stored Procedures as per the requirements.
Preparation of unit test cases and performing unit testing
Preparation of reports using SSIS and SSRS.
Support provided to Quality Assurance and User Acceptance Testing.
Responsible for escalation of PROD incidents and arriving at timely resolution approach.
End to end ownership taken for the projects without any post production issues.

Accomplishments

Recognized with “Associate of the Quarter” for outstanding performance in EDM
implementation and EDM requirement tool development at Cognizant 2 times.

Watching Movies, Playing Games

In free time I used to watch movies and playing outdoor games like Badminton

Timeline