KIN F. DE ALBA

Specialist: SAP BW Senior Consultant Certificate S0003700648

Main Module: SAP BW

Sub modules: SAP Analytics Cloud, BW HANA, BW IP, BPC, SCRUM MASTER.

Nationality: Mexican – TN Visa & SSN with work permit for USA.

LinkedIn:

Mail: ad2rtc@r.postjobfree.com Phone: +52-55-609***** Skype: kindealba

GENERAL DATA

Professional Summary:

●20 years of experience in Business Intelligence implementations in different positions, such as Project Manager, BI Leader, and SAP Functional Consultant.

●Knowledge of SAP BI tools such as SAP Analytics Cloud, BEX, Query Designer, Web Application Designer (WAD), Web Intelligence, HANA Studio, HANA Modeler, BW Planning Modeler, Widgets for Analytics Cloud. And new processes that move to the Cloud, such as Datawarehouse in the cloud. As well as the flow of data from SAP sources or generic sources, combined with data provisioning and data transformation and extraction using tools such as HANA SLT.

●International experience (USA, France, Central America, South America, and Mexico).

●Extensive experience providing training to key users (functions, design, development, and process documentation).

●Sales support: Creation of solution proposals (Technical and Economic) and RFP (Request for Proposal) for contests and bids.

●Languages: English, Spanish & Portuguese.

●Certificate in SAP BW Ver. 7.0

●Certificate in QlikView.

●Certified in MicroStrategy.

●Certified in SCRUM: SCRUM Master, Product Owner & Team Member.

Education:

Institution

Title

Date

Tec de Monterrey - CCM

PMI Diploma

2016

Tec de Monterrey - CCM

Bachelor’s Degree in Computer

1999-2003

Helsinki Business

Administrative Systems

2002

Polytech.

Degree in international business.

Certifications:

No.

Certification

Status

1

SAP BW

CERTIFICATION

2

QlikView

CERTIFICATION

3

SCRUM Master

CERTIFICATION

SCRUM Product Owner

CERTIFICATION

SCRUM Team Member

CERTIFICATION

4

MicroStrategy

Diploma

5

Project Management Institute

Diploma

Implementations:

No.

SAP module

Years of

No. of

Rollouts #

experience

implementations

1

Project Manager /

Project leader

7

9

1

2

BW

10

11

2

3

BW – IP

4

6

4

BPC

2

3

1

5

BO

2

4

6

SAP Analytics Cloud

3

3

7

ERP (SD, CRM, FICA, MM,

2

1

1

FICCO, PP)

PROFESSIONAL EXPERIENCE:

WORK EXPERIENCE:

Position: SAP Analytics Cloud Developer. BI Specialist.

Duration: December 2022

Company: Concentrix Catalyst

Assigned to: Valvoline.

Software used: SAP BW, S4Hana, BO, Analytics Cloud, Native Hana, Cognos.

Description:

End-to-end implementation project of SAP Analytics Cloud, including the migration of the Cognos system to the SAP platform in the cloud. Responsible for creating new management dashboards and replacing previous COGNOS reports with its new version in real time with the use of SAP Analytics Cloud Widgets such as Smart Discovery, Smart Insight, and Smart Predictive.

Responsible for quality assurance in deliverables and monitoring of committed work on a weekly basis.

Position: Solutions Specific Knowledge Leader.

Duration: February 2022 – December 2022

Company: NTT DATA México

Assigned to: El Palacio de Hierro, Grupo PROA, HAITIAN.

Software used: SAP BW, S4Hana, BO, Tableau.

Description:

EPH:

Direct and lead the BI team to the functional and technical discovery of the processes and modules that are obsolete in SAP BW, to replicate said operation in new tools such as Amazon Web Services, Tableau, IBM DataStage.

Design the work plan and distribution of tasks for team members. Carry out the inventory of OLAP objects. Carry out the inventory of BI Reports to be confiscated, inventory of BO Reports to migrate to Tableau. Creation of functional and technical specifications for the creation of OLAP models in AWS. Mapping of tables and fields from the ERP to the AWS Datalake. Mapping of tables and fields of the ERP for the use of Redshift and its subsequent exploitation in different reports and dashboards.

