Manager Project

SADHANA VENKATARAMAN

Mobile No: 651-***-****

E Mail: accef0@r.postjobfree.com

SUMMARY

7+ years of extensive experience in Information Technology in Banking Domain.

1.

Vast technical experience in COBOL,DB2, IMS DB/DC, DYL280,

•

CICS,JCL,VSAM,Changeman/Endevor,FileManager,QMF,SPUFI,TIVOLI, IBM Rational

Clear Quest,SAR,SAS,Control M(CTM), DISPATCHMAINVIEWRMM – Removable Media

Manager,VIASOFT/Expeditor,DFSORT,SYNC SORT,IBM Fault Analyzer, IBM Application

Performance Analyzer,DB2 Explain.

Designed CICS online screens using GBBM and SDF utilities.

•

Possess knowledge on CA 7 scheduler and REXX language.

2.

Experienced in creating SQL’s for retrieving and manipulating DB2 database servers

•

using query management tools like QMF and SPUFI.

3. Experienced in creating optimized queries using DB2 in COBOL programs.

Strong experience in the TSYS credit card processing system.

4.

Possess knowledge on software development life cycle methods as Waterfall and Agile

•

Methodologies.

Possess excellent client co ordination skill and involved in various related activities like

•

attending project kickoff meeting, preparing and sending daily and weekly status reports

to stake holders of project, conducting weekly project progress meeting with projects

stake holders and by addressing queries related to the project.

5.

6.

CERTIFICATION:

7.

•Completed Scrum Master Accredited certification.

•Hold L1 Credit Cards & L0 Banking and Financial Service certifications.

•ADM Developer MF certification by Element K.

AWARDS:

•Won many ‘Applause’ and ‘Associate of the Month’ awards.

Technical Skills:

IBM Mainframe

Host Language : COBOL 370

Hardware : IBM S/390, IBM Compatibles.

Operating Systems : OS/390.

Database and File

System : DB2, VSAM, IMS DB.

Tools & Utilities : TSO/ISPF,MVS, FILE AID, SPUFI, DCLGEN, ENDEVOR,

DYL280,VIASOFT,SUPERC,QMF, Expeditor,

FileManager,Abend aid, Fault Analyzer, Change Man,

IDMS, Info man, NDM, DFSORT, SYNCSORT, VSAM,

IEFBR14, FTP, SDSF, IBM Utilities (IDCAMS, IEBGENER,

IEBCOPY, IKJEFT01), TIVOLI, IBMRationalClear Quest,

DISPATCH,PANVALET.

Testing Tools : Load Runner, Win Runner.

Control Systems : CICS, IMS DC.

Open System

Language : Visual Basic, JAVA.

Operating System : MS Windows NT/98/95.

Database : Oracle, MS Access, SQL Server.

Others : Ms Word, Excel, PowerPoint, MQ Series.

PROFESSIONAL EXPERIENCE

CLIENT Rabobank, NJ Aug’11 to Sep’13

Rabobank is an international financial service provider in US offering services like retail

and wholesale banking. I was part of both the Savings and Management of Information systems

(MIS) team of this bank.

The SAVINGS(AZS) portfolio is a real time online savings system which deals with various

savings products and schemes for customers holding an account with RABOBANK.AZS

comprises of 6 sub systems called OBS,IVS,PBS,FAS,OFS and WNS.

The Management of Information systems (MIS) portfolio is responsible for information

and report management system of the bank and does analysis, processing and management of

data coming from various other interfaces.

Responsibilities:

As a Team lead,

8. Involved in all the phases of a project lifecycle like requirements gathering, design,

coding, unit testing, implementation, post implementation support.

9.

10. In SAVINGS portfolio,

11. Worked extensively in the online agreement management system ( OBS) that enables

the bank employee to create, view, modify and terminate a savings agreement.

12. Involved in batch functions to merge and manage agreements.

13. Worked in the subsystem IFS, which provides agreement related information to all

other subsystems in AZS and systems outside AZS. It also provides accountability

information of the customer to external systems to process the delivery of bank

