Ajeet Kumar Verma

*** ****** **** ***, *** ***, Collierville, TN, 38017

addn87@r.postjobfree.com, +1-201-***-****

Total Experience: 12 years 00 months

Academic Qualifications

●BE in Electronics & Tele Communication from SSBT’s College, North Maharashtra University, year of passing 2007 with aggregate of 61.5%.

●K.V 9 BRD, Pune (Class XII) – 73.2%.

●K.V 9 BRD, Pune (Class X) – 76.6%.

Certifications

■AWS Associate developer

■SAFe Agile 4.6

■Oracle 9i

Work Experience Details

■Current Company : Atos – Syntel Inc

■Current Designation : Senior Consultant

■Job Domain Expertise : Data Warehousing ETL(Ab-Initio)

■Current Company : Cognizant Technologies Solutions US Corp

■Current Designation : Senior Associate

■Job Domain Expertise : Data Warehousing ETL(Ab-Initio)

■Previous Company : Wipro Technologies

■Current Designation : Senior Software Engineer

■Job Domain Expertise : Data Warehousing ETL(Ab-Initio)

■Previous Company : BitWise Solutions Pvt Ltd

■Current Designation : Programmer Analyst

■Job Domain Expertise : Data Warehousing ETL(Ab-Initio)

Career Summary

27th Aug 2018 – Till Date Atos - Syntel Inc

Client: Fedex Services, Collierville, TN, USA.

Project Name: EDW and Data Acquisition

Role: Abinitio Developer at Onsite (Collierville, TN)

Platform: UNIX, GDE- Ab-Initio 3.3.5, Co-operating System version 3.1.3

Database: Teradata

Team Size: 6

Duration: 27rd Aug 2018 – Till Date

Project Description:

FedEx Express is a cargo airline based in Memphis, Tennessee, United States. It is the world’s largest airlines in terms of freight tons flown and the world's fourth largest in terms of fleet size. It is a subsidiary of Fedex Corporation. Customer wants to consolidate all their Customer Information Data and maintain for the customers across FedEx. Data Acquisition application is involved in capturing the data from various FedEx entities (sources) into the Enterprise Data Warehouse (EDW) which is in Teradata Platform. The data mostly contains the customer identity (customer demographic) information, revenue and shipment information. Where the beneficiary will be working on the Analysis of their business requirements on Enterprise data ware house, Purge criteria, Data retention period, Writing of Software requirement specification document, Mapping of the source to target elements, Data integration testing, Stake holders management.

Tasks:

Work on the development related to designing, coding, code level unit testing activities & deployment for Software application development tasks.

Supporting the activities like application maintenance, server loads and calculation of various fields to understand the state of the servers.

Working on the Defects that needs to be resolved as per the requirement. This involves design & code changes to adhere to the solution provided.

Interacting with the client on requirements.

Working on optimization of the code and design level changes if required to improve the performance.

Mentoring & contributing to improvements of the overall application by discussing on the new features and changes in business, domain & technical areas. Understanding the issues faced by the team and providing solution

19th Jan 2014 – 15th Aug 2018 Cognizant Technologies Solutions

●Client: Capital One, Richmond, USA.

●Project Name : Customer Experience Metrics Program

●Role: Abinitio Developer at Onsite (Richmond, Virginia)

●Platform: UNIX, GDE- Ab-Initio 3.2.0, Co-operating System version 3.1.3

●Database: Teradata

●Team Size: 10

●Duration: 23rd Feb 2015 – Till Date

Project Description:

●Capital One’s overall objective is to drive improved business results, via improvements to the customer experience. Currently, the company tracks a multitude of customer satisfaction across several independent programs that are either line of business or channel specific. The current metrics and their defintions are not consistent or actionable across business areas and impede the ability to obtain a holistic view of enterprise performance. The goal is to provide both a single enterprise view of our delivery to customers; as well as, drill-down customized views of LOB/channel performance – ideally on the same reporting frequency.

The first objective is to create a comprehensive, enterprise-wide customer satisfaction assessment program that will replace numerous overlapping and inconsistent customer satisfaction programs. The enterprise view will focus on the 10-12 key metrics. In addition, Capital One’s three US business units (Credit card, Bank and Financial Services) will have the opportunity to add a few additional questions to surveys of their customer interactions.

Tasks:

●Involved in requirement gather meetings and Analysis

●Involved in detail design creation and design review

●Creation of Source to target Mapping

●Process Improvement

●Developing Abinitio graphs and Shell Scripts

●Unit testing of the code

●Supporting QA team in testing

●UAT Support

●Involved in production support

●Cloud Migration

●Client: Express Scripts, Franklin Lakes, NJ, USA.

●Project Name : Automated Benefit Load

●Role: Abinitio Developer at Onsite (Franklin Lakes, New Jersey)

