Data Analyst Power Bi

ROHAN NEEMKAR

DATA ANALYST

**********@*****.*** 773-***-**** Chicago, IL Linkedin

SUMMARY

Data Analyst with over 2+ years of experience specializing in building interactive dashboards, designing ETL workflows, and performing data analysis to deliver actionable insights.

Proficient in utilizing tools like Power BI, Tableau, and Google Data Studio for data visualization, enabling data- driven decision-making across operations, marketing, and business domains.

Expertise in Python (Pandas, NumPy, Matplotlib, Scikit-learn) and SQL (Joins, CTEs, Subqueries) for data cleaning, analysis, and predictive modeling, ensuring high accuracy and reliability of datasets.

Skilled in ETL tools such as Talend, Apache Airflow, and Power Query to automate data pipelines and improve operational efficiency.

Experienced in managing cloud platforms like AWS (Redshift, S3, RDS) and Azure (Data Lake, Data Factory) to optimize data storage, processing, and accessibility. EDUCATION

Governors State University, IL Aug 2022 - May 2024 Master of Science in Information Technology IL, USA JNTU University Jul 2017 - May 2022

Bachelor of Science in Computer Science and Engineering India PROFESSIONAL EXPERIENCE

Data Analyst Aug 2024 – Current

Uber, IL, USA

Developed interactive Power BI dashboards to analyze rider behavior across 50+ cities, providing actionable insights for marketing and operations teams.

Optimized SQL queries to preprocess 1M+ ride records, ensuring the high accuracy and readiness for analytics workflows.

Automated data integration workflows using Talend, reducing manual intervention for transformation by 20 hours weekly.

Conducted A/B testing on promotional campaigns using Python (Pandas, Matplotlib), identifying strategies that increased ride bookings by 10%.

Collaborated with teams to migrate historical trip data to AWS Redshift, enabling fasterqueries and seamless integration with existing analytics systems.

Created custom datasets using Power Query, allowing business analysts to drill down into KPIs and improveoperational decision-making.

Documented analytics processes and presented findings to stakeholders using Google Data Studio, improving reporting clarity and usability.

Data Analyst Aug 2021 – Jul 2022

Adani India

Built ETL pipelines using Apache Airflow to ingest energy usage data from 100+ facilities into a centralized Azure Data Lake, reducing reporting delays.

Designed Tableau dashboards for real-time monitoring of energy consumption trends, enabling efficient resource allocation across sites.

Conducted gap analysis on energy workflows, identifying inefficiencies and implementing changes that saved 500+ man-hours annually.

Analyzed facility performance using SQL (Joins, CTEs), providing insights that optimized energy distribution and reduced outages.

Developed regression models using Python (Scikit-learn) to forecast energy demands, enabling resource planning.

Coordinated UAT sessions for new analytics features, collecting stakeholder feedback and ensuring alignment with operational goals.

Implemented data validation checks to ensure the accuracy of 2TB+ of operational data, enhancing trust in analytics outputs.

SQL Developer Feb 2021 – Jul 2021

Trinity Technolabs India

Engineered complex SQL queries to support e-commerce order tracking, reducing query response times for key reports by 50%.

Created and maintained stored procedures for data validation, ensuring consistent processing of 500K+ transactional records daily.

Designed and implemented database schemas in MySQL, streamlining integration with frontend applications and ensuring scalability.

Conducted data cleaning and transformation using Python (Pandas), reducing errors in order processing pipelines.

Built an automated reporting system in Excel with pivot tables and macros, delivering operational insights to stakeholders within minutes.

Collaborated with backend teams to resolve database performance bottlenecks, improving query efficiency for high- traffic scenarios.

Documented workflows for database management and provided training to junior developers, ensuring knowledge transfer and process continuity.

SKILLS

Core Skills Data Cleaning, Data Wrangling, Trend Analysis, Statistical Analysis, Report Automation

Programming Languages Python (Pandas, NumPy, Matplotlib, Seaborn), SQL (Joins, CTEs, Subqueries), R

Data Visualization Power BI, Tableau, Google Data Studio

Databases MySQL, PostgreSQL, MongoDB, Oracle

ETL & Data Integration Talend, Apache Airflow, Power Query

Cloud Platforms AWS (RDS, Redshift, S3), Azure (Blob Storage, Data Lake, Data Factory)

Tools & Platforms Excel (Advanced: Pivot Tables, VLOOKUP, Macros), JIRA, GitHub, SharePoint

Testing & Validation Data Validation, Regression Testing, A/B Testing

Project Management Agile (Scrum, Kanban), Sprint Planning, Backlog Grooming

Contact this candidate