Data Analyst Labor Relations

Programming Languages: SQL, Python, R, SAS, UNIX shell scripting.

Tools: ETL, MySQL, MS SQL, Hive, Apache Hadoop, Rules Engine, Apache Pig, Apache Spark, GIT, JIRA, TensorFlow, Visio, Big query, Databricks.

Testing: UAT, SIT, Production testing, VBA.

Data modeling: OLAP,

ETL Tools: Informatica, Alteryx, Talend

Financial Data & vendors: Bloomberg, IDC Markit, Reuters.

Data Management Data Mapping Validation & Reconciliation

Healthcare Data Sources: CMS, US Commercial Claims, EHR, MCG, InterQual

Statistics & Machine Learning: Linear Models, Regression models, Time Series, Logistic Regression, PCA, SVM, Decision Tree, Random Forest, Boosting and Bagging, XGB, K-NN

Cloud: AWS (EC2, S3, EBS, RDS, EMR, IAM, etc.), GCP (Kubernetes), Azure data explorer, Azure, Snowflake, Docker, Microsoft Fabric, AWS. Agile, Kanban,

Predictive Modelling / ML – customer segmentation, forecasting, targeting

Packages: API integrations, NumPy, Pandas, SciPy, Matplotlib, Sckit-Learn, Stats models, PySQL, PySpark, Tensorflow, Sqlite3

Reporting Tools: Tableau, Jupyter, BigQuery, Redshift, Microsoft Fabric, Alteryx, (Power Query M, DAX, Power Automate)

Google Data Studio, Power BI (2.x), Microsoft analysis services, Oracle, Teradata, Azure Database Explorer (Kusto), Sisense, Databricks, S3, Spark EMR, SageMaker, Azure AI

Software Suites: Microsoft Office

WORK EXPERIENCE

Client: Optum Inc, Tampa, Florida, Usa Mar 2023 – Present

Role: Data Analyst

Description: Optum is a health services and innovation company using the world's largest healthcare database to improve healthcare delivery, quality, and efficiency. Optum handles a wide variety of projects related to healthcare, leveraging its data and technological capabilities.

Responsibilities:

Developed and optimized processes for data cleaning, management, and reporting to enhance business decision-making.

Led data analysis for complex financial systems, integrating vendor data feeds and enhancing data models.

Developed backend Power BI dashboards using Power Query M, DAX, and Power Automate to deliver performance insights for key business functions.

Delivered advanced analytics and data insights in a B2B healthcare SaaS environment using Snowflake, Salesforce, and Tableau.

Built and optimized ETL pipelines using GCP Dataflow, processing healthcare and business data from multiple sources into Snowflake.

Integrated Salesforce data structures to develop dashboards for campaign tracking, sales funnel performance, and market analysis.

Designed and deployed interactive dashboards in Tableau to enable dynamic decision-making for commercial and operational teams.

Designed data models optimized for both OLAP (Power BI dashboards, regulatory reporting) and OLTP (provider onboarding workflows), ensuring efficient storage and querying.

Used SQL to extract and transform data from complex data models, including Snowflake and GCP BigQuery.

Worked with OLAP tools such as Microsoft Analysis Services and Business Objects to create multidimensional reports and dashboards for stakeholders across healthcare operations.

Led quality control checks for statistical outputs in line with internal SOPs and external publication standards.

Developed and documented machine learning models in compliance with internal model governance frameworks, supporting audit trails and validation documentation under healthcare regulatory standards.

Familiarity with Epic reporting systems, including Caboodle/Clarity; currently self-training to enhance EHR data extraction and integration skills.

Developed and maintained Power BI dashboards specifically for Medicare Advantage (Part C) population analytics, focusing on Risk Adjustment Factor (RAF) scores, HCC coding, and member-level trends.

Conducted deep data exploration using SQL across claims, eligibility, and encounter data to identify risk gaps and drive Stars quality initiatives.

Collaborated with business and clinical stakeholders to define KPIs, validate logic, and ensure alignment with CMS Risk Adjustment models.

Conducted complex data wrangling and transformation to support predictive modeling and exploratory analysis in partnership with analytics teams.

Contributed to building reusable ML components and internal libraries to streamline experimentation and deployment processes across the analytics team.

