Kavya U. Email & Phone Number

As a Data Analyst, my responsibilities involved:•Performing daily integration and ETL tasks by extracting, transforming and loading data to and from different RDBMS.•Conduct comparative cost/benefit analysis between DQM modules and Inquiry Framework for DQ assessments. Utilize multimedia office suite applications and conduct surveys for high-level dashboard reporting.•Creating complex SQL queries and scripts to extract and aggregate data to validate the accuracy of the data… Show more As a Data Analyst, my responsibilities involved:•Performing daily integration and ETL tasks by extracting, transforming and loading data to and from different RDBMS.•Conduct comparative cost/benefit analysis between DQM modules and Inquiry Framework for DQ assessments. Utilize multimedia office suite applications and conduct surveys for high-level dashboard reporting.•Creating complex SQL queries and scripts to extract and aggregate data to validate the accuracy of the data. •Extracting the data from various sources like Oracle, SQL, Teradata, and XML.•Performed Data Analysis and Data Profiling using complex SQL queries on various sources systems including Oracle, Teradata. Show less

Tasks Performed:•Created logical Data model from the conceptual model and its conversion into the physical database design.•Used SAS to build models to identify definite patterns and suggest a business with possible problems and feasible solutions.•Worked with the Business Intelligence and ETL developers on the analysis and resolution of data related problem tickets and other defects.•Data Modeling using Star Schema, Snowflake Schema.

Atlanta

Responsibilities:•Prepared Business Process and Data Process Models using MS Visio.•Designed and developed weekly, monthly reports using MS Excel Techniques (Charts, Graphs, Pivot tables) and PowerPoint presentations.•Exposure to Strong Excel skills, including pivots, VLOOKUP, conditional formatting, large record sets. Including data manipulation and cleaning.

Denver

Job Responsibilities:•Performed data analysis and data profiling using complex SQL on various sources systems.•Documented the complete process flow to describe program development, logic, testing, and implementation, application integration, coding. •Worked with internal architects and assisted in the development of current and target state enterprise data architectures.•Provided Business Requirement Documentation (BRD) for the customers after thorough market and technology… Show more Job Responsibilities:•Performed data analysis and data profiling using complex SQL on various sources systems.•Documented the complete process flow to describe program development, logic, testing, and implementation, application integration, coding. •Worked with internal architects and assisted in the development of current and target state enterprise data architectures.•Provided Business Requirement Documentation (BRD) for the customers after thorough market and technology research and by analyzing current market trends. Show less

Chennai

Pune