SUMMARY

• More than 9 years of professional experience in all phases of Software Development Life Cycle including System Study, Analysis, Design, Programming, Implementation and Administration. Providing real time problem determination support for all dependent business applications. Analyze dumps, traces, and logs in order to determine root cause of specific problem.
• Efficient in documenting existing processes, preparing Business Requirement Documents (BRD), analyzing Business Requirements, working with Requirements Traceability Matrices (RTM), re - engineering business processes
• A key liaison for Middleware Services and provide on call support around the clock for all business critical issues.
• Experience working with DB2, IMS,ORACLE,TERADATA and SQL Server databases.
• Experience in working with distributed environments,mainframe environments.
• Experience with high level language as java along with legacy system languages like COBOL,CICS
• Experience in mentoring/grooming other team members.
• Performance Tuning for application optimal performance.
• Leadership and interpersonal skills with an ability to interact with individuals at all levels.
• Excellent Technical, Analytical, Problem Solving, Oral and Written Communication skills.
• Utilized COBOL,JCL,VSAM,DB2,stored procedures,QMF, IMS; File-aid, TSO on an IBM Z/OS platform
• Extensive Policy Admin Consolidation experience - 2 major Life and Annuity Policy Administration conversion projects for major North American Insurance clients, collectively comprising over 250K UL, Term, Trad and Annuity contracts spread over 100 products.
• Insurance Project Experience includes - Product Development, design, development, core. Customization & Configuration on Vantage One for UL, VUL, Annuity products.
• Application Maintenance & support of 7 different insurance and annuities products, Product Development - Customization & Configuration on Vantage One for UL, VUL products.
• Experience of Service pack upgrade of Vantage One - for Product Wizard implementation, e-Cobol conversion and VP/MS integration for a Vantage One, Universal Life policy admin application.
• Experience on loading and creating different kind of extracts for HR management system.
• ALMI certification from LOMA, Extensive domain knowledge in Life & Annuity business life cycle - underwriting, illustrations, customer service, claims, investments, compensation & compliance.
• Extensive data mapping, business requirement gathering and functional testing knowledge thru key product & peripheral implementation experience over a decade.

TECHNICAL SKILLS

Operating Systems: AIX, Unix, HP UX, Linux, Windows, MVS.

Languages: Java,C, SQL, PL/SQL,COBOL, JCL, CICS, REXX, Eazytrieve, java

Monitoring Tools: Jobtrac, TWS,CA7,Librarian

Databases: DB2, SQL Server, IMS,TERADATA,ORACLE

Scripting Languages: XML, HTML, SPLUNK

Protocols: TCP/IP, HTTP

Tools: & Utilities: Changeman, XPEDITER, ISPF,SQL Server management studio, Telnet, Putty, File Aid, Abend Aid, Mainframe Express, DOCUMERGE, Stored Procedures,Quality Center,QMF,MQ Series,Platinum,Strobe,Fault Analyzer,Remedy, ServiceNow,Managenow

Application Servers: IBM WebSphere 7.x/6.x/5.x, WAS 6.x,7.x

Web Servers: IBM HTTP Server, Tomcat, Apache

PROFESSIONAL EXPERIENCE

Confidential, Bentonville

DB Administrator

Responsibilities:

• Responsible file format and data quality analysis of incoming files.
• Designing, Development, coding, testing and implementation.
• Co-ordination with business users, Testers, QA and project managers.
• Responsible for all the Production Support activities, guiding L1 and L2 support teams on the same. Worked on conversion of data for one of the DB2 tables for all the countries.
• Analysis the architecture between the front-end platform at the Client site and the interface between the back-end Mainframe. Provide the solutions for the Adjudication of many different applications.
• Worked on to create a new application for performance and talent management system, which required loading feed from 25 different countries to DB2 database and then creating different extracts for Success Factor system.
• Debug and test the programs with XPEDITER after making changes for expected results.
• Worked on pulling records from Teradata history database to get the information on terminated associates.
• Single Sign on created for all market to login to successfactor.
• Weekly status reporting, issue tracking, escalation.
• AGILE methodology used throughout the project for all phases of project planning.

Environment: Cobol, JCL, DB2, Teradata, CICS, File Aid, Xpeditor,CA7,Librarian,REXX,JAVA

Confidential, Minneapolis

DB2 Administraor

Responsibilities:

