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.