Senior SAP BI/BW/BO Consultant
Resume:
CONSULTANT
SAP BI/BW/BO
RESUME
I. PERSONAL DETAILS
NAME: Raúl Mauricio Alonso Carmona
DATE OF BIRTH: 20 /06 /1980 BIRTHPLACE: Mexico City NATIONALITY: Mexican MARITAL STATUS: Single
EMAIL: acyyg7@r.postjobfree.com
PROFESSION: Bachelor in Computer Systems Applied to Management
SAP BI/BW/BO Consultant, with experience in several projects within North and Central America, experience with clients of different areas as manufacturing, retail and medical services; able to work under pressure and experience working and training different levels of users. Looking to get challenging tasks to improve myself in different aspects as knowledge and experience, is important for me to always leave an enhancement in the work that I do in order to reach the best level possible professionally and personally.
II. EDUCATION
DEGREE
INSTITUTION
PLACE
PERIOD
Bachelor
ITESM-CCM
Mexico City
1999-2005
III. PROFESIONAL EXPERIENCE
COMPANY
JOB
ACTIVITIES
PERIOD
California Steel Inc.
(Fontana, Ca, USA) / Axosnet
SAP BI/BO
Consultant
PROJECT: BI Project
Sap Business Objects report development using Web Intelligence 4 and 4.1
Sap Business Objects universe creation and analysis using Information Design tool 4 and 4.1
Business Objects Dashboards
Business Objects Web Services
Database Oracle Analysis using Hora interface.
Steel production and testing reporting.
Sales data analysis
SQL coding and reporting
Bex reporting BW modeling and workbook creation version 7.30
SAP ECC FI data analysis and consolidation with different data sources.
BW data extraction from MES oracle database.
Inventory reports based on MES data.
Sales reporting combining SAP R/3 data and MES Oracle
From
Feb 2014
To
April 2016
Petrotrin
(Trinidad & Tobago)/
N&BTeamConsulting
SAP BI/BW Lead Consultant
PROJECT: BI Assessment
BW extractors Analysis
Business Objects Universe creation
Business Objects Webi report development
BW queries and integration with BOBJ
Matching information with BW, R/3 data and BOBJ Reports.
Report analysis with Webi.
From
Oct 2013
To
Nov 2013
Prairie Materials (Bridgeview, IL, USA)/
Softtek
SAP BI/BW Lead
Consultant
PROJECT: Extended Support
Rebates data consolidation
BI team lead, of a team of 3 people
Consolidation of billing, conditions and profitability data.
Creation of transformation, abap routines, DTP.
DSO Creation, multicube and infocube creation.
LO data extraction generation.
Query creation, input variables, text variables, alternate date analysis.
Data modeling.
Workbook creation.
Power user training.
Business Content Data Source Activation.
ABAP Start Routine implementation.
From
April 2013
To
Oct 2013
Burger King
(Miami, FL, USA)/
Softtek
SAP BI/BW/BO
Consultant
PROJECT: Support
Support in process chains and data load.
Business Objects report monitoring.
Business Objects webi report development.
Support in query and web templates creation.
Job support and monitoring.
HR and FI data support.
BOBJ support with dashboard information.
Matching data between BW and BOBJ reports.
From
Oct 2012
To
April 2013
Prairie Materials (Bridgeview, IL, USA)/
Softtek
SAP BI/BW Lead Consultant
PROJECT: Extended Support
Integrated planning full cycle implementation.
BI team lead for 3 people.
Aggregation level creation, input queries creation, planning function creation.
Interaction between existing reports with real-time infocube data.
Creation of queries for income statements for different business divisions.
Optimization of Income statement workbooks.
Creation of queries for sales analysis.
Creation of web templates for analysis.
Multicube creation to consolidate data including inventories, financial and sales information.
User-Exit for time variables.
Training to power and end users.
From
Nov 2011
To
Sept 2012
Felix B. Maduro (Panama, Panama)/ LatCapital
SAP BI/BW Lead Consultant
PROJECT: Extended Support
Support and training in building workbooks for users.
BI Team lead for 2 people.
Development of Z extractors for purchase, sales, discounts and inventory.
Development of Z DataStore Objects for sales and inventory.
Transformation routines for Article and sales price validation.
Inventory extraction from business content.
Custom data model for CEO’s report.
From
May 2011
To
June 2011
Prestige (Orlando & West Palm Beach, FL)/ Softtek
SAP BI/BW Lead
Consultant
PROJECT: Prestige SAP Implementation
Creation of queries for income statement.
Creation of queries for sales analysis.
Creation of queries for HR employee headcount.
This project was a roll out of a previous phase.
For the queries made in this project, Z infocubes were used, the infocubes were developed in the previous phase of the project.
Creation of conversion type to visualize alternative units of measure in queries for 0MATERIAL.
From
Jan 2011
To
March 2011
Felix B. Maduro (Panama, Panama)/ Latcapital
SAP BI/BW Lead Consultant
PROJECT: SAP RETAIL PROJECT
SAP best practices scenarios 761 – 764, for OTB and PPW.
Purchase vs. Budget workbook using LO extractors.
BI team lead for 2 people.
ABAP programming event oriented for start routines, transfer rules, update rules. Function creation and manage.
Business Warehouse data modeling, custom and business content InfoCubes, real-time infocubes, multiproviders, virtual providers, DataStore Objects, InfoObjects.
Manage and creation of 3.5 ETL process, data source, infopackage, transfer structure, transfer rules, infosource, update rules, data target.
Manage and creation of 7.0 ETL process, data source, infopackage, psa, transformation, infosource, dtp, data target.
Installation from business content.
Manage and creations of transformation routines, start routines, end routines, for version 7.0 and 3.5.
Development of user-exit enhancements for variables in queries with their abap codes.
Manage and creation of roles and authorization profiles.
From
Aug 2010
To
Oct 2010
McDonald’s Mesoamérica (Guatemala, Guatemala)/Crystalis
SAP BI/BW Lead
Consultant
PROJECT: BI PROJECT
Financial Statements: P&L for each restaurant using CO Standard InfoCube.
BI team lead for 2 people.
Financial Statements: Balance Sheet, Income Statements for different companies using FI GL InfoCube.
Power user training.
Z Data sources applied to Standard InfoCubes.
ABAP programming event oriented for start routines, transfer rules, update rules. Function creation and manage.
Business Warehouse data modeling, custom and business content InfoCubes, real-time infocubes, multiproviders, virtual providers, DataStore Objects, InfoObjects.
Manage and creation of 3.5 ETL process, data source, infopackage, transfer structure, transfer rules, infosource, update rules, data target.
Manage and creation of 7.0 ETL process, data source, infopackage, psa, transformation, infosource, dtp, data target.
Installation from business content.
Manage and creations of transformation routines, start routines, end routines, for version 7.0 and 3.5.
Development of user-exit enhancements for variables in queries with their abap codes.
Manage and creation of roles and authorization profiles.
From
Jan 2010
To
June 2010
Urrea (Guadalajara, Jalisco, México)/ Axosnet
SAP BI/BW
Consultant
PROJECT: BI PROJECT
Data extraction training for power users in SAP BW 3.5 and BI 7.0
From
May 2009
To
May 2009
California Steel Inc.
(Fontana, Ca, USA) / Axosnet
SAP BI/BW Lead Consultant
PROJECT: BI PROJECT
SAP BI 7.0 implementation.
Integrated planning full cycle implementation used to capture data not available in R/3.
BI team lead for 3 people.
Special fiscal periods grouped as one single period.
Data extraction from FI module, using Business Content and Z infocubes.
Data model of financial information required by the client.
Reports of the company’s financial statements, balance sheet, cash flow, statement of retained earnings, income statement.
Financial statements’ workbooks using VBA code.
Financial statements’ graphs using Excel interface and WAD for Enterprise Portal.
Web version of the financial statements to be shown on Enterprise Portal.
ABAP programming event oriented for start routines, transfer rules, update rules. Function creation and manage.
Business Warehouse data modeling, custom and business content InfoCubes, real-time infocubes, multiproviders, virtual providers, DataStore Objects, InfoObjects.
Manage and creation of 3.5 ETL process, data source, infopackage, transfer structure, transfer rules, infosource, update rules, data target.
Manage and creation of 7.0 ETL process, data source, infopackage, psa, transformation, infosource, dtp, data target.
Installation from business content.
Manage and creations of transformation routines, start routines, end routines, for version 7.0 and 3.5.
Development of user-exit enhancements for variables in queries with their abap codes.
Manage and creation of roles and authorization profiles.
From
Sept. 2008
To
March 2009
ISSS
(El Salvador) / Soluziona
SAP BI/BW Consultant
PROJECT: SAFISSS
Part of the project as junior consultant in SAP Netweaver 2007s BI and prototype design in BW 3.5 version.
ABAP programming event oriented for start routines, transfer rules, update rules. Function creation and manage.
Development of user-exit enhancements for variables in queries with their abap codes.
Structure append in transactional extractors like master data extractors.
Creation of ODS, InfoCubes, InfoObjects.
Elaboration of conditions, exceptions, calculated and restricted Key Figures.
Creation of views, tables, extractors in R/3.
Process chains manage and creation.
BEx map example elaboration using ArcView 9.1.
Creation of data transfer processes, master data load, basic ABAP routines OO, rules in SAP Netweaver 2004s.
Role creation and profile manage.
Extraction of SQL database using Toad for Oracle.
Creation of start and end routines, rules, groups of rules in transformations in BI 7.
Remodeling and cube partitioning.
Manage of information with Open Hub Service.
Extraction of modules in R/3: PSM_FM, CFM, PS.
User training in BI7.
Presentation of reports and BI7 tools to insurance, planning, statistics and income control sections.
Source systems connection to SAP-BW.
PS consulting in intermediate level.
Integrated Planning implementation for workbooks.
BI team lead for 3 people.
Technology used: SAP BW 3.5, ABAP/4, SAP Netweaver 2004s BI
Project type : Implementation
From
Nov. 2006
To
Sept. 2008
ING México
E-Procure Specialist
I made efficiently the required tests for the release of the “Express Pay” application.
I organized and debugged the cost center and accounting databases.
I managed the creation of users and providers in the procurement system.
I took care of the problems that the users had in the system until we got to a solution.
Technology used: Ariba Buyer
From
Nov. 2005
To
Feb. 2006
COSTUMERS
oING Mexico
oISSS
oCEMACO
oCaña Real
oPROMERICA
oCalifornia Steel Industries
oUrrea
oMcdonalds
oFelix B. Maduro
IV. KNOWLEDGEABLE
Operative Systems: Unix, Windows XP, Windows 2000/2003, Windows Vista, Windows 7, Mac OS.
Programming Languages: SQL, ABAP, VBA, HTML, Action Script, JavaScript
Data bases: MS Access, DB2, MySQL, SAP HANA
Methodologies: ASAP
Modeling tools:
Others: Macromedia Flash/Dreamweaver
Protocols: TCP/IP
Office tools: MS Office, MS Access, MS Project, MS Visio, MS Outlook.
V. LANGUAGES
SPANISH: Native language ENGLISH: 95% GERMAN: 50%
VI. COURSES
INSTITUTION
COURSE
PLACE
DATE
Beltsoft
Open SAP
SAP Sales and Distribution
Introduction to Software Development on SAP HANA
Mexico City
On-line
January 2016
July 2013
VII. OTHERS
COMPANY
ACTIVITIES
DATE
TIME
CEMACO
Analysis to data load problem and chain process adjustment.
09/2007
1 week
Caña Real
Business Intelligence presentation and demo.
10/2007
2 days
PROMERICA
Collect of requirements to complete proposal.
10/2007
3 days
Contact this candidate