PROA:

Migration project of the SAP S/4Hana application from version 1511 to version 2021. To improve the current functionalities in the transactional system. The tasks are focused on support and help in the technical upgrade, in the BW and BPC modules. Especially in the validation of functional scenarios that include standard processes and processes customized by the user in the entire spectrum of interaction of BW/BPC with S/4Hana 2021. Carry out the design and validation of test scenarios. Detect BW/BPC functionalities that could become obsolete with the S/4Hana 2021 updates.

HAITIAN:

Offer of a support system oriented towards electronic accounting, electronic invoicing and a payment complement. As well as the migration to the new version 4.0 of stamping by the tax authority in Mexico.

Position: Sr. Business Systems Analyst, BI Finance.

Duration: September 2020 – February 2022

Company: Chamberlain Group (CGI)

Assigned to: CHAMBERLAIN MEXICO

Software used: SAP ANALYTICS CLOUD, SAP BPC, SAP BW, S4HANA, POWER BI.

Description:

SAP Analytics Hub:

SAP Analytics Hub project to create a single point of truth within the company. Allowing access and search in all available information sources, relevant topics for decision-making users within the company. This solution allowed access to both reports in SAP technologies and reports in other technologies such as QlikView and Tableau. The solution enabled data orchestration and metadata management.

SAP Analytics Cloud:

Project that consisted of creating a dashboard with daily information to monitor the price of the most important commodities within the company's industry. Especially the price of copper, steel, and the price of shipping goods from China to the US. The dashboard contained predictive information, information estimated by company experts, and historical data on past price behavior. All this as a visualization and decision-making tool against the inflation that was skyrocketing in the USA.

SAP BPC:

BPC migration and simplification project Planning for the Budget version generation process including manual entries and data retraction to the transactional SAP ECC system.

SAP BW:

Migration of data sources, data repository structures to BW/4Hana including transformations, routines and process chains to new data structures

such as Composite Providers, Advanced DSO and other Business Intelligence elements

Power BI:

Power BI data visualization of SAP BPC Data Models allowing Dashboard analysis and visual support for decision makers and process owners in the company.

Position: SAP BPC – Financial Planning / Consolidation.

Duration: November 2019 – June 2020

Company: UCRYA

Assigned to: Continental Resources – Oklahoma City OK USA

Software used: SAP BPC 10.1 & SAP BW 7.5 BW IP, ECC 6.0

Description:

Financial Planning using BPC console. Support on Planning Financial Reports for Property Rolls. Upload financial information from ECC: FICA, FICO, SD to BW and BPC. Take care of Process chains and BPC packages to run appropriately. Creation of aggregates and planning functions.

Create new reports to have different versions live on the budgeting for client.

Support to the transformation and conversion files for master and transactional data in the BPC.

Support to dimensions of the planning financial model. Creation of Composite providers using Info Objects required in BW using Hana modeler.

Filling information from the corresponding Info Providers (in BW) from the transactional system and its subsequent replication in the corresponding structures in BPC Environments.

Monitoring and resolution of problems with the client, as well as advice on processes and best practices.

Position: Application Mgmt. Sr. Specialist Advisor.

Duration: August 2019 – February 2020

Company: NTT Data- Services

Assigned to: Coca Cola Southwest Beverages – Dallas Fort Worth TX USA

Software used: SAP MM, SAP FICA, SAP FICO, PP, SAP APO, SAP Success Factors, SAP BW 7.40 BW IP, ECC 6

Description:

Hiring process for new resources to provide L1.5 and L2 support for Coca Cola (CCSWB) team at Dallas Texas. Train new resources in order to comply with SLA for our client in Dallas Texas. Creation of deployment plan for transitioning help desk & support from Guadalajara Mexico.

Follow up team activities during transitioning from Dallas Texas to Guadalajara Mexico.

Create new applications specialized Knowledge Data Base.

Maintain transparency throughout the transition in order to identify and mitigate risks, provide timely updates and status, and adhere to schedule. Leverage support tools: Portfolio Analyzer, Repository/Analyzer, Articulate 360 planning functions & aggregates for transitioning.

