Core skills include Design, Development, Testing and DBA activities using COBOL, CICS, JCL, DB2, DB2 utilities and VSAM, debugging skills in IBM Debugger (Batch / Online modules) Client / End User support to resolve data issues while using DB2. Performance tuning / issue resolution for various DB2 objects / SQL Queries Expertise on BRIO for generation of Usage Reports Worked in DB2 V8 to V9 Migration process Application-side testing. Preparation and conducting training programs for newly joined team members. Contribution towards practice by taking interviews, preparing best practices / scenarios document. Active participation in various organizational activities / surveys giving feedback.
to 07/2014 CAPGEMINI INDIA PVT LTD – PUNE INDIA
Wrote maintainable and extensible code in a team environment.
Worked closely with other team members to plan, design and develop robust solutions in a timely manner.
Interfaced with business analysts, developers and technical support to determine the best requirement specifications.
to 07/2014 CAPGEMINI INDIA PVT LTD – PUNE INDIA
Directed software design and development while remaining focused on client needs.
to 10/2010 IBM India Pvt Ltd – PUNE INDIA
Completed IBM 703-DB2 V8 Application Developer (Score
Prepared detailed reports concerning project specifications and activities.
Diploma: INSTRUMENTATION2002GOVERMENT POLYTECHNIQUE-
MBA: Finance1 2011Symbiosis University-
Finance BE (Computer) - 2005, Pune University, Pune (63.63%)
DIPLOMA (IS) - 2002, MSBTE (77%)
SSC - 1999, Pune Divisional Board (75%)
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.
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.
Creating Report on BRIO depending on Requirements.
Scheduling the jobs in OPC.
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.