SUMMARY:

• 9 years of experience in Design and Development of Ab Initio Applications in Banking and Retail sector.
• Currently working with IBM India Pvt Ltd at client location in USA. The nature of work is based on Data Lake architecture.
• The area of expertise has been in requirement gathering, analysis, application design and development by using Ab Initio followed by Unit testing, system testing, production implementation and support.
• Having an experience on dependency analysis and MHUB lineage in Ab Initio.
• Having knowledge on creation of Hadoop files using Ab - Initio.
• Ability to deliver multiple projects simultaneously in an efficient manner.
• Worked on Performance tuning of Ab Initio Jobs for optimal performance and throughput.
• Having previous client site experience of 8 months in which worked on functional acceptance testing.
• Knowledge and experience in UNIX commands & shell scripting.
• Provided support to various applications. Worked with multiple teams to deliver a project.
• Experience in mainframes for scheduling the jobs.
• Extensive experience with analysis, design, development and implementation of ETL software applications.
• Proficient in analyzing and translating business requirements to technical requirements and design.
• 2+ Years of work experience in Oracle and 1+ years of work experience in Teradata.
• Having a knowledge in complete development life cycle of Data Warehousing and data marts.
• Involved in effort estimation and project planning.
• Previously worked in TCS from May 2008 for Leading Bank of Netherlands (ABN AMRO), The project is related to Marketing Intelligence department of the bank. Objective of this project is to organizing and analyzing customer data.
• Worked in project related to American’s pharmacy unit. Objective of this project is to keep financial data of patient’s insurance provided by insurance companies, and bank deposits.
• Worked for J.P. Morgan Chase as a vendor for Transfer Pricing project. Successfully implemented the solution for LATAM, Suisse, IBF NASAU and London.

TECHNICAL SKILLS:

Development ETL Tools: Ab Initio

Functional Modules: Finance, Warehousing, Retail

Database: SQL, Oracle, Teradata

Operating System: Windows Xp, Unix

Scripting Language: Unix shell scripting

Schedulers: Control-M, Mainframes

Other Tools: EME, MHUB, Hadoop, Quality Center

PROFESSIONAL EXPERIENCE:

Confidential

Ab Initio Specialist

Responsibilities:

• To feed the Atlas Data Lake with the current source systems by migrating the existing DIME environments to Atlas.
• To add all source system data with potential for future usability to the Atlas Data Lake.
• Ensure that the quality of data in Atlas Data Lake is at par with the DIME and the source system.
• Develop reusable processes to efficiently extract & load both data at rest and data in motion into the Atlas Data Lake.
• Build new demands in Atlas Data Lake directly without involvement of DIME.

Ab Initio Specialist

Responsibilities:

• Transfer Pricing - Transfer pricing involves the solution where the "cost of use" or "credit for provision" of a business unit's funds is approximated.
• For these projects I was responsible for analysis, design, development, testing and implementation of particular module and upgrades for our IBM US customer Confidential (JPMC)
• Receive a Functional and Technical specification documents on the system requirement. We work on the understanding and analyze the impact of new requirements.
• Responsible to accomplish the task on time with high quality.
• For a varying business requirements, deliver the new and effective solution as per the business.
• Responsible for understanding the business requirements from customer.
• Provide the effective design for the requirement keeping the future changes in mind.
• Responsible to estimate the effort required and work as a team to accomplish the goal.
• Engaged in setting up the environment for different phases of project life cycle.
• Involve in the communication with customers to understand the requirements better.
• Involve in creating the System requirements, Design documents and other solution specific documents.
• Use the strong technical knowledge to do an in-depth analysis and propose a solution for business.
• Managing the handover session to the Production support team.
• Key projects handled in Confidential - Transfer Pricing.

Environment: Ab Initio, Unix, Control-m and Oracle

Senior Consultant Oracle Financial Services Software

Responsibilities:

• Worked in OFSS for Citibank client which involves:
• Successful implementation of the code related to addition of Luxembourg branch in MT210 project and tuned the script to run at different time transaction and cancellation data.
• Provided UAT support for migration of LATAM code from CBII to GIW statements

Environment: Ab Initio, Unix, and Oracle

IT Analyst

Responsibilities:

• Worked in enhancement activities and various code-fixes for Walgreens client in retail sector.
• Effort estimation and project planning.
• Provided support for critical batch jobs in two applications - PARS and MDTS which are related to financial data.
• Created new graphs for permanent fix of data corrections.
• Upgraded the graphs for fine tuning.
• Resolved user queries/tickets on the spot.
• Received “On the spot award” for resolving the critical failure on time by involving various vendors

Environment: Ab Initio, Unix and Oracle

Ab Initio Developer

Responsibilities:

• Worked for ABN AMRO client in banking sector.
• Requirement gathering during the Functional module iteration phase.
• Assisted in effort estimation and project planning.
• Involved in system building, Ab Initio graph testing, code review and preparation of implementation plan.
• Performed integrated and functional testing.
• Received appreciation from Project Lead for handling mainframe related issues in a very short notice and transferring of code from old to new source.
• Recruited new associates for team and groomed them for project.
• Virtual Delivery Assistance Facilitator appointed for projects of other domains (Transactional banking, Internet banking)
• Involved in preparation of Project Management Reports for facilitating projects.

Environment: Ab Initio, Unix, Teradata, Mainframes and Quality Center

Ab Initio Developer

Responsibilities:

• Worked for ABN AMRO client in banking sector.
• Worked directly in team of client including business analysts, test lead, PMIT.
• Represented TCS in high level functional testing at client site as that was the first FAT project given to TCS.
• Coordinated with development team at offshore as well as test team and SDT at onsite.
• Participated in test team meetings with client and created test document.
• Provided error resolution for most of the defects in Ab Initio.
• Created several fastload scripts to load data from mainframes data set to NCR teradata.
• Created test data for new customers of bank that was supposed to merge with client. (This project was related to merger of two leading banks of Netherlands)
• Provided effort estimation.
• Received customer appreciation for completing the project in short span of time.

Environment: Ab Initio, Unix, Teradata, Mainframes and Quality Center

Ab Initio Developer

Responsibilities:

• Completed two months of initial training in TCS.
• Worked for ABN AMRO client in banking sector
• Requirement gathering during the Functional module iteration phase.
• Designed the system, built and tested Ab Initio graphs during the Design and Built iteration Phase.
• Performed technical and functional testing.
• Learned basic banking domain and project related features
• Worked in team for creation of new data mart at financial household level.

Environment: Ab Initio, Unix, Teradata, and Mainframes.