SAP BW Consultant
Hanson Regan - JTI
Schlagwörter
Skills
SAP BW /BI
Databases
Technical Skills:
- Data Modeling:
- BW Modeling: Design and construction of data structures to support SAP BW 7.* data warehouse platform, InfoObjects, Advanced DSO, DSO, cubes, multi-cubes, multi-providers, composite providers, master data, use of predefined Business Content objects.
- VDM (Virtual Data Modeling): Designing and developing a well-structured CDS tree, focusing on consistent and user-friendly naming conventions for various types of CDS views (Basic, Dimension, Cube, Composite, and Consumption Views) along with their appropriate annotations. Leveraging pre-existing embedded views offered by SAP S/4HANA is prioritized to minimize the need for extensive customization. When custom views are necessary, they are tailored to align with specific user requirements while ensuring optimal performance.
- ABAP - Implement programming best practices for start, end, expert, and field routines. Optimize code for better performance and debug to resolve issues, DTP filters, function module, creation of Z programs.
- BEx Query Designer, Analyzer - Creation update and debug of queries, variables, filters, calculated key figures, data validation, RSRT debugging, Customer exit definitions and implementation, maintenance of BEx workbooks. Use of Analysis for Office for query analysis visualization, development of reports and validation, complemented with wide variety of excel knowledge, performs of same tasks as in Bex Analyzer.
- Process chain: Monitor and schedule data loads daily, weekly, and monthly. Resolve incidents due to load failures or execution issues and manage full and delta loads effectively.
- Maintenance: Organize objects, BI content, data requests, and master data. Constantly monitor data consistency and integrity and available space, and clean PSA as necessary.
- OpenHub destination, Analysis Process Designer - Use of OpenHub as a tool for report data export.
- SAP Analytics Cloud – Creation of SAC Stories, Applications, Data exploration, enhancement, and visualization
- Roles/ User Analysis Authorization- Definition of roles and analysis authorization restrictions
- HANA Studio (Eclipse Modeling Tools)– Use for management of Modeling and reporting objects, data exploration, validation, exporting and analysis.
- Management of Advanced DSO, Composite Providers, InfoObjects, ABAP Packages, Table functions, AMDP and SQL Script, CDS Views, Bex Query, calculated and restricted key figures, query filters, columns, and rows structures.
- SAP Lumira Designer-Discovery 2.2, Business Object Web Intelligence - Create web applications and components with the Lumira suite, integrate dashboards and KPIs based on data from SAP BO Universes, BEx queries.
- EWM/WM/MM: medium knowledge of functional transaction for data exploration and validations contrasting report numbers against ECC tables data, keeping in mind relationships, and cardinality.
- BOM tables and organization, FI, and SD knowledge: Understand transactions, operations, and data structures within the SAP R3 system for designing views and data extraction mechanisms towards SAP BW systems.
- Data extractors: Customize SAP predefined extractors and create user exits via CMOD, based view extractors, function modules creation, master data texts extractors, and hierarchy extractors. Manage pointers and delta queues and fill setup tables effectively.
- Transport Orders: Manage transport orders release/imports between the different SAP BW and SAP ECC systems involved in the software development landscape.
Databases
- HANA SQL Script: Write SQL sentences for data display and management effectively.
- Oracle 12g, Microsoft SQL Server, and PostgreSQL: Understand the differences between these databases and use them effectively.
- PL/SQL language: Use structuring of complex SQL queries, views, triggers, functions, stored procedures, mid-level DBA work, and queries performance optimization to improve database performance.
Technical Skills:
- Web Development: Full-stack development of web-based information systems, reporting applications, and data presentation using MVC architecture, object-oriented programming, and web security principles.
- Programming Languages: Proficient in PHP, ASP, and Java J2EE.
- Frontend Development: Experience with JavaScript, jQuery, AngularJS, HTML5, and CSS3.
- Integrated Development Environments: Familiarity with Eclipse, Netbeans, and Visual Studio Code.
- Version Control: Experience with GitHub, TFS, and SVN.
- Team Coordination: Successfully led and coordinated a team of 5-8 developers working on web development and databases.
- Software Project Management: Eventually became responsible for the Systems Administration Department.
Projekthistorie
03/2020
-
12/2022
Main development and functions:
* Design and development of Bills of Material(BOM) multivelel explosion reports,
implementing CDS views extraction, Recursive ABAP programming, OpenHub destination,
* Inventory reports fix, integration to new IBP data models, new modeling design, ABAP
programming, new Querys, calculated and restricted key figures
* Incidence resolution around Report's company environment Including ECC extractors, CDS
Views, SAP BW data sources data flow through ADSO, InfoObjects, Composite Providers, until
its final points like queries, reports, files.
* Change request development of new functionalities, gather requirements and design of ETL
data flow solutions for the client's data warehouse.
* Development's Documentation, tests and data analysis.
* Design and development of Bills of Material(BOM) multivelel explosion reports,
implementing CDS views extraction, Recursive ABAP programming, OpenHub destination,
* Inventory reports fix, integration to new IBP data models, new modeling design, ABAP
programming, new Querys, calculated and restricted key figures
* Incidence resolution around Report's company environment Including ECC extractors, CDS
Views, SAP BW data sources data flow through ADSO, InfoObjects, Composite Providers, until
its final points like queries, reports, files.
* Change request development of new functionalities, gather requirements and design of ETL
data flow solutions for the client's data warehouse.
* Development's Documentation, tests and data analysis.
01/2022
-
04/2022
SAP BW/BI Consultant
Client Solutions
Main development and functions:
* Optimization of Virtual Data Model environment of CDS views regarding to Inventory
dashboards and Global Reports.
* Implement of a staging data solution of Main CDSs to BW persistent objects for report's
response time improvement.
* Creation and update of Queries for various reports.
* Incidence resolution around Report's company environment Including ECC extractors, CDS
Views, SAP BW data sources data flow through ADSO, InfoObjects, Composite Providers, until
its final points like queries, reports, files.
* Development's Documentation, tests and data analysis.
* Optimization of Virtual Data Model environment of CDS views regarding to Inventory
dashboards and Global Reports.
* Implement of a staging data solution of Main CDSs to BW persistent objects for report's
response time improvement.
* Creation and update of Queries for various reports.
* Incidence resolution around Report's company environment Including ECC extractors, CDS
Views, SAP BW data sources data flow through ADSO, InfoObjects, Composite Providers, until
its final points like queries, reports, files.
* Development's Documentation, tests and data analysis.
05/2015
-
04/2022
Senior Programmer Analyst
Randstad Technologies
Main functions:
* Information´s extraction, transformation and loading from SAP / FI Databases, Analysis, design and
construction of accounts receivable reports
* Frontend evolutives development of, Intranet applications, reports, web services
* -Architecture and development of an application for customer´s debts query and application of
record work accidents, development of webServices, image change of frontend, export data to excel
programs
* -Maintenance of incidences management application, reports creation, statistical graphics with
Google Chart API
* -Migration of source code for Intranet Applications, Team Foundation Server 2010 to Team
Foundation 2015.
* -Agile
Tools / Technological environment: Java J2EE, Eclipse Indigo, Team Foundation Server(TFS),
AngularJS, jQuery, Bootstrap, HTML5, CSS3, Java Server Pages(JSP), Team Foundation Server 2010,
Team Foundation Server 2015, SAP R/3 Financials
Functional areas: Intranet Randstad Technologies
* Information´s extraction, transformation and loading from SAP / FI Databases, Analysis, design and
construction of accounts receivable reports
* Frontend evolutives development of, Intranet applications, reports, web services
* -Architecture and development of an application for customer´s debts query and application of
record work accidents, development of webServices, image change of frontend, export data to excel
programs
* -Maintenance of incidences management application, reports creation, statistical graphics with
Google Chart API
* -Migration of source code for Intranet Applications, Team Foundation Server 2010 to Team
Foundation 2015.
* -Agile
Tools / Technological environment: Java J2EE, Eclipse Indigo, Team Foundation Server(TFS),
AngularJS, jQuery, Bootstrap, HTML5, CSS3, Java Server Pages(JSP), Team Foundation Server 2010,
Team Foundation Server 2015, SAP R/3 Financials
Functional areas: Intranet Randstad Technologies
02/2018
-
03/2020
Multiple-project consultant
Grupo IMAN
Grupo IMAN
* Maintenance and creation of ALV report routines through ABAP of FI flow processes, process
optimization in CRM programs and data visualization.
* Architecture proposal for SLA SAP BW construction for company reports framework.
Allianz
* Workbooks Maintenance, Querys BEx adjustment, data validation of issued reports.
* Adjust ABAP programs responsible for loading data to different InfoProviders within the
system
* Optimization of data loading process routines (Transformations) within the SAP BW system for
4 main reporting infoCubes regarding to clains and financial accounting informatión.
* Documentation and test of developments on the improvements made
* Maintenance and creation of ALV report routines through ABAP of FI flow processes, process
optimization in CRM programs and data visualization.
* Architecture proposal for SLA SAP BW construction for company reports framework.
Allianz
* Workbooks Maintenance, Querys BEx adjustment, data validation of issued reports.
* Adjust ABAP programs responsible for loading data to different InfoProviders within the
system
* Optimization of data loading process routines (Transformations) within the SAP BW system for
4 main reporting infoCubes regarding to clains and financial accounting informatión.
* Documentation and test of developments on the improvements made
11/2017
-
01/2018
SAP BW Consultant
RBA (Improgether, SL)
Main functions:
* Functional and technical analysis based on customer requirements.
* Data flow design for Extraction, Transformation and Loading.
* Development documentation, test and transport, data analysis.
* ABAP extractor's code optimization / transformations, reducing data high loading times.
* Activation and customization of standard SAP SD (Sales and Distribution) module extractors:
2LIS_11_VATITM,
2LIS_11_VAHDR
(transactions: LBWQ, LBWE, OLI7BW ), setup tables filling and delta queue link management
between the source system and DW
* Customizing of FI, CO extractors :
0FI_GL_4,
0CO_OM_OPA_6
* Extractor creation for:
Master data texts,
Table-view based extractors
(transaction RSO2, CMOD)
* ABAP Development of transformations routines :
START routine,
END routine ,
EXPERT routine,
FIELD routine,
using lookups, SQL ABAP, ABAP data dictionary, optimization and code modularization
* Programs, routines and module functions development, code organization, cleaning and
separation and data structures definition, organization to make the code more clear,
maintainable and fast execution, Class creation
(transactions : se37,se38, se24), ABAP code debugging
* Daily monitoring of delta queue extractors, filling of setup tables (RSO2, RSA3, RSA5, RSA6,
RSA7, for customized extractors).
* Integration through Z tables and views of FI, CO, SD modules via CMOD and ABAP code
* Daily monitoring of data flow loading of InfoPackages and DTP, filters, data maintenance of
PSA, DSO, cubes, process chain management.
* Creation and maintenance of InfoObjects, InfoCubes, Real-time InfoCubes, DataSourceObjects
(DSO), InfoProviders.
* Query's development with BEx Query Designer, and data verification with BEx Analyzer,
* WebIntelligence Report's development.
* Creation of Real-Time InfoCUbes, Aggregation levels, Filters, Aggregation Functions, FOX
Routines, (RSPLAN), Analisys for Office
* Functional and technical analysis based on customer requirements.
* Data flow design for Extraction, Transformation and Loading.
* Development documentation, test and transport, data analysis.
* ABAP extractor's code optimization / transformations, reducing data high loading times.
* Activation and customization of standard SAP SD (Sales and Distribution) module extractors:
2LIS_11_VATITM,
2LIS_11_VAHDR
(transactions: LBWQ, LBWE, OLI7BW ), setup tables filling and delta queue link management
between the source system and DW
* Customizing of FI, CO extractors :
0FI_GL_4,
0CO_OM_OPA_6
* Extractor creation for:
Master data texts,
Table-view based extractors
(transaction RSO2, CMOD)
* ABAP Development of transformations routines :
START routine,
END routine ,
EXPERT routine,
FIELD routine,
using lookups, SQL ABAP, ABAP data dictionary, optimization and code modularization
* Programs, routines and module functions development, code organization, cleaning and
separation and data structures definition, organization to make the code more clear,
maintainable and fast execution, Class creation
(transactions : se37,se38, se24), ABAP code debugging
* Daily monitoring of delta queue extractors, filling of setup tables (RSO2, RSA3, RSA5, RSA6,
RSA7, for customized extractors).
* Integration through Z tables and views of FI, CO, SD modules via CMOD and ABAP code
* Daily monitoring of data flow loading of InfoPackages and DTP, filters, data maintenance of
PSA, DSO, cubes, process chain management.
* Creation and maintenance of InfoObjects, InfoCubes, Real-time InfoCubes, DataSourceObjects
(DSO), InfoProviders.
* Query's development with BEx Query Designer, and data verification with BEx Analyzer,
* WebIntelligence Report's development.
* Creation of Real-Time InfoCUbes, Aggregation levels, Filters, Aggregation Functions, FOX
Routines, (RSPLAN), Analisys for Office
03/2017
-
12/2017
SAP BW Consultant
Pixie Services - CaixaBank (Accenture)
Main functions:
* Requirements taking, functional and technical analysis, design of ETL data flow solutions
for the client's data warehouse.
* Creation of InfoObjects, DataSourceObjects, InfoProviders.
* Execution of InfoPackages and DTP, filters, maintenance of data of PSA, DSO, Cubes.
* Transformations development and ABAP routines programs (START, END, EXPERT routine) using
lookups, SQL ABAP, ABAP data dictionary, ABAP code debugging.
* Management of Transport Orders between BW environments (se09) (smts).
* ABAP code optimization in transformations and programs, modularization of code through the
creation of ABAP classes.
* Creation and monitoring of process chains for programming and execution of data loads.
* HANA Studio Calculation views creation.
* Query elaboration with BEx Query Designer and data test analisys with BEx Analyzer, Reports
with Webi.
* Development's Documentation, tests and data analysis.
* Requirements taking, functional and technical analysis, design of ETL data flow solutions
for the client's data warehouse.
* Creation of InfoObjects, DataSourceObjects, InfoProviders.
* Execution of InfoPackages and DTP, filters, maintenance of data of PSA, DSO, Cubes.
* Transformations development and ABAP routines programs (START, END, EXPERT routine) using
lookups, SQL ABAP, ABAP data dictionary, ABAP code debugging.
* Management of Transport Orders between BW environments (se09) (smts).
* ABAP code optimization in transformations and programs, modularization of code through the
creation of ABAP classes.
* Creation and monitoring of process chains for programming and execution of data loads.
* HANA Studio Calculation views creation.
* Query elaboration with BEx Query Designer and data test analisys with BEx Analyzer, Reports
with Webi.
* Development's Documentation, tests and data analysis.
06/2016
-
03/2017
Senior Programmer Analyst
Pixie Services - Orange España (Everis)
Main functions:
* Frontend web development of AngularJS 1.57 Typescript components, Node.js, Grunt, Karma
* Layout CSS3, HTML5, SCSS
* Unitary Tests Typescript development, Karma
* Bug fixes, documentation of activities and developed components.
* Development under AGILE, SCRUM, Management 3.0 methodologies.
* Frontend web development of AngularJS 1.57 Typescript components, Node.js, Grunt, Karma
* Layout CSS3, HTML5, SCSS
* Unitary Tests Typescript development, Karma
* Bug fixes, documentation of activities and developed components.
* Development under AGILE, SCRUM, Management 3.0 methodologies.
03/2014
-
02/2015
Analyst BI - BW
Supreme Court of Justice - National Assembly
Migration of the Judicial Statistics System for the National Assembly to SAP BW 7.0
* Definition and development of data flow loading
* Creation of InfoObjects, InfoProviders / MultiProviders, transformations
* ABAP development (start / end / expert routine)
* Creation and maintenance of process chains
* Monitoring of data loads
* Design and creation of BEx queries
* Creation and Maintenance of Universes, Creation of Reports, Graphics, Drill down Reports
with Sap Business Object Web Intelligence and Crystal Reports
Tools / Technological environment: SAP BW 7.0, SAP Business Object 4, SAP R3, BEX, ABAP.
* Definition and development of data flow loading
* Creation of InfoObjects, InfoProviders / MultiProviders, transformations
* ABAP development (start / end / expert routine)
* Creation and maintenance of process chains
* Monitoring of data loads
* Design and creation of BEx queries
* Creation and Maintenance of Universes, Creation of Reports, Graphics, Drill down Reports
with Sap Business Object Web Intelligence and Crystal Reports
Tools / Technological environment: SAP BW 7.0, SAP Business Object 4, SAP R3, BEX, ABAP.
Zertifikate
Reisebereitschaft
Nur Remote verfügbar
