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.• Implement Agile Methodology.• Hosted dashboards with live updates on workspaces and created subscriptions for government business users to access data at a schedule thereby helping drive important business decisions. • Analysed requirements for various reports, dashboards, scorecard and created proof of concept/ prototype the same using Tableau desktop.• Used advanced analytics and visualization using Tableau to take large-scale data and create a means for easy comprehension and insights from internally developed consumer data products. • Sharing of Power BI reports and managing workspaces in Power BI service.• Cleanse and validate the data by fixing structural errors, Filter unwanted outliers & Handle missing data.

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.• Reviewed team members code on Python, DBT Core and provide feedback.• Involved in enhancements and maintenance activities of the data warehouse including tuning, modifying of stored procedures for code enhancements.• Understand the data visualization requirements from the Business Users• Bulk loading from External stage(Azure),internal stage to Snowflake cloud using Copy command.• Loading data into snowflake tables from the internal stage using SnowSQL.• Cloned production data for code modifications and testing• Manipulation of Data using Python Programming• Evaluated data profiling, cleansing, integration and extraction tools • Performed Data Cleaning, features scaling, features engineering using pandas and numpy packages in python• Analyze the financial reports and help him in decision making. • Compiled weekly service delivery implementation metrics using Excel workbooks and proprietary databases.• Performed Data analysis using Python Pandas.• Extensive data cleansing and analysis, using pivot tables, formulas (v-lookup and others), data validation, conditional formatting, and graph and chart manipulation.• Embedded Power BI reports to webpages. • Created the Row Level Security in Power BI. • Created the Schedule refresh for Datasets in Power BI Pro version. • Create the Calculated columns and measures with the use of DAX Expressions.

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.• Developed SQL scripts using RANK functions to improve the query performance while pulling the data from large tables.• Experience in performing Dual Data Validation on various Businesses critical reports working with another Analyst.• Developed highly optimized stored procedures & Database Views to implement the business logic• Implement point of view security to Tableau dashboards to facilitate visibility across various levels of the Organization• Developed Python programs for manipulating the data reading from various Teradata and convert them as one CSV Files, update the Content in the database tables.• Perform slicing and dicing of data using SQL and Excel for data cleaning and data preparation• Generated and published customized interactive reports, dashboards and scheduled reports using Tableau• Designed modeling in Power BI. • Involved in developing reports and dashboards in Power BI. • Involved in creating data visualizations like Clustered Column Chart, Donut Chart, Line Chart, Slicer, Gauge, Bar charts, Tree Maps, Line charts, Scatter plot Visualization etc. with Power BI. • Involved in effectively used data blending, filters, actions feature in Power BI.