Power Bi Business Intelligence

Jagadeesh Kumar Gorla

312-***-**** *******************@*****.*** LinkedIn

Professional Summary

9+ years of experience in Business Analysis, Process Improvement,Data Analytics, and Business Intelligence across healthcare and financial services.

Proven ability to automate and optimize processes, reducing costs, improving efficiency, and ensuring data accuracy using Lean Six Sigma methodologies, process mapping and automation.

Expertise in data visualization, reporting, and dashboard creation using Power BI, Tableau, Alteryx, SQL, and Python.

Expertise in business process modeling (BPM), risk assessment, and business continuity planning (BCP) to enhance operational resilience.

Skilled in requirement gathering, stakeholder management, and Agile methodologies, with hands-on experience in JIRA, Confluence, and Six Sigma Black Belt.

Experienced in leading cross-functional teams, training 100+ employees, and fostering a data-driven culture.

Recognized for delivering strategic solutions, improving operational efficiency, and reducing manual efforts through cloud-based analytics and workflow automation.

Skills

Business Process & Analytical Skills

Business Analysis & Process Improvement

Data Visualization & Reporting (Microsoft Excel, Power BI, Tableau, Alteryx)

Agile & Scrum Methodologies (JIRA, Confluence)

Process Mapping & Workflow Documentation (Visio, Lucidchart, BPMN)

Business Continuity Planning (BCP) & Disaster Recovery Strategies

Risk Analysis & Operational Resilience

Stakeholder Engagement & Requirement Gathering

KPI Dashboards & Automation

Technical Skills

Databases: SQL, Oracle DBA, Postgres, Azure Cloud

Programming: Python, R, Excel VBA, JavaScript, FastAPI

Cloud Technologies: Snowflake, AWS (EC2, S3), Azure

Machine Learning: Pandas, NumPy, Scikit-learn, TensorFlow, PySpark

Project Management: Six Sigma Black Belt, ServiceNow, User Stories

Work Experience

Senior Business Analyst (SOS3)

Wells Fargo, Bangalore, India AUG 2020 – APR 2022

Led automation of 100+ reports and dashboards using Excel VBA, Tableau, and Alteryx, reducing manual workload by 15% and saving the equivalent of 7 full-time employees.

Developed dynamic dashboards for real-time data tracking, improving accuracy by 30% and enhancing performance evaluation by 25%.

Optimized process flows, increasing team productivity by 20% through bottleneck identification and strategic planning.

Utilized Six Sigma methodologies, achieving $300,000 in annual cost savings through data-driven process improvements.

Trained 100+ employees in data analysis, risk mitigation, automation, and UAT, improving process efficiency by 40%.

Managed a 10-member analyst team, improving asset management efficiency by 20% through strategic data insights.

Developed automated tracking systems, reducing manual data entry by 50%, saving 200+ hours annually.

Conducted process mapping and business impact analysis (BIA) for critical banking functions, ensuring resilience in technology disruptions.

Developed standardized user guides and contingency playbooks, improving operational response time by 30% in disruption scenarios.

Extracted and prepared large-scale financial data using SQL & Alteryx, ensuring high data quality and compliance.

Tools & Technologies: Power BI, Tableau, QlikView, SQL, Alteryx, Six Sigma, Agile, Jira, Confluence, Excel VBA

Business Analyst

First Source Solutions, Bangalore, India Jul 2016 - Apr 2019

Led business process automation in healthcare claims and reporting, reducing processing time by 20%.

Automated 45+ healthcare reports using SQL, Power BI, and Excel VBA, saving 0.8 FTE in manual effort.

Enhanced incentive reporting using Pareto Analysis, improving performance evaluations by 15%.

Conducted root cause analysis to reduce SLA non-compliance issues by 30%.

Developed stored procedures and optimized SQL queries, improving database performance by 25%.

Managed financial reconciliation projects, reducing error rates by 30% through better process flows and automation.

Designed step-by-step user guides for claims processing teams to handle service disruptions, reducing downtime by 25%.

Acted as a liaison between healthcare business teams and IT, ensuring accurate requirement translation for EHR (Electronic Health Records) systems.

Created process flow diagrams to optimize healthcare data workflows, ensuring compliance with HIPAA privacy rules.

Tools & Technologies: Power BI, Tableau, SQL, Agile, Jira, Excel VBA, Six Sigma, Visio

Business Data Analyst

Intelsoft Pvt Ltd, Bangalore, India AUG 2013 – APR 2016

Conducted business analysis for healthcare data management systems, ensuring compliance with HIPAA Privacy & Security Rules.

Assisted in the migration of healthcare data systems, supporting ICD-10 transition and improving medical coding efficiency.

Developed BRD, FRD, and SRS documentation for healthcare applications used in claims processing, patient record management, and provider networks.

Facilitated JAD sessions with healthcare professionals to refine EHR (Electronic Health Records) systems for better patient data accessibility.

Automated healthcare reporting dashboards using Power BI, SQL, and Excel VBA, reducing manual reporting efforts by 40%.

Designed and executed test plans for claims processing, billing automation, and eligibility verification systems.

Analyzed patient demographics and treatment data, providing insights that supported hospital administrators in resource allocation and service optimization.

Tools & Technologies: Power BI, SQL, Excel VBA, Healthcare Data Analytics, HIPAA Compliance, Agile, JIRA, MS Visio

Education

Master of Information Technology in Data Analytics

Illinois Institute of Technology, Chicago, IL Aug 2022 – May 2024 GPA: 3.8

Analyzed 3M+ Chicago crime records using Python & Azure, developing predictive ML models for public safety strategies.

Engineered a student aid web app integrating FastAPI, JavaScript, and AI-powered data visualization tools.

Designed a real-time fraud detection system using machine learning algorithms, increasing fraud detection accuracy by 25%.

Developed a Power BI dashboard for a large-scale healthcare dataset, providing real-time insights on patient records.

Led a cloud migration project to transition big data storage to Azure, improving system scalability and reducing costs by 15%.

Contact this candidate