Sap Data
Resume:
Gboyega Aboderin
Sugar Land, Texas
*********@*****.***
Profile
•Senior Consultant with over 20 years of overall IT experience, 10 + years in SAP BW, SAP BusinessObjects BI tools 7 years,4+ years of SAP HANA and 1+ year of SAP S/4HANA (1511,1610,1711,1809,1909,)
•Deep knowledge of SAP BW on HANA and BusinessObjects Architecture with the ability to design develop and implement Data Warehouse and Business Analytics solutions to support complex business requirements.
•Thorough understanding of the BusinessObjects Integration with SAP BW, SAP HANA, SAP S/4HANA ABAP CDS Views.
•Hands on experience working with SAP BusinessObjects BI tools and BI platform 4.x, WEBI, IDT, Analysis for office, Lumira, SAP Fiori.
•Hands on experience implementing SAP HANA Native Information Models, S/4HANA and HANA database architecture
•Hands on experience designing CDS Views using ABAP Scripting Editor used by S/4HANA Analytics & BOBJ BI tools
•Hands on experience designing Backend Data models in Embedded BW, ODP used by S/4 Analytics & BOBJ BI tools
•Hands on experience writing SQL, SQL Script for SAP HANA.
•Hands on experience working with SAP HANA XS (classic) and XSA (advanced).
•Hands on experience developing SAP HANA XS/XSA APIs(XSJS), OData, CDS views, extensive knowledge of the embedded http server configuration and server side java scripting methods.
•Hands on experience developing all SAP HANA information models (Attribute, Analytic, Calculation Views, Tables (Row & Column), Packages, Schemas, Stored Procedures, Views, Analytical Privileges etc. Involved in 5 SAP HANA native deployments
• Hands on experience with SAP BW modelling with respect to SAP HANA using composite providers, Advance DSOs, ODP, LSA ++ and using BW objects exposed as HANA views
•Experience implementing Project Implementation Methodologies, such as ASAP, Solution
Manager and the use of Best Practices
•Excellent client-facing skills and a strong team player with leadership qualities
•Strong analytical, problem solving and quantitative skills as well as excellent trouble-shooting skills.
Technical
Heavy hands on work experience in the SAP HANA, thorough understanding of the HANA concept and its role in delivering solutions to business and in the SAP landscape.
Expert in HANA modeling using the HANA Studio and HANA web IDE to create information models, Attribute, Analytical and Calculated Views, stored procedures, XSJS, ODATA CDS views.
Hands on experience designing CDS Views using ABAP perspective in HANA studio and in the backend system (SAP S/4HANA) to create basic interface, composite and/or consumer views for Analytic Solutions.
experience working on HANA Enterprise - Modelling including Attribute Views, Analytical Views, Calculation Views, SQL scripting, Analytical Privileges
experience in Data Modeling, Data Provisioning, Reporting, Security and Authorization aspects of SAP HANA.
Experience in ETLs – SAP BODS, SLT
Experience in HANA XSJS APIs and HANA SQL scripting
Experience in SAP HANA architecture, optimization techniques, delivery units (transports), CTS+, Hana Native transport, Hana security, SQL Scripting and administration.
Team Player, excellent communication and interpersonal skills
Self-driven, proven ability to work independently and strong Analytical skills
Experience in providing advanced technology advisory services.
Understanding of market and technology trends.
Expert in creating schema, packages, tables, views, attribute, analytical & calculation views, analytical privileges, joins in SAP HANA
Extensive knowledge and hands on using SAP Hana data provisioning tools:(SAP BO Data Services, SAP LT Replication Server (SLT), Hana Smart Data Access (SDA), Hana Smart Data Integration (SDI)
Expert in backend configuration: BW 7.x & 3.x Data Sources, Transformations & Transfer and Update Rules, DTPs, InfoCubes, MultiProviders, DSOs, Real Time Cubes, InfoSources, Process Chains, generic DataSources and 7.x & 3.x ETL Design
Expert in SAP BusinessObjects Web Intelligence on the BI 4.x platform including Information Design Tool (IDT) as well as the Universe Design Tool (UDT)
Expert in development, Training super users/SMEs in the features and workings SAP BI tools such as IDT, UDT, Webi, Analysis for office/OLAP, Lumira.
Hands on Experience with SQL Queries for RDBMS
Hands on Experience in ABAP programming skills for Transformations and User Exits
Hands on Experience in LSA++ methodology for BW on HANA architectural solutions
Extensive knowledge of SAP ECC data dictionary and common SAP tables
Hands on Experience working in various SAP ECC process areas including exposure to developing business intelligence solutions for FICO, MM, PP, SD, COPA etc.
Career History
Terasys Inc. (Clients –Murphy Oil and Exploration Company, Houston, TX, AT&T,Plano,TX)
March 2018 –
SAP BW/HANA, SAP S/4HANA Developer.
Lead requirement gathering activities, design solution approach, conducting SAP HANA hands on proof-of-concept development work, design solutions in SAP Cloud Platform, SAP BW & Hana,SAP S/4HANA, modeling, Administration, hands on development of information models, CDS views etc.
Solutions:
SAP Native HANA Deployment
SAP BW on HANA
SAP HANA XSA deployment
SAP S/4HANA
SAP Cloud Platform
RESTAPI/OData
SDI/SDA
Integrating various systems on premise to SAP Cloud Platform using SCC –SAP Cloud Connector.
Web and Mobile Apps – Fiori
Terasys Inc. (client Salt River Project, Phoenix, Arizona)
Dec 2017 – Feb 2018
SAP BW/HANA Developer/Training Consultant.
Conducting SAP HANA hands on training for various technical group of a regional utility provider. The company had just implemented SAP HANA 2.0 sp2, and upgraded/migrated to SAP BW 7.5 on HANA DB. Theme of the training was to expose the teams to the features and opportunities of the SAP HANA, identify all possible optimization areas in SAP BW using the LSA++ method, educate the SAP Basis team on SAP HANA installation and administration processes. The training sessions were heavily hands on.
Groups trained
BI team – SAP and non-SAP
SAP Basis team
SAP BW/BI team
Courses
SAP HA100 - SAP HANA 2.0 Introduction
SAP HA200 - SAP HANA 2.0 Installation and Operations
SAP BW362 - SAP BW Powered by SAP HANA
IBM NY
August 2016 – Nov 2017
I worked as a professional consultant on various engagements, on SAP BW on HANA, SAP HANA, SAP S/4HANA migration, onsite lead developer for clients, responsible for development, client facing and managing offshore resources
As a SAP HANA/BW/BI lead developer working onsite and also managing offshore developers to enhance project deliverables.
I worked with SAP frontend BI tools, development work and training of SMEs and super users on the SAP BI tools including SAP Lumira tool.
Infosys Ltd, Houston, Texas.
February 2016 to August 2016
SUMMARY: Acted as a Lead SAP HANA Architect, responsible for hands on development work and the management of on shore and off shore SAP HANA developers, also for quality and delivery of technology business solutions leveraging the SAP HANA suite, backend and XS application – APIs XSJS and OData. Design, develop, test, and support SAP HANA components needed to support the client requirement. I lead SAP HANA internal and external developers both onshore and offshore.
DUTIES AND RESPONSIBILITIES:
Worked with the Infosys SME and client SME business process teams and other IT teams to implement SAP HANA based procurement and Analytics solutions using SAP HANA DB as the backend and SAP HANA XS Application as the API layer.
Worked on S/4HANA migration projects, finance & logistics,
Keurig Inc., Burlington. Vermont.
November 2014 – February 2016
SUMMARY: I was the Lead SAP HANA/BW/BI Architect/developer, reporting directly to the senior BI director, was responsible for providing strategy, expertise and implementing SAP BI solutions, using various SAP tools, SAP BW on HANA, SAP HANA enterprise sidecar, SAP BO-BI platform & tools, also responsible for the quality and delivery solutions, develop, test, and support SAP BW/HANA/BO-BI components needed to support Enterprise BI Analytics. I lead other resources SAP BW/BO/HANA internal and external developers both onshore and offshore. I introduced SAP Lumira interactive tools to the organization as a tool that allows the SAP HANA/BI development team to work closely with the SMEs, I trained the power users and SMEs on the features and usage of the SAP Lumira tool, this allowed the functional folks to identify the datasets that are critical to their operations and the backend SAP HANA and BW team were able to work hand in hand with the business team. SAP Lumira allowed high level visibility to the critical datasets needed by the demand planning, financial analysts and the sales team.
DUTIES AND RESPONSIBILITIES:
Worked hand in hand with business process teams and other IT teams to implement SAP BW on HANA, HANA sidecar, based BI and Analytics solutions using SAP ECC 6.0 as the backend ERP system.
Worked closely with senior BI director to set overall enterprise BI strategy, Analyzing business goals, rules, and processes across various information systems tools and technologies.
Develop functional and technical specifications from business requirements for the development of SAP BW objects such as extractors, infoobjects, infosources, infocubes, transformations, process chains etc.
Recommended and implemented upgrade and migration solutions for SAP BW 7.3 to 7.4 on HANA, SAP BODS from 4.1 to 4.2 and SAP BO-BI from 4.0 to 4.1, SAP HANA SPS 9,SAP SLT SAP and HANA Live for operational analytics .
Heavy hands on experience in the SAP BW on HANA pre and post migration activities using DMO tools
Developed solutions using SAP BW/HANA/BO-BI, utilized standard content, enhanced existing standard objects, and created custom objects using the SAP BW toolset
Developed SAP HANA Information models to deliver COPA solutions, FI AR&AP & MM – Purchasing solutions.
Implemented SAP HANA Live to deliver multiple SAP LoB solutions to enable real time analytics.
Architected solutions from a technical standpoint to make sure that we build the right reporting solutions for business needs
Enforce and ensure reporting SLA's are being met on a consistent basis
Review development objects in SAP BW / BO / HANA/HANA Live standards.
Support integration between SAP Business Objects, HANA sidecar and SAP BW on HANA
Develop and maintain documents detailing requirements, design, implementation, and maintenance of our information systems tools and technology
Perform production support activities, including managing changes within the production environment, problem resolution, reporting modifications, and performance tuning
SAP America Inc,
Senior Consultant – Business Analytics Services group.
SAP BW/HANA/BusinessObjects BI Developer
August 2010 – July 2014
I was a member of the SAP America professional Services group, during the period of 4 years; was deployed to deliver solutions to various clients in diverse industry sectors, in some cases as the only SAP consultant on site representing SAP America and in some cases as a member of the SAP engagement consulting team.
Experiences/Project Works
Experience with HANA modeling using the HANA Studio to create Attribute, Analytical and Calculated Views
Experience in Data Provisioning in HANA
Experience with SQL Queries for RDBMS
Proficient in ABAP programming skills for Transformations and User Exits
Proficient with SAP BusinessObjects Data Services ETL tools
Proficient with Crystal Reports and Xcelsius
Experienced in LSA++ methodology for BW on HANA architectural solutions
Excellent on SAP BW on HANA pre and post migration optimization activities
Good knowledge on LSA++ modeling for BW on HANA
In depth knowledge on SAP HANA Cloud Strategy Roadmap, HEC, Hybrid Solutions.
Hands on experience working with SAP HANA on premise/on cloud solution using SAP HANA HCI.and SuccessFactors BizX suite
Hands on experience using SAP HANA studio and SP HANA web IDE to design information models
Hands on experience creating schema, packages, tables,views,attribute,analytical & calculative views, analytical privileges,joins in SAP HANA
Gabod Consulting Group LLC contractor to Owens Corning, Toledo, OH.
SAP BW/BusinessObjects Developer
September 2009 – August 2010
Scope of Work (Detail of duties and tasks) and environment (Reporting & Analytics) SAP NW BW 7.0 BEx, SAP BusinessObjects XI 3.1, SAP BusinessObjects Integration Kit 3.1, Infoview and WEBI 3.1
Responsible for interacting with Business users for gathering reporting requirements and preparing technical specifications for several reports in, FI- AP,AR, COPA,INV,CCA.
Worked with BEx Query Designer and OLAP Universe Designer, to create WEBI reports.
Generated Xcelsius dashboards out of SAP BW data where the data is in the form of BEx Queries.
Created OLAP Universes on BEx Queries and using them in Query As A Web Service (QAAWS) for data loading into Xcelsius.
Worked with Query Designer to create various query elements such as Restricted Key Figures, Calculated Key Figures, Conditions, Exceptions, and Variables.
Create and design documents (technical and functional) for BEx Queries, Universe, Webi & Xcelcius reports.
Build and design BEx Queries, Universe, Webi & Xcelcius reports from technical designs.
Responsible for Designing and building Universes over existing SAP BW systems.
Created Documents for all design build activities.
Conducts Testing - Unit, and participates in Functional, Integration, User Acceptance)
Designing reporting templates with BEx Analyzer and Web Analyzer; Using key figures, features, hierarchies, variables, properties, exceptions. and conditions in the query definition; Integrating SAP BusinessObjects with SAP BW datasources
Responsible for Universe Design with SAP BW Data Sources and BEX Queries
Responsible for Creating WEBI query and documents
Worked with power users to adapt WEBI features and functionalities to the over all global user community.
Environment: SAP NW 2004s, SAP EP. 6.0, SAP BusinessObjects 3.1, HP QC 10,
Gabod Consulting Group LLC contractor to Applied Materials Inc. Santa Clara, California—October 2008 – December 2008
SAP BI Trainer.
I worked for AGU (Applied Global University) the internal training division responsible for learning and development for Applied Materials Inc employees globally. I worked as an instructor responsible for conducting SAP BI Intermediate and Advance training for users. This training is focused on the front-end tools for SAP BI (SAP BEx and SAP Portal
The SAP BI Advanced class was for power users and SAP BI Intermediate class was for others.
The training Classes conducted was focused on the following course objectives:
Describe BI concepts and reporting tools.
Understand the Data Flow concepts within BI
Access the BI Portal and run reports using BEx Web Analyzer and BEx Analyzer using all functionality in these components
Use the Query Designer to create Queries and Reports
Configure and Implement the use of Characteristic Properties, Variables, and Hierarchies
Configure and Implement the use of Key Figure Properties, Restricted Key Figures, Calculated Key Figures
Understand the functionality of the Cell Editor and Exception Aggregation
Configure the functionality of BI Exceptions and Conditions
Configure and Implement the use of Documentation in a BI report
Create the Report to Report Interface component of BI
Understand the BEx Analyzer Workbook
Configure the Functionality the BEx Analyzer Workbook
Environment: SAP NW 2004s, SAP EP. 6.0
July 2007 – September 2008
Lorillard Inc. Greensboro, – North Carolina, USA.
Senior SAP BW/BI Developer
Scope: To provide and implement SAP BW strategy for Sales and Financial analysis.
Responsibilities Include creation, development and support of:
Infocubes: Customer 0SD_C01, Delivery 0SD_C02, Sales overview 0SD_C03, Delivery Service 0SD_C04, Quotations and orders 0SD_C05,Custom Cubes, FI-AR Accounts Receivable, FI-AR Line Items, FI-AP Accounts Payable, FI-AP line items and Summary values,0FIGL_VC1 (general ledger: financial statements),0FI_GL_1 general ledger: transaction figures,0FI_GL_2 transaction figures –cost of sales.
ODS: 0FIGL_O10: general ledger: transaction figures.
Datasources:2LIS_11_VAITM,2LIS_11VAHDR,2LIS_11_V_ITM,2LIS_12_VCITM,2LIS_12_VCHDR,2LIS_13_VDITM,2LIS_13_VDHDR
Extractions: Extracted Logistics data from SD using both LIS and LO Cockpit. Extracted data for financial analysis.
Customizations: Created InfoObjects and datasources to enable data extraction from legacy systems, modified sap BC to conform to the business requirement.
Modeling: Created InfoCubes, InfoSources, DataSources and InfoObjects, Update, Transfer and Transformation rules to enable Data Loading (initial / Delta Up-load), Scheduling and Monitoring.
Reporting (BEx):Worked Extensively in BEx Analyzer (Query Designer) in building Queries, saving it in Workbooks (Excel workbookCreated Standard/ Custom queries using Bex Query Designer and WAD, created Calculated Key Figures, Restricted Key Figures, Structures, Variables, Exceptions, Conditions.
SAP BW Security: Developed and maintained authorization objects.
Created and maintained security for all SAP BW authorizations, profiles and roles.
Collaborated with other team members as necessary to translate business requirements into BW Security roles.
Environment: SAP Netweaver 2004 & 2004s, BOE XI 2, SAP ECC 6.0, AIX, DB2, MS SQL, ORACLE.
EDUCATION
BS Computer Science
SAP Certifications
SAP Certified Associate - BW & SAP BI 4.0
SAP Certified Associate - HANA
Contact this candidate