Summary

• Working knowledConfidential 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 larConfidential Unisys and IBM Mainframe Applications, including databases and in supporting staging and development environments
• Sound knowledConfidential 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 staConfidentials of the software development lifecycle as well as project manaConfidentialment 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 larConfidential 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 ManaConfidentialr (Systems) in Confidential, Noida, from August 2000-March 2001.
• Worked as Project Manager Confidential, from October 1998-July 2000.
• Worked as Jr. ManaConfidentialr (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 CONFIDENTIAL 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 CONFIDENTIAL Capital – Vendor Financial Services For Recognition of Effort in Supporting CONFIDENTIAL 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, ChanConfidentialMan, 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, AConfidentialnt 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 Confidentialnerate 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 ManaConfidentialment 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, debugConfidentiald, 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 chanConfidentials. 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, USA
Project : Travelers Integration (Migration Applications and Data Conversions)
Duration :March 2005 – April 2006
Title : Project ManaConfidentialr
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 knowledConfidential gained from conversions.

• Interact with different groups within the organization like Business analysts and Programmers.
• Client interaction for documenting business processes and requirements
• KnowledConfidential 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 ManaConfidentialment, 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 languaConfidential, 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, ChanConfidentialMan, Citrix Server, HR-Hummingbird Neighborhood, Telnet.

Client : CONFIDENTIAL
Project : ConfidentialnESis
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 Confidentialnerations, 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 ManConfidentialr 
Description : 
Trade Payables Services (TPS) works with suppliers of clients to offer early payment terms in exchanConfidential 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 larConfidential 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 Confidentialtting new business which includes Client interfacing, Proposals Preparations and Negotiations with client Project ManaConfidentialment & 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 manaConfidentialment 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 : Confidential, USA
Project : Easytrieve to COBOL II Migration 
Duration : August 2000 –December 2000
Title : Consultant
Description : Confidential is one of the larConfidentialst mortgaConfidential services with over one million customers in USA. It is one of the companies of CONFIDENTIAL Financial Network family that offers a wide ranConfidential of products and services. The purpose of this project is to convert the existing Easytrieve programs into COBOL. It also includes the chanConfidentials 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 Confidentialnerating the reports, Accessing IDMS records to Confidentialnerate the same related with finance and insurance. There is having total around 56 programs of Easytrieve on IBM 3090. Most programs are Confidentialnerating the reports, Accessing IDMS records and DB2 tables to Confidentialnerate 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.