Rajesh Kumar Email & Phone Number

London, United Kingdom

 Designed ETL architecture and define standards. Prepared STAR schema data model to handle trade reconciliation process ( Post Trade Utilities). Prepare mapping & technical documents. Manage multiple streams of release & change management process. Managing Offshore team for development. Involve release management. DataStage Jobs tuning and performance tuning Designed architecture for Quartz Scheduler ( Java). Wrote PL/SQL & shell scripts for control frame work and other activities.

Slough, United Kingdom

 Write strategy document for code migration from 7.5.2 to 9.1. Preparing Standards and Strategy documents. Involve design and development in new projects. Performance guidance documentation. Review design documents and coding. Datastage Jobs tuning

Chester, United Kingdom

Remediation program is to upgrade hardware & software from existing platform (DataStage 7.5.2/AIX 5.0) to new platform (DataStage 9.1./AIX 7.1). Roles: Installation & Configuration of Infosphere in Development, Test, Pre-Prod & Prod Servers including HA configuration and multiple tiers. Configuration of Operations console & Workload manager. Write strategy document for code migration from 7.5.2 to 9.1 including hash file migration, parameters etc. Shake down testing of new functionalities like Bulk load, Dynamic files creation, Xls reading etc. and performance testing. Backup and Restore strategy document & script using recovery tool. Apply fix packs Automation of moving Datastage Assets from one environment to another environment. Automation tool using Oracle PL/SQL to compare two environment tables. Wrote POC for converting XML Utility ( from C# code for xml parser) to Datastage using xsd. Leading offshore team size of 10

Penne program is used to standardize process and introduce new ODS and EDW environment. MQ & JMS Queue has been used to transfer message and load data into ODS nearly online. Roles: Understand Business requirements and map requirements into Oracle retail Model. Preparation of High level flow documents and mapping documents. Designed and developed conceptual, logical and physical data models. Erwin tool used to generate different types of models. Wrote common Interfaces using ODI 11g to transform and load data. Wrote generic reports to compare values using different environments using OBIEE 11g. Worked on AGILE methodology.

Kent

 Write Strategy document for projects. Write High level design/ low level design documents. Designed extraction tool to extract data from any table/columns and send to any remote location.  Designed and developed conceptual, logical and physical data models. Erwin data modeler used to generate different types of models. Created Framework Model using COGNOS framework manager and created template reports. Worked on extracting data from multiple sources like SAP, SQL Server, Oracle, and flat files using schema file etc. Developed multiple reusable components like loading data from flat files into staging area, extract data from other database to staging using RCP, multiple instant job usage. Developed data dictionary for data model based on data elements extracted from source system and fields populated in the models. Worked on Oracle, SQL and PL/SQL, Performance tuning. Prepared Test Strategy and test plans. Designed tool using oracle PL/SQL to refresh single dimension (Text tables) refresh from staging DB to Target DB.

 Analyzed and designed the flow from source to Staging, Staging to BIR (Business Intelligence Repository). Designed and developed conceptual, logical and physical data models. Erwin data modeler used to generate different types of models. Worked on extracting data from multiple sources like DB2, SQL Server, Oracle, and CFF etc. Developed multiple reusable components like automated storage maintenance, multiple instant job usage. Prepared documents like Logical design document, Physical design document, Implementation Plan. Developed UNIX shell scripts for BIR upgrade and Migration projects. Developed data dictionary for data model based on data elements extracted from source system and fields populated in the models. Worked on AGILE methodology to execute many projects. Worked to do effort estimation of projects.  Worked in parsing and preparing XML files using DataStage. Created Business Objects universe and BOB reports. Worked on migrating SAS code into ETL.

Other clients worked: Roads Traffic Authority (RTA), Australia thru HCL Technologies, Jan‘2005 to Jun 2006 Deutsche Bank, Germany thru HCL Technologies, July ‘2004 to Jan 2005 Land Transport Authority (LTA) Singapore thru HCL, June ‘2002 to June 2004 Citadon Inc, SanFrancisco, U.S.A thru HCL Technologies,Jul’2000 to May’2002 R.S.Software Ltd,Oct’99 to Jul’2000 Rane Brake Linings Ltd, May 99 – Sep’ 99 Verbatim systems, Jul’95 – July’98