PROFILE

• More than 10 years of professional experience in design, development and implementation of business application, which includes 4 years of SAP BW/BI and I year of SAP business object (BO).
• 5 years of Functional and Technical expertise in SAP BW/ECC 6.0 version 7.0/3.5.
• Experienced in requirement gathering, GAP analysis and Data Mapping exercise.
• Extensively worked in InfoCubes, InfoObjects, ODS Objects, DataSources, InfoPackages, Process Chains, Transfer, Updates rules, transformation Characteristics and Key figures, Activating and Enhancing Business Content, Datasource Enhancement and Data Extraction.
• Expertise in extracting data from applications of LO cockpit, SD, MM, FI-CO, Business Contents, Generic Data Extraction from Views, Functional Modules, DB connect and Flat Files.
• Expertise in front-end Business Warehouse components: SAPBusiness Object, BEx Analyzer, Query Designer, Workbooks, Calculated key Figures, Restricted Key Figures, Structures, Variable, Exceptions, Conditions, Jump_to Query, Ad-hoc Queries, Web Application Designer, Exception Reporting and Pre-Calculated web templates.
• Good experience and knowledge in Web Reporting using WAD Report Designer, BEx Broadcaster.
• Experienced in Performance Tuning and using BW Statistics. Improved data load and query performance by creating Aggregates, Compression, Indexes and Data Transfer Settings.
• Experience with latest Netweaver 2004s data modeling, reporting features, migration and issues.
• SAP Business Objects: SAP BO Universe design and experience in the use of WEBi, DESKI, Xcelsius, dashboard and BOBJ Integration Kit .Data Integrator and Data Federator.

EXPERIENCE:

Confidential, Calgary, AB

SAP BI CONSULTANT March 2009 - Dec 2010

• Involeved in complete life cycle implementation (from project preparation, business blue print, realization, final preparation and go- live) of SAP BW in SD AND MM.
• Worked with several users and interacted with them to gather requirements and transformed them into data model with the concept of star schema.
• Analysed business reporting requirements that could be satisfied with SAP business content and installed the necessary objects.
• Created: dataSources, infoObjects, ODS and InfoCubes.
• Loaded attributes, texts, hierarchies from flat files to the infoObjects.
• Created process chains for data loading, delta uploading and periodical PSA deletion.
• Managed and monitored several data loads, captured errors and corrected bugs.
• Designed Generic Data Extractors to extract/cleanse and transform the data to suit the Business Warehouse model.
• Heavily involved in LO cockpit and Generic data extraction mechanisms.
• Created queries using variables, restricted key figures, Calculated Key figures and exceptions, conditions, offset and structures.
• Scheduled timely deletion of the PSA, DSO change log.
• Performed extraction from multiple source systems including SAP and Flat files like POIS files, stored and remote servers.
• Used job-scheduling tools (process chains) to load data.
• Developed multi-providers and created reports on them.
• Migration of 3.5 objects to 7.0 in both frontend and backend.
• Worked with SAP security team to administer used roles in both back end and front end.
• Developed queries, workbooks and published them on the web.
• Working with BI Portal, publishing of queries and linking of workbooks to the portal.
• Working with Basis team to resolve short dumps related to table space.
• Involved with system upgrades.
• Heavy production Support.

Confidential, Toledo, OH

SAP BI/BO DeveloperMarch 2008 to Feb 2009

• Involved in different phases of Software Development Life Cycle (SDLC) like requirement gathering, preparation of technical specification documents, designing and development reports and unit testing.
• Interacted with the Business Users to analyze the business process and gathered the requirement.
• Responsible for development Analytical Report with multiple parameter fields, multiple expression and multiple grouping of hierarchy levels and published them using the Business Object Enterprise X1.
• Defined BO Classes, Objects in the Universe, defined Cardinalities, Contexts, Joins and Aliases and resolved loops in Universe using Table aliases and contexts.
• Checked the Universes for integrity and exported to the Repository to make resources available to the users and groups and Created Ad-hoc Reports by accessing the Universe.
• Enabled dynamic report linking by passing Variables (prompts) between reports.
• Designing, developing and deploying using Universe Designer, Web Intelligence, Desktop Intelligence, InfoView and CMC.
• Worked on Hierarchy Levels and developed hierarchies to support drill down report.
• Extensive experience in creating report with Charts (bar, charts, Pie chart etc), Cross-tabs and Sub reports.

