Kirtikumar Shinde

Contact No.: +91-976*-**-**** ~ E-Mail: acpgq2@r.postjobfree.com

EXPERIENCE SUMMARY

. 10+ Years of experience in IT with Specialisation in ETL Architecture

and Data Integration

. Expert in data analysis, modeling, integration and aggregation, flows,

lineage

. Working with "Equities - Security Services" domain as Data Analyst to

identify and define data requirements, interfaces, data flows,

reconciliations.

. Participated in Analysis, Design, Development and Implementation of

various Regulatory and Economic Capital Projects - AGREE, GLEAM, GEC.

. Hands on experience with Credit Risk software like Moody's Portfolio

Manager, Risk Frontier

. Worked as part of HSBC Data Warehouse CoE for implementing DW projects

with aggressive deadlines

. Have participated in defining Test strategies for SIT and UAT Phases

. Have knowledge about Asset classes - Equities, Fixed income and money

markets.

. Have provided guidance and work leadership to the less experiences

staff members

TECHNICAL ACUMEN

. ETL and CDC: IBM InfoSphere Datastage 7.5/8.x/9.x, IBM InfoSphere Change

Data Capture (CDC) 6.3/10.2

. Reporting: QlikView, Cognos

. Databases: Oracle, Teradata, DB2, MS SQL

. Operating Systems: Unix, Linux, Ubuntu, Windows Server 2000/2003

. Languages: C, C++, SQL, Scripting

. SDLC Methodology: Agile, Test Driven Development, Waterfall, Extreme

Programming

. Version Control Tools: MKS, SVN, and ClearCase

. Other tools: Control M, Jira, HP Quality Center, ERWin, MS Visio, MS

Excel, MS Power Point, MS Word, Lotus Notes.

AWARDS AND RECOGNITION

. An "Enterprise Engineer" - an Elite group in HSBC who are recognized best

technologies and consulted for technical issues across different projects

- 2013

. Member of "Innovation Group" - HSBC since 2013

. Member of "BI - CoE" - HSBC from 2007 helping ETL projects around ETL

Architecture

