Consultant (SAP/DW Analytics) Resume

SUMMARY:

Expertise in SAP technologies - BODS, BO, Information Steward with SAP Data Migration, Data Warehousing and Data Quality in past 12 years and leading team since past 5 years.
Have worked with leading technology service providers like Confidential and with High-Value clients like Dell, Confidential, Carrier (UTC), 3M, Nestle, and DuPont.

PROFESSIONAL EXPERIENCE:

Confidential

Consultant (SAP/DW Analytics)

Develop BODS transformation job for Legacy to SAP data Migration.
Support data analyst to create mapping for extraction of Legacy data for different SAP WRICEF objects like Pricing, Customer Contracts, Chargebacks and more.
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.
Created data models on SAP HANA SP8.
Upgrade to SAP BODS to 4.2 and Perform Job Migration.

Confidential

Team Lead (SAP BI operations)

Create Technical Design documents for different WRICEF objects Customer Master, Material Master and more, for Migration to SAP.
Support conversion mapping from legacy to SAP including but not limited to Customer and Material master.
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.
Create Real-Time BODS jobs to extract data from xml and load to Datamart.
Use SAP TCODEs for data Analysis to support BODS development process. Load data in SAP using LSMW methods like BDC, Batch input, iDoc.
Created Attribute, Analytic and Calculation views in SAP HANA.
Create sessions, workflows in Informatica and troubleshoot production jobs.
Modify existing Business Objects Universe as required for business needs.
Create new and modify existing WEBI reports.
Optimize Universes by resolving join problems, setting up aggregate awareness, defining hierarchies, cascading LOV, @Functions and more.
Used Alerts, Variables, Prompts, and also generated hyperlink reports using WEBI.

Confidential

Analyst Programmer

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)

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

Preparing the DTS job for loading data to server.
Maintaining Excel based tools on the intranet of Dell which are designed using Macros and helpful to Dell Sales representatives to get quick access to top selling SKUs.
Analyzing revenues generated by SKUs on DELL.Com using SQL queries.
Allocating appropriate Product category to new and existing SKUs on the website to ensure better penetration of desired customers

TECHNICAL SKILLS:

SAP Business Objects Data Services, Information Steward, SAP HANA modeling, SAP Business Objects BI, SAP ECC
Informatica
SQL Server 2012, Oracle 11g
MS office applications(Excel, Word, PowerPoint)

We provide IT Staff Augmentation Services!

We'd love your feedback!

Resume Categories

Client Services

Job Seekers

Visa Sponsorship