Business Analyst Power Bi

BHRAMARAMBA SIMHADRI

Business Analyst

Jersey City, NJ +1-551-***-**** ***********************@*****.*** SUMMARY

Results-oriented Business Analyst with 2.5 years of experience driving data-driven decisions and process improvements across consulting, healthcare, and travel domains. Expert in requirement gathering, process mapping, and advanced data analysis, leveraging tools like SQL, Python, Power BI, Tableau, Snowflake, and AWS to streamline workflows for 5M+ records, reduce compliance reporting time by 6 business days, and eliminate 240+ manual analyst hours annually. Proven ability to translate complex business requirements into actionable insights, design executive dashboards, and lead cross-functional agile teams delivering multi-million-dollar transformation projects. Known for improving forecasting accuracy to 95%, optimizing reporting efficiency, and aligning analytical solutions with enterprise strategy to drive measurable business growth. EXPERIENCE

McKinsey & Company USA August 2025 – Present

Business Analyst

● Gathered business and technical requirements that supported a $12M enterprise cost optimization program, by documenting BRDs and user stories in Confluence for 15+ stakeholders across finance and operations.

● Conducted market segmentation analysis using SQL and Excel to identify high-potential customer clusters, improving targeting accuracy by 20% and driving higher conversion.

● Reduced compliance reporting turnaround from 14 business days to 8, by mapping end-to-end workflows in Lucid chart and Visio And recommending redesigns for 7 identified inefficiencies.

● Built channel performance dashboards in Power BI to track sales KPIs across geographies, helping leadership reallocate marketing spend more efficiently.

● Delivered executive-level reports and visual insights summarizing consumer trends, pricing patterns, and competitive movement to support strategic planning.

● Performed forecasting and sales trend modeling using Python to predict quarterly revenue outcomes with 95% accuracy, enabling better inventory and budget planning.

Trinity Technolabs India May 2022 – July 2023

Business Analyst

● Collaborated with doctors, insurance teams, and developers to translate healthcare business needs into functional system requirements, ensuring regulatory alignment with HIPAA and HL7 standards.

● Orchestrated backlog grooming and sprint planning in Jira and Confluence, coordinating 12 stakeholders to resolve dependencies and cutting delivery delays by 9 releases annually.

● Interpreted business KPIs using SQL Server and Power BI, preparing executive dashboards that improved visibility and cut decision- making turnaround from 10 business days to 4.

● Optimized workflow automation using Python and Airflow, eliminating 240+ manual processing hours yearly and enabling compliance reporting for audit teams.

● Designed interactive Power BI dashboards to track hospital performance, readmission rates, and patient satisfaction, improving management decision-making speed by 30%.

● Facilitated cross-functional workshops with QA, developers, and business users, leveraging agile ceremonies and Azure DevOps boards to ensure end-to-end alignment during a $4.5M platform migration.

● Prepared KPI reports for executive stakeholders, highlighting trends in cost efficiency, patient throughput, and claim cycle times. Airbnb India May 2021 – April 2022

Business Analyst

● Analyzed 25,000+ booking and transaction records using SQL and Python (Pandas, NumPy), collaborating with finance teams to uncover anomalies that reduced refund processing time by 3 days per cycle.

● Mapped end-to-end reservation workflows in Lucidchart and Jira, identifying 14 bottlenecks and recommending optimizations that accelerated guest support resolution by 1,200 tickets annually.

● Evaluated business requirements with cross-functional teams, creating BRDs and FRDs and translating them into technical specifications that supported the launch of 6 new booking features.

● Analyzed flight booking and user journey data using SQL and Python to identify bottlenecks in the reservation process, improving booking success rate by 22%.

● Designed interactive Power BI dashboards to visualize flight demand, pricing fluctuations, and route performance across regions, helping leadership make data-driven pricing decisions.

● Validated UAT test cases in Tableau and Excel, coordinating with QA engineers and ensuring system accuracy that decreased failed bookings by 3,500 transactions quarterly.

● Facilitated sprint planning with product managers and developers, leveraging agile ceremonies and Confluence dashboards to align 8 team members, driving the on-time release of a high-priority API integration. TECHNICAL SKILLS

Business Analysis & Methodologies: Requirement Gathering, BRD/FRD, User Stories, UAT, Process Mapping, Change Management, Agile (Scrum, Sprint Planning), Waterfall Data Analysis & Visualization: SQL, Python (Pandas, NumPy), R, Power BI, Tableau, Looker, Excel (VBA, Power Query, PivotTables), Alteryx

Cloud & Data: AWS (S3, Glue, Redshift), Snowflake, Databricks, Google BigQuery, Microsoft Azure (Synapse, Data Factory), GCP ETL & Workflow Orchestration: Apache Airflow, SSIS, Informatica, Data Wrangling, Workflow Optimization Statistical & Analytical Techniques: Predictive Analytics, Hypothesis Testing, Forecasting Models, Machine Learning (Scikit-learn) Collaboration & Productivity Tools: Jira, Confluence, MS Visio, Lucidchart, Microsoft Office, Google Workspace, Slack, MS Teams Governance & APIs: Data Governance (HIPAA, GDPR), API Analysis & Documentation. PROJECTS

Corporate Social Responsibility Impact Study Pace University

● Analyzed survey responses from 500+ participants using R and SQL, identifying 3 consumer behavior patterns that influenced purchasing decisions in CSR campaigns.

● Prepared reports and visualizations that guided retail strategy changes, increasing adoption of sustainable products by 320 customers in the pilot group.

Sustainable Landscaping & Water Efficiency Project KLH Global Business School

● Evaluated water usage across 10+ sites and developed proposals in Excel and Tableau, achieving a reduction of 25,000 liters annually in overall consumption.

● Coordinated with 5 engineers and architects, producing 15 detailed project plans that shortened delivery timelines by 18 days and cutting costs by $12,000 in resource allocation. EDUCATION

Master of Business Administration in Business Analytics – Pace University NY, USA September 2023 – May2025 Bachelor of Business Administration – KLH Global Business School Hyd, India September 2020 – May 2023

Contact this candidate