. "RISE" (Recognition of Individual's Superior Efforts) - HSBC, 2008

. TEAM (Together Everyone Achieves More) - HSBC, 2009

EXPERIENCE DETAILS

. Since Dec-2011: With HSBC Software Development (I) Pvt. Ltd. as "ETL

Architect"

. Nov-10 to Nov-11: With Talentain Technologies working for IBM India as

"ETL Architect and Performance Engineer"

. Aug-04 to Oct-10: With HSBC Software Development (I) Pvt. Ltd. as "System

Analyst"

EDUCATION

. 2004 - Bachelor of Engineering in Computer Science from Pune University,

India - First class with Distinction

PROJECT DETAILS

1. Data Provisioning - Custody Data Warehouse

Duration: Since Dec-11

Client: HSBC UK

Technology: IBM InfoSphere Datastage 8.5/9.1, Change Data Capture (CDC)

6.3/10.2, Unix/Linux, Oracle, MQ.

Methodology: Agile Development & Test Driven Development

Domain: Equities - Custody and Securities

Project Details:

The purpose of the project is to act as a Golden Source for Custody related

information like Securities, Trades, Corporate Actions, Entitlements,

Holdings, Cash and Security positions etc.

The warehouse was sourced from primary custody systems in HSBC - Global

Custody and Asia Custody. It also gets the cash information and Forex

information from other HSBC systems. Primary purpose of this data is to

feed the Corporate Action processing engine "BaNCS". Once the Corporate

Actions are processed by BaNCS, the information is fed back to the

warehouse. In addition to this warehouse also provides information to other

consumers like - Option Election Data Store, Tax printing, Prime Marts,

HSBC Portal Marts, Custody Reporting Marts, Cash Forecasting etc.

Role:

. Planning and implementation of Evergreening - From Datastage 8.5 on AIX

to Datastage 9.1 on Linux

. Drive the Design - High level and Low level for the requirements and

issues in testing or implementation

. Handle the offshore team from delivery perspective - mentor them and help

the deliveries

. Analysis of source systems to identify the data element required for the

warehouse

. Define and document the data flows and interfaces with the producers and

consumers

. Define mapping and lineage documents

. Planning and implementing projects from identification, research,

analysis, design, execution, testing and roll-out side

. Coordinating with teams from UK, HK, India, Malaysia to integrate IT with

business systems and processes

2. Call Usage Data Mart

Duration: Nov-10 To Nov-11

Client: Vodafone India and IBM India

Technology: IBM InfoSphere Datastage, Unix, Oracle, Taradata.

Methodology: Agile Development

Domain: Telecom

Project Details:

The purpose of the project was to create a single Data Warehouse from

Reporting point of view. Earlier each circle was having their own reporting

manual or through individual systems. Providing a single unified view

across the whole country with 23 circles was key driver. The challenge was

size of the data which was around 500 GB in a day.

Role:

. Migration of Teradata implementation to Datastage and Oracle

. Performance tuning of the implementation to implement D-1 reports which

were earlier D-3

. High level and Low level design

. Discuss business reporting for the Country level business as well as

individual department/circles requirements

. Identify the critical data elements, reference and transaction data

sources, interfaces with sources for the warehouse

. Define a single common message format and minimum quality requirement for

providing data for all 23 circles

. Provide a plan and guidance for the circles to certify them while moving

onto common message format

. Conduct meetings with environment, testing, development, support teams to

guide them over the course of the project

. Define the aggregation requirements for reporting requirements

3. Group Economic Capital

Duration: Apr-07 To Oct-10

Client: HSBC UK

Technology: QlikView, IBM InfoSphere Datastage, Unix, SQL Server, Windows

2003 Server, Risk Frontier.

Methodology: Waterfall Development

Domain: Credit Risk - Economic Capital and Basel II

Project Details:

The objective of the project was to develop the HSBC EC framework. The

project used a third party Economic Capital Calculation engine "Risk

Frontier Portfolio Manager" (RFPM). The system was developed to feed the

Credit risk coming from source systems data to this tool in the expected

format. Then the risk analysis was done by the tool and economic capital

data was produced. The system also extracted the risk calculation results

back to GEC database.

Role:

. Investigation of Data Elements required for Risk Frontier and HSBC Global

Credit Risk Systems to define mapping

. Discussions with Credit Risk systems re Data provision and formats

. Discussion with business re various reports like Expected loss, VaR,

Industry, Country Exposures; then design data flow from RFPM to GEC model

for reporting purpose

. Documentation of Data Flows, Interfaces and mapping documents from Source

to GEC, GEC to RFPM and RFPM to GEC

. Coordination with Business, IT Support, Vendors, Testers and Development

teams

4. AGREE - A Generic Reconciliation Enterprise Engine

Duration: Aug-04 To Mar-07

Client: HSBC UK

Technology: IBM InfoSphere Datastage, SOA, Unix, DB2, Java.

Methodology: Waterfall Development

Domain: Credit Risk - Basel II

Project Details:

This system was designed to reconcile the difference before considering the

data for Risk calculations. There were 2 inputs from source systems called

as master or true data and slave data. The system was designed to compare,

report and repair the differences.

Role:

. Requirement discussions and documentation

. Technical and functional documentation - Data model, mapping and

interface definitions

. Discussions with risk systems GLEAM and Customer systems GCDU for

designing interfaces

. Identifying data elements for posting the repaired differences back to

source system GLEAM

ATTENDED TRAININGS

. 2014 - "Enterprise Engineers' Programme" for Elite Technologist in HSBC -

Training had 3 modules over the period of 6 months in UK, Hong Kong and

China

. 2009 - QlikView from Project Brokers, UK

. 2005 - Cognos from Systime, India

. 2005 - IBM Datastage and Metastage from IBM, India

PERSONAL DETAILS

Date of Birth: 06th November, 1982

Languages Known: English, Hindi, and Marathi

Nationality: Indian

Marital Status: Married

Passport Details: F1410970

Address: S.No. 49/1, Runanubandh, Gangurde Nagar,

Pimple Gurav, Pune, Maharashtra, India.

Pin code - 411061.

Contact this candidate