Data Analyst Power BI & AWS Cloud

Vivek Prodduturi

DATA ANALYST – POWER BI & CLOUD ANALYTICS

+1-562-***-**** **********@*****.*** Houston, TX Professional Summary

Data Analyst with 6+ years of experience in Power BI, Advanced SQL, AWS Cloud, and Enterprise Data Analytics – delivering actionable insights through interactive dashboards and KPI reporting. Expert in Power BI (Data Modeling, DAX, Power BI Service) for enterprise-grade reporting and visualization. Advanced SQL proficiency across PostgreSQL and relational databases, with experience in DynamoDB/NoSQL for modern data platforms. Strong experience with AWS Cloud services including S3, Redshift, and Lambda for scalable data solutions. Designed, developed, and maintained 40+ dashboards and reports, reducing report load times by 60% and improving decision-making speed by 40%. Excellent analytical, problem-solving, and communication skills with ability to partner with cross-functional teams. Passionate about leveraging data to drive business outcomes and operational excellence. Technical Skills

Power BI: Power BI Desktop, Power BI Service – data modeling, DAX measures, Power Query, row-level security, and performance optimization for enterprise reporting.

Advanced SQL: Expert T-SQL, PostgreSQL – complex queries, joins, CTEs, window functions, stored procedures, and performance tuning for large-scale datasets.

AWS Cloud: AWS (S3, Redshift, Lambda, Glue, RDS) – building scalable cloud-based data solutions and integrating data platforms. PostgreSQL: Advanced PostgreSQL – query optimization, data modeling, stored procedures, and performance tuning for enterprise analytics.

DynamoDB / NoSQL: DynamoDB and NoSQL databases – working with unstructured and semi-structured data for modern data platforms.

Dashboard Development: Building interactive dashboards and reports – with drill-through, bookmarks, and user-friendly visualizations for business intelligence.

KPI Reporting: KPI development, tracking, and reporting – defining metrics, scorecards, and performance dashboards for operational and strategic decision-making.

Enterprise Data Analytics: Analyzing large-scale enterprise datasets – identifying trends, patterns, and actionable insights to support business decisions.

Data Integration & ETL: ETL/ELT pipelines using AWS Glue, Python, and SQL – integrating data from multiple sources for enterprise analytics.

Certifications

Microsoft Certified: Power BI Data Analyst Associate (PL-300) Microsoft Microsoft Certified: Fabric Analytics Engineer Associate (DP-600) Microsoft AWS Certified Data Analytics – Specialty AWS

SQL Advanced Certificate Microsoft

Tableau Desktop Specialist Tableau

Experience

Bank of America – Data Analyst (Power BI & Cloud Analytics) Jan 2024 – Present Power BI, SQL, AWS, PostgreSQL, DynamoDB, Dashboard Development, KPI Reporting Houston, TX

– Designed, developed, and maintained 25+ Power BI dashboards and reports – with advanced DAX measures, data modeling, and Power Query transformations, enabling real-time KPI monitoring and reducing manual reporting effort by 85% for 200+ stakeholders.

– Wrote 300+ complex SQL queries across PostgreSQL and SQL Server – optimizing performance and reducing query execution time by 50% for enterprise data analytics and reporting.

– Leveraged AWS Cloud services (S3, Redshift, Lambda) – building scalable data pipelines and integrating data platforms, reducing data processing time by 40% and improving data freshness by 50%.

– Utilized PostgreSQL for advanced data modeling and query optimization – designing star/snowflake schemas that improved query performance by 50% and enabled scalable enterprise analytics.

– Worked with DynamoDB and NoSQL databases – integrating unstructured and semi-structured data into enterprise reporting, enabling new analytics use cases for 150+ stakeholders.

– Developed KPI reporting frameworks and scorecards – defining metrics for operational and strategic decision-making, improving business performance visibility by 35% and enabling data-driven decisions.

– Performed enterprise data analytics on large-scale datasets – identifying trends, patterns, and actionable insights that improved operational efficiency by 25% and reduced costs by 15%.

– Collaborated with cross-functional teams – understanding business requirements and delivering data solutions with 95% stakeholder satisfaction.

– Mentored 2 junior analysts on Power BI, SQL, and AWS best practices – increasing team productivity by 25%. Kroger – Data Analyst (BI & Analytics) Jan 2022 – Dec 2022 Power BI, SQL, Dashboard Development, KPI Reporting, Data Analysis Hyderabad, India

