VAIBHAV KUMAR

Lincolnshire, ILLINOIS +1-847-***-**** : actafv@r.postjobfree.com

Professional Synopsis

An Engineer with 6+ years of work experience in Ab initio, PL/SQL, UNIX and Shell Scripting.

Vastly experienced in Data Modelling, Data Extraction, Data Migration, Data Warehousing and Report Generation.

Leading the onshore and offshore team for the current project. Responsible for tracking project tasks for delivery milestones.

Used various Ab initio components for development of complex graphs and designs.

Extensive use of Oracle 11g/10g/9i during project level.

Experience in designing, developing and testing applications.

Have shown magnificent performance in analysing complex application for restructuring and writing performance improvement processes to reduce batch process time.

Involved in all phases of SDLC right from requirement gathering to successful deployment in production.

Responsible for managing client’ expectations and obtaining all client approvals and sign-offs such as for code, documentations, testing for project deliveries.

Awarded with Best Performer Award in 2014.

Business Domain: Healthcare Accounts Receivable Management, Retail Management.

Technical Summary

Tools/Technologies : Ab-Initio GDE 3.02 Ab-Initio Co>op 3.2.2.1, UNIX shell scripting, PL/SQL

RDBMS : Oracle 11g/10g/9i, PL/SQL

Platforms : Windows, UNIX

Version Control Tools : CVS, RCS, EME

Other Tools : Oracle Sql Developer, Toad, Putty, WINSCP

Educational Summary

Degree : B.Tech, Computer Science

University : UP Technical University

Year of Passing : 2009

Projects

01

Project Name

Pharmacy Accounts Receivable System (PARS),

Medical Document Tracking System (MDTS) (Feb, 12 – Present)

Location

Lincolnshire, Illinois

Client

Walgreens

Role

Technical Lead

Responsibility

Responsible for design and implementation of ETL processes of the global corporate actions platform using Ab initio, Oracle and Unix.

Prepare detailed design document and implementation proposals.

Prepare and Present POC to client.

Performance tuning of ETL processes to reduce batch window.

Building interfaces using Ab-Initio graphs.

Manage the deliveries across multiple instances in production & test environments

Manage completing priorities of business, with minimum or no loss of efficiency on project deliverables.

Built re-usable components to be used by family applications within the framework.

Managing project deliverables for timely delivery, code reviews, defect tracking, coordinating across functional area to meet important project deadlines.

Tools and Technology

:

Ab-Initio GDE 3.02, Ab-Initio Co>op 3.02, UNIX shell scripting, Oracle 11g/10g, Putty, WINSCP, PL/SQL

Project details:

The Pharmacy Accounts Receivable System (PARS) system is used to ensure that Walgreens gets paid for every prescription it fills. It handles the claims made by customer while purchasing medicines. These claims are provided by the insurance companies to the customers. The insurance companies provide the amount of these claims to the bank and in turn bank provides the amount to PARS. PARS primarily take care of the rebilling of the claims which did not match with the deposits received from the bank.

The main functionalities of PARS are:

• To load the claims in the database.

• To load the Remittance Advice in the PARS Database.

• To load the deposits in the PARS Database.

• To load the plan information in the PARS Database.

• Apply deposits to RA.

• Apply RA to claims.

• Adjustments.

• Billing

• Collections

• Payment Exceptions

• Billing Exceptions

• Operational Management Reporting

Client systems have a document producing engine called Medical Document Tracking System (MDTS) for purpose of generating documents that are in line with all the government norms and providing it to the government on demand. The government’s stand on the exhaustive documentation is justified by the fact that majority of the population are subscribed under the Federal social insurance program – Medicare.

MDTS strengths can be listed as below:

•Reduces manual effort

•Tracking of documentation

•Interface with Allwin (Emdeon) for Medicare billing.

•Auto Fax out to Doctors.

02

Project Name

Basic Department Management (Jun, 11 – Feb, 12)

Location

Noida, Uttar Pradesh

Client

Walgreens

Role

ETL Developer

Responsibility

:

Collecting and understanding requirements from on-site lead.

Analysing and estimating the requirements and the impact current system.

Preparation & implementations of technical designs.

Optimizing performance of the Ab-Initio graphs.

Building interfaces using Ab-Initio graph which include data transfer from Oracle database.

Building data transfer tunnels between Ab-Initio and AS/400 Systems.

Unit and System Integration testing.

Data Analysis and Validation.

Tools and Technology

Ab-Initio GDE 2.14, Ab-Initio Co>op 2.15, Driver programming on MSS Framework, Oracle 10g, putty, WINSCP

Project details:

i)Automation of Store Subscription Validation Tool:

Automate the extraction and validation process by introducing the tool in BDM Application to streamline the business process. ETL process is used to automate the assortment process that was done manually using excel sheets for departments and their mapped departments.

ii)Reinstatement of stores:

The ETL Process to extract the List of Remodel Stores from the ADR7 server which is going to be remodelled 84 days from the system date. The process will help the Business users to sell out the items which are getting dropped from the store within the remodel period to maximize the profit.

iii)Automated Proposed Planogram Correction:

This is an approach taken up to compare active and proposed subscriptions to remove the discrepancies in the planograms that occur due to SCA’s re-clustering. This is an observed business scenario that while a planogram moves from proposed state to active state, there are chances that a store re-clustering can occur. Due, to this re-clustering, the already proposed planograms that have yet not reached the active state are apparently in the wrong cluster. This wrong clustering can impose significant business losses. Thus, to come up with a solution to this problem, Automated Planogram Correction System was implemented.

03

Project Name

Target Integrated Procurement Process(TIPP) (May, 10 – May, 11)

Location

Chennai, Tamil Nadu

Client

TARGET

Role

ETL Developer

Responsibility

:

Defining and finalizing the requirements with the business users/clients.

Understanding the impact of changes to be made on existing system.

Preparation of technical designs.

Coordinated activities for testing and implementation.

Touch base with Business coordinators on the progress.

Held daily status meetings with client to fix intermediate issues effectively.

Mentored new team members with system, process, and technical knowledge.

Held daily status meetings to effectively monitor the progress of the development and defects-fixing.

Implemented fixes for problems through RFC.

Tools and Technology

Ab-Initio GDE 2.14, Ab-Initio Co>op 2.15, UNIX shell scripting, Oracle 9i, putty, WINSCP, Platform: Windows

Project Details :

Worked on TIPP –Ariba (Target Integrated Procurement Process)

Personal Details

Date of Birth : 08th Feb, 1988

Marital Status : Married

Location : Lincolnshire, IL

Mobile no : +1-847-***-****

Contact this candidate