SUMMARY

• More than 5 years of experience in Information Technology, with expertise in technologies like WTX/DSTX/Mercator, COBOL, JCL, VSAM, DB2, CICS, VSAM, Clist, REXX, FILE-AID, Expeditor, Endevor, and MQC.
• Expertise in WTX (Websphere Transformation Extender).
• Having good knowledge on Data Extraction , Transformation and Loding using Datastage TX on Mainframe.
• Have been working as Senior Software Engineer in HSBC Software Development (India) Pvt.Ltd, Pune since December-2005.
• IBM certified WTX (Mercator/Datastage TX) professional.
• Having excellent knowledge on WTX 6.7,8.0,8.1 and 8.2
• Worked on different tools like FILE-AID, ENDEVOR, IBM utilities, Smart Test, CA-ProEdit, File Manager, SPUFI, WTX(Datastage TX), Ezyedit, Strobe.
• Have a good exposure & understanding of Design, Development, production support environments & processes in complex banking, Payments & Cash Management applications.
• Having good knowledge on SWIFT messages, payment instruments and BOS advises and Reports.
• Expertise in the database analysis and Design.
• Expertise on scheduling & rescheduling of batch jobs.
• Extensively used Database SQL queries.
• Having a good exposure to the operating systems WINDOWS 9x/2000, NT, XP, Vista, MS-DOS, MVS, OS/390, Z/OS.
• Having good knowledge on CHAPS, ACH, CHIPS and BACS settlements.
• Having good knowledge on RTGS.
• Active member of RCA (Root cause Analysis) Team.
• Have good exposure to the Project Planning right from business requirements gathering, converting them in to functional specs and then to technical specifications. And also providing estimations & converting them in to various modules and executing them thru different phases.
• Expertise on executing different tasks through various phases of SDLClike requirement analysis, technical specifications, development, retrofitting, UTC preparation, Unit testing, functional/acceptance testing and final documentation.
• Have a good combination of technical, communication and interpersonal skills, which provide the ability to be an effective mediator between programmers, Subject matter experts, end-users and the clients.
• Received RISE award in HSBC Pune Two times - for the excellent performance.
• SINE Award Nominee - Performer of the Year.
• Having a good exposure on setting up a new team and planning the KT and Necessary software installations for the team members.
• Having Good exposure on dealing with the clients and get the required information from them to implement the project in a better way.
• Having excellent communication skills and very well handled the projects during crisis situations.

PROFESSIONAL PROFILE

Confidential

Pune

Dec ' 05 - Till date

Senior Software Engineer

CERTIFICATIONS

• IBM certification on WTX (Websphere Transformation Extender).
• IBM Mainframe Certification.

EDUCATIONAL PROFILE

• BACHELOR OF TECHNOLOGY

TECHNICAL SKILLS

Languages

C, COBOL, JCL, CICS & SQL.

Databases

SQL Server 7.0,VSAM & DB2

Operating System

Z/OS, OS/390, MVS, MS-DOS, WINDOWS (Various flavors)

Tools/Utilities

FILE-AID, ENDEVOR, Expeditor, MQ series, TSO/ISPF, Smart Test, SPUFI, PROJCL,CA- Pro Edit, File Manager and WTX (Data stage TX)

Domain Knowledge

Banking.

Process

Knowledge of IQA and CMMI Audits.

PROFESSIONAL EXPERIENCE

Project-1
Client: Confidential
Project: HSBC Connect
Role: Module Lead
Description:
Confidential, is a Group strategic delivery channel that was piloted in UK in year 2001, and was designed to provide CIB clients with a single gateway into HSBC Group. A seamless and secure link was established between the customer's back office systems and HSBC. It supports payment instructions, receivables management, account balance/transaction reporting and report/file download.

Confidential, receives files from several delivery channels namely, Connect, Swiftnet Fileact, Connect Enterprise, Multi-Channel Delivery (MCD) and HSBC net File Upload. Once the file reaches HSBC Connect via HSBCNet or HOST the system operates an intelligent switch, which receives, validates, converts and dispatches customer instructions to the relevant internal system or external supplier. The switch, known as the Host Converter is based on an external file converter package from Mercator.

Confidential, accepts a variety of inbound file formats that may contain high value, low value, and Cheque instructions and also may contain advising data. It has links to Back Office systems around the world and also connects to the three Asia and Pacific Lionheart Engines, COS (Cheque Outsourcing Service), Customer Advising Service and RCMS (Receivables and Collections Management Service)

