Chetana Surapaneni
Data Analyst
Miami
Summary
Detail-oriented Data Engineer / Data Analyst with 3 years of experience in eCommerce and Healthcare. Built and optimized data pipelines, data warehouses, and dashboards using AWS Glue, EMR, Airflow, Spark, Hadoop, SQL, and Python. Specialized in data modeling, ELT automation, and Power BI visualization, delivering actionable insights from complex business requirements.
Overview
4
4
years of professional experience
Work History
Data Analyst
Master Compliance
07.2023 - Current
- Built automated ELT pipelines with AWS Glue, EMR, and Airflow to speed up data collection from eCommerce sources and reduce manual work.
- Utilized Python and SQL to clean, transform, and aggregate large datasets.
- Utilized SQL Server Management Studio to design, enhance, and oversee complex T-SQL queries, stored procedures, views, and functions for large-scale data sets.
- Modeled and stored large-scale data in Snowflake supporting enterprise analytics and reporting.
- Created Power BI dashboards leveraging DAX to display KPIs like sales trends and customer engagement metrics.
- Built streaming data workflows leveraging Kinesis Firehose to deliver real-time analytics into S3 and Redshift, enabling near-live reporting in Power BI.
- Collaborated with analytics and product teams to translate data insights into actionable business strategies.
- Applied ML techniques to create a predictive model for sales forecasting, improving accuracy using Amazon SageMaker.
- Integrated AWS SNS alerts into the pipeline for monitoring failures and job completion notifications.
- Supported end-users in understanding complex datasets through effective training sessions and documentation materials.
- Provided ongoing support for BI solutions, troubleshooting and resolving issues as they arose to ensure minimal disruption to user operations.
- Key Technologies: AWS Glue, EMR, Airflow, SNS, Power BI, DAX, Snowflake, Python, SQL, Spark, ELT, Amazon SageMaker, Kinesis Firehose, S3, Redshift, SSIS, SSRS
Data Analytics Engineer Intern
Master compliance
12.2022 - 06.2023
- Developed and automated ELT data workflows with Spark, Hadoop, and Airflow to streamline processing of millions of daily transactions.
- Applied data cleaning and transformation processes to ensure consistency across datasets Using DBT.
- Integrated Snowflake as a centralized data warehouse to enhance data availability and performance.
- Built Power BI dashboards with DAX and Power Query to deliver insights for executive-level decision-making in healthcare operations.
- Supported exploratory data analysis using Python for data validation, insights generation, and trend identification.
- Built Power BI dashboards leveraging DAX and Power Query for executive-level analytics on healthcare operations.
- Enhanced database performance through indexing and query optimization, resulting in improved data retrieval times.
- Created comprehensive documentation for data workflows, facilitating better knowledge sharing and onboarding.
- Key Technologies: Power BI, DAX, Snowflake, Airflow, Spark, Hadoop, SQL, Python, AWS S3, ELT, DBT
Education
Masters in Information Systems -
George Mason University
12-2022
Bachelors in Computer Science Engineering - undefined
Malla Reddy Engineering College
06-2021
Skills
- Data Analysis Tools
Data visualization (Power BI, Tableau)
- Statistical Analysis
- Data cleaning
- Data Reporting Techniques
- Data modeling
- Query performance tuning
- ELT pipeline development
DBT integration
Programming: Python, SQL, Scala
Cloud platforms (AWS, Azure)
Version control
Websites
Timeline
Data Analyst
Master Compliance
07.2023 - Current
Data Analytics Engineer Intern
Master compliance
12.2022 - 06.2023
Bachelors in Computer Science Engineering - undefined
Malla Reddy Engineering College
Masters in Information Systems -
George Mason University