Rammurthy Shekar

Understanding customer requirements in order to transform the customer data to Ariba reporting schema
Do POC on small set of customer data to create mapping of fact and dimension tables.
Use ETL tool – SSIS – SQL Server Integration Services to perform the ELT tasks.
Extraction, transform and load data from various heterogeneous data sources and destinations like Access, Excel, CSV and flat files.
Build packages in SSIS to perform step by step ETL process based on the stages - pre transformation, Transformation and QA stage.
Include lookup tables wherever required and use multiple dedicated containers like Derived Column, Merge, Aggregator, Sort etc to
structure the data according to Ariba star schema.
Reviewed existing business procedures and recommended and implemented changes.
Trouble shoot problems with the various teams including network related issues
Knowledge on Facts and Dimensions tables

Use ADE(Ariba Data Enrichment) tool to import customer’s Spend data
Classify data based on Spend and Suppliers
Link the suppliers to their Global Ultimate Parent using D&B
Provide Diversity, Financial and green information