File Formats: XML, IDOC, SWIFT Formats - MT103, MT101, MT999, MT940, MT942 and EDI Formats - PAYMUL D96A, DIRDEB D 96A, SEPA DD and HBTR Formats.

Technologies used: COBOL, JCL, CICS, DB2, MQ series, IBM tools
Tools Used : MQC, WTX (DATASTAGE TX), Message Broker, MKS.
Responsibilities:

• Developing various COBOL, CICS modules, writing SQLs to access data from DB2 tables , Setting up JOBS using JCL to execute modules and run C:D scripts.
• Developing Mercator maps / WTX maps to execute them on Mainframe for data transformation.
• Requirements gathering, preparing functional and technical documents which will be given to development teams for further development of the project.
• Providing Project Estimations by analyzing project size and availability of the resources and get it approved by the client.
• Providing project status reports which will provide clear idea of the project status and project tracking details.
• Task allocations and preparing management reports such as Connecting GTB applications, SME nominations.
• Release Management: Such as creating GSD (global service delivery), Verifying sing-off forms and monitoring release components.
• Perform IQA and DPC roles with in the project to maintain documents and prevent Defects.
• Travelled to Hyderabad HSBC to Set up a new team - Completed successfully.
• Travelled to Mumbai HSBC as a business analyst to meet Customers and client integration team to understand their requirements on a new product.
• Provided training for client integration team on Websphere transformation extender.
• Conduct WebEx sessions for different teams across GLT centers on HSBC Connect.
• Involved in the Project co-ordination between business, functional team and development Team.
• Data Base Design & Risk analysis in dealing high volumes.
• System improvements and monitoring.
• Successfully delivered more than 25 projects within HSBC Connect releases ( R9 to R25)
• Successfully performed all kinds of testing(i.e. Unit test, E2E testing, Regression Testing, Performance testing) for all the projects in R9 to R25

Project-2

Client: Confidential
Project: SEPA DD Creditor-MVP/MVPA
Role: Module Lead
Description:

Confidential, Direct Debits will provide a single direct debit scheme for 32 countries; the EU 27, EEA 3, Switzerland & Monaco. All the inter-bank transactions will be in euro. It will eventually replace the domestic Direct Debit schemes in those countries where the domestic currency is the euro. It will also work in parallel to European domestic schemes in other currencies. HSBC connect will receive SEPA DD files up to 2 GB ( high volumes) and WTX maps has to process them to PIP for further processing.

File Formats: XML
Technologies used: COBOL, JCL, CICS, DB2, MQ series, IBM tools
Tools Used : MQC, WTX (DATASTAGE TX), Message Broker, MKS

Responsibilities:

• Development of Online and Batch COBOL modules to process high volume payments
• Setting up New Jobs Using JCL to run the COBOL modules and perform Mercator calls for the transformation from XML to VOCA XML.
• Perform POC using different languages/technologies/tools such as COBOL, VSAM, WTX, Message broker to identify the cost effective solution to process 2GB data in a single payment file.
• Suggested and developed an application using WTX on Mainframe to handle high volumes and got it approved by UK, HK and GLT teams.
• Conducted performance testing while processing high volumes (2GB data in a single payment file with around 5 million payments in it).
• Conduct a WebEx session for UK, HK, and GLT teams on the solution which was provided by me.
• Documenting POCs and preparing functional and technical documents for further development.
• Providing Project Estimations by analyzing project size and availability of the resources and get it approved by the client.
• Providing project status reports which will provide clear idea of the project status and project tracking details.
• Task allocations and preparing management reports such as WSR, IQA, DRE (defect removal efficiency) data etc.
• Release Management: Such as creating GSD (global service delivery), Verifying sing-off forms and monitoring release components.
• Involved in the retrofitting of code developed by the different team members by using various version control tools.
• Prepare test cases and upload them on to MQC and execution of tests, bug fixing and providing sign-off for different stages.
• Data Base Design & Risk analysis in dealing high volumes.
• System improvements and monitoring.

Project-3

Client: Confidential
Project: Faster Payments through HSBC-Connect
Role: Senior Developer
Description:
The Aim of this project is to provide GTB's PCM clients with the ability to initiate Faster Payments via HSBC two strategic delivery channels, HSBC net and HSBC Connect, in order to maintain a competitive offering following the launch of FP service for personal customers from Nov 2007.
UK banks currently operate 2 standard payment types, same day RTGS type payments known as CHAPS and ACH payments known as BACS which operates on a 3 day settlement basis. A new industry payment mechanism known as Faster Payments is being introduced in Nov 2007, which will offer same day settlement, and will incorporate a combination of features from both existing payment mechanisms.

