With over 17 years of experience in back-end data modeling and front-end report development across SAP, Snowflake, and Azure, I specialize in data extraction, staging, and load scheduling while optimizing reporting performance and data quality, having contributed to full lifecycle implementations and upgrades in SAP Financials and various other modules; I am also a certified SAP HANA Modeler.
• Data Management and Integration: Designed and implemented data solutions across SAP HANA, S/4 and Snowflake, including calculated views, stored procedures, and data pipelines, while integrating external APIs using Azure Data Factory, BODS and Qlik.
• Reporting and Visualization: Developed complex reports and visualizations using SAP Analytics Cloud, BEx, and Analysis Office, tailored to business needs and enhancing decision-making processes.
• Collaboration and Support: Engaged in requirements gathering with functional teams, supported system upgrades, and coordinated troubleshooting efforts with SAP support to ensure data accuracy and accessibility.
• Requirements and Specifications: Led requirements gathering and collaborated with functional teams to develop comprehensive Functional and Technical Specification documents.
• Data Management and Reporting: Developed a Profit & Loss report using WEBI by creating Cubes, DSOs, and Multiproviders, and utilized BODS for data validation and load job triggering.
• Report Development and Testing: Engineered complex calculations and formulas for the P&L report, merged KPIs from multiple BEx queries into WEBI reports, and conducted thorough testing across different cycles to ensure accuracy.
• Requirements Gathering and Development: Led functional requirements gathering for FI, CO, and SD modules during project blueprinting and developed InfoCubes, MultiProviders, and ODS objects for Master and Transaction data.
• Reporting and Analysis: Created complex financial comparative and trend reports to analyze variances between actuals and budget across various metrics, and developed multiple reports focusing on FICO areas and COPA data.
• Dashboard Creation and Support: Designed dashboards using Xcelsius for financial and profitability analysis, generated WEBI reports via BICS connectivity, and addressed technical issues with SAP through OSS messages to ensure seamless report functionality.
• Data Model and Development: Led the design and development of data models for Objective Setting, Appraisals, and E-recruitment at NBCU, including writing technical specifications for these systems.
• Report Development and Implementation: Analyzed BW Business Content DSOs and created standard reports for Appraisals and Requisitions, developing key performance reports on time-to-fill and open requisitions.
• Business Objects and Performance Optimization: Utilized BO Web Intelligence to create complex reports by merging multiple queries and dimensions, while also addressing performance issues and fine-tuning universes based on BEx queries.
• Implementation of Planning Solutions: Led the implementation of Merchandise Assortment Planning using Integrated Planning (IP) for the Nike Retail system, employing the Planning Modeler for functionality.
• Technical Specifications and Development: Developed technical specifications based on functional requirements and implemented various planning functions, sequences, and layouts for efficient data retrieval.
• Data Management and Reporting: Created planning cubes, multiproviders, queries, and web templates, while also handling disaggregation, data slices, and designing input-ready queries and web layouts in BI-IP.
• Implementation of Plant Maintenance: Led the implementation of Plant Maintenance at Sempra Energy Utilities by gathering functional and technical specifications and activating relevant PM data sources and standard BI cubes.
• Master Data Management and Reporting: Maintained master data for functional locations, equipment, and pipelines, while creating various reports, including exception, master file proof, and asset history reports.
• User Training and System Optimization: Conducted user training and testing sessions prior to Go-Live, and wrote ABAP routines and customer exits to meet reporting needs, while also performing system maintenance activities to enhance performance.
· Specification Development and Data Activation: Converted functional specifications to technical ones for POS design, activated IS-Retail and MM datasources for transactional and inventory data, and optimized data targets for improved performance.
· Reporting and Testing: Developed reports for sales accountability and inventory analysis, created InfoCubes and ODS objects, and conducted extensive testing and validation to ensure data consistency, collaborating with the testing department for effective implementation.
• Configuration and Data Extraction: Configured HCM, SD, and MM applications, implementing standard extractions for various modules and utilizing LO-Cockpit extractors for purchasing and delivery data.
• Data Modeling and Performance Optimization: Designed ODS and InfoCubes for FI data, generated variance reports, and enhanced system performance through techniques like cube partitioning, while also managing data extraction from SAP R/3 and Oracle using ABAP.
• Implemented and customized BI 7.0 by identifying and activating relevant Business Content for FI-GL, designing data extraction processes, developing ABAP routines and custom extractors, creating complex BEx queries, and managing transport processes, while also training end users and handling data extraction from Oracle and Hyperion.