Collaborated with clinical teams using Epic systems for extracting and analyzing provider and patient engagement data.

Utilized Microsoft Fabric and Alteryx to support data pipeline creation, advanced analytics, and workflow automation.

Designed and implemented advanced machine learning models (including classification, clustering, and regression algorithms) to extract meaningful insights from large-scale structured and unstructured healthcare datasets, supporting strategic clinical initiatives.

Developed predictive analytics solutions using Python (Pandas, scikit-learn, TensorFlow) to identify patient risk patterns and improve care management outcomes.

Collaborated cross-functionally with clinicians, data scientists, and business stakeholders to translate complex data into actionable insights at the point of care.

Built and deployed automated data pipelines leveraging SQL and cloud platforms (AWS/GCP), improving ETL efficiency and enabling real-time analytics.

Led exploratory data analysis and visualization using advanced statistical methods and tools (e.g., seaborn, matplotlib, Tableau) to support data-driven decision-making across departments.

Implemented end-to-end ETL/ELT processes for claims and eligibility data, integrating EMR records with downstream reporting systems under HIPAA compliance.

Designed and maintained scalable data ingestion and transformation pipelines using Azure Data Factory, streamlining ELT processes across multiple healthcare data sources.

Partnered with data engineers to build and optimize Snowflake presentation layers, enhancing reporting scalability and dashboard performance.

Wrote and maintained complex SQL queries across Snowflake and SQL Server to transform and aggregate large volumes of healthcare and payer data.

Designed AB test evaluation dashboards and provided actionable insights from campaign lift and engagement analyses.

Automated recurring reporting processes using Power BI and SQL to streamline client deliverables and improve turnaround time.

Conducted A/B and multivariate testing to evaluate campaign strategies and optimize targeting, creative, and budget allocation across marketing channels.

Developed measurement frameworks and dashboards to track KPIs and campaign success metrics, leading to improved performance and increased client retention.

Developed data pipelines using Azure Data Factory to ingest and transform healthcare datasets stored in Snowflake, optimizing query performance for large-scale reporting.

Generated AWP and WAC-based pricing reports to inform formulary status decisions post-P&T review.

Built and automated compliance monitoring tools using SQL and Power BI to track adherence to plan-specific PDL mandates.

Engaged with client-facing teams to translate analytic findings into strategic cost-saving opportunities across benefit design and claims routing logic.

Designed and delivered insightful reports and visualizations to support business intelligence efforts.

Performed detailed audits and reconciliations of eligibility and enrollment data, identifying data integrity issues and driving resolution with internal and external partners.

Applied machine learning models to predict member behavior and optimize campaign lift, using scikit-learn and TensorFlow for classification and response modeling.

Built real-time monitoring systems to track product performance and customer satisfaction.

Led efforts to integrate and manage diverse data sources, improving data flow and accessibility.

Environment: Tableau, Google dialog Flow, Power Query M, DAX, Microsoft Fabric, Alteryx Power Automate, EPIC, Epic Caboodle, OLAP, Google Looker, SIT, UAT, Kusto, Python, Pandas, Numpy, Snowflake, Jupyter, Power BI, SQL, ETL/ELT, Visio, Azure, HCC coding, PySpark, Databricks, S3, Spark EMR, SageMaker, Azure AI, Rules Engine, HRIS systems, Azure data explorer, B2B & SaaS Data Analytics, Bloomberg, Reuters, IDC, Markit Azure DevOps Agile, Google Data Studio, SSIS, Help desk Chatbots, SparkSQL, Hive, Hadoop HSDF.

Client: MUFG Bank, Tampa, Florida, Usa May 2021 - Feb 2023

Role: Senior Data Analyst

Description: MUFG Bank (Mitsubishi UFJ Financial Group) is a major global financial institution offering a range of banking services. Optimized data processes, resolved performance issues, managed large datasets, created insightful visualizations, and applied Agile methodologies to ensure efficient and scalable solutions.

Responsibilities:

Participated in daily scrum meeting with the team to discuss the challenges and development of the project

Involved in requirement gathering from business users and IT teams to understand and express business processes and business logic.

Worked in a B2B financial setting, integrating Salesforce data with Tableau and Power BI to support executive decision-making and operational analysis.

