Resume_akhilesh 2.doc

Resume Name : Akhilesh Gupta Phone : +91-9822731459

E-mail : [email protected]

Overview

 Possesses strong skills in Administration, development & customization of graphs using Ab>Initio GDE 1.15 and 3.0 above .Expert in the use of Co>Op 2.15, 3.0 and above, Conduct>IT, ACE/BRE for development and testing.

 Seasoned IT consultant, with demonstrable experience of 7.8 Years. Played different roles in Fields of Information Technology.

 Experienced technical leader in Business application delivery in Retail, Banking, Telecom, Cards and Insurance domain. .

 Good grasp of data warehousing and ETL.  Good Hands on UNIX Shell Scripts. Professional Summary Start

End

Company

Role

Dec 2015

Till Date

Capgemini,Pune

Abinitio Technical Lead

Aug 2014

Oct 2015

Nityo Infotech , Singapore

Abinitio Consultant

Feb 2014

July 2014

Cognizant Technology Solutions, Pune,India

Associate-Projects

Jan 2011

Jan 2014

Hoonar Tekwurks Consulting LLP , Pune,

AbInitio Specialist

Oct 2009

June 2010

Crystal Corporations,Nasik

PHP Web Developer

Technical Expertise Domain

Primary

Secondary

Data Integration

Ab>Initio GDE (1.15, 3.0 above) Co>Operating System (2.15, 3.0 above)ACE/BRE ( Express > IT) ,Data Profilers,Absql,Op console,Control Center,Continuous flows, Webservices

Informatica Power Center , Workflow Designer

Databases

Oracle

MYSQL

Others

UNIX Shell Scripting , Business Objects, SQL, PHP ,AJAX,Javascript

Akhilesh Gupta

+91-9822731459

Project Summary: Client

: Barclays Bank, UK (Banking)

Project : E-vision RTDE

Technology : Abinitio Co>Operating System 3.2.2.7 GDE 3 and above,Continuous flows,Web services

Description: Barclays E-vision is real time application framework developed using Abinitio Continuous flows and Web services components . Evision is Fraud detection system which continuously get request 24X7 for debit cards related customer transactions declined by third party vendor RSA due to potential risk of fraud associated with it. Evision validate the request on the basis of certain set of predefined rules and checks and then send interactive SMS to customers regarding particular transaction via IMI(Barclays Mobile SMS vendor) to verify genuine transactions. As per basis of response of customer E-vision update the status to RSA again and also sends details to Barclays Evision Fraud OPS team if any fraud detected. Roles and Responsibilities:  Design and Development of Continuous flows graphs and webservices graphs.  Responsible for requirement gathering and design analysis.  Point of contact to testing team in OAT and SIT.  Code Migration and Implementation to higher environment. Client

: Citi Bank, USA (Banking)

Project : Abinitio Administration and Support

Technology : Abinitio Co>Operating System 2.15,3 and above, GDE 3 and above,EME 2.15,3 and above,Unix, Op console

Description: Citi Bank is USA based multinational Banking and Financial Corporate has multiple applications running on shared servers across multiple regions. Middle ware teams under Global Production Assurance (GPA) supports all control and Development servers Roles and Responsibilities:  Handling Abinitio Performance related issues.  Handling Abinitio Code related issues.  Code Migration to higher environments by following complete SDLC process .  Infrastructure build and Abinitio configuration. Client

: MTN, South Africa (Telecom)

Project

: IRWA (Informatica Replacement with Abinitio)

Technology : Abinitio Co>Operating System (3.01), GDE 3.01, Data Profilers, Informatica Power Center, Workflow Designer, Oracle,Absql.

Description: MTN seeks to implement a high performing computing platform capable of processing over billion plus records every day and able to seamlessly integrate into a real time data processing capability. MTN identifies Ab Initio as the technology on which to consolidate its data integration requirements in information management space viz. data warehousing, data marts, business intelligence, data integration, MIS, ODS among others. Currently there is a set of bespoke code that is being run in technology such as Informatica and SAS that is doing data integration mainly in data warehousing and marts space.

Akhilesh Gupta

+91-9822731459

This has been identified to be deprecated in a phased manner built to future architecture. The start will be with Informatica replacement and then moving on to the other tools and technologies The current process in Informatica perform sourcing from key operational systems such as SV, EPPIX, CDR, PPMed etc. and loading into RSA, RA, EDW2, EDW as the main downstream targets. Informatica application perform transformations ranging in complexity from simple to complex on a daily, weekly, monthly, and quarterly basis which support tight SLA. It is the desire of MTN to consolidate all of this on to a single platform of Ab Initio. Roles and Responsibilities:  Worked as agile developer responsible for analysis, design, development, testing and Documentation.  Documentation of the technical and non – technical requirement.  Requirement gathering by analyzing existing code in Informatica.  Design and Development of bespoke graphs in Abinitio.  Unit testing and System testing.  Responsible for Code promotion.  Point of contact to testing team in OAT and SIT.  Responsible for code review.  Client appreciation to gain high performance over Informatica code. Client

