David Alejandro Flores Espinoza

Consultant Sr. SAP BW / BO / BCS / HANA / BPC / SAC

Professional experience

Profile

Mr. David Alejandro Flores Espinoza I have more than 11 years of successful application programming, development experience and maintenance, including 11 years of SAP BW, 3.5 years implementing SAP BOBJ and BCS.

I m Consultant with strong problem-solving skills that can design solutions and assist customers with critical and challenging issues.

My experience includes requirements and management, concept development, system design and configuration, software development and testing, and project management. Demonstrated proficiency providing business and technical analysis, developing functional requirements, specifications, and documentation, and translating business requirements into working solutions. As well, I have participated in projects with financial department creating balance sheet, state incomes and COPA, SD, MM, PP and CRM modules.

I have participated in projects in the soft drink, government, beer, steel industries, shopping outlets in extra and transitions for AMS SAP BW/BO/BCS/HANA.

Etc.

Career History

JUN/2017 – PRESENT

Accenture Mexico – Mexico City

Consultant Associate Manager BW / BO / HANA / BPC / SAC

MAY/2016 – MAY/2017

gA (grupo Assa) – Mexico City

Consultant Sr BW / BO

NOV/2015 – ABR/2016

Selever and Tasisosft of America Corporation – Rancho Cucamonga / CA (USA)

Consultant Sr BW / BO

Note: This is my sponsor for TN Visa

FEB/2015 – JAN/2016

IM Consulting / Axosnet – Fontana / CA (USA)

Consultant Sr BW / BO

MAR/2014 – JAN/2015

INFOSYS – Mexico City

Consultant Sr BW / BO

NOV/2013 – MAR/2014

TOPIT – Mexico City

Consultant Sr BW / BO / BCS

MAY/2012 – OCT/2013

T-Systems – Puebla, México and Germany, Munich

Consultant Sr BW / BO / BCS

AUGUST/2011 – APRIL/2012

FL- Associates (Client T-Systems) – Puebla, México and Germany, Munich

Consultant Sr BW / BO / BCS

OCTOBER/2010 – JULY/2011

Deloitte – Mexico City

Consultant Semi-Sr BW / BO

FEB/2010 – SEPT/2010

Enapsys – Mexico City

Consultant Semi-Sr BW

SEPT/2007 – FEB/2010

LOG Sistemas – Mexico City

Consultant Jr BW

Assignment History

Company: Accenture – Grupo LALA

JUN/2017 – PRESENT

Project Name: Implementation of SAP BPC Embedded (Financial Planning and Financial Consolidation) & SAC (Financial Planning and Financial Consolidation)

This project was implemented SAP BW HANA and BPC tool from scratch.

Requirements gathering in the field.

Design and implementation of BW 7.5 on HANA and BPC 10.1 Embedded

Creating Cubes, Advanced DSO’s, DTP, Transformations, Composite Providers and Aggregation Levels, Query’s.

Definition of proposal and development BBP Business Blueprint.

Loads of information from standard extractors 2LIS_13*, 0FI_GL_04, 0EC_PCA_1, 0CO_OM_CCA_9

Tests with end users and key users

Enabling BI Content Business objects

Make process chains

Make SAC reports (some Dashboards, and simple reports)

Use Analysis for Office to make workbooks for BPC

Create Business Rules for eliminations and reclassifications

Create Ownership Manager

Create Journals

Make Consolidation

Technical Tools:

SAP BW, SAP HANA, SAP BPC, SAP SAC, SAP R/3.

Company: gA – PEPSICO International

MAY/2016 – MAY/2017

Project Name: CASA (Argentina, Chile, Venezuela, Mexico) and global catch-up

Support Level 2nd and 3rd.

Made improvements to upload flat files into BW System

Attention of tickets into SM9 Tool

Creation tickets in Toolset (Tickets approval for Basis transports)

Make documentation

Make work plans

Maintenance into BW system directly in Productive.

Transports to Productive.

