Sap Data

Luis Alberto Canela Chacon

email: ****.******@*****.*** +44-743*******

SAP BI/BW, POS DM, ABAP, BO, HANA Consultant

HIGHLIGHTS OF QUALIFICATIONS

Certified, SAP BI/BW - HANA consultant with 10+ years of extensive IT and business expertise

3 Years of HANA Studio experience.

Actively code and configure application and business information systems

POS DM Expert

ABAP programming of reports, dialogs, user exits, BADIs

Business Objects (BO) Universe and Report Creation and Data Services (BODS)

Languages spoken: Spanish (native speaker), English (Advanced), French (Advanced), Dutch (Basic)

PROFESSIONAL EXPERIENCE

Jul 2014 - Present, Mark & Spencer London, UK

SAP BI/HANA Senior Consultant

Technology used: SAP BI 7.4, SAP HANA studio, 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

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.

Jun 2012 – Apr 2014, Shell (Global Solutions), The Hague, Netherlands

SAP BI/HANA Senior Consultant

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.

Identification of data sources to be migrated to SLT for real time acquisition data.

Nov 2010 - May 2012, British Gas (Centrica), London, UK

SAP BI/BW Senior Consultant (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).

Mar 2010 - Oct 2010, TITAN warehouses, Panama City, Panama

SAP BI/BW, POS DM Consultant

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

Nov 2009 - Feb 2010, COBECA, Maracaibo - Venezuela

SAP BI/BW Consultant

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.

Jun 2009 - Oct 2009, EBSA (Boyacá Electricity), Colombia

SAP BI/BW Consultant

Project: “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.

Jan 2009 - May 2009, AC Hotels, (Madrid, Spain)

SAP BI/BW Consultant

Technology used: 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).

Sept 2007 - Dec 2008, ACCENTURE / UNILEVER, Europe

SAP BI/BW Consultant

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

Feb 2006 - Aug 2007, ELECTRICIDAD DE CARACAS, Venezuela

SAP BI/BW Consultant

Jul 2005 - Jan 2006, EMPRESAS POLAR, Caracas, Venezuela

Operative continuity consultant

EDUCATION

B.S. Information Systems, June 2005

Lisandro Alvarado University. Barquisimeto, Venezuela

COURSES

SAP HANA, April 2012

SAP BO (Excelsius, Web Intelligence, Universe designer) workshop, Nov 2009

ABAP (NCG consulting group), July 2006

Academy SAP BIW 3.5 (Certified), March 2006

ASP y SQL Server (40 Hours) (Mega Training IBM, Adecco), October 2005

Macromedia Flash MX (20 Hours), February 2005

2nd Module CCNA (Cisco Networking Academy)

1st Module CCNA (Cisco Networking Academy)

Contact this candidate