Career Summary:

• Software professionalwith 7 years of Information technology experiencein various domains such as Retail Hospitality, Healthcare and application development areas and Project Management.
• Leading and managing projects involving diverse technologies.
• Expert in systems analysis and troubleshooting, quality control, scheduling and planning, and tracking of results.
• Experienced in executing projects involving Mainframe and AS400 COBOL400 .
• Highly knowledgeable in SDLCcomponentsfrom design to development, Testing, implementation, QA and production support.
• Providing overall application health metrics and root cause analysis for the problems in application periodically.
• Experience in tracking and defect reporting software's tools like HP Quality Center.
• Create project plans for the entire project team using Microsoft Project Planner and tracked the entire phase of the project starting from requirements gathering to implementation.
• Setting Goals and conducting performance appraisals for the 4 member team.
• Strong communication, presentation, analytical and problem solving skills.
• Excellent communication skills between management, clients, and personnel.
• Expert in the Stores System, Central Pricing and Inventory and WMS processes.
• Ability to quickly adapt to new environments and learn new technologies and work in both team environment as well as Independent.
• Current Role Onsite Project Lead

Summary of Skills:

• Technical skills:
• Technologies Mainframe, AS400 COBOL
• Programming Languages: JCL, COBOL, COBOL/400, CL/400, PL/1
• Middleware CICS rem2host , MQ Series, LIFT
• Management Tools: Microsoft Visio ,BMC Remedy, Change Management
• Databases - DB2, DB2400
• Operating systems OS390, OS400
• Testing Tools HP Quality Center.
• Source Control: Endevor Mainframe , NETRON Fusion
• Debugging Tools: Expeditor

Professional Experience:

Project 1:

Confidential

Role : ONSITE LEAD

Description:

• Confidential. is a US-based chain of retail home improvement and appliance stores. It is the second-largest hardware chain in the U.S. It is organized geographically into Divisions such as Confidential and then the individual store.Confidential store can have anywhere from 80 to over 400 employees depending on the size and sales volume.
• Confidential Selling is a point of sale application of Confidential. Application maintenance for the application running across 1800 stores and handling issues and fixing. It involves support, bug fixes and enhancement of new features in addition to co-ordination of work between offshore and client team along with the review of work done at offshore.

Responsibilities:

• Worked in application and maintenance support and provided 24 7 support for store systems.
• Resolved all incidents and Problem Investigation PBI's related to stores-mainframe part of selling/Central Processing Inventory application.
• Had hands on experience in Sales system, Returns system, Historical Sales System HSS , Central Processing and Inventory systems CP I , Order Management Systems OMS and Distributed Order Management Systems DOM .
• Monitored all production jobs related to Lowe's store mainframe, taken care of job abends and resolved them as quick as possible.
• Responsible for enhancements and maintenance activities within stores mainframe application.
• Conducted knowledge transition sessions with build team and started supporting new modules rolled out in production.
• Worked on emergency fixes and moved mainframe components to production in emergency package for any production abends or program changes.
• Collaborated with business to explain the functionalities related to store applications.
• Interacted with client SME's to discuss on the long term fixes for any recurring incidents and applied them in production with business approvals.
• Worked on service requests asked by business users and completed their tasks in short span of time.
• Investigated the problems within the store systems, analyzed the root cause, found the appropriate solution and fixed them quickly.

Environment:

Platforms : ZOS-390 Languages : JCL, COBOL Special software's : TSO/ISPF, SQL, SPUFI, CICS, FILEAID, ENDEVOR,XPEDITOR,Stored Procedure Management tools : JAZZ, BMC remedy, Change Management, HP Quality Center DB : IBM DB2

Other Technologies involved :C/Unix, Java, MQ series, LIFT, FTP

Project 2:

Confidential

Role : ONSITE LEAD

Description:

• Store Fulfillment and Returns Project's primary mission is to continue rolling out Flexible Fulfillment functionality to additional stores while expanding the meaning of Flexible Fulfillment to include returning any product anywhere. It broadens the scope of Services Platform Initiative by extending the Flexible Fulfillment model to be included in store selling channels and expanding the fulfillment nodes.

Responsibilities:

