Professional Summary

. SAP BW/BI/BO consultant having over 5 years of professional experience

which includes over 5 years of SAP BI/BW experience, 2 year of SAP BO

experience and 1 year of SAP ABAP experience.

. Completed 2 Full Life Cycle Projects in SAP BI/BW/BO

. Experienced in Pharmaceuticals, Financial Services, Energy, Retailing,

Manufacturing

. Having very good technical skills, functional knowledge of SAP ECC

application areas like SD, MM, and FICO.

. Experience using BWA (Business Warehouse Accelerator) extensively.

. Involved in 3 full cycle implementations, which includes Gap Analysis,

Requirements gathering, Blue printing, Development, Testing,

Reporting, Go-live and Post Go-live support.

. Delivered optimized solutions which helped in reducing the processing

time and thus improving the efficiency of the Business Process.

. Handled End User and Corporate Trainings for SAP BW 3.5/BI 7.0/BI 7.3.

. Excellent communication skills and Won Appreciation from the clients

worked.

. Subject Matter Expert to explain technical terms, single point of

contact to provide solution to clients operating with a strong sense

of urgency.

. Ability to work under pressure with cross-functional, cross-geographic

and cross- cultural teams. Exceptional ability to quickly master new

concepts and technologies.

SAP BI 7.0/7.3 Expertise

. Worked with the creation of Info Objects, Data sources,

Transformations, Data Transfer Process, Info cubes and Data Store

Objects.

. Worked with Process Chains to monitor the data loads and ensure

quality data.

. Worked with all the DTP processes to extract the data from the PSA.

. Worked on Error Handling procedure.

. Proficient in OLTP extractions of SAP LO-Cockpit, SD, FI, MM, APO,

generic extraction, flat files & using DB Connect for legacy data.

. Implemented the data extraction process on BI 7.0/7.3 that includes

installation of the Business content, creating data transfer processes

(DTP) using the graphical UI provided by new BI 7.0 features.

. Developed Start routines, End routines and Expert Routines using ABAP

to incorporate Business logic and perform data manipulation.

. Using BEx Query Designer to define complex queries, defining

Exceptions, Conditions which are later deployed in variety of

scenarios like Excel workbooks and web applications.

. Expertise with BI reporting for Data Analysis with BEx Analyzer, Web

Application Designer (WAD) and implementing BEx Queries, Variables and

Workbooks.

. Migration requirements related to BEx Query Designer, BEx Analyzer and

BEx Web Application Designer.

. Knowledge in creating Multi providers and Info sets.

. Experience in Performance Tuning using Aggregates, Rollup, Multi

Providers, Indexing, Partition, and Compression.

. Knowledge in SAP BI 7.0 security authorization concepts: create

authorizations, profiles, assign profiles to users etc.

. Worked on the Planning scenarios for financial and sales applications

using IP.

SAP BW 3.5 Expertise

. Extensively worked on different types of Info objects, Data sources,

Info Sources, Info packages, PSA, Info Cubes, ODS, Multi providers,

Info sets, Business content, Update rules, Communication Structure,

Transfer rules.

. Undergone Implementation of BW which includes Data Loading (Full

/Delta Up-Load), Scheduling, Monitoring, Process Chains, Performance

Tuning, Data marts.

. Activated, Installed and Extended Business Contents based on Gap

Analysis established on user requirements.

. Expertise in Data Loading (Initial / Delta Up-Load), Scheduling,

Monitoring.

. Worked extensively in Front-end Business Warehouse Components like

Queries, Calculated key figures, restricted key figures, Structures,

Variables, Exceptions and Conditions.

. Worked extensively on Data Extraction from SAP R/3 using LO

Extraction, Scheduling, Monitoring, BEX Analyzer, BEX Browser,

Workbooks, and Report-to-Report interface.

. Creating Line item dimensions, optimizing data loads, defining Info

Cubes aggregates, Roll-ups, Compression, Info cube Partitioning,

indexing, Remodeling, query optimization.

SAP BO 3.1/4.0 Expertise

. IDT: Creation of OLAP and OLTP Connection using IDT.

. Universe Designer: creation of universe from BI Info Cubes, queries

and databases.

. Web Intelligence: creation of reports from universe and formatting of

reports.

. Info View: creating corporate dashboards from dashboard builder in

info view and link your reports to the dashboard.

. CMC: create and give access to other applications and maintain user