Position: SAP BPC – Financial Planning / Consolidation.

Duration: November 2018 – August 2019

Company: BTS Consulting Solutions

Assigned to: CHARLY – Mexico Guanajuato

Software used: SAP BPC 10.1 & SAP BW 7.40 BW IP, ECC 6.0

Description:

Financial and Consolidation System deployment for Charly group, including 8 companies plus an additional foreign company (which is not included for consolidation).

-Development of Business Blueprint.

-Creation of connections between systems: FICO-BW-BPC for the flow of information.

-Creation of transformation and conversion files for master and transactional data in the BPC EPM console for Charly Group.

-Creation of the corresponding dimensions of the planning model & consolidation model.

-Creation / Activation of Info Objects required in BW as repositories of data for exploitation in the BPC server.

-Filling information from the corresponding InfoProviders (in BW) from the transactional system and its subsequent replication in the corresponding structures in BPC Environments.

-Monitoring and resolution of problems with the client, as well as advice on processes and best practices.

Position: SAP BPC Consultant.

Duration: September 2018 – November 2018

Company: CELERITECH

Assigned to: Grupo Axo – Mexico City

Software used: SAP BPC 10.1 & SAP BW 7.40 BW IP.

Description:

Creation of imputable reports in BPC using aggregates to a Composite Provider, as a solution for H.R. providing a deep dive visualization for Brand, Account, Cost Centre with drill down capabilities. Correction and enhancement of BPC Cash Flow report (correction in user exit variables and planning function).

- Harmonization of data coming from Accounts Receivable and Payable (FI-CA) in or der to process large documents to realize account receivable reports.

- Perform technical review of information gathered from functional resources (functional specifications).

- Provide reports for final user Analysis Office (for Excel).

-Creation/Modification of Fox code in Planning Function for Planning Sequences.

-Deliver Business Blueprint to client for proposed solution.

-Data Source creation, Data Flow creation, Info Objects creation, ADSO creation, Composite Provider Creation, Query creation, Workbook creation.

-Resolution to different BPC issues.

Position: SAP BW/HANA Developer.

Duration: July 2018 – September 2018

Company: BEYSERIN CONSULTING

Assigned to: Coca-Cola Colombia

Software used: SAP BW 7.5 BW IP & HANA.

Description:

Deployment of a full pack of ETL custom extractors along with dataflows from CRM & FICO, SD, MM, FICA to BW/HANA. Creation of dynamic reports and dashboards to fill up KPIs and diverse indicators for Coca-Cola. Develop planning functions under BW IP platform.

-Technical review of information gathered from functional resources (functional specifications).

-Creation of technical specs for ABAP team located in Mexico.

-Correction of Business Blueprint as part of deliveries to client.

-Data Source creation, Data Flow creation, Info Objects creation, ADSO creation, Composite Provider Creation, Query creation, Workbook creation.

-Resolution to any performance issues.

-Training and walk through the client to solution delivered.

Position: Associate Manager / Project Manager.

Duration: August 2016 – July 2018

Company: COLGATE-PALMOLIVE

Assigned to: Colgate-México, Colgate-Peru, Colgate-India, Colgate-USA.

Software used: QlikView, MicroStrategy, Tableau, SAP, BW IP.

Description:

Implementation of business intelligence systems focused on business planning (Colgate Business Planning). Implementation of solutions focused on the governmental (regulatory) requirements of each subsidiary in Latin America.

Project Manager Responsible for project implementation:

-Top Customers Project with QlikView.

-CBP (Colgate Business Planning) project for commercial promotion with SAP (BEx, CRM and BW).

-Project to change currency for Colgate-Venezuela with SAP (ABAP and BW).

-Design of compliance in safety standards for suppliers of Colgate-Colombia, Colgate-Peru, Colgate-India, Colgate-Brazil and Colgate-Mexico.

-Electronic Billing Project for Colgate-Colombia.

Position:

Duration:

Company:

Assigned to:

Software used:

Description:

SAP-BPC Architect

From June 2015 to March 2016

EKLEFT