statements.

14. Worked in the PBS subsystem, which provides product and interest variant

information to the agreements.

15. Used the FAS subsystem to calculate interest such as projected interest and current

interest of an agreement.

16. Worked in the OFS subsystem, which deals with setting up of booking dates and

booking period for savings agreement.

17.

18. In MIS portfolio,

19. Developed scripts to maintain and enhance the information maintenance of the bank

in the data warehouse.

20. Involved in developing SQL scripts and embedding them in the COBOL programs to

intake files from different interfaces/external systems, analyze/pre process data and

performed ETL (Extraction, Transformation and Loading) to load data into data

warehouse.

21. Applied various concepts of data warehousing like staging, landing, fact

dimensional and data marts.

22. Developed few procedures in FOCUS to generate analytical reports on the different

products of the bank.

CLIENT JPMorgan Chase, Wilmington Jul’07 to Jul’11

C3 (Chase Card Core), formerly known as MyTSYS, is a Card Processing platform of the

which includes the authorizations, clearing, settlements and rewards functionality of JP Morgan

Chase. It includes enhancements, maintenance and 24/7 production support for the Card

processing application. I worked in some of the projects listed below:

Visa Advanced Auth – As part of April Release 2008, Fraud Risk Management is requesting the

implementation of the Visa Advanced Authorization score, Risk Condition Codes and

Compromised Event Reference ID on the C3 card processing platform to help in fraud detection

during the authorizations process.

April Association – Tandem will send new fields Message Reason Code, STIP/Switch Reason

Code and Response Code online and batch to IBM Authorization. IBM Auth will accept new value

in Terminal Capability code field will be passed to RTD and RTL messages. These fields are to be

showed to the Customers also.

Tandem DB Expansion – The source of the request to expand Auth log files and Tandem

positive files for the increase in the performance.To support Tandem Authorizations changes, IBM

Authorizations is required to expand Authorizations log file and Tandem positive file (Account,

Card and Emboss name) groups.

FALCON Upgradation – FALCON is the Third party vendor used by Chase as the Fraud

detection tool which calculates the fraud score. For every real time transaction, if it is considered

as the Fraud transaction, then the Chase card services uses the Falcon for finding the falcon

Score, then as per the Falcon Score it determine whether to approve the transaction or not. As

per new functionality, FALCON has decided to add some set of rules for each transaction

Circuit City – Age of oldest trade The purpose of the Circuit City project is to convert all

accounts currently on the PLTSYS platform to the C3 platform. This conversion includes: Circuit

City Co brand & Private Label, United Private Label, and Healthcare Financing (HCF) Private

Label accounts. This project deals specifically with the addition of the Age Oldest Trade as a

decision key in the Triad application. Also they added a new Score Type T0060 to determine the

value of Age of Oldest Trade.

RTD / Card Guard Expansion The scope of the project is to expand the RTD and Card Guard

Fraud Strategies. Before this release we have 98 Rules to identify the fraudulent transactions. But

in this Release we expanded the Fraud Strategies to 298. This is one of the biggest release in

Authorization part.

Regulation Z On May 23, 2008 the Federal Reserve Board (FRB) announced their intention to

make the first major overhaul of Reg Z since 1981, and these amendments were published in the

fourth quarter of 2008. Compliance is required by July 1st 2010. The amendments impact

policies, timing, due dates and payment allocation.

Points of Sale (POS) – Phase 1 A new engine Auth Decision Engine (ADE) is created to

decommission the other rule engines, Real time Decision (RTD), FAST Engine, Tandem Level

Authorization (TLA) to reduce lot of fraud decisions identified by these engines which causes

decline responses for the good customers.

Points of Sale (POS) This project’s scope includes robustness of data at the customer,

merchant and account levels. The system must leverage this data for multiple real time models

and enriched rules to enable a financial evaluation on every transaction. The system will store

information to provide customers the best experience.

Responsibilities

Gained in depth knowledge in Analysis, Design, Coding, Testing and Implementation

•

Support for the Core Authorization team

