📈 Jan Lock Email & Phone Number

Gauteng, South Africa

I'm a highly accomplished SAP Analytics and BI Specialist with 15+ years of global recognition. I've led key roles in projects for BMW Group, Anglo American, SAB Miller, Imperial Group, and Linde PLC.My profile reflects adaptability, analytical skills, and technical expertise. I excel in teamwork and independence, consistently showing focus and diligence.Proficient in SAP tools like SAC and Eclipse, I troubleshoot across teams and facilitate SAP MAX Attention sessions.My experience makes me a valuable asset to BI Design Authority Committees. At Anglo American, I modernized reports for Anglo Platinum, migrating from Legacy SAP to tools like SAC.I've developed TA-XPLORE, analyzing Smart Recruiters data with HANA, transmitting it to SAC through BW Live Connection.My tenure at BMW ZA Hub enriched my expertise in SAP Gateway, API's ODATA development, and troubleshooting.I'm proficient in SAC User Groups, user management, BW Live connections, and resolving story performance issues.Eager for new challenges and mentorship opportunities.

Taking some time off

Johannesburg Metropolitan Area

Johannesburg Metropolitan Area

Project: TA-XPLORE (SAC Dashboard)Data is extracted from Smart Recruiters, the Global Talent Acquisition application used by Anglo American across all their Business Units.More than 120 Tallent Acquisition KPIs are calculated on the fly in HANA’s In-Memory technology and passed to SAC via a Live Connection. This functionality allows for complete data transparency and versatile data analysis. Business can see the different KPIs calculated at any reporting dimension of their choice. Business can filter on any value on any of the charts. The selected value will filter all related charts, and the user continues to drill down by selecting a more detailed reporting dimension. The user repeats the process until the Requisitions/Jobs are displayed in a table, providing complete transparency in calculating every KPI.The user jumps directly into the source system by clicking on the Document Number. The relevant document opens in Smart Recruiters for further investigation.Thresholds with RAG (Red And Green) highlighting help to identify KPIs that deviate from targets and require further investigation.Heatmaps measuring the process steps over a long period helps identify which processes largely deviate when things go wrong.One business unit experienced a reduction from 5 days to 5 minutes to compile their monthly reporting pack.

Midrand, Gauteng, South Africa

BMW LUP-O Global Template Development & ImplementationBedarfs BeKoSt LUP-O Project (2020 –2022)I am the Backend Team Lead and System Architect, deciding on technologies to minimize development time while maximizing maintainability. I am also responsible for a design that maximizes scalability, performance, and operational ease. This application rates as one of the top-five-sensitive-data-applications within BMW Group. Data consistency, transparency, and date-change-traceability are of utmost importance. Data accuracy is crucial as the decisions relying on this data amount to €60 billion annually.The central buyers use Bedarfs BeKoSt during purchasing agreements negotiating for components used in the manufacturing process, up to 15+ years in the future. The application receives data from several source systems. Master Data is stored in its raw format and mapped to harmonized application Master Data. Transaction Data is versioned and stored in its raw format. The main business entities in the Transaction Data are harmonized to the application Master Data, and values aggregated. The data is versioned again, allowing for adjustments to be made to MD Attributes and values. The values then get distributed, allowing for another adjustment opportunity.An Official Scenario is created, bringing all the different versions together. Once a scenario is released, it is locked and can never be changed. There are also Project Scenarios and Simulations for what-if-analysis. Users can create multiple simulations, which can later be published for reporting.The backend does the heavy lifting of all this functionality. The application uses SAP BW 7.5 on HANA 2.0 on the Backend and a JavaScript Frontend (BW/4HANA rollout to only start 2021). Backend and Frontend communication is done via REST-based OData Services using JSON data-interchange format.Due to the sensitive nature of the data, this application's functionality will not be discussed in detail.

Midrand Area, South Africa

