Data Analyst Power Bi

ANUSHA SINGAMALA

New York, USA +1-716-***-**** ********************@*****.*** LinkedIn

Summary

Data Analyst with 4+ years of experience in Python (pandas, scikit-learn), SQL (BigQuery, Snowflake), and R for predictive modeling, risk analysis, and financial forecasting. Proven in building interactive dashboards (Tableau, Power BI) and automating ETL pipelines (Azure Data Factory, Airflow) that reduced hospital readmissions by 15% and optimized $200K in inventory costs. Skilled in statistical analysis (A/B testing, regression), healthcare data standards (HL7, HIPAA), and financial reporting (KPI tracking, ROI analysis). Skills

• Programming Languages: Python (pandas, NumPy, scikit-learn), SQL (Advanced Queries, Window Functions, CTEs, Query Optimization), R (tidyverse, ggplot2), Basic Bash/Shell Scripting

• Databases & Tools: PostgreSQL, MySQL, SQL Server, Snowflake, BigQuery, AWS Athena, SSMS, Data Modeling (Star Schema)

• Data Analysis & Visualization: Tableau (Dashboards, Calculated Fields), Power BI (DAX, Power Query), Looker, Jupyter Notebook, Google Data Studio, Python Libraries (Matplotlib, Seaborn, Plotly), Statistical Analysis (A/B Testing, Hypothesis Testing, Regression)

• Cloud & ETL: AWS (S3, Redshift, Glue), Azure (Synapse), GCP

(BigQuery), Basic ETL (Airflow)

• Statistical & Analytical Tools: Regression Analysis (Linear, Logistic), Predictive Modeling, SAS/SPSS (if industry-specific)

• Methodologies & Project Management: Agile (Scrum, Kanban), Jira

(Sprint Planning), Advanced Excel (Pivot Tables, VLOOKUP, Macros), CRM (Salesforce)

• Documentation & Reporting: Confluence, Technical Writing, Data Governance, Business Requirements Gathering

• Soft Skills: Stakeholder Management, Data Storytelling, Problem- Solving, Critical Thinking, Cross-functional Collaboration Professional Experiences

Data Analyst 02/2025 to Current

Capital One Remote, USA

• Automated monthly credit risk reports using Python (pandas) to analyse 2M+ customer transactions, reducing manual effort by 15 hours/month for the Risk Management team.

• Built a dynamic Tableau dashboard tracking loan approval rates in 50+ branches, identifying 3 underperforming regions for the Retail Lending Director.

• Optimized SQL queries for customer segmentation in Snowflake, cutting query runtime by 40% and faster campaign targeting for the Marketing team.

• Developed an A/B testing framework in R (tidyverse) to evaluate new card offers to increase in customer sign-ups for the Product Innovation team.

• Standardized 5 years of transaction data in BigQuery, clearing 200K+ inconsistencies to improve fraud detection for the Compliance Department.

• Designed a Power BI KPI tracker monitoring $500M+ deposit inflows/outflows, reducing reporting latency by 6 hours weekly for the Treasury team.

• Collaborated with engineers to deploy an Airflow pipeline automating daily balance sheet, eliminating 8 manual processes for the financial team.

• Audited 10+ legacy Excel models for loan delinquency tracking, migrating 3 critical models to Python to reduce errors by 25% for the Collections team.

• Presented data-driven insights on spending trends to senior leadership, influencing 2 new credit card features launched in Q3 2025. Data Analyst 06/2020 to 08/2023

Capgemini Bangalore, India

• Developed an Azure Data Factory pipeline to automate ETL workflows for patient records, reducing manual processing time from 7 hours to 2 hours daily for the healthcare operations team.

• Engineered a Python (PySpark) script to process 10M+ HL7 messages daily, reducing data latency by 40% for real-time patient monitoring systems.

• Designed a Power BI dashboard with DAX measures to track patient readmission rates, enabling identify high-risk cases and reduce readmissions.

• Built a predictive model using Scikit-learn (Random Forest) to forecast medical equipment demand, optimizing inventory costs by $200K annually for supply chain managers.

• Trained a XGBoost model (Python) to predict ICU bed demand, improving accuracy and reducing staff overtime costs by $35K/year.

• Migrated SQL Server databases to Azure Synapse Analytics, cutting query costs from $8,000/month to $4,500/month while handling 10TB+ data.

• Created Tableau visualizations for real-time bed occupancy tracking, reducing ER wait times by 30 minutes per patient for hospital staff.

• Automated Python scripts to clean and standardize EMR (Electronic Medical Records) from 5+ sources, eliminating 10,000+ monthly manual corrections for data integrity teams.

• Conducted A/B tests using SciPy/StatsModels to for telehealth adoption strategies, enabling a $500K revenue opportunity for the digital health division.

• Optimized SQL queries with window functions to accelerate patient billing reports, reducing runtime from 3 minutes to 20 seconds for finance teams.

• Trained 3 junior analysts in Python/Pandas, reducing their project turnaround time by 2 days per task and improving team productivity.

• Implemented Azure Blob Storage for HIPAA-compliant data archiving, reducing storage costs by $1,500/month while ensuring audit readiness. Data Analyst Intern 01/2020 to 06/2020

Capgemini Remote, India

• Engineered a Python-based ETL pipeline to process 10,000+ daily patient records in Azure Data Lake, reducing data processing time from 6 hours to 2 hours for the healthcare analytics team.

• Developed Power BI dashboards tracking hospital-acquired infections, enabling infection control teams to reduce cases by 12% across 5 facilities.

• Assisted in logistic regression modelling (AUC 0.85) to predict patient no-shows, saving 200+ physician hours monthly through better scheduling.

• Created SQL scripts with complex joins to analyse pharmacy inventory turnover, reducing expired medication waste by $75,000 annually.

• Optimized Azure Data Factory pipelines handling 5GB/day of lab test results, reducing pipeline failures from 3/week to 1/week.

• Documented data dictionaries for 50+ healthcare datasets, reducing onboarding time for new analysts by 40%. Certifications

• Microsoft Certified Azure Fundamentals

• Salesforce Certified AI Associate

• ITIL4 Foundation

Education

Master of Professional Studies: Data Sciences and Applications 12/2024 The State University of New York at Buffalo Buffalo, NY, USA Bachelor of Technology: Electronics and Communication Engineering 07/2021 Vel Tech University Chennai, Tamilnadu, IND

Projects

Retail Sales Performance Dashboard

• Developed an interactive Tableau dashboard analysing $5M+ in annual sales data, utilizing advanced calculated fields and SQL queries for dynamic customer segmentation and product profitability analysis.

• Identified and presented 3 key pricing and marketing opportunities, leading to a 15% increase in profitability for the retail product division. Healthcare Analytics & Management System

• Engineered a comprehensive Power BI dashboard integrated with an Oracle database to track 10K+ monthly patient admissions, average length of stay, and resource utilization metrics.

• Automated manual reporting processes, providing real-time insights that improved operational efficiency by 20% and reduced reporting time by 15 hours per week for hospital administrators.

University Data Integration & Migration

• Led a data migration project for a 50GB+ dataset, designing a normalized SQLite database schema to ensure data integrity and consistency across 10+ source tables.

• Developed Python ETL scripts to automate data cleaning and processing, improving data accessibility and usability by 39% for academic researchers and staff.

#HRJ#96c98fd4-8b45-4db3-8ffa-afbca7d41876#

Contact this candidate