BRIDGESTONE - Mexico City.

SAP BPC 10.0. / BW 7.3 / ERP 6.0

Implementation of SAP-BPC for Mexico, Costa Rica and Colombia. Roll out.

Responsibilities:

Solution architecture design for SAP-BPC implementation.

Monitoring the development of the implementation of the Business Intelligence team.

Design of Models and Dimensions BPC.

Development of server and hardware sizing for the implementation of BPC.

Creation of RFP as part of the internal customer team.

Monitoring the development of the BPC solution.

Creation of the formats for the transformations in the information flows for the BPC ETL layer.

Position:

Duration:

Company:

Assigned to:

Software used:

Senior Consultant SAP-BW / Project Manager

February 2015 to June 2015

Fast Dolphin

GORSA Mexico City and Chiapas.

SAP BW / SAP BO

Description:

SAP Business Intelligence implementation.

Responsibilities:

Building the BI solution for the client.

Bex reporting project.

Monitoring the development of the project.

Position:

Duration:

Company:

Assigned to:

Software used:

Description:

Solution Architect in SAP.

Responsibilities:

Solution Architect & Sales Support / Project Manager

From April 2014 to February 2015

UST-Global

Casas YES, Copa Airlines, Pemex.

Microsoft Dynamics, SAP-BO, SAP-BW.

Creation of Technical and Economic Proposals as part of the services offered by UST-Global.

Reply to contests.

Negotiation with the client and executive presentations.

Tools Used:

SAP R / 3 FICA, FICO, MM, SD; SAP-BO, SAP-BW, Microsoft Dynamics, Microsoft Outlook, Microsoft Office and Windows X, Project, MS Visio.

Skills acquired in project:

Negotiation with the client.

Conflict resolution.

Leadership team

Position:

Duration:

Company:

Assigned to:

Software used:

Description:

Bex leader and developer.

February to March 2014

3Dconseil

Faurecia - Paris France.

SAP BW 7.0

Implementation of BI reports.

Roll Out Mexico - France.

Responsibilities:

Creation of interfaces.

Creation of functional specifications.

Creation of Bex reports.

Leading the Bex team.

Follow-up of developments.

Tools Used:

SAP-BW, Query Designer, Bex Analyzer.

Skills acquired in project:

Work in an international environment and in the French language.

Position:

Duration:

Company:

Assigned to:

Software used:

Description:

Architect BW / Hana / Project Manager

October 2013 to December 2013

UST-Global

Grupo Empresarial Angeles - Mexico City.

SAP BW 7.0

Tuning the performance of the Business Intelligence platform (Tune UP) and propose HANA as a future solution and likely future implementation.

Responsibilities:

Deep analysis of each BI Report, Query, WAD, InfoView, Dashboard and get the possible solutions for each problem.

Analysis of ETL performance.

Analysis of the current BW architecture.

Analysis of BI servers.

Tools Used:

Microsoft Suite. SAP-BW, SAP-FICA, FICO, SD, Query Designer, Bex Analyzer, Web Application Designer (WAD), Web Intelligence.

Skills acquired in design:

Experience as a solution architect.

Technical skills to improve performance and adjust.

Leadership.

Position:

Duration:

Company:

Assigned to:

Software used:

Description:

HANA / BI solutions architect.

From June 2013 to September 2013

Fast Dolphin - IBM USA

Cemex - Monterrey Mexico.

SAP BW / HANA

Redesign of data architecture for CEMEX, reporting and monitoring of predictive analytics as well as process optimization.

Responsibilities:

Design a solution infrastructure that integrates strategic visualization, drill-down and KPI precision. Ensuring that the solution allows real-time updates and factors such as what-if analysis are possible. From a technical point of view, create a solution that allows the replacement of databases of legacy systems, such as CMSC, SIM and others, with SAP BW in HANA as a solution.

Tools Used:

SAP BW / Hana, SAP FI, SD, MM, PP, Microsoft Outlook, Microsoft Office and Windows X, Project, MS Visio.

Skills acquired in project:

Teamwork with US colleagues.

Architectural project

Approach to HANA.

Position:

Duration:

Company:

Assigned to:

Software used:

Description:

Senior BI / BO Consultant / Project Manager

February 2013 to April 2013

LatCapital

Agricorp - Managua Nicaragua.

SAP R / 3, SAP BW.

Business Objects implementation.

Creation of customized management indicators (KPIs).

Creation of WebIntelligence and Crystal Reports.

Responsibilities:

Business Objects implementation.

Creation of customized management indicators (KPIs).

Creation of WebIntelligence and Crystal Reports.

Training for the client's team.

Development of new extraction structures.

Tools Used:

SAP FICO, SD, MM, FICA, SAP BW, SAP BO.

Skills acquired in project:

Leadership of a group of 8 people.

Training and creation of new Jr consultants in the BI area.

I have strengthened the experience in leadership and team coordination.

Position:

Duration:

Company:

Assigned to:

Software used:

Project Manager.

From September 2012 to December 2012

LatCapital

Petrotrin - San Fernando Trinidad and Tobago.

Microsoft Project. SAP BW, SAP BO, SAP ERP.

Description:

Business Objects implementation.

Implementing Expense Performance Management (SAP-SPM Analytics).

Creation of 10 customized management indicators.

Reporting using WebIntelligence and Crystal Reports.

Responsibilities:

Responsible for all implementation of BO and SPM Suite.

Problem tracking and risk management for deliveries.

Project management for actions and problem solving.

Tools Used:

Microsoft Outlook, Microsoft Office and Windows X, Project, MS Visio.

Skills acquired in project:

Leadership of an international group. Project management completely in English. Knowledge of SAP-SPM (Spend Performance Management) solution for acquisition projects (acquisitions).

Position:

Duration:

Company:

Assigned to:

Software used:

ABAP.

Project Manager.

From September 2012 - December 2012

LatCapital

Beharry & CO. LTD - Georgetown Guiana.

Microsoft Project. SAP BW, SAP SD, FICA, FICO, MM, CO, PP, BASIS and

Description:

Upgrade (ECC upgrade) of the entire ERP from version 4.7 to version 6.0

Responsibilities:

Responsible for all upgrade and modules considered.

Project monitoring using SAP-Solution Manager (SOLMAN).

Tools Used:

Microsoft Project. SAP BW, SAP SD, FICA, FICO, MM, CO, PP and ABAP.

Skills acquired in project:

Leadership of an international group. Project management completely in English.

Conflict resolution.

Acceleration of project delivery with cost reduction.

Position:

Duration:

Company:

Assigned to:

Software used:

Description:

Complete implementation cycle

BI Module Leader. SAP BW Development Consultant.

From August 2011 to April 2012

Softtek

ConProducts - Chicago IL, USA.

SAP BW.

Implementation of BW.

Roll Out Mexico - USA.

Responsibilities:

Responsible for the BI module.

Creation of adaptations and extractors for different DataSources (Data Sources).

Creation of Multiproviders, InfoCubes, DSO

Creation of InfoObjects, transfer rules, transformations.

DTP (Data Transfer Process) creation. InfoPackages.

Responsible for the processes of loading legacy systems into the SAP BW system.

Project monitoring and problem solving.

Design of executive presentations.

Tools Used:

Microsoft Project. SAP BW.

Skills acquired in project:

Work in an international group. Design completely in English.

Conflict resolution.

Position:

Duration:

Company:

Assigned to:

Software used:

Description:

Complete implementation cycle

Implementation of BW.

BI Module Leader.

From June 2010 to June 2011

EBPartners

Walmart - Bentonville AR, USA / Mexico City.

SAP BW.

Roll Out of Mexico - USA, UK, Japan, Canada, Puerto Rico, Argentina.

Responsibilities:

Responsible for the implementation of BI for Mexico.

Change control management with the SAP ADM tool.

Quality control management with the HP-Quality Center tool for comprehensive test cycles.

Creating local and global Functional Specs.

Creation of local and global Technical Specs.

Creation of manuals, business processes and simulations using the SAP-SSP tool (SAP Service Pack).

Responsible for uploading data from legacy systems to SAP BW.

Project follow-up and module status.

Tools Used:

