ASSOCIATE CONSULTANT Professional Summary 7+ years experience Analysis, Design, Coding, Testing, Database Administrator Production Support application software Mainframe platform. Having working Domain experience areas Banking, Financial, Warehouse, Legacy System. Extensive hands experience IBM Mainframe Application programming using COBOL II, CICS, JCL, DB2, VSAM, UNIX. Using BRIO generation Usage Reports. Extensively used debugging tools XPEDITOR, IBM DEBUGER. Hands experience DB2 tools QMF, SPUFI, FILE-AID, DB2 Admin, DB2 command editor. Expertise using configuration management tools ENDEVOR, SCLM. Good exposure Analysis Designing Documents like Software requirement Specifications (SRS) specification design documents (HLD LLD). Expertise using scheduling tool OPC. Excellent Problem Troubleshooting, Problem resolution root cause analysis. Excellent knowledge Batch Online Systems running Mainframes. CERTIFICATIONS: IBMCertified z/OS Database AdmiN,DB2 Application Developer DB2 UDB V8 family Fundamentals Certifications. Key Skills OS MVS, OS/390, Z/OS, Windows, UNIX. Databases DB2,VASM ORACLE, SQL. Tools/Utilities TSO/ISPF, RACF, OPC, QMF, FILE-AID, SPUFI, XPEDITOR, ENDEVOR, ABEND-AID, SDF, DCLGEN, SUPER-C,IBM SORT, ICETOOL, BMS, Quality Center (8.2), Clear Quest, Fault Analyzer, SDSF, FTP,IBM UTILITIES, JCL UTILITIES. DB2 ADMIN PANEL,SONAR,RDZ,MQ Shooter Languages COBOL, JCL, CICS, VSAM, SQL, HTML, XML, JavaScript, REXX Java PC Applications MS-Word, Excel, MS-Office, MS Access. OLTP CICS. Experience Associate Consultant October 2010 July 2014 Company Name － City State HSBC CORE BANKING October 2010 July 2014 Company Name － City HSBC Database DB2 9.0 Team Size 10 Role Developer -> Team Member -> Team Lead Env Mainframe Z/OS Technology IBM-MVS, DB2, SPUFI, Scheduler, REXX, JCL/PROC, VS COBOL-II, COBOL, CICS, ENDEVOR, EXPEDITOR, R2DS, MQ Roles Responsibilities: Managed Team 7 members Proactively taking responsibilities demanded Done Resource Management activities: Resource Onboarding, Fun Fridays, News-Letter, team outings, Daily status reporting, Leave management, timesheet management without schedule slippage Mentored new team members solve technical issues prepared documentation commonly occurring technical issues. Worked different modules streams project tenure: Product parameters Account maintenance Cheque management Account value Taxation Advice, statements reporting Exception handling Bulk inputs Fees Interests OAM Gained in-depth core banking knowledge like important control record setup, complete transaction flow account application fees interest account. Providing design proposals Development new programs handle various functions banking activities online batch. Creating CICS MAP scratch developing Presentation layer service programs As coordinator various releases, taken responsibility daily status reporting follow ups required, resolved proactively functional/technical hurdles impact deliverables, resulted timely flawless delivery releases Creating High level design document providing best architectural solution possible Providing Techinical Specifications based business requirment. Proving solutions performance tunning working testing part, STUB creation activity tunning Creating UTP service online programs Tracking reporting defects SIT sent status reports required Working POC project E2E process reengineering activity Resolving production issues, Abends tickets, working code changes, scheduling change, bug fixing, completing adhoc business requests priority work. Gain ability work high pressure complete deliverables time high quality Working team, team members similiar experience proving among would also one important achivement Active player project allocating tasks within team timely delivered tasks clients Involved various Reviews project deliverables Document Reviews, Code Reviews, peer reviews Handle responsibility arranging knowledge improving sessions team includes domain knowledge, technical sessions walkthrough projects team member knowledge projects platform Emphasis preparing document every phase project like testing reports, learning's project, technical issues faced project solved someone else faces directly refer document solve less time. Creation STUB program Batch modules manipulation 20 million records Working Performance Testing Tuning different Batch programs. Active participation Impact Analysis, Coding Unit Testing, AIT SIT phases. Involved various Reviews project deliverables Document Reviews, Code Reviews, peer reviews Involved Retrofit activity Reviews. Working SIT defect resolution team. SYSTEM ENGINEER March 2007 October 2010 Company Name － City State Education MBA Finance 2011 Symbiosis University － City State INDIA BE Computer Pune University 2005 Accomplishments OHCB project development new platform processing banking business HSBC mainframes Currently project SIT phase Term Deposit initial design Lending. As part one HSBC initiative HSBC Developing new product named OHCB Mainframes platform existing functionality existing core banking product HUB AS400. In conjuction current functionality HUB, HSBC decided include additional functionality OHCB meet One HSBC solution. Currently 53 countries uses HUB primary banking system. OHCB architecture totally service based remains loosely coupled interact OH (One HSBC) financial product like OH payment, OH forex, OH cards OHCDM etc easily. This flagship project HSBC OHCB deployed 85+ countries HSBC currently business 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 Utilities) Change request estimation updating scheduling, project metrics management using RPM tool Active participation Application design. Responsible Change Request Management, Code development delivery Creation BRIO Reports Unit testing documenting unit test results. Review program specifications, unit test specifications unit test results Production Support (L3) Resolution abends Description: Marketplace Information Warehouse (MIW) part IW suite applications. MIW houses multiple sources data makes data easy use cleaning, processing, linking, defining data faster delivery information critical business needs sales marketing professionals. Data licensed external sources compiled IBM internally. MIW receives External data Vendors. MIW refines process raw information received different vendors useful information, loaded DB2 tables. IBM sales marketing team access data using different online interfaces. The information MIW receives process differ 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 BRIO depending Requirements. Scheduling jobs OPC. DBA Activities. Participate project meeting. Description: EBI (Enterprise Business Information) Operation includes three batches, one GEO (EMEA, NA AP) running overnight. The batches feed daily IDOCs CBS located SAP environment S&D IW located MVS/DB2 environment FODS (Fulfillment Operational Data Store). The LDW ESW physically located MVS/DB2 environment UK/Portsmouth UK MVS TSOBA. There direct access LDW ESW system TSOBA common users (key users LCM direct access). Edge-On-Demand used front-end tool BRIO query tool behind. It's WEB based solution, supports different formats (BRIO, HTML, 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 BRIO depending Requirements. Scheduling jobs OPC. DBA Activities. Participate project meeting. Description: The Legacy Data Store (LDS) logical part EDW consists 12 tables. It system receives data Legacy Warehouse systems stores S&D Information Warehouse. The whole transmission system consists two parts: 1) The sending part Legacy Warehouse Country side 2) The receiving part S&D IW side For sending system exists S&D IW one dedicated receiving System. The sending receiving systems developed OPC job net running MVS. Each job net consists several jobs, usually executes one program, also jobs executing one. A program MVS/DB2 Utility PL/I Program. Because 12 tables fed, also 12 interfaces, responsible one target table. Dependent target table, every interface specific layout record format. The two subsystems communicate help trigger file. This file indicates sending action successfully completed data accessed receiving side. If trigger file received target side, processing take place. Skills analytical skills, banking, CICS, COBOL-II, COBOL, client, clients, Database, delivery, documentation, ENDEVOR, English, File-Aid, functional, Hindi, IBM, DB2, DB2 8.0, DB2 9.0, IBM-MVS, ISPF, JCL, Languages, team building, Team Lead, Mainframe, MS-Access, Windows, News-Letter, OS, Developer, PL1, Coding, proposals, QMF, quality, Quest, reengineering, reporting, REXX, scheduling, SPUFI, SQL, TSO, UDB, VSAM Additional Information PERSONAL DETAILS Date Birth 20-08-1983 Sex Female Marital Status Married Hobbies, Interest Watching movies, Listening music Swapanali Dhend