Chetan Kumar Email and Phone Number

I have extensive experience collaborating with Subject Matter Experts and Product Owners to define data requirements and create comprehensive source-to-target mappings for advanced analytics within Manufacturing and Supply Chain (M&SC). My expertise includes creating data warehouses, integrating systems like Salesforce and SAP, and unifying multiple databases into a single universe. I have also excelled in developing interactive Power BI reports using storytelling features and custom visualizations, and implementing machine learning techniques in Python to convert multilingual text to English for analysis.In my role, I have published and maintained Power BI workspaces, used DAX functions and Power Queries for logical visualizations, and translated data requirements into detailed data maps. I have also performed critical analysis tasks such as COPQ and DPPM analysis to aid Global Quality Leaders in data-driven decision-making. My experience includes managing cloud-based data warehousing solutions with Snowflake, creating UML and ER diagrams, conducting exploratory data analysis with Python, and leveraging advanced Excel features for complex dataset analysis.Additionally, I have developed interactive dashboards and reports, implemented Google Analytics, utilized D3.js for advanced data visualization, and streamlined workflows with Alteryx. My project management skills are backed by experience with Jira, ensuring timely delivery of data analysis projects in alignment with Agile methodologies. Overall, my diverse skill set and collaborative approach have consistently supported strategic decision-making and operational efficiency in various business environments.

As a Data Analyst, I have a comprehensive background in managing and optimizing data-driven projects across various platforms and tools. My responsibilities have included creating and maintaining database objects, implementing referential integrity constraints, and developing effective Amazon QuickSight reports and visualizations in collaboration with cross-functional teams. I've conducted extensive data analysis using AWS, identifying trends and anomalies to enhance business strategies and operational efficiency.I have developed ETL processes in Python to extract and load data into MySQL databases, leveraging regular expressions for efficient data handling. My expertise includes implementing Apache Spark RDD transformations in a Hadoop data lake environment, optimizing large-scale data processing for advanced business analytics.I have performed T-SQL tuning and query optimization using MS SQL Profiler and Database Engine Tuning Advisor, and engaged in data mapping, logical data modeling, and creating class and ER diagrams. Additionally, I have reverse-engineered backend databases to enhance performance through optimized T-SQL scripts, views, stored procedures, triggers, and functions.My experience extends to performing data transformations in SSIS, utilizing advanced Excel functionalities, leveraging Snowflake for cloud-based data warehousing, and developing interactive dashboards in Tableau. I've conducted exploratory data analysis and statistical modeling in Jupyter Notebooks and Python, and implemented Google Analytics to track website traffic and user behavior.I have a solid understanding of data governance frameworks and regulatory compliance, ensuring best practices in data management. My technical proficiency includes SQL Server, Oracle, PL/SQL, PostgreSQL, SAP HANA, Teradata, and a variety of business intelligence tools, enabling me to deliver actionable insights and drive strategic business initiatives.

As a Data Analyst, I specialize in developing and maintaining robust data pipelines using Azure Data Factory, ensuring seamless integration and transformation of data across multiple sources. I implement stringent data security measures and manage access controls within Azure Blob Storage to protect sensitive information and ensure compliance with data governance policies.My role involves architecting and configuring secure cloud VPCs using private and public networks through subnets in Azure, leveraging Python for automation. I utilize DAX functions for creating calculations and measures in SSAS Tabular Models, and work on various data transformation tasks within SSIS, such as Execute SQL Task, Execute Package Task, Conditional Split, Script Component, Merge, and Lookup.I develop and document data analysis workflows in Jupyter Notebooks using Python and R, collaborating closely with data engineering teams to optimize Python code for performance and scalability. My expertise extends to performing ETL operations using SQL to extract, transform, and load data into data warehouses, and maintaining Hadoop workflows using Oozie for job scheduling and management.I collaborate with business stakeholders to gather requirements and develop custom SAS solutions, conduct data profiling and analysis using SQL to identify patterns and anomalies, and document RapidMiner processes for reproducibility. Additionally, I collect and analyze global plants data in Excel, integrating it into Power BI to assess product loss and profit.My environment includes Azure, Python, DAX, SSAS, SQL, Jupyter Notebooks, ETL, Hadoop, RapidMiner, Excel, Power BI, and SSIS, enabling me to deliver comprehensive data solutions that drive informed business decisions.

As a Data Analyst, I specialize in configuring and managing AWS EC2 instances to support data analysis tasks, ensuring high availability and scalability of computational resources. I utilize AWS S3 for efficient data storage and retrieval, implementing secure data management practices and optimizing storage costs. My expertise includes designing and developing graphical and visualization solutions using Python, and creating interactive dashboards with SQL in Einstein Analytics Studio.I am responsible for coding SSIS processes to import data into the Data Warehouse from various sources, including Excel spreadsheets, Flat Files, and OLEDB Sources. I create and administer workspaces for each project on Power BI Service, publishing reports from Power BI Desktop to Power BI Services workspace. I collaborate closely with stakeholders to gather requirements and deliver customized Google Analytics solutions.My role involves developing SAS scripts for data extraction, transformation, and loading (ETL) processes, and maintaining project plans and timelines in Word to track progress. I also integrate Jira with other project management tools and applications for comprehensive project tracking.