Data Analyst Power Bi

Khaja Moin Md

Newark, Delaware 302-***-**** *********.***@*****.***

PROFESSIONAL SUMMARY

Results-driven Data Analyst with 5+ years of experience transforming raw data into strategic insights using SQL and modern BI tools. Expert in developing design solutions, creating test scenarios, and executing proof of concepts to mitigate risks. Proven ability to refine stories, accurately estimate work, and deliver integrated, robust applications aligned with business goals. EDUCATION

Wilmington University Present

MASTERS, INFORMATION SYSTEMS AND ASSURANCE

• GPA: 3.72

Gudlavalleru Engineering College Present

Bachelors

• GPA: 8.2

PROFESSIONAL EXPERIENCE

Starbucks Dec 2024 - Present

Data Analyst / BI Developer Remote

• Led cross-functional analytics projects, translating stakeholder needs into data models and visualizations that improved customer retention by 18%.

• Developed design solutions through robust Power BI dashboards integrating data from Azure SQL, PostgreSQL, and Excel, ensuring seamless integration with existing applications.

• Built predictive models using Python and machine learning to detect fraud patterns, increasing detection accuracy by 23%.

• Designed mobile-first PowerApps connected to CDS and SharePoint, enabling field teams to track distribution in real-time.

• Created optimized T-SQL stored procedures and performance-tuned indexes, reducing report load times by 40%.

• Engineered SSIS packages for complex ETL pipelines with real-time alerting and fault tolerance.

• Published and maintained reports in Power BI Service with advanced DAX, gateway configurations, and workspace governance.

• Finalized a central analytics platform that unified over 5M transaction records/month, improving decision agility. Molina Healthcare Jan 2024 - Nov 2024

Data Analyst / BI Developer Long Beach, CA

• Built Tableau dashboards and Power BI reports to monitor claims, risk, and member population data across medical departments.

• Conducted root cause analyses on cost overrun patterns, influencing cost-cutting initiatives that saved $1.2M annually.

• Developed SQL-driven BI tables from claims, billing (837/835), and enrollment data (834), supporting executive KPIs.

• Automated claims validation and cost prediction pipelines using statistical modeling in Python and Excel VBA, incorporating test scenarios to ensure robust solutions.

• Partnered with clinical informatics and data science teams to create data assets for Stop Loss and KICK projects.

• Improved financial visibility through dashboards that integrated disparate data sources (SSRS, SQL, Excel).

• Finalized healthcare reporting systems that reduced report delivery time by 60% and improved billing accuracy. Macy's (Retail / eCommerce) Feb 2023 - Dec 2023

Data Analyst New York, NY

• Designed SSIS packages and SQL-based ETL jobs to automate daily product and order data ingestion from diverse sources.

• Built Power BI dashboards and Excel models that forecasted demand, reduced stockouts, and optimized inventory.

• Implemented fraud detection models using logistic regression and anomaly detection, mitigating risk exposure by 15%.

• Created scalable Tableau reports analyzing customer behavior, supporting decisions for marketing and promotions.

• Led inventory performance tracking with multi-week trend visualizations, driving $400K in operational savings.

• Finalized end-to-end BI pipelines integrating data modeling, design solutions, and test scenarios, ensuring clear, robust, and well-tested interfaces.

iBase IT Jun 2020 - Nov 2022

Power BI / Tableau Developer Hyderabad, India

• Delivered 20+ enterprise-level Power BI/Tableau dashboards covering logistics, billing, and operations.

• Designed reusable SSIS templates for incremental loads from Excel, XML, and flat files, reducing development time by 30%.

• Integrated Power Apps with Power BI to enable write-back features and decision logging across business teams.

• Created and scheduled SQL Agent jobs for report automation and alerting.

• Conducted code reviews, data profiling, and root cause analysis for data quality issues across departments.

• Finalized a reusable reporting framework by contributing to story refinement and defining requirements, adopted by 4+ business units. PROJECTS

KICK Claims Insights System

Molina Healthcare

• Built a claims analytics system for KICK project at Molina Healthcare, integrating financial, claims, and enrollment data.

• Developed Tableau dashboards highlighting cost-saving opportunities and early trend detection in claims data.

• Automated data prep with SSIS and created SQL logic to parse EDI files for analysis. Predictive Fraud Detection Engine

TSYS

• Designed ML pipeline using classification models to detect fraudulent transactions at TSYS.

• Trained model on millions of records and deployed results into Power BI dashboard for real-time alerts. TECHNICAL SKILLS

• Languages: Python, R, SQL, Java

• Databases: SQL Server, MySQL, Oracle, NoSQL, PostgreSQL, Oracle Exadata

• BI & Visualization: Power BI (Dataflows, Gateway, Report Server), Tableau (Prep, Public, Server), SSRS, TIBCO Spotfire

• ETL/Data Engineering: SSIS, Informatica, Azure Data Lakes, Snowflake

• Data Science: Pandas, NumPy, Statistical Modeling, ML (Predictive Modeling, Regression), Data Analysis

• Cloud Platforms: Azure, AWS, GCP

• Tools: Power Apps, Power Automate, Excel (Power Query, Pivot), SharePoint, Visual Studio, Microsoft Office

• Methodologies: Agile, Scrum, Waterfall

• OS: Windows, UNIX

• Core Competencies: Analytical Thinking, Innovative Thinking

Contact this candidate