Data Analyst Analysis

Piyush Gupta

Data Analyst Detroit ********.****@*****.*** 425-***-**** LinkedIn GitHub

Summary

Accomplished Data Analyst with over 4 years of experience in data analysis, statistical modeling, and management consulting. Proficient in leveraging advanced data science techniques to convert complex datasets into actionable insights that drive business growth and operational efficiency. Eager to apply deep expertise in process optimization and predictive analytics to solve challenging problems in dynamic business environments.

Work Experience

CCS Global Tech – Data Analyst- Detroit, MI (Sep 2024 – Present)

• Spearheaded designing and implementing a comprehensive data warehouse for the CapMetro project, enhancing data integration and storage solutions using SQL and Python.

• Developed complex SQL queries and stored procedures to manage and retrieve large datasets efficiently, significantly boosting query performance through strategic use of indexing.

• Employed Python and SAS to perform advanced statistical modeling and machine learning, increasing financial forecasting accuracy for project budgets by 28%.

• Optimized and automated the extraction, transformation, and loading (ETL) processes, reducing data processing times and improving system scalability with Python scripts.

• Created dynamic Power BI dashboards to provide real-time analytics and insights, facilitating better strategic decision-making and improving campaign response rates by 11%.

• Designed and maintained robust reporting frameworks using Power BI and Tableau, ensuring high data integrity and accessibility for ongoing project monitoring and stakeholder reviews. Ernst and Young L.L.P. - Technical Consultant (Data Analysis, Financial Projection) - India (Nov 2021 – Apr 2022)

• Boosted financial forecasting accuracy by 28% for multiple projects using Python and SAS, with SQL-stored procedures to handle complex data structures efficiently.

• Led initiatives to extract predictive insights, employing optimized SQL queries and indexing to enhance the performance of a

• Created automated reporting solutions in Excel and Power BI, converting complex datasets into clear, actionable insights for stakeholder decision-making, ensuring high data integrity.

Dilip Buildcon Limited - Data Analyst (Data Analysis, Project Monitoring) - India (Oct 2017 – Nov 2021)

• Leveraged SQL and Python for data analysis and reporting, enhancing project reporting efficiency by 20% through interactive Power BI dashboards and real-time data visualization.

• Applied A/B testing to refine invoice processes, achieving a 15% reduction in submission times via predictive modeling.

• Identified critical touchpoints and pain points in the customer journey through in-depth user interaction data analysis, contributing to strategic decision-making for a prominent e-commerce client.

• Controlled data-driven inventory management strategies, using Python for data analysis and forecasting, to optimize inventory levels and effectively meet demand.

Technical skills

• Languages: Python, SAS, Scala, R Packages: NumPy, Pandas, Matplotlib, Seaborn, ggplot2, SciPy, Scikit-learn, TensorFlow

• Database Management: MySQL, PostgreSQL, SQL Server 2019, 2016, 2014, Neo4j (Graph Database)

• Visualization Tools: Tableau, Power BI, Advanced Excel (Pivot Tables, VLOOKUP)

• Cloud Technologies: Azure SQL, Azure Data Factory, Azure Data Bricks, Azure Storage (BLOB, Tables, Queues, and File Share)

• Project Management & Tracking Tools: Jira, Microsoft Visio, Microsoft Project, Primavera

• Concepts: Machine Learning Algorithms, CI/CD, Advanced Analytics, ETL Processes, Report Generation, A/B Testing, Forecasting & Modeling, Hypothesis Testing, Time Series Analysis, SDLC, Agile, Waterfall, Git, GitHub Education

Pace University – Seidenberg School of Computer Science and Information System, New York May 2024 Master of Science in Data Science

National Institute of Construction Management and Research, Pune, India Mar 2017 Post Graduate Program in Advanced Construction Management Jaypee University of Engineering and Technology, Guna, India Jun 2015 Bachelor of Technology in Civil Engineering

Contact this candidate