: TESCO, UK , (Retail)

Project : Simpler Integration

Technology : Ab Initio Co>Operating System (3.01), GDE 3.01, ACE/BRE, UNIX, Oracle. Description:

Tesco PLC is a British multinational grocery and general merchandise retailer headquartered in Cheshunt, United Kingdom. It is the third-largest retailer in the world. Tesco has decided to do the future developments in SOA model. For implementation of this modular approach, generic graph patterns or adapters need to be developed. Generic pattern includes Extractor, Joiner, CDE, Transmitter, Normalizer, Extract-Join-CDC etc. These generic graphs later communicate with each other as per business requirement and also configured in ACE. Roles and Responsibilities:

      

Client

Involved in complete life cycle of development of the project. Understanding and finalizing S2T mapping with lead. Designing of the graphs and lead junior developers in coding of the graphs and ACE Templates. Code review of graphs developed by other members of the team. Responsible for tag creation and promotion of the code. Point of contact to testing team in SIT. Client and internal management appreciation for the work. : Standard Life Group (Insurance)

Project : Solvency-II

Technology : Ab Initio Co>Operating System (3.01), GDE 3.01, ACE, UNIX, Oracle, Plan and Conduct>It Description:

Standard life group as per other European Insurers will need to adhere to the Solvency II directive. Solvency II is based around the need for European Insurers to calculate their solvency according to the international rules, evaluate and manage their risk and report on solvency of the local regulators.

Akhilesh Gupta

+91-9822731459

It is being implemented in order to protect the consumer from an insurer failure; such a failure could include a catastrophe such as flood and result in insurers being unable to payout on insurance claims. As part of the directive, Standard Life will need to go through an internal model approval process (IMAP). In order to successfully complete the IMAP process Standard Life will need to illustrate how their Solvency II solution will enable compliance to the European regulation. Ab-Initio is used as data integration tool for this solution architecture. Scope is the full range of ETL processes that capture/extract data from source administration systems and extends through all the ETL processes involved in providing data to various staging/intermediate data repositories up to and including those used for final analysis and reporting. Roles and Responsibilities:  Involved in complete life cycle of phase-1 and Phase-2 part of the project.  Responsible for functional specs review and raise defects in initial phase.  Development of generic and other complex bespoke graphs.  Understanding and implementation of the business rules by referring S2T mapping document.  Creation of Automated Test Harness for all the graphs developed, using Ab-Initio Plan/Conduct>It.  Unit testing by creating the proper test data.  Code review of graphs developed by other members of the team. Client : Capital One, USA (Banking) Project : Integrated Fulfillment Manager (IFM) . Technology : Ab Initio Co>Operating System (2.15), GDE 1.15, UNIX, Teradata, Plan and Conduct>It Description:  IFM is a COAF developed secure, auditable application that receives and consolidates fulfillment requests from a diversified set of requesting sources AND fulfills on those requests to various systems/vendors.  IFM Provides single platform to interact with external vendors and internal vendors thus, reducing multiple communication channels which helps with improved turnaround time, better service and single point of escalation.  IFM Provides a Common Interface –for both the DA Community and Upstream Automated target fulfillment systems.  IFM Introduces Action Types and Flows (combination of action types) and Target Fulfillment Processes those are reusable by any requestor.  IFM Supports Orchestrations (Serial and Parallel) to handle dependency between action types within a flow.  IFM Provides Reconciliation Services (Record Level and File Level Reconciliation) which would update source systems with the status of each and every record sent over to target.  IFM supports Continuous Flows to make a real time transmission (For sending email and SMS alerts) .  IFM handles all target specific DQ checks while transmitting the data. Roles and Responsibilities:  Responsibility included development and design of graphs.  Work on complete cycle of analysis, design and development on stories like Control Process Improvement, Performance optimization in Orchestrations, Archival process Enhancement which are most important processes in IFM.  Undertake performance improvement analysis.  Test case preparation, Unit Testing, dependency analysis in EME.  Production Support, cycle monitoring and report creation.

Akhilesh Gupta

+91-9822731459

     

As a part of production support I handled the issues related to production and resolution of defects . Found the root cause of defects whether it is graph defects or database defects. Fixed it and did UT for same and finally check in the graph or project. Providing solution to IPS team within short time. Also using the standard wrapper script / editing it for the new jobs Also worked with testers for defect fixing and answering questions Creating Plans in Conduct>IT for the project Use of EME for version control (check-in, check-out), job tracking and dependency analysis

Personal Details Date of Birth Sex Nationality Marital status Languages Passport

: : : : : :

Feb -01-1986 Male Indian Single English, Hindi K5616436 (Valid Till June 2022)

Educational / Professional Qualifications

Qualification

College/Institute/University

Duration

Data warehousing Certification

ATS InfoTech, Pune

07/2010 - 12/2010

Master Of Computer Application (MCA)

HPT Arts & RYK Science College, Nasik (Pune University)

2006 - 2009

Akhilesh Gupta

+91-9822731459