Designed ETL logic for processing investment and procurement data, ensuring data quality and delivery to internal stakeholders.

Mentored junior analysts in Python, SQL, and model development best practices, including code reviews, model validation techniques, and workflow optimization.

Wrote advanced SQL queries for data transformation and analysis across Oracle and Azure SQL environments.

Designed KPIs and dashboards to track financial returns, investment volatility, and customer segment performance, enabling data-driven strategy shifts in B2B banking operations

Collaborated with cross-functional teams to automate reports and develop KPIs for business performance tracking.

Supported organizational KPIs and strategic decision-making through critical data storytelling.

Led cross-functional teams to streamline business processes and enhance data accuracy.

Provided leadership in Agile development, working closely with IT project managers and developers.

Created PowerPivot models and PowerPivot reports, publish reports onto SharePoint, and deploy models into SQL Server SSAS instance.

Assisted in creating SQL database maintenance logs and presenting any issues to the database architects.

Worked on Power BI reports using multiple types of visualizations including line charts, doughnut charts, tables, matrix, KPI, scatter plots, box plots, etc.

Delivered executive-facing Power BI dashboards to monitor operational and compliance performance across financial lines of business.

Conducted ad-hoc analytics using Excel (pivot tables, macros, VLOOKUP) to support regulatory reviews and finance audits.

Acted as a trusted analytics partner for marketing and healthcare clients, translating complex data into clear insights to guide business decisions and optimize campaign ROI.

Delivered data-driven storytelling and visual presentations to executive stakeholders using Tableau and PowerPoint, helping shape strategy based on performance analytics.

Worked closely with cross-functional teams to document data mappings, model specifications, and study protocols.

Automated data reconciliation and validated business logic for financial and compliance-related reports.

Conducted financial data modeling and risk segmentation using SQL and Power BI, supporting compliance monitoring and operational oversight across investment and procurement channels.

Utilized Power BI to create various analytical dashboards that help business users to get quick insight into the data

Installed Data Gateway and configured schedule plans for Data Refresh of Power BI reports

Created SSIS packages for ETL processes by using control flow and data flow components

Built Power BI dashboards integrated with Salesforce to monitor campaign conversion, segment engagement, and channel performance across financial products.

Responsible for accurately reporting on the financial aspect of the company's operations by rendering reports on a daily/ weekly/monthly basis

Evaluated returns and risks for various types of investments, including stocks, fixed-income assets, hedge funds, real estate, and commodities, and evaluated risk tolerance for customers

Created ad-hoc reports such as YTD, YOY, MTD, MOM analysis for the income statement, cash flow by request from business units

Created and maintained customer-centric metrics and executive dashboards to evaluate marketing ROI, audience acquisition, and retention trends.

Implemented report integration among Power BI, Tableau, SSRS and Python reports.

Environment: Power BI Desktop, Power BI Service Bloomberg, VBA, ROI, Reuters, IDC, Markit, SQL Server 2016/2017, SSRS, SSIS, SSAS, DAX, Tableau, SIT, UAT, Python, HRIS systems, SharePoint, Snowflake, Visual Studio, Scrum/Agile, BI Development Studio (BIDS), MDX, XML, SQL Profiler, TFS, MS Office, Windows 10/7, Data Analyzer

Client: MSCI Inc, Mumbai, India Dec 2019 - Jan 2021

Role: Data Analyst

Description: MSCI Inc. is a leading provider of global investment decision support tools, offering a range of services including indices, portfolio analytics, risk management. Designed and implemented data solutions, performed statistical analysis, built interactive dashboards, and utilized visualization tools to drive insights across multiple platforms.

Responsibilities:

Led the development of prescriptive data model to optimize operations and increase efficiency

Analyzed requirements, developed and debugged applications using BI tools

Worked with end users/customers to understand business requirements, recommended technical solutions and documented functional requirements.

Managed large-scale financial data analysis projects, ensuring compliance with regulatory mandates.

Designed and optimized SQL queries for data analysis, mapping, and troubleshooting.

Developed data integration solutions for vendor product implementations.

Led cross-functional teams to streamline business processes and enhance data accuracy.

Provided leadership in Agile development, working closely with IT project managers and developers.

Conducted comprehensive system and user acceptance testing (SIT & UAT).

