Sap BW HANA Architect

Contact info

Address: **** * ******** **, *******, TX, 77077

Cell Ph: 303-***-**** Email :*****.******@*****.***

Skype : ebertosky

Executive Summary

SAP Architect (BW 7.4 over HANA), SAP HANA 1.0 SP06, SAP HANA modeling

and loading, data provisioning, SAP Data Services, SAP BI/BW with

Layered Scalable Architecture experience, Business Objects 4.1, SAP

Lumira, BW-IP, BPS, BPC & SEM, ABAP Consultant & SAP architect

Long experience as business and technical consultant at largest

organizations and international experience. Business consultant

experience with 20+ yrs,16+ Years of experience in SAP R/3,SAP BW and

Sap Business Objects 4.1 and 18 years in applied IT/IS area. New SAP

architecture update with SAP BW 7.4 over SAP HANA, and Business

Objects Data services, 12 full cycle implementations, 4 completed

rollouts, and 11 project participation for specific requirements at

International companies. 8 years of experience as BI consultant in

release 7.0 & 7.3; 5 years of development experience (ABAP) in R/3

Rel. 4.6D,ECC 5 & 6.0. Wide experience in telecommunications,

pharmaceutics, manufacturing, retail, beverage companies, AFS and

retail. Also deep experience in consulting services and solutions

integration with SAP and non-SAP systems. SAP Business objects

implementation 4.0 with SAP BW as backbone. A deep knowledge in

financial and process areas. Experience exchanging information with

Oracle, Platinum, ADAMS, Peoplesoft, Hyperion, Siebel, CRM and APO

solutions. . Plus 6+ years as developer and designer at legacy systems

.

Skills Summary

. SAP HANA, BW362E, HA350, HA300, HA100, HA360.

. SAP Applications Modules : SAP HANA (BW modeling and loading), SAP

Data services, SAP BW, SEM (BPS, BCS, CPM), BI-IP, FI-CO (No

experience from 5 years ago), ABAP, XI, Business Objects 4.1 BI

platform (Information Designer Tool, WebI, Crystal Reports). SAP

Lumira and In memory computer for SAP HANA (only proof of concept

experience)

. SAP Applications Releases: R/3: 3.1H, 4.5, 4.6D, ECC 5.0 & ECC 6.0,

Netweaver; BI 3.5, 7.1, 7.3 & 7.4

. SAP architect as analyst, designer and builder to integrate SAP with

another SAP and non-SAP systems.

. Specialization in R/3 systems fine tuning (Certified).

. Courses applied to SAP BI: ETL, infocubes, queries, reporting, BI

performance, SEM(CPM,BCS,BPS), BI-IP (integrated planning) courses

. Experience as ABAP developer: Transactions development, sapscripts &

smartforms development, batch inputs, workflow objects development,

BAPI's, ALE, IDOCS.

. Tools used for SAP BI: Data modeling, Global DWH design and

implementation, ETL, interfaces design for DWH (Open Hub), Integrated

planning, FOX formulas, planning functions, planning process, Query

reporting, IMG. Business Objects 4 suite (Dashboard, BO Explorer, Web

Intelligence). Other BI tools: QlikView Analytics for ERP.

. Tools used for ABAP: business object builder, ABAP workbench, ABAP

query, ABAP screen painter as Dialog Programming, ABAP Dictionary,

SQL. Repository, function builder, etc.

. Languages: SQL, JAVA, ABAP, Cobol, C++, Sapscript.

. Methodologies & Documents: Project management by PMI, ASAP, consulting

methodologies, audit methodology (Computerized Accounting), IS

lifecycle.

. Productivity Applications: MS Office, MS Visio and MS Project.

SAP Apps Tools

. Tools used for SAP BI: Data modeling, Global DWH design and

implementation, ETL, interfaces design for DWH (Open Hub), Integrated

planning, FOX formulas, planning functions, planning process, Query

reporting, IMG.

. Tools used for ABAP: business object builder, ABAP workbench, ABAP

