Summary
Overview
Work History
Education
Skills
Websites
Certification
Projects
Timeline
Generic

Ramya G

Summary

Over 8 years of experience in analytics, reporting, data migration, and project management, providing data-driven solutions in the healthcare and financial industries, while managing commercial operations and analytical projects through problem-solving, storytelling, machine learning, and advanced analytics techniques. A data enthusiast and researcher with over six years of experience in Master Data Management, and a broad range of analytics, including sales, patient, payer, and marketing analytics. Proven track record of deploying end-to-end go-to-market strategies, from initial planning to execution, within the healthcare and pharmaceutical industries. Strong expertise in data analysis and profiling, with hands-on experience across various databases, including Big Data platforms like Hadoop and Spark frameworks. Proven track record of managing health payer IT system implementation projects, collaborating with remote, cross-functional teams to ensure project milestones are met on time. Skilled in designing intuitive, visually compelling dashboards that simplify complex data for stakeholders across all organizational levels. Proficient in creating interactive dashboards and data visualizations using tools such as AWS Athena SQL, SAS, QlikView, and Tableau. Hands-on experience working with Medicaid, Mediclaims, provider data, payers, claims, CCDA, FHIR, HL7, DRG data, and Symphony Health claims data. Proficient in Python for data analysis, automation, and scripting, with experience in libraries such as Pandas, NumPy, and Matplotlib for data manipulation and visualization. Proficient in developing complex SQL queries for data extraction, transformation, and analysis across large-scale databases, and expertise in writing advanced SQL queries involving joins, subqueries, CTEs, window functions, and aggregate functions to derive meaningful insights from data. Determined Data Quality Analyst, proudly offering expertise in data quality management and data collection. Creative and analytical, with excellent skills in recommending test procedure improvements.

Overview

9
9
years of professional experience
1
1
Certification

Work History

Senior Business Data Quality Analyst

Evernorth
Connecticut
01.2023 - Current
  • Company Overview: Cigna
  • Engaged collaboratively with Business Area Subject Matter Experts (SMEs) to conduct thorough analyses of potential risks related to products and business processes
  • Recognized opportunities for business process enhancements through discussions with business users and developers, subsequently initiating improvement efforts
  • Performed a thorough analysis of requirements and created and updated the Business Requirements Document (BRD) for the Collibra Data Quality (DQ) governance project
  • Executed ETL processes using Python and SQL on AWS to convert data into FHIR and HL7 formats, ensuring compliance with HIPAA regulations throughout the data transformation and analysis lifecycle
  • Involved in the complete Jira life cycle of the project performing various tasks like data understanding by performing Exploratory Data Analysis, Data Cleansing, Data Modeling for creating visual representation, statistics, and marketing from several sources with the business, Evaluating and Deploying
  • Established facets data quality rules in Informatica MDM, improving master data accuracy and reliability for business operations
  • Led the implementation and integration of EHR systems like EPic for healthcare providers, ensuring seamless transition from paper-based to digital records
  • Managed the mapping and integration of EDI 834 files between employers, insurance carriers, and third-party administrators, ensuring accurate benefits enrollment and eligibility data
  • Played a key role in the successful deployment of the GuidingCare application by conducting extensive API testing using Postman
  • Experience in creating Data Governance Policies, Business Glossary, Data Dictionary, Reference Data, Metadata, Data Lineage, and Data Quality Rules and implementing Collibra to automate data management processes
  • Automated data processing tasks using Python, resulting in a 50% reduction in manual effort and improved data analysis efficiency
  • Devised effective metrics, KPIs, Visualizations, and built Dashboards for reporting the Daily, Weekly, and Monthly summary, trending, and benchmark reports to the Management in Tableau Desktop
  • Cigna
  • Environment: Jira, Toad, SQL, Informatica, Python, Excel, Tableau, Collibra, AWS, Snowflake, R

Sr Data Analyst

Optum
California
11.2021 - 01.2023
  • The main motto of this project is to transform how healthcare is delivered to the most medically vulnerable members in our community providing home-based medical care to chronically ill patients
  • Serving as the subject matter expert on assigned function to ensure operational performance excellence
  • Creating and documenting the business requirements
  • Ensured the accuracy and completeness of patient data in the EHR system, resulting in a 98% data accuracy rate
  • Building and configuring interfaces to support the flow of data between Epic and external systems
  • Developing, sharing, and incorporating organizational best practices into business processes for Medicaid, Medical and Provider claims
  • Supported testing and validation of EDI 834 files, ensuring compliance with HIPAA and ACA standards
  • Advanced the usage of PowerBI for visual data representation, improving interactive data exchange by 20%
  • Developed and executed ETL processes using SnapLogic, establishing rules and regex for integrating insurance data from various sources into GCP BigQuery
  • Provided training and mentorship to healthcare IT staff on best practices for clinical data management, EHR integration, and HL7/C-CDA standards
  • Utilized advanced SQL and data profiling techniques to validate source-to-target mappings
  • Environment: Jira, Snaplogic, SQL, SAS, Python, Excel, PowerBI, GCP, Atrylex

