Power Bi Data Analyst

MUKKANTESWARUDU MASABATTHINI

Saint Louis, MO +1-314-***-****

****************@*****.*** linkedin.com/in/mukkanteswarudum PROFESSIONAL SUMMARY

• Business & Data Analyst with 4+ years of experience delivering case-management, e-filing, and analytics solutions for healthcare, logistics, and public-sector clients.

• Proven ability to streamline operations, cutting cycle times by up to 35% and reducing manual effort by 40% through automation and process re-engineering.

• Skilled in SQL, Python, Power BI, and Tableau for data modeling, analytics, and executive-level dashboard development.

• Experienced in Agile Scrum facilitation, managing backlogs of 400+ user stories, and ensuring traceability for compliance-driven projects.

• Open-source contributor with a focus on HIPAA-compliant analytics, public-sector data quality, and operational efficiency.

• Strong soft skills including stakeholder communication, cross-functional collaboration, problem-solving, adaptability, time management, and decision-making in high-pressure project environments.

• Adept at UAT execution with 50+ users and delivering solutions with up to 96% user acceptance rates. AREAS OF EXPERTISE

• Languages & Tools: SQL, Python (Pandas, NumPy, scikit-learn, OR-Tools, Matplotlib), Power BI, Tableau, Figma, Visio, JIRA, Docker

• Domains: Case Management, Electronic Filing & Payments, Healthcare, Logistics, Public-Sector Portals

• Methodologies: Agile Scrum, User-Centered Design, Gap Analysis, Traceability Matrix, UAT

• Soft Skills: Stakeholder Communication, Cross-Functional Collaboration, Problem-Solving, Analytical Thinking, Adaptability, Time Management, Decision-Making, Attention to Detail, Presentation Skills CORE COMPETENCIES

• Public-Sector Case Management & Workflow Optimization

• Electronic Filing & Penalty Payment Processing

• AS-IS / TO-BE Process Mapping & Gap Analysis

• Agile Scrum Ceremonies & Backlog Management

• Power BI & Tableau Dashboard Development

• SQL & Python Data Processing (Pandas, OR-Tools, scikit-learn)

• UAT Planning & Execution with Stakeholder Engagement

• Mobile-First UX & Regulatory Compliance Reporting

• Cross-Functional Team Collaboration & Stakeholder Training PROFESSIONAL EXPERIENCE

Infosys, Hyderabad, India & Saint Louis, MO Sept 2021 – Dec 2022 Business Analyst

• State Licensing Case-Management Modernization: Led end-to-end requirements gathering and process re-engineering for replacing a legacy mainframe with a cloud-first Java/React portal; reduced average filing time by 35% and late filings by 22% using automated reminders and mobile push notifications.

• Designed end-to-end process flows, AS-IS/TO-BE maps, and impact analyses to guide development and ensure compliance with state regulations.

• Electronic Penalty Payments: Integrated ACH/credit-card payment gateway with the state treasury system, reducing manual reconciliation workload by 40% and minimizing payment delays.

• Public KPI Dashboards: Developed nightly-refresh Power BI dashboards for tracking "% on-time filings" and "average resolution days" by sourcing data from SQL stored procedures, enabling real-time executive monitoring.

• Agile Facilitation: Acted as Scrum Master for a 12-member cross-functional team, running sprint ceremonies, backlog refinement, and maintaining 400+ user stories & traceability matrix in JIRA.

• UAT Leadership: Coordinated User Acceptance Testing with 50+ end users, achieving a 96% acceptance rate and ensuring smooth post- go-live transition.

SimpliLearn, Guntur, India Jun 2021 - Aug 2021

Business Analyst Intern

• Extracted and analyzed learner engagement data using SQL, creating Power BI dashboards that cut weekly reporting time by 30%.

• Designed Figma wireframes to enhance course navigation, contributing to a 15% drop in support tickets.

• Collaborated with product and engineering teams to translate learner feedback into actionable UI/UX improvements. TECHNICAL PROJECTS

Diabetes Prediction Tool

• Developed a machine learning model using logistic regression and random forest algorithms to predict the likelihood of diabetes in patients.

• Utilized synthetic patient datasets from Synthea to simulate real-world healthcare scenarios.

• Conducted exploratory data analysis (EDA) using Matplotlib and Seaborn to identify key features affecting diabetes risk.

• Integrated model evaluation metrics (precision, recall, ROC AUC) to assess performance and reduce false positives.

