Kin Francisco De Alba Alvarado

N

Solutions Specific Knowledge Leader.

NTT DATA MEXICO

Feb 2022 - Dec 2022 (11 months)

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 o

Sr. Business Systems Analyst, BI Finance.

Chamberlain Group CGI

Sep 2020 - Feb 2022 (1 year 6 months)

U

SAP BPC – Financial Planning / Consolidation.

UCRYA

Nov 2019 - Jun 2020 (8 months)

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 struc

Application Mgmt. Sr. Specialist Advisor.

NTT DATA, Inc.

Aug 2019 - Feb 2020 (7 months)

SAP MM, SAP FICA, SAP FICO, PP, SAP APO, SAP Success Factors, SAP BW 7.40 BW IP, ECC 6 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 fu

B

SAP BPC – Financial Planning / Consolidation.

BTS Consulting Solutions

Nov 2018 - Aug 2019 (10 months)

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

SAP BPC Consultant.

Celeritech

Sep 2018 - Nov 2018 (3 months)

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 S

B

SAP BW/HANA Developer.

Beyserinconsulting-Nttdata en Terpel Colombia

Jul 2018 - Sep 2018 (3 months)

-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.

Associate Manager / Project Manager.

ColgatePalmolive

Aug 2016 - Jul 2018 (2 years)

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.

E

Architect

EKLEFT BRIDGESTONE

Jun 2015 - Mar 2016 (10 months)

SAP-BPC

F

Senior Consultant SAP-BW / Project Manager

FASTDOLPHIN

Feb 2015 - Jun 2015 (5 months)

SAP Business Intelligence implementation. Building the BI solution for the client. Bex reporting project. Monitoring the development of the project.

U

Solution Architect & Sales Support / Project Manager

USTglobal

Apr 2014 - Feb 2015 (11 months)

Dynamics

3

Bex leader and developer.

3Dconseil

Feb 2014 - Mar 2014 (2 months)

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 Work in an international environment and in the French language.

U

Architect BW / Hana / Project Manager

UST-Global Grupo Empresarial Angeles

Oct 2013 - Dec 2013 (3 months)

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 adjust. Leadership.

F

HANA / BI solutions architect.

FASTDOLPHIN

Jun 2013 - Sep 2013 (4 months)

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.

Senior BI / BO Consultant / Project Manager

LatCapital Solutions

Feb 2013 - Apr 2013 (3 months)

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 in 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 coordination.

L

Project Manager.

LatCapital Beharry & CO. LTD

Sep 2012 - Dec 2012 (4 months)

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 Leadership of an international group. Project management completely in English. Conflict resolution. Acceleration of project delivery with cost reduction.

Project Manager.

LatCapital Solutions

Sep 2012 - Dec 2012 (4 months)

Project. SAP BW, BO, 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 in Leadership of an international group. Project management completely in English. Knowledge of SAP-SPM (Spend Performance Management) solution for acquisition projects (acquisitions).

SAP Analytics Cloud Developer. BI Specialist.

Concentrix Catalyst

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.

Kin Francisco De Alba Alvarado

About

Detail

Timeline

Résumé