SAP/DW Analytics Resume

SUMMARY

Skilled in SAP Data Migration, Data Warehousing and Data Quality during his 10 years of professional career.
Have worked with leading technology service providers like Confidential.
Worked with High - Value clients like Confidential.
Proficient SAP BODS consultant with 6 years of experience and SAP BO consultant with 4 years of experience.
Has strong analytical skills using Excel and SQL.

TECHNICAL SKILLS

PROFESSIONAL EXPERIENCE

Confidential

SAP/DW Analytics

Responsibilities:

Develop BODS transformation job for Legacy to SAP data Migration.
Work with system user for extraction of Legacy data for different SAP WRICEF objects.
Lead and support development process done from offshore.
Plan and design Data cleansing approach for Customer Master Data using BOIS and BODS DQ.
Develop cleansing Package and IS rules in BO Information steward, Develop BODS Job, Create BO Universe and WEBI reports.
Upgrade to SAP BODS to 4.2 and Perform Job Migration.
Support System testing, Integration testing and User Acceptance testing.

Confidential

Team Lead (SAP BI operations)

Responsibilities:

Create Technical Design documents for different WRICEF objects for Migration to SAP.
Develop Jobs to migrate data from legacy to SAP systems.
Optimize existing Jobs to perform faster transformation of data.
Technical Team Lead in multiple projects. Max team size handled is of 15 members.
Installation of SAP BODS 4.2 on Windows server, creation of repositories and managing users and admin activity in CMC.
Worked with business on Conceptual Data modeling and transform to Logical and Physical model.
Use DQ tools for Implementation of Deduplication using Match/Associate and Data cleansing using Address, Data cleanse transform etc.
Extract data from various sources like SQL, ORACLE, Flat files, XML, SAP ECC.
Support existing BODS daily scheduled data warehouse jobs and address any data issues reported.
Upgrade and work with BODS directories/files on UNIX server.
Use SAP TCODEs for data Analysis to support BODS development process.
Load data in SAP using LSMW methods like BDC, Batch input, iDoc.
Modify existing Business Objects Universe as required for business needs.
Create new and modify existing WEBI reports.
Used Alerts, Variables, Prompts, and also generated hyperlink reports using WEBI.

Confidential

Analyst Programmer

Responsibilities:

Created training Documents on SAP BODS, organized several training sessions on SAP BODS.
Created mapping documents to outline data flow from sources to targets.
Created sessions, configured workflows Informatica to extract data from various sources, transformed data, and loading into data warehouse.

Confidential

Asst. Manager (BI Operations)

Responsibilities:

Support creation of Data Mart using standard Data model design.
Developing SAP BODI ETL jobs for loading data to the Data Mart.
Develop BO WEBI reports using Drill Down, Graphs, complex filters, prompts, sub queries and free hand SQL.
Create BO Universe on SQL Server Data source.
Utilized Calculation contexts for several WEBI reports.
Defined Derived Tables, Aliases, Classes, Objects, Dimensions, Measures, Details, Conditions, Joins and Contexts in Universe.
POCs for new Product Management/Analysts requirements.
Analysis of DW and different live databases for implementation of reports
Providing end to end solution on the productivity reports through analysis required by management.
Close co-ordination with Product Team Functional requirement gathering.
Working with IT vendors to reduce SLAs by automating the reports using BOXI

Confidential

Analyst

Responsibilities:

Preparing the DTS job for loading data to server.
Analyzing revenues generated by SKUs on Confidential .Com using SQL queries.
Allocating appropriate Product category to new and existing SKUs on the website to ensure better penetration of desired customers