Associate Consultant Resume Example

7+ years of experience in Analysis, Design, Coding, Testing, Database Administrator & Production Support of application software in Mainframe platform.

Having working Domain experience in the areas of Banking, Financial, Warehouse, Legacy System.

Extensive hands on experience on IBM Mainframe Application programming using COBOL II, CICS, JCL, DB2, VSAM, UNIX.

Using BRIO for generation of Usage Reports.

Extensively used debugging tools such as XPEDITOR, IBM DEBUGER.

Hands on experience on DB2 tools such as QMF, SPUFI, FILE-AID, DB2 Admin, DB2 command editor.

Expertise in using configuration management tools ENDEVOR, SCLM.

Good exposure on Analysis and Designing of Documents like Software requirement Specifications (SRS) and specification design documents (HLD and LLD).

Expertise in using scheduling tool OPC.

Excellent in Problem Troubleshooting, Problem resolution and root cause analysis.

Excellent knowledge of both Batch and Online Systems running on Mainframes.

CERTIFICATIONS: IBMCertified z/OS Database AdmiN,DB2 Application Developer and DB2 UDB V8 family Fundamentals Certifications. 

• OHCB project is development of a new platform for processing the banking business of HSBC in mainframes Currently this project is in its SIT phase for Term Deposit and initial design for Lending.
• As a part of one HSBC initiative HSBC is Developing new product named OHCB on Mainframes platform which will have all the existing functionality of it's existing core banking product HUB which is on AS400.
• In conjuction with the current functionality of HUB, HSBC has decided to include additional functionality in the OHCB to meet One HSBC solution.
• Currently 53 countries uses HUB as their primary banking system.
• OHCB architecture is totally service based so that it remains very loosely coupled and can interact with other OH (One HSBC) financial product like OH payment, OH forex, OH cards , OHCDM etc easily.
• This is the flagship project for HSBC and OHCB will be deployed in all the 85+ countries where HSBC is currently in business by year 2020.
• 2.
• IBM INDIA PVT LTD, Pune (System Engineer: Mar 2007 - Oct 2010) PROJECT: MIW (MARKETPLACE INFORMATION WAREHOUSE) Developer / DBA Apr 2009 - Oct 2010 Client : IBM, USA Tools : SCLM, RMDS, DB2 Admin Panel, Spufi, QMF, Brio.
• Platform : Z/OS.
• Languages : PL1, JCL, VSAM, DB2.
• Database : DB2 8.0 / 9.0 Team Size : 7 Roles / Responsibilities: DBA Activities (Solving user queries, Loading / Unloading data, Authorization, Execution of Utilities) Change request estimation / updating and scheduling, project metrics management using RPM tool Active participation in Application design.
• Responsible for Change Request Management, Code development / delivery Creation of BRIO Reports Unit testing and documenting unit test results.
• Review of program specifications, unit test specifications and unit test results Production Support (L3) / Resolution of abends Description: Marketplace Information Warehouse (MIW) is a part of IW suite of applications.
• MIW houses multiple sources of data and makes this data easy to use by cleaning, processing, linking, and further defining the data for faster delivery of information that is critical to the business needs of sales and marketing professionals.
• Data is both licensed from external sources and compiled by IBM internally.
• MIW receives External data from its Vendors.
• MIW refines and process raw information received from different vendors into useful information, which is loaded to DB2 tables.
• IBM sales and marketing team access this data using different online interfaces.
• The information that MIW receives and process differ for different vendors.
• PROJECT: LDW ESW Developer Apr 2007 - Mar 2009 Client : IBM, Germany Platform : Z/OS.
• Tools : Spufi, QMF, Brio, DB2, TSO/ISPF Team Size : 2 Roles / Responsibilities: Responsible Application design.
• Production Support.
• Creating Report on BRIO depending on Requirements.
• Scheduling the jobs in OPC.
• DBA Activities.
• Participate in project meeting.
• Description: EBI (Enterprise Business Information) Operation includes three batches, one for each GEO (EMEA, NA and AP) running overnight.
• The batches feed daily IDOCs from CBS located on SAP environment to S&D IW located on MVS/DB2 environment through FODS (Fulfillment Operational Data Store).
• The LDW ESW is physically located on an MVS/DB2 environment in UK/Portsmouth - UK MVS TSOBA.
• There will be no direct access to the LDW ESW system on TSOBA for the common users (key users and LCM have direct access).
• Edge-On-Demand is used as a front-end tool with BRIO as the query tool behind.
• It's a WEB based solution, which supports different formats (BRIO, HTML, and L123).
• PROJECT: LDS (LEGACY DATA SYSTEMS) Developer Oct 2007 - Mar 2009 Client : IBM, Germany Platform : Z/OS.
• Tools : Spufi, QMF, Brio, DB2, TSO/ISPF Team Size : 2 Roles / Responsibilities: Responsible Application design.
• Production Support.
• Creating Report on BRIO depending on Requirements.
• Scheduling the jobs in OPC.
• DBA Activities.
• Participate in project meeting.
• Description: The Legacy Data Store (LDS) as a logical part of the EDW consists of 12 tables.
• It is a system which receives data from the Legacy Warehouse systems and stores it in the S&D Information Warehouse.
• The whole transmission system consists of two parts: 1) The sending part on Legacy Warehouse Country side 2) The receiving part on S&D IW side For each sending system exists in the S&D IW one dedicated receiving System.
• The sending and the receiving systems are developed as OPC job net running under MVS.
• Each job net consists of several jobs, which usually executes one program, but there are also jobs executing more than one.
• A program is a MVS/DB2 Utility or a PL/I Program.
• Because up to 12 tables are fed, there are also 12 interfaces, each responsible for one target table.
• Dependent from the target table, every interface has a specific layout and record format.
• The two subsystems communicate with the help of a trigger file.
• This file indicates that a sending action has successfully completed and the data can be accessed on the receiving side.
• If no trigger file is received on the target side, no processing take place.

• PERSONAL DETAILS Date of Birth : 20-08-1983 Sex : Female Marital Status : Married
• Hobbies, Interest : Watching movies, Listening music Swapanali Dhend