Home

Sucharitha Amancha - Data Analyst

[email protected]

Location: Kalamazoo, Michigan, USA

Relocation: Open

Visa: H4 EAD

Resume file: Sucharitha_DA_1772565982225.pdf Please check the file(s) for viruses. Files are checked manually and then made available for download.

SUCHARITHA AMANCHA Michigan, USA | +1 269-598-1688 | [email protected] | LinkedIn | Visa: H4 EAD SUMMARY Data Analyst with 4+ years of experience in healthcare utilization analytics, enterprise KPI reporting, and cost modeling across manufacturing, technology, and payer healthcare environments. Built analytics solutions using SQL, Python (Pandas, PySpark), Power BI, Tableau, AWS Redshift, and Azure Data Factory to improve reporting efficiency, automate ETL validation, and support financial decision-making. Developed forecasting models and ML-based classification systems while maintaining compliance with HIPAA and SOX standards across three enterprise organizations. Collaborated with 12+ stakeholders across finance, operations, compliance, and data engineering to deliver analytics solutions in Agile environments. PROFESSIONAL EXPERIENCE Data Analyst | Molina Healthcare, USA | Jan 2025 Present Directed healthcare utilization analysis using SQL (CTEs, window functions) and Power BI, evaluating 1M+ member claims and reducing executive reporting cycle from 3 business days to 1 day through query optimization and automation. Orchestrated ETL validation using Python (Pandas, PySpark) and Azure Data Factory, removing 5 manual reconciliations and reducing data exceptions from 15 to 9 per cycle across 8 HIPAA-governed reports. Constructed regression and time series forecasting models in Scikit-learn to analyze pharmacy and inpatient cost drivers, enabling finance teams to initiate containment actions projected to avoid $170K in upcoming fiscal allocations. Designed and executed A/B testing frameworks to evaluate care management outreach effectiveness and reporting enhancements, enabling data-driven optimization of operational strategies. Refactored complex Redshift SQL queries and collaborated with data engineering on distribution key alignment, reducing Power BI dataset refresh latency from 11 seconds to 3 seconds for 90+ operational stakeholders. Data Analyst | Dell Technologies, India | Aug 2021 Sep 2022 Designed executive KPI dashboards in Power BI (DAX) integrating data from PostgreSQL and Azure SQL Database, supporting operational reporting across 3 business units and 30+ senior stakeholders. Developed advanced SQL queries using window functions and performance tuning, reducing monthly reporting cycle from 6 days to 3 days while analyzing datasets containing 5M+ transactional records. Built machine learning (ML) classification models using Random Forest and Logistic Regression to evaluate customer churn indicators, enabling account teams to prioritize outreach for 800 enterprise accounts. Enhanced ETL workflows using SSIS and Informatica, stabilizing data refresh processes for 12 recurring reports and reducing failed batch jobs from 5 to 3 per quarter through monitoring improvements. Identified cross-system billing discrepancies using reconciliation scripts in Python and Excel VBA, surfacing $190K in mismatched transactions during quarterly audits under SOX controls. Partnered within Agile Scrum teams using Git and Jupyter Notebook, translating stakeholder requirements into production-ready analytics solutions and delivering 9 user stories across 4 sprint cycles. Data Analyst | Adani, India | May 2019 Jun 2021 Analyzed plant production data using SQL Server and Excel Power Query, identifying throughput bottlenecks in 3 batch reactors and reducing average processing delays by 10 production hours per month through scheduling adjustments. Developed automated KPI dashboards in Tableau monitoring 16 manufacturing metrics, enabling plant leadership to track cycle time, yield variance, and downtime across 3 production lines and supporting weekly performance reviews. Conducted statistical analysis using R (Hypothesis Testing, ANOVA) to assess raw material quality variation, supporting procurement decisions that reduced rejected lots from 9 to 6 during the 8-month evaluation period. Engineered data cleaning and transformation workflows in Python (Pandas), standardizing 120K historical production records and improving reliability of time series demand forecasts used for monthly capacity planning. Coordinated cross-functional reviews with operations and compliance teams, formalizing 5 process control enhancements that were incorporated into plant standard operating procedures. TECHNICAL SKILLS Programming & Analytics: Python (Pandas, NumPy, PySpark, Scikit-learn), R, SQL, VBA, Shell Scripting Databases & Querying: PostgreSQL, MySQL, MS SQL Server, Azure SQL Database, BigQuery, MongoDB, AWS Redshift Business Intelligence & Reporting: Power BI (DAX), Tableau, Microsoft Excel (Power Query, PivotTables), Spotfire Cloud Platforms: AWS (S3, Redshift), Microsoft Azure (Azure Data Factory, Azure Databricks), Google Cloud Platform Data Engineering & Integration: SSIS, Informatica, Apache Airflow, ETL Pipelines, Data Modeling Statistical & ML Methods: Regression Analysis, Time Series Forecasting, ANOVA, A/B Testing, Random Forest, XGBoost, K-Means Data Governance & Compliance: HIPAA, GDPR, SOX Controls, Data Validation, Reconciliation Checks Development & Collaboration: Git, GitHub, Docker, Jupyter Notebook, VS Code, Agile, Scrum, SDLC Core Competencies: Healthcare Utilization Analysis, Cost Analytics, KPI Monitoring, Automation, Cloud Migration EDUCATION Master of Technology in Chemical Engineering | National Institute of Technology Calicut | Jul 2020 Jul 2022 Bachelor of Technology in Chemical Engineering | Jawaharlal Nehru Technological University | Jul 2015 Jul 2019 Keywords: machine learning business intelligence sthree rlang microsoft mississippi