Microsoft Project. SAP BW. HP-Quality Center, SAP-SSP.

Skills acquired in project:

I work in an international group. Design completely in English.

Conflict resolution. Training for users.

Position:

Duration:

Company:

Assigned to:

Software used:

Business Intelligence Module Leader.

From January 2009 to June 2010

Nasoft

Nadro - Mexico City.

SAP BW, SAP BO, QlikView.

Description:

Complete cycle of the implementation of SAP FICA, MM, SD,PP,PS and BW.

Responsibilities:

Responsible for the implementation of BI.

Development of the following modules: PS (Project System), BPC (Business Planning and Consolidation), BW (Business Warehouse), BO (Business Objects), QlikView (Dashboards and KPIs).

Troubleshooting.

Responsible for the design and architecture of SAP BW.

Responsible for connecting and communicating between SAP and QlikView.

Project WBS drawing.

Tools Used:

Microsoft Project. SAP BW. SAP-BO, QlikView.

Skills acquired in project:

Knowledge of QlikView and Certification. Integration of the entire solution.

Project management. Leadership

Position:

Duration:

Company:

Assigned to:

Software used:

Description:

Project leader. Consultant BW.

From November 2008 to December 2008

Nasoft

Facileasing - Mexico City.

SAP BW

Development and activation of standard BW functionality.

Activation and start-up of standard reports, queries, cubes, rules and InfoObjects.

Activation of Business Content modules: FI-GL, FI-CA, FI-CO, SD, MM.

Responsibilities:

Responsible for the construction of the BW solution model.

Configuring and improving the performance of InfoCubes, Reports, Queries in all environments:

Development, Quality, Productive.

Attention to issues and problem log tracking.

Tools Used:

Microsoft Project. SAP BW.

Skills acquired in project:

Knowledge of the leasing industry.

Position:

Duration:

Company:

Assigned to:

Software used:

Description:

Senior Consultant BW

From May 2008 to September 2008

Intellego

Intercontinental hotels - Mexico City.

SAP BW

Development of a dashboard, with costing system ABC (costs by activities). The project is built by integrating Business Objects (Metify) into BW cubes. Conversion of the Value Driver Tree, for costs per activity.

Web reporting using the Web Application Designer (WAD) tool, with drill down functionality for each indicator in different dimensions.

Responsibilities:

Responsible for the construction of the SAP BW solution model.

Responsible for the SAP BW / BO connection.

Responsible for creating SAP BW reports.

Track the log of project issues.

Tools Used:

SAP BW. Business Objects - Metify.

Skills acquired in the project:

Approach to the hotel industry and the cost-per-activity model.

Position:

Duration:

Company:

Assigned to:

Software used:

Description:

Consultant BW / Consultant BCS / Project Manager.

From January 2007 to December 2007

Intellego

Petróleos de Venezuela (PDVSA) - Caracas Venezuela.

SAP BW, NetWeaver BCS.

Migration of the Consolidation process (FI-LC) for SEM BCS V4.0 (based on BW), for the consolidation of 56 companies. Financial consolidation using IFRS and US GAAP.

Responsibilities:

Responsible for the project of financial and volumetric consolidation with its 56 companies using different sources of information. Responsible for 6 technology specialists and monitoring of their deliveries.

Creation of the work plan.

Responsible for the sources of information for the financial consolidation model.

Responsible for the creation of the indicator framework.

Tools Used:

SAP BW. SAP BPC, Microsoft.

Skills acquired in project:

Approach to the oil industry and financial consolidation.

Position: SAP BW Consultant / Project Leader.

Duration: From October 2006 to December 2006

Company: Intellego

Assigned to: Petróleos de Venezuela (PDVSA) - Caracas Venezuela.

Software used: SAP BW.

Description:

SAP-BW implementation.

Responsibilities:

Definition of reports for third parties, such as: Central Bank of Venezuela, Ministry of Oil and Mines, Stock Exchange; among others.

Definition of a statistical graph for financial management in PDVSA.

Tools Used:

SAP BW. Microsoft.

Skills acquired in design:

Approach to the oil and government industry.

Contact this candidate