Smit Patel

Smit Patel

Data Analyst
United States of America

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…

Experience

Category Management Intern

PIM Brands
Jun 2023 - Present · 3 years 1 month

• 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

PIM Brands, Park Ridge, NJ
Jun 2023 - Dec 2023 · 6 months

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

Vita Pure, Roselle, NJ
Mar 2020 - Dec 2022 · 2 years 9 months

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.

Skills

Power BI Data Analytics Strategic Thinking Problem-Solving Skills Research Skills Customer Support Attention to Detail SQL SSRS Tableau Excel JSP Java JavaScript CSS HTML C++ MySQL MongoDB VLOOKUP HLOOKUP XLOOKUP Pivot Tables Data Visualization SAS Data Step Proc Steps Informatica Power Mart PL/SQL ETL Stored Procedures SQL Server
Report this Profile?