Data Analyst Power Bi

Kovvuru Saicharanreddy Data Analyst

Hayward, CA, USA +1-408-***-**** ******************@*****.*** LinkedIn PROFESSIONAL SUMMARY

Data Analyst with 5+ years of experience delivering data-driven solutions across banking, healthcare, and tech industries. Proficient in SQL, Python, Power BI, Tableau, Snowflake, and Databricks for building predictive models, automating ETL pipelines, and developing real-time dashboards. Demonstrated success in improving loan approvals, reducing fraud exposure, and enhancing reporting accuracy by solving high-impact business problems. Adept at working with large, messy datasets under tight deadlines in cloud and on-premise environments. Strong communicator and self-starter who connects data to action across cross-functional teams.

TECHNICAL SKILLS

Data Visualization and Analytics Tools: Power BI, Tableau, Looker, Qlik Sense, KPI Dashboards, Row-Level Security (RLS), Google Analytics, Ad Hoc Reporting, MS Excel.

Programming Languages: SQL (CTEs, Window Functions, Optimization), Python (Pandas, NumPy), PySpark, R, DBT (macros, tests).

Cloud & Big Data Platforms: AWS (S3, Redshift, Athena, Glue, EMR, EC2), Azure (Synapse, Blob Storage, Data Factory), GCP (Big Query), Snowflake, Databricks, Delta Lake.

ETL & Workflow Orchestration: Apache Airflow, DBT, Prefect, Kafka, Power Automate, AWS Glue, Alteryx Machine Learning & Predictive Analytics: Scikit-Learn, XGBoost, Logistic Regression, Clustering (K-Means), Forecasting (ARIMA, Prophet), Bayesian Statistics, A/B Testing, Hypothesis Testing. Data Science & Statistical Modeling: Data Exploration, Data Mining, Classification, Clustering, Predictive Analytics, Risk Modeling.

Data Engineering & Warehousing: Apache Spark, Hadoop, ETL Pipelines, Data Cleansing, Data Modeling (Star/Snowflake), Databricks.

Business & Strategic Analytics: Customer Segmentation, Revenue Optimization, Churn Prediction, Data-Driven Decision Making. Data Governance & Regulatory Compliance: Data Quality Management (DQM), Metadata Management, Master Data Management (MDM),Great Expectations, Data Lineage, Collibra, GDPR, CCPA, HIPAA. Collaboration & Project Delivery: Agile Methodologies (Scrum, JIRA), Cross-Functional Collaboration, Stakeholder Management, Strategic Decision-Making, Data Storytelling, Confluence, Version Control (Git/GitLab). PROFESSIONAL EXPERIENCE

Fifth Third Bank Jul 2023 - Current

Data Analyst Retail Banking Analytics United States Project Description:

Led data analytics projects across fraud detection, credit risk modeling, and customer segmentation. Engineered real-time ETL pipelines and predictive models using Python, SQL, Databricks, and Power BI on Azure.

• Developed Power BI dashboards using DAX and SQL to monitor churn, CLV, and engagement metrics, reducing customer attrition by 8% across 2.4M+ savings and credit accounts.

• Enhanced credit risk models by analyzing 80K+ borrower profiles using Scikit-learn on Databricks, reducing loan default rates by 5% via behavioural segmentation and improved credit risk stratification.

• Rebuilt a Python-based pricing engine using historical lending patterns, competitor benchmarks, and treasury rate data— boosting net interest margin (NIM) by 3% on personal loan products.

• Ran various A/B tests on personalized campaigns using Python (SciPy, Stats Models), increasing multi-product conversion by 7% and optimizing digital marketing ROI.

• Tuned Kafka-based ETL pipelines using Databricks notebooks, reducing query latency by 50% and enabling real-time anomaly detection across 12M+ monthly transactions.

• Integrated scoring dashboards into core banking systems across 5 loan categories, accelerating credit approvals by 30% and enhancing approval precision by 22% via data-driven decision triggers.

• Built data lineage workflows and 40+ automated quality checks, improving FDIC/OCC audit readiness and compliance traceability across credit analytics pipelines.

