Power Bi Data Analytics

SUMMARY

SAIROOPESH MADHAMSETTY

+1-860-***-**** *******.***********@*****.*** LinkedIn

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 TECHNICAL SKILLS

•Programming: SQL, Python, T- SQL, R, C,, MySQL, Oracle, Snowflake, DynamoDB, MongoDB, NoSQL, PostgreSQL

•Data Analysis: Python (Pandas, NumPy, Matplotlib, Seaborn), SQL, Sas, R, Excel (VBA, Pivot Tables),Predictive Modelling, Statistical &Regression Analysis, Time Series, Hypothesis Testing, Forecasting, A/B testing, Web Analytics

•Visualization, Warehousing & ETL: Power BI, Tableau, Alteryx, QlikView, Snowflake, Data Bricks, Informatica, Redshift

•Big Data and ETL Tools: Hadoop, Hive, Apache Spark, Kafka, Spark-Streaming, Informatica, Snap Logic, Talend, Airflow, SSIS

•Data Pipeline: Informatica PowerCenter, Airflow, SSIS, Talend, CI/CD, Jenkins, GitLab, Docker, Kubernetes, Alteryx Power BI, Tableau, Alteryx, QlikView, Snowflake, Data Bricks, Informatica, Redshift

•Cloud Platforms: AWS (Lambda, S3, RDS, CloudWatch, CloudFormation), GCP, Azure

•Certifications: SQL, Intro to Data Science, AWS and Microsoft Azure, Certified Scrum Master, PMP, CISA, CPA WORK EXPERIENCE

Consultant, PepsiCo Hartford, CT Aug 2024 – Dec 2024

•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, Deloitte Hyderabad, India Oct 2020 – Jan 2023

•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, Accenture Chennai, India Jan 2020 – May 2020

•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%.

•Developed and maintained financial data models and databases, enabling efficient storage and retrieval of financial data for budgeting, forecasting, and financial analysis purposes.

•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.

ACADEMIC PROJECTS

Data Warehousing and Business Intelligence for IMDB Talend, Alteryx, Tableau, Power BI Aug 2023

•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 Database Integration & Dimensional Modeling for NYPD dataset Talend, Data Modeling Jan 2024

•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 EDUCATION

Master of Science in Data Science, University of Connecticut, Hartford, CT Jan 2023 – Dec 2024 Bachelor of Engineering in Computer science, Osmania University, India Aug 2016 – May 2020

Contact this candidate