Sidney S. Santos

SAP BI Analytics Lead Consultant (BW, BI, BOBI 4.0, ABAP)

***** ******** **., *******, ** 90650

Mobile 562-***-****

Personal Email: acanqv@r.postjobfree.com

SUMMARY

Total of 13 years in SAP --- 7 years as an SAP BI, BIBO IDT consultant

integrating and 6 years of solid ABAP programming expertise.

Successfully implemented 2 full cycle implementations of BW 3.1C and

3 full cycle implementation of BI 7.0, BIBO IDT. These implementations were

geared towards providing SD and MM integration with SAP BW particularly the

in the LO cockpit processes.

Acted as the lead BW consultant in the development of the entire data

flow, from the R3 source systems until the design of the data targets in

BW.

Worked in the Upgrade team from BW 3.1C to BI 7.0 and successfully

migrated the old BW objects into the new platform. Acted as the main

coordinator of this upgrade with the Basis team.

Participated in full-cycle project implementation for SAP MM and SD

and is primarily involved in user requirements gathering, solution proposal

and strategy planning. Leads a team of developers to implement the

solution and finalizes all the migration of change requests.

Facilitated the review of an old reporting procedure for SAP SD Sales

&Billing from a Legacy system and implemented an SAP BW-centered reporting

strategy for end users. Designed the SAP SD - LO Cockpit scheme for Sales

Document Header, Item and Conditions and Billing Document. Developed tuned

reports from performance-maximized Infoproviders, giving users flexibility

in reporting sales data in their daily and monthly operations.

Provided end-user support and aided in the training and orientation

of the new Bex reports.

Designed and developed Universes using BIBO 4.0 Information Design

Tool

Provided end-user support for creation and modification of Web

Intelligence, Dashboards, Crystal Reports

TECHNICAL EXPERTISE

SAP Business Warehouse 3.5 and BI 7.0

. Business Information Warehouse Administrator Workbench

. Datasource Configuration and Extractors in SAP R/3 systems

. Datasource setup from Flat file systems (i.e. file server,

third-party customized Databases)

. SAP-R3 IMG Configuration for BW extraction from R3

. SAP-BW Data Modeling (InfoObjects, InfoSources, InfoProviders,

DataSources)

. LO Cockpit Analysis and Solutioning

. Extraction Transformation and Loading (ETL) Strategy

. Business Explorer

. Web Reports

. Transport Management

. Upgrade to BI 7.0 Analysis of Scope and Implementation

. Integration Testing of BI 7.0 Migrated objects

. Conversion of Bex Reports

. Design Bex queries and Web reports

. Activate, configure and initialized Business Content Extractors

for Logistics, Sales and Finance in ECC side

. DB View, SAP Query and Function Module custom extractor

creation

. OLAP Universe using BusinessObjects Enterprise

. Open Hub Destination

. BOBI 4.0 Reporting tool (Crystal Report, Dashboard, Web Intelligence)

. Data Services

ABAP

. Online/Modular programming

. Batch Input Recording (BDC)

. Table Control

. FTP

. Table maintenance event

. ABAP Report programs

. ALV Report programs

. Call Transaction

. SAP Scripts

. Smartforms

. BAPI

. Upload and Download programs

. Database Updates

. Function Module programs

. Performance Tuning

. ABAP Events and Modification

. SAP Users Authorization

. IDOC

. LSMW

. Macros

July 2009 to present

SAP BI Lead Consultant

ACCENTURE - Manila Delivery Centre Philippines

IPI Incorporated

Project: Keystone Project Services - Connect Programme Data Drop 3 ECC

Extractors (Unilever Europe)

. Create global data warehouse that will facilitate the

collection of data from across different regions which are Europe, AAC

and Americas and provide global reporting solution access different

functional areas.

. Activating, configuring and initializing about 360 Business

Content extractors which will enable extraction of Logistics, Sales,

Finance and a lot of other data out of S1P Sirius (Production system)

and APO

. Deliver change requests based on Business Content extractors

and custom tables

. Resolves issues on different kind of extractors

. Handles all ECC ABAP related extractors

Project: Cordillera BI (Unilever America - New Jersy)

. Handles all BI ABAP routines for the SAP BI Offshore Team

. Resolves issues raises by user specially for Master Data

. Handled incidents pertaining to ETL loading issues

