Sap Bw Data Modeling

SUMMARY

** ***** ** ** ********** in systems analysis, design and development. Excellent process analysis and design with a great knowledge of Oracle databases. In that have 13 years of SAP BW/BI and with vertical experience of eight years of SAP BI Business Object Web Intelligence, Dashboards and AFO. Worked in various roles as Technical lead, Developer, Tester and Trainer.

Implemented two full life cycle implementations and nine Production Support Projects for different modules in SAP BW, running in different sectors, provided solution for their business requirements mapped in FI, SD, HR, and CO-PA using SAP NetWeaver BW, ABAP, BO and BO Mobile, involving Requirement analysis, back-end development/ Data modeling and configuration, SAP.

Excellent analytical skills and effective teamwork participation and a good development on personal work. Service attitude, knowledge capacity in tasks and adapt easily to changes.

Skills

BI development

Data Modeling

KPI Design

Data Sources

APD (Analysis Process Designer)

Process Chain

Sap BO Information Design Tool

Sap BO Universe Designer

ABAP development

Expert/Start/End Routines

Virtual Key Figures/Char.

User Exit/Text Variables

Generic DataSources

Enhancement of DataSources

Enhancement of CDS views

Reporting Tools

Bex Analyzer

Web Application Designer

Sap BO Web Intelligence

SAP BO Analysis for Office

Sap BO Dashboard

Sap BO Data Services

SAP Analytics Cloud

Work Experience

SAP BW/BO/BW4Hana Developer-Consultant

Digital On Us by Tech Mahindra - September 2021 – March 2023

Industries: Foods services, Government institution Business Areas: HR, Sales, Treasury, Accounting, Supply Chain

Client locations: New Zealand/Australia/Mexico

Activities:

Handled SAP CAS (AMS) tickets of priority 2, 3 and 4 by following standard operating procedures of SAP BW and SAP BW4Hana projects for different clients from New Zealand/Australia/Mexico.

Received Knowledge transfer from production systems (SAP BW, SAP BW4Hana, Reporting SAC, SAP BO Analysis for Office) to keep supporting them for any issue or modifications required over Data model level.

Involved in requirement analysis and intake check to identify open issues.

Analyzed, designed and developed (Modeled/customized) various SAP BW objects like Info Object, Info Source, Info Cubes and DSO Object and SAP BW4Hana/BW on Hana objects like ADSO, ODP/ODQ, Open ODS view and Composite providers for new and existing data flows. Analyzed existing Calculation views, Analytic views, Attribute views, CDS views on Eclipse/Hana Studio tool to trace and find data discrepancies.

Analyzed/modified transfer rules, update rules, transfer routines and update routines (using ABAP code).

Analyzed/modified Calculated Key figures, Restricted Key figures, Structures, Variables and User exits (ABAP coding) to enhance the reporting features.

Analyzed the existing operating concern in SAP ECC/S4Hana systems to create/enhance data sources according to reporting requirements.

Loaded/extracting transactional and master data from different source systems like, ECC and S4Hana.

Loaded data into table definitions, suspending data loads, resuming data loads.

Actively and regularly involved in Load monitoring of daily, weekly and monthly data loads (Transactional and Master data) using process chains and fixing the failures to complete loads in given time.

SAP BI BW/BO Developer-Consultant

Digital On Us - June 2018 – July 2019

Industries: Banking Business Areas: CRM

Client Locations: Mexico

Activities:

Handled SAP CAS (AMS) tickets of priority 2, 3 and 4 by following standard operating procedures.

Interacted with end users to gather Requirements.

Involved in requirement analysis and intake check to identify open issues.

Involved in creation and review of Technical Design Specifications.

Involved in preparation and test cases and test plan.

Designed and created DSO’s, Infocubes, Multicubes, BexQueries and reports and Info sources to extract data from CRM module into SAP BW.

Created/modified transfer rules, update rules, transfer routines and update routines (using ABAP code).

Created/modified Calculated Key figures, Restricted Key figures, Structures, Variables and User exits (ABAP coding) to enhance the reporting features.

Extensively worked on SAP Business Explorer tools like BexQuery Designer, Bex Analyzer.

Involved in redesign of the existing BO Dashboards and BO WebI reports.

Assisted in BO LaunchPad Administration task (promotions, user access, report scheduling)

SAP BI BW/BO Developer-Consultant

PS Consulting - October 2015 – June 2017

Industries: Foods Services, Education Business Areas: Sales, Planning, Purchase

Client Locations: Mexico/USA

Activities:

Responsible for Identifying Business Requirements from end-users.

Analyzed the existing operating concern in SAP ECC system to create/enhance data sources according to reporting requirements.

