ALERAT(KEMI) ALLI-ONIFADE

*** ***** *****

Atlanta, GA 30324

925-***-**** (Cell Phone)

ab96gr@r.postjobfree.com (E-mail)

[pic]

CAREER SUMMARY

Senior SAP BW Consultant

Decisive, action-oriented and results-focused professional offering over

25 years of professional experience in Information Technology, including

more than 8 years as a SAP BW consultant. I have had various roles as a

Team lead, Project manager, Consultant, Developer and Analyst.

. Functional experience in GL, AP, AR, CO, SM, SD, CRM, PM, QM, MM, PP, OO

modules in SAP R/3.

. Utilizing SAP BW as EDW which incorporates data from PeopleSoft HR, ECC

and MicroSoft Database through DB connect, UDC connect.

. Completed 10 full life cycle BW implementations on platforms of BW 3.0B,

3.1H, 3.5 and 7.0, NetWeaver 2004s to NW 7.4 which includes business

content installation, Gap analysis, Data-Modeling, Data Extraction, Data

Presentation, Data Loading (Full/Delta Upload), Scheduling, Monitoring,

Report broadcasting, creating Process chain and Production Support.

. Strong in customizing & developing SAP BW components such as InfoCube,

ODS/DSO, Multi-Provider, Remote Cube, Transfer Rule, Update Rule,

Transformation Rule(7.0), InfoSet, InfoSource, InfoObject, DataSource,

InfoPackage, DTP, Open-Hub and DataMart.

. Extensive experience with various SAP and non-SAP extractions: Flat file,

BCT, SAP CRM, LO Cockpit, CO-PA, FISL, Cross-Application generic

extraction from DB view, SAP Query, Function Module.

. Worked extensively on Bex Query Designer, Bex Analyzer, Dashboard

Report/Web Application Designer (WAD) with HTML, Queries on MultiCube,

RRI, template, Value sets, Jump, condition, exception, Infoset queries &

drill-through queries, VB code enhanced workbook, Visual Composer,

Publishing iView to Portal, integrating Bex query with BO Crystal Report,

Xcelsius, Universe and Webi.

. Report Performance Tuning using Data Compression, Logical and Physical

Partitioning, Archiving, OLAP cache, Aggregate, Dimension Sizing.

. ETL Performance Tuning through ABAP code optimization, system resource

balance and load parallelism.

. Proficient in data manipulations, report/graph generations using data

steps with various SAS functions, procedures, macros and ODS facilities

. Experience in data management and analysis of data for statistical

analysis, list & summary reporting

. Excellent interpersonal, analytic, problem solving and communication

skills with the ability to interact with individual at all levels

PROJECT EXPERIENCE

GAP Inc, San Francisco, CA Aug 2010 -

Present

SAP BW Sr. Developer (BI 7.3 on NetWeaver 7.4, ECC6)

Platform: SAP NW7.0, SAP ECC6, GL, AP, AR, CO, HR, OO ABAP, BODS, BADI,

BEx Designer/Analyzer, Web Application Designer, EP/SAP BI Portal

Responsibilities include:

. Year-end Partitioning for CO, AP, AR, HR and GL: Built objects for year

2011 partitions which include 12 InfoCubes, 11 DSOs, 62 transformation

rules, 65 process chains. Modified 21 multiProviders and configured

pruning entries for the purpose of dataset separation and reporting

performance improvement.

. CO Plan/Actual and HR Data Archiving: Moved data to keep most recent 2

year data in current cube, previous 5 years data to historical cube and

all other years data to ancient historical cube. Run RSRV and DBSTATS to

ensure data consistency.

. Scheduled Hours: Built DSO, InfoCube, Transformation with complex logic

to provide

weekly estimated and scheduled details for selected division, resource

type, work type, program, year and time frame (calendar week)

. Project Details/Activity Type/Multiyear/Summary: Built BEx queries to

limit plan data under cost element hierarchy of Order Financial Cost and

give detailed information of project quantity and amount for labor,

