Data Analyst Power Bi

Harijanardhana Reddy Uppala Data Analyst

+1-848-***-**** ********************@*****.***

Summary

Data Analytics professional with 5+ years of experience in business analysis, operations analytics, and business intelligence across banking and consulting environments. Skilled in SQL, Power BI, Tableau, Python, and cloud platforms (Azure, AWS, Snowflake). Proven record of automating reporting workflows, optimizing ETL processes, and building executive dashboards that improve decision-making. Adept at risk monitoring, compliance reporting, and delivering scalable data solutions that enhance governance and operational performance.

Technical Skills

• Data Analytics & BI: SQL, Tableau, Power BI, Excel, Data Modeling, Executive Dashboards

• Cloud & Databases: Azure SQL, AWS RDS, Snowflake, Data Warehousing, ETL Processes

• Programming: Python (Pandas, NumPy), R, Shell Scripting

• Statistics & ML: Regression, Classification, A/B Testing, Time-Series Analysis

• Tools & Collaboration: PowerPoint, SharePoint, Jira, Confluence Professional Experience

Capital One, McLean, VA Nov 2023 – present

Data Analyst

• Designed Power BI and Tableau dashboards for loan growth, portfolio performance, and client engagement KPIs.

• Automated SQL and Python workflows, cutting manual reporting.

• Partnered with Finance, Operations, and IT to standardize reporting across 5+ business units.

• Migrated reporting from legacy systems to cloud (Azure, AWS), improving scalability.

• Supported risk & compliance monitoring, aligning reports with governance frameworks.

• Created optimized SQL queries and ETL workflows, reducing processing.

• Trained business users on self-service BI dashboards, reducing reliance on analysts.

• Conducted portfolio validation and reconciliation to improve data accuracy.

• Built executive decks and performance reports for senior leadership reviews.

• Contributed to vendor management, campaign tracking, and pipeline performance analysis. PNC Bank, Pittsburgh, PA Sep 2022 – Oct 2023

Data Analytics Consultant

• Conducted analytics on Commercial & CRE loan portfolios, uncovering $25M+ growth opportunities.

• Built executive dashboards to track KPIs, portfolio health, and compliance adherence.

• Partnered with Risk & Compliance to enhance pipeline risk monitoring, reducing delays.

• Streamlined reporting workflows by integrating SQL queries with cloud BI dashboards.

• Led weekly performance reviews, presenting insights on pipeline and loan performance trends.

• Collaborated with bankers, ARDs, and Finance to improve reporting efficiency.

• Designed ad-hoc reports and custom SQL queries for leadership initiatives.

• Developed data dictionaries and documentation for standardized analytics.

• Worked with IT to align BI reports with data warehouse architecture.

• Supported vendor oversight and resource allocation analysis through data-driven insights. HDFC Bank, Mumbai, India Dec 2019 – Dec 2021

Data Analyst

• Delivered sales and portfolio analytics for retail & commercial banking strategies.

• Built Excel and Power BI dashboards for portfolio visibility and risk tracking.

• Partnered with Risk & Compliance on early warning indicators, reducing loan default risks.

• Conducted campaign and pipeline performance analysis across regions.

• Automated reporting tasks, reducing turnaround from 2 days to a few hours.

• Supported data migration during core system upgrades, ensuring accurate validation.

• Developed standardized templates to reduce inconsistencies across teams.

• Segmented customer data for portfolio risk and repayment trend analysis.

• Delivered data-driven insights for leadership strategy and decision-making.

• Provided training sessions to junior analysts on BI and reporting practices. Education

University of Bridgeport – Master’s in Computer Science

Contact this candidate