Customer Service Project
Resume:
SANDEEP PAL
Mobile: +91-985*******
E-mail: *************@*****.***
*******.*****@*****.***
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