Gustavo Reguilón

- Administration and monitoring of BW - Performance expert: * BW database. Modeling * Reporting. Improve the analysis of the reports * Data Extraction. Improved administration and data load times to BW - Business Analysis consulting - SAP Best Practices - On Site and Remote services

MER 2013 Project: BW Improvements for SAP CRM models. BW Architecture concept LSA (Layered Scalable Architecture). Bex Queries construction to connect with Business Object.

BW – Project: BBP development for SAP BW implementation for finance models (FI and CO), Sales (SD), Purchase and Stocks (MM) and Planning (IP Models). Sources from SAP ECC, Teradata and Hyperion (historical data).

Integra Project: Enhancements Payment Engine data sources and models.

Technical Upgrade from version BW 7.0 to BW 7.3 and architecture remodeling with LSA concept (Layered Scalable Architecture). Reimplemented in BW modules: Master Data, FI, CO, SD, MM, PP, PM, QM and PS

Project MAP - IP: MAP-IP solution implementation (Merchandise and Assortment Planning), retraction data to SAP ECC, IP (Integrated Planning) Purchase budget and sales logistics datasources (2LIS_13_VDITM), Purchasing (2LIS_02_SCL), Stock (2LIS_03_BX , and 2LIS_03_UM 2LIS_03_BF) and Finance (GL, AP and AR). Layered architecture BW – LSA. Construction of cross modeling FI-AP, Budget and Procurement (with different temporary displays).

Project Vector: Re-init and restructuring of data loss caused by pointers deltas. Relevant datasources: Material Movements (2LIS_03_BF), Sales billing items and Conditions (2LIS_13_VDITM, 2LIS_13_VDKON and custom datasource), Transport LE (2LIS_08_TRLP), Purchase orders items and receipts Schedule Line (2LIS_02_ITM and 2LIS_02_SCL), Delivery items (2LIS_12_VCITM), Finance - Receivables (0FI_AR_4 and 0FI_AR_9). Verification, adjustment and commissioning of the affected models.

BI project - HCM: Implementation of HR Management Organization (PAOS) Personnel (PAPA) and Payroll (PY) models. Activating Business Content, setup and automation of data load and functional adjustments of models and reports. Creating a specific model for HR planning load from flat files, and in the future should serve to re-using the standard sub-module SAP HR - PCP (PACP).

Project GPA-ACR: Business Blueprint development. Datasources, data marts and specific models of GPA in SAP BW, and retraction of data to SAP ECC with BW functionality. The relevant datasources are: Sales orders item and conditions (2LIS_11_VAITM and 2LIS_11_VAKON) Delivery items (2LIS_12_VCITM), Sales billing items and conditions (2LIS_13_VDITM and 2LIS_13_VDKON) Purchase Order items (2LIS_02_ITM), Verification of purchase invoices (2LIS_06_INV), and purchase conditions orders (by custom Extractor)

Project BI - FI: Creating a custom ABM Vendors model that allows to manage the master data with all the information associated with general data, purchasing organization, corporation, bank accounts and tax deductions. Implementation of SAP standard financial models FI-AP, FI-GL SAP and custom settings according to the need of the request.

Project BI-HR: Implementation of models of HR Management Organization (PAOS) Personnel (PAPA), Times (PT) Payroll (PY) and Strategic HR (PACA). Activating Business Content, setup and automation of data load and functional adjustments of models and reports.

Implementation of HR-CATS model, data extraction from ECC 6.0, legacy system and data input from IP. Workshop training to users: Overview BI, BI modeling, Data extracrion to BW from differents sources, performance in BI, background processes, Integrated Planning, Data Mining and Broadcasting and reporting tools (Bex Query Designer and Bex Web Application Designer).

Maintenance: Process Chains, data load performance, technical improvements, remodeling. Modules FI, CO, SD, MM y BPS.

Workshop training to users: Overview BI, BI modeling, Data extracrion to BW from differents sources, performance in BI, background processes, Integrated Planning, Data Mining and Broadcasting and reporting tools (Bex Query Designer and Bex Web Application Designer).

Introduction to Materials Movements models of a new model for a new society. Logical partitioning of the current models of material movements to improve performance reporting.

Project PROF-SMS: Support, maintenance and continuous improvements on the models implemented in BW and SEM - BPS, which make up business solutions focused on key areas of the organization (sales, production, finance, control, and budgets).

Project NCG: Customizing of OpenHub Services in a DB table for data entry daily from infocubos sales and billing, then make a retraction of data to the source system (ECC 6.0) for the execution of letters of credit management (NCG) and provide feedback to the charging circuit BI.

Business Intelligence Consultant (BI / BW)