. Supports the US counterparts in ticket resolution

. Create different scenarios in BI 7.0 sandbox to incorporate

Release 2 project which involve other countries

. Create BI objects needed for Release 2 project pertaining to FI

and Master Data

. Create Open Hub Destination required by MS reporting

. Connect and extract data from BW system to BO Data services table

Project: Gemini AT&T Operations ( AT&T San Ramon California)

. Acted as Principal Consultant for the SAP BI Offshore Team

. Handles Incident Management of Service Requests for Bug Fixes

. Supports the US counterparts in ticket resolution

. Creates solution proposals for known product defects

. Participates in new Product release bi-monthly

. Assists the scheduling of product releases

. Led the knowledge transition sessions for SAP BI projects and

documentations

. Served as the 0perations and Offshore Team Subject Matter

Expert

Project: Shell (Shell Malaysia)

. Acted as the Principal Consultant for the Support and

Maintenance team

. Handles Incident Management of Service Requests for Bug Fixes

pertaining to BO Universes and Web Intelligence Report

. Resolves issues raised by BW users of Sales and Distributions

queries and reports

. Maintains and creates BW objects in the Administrator Workbench

in BI 7 to resolve loading issues, object inconsistencies, process

chain errors and other Production issues

. Create and Maintains BO Universes

. Create Web Intelligence Reports

. Advises and proposes solutions to Incidents and prepares the

Problem Analysis and Fix Approach document to be passed on to the BW

support team

. Resolves recurring issues by looking into the root cause of the

problem

. Maintained 100% resolution level for all incidents

. Leads a team of 7 BW developers

Project: Deutsche Bank (Deutsche Bank Europe)

. Acted as the SME (Subject Matter Expert) for the SAP BI

implementation and is reporting directly to the Project manager

. Participated in the bug/fix investigation and resolution with

an experience BI team made up of Developers and Analysts

. Handled incidents pertaining to mainly ETL Loading issues,

performance tuning and report generation

. Used BI 7.0 version to support and maintain over 20 Cubes and

ODS mainly used for FI CO reporting

. Recommended OSS Notes to solve known problems /bugs in the

system

. Raised OSS messages for BI Standard Extractors

. Provided Solution Proposals and Bug Fix approach

. Documented training strategy and aided in the training of the

new BI users and developers in the team

. Prepared the Training plan for the Business Explorer Training

to be conducted to the members of the BI team

. Completed a comprehensive Training Course for Business Explorer

which includes BEx Analyzer Navigation and integrated the basic BeX

features from the Query Designer

May 2009 to July 2009

Senior SAP BW Team Lead

SONY ELECTRONICS Asia Pacific Pte. Ltd. (Singapore)

. Acted as a Senior Consultant for the Regional Sales Department

Business Warehouse Implementation

. Participated in the business user presentation of BW reports

that resulted to a commitment a long term contract for BW usage in the

Sony Product Marketing groups.

. Lead a team of 3 in the decision making of the Solution

Proposal based on user requirements

. Completed a Sales Consolidation Report which integrates

Customer-wise breakdown of Billing Document daily sales reporting

. Spearheaded the design of the support framework (maintenance

and resource planning) for this Consolidated Reports

. Completed and deployed 2 Cubes, 2 extractors, 5 reports and 2

workbooks to end users

. Participated in the design of the ETL process for a new

Regional Reporting mechanism that integrates the standard LIS

extractors and 2 customized extractors for Flat TV sales reporting.

. Maintained and supported the BI 7.0 system for 16 countries in

the Asia Pacific region with ETL troubleshooting and operational

questions.

May 2007 to May 2009

SAP BW Consultant

APRIL Management Pte.Ltd Singapore (Singapore)

. Acted as the SAP BW and ABAP coordinator for a new project

. Designed a cost-effective and comprehensive solution for the

Sales Adjustment functionality utilizing the SAP BW reports

. Developed an ABAP progam that would allow manual adjustments to

pre-loaded figures in the Infocube that would later be reloaded as

adjusted records

. Designed and lead the implementation the SAP SD Sales and

Billing Document

. Utilized the LO Cockpit in activating the SAP standard

datasources 2LIS_VDKON and 2LIS_VAKON

. Developed a set of Bex reports based on user requirements

. Published the performance-tuned reports in the Web Browser

January 2006 to May 2007

SAP BW / ABAP Consultant