Make change requests.

Design and Implementation of new queries.

Definitions in the BW data flow for new requirements.

Maintenance and Monitoring of Process chains

Maintenance of Extractors Standard 2LIS, FIAP, COPA.

Create offers for new requirements.

Create new start routines.

Create Dashboards in BOBJ

Corrections in Web Intelligence

Modification and creation of ODS's, Buckets, Transformations, DTP's.

Work together with BASIS team to review performance

Balancing of loads.

Migrate Oracle data base to HANA cubes

Avoid dimensions tables of the cube (SID’s)

Change Advanced DSO's from the Standard DSO's

Update Multiproviders as Composite Providers

Transports via Promotion Management.

Testing of BO Universes

Validation of Roles and Security

Creation of Web Intelligence Reports

Prototype Design for a Sales Dashboard

Creation of Connections

Requirements analysis and creation of proposal based on user needs

Connection of Dashboards to Portal via Queries BEx

Technical Tools:

SAP BW, SAP BOBJ, SAP HANA, SAP R/3.

Company: IM Consulting – Axosnet

FEB/2015 – JAN/2016

Project Name: MES Implementation in CSI (California Steel Industries in Fontana, California) (Partially remote & Client offices)

Implementation of BW and BOBJ

Made improvements to upload flat files into BW System

Make work plans

Maintenance into BW system directly in Productive.

Transports to Productive.

Design and Implementation of new queries.

Definition in BW data flow.

Create Process chains.

Maintenance of Extractors Standard 2LIS.

Create new start routines.

Create reports in Web Intelligence

se IDT tool to define Universes to extract direct data from ERP

Administrator of BOBJ

Modification and creation of ODS's, Buckets, Transformations, DTP's.

UD_Connect Source System

Maintenance in COPA cubes

Working with Finance department to create balance sheet reports, states of incomes.

Maintenance of Extractors Standard 2LIS, FIAP, COPA.

Work together with BASIS team to review performance, balancing of loads from R/3

Transports via Promotion Management.

Testing of BO Universes

Requirements analysis and creation of proposal based on user needs

Analysis and update of queries based on user needs

Technical Tools:

SAP BW, SAP BOBJ, SAP R/3.

Company: Infosys – PEPSICO International

MAR/2014 – DEC/2014

Project Name: SACCAF (Argentina, Chile, Venezuela, Mexico)

Support Level 2nd and 3rd.

Made improvements to upload flat files into BW System

Attention of tickets into SM9 Tool

Creation tickets in Toolset (Tickets approval for Basis transports)

Make documentation

Make work plans

Maintenance into BW system directly in Productive.

Transports to Productive.

Make change requests.

Design and Implementation of new queries.

Definitions in the BW data flow for new requirements.

Maintenance and Monitoring of Process chains

Maintenance of Extractors Standard 2LIS, FIAP, COPA.

Create offers for new requirements.

Create new start routines.

Create Dashboards in BO

Corrections in Web Intelligence

Administrator of BOBJ

Manage user profiles in BO

Modification and creation of ODS's, Buckets, Transformations, DTP's.

Cut over’s.

Update version from 7.0 to 7.4

Work together with BASIS team to review performance

Balancing of loads.

Migrate Oracle data base to HANA cubes

Avoid dimensions tables of the cube (SID’s)

Change Advanced DSO's from the Standard DSO's

Update Multiproviders as Composite Providers

Testing of BO Universes

Validation of Roles and Security

Creation of Web Intelligence Reports

Prototype Design for a Sales Dashboard

Creation of Connections

Requirements analysis and creation of proposal based on user needs

Connection of Dashboards to Portal via Queries BEx

Technical Tools:

SAP BW, SAP BOBJ, SAP HANA, SAP R/3.

Company: Top-IT “Grupo Gigante”

NOV/2013 – MAR/2014

Project Name: SAP Project

Support Level 2nd.

Attention of tickets into OTRS tool

Make documentation