• Subject matter expert for the Vantage Universal Life Application. Working on annual fund merger project in which we add and merge new funds and terminate the old funds from the system.
• Working as a project lead at onsite and providing 24 X 7 production support & maintenance co-coordinating with the offshore team.
• Fixing existing production problem to correctly calculate MEC premium for the joint policies when policy has passed 7 year premium test and policy had a decrease.
• Created and modified files and JCLs in order to test the accuracy of System modifications and running the jobs in test region before uploading to production.
• Tune DB2 applications performance and COBOL batch jobs including DB2 tables unload/load, VSAM files re-org and JCLs setup. Create batch reports using DB2 SQL and COBOL-3, and JCL.
• Worked on a initiative to optimize CPU utilization of the batch jobs around the clock so that CPU utilization across all LPARS is stable. This was the combination of multiple small level projects with identification of improvements at different fronts.
• Programming and debugging both batch (COBOL, VSAM, JCL, DB2) and online (CICS) programs in Mainframe environment.
• Prepare High level Design of the automation process, Functional/Technical Specification, Integration / Regression / UAT Test Strategy and Test cases documents.
• Creating printable contracts for the new products.
• Creating critical CTAX report, RMD processing, and annual statements for year-end implementation.
• Estimated of lot of small scale insurance projects.
• Worked on the CPU optimization of long running monthly MIS jobs. Aim of the project was to reduce CPU time for these jobs by 3 times. Idea was to reduce number of valuation calls made by the job.
• Worked on re-pricing so that the same product can be used with new pricing structure.
• Worked on Fund Expansion project for one of the annuities system so that system can hold more number of funds at account level.

Environment: Cobol, JCL, DB2, IMS, VSAM,CICS, File Aid, Xpeditor, Changeman, Filemanager,REXX

Confidential, Minneapolis

DB Administrator

Responsibilities:

• Handling the production environment for all the Inside and Outside Distribution Application for the Insurance and Annuities Domain.
• Create new DB2 Tables. Code COBOL/CICS/DB2, and Stored Procedures. Apply XML coding in the COBOL-3. Build COBOL API interface with IBM Workflow technology.
• Works on the applications Vantage FA, UL, FD, RPS, CAPS, QUARP, CSR, Adminserver, LANMARK and Trad. Tasks involves handling (resolving or coordinating) of all the production related incidents for these applications.
• Worked on incident management, problem management and SLA management for all the supporting applications.
• Provide business continuity service for Disaster Recovery.
• Understanding the different deployments going in E3, understanding the impact and planning checkout for the same.
• Attending priority one calls and making sure P1 tickets are resolved within SLAs.
• Measuring E3 environments Business outcomes - Performance, Availability and Data currency every month. Taking appropriate measures to improve system for the better performance of the business outcomes.
• Working on Production improvement initiatives to resolve system abends and performance of the batch jobs.
• Supporting and planning for year end, quarter end and Semi-annual batches.

Environment: Cobol,JCL,JAVA,DB2,IMS,VSAM,CICS,Websphere MQ,UNIX,SPLUNK,GOMEZ,UDB,Oracle,Tivoli, SQL Server, XML, HTML, Putty, REXX, File Aid, Xpeditor, Changeman, File Manager,Abend Aid, Tomcat Apache, SQL Server Management Studio, Jobtrac

Confidential

Database Administrator

Responsibilities:

• Worked on Annuity Commencement Date Conversion Project. Due to new law all the active annuities were converted to have new retirement date of the annuitant.
• Worked on enhance variable fund capacity project. As a part of this project fund capacity of Universal Life system was increased. Earlier system used to support maximum 97 funds per plan now it supports 255 funds.
• Took initiative and executed idea to delete all the funds for the policies in the system which had zero allocation and have always been inactive. It brought around 350 k $ save.
• Took one more initiative to reduce the CPU time of one of the heavy downstream job by reducing transaction history looping.
• Worked on fund merger project in which old funds are merged to new ones and old ones are terminated.

Environment: Cobol, JCL, DB2, IMS, VSAM,CICS, File Aid, Xpeditor, Changeman, Filemanager,REXXDocumerge, Eazytrieve, Stored Procedure

Confidential

Senior Developer

Responsibilities:

• Understanding MLCT Universal Life system and preparing understanding documents on the various business functionalities. This was one of the new application that as a vendor we were supposed to start take over.
• Cycle Run for the Customer Information Management System.
• Enhancements for the Vantage UL System.
• Enhancements for the Vantage Annuity System.
• COBOL 3 to ECOBOL conversion for all the source modules for Confidential application.

Environment: Cobol, JCL, DB2, VSAM,CICS, File Aid, Xpeditor, Changeman, Filemanager,REXX, Abend Aid, Mainframe Express, PL SQL

Confidential

Mainframe Developer

Responsibilities:

• Retrofitting: It was done using window based tool Beyond Compare.
• Installation: Once the retrofitting was over then the code was installed for the testing purpose. Changeman was used as a installation tool.
• Admin Table Conversion: Admin Tables are the rule tables for the vantage, these were converted from VSAM to DB2 format for the implementation of the Product Wizard.
• V3.4 Conversion: V3.4 Vantage System Policies were converted to V15.19 Vantage Policies.
• Worked on maintenance of inhouse weekly status report system which required making enhancement in java.
• L70 Conversion: Life70 System Policies were converted into transactions first and then transactions were applied in cycleup to convert them to V15.19 Vantage Policies.
• L70 Technical Enhancement: Many technical enhancements were done in end state like Surrender Charge and Preferred Loan, Dollar Cost Averaging to take Life70 Policies into account.
• Audit Preparation: Audit data was prepared with pre conversion and post conversion data to verify the conversions.

Environment: Cobol, JCL,Java, DB2, VSAM,CICS, File Aid, Xpeditor, Changeman, Filemanager