• Expert in Returns functionality developed as a part of flexible fulfilment, Point of contact for all the functionalities related to the project and helped teams across in several queries and impact analysis.
• Hadin-depth knowledge in the architecture of sales database, returns database and historical sales database and had hands on experience in working on the Sales system, Returns system, Historical Sales System HSS , Order Management Systems OMS and Distributed Order Management Systems DOM .
• Successfully handled three implementations and gave quick turnaround in solving critical production issues.
• Interacted with business for new enhancements to make the code flexible to satisfy customer needs.
• Took ownership of the system in giving workable solutions for design change and involved in activities such as CRQ creation, CAB approvals, working with DA's and DBA's to deliver quality codes.
• Improved the performance of the system by optimizing the queries and brought the system into a saturated level which was highly appreciated by DBA's.
• Gave proper and tangible estimates through estimation methodologies which had high degree of focus on achieving the estimated tasks.
• Worked on component based design and high quality coding standards, incorporating performance aspects with futuristic view giving very little room for rework or defects.
• Managed team of 4 members, assigning tasks and tracking them.
• Worked with testing team members in test plan, defect fixing and in customizing the jobs as per the test environment.
• Prepared handover document and help manuals having the technical description of the entire system which acted as a key reference for the business users and support teams.

Environment:

• Platforms : ZOS-390 Languages : JCL, COBOL Special software's : TSO/ISPF, SQL, SPUFI, CICS, FILEAID, ENDEVOR,XPEDITOR,Stored Procedure Management tools : Change Management, HP Quality Center, Microsoft Visio DB : IBM DB2
• Other Technologies involved :C/Unix, MQ series, FTP, Sterling

Project 3:

Confidential

Role : TECHNICAL LEAD

Responsibilities:

• Responsible for the entire SDLC from analysis design to implementation support.
• Actively involved in impact analysis, project estimations and design for the proposed module to be developed.
• Worked on the high level and detail level designs, visualized the overall project flow and flow diagrams of individual modules in Microsoft Visio.
• Worked with Horizontal Leads/team members to ensure adherence to timelines.
• Interacted with onsite counterpart on a daily basis to get the business requirements and to propose workable solutions for the same.
• Managed the team of 4 members and guided them in all project related activities in technical and business aspects.
• Mentored couple of members in the team and made them productive within a short span of time.

Environment:

• Platforms : ZOS-390 Languages : JCL, COBOL Special software's : TSO/ISPF, SQL, SPUFI, CICS, FILEAID, ENDEVOR,XPEDITOR,Stored Procedure Management tools : Change Management, HP Quality Center, Microsoft Visio DB : IBM DB2
• Other Technologies involved :C/Unix, MQ series, FTP, Sterling

Project 4:

Confidential

Role : TECHNICAL LEAD

Description :

• Confidential is a cooperative of more than 5,100 independent retail stores. Confidential is committed to providing low upfront costs on merchandise purchases by Confidential from strategically located Confidential hardware retail support centers or through Confidential drop ship and bulletin programs. Over 65,000 brand name and Confidential Brand items support dealers, a comprehensive advertising program, sophisticated retail support systems, and headquarters and field staff personnel. Confidential is one of nation's largest co-ops. It currently consists of over 5,100 stores in 50 states and 62 countries and two paint manufacturing facilities.
• To identify the discrepancies between Inventory Location Totals and the Total Inventory. These values should be identical, there were incidences where they become out of sync and need to be corrected. This report will quickly identify these incidences, so that the source of the root cause can be identified and corrected.

Responsibilities:

• Preparing the low level and high level design strategy documents.
• Involved in the coding of various modules which involved various complex logic.
• Designed various AS400 screens for satisfying the scope of the project.
• Involved in detail design, coding and unit testing for the report generation.
• Involved in various testing and debugging activities for various complex modules and prepared Unit test Plans and Results in a detailed manner to cover all the requirements.
• Worked on QA abends and defect fixing.
• Involved in production support and worked for the successful completion of the project.
• Got several appreciation mailsfrom the Client for successfully implementing the group modules.

Environment:

• Platforms : ZOS-400 Languages : CL/400, COBOL/400 Special software's : SQL, SPUFI, RLU, SDA and DFU/400, RU,Stored Procedure Management tools : HP Quality Center DB : DB2400
• Other Technologies involved : .Net

Project 5:

Confidential

Role : MODULE LEAD

Description :

The Real time replenishment and Document creation project will accept orders from SAP into the Warehouse Management System WMS and create real time order filling documents and replenishments. This project is also aimed to support the WMS Supply Chain three year transformation plan and to provide greater flexibility for the Confidential order management process by providing real time bin replenishment and real time document creation.

