Power Bi Data Analyst

ATLANTA, US • *******.***********@*****.*** •

+1-860-***-****

SAIROOPESH MADHAMSETTY

PROFESSIONAL SUMMARY

Data analytics professional with 5+ years of experience transforming complex data into actionable insights that drive business decisions and revenue growth. Proven expertise in Power BI, SQL, Python, and Excel, with a track record of optimizing workflows and creating high-impact dashboards. Skilled in cross-functional collaboration and implementing data-driven strategies to enhance processes and outcomes.

EMPLOYMENT HISTORY

CONSULTANT Aug 2024 - Dec 2024

PepsiCo Hartford, CT

• Designed a model which predicts the best percentage of PET that can be used in the bottling process and reduced the current usage of PET by 20% and by passing the acceptance tests conducted.

• Predicted the best percentage of PET that can be used for distinct size of bottles and saved 1.5 billion dollars annually.

• Implemented a Model which measures the outcome of the bottle based on the recipe and predicted whether the bottle will pass the acceptance test before production accurately by 100%.

• Successfully created formulas which would predict the outcome of the recipe and enhanced model accuracy by 25%. DATA ANALYST Oct 2020 - Jan 2023

Deloitte Hyderabad, India

• Reengineered Cargill’s CPQ quoting platform, reducing quoting time by 35% through Salesforce CRM integration, enhancing data accuracy, and enabling AI-driven pricing guidance.

• Collaborated with Cross-functional teams to conduct ad-hoc analysis thereby mitigating profit and margin leaks.

• Led data governance initiatives by enforcing role & profile-based access and action policies by continuous learning.

• Developed Power BI reports to track sales pipelines, analyzed datasets for market trends, evaluated AI pricing, optimizing production, boosting revenue by 23%.

• Facilitated User Acceptance Testing (UAT) for security configurations & provided training to stakeholders on access management.

BUSINESS INTELLIGENCE ANALYST INTERN Jan 2020 - May 2020 Accenture Chennai, India

• Architected Customer Data Platform using object-oriented programming, AWS Lambda, DynamoDB, SQS queues to onboard advertising partners, fetching and pushing CDP data to Data Lakes, resulting in 11% increase in ad campaign efficiency.

• Streamlined data integration processes by implementing automated ETL workflows, reducing data processing time by 40% and improving data accuracy by 25%.

• Collaborated with finance teams to gather data requirements, designing and implementing data pipelines to ensure availability for financial reporting.

• Developed Tableau financial dashboards, enabling actionable insights for stakeholders, resulting in a 15% improvement in data-driven decision-making.

EDUCATION

MASTER OF SCIENCE IN DATA SCIENCE Jan 2023 - Dec 2024 University of Connecticut Hartford, CT

BACHELOR OF ENGINEERING IN COMPUTER SCIENCE Aug 2016 - May 2020 Osmania University India

SKILLS

SQL, Python, T-SQL, R, C, MySQL, Oracle, Snowflake, DynamoDB, MongoDB, NoSQL, PostgreSQL, Pandas, NumPy, Matplotlib, Seaborn, Sas, Excel, Power BI, Tableau, Alteryx, QlikView, Hadoop, Hive, Apache Spark, Kafka, Informatica, Snap Logic, Talend, Airflow, SSIS, AWS, GCP, Azure. ADDITIONAL INFORMATION

ACADEMIC PROJECTS

Data Warehousing and Business Intelligence for IMDB

• Implemented star/snowflake schemas to design Enterprise Data Warehouse (EDW) by dimensional modeling

• Performed data profiling using Alteryx for addressing data quality gaps through data cleaning, testing, normalization process

• Developed Power BI dashboards to monitor movie rating trends, review count by region, user category, genres, years for 200 movies

ACADEMIC PROJECTS

Database Integration & Dimensional Modeling for

NYPD dataset

• Demonstrated a data model for NYPD dataset after converting it to 3rd normal form implementing Normalization techniques

• Analyzed data using Alteryx and incorporated Data integration using Talend for loading the data into tables

• Built SQL scripts to deliver required insights from the NYPD dataset for case study

Contact this candidate