📈 Jan Lock

📈 Jan Lock Email and Phone Number

SAP Data and Analytics Specialist ● Passionate about Analytics and Data Visualisation ● B.Sc. in Computer Science and Information Systems ● Founder of ANALITIX and Principal Consultant @ ANALITIX
📈 Jan Lock's Location
City of Johannesburg, Gauteng, South Africa, South Africa
About 📈 Jan Lock

I am passionate about Data Analytics, Data Visualization, and Data Strategy, underpinned by an unwavering dedication to the domain of SAP Analytics.With a Bachelor's degree in Computer Science and Software Engineering (Double Major), I have earned recognition as a leading specialist in SAP Business Intelligence and Analytics within the global market. My reputation is built on a track record of successful engagements with top-tier organisations, where I played a pivotal role in implementing SAP Global Templates for renowned companies such as BMW Group AG, Anglo American PLC, SAB Miller PLC, and Imperial Group, among others.My ability to swiftly grasp new concepts and adapt to evolving technologies is a hallmark of my career. My meticulous and analytical approach, combined with my technical prowess, allows me to excel in addressing complex challenges and introduce innovative solutions that drive business success.My collaborative spirit shines through in my seamless teamwork, while my unwavering focus and organisational skills make me equally effective when working independently. I am equally adept at being a valuable contributor to a team or leading initiatives with autonomy.Given my academic background and extensive technical expertise, I am well-equipped to help organisations navigate the ever-evolving landscape of data-driven decision-making.Join me on a journey to transform your Data into a Strategic Asset.Insights at a glance - Unlocking Data Clarity for Smarter Decision-Making🌐ANALITIX.cloud● Fostering Comprehension ● Meaningful Insights ● Transforming Data into a Strategic Asset

📈 Jan Lock's Current Company Details
ANALITIX

Analitix