File Formats: IDOC, SWIFT Formats - MT103, MT999, MT940, MT942, PAYMUL D96A, DIRDEB D 96A, BACS , ANSI 820 and XML.

Technologies used: COBOL, JCL, CICS, DB2, MQ series, IBM tools
Tools Used : MQC, WTX (DATASTAGE TX), MKS.

Responsibilities:

• Preparing Internal design Document and providing all technical details for development and unit testing.
• Implement New MQ links connectivity between HSBC Connect and UK BOS for HV Payments.
• Developing COBOL-DB2-CICS modules to validate the payments and routing.
• Writing Connect:Direct Scripts and run it using JCL to transfer Low Value Payment files to BOS.
• Prepare End to End test cases and test plan to perform E2E testing effectively.
• Maintain project related documents such as EDR, IDR, E2E test plan, estimations, Check lists on DOMDOC.
• Upload all testing related documents and test plan onto MQC and execute tests.
• Perform DPC role: (defect prevention champion)to track defects across all the projects and conduct meetings to come up with an action plan.
• Conduct meetings with UK team and on-site coordinators to provide project status and discuss issues.
• Developed the entire process flow design of the system, which is being used even by onsite team members & client for reference of the system flow.
• Involved in the retrofitting of code developed by the different team members by using various version control tools.
• Developed a QA environment just as a replica of production with generic code, which will facilitate the application developers to test their code irrespective of different business logics that are in production environment.
• Member of Subject matter Experts team and performed SME role in connecting GTB applications.
• Member of root cause analysis team

Project-4

Client: Confidential
Project: EU Rollout HSBC net FLU & Connect to TURKEY
Role: Software Developer
Description:
As a part of focusing on strength area & bring value to their PCM (Payments and Cash Management) business and clients in Europe HSBC initiated this project. In Europe the goal is to focus on UK, France, Germany and Turkey, where HSBC have substantial branch networks and domestic capabilities. However, whilst HSBC have undoubted strength in all of these four countries, it is Turkey which remains the least connected to the outside world. In the UK, France and Germany, HSBC Connect and HSBC net links exist and the business now has a requirement to achieve the same connectivity for Turkey.
The growth of the Shared Services Center and Payment Factory arena has shown HSBC that there is a requirement to have a host-to-host link to Turkey for the delivery of payment instructions. Procter & Gamble, Roche and Unilever have all enquired of our abilities in Turkey recently, and an RFP from P & G is expected later in the Year.
Whilst local connectivity channels exist in Turkey, the nature of SSCs is such that whilst the transaction may originate in Turkey, corporate, global ERP links will want to connect to their banks in a different part of the world and in a common format. Hence the requirement for host-to-host channels with our clients and in a deliver these payments files bank into Turkey in the correct format.

File Formats: XML, IDOC, SWIFT Formats - MT103, MT101, MT999, MT940, MT942 and EDI Formats - PAYMUL D96A, DIRDEB D 96A, and HBTR Formats.

Technologies used: COBOL, JCL, CICS, DB2, MQ series, IBM tools
Tools Used : MQC, WTX (DATASTAGE TX), MKS.

Responsibilities:

• Preparing Internal design Document and providing all technical details for development and unit testing.
• Prepare Online JCL program which will prepare a Job and submits for execution.
• Developing Connect: Direct links between UK mainframe and Turkey HUB.
• Developing COBOL-DB2-CICS modules to validate, transforming of data into Outbound Formats (HBTR) and routing.
• Provide Application Development support for all development regions (i.e Monitoring CICS regions, transactions abends, and link status checks, long running JOBs).
• Prepare End to End test cases and test plan to perform E2E testing.
• Code movement to SAT and UAT regions using Endevor tool and provide support for SAT , UAT and regression Testing.
• Maintain project related documents such as EDR, IDR, E2E test plan, estimations, Check lists on DOMDOC.
• Provide Production support and Perform Post release verifications.
• Worked on the Encryption & Decryption of Payment files that being sent to HUBS.
• Perform IQA role: (Internal Quality Assurence)
• Monitoring Gateways for incoming files and outgoing messages and raise an alert if any file transmission failures.
• Was very much involved in the Unit & acceptance testing of various enhancement modules that are implemented as per different client change requests.
• Involved in the retrofitting of code developed by the different team members by using various version control tools.
• Involved in documenting the application test results and fixing bugs and enhancements.