Power Bi Business Analyst

Anusha P

+* (***) *** - **** ***********@*****.*** Dallas, TX https://www.linkedin.com/in/anusha4211/

PROFESSIONAL SUMMARY

Data and Business Analyst with experience at J.P. Morgan, Humana, and Walmart Global Tech India. Skilled in transforming complex datasets into actionable insights that improve risk management, healthcare performance, and supply chain efficiency. Proficient in SQL, Python, R, Tableau, Power BI, and SAS. Expertise in dashboard optimization, automating ETL workflows, reporting automation, KPI tracking, predictive analytics, data quality, and data validation. Certified in Google Cloud Data Engineering, Power BI, Snowflake, and Alteryx. Strong ability to connect business needs with technical solutions to deliver insights that drive measurable results.

TECHNICAL SKILLS

Technical Category

Technical Skills

Databases & Warehousing

SQL, Snowflake, BigQuery, Oracle, SAP, SQL Server

Data Processing & ETL

AWS Glue, Alteryx, Python (Pandas, NumPy), R, Excel Macros, SAS, ETL Workflow Design, Kafka, Kinesis

Data Visualization & BI

Tableau, Power BI, DAX, QlikView, Excel (Pivot Models), Google Data Studio, Lucidchart, Visio

Statistical & ML Modeling

Python (Machine Learning, Pandas, Time-Series), R (Regression, Forecasting), SAS

Cloud & Integration

Google BigQuery, AWS (S3, EC2, Redshift) SAP Data Integration, Snowflake Pipelines, Spark

Automation & Scripting

Python Automation Scripts, R Scripts, Excel VBA Macros, SAS Scripts

Project & Workflow Tools

Jira, Confluence, Microsoft Visio, Lucidchart, Agile Ceremonies

Reporting & Compliance

SAS Regulatory Reporting, HIPPA, PHI, Compliance Dashboards, Risk Analytics Pipelines

Collaboration &

Documentation

Jira (Epics, Stories), Confluence (Requirements, Test Cases), Stakeholder Workshops

PROFESSIONAL EXPERIENCE

J.P.Morgan Sep 2024 – Present

Data Analyst Dallas, TX

Designed and optimized Python, SQL, Spark, and Snowflake queries to process millions of trade records, improving accuracy of analytics and regulatory reporting.

Built and maintained ETL pipelines in BigQuery and Snowflake, orchestrated with Alteryx workflows similar to Apache Airflow, reducing reporting latency from 30 minutes to under 5 minutes.

Engineered data models (star schema and snowflake schema) for trade and risk datasets, improving dashboard performance and reducing query complexity.

Developed real-time risk dashboards in Tableau and Power BI, powered by Kafka-based data pipelines that streamed intraday trade P&L and volatility metrics.

Applied machine learning techniques in Python (time-series forecasting, predictive analytics) to generate sector-wise risk scores, supporting portfolio decision-making.

Conducted derivatives anomaly detection using SQL and R regression models, reducing reconciliation errors by 25%.

Delivered compliance and audit-ready pipelines ensuring adherence to financial industry data governance and security best practices.

Partnered with cross-functional teams to translate business requirements into technical solutions, improving adoption of self-service data platforms.

Humana July 2023 – Aug 2024

Business / Data Analyst Austin, TX

Designed and deployed ETL pipelines in AWS Glue and Alteryx, integrating healthcare claims, encounters, and eligibility data into Snowflake and Amazon Redshift, reducing latency by 35%.

Leveraged Python, SQL, and Spark to clean, validate, and transform EHR and claims data, ensuring high data quality for analytics and reporting.

Automated ingestion of EDI files (837, 835, 834) via AWS S3 and EC2 services, streamlining downstream analytics and reporting processes.

Built and maintained Tableau and Power BI dashboards for claims, enrollment, and operational KPIs, enabling real- time decision-making for clinical and business teams.

Implemented Kinesis-based streaming pipelines to capture patient events and claims data in near real-time, enabling faster insights for operations teams.

Collaborated with compliance teams to enforce HIPAA and PHI security standards in AWS environments, passing multiple audits with zero findings.

Applied A/B testing and advanced SQL analytics to evaluate patient outcomes and claims accuracy, delivering insights that improved clinical workflows.

Documented BRDs, FRDs, and UAT for enterprise reporting projects, ensuring alignment between technical teams and business stakeholders.

Facilitated workshops and provided stakeholder training on self-service BI tools, improving adoption of analytics platforms across the organization.

Walmart Global Tech India June 2021 – Dec 2022

Business Analyst Bangalore, India

Gathered business requirements and translated them into Agile user stories in Jira and Confluence for cross-functional teams

Analyzed sales and supply chain datasets using SQL Server, Python, and Excel including Pivot Tables, VLOOKUP, and Power Query to optimize replenishment and reduce stockouts

Developed Power BI and Tableau dashboards integrating SQL and SAP data, providing visibility into supply chain KPIs and vendor performance

Partnered with SAP teams to extract procurement and inventory data for executive decision-making

Automated data cleaning using Python and VBA, reducing manual effort by 40 percent

Delivered executive reports on pricing mismatches, delayed deliveries, and high-demand product forecasting

Prepared datasets for demand forecasting using SQL and Python preprocessing, improving replenishment accuracy

Facilitated Agile ceremonies including sprint planning and retrospectives, aligning teams on dashboard enhancements and BI reporting deliverables

Applied data modeling techniques including star schema and snowflake schema for dashboard optimization and accurate KPI tracking

ACHIEVEMENTS

Built an end-to-end risk analytics solution leveraging SQL (joins, window functions), Python (Pandas, NumPy, Scikit- learn), and Tableau dashboards, enabling advanced data modelling, visualization, and reporting that reduced decision- making time for traders and executives by 40%.

Improved supply chain efficiency by designing SQL Server queries and Tableau BI dashboards integrated with procurement, sales, and inventory datasets from ERP systems (SAP/Oracle), reducing regional stockouts through real- time visibility into inventory levels, sales trends, and procurement performance.

ACADEMIC PROJECT

Project Title: Elite Party Services (Tech Stack: "Python, R, Jupyter Notebook").

Project Description: "Led a team to analyze data on user interest in party services, utilizing visual tools like graphs and charts to uncover trends and insights."

Analyzed user interest data and applied visualization techniques to identify service trends and actionable insights.

CERTIFICATIONS

Google Cloud Professional Data Engineer

Microsoft Power BI Data Analyst Associate

EDUCATION

Snowflake SnowPro Core Certification

Alteryx Designer Core Certification

Master of Science in Computer and Information Science Southern Arkansas University

Bachelor of Technology in Civil Engineering TKR College of Engineering and Technology

Contact this candidate