PROFESSIONAL SUMMARY:

• Over 6 years of professional experience working as Data Engineer, Data Analyst and Quality Assurance Engineer
• Performed data analysis on healthcare for Medicare, Medicaid, and Commercial lines of business writing complex SQL queries
• Worked on healthcare data quality reporting to generate RAF scores and Charlson scores for Medicare population
• Developed business strategy and data analytics to implement data collection methods to yields highest quality results.
• Demonstrated ability in using ETL methods, developed stored procedures, functions, packages, database triggers, schema design in Oracle, SQL Server and Google Big Query
• Developed jobs using ETL tools Pentaho and SSIS for the data involving various sources of information and large data sets including member, pharmacy, claims
• Assisted clients from health care industry in data analysis, root cause analysis, resolve any data quality issue and generating reports for HEDIS measures
• Performed quality checks on the healthcare data to comply with NCQA reporting
• Experienced in designing, updating and maintaining Oracle Application Express (APEX) tool for the reporting purposes
• Good understanding of data warehousing, Google cloud and bigquery concepts
• Experienced working in Agile and have strong knowledge of all aspects of SDLC
• Proficient in writing well - structured and easily maintainable code using C++, ORACLE, HTML and Windows Batch Script
• Experienced in creating Test Plan, Test Cases and executing Test Cases
• Debugging, failure analysis, log analysis for test execution results
• Experienced in Back-end testing using SQL queries
• Understanding of basic UNIX commands to perform file manipulation and scripting.

TECHNICAL SKILLS:

Technologies & Languages: SAP-ABAP, VB Scripting, C++, Java, PL/SQL, HTML, UNIX shell scripting, Python basics

Databases:: Oracle 11g, 12c, SAP-HANA, SQL server, Google cloud platform

Tools: SSIS, Pentaho, Matillion, Talend (basics), Putty, eCATT, QTP, In-house ELT Tools, WEKA software

Methodologies: Agile, Waterfall model, Scrum

Concepts:: Big Data, Data Warehouse, Data Mining, Hadoop, Object oriented programming concepts

PROFESSIONAL EXPERIENCE:

Confidential, Minnetonka, Minnesota

Data Engineer

Responsibilities:

• Worked directly with research groups to understand their initiatives and programs in healthcare domain and helped them in providing the data from the different sources using ETL tools and performed end to end data analysis using sql queries to provide quality data for research
• Made the data available on bigquery performing ELT process using Matillion Tool to move the data from google cloud storage (GCS) bucket to Bigquery Tables
• Developed jobs using SSIS and Pentaho tools to transform and load the data to datamarts
• Built Designing and Architecting solutions in Google Cloud Platform involving huge claims data mart of Medicare, commercial population to effectively execute the queries in Big Query
• Wrote complex Big Queries on Google Cloud Platform involving joins, user-defined functions (UDF), jobs to help the reporting team in sending reports to higher management involving bonus, HSA incentive and comparing daily step activities across UHG population
• Exploring new ETL tools like Talend for performing ETL loads to google cloud platform
• Extracted data from salesforce database for research and process improvement on fitness program initiatives

Confidential

Data Analyst

Responsibilities:

• Designed and developed commercial and business applications using Quality Engine, Quality Reporter, Data Audit, Measures Developer, SSIS and ETL methods
• Performed complex data analysis for medical analytical software using HEDIS specifications
• Designed data warehouse structures and performing data warehouse analysis
• Coded Oracle PL/SQL stored procedures, packages, and database triggers
• Resolved client issues by analysing the healthcare data
• Wrote complex queries and code packages to load huge volumes of client data
• Performed SQL tuning to retrieve data from large datasets joining multiple tables and used query Optimization techniques
• Performed quality assurance on encrypted data marts and performed secure file transfer to client servers
• Developed automation batch framework to execute stored procedure without manual intervention and generate success report after ETL completion
• Conducted data audits to clean client’s data and performed TDD before the production
• Coded and executed translations, scripts, and procedures, and create data marts for loading data into SQL Server 2010/2012, Oracle from files
• Worked on custom translations and custom chases in addition to the standard process, and performing various data warehouse administrative functions as required
• Designed and developed ETL process to load DataMart and created views for HEDIS Reporting
• Worked closely with clients from gathering requirements and priorities deliverables
• Scheduled s for clients on new software releases and changes on the file layouts
• Developed SSIS package to perform ETL task for internal project

Confidential

Quality Assurance Engineer

Responsibilities:

• Designed test cases for given functional requirements
• Executed Test cases to perform Smoke Testing, Regression, Functional, Integration Testing, User Acceptance Testing (UAT) and backend testing of application
• Coordinated with the development team and onsite colleagues for fixing the bugs
• Created automated scripts using ABAP language and VB scripting for Regression Testing and Functional Testing
• Created Test Specification Documents for Test Automation scripts
• Tested configuration and end to end testing of the SAP TM and MDG product
• Perform Non-Functional Testing like Compatibility and Ad-hoc Testing
• Performed data validation using SQL queries
• Created traceability matrix based on mapping document and requirements
• Tested reporting components and capabilities for SAP BO product
• Preparation of Daily and Weekly Status Reports and reporting the same to project lead and team