– Designed and developed 15+ Power BI dashboards and reports for supply chain, inventory, and sales analytics – empowering 80+ business users with self-service BI and reducing ad-hoc requests by 45%.

– Wrote 200+ complex SQL queries for data extraction and analysis – reducing report generation time by 60% for business intelligence reporting.

– Developed KPI reporting frameworks and scorecards – enabling data-driven decisions that reduced stockouts by 18% and improved inventory turnover by 12%.

– Performed enterprise data analytics on large-scale datasets – identifying trends and insights that improved operational efficiency by 25%.

– Collaborated with cross-functional teams – delivering data solutions that passed UAT with zero defects and achieved 95% stakeholder satisfaction.

– Optimized Power BI performance – reducing load times by 50% and improving user experience.

– Provided training and documentation to 25+ end-users – enabling self-service BI adoption across the organization. HCL Technologies – Data Analyst (Financial & Analytics) Jan 2020 – Dec 2021 SQL, Power BI, Data Analysis, Reporting Hyderabad, India

– Developed 15+ Power BI dashboards and reports for a banking client – supporting loan portfolio monitoring, risk assessment, and regulatory reporting with interactive visualizations.

– Wrote 150+ complex SQL queries for data extraction and analysis – reducing report generation time by 60% and improving data accuracy by 30%.

– Performed enterprise data analytics – identifying trends and insights that improved operational efficiency by 25%.

– Developed KPI reporting frameworks – enabling data-driven decisions and improving business performance visibility.

– Collaborated with cross-functional teams – delivering data solutions that passed UAT with zero defects and achieved 95% stakeholder satisfaction.

– Optimized Power BI performance – reducing load times by 50% and improving user experience.

– Provided training and documentation to 25+ end-users – enabling self-service BI adoption across the organization. Aramark at CSU Dominguez Hills – BI Developer (Power BI) Feb 2023 – Dec 2023 Power BI, SQL, Data Analysis, Reporting Carson, CA

– Designed and developed Power BI dashboards for revenue, labor costs, and customer satisfaction – enabling real-time visibility and improving operational efficiency by 20%.

– Wrote optimized SQL queries for data extraction and transformation – reducing report load times from 8 seconds to under 2 seconds through performance tuning.

– Developed KPI reporting frameworks – enabling data-driven decisions and improving business performance visibility.

– Performed enterprise data analytics – identifying trends and insights that improved decision-making and operational performance.

– Collaborated with stakeholders – delivering data solutions that reduced manual reporting effort by 8 hours/week.

– Documented data definitions, business rules, and analytical processes – facilitating knowledge transfer and long-term supportability.

– Optimized Power BI performance – improving user experience and report availability. Data Analytics & Business Intelligence Excellence

Power BI Development: Designed and deployed 50+ Power BI dashboards and reports – with 500+ DAX measures and data models, enabling 400+ stakeholders with self-service analytics and real-time business intelligence. Advanced SQL: Wrote 1,500+ complex SQL queries across PostgreSQL and SQL Server – achieving 99.9% data accuracy and 50% faster query execution for enterprise analytics.

AWS Cloud: Built scalable data pipelines on AWS (S3, Redshift, Lambda) – reducing data processing time by 40% and improving data freshness by 50% for enterprise data platforms. PostgreSQL: Designed and optimized 30+ data models on PostgreSQL – achieving 50% faster query execution and enabling scalable enterprise analytics.

DynamoDB / NoSQL: Integrated DynamoDB and NoSQL databases – enabling new analytics use cases for 150+ stakeholders with unstructured and semi-structured data.

Dashboard Development: Developed 50+ interactive dashboards – with drill-through, bookmarks, and user-friendly visualizations, improving user adoption by 45%.

KPI Reporting: Developed 100+ KPI reporting frameworks and scorecards – improving business performance visibility by 35% and enabling data-driven decisions.

Enterprise Data Analytics: Analyzed 10TB+ of enterprise data – identifying trends, patterns, and actionable insights that improved operational efficiency by 25% and reduced costs by 15%. Stakeholder Collaboration: Partnered with cross-functional teams on 50+ projects – delivering data solutions with 95% stakeholder satisfaction.

Certified & Continuously Learning: Holds PL-300, DP-203, AWS Data Analytics, SQL Advanced, and Tableau certifications – committed to excellence in data analytics and business intelligence. Education

California State University, Dominguez Hills 2023 – 2024 Master of Science in Computer Science California, USA

Contact this candidate