query, ABAP screen painter as Dialog Programming, ABAP Dictionary,

SQL. Repository, function builder, etc.

SAP Applications Project Experience

SAP Sr Business Intelligence consultant @ CROCS, attune

08/2013-Today

Corresponding Location: Massachusetts & Denver, CO

Company Profile: Retail & AFS consulting firm for CROCS

Description: Analyze, design and build the current Inventory &

Deliveries management architecture for Crocs for the global

architecture to support 32 countries at Asia, Australia, Europe and

USA.

Responsibilities:

Analyze, propose, design and build the integration solution with SAP

BW system creating the global layout for Crocs.

Design and apply enhancements to the BW platform as Architect, propose

the best practices and approach in analysis, design, build and testing

solutions for Deliveries and Inventory management

Design and implement the platform for deliveries and inventory

management to support global requirements @ CROCS.

Responsible to best practice, implement first phase for Business

objects and determine the best approach to create a flexible platform

using SAP BW & SAP Business Objects.

Tools Used: Business Objects 4.0, SAP BW 7.3, ABAP, SAP Web Analyzer.

SAP Business Intelligence Architect, MABE

07/2012-07/2013

Corresponding Location: Mexico City, MX; Latin America

Company Profile: Global Appliance manufacturing

Description: Analyze, design and build the current architecture for

Mexico considering a further Latin America region implementation. Co

participation with Accenture.

Responsibilities:

Analyze, propose, design and build the integration solution with SAP

BW system creating the global layout for Accenture.

Design and apply enhancements to the BW platform as Architect, propose

the best practices and approach in analysis, design, build and testing

solutions for Finance, Manufacturing, Sales & logistics, as SRM &

APO.

Advisory related with best practice to design, implement, build and

improve performance enabling flexibility at the current and new

reports, reusing the current architecture.

Responsible to best practice, implement first phase for Business

objects and determine the best approach to create a flexible platform

using SAP BW & SAP Business Objects.

Analyze and define the enterprise reporting platform, guidelines, and

sequence for implementations at short and middle term.

Special integration for SAP ECC, SAP BW & SAP APO for further

integration with SAP Business Objects.

Evaluate feasibility for QlikView vs Business Objects by flexible

platform implementation for Latin America.

Tools Used: Business Objects 4.0, SAP SRM, SAP APO, SAP portal, SAP BW

7.3, ABAP, SAP Web Analyzer. QlikView for ERP.

SAP Business Intelligence Architect, Kraft Foods

09/2011-06/2012

Corresponding Location: Mexico City, MX; Chicago, US

Company Profile: Snack & food products

Description: Analyze, design and build the current architecture for

Latin America region implementation.

Responsibilities:

Analyze, propose, design and build the integration solution with SAP

BW system using a Catalystalyst template for Latin-America

implementation. Regional SAP HCM evaluation for HR management.

Design and apply enhancements to the BW platform as Architect, propose

the best practices and approach in analysis, design, build and testing

the RTR solution (Finance area).

Advisory related with best practice to design, implement, build and

improve performance enabling flexibility at the current and new

reports, reusing the current architecture.

Responsible to load master, transactional & hierarchies

Replace QlikView components for global reporting keeping the QlikView

use for regional Sales & logistics needs only.

Tools Used: SAP portal, SAP BW 7.1, ABAP, SAP Web Analyzer, QlikView,

MS Project, Excel planning simulation.

SAP Business Intelligence Architect, Procter&Gamble

03/2011-08/2011

Corresponding Location: Cincinnati, US

Company Profile: Consumer products

Description: Analyze, design and build the current architecture for

Global BW platforms.

Responsibilities:

AAnalyze, propose, design and build the integration solution with SAP

BW system.

DDesign and apply enhancements to the BW platform as Architect,

propose the best practices and approach in analysis, design, build and

testing the multivendor solution.

Advisory related with best practice to design, implement, build and

improve performance integrating IDOCs for inbound and outbound

process.