• Attended meetings to gather business requirements, assimilating them and breaking

them into functional components

• Analyzed and created Statement of Business Needs and coordinated with onsite

teams to come up with scalable design specifications.

• Developed technical designs and implemented changes as per the business

requirements.

23. Modified existing COBOL programs in the required sections like File section, Working

Storage Section, Procedure Division or created new COBOL programs based on the

requirement.

• Developed CICS Screens (using GBBM and SDF) and Online programs (including

ATI transactions) and MQ Programs.

24. Modified Parms, Procs, JCL’s for the COBOL programs.

25. Changed calls to databases like DB2, IMS, VSAM.

26. Made changes to the DB2 tables, IMS segments, VSAM files using the file manager

and other IBM utilities.

27. Used the DFSORT utility in the JCL to make changes to the file contents or layout.

28. Compiled and link edited the COBOL programs.

29. Prepared the unit test JCL and performed unit testing using test files and setting test

data in the DB2 table and IMS segments.

30. Performed unit testing using Expeditor.

31. Prepared Unit Test Scripts and captured the test results with screenshots.

32. Staged the latest code in configuration management tools like Change Manager,

Endevor.

Acted as Team Lead to plan and execute rollout into Unit Testing, Integration Testing,

•

Pre Q testing and Production environments.

Developed the new design for SCORES batch process and worked in the new

•

design for Authorization batch process to tune the performance.

Developed Fraud Strategies derived by Business consulting Group and a SME for

•

the Authorization module in offshore especially in Fraud Strategies.

Developed many value adds, tuned the Performance of the System, reduced the run

•

time of Job flow, stabilized the downstream jobs, reduced lot of manual interventions

and delivered lot of Cost Savings to the team.

Created the performance dashboard to monitor the transactions in Peak Season

•

and also for every release.

Prepared a detailed inventory analysis for Customer’s applications for each and every

•

release.

Involved in doing peer reviews.

•

Rabo Bank, Chennai Jun’06 to Jun’07

1

Role: Associate, Mainframe Developer

Rabobank is an international financial service provider in Netherlands offering

services like retail and wholesale banking. I was a part of the Savings and Management of

Information systems (MIS) team of this bank.

The Project currently involves executing and implementing enhancements to the application in

line with the changing business needs. The team is involved in analysis, design, coding, creation

of unit test scripts, preparing test data and unit testing for the application. The project also

involves System Test and UAT defect support, Release Implementation and post implementation

support.

Responsibilities

33. Coded both Batch and online Modules using COBOL, Procs, JCLS, IMS DB, DB2.

Interacted to add and update data stored in IMS, DB2 database and Coded and tested

•

Database Changes.

34. Prepared Unit test plans and Unit test cases and responsible for unit testing.

35. Tested both Batch and online Modules developed in mainframe environment.

36. Attended Conference with business regularly regarding functionalities, providing

solutions and suggestions for software’s.

37. Provided Line of Estimates for different projects using FP analysis and Cocomo Tool.

38. Provided tracking sheets and status reports on a daily basis.

39. Created traceability matrix to cross verify coverage of test scripts to all project and

test requirements; created expected results traceability to test cases; built test

execution and test step delegation plan; and verified and approved testing cases and

script with client.

40. Analyzed data processing problems for applications to electronic data processing

systems.

41. Environments worked in: IBM Mainframe Z/OS, OS 390,UNIX, TSO/ISPF, JCL,

DB2, COBOL II/III, IMS DB, IBM Utilities, File manager, DFSORT, ChangeMan,

SUPER C, SPUFI, QMF,SAS,PANVALET MS Office Suite,TSRM – Tivoli Service

Request Manager,IBM Rational Clear Quest, SAR, Control M(CTM),DISPATCH,

MAINVIEW,RMM – Removable Media Manager, IBM Fault Analyzer, IBM Application

Performance Analyser.

Education

Master of Business Administration,AnnaUniversity,First Class.

•

Bachelor of Electronics and Communication Engineering, Anna University, India, First

•

Class with Distinction.

Contact this candidate