BMW Group IT: SAP Shared Service Centre, South Africa, Business Intelligence, Data WarehousingBMW After Sales Global Template Development & ImplementationI was a team member of the ILAS Project, the biggest BW/BI Project in the history of the BMW Group to date. The project was moved from a European Consulting House to the BMW SAP Shared Service Centre in South Africa. I was one of the initial key developers, delivering the second work package successfully, which was a key factor in securing the ILAS project for the SAP Shared Service Centre in South Africa. We successfully delivered all the modules used by the global BMW After Sales Department, replacing the Legacy Data Warehouse. The Agile Project Management Methodology ensured greater adaptability to frequently changing scope through short iterative Development Life Cycles with daily interactions with the Product Owners in Germany.I was the architect and developer of the BI Time Zone Conversion Framework which enabled aligning and comparing overlapping perspectives of different timelines for KPI and management reporting. Later I also fulfilled the position of Design Authority, introducing Development Standards, Development Scoring Matrix for Gateways, System Stability Guidelines and Active Measures to ensure an optimal Solution and System.

Johannesburg Area, South Africa

• New Development Request: Real-time- Datasets, Dashboards and Reports• Change Requests, Optimizations and Incidents• Technical: HANA Live Views & Universes, SLT with HANA Views with BW Open/Advanced ODS’ and Composite Providers, Fiori, Webi Reports, Design Studio etc.• Supporting the Business Units in the Imperial Group which are live on SAP• Other: Designed and developed ‘Dynamic Date Filtering Selection’ functionality that is used when creating several BI Publications from one ‘Webi Report based on a BEx Query’. Each Publication is for a different time frame e.g. Free Date Range Selection (Ad Hoc), Current- & Previous- Day, Week, Month and Year.

Centurion

Multiple Clients:HANA & BI: • SAP HANA Live with HANA Studio • SAP Gateway & SAP Fiori • SAP Design Studio • SAP Lumira • SAP Dashboards • SAP Crystal Reports • SAP BW 7.4 on HANAMultiple Clients:Upgrade Projects: • to BW 7.4 • to BI 4.1Multiple Clients:SAP BI/BW System Analysis: • BW System Health-Check Toolset Analysis • ETL Performance Analysis • Reporting System Analysis • Report Performance Analysis • Database Size/Growth Analysis (Housekeeping) • Best Practice Implementation Analysis • Comprehensive Analysis (all of the above) • Specific Problem Area Analysis

Johannesburg Area, South Africa

• New Development Request, Change Requests and Incidents• Developed a Total Reward Statement for Employee Self Service: Employees follow an URL to the Crystal Report and log on to SAP BI (BO) with AD Authentication and only the Employee associated with the AD Account’s TRS data is displayed - passing the AD Account details from BI (BO) to BW as input to a BEx Variable.

Botswana

Resolutions on all issues experienced during the BW 7.4 Upgrade Project

Johannesburg Area, South Africa

Summary of deliverables are:• Enhancing current Dataflows to cater for new Business Requirements identified during project AAP1 Finance - BPC SAP ETL Data Provisioning• Creation of DDL (Data Distribution Layer) for BPC NetWeaver 10 Data Provisioning from SAP ECC• Creating Retraction Dataflows from BPC NetWeaver 10 to NetWeaver BW 7.3• Automating BPC ETL via BW Process Chains, including Lite Optimize, BWA Index and Backup of models with millions of records, with the largest one being 180 million records• Changing existing Dataflows to LSA Dataflows across all Functional Areas with performance tuning current models (BW 7.3)• CO LSA (CCA, OPA & WBS) build, optimizing the old CO dataflows, reducing daily runtimes by 60%• Optimizing BWA (Business Warehouse Accelerator) 7.2, for efficiency in storage and access• Advising SAP BPC NetWeaver 10 implementation partner on performance tuning BPC loading, calculation and reporting by creating Database Indexes and BWA Indexes

Johannesburg Area, South Africa

Projects:• Anglo American Corporate: Project Kenako• Anglo American Kumba Iron Ore: Project J2E• Anglo American Platinum: Project AAP1 Finance

Pretoria Area, South Africa

Providing governance and guidance:• Local AOP BW Application Manager• Global AOP BOBJ Application Manager• to the J2E Kumba Iron Ore BI project team ensuring their development aligns to the chosen LSA (Layered Scalable Architecture) template principles, and• to incorporating the J2E Kumba Iron Ore BI Solution into the current live AOP (Anglo Operating Platform) Global BI Template

Johannesburg Area, South Africa