Extensively worked on advanced visualization techniques in Tableau to assist business users in representing data visually to solve complex problems.

Worked with the leadership management team to visualize the key customer metrics, driving better consumer POD and supply chain solutions.

Utilized various Tableau functions like LOD, WINDOWS SUM, WINDOWS AVG, conditional functions (IF, Nested IF, CASE, etc.), RANK, Table calculations like Percentage difference, Percent of Total, Moving Average, YTD, YOY, etc. for various measures/calculated fields.

Worked on view orientation, Sizing, layout, Colour, Fonts, Tooltips, for building Interactive dashboards/reports.

Extensively worked on Tableau dashboards optimization for better performance and monitoring. Specifically dealing with a huge volume of data sets in Tableau.

Analyzed large structured datasets and built statistical models to evaluate patient-level and treatment-level outcomes.

Conducted exploratory data analysis and generated study-ready datasets for use in SAP execution.

Created codebooks and data dictionaries for internal and external RWD collaboration.

Provided ad-hoc statistical analysis for healthcare and patient-level outcomes related to market risk modeling.

Extensively worked in preparing strategic planning and implementation of successfully delivered projects within the POD and supply chain teams.

Supported pharmacy data analysis pipelines, enabling eligibility and provider rule validation across EHR and claims systems.

Created data validation scripts to align prescription transactions with PDL rules and submission cost controls.

Scheduled data refresh on Tableau Server for weekly and monthly increments, upon business requirement, and ensured views and dashboards display changes in the data accurately.

Published dashboards to the Tableau server and communicated with the end stakeholder for PMO Usage

Integrated projects in the server and organized workshops on the projects for better usage of the capabilities built in the dashboards.

Publishes reports/dashboards on Tableau server & embedded views in other web applications.

Environment: Tableau 2018.3 (Desktop/Server), Databricks, S3, Spark EMR, SageMaker, Azure AI, NetSuite, Coupa, Concur, AvidXchange, AWS Redshift, Alteryx, Talend, Visio, Oracle, SIT, UAT, SQL Workbench, Control - M, AWS, Jira, Agile, SSMS, Microsoft Office Suite (Word, Excel, Macros, Pivot tables, PowerPoint, SharePoint)

Client: OMH Health Edge Holdings, Navi Mumbai, India Sep 2018 - Nov 2019

Role: Programmer Analyst

Description: OMH Health Edge Holdings is a healthcare technology company that provides software solutions for health insurance providers, helping them streamline operations, improve claims processing, and enhance customer service through innovative technologies and data-driven insights.

Responsibilities:

Worked with different team's client, analytics, data sources, QA and visualization.

Worked in agile process having expertise in life cycle of a project from start to end.

Created data warehouse and data marts from scratch based on data structures and reporting needs.

Worked on writing ad hoc SQL scripts which are required for reporting purposes. Worked on creating basic dashboards in tableau connected to Azure SQL database for client reporting.

Built and managed automated pipelines for eligibility data extraction, loading, and validation across multiple health plan products using SQL and SSIS.

Created SQL-based reconciliation scripts to identify mismatches in eligibility feeds and member data across data warehouses and EHR systems.

Processed and analyzed diverse data types including JSON, flat files, and XML for healthcare claims, pharmacy data, and survey-based inputs, using Python and SQL.

Worked on user management for power bi. Sharing the dashboard access for power bi online.

Worked on Power BI dash boards and ad hoc DAX queries for power bi.

Extensive back-end support for many various reports on Tableau and Power BI.

Created store procedures, functions, triggers, indexes, views based on data processing and data cleansing.

Created various SSIS packages for data movements and transformations. Worked on Python code to load data from Google buckets to big query tables, used data flow for ELT (Extract Load Transform) in Big Query.

Worked on creating POC for data movement in NiFi (Hortonworks), C# programming used in script task for SSIS and in Azure functions to create retrievers for data pull from API.

Developed and tested data transformation pipelines for structured EHR datasets using SQL and Python.

Supported the analysis of survey and qualitative datasets for population health and case management programs.

Worked closely with QA and data management teams to identify root causes of migration issues in patient-level datasets.

Worked on Web jobs, AZURE data factory, Logic Apps for application and project development in Azure.