DGIT SOLUTIONS PTE LTD Singapore (Singapore)

CASE I

JANUARY 2006-May 2007

SONY ELECTRONICS ASIA PACIFIC PTE.LTD SINGAPORE

. Configures SAP-BW Data Modeling (InfoObjects, InfoSources,

InfoProviders, DataSources)

. Create DataSource extractor, ODS/cube/multiprovider, ABAP

routine in update rules/transfer rules and query/web template.

. Configures SAP-BW Source Systems (Extract data from flat file

and SAP R/3 using RFC)

. Configures SAP-R3 IMG for BW extraction from R3

. Create and Schedule Process Chain

. Data loading

. Generates SAP-BW for management use

. Designs and develops customer requirements for BW and ABAP

. Provides assistance to BW users

. Generates SAP-BW star-schema model for approval of SAP-BW

architects

. Provided first level production support through trouble-

shooting of data load errors

. Supports users' inquiries on report related data accuracy

issues

. Formed part of the pioneer team to execute the BW BI 7.0

Upgrade

. Involved in requirement gathering for Project Preparation,

Business

. Involved in the Pre Upgrade Activities (BW version 3.1 to BI

7.0).

. Assessed impact of BI 7.0 objects in existing production

programs and interface of SAP SD, MM and FI to SAP BW

. Initiated change requests for objects that will be affected by

the changed functionality of BI 7.0

. Developed a workplan for all program changes to be done prior

to the upgrade

. Involved in the preparation of the BW 7.0 version sandbox for

BI 7.0 requirement analysis

. Created test infosources using direct table setting in R/3 in

the BI 7.0 sandbox

. Created test cubes and ODS in the BI 7.0 sandbox

. Created test queries in the BI 7.0 sandbox

Functional knowledge on the SAP BW data warehousing concepts

. Extraction, Loading and Transformation Tool expert

. Development, design and requirements analysis

. Infoobject design

. Implementation of Loading and Scheduling of Infopackages

. Troubleshooting Info package Loading errors

. Integration with SAP R/3

. Data Extraction from SAP R/3 and other sources

. Flat file data source integration

. Data Maintenance

. BW Project plan

. Administrator Workbench

. Extraction, loading and Transformation

. Automated Loading Process Redesign and Implementation

. Automated Loading Process Support and Maintenance

. Troubleshooting BW Load Errors

. Flat File Source System

. SAP R/3 integration and table extraction

. Involvement in SAP BW Development

. Supporting 5 releases and providing support as bug/fix team

. Business Explorer

. Query Design

. Creating Ad hoc queries based on requirements

. Analysis of Reporting results

. Troubleshooting report errors

. Report formatting

. Workbooks Design

. Integrating with Web Reporting

. Query Performance Analysis and redesign

. Creating ad hoc queries based on a functional design

. Transport Management System

. Managing User Authorization

. Development Classes

. Transport Organizer

ABAP/4 Programming

. Systems Analysis and design.

. Programming based on user requirement.

. Designed ABAP/4 programs based on company standards, user

requirements and system flexibility focusing on FI and Marketing data

from InfoCubes and ODS on BW server

. Trouble-shooting (i.e. analyzing why programs abort or behave

in unexpected ways)

. Developed/Enhanced ABAP/4 applications such as

. FTP

. RFC programs

. ABAP Report programs

. Call Transaction

. BAPI

. Upload and Download programs

. Function Module programs

August 2004 to January 2006

Senior SAP ABAP Consultant

HEADSTRONG PHILIPPINES, INC

CASE I

JANUARY 2005 - JANUARY 2006

ACCENTURE PHILIPPINES

CASE II

AUGUST-DECEMBER 2004

GLOBE TELECOM PHILIPPINES

. ABAP/4 Programming

. Systems Analysis and design.

. Programming based on user requirement.

. Designed ABAP/4 programs based on company standards, user

requirements and system flexibility focusing on SD, MM, FI and PP

modules

. Trouble-shooting (i.e. analyzing why programs abort or behave

in unexpected ways)

. Technical Designer base on Functional Design

. TD reviewer

. Code reviewer

. Create component test plan

. Developed/Enhanced ABAP/4 applications such as

. Online/Modular

. Batch Input Recording (BDC)

. Table Control

. FTP

. RFC programs

. ABAP Report programs

. ALV Report programs

