Chaitang Shah

Chaitang Shah

Data Analyst
United States of America

About Me

4+ Years of experience in Data Analysis, report generation, business report process maintenance, data verification, data modeling, data warehousing, data validation, and data mining with large datasets of structured and …

Experience

Data Analyst

Principal Financial
Sep 2023 - Present · 2 years 10 months

• Develop automated data pipeline architecture, extracting data from various external data sources to create a single data
platform and exporting it to reporting tools like Tableau.
• Improve data accuracy and reduce the data processing time by 40% by optimizing and automating data cleansing, extraction,
and analysis processes.
• Implement continuous integration and continuous delivery (CI/CD) pipelines in Azure DevOps, increasing code deployment
frequency by 30%.
• Execute ETL process in Alteryx to extract data from multiple sources (SQL Server, XML, Excel, CSV) and schedule workflows.
• Establish data models to support advanced analytics and reporting, enabling data-driven decision-making and contributing to
a 25% increase in revenue through improved business insights.
• Industrialize a robust data cleaning and wrangling pipeline, reducing overall processing time by 25%.

Data Analyst

Principal Financial, MA
Sep 2023 - Present · 2 years 10 months

Develop automated data pipeline architecture, extracting data from various external data sources to create a single platform and exporting it to reporting tools like Tableau.
Improve data accuracy and reduce the data processing time by 40% by optimizing and automating data cleansing, extraction, and analysis processes.
Implement continuous integration and continuous delivery (CI/CD) pipelines in Azure DevOps, increasing code deployment frequency by 30%.
Execute ETL process in Alteryx to extract data from multiple sources (SQL Server, XML, Excel, CSV) and schedule workflows.
Establish data models to support advanced analytics and reporting, enabling data-driven decision-making and contributing to a 25% increase in revenue through improved business insights.
Industrialize a robust data cleaning and wrangling pipeline, reducing overall processing time by 25%.

Data Analyst

Clover Infotech, India
Nov 2019 - Dec 2021 · 2 years 1 month

Developed Tableau dashboards to track performance metrics, improving team productivity by 10%.
Designed an Extract-Transform-Load process to load 200TB of data into a data warehouse using SQL Server Integration Services (SSIS).
Utilized Google Analytics insights to implement targeted strategies, contributing to a 30% increase in user engagement metrics.
Built and optimized 5 machine learning models in Databricks, achieving a 28% improvement in accuracy compared to traditional methods.
Collaborated with stakeholders to develop and maintain data standards and naming conventions, improving data consistency and facilitating effective data governance practices.

Data Analyst

Dixon Technology, India
Jan 2018 - Oct 2019 · 1 year 9 months

Utilized Azure Databricks and Azure Synapse Analytics for exploratory data analysis, resulting in a 25% reduction in the time required for uncovering in-depth insights and discovering patterns in the data.
Applied advanced analytics techniques to create 24 Power BI dashboards and generate 35 ad hoc reports, enhancing data visibility and analysis.
Monitored the performance of the Snowflake platform and implemented performance tuning strategies, optimizing SQL queries and troubleshooting performance issues, resulting in a 30% improvement in query performance and enhanced user experience.
Designed, developed, and tested QlikView scripts to import data from source systems and test QlikView reports/dashboards to meet customer requirements.

Skills

Analytics Data Analysis Professional Information Systems Management Data Mining Microsoft Access Statistical Analysis System (SAS) Structured Query Language (SQL) Data Representation Data Analysis Skills Power BI R Programming Language (R) Tableau Python NumPy Pandas Matplotlib SciPy Seaborn PyTorch TensorFlow Sklearn Keras ggplot2 Jupyter Notebook R Studio Microsoft Excel Alteryx QlikView Looker Google Analytics SSIS Informatica Talend Azure Data Lake Storage Azure Data Factory Azure Databricks Azure DevOps Azure Synapse MySQL SQL Server MongoDB PostgreSQL Data Cleaning Data Wrangling Data Warehousing Data Mapping Data Modeling Snowflake Windows Linux MacOS
Report this Profile?