●Platform: UNIX, GDE- Ab-Initio 3.1.2, Co-operating System version 3.1.3

●Database: SQL Server

●Team Size: 6

●Duration: From 19th Jan 14 till 5th Feb 15

Project Description:

●WellPoint client sent the XML files to the ABL system, after receiving the xml files data validation occurs and the file was processed/rejected. Based on coverage code, BPL was generated and passed to BRE for creating accum and copay files and sends to GDE Dev team. Later the process maps the fields in CBM after doing the transformation on the fields and based on add/update the benefits get updated in CBM and reports sent to client. After confirmation from client the Copay and Accums were loaded in CBPS system.

Tasks:

●Involved in requirement gather meetings and Analysis

●Involved in detail design creation and design review

●Developing Abinitio graphs and Shell Scripts

●Create parameter sets including PDLs.

●Create Abinitio Plans using Conduct It

●Unit testing of the code

●Doing SIT testing with BRE and Java team.

●Supporting QA team in testing

●UAT Support

●Involved in production support

11 March 13 – 17th Jan 14 Wipro Technologies, USA

●Client: Capital One, Richmond, USA.

●Project Name : Basel II (UK Card)

●Role: Abinitio Programmer at Onsite (Richmond, Virginia)

●Platform: UNIX, GDE- Ab-Initio 1.15, Co-operating System version 2.15

●Database: Teradata

●Team Size: 8

●Duration: From 11th March 13 till 17th Jan 2014

●The Basel II Retail Credit Teradata Repository project will be responsible for implementing the Teradata Repository which will store all data elements required for the development and execution of Basel II. The data elements for each Retail Credit Line of Business (LOB) will be modeled within the Teradata container based on the Core Data deliverables produced by the Historical Data Collection Projects, combined with the RWA required data elements.

The process involves creation of clean files once the init files from UK team received at US EDE end. The clean file is accumulated daily in MVS to create month end file. On month end the accumulated file published to DDE. All the transformations are done while creating the nrch file from accumulated file and later on load ready files are created which are loaded into PBASEL table.

Tasks:

●Involved in data mapping review meetings

●Coding as per the data mapping Document

●Involved in design creation and design review

●Unit testing of the code

●Supporting QA team in SIT testing

●UAT Support

●Creation of Toss-G, technical design document and control –m doc.

●Involved in production support

●Client: CitiGroup, USA. JUN-2012 to FEB-2013

●Project Name : CCD (Commercial Cards)

●Organization: Wipro Technologies, India

●Role: Abinitio Programmer at Onsite (Columbus Ohio)

●Platform: UNIX, GDE- Ab-Initio 1.15, Co-operating System version 2.15

●Database: Oracle

●Team Size: 15

●Duration: 7 months

●The data from different region are sent to GDR system that is global data repository. These data are loaded into staging area and from staging to citicom database. The data from the GDR is read by Microstrategy team to create different report. The data is also sent to visa and master as per required format.

Tasks:

●Gathering the requirements with Business for inbound and outbound process.

●Involved in data mapping

●Coding as per the requirement gathered

●Unit testing, Integration testing and UAT of the application before delivery.

●Involved in the code walkthrough.

●Client: CitiGroup, USA. JUL-2010 to MAY 2012

●Project Name : ESA - CBR (Economic Stabilisation Act – Cost Basis Reporting)

●Organization: Wipro Technologies, India

●Role: Abinitio Programmer

●Platform: UNIX, GDE- Ab-Initio 1.15, Co-operating System version 2.15

●Database: Oracle

●Team Size: 08

●Duration: 26 months

●The Emergency Economic Stabilization Act of 2008 ("ESA" or "Act") and associated proposed regulations requires certain payers to provide their "U.S. Non-Exempt recipient" clients and the Internal Revenue Service with the adjusted cost basis of "covered securities" acquired after January 1, 2011. Adjusted cost basis is generally defined as the original purchase price of a security, adjusted for fees, corporate actions, wash sales and other tax-related adjustments.

Tasks:

●Gathering the requirements for different sources(Total :10).

●Attending meetings to finalize layout for different sources.

●Unit testing and Integration testing of the application before delivery.

●Data validation was done by using comparison applications.

●Involved in the code walkthrough.

Jan 08 – May 10 BitWise Solutions Pvt. Ltd., Pune.

●Worked on all phases of development life cycle, from gathering requirements to implementation, testing and support.

●Demonstrated the required utilization of ETL tool Ab Initio with integrated utilization of UNIX and TERADATA (SQL).

●Exceptional background in analysis, design, development, customization and implementation and testing of data warehouse applications and utilities.

●Team player with good communication and problem solving skills.

Technologies and Tools Used

●Abinitio

●Unix(Shell scripting)

●Teradata SQL 6.2

●IBM job scheduling Console

Professional Experience

Project: DDS (Decision Data sourcing)

