Sap Hana Senior Consultant
Resume:
LUIS CANELA
****.******@*****.***
UK/Spain
PROFESSIONAL SUMMARY
I am an informatics engineer, certified in SAP BI/BW and in SAP HANA. I have worked as a consultant for over 16 years. My background in SAP includes more than 5 full life cycle implementations, where I've played a key role in facilitating smooth migrations from legacy systems to new, technologically advanced versions. I thrive in multicultural environments and have a proven track record of successful work in various countries, showcasing my adaptability to diverse settings.
SKILLS
BW4HANA / BW2HANA expert.
BW Embedded expert. (HANA Analytic)
SAP Analytic Cloud (SAC)
SAP Datasphere (Views, Analytical models, dataflows, DAC)
SAP BW Bridge.
ABAP programming.
SQL.
SAP CAR (former POS DM) knowledge.
HANA (CDS, Scripts, Views, Table functions, Procedures, PlanViz)
Design Implementation
Decision Making
Business Process Analysis
EXPERIENCE
SAP Datasphere/SAC senior consultant/designer.
Vivo Energy (Feb 2024 – Present)
Technology used:
Datashpere, SAC, SAC planning, Microsoft Lists.
Gathering of requirements from functional counterparts and translating them into functional requirements.
Design of the solution using Datasphere and SAC and SAC planning.
Creation of Views in Datasphere.
Creation of Dataflows in Datasphere.
Creation of Analytical Models in Datasphere.
Creation of Stories on SAC.
Data access control (DAC).
SAP BW4HANA/HANA studio Sr.Consultant/Architect (Part Time)
Essity, Jan 2024 - April 2024
Collaborated closely with functional teams to gather and comprehend project requirements.
Proposal and discussion of the technical design of the BW/HANA solution.
Development of the HANA views essential for extracting and transferring data to Datalake, implementing logic within these views to avoid duplicated storage of data.
Utilized data from diverse sources including ACDOCA, KEKO, KONH, KONP, CKIS, COSS, COSP among others to compute material costs, activity costs, overheads, PUP, Legal and Global prices (Actuals, Planned and Targets), and other critical metrics pivotal for KPI’s assessments.
Technology used:
SAP HANA studio, BW4HANA, SQL, CDS Views,ABAP.
SAP BW4HANA/HANA studio Designer/SAC/Sr.Consultant/Architect
HILTI, Jun 2021 – Dec 2023, Switzerland
SAP HANA studio, HANA 2.0 SQL, SAP BW4HANA 2.0, Sap Analytic Cloud (SAC), BW Embedded, Jira, ABAP, Confluence
Redesign existing flows built in BW 3.7 into new solutions for BW/HANA
Gather the requirements from the functional side to add new functionalities to the old solutions.
Design the new solutions to achieve better performance on BW4HANA
Responsible of quality management area/reports
Designing reports on ECC embedded BW.
SAP Analytic Cloud SAC Reporting.
Migration of BW models to datasphere (BW bridge).
Creation of new Datasphere models to replace BW models.
Use of CDS views to improve performance and push down the logic to HANA
Performance Analysis on bex queries and HANA views using PlanViz to find bottlenecks and make faster reports.
SAP HANA studio Designer/Sr.Consultant, BAYER, Jun 2021 - Sep 2021, Barcelona (Part - time).
SAP HANA studio, RoiPE
Migration of bex query reports to HANA views.
SAP BW4HANA/ HANA studio Designer/Sr.Consultant, Kering, Sep 2019 - Mar 2021, Milano, Italy
Used: SAP HANA studio, HANA 2.0 SQL, SAP BW4HANA 2.0, SAP CAR, BW Embedded, Jira, Kanban, Confluence, CHARM, SNOW
Gather functional requirements and create a technical design
Responsible of Sales Billing implementation on BW4HANA 2.0 and HANA 2.0
Responsible of Sales Order flows BW4HANA 2.0 and HANA 2.0
Responsible of POS (billing, tender and discount flows) on BW4HANA 2.0
Designing reports on HANA CAR embedded BW (Sales item, discounts, tender)
Designing reports on ECC embedded BW
Use of PlanViz to improve performance of queries and HANA views.
(Sales item, discounts, tender)
Use of CDS views to improve performance and push down the logic to HANA.
BW/HANA Designer/Architect/Scrum Master, Nestle, Oct 2016 - Sep 2019, Vevey, Barcelona, Switzerland / Budapest, Spain
(SAP HANA / SAP BW/ SAP design Studio, ABAP)
Technology used: SAP HANA studio, HANA SQL, SAP design Studio, SAP BW, SAP MII, DMO
Daily contact with business to understand new requirements and translate those into technical solutions that must meet the architecture principles
Designed/Co-designed solutions at Nestle like (Contract Manufacturing Reports, FEAT reports, OSD reports, AMM reports)
Worldwide roll out of FEAT solution to connect SAP MII to SAP HANA and BW reports in over 380 factories
Help business to create meaningful KPI's based on the existing data in the systems, giving new ideas and helping them streamline their own ideas
Design of the “Contract manufacturing” dashboard solution for Nestle worldwide
Design of the “Milk Collection” Report for Mexico, used later as a template for Milk Collection solution around the world
Creation of POC's to check viability of new solutions developed using mixed scenarios HANA/BW/Design Studio
Involved with General architecture team in discussions to integrate new technologies to existing architecture principles
Assessing of offshore developments
Driving scrum meetings as scrum master
Creation of design documents and build specs
Managing of human resources assigned to my projects.
HANA Senior Consultant, Airbus Group, SAP, Jun 2016 - Sep 2016, Toulouse, France
Technology used: SAP HANA studio, HANA SQL, Lumira, SAP design Studio
Migration of the BW solution onto SAP HANA studio standalone
In direct contact with the business for the definition of the new KPI's
Creation of new SAP HANA models.
Creation of real time dashboards used for airplanes manufacturing
Use of CDS Views (Files)
Use of Lumira
Use of SAP Design Studio.
SAP BI/HANA Senior Consultant, Mark & Spencer, Jul 2014 - Mar 2016, London, UK
SAP BI 7.4, SAP HANA studio, HANA SQL, NLS
Head of sales migration to HANA data flow and reports
Liaising with the business to understand their requirements and suggest the best options and alternatives
Designing the Sales data flow on BW/HANA (LSA++)
Creation of HANA views (Attribute, Analytic and Calculated) in HANA studio
Creation of SQL script views and procedures in HANA studio
Use of Expert (HANA) Script in BW transformations
Working on NLS split solutions in order to save HANA memory space
Design and building of planning interface solution, to send data from BW/HANA system to JDA (Planning system)
Working on Merchandise planning project to consolidate planning data, Sales, Stock and Intake on reporting layer
Redesigning existing solutions in order to meet new requirements
Coordination of transport releases.
SAP BI/HANA Senior Consultant, Shell, Global Solutions, Jun 2012 - Apr 2014, The Hague, Netherlands
Technology used: SAP BI 7.3, SAP R3, SAP HANA studio, SAP BO, SLT, BODS
Leading the migration of Real Estate and PTW (Projects and Time writing) solution into BW powered by HANA
Contributing to the creation of the new LSA++ approach for the new system
Redesigning of existing data flows in order to fulfill the new standards of LSA++ for BW powered by HANA
Building the new solution on BW powered by HANA adding new providers as Composite providers and hybrid providers in order to push the calculations to the data base and therefore improve performance
Implementing the new ABAP standards to improve performance on BW powered by HANA
Use of Native HANA for the Creation of calculated, attributes and analytical views on HANA studio, to be published and used on SAP BI 7.3
Creation of HANA views (Attribute, Analytic and Calculated) in HANA studio
Creation of SQL script views and procedures in HANA studio
Identification of data sources to be migrated to SLT for real time acquisition data.
SAP BI/BW Senior Consultant, British Gas, Nov 2010 - May 2012, London, UK
Team/Dev
Lead)
Project “Catalyst” (Siebel replacement) - Reports creation for ISU
Technology used: SAP BI 7.0, SAP R3-ISU, SAP CRM
Systems: SAP R3-ISU, SAP HR, SAP CRM, Boxi3, Boxi4 and Non-SAP Sequel Server systems
Leading a team of 10 consisting of BW, Testing and BO resources
Responsible for the overall design and Architecture of the solution
Analysis of the User Stories (Business requirements in Agile methodology)
Interacting with the business to flush out any outstanding requirements
Time estimations and Sprint planning
Analysis and Activation of CRM and ISU data sources
Enhancement of the data sources when needed by using BADIs
Use of LSA to the whole design in BW data flow
Universe creation (BOXI4) and Reports creation (BOXI4)
Data Services data extraction
Methodology: Agile, LSA (Layered Scalable Architecture).
SAP BI/BW, POS DM Consultant, TITAN warehouses, Mar 2010 - Oct 2010, Panama City, Panama
Technology used: SAP BI 7.0, SAP POS DM, SAP Retail, Non SAP POS (Point Of Sale)
SAP Retail Implementation
POS Analytics (SAP BI) Business Content Activation
POS DM, PIPE (Inbound, Outbound) installation and Setup
BI Retail: Customizing and Master Data Extraction Delta Extraction MARM and MEAN for POS Analytics Content
PIPE configuration
BI Retail: Merchandize and Assortment Planning configuration, OTB (Open to Buy) and PPW (Price planning workbench)
Analysis of the Tlog (Transaction Log Coming from POS).
SAP BI/BW Consultant, COBECA, Nov 2009 - Feb 2010, Maracaibo, Venezuela
Project: “Sinergia phase 1B”
Technology used: SAP BI 7.0, SAP R3 (HR, FI, SD, and MM), ORBIS, E3 (Sales and purchase)
SAP BI BO technical designer for SAP BI 7.0 Full life cycle implementation (SAP: HR, FI)
Technical design for the Business blue print for Sap BI 7.0 and supporting the Sap SM (Pilot) and SAP BO design
Data extraction test, data sources identification and activation
Business content (BC) Activation
LO-Cockpit Extractors
Identification and configuration of relevant KPIs for the Balanced Score Card.
BI/BW Consultant, EBSA, Boyacá Electricity, SAP, Jun 2009 - Oct 2009, Colombia
MARA”
Technology used: SAP BI 7.0, SAP CRM 7.0
BI 7.0 implementation for CRM 7.0 Implementation (services, analytics, sales)
Analysis of client indicators, and Business blue print adjustment
Business content activation
Data sources identification and activation (Source system and BI)
Infoproviders activation: DSO, Infocubes, Multiproviders
Update rules, transfer rules, DTP, data packages creation/ Activation
Design and Creation of info providers and reports used to achieve client needs not included in the SAP standard
Process chains creation and reports creation
Standard reports activation and standard data extractors activation
Creation and enhancements of customized data extractors
ABAP routines development
Data loading tests
Investigation, creation and application of OSS notes
Inside CRM 7.0 and 6.0 Configurations:
Installed Base, Service orders, service contracts
0CRM_TSS_PKYF => Timestamp Service: Performance Key Figures
0CRM_TSS_DTRACK=> CRM Tracking of Document Processing Lifecycles
Other Operations configurations.
SAP BI/BW Consultant, AC Hotels, Jan 2009 - May 2009, Madrid, Spain
SAP BW 3.5, SAP R3
Creation of new reports, and analytical tools needed for AC Hotels that will help with future decisions
Creation and design of Calculated and restricted key figures, reports, process chains, APD, Data mining (ABC Clustering) Infocubes, multiproviders
Managing of daily data loads, and integrity of data on the reports for AC Hotels Spain, Italy and Portugal
Analysis of the new requirements and designing possible solutions
Making changes on the existent web applications
BW Authorizations, transports, development, and unit test
Customizing, support and development of minor enhancements on BW, Process Chains, Queries, ABAP routines, user exit, Business Explorer, Web Application Designer, creation of new calculated and restricted key figures and reports For AC Hotels (Italy, Spain, Portugal)
BI/BW Consultant, UNILEVER, SAP, Sep 2007 - Dec 2008
Project: “Sirius”
Technology used: SAP BW 3.5, SAP BI 7.0, and SAP R3
Analysis of new requirements and designing possible solutions
Interacting with Build, Design, Test teams to find root of the cause, fixing in development environment, transporting to UAT systems and subsequently to production systems thru creating change requests, live link tasks and transport request via change manager's channel
Gathering the work log information (remedy) to fix the business issues and communicating with client in order to solve/fix issues in a timely manner.
Also involved in discussing their concerns, enhancements, future changes and developments in the system thru GAP analysis and change management (ME's) in order to meet their deadlines
Creation and design of Calculated and restricted key figures, reports, process chains, Update rules, Infocubes, multiproviders, ABAP routines, Infospokes, web applications, ODS, DSO, user exits (in general ETL)
Managing of daily data loads, and integrity of data in reports for Unilever around Europe (over 15 European countries).
SAP BI/BW Consultant, ELECTRICIDAD DE CARACAS, Feb 2006 - Aug 2007, Venezuela
Operative continuity consultant, EMPRESAS POLAR, Jul 2005 - Jan 2006, Caracas, Venezuela
EDUCATION
Introduction to Python (online training)
Jan 2024
Datasphere (Open sap training)
Jul 2023
SAP HANA
Apr 2012
SAP BO (Excelsius, Web Intelligence, Universe designer) workshop
Nov 2009
ABAP (NCG consulting group)
Jul 2006
Academy SAP BIW 3.5 (Certified)
Mar 2006
ASP y SQL Server (40 Hours) (Mega Training IBM, Adecco)
Oct 2005
Engineer Informatics (B.S and Master): Information Systems
Universidad Centro-Occidental Lisandro Alvarado, Barquisimeto, Venezuela, Jun 2005
Macromedia Flash MX (20 Hours)
Feb 2005
2nd Module CCNA (Cisco Networking Academy)
1st Module CCNA (Cisco Networking Academy)
.
Contact this candidate