Summary
Overview
Work History
Education
Skills
Certification
Timeline
Generic

Pavithra Dappu

Paterson,NJ

Summary

Results-driven Data Analyst with 3+ years of experience in Python, SQL, and advanced data analytics across cloud and on-premise environments. Skilled in ETL automation, data engineering workflows, predictive modeling, and dashboard development. Experienced in working with Snowflake, Airflow, AWS, Azure, and modern BI tools (Tableau, Power BI). Strong foundation in object-oriented programming, data warehousing concepts, and DevOps-aware practices (version control, agile, automation). Certified in Tableau Desktop Specialist and Google Data Analytics, with an M.S. in Business Analytics

Overview

4
4
years of professional experience
1
1
Certification

Work History

Data Analyst

Amphenol
Wallingford, CT
06.2024 - Current
  • Developed 12+ Tableau dashboards for executives, improving KPI visibility and decision-making speed by 25%.
  • Automated ETL workflows (Python/SQL + Airflow), reducing manual reporting effort by 40+ hours/month.
  • Designed time-series forecasting models (ARIMA, Prophet) and regression models, increasing forecast accuracy by 18%.
  • Optimized SQL queries (window functions, CTEs, indexing), cutting query runtime by 30%.
  • Partnered with finance & operations to deliver cost modeling dashboards, reducing expenses by 10%.
  • Contributed to cloud migration efforts leveraging AWS RDS and Snowflake for scalable analytics.

Jr Data Analyst

Ayant Software Pvt.Ltd
kolkata, IN, In(Remote)
01.2022 - 07.2023
  • Built and maintained 15+ Power BI dashboards, improving reporting efficiency by 35%.
  • Streamlined data pipelines (SQL + Python), improving reporting accuracy by 20% and reducing refresh time by 25%.
  • Conducted EDA, regression analysis, and hypothesis testing, driving insights that improved client retention by 12%.
  • Automated recurring Power BI reports with Python and SQL scripts, saving 25+ hours/month.
  • Collaborated with senior analysts to deliver data-driven recommendations, increasing client satisfaction scores by 15%

Education

Master of Science - Business Analytics

Sacred Heart University
Fairfield, CT
11-2024

BBA -

Sun International Institute of Technology
Hyderabad, IN
11-2022

Skills

  • Programming & Query Languages: Python (Pandas, NumPy, Scikit-learn), SQL (T-SQL, PL/SQL, MySQL, PostgreSQL), R (basic)
  • Big Data & Cloud: AWS (Certified), Microsoft Azure, GCP, Snowflake, Apache Airflow, Azure Databricks
  • ETL & Data Engineering Tools: Python ETL, Alteryx, dbt, Talend, Power Automate
  • Databases: SQL Server, PostgreSQL, MySQL, Oracle, Snowflake, AWS RDS
  • Data Visualization: Tableau (Desktop, Prep), Power BI (DAX, Power Query), Looker, Amazon QuickSight, Excel (Power Query, Macros)
  • Concepts & Practices: Object-Oriented Programming, Advanced SQL (CTEs, window functions, query optimization), Data Warehousing, Agile/Scrum, SDLC
  • Other Tools: Git, JIRA, Confluence, MS Visio, Jupyter Notebook
  • Awareness: CI/CD pipelines, Docker, Data Security best practices & compliance standards

Certification

  • Tableau Desktop Specialist
  • Google Data Analytics Certificate
  • AWS Certified (Cloud Fundamentals)

Timeline

Data Analyst

Amphenol
06.2024 - Current

Jr Data Analyst

Ayant Software Pvt.Ltd
01.2022 - 07.2023

Master of Science - Business Analytics

Sacred Heart University

BBA -

Sun International Institute of Technology

Similar Profiles

CREATE PROFILE