Confidential, Toronto, ON

BW ANALYST Sept 2006 to March 2008

• Capture and convert high level business requirements to specific functional requirements.
• Develop custom data model using InfoObjects, write optimized DSO, Standard DSO, InfoCubes and business logic.
• Develop Queries using BEx Query Designer with restricted key figures, calculated key figures, constant selections, exception aggregations, global structures, cell editor, variables, exception and conditions. Develop customer exit code required to process BEx variables.
• Develop new workbooks using BEx Analyzer with using custom macros and certificates. Migrate BEx workbooks from BW 3.5 to BI 7.0.
• Worked with ABAP programmer in creating start and end routines, dynamic DTP filters, Z programs, Function Modules.
• Publish BEx queries to Enterprise Portals. Identify proper authorization objects and roles required for online reports.
• Created global Sales Dashboards with Top 10 products, Market Share using Web Application Designer.
• Activated business content for BI Statistics Cubes, Multiproviders and Queries to read Front-End OLAP statistics, DTP and InfoPackage statistics.
• Improve query execution times and data load times: identify proper aggregates, creating indexes, restructure dimensions based on size of fact table vs. dimension tables, use write optimized DSO for staging where required, identify proper parallelism based on number of process available. Extensive experience in reading new event based BI 7 statistics model for performance data to identify bottle necks.
• Experience in Transport Management System, creating transport proposals, importing proposals, resolve failed transports and fix them.
• Debugged ABAP routines, read ABAP dumps, long query executions, and failed data loads, failed process chains, authorization issues, check job logs, sizing, table space issues.

Business Analyst Toronto ON

Confidential, Nov 2004 to sept. 2006

• Working with business owners to define project scope, schedule, dependencies and issues.
• Assisting in the definition of business requirements and the functional design of major components of an application.
• Assisting in producing the Project Charter with Project Manager, and Business Sponsors.
• Managing priority projects/initiatives and effectively communicating status
• Helping define and structure new system processes.
• Creating project status reports and providing input for executive presentations.
• Responsibility for supervising the day-to-day efforts of a small team of less experienced business systems analysts working on smaller components of the overall application development.
• Facilitating project review sessions and assisting Project Manager in facilitating executive review sessions.
• Identifying, analyzing, escalating and resolving critical initiative risks and issues
• Leading meetings with business owners to define application requirements.
• Helping define and structure new system processes.
• Day to day client interactions, with periodic client interface at the executive level.

Application Support Analyst/Network Engineer
Confidential, Nov 1999- Oct 2004
2nd -3rd line support of corporate desktops

• Troubleshooting Exchange 2000, User logon and Exchange account creation.
• Maintaining and performance of all servers and services.
• Support of satellite offices (servers and services).
• Network/drive mappings.
• Troubleshooting network connectivity issues.
• Floor-walking to support student and to show IT team visibility.
• Daily IT team 'brainstorming'.
• Systems administration.
• Test lab configuration utilizing W2K and Active Directory.
• Business alignment and streamlining with technical platform resources available (present and future).
• Configuring WINS (Windows Internet naming service) servers.
• MS Office upgrade.
• Laptop/Desktop builds.

CERTIFIED ITIL
SAP BW 3.5, BI 7.0
SAP R/3 Finance & Controlling 4.6C, 4.7 Canada
Investment Funds in Canada (IFC) Canada
BSc Business Administration (Brandon University) Canada
BSc Computer Science (University of Benin) Nigeria