• Automated ML model deployment using Azure DevOps, GitLab, Docker, and Kubernetes, increasing release velocity by 40% with rollback time reduced from 4 hours to 30 minutes.

• Analyzed savings and deposit account trends using SQL and Power BI, uncovering underperforming segments and driving a 6% increase in retention through targeted outreach.

• Delivered executive dashboards in Tableau and Power BI, enabling leadership visibility into portfolio health, fraud anomalies, churn trends, and product growth metrics.

Infosys Limited Aug 2021 - Dec 2022

Data Analyst Healthcare analytics India

Project Description:

Delivered data solutions for EHR analytics, regulatory compliance (HIPAA, SOX, MIPS), and patient quality reporting. Automated pipelines, standardized models, and performed claims analysis across AWS and Databricks ecosystem.

• Directed Tableau dashboards with row-level security (RLS) and drill-down capabilities, improving EHR workflow efficiency by 25% across provider networks and geographic regions.

• Performed SQL joins, unions, and aggregations on 5M+ claims records, automating validation rules to reduce report inconsistencies by 30% and enhance data schema reliability.

• Consolidated multiple EHR, lab, and pharmacy data sources into unified schema models, supporting CMS MIPS, NCQA, and clinical research benchmarks across three client organizations.

• Queried and analyzed EHR datasets in AWS using Athena and Databricks to identify documentation gaps and enhance clinical data completeness.

• Maintained metadata dictionaries and standardized glossary terms for 100+ data assets, improving traceability across compliance reporting and enhancing audit transparency.

• Upgraded PySpark-based ingestion pipelines and scheduled DAGs in Airflow, reducing daily refresh errors by 45% and enabling ingestion from external sources.

• Enforced HIPAA and SOX-compliant controls in ETL workflows, safeguarding PHI for 2M+ patient records and ensuring 100% quarterly audit compliance across review cycles.

• Automated CMS MIPS metric validation scripts, improving submission accuracy by 30% and reducing provider penalties under value-based care programs.

• Integrated outputs from SAS risk models into Tableau dashboards, visualizing 15+ provider quality metrics and improving treatment plans and payer reimbursement alignment.

• Partnered with clinicians and data engineers to refine data models, improving care quality interpretations and outcomes reporting for major hospital groups.

• Developed reusable mapping functions and parameterized Airflow tasks, reducing manual ETL interventions by 40% across 24x7 production environments.

ACS Technologies Limited Aug 2019 - Jun 2021

Junior Data Analyst Business Intelligence & Operations Analytics India

• Authored Power BI dashboards using SQL Server datasets, enabling department heads to track KPIs such as revenue, utilization, and ticket resolution with enhanced visibility and self-service insights.

• Refactored legacy SQL queries to optimize ad hoc reporting, decreasing refresh latency by 30% and improving reliability in leadership-level performance dashboards.

• Designed SQL-based ETL pipelines to migrate historical data from on-premise to cloud environments, reducing data loss and enhancing centralized reporting layer accuracy.

• Implemented role-based access controls and audit logging in Power BI reports, achieving 100% audit compliance over 3 quarters and eliminating unauthorized access issues across enterprise-level BI reports.

• Applied normalization and indexing techniques to ensure referential integrity, improving query efficiency by 25% and reducing redundancy in relational database systems supporting business intelligence dashboards.

• Spearheaded ETL data cleansing logic to handle nulls, outliers, and duplicates, improving consistency in Power BI dashboards and Excel-based monthly reporting packs.

• Automated daily operational reports using Bash scripting, reducing manual workload by 40% and improving turnaround time for cross-functional operations teams.

• Prepared BigQuery pipelines on GCP to process structured billing datasets, enhancing KPI dashboard refresh speed by 40% and reducing monthly query execution costs by 20%. EDUCATION

Master’s in Business analytics (STEM)

California State University East bay, Hayward, CA, USA Electronics and communication Engineering (ECE)

SRM Institute of Science and Technology, Chennai, India

Contact this candidate