SRAVAN ANCHA

acqac2@r.postjobfree.com

623-***-****

SUMMARY

Ab Initio Professional having 7+ years of software development experience in design, development, implementation and support of software applications.

Worked with the Banking giants like JP Morgan Chase, American Express and Barclays.

Excellent UNIX experience and developed multiple scripts using UNIX SHELL Scripting. Well versed in Oracle, SQL, Teradata and DB2.

Experience in developing applications using Waterfall & Agile methodologies.

Worked with IBM scheduling tool Control-M.

High Level of expertise in Administrating, designing and developing ETL Solutions using Ab Initio 1.15, 2.14, 3.0, 3.1.

Over 7.8 years of experience in Data Warehousing and ETL processing with excellent Business Intelligence skills.

Good expertise in database and data warehouse concepts.

SPECIALITIES

• Over 7.8 Years of experience in Data Warehousing ETL tool AB INITIO.

• Expertise in ETL as Data warehouse Analyst in design, creation, admin and implementation using ETL, AB INITIO 1.15, 2.14, 3.0, 3.1, UNIX, Oracle and DB2.

• Has worked with critical components like Transform (Reformat, Filter By Expression, Join, Dedup etc), Partition (Partition By Expression, Partition By Key, Partition By Round-Robin etc), Departition (Concatenate, Gather, Merge, Interleave), Sort (Sort, Sort within Groups) and Multi stage (Rollup, Scan, Normalize) Components. Has worked with LOOKUPS, Multi File System (MFS).

• Lead a team in an Onsite - Offshore Model. Co-ordinate with offshore team and get daily work assigned and get completed.

• Efficient in software engineering skills in generating design and architecture artifacts using SPRINT Process (Envisioning, TBD, RT, RD & WC).

• Have extensive knowledge and working experience on Software Development Life Cycle (SDLC) and AGILE Methodologies.

CERTIFICATIONS & TRAININGS

• IBM DB2 9 FUNDAMENTALS Certified.

• AMEX certified in AGILE, Waterfall, SDLC, Capital Markets, Payments and Banking.

• JPMC certified AML & WFH.

• Trained Campus-Hires on AB INITIO.

ACHEIVEMENTS

• Syntel SYNERGY award 2013.

• Syntel SMART award 2014.

TECHNICAL ACUMEN

Languages

Unix scripting, PL/SQL, HTML, XML.

Technologies

ABINITIO 1.15, 2.14, 3.0.3, 3.1.2

Scripts

Shell Scripting

RDBMS

Oracle, MySQL, DB2, TERADATA, SQL Server.

Version Control Tools

EME

Case Tools

SCRUM, AGILE, SDLC

Operating Systems

Windows XP/ 2000/NT/98/95, MS-DOS, UNIX (Sun Solaris)

ACADEMIC QUALIFICATIONS

Bachelor’s Degree in Electronics and Communication from Anna University (July 2002 – May 2006).

PROFESSIONAL PROFILE

Employer 1: JP Morgan Chase & Co

Client: JP Morgan Chase & Co

Duration: May 2014 – Till date

JP Morgan Chase & Co. is a leading global financial services firm and one of the largest banking institutions in the United States, with operations worldwide serving millions of consumers, small businesses and many of the world's most prominent corporate, institutional and government clients.

PROJECT#1 : FXDRRS

Description:

FXDRRS (Fixed Derivative Regulatory Reporting System) is an application in which we extract derivate data from GLOBALNET Database. Transformations are performed on this data and loaded into RDRPROD Database from where the LE/USERS will pull data to generate reports. This is one of the critical applications. We have both monthly and daily jobs. Downstream will generate reports daily and summarized reports on month ends.

PROJECT#2 : TDM

Description:

TDM (Treasury Data Mart) is a central repository for JPMorgan Chase accrual asset and liability accrual products. TDM calculates daily transfer pricing on its wholesale and retails CDs. It also generated basic surplus and investor concentrations reporting to treasury. TDM application supports corporate treasury. TDM receives approximately 715 interface files on a varying daily or monthly schedule from 40 different upstream product systems. It also processes on demand files from treasury to support bank product mappings. These interface files are loaded directly into Treasury Data Mart, reference data is accessed from FDW.

Roles & Responsibilities:

Responsible for entire application development & Dealt with multiple projects at the same time.

Design & Development of Ab Initio graphs using various components like Transform (Reformat, Filter By Expression, Join, Dedup etc), Partition (Partition By Expression, Partition By Key, Partition By Round-Robin etc), Departition (Concatenate, Gather, Merge, Interleave), Sort (Sort, Sort within Groups) and Multi stage (Rollup, Scan, Normalize) that run on a daily, weekly and monthly basis and FTP reports/files to client Servers.

Creation of Unix wrapper scripts for supporting the graphs in PROD environment.

Worked with generic graphs.

Lead the entire team of analysts, developers & testers.

Coordinating and assisting the team to ensure that the tasks are delivered on schedule.

Involved in Onsite-Offshore calls for providing clarifications and updating work status.

Providing the Review comments and methods to enhance the Ab Initio jobs performance.

Execution of the projects as per quality processes.

Scheduled job using Control-m.

Warranty Support.

Ensuring adherence to quality standards on the deliverables made.

Troubleshooting and defect fixing on the delivered code.

Review the code.

Project management for the respective modules.

Assisting the project manager for estimation/requisition of resources for the project duration and their respective allocation/release.

Analysis and gathering of requirements for new implementations.

Testing – E2E SIT and UAT. Entire production Support.

Respond to the queries from business users and provide support to the application.

Employer 2: Syntel

Client: American Express

Duration: May 2012 – May 2014

American Express is a global financial, travel and network service provider. AMEX issues corporate cards to its corporate clients through which it helps companies and institutions to manage their travel, entertainment and purchasing needs.

PROJECT#3 : DFF (Data File Factory)

PROJECT#4 : Internal Corporate MR (Membership Rewards)

PROJECT#5 : Jet Fuel CID & Legal Entity Details

PROJECT#6 : GPFT Automation

PROJECT#7 : Mexico EI (Electronic Invoice)

Roles & Responsibilities:

Prepared documents like LDD, solution architecture, security interaction and test case document etc.

Understanding and preparation of requirements for the user stories.

Designing of basic framework that ensures maintenance of proper coding standards.

Interacting with the other Team members and resolving the concerns within the other modules of the Project.

Considering the challenges that are faced and documenting these and take it to the clients for deciding on the exact resolution Methods.

Conducted Knowledge Transition (KT) sessions to other developers.

Design & Development of Ab Initio graphs using various components like Transform (Reformat, Filter By Expression, Join, Dedup etc), Partition (Partition By Expression, Partition By Key, Partition By Round-Robin etc), Departition (Concatenate, Gather, Merge, Interleave), Sort (Sort, Sort within Groups) and Multi stage (Rollup, Scan, Normalize) that run on a daily, weekly and monthly basis and FTP reports/files to client Servers.

Creation of Unix wrapper scripts for supporting the graphs in PROD environment.

Worked with generic graphs.

Worked in a sandbox environment while extensively interacting with EME to maintain version control on objects. Sandbox features like Check In and Check Out were used for this purpose.

Performing transformations on source data with Transform Components like Reformat, Filter-by-Expression, Rollup etc.

Done appropriate unit-level testing, log defects in QC and the management of the review process for the Ab Initio deliverables. Provided Warranty Support.

Employer 3: Span Infotech

Client: Barclays

Duration: Aug 2007 – Apr 2012

Barclays is a British multinational banking and financial services company headquartered in London. It is a universal bank with operations in retail, wholesale and investment banking, as well as wealth management, mortgage lending and credit cards. It has operations in over 50 countries and territories and has around 48 million customers.

PROJECT#8 : Global Integrated Warehouse

PROJECT#9 : Cross Sell Applications

PROJECT#10 : Warehouse Management System

PROJECT#11 : Global Trade Transactions File Process

Roles & Responsibilities:

Design and Development of Ab Initio graph that runs on a daily basis.

Documentation.

Worked with Partition, De-partition, Sort and Transform Components for faster processing of data.

Designing of basic framework that ensures maintenance of proper coding standards.

Interacting with the other Team members and resolving the concerns within the other modules of the Project.

Done appropriate unit-level testing.

Was involved in Onsite- Offshore calls for clarifications and updating the work status.

Delivered on time all the assignments that were assigned and responsible for.

Contact this candidate