Maintenance into BW system directly in Productive.

Transports to Productive.

Make change requests.

Design and Implementation of new queries (Balance Sheet, Statements of Income).

Definitions in the BW data flow for new requirements.

Maintenance and Monitoring of Process chains

Create offers for new requirements.

Create new start routines.

Create function modules.

Create APD’s.

Create Dashboards in BO

Make new offers for new clients (Companies: Pochteca, Hoteles Presidente and Hotel Palace Resort)

Make analysis in performance of the system.

Make ABAP routines

Create and manage Semantic Cubes (HANA Cubes)

Work together with BASIS team to review performance

Balancing of loads.

Sizing for new Server of BW

Technical Tools:

SAP BW, SAP BO, SAP R/3.

Company: T-Systems Puebla & T-Systems Germany

MAY/2012 – OCT/2013

Project Name: SEN Ongoing AMS SAP

Technical Lead in BW / BCS

Support Level 2nd and 3rd for Siemens Germany.

Loads of flat files.

Made improvements to upload flat files into BW System

Making enhancements into Validation rules to BCS

Attention of tickets into Remedy tool

Make documentation

Maintenance into BW system directly in Productive.

Maintenance into BCS system.

Activities for month end closure in BW/BCS

Customizing in BCS.

Create new validations rules in BCS

Adjustments in master data of Companies – BCS

Transports to Productive.

Make change requests.

Design and Implementation of new queries.

Definition in the BW data flow for new requirements.

Maintenance and Monitoring of Process chains

Maintenance of Extractors Standard 2LIS, FIAP, COPA.

Create offers for new requirements.

Create new start routines.

Working with Finance department to create balance sheet reports, states of incomes

Technical Tools:

SAP BW, SAP BO, SAP R/3, SAP BCS.

Company: FL Associates – T-Systems Puebla & T-Systems Germany

AUGUST/2011 – ARPIL 2012

Project Name: SEN Transition to AMS SAP

Support Level 2nd and 3rd for Siemens Germany taking the transition from the office of München Germany.

Transition of Knowledge transfer from supplier of Siemens.

Loads of information

Made improvements to upload flat files into BW System

Making enhancements into Validation rules to BCS

Attention of tickets into Remedy tool

Make documentation

Maintenance into BW system directly in Productive.

Maintenance into BCS system.

Activities for month end closure in BW/BCS

Customizing in BCS.

Transports to Productive.

Make change requests.

Design and Implementation of new queries.

Definitions in the BW data flow for new requirements.

Technical Tools:

SAP BW, SAP BO, SAP R/3, SAP BCS.

Company: Deloitte – Grupo Modelo

APRIL/2011 – JULY/2011

Project Name: Factory Software

Creating Querys

Loads of information, Tests with end users

Creating user exits, Creating variables

Modification of Multicubes

Analysis of integration

Creating Webis

Creating Universes and Connections

Data Flow Design

Changing data stream

Modification and creation of ODS's, Buckets, Transformations, DTP's, Extensions extractors and data sources

Modification and creation of WAD's.

Working with Finance department to create balance sheet reports, states of incomes.

Technical Tools:

SAP BW, SAP BO, SAP R/3.

Project Name: Support META

FEBRUARY/2011 – MARCH/2011

Attention of Change Request, Problems, Support to the operation.

Creating Querys

Loads of information,

Tests with end users,

Modification of Multicubes, Analysis of integration

Creating Web Intelligence reports

Creating Universes and Connections in BO

Made dashboards with links and drill down

Data Flow Design

Changing data stream

Modification and creation of ODS's, Buckets, Transformations, DTP's, Extensions extractors and data sources

Modification and creation of WAD's.

Technical Tools:

SAP BW, SAP BO, SAP R/3.

Project Name: Pattern Mailbox

NOVEMBEMBER/2010 – JANUARY/2011

This project is for measurement of congratulations, complaints, suggestions and recommendations.

Analysis, design and implementation

Creation of model and data flow of BI