Tools Used: IDOCS, ALE, Functions, ABAP.

SAP Architect for Electronic Invoicing process

09/2010-02/2011

Corresponding Location: Mexico City

Company Profile: Logistics & Transportation Company

Description: Build the interface for electronic invoicing process

Responsibilities:

AAnalyze, propose, design and build the invoicing solution with SAP

system.

DDesign the platform as Architect, propose the best practices and

approach in analysis, design, build and testing the invoicing

solution.

Testing for invoicing process.

Tools Used: IDOCS, ALE, Functions, ABAP.

SAP BW Architect & Designer, Loblaw

07/2010

Corresponding Location: Toronto, Canada

Company Profile: Retail company

Description: Advice for design of the best way to manage large amount

of information at BW platform, and specially the retail and POS

information.

Responsibilities:

AAnalyze, propose and design the integration solution with SAP BW

system.

PPropose the BW best practices and approach in analysis, design and

build for Retail solution.

Advisory related with BW best practice to design and improve

performance integrating IDOCs for inbound and outbound process.

RAnalize the current Platform to migrate SAP HR into SAP HCM for

management workforce.

Tools Used: BW platform analysis.

SAP Architect for logistics area, Procter&Gamble

04/2010-06/2010

Corresponding Location: Cincinnati, US

Company Profile: Consumer products

Description: Determine the design and integration with current vendor

portal platform with internal America's SAP system for multivendor

project.

Responsibilities:

AAnalyze, propose, design and build the integration solution with SAP

system.

DDesign the platform as Architect, propose the best practices and

approach in analysis, design, build and testing the multivendor

solution.

Advisory related with best practice to design, implement, build and

improve performance integrating IDOCs for inbound and outbound

process.

Tools Used: IDOCS, ALE, Functions, ABAP.

SAP BW SEM Sr Leader, GCC 04/2009-03/2010

Corresponding Location: US

Company Profile: Cement Manufacturing

Description: For SAP US project implementation, as BI team leader,

coordinating BI team, Supporting BW design, interfaces and performance

tuning for US project offices.

Responsibilities:

AAnalyze, propose, design and build P2P, OTC, Finances & controlling,

HR scenarios, integrating SAP SAP systems, BI 7.1 and SEM design for

next phase.

CCoordinate the BI team members, design the platform as Architect,

propose the best practices and approach in analysis, design, build and

testing the enterprise warehouse. Performance tuning for entire

platform and prepare release strategy for go-live.

AAdvisory related with best practice to design, implement, build and

improve performance at BI business process, DB and GUI level.

DDesign and implement a strategic financial analysis for EVA(Economic

Value Added) as producer as logistics companies evaluating their

performance.

Tools Used: BI, Bex Analyzer, Workbooks, ETL process, Enterprise

datawarehouse design, XI Query Designer, Web templates.

SAP Architect-Designer solution, PriceWaterhouseCoopers

01/2009-03/2009

Corresponding Location: Costa Rica & Mexico

Company Profile: Consulting Firm

Description: Supporting project proposals to Mexico & Costa Rica

offices.

Responsibilities:

AAnalyze, propose, design and build specific scenarios, integrating

SAP & non SAP systems and applications.

PPrepare, identify the project risks at technical level and how will

be minimized or avoided also as propose the best approach to integrate

heterogeneous platforms.

Tools Used: SAP XI, SAP open hub, IDOCS, RFCs

Senior BI-BPS Strategic Consultant, Brookshires Grocery Company

08/2007-11/2008

Corresponding Location: Tyler, TX

Company Profile: Groceries Retail company, Best place to work in TX

Description: SAP IS-RETAIL PRICING PROJECT - SAP IS-RETAIL, Strategic

Business consultant for Enterprise planning data warehousing,

migration of the current platform from BW 3.5 to BI 7.0. Implement

preconfigured financial scenarios with Business Objects. Prepare the

upgrade for all the operations for retail with POS system. Design,

build and testing for Category management project.

Responsibilities:

AAnalyze, propose, design and build specific scenarios.

IInitial integration and evaluation with Business Objects for

enterprise reporting

PPerformance tuning for BI platform.

Support to current productive system while release the CM project in

productive.

Tools Used: MAP, SEM BPS, ETL tools, Analyzer, Crystal Reports, Live

office, Xcelsius, Sap integration kit, BW tools for infocubes design

and build, retraction, transformations, Business content. Bex WEB

Analyzer, FOX formulas, planning functions and planning sequences. XI

integration with open hub and standard BI interfacing tools.

Senior BI-BPS Strategic Consultant, Grupo Emyco

04/2007-08/2007

Corresponding Location: Leon City, Mexico

Company Profile: The largest Shoes manufacturer at Mexico

Description: Strategic Business consultant for Enterprise planning for

region Americas, Europe and Asian regions, 1st phase with Sales

Planning, 2 with Production and financial planning (BI-BPS Netweaver

2004s). Also was replaced the CO-PA module with a specific and more

flexible profitability analysis in BI 7.0

Responsibilities:

AAnalyze, propose, design and build the solution given.

TTest and document all the process with the new functionality

introduced.

Tools Used: Integrated Planning, MAP, ETL tools, Analyzer, BW tools

for infocubes design and build, retraction, transformations, Business

content. Bex WEB Analyzer, FOX formulas, planning functions and

planning sequences, Excel based.

Senior BI Consultant, Muebles Azcu 03/2007-04/2007

Corresponding Location: Mexico City

Company Profile: Furniture.

Description: BW Consultant to build several financial statements with

specific requests by the customer.

Responsibilities:

AAnalyze, propose, design and build the solution given.

TTest and document all the process with the new functionality

introduced.

Tools Used: ETL tools, Analyzer, BW toosl for infocubes design and

build, Business content.

Senior ABAP consultant, Cerveceria Nacional of Panama

12/2006-01/2007

Corresponding Location: Panama

Company Profile: Beer factory & production.

Description: ABAP Consultant to build an automatic compensation

program in order to eliminate all records with compensation

availability. Also build an automatic process to post all inbound and

outbound empty bottles.

Responsibilities:

AAnalyze, propose, design and build the solution given.

TTest and document all the process with the new functionality

introduced.

Tools Used: BAPI's, ALE, call transaction, User-exits & ABAP programs.

BW Performance tuning, CIMSA - Coca Cola,

11/2006

Corresponding Location: Cuernavaca.

Company Profile: Coca Cola company

Description: BW expert to solve issues about performance and

optimization, also as changes to current BW platform.

Responsibilities:

FFix problems with BW issues in the current operation using R/3,

interfacing with Basis Operating

Suite (ERP) and BW.

Tools Used: BW WH, Reporting and Technical content.

Data expert, Nestle Centroamerica, 10/2006

Corresponding Location: Panama.

Company Profile: Food company

Description: Data expert to design, manage and coordinate data loads

into APO system.

Responsibilities:

AAnalyze and Design the Information architecture to master data loads

well integrate between SAP with and APO system.

DData load into BW Infocubes from APO, proposing new KPI at different

business levels.

Tools Used: APO, BW, Business Content.

Senior ABAP consultant, Stahl

08/2006-09/2006

Corresponding Location: Mexico, USA

Company Profile: Chemical & leather treatment. company

Description: ABAP Consultant to build an automatic transaction to

create material master data, BOM, recipe and price assignment. Also

modification to sapscripts and smartforms.

Responsibilities:

CCreate a super transaction to create automatically mix materials

CCreate a invoice and delivery note for US and Mexico.

Tools Used: BAPI's, ALE, Smartforms, Sapscript.

BW Architect, Tequila Herradura, 07/2006-08/2006

Corresponding Location: Mexico

Company Profile: Tequila and beverage producer

Description: BW Architect to design, manage an Upgrade the BW platform

as R/3 upgrade review as upgrade of BW 3.0B to 3.5.

Responsibilities:

AAnalyze and Design the Information architecture to keep well

integrate SAP with BW system.

MManage BW Infocubes in order to create another after the

installation, proposing new KPI at different business levels.

Tools Used: BW, Business Content, BW SEM.

Senior SAP Architect & ABAP team manager, Grupo Modelo

11/2005-03/2006

Corresponding Location: Mexico

Company Profile: Beer and beverage producer

Description: SAP Architect to design and manage the ABAP team to build

interfaces to connect legacy systems and WEB applications to SAP R/3

to Personnel administration and Personnel development as unify into

one SAP system around 15 legacy systems to payroll control.

Responsibilities:

DDesign the architecture to integrate SAP with legacy systems and WEB

applications.

MManage ABAP team to build any ABAP requirements.

Tools Used: HR TOOLBOX, ALE, Java Conn, WEB sphere, ALV, BAPI's, batch

inputs, smartforms .

Senior ABAP consultant, Domecq

10/2005-11/2005

Corresponding Location: Mexico

Company Profile: Drink and beverage producer

Description: ABAP Consultant to build a report to show the marginal

contribution by each customer to open accounts receivables.

Responsibilities:

CCreate a ALV report to extract the customer information to Excel

file.

Tools Used: ALV, BAPI's .

Senior ABAP consultant, Astra Zeneca

07/2005-08/2005

Corresponding Location: Mexico

Company Profile: Pharmaceutical Company.

Description: ABAP Consultant to build an automatic interface between

APO and R/3 to exchange the Sales orders forecast with another system

called VISION.

Responsibilities:

CConfiguration to automatic exchange info between APO, R/3.

DDefine the new key figures to be extracted and set up the extraction.

DDetermine the procedures to exchange info between R/3 & VISION

Tools Used: BAPI's, ALE.

Senior ABAP consultant, Cerveceria Nacional of Panama

05/2005-06/2005

Corresponding Location: Panama

Company Profile: Beer factory & production.

Description: ABAP Consultant to build an automatic interface between

APO and R/3 to exchange the Production process models as SNP as PP/DS.

Responsibilities:

OOptimization and analysis for load balances.

DDefinition procedures for developing of programs and enhancements for

PPMs.

Tools Used: BAPI's, ALE.

ABAP team leader, Jr. BW Consultant; Novartis Pharmaceutica

10/2004-04/2005

Corresponding Location: Distrito Federal, Mexico

Company Profile: Pharmaceutical company for health products.

Description: ABAP coordinator with FICO & sales module. BW consultant

to support the design and build process for sales monitoring. Load

programs and customizing procedures for start-up phase also as

integration with older systems (Strong experience in Interfaces).

Definition of standard interfaces methods and procedures. Designing

and coding for specialized interfaces.

Responsibilities:

CCoordinate ABAP development team.

BBW consultant to design a datawarehouse for Mexico sales force called

Sales monitoring

OOptimization and analysis for load balances.

DDefinition procedures for start-up for developed programs and

enhancements.

Tools Used: BW Datawarehouse, BW report and analysis, workflow,

Smartforms, sapscript, ABAP workbench, BAPI's, ALE, IDOC, Batch

inputs.

Senior ABAP project leader, Envases Universales

06/2004-09/2004

Corresponding Location: Edo. De Mexico

Company Profile: Manufacturing and reseller company for containers and

molding products.

Description: ABAP Project leader related with HR, payroll, materials,

sales, finance and PP module. Load programs and customizing procedures

for start-up phase also as integration with older systems. Definition

of standard interfaces methods and procedures. Designing and coding

for specialized reports.

Responsibilities:

CCoordinate ABAP development team.

OOptimization and analysis for load balances.

DDefinition procedures for start-up for developed programs and

enhancements.

Tools Used: Smartforms, sapscript, ABAP workbench, BAPI's, Batch

inputs, ABAP query, ABAP dictionary, etc.

SAP Architect and Sr ABAP project leader, Hewlett Packard

09/2000-06/2004

