06/21/2024 updated
GH
100 % available
SAP BW/BI ARCHITECT
BARCELONA, Spain
Only remote
Computer science engineerASP.NETJava (Programming Language)JavaScriptPHPAgile MethodologyData AnalysisHTML5ConstructionCascading Style Sheets (CSS)Composite MaterialsInformation SystemsDatabasesData ValidationData Display DebuggersData Management
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.
Experience
Professional experience10+ years
Freelancer since2017
Languages
EnglishGoodSpanishNative speaker
Project history
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.
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.
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