material, contract and other for each combination of year, month, cost

element, etc. by a given year, plan version and set of PM orders. Created

5

function modules to pass parameters and call queries. The returned

results of queries will be sent back to ECC for Proxy reporting.

. Staging Cube Cleanup Process: Created shadow cube, transformation to

blank out

time stamp for records older than four months before uploading data to

BPS plan cube for performance improvement.

. Back-to-back Delta load: Built event, schedule background job, enhance

process chain to perform back-to-back delta load.

. PVA plan cube load: Built PVA plan cube, transformations and DTPs to load

data from WIP detail plan and BPS plan.

. BroadCasting implementation for PVA/SVC text translation errors:

Configured broad casting setting for queries of PVA/SVC text translation

errors. Built process chain to automate

error files sending via broadcasting.

. CO Production Support: Monitor, communicate and troubleshoot issues with

data

Intuit Inc, Menlo Park, CA Aug 2009 -

July 2010

Role: SAP BW Sr. Analyst (BI 7.0 on Net Weaver 2004s, ECC6)

Platform: SAP NW2004s, SAP ECC6, GL, AP, AR, CO, SM, SD, CRM, PM, QM, MM,

PP, OO ABAP, BADI, BEx Analyzer, Web Application Designer, EP/SAP BI Portal

Responsibilities:

. Implementation of SD BW: Implemented extractors of sales order

header/item, sales order schedule line, sales order delivery link,

billing item and consolidated data into an infoCube. Built Order to

Cash report that will consolidate monthly Sales Orders for Spares,

Warranty, Contract orders and Invoice of spares sold. It allow users to

view data of sales org, distribution channel, division, reason for order,

reason for rejection, delivery priority, net value, % revenue, cost,

order quantity, delivery cost, delivery amount, billing quantity, billing

net value, billing cost, billing items. Users can drill down during the

run time to get detailed information such as SO item creation date,

Actual Goods issue date, billing doc. date, sold-to party, service order

type, transaction type, BU and group, etc.

. Metrics Reports: Built dashboard reports by Web Application Designer,

that displays charts and metrics, also allows jump from report to report

with RRI functionality.

. On-going maintenance and production support: Add new tools and customers

to scorecard system, and configure relevant process, state/substate,

failure category for a new tool. Enhance and support many BI reports such

as open production order status, production order header and item

details, shortage report, Actual delivery report, ECO activity report,

etc.

WELLSFARGO BANK, Concord, CA Apr 2007 - Aug

2009

SAP BW Technical Lead (BW 3.1C, 3.5 & on WebAs 6.20, R/3 4.5b, 4.7)

Platform: SAP R3 4.5, 4.7, EC-PCA, CCA, GL, AP, AR, CO, AM, PS, RE, HR,

ABAP, BADI, BEx Analyzer and Web Application Designer

. Lead the team of 4 members in BW migration process as R/3 upgrade needed

from 4.5 to 4.7. Came up with a strategic plan for moving BW objects and

coordinated well with corresponding upgrade conversions.

. Lead the BW team in data modeling and architecture design. Proposed

suggestions to use

multi-provider to report data in HR and RE modules. Created

modeling for combining CO

data such as plan, budget and actual for each WBS element presented

in PS hierarchies.

Review data architectures designed by other team members.

. Made cut over plan, analyzed data element, designed Logical Data Model,

created and executed integration test plan & string Test plan.

. Converted extractors, rules in R3 and BW for the changes of Company Code,

Cost & Profit Centers due to improved Business Process Requirements.

. Analyzed, designed, architected and implemented complex BW applications

of Project System, Profit Center Accounting, Controlling, Asset

Accounting, Real Estate Management and Human Resource.

. Analyzed report requirements, eliminated duplicates and combined similar

reports. Installed business contents and performed gap/fit analysis.

. Use ABAP object to develop a dialog program to update table entries used

as parameter control in BW loading.

. Develop following reports by using BAPI functions and ALV for result

display:

- Contract Renewal