The following is a brief summary of my duties:1. Working as a team member responsible for the Global Template implementation and AOP BI Governance.2. Building EDW and ADM Data Flows in accordance with LSA, implementing SPO’s for domains3. Building, maintaining and monitoring Process Chains4. Business Objects CMC Administrator, including setting up CMC5. Creating Web Intelligence super user training material and training the trainer

Pretoria Area, South Africa

The following is a brief summary of my duties:1. Maintenance Weeks, doing routine maintenance to keep the BW landscape running optimal2. Migrating CCA Financial Management Comparive Reporting from Oracle Hyperion Financial Reporting Studio to SAP Crystal Reports3. Building Comparative Reporting Templates in SAP Crystal Reports which displays Cost Element Hierarchy Node grouping sections, each displaying the Top N Cost Elements for the Hierarchy Node and aggregating/rolling up all other Cost Element values outside the Top N into an Other Costs line. This happens dynamically in the report. The numbers used in the TOP N groupings are defined per Cost Element Hierarchy Node.4. Member of the BI Team that was involved in the BW 7.3 Upgrade Project. I investigated and applied the necessary SAP Notes after the upgrade to stabilize the BW environment

Johannesburg Area, South Africa

Projects:• Impala Platinum: Comparative Management Reporting

Centurion, Gauteng, South Africa

Freelance Work (SAP BI SD)

Taking some time off

Centurion, Gauteng, South Africa

Freelance Work

Sandton, Gauteng, South Africa

• Assisting with Dataflow Modeling, modeling Extraction Layer, Consolidation Layer, Analysis Layer, Reporting Layer as well as Failure-Recovery and Enhancement-History Dataflow Modeling• Building of Dataflow, from DataSource to InfoProvider, including ABAP in InfoPackage Selection Routines to Transformation Routines, Start- and End Routines• BW Back Office Box provides Material Movements data to BW Front Office Box, Coordinating and Developing Solution• Building, Enhancing and Monitoring of Process Chains, including ABAP Programs used in the Process Chains• Transporting Development through the SAP Landscape using CHARM from Solution Manager, as well as manually correcting transports where necessary• Preparing Data Warehouse Production Environment, including BI Statistics & Technical Content• Sole responsible party to build Global Reporting Web Template, consisting of several templates e.g. Header, Toolbar and Footer. The Toolbar Template included the following functionality via drop down windows that opened and closed: More Information (Technical Support Information and Report Meta Data), Filters & Variables (Filters Applied and Variable Screen), Exceptions & Conditions, Print Version, Export to Excel and CSV, Settings for Analysis Items and Charts• Building of BEx Queries, and Maintaining of Report-to-Report Interfaces, jumping from Summary Reports to more Detailed Reports to Transactions in ECC• Building of Web Templates and Analytical Applications• Assisting the BO Team with identifying and resolving issues with BW BAPI’s used by BO• Writing of Test Script Templates for Dataflow and BEx Report Testing• Logging of SAP OSS Messages, implementing corrections and providing workarounds

Pretoria, Gauteng, South Africa

Projects:• Transnet, Project: Shape Up• Transnet, Project: McCarthy Viamax• Transnet, Project: Supply Chain Executive Dashboards

Johannesburg Cbd, Gauteng, South Africa

Projects at Transnet Freight Rail: Shape Up, McCarthy Viamax, Supply Chain Executive Dashboards

Germiston, Gauteng, South Africa

Implementing a global template with customizations for Afrox on Project SAPhari

Rivonia, Gauteng, South Africa

Projects:• Landbank• TFMC: Post Go-Live Enhancements & Corrections• Afrox: Project SAPhari

Centurion

Post Go-Live Enhancements & Corrections

Hyde Park, Gauteng, South Africa

Responsibilities can be summarized as:• Authoring IT/IS Policies and Procedures• Project Management• Business Process Analysis• New Business Process Development• Need Analysis• Scoping of the Needs• System Analysis• Heading of Development Team• Testing Plan development• Change Management Plan development

Kempton Park, Gauteng, South Africa

• Management• Process Analyst• Business Analyst• Systems Analyst• Data Analyst• Software Developer• Registered Preliminary and Final Patents

Bsc, Information Systems, Computer Science

BSc (with double majors) Information Systems & Computer Science Other Subjects: Operational Research / Quantitative Management

Diploma, Datametrics

Diploma in Datametrics (Obtained with distinction)