Personal Synopsis:

Mainframe Developer with over eight years experience performing analysis, development, enhancements, testing and Production Support Mainframe Projects. My assignments include business analysis (interviewing end users and gathering requirements), systems analysis, design, development, coding, testing, debugging, implementation, conversion, auditing, reconstruction, and documentation.

Related experience includes:

• Worked directly with clients to gather requirements and report project status to mitigate risks and issues
• System Design, Development, Testing, Implementation, Production Support and Maintenance
• Worked within IMS DB/DC Platform, coding in COBOL and QUIKJOB, JCL, CICS, DB2 and Web Applications
• Total IT experience of 8+ years working entirely on Mainframes.
• Worked extensively on development, maintenance and support of mainframe applications as Senior Programmer analyst.
• Actively involved in all stages of Software development lifecycle including Requirements Analysis, Estimation, Database design, High level design, Detailed design, Coding/Testing//Review, Integration testing, Installs and scheduling
• Extensively involved in Production support of mainframe systems. Given Beeper support for our systems during the nights and weekends. Directly coordinated with the Tech groups in ensuring correct and instant fixing of the Production Job happens during the nights.
• Worked on the performance optimization of the existing mainframe Online and Batch systems. Identified the necessary changes required in the system parameters and design, which will enhance the performance of the system.
• As a senior member of my team, extensively involved in the review of COBOL and JCL and codes, Test plans and Test results of team members. Participated in of Group reviews of the designs of systems belonging to other projects because of my knowledge in design and implementation of Mainframe systems.
• Also worked as the Onsite/Offshore model for Software development with the offshore team being present in India. Worked as the Onsite Coordinator of the team.
• Excellent team player with strong team leading and interpersonal skills. Excellent communication and probing skills, especially in coordinating with the Business users in getting their requirements.
• Expertise in usage of Microsoft office soft wares - Word, Excel, PowerPoint, Visio, and Project.
• Create report design templates using Crystal Reports
• Apart from my profound technical skills, I have knowledge about the industry best processes and standards for creating best-in-class software systems. My designs will be simple, efficient, and flexible for easy future maintenance and enhancement.

DATABASES/FILE STRUCTURE DB2, IMS DB/DC, DL/I
OPERATING SYSTEMS IBM Mainframe MVS & VSE, DOS
SOFTWARE / TOOLS Fileaid, Changeman, Xpediter, SAR, QMF, SPUFI, FIXIT, INTERTEST, CICS, XML reporting, VSAM, Visual Studio, Dream Weaver, ASP.Net
LANGUAGES COBOL, JCL, Easytrieve Plus, SQL, QUIKJOB, Assembler, HTML, XML, Visual Basic

Dec 2007 - Present

Client: Confidential
Domain: Confidential
Location: Concord, NH
Position: System Analyst

Project: New HEIGHTS (New Hamshire State Government health and welfare project)

Project Overview:
New HEIGHTS is a large-scale, client/server, interactive welfare system for the state of New Hampshire that automates: Client Registration (CR), Application Entry (AE), Standard Filing Unit (SFU), Eligibility Determination, Benefit Calculation (EDBC), Benefit Issuance, Benefit Recovery, Caseload Management, Security Maintenance, Client Notices, Employment & Training for the Temporary Assistance for Needy Families (TANF), State Adult Cash Programs, food Stamps, Child Care, Foster Care, Adoption Subsidy and Medical Assistance Programs. The system also interfaces with Child support, MMIS, Managed Care, Electronic Funds Transfer (EFT), Electronic Benefits Transfer (EBT), NADA and many federal data exchanges. The system also provides an automated facility for the administration of various public assistance programs and supports the information needs at the office and State level.

Department of Education : One of the particpating projects was to provide the list of children who are eligible for getting free meals at school under the National School Lunch Program. Any child getting the benefit of Food Stamp or any Family cash and is between the age of 2 and 21 will be eligible for this program. This list will be sent to the department of education via FTP to a secure online site.

Medicaid Management Information System (MMIS) : Send a file to MMIS every night includes client's Demographics (DM), Eligibility (EL), Case Head Information (CH), Third Party Liability (TP), Nursing Homes (NS), Pregnancy (PG), Legally Liable County (LC) Medicare Part A/B (PT) HCBC (EC) and Replacement Card Requests (RC) when the individual requesting is eligible for Medicaid or Medicare.

• MMIS is a one-way interface, informations are always sent to MMIS from New HEIGHTS and there are no information coming back from MMIS. New HEIGHTS sends information using two processes. They are as follows
• A) Daily Process: - In this process, informations that are modified/added on the day of run are processed and sent to MMIS with an exception for patient liability (PL), where all the informations available for an individual are sent, just like the re-trigger process. Also for third party liability insurance (TPL) we send all the information available if TPL record is sent due to eligibility record (EL) and only the current modified ones if we send TPL due to a trigger received.
• B) Re-Trigger Process: - In this process all the information available for a case is processed and sent to MMIS. This process can be initiated at case level only and this process take precedence over daily process. Replacement card (RC) record won't be processed in re-trigger. But if there exists a request for RC on the day of run then RC record will be processed.
• New Heights application is designed to generate a trigger whenever a user enters new information or changes the existing one. At the end of the day when we run our batch cycle MMIS process picks up these triggers and convert them in to appropriate record types, which is send over to MMIS.

Responsibilities:

• Experience in Cobol, DB2, Endeavor, FTP
• Created new DB2 and COBOL batch programs from scratch.
• Designed the format of the report.
• Create FTP and Email jobs for all the reports for each day
• Created test scripts and other deliverables.

Environment: DB2, Cobol, JCL, CICS, Endeavor, XML reporting, FTP, Microsoft visio

June 2007 - Nov 2007

Client: Confidential
Domain: Financial
Location: Chicago, IL
Position: Developer

Project: Email Access Restoration

Project Overview:

File transfer protocol (FTP) of all the emails being sent to the clients from Goldman Sachs database on various financial matters from UNIX to Mainframe and Vice Versa. Other emergency compliance tasks like creating the option transfers exception reports, taking care of all the enrolled option exchange firms etc that involved extensive interaction directly with the users to gather the requirement.

Responsibilities:

• Experience in Cobol, DB2, Endeavor, Panvalet, FTP
• Created new DB2 and COBOL batch programs from scratch.
• Designed the format of the report.
• Installed using Endeavour and Panvalet.
• Identify all the reports that need to be restored and FTPed to UNIX.
• Identify the Access file ids corresponding to these reports for email to UNIX.
• Testing of FTP job and confirming the data being FTP at the target location.
• Create FTP and Email jobs for all the reports for each day
• Submitting these jobs with respect to each day. Verifying the data being transferred to the UNIX server by looking into the mainframe dataset that is extracted.
• Once the jobs for one particular day are done, the email reports from UNIX are verified with the restored report dataset.
• Designed and developed web pages using ASP, HTML, JavaScript, CSS
• Designed and developed User entry screen and layout screens

Environment: DB2, Cobol, JCL, Endeavor migration, Panvalet, ASP.Net, Visual Studio, Visual Basic, HTML

April 2004 - May 2007

Organization: Confidential
Client: Confidential
Domain: Financial
Location: Pune, India / Wooddale, IL
Position: Team Lead & Developer

Project: Consumer Lending - Loan Origination System

Project Overview:

The objective of this project is to enhance the Loan Origination System for all the products offered by HSBC in North America and Canada to customers. The enhancement involved developing a Pricing Engine which will decide the most appropriate rate that can be offered to a customer based on the predefined state law approved rates and the customer's credentials.

Responsibilities:

• Maintain database of Household Bank customers. Technologies used are SQL, COBOL, JCL, MVS, IMS DB/DC, DB2, QUIKJOB, and Power Builder.
• Involved in technical discussions to assist team members with resolving any technical issues
• Design and development of programs using COBOL, DB2, JCL and Endevor. Coding in QUIKJOB
• Designed and developed HTML & JavaScript template for front-end screen using Visual Studio.
• Performed Client side validation using JavaScript
• Designed and Developed knowledge portal using HTML, ASP, JavaScript, XML
• Servicing enhancements, bug fix and production support requests. Provide solutions for production defects
• Performed coding and testing of high priority tasks. Deliverables were reviewed as per ISO standards
• Conducted front end testing.
• Environment: Cobol, JCL, IMS DB/DC, DB2, QUIKJOB, SQL, HTML, JavaScript, Visual Studio

Project: Vision Support

Project Overview:

The objective of this project was resolving any critical production issues in the loan origination system in a very quick turn around time.

Responsibilities:

Resolved trouble tickets regarding production issues. Analyzed the cause of the issue and suggested the appropriate solution for the problem, ensuring that the changes made did not have a negative impact on the existing workflow.

• Analyzed Assembler programs
• Coded DB2 programs.
• Fixing production issues on a high priority basis.
• Environment: Cobol, DB2, Assembler, JCL

Project: Compliance Audits

Project Overview:
The objective of this project was to generate report related to any compliance needs. Most of the requests were adhoc based which was to be delivered on emergency basis after generating the required report from the system database.

Responsibilities:

• Generated reports per project criteria and analyzed and resolved emergency tasks. Developed new programs to resolve emergent project issues.
• Technology used: IMS DB/DC, COBOL, and JCL
• Design and developed a computerized system to track customer's credit history.
• Code and test programs, prepare test cases, generate report of findings, participate in conference calls to discuss the issues and provide bug fixes and production support requests
• Used Expeditor to expedite the program written to capture the area of defects. Used FIXIT to view and modify data in IMS DB platform.
• Environment: IMS DB/DC, Cobol, JCL, FIXIT

January 2004 - Mar 2004

Organization:Confidential
Client: Confidential
Domain: Insurance
Location: Pune, India
Position: Team Lead and Developer

Project: Payroll Management of the employees

Project Overview:

The objective of this project was to develop a payroll system for the employees.

Responsibilities:

• The project is a power builder based application used for managing payrolls of the employees. It was developed for attendance and leave details, provident fund, income tax, and professional task of the employees.
• Modules - Attendance Module, Leave Module, Income Tax Calculator, Investment Details Module, Pay Slips Module with the backend as DB2 tables for maintaining the data.
• Involved in technical discussions to assist team members with resolving any technical issues.
• Design and development of programs using Cobol, DB2, CICS, TSO, ISPF and JCL. Coding in QUIKJOB
• Servicing enhancements, bug fix and production support requests. Provide solutions for production defects
• Performed coding and testing of high priority tasks. Deliverables were reviewed as per ISO standards
• Conducted front end testing.
• Environment: Cobol, DB2, CICS, TSO, JCL, QUIKJOB, Changeman

May 2001 - December 2003

Organization: Confidential
Client: Confidential
Domain: Finance
Location: Mumbai, India
Position: Developer

Project: PDO NDS Computerization

Project Overview:
This project is the computerization of the entire Primary Market and Secondary Market and its Subset's operations. The technologies used are DB2, CICS, VB, MQ Series, SQL, C++ and Oracle 9i. Oracle is used as the Member end database whereas DB2 is used as the Host End Database. The entire coding is done in TCS proprietary software language Q++ that is converted into C++ coding in Mainframes. MQ Series is used for navigation of data.

Responsibilities:

• Technologies used: DB2, CICS, VB, MQ Series, SQL, C++ and Oracle 9i. Oracle is used as the member end database whereas DB2 is used as the Host End Database. A proprietary software language Q++, which was later converted into C++ coding in Mainframes, performed coding. MQ Series is used for navigation of data.
• Performed coding and generated reports.
• Designed report templates in Crystal Reports
• Worked on tools such as QMF and SPUFI for updating data and queries in DB2 tables.
• Provide production support by responding to client issues and updating data in the DB2 tables at the back end.
• Involved in testing of new phase.
• Worked within the development team, working towards providing interface to RTGS (Real Time Gross Settlement) operations and enhancements in the existing phase of PDO (Public Debt Offices) across various branches in India.
• Designed and developed data dictionary using HTML, JavaScript, CSS and Dream Weaver
• Environment: DB2, C++, SQL, MQ Series, VB, Crystal Reports, JavaScript, Dream Weaver, HTML.

Project: Recovery Management System

Project Overview:
This project was to computerize the system that maintains the customer's credit history for those who do not pay in time, bad debit records. The higher managerial people will take action as per the reports. They can also decide whether that particular account should be handling by the in-house people or give it to some third party to recover the money back. Technology used is IMS DB/DC, COBOL, and JCL.

Responsibilities:

• Technology used: IMS DB/DC, COBOL, and JCL
• Design and developed a computerized system to track customer's credit history.
• Code and test programs, prepare test cases, generate report of findings, participate in conference calls to discuss the issues and provide bug fixes and production support requests
• Used Expeditor to expedite the program written to capture the area of defects. Used FIXIT to view and modify data in IMS DB/DC platform.
• Used CLIST for splitting of files, copying and backups
• Exposed to CHANGEMAN for production releases
• Environment: IMS DB/DC, Cobol, JCL

EDUCATION SUMMARY

Electronics and Communication Engineering
HSC - Computer Science