Worked on Web Applications in Azure and Azure functions to pull data from API to blob Storage and SQL.

Worked on deploying web sites in Azure and used MVC framework on backend. Experienced in Developing PL/SQL- Procedures, Functions, SQL Scripts and Database Triggers to populate the data applying business logic.

Extensive knowledge in developing PL/SQL codes using Oracle 11g.

Environment: Azure Data Factory, IBM DataStage / Infosphere, NetSuite, VBA,Coupa, Concur, AvidXchange, Azure Copy,Visio, Polybase, BigQuery, Redshift Google Cloud Platform, Power BI, ETL, Python, T-SQL queries

EDUCATION

Masters in Health Informatics - Northern Kentucky University 2023

Bachelors in Computer Science – JNTU 2012-2016

Anusha Bandarupalli

Senior Data Analyst

OBJECTIVE

Phone No: 813-***-**** Email ID: ****************@*****.***

Adept at identifying trends, creating detailed reports, and providing actionable insights to support data-driven decision-making. Seeking to leverage my expertise to contribute to a dynamic team and help optimize processes and strategies to achieve organizational goals.

SUMMARY

5+ years of progressive experience in Business Analysis, Reporting and Dash-boarding for enterprise-wide applications using Power BI and Tableau.

Proficient in BigQuery, Cloud Storage, Cloud Functions, and Dataflow for cloud-based data engineering and analytics.

Managed data storing and processing using big data tools such as Hadoop, HDFS, Hive and Spark.

Experience with building ETL pipelines using Apache Beam, Dataflow, and Cloud Composer to move and process data within GCP.Excellent Software Development Life Cycle (SDLC) with good working knowledge of testing methodologies, disciplines, tasks, resources and scheduling. Excellent in Data Analysis, Data Profiling, Data Validation, Data Cleansing, Data Verification, and Data Mismatch Identification.

Strong experience in Data Analysis, Data Migration, Data Cleansing, Transformation, Integration, Data Import, and Data Export through the use of multiple ETL tools such as Ab Initio and Informatica PowerCenter Experience in testing and writing SQL and PL/SQL statements - Stored Procedures, Functions, Triggers and packages. Strong working knowledge of Microsoft Office Excel

Hands-on experience and solid skills in R and SAS for hypotheses tests including t-test, F-test, Welch's t-test, Chi-Square test, ANOVA and MANOVA and statistical modelling.

Developed data wrangling through data gathering and querying process over SQL and Google BigQuery Database and implemented data cleaning process with R & Python.

Contributed to enterprise-wide data science initiatives by supporting end-to-end lifecycle of AI/ML model development, including data preprocessing, model tuning, and performance evaluation.

Good understanding of Tableau Desktop architecture for designing and developing dashboards.

Experience in Data Transformation and Data Mapping from source to target database schemas and also data cleansing. Strong understanding of Data Modeling (Relational, dimensional, Data analysis, implementations of Data warehousing using Windows and UNIX.

Proven expertise in Power BI, Databricks, and SQL to build scalable dashboards, automate reporting, and drive business insights.

Partnered with managed care and quality teams to develop data pipelines that evaluated MCO plan performance on formulary compliance and drug pricing efficiency.

Delivered insights into drug status transitions and cost variation using real-time claims feeds and longitudinal analysis.

Collaborative, self-motivated, and always eager to improve tools, processes, and outcomes in cross-functional environments.

Guided end users of Clients in using Power BI and developing and publishing dashboards, sharing them with other colleagues and how to embed them on their websites.

Experienced in migrating Data from Excel, Flat file, Oracle to MS SQL Server using SQL Server Integration Services (SSIS) and expert in Creating, Configuring and Fine-tuning ETL workflows in SSIS.

Hands-on experience in Cloud services including AWS (EC2, S3, RDS), GCP(Kubernetes) and Docker Hub. Experience modeling with OLTP/OLAP systems and Kimball and Immon Data warehousing environments. Performed Business Requirement Gathering and Analysis, Feasibility study, ROI Analysis, Process Flow and Process Modeling, Functional and Techno-Functional Gap

Participated in early-stage AI and ML use case exploration, preparing clean datasets and structured KPIs for potential model inputs.

SKILLS

Contact this candidate