Atul Kumar

Key Deliverables:
1.Working with Business Analyst to Identify, Develop Business requirements, Transforming it into technical requirements (SDD) and responsible for deliverables.

2.Worked on Routine free of DataStage Jobs using Unix Script.

Developing complex jobs using various stages like Sequential File, XML Stage, Data set, Lookup, Join, Merge, Aggregator, Remove Duplicate, Modify, Filter, Funnel, Copy, Surrogate Key Generator, Sort, Transformer, Change Capture, SCD ,and Pivot stage

PROJECTS

>>HCBB

Helping to load 4 HCBB file to EDR to support HCCB Program. As part of this project system will receive four sequential file which will have all member information and what kind of plan that member have. Loaded all four-file using Schema file definition to minimize Datastgae Code. This project is entirely executing in Agile

methodology

>>Senior Market Wellness Incentive-NOVU
Helping to load 2 files on monthly basis that would provide better member engagement and would ultimately lead to better HEDIS quality scores and plan performance. As part of this project system will receive 2 text files and have all member eligibility information. We have used Stored Procedure to load data from source to target. This project is entirely executing in Agile methodology.

>>LIFESPAN-ESI

Helping to load 2 files to EDR and send data to ACG solution to analyses claim data and flag potential case. As part of this project system will receive 2 Text files (Fixed Width) will have claim information. This project is entirely executing in Agile methodology.

>>Halo Y75 Project

We are helping to create the best claims on the market by implementing a modern and effective system for the customer Contact. As part of this project system is receiving the XML publish file which is having entire claim details from Y75 source system and we are loading into Y70 Datawarehouse system. Some of the jobs are running in monthly and loading into G70 mart for statics analysis purpose. This project is entirely executing in Agile methodology.

>>CALLGUIDE

We are helping to load data related to Agent, Survey conducted, Quiz into Datawarehouse and Mart. As part of this project system is receiving sequential file which is having entire Agents, Survey, and quiz , details. Jobs are running on daily basis to load data in Mart and use for reporting which help customer to take financial decision. This project is entirely executing in Agile methodology.