Power Bi Data Analyst

Sarvesh Rodi

Pune, IN • ************.**@*****.*** • +91-976*******• linkedin.com/in/sarvesh-rodi-03692a208/ Education

AISSMS Institute of Information Technology, Pune

Bachelor of Engineering (Electronics and Telecommunication) June 2019 – May 2023 Work Experience

Data Analyst Dec 2023 – Present

Tech Mahindra, Pune

• Optimized complex ETL workflows by automating data ingestion from multiple sources (e.g., SQL,AWS) into Power BI, reducing daily processing time from 30 to under 20 mins while ensuring data quality and enabling efficient dashboard deployment for business insights.

• Refined data analysis and visualization using Google Data Studio(LOOKER studio), streamlining decision-making for business, marketing, and product teams, leading to a 25% operational efficiency boost.

• Created interactive Power BI and Fusion Analytics dashboards, streamlining reporting and actionable insights for stakeholders.

• Earned Finastra Basic & Advanced Technical Consultant Certification (valid for 2 years), driving data strategy enhancements, and opti- mizing financial applications for better performance and scalability. Tech Lead & Data Analyst June 2023 - Nov 2023

Aproop Production, Pune

• Led website development (aproopproduction.com),strengthening the company’s online presence and accelerating customer acquisition by 50%.

• Analyzed competitor strategies and conducted SEO audits, resulting in the identification of 20+ high-potential keywords; adjusted the content accordingly, resulting in a boost in organic reach by 20%.

• Studied visitor data and user behavior to optimize website performance and refine future business decisions, increasing traffic by 20-40%. Projects

Sales Data Analysis AWS, MySQL, Power BI, Redshift, Glue, Athena

• Built a scalable data pipeline that integrates MySQL (customer data) and AWS S3 (transaction & product data).

• Built ETL with Glue Crawler and Athena, reducing data processing time by 30%.

• Developed an interactive Power BI dashboard, leveraging DAX for real-time insights. Automated Stocks Portfolio Management & Analytics System Power BI, Python, API Automation

• Created an automated pipeline that updates live data in 3-5 seconds, allowing prompt adjustments based on market fluctuations.

• Automated hourly data updates with a robust pipeline, improving efficiency by 30%

• Designed an interactive Power BI dashboard for live PnL analysis and actionable insights, reducing analysis time by 50%. Smart Traffic Control System Python, AWS, Power BI, Raspberry Pi

• Engineered an AI-driven traffic management system that dynamically adjusted signal timings, reducing congestion by 25%.

• Live traffic data collected and analyzed from Pune, optimizing signal efficiency by 30-50%.

• Utilized Raspberry Pi 4B+, OpenCV, and Python for real-time vehicle detection and adaptive control. Skills

• Languages: Python,SQL.

• Cloud/Databases: :MySQL,AWS.

• Data Visualization Softwares: Power Bi,Tableau,Google Data Studio, Fusion Analytics

• ETL/Data engineering Tools : AWS Glue, Alteryx.

• Other Skills: Wix,Wix Analytics,Linux,MS-Excel,Market Research, Economics Analysis

• Relevant Coursework: Aws data Engineer,Google Data Studio, Bash Shell Scripting, SQL Fundamentals,Agile Fundamental Power BI Data Analyst,Loan IQ Advance Technical 7.6 - Finastra Certified Associate (Valid till 2026) Achievements and Responsibilities

• Led and managed a team of 50+ members to organize and perform in college festivals for 3 years

• Served as coordinator for the college’s cultural group, leading and managing a team of 50–70 members

• Authored and published a paper on ”Automatic Traffic Control System Using Raspberry Pi”

Contact this candidate