. Call Transaction

. SAP Scripts

. BAPI

. Upload and Download programs

. Database Updates

. Function Module programs

. ABAP Events and Modification

. IDOC

June 2004 - August 2004

SAP ABAP Consultant

SUVIN TECHNOLOGIES SINGAPORE

CASE I

JUNE-AUGUST 2004

MITSUBISHI MOTORS THAILAND

. Performed different ABAP programs on R/3 and SAP APO

. Online/Modular, Batch Input Recording (BDC), Table Control,

FTP, RFC programs, ABAP Report programs, ALV Report programs, Call

Transaction, SAP Scripts, BAPI, Upload and Download programs, Database

Updates, ABAP Events and Modification.

. Create, Delete and Update Z Tables, Search Help, Table Indexes,

Function Groups

. Trouble-shooting on different errors encounter if programs

behave in unexpected way.

. Debug Modify and Updates of program.

October 2001 - June 2004

IT Application Specialist

San Miguel Information Technology Services Inc. (SMITS) Philippines

. Performed ABAP programs

. Online/Modular, Batch Input Recording (BDC), Table Control,

FTP, RFC programs, ABAP Report programs, ALV Report programs, Call

Transaction, SAP Scripts, BAPI, Upload and Download programs,

. Database Updates, ABAP Events and Modification.

. Create, Delete and Update Z Tables, Search Help, Table Indexes,

Function Groups

. Trouble-shooting on different errors encounter if programs

behave in unexpected way.

. Debug, Modify and Updates of programs

. Performed Users Authorization

. Create, Change, Delete Users id with assign authorization

. Create, Change, Delete Activity Group

. Create, Change, Delete Responsibilities

. Create, Change, Delete different Profiles

. Different configuration on Material Management

. Create and set-up different materials

. Create, Delete and Update Customer

. Create, Delete and Update Discounts

. Provides on-line support on all sales offices

. Performed sales office reconfiguration

. Conducted basic training of CKAG- SAP

April 2000 to September 2001

PD SAP Support / Hand-holder

Coca-cola Bottlers Philippines Incorporated.

. PD SAP Support/ Hand-holder

. Teach the users in the correct encoding of the various PD

transaction following the SAP PD blue prints

. Train users in the analysis of reports and more importantly

analyze problems related to inventory management (i.e. trace stock-in-

transit, inventory difference)

. Transfer of skills from PD SAP Support/ Hand-holder to the PD

Clerk, PD Supervisor and PD

. Superintendent within 4 to 8 weeks from deployment

. Ensure a correct SAP implementation at the plant or sales

office assigned

. Analyze SAP PD reports and know how to reconcile these with the

transactions processed and determines it there are any errors

. Analyze errors encountered and knows what and how to correct

these

. Conduct formal training classes and on-the-job coaching of PD

users

April 1998 to March 2000

Computer Operation Assistant

Globe Telecom Philippines

. Monitor different task/jobs, keeping tracks of cTABS users.

(Customer & Telephone Administration and Billing System).

. Traffic process of national and international calls.

. Perform daily database backup routine for different servers.

. Perform File System backup.

. Handles batch job runs for the scheduled Billing date for

Globelines subscriber for differentfranchises.

. Magnetic Tape re-loading and reading of Daily calls of

Globelines

. Attends to different user's of cTABS system, keeping track of

all the traffic logs of different CDR's of different Host Switches

TRAININGS AND SEMINARS ATTENDED

July 16-20 - Business Objects Reporting & Analytics

May 12-14, 2004 - "SAP BW 330-Business Information Warehouse Modeling",

SMITS Inc.

May 07, 2004 - "Crystal Reports 8.5 and Macro Programming for SAP-

BW", SMITS Inc.

May 5-6, 2004 - "SAP BW 310 - Data Warehousing", SMITS Inc.

May 3-4, 2004 - "SAP BW 305 - BW Reporting and Analysis", SMITS Inc.

Dec.8-16, 2003 - "SAP-BW Training", SMITS Inc.

December, 2001 - "ABAP Training", SMITS Inc.

October, 2000 - "SAP Training and SMC CKAG Business Process", SMITS

Inc.

EDUCATIONAL

1994 - 1998 Centro Escolar University, Mendiola Manila

Bachelor of Science in Commerce (BSC)

Major in Computer Science and Information System

Contact this candidate