Responsibilities:

• Involved in requirement gathering, High Level Design, Detail design, and unit test case document preparation.
• Project involved around 40 member team, out of which worked as a part of a 5 member team that handled the most critical modules in the project reporting straight to the senior manager.
• Involved in online screen design programs in COBOL400.
• Worked on the design, coding and unit testing for the online screens.
• Designed stored procedures in order to interact with the .Net modules.
• Coordinated with testing team during system and integration testing.
• Responsible for pre-implementation tasks such as turn over document creation, performance tuning and package creation.
• Responsible for the on time delivery of the offshore team with good code quality.
• Responsible for the entire SDLC from analysis design till implementation support.

Environment:

• Platforms : ZOS-400 Languages : CL/400, COBOL/400 Special software's : SQL, SPUFI, RLU, SDA and DFU/400, RU, Stored Procedure Management tools : HP Quality Center DB : DB2400
• Other Technologies involved : .Net

Project 6:

Confidential

Role : TEAM MEMBER

Description :

This project focuses on enhancing the current Dealer freight rate and Route maintenance screen to limit Drive retail sales increases in excess of 5 for maximum participating stores for each integrated promotion on the 2009 calendar. Reduce promotional retail execution time by 5 hours per month, and improve end-to-end retail execution of promotions by streamlining every aspect of the process, from ordering to communication to in-store execution. Increase Gallup metrics of past-30-day shops and overall top-of-mind awareness

Responsibilities:

• Worked in a new tool NETRON and on stored procedures.
• Involved in coding and unit testing for stored procedures.
• Involved in integration testing for stored procedures and worked for the successful completion of the project.
• Test case preparation and review.
• Production execution support.

Environment:

• Platforms : ZOS-390 Languages : JCL, COBOL Special software's : SQL, SPUFI, Stored Procedure Management tools : NETRON Fusion DB : DB2
• Other Technologies involved : .Net

Project 7:

Confidential

Role : TEAM MEMBER

Description :

• AetnaConfidential offers a broad range of traditional and consumer-directed health insurance products and related services, including medical, pharmacy, dental, behavioral health, voluntary plans, group life and disability plans and medical management capabilities and health care management services for Medicaid plans. Our customers include employer groups, individuals, college students, part-time and hourly workers, health plans, governmental units, government-sponsored plans, labor groups and expatriates.
• Customer and control information including the Account, Plan, and Benefit details are entered manually in remediated Confidential. This information is stored in PSBOR Plan Sponsor Book of Records from where it is available for use by downstream applications.

Responsibilities:

• Worked in Policy Entry and Reporting System.
• Customer and control information including the Account, Plan, and Benefit details are entered manually in remediated PERS.
• Data entered in PERS is validated in Remediated CCI WEB CCI
• Involved in execution of test cases and entering the test results in QC.

Environment:

• Platforms : MVS OS/390 , MS Windows Languages : JCL
• Special software's : Legacy PERS, Legacy CCI
• Management tools : Policy Entry and Reporting System PE/RS , QC Quality Centre -
• HP test management tool.
• DB : DB2
• Other Technologies involved : WEB CCI, IDMS APM database

Project 8:

Confidential

Role : TEAM MEMBER

Description :

• Confidential is the largest health benefits company in terms of commercial membership in the United States. Through its networks nationwide, the company delivers a number of leading health benefit solutions through a broad portfolio of integrated health care plans and related services, along with a wide range of specialty products such as life and disability insurance benefits, dental, vision, behavioral health benefit services, as well as long term care insurance and flexible spending accounts.
• Confidential wanted to rewrite its then Capitation system. This provides value to several of its business functions such as Sales and Product development, Network Development, Actuarial and Underwriting, Finance and PMG / IPA / Other healthcare professionals. The existing Capitation system which is Model 204 platform based was rewritten in COBOL DB2 based Mainframe batch system using JAVA as front end.

Responsibilities:

• Involved in creating high level and detail design documents.
• Designed efficient queries used in COBOL program for extracting related data from the required data tables for generating the reports.
• Worked in VSAM files and mainframe utilities like file aid, changeman and QMF Query Management Facility .
• Worked on extensive Unit testing to ensure bug free code delivery.

Environment:

• Platforms : ZOS-390 Languages : JCL, COBOL Special software's : QMF, SPUFI DB : DB2