View
SAP Data and Analytics Specialist ● Passionate about Analytics and Data Visualisation ● B.Sc. in Computer Science and Information Systems ● Founder of ANALITIX and Principal Consultant
📈 Jan Lock Work Experience Details
  • Analitix
    Sap Data And Analytics Specialist ● Founder And Principal Consultant
    Analitix Sep 2009 - Present
    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.
  • Sabbatical
    Sabbatical
    Sabbatical Oct 2023 - Jan 2024
    Taking some time off
  • Anglo American
    Platinum Sap Bw Im Lead (Aop Platinum Project)
    Anglo American Jun 2022 - Sep 2023
    Johannesburg Metropolitan Area
  • Anglo American
    Sap Bw Hana & Sac Specialist
    Anglo American Mar 2022 - Jun 2022
    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.
  • Bmw It Hub South Africa
    Sap Bi/Bw Specialist (Lup-O Project)
    Bmw It Hub South Africa Jan 2020 - Feb 2022
    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.
  • Bmw Group
    Sap Business Intelligence Specialist (Ilas Project)
    Bmw Group Jun 2017 - Jan 2020
    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.
  • Imperial Logistics
    Sap Bi Run Team Lead
    Imperial Logistics Sep 2015 - May 2017
    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.
  • Britehouse Specialist Sap Division (Pty) Ltd
    Sap Hana / Bi / Bw / Bpc (Etl) Subject Matter Expert
    Britehouse Specialist Sap Division (Pty) Ltd May 2015 - May 2017
    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
  • Sappi
    Bi/Bw Subject Matter Expert
    Sappi May 2015 - Dec 2016
    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.
  • Debswana
    Sap Bw Subject Matter Expert
    Debswana Aug 2015 - Nov 2015
    Botswana
    Resolutions on all issues experienced during the BW 7.4 Upgrade Project
  • Anglo Platinum
    Sap Bi / Bw / Bpc Etl Subject Matter Expert
    Anglo Platinum Feb 2014 - Apr 2015
    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
  • Lighthouse Strategic Technologies
    Senior Sap Bi/Bw Consultant
    Lighthouse Strategic Technologies Jun 2013 - Apr 2015
    Johannesburg Area, South Africa
    Projects:• Anglo American Corporate: Project Kenako• Anglo American Kumba Iron Ore: Project J2E• Anglo American Platinum: Project AAP1 Finance
  • Kumba Iron Ore
    Aop Bi Local Application Manager
    Kumba Iron Ore Oct 2013 - Jan 2014
    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
  • Anglo American
    Senior Sap Bi/Bw Consultant
    Anglo American Jun 2013 - Sep 2013
    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
  • Impala Platinum
    Senior Sap Bi Consultant
    Impala Platinum May 2012 - May 2013
    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
  • Skycode
    Senior Sap Consultant
    Skycode May 2012 - May 2013
    Johannesburg Area, South Africa
    Projects:• Impala Platinum: Comparative Management Reporting
  • Rtt Medical
    Senior Sap Bi Consultant
    Rtt Medical Feb 2012 - Apr 2012
    Centurion, Gauteng, South Africa
    Freelance Work (SAP BI SD)
  • Sabbatical
    Sabbatical
    Sabbatical Oct 2011 - Jan 2012
    Taking some time off
  • Rtt Medical
    Senior Sap Bi Consultant
    Rtt Medical Jul 2011 - Sep 2011
    Centurion, Gauteng, South Africa
    Freelance Work
  • Sabmiller
    Sap Bi Expert
    Sabmiller Sep 2009 - Jul 2011
    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
  • Satreno
    Sap Bi Consultant
    Satreno Feb 2008 - Aug 2009
    Pretoria, Gauteng, South Africa
    Projects:• Transnet, Project: Shape Up• Transnet, Project: McCarthy Viamax• Transnet, Project: Supply Chain Executive Dashboards
  • Transnet
    Senior Sap Bi Consultant
    Transnet Mar 2008 - May 2009
    Johannesburg Cbd, Gauteng, South Africa
    Projects at Transnet Freight Rail: Shape Up, McCarthy Viamax, Supply Chain Executive Dashboards
  • Afrox
    Sap Bw Consultant
    Afrox Apr 2007 - Jan 2008
    Germiston, Gauteng, South Africa
    Implementing a global template with customizations for Afrox on Project SAPhari
  • The Iq Business Group
    Sap Bi/Bw Consultant
    The Iq Business Group Jul 2006 - Jan 2008
    Rivonia, Gauteng, South Africa
    Projects:• Landbank• TFMC: Post Go-Live Enhancements & Corrections• Afrox: Project SAPhari
  • Tfmc
    Sap Bw Consultant
    Tfmc Oct 2006 - Feb 2007
    Centurion
    Post Go-Live Enhancements & Corrections
  • Alliance Media
    Head Of Information- System And Technology Department
    Alliance Media May 2004 - Dec 2005
    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
  • Jet High Computer Systems
    Managing Member / Analyst / Developer
    Jet High Computer Systems Jan 1996 - Dec 2003
    Kempton Park, Gauteng, South Africa
    • Management• Process Analyst• Business Analyst• Systems Analyst• Data Analyst• Software Developer• Registered Preliminary and Final Patents

📈 Jan Lock Education Details

Frequently Asked Questions about 📈 Jan Lock

What company does 📈 Jan Lock work for?

📈 Jan Lock works for Analitix

What is 📈 Jan Lock's role at the current company?

📈 Jan Lock's current role is SAP Data and Analytics Specialist ● Passionate about Analytics and Data Visualisation ● B.Sc. in Computer Science and Information Systems ● Founder of ANALITIX and Principal Consultant.

What schools did 📈 Jan Lock attend?

📈 Jan Lock attended University Of South Africa/universiteit Van Suid-Afrika, University Of South Africa/universiteit Van Suid-Afrika.

Not the 📈 Jan Lock you were looking for?

Free Chrome Extension

Find emails, phones & company data instantly

Find verified emails from LinkedIn profiles
Get direct phone numbers & mobile contacts
Access company data & employee information
Works directly on LinkedIn - no copy/paste needed
Get Chrome Extension - Free

Aero Online

Your AI prospecting assistant

Download 750 million emails and 100 million phone numbers

Access emails and phone numbers of over 750 million business users. Instantly download verified profiles using 20+ filters, including location, job title, company, function, and industry.