SANDEEP PAL

Mobile: +91-985*******

E-mail: acgswf@r.postjobfree.com

+91-937*******

acgswf@r.postjobfree.com

Objective:

Looking for assignments in Project Management /Software Application

Development with well known organisation of repute

Academic:

BE (IT) from Mahankal Institute of Technology, Affiliation under RGPV

University Bhopal in 2005.

HSBC Software Development Pvt Ltd, Pune

January,2007 to Till Date

Professional Preface:

> I am having 5 Years of relevant experience in Mainframe (COBOL, JCL,

RDBMS DB2,CICS and MQ). and 8 years of total IT experience.

> Currently working with HSBC Software Development Pvt. Ltd., working as

Senior Software Engg.

> Worked as ONC (Onsite Coordinator) and Analyst for 6 months at UK (Client

Site - HSBC Bank UK Plc)

> Exposure in managing the entire software development operations and

involving application support, requirement gathering, development of

functional specifications & development and co-ordination with customer.

> Functional experience in Banking/Finance/Cards Domain (Mortgages/Retail

Banking/Cards - Compliance).

> Presently I am on Application Support.

> Understanding user requirements and delivering Estimations, Impact

Analysis, Functional specifications, technical specifications, designing,

development and UAT/System/Unit testing related to projects.

> A team player with strong communication, analytical, relationship and

vendor management skills.

Employment Recital:

Skill Set:

Technical

Operating Systems : Windows Xp/2000/98

Language : COBOL

Data Base : RDBMS DB2, Oracle 9i

Other : CICS,JCL,MQ, ENDEVOR, SPUFI, PL/SQL Developer,

CICS Provisioning,

Smart Test, MERCURY QUALITY

CENTER, GSD R12, PowerBuilder

Functional:

Project Management

< Managing complete range of project activities right from

conceptualisation, consultancy, testing and maintenance.

< Undertaking scheduling and analysing the requirements for further

proceedings.

< Involved in Incident resolution and Incident management.

< Evaluating and assessing requirement of system software.

< Delivering and implementing the project and small changes as per

scheduled milestones.

< Given KT to offshore, Hyderabad and system testing team.

< Interacting with team members for resolving their functional and

technical queries.

Application Maintenance and SDLC

< Resolving the Incident, Analyzing and fixing the problem and work

request.

< Interacting with the users for system study, requirements gathering,

analysis, implementation and testing of the system.

< Designing & coding of the FATCA & solution for the project.

< Post production application maintenance and support.

< Part of Unit and system testing and worked on defects.

< Identifying, analysing defects & Code Per-review.

Projects Undertaken:

#Project 1 : FATCA-Foreign Account Tax Compliance Act

Working for : HSBC India

Period : Dec 2013 -Till now

Tools : COBOL, JCL, Db2, CICS and MQ

Description: The Foreign Account Tax Compliance Act ("FATCA") was signed

into law on 18 March 2010 in the US. This requires financial institutions

to report more extensively on business they conduct with US persons.

One of the primarily requirements of this project is for HSBC to identify which

customers (Individuals and Entities) fall under the scope of FATCA. The FATCA

Common Business Requirements Document has identified this will be accomplished by

searching customer data for indicia facilitated by an electronic searching

utility.

To ensure indicia searching, entity classification and data validation is

consistent and accurate across the bank, a utility will be required that allows

local systems to search and receive a result locally. The utility will need to

support both ad hoc and batch queries for local operational processing. This

utility will be badged as the FATCA Services Utility (FSU).

Role: Senior Developer, Code review, Unit and system testing, prepared EDR

and IRDR.

#Project 2 : HSBC (UK) CNS - Customer Need System

Working for : HSBC India

Team Name : Application Services

Period : Nov 2010 - Nov 2012

Tools : COBOL, JCL, Db2, CICS and MQ

Description: Customer need system has front end screens and back end

processing as EOPS (Ease of Purchase system).

This system deals with account opening for UK HSBC customer. It has

following feature.

< Staff facing screens and UK Product opening.

< Work In Progress Database used by Customer Need System which includes

PAO, BAO, and GEMS etc.

< Product offered line Bank Account, Loans, Mortgages, and Cards etc.

Role: Senior Developer, Incident resolution, Support (Primary contact),

#Project 3 : CNS Application

Team Name : Channel Integration

Period : Jan 2010 - Oct 2010

Tools : COBOL, JCL, Db2, CICS and MQ

Description: The Customer Needs Account Opening process supports Personal

and Business product opening for new and existing customers. The framework

provides generic product opening functionality that is common to all

product types (e.g. product selection processing, product completion). The

Customer Needs Host database (e.g. work in progress) supports the product

opening process. The database is used to store application, quotation and

product information for the applications in progress. On successful product

completion the Customer Needs Host generates interface(s) to the

appropriate background processing system(s) (e.g. Product Ledger Management

(PLM), Plastic Card Ordering (PCO), Encoded Paper, WHIRL (Credit Cards),

Statements & Advices (SAS), Fees & Interest (FIS) and Folders Views &

Queues (FVQ)).

Role: System Analyst, Design (Functional Specification, Process

Specification, Technical Specification), Client Relationship, Developer.

#Project 4 : Caesar

Team Name : HFC Team

Period : Jan 2007 - Dec 2009

Tools : PowerBuilder and Oracle 9i

Description: Caesar is a Windows based application used to maintain credit

card, store card and retail accounts portfolio. Caesar's primary role is to

provide Customer service officers with all the information and

functionality they need to deal with credit cards customer calls quickly

and efficiently. The various departments that use Caesar are as Customer

Service, Chargeback, and Fraud.

In the Credit cards industry, the Payment systems like MasterCard and Visa

continuously monitor the transactions sent by various members and carries

out detailed analysis on the same. At the same time they also study the

market to search for new opportunities, new products, emerging technologies

and Fraud prevention techniques. Based on their analysis, MasterCard and

Visa come up with certain modifications in their systems to incorporate the

above objectives. When MasterCard and Visa make changes in their systems,

they make it mandatory for all the members to make the corresponding

changes in their systems as well. These modifications carried out by

members in their respective systems/application to bring them in line with

the MasterCard/Visa systems are called Compliance changes and the projects

are termed as Compliance.

Role: /Systems Analyst, Developer, Support.

Achievements:

. Certificate of recognition award for best performance in Team

Training:

V Banking For developers Training.

V Training for DB2.

V COBOL Training

Personal Details:

Date of Birth : 12th

Feb 1981

Languages Known :

English and Hindi

Gender :

Male [pic]

Contact this candidate