Kavitha Kumar Email & Phone Number

United States

• Designed, developed, revised and maintained SQL Scripts and queries for data translation, conversion and reporting through Azure
• Converted existing data, using ETL processes, created queries and scripts to manipulate the data into required format.
• Conducted system testing and provided trouble-shooting to quickly and accurately find solutions to resolve issues.
• Provided post conversion issue resolution, inefficiencies and recommendations for existing process changes.
• Developed and maintained dynamic dashboards on Tableau Desktop and Tableau Server, Power BI Desktop, Power BI Portal.
• Developing Standard and Create reports using Tableau Desktop.

Newark, New Jersey, United States

New Jersey, United States

• Responsible of Migration from Oracle to Snowflake Ware House using ADF.
• Designed and implemented Data Pipeline to process structured Data and Semi structured data from 10 Different sources.
• Defined Data validation Framework/Solution for Oracle and Snowflake which reduced the manual validation.
• Handled Multiple POC’s for the conversion of Qlik Report to Power BI Report.
• Written Transformation procedure/Logic using DBT Core.
• Generated Account/Monthly Transaction/Sales KPI Report by Power BI.

Buffalo-Niagara Falls Area

• Involved in analysis, design and documenting business requirements and data specifications. Supported data warehousing extraction programs, end-user reports and queries
• Interacted with Business analysts to understand data requirements to ensure high quality data is provided to the customers
• Worked on numerous ad-hoc data pulls for business analysis and monitoring by writing SQL scripts.
• Created monthly and quarterly business monitoring reports by writing SQL queries includes System Calendars, Inner Joins and Outer Joins to retrieve data from multiple tables.
• Performed verification and validation for accuracy of data in the monthly/quarterly reports.
• Created multi-set tables and volatile tables using existing tables and collected statistics on table to improve the performance.