Power Bi Data Analyst

Aditya Kulkarni

Dallas, TX, +1-469-***-****, linkedin.com/in/aditya-kulkarni003, ******.***********@*****.***

SUMMARY

Data professional with expertise in SQL, Python, Power BI, Excel and AWS, transforming complex data into actionable insights. Skilled in data visualization, trend analysis, and optimizing workflows to drive business decisions. A problem-solver with strong attention to detail, ensuring data accuracy and impactful analytics.

PROFESSIONAL EXPERIENCE

Cognizant Technology Solutions Corporation Pune, India

Data Analyst February 2022 – January 2023

Developed an automated ETL pipeline to ingest 125,000+ vehicle rental records from EDW into Amazon S3, utilizing SQL for data transformation and integration.

Streamlined data workflows using AWS SQS, Lambda, and AWS Batch, improving pipeline efficiency by reducing processing time by 30%.

Automated schema validation and error handling on AWS EMR, increasing data accuracy and ensuring data integrity.

Enhanced query performance by leveraging AWS Glue and metadata management of JSON and CSV datasets in Athena, optimizing data aggregation for fleet efficiency.

Designed real-time Power BI dashboards integrated with AWS Athena, visualizing key metrics like fleet utilization, vehicle availability, rental revenue, and maintenance costs, enabling data-driven decision-making.

Epsitek Technologies Pune, India

Data Analyst Intern March 2021 – December 2021

Collected and structured data from 15,000+ prescriptions and medicine usage records using SQL and Excel, identifying key trends that helped optimize inventory and target high-demand areas.

Utilized Python and SQL to generate medicine trend reports, enabling a 12% improvement in targeted advertising.

Developed a Power BI dashboard to visualize patterns across 50+ regions, leading to a 10% increase in sales.

ACADEMIC PROJECTS

American Airlines Flight Delay Analysis (SQL, Python, Power Bi)

Analyzed 475,000 flight records, identifying a 21.86% delay rate and proposing $2.02 billion in potential cost savings through operational improvements.

Utilized Power BI to analyze weather-related delays, identifying key patterns and improved KPI tracking for flight schedule reliability and operational performance.

Walmart Data Analysis (Python, Power Bi)

Achieved 94% accuracy in sales forecasting by applying Linear Regression and Random Forest, with Random Forest delivering the best results.

Boosted decision-making efficiency by 10% through the development of Power BI dashboards that tracked sales, inventory, and demand trends in real time.

Healthcare Data Analysis (Azure, SQL, Power Bi)

Engineered an Azure Data Pipeline for healthcare revenue cycle management, integrating medical records and claims data, processing 46K+ records to analyze billing inefficiencies and data trends.

Processed healthcare data using efficient ETL and data pipeline techniques, enhancing data quality and accessibility for scalable analysis and reporting in Power BI.

SKILLS

Programming Languages: Python (Pandas, NumPy, Scikit-Learn, Matplotlib, Seaborn), SQL, R, PySpark

Databases: MySQL, MongoDB, PostgreSQL, Snowflake

Cloud Platforms: AWS (Redshift, S3, EMR, Lambda), Azure (Synapse, Data Factory, Stream Analytics)

Data Engineering and Visualization: Apache (Kafka, Spark), Tableau, PowerBI, Excel(Macros, VLOOKUP)

CERTIFICATIONS

AWS Academy Graduate - AWS Academy Machine Learning Foundations

AWS Academy Graduate - AWS Academy Data Engineering

EDUCATION

University of Texas at Dallas, Master of Science, Business Analytics and Artificial Intelligence May 2025

Savitribai Phule Pune University, Bachelor of Engineering, Information Technology June 2022

Contact this candidate