Gilberto Hernández

Design strategy and deployment architecture, focusing on business requirements and integrated solutions within SAP FICO. Oversee master data management, including preparation, cleansing, and migration processes. Lead full lifecycle implementation of 0FI_ACDOCA_10 Universal Journal extractor data flow at Carrefour, including testing, analysis, and cross-team coordination for data extraction from ACDOCA.

Engage in in-depth activities involving SAP BW/4HANA, ABAP programming, and virtual data modeling to optimize system performance and data management. Create ABAP programs and CDS views for MATDOC and provide project management guidance for SAP BW/4HANA and S/4HANA landscape development. Key Deliverables;

• Completed a master data migration update, enriching report infoObjects extracted from 0FI_ACDOCA_10.

• Designed and executed a sale reporting solution, serving as a benchmark for future projects; enhanced team's data management proficiency via virtual data modeling using CDS within a S/4HANA setup.

• Conducted a proof of concept with SAP DATASPHERE and SAP business technology platform, mapping existing data flows to Datasphere hand in hand with new SAC-based report proposals.

Analyzed and optimized CDS executions, collected traces (PLANVIZ), and identified and resolved data join bottlenecks. Implemented a staging data solution to BW persistent objects (ADSO), reducing report response times through a pseudo delta mechanism and process chain for regular data staging. Expanded inventory dashboard functionality by integrating new fields for handling unit pallet counts/quantity and material price lists for accurate inventory value calculation. Developed, documented, and validated queries and CDS for multiple client reports, ensuring data integrity and analysis accuracy. Enhanced and maintained SAP embedded Analytics applications, focusing on virtual data modeling with CDS development for Lakeland daries. Key Deliverables;

• Streamlined data flow and enhanced performance by redesigning joins and modifying the CDS tree structure.

• Facilitated improved data staging and report responsiveness by implementing a staging data solution to ADSO with a daily/weekly process chain.

• Enriched inventory dashboard data analysis capabilities by adding new fields for year/month period tracking.

• Reduced inventory dashboard report response time from 120 seconds to 20 seconds per navigation click through bottleneck detection and optimization.

• Reduced report response time to 0.5 seconds per navigation click by implementing a materialized view.

Conducted thorough requirements gathering for ETL data flow solutions, ensuring accurate and efficient data warehouse management. Documented development processes, executed tests, and analyzed data for report accuracy. Designed and developed complex reporting solutions for JTI, including multilevel bills of materials (BOM) explosion reports utilizing CDS views, recursive ABAP programming, and OpenHub destinations. Enhanced inventory reports by integrating new IBP data models, creating innovative modeling designs, and executing ABAP programming for advanced queries. Troubleshot and resolved reporting issues, ensuring seamless data flow through ADSO, InfoObjects, and Composite Providers. Key Deliverables;

• Replicated over 20 SAP analytics cloud reports for a feasibility evaluation, assessing migration benefits and challenges.

• Updated data flow of five main logistics Multiproviders and 18 data source objects to new composite providers and advanced data source objects.

• Improved efficiency by optimizing BOM multilevel explosion reports from a runtime of one hour daily to just five minutes.