Corresponding Location: Guadalajara, Mexico

Company Profile: Manufacturing and reseller company for personal &

business computing

Description: ABAP Project leader related with materials, sales,

finance and APO module. SAP architect for enhancements to technical

platform and standardizing the new projects and developments.

Coordinating ABAP contractors for developments to Canada &

Latin-America (Brazil, Colombia, Chile, Venezuela, also Canada and

USA). Special assignments for APO implementation at technical

developments to adjust at specific functionality. As SAP Architect,

analyze and provide the best interfacing methods between SAP and

non-SAP systems also as build such scenarios. Definition of standard

interfaces methods and procedures.

Responsibilities:

FFeasibility and architecture definition for interfaces

CCoordinate ABAP development team.

CCoordinate the relations with other vendors for ABAP services.

OOptimization and analysis for load balances.

PPerformance tuning special assignments for CALADO projects (Canada &

Latin-American)

Tools Used: ABAP workbench, BAPI's, IDOCs, Batch inputs, ABAP query,

SAP Business object builder, Sapscript, unix scripts, ABAP dictionary,

etc.

SAP manager consultant, Hildebrando (An Advent Company)

02/2000-08/2000

Company Profile: Software development & technology company

Description: Responsible to grow up the national & international

market for SAP services

Responsibilities:

Find out the market needs and special segments to offer SAP services

Follow up for potential clients.

Understand requirements and Generate solutions proposals

Tools used: Project & Excel, Outlook.

SAP Consultant, ACER 11/1999-01/2000

Company Profile: Manufacturing and reseller company for personal &

business computing

Description: SAP technical consultant for EDI configuration

Responsibilities:

Configuring and Support the requirements for EDI interface and R/3.

Training for production personal to support any new requirement.

Tools used: SD transactions and EDI support. ABAP development, ABAP

dictionary, etc

SAP consultant, Softtek

07/1998-08/1999

Company Profile: TELMEX. Mexican leader at public telecommunications.

Description: Support the R/3 upgrade to release 4.0 and TR

configuration module. ABAP dev.

Responsibilities:

Generate the information interfaces, reports and new requirements for

the new R/3 version

Support the TR configuration for a treasury entities.

Tools used: IMG & ABAP tools.

Other Experience

Softtek, Mexico, Business Consultant Feb

97 - Jun 98

. Consultant in process engineering

. Advisor support in technology trends

. Strategic consultant to apply technology

. Backbone for all technology integration projects, providing

compatibility, trends, market analysis and ROI for project

investments..

Softtek, Mexico, Legacy programmer May

96 - Jan 97

. Cobol programmer for a Healthy government agency called IMSS.

. Design and code the programs and components required to control the

payments to retired persons.

. Coordination with other teams in order to create a flexible system

. Documentation design and update.

SAC (Audit computer-Based systems), Mexico, Designer& programmer Feb 94 -

Feb 96

. Planning and design of components for an audit computer-based system

called SAC using X-base language and procedural programming.

. Programming of components.

. Test and prototyping of new functionality from version 1.0 to 2.0

. Control over new programmers to support the productive systems at our

customers.

. Documentation design and update.

. Security responsible in order to avoid data manipulation using

cryptographic devices.

Education

. B.S. in information systems & management. Strategic IT/IS planning

experience. Tecnologico de Monterrey-Campus Estado de Mexico

1994-1998

. MBA with Electronic Commerce specialization, Tecnologico de Monterrey-

Campus Guadalajara (2007 - Today).

Certifications and Continuing Education

. Consultant formation at Deloitte, KPMG, Softtek and SAP companies.

. Internal Academy at Softtek as SAP FI-CO consultant at 3.1H version.

. Internal Academy at Novartis as BI & SEM consultant.

. Financial advisor and Broker certification by CNByV at Mexico.

. Project Management certification at 2003 by Tecnologico de Monterrey

with PMI coordination.

. Strategic management for IT/IS

. R/3 system fine tuning

Contact this candidate