Profile of Rajeev Sankarathil Abinitio, Oracle ( PL/SQL ), Unix KShell Scripting

Rajeev Sankarathil ( Available From 04/27/2009 )

Claymont, DE - 19703 USA

Expertise :	Abinitio, Oracle ( PL/SQL ), Unix KShell Scripting
Status :	Permanent Resident
Job Type :	All -
Position :

Resume

SUMMARY

An IT professional having an Industrial Experience of 10+ years
Strong experience on Data Warehouse Technology and its SDLC Phases
Excellent work base experience on ETL Process Design and implementation
Strong experience on Logical and Physical Design process, Data Mapping, Impact Analysis and Root Cause Analysis
Strong experience on conducting Review Meetings and Process Documentations
Strong hands on experience with Change Management processes of major Corporations
Excellent work base experience on ETL Process using Ab Initio
Excellent work base experience on ETL Process using Oracle PL/SQL Functions, Procedure and packages
Excellent work base experience on Unix O/S and Unix Korn Shell Programming
Excellent work base experience on Disaster Recovery process
Strong experience on Oracle DBA routines, SQL Tuning, Application Design and Development and Data Analysis
Strong experience on SQL, PL/SQL, Pro*C, Forms 3, 5 and Developer/2000 Rel 1 and 2
Excellent work base experience with Tivoli and Autosys
Strong Communication Skills and Team Management

PROFESSIONAL EXPERIENCE

January, 2009 - March, 2009	Organization Title Start End HCL Technologies America ETL Consultant
	JP MORGAN CHASE CARD SERVICES Wilmington , DE USA Senior Appl Developer/Lead Developer 2005 2008 SATYAM COMPUTER SERVICES Shelton , CT USA Senior ETL Consultant 2004 2005 BANK OF AMERICA Horsham , PA . US Senior Programmer Analyst 2001 2004 GLOBAL INNOVATIVE SOLUTIONS INC Boston , MA USA Software Engineer 2000 2001 DATAMATICS LTD Mumbai INDIA Software Engineer 1997 2000
January, 2009 - March, 2009	ETL Consultant
	HCL Technologies America or Readers Digest . Chappaqua , NY USA JP MORGAN CHASE CARD SERVICES Wilmington , DE USA Senior Appl Developer/Lead Developer 2005 2008 SATYAM COMPUTER SERVICES Shelton , CT USA Senior ETL Consultant 2004 2005 BANK OF AMERICA Horsham , PA . US Senior Programmer Analyst 2001 2004 GLOBAL INNOVATIVE SOLUTIONS INC Boston , MA USA Software Engineer 2000 2001 DATAMATICS LTD Mumbai INDIA Software Engineer 1997 2000 Perform MSR Marketing System Replacement Data Warehouse system study Identify the Unix KSH, Perl and Abinitio code base to get the knowledge transfer to HCL offshore employees Be a mentor to the HCL onsite employees for Unix KSH and Abinitio Identify the EME elements to be documented and addressed Prepare different functional and technical documents and get it reviewed
January, 2005 - December, 2008	Abinitio Developer
	Wilmington , DE USA Design ETL application and development based on the technical or functional specification Implement Re-startability, Recovery Options, Extract or Load Staging, DIM or FACT loading, ETL Audits Design and implement ETL staging Seriel and multi and loading applications using Ab Initio Implement Disaster recovery routines and documentions Work closely with the Business Analysts and Application Leads to get the business/technical requirements and develop datawarehouse applications using Ab Initio, Oracle PL/SQL and Unix Kshell for JPMC s Very Large Database VLDB Create logical and physical design documents for each processes and provide approved 1 to the Corporate Database Achitecture team and Database maintain capasity plans Conduct process status meetings with all stakeholders and publish dashboards Lead developer, point of contact for data conversion processes COBOL dataset from legacy system and develop Ab Initio applications and PL/SQL Functions, Procedures and packages and Unix Kshell Lead developer for CORE and Non-CORE applications for JPMorgan Chase Card Services Datawarehouse department COBOL dataset from legacy system Ab Initio, PL/SQL and Unix KShell Conduct functional or technical reviews, DMC presentations Lead developer for Disney Stored Value Cards and Business Cards Webfeed Applications Ab Initio, PL/SQL and Unix KShell Worked closely, as a lead developer, with BankOne Privacy groups and Enterprise data warehouse team for Enterprise privacy process to facilitate the needs of Risk management and customer development group Ab Initio, PL/SQL and Unix KShell Generate Customer information details from the TSYS feeds for Consumer and Business customers based on the analytical charactoristics COBOL dataset from legacy system Ab Initio, PL/SQL and Unix KShell Analyze the data feeds from Enterprise Datawarehouse and daily customer feeds and report the current or possible issues to Application lead and take necessary actions from IT perspective Lead developer for Internet Channel Marketing Datamart applications Ab Initio, PL/SQL and Unix KShell Developed 3 Ab Initio applications to process SASDATASET and loading into different DW schema for the datamart process Perform crucial roles on system testing or QA implementation and production jobs maintenance Key technology resource for Disaster Recovery process and maintenance