Data Business Analyst

State Government of North Carolina
North Carolina
08.2019 - 08.2021
  • Performed data analysis and data profiling using complex SQL on various sources systems and answered complex business questions by providing data to business users
  • Worked for Medicaid and Covid 19 project in supporting public facing dashboards
  • Utilized ETL, Oracle SQL, SPSS, SAS data warehousing programs and data governance techniques for complex data sets
  • Collecting, analyzing, interpreting, and summarizing data in preparation for the generation of statistical and analytical reports with BI tools
  • Developed reports and presentation of dashboards in Tableau and/or Cognos for COVID-19 project and Healthcare Medicare projects
  • Hands on experience with Databricks clusters and doing analysis in python and pyspark
  • Ensuring that the data management practices comply with HIPAA and other healthcare regulations
  • Environment: Oracle, SQL, EG SAS, Tableau, Cognos, Crystal Reports, Microsoft Excel

Data Analyst

Ally Financial
Michigan
07.2018 - 05.2019
  • Created artifacts like BRD, FDD or Use Case Model, Data Model (Content Model or DMM)
  • Worked with extract-transform-load (ETL) processing tool for data mining, data warehousing, and data cleaning using SQL
  • Performed Cross Validation on single holdout set to evaluate the model’s performance on training data sets
  • Worked with Analytics team to evaluate & developed organizational change business models with the requirements
  • Performed Data extraction, wrangling, Preprocessing, data transformation, data validation, data mining, and data cleansing using Microsoft SQL
  • Implemented ETL process, Data Mapping, Data Governance, Data Lineage, Data Modeling, Snowflake Schemas, and designed E - R Models
  • Environment: Oracle, SQL, Tableau, Cognos, Crystal Reports, Microsoft Excel

Data Analyst

Aurobindo Pharma Limited
India
08.2016 - 05.2018
  • Ensure ongoing activities/projects to check all data are accurate and available to meet established deadlines
  • Worked with extract-transform-load (ETL) processing tool for data mining, data warehousing, and data cleaning using SQL
  • Design, development, and analysis-using SQL, R, Python programming languages and analytical tools
  • Application of mathematics, statistics, modeling, business analysis, and technology to transform high volumes of complex data into advanced analytic solutions
  • Develop, maintain, and enhance reporting which enables effective business decision making
  • Environment: MS SQL, Tableau, Python, R studio, Microsoft Excel, Machine Learning

Education

Masters - Computer Science

Texas A and M

Bachelors - Computer Science

Vignan Institute of Technology
India

Skills

  • Tableau
  • Power BI
  • QlikView
  • SAS
  • Advanced Excel
  • Google Analytics
  • Alteryx
  • MS Visio
  • MS Word
  • MS Excel
  • MS PowerPoint
  • JIRA
  • AWS
  • GCP
  • Azure
  • Python
  • NumPy
  • Pandas
  • Matplotlib
  • NLTK
  • Scikit-Learn
  • SQL
  • R Studio
  • Collibra DQ
  • Snap Logic
  • Informatica
  • Phoenix
  • CMC
  • GoAnywhere MFT
  • FileZilla
  • Oracle
  • MS-SQL Server
  • Hadoop
  • Spark
  • Snowflake
  • Data Lake
  • Redshift
  • NoSQL
  • MongoDB
  • PostgreSQL
  • MySQL
  • HL7
  • FHIR
  • Electronic Health Records
  • ICD-10
  • CCDA
  • CPT
  • SNOMED CT
  • LOINC
  • HIPAA compliance
  • Lake Exploratory Data Analysis
  • Support Vector Machines
  • Decision Trees
  • Random Forests
  • Linear Regression
  • Logistic Regression
  • Clustering

Certification

  • Intermediate Python for Data Science Udemy Certificate
  • Pandas in Python Data Camp Certificate
  • R Programming Coursera Course Certificate from John Hopkins University

Projects

Impact of Medication Use on Pregnancy Outcomes, Python, SQL, R, Tableau, Excel, Responsible for design and development of advanced R/Python programs to prepare transform and harmonize data sets in preparation for modeling. Analysis of Health Factors Effects on Health Outcomes in the United States, SQL, Tableau, R Programming, Performed Data cleaning, feature scaling, feature engineering using pandas, and NumPy packages in python, and build models in R. Comparative analysis of various risk factors for Cervical Cancer, Python, Excel, MySQL, Lead predictive analytics initiative that improves the quality of life of Cancer patients.

Timeline

Senior Business Data Quality Analyst

Evernorth
01.2023 - Current

Sr Data Analyst

Optum
11.2021 - 01.2023

Data Business Analyst

State Government of North Carolina
08.2019 - 08.2021

Data Analyst

Ally Financial
07.2018 - 05.2019

Data Analyst

Aurobindo Pharma Limited
08.2016 - 05.2018

Masters - Computer Science

Texas A and M

Bachelors - Computer Science

Vignan Institute of Technology
Ramya G