authorizations etc.

. Query as a web service: created the query and publish the query as a

web service.

. Xcelsius/Dashboard: created excellent dashboards.

. Crystal reports: create the reports from SAP BI Info Cubes and create

the report from query as a web service.

. Dashboard builder: created corporate dashboards and link the reports

to the dashboards and linked the dashboards to the dashboard.

. Used the Information Design Tool (IDT) to establish connection and

created different resources for BO Reporting. Created WEBI Report,

OLAP Analysis report, Crystal report, Dashboard (Xcelsius) and Live

Office Reports.

Technical Skills

ERP SAP ECC, SAP R/3.

Data warehouse SAP BI 7.3, SAP BI 7.0, SAP BW

Tools 3.5, SAP BO 4.0 and SAP BO XI 3.1.

Languages ABAP/4, C, C++, Java, VB, HTML,

DHTML.

Operating System Windows 95/98/NT/XP.

GUI SAP GUI.

RDBMS Oracle9i.

Professional Experience

Promega Inc, Madison, WI

Aug 2012 - Till Date

Role: SAP BW/BI /BO Developer

Responsibilities

. Enhanced 0mat_unit, 0customer_attr and 0material_attr to incorporate

new fields and wrote Customer Exit to retrieve the data.

. Enhanced Material Movements Data source and wrote customer exit to

fill the new fields.

. Created a custom hierarchy to extract transaction data from SAP ECC

and wrote custom program to fill the Hierarchy.

. Extracted Sales Order, Replenishment Order, Check in transaction data

into SAP BI using Dbconnect and modeled the entire flow starting from

Data source, DSO and Cube design to creating Bex Report on top of

Multiprovider.

. Modeled Ordered Vs Delivered, Sales Actual and Sales Breakage Data

models till reporting.

. Created Process Chains for all models having Selective deletion and

event driven functionality.

. Created Expert, Start, End and Field level routines as per the

requirement.

. Created Filters by writing ABAP Routine at Info package level.

. Generated the Technical Design Documents for Procurement, New-GL and

CCA.

. Implemented Reporting Financials for Profitability Analysis.

. Implemented Hybrid Provider for CCA to get direct access to data from

ECC and replicated data from SAP BI.

. Created reports on Purchasing Data Cube in existing flow.

. Activated Business Content specific to the requirement.

. Created Virtual Provider in SAP BI 7.3.

. Used the Information Design Tool (IDT) to establish connection and

created different resources for BO Reporting. Created WEBI Report,

OLAP Analysis report, Crystal report, Dashboard (Xcelsius) and Live

Office Reports.

. Created Dashboards, WEBI Report and Crystal Reports.

Environments: SAP BI 7.3, SAP BO 4.0, SAP ECC 6.0.

Merck, Lebanon, NJ

Feb 2010 - July 2012

Role: SAP BI Developer

Responsibilities

. Conducted requirements gathering workshops with key business users to

understand existing challenges.

. Reviewing the functional specifications and generating the technical

specification and design with gap analysis.

. Conducted end user training on BEx Query Designer and Analyzer.

. Helped coordinate meetings on project status, open issues, and overall

progress to goal.

. Worked with functional team to perform extensive testing on queries

before coordinating the production change requests (transports) with

SAP Basis team.

. Involved in end to end design and development of Sales and Operations

development starting from extraction to front end reporting.

. Used BWA to improve the query performance.

. Created Exception and Customer Sales Operations Reports.

. Created Start, End and Expert routines according to the requirement.

. Created Multi providers and enhanced queries for optimal performance.

. To accommodate P2P process in BI, Extracted data using FM extractor

from ECC to BI and then modeled IP s in BI and generated reports on

top of MP.

. Developed Static and Dynamic cubes for GL reporting.

. Modeled Mail AR and Premium Billing aging and details cubes.

. Extracted data from Aging cubes to files using OHD.

. Generated reports for Mail AR and premium billing.

. Involved in High level Design & development of SAP BI Backend Data

modeling and Frontend Reporting.

. Conducted requirements gathering workshops with key business users to

understand existing challenges.

. Created OHD for extracting data from different source DSOs for

different ledgers.

. Created alternate Hierarchies for 0COSTCENTER and 0PROFIT_CTR master

data and loaded through flat file.

. Created Average Daily Balance variance reports to compare BI and

Source System data.

. Ensure that all periodic schedules like daily/weekly and monthly are

