Data Analyst Power Bi

APURVA PATIL

DATA ANALYST

Location: IL, USA Phone: 773-***-**** Email: *****.*********@*****.*** LinkedIn GitHub SUMMARY

Data Analyst with 3+ years of experience in building scalable ETL pipelines using Python and SQL, handling 1M+ records across diverse datasets. Proficient in AWS (EC2, S3, Lambda, Redshift), dashboarding with Power BI/Tableau, and applying ML techniques using Scikit-learn and Pandas. Skilled at delivering data-driven insights in Agile/Waterfall environments to support decision-making and improve operations. PROFESSIONAL EXPERIENCE

CHIEAC, Chicago, IL Data Science Alliance / Data Analyst Jun 2025 – Current

• Build dashboards using Python (Pandas, Seaborn) and Power BI to track digital access trends, identifying service gaps affecting 28% of schools in underserved districts and informing targeted outreach efforts.

• Train predictive models with scikit-learn to flag students at risk of deficient performance, enhancing early intervention strategies and improving model accuracy with an F1-score of 0.82.

• Analyze 100K+ student records using PostgreSQL to uncover equity trends, contributing insights to 3 policy briefs for educational advocacy.

• Design secure platforms for student-educator collaboration, integrating cybersecurity safeguards to ensure safe data use.

• Apply ML techniques to evaluate funding allocation patterns, supporting decisions that impact outcomes for 15,000+ K–12 students. Accenture (End Client: Merck), India Application Development Associate / Data Analyst Nov 2021 – Jul 2023

• Consolidated 1M+ customer records from databases and CRMs using SQL and Oracle, improving access for 10+ teams.

• Engineered Python-based ETL scripts to automate data extraction and transformation tasks, reducing manual reporting workload by 15 hours weekly through reusable, modular code structures.

• Deployed AWS services including EC2, S3, Lambda, and Redshift to build scalable data pipelines, enhancing processing speed for analytics workflows across large data volumes.

• Built Power BI dashboards for customer churn insights, enabling real-time decisions across 5 business units.

• Visualized data patterns with Pandas & Matplotlib to support quarterly planning for 7+ stakeholder groups.

• Collaborated with QA, product, and analytics teams under Agile sprints to validate datasets and deliver timely releases, completing 12 sprints cycles on schedule with cross-functional alignment.

• Documented SQL logic, ETL processes, and dashboard schemas in Confluence, streamlining onboarding for 3 junior analysts and ensuring audit readiness through version-controlled documentation.

• Translated business requirements into technical data models using RDS and Redshift, enabling structured storage for 10+ departmental reports across Merck operations and ensuring data traceability. Dell Technologies, India Data Analyst Aug 2020 – Oct 2021

• Automated Python and SQL-based data pipelines for EIA reports and survey data, accelerating access for weekly reviews.

• Maintained MySQL databases to manage project specifications, sensor readings, and site metrics, streamlining data retrieval for engineering teams and improving access for over 50 cross-functional users.

• Designed Power BI dashboards and Excel reports to track compliance and progress for 10+ stakeholder meetings.

• Analyzed load patterns and material data using NumPy and statistical models, aiding 3 design revisions.

• Standardized telemetry data and added validation checks, improving accuracy across 7 active projects.

• Leveraged historical project data and cost records to detect risk trends and resource allocation patterns, enhancing forecasting accuracy for future infrastructure bids and reducing cost overrun projections by 20%.

• Followed Waterfall methodology for structured project execution, collaborating with civil, design, and environmental teams to ensure traceable and repeatable analytical workflows across project phases. PROJECTS

LinkedIn Data Mart Development: Developed an ETL pipeline (SQL, Power Query) to load LinkedIn JSON into MySQL, improving speed by 45%, and built Power BI dashboards for centralized data access. Uber & Lyft Fare Prediction: Engineered a fare prediction model using SQL and Python on 16K+ records, achieving 97.9 (Uber) and 93.3

(Lyft) accuracy with Scikit-learn.

TECHNICAL SKILLS

Programming Language: Python, SQL, R.

Databases: MySQL, Oracle, Mongo DB, PostgreSQL.

Libraries: NumPy, Pandas, Matplotlib, Scikit-learn Cloud: AWS (EC2, S3, Lambda, RDS, Redshift), Azure (Blob, Factory, SQL, Data Lake, Databricks) Data Visualization Skills: Tableau, Power BI (DAX, Slicers), MS Excel (Pivot tables, VLOOKUP, Macros) Methodologies: Agile, Waterfall

Analytics & Modeling: Mining, Cleansing, Analysis, Wrangling, Warehousing, ETL/ELT Other Skills: Hadoop, Snowflake, Apache Airflow, Git, GitHub, Docker EDUCATION

Illinois Institute of Technology (IIT) Chicago, IL Aug 2023 - May 2025 Master of Science, Information Technology Management (Specialization: Data Analytics and Management) Savitribai Phule Pune University India Aug 2017 - May 2021 Bachelor of Engineering, Electronics and Telecommunication Engineering

Contact this candidate