SUMMARY:

• Senior IT Analyst, practically 7 years of experience in the development, maintenance and enhancement of Mainframe applications as well as Client Server Applications
• 5 yrs of experience in Financial Services industry, focusing on Private Products for the retail banking industry
• Sound knowledge of Managed Accounts in financial industry
• Over 1 year of experience of Legacy Conversion Project from one version to another version thru VSAM and DB2
• Extensive experience with Requirement Gathering, System Analysis, System Design, Development, Testing, Implementation of application projects and Interaction with Clients
• Sound knowledge of MVS, COBOL II, JCL, VSAM, CICS, DB2, MS SQL, EZYTRIEVE
• Experience in development of CICS screens thru the SDF Screen Development Facility
• Sound knowledge on Fileaid for DB2
• Worked on various IBM tools TSO/ISPF, File-aid, with hands on experience on debugger tools like InterTest, Expeditor
• Extensively used ChangeMan as version conroller
• Achievement oriented with an ability to manage change with ease. Willing to learn and upgrade skills
• Documentation of deliverables like Low Level Design Document, Detailed Design Document, Test Case Document & Test Results
• Prepared Implementation plan, best practices, created document for achievements & learning from the projects
• Thrive for continuous process improvement to keep client in delighter zone
• Good communication skills, interpersonal skills, presentation skills, self-motivated, quick learner, team player
• A self-motivated person and has proved to be a good team leader who possesses good organizational qualities as well
• Technical expertise to provide Services and solutions that consistently exceeds client's expectations
• Capable problem-solver who develops feasible solutions considering business & technical perspectives
• Followed SEI-CMM-5 process standards,
• Implemented Defect Prevention Process and created awareness about the quality process among the team members
• Received Appreciation from TCS for quality adherence and Best Team
• Conducted Internal quality assurance audit for many projects while working in TCS
• Achieved the ITIL certification for Information Technology for Infrastructure Library
• Awarded DB2 certification by IBM

Job Functions

Business/Sr. Programmer/Systems Analyst, Project Management, Configuration Management, Knowledge Management representative and Internal Quality Auditor

Languages

COBOL DB2, VSAM, JCL, CICS, Ezytrieve, XML

Tools

MS Office: Word, Access, Excel, PowerPoint, Visio

DBMS

DB2

Front End/GUI

CICS

OS/Environment

MVS (OS/390), Windows NT, 2000

Other Tools

FILEAID, FILEAID for DB2, INFOX,TWS, ISPF, TSO, XPEDITER, INTERTEST, SYNCSORT, SPUFI, QMF, SAGTRAN

Quality Functions

SEI-CMM-5 process standards,
Internal Quality Auditor

ITIL Process

Peregrine Service Center

EXPERIENCE:

• Working as a Sr. IT Analyst for Confidential, since February. 2006
• Sr. Programmer Analyst for Confidential, from April 2004 to Feb 2006
• Programmer Analyst for Confidential, March 2003 to April 2004

PROJECT:

01/08 - Present Confidential, NY

Separately Managed Accounts is the maintenance and development project, which has 5 applications. The application are NDA(Non Discretionary Accounts), DMP(Discretionary Management Program), MDA(Multiple Disciplinary Accounts), IAC (Investment Advisory Consultant) and PAD (Portfolio Advantaged Accounts). Each application handles one product. Here all the products having the common feature of being the managed account. Managed account means one manager handles all the accounts of the customers. Each account contains the diversified class of shares in it. So the manager charges the percentage or fee schedule for managing the account.

The accounts that are managed under various applications had lot of maintenance support to be handled. The new features and functionality keeps on adding and changing due to the change of market. The technology is mainly on mainframes using stored procedures.

Role & Responsibilities:

• Sr. Programmer Analyst for Application Team
• Estimation of efforts for project requirement
• Gathering requirement & creating high level design document, analyzing the existing system for future enhancement
• Coordinating Business Meetings with IT, Design Discussions with different IT teams, Planning on different levels of Testing and Implementation
• Responsible for coding, unit and integration testing of the application
• Working with DBA for new enhancements in the database
• Implemented the project on extensively tight schedules.
• Worked with the front end team, coordinating the ASP.NET application look and feel
• Created lot of stored procedures, which are called by ASP.Net application from front end
• Designed lot of CICS MAPS and CICS programs
• Used CICS web services
• Created Stored procedures, which are dual mode i.e OOPS module and Storproc
• Interacting with users for issues related to production
• Worked on Peregrine Service Center to request for database structure changes and creation
• Documentation of deliverables like detailed design document, test case document and test results
• Coordinating with System testing & UAT team
• Onsite Coordinator for Production Support Team and QA Support Team
• Worked on OMEGAMON to monitor the jobs and performance

