About Me
Data Analyst with experience in SQL, SSRS, SAS, ETL, Informatica Power Mart, and PL/SQL. Experienced in data extraction, transformation, cleansing, validation, reporting, and analysis, with a background in computer scien…
Data Analyst with experience in SQL, SSRS, SAS, ETL, Informatica Power Mart, and PL/SQL. Experienced in data extraction, transformation, cleansing, validation, reporting, and analysis, with a background in computer science and coursework in data management and data science.
Experience
Category Management Intern
• Generated and maintained diverse performance and attribution reports, ensuring accuracy and relevance.
• Condensed report insights, empowering informed decisions for both internal and external stakeholders.
• Contributed collaboratively throughout modular relay phases, ensuring project success with vital support.
• Performed analytical functions to bolster the modular relay workflow, contributing to seamless operations.
• Conducted competitive analysis by conducting regular in-store visits and leveraging online research methods.
Category Management Intern
<p>Generated and maintained diverse performance and attribution reports, ensuring accuracy and relevance.<br>
Condensed report insights, empowering informed decisions for both internal and external stakeholders.<br>
Contributed collaboratively throughout modular relay phases, ensuring project success with vital support.<br>
Performed analytical functions to bolster the modular relay workflow, contributing to seamless operations.<br>
Conducted competitive analysis by conducting regular in-store visits and leveraging online research methods.</p>
Data Analyst
<p>Extensive use of SQL (SSRS) for writing SQL queries to retrieve data and perform various kinds of analysis and validations.<br>
Cleansing and validating complex data using data step, proc steps and SAS functions.<br>
Utilized SQL for data extraction and transformation from various Amazon databases, ensuring accuracy through effective cleansing techniques.<br>
Created SQL scripts, complex stored procedure, provide database support, data analysis and scripts for data cleansing and scrubbing etc.<br>
Identifies and makes recommendations for resolution of issues in data reporting quality.<br>
Collaborated with Business Analysts and Data Manager on source to target mapping.<br>
Designed and Developed ETL (Extract, Transformation & Load) strategy to populate the Data Warehouse from the various source systems feeds using Informatica Power Mart, PL/SQL.<br>
Perform Data Analysis on both source data and target data after transfer to Data Warehouse.<br>
Created SQL Server Stored Procedures with complex query logic based on case statements and using input parameters and control of flow statements.<br>
Collected business requirements to set rules for proper data transfer from Data Source to Data Target.<br>
Created the SQL scripts for demonstrating the prototypes and for verifying the result sets.</p>