Data Management

SATHEES KUMAR RAJASEKARAN

E-mail: abhjjm@r.postjobfree.com

Nationality: Indian

Current Visa Status: Employment Pass

Hand Phone: (65)91083625

Date of Birth: 9th May 1985

OBJECTIVE

To work in a challenging environment that encourages continuous learning

and creativity in both domain and technical knowledge, provides exposure to

new ideas that stimulates professional and personal growth leading to a

lasting relationship with the organization.

CAREER PROFILE

> 7 years 10 months of Software Design and Development with extensive

domain knowledge in Credit & Risk management, MIS System, Financial

accounting systems, Index & equities and banking, Development,

Deployment and Quality Assurance experience in developing Business

Intelligence and Data Warehousing Solutions and Client/Server

Technologies, including heavy client interaction as onsite lead.

> Extensive experience in core technical design and development using

Oracle PLSQL, Informatica 8.x, UNIX.

> Excellent knowledge and experience in other ETL tools including

Business Objects Data Integrator XI, Cognos Decision stream 7.1 and

reporting tools including Business Objects XI R2.

> Experience in developing Oracle SQL, PL/SQL Stored Procedures

9i/10g/11g, DB2 SQL, DB2 command line UNIX programming. Experience in

Data ware housing concepts and data modeling process.

> Experience in developing UNIX scripts with DB2 Command line interface

and informatica.

> Informatica Power Center 8 Mapping Design Level completed. Oracle

Certified SQL Expert.

EXPERIENCE SUMMARY

Senior Application Consultant, NCS Singapore with client DBS Singapore

(September 2011 to Present)

Associate, Cognizant Technology Solutions, India (October 2009 to August

2011)

Senior Software Engineer, Keane Inc, India and United States (June 2006 to

October 2009)

TECHNICAL SKILLS

. Primary Skills: Informatica 8.6-7.1,Oracle PLSQL-SQL,DB2 SQL,unix, data

warehouse application architect, BO Reports & DI ETL involving in

technology of Data warehousing and Business Intelligence in MIS, Credit

& Risk Management, Index, Equity, Banking and Financial domains

. Development Tools: Informatica Power Center 8.6, Business Objects Data

Integrator XI, Cognos Decision Stream 7.2, Business Objects XI R2.SQL

Developer data modeler.

. Databases: Oracle 11g, 10g -9.2i, DB2 8.2, PL/SQL, and Oracle certified

SQL Expert.

. Scripts: UNIX scripts, IBM Tivoli Workload Scheduler 8.5,orsyp.

. Configuration Tools: Microsoft VisualSourceSafe, Document Manager,

Microsoft SharePoint, Star Team, IBM Manage Now

. Domain Knowledge: MIS system, Credit & Risk management, Index and Equity

services (banking and Finance), Retail, Manufacturing.

WORK AND EXPERIENCE

Senior Application Consultant, NCS (Singapore) (Sep, 2012 - till

date)

Relevant Projects:

o Applications ETL Lead, National Computer Systems (NCS Singapore)-Credit

Management -3G (Sep, 2011 - till date)

. Involved in Bug Fix, enhancement developments, performance tuning and

solving major production issues in multi integrated data warehousing

application for Management information system(3G-GIS) in Data

warehousing technology in Financial credit management in banking domain,

for the client DBS Bank ltd Singapore.

. Understanding of financial accounting, Management information system,

Global relationship & profitability information system and developed

enhancement in oracle plsql & sql packages and procedure in Unix

servers.

. Handled the complete ownership of 3G-GIS production module, batch

processing of scheduled Oracle PLSQL,Informatica ETL jobs in UNIX

scheduled in IBM Tivoli workload scheduler.

. Handled extensive enhancements and production bug fix, critical data

analysis to fix and played major role performance enhancement in

production and development planning process. Played vital role in major

Production changes and automation developments using oracle

plsql,Informatica 8.6, UNIX scripts.Involved and delivered major code

promotion, Bug fix, Production cut over (sg loans,dubai &Macau

cutovers).

. Played vital role along with team in major Production application

stability for EW & RAPM applications.

. Involved complex system and data analysis of various 3g project

application systems and involved system understanding and knowledge

transfer system integration and application production to domain

relationships.

o Application Consultant, National Computer Systems (NCS Singapore)-Risk

Management-RMG (Sep,2011-Sep,2012)

. Involved in Bug Fix, enhancement developments, performance tuning and

solving major production issues in multi integrated data warehousing

application for Risk management data analysis processing, enhancement

and fix in Data warehousing technology in Financial Risk management in

