Sampath A E-mail: ad4low@r.postjobfree.com

SAP BODS Analyst Phone: +91-997*******

Professional Summary

11+ years of Professional IT Experience in SAP Business Objects Data Integrator / Data Services & Business Objects.

Involved in BODI/BODS (Business Object Data Services) Projects End to End implementation, Data Integration, Migration, Support and Upgradation projects.

Developed Workflows, Data flows based on the specifications using various stages in BODI/BODS.

Experienced in various Data integration, platform transformations and flat file concepts.

Worked on Data Migration from legacy systems to SAP systems.

Experience on BODS with SAP and Non-SAP Data sources and Native SAP HANA Modelling.

Integrated SAP HANA with BOBI reporting tools (AO Reports, Web Intelligence).

Data Migration using LSMW, BAPI, and IDOCs.

Involved in the preparation of test scripts, Unit testing, Source code reviews and performance tuning of objects during system and integration testing.

Experience in configuring SAP ECC 6.0 with Data Services system.

Capability of scheduling, maintaining & designing SAP BO Webi Reports.

Experience in Upgradation of SAP-BO suite and BODS.

Experience in SSRS reporting tool.

Technical Skills

ETL : SAP BODS 4.2, 4.3

Reporting : SAP BO, SSRS

Databases : SQL Server, Oracle 9i/10g, SAP HANA 1.0

Platforms : Windows 2000 / 2003/2008 / XP, UNIX.

Other Tools : Responsys, JIRA, Tidal, ITSM

Employment History

Numeric Technologies India Ltd, from Jan-2020 to till now.

MaxChar Technologies, Pune from Aug-2016 to Dec-2019.

GeoReach Technologies, Pune from Jan-2016 to Aug-2016.

Zensar Technologies,Pune from May-2013 to Dec-2015.

KPMG Advisory Services Pvt. Ltd. from Feb-2013 to May-2013

HCL Technologies from Sep-2011 to Dec-2012.

Awards & Certifications:

Recieved Emerging Star award for outstanding contribution in Zensar Technologies.

Project of the year award in Zensar Technologies.

PROJECTS DETAILS

Project# 1:

Client : Mohawk Industries

Environment : SAP BODS, BO, HANA

Duration : Jan 2020 to till date.

Role : BODS Data Analyst.

Responsibilities:

Implemented logic to send out the zipped Excel reports through BODS tool as an Email

attachment.

Configured BODS with SAP ECC to extract data from ECC tables into staging.

Extensively used History Preserving, Table comparison, Map, Case transformations.

Designed batch jobs to load the data into HANA systems.

Experienced in using report bursting to distribute the BO reports to different regions.

Worked on the XML files to extract the PIM data into HANA.

Scheduled Batch jobs in Tidal Automation tool.

Designed and Prepared High level and Detailed level Test cases.

Extensive Experience in setting up environment for the project that involves creating the groups in CMC, adding users, mapping the row level and object level securities, migrating objects and universes.

Worked as Production Support Lead for the Business Objects Reporting Environment.

Project# 2:

Client : Clearly (COASTAL CONTACTS Inc.),Canada

Environment : SAP BODS, BO, MS SQL Server 2008

Other Tools : SSRS, Oracle Responsys

Duration : May 2013 to Nov 2019.

Role : BODS Consultant.

Responsibilities:

Created data model & designed several complex data flows for Oracle-Responsys, Bronto cross-channel marketing tool.

Implemented dependency between the batch jobs.

Implemented logic to build flat files with header & multiple line Items data.

Event & time-based scheduling of SAP-BO Webi Report’s.

Designed reports using SS reporting services (SSRS).

Extensively worked on promotion management to migrate the webi objects across environments.

Enhancing the existing Webi reports design.

Implemented files archiving using windows batch file.

Importing & exporting data to Responsys database via flat files.

Enhancing the existing design of data flows according to business requirements.

Experience in writing the custom functions.

Project# 3:

Project Name : Data Migration.

Client : Jindal Steels (JSW)

Environment : SAP BODS 4.0, Oracle 10g, Windows

Duration : Feb 2013 to May-2013.

Role : BODS Developer.

Responsibilities:

Designed various Data Flows for extracting data from various sources including excel work books and relational tables.

Created lookup functions explictily to populate the corresponding data from lookup tables.

Extensively uploaded data using LSMW methodologies.

Uploaded the data into SAP-ECC system using IDOC’s.

Automated the process of uploading the purchase order data LSMW BAPI.

Uploaded Bank Master, Goods Receipt using LSMW IDOC.

Involved in client meetings to understand the requirements.

Project# 4:

Project Name : LBG-PCCP.

Client : Lloyds Banking Group, UK

Environment : SAP BODS 3.2/4.0, SQL Server, Windows

Duration : July 2012 to Dec 2012.

Role : BODS Developer.

Responsibilities:

Analyze the eMLPD and prepare the Technical design document (DPAD) for the SAP-Data Objects.

Developed data flows as per the Coding Standards mentioned in DPAD.

Implemented standard framework to run the jobs.

Worked with Unix Server for Flat files storage & Scheduling jobs.

Creating Global variables and Substitution parameters.

Loaded data from source files into SAP ECC using IDOC’s and BAPI’s.

Implemented SCD Type-2 to preserve the history of data.

Used validation rules to populate messages for mandatory columns.

Experience in Automation of jobs through Management console & Creating Batch jobs.

Worked on Unix Commands for Copying, Archiving of files on daily basis from ftp Locations, implementing logic & daily scheduling of UNIX .sh jobs.

Prepared the Unit Test case document, Unit Test Log and code review template.

Code Review and Performance checking of peer objects.

PROJECT# 5:

Project Name : Code Migration.

Client : Wloters Kluwer, UK.

Environment : SAP BODS 3.2, Oracle 10g, Windows

Duration : Sep 2011 to Jun 2012

Role : BODS Developer/Administrator

Responsibilities:

Extracting Data from SAP ECC 6.0 and from Non-SAP systems like OMS, TURBO, NXT.

Implemented Slowly Changing Dimensions type-2 technique to load current and Historical Data.

Designed various Data Flows for extracting data from various sources including flat files and relational tables.

Implemented conditional flow within batch jobs.

Worked with different transformations like (History Preserving, Table Comparison, Validation, SQL Transformation, Case and Table Comparison, Row Generation).

Using SQL Queries like inner joins, Outer joins and DDL, DML commands to testing the data at the database level.

Created custom functions to implement reusable logic.

Handled administration related issues like, creating local and central repositories as per client requirements SAP BODS.

Extensively worked on management console.

Created Users and providing access to them.

Configured Job Servers with repositories

Resolved tickets within a specified SLA time.

Education

Master of Computer Applications(MCA) from Osmania University.

Contact this candidate