Akarsh Kapoor

The client has initiated a cloud modernization initiative that includes the migration of multiple existing Hadoop applications to GCP. Four applications have been selected for this project and must be migrated within a defined timeframe.

Roles & Responsibilities

· Work with Hadoop application owner and understand the on prem architecture and landscape.

· Work with Solution engineer to create the tenancy to support the application migration

· Design the pipe lines on GCS, DataProc, Composer and python

· Design the pipe lines to migrate one time data from Hadoop to Big query

· Led daily standup, Scrum of Scrum, sprint planning, retrospective and ad-hoc meetings using rally.

· Stakeholder management, escalation management and presentation to the senior leadership.

Client is migrating multiple Care Manager platforms to a third-party application. Client had multiple Care Manager systems and supporting systems. This project involved migrating data incrementally based on program, Plan, State etc. Biggest challenge was to keep both systems updated and live. Team was responsible for reading data from source systems, Transform data into Target system acceptable format. Currently team is handling more than 80 files ((input + output) every day.

Roles & Responsibilities

· Analyze the business requirements, functional specification and technical Specification.

· Participate in the discussion with architects and business and give input for the solution.

· Closely work with business owners, architects to understand the business requirement and design the solution as per the need.

· Analysis of Existing Source and Target System

· Lead the team and assign the task and take care of all the deliverable.

· Involved in guiding peers and reviewing their code.

· Analyzed the job and tune them as per the need.

· Developed jobs Using Parallel Extender v11.7 to achieve better performance and throughput by efficient usage and developed strategies for Extraction, Transformation and Loading (ETL) the data into the target database.

Provide support during implementation of project.

The purpose of RASP is to receive the financial data from source system (DB2, Sql Server and Hadoop Data Lake) and process it for the downstream RA system for G/L entry. As a part of this processing, we needs to perform below operations

Tagging

RASP-P must identify the transaction as per the given set of business rules and tag them as actual or accrual.

Reversal

RASP-P must identify the transaction as per the set of business rules and check if a reversal is required to make correct G/L entry.

Aggregation

RASP-P must aggregate incoming transactions from all sources at the 'trigger' level and send the aggregated data to RA system.

Spreading

RASP-P must identify when spreading will occur and for which transactions (Specific Account Level Accessorial and Unclassified Revenue) and supply the calculations that need to take place.

Along with each of the above process RASP need to perform balancing process to make sure there is no financial data loss is happing as the same will used to make G/L entry.

Roles & Responsibilities

· Analyze the business requirements, functional specification and technical Specification.

· Analysis of Existing Source and Target System

· Developed jobs Using Parallel Extender v11.5 to achieve better performance and throughput by efficient usage and developed strategies for Extraction, Transformation and Loading (ETL) the data into the target database.

· Analyzed the job and tune them as per the need.

· Involved in testing the developed codes, fixing defects if any and redoing the test and fix upon delivery to the client manager.

· Involved in guiding peers and reviewing their code.

· Provide support during implementation of project.

The purpose of 3Rs is to determine what it will take to meet the needs of Healthcare Reform PPACA's legislation that requires insurers to administer reinsurance, risk adjustment, and risk corridor programs, We need to allocate, calculate, store, and provide information to HHS and/or the states about these three programs for time periods ranging from 3 years to permanent with data storage requirements for each program of not less than 10 years.

Roles & Responsibilities

· Analyze the business requirements, functional specification and technical Specification.

· Analysis of Existing Source and Target System

· Developed jobs Using Parallel Extender v8.7to achieve better performance and throughput by efficient usage and developed strategies for Extraction, Transformation and Loading (ETL) the data into the target database.

· Analyzed the job and tune them as per the need.

· Involved in testing the developed codes, fixing defects if any and redoing the test and fix upon delivery to the client manager.

· Involved in guiding peers and reviewing their code.

Provide support during implementation of project

This project will provide a 360 degree end to end view from sales to billing with a new online tool which will enable stakeholders to see details for business customers across all strata. This new tool will provide a holistic view of the services customers have on their account(s) and provide a dashboard on work in progress including completed work for the account(s) across provisioning, service assurance (maintenance) and billing functions. Currently, there is no tool available to link customer accounts and products in a single view.

Roles & Responsibilities

· Analyze the business requirements, functional specification and technical Specification.

· Analysis of Existing Source and Target System

· Developed jobs Using Parallel Extender v8.7to achieve better performance and throughput by efficient usage and developed strategies for Extraction, Transformation and Loading (ETL) the data into the target database.

· Involved in guiding peers and reviewing their code.

· Involved in testing the developed codes, fixing defects if any and redoing the test and fix upon delivery to the client manager.

· Provide support during implementation of project

The purpose of the Adjustments project is to provide functionality to allow sites to pass adjustments on a monthly basis at an optimum level of granularity for inclusion in MI and reports, and to allow users to see the impact of their adjustments in data analysis tools.

Adjustments will undergo the validation process to make sure that the adjusted attributes are in-line with the data held in GLEAM. The document covers the validation process which is applicable when Adjustments are uploaded via Bulk Upload or Manual Input screens or reworked as a part of rework process.

Roles & Responsibilities

· Analyze the business requirements, functional specification and technical Specification.

· Analysis of Existing Source and Target System

· Developed jobs Using Parallel Extender v8.1 to achieve better performance and throughput by efficient usage and developed strategies for Extraction, Transformation and Loading (ETL) the data into the target database.

· Involved in testing the developed codes, fixing defects if any and redoing the test and fix upon delivery to the client manager.

· Worked on performance tuning of the jobs.

· Responsible for preparation of Design Documents, Test Case Specifications, performance review and Coding

· Involved in guiding peers and reviewing their code.

Provide support during implementation of project

The purpose of the Strategic Payment Program is to bring a strategic
level focus on payment capabilities and objectives by aligning all
associated activities under a single program and vision.

Roles & Responsibilities

· Scoping and Requirements Study

· Analyze the business requirements, functional specification and technical Specification.

· Analysis of Existing Source and Target System

· Involved in analysis and developing of Data Stage jobs and bug fixing.

· Provide support for handling tickets which includes Incident management, Problem management

Aetna provides various products like Medicare, Medicaid etc. Medicare products is for the people whose age is greater than 65 years. To provide such kind of insurance Aetna has to follow some rules stated by U.S government. One of that rules is MIPPA (Medicare Improvements for Patients and Providers Act).

Roles & Responsibilities

· Scoping and Requirements Study

· Analyze the business requirements, functional specification and technical Specification.

· Creation of various document like mapping, Design and understanding document

· Analysis of Existing Source and Target System

· Involved in analysis and developing of Data Stage jobs and bug fixing.

· Taken Care of all the quality related work and project management work.