banking domain, for the client DBS Bank ltd Singapore.

. Understanding of financial risk management and developed enhancement in

informatica code and DB2 CLI interface.

. Handled the complete ownership of Risk management production, batch

processing of scheduled Informatica ETL tool jobs and DB2 code in UNIX

scheduled in IBM Tivoli workload scheduler.

. Handled extensive enhancements and production bug fix, critical data

analysis to fix and played major role performance enhancement in

production and development planning process. Played vital role in major

Production changes and automation developments using DB2,UNIX scripts.

. Involved in all code promotion, Bug fix, Production cut over process,

also involved in raising extensive major Change request using IBM Manage

Now. Involved in analysis and Fixing complex business logics related to

data profiling and handling from flat files, implemented control,

monitoring table's logic loads mappings.

Associate, Cognizant Technology Solutions (Oct, 2009 - Aug, 2011)

Relevant Projects:

o Module Lead, Tata McGraw Hill - S&P -Index services(S&P 500)-

Integration Systems (Oct,2009-Aug,2011)

. Involved in driving efficiencies and new capabilities in Data

warehousing technology in Index, equity domain, for the client Standard

& Poor's for world famous American stocks: the S&P 500.

. Designed data model, ETL loads and BO reports and developed many complex

Informatica mappings for the client S&P Indices for loading daily index,

stock and historical data from index application into Oracle Warehouse

for Index products.

. Involved in migration of huge volume of data between systems and worked

on complex business logics related to data profiling and handling from

flat files, JMS Sources. Implemented control, monitoring table's logic

loads mappings.

. Development of daily capture workflow using JMS integration. Extensive

ETL production support. Development of UNIX scripts with file watching

logics.

Senior Software Engineer, Keane Inc., India and US (Jun, 2006 - Oct,

2009)

Relevant Projects:

o Module Lead, Honeywell - Honeywell ACS - RAS Project (Feb, 2009 -

Oct, 2009)

. Analysis and understanding of source oracle ERP system and interacting

with oracle functional (finance customer module) to prepare functional

specification for extracting of the data as per ERP modules.

. Designed and developed ETL loads to extract data from various oracle ERP

source systems tables and flat file for the report and input to SAP ERP

system. Testing of ETL mapping and process to extract data as per

requirement and to test the transformations involved. Providing

consolidated status of team member on different modules of the extract

report to the clients, Created complex mapping and workflows as per

process to load different staging table and performing transformations.

o Module Lead, Honeywell - Transportation & Systems - Clover Informatica

(Sep, 2008 - Feb, 2009)

. Implemented SAP ERP system for Honeywell TS which involved migration of

data using Informatica from Avalon Oracle Database and SAP Systems to TS

SAP system to implement the functional complete SAP system for their

products.

. Designed and developed ETL loads to extract data from various source

systems and load them to SAP system.

. Responsible for managing risk and performing defect prevention analysis

of the projects based on defect trends and overall goal. Performed

requirements gathering to understand the client requirements and

designed system.

o Onsite DEV & QA Lead, Staples (USA) - Adjusted margin reporting (AMR)

(April, 2008 - Sep, 2008)

. Responsible for Development & quality assurance analysis and testing at

onsite for Staples Inc, US.

. Involved in development of separate Development analysis & test

strategy, functional spec & test plan for sales data which were cleansed

and calculated for adjustment before loading into DB2 database.

. Coordinated and developed with team and also performed smoke testing,

system testing for ETL mappings in Informatica and DB2 procedures.

Performed testing on sessions and workflow and scheduler tool orsyp for

data load to target database for reporting.

o Aerospace Information Warehouse - Revenue Chain Reporting (Sep, 2007

- Apr, 2008)

o Honeywell Aerospace Information Warehouse Development (Dec, 2006-

Sep, 2007)

o Staples European Catalogue EDW (Jul, 2006 - Dec, 2006)

. Software change request management, preparation of impact analysis,

development and testing including preparation of Design Document and

Test Plans to cleanse and load data to Oracle database. Involved in

critical development and enhancement of ETL Informatica &oracle PLSQL

mappings and solving deployment issues. Involved in development of for

Enterprise Data Warehouse as part of production support activities.

Designed and developed the data marts and data warehouse. Responsible

for development of ETL Mappings in Business Objects Data Integrator XI

to load data into AI Oracle data warehouse. Performed configuration

management activities as configuration team lead.

EDUCATION AND CERTIFICATIONS

. Bachelor of Engineering in Computer Science Engineering, SSN College of

Engineering, Anna University, India, 2006.

Contact this candidate