Duration: Jan 2008 till date

Role: Programmer Analyst

Client: Discover Financial Services

Description:

Discover Financial Services is the major client of BitWise Solutions Pvt. Ltd. Decision Data Sourcing team is an important part of Discover environment.

The Decision data sourcing system includes the STRATA system that is responsible in deciding the scores of credit card holders of Discover depending upon their behavioral patterns, loyalty and history. FICO Score, Super Score, Behavior Score are the type of scores calculated by the system.

Data needed for the STRATA system has to be extracted from various sources, cleaned, updated, formatted, concentrated and then made available for further scoring process.

Under Decision Data Sourcing team the projects includes impact analysis of any changes to the DDS process, preparing technical design and test plans for the proposed changes and making executables as per business requirements and maintaining the system and supporting it.

Responsibilities:

It included DDS support, maintenance and enhancements. In addition to my role as a developer in Ab-initio, I was often entrusted the tasks related to Shell scripting for the wrappers to catalog the files and some run scripts, process enhancements, data analysis, impact analysis, extraction and mapping

Project Summary

Project Title: Scalable Batch (Phase I)

Organization: BitWise Solutions Pvt. Ltd, India

Client Name: Discover Financial Services, U S.

The objective of Scalable Batch project (Phase I) is to convert the historical files used into teradata tables to reduce the redundancy of data and speed up the processing. The required data is first transformed and stored in the files (load files) and then it is loaded into tables.

Role:

■Backtracking of derived fields to find out the source field and file.

■Distinguishing the fields based on different criteria such as monetary fields, non-monetary fields etc.

■Creation of load files and testing the application using development tables.

■Used normalize, demoralize and output table components.

■Interacted with the onsite coordinators at US for knowledge transfer of the existing system and discussed the requirements, features, functionalities and the design of the new requirements.

■Used multi files as source.

Project Title: Decision Batch Application Migration

Role: Team Member

Project Description:

■Decision Batch Application Migration involved migration of the data processed in Decision Data Sourcing from files to tables. Thereby increasing the performance of the applications extensively and reducing the space issues. This being a large scale project is being executed in phases. I am currently working for Phase 2 Implementation

■Under Phase 2 Implementation of this project, it involves migration of all the important inbound events that constitute the major applications of DDS to Teradata

■Currently all the inbound events process the data by reading from files and write the processed data to files.

■However, with the implementation of DBAM the inbound events will read data from tables and load the processed data to be sent to Strata into tables

■This would lead to tremendous performance enhancement for DDS

Responsibilities:

■Member of Development and Testing Team

■Creation of DTD (Detailed Technical Design)

■Developing generic graphs and extensively using psets and pdl concept

■Developing graphs to load data into Teradata tables

■Performing validation of the data loaded into tables

■Performing extensive Unit Testing

■Providing support for Development environment – bug-fixing and problem solving

Project Title: Account Transfer

Organization: BitWise Solutions Pvt. Ltd, India

Client Name: Discover Financial Services, U S.

The objective of Account Transfer is to create an application(s) for assignment of new account numbers for accounts that are lost, stolen, or transferred in order not to lose historical data.

Role:

■Interacting with the onsite coordinators for understanding the requirements and updating the status.

■Implementing the code design for the required fields.

■Unit testing and Integration testing of the application before delivery.

■Used the concept of lookup file and lookup function in reformat component.

Project Title: Default Pricing Project

Organization: BitWise Solutions Pvt. Ltd, India

Client Name: Discover Financial Services, U S.

The objective of Default Pricing Project is to create an application(s) for updating files with additional month’s data for existing fields by adding buckets.

Role:

■Back tracking the required fields for identifying the source.

■Writing the transformations for implementing the rotation logic to keep the minimum of 12 months data and pulling the fields from the required source files.

■Creating new dml with the added fields.

■Validation of data by using multi files as source.

Short Requests:

Worked on short requests some of which are as follows:

a.Backfilling of data.

b.Optimization of application.

c.Creating and updating analysis document of various applications.

Achievement

●Has got excellence award twice for SBI project and Support Activity.

●Has got Thank You card from Project Manager for showing the commitment to work and

providing a defect free delivery

●Has received appreciation from Onsite Co-coordinators for dedication to the project and

defect free delivery

●AWS dev certification

Personal Details

Name : Ajeet Kumar Verma

Date of Birth : 24th July, 1986

Gender : Male

Marital Status : Single

Religion : Hindu

Nationality : Indian

Passport Number : G6380850

PAN : AGHPV8906B

Permanent Address : Arya, Survey no 49/2, Opposite Relax Hotel, Vadgaon-sheri Pune-14, Maharashtra

I hereby declare that the information furnished above is true to the best of my knowledge.

Date:

Place: Collierville, Tennessee Ajeet Kumar Verma

Contact this candidate