SAP BODS Expertise:

Ø Data Profiling – worked on pre-build data analysis and objects identification & classification.

Ø Data Cleansing – worked on pre-transformation data cleansing in source data extracts and snapshots.

Ø SAP standard solutions - Worked with standard RDS and BPDM jobs & objects.

Ø Object build using BODS objects like Projects, Jobs, Workflow, Dataflow, File Formats, ABAP Data flows and transformations under Data Integrator and Platform categories.

Ø Data manipulation using BODS in-built functions, transforms and SQL scripts.

Ø Job execution control using Global variables, Substitution parameters, Scripts

Ø Scheduled, executed, and monitored jobs from Central Management Console and 3^rd party tools like CPS Scheduler, TIDAL scheduler.

Ø Performance optimization on data extracts and transformations of large data sets.

Ø Performed data cleansing during transformation using Custom functions on specific source field data

Ø Have good understanding of iDocs generation, iDocs processing and relevant settings setup at SAP system and BODS end.

Ø Created pre-load / post-load reconciliation views (SQL & BODS table joins) for validation sign-off.

SAP BW/Data Warehousing Profile:

Ø Provided solutions to Front-end issues for 1100+ BW reports & dashboards to system users.

Ø Design, implement, and fix issues related to Data loading and Process chains in the system using BW Objects as per business logics.

Ø Scheduled process chains and jobs through 3^rd party schedulers with and without dependencies.

Ø Automated post-load reports reconciliation of daily/monthly report refreshes.

Ø Implemented 8 enhancements in project to stabilize the system and received 4 recognitions from Client for the same.