Post Job Free
Sign in

Project Data

Location:
Singapore, 461219, Singapore
Posted:
April 23, 2013

Contact this candidate

Resume:

A.T. Praveen Kumar *********@*****.***

Singapore PR

Ph: +65 - 9455 7646

Summary:

. Around 9 years of IT industry experience in BI and Data warehousing,

Basel II model Implementation, Impact Analysis with expertise in SAS.

. Hands on to end-to-end software development lifecycle and Implemented

Automation project for BI system.

. Support project management, process implementation, and co-ordination

with external vendors.

. Well versed in Data acquisition, Analysis, Validation, segmentation,

Data Modeling and working with complex data from multiple sources.

. Good understanding of Basel II credit risk, credit cards, Market

Research, Campaign management.

. Competent in SAS (Base SAS, Macros, SAS DI studio, SAS/SQL, SAS

infoMap, WRS, IDP, EG).

. Self-starter, resourceful, flexible and have a proven ability to work

in a team with cross-cultural international work experience in

Holland, India, Singapore, Philippines.

Training Received:

. Banking (Credit Cards Section) in CITIBANK, Singapore.

. Retail Domain (Market Research) at TCS, Chennai.

Work Experience summary

Industry Client Type of Application

Banking - Retail CITIBANK, Singapore, Basel II-Credit Credit Risk

DBS Bank Singapore Reporting Data warehouse and

Datamart

Government MOM Singapore Datawarehouse,BI and Reporting

Banking - Wholesale ING Bank-Wholesale division, DWH and BI for Financial

Singapore Reporting

Human Capital ING Bank,Amsterdam, HR Data warehouse

Netherlands

Market Research AC Nielsen, TCS, Chennai Retail Datawarehouse

Media Research Ogilvy and Mather, Bangalore CRM Reporting

Major Responsibility Handled

. Basel II model implementation for Retail Portfolios

. Rollout business data-marts for Credit Cards.

. Work with multiple vendors for project delivery.

. Work with subject matter experts to provide solutions, cost estimates,

functional specifications, design for project initiatives.

. End to End ETL design for Basel II Reporting System and DWH using SAS.

. Facilitate UAT and Test cases preparation, Support QA.

. Data Analysis and MIS Automation for BI system.

. Support Project Management and Pre sales activities.

. Impact analysis for the SAS migration project (9.1.3 to 9.2).

. Requirements gathering, FRD, UAT and support Audit team.

. Source data validation and advice on process improvement measures and

impart SAS training to internal staff.

Technical Portfolio:

Tools Base SAS, SAS/Macros, SAS DI Studio, SAS OLAP, SAS SMC,

SAS EG, SAS WRS, MS-Excel, MS-PowerPoint

Languages SQL, VB6.0, shell script, HTML.

Databases Oracle, MS-Access.

OS / Platform Unix, Windows, Control M

Knowledge Mainframe, SAS Miner 5.2,SAS 9.1.3 administration, Java2,

PL/SQL, Unix shell script

Scholastic Records:

. Master of Computer Application.

. Bachelors Degree in Mathematics.

Major Assignments (in reverse chronological order)

