Gideon Sundarsingh

Background

About Gideon Sundarsingh

Professional Summary •Having around 9 years of IT experience in ETL environment with projects involving Development and Implementation, Data Migration, Platform Migration, enhancements and Support with Hands on experience on requirement analysis, design, development, testing, deployment and support. •Currently working as SAP BODS Team Lead (Land scape involving SAP BODS 3.2 & 4.2, SAP, Salesforce, People Soft, Oracle HFM, Oracle Data warehouse, Tableau 9 & 10 and IBM Cognos Analytics 10 & 11) in WABCO India Private Ltd and previously as SAP BODS Senior consultant in NTT Data Global Delivery Services India Ltd and SAP BODS consultant in IBM India Private Ltd. •Played the role of ETL Data Migration Specialist for almost 7 years involving Projects with Data migration from Various Legacy systems like ( People Soft, Maximo and other complementary Applications ) to SAP ECC and Various other Modules and also Involved in projects with Platform migration between the ETL Technologies •Involved in Data Warehouse Implementations working with Data Conversion and Extraction/Transformation/Loading (ETL) using Informatica Power center/SAP Business Objects Data Services/ IBM info sphere Data stage with Oracle, SQL Server and DB2. • Proficient in using SAP BODI/ BODS 3.2,4.0,4.1 and 4.2(Data Services Repository Manager, Data Services Designer, Data Services Server Manager and Management console). • Created Jobs, Workflows, Dataflow, Transformations according to the specific requirement/details given by the source data to integrate it to the target warehouse • Good experience in cleansing of Master data using data quality transforms and platform transforms. • Hands on experience on extracting and loading data from SAP ECC and SAP BW and working with IDOC’s, Calling BAPI from Data Services and Creating Custom APAP in data services. • Implemented SAP HANA Replication using SAP BODS. • Extensive Experience on BODS migration from 3.x to 4.x • Have Good knowledge on BO Reporting Tools ( IBM Cognos and SAP BO ) • Extensive Knowledge on Integration between Salesforce and SAP. • Good knowledge on SAP Functional modules ( SD,MM,FI, CO, WM,QM and PP ) • Sound Knowledge on Data Warehousing Concepts such as Metadata Repository, Data Mining, Data Mart, Star Schema, Snow-flake Schema and OLAP. • Good experience in SCD s implementation. • Experience in Tuning ETL Jobs and CDC using Time stamp, and also set up validation rule. • Hands on experience on information steward for data profiling. • Hands on experience on extracting and loading data from SAP ECC and SAP BW