- Lease Obligation

- Underutilized Space

- Vacant Customer Charged

- Vacant external

CISCO SYSTEMS, San Jose, CA Jan 2005 - Mar

2007

SAP BW Sr. Consultant (BW 3.5, BI 7.0 on Net Weaver 2004s)

Platform: SAP NW2004s, SAP ECC6, GL, AP, AR, CO, AM, SD, CRM, MM, PM,

ABAP, BADI, BEx Analyzer, Web Application Designer

Responsibilities:

. Implementation of SM&QM&ECO Project (Microsoft DB) EDW - Install &

Warranty to QN Metrics: This project incorporates data of CO object

expense, Service Order and Confirmation, Sales Order and Contract,

Upgrade, Equipment Master to build a detailed finance expense

report(overhead, part and labor) for equipments in the post-sale phases

of Install and Warranty. Filter out top 20(or top N) materials and merge

data from quality notification, project to build a system in BI which is

tracking high expensive Installation and Warranty Parts by Quality

Notifications(QN) to review correlation and other statistics. Lead

analysis, working closely with business users to finalize business

requirements. Designed, configured, and implemented tools for reporting

and analysis.

. Implementation of ECO (Microsoft DB) & QM EDW - ECO QN Metrics and

Dashboard: Combined ECO (Windchill via UDC) and QN (SAP) data together

into BI, implemented a system to track the effectiveness of the ECO

Project system by measuring the number of ECO parts released with and

without projects by the number of QNs categorized by engineering caused

QN type.

. Building Quality Notification Task Extractor: Customized standard

extractor to pull

40 more QN task related fields and ensure delta update in a correct

sequence.

. Implementation of SM BW - Install/Warranty/Contract Tool Report: Lead

analysis and custom designed DSOs, InfoCube, and extractors to build a

system, which reports tools in the phases of Install, Warranty and

Contract in a time dependent basis. This report includes information of

equipment, module type, equipment service transaction type, contract no.,

contract type, material, install location, serial no., sales order no.,

BU, platform, function location customer, customer no., original sales

order, tool counter.

. Implementation of FIGL BW - Historical Trend Report: Utilized standard

extractor GL line items and customized it with information from PO and

standard price. Built a system/report that provides trended historical

view of material cost variances.

. Upgraded processes from BW3.5 to BI 7.0 (Net Weaver 2004s)

KAISER PERMANENTE, Oakland, CA Mar 2005 - Dec

2005

Consulting Data Analyst, the Permanente Group (TPMG).Develop and maintain

benefit data in multiple file formats, standardize and convert data into

permanent datasets. Work with a varied degree of customers ranging from

support staff to top level executives in the business area of human

resources.

. Maintain complex statistical SAS routines using macros, vendor

software and written software using SAS, SQL, ORACLE, UNIX and EXCEL

. Delivery of timely, high quality and insightful ad-hoc and project

reports covering physician benefits

. Collate and manipulate highly confidential data in preparation for

analysis

. Design and develop highly efficient SAS code for use in automated data

processing systems on Unix based platforms

. Provide business process analysis to determine reporting requirements

. Perform the role of mentor by offering advice, suggestions or other

means of support

BARCLAYS BANK, Canary Wharf London, UK Mar 2004 - Feb

2005

Sr. Marketing Analyst, Business Banking, Consumer Banking.

Marketing strategy and tactics using a wide variety of analysis techniques

including SAS 9 Base(PC/UNIX), SQL, MS Office Products, SAS Enterprise

Guide, SAS Graph, SAS STAT.

Perform programming tasks to facilitate the building of analytical data,

data transfers, data quality, and data dictionary/structure documentation.

Assist team members with SAS programming, UNIX scripting, and data

knowledge issues. Work with Barclaycard UK Decision Science Infrastructure

in maintaining the Analytical Platform.

Build SAS datasets from various sources for Decision Science team members

to use in Model Development

Extract data from Databases, Data Marts, Text Files, MS OFFICE, or other

formats on periodic or ad-hoc basis

