Sap BW Hana Management
Resume:
T i a g o M o t a
SAP Consultant
S/* HANA / BW / BI / BO / ABAP
(UK) :
E-mail :
Address :
****.*****@*****.***
London
United Kingdom
PROFILE
As a SAP consultant with 10+ years of experience, I have in-depth knowledge and skills within the IT, retail, energy & utilities and wholesale foods organisations, and have worked as a Project Management on a number of Information projects. This has strengthened my leadership, strategy and management skills, as well as my business acumen. I thrive on constant challenges, work well within a team or independently and have enthusiasm for new technologies. Highly mobile, willing to relocate or travel extensively to fulfil corporate objectives.
KEY SKILLS
Experienced in various stages of the project from blueprint all the way to post go-live support
Technical / Functional expertise in S/4 HANA Embedded / BW 7.x and 3.5 / BI / BO / SQL / ABAP
Analytical and problem-solving skills
In-depth knowledge of implementing complex systems in multinational organisations
Experience in Netweaver, HANA, ERP, SD, CS, MM, Accounts Payable, FICO, FI-CA, CAR, IS-H
Strong communications skills
Delivery focused and able to motivate teams
Capable of selling the benefits of projects to their target audiences
International implementation projects
Performed project presentations, timeline determination, communicative and scope management
Data migration
Creation of calculated, attributes and analytical views on HANA, to be populated and used on latest version of SAP S/4 HANA 2 SP5
WORK EXPERIENCE
Oct 2018 -
Current
S/4 HANA / BI / AFO / SAC / ABAP, Kering Italy
SAP BI Management / Developer for an international luxury goods brands, including Gucci, Alexander McQueen, Bottega Veneta, Yves Saint Laurent, Brioni, and few others. Involved in creating test scenarios for various retail areas (POS, IM, PO) on a new S/4 HANA 2.0 system
Involved in various roll-out activities in 30+ countries world-wide, ensuring successful implementation and adoption across S/4HANA Embedded Analytics
Played a key role in the move to cloud project, ensuring quality, performance, and minimal disruption during the migration process
Managed the support team on a daily basis, overseeing their activities and ensuring prompt resolution of issues and tickets.
Conducted meetings with stakeholders, technical teams, and business users to gather requirements, discuss project progress, and address concerns in an efficient manner.
Designed, built, and monitored process chain on BW side as well as the scheduling tool with seamless integration of ERP jobs. Optimising data processing and improving efficiency.
Monitored data quality and reconciliation within different BW systems using AFO (Analysis for Office) reports designed and built on top of HANA, BW, and other systems.
Successfully managed transport management activities, ensuring smooth and reliable deployment of changes across various environments directly within SAP or using SAP Solution Manager tool.
Proactively handled incidents, service requests, and tickets, collaborating with SAP Support to resolve issues and maintain system stability, ensuring timely resolution of issues
Designed and implemented testing scenarios for data validation in complex queries, ensuring robust validation and checks throughout the project stages.
Used specific company’s POS (Point-Of-Sales) implementation, testing and integration with the Billing flow
Implementation and testing of CDS Views for the extraction of data from CAR to BW for POS and Prices
Developed Queries and AFO Reports (and more recently SAC) in either Embedded or Enterprise Analytics for effective data analysis and reporting
Built SAC dashboards and reports on enterprise analytics, providing valuable insights for decision-making and business intelligence
Hands-on in SD, MM, ERP, CAR, CS SAP Modules
Documentation creation/update on design, testing, activities and demonstrations to stakeholders and internal team information using various Office tools including Office 360 sharepoint, JIRA
Oct 2017 – Aug 2018
SAP BI-HANA / BI / BO / ABAP, Accenture United Kingdom
End-client: Johnson Matthey
SAP HANA BI/BO Consultant for a British multinational speciality chemicals and precious metals. Responsible to accommodate into BW7.5, RTR, PTP, OTC and PTM areas and its Reporting solution.
Design and implement a solution to bring into BW HANA 7.5 system on a greenfield SAP project life cycle
SAP BW flow built using LSA++ and optimised to take full BW HANA process whenever possible
Responsible for designing, development and testing of InfoObjects, DSOs, Composite Providers, Transformations and other components i.e. ABAP-OO, BADI, User exists and FMs
Working closely with the business and functional resources in different areas in order to design, and meet the requirements for functional and technical specs
Responsible for designing and building BEx Queries in HANA using BW 7.5 SAP standard guides
Designing and building several complex WEBI reports within all areas and using multiple queries
Complex user authorisation and role implementation on BI and BO for multiple user groups
Involved in the designing of the process chain and monitoring Post go-live so that it’s processed end-to-end within SLA
Responsible for the ST and IST and its related documentation
Monitoring Incidents, Defects and CRs; managed and prioritised tasks in a timely manner during System Test and Hypercare phases
Coordinating tasks within onsite and offshore team
Mar 2017 – Oct 2017
SAP BW-HANA / BI / BO / ABAP, Brake Bros Ltd (Brakes) United Kingdom
SAP HANA BW Consultant for one of Europe’s leading foodservice providers and a market leader in UK foodservice. Responsible to accommodate into BW7.4 the Vistex solution.
Responsibilities:
Design and implement solution to bring Vistex Chargebacks and Sales Rebate Agreements data into BW HANA 7.4 system
SAP BW flow built using LSA++ and optimised to take full BW HANA process whenever possible
Responsible for development of InfoObjects, DSOs, Composite Providers, Transformations and other components related to the project
Implement the BW3.5 Price Review System (PRS) logic into BW 7.4 using SAP standard guides
Migrating BW 3.5 BEx Queries into a re-designed, efficient and optimised business solution to the new BW 7.4
Designing and building WEBI, A4O and OLAP reports
Responsible for the UT, UAT and IST and its related documentation
Managed and prioritised tasks and defects in a timely manner
Mar 2014 – Dec 2016
SAP BW-HANA / BI / ABAP, Marks and Spencer (M&S) United Kingdom
Lead BW developer for a major British and multinational retailer that specialises in selling clothes, luxury foods and home products. Involved in creation of the General and Merchandise reporting using SAP BW powered by SAP HANA and connectivity with, legacy system, JDA via DataStage and BOBJ. Exceptional methodologies to deliver the finest solution.
Responsibilities:
Responsible for development of Extraction programs, Programs and FM based on SAP module SD
Code review and improve process using the standard SAP performance guides
Design and development of BEx queries based on Composite Providers and MultiProviders
Performed data modelling and developed analytical views for the transactional data in HANA
Created attribute view, analytic View and calculation view based on Data foundation and join including the refining of output structure based on project and business requirements on HANA Studio
Developing SQL Script for BW Transformations and HANA Calculation View
Managed and prioritised SAP defects including debugging and fixing of complex problems in a timely manner
SAP POS Analytics (SAP BI) content activation
Article and Site scrapping in SAP POS DM (Point of Sales Data Management) and ECC
Investigated SAP's Retail product and store and estimated effort required to configure and develop the interface across all the stores
Working on NLS split solutions to save HANA memory space
Working on POC’s for Sales business units using SAP HANA by following best practices and optimised data models in MS Excel and Business Objects Explorer
Designing and implementing solution to bring plan data from legacy JDA system into BW and to extract to JDA
Resolving and developing solution to calculate daily status of the product life cycle within all stores across the company
Proactively managed projects stakeholder satisfaction to secure customer satisfaction
Support the SIT & UAT phases working on all defects & approved CRs for the HPS SAP Platform FI area to ensure quality exit on target
Design, configuration, daily jobs control
Integrated BOBJ 4.0 and DataStage with SAP HANA SPS12
Creation flat-files in BW via openHub and HANA SQL to be extracted via 3rd party supply chain tool
Migrated HANA content from development, testing environment to Production environment using delivery units
Analysing reports and improve its performance
SAP BW landscape has been completely re-build and optimised with an EDW / LSA++ layered structure, ABAP-OO, user exists and performance optimisation has been considered
Overall responsibility for the Macro Space and Plan Data
Planning and collaboration with resources within various teams
Established the best modelling and recommended strategies for BOBJ environment and architecture for SAP HANA
Implementing the new ABAP standards to improve performance on BW powered by HANA
Created Technical specifications for Business and standard modelling documents for HANA
Mar 2013 – Feb 2014
SAP BW / BI / ABAP / BO Senior Consultant, Hewlett-Packard (HP) Galway, Ireland
Project Managing and SAP BW for a leading IT company that has +1m SAP instances and where HP Servers run nearly 50% of all global SAP-based installations. Involved in various productions tasks and currently managing a worldwide project. Excellent time skills and quality assurance methodologies. Due to my commitment at HP I have received various rewards.
Responsibilities:
Daily monitoring BW production boxes to ensure no SLA is missed
Proactively managed projects stakeholder satisfaction to secure customer satisfaction
SME on Warranty Portfolio for EMEA
SAP BOXI 4 WebI report design and integration with current system SAP BW 7.3
Analysing reports and improve its performance
Responsible for development of Extraction programs, Programs and FM based on SAP modules SD / MM / CS / LO
Overall responsibility for a Customer Differentiation reporting solution
Planning and collaboration with resources around the world (APJ, EMEA and Americas)
Design, configuration, ETL and maintenance SI Trackers and Incident Managements
Determine which tasks/steps to automate (by identifying scope and requirements)
Support the SIT & UAT phases working on all defects & approved CRs for the HPS SAP Platform FI area to ensure exit on target
Mar 2009 – Mar 2013
SAP BW / BI / ABAP / BO (Team/Dev lead), Centrica (British Gas) London, UK
Project Managing and SAP BW for a utility (Gas and Electricity) company that have more 16 millions of customers. Involved in various life cycle SAP projects and currently managing a large scalable, high risk, strategic project. Strong customer and quality assurance methodologies
Responsibilities:
Responsible for development of Extraction programs, Programs and FM for SAP
Project Managing a Sales Based reporting solution, based on SAP CRM and IS-U as well as integrating several 3rd party software into a BI (7.0) & BO solution (BOXI4)
Configuration, maintenance and design of BW extractors, InfoObjects, InfoSources, update rules, transfer rules, InfoProviders, and OLAP queries
Design and development of BEx queries and the integration of BO reports by creating the universe connection types
Providing technical analysis, expertise and solutions on system issues and performance tuning
Design, code, and test various ABAP user exits in BW for extraction, jump queries, variables, and OLAP virtual characteristics and key figures
Planning work for all team members and resourcing on and off-shore resources
Managing both on-shore/off-shore resources (team size 4-9) in delivering several internal projects
Overall responsibility for the architecture and design solution
Full life-cycle of the implementations, from requirement gathering, development, testing and successful implementation and go-live of the projects
Ramp-up liaison and product BU
At Data Staging process responsible for BAPIs to extract data to BW from SAP/Non-SAP systems and design of DSOs, Cubes and MultiProviders using LSA architecture.
HANA integration with current project
Participated in a proof of concept with HANA
Implementing the new ABAP standards to improve performance on BW powered by HANA.
Aug 2008 – Feb 2009
SAP BW / ABAP Consultant
Client: Siemens SA/NV Belgium
End-Client: Touring, Brussels
SAP Consultant for an international automotive company on migration SAP ECC 5.0 to 6.0 and to use the new General Ledger Accounting (FI-GL). Worked on a team of 3, technical responsible for the development of the data conversion and migration. Functional responsibilities included the configuration and implementation of the new FI-GL, preparation of pre and post go-live strategy documents, BBP Documents, Training Materials for End Client, Feasibility Checks, Validations and Assignments.
Responsibilities:
Technical planning of data migration and Unicode conversion
InfoCube data modelling, design and query development
Provide functional and technical support to the FI department in several SAP modules: FI / CO / AA / GL / AR / AP / MM
Responsible for development of Extraction Reports, Master Data Migration
Providing technical analysis, expertise and solutions on system issues
Developing and testing programs to technical specifications
Maintenance in SAP FI CO and CO-PA modules (Cost Centre, Profit Centre, Vendor, Customer, Profitability Analysis)
Business analyst, understanding the requirements and converting them into both functional and technical documents for development.
Write functional and technical documentation
Techno-functional SAP ABAP experience
End-Client: RKW / ONAFTS, Brussels
SAP Consultant for a health care institution on migration SAP ECC 4.7 to 6.0. Responsible for its data migration procedures, end-client and technical documentation. Provided delivery management ensuring customer approval.
Responsibilities:
Proactively managed systems development, implementation and end user actions from legacy system
Development of programs with Unicode conversion
SAP HR Infotypes
Translated requirements into functional and technical specifications
Feb 2006 – Feb 2008
SAP Consultant, Logica Portugal
End-Client: EDP (Portugal Electricity), Porto - 6 million clients
Client responsibilities included supporting project activities, resource planning and managing project issues. Responsible for consultant training, functionality presentations and documentations. Developed interface requirements and performed system testing. Supported business requirements and developed new billing design. Involved in 3 full life-cycle SAP projects.
Responsibilities:
Involved in writing and reviewing functional specifications for new and existing projects
Go-live and support responsibilities
Creating uploads, reports, SAP scripts in FI/CA Module
Responsible for development of Master Data Migration, Extraction Reports, SAP Scripts for FI/CA Customisation
Analysed risks, established contingency plans and responsible for initialising mitigation action
Proactively managed projects stakeholder satisfaction to secure customer satisfaction
Analysed lessons learned and share information with the organisation
Achieving acceptance and sign-off in time
Providing technical analysis, expertise and solutions on system issues
Developing and testing programs to technical specifications
Subject to provide technical analysis, expertise and decisions on system issues
Synchronise existing data using migration programs and Batch Input
Responsible for developing Data Conversion programs for Data Migration
April 2000 – July 2002
Webmaster and Computer Assembler, APIE Portugal
System Environment
RedHat 7.1 / 7.2, Mandrake Linux 7.2, Windows NT / XP
Applications
LAMP (Linux, Apache, MySQL 4, PHP 4/5), HTML 4, XHTML 1.1, CSS 2, Flash MX, CorelDraw 11, Photoshop 6/7
Planned, designed, created, launched and managed corporate websites for its end-clients. Strong emphasis on user-centred design, usability standards and human factors testing.
Responsibilities:
Designing and presenting different templates to the user on different budgets
Website templates using the latest technologies and customised scenarios for each user
Graphic production, web design and maintenance
Design and maintenance of tables using latest version of MySQL in an Apache server
Installation and configuration of different OS for web servers
Network and client support
Training and presentation to end-clients
End-user and internal documentation
EDUCATION
2002 – 2005
University of Essex, United Kingdom
BEng (Hons) Internet Engineering
Modules included: Programming with Java, Information Systems (SQL), Mathematics for Digital Networking, Web Application Programming (XML, HTML, JSP, ASP), Professional Development Studies, Data Communications, Software Engineering, Computer Networks with Networks Project, Advanced Object Oriented Programming, Computer and Communication Networks (LAN, WAN, TCP /IP, virtual circuits, ATM networks).
PROFESSIONAL DEVELOPMENT
SAP Modules
SAP NetWeaver - ABAP Programming with ABAP objects
SAP FIORI S/4 HANA
Modules include: BC095, BC400, BC401, BC405, BC410, BC415, BC420, BC430, BC460,
BC470, BC630, and HR350, BW340.
Certified ScrumMaster and SAP BusinessObjects
I.T. Skills
Extensive knowledge and competency in the following areas:
Operating systems: Windows XP / NT, Linux, Macintosh
S/4 HANA (5+ years)
SAP BI/BW and ABAP (10+ years)
SAP BO (7+ years)
Database Management Systems (RDMS): SQL (10+ years), MySQL 3/5 (5+ years)
Scripting Languages: PHP 3-5 (10+ yr), JavaScript 1.3/1.8 (10+ yr), AJAX (2 yr), VBScript (2 yr)
Markup Languages: HTML 4/5 (15+ years), XHTML 1.0 (9+ years), XML (4+ years)
Stylesheet Language: CSS 2 (8+ years)
Web Authoring software: Macromedia Flash MX (5 years), Dreamweaver (4 years)
Graphics: Corel Draw (10+ years), PhotoShop (4+ years)
MS. Office Apps: Word, Excel, Access, Outlook, PowerPoint
Languages
Native: Portuguese
Fluent: English
Proficient: Spanish
Basic: Italian, French
Contact this candidate