نبذة عني
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.
الخبرة
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
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.
Data Analyst
Extensive use of SQL (SSRS) for writing SQL queries to retrieve data and perform various kinds of analysis and validations.
Cleansing and validating complex data using data step, proc steps and SAS functions.
Utilized SQL for data extraction and transformation from various Amazon databases, ensuring accuracy through effective cleansing techniques.
Created SQL scripts, complex stored procedure, provide database support, data analysis and scripts for data cleansing and scrubbing etc.
Identifies and makes recommendations for resolution of issues in data reporting quality.
Collaborated with Business Analysts and Data Manager on source to target mapping.
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.
Perform Data Analysis on both source data and target data after transfer to Data Warehouse.
Created SQL Server Stored Procedures with complex query logic based on case statements and using input parameters and control of flow statements.
Collected business requirements to set rules for proper data transfer from Data Source to Data Target.
Created the SQL scripts for demonstrating the prototypes and for verifying the result sets.