Alfred Chagweda
Development
Gauteng, South Africa
Skills
SAP
About
The candidate's skills align with Consultants and Specialists (Information and Communication Technology). The candidate has 9 years of work experience, with 6 years of management experience, including a low-level position.
View more
Work Experience
Senior Datasphere/SAC Developer
Waste Pro
October 2023 - Present
- • Responsible for efficiently delivering the project and supervising the implementation team. • Responsible for preparing technical specification documents. • Identifying SAP S/4HANA tables and structures, using SAP SLT to replicate data to SAP DWC (SAP Data Sphere) • Developed Finance reports from FI tables like ACDOCA and ACDOCP • DWC Space Management, Data Builder and Story Builder. • DWC Security, Users and Roles. • Designing and creating data models and views to enable data extraction to downstream systems, and business views to enable operational reporting using SAC. • Exposing Analytic Models into SAC using live connection. • Successfully created Dashboard story in SAC using Canvas, Responsive pages and Digital boardroom. • Successfully display story in Mobile SAC app using Responsive pages. • Prepared Transport Management from dev tenant to prod SAC tenant. • Manage User creation in SAC and SAML mapping. • Manage SSO from SAC to SC Created BPC planning function to upload data from EXCEL to Analysis for Office (AFO). • Manage PID's and email in SAML mapping in SC. • Tested and resolved data issues in SAC Dashboard stories. • Implemented stories using different features of SAC. • Implemented complex calculations in SAC stories. • Manage security restriction in SAC. • Successfully showed big data volume in SAC story
SAC Developer
SANRAL
January 2022 - August 2023
- Participated in development, documentation, requirement analysis, end user documentation, data extraction, data modelling, reporting and production support. • Interacted with the business users/Business Analysts to gather requirements. Documented the meeting in meeting minutes template. • Defining the strategy of the Analytics landscape in the context of the broad Modern Data Platform. • Worked in close collaboration with business process owners and analyst, and to ensure correct understanding and description of (ERP) business requirements • Worked in close collaboration with data engineers, cloud engineers and define the target architecture for self-service analytics applications. • Responsible for the design and delivery of (ERP) data integration solutions according to standard methodologies. • Complying with project methodologies and help deploy governance models for operational efficiency. • Providing input and identifying required architecture for continuous improvement of the Modern Data Platform. • Development of financial reports from FI Data sources like 0FI_GL_12 and 0FI_GL_14 • Modelling of ADSO'S, creation of composite provider with joins. • Involved in writing CDS views to consume the data in BW/4HANA. • Using ABAP Managed Database Procedures (AMDP) to manage and call stored procedures as ABAP. • Creation of customer exits to enhance queries. • Using CMOD to append standard SAP data sources. • Editing the structure of standard SAP data sources to add new fields. • Native Hana and Hybrid, using ADSO's as calculation views and vice versa. • Creating graphical and scripted calculation views. • Creating process chains in BW4hana cockpit. • Transformations using SAP HANA script and routines. • Creation of queries with calculated key figures and restricted key figures. • Reviewed performance issues and provided enhancement. • SAC data acquisition from SAP SuccessFactors and SAP Ariba. • SAC development of Level-based hierarchy using Geo-names for Country, Province and district and enabled drill-down on the map. • Developed a Waterfall based charts to visualize the Net Increase or Net Decrease on a time-based dimension in SAC. • Used Linked Analysis on Charts in SAC Stories to dynamically filters the widgets on the page. • Configured Conditional Formatting on tables • Created Value Driver Trees (VDT) in SAP Analytics Cloud to develop a "What-If" analysis scenario and managed to Publish to Public Models • Created a Custom Forecasting utilizing additional influencers (data from another model) with limited Prediction horizon • Worked on SAP HANA Security including User Management, ROLES, and Privileges, Reporting, Accessing Analytical and Calculation views from EXCEL. • Worked with Digital Board room, time series forecasting, smart discovery, smart insight, search to insight and heterogeneous data wrangling • Migrated HANASQL Scripts, Model objects from DEV to QAS and QAS to PRD. Monitored and conducted troubleshooting during data loads in HANA environment. • Adhoc reports using SAP Web Intelligence.
SAC Developer
City of Johannesburg
January 2021 - December 2021
- • Involved in requirement gathering for development, Data modelling and designing reports as per the requirement. • Was involved in the migration from BW7.4 to BW7.5 on Hana and then finally to BW/4HANA. • SAP BW/4 HANA Modelling for ADSO and Open ODS. • Extraction Activity for Fl-CA: BP Items, Payments and Payments Lot, Promise to Pay, Instalment Plans, Settlement Documents, Returns and Checks. • Consumed Composite providers and ADSO's as calculation views. • Developed complex calculation view using SQL and CE-Function. • Responsible for efficiently delivering the project and supervising the implementation team. • Configuration of SAP Cloud connector and Agent to import data to SAP Analytics Cloud. • Worked with OData service. • Exposing SC Data Models into SAC using live connection. • Successfully created Dashboard story in SAC using Canvas, Responsive pages and Digital boardroom. • Successfully display story in Mobile SAC app using Responsive pages. • Prepared Transport Management from dev tenant to prod SAC tenant. • Managed User creation in SAC and SAML mapping. • Managed SSO from SAC to SC. • Successfully optimized SAC Dashboard as per business requirements, which was not working in multiple model approach. • Using different features of SAC. • Implemented complex calculations in SAC stories. • Managed security restriction in SAC. • Successfully showed big data volume in SAC story. • Also Involved in Installing Bl Technical Content. Installed Business Content for standard Info objects, Info-Sets, Info- Cubes, Multiproviders, Composite Providers etc. • Created Technical specifications and standard modelling documents for HANA. • Performed data modelling and developed Calculation views of type cube for the transactional data, Calculation views of type dimension for the master data, and the calculation views as final model in SAP Web IDE for SAP HANA. • Financial statements development using SAP WEB Intelligence. • Creation of sales volume reports using SAP WEB Intelligence.
SAC Developer
IFMIS
July 2019 - December 2020
- Gathered, Analyzed and Participated in JAD sessions with business users to understand and document the business requirements from technical perspective. • SAP BW extraction using ODP • Working with Composite providers, Advanced DSO • LSA++ Methodology • Handling various types of SAP extractors Writing ABAP Code for BW extractors and transformations • Working within an Application Support environment to ITIL processes and Project Execution Methodologies e.g., Agile, Waterfall Model • CDS views, coding using Annotations • Developed reports using SAP Web Intelligence • Developed a onClick script to Add Dimension members on the fly and to save them back to the Planning Model using createMembers() function. • Used Slider to implement "What-If" Analysis. • Used iFrame to embed SAC stories in other webpages and pass parameters. • Created email notifications to users after a certain Threshold is met. • Merge dimensions from multiple Data sources to develop a Trend Analysis dashboard. • Created calculated measures (Restricted and Calculated) in SAC Stories. • Used Smart Discovery to identify Key Measure influences and relationships in my dataset and to simulate different scenarios. • Created visualizations using Natural Language querying in SAC and deployed the Stories for mobile device consumption. • Identified and tracked the slowly changing dimensions, heterogeneous sources and determined the hierarchies in dimensions.
Lead Data Analyst
TTCS
January 2015 - December 2020
- • Market Intelligence and Analytics • Responsible for the conception, design, development, and deployment of data architecture and data models • Provide leadership for the architectural direction, and provide consultation to agile teams • Working together with various business units to develop data warehouse platform vision, strategy, and roadmap • Following various ETL Processes to prepare design for all metadata • Responsible for the development of physical and logical data models • Ensuring high-performance access to diverse data sources • Enforcing architectural constraints and reject designs which compromise system integrity • Participated in research, requirements definition, planning, design and execution of projects on enterprise Business Intelligence initiatives • Managing customer expectations to ensure strong customer satisfaction by meeting the business needs for IT systems in a timely manner • Make configuration changes to improve performance • Churn analysis and prediction • Pattern recognition and customer segmentation • Data mining • Product Pricing • Developing and designing business intelligences dashboards and reports • Creating and getting sign off for Functional and Technical Specifications. • Calculating KPIs • Developed Dimension set build (including calculated and restricted dimension) • Developed and maintained dimension properties to be leveraged in calculations • Developed complex advanced formulas using Data Actions Process • Developed configured layout using Analytics Application • Developed complex Bex Queries to support SAC backend • Configured connections between SAC and BW4/HANA system • Security Configuration at Model, Dimension, Story and File Structure level. • Key point of contact in communicating business requirements for reporting needs. • Involved in business process blueprinting and subsequent solutions architecture design Worked with business and technical stakeholders in developing Models, Dimensions, Members and Hierarchies • Developed dashboards that provided insights using variances, time series, bar, geo-special charts and tables rendering visually stunning representation of key metrics. • Provided training for business users • Building Bex queries in SAP HANA studio using BW/4HANA Objects. • Data extraction in BW/4HANA from SAP S/4HANA. • Data ingestion to BW/4 HANA from 3rd party systems. • Design and develop end to end data flows for BW/HANA data models, including extractors, DTP's and Open Hub. • Reporting using Lumira, Analysis for Office (AFO) • Developing SAP S4/HANA CDS Views. • Performance tuning of long running queries/procedures Experience with large data volume, performance tuning. • ABAP programming skills and SQL Skills • Designing, building, and implementing Data/Data Warehouse Models using SAP Data Services • Designing, building, and Implementing ETL components, for real time and near real time feeds of data. • Designing, building, and Implementing Reporting and Visualization tools including stream processing • Implementation and support of existing products • SAP HANA Modelling • Configured and managed Repositories using administrator console as per business requirements in SAP Data Services. • Created mappings using Designer and designed workflows using Workflows to build DW as per business rules in SAP Data Services. • Managed the central and local repositories using the Management console and Repository Manager in SAP Data Services • Developed Dashboards for Project systems, Finance Director and Materials Management using Dashboard Designer, Web intelligence, Live office, Lumira and SSRS • Developed Universes using Information Design Tool (IDT) to be used as data sources for Web Intelligence reports • Implementing Change Data Capture (CDC) strategies • Data transformations using Validation Transformation, Merge Transformation, Case Transformations and Pivot. • Created complex Jobs, Work Flows, Data Flows and Scripts using various Transforms. • Wrote scripts to schedule Batch-Jobs. • Used Data Services Management Console to schedule and execute jobs.
SAC Developer
EJUSTICE
November 2018 - June 2019
- • Building Bex queries in SAP HANA studio using BW/4HANA Objects. • Data extraction in BW/4HANA from SAP S/4HANA. • Data ingestion to BW/4 HANA from 3rd party systems. • Design and develop end to end data flows for BW/HANA data models, including extractors, DTP's and Open Hub. • Reporting using SAC, Analysis for Office (AFO) • Developing SAP S4/HANA CDS Views. • Performance tuning of long running queries/procedures Experience with large data volume, performance tuning.
SAC Developer
ECZ
April 2018 - December 2018
- • Requirements gathering; analyses of business processes and validation of functional requirements. • Conducting sizing to determine how much infrastructure is required to support the solution including hardware, storage and network usage. • Created Technical specifications and standard modelling documents for HANA. • Involved in business and blueprint gathering discussion. Native HANA XS application development to read tables in HANA database using SAP Web IDE for SAP HANA. • Involved in postproduction support activities in monitoring the daily data loads, performed data modelling and developed Analytical views for the transactional data, Attribute views for the master data, and the calculation views as final model in SAP Web IDE for SAP HANA. • Experienced with understanding of the end-to-end Architecture (Data loading, Data modelling & Reporting); Working • Knowledge on SDI (Smart Data Integration) and SDQ (Smart Data Quality). • Created Remote connection from HANA Database to Hadoop system using SDA (Smart Data Access). Worked on SAP HANA Data provisioning technology including SAP LT, Data Services-BODS, replicated Data from multiple modules- FICO, MM, SD. • Configured SAP HANA data provisioning for replication with SAP source systems and non- SAP source systems. • Experienced in Importing meta data, Table definitions, performing initial load and Replication, Resuming and Suspending data loads using SAP HANA studio. • Developed complex calculation view using SQL and CE-Function. • Developed data models for the operations FI, PS, PP, MM, Quality management tables in HANA. • Created advanced modelling using Hierarchies, derived views, restricted calculated column, variable, input parameter. • Developed the security model, naming conventions, folder structure for HANA2.0 and BOBJ 4.3 and established the recommended SAP best practices for developing Universes, reports and dashboards from HANA data sources. • Migrated HANA content from development, testing environment to Production environment using delivery units. • Developed Webi reports and dashboards for different operations and finance KPI'S like Project planning, Funds Management, quality management, warehouse management, Material management, Global Sustainment, Value management. • Created dashboards using SAC
SAP BW/BI Developer
PSMAS, ZIMBAWE via TTCS Consulting
August 2017 - March 2018
- • Key end to end Solution developer for Success factors talent management solution for Shoprite head office • SAP Success Factors Data Migration into BW on Hana 7,5 Using SAP DATA services. • SAP ETL process SAP BW and HANA Data modelling • Develop data model Calculation views for report writing Tableau • Developed data flows and workflow using BODS ETL table Replication from source to land. • SAP BW model ETL (Extract, Transform and Load) and Data warehousing loading Success factors tables in to ADSOs • Model complex keys files to address delta functionality to handle deleted records used in a file system. • Building Advanced Data store objects at Acquisition layers • BW Process Chain Design and Development • Move Data service Development from Dev Systems to Prod systems using central repository • Building Composite Providers and exposing BW objects in SAP HANA Views, Operational Data Provisioning, ADSO etc.
SAP BW/BI Developer
NATIONAL SOCIAL SECURITY AUTHORITY via TTCS Consulting
January 2016 - August 2017
- • Requirements gathering; analyses of business processes and validation of functional requirements. • Conducting sizing to determine how much infrastructure is required to support the solution including hardware, storage and network usage. • Analyzing existing client processes and created optimized and enhanced solutions for SAP BW & SAP BPC • Gathering requirements for BW and BPC Technical implementation • Designing Data Models using Star Schema, mainly by the Kimball Architecture methodology • Working with Info Objects: Standard as well as created custom Info Objects • Working with Info packages and Scheduling loads into Persistent Staging Area (PSA) • Working with Transformations, Data Transfer Process (DTP) • Working with Info Cubes and Data Store Objects (DSO) as data targets and Info Providers. • Working intensively with Data Warehousing Workbench, Data Source maintenance, and Data Acquisition. • Working with Process chains in order to automate the processes. • Loading of Master Data and Working on Delta Loads for Transactional Data • Performing checks for DSO's views for consistency. • ETL Development & Implementation with Flat Files, SAP R/3, BW, and non-SAP sources as Source Systems • Establishing and maintained RFC Connections between BW, BPC and SAP R/3 • Development of reports using Web intelligence. • ABAP programming skills and SQL Skills • Development of reports using business objects.
SAP BW/BI Developer
ZIMDEF via TTCS Consulting
July 2015 - December 2015
- • Requirements gathering; analyses of business processes and validation of functional requirements. • Experienced BW Architect / Development / Methodology development • Source System Creation and RFC Maintenance • Near-time loading into HANA • Data source identification and customization of extractors • ECC HCM/IS-H/RE/EHS/PM / FI-CO / MM/SD/WM/EWM/ Functional and Process Experience • BW Authorization design • BW Process Chain Design and Development • Developed the following HANA Data Models: Attribute Views for master data • Analytic Views for Transaction Data and Calculation Views Graphical and SQL Script to Join/Union the Attribute and Analytic Views for report consumption with time dimensions. • Dashboard design using Design Studio • Building a Data Warehouse using SAP BW on HANA • SAP ETL / Process / HANA Data modelling / Solution Architecture • Use of BW on Hana Objects such as SLT, Open ODS Views, Hana Analysis Process and Advanced DSOs to ETL
Education
Period of Studies
Certificate
Chinhoyi University of Technology
MSc in Data Analytics