> Wipro Technologies, Singapore (Aug ' 11 till date)

Client CITIBANK, Singapore

Project International Regulatory Reporting System(Basel II) - LATAM Region

Description The International Regulatory Reporting System (Basel II) supports

the Credit Risk regulatory reporting for LATAM Region which

includes Secured and Unsecured products.

Responsibilities

. Lead the Basel II Implementation team for Retail Portfolios of LATAM

region.

. Co-ordinate with Risk Team, PMO to develop FRD, Complete UAT and

report validation.

. Source data validation and advice on process improvement measures in

ETL layer design.

. Reconciliation of Basel system generated reports with the Business

output.

. Implement/Advice process improvement measures, which includes

improvement of data quality and to improve the efficiency/turnaround

time of the present system, Automation etc.

. Project Management

> Optimum Solutions, Singapore (June '10 till Jul ' 11)

Client DBS Bank, Singapore

Project Basel II Reporting System

Description DBS has a key objective to be compliant with BASEL II requirements

as prescribed by Monetary Authority of Singapore (MAS). This

project provides the application platform required to enable CBG

Singapore to be ready for BASEL II Credit Risk compliance.

Responsibilities

. Obtain a comprehensive view of the user requirements, end-to-end co-

ordination and support to business users from initial requirement

phase, data reconciliation and report validation.

. Implementation of new models using SAS, based on the new PD, LGD and

EAD calculation.

. Preparation of design specification based on the CBR and requirement

gathering sessions.

. Maintenance of data dictionary for reports and Data, test plans and

schedule, as well as risks and contingencies.

. Report Automation and parameterization of KPI, root cause analysis for

issues.

> HP, Singapore (July 0'7 - June'10)

Client Ministry of Manpower,Singapore

Project ERIKA (Employer Relationship, Industry Knowledge Analysis).

Description ERIKA is a project spun off by the Ministry Of Manpower (MOM) with

the aim of creating a robust and flexible enterprise class

platform, which can rapidly evolve, with the business needs of MOM.

The BI system is built on SAS9.1.3 EBI platform.

Responsibilities

. Requirement Analysis, Functional Spec creation and technical specs

rectification.

. Data Analysis and validation, Designing structure/model of reports,

. Design MIS Automation, Training other team members.

. Impact analysis for the migration of SAS 9.1.3 to SAS 9.2.

. Support presales activities, User training.

July'07 - June'09

Client ING Bank N.V - Wholesale division, Singapore

Project BIS - Financial Reporting

Description This project is one of the initial initiatives form ING Singapore

for automating their Financial reporting system. Some of the

reports which were generated are Regulatory, ALCO - Market Risk,

Pipeline, Deal By Deal, WRM report, Sales Credit etc.

Responsibilities

. Business requirement Study, Functional and technical specs creation.

. Designing structure ETL for Reports, develop model of reports, MIS

Automation,

. Data Analysis and validation, User training, QA.

. Designed and developed the ETL process for data warehouse including

data repositories, exception reports and scheduling process for all

ETL jobs and their dependency using LSF scheduler.

. Work prioritization and allocation, Training other team members.

> Arinso International ltd, Singapore (Oct'06 - April'07)

Client ING Bank N.V,Amsterdam, Netherlands

Project HR Reporting System

Description The HR Department at ING relay on SAS DWH for generating

different types report such as payments, sickness, leaves etc of

ING employees. The data are extracted from different external

sources like SAP, PeopleSoft, Oracle, flat files.

Responsibilities

. Offshore the maintenance and support of the SAS data warehouse system

with more than 20 interfaces of ING HR dept in the Netherlands.

. Discuss detailed transition plan with client, help ING managers to

sketch plan for division of work and plan offshore activities.

. Design and development of new projects, and train team members at

offshore.

> Polaris Software Labs Pte Ltd, Singapore (June'05 - Oct'06)

Client CITIBANK, Singapore

Project Global Analytics

Description The objective of project is to introduce common Data Model

across the region, and generate reports for Portfolio Analysis,

vintage analysis, Segmentation, sales delinquency tracking,

credit line tracking etc.

Responsibilities

. Understanding key business drivers, Design business datamart for cards

Analytics department

. Relationship Management with internal business clients & Analytics

Teams.

. Data Mart Development in SAS, cater dynamic requests from multiple

projects, automate MIS reports used by top-level management.

. Provide Support to around 10 Countries by extracting and gathering the

daily and Month end files and support BO reports generation and

releasing the report to the Users.

> Tata Consultancy Services, Chennai (OCT'04 - June'05)

Client ACNielsen, ODC TCS Chennai

Project Market Research Automation Analysis system

Description The Automation Analyst group is responsible for collecting the

client requirements, creating and maintaining report

specifications and collecting the data required to satisfy the

client request.

Responsibilities

. As a Module lead interacts with the Client, gather the requirements,

Work distribution.

. Design the ETL using Base SAS and SAS Macros.

. Validate research data related to Campaign/data collection team.

. Recording of test results, Unit testing, Regression testing and follow

the project metrics.

> Digital Solutions, Kottayam (June'03 - Oct'04)

Client Ogilvy One Worldwide, Bangalore

Project Purple GRP (Media research)

Description Purple GRP is aimed to determine the reach of each TV channel

(India & abroad) on a particular time slot for different

categories of people.

Responsibilities

. Gather requirement and rules from Statistical analysts, Basic analysis

of generated results

. Campaign Analysis - Pre &Post campaign Data preparation and Analysis

. Working closely with the Statistical Analysts to cater their dynamic

technical needs, Convert ASCII/Oracle/Excel files to SAS Datasets for

further analysis.

. ETL design for generating CRM dataset.

. Prepare Statutory Reports/Graphs/Charts.

Key Achievements

. Implemented revised Basel II Model for Secured and Unsecured products

for Singapore.

. Actively involved in the implementation of reports for Business

Intelligence System for Finance department of wholesale bank.

. Played a vital role in offshoring existing the SAS data warehouse

system from Amsterdam to Manila and setting up a new SAS team at

offshore.

. Designed and developed new Regional Biz Datamart, which brings the

segregated MIS, reports by individual country under the Regional

reports.

. Lead in stabilizing the Automation Analyst System of ACNielsen

Datawarehouse at offshore development center.

. Worked in Media Planning Industry for finding the Reach and Frequency

of T.V channels among people, used by a top global Media research

group.

Academic

. Selected as Mathematics Association Secretary, Department of Mathematics

. Selected for the prestigious Duke of Edinburgh Silver Medal award.

. B certificate holder of N.C.C Army wing.



Contact this candidate