Designed and developed (Modeled/customized) various SAP BW objects like Info Object, Info Source, Info Cubes and DSO Object for new and existing data flows.

Created/modified transfer rules, update rules, transfer routines and update routines (using ABAP code).

Created Transport requests to transport the objects from Development server to Quality and Production for new/enhanced objects.

Involved in the design and creation of Star Schema in Information Design Tool with Oracle as Database.

Created/modified Calculated Key figures, Restricted Key figures, Structures, Variables and User exits (ABAP coding) to enhance the reporting features.

Responsible for analyzing and adjusting master data loading through SAP BO Data Services data flow.

Extensively worked on SAP Business Explorer tools like BexQuery Designer, Bex Analyzer. Also, on SAP BO tools such as Information Design Tool (IDT), Query Universe Designer, Web Intelligence (client and Web), Analysis for Office, Dashboard.

Designed and created BO Dashboards (Web and mobile version) using QaaWS and Query browser WebI connections.

Created Functional, Technical, and User documentation.

SAP BI BW/BO Developer-Consultant

D&C Solution Consulting - September 2012 – September 2015

Industries: Construction, Foods and Beverages Services Business Areas: Sales, Profitability, Portfolio, Planning, Transport-APO

Client Locations: Mexico/USA

Activities:

Involved in creation and review of Technical Design Specifications.

Involved in preparation and test cases and test plan.

Designed and developed (Modeled/customized) various objects like Info Object, Info Source, Info Cubes and DSO Object for new and existing data flows.

Extractor enhancements through Table/Views, Function modules (ABAP code).

Created/modified transfer rules, update rules, transfer routines and update routines (using ABAP code).

Created Transport requests to transport the objects from Development server to Quality and Production for new/enhanced objects.

Extensively worked on SAP Business Explorer tools like BexQuery Designer, Bex Analyzer. Also, on SAP BO tools such as Information Design Tool (IDT), Query Universe Designer, Web Intelligence (client and Web)

Created/modified Calculated Key figures, Restricted Key figures, Structures, Variables and User exits (ABAP coding) to enhance the reporting features.

Designed and created BO Web Intelligence views (Web and mobile version) using BexQueries as source through BICS connections.

SAP BI BW Developer-Consultant

Neoris Consulting - February 2007 – September 2012

Industries: Banking, Construction, IT, Foods and Beverages Services

Business Areas: Sales, Profitability, Finance, HR, Portfolio, Planning, Transport-APO

Clients Locations: Mexico/USA

Activities:

Created Functional, Technical, and User documentation.

Translate business requirements into an optimal BI architecture.

Created detailed data models, including mapping the flow of data from the source system.

Assigned activities to the implementation team and managed all development activities required by the BI solution.

Installed/activated business content data sources in various application components like SD, FI, HR, and CO-PA.

Created and maintained data sources at ECC source system and extracted data into Info cubes/DSO after creating Transformations, Info packages and DTP’s.

Activated Business Content Info Sources, Info Cubes, Roles, Queries, and Info Objects and customized Business Content to meet business requirements, like Commitments/Actuals and Budget in Funds Management (0PU_C02) for Funds Management and configured the extractors for Budget Total Records, Commitment Line Items, FI Line Items, and CO Line Items. Extractor enhancements through Table/Views, Function modules (ABAP code).

Created/modified transfer rules, update rules, transfer routines and update routines (using ABAP code).

Loaded master and transactional data from ECC source systems and Flat Files.

Designed and developed process chains for Master data loads and Transaction data loads.

Extensively worked on SAP Business Explorer tools like Bex Analyzer, Bex WAD

Created/modified Calculated Key figures, Restricted Key figures, Structures, Variables and User exits (ABAP coding) to enhance the reporting features.

Rolled out an SAP BW project for reporting needs on SAP FI, SD, HR and CO-PA data.

Created Transport requests to transport the objects from Development server to Quality and Production for new/enhanced objects.

Involved in preparation and test cases and test plan.

Executed the effective Knowledge transfer to production and support.

Developed analytical reports necessary to satisfy business requirements.

Created Consolidated Balance Sheet, Profit & Loss Reports, Overall Budget, Annual Budget, Commitments and Actuals as per client requirement in Funds Management using SAP BEx Query Designer.

Constructed graphical reports and dashboards, focusing on quality and functionality.

Executed maintenance tasks on data models: compression, reloading, targeted deletes, aggregates.

Created Functional, Technical, and User documentation.

Involved in preparation and test cases and test plan.

Education/Courses

Bachelor’s Degree - Universidad de Monterrey

Computer System Engineering (August 2001 – June 2006)

Certification - SAP

SAP Certified Application Associate - SAP Analytics Cloud (July 2022)

Language:

Spanish (Native)

English 90%

Contact this candidate