Assist in standardization of data extraction and building process.

Acquire or create Data Dictionaries, Operational System Documentation, and

End-to-End Data Flow

Ensure that data needs and business rules are in compliance with enterprise

policies and standards

WELLS FARGO BANK, San Francisco, CA May 2003

- Jan 2004

Senior Data Analyst/SAS Programmer

. Experience in the analysis of large data sets to find useful

relationships across time using database analysis tools and techniques

including most SAS modules, SQL, UNIX and Excel.

. Use client and third party credit and non-credit data for statistical

modeling to predict response and approval rates to increase success of

customer acquisition and cross-sell campaigns for credit card and retail

markets.

. Build and load data, create extract files for reporting using SAS ETL.

. Integrate data from different sources like Oracle, to be merged &

cleansed

. Responsible for monthly data loads, testing, auditing and reporting for

the Marketing Data Repository (MDR).

. Enhance and maintain the reporting/business intelligence environment to

meet the needs and requirements of all customers.

. Manage, manipulate and join data using SAS, Excel tables, Oracle and SQL

query builder.

. Extract/transfer data and perform ad-hoc queries using SAS v9.1 from/to

different data sources, like MS SQL server, Excel and reporting items.

. Developed a number of improvements in data mining algorithms, which

significantly increased accuracy and performance.

IBM CONSULTING SERVICES, San Francisco, Ca 1997 - 2003

IBM consultant - assisted clients with the design, build and management

aspects of their transformation to on-demand e-businesses.

Clients included:

Wells Fargo - Software Engineer (1998 - 2003)

. Managed and led a team of developers in the implementation of Prospector

application which was developed as a sales lead delivery utility.

. Developed project plan and resources allocation and provided performance

reports.

. Developed SAS and COBOL code, perform end-to-end test cases/scripts, test

case automation and test execution.

. Performed the prototyping, development and implementation of the

analytical databases used for marketing analysis using SAS ETL,

SAS/ACCESS and SAS Data Surveyor.

. Key player in the development of ISO9000 procedures for the bank.

Participated in ISO9000 departmental audits. Department completed 4

audits with no non-compliance issues found.

. Performed PROC summary, PROC download and PROC Export in order to create

Excel spreadsheets.

. Requirements gathering, scoping and develop gap analysis.

. Produced workflow models and translate functional specifications into

design specifications.

Kaiser Permanente- Technical Lead (1997 - 1998)

. As Team leader of Kaiser Permanente's Health Plan Membership team, was

responsible for managing maintenance and new projects

. Assisted in translating and analyzing each application and identifying

areas of modifications.

. Developed and produced Statement of Translation, Statement of Scope,

determining dependencies of one application on another and the rippling

effect, assessing impact of changes.

. Coordinated all testing efforts for the applications.

. Developed and produced project plans based on client requirements,

establishing and monitoring adherence to development standards.

. Assisted as the primary interface between the project team and the

project manager.

INTERIM TECHNOLOGY SOLUTIONS, San Francisco, Ca 1995 - 1997

As a consultant at Wells Fargo Bank, played a lead role in the design and

development of the Mortgage Lending Control Systems (MLCS). The MLCS system

is used to track mortgage loans through processing from the point of data

input, to loan approval(using different credit bureaus), to funding and

boarding each loan.

Wells Fargo Bank- Sr. Consultant

. Assisted in the day-to-day production support to troubleshoot problems

with CA7 jobs;

. Managed and implemented changes to the Job Schedules;

. Developed and maintained programs, JCL and PROCS and supported all the

testing groups;

. Designed and defined the Systems Requirements Definition;

. Coordinated and led various JAD sessions;

. Developed and implemented system enhancements.

EDUCATION AND PROFESSIONAL DEVELOPMENT

Graduate Diploma Systems Analysis, University of London, England

BS Computer Science, University of Lagos, Nigeria

PROFESSIONAL AFFILIATION

British Computer Society

SAS Institute

SAP Community Network

Contact this candidate