Environment: COBOL, JCL, DB2, CICS, INTERTEST, TSO/ISPF, File-Aid, SPUFI, SAGTRAN,File-Aid for DB2

10/07 - 01/08 Confidential, Stanley, NY

VPN (Virtual Private Network automation) is the workflow automation provided to the Morgan Stanley's external managers. Here external managers mean financial advisors, who are not the part of Morgan Stanley's financial advisors. As the customer decides to open the account in the morgan Stanley, he has to send the papers to the branch, which usually takes 7 days, which is time consuming, to overcome this time, design is made to update the manager of branch to incept the account and the papers will be following. This automation is done thru mainframes stored procedure.

The managers should get all the accounts which are waiting for their acceptance in their purview. As soon as they see the accounts and their account holdings, they have an option of accept or reject the account for inception.

Role & Responsibilities:

• Sr. Programmer Analyst for Application
• Worked with the front end team, coordinating the ASP.NET application look and feel
• Created lot of stored procedures, which are called by ASP.Net application from front end
• Designed lot of CICS MAPS and CICS programs
• Created Stored procedures, which are dual mode i.e OOPS module and Storproc
• Interacting with users for issues related to production
• Worked on Peregrine Service Center to request for database structure changes and creation
• Estimation of efforts for project requirement
• Gathering requirement & creating high level design document, analyzing the existing system
• Coordinating Business Meetings with IT, Design Discussions with different IT teams, Planning on different levels of Testing and Implementation
• Responsible for coding, unit and integration testing of the application
• Working with DBA for new enhancements in the database
• Interacting with Clients for issues related to enrollment data
• Documentation of deliverables like detailed design document, test case document and test results
• Coordinating with System testing & UAT team

Environment: COBOL, JCL, DB2, CICS, INTERTEST, TSO/ISPF, File-Aid, SPUFI, SAGTRAN,File-Aid for DB2

02/06 - 10/07 Confidential, Morgan Stanley, NY

Management Services support provides services to its clients like providing investment consulting data to the financial investment companies. MSS provides Client data, specified by its clients to cater their requirements. The client data has to be catered according to their requirements and has to be delivered to their end using NDM.

This project provides the required data to the down stream system PWM. We receive the information from trading systems. There are two types of information which we provide to GIMII are Client Data Mapping(CDM) and Transaction Data Mapping(TDM).Morgan Stanley being a central repository of financial data, clients gets their accounts information thru morgan Stanley to tweak to their requirement.

Role & Responsibilities:

• Sr. Programmer Analyst for Application Team
• Estimation of efforts for project requirement
• Handled the production support team and QA support team
• Gathering requirement & creating high level design document, analyzing the existing system.
• Interacting with DBA team for understanding the logical and physical model of the system
• Doing gap analysis for defining the relationship between the DB2 tables
• Did Regression system for the critical flow of jobs
• System and integration system
• Guiding & supporting junior team members in their day to day activities
• Responsible for coding, unit and integration testing of the application
• Documentation of deliverables like detailed design document, test case document and test results
• Monitor and review the quality of work being delivered for other team members
• Accountable for final delivery of work to the client
• Finding the defects thru the test director and fixing ASAP.

Environment: COBOL, JCL, DB2,TSO/ISPF, File-Aid, SPUFI, QMF

08/05 - 01/06 Confidential, Citibank, NY

Confidential, business required to have a billing system wherein the pricing should be done to their products automatically periodically and the reports are to be generated monthly quarterly and half yearly.
Confidential, planned to buy pricing product install it in its existing system, Suntec is the company which provided the product and iflex provided the system study of the existing the interfaces. Input and output interfaces of the mainframes system was huge that took lot of time analyse and jot down the each every data field with that of the other external interfaces of the system.

Role & Responsibilities:

• Technical Analyst for Data supporting for the product.
• Understanding Business Requirements and converting to IT specifications
• Estimation of effort project requirement
• Analysis & Design of business requirement
• Creation of technical specification document for the development team
• Co-ordinate with developers to make sure all business requirements are covered during code development
• Coordinating Business Meetings with IT, Design Discussions with different IT teams, Planning on different levels of Testing and Implementation
• Managing Issues, Interface lists and Test cases during execution of Project
• Co-ordinate Unit testing efforts
• Co-ordinate with QA team to carry out System test & UAT
• Monitor and review the quality of work being delivered

Environment: COBOL, DB2, VSAM, SQL, XSL-FO, XML

10/04 - 08/05 Confidential, Singapore

Confidential, business required to introduce some new products. The products are nothing but the services to the customer where each service is considered as the product and each product is priced accordingly to the customer.
The proper workflow is required from the selection of the product by the customer till the acceptance of the top senior business relationship manager. The automation of this process is done in this project.
Customer requires the counseling for the products will place call and wherein a call representative will fix an appointment with the business analyst to the customer. Upon meeting customer selects the product. The product selection form is uploaded, screening is done for the same and entire cycle of work flow is carried out from the manager to the senior BRM. Atlast the BRM has approved then the product is incepted and service is started and product is priced.