August, 2004 - January, 2005	Abinitio ETL Consultant
	GE Consumer Finance SATYAM COMPUTER SERVICES Shelton CT USA Worked closely with Business Analysts to gather business requirements and convert them into IT specifications Business + Technology Analysis Design and implement corrective measurements based on the production issues and tickets. Work closely with Offshore and onsite development team and GE resources. Conduct process status and review meetings with all stakeholders and publish dashboards ETL Extraction, Transformation, Loading process using Ab Initio Data Warehouse Application development using Abinitio, SQL, PL/SQL and Kshell Korn Shell Issue based analysis on the tickets raised by the GE Consumer Finance on data warehouse applications and resolve them in the speculated window Work closely with the offshore Satyam Technology development team to develop and maintain GE data warehouse data and applications Handle FDR data loading Process and data conversions Revisit the process specifications or component specifications and work with necessary groups to keep the GE data warehouse intact Data scrubbing based on the process requirements and production process and its maintenance
July, 2001 - August, 2004
	Horsham , PA . USA Role : Senior Programmer Analyst or Oracle - Abinitio Developer Environment : Oracle 8. x/9x, SQL, PL/SQL, Ab Initio, ERWin, Kshell, HP-UX 11, Sun OS 5.8, Visio, Clear Case, Tivoli, Autosys Handle campaign processes, Data loading, Account Review Process, Business Card process etc Create technical specifications and conduct review meetings Gather production issues, report to management and implement through future releases ETL Extraction, Transformation, Loading process using Ab Initio, PL/SQL and Kshell Application development using SQL, PL/SQL and Kshell Korn Shell Perform data analysis for Database Marketing and Data In teams. Data scrubbing based on the process requirements Ab Initio and PL/SQL Productionisation process Version control, QA process and maintenance Disaster Recovery process and maintenance
November, 2000 - June, 2001	Role : Software Engineer
	Installation and Administration of Oracle 8.1.6 Database on Win/NT Server Oracle Application Turning, Develop Oracle components, testing and implementation Develop Business Object repositories and components for clients Create and maintain proper documentations like Component Specification Document, Changes List etc
November, 1997 - November, 2000
	Mumbai INDIA

SKILLS SUMMARY

Operating Systems Ab Inito Co>Op 2.13 IBM AIX, Sun Solaris 2.5 and 2.7, HP-UX 11, Unix, Super Max Unix AT and T Compatible, Linux Redhat, MCS/AS Master Control Program or Advanced System, Windows 95/98/NT/2K/XP, DOS Hardware Sun Sparc Stations, Sun Solaris, HP Server, ORG SuperMax R3000 Server, Unisys A3K Mainframe System, Intel Platforms RDMS Oracle7 .x, Oracle 8.x, Oracle 9.x, Oracle 10g Languages Unix KShell, SQL, PL/SQL, Pro*C, C, DBMS-COBOL74, HTML, DHTML, JavaScript Applications or Packages SQL*Forms3.0/4/5, Developer/2000 Rel 1 and 2, GEMCOS, TMS, Harvest Version Control, Clear Case Version Control, IBM Tivoli Scheduling, SQL Navigator, TOAD ETL or BI Tools Ab Initio GDE 1.13 Business Objects BO5, Webi5 Database Tools ERWin, Visio
Skill years Skill years Ab Initio 5+ Data Warehouse 10 Oracle 10+ SQL, PL/SQL 10+ Oracle DBA 5 Unix. KShell Scripting 10+ Business Objects 1 ERWin or Visio 5 Pro*C 2 Unisys A3K Mainframe 4 Oracle Forms, Reports 2 Functional or Technical 8 TWS Tivoli job scheduler 8 Autosys job scheduler 1

MISCELLANEOUS

CTC-S, Tokyo, JAPAN TAURUS and VEGA System Role : Software Engineer Module leader, Developer Database Administration and Oracle Backend development Environment : Oracle 8.i, Power Builder 7, ERWin, PL/SQL, Pro*C, Sun Solaris 2.5, Win/NT 4.0 and Win 95, Sun Spark or Sun Solaris Kshell, Intel Platforms ETL and back end development using PL/SQL components Conversion of Sybase Pro*C to Oracle8 Components and front end development using Power Builder Data mapping Mapping and conversion routines Reporting using Pro*C, Develop user screen using Forms 5, Data Warehouse schema development Data loading using SQL Loader Database administration Oracle 8 or 8I on NT 4.0 and Solaris 7 and Performance tuning Team Coordination TCI : TRAVEL CORPORATION INDIA LIMITED Role : Senior Database Developer Database Administration, System Analysis, Application design and development Environment : Oracle7 .x, SQL Forms3.0, Pro*C 1.5 and Developer/2000, ORG Super Max R3000 Server Kshell In-house application design and development for TCI, Pune India branch Database Administration on Oracle 7.x, and 8.x Development and maintenance form Rail, Domestic Air, International Air, Tours, Accounts, Payroll and Business center modules Data analysis and IT documentations. Development on SQL, PL/SQL, Pro*C 1.5, Forms 3.0 or 4.5, Unix Shell Scripts System Analysis, testing and implementation Work with Mumbai IT head office and do hardware or software upgrades. KEOL : Kirloskar Oil Engines Ltd Pune, INDIA Role : Database Developer, System analysis, System Administrator, Database design and development Environnent : Unisys A3K Mainframe, DBMS Cobol74, DASDL, dBase III Plus, MS DOS 3.1 System Study or Requirement Analysis or Design Development using DBMS Cobol 74dBase III Plus, FoxPro GEMCOS Generalized Message Control System maintenance TMS The Manufacturing System maintenance DM UTILITIES Database Management Utilities TEST BED Analysis. Rajeev Mathew Sankarathil