Creating Querys BEx

Creating connections and universe

Creating Reports Web Intelligence reports

Creating process chains

Tests with end users

Data loads

Creating data sources UDI Connect

Technical Tools:

SAP BW, SAP BO, SAP Portal.

Company: Enapsys - INFONAVIT

Project Name: BI Implementation from scratch

FEBRUARY/2010 – OCTOBER/2010

This project was implemented SAP BI tool from scratch.

Requirements gathering in the field.

Design and implementation of BI model

Creating Cubes, ODS's, DTP, Transformations, Multicubes

Definition of proposal and development BBP Business Blueprint.

Creating Querys

Loads of information

Tests with end users

Information Extractor Search Standard CRM

Enabling BI Content Business objects

Creating process chains

Technical Tools:

SAP BW, SAP CRM.

Company: LOG Systems – FEMSA Coca-Cola

Project Name: Execution Systems Evaluation (SEE), Assertively, Fill Rate

OCTOBER/2009 – FEBRUARY/2010

Requirements gathering in the field.

Model design and implementation of BI

Definition of proposal and development BBP (Business Blueprint).

Creating Querys

WAD's Creation

Creating Workbook

Loads of information

Tests with end users

Configuration file upload via FTP

Modification of sources of data in flat files

Technical Tools:

SAP BW, SAP R/3, WSFTP, Unix.

Project Name: Global indicators at corporate FEMSA

NOVEMBER/2009 – JANUARY/2010

Create proposed global indicators

Follow up with managers

Technical Tools:

Microsoft Office.

Project Name: Upgrade BI version 3.5 to 7.0

JULY/2009 – OCTOBER/2009

Validate extraction from ECC

Validate Querys

Validate WAD's

Validate performance of BI data flows

Validate process chains

Validate user roles

Validate BI Accelerator

Loading data into Cubes and DSO’s

Technical Tools:

SAP BW, SAP R/3.

Project Name: Standardization of indicators

OCTOBER/2007 – JUNE/2009

Requirements gathering in the field.

Design and implementation of BI model

Creating Cubes, ODS's, DTP, Transformations, Multicubes

Definition of proposal and development BBP (Business Blueprint).

Creating Querys

Loads of information

Tests with end users

Information Extractor Search Standard BI

Enabling BI Content Business objects

Creating process chains

Technical Tools:

SAP BW, SAP R/3.

Project Name: Score Card

OCTOBER/2007 – NOVEMBER/2007

Modification of Procedures SQL

Documentation of project

Technical Tools:

SQL 2003.

Key Skills

Industries: Soft Drink, Government, Beer and Shopping Outlets

Project Domain: Consultant BW (BI) / BO / BCS

Platform: Windows / Linux / Unix

Operating Systems: Windows, Linux, Unix

Languages: Java, ABAP

RDBMS: MySQL, Oracle, MS SQLServer

Other Utilities:

Methodologies:

Business Blue Print, Methodology ASAP, Ambition Methodology, Change Management (Certified), Incident Management (Certified), Problem Management (Certified).

Office tools:

MSProject,Visio,Excel,Word,PowerPoint,etc.

Key Courses and Training

TBW20 SAP Business Intelligence – Reporting & Analysis SAP February 2008

TBW42 SAP BI - Advanced Enterprise Data Warehousing and Reporting

SAP February 2008

Business Object Build Moncayo, México November 2010

Training of BCS Office T-Systems München May 2012

Education

Qualifications

Bachelor degree in Engineering Computer System

UNITEC (UNIVERSIDAD TECNOLOGICA DE MÉXICO)

Languages

English (Advance)

Spanish (Native)

German (Basic)

Telephones

Home +525*********

Cell Phone +521********** – Preferred

Cell Phone 2 +1-714-***-****

Office: +522*********

e-mail: ac69bn@r.postjobfree.com

Documents

American Visa Valid

TN Visa Valid

Mexican Passport Valid

Contact this candidate