Role & Responsibilities:

• Technical Analyst for Pricing Automation project
• Created technical specification documents
• Implementing this project on iflex mainframes was big challenge
• Citibank didn't provide its mainframes so we did on iflex owned mainframes system
• Worked very closely with DBA's to setup the PPT entrys and Dbase design
• Understanding Business Requirements and converting to IT specifications
• Estimation of effort project requirement
• Analysis & Design of business requirement
• Creation of technical specification document for the development team
• Co-ordinate with developers to make sure all business requirements are covered during code development
• Coordinating Business Meetings with IT, Design Discussions with different IT teams, Planning on different levels of Testing and Implementation
• Construction of Project Plan, Testing Plan and Implementation Plan
• Managing Issues, Interface lists and Test cases during execution of Project
• Co-ordinate Unit testing efforts
• Co-ordinate with QA team to carry out System test & UAT
• Monitor and review the quality of work being delivered

Environment: COBOL, JCL, DB2, CICS, INTERTEST, TSO/ISPF, File-Aid, SPUFI, QMF

04/04 - 10/04 Confidential, Development, NY

Deutsche is implementing the trading system for buy and sell of the securities of its customers wherein the system requires to update the database immediately as soon as the transaction occurs, so stored procedures where used to achieve this functionality. About 17 stored procedures are written to do various database activities. This was complete development of the stored procedures from scratch.
Due to security issues deutsche bank didn't give the connectivity of their system. So this was the huge challenge and complete database system was replicated into the local company owned mainframes system. We executed ran the DB script on our system and then started writing SP.

Role & Responsibilities:

• Understanding Business Requirements and converting to IT specifications
• Interacting with DBA to install the Database Script
• Understanding of the logical design of the database
• Estimation of effort project requirement
• Analysis & Design of business requirement
• Creation of technical specification document for the development team
• Co-ordinate with developers to make sure all business requirements are covered during code development
• Coordinating Business Meetings with IT, Design Discussions with different IT teams, Planning on different levels of Testing and Implementation
• Construction of Project Plan, Testing Plan and Implementation Plan
• Managing Issues, Interface lists and Test cases during execution of Project
• Co-ordinate Unit testing efforts
• Co-ordinate with QA team to carry out System test & UAT
• Monitor and review the quality of work being delivered

Environment: COBOL, JCL, DB2,INTERTEST, TSO/ISPF, File-Aid, SPUFI, QMF

03/03 - 04/04 Confidential, WI

General Casualty is a property and casualty insurance provider headquartered in Sun Prairie, Wisconsin. GCC also covers the commercial property insurance.
As part of the requirement, GCC being the old usage of the copybooks and its size of the numeric fields haven't increased since long. So now as the business growing great it had to expand all the amount fields. The amount fields means the premium fields, claimed amount fields and etc.

Version 6 to version 7: The old amounts fields being the version 6 and the new size of the fields being the version 7. As part of this change, the entire systems i.e. modules are being affected like the statements, receipts and reports. So a detailed analysis of the system change impact is conducted to vigil the change. All the copybook layouts , input file and output files to the downstream and upstreams are listed as part of this change and impact of the programs to be changes were in huge number.

After the change the unit testing and system integration testing is done to reflect the business in proper shape.

Role & Responsibilities:

• Ensuring On time processing of Client Settlement file as per the SLA (Service Level Agreement)
• Perform technical program analysis; develop technical specifications for enhancements / system fixes.
• Solve job abends, identify application changes and analyze change requirements for GUI screens & interface files.
• Analyzing user Requirements
• Make sure that the team follow all the quality process for SDLC tasks
• Coordinating with various teams in the event of production issues
• System support during total outage scenarios
• Understanding Business Requirements and converting to IT specifications
• Acted as a coordinator between the business and the technical applications development staff
• Coordinating Business Meetings with IT, Design Discussions with different IT teams, Planning on different levels of Testing and Implementation
• Identification of the problems, researching alternatives, preparing presentations, driving solutions, testing to confirm, gaining consensus, and implementing solutions
• Working effectively within a fast-paced environment to resolve problems and implement change in a timely manner

Environment: COBOL, JCL, IDMS, ADS/O, DB2,Intertest, TSO/ISPF, File-Aid.

PROFESSIONAL CERTIFICATION & EDUCATION:

• Bachelor of technology in Computer science and engineering
• Post Graduation Diploma in Business Administration
• ITIL Certified
• DB2 Certified
• Internal quality Assurance Auditor