• Visualized prediction outcomes and patient demographics in an interactive Power BI dashboard for healthcare stakeholders.

• Automated weekly data refreshes in Power BI for up-to-date monitoring of patient health indicators.

• Designed a user interface mockup in Figma to demonstrate how the tool could be embedded in a hospital management system.

Cybersecurity Metrics Dashboard

• Designed and deployed a dynamic Tableau dashboard that consolidated key cybersecurity performance indicators.

• Wrote optimized SQL queries to extract and aggregate data from enterprise security systems.

• Tracked metrics such as intrusion attempts, patch compliance, and mean time to detect (MTTD).

• Achieved a 20% reduction in average threat mitigation time through visual insight into threat hotspots.

• Implemented calculated fields and filters in Tableau to allow real-time exploration by incident type and severity.

• Developed alert thresholds for critical KPIs to proactively notify cybersecurity teams.

• Conducted stakeholder workshops to gather requirements and iterate on dashboard features.

• Integrated historical breach trends and predictive analytics for forward-looking risk assessment. Logistics Application Optimization

• Analyzed an existing logistics management workflow and identified process bottlenecks using Microsoft Visio.

• Redesigned the end-to-end shipping and inventory handling process to eliminate redundant approvals and data entry steps.

• Documented AS-IS and TO-BE processes to highlight changes and secure stakeholder buy-in.

• Integrated automation strategies such as barcode scanning and batch tracking for warehouse operations.

• Calculated time savings and cost reductions post-optimization, resulting in an 18% improvement in operational efficiency.

• Presented KPIs such as order processing time and delivery turnaround in a Power BI dashboard.

• Created a user training guide for system users to adopt the revised workflow with minimal friction. Sales Trends Analytics

• Collected multi-channel sales data spanning 2 years and conducted preprocessing using Python.

• Built predictive models using linear regression, ARIMA, and XGBoost to forecast future sales with high accuracy.

• Evaluated models using cross-validation, RMSE, and MAE to determine best-fit algorithm.

• Segmented sales data by region, product line, and time of year to identify high-performing segments.

• Created Power BI dashboards that dynamically updated with new data and included interactive filters.

• Identified underperforming SKUs and provided insights into seasonal demand patterns.

• Enabled executive leadership to plan inventory and pricing strategies based on insights. SELECTED PROJECTS & OPEN-SOURCE CONTRIBUTIONS

Google OR-Tools Route Optimization (Open-Source Fork)

• Developed Jupyter notebook pipeline ingesting IoT fill-level sensor data and historical route logs.

• Ran simulations showing 19% mileage reduction and 14% overtime savings while maintaining 100% SLA compliance. Microsoft FHIR-Server Analytics Extension (Open-Source)

• Built dbt transformation models converting FHIR JSON into HIPAA-compliant star-schema tables.

• Enabled hospital teams to deploy Power BI dashboards in under 2 hours. Great Expectations Public-Sector Data-Quality Suite (Open-Source)

• Authored custom expectation packs for licensing and penalty-payment feeds.

• Improved nightly dashboard accuracy from ~95% to 99%. Smart-City Waste Collection Optimization (City Micro-Contract)

• Integrated IoT fill-level sensors with BigQuery logs; applied OR-Tools VRP solver for route planning.

• Projected 19% fewer miles and 14% overtime reduction, using SHA-256 hashing and GPS fuzzing for privacy compliance. Retail Footfall & Conversion Analytics (Fashion Retailer)

• Combined POS and Wi-Fi sensor data to engineer dwell-time metrics and zone heatmaps.

• Delivered Power BI dashboard that guided staffing changes, lifting in-store conversion by 12%. Fintech Loan Default Risk Engine (Seed-Stage Startup)

• Developed XGBoost risk-scoring model on 150k anonymized loans, reducing underwriting time 48h 6h and early defaults by 8%.

• Deployed Dockerized REST API with Streamlit prototype and MLOps runbook. SaaS Customer-Churn Predictor (B2B SaaS, NDA)

• Built churn-propensity pipeline using BigQuery, Python (Cox PH, scikit-learn).

• Created Tableau dashboards flagging at-risk accounts 60 days in advance, reducing churn by 5% in pilot. EDUCATION & CERITIFICATIONS

• Master of Science in Applied Analytics (GPA: 3.4/4) Jan 2023 – Dec 2024 Saint Louis University, St. Louis, MO

• Bachelor of Science in Business Technology Management (CGPA: 7.73/10) May 2017 – Apr 2021 KL University, Guntur, India

Contact this candidate