successful.

. Analyze the errors occurred while uploading the data if the request

fails and make the latest data available in data target.

. Extracted data using view from ECC to SAP BI and modeled IPs and then

generated Road Permit Status, Road permit Stock and Nil Permits

reports on them.

. Extracted data using view from ECC to SAP BI and modeled IPs and then

generated Labor Cost analysis report on it.

. Modeled IPs and generated Sales Comparison Report for Yearly, Monthly,

Weekly and Daily.

. Created start routines, End routines and Transformation rules

according to the requirement.

. Validating user input in the initial screen of the sales report using

Customer Exit.

. Ensure that all periodic schedules like daily/weekly and monthly are

successful.

. Analyze the errors occurred while uploading the data if the request

fails and make the latest data available in data target.

. Installed relevant business content objects as and when required.

. Conducted requirements gathering workshops with key business users to

understand existing challenges.

. Understand the client requirements and developing the Reports and

dashboards using business objects tools.

. Building of the Universes for the reports using Business Objects

Designer.

. Successfully Integrated SAP BI with SAP business objects XI3.1.

. Developed Various Reports in Web intelligence to track Sales

periodically.

. Organized data in reports by using filters, ranking, alters and sorts.

. Created Crystal Reports with hierarchies and Filter.

. Developed highly formatted reports using Crystal Reports on top of BEX

Queries.

. Created, designed and implemented Universes, WebI, Crystal Reports and

Xcelsius Dashboards.

Environments: SAP BI 7.0, SAP ECC 6.0, Business Objects XI 3.1.

PSE & G, Newark, NJ Mar 2008 - Jan 2010

Role: SAP BI/BW Consultant

Responsibilities

. Designed and developed new BI models optimized for reporting and

satisfying the business needs.

. Created Generic data source to extract Sales activities transaction

data for

reporting to sales activities analysis such as Sales Activity status,

Customer, Start & End of sales Activity.

. Generated pending PO and PR report.

. Performance tuning of queries & data load by maintaining query read

mode,

Aggregates, Index & Statistics & Compression.

. Involved in Transporting the BI objects from development server to

Quality

server for Integration & Pre- production testing before UAT.

. Detected/resolved data Cardinalities and loops, checked integrity of

Universes.

. Involved in developing Universe and reports on SAP BI including DSO,

Info Cubes, Multi Providers and BEx Query development.

. Measure Objects and dimension objects were created keeping in view of

the end-user requirement.

. Defined business objects standard reports & ad-hoc reports and Created

report templates for consistency in the look and feel of the reports.

. Developed complex reports using Business Objects functionalities like

Slice and Dice, Drill down, Cross Tab, Master detail and Formulas etc.

. Implemented dynamic charts and graphs in dashboards to improve look

and feel using Xcelsius.

. Responsible for data extraction, reconciliation and reporting.

. Responsible for loading time dependent and time independent master

data and hierarchies.

. Created Start routines and End routines using ABAP in transformations

to update characteristics and key figures in the Info Cubes.

. Performed Remodeling on already existing Info Cubes to add new key

figures and characteristics.

. Designed process chains for daily master data loading, transactional

data loading from ECC.

. Created & Scheduled Info Packages and populated DSOs, Info cubes with

full and Delta Update.

. Uploaded Transaction Data from the Flat File as the Source System.

. Used Write-optimized DSO's for staging huge volumes of data.

. Created a routine to select a file dynamically on Application server

which comes from portal to SAP BI every day.

. Created Factory calendar for scheduling the Info package on particular

day of a week at particular time interval.

. Monitoring of Info packages and analyzing the reasons for frequent

failures of Info packages.

. Wrote routines to handle Invalid characters.

. Involved in all phases of Implementation of Secondary Sales Analytics

Project in Britannia.

. Extracting Master & Transaction Data using Generic Data Sources from

OLTP.

. Setup the Statistical Setup for the LO-Cockpit and used the V3 Update

for Delta Management.

. Developed validation program in Process chains to generate Error log

on File validation, Invalid data and Availability of Master data.

. Involved in Info Cube maintenance i.e., Compression, Roll-up.

. Designed various types of Queries and generated reports using BEx

Analyzer.

Environments: SAP BI 7.0, SAP ECC 6.0.

1 EDUCATION

. University of Ibadan - B.A in Philosophy

. Enugu State University - Computer Science.

Contact this candidate