Summary

• Working knowledge of Micro Focus Cobol, Net Express, Server Express under UNIX and Linux, Oracle, DB2, DMS, IDMS, VSAM, MVS, JCL, ECL on Financial and Insurance applications and Hands-on in Technical specifications, Coding, break fixing, Coding of Cobol applications.
• System implementations, functional definition and design, and data analysis and data conversions. Participated in and led implementation and data conversion projects for major Insurance and financial sectors.
• Extensive experience on Peoplesoft HRMS applications with Oracle 9i / 8i, VSAM, DB2, IDMS databases related to application migration, database installations and Production supports.
• Highly experienced in supporting large Unisys and IBM Mainframe Applications, including databases and in supporting staging and development environments
• Sound knowledge of database loads, PL/SQL scripting in 2-tier and 3-tier application architecture
• Proficiency in working with testing tools and carried our Functional Testing, Integration Testing, Regression and Parallel testing , White Box testing, Black Box Testing, UAT, and Regression Testing of Mainframe and Client/Server Web based applications.
• Fully conversant with all stages of the software development lifecycle as well as project management and SIX Sigma and CMM Level 5 processes.
• Implementation of Six Sigma methodologies at projects level and Organization’s division level. Leadership as Lead Six Sigma Green Belt delivering successful results for business problems.
• Accustomed to working in large data center environments and in handling multiple projects at a time
• Strong in On-site/Off-shore Co-ordination, client interaction and interpersonal skills
• Recognized as highly motivated and able to achieve results in a fast paced environment

Employment History

• Worked at Confidential, Albany, NY as Consultant From October 2006 – February 2013..
• Worked with Confidential, Noida, as a Project Manager from March 2001 - October 2006
• Worked as Assistant Manager (Systems) in Confidential, Noida, from August 2000-March 2001.
• Worked as Project Manager Confidential, from October 1998-July 2000.
• Worked as Jr. Manager (systems) in Confidential, from August 1988 - October 1998.

Training(s)

• TERADATA V12 Released/ V13 Released
• SIX SIGMA GB Training
• QMS /CMMI/ Internal Quality Audits
• IBM S/390.

Achievements

• Received “Certificate of Excellence” from GE Capital – Vendor Financial Services For Outstanding Support of TPS Critical Business Production.
• Outstanding Contribution in achieving CMM level 5 in the year 2002 (Assessed by Lead Assessor).
• Received “Certificate of Excellence” from GE Capital – Vendor Financial Services For Recognition of Effort in Supporting GE Trade Payables Services First Quarter 2003 Projects.
• Certified Six Sigma Green Belts with command over both DMAIC and DFSS processes.
• Skills Summary

Hardware Platforms:
IBM PENTIUM, IBM S/390, UNISYS 1100/2200, VAX-11/780, and ICL3980 MAINFRAME

Databases and Software Tools
Oracle 91,8, DB2, MySQL, MS Access, Microsoft Visio, SQL*Plus, Toad, PL/SQL Developer, Win Runner, File-Aid, QMF, Spufi, Xpediter, Astra Quick Test, Microsoft Project, FOXBASE, IDMS, ADSO, MAPC, DMLO, OLQM, IDDM, Unisys COBOL (ACOB/UCOB) Micro Focus COBOL (5.1), EASYTRIEVE, MVS/ESA, JCL, SyncSort, IDCAMS, VSAM, Vision Builder TSO, TCP/IP FTP, ICLS Data Dictionary, ECL, ASP, HTML, MS Visual Basic, SQR, People Code, PS Query, , PeopleSoft COBOL, Process Scheduler, Application Engine, VSS, Six Sigma (DMAIC and DFSS) APC (Automated Production Control), Info Pac, ChangeMan, Team Play, Kintana, GCOS7, TPS, Bull Mainframe, LifePRO ,DOS, Sever Express 4.0, Net Express, Windows XP/NT/2000, Animator, Personnel Communicator, Power Term, Telnet, TOAD, Case Intake, Polar Express, Agent Ransack, Mantis, WSAD 5.1.2,Eclipes, Teradata, Teradata components(PE, BYNET, AMP and VDISKs), Teradata utilities (BTEQ, FASTLOAD, FASTEXPORT, MULTILOAD, Teradata Administrator, SQL Assistant, PMon).

Experience

Client : Confidential, New York.
Project : Analyst Case processing Systems (ACPS) and eDib Implementation
Duration : October 2006 to February 2013.
Role : Consultant
Description : This application, Analyst Case Processing Systems (ACPS), is being maintained, making Enhancement and ongoing development and used jointly by the Social Security Administration (SSA) and NY Disability Determination Services (DDS). This application will generate following modules:

• Working with maintenance, Enhancement and development team responsible for n-tier client/server based case processing systems.
• Create an application that would provide a view of the local Document Management Architecture (DMA) documents and the local electronic folder (EF) data interfaced for Federal SSA Electronic Disability.
• Create software that will interface with SSA Electronic Folder Interface (EFI) software enabling NY to participate in eDib.
• Performing Technical Analysis and determining conversion requirements and development of conversion specifications, data-mapping specifications, documents.
• Modifying the existing NY legacy system, Analyst Case Processing System (ACPS) to accept and display select data from the Electronic Folder Request and make assertion and prefill data available for the ACUDD application.
• Conversion of more than 1000 Micro Focus Cobol programs from UNIX to Micro focuses COBOL under SuSE Linux environment.
• Development and maintenance of Shell scripts as per the requirement.
• Performed integration, regression and systems Testing and prepared test scenarios.
• Data Analysis and design using Dfed tools on UNIX.
• Development of SQLs and store procedures and also developed extracting and loading processes using MS SQL Server Integration Services (SSIS).
• Loading, backup, restore and maintain VSAM files and IDMS records.

Technology Used: DMS-1100, ECL, DPS, IPF-1100, MF COBOL5.1, Micro focus Net Express  Integrated Development Environment (IDE) on Windows, DfEd, Oracle 10g, IDE tools on SCO UNIX, Linux, Bugs tracker tool (Mantis), IBM Mainframe, COBOL-II, JCL, APC, Expeditor, MVS/ESA, JCL etc.

Client : Confidential
Project : Insurance and Pension Support Application 
Duration :May 2006 – September 2006.
Title : Consultant

Role : 
Developed new payment functionality and processing capabilities using COBOL, TSO/SPF, JCL, Micro Focus Cobol. Developed, tested, debugged, and documented streamlined billing, payment and reconciliation processes in both online and batch environments. Also extensive involved in design and creation of new, and modification of existing programs of life, health and annuity with living benefits insurance for LifePRO software. Automated payments orders and order changes. Files transfer from mainframe to other environment using NDM and SQL. Modification of Stream to run the Batch Interface using Batch Interface program DMBATCH contains the CONNECT; Direct commands as SYSIN input, DMBATCH reads the input stream and processes the requested functions.

I worked on both production support and development of the LifePRO software. The few modules were written in Micro Focus COBOL under Unix environment.

Prepared project and process improvement documents.

Prepared test cased and performed unit and integration testing.

Environment : IBM Mainframe, COBOL-II, JCL, APC, Expeditor, MVS/ESA, JCL, IDMS, ADS/O, MAPC, DMLO, OLQM, IDDM VSAM, NDM,TSO, TCP/IP, FTP, Windows NT, UNIX, LifePRO ,MF-Cobol 3.1, Micro Focus Server Express (IDE) , Micro Focus Net Express (IDE) tools on Windows/Unix, Animator.

Client : Confidential
Project : Travelers Integration (Migration Applications and Data Conversions)
Duration :March 2005 – April 2006
Title : Project Manager
Description :
PeopleSoft HRMS Implementation
Responsibilities includes is assisting Confidential in doing business analysis and business process reengineering, as well as technical analysis and design, for people soft solution for Integrating US and Non-US based Traveler\'s data into Confidential\'s Mexico based PS HRMS application. Apart from US, there are 15 Non-US based Traveler\'s locations. The work involves integration of US and other Global business Travelers\' data with Confidential.

As the data conversion coordinator participated, analyzed the integration/conversion requirements in the migration of portfolios of insurance policy data bases from mainframe system to SQL server platform. Also, Developed the strategy, data mapping, specifications and implementation needs for the conversion.

Tested the Data Converted for Business rules compliance and counted checks and verified.

Modified and developed COBOL programs and jobs. Participated in technical recommendation team and support for implementation and integration of the Policy Premium Payment System (LifePRO) during this time I had to task the QA Testers validating data migration and security. Also involved in pilot project to transfer existing policies over to LifePRO along with achieve data.

Analyzed legacy system data quality and performed data cleanups. 
Provided metrics on data quality and conversion activities. 
Assisted with report development using knowledge gained from conversions.

• Interact with different groups within the organization like Business analysts and Programmers.
• Client interaction for documenting business processes and requirements
• Knowledge Transition
• Development and Support
• Development of macros and store procedures and also developed extracting and loading processes using MS SQL Server Integration Services (SSIS).
• Risk Management, monitoring, Status Tracking.
• Developed new SQR Reports, customization of PS Cobol modules, people Code, store procedures, SQLs.
• Reengineering of Mainframe application to Unix (EFT, Check writing, Headcount etc)
• Update IDMS records, and DB2 Tables. Develop Loading programs and procedures to records into the files to load into Oracle database using COBOL language, SQLs.
• Payroll Tax Upgrades
• Copy and creation of dataset using IDCAMS/REPRO utility
• Loading, backup, restore and maintain VSAM filed using IDCAMS utility
• Production support

Environment :
ERP (PeopleSoft) 8.4 Application Designer SQR, PeopleCode, PS Query, Database (Oracle, SQL), Windows NT, UNIX, MF-Cobol 3.1, Micro Focus Server Express (IDE) , Micro Focus Net Express (IDE) tools on Windows/Unix, IBM S/390, MVS/ESA, MQ Series, Vision Builder ,COBOL II, DB2, IDMS, MS SQL Server, JCL, IDCAMS, REPRO, LifePRO, SyncSort, VSAM, TSO, TCP/IP FTP, ChangeMan, Citrix Server, HR-Hummingbird Neighborhood, Telnet.

Client : Confidential
Project : GenESis
Duration :August 2004 – March 2005
Title : Onsite Co-ordinator
Description :
Peoplesoft Pension Implementation

• Involved in Maintenance and Enhancements to
• Retiree Administration Module
• Periodic Pension Calculator Module
• Life Events Modules
• Modified PeopleSoft delivered COBOL for Retiree Payments, Withdrawals, Pension Calculations, etc.
• Developed new SQR Reports for Group generations, Current Year Contribution and Annuity Audit, Supplementary Plan Retirements, Deduction Balance Compare Report, Review Trustee Extract Summary, etc.
• Technical implementation of the gaps in 4 custom web applications and related PeopleSoft batch processes (SQRs and COBOL).
• Compile, test, and debug COBOL programs with Net Express 3.1
• Synchronized other customized SQRs with PeopleSoft HCM 8.8 and People Tools 8.4 SP1.

PeopleSoft: PAYROLL FOR NORTH AMERICA

• Involved in Payroll Integration Projects, which required setting-up pay groups, earnings and deduction codes etc.
• Enhancing payroll interfaces and retrofitting existing business processes and applications to those of acquired business units.
• Designed and implemented enhancements to - Payroll Roll Register process, Pay Run ID creation process.

Role : Onsite Coordinator, Involved in preparation of Functional and Technical specification for Peoplesoft SQR and PS-Cobol. Development/Testing online customization requests, new SQRs and Interfaces and COBOL enhancement as per business requirement. Interacting with the Client, Functional leads for data analysis , designing, mapping and migration. Developed cursors, SQLs and stored procedures

Environment : ERP (People soft) 8.4 Application Designer SQR, PeopleCode, PS Query, Database (Oracle, SQL), HTML, XML, MF-Cobol 31, Micro Focus Server Express (IDE) , Micro Focus Net Express (IDE) tools on Windows/Unix, S/390, MVS, COBOL II, DB2, VSAM, Vison Builder, SyncSort, and JCL, APC.

Client : Confidential
Project : Trade Payables Services (TPS)
Duration :March 2001 – July 2004
Title : Project Manger 
Description : 
Trade Payables Services (TPS) works with suppliers of clients to offer early payment terms in exchange for discount on purchases. The discount dollars are split between VFS and its clients to boost net income, or to extend net payments dates for significant cash flow benefits. 
Project involved Maintenance/Production Support and medium-to large enhancement in DB2/Cobol environment.

Role : As Tech Lead, my responsibilities include Provide Client IT enabled Technical Solutions to client Convert the business requirement to technical requirements Develop High-Level design & associate in complex low-level/detail designs Data Analysis and development of cursors and SQLs Getting new business which includes Client interfacing, Proposals Preparations and Negotiations with client Project Management & Project Reviews Active Member in Quality Initiatives - One of most successful has been in Uniform Estimation across Converting Business Requirements into Technical Requirements As a Technical Expert, mentor the teams when a new project begins Completed coding/testing of several Detail Account Monthly Reports for new COA structure using Report builder tool.

• Ensuring adherence to Quality process (SIX SIGMA & SEI CMM Level 5)
• Implemented Six Sigma project and saved couple of thousands US dollars by optimizing the number of vendors for and standardizing similar parts across various manufacturing units to simplify the inventory process.
• Implementation of Software Configuration management in Major mainframe applications as well.

Environment : IBM S/390, VSAM, COBOL-II, SPUFI, DB2, VSAM, TSO/ISPF,, JCL, IDMS, ADSO, , MQ-Series, QMF, SDSF, FILE-AID & EXPEDITOR, QA-tools, Sigma tools(Failure mode & Effects Analysis(FEMA), Pareto Chart, Statistical process Control, Trend chart, Fishbone(Ishikawa) diagram, Design of experiment, etc), Astra Quick Test, Win runner, APC.

Client : ConfidentialUSA
Project : Easytrieve to COBOL II Migration 
Duration : August 2000 –December 2000
Title : Consultant
Description : Confidential is one of the largest mortgage services with over one million customers in USA. It is one of the companies of GE Financial Network family that offers a wide range of products and services. The purpose of this project is to convert the existing Easytrieve programs into COBOL. It also includes the changes in related components like procedures and jobs. The new Components are intended to provide the same functionality and outputs as that of the original ones. Prototyping is done and shared with the client. There is having total around 800 programs of Easytrieve on IBM 3090. Most programs are generating the reports, Accessing IDMS records to generate the same related with finance and insurance. There is having total around 56 programs of Easytrieve on IBM 3090. Most programs are generating the reports, Accessing IDMS records and DB2 tables to generate the same related with finance and insurance.

Role :

• Ensuring that the team meeting all deliverables within the specified time by Providing Technical support to them.
• Analysis of JCL & Easytrieve Programs, Writing specification
• Preparation of JOB specifications.
• Coding of Programs. Analysis of Data and files
• Development of cursors, SQLs
• Review of program specifications, programs and Unit & Integration Test plans.
• Unit testing/Integration Testing.
• Integration of all COBOL programs into JCL.
• Checking-out the programs and staging of deliverables using Automated Production Control.
• Ensuring that all the work meets the client’s expectations, standards and SEI- CMM Level 5 quality process.

Environment : IDMS, VS-COBOL II, COBOL, DB2, VSAM, TSO, JCL, DMLO, Expeditor, Easytrieve, APC.

Client : Confidential
Project : Insurance Investment Linked System
Duration : December 1999 – July 2000
Title : Consultant
Description : IL system used IDMSX database and TPMS transaction processing system. All additional benefits on Investment Policies are held on LIFEDATA, and Investment linked interface to pickup the premium and some benefits details. There is no interface between person details held on Investment Linked with those held on Life data. Bills all direct paying policies and create notices to be sent out. Next action records that indicate when a policy is to be billed control the billing process. IDMS- IL system uses the iDMSX database system. This is a network type database.
TPMS- IL uses TPMS system in a very hierarchical way. One navigates from screen to screen using menus and submenus in contract to Life data where can go directly from screen to another.

Environment : ICL/VMS, SCOBOL, SCL, IDMSX,MS-Office(EXCEL, Power Point, MS-Access)

Client : Confidential
Project : Year 2000 Conversion Project
Duration : November 1998 – October 1999 
Title : Consultant
Description : Conversion of COBOL Programs into LE COBOL Environment and also Y2K compliance on Unisys Cobol Programs. All verbs that are not compatible in LE environment will be changed as per requirement of LE- 390 environment. Relevant changes will be done in the source code statements, which give severe errors while compiling in LE-COBOL (e.g. any character after period which is ignored by OS/VS COBOL, Comparison of Numeric field with alphanumeric value etc.) Wherever in ISAM file primary key and Alternate key is same and Alternate key is defined as duplicate, this is a conflict in case of VSAM. These issues will be discussed with UNNY on a case to case basis and if required files layout will be revised. Year 2000 Conversion for following Subsystems:
New York Payroll, Mobility Hardship, Taxation, Head Quarter Payroll
Role : Understanding and walkthrough of Client\'s systems and processes, impact analysis, remediation and unit testing of the pilot systems. Guiding the offshore team members for impact analysis of the various systems, discuss the methodologies for the testing process for the various systems, review the remediated code, Analyzed Data and testing of the various modules, interact with the on-site team. Developed Subroutines in COBOL for date manipulation. Participation in the verification and validation and Quality assurance.

Environment : UNISYS 1100, COBOL / DMS-1100, IPF-1100, IBM S390, COBOL, and IDMS, ADSO, COBOL II, COBOL, VSAM, DB2, TSO, JCL, DMLO, Expeditor.