📈 Jan Lock Email and Phone Number
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
Analitix
View-
Sap Data And Analytics Specialist ● Founder And Principal ConsultantAnalitix Sep 2009 - PresentGauteng, South AfricaI'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. -
SabbaticalSabbatical Oct 2023 - Jan 2024Taking some time off -
Platinum Sap Bw Im Lead (Aop Platinum Project)Anglo American Jun 2022 - Sep 2023Johannesburg Metropolitan Area -
Sap Bw Hana & Sac SpecialistAnglo American Mar 2022 - Jun 2022Johannesburg Metropolitan AreaProject: 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. -
Sap Bi/Bw Specialist (Lup-O Project)Bmw It Hub South Africa Jan 2020 - Feb 2022Midrand, Gauteng, South AfricaBMW 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. -
Sap Business Intelligence Specialist (Ilas Project)Bmw Group Jun 2017 - Jan 2020Midrand Area, South AfricaBMW 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. -
Sap Bi Run Team LeadImperial Logistics Sep 2015 - May 2017Johannesburg 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. -
Sap Hana / Bi / Bw / Bpc (Etl) Subject Matter ExpertBritehouse Specialist Sap Division (Pty) Ltd May 2015 - May 2017CenturionMultiple 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 -
Bi/Bw Subject Matter ExpertSappi May 2015 - Dec 2016Johannesburg 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. -
Sap Bw Subject Matter ExpertDebswana Aug 2015 - Nov 2015BotswanaResolutions on all issues experienced during the BW 7.4 Upgrade Project -
Sap Bi / Bw / Bpc Etl Subject Matter ExpertAnglo Platinum Feb 2014 - Apr 2015Johannesburg Area, South AfricaSummary 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 -
Senior Sap Bi/Bw ConsultantLighthouse Strategic Technologies Jun 2013 - Apr 2015Johannesburg Area, South AfricaProjects:• Anglo American Corporate: Project Kenako• Anglo American Kumba Iron Ore: Project J2E• Anglo American Platinum: Project AAP1 Finance
-
Aop Bi Local Application ManagerKumba Iron Ore Oct 2013 - Jan 2014Pretoria Area, South AfricaProviding 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
-
Senior Sap Bi/Bw ConsultantAnglo American Jun 2013 - Sep 2013Johannesburg Area, South AfricaThe 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 -
Senior Sap Bi ConsultantImpala Platinum May 2012 - May 2013Pretoria Area, South AfricaThe 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 -
Senior Sap ConsultantSkycode May 2012 - May 2013Johannesburg Area, South AfricaProjects:• Impala Platinum: Comparative Management Reporting -
Senior Sap Bi ConsultantRtt Medical Feb 2012 - Apr 2012Centurion, Gauteng, South AfricaFreelance Work (SAP BI SD) -
SabbaticalSabbatical Oct 2011 - Jan 2012Taking some time off -
Senior Sap Bi ConsultantRtt Medical Jul 2011 - Sep 2011Centurion, Gauteng, South AfricaFreelance Work -
Sap Bi ExpertSabmiller Sep 2009 - Jul 2011Sandton, 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 -
Sap Bi ConsultantSatreno Feb 2008 - Aug 2009Pretoria, Gauteng, South AfricaProjects:• Transnet, Project: Shape Up• Transnet, Project: McCarthy Viamax• Transnet, Project: Supply Chain Executive Dashboards
-
Senior Sap Bi ConsultantTransnet Mar 2008 - May 2009Johannesburg Cbd, Gauteng, South AfricaProjects at Transnet Freight Rail: Shape Up, McCarthy Viamax, Supply Chain Executive Dashboards -
Sap Bw ConsultantAfrox Apr 2007 - Jan 2008Germiston, Gauteng, South AfricaImplementing a global template with customizations for Afrox on Project SAPhari -
Sap Bi/Bw ConsultantThe Iq Business Group Jul 2006 - Jan 2008Rivonia, Gauteng, South AfricaProjects:• Landbank• TFMC: Post Go-Live Enhancements & Corrections• Afrox: Project SAPhari -
Sap Bw ConsultantTfmc Oct 2006 - Feb 2007CenturionPost Go-Live Enhancements & Corrections -
Head Of Information- System And Technology DepartmentAlliance Media May 2004 - Dec 2005Hyde Park, Gauteng, South AfricaResponsibilities 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 -
Managing Member / Analyst / DeveloperJet High Computer Systems Jan 1996 - Dec 2003Kempton Park, Gauteng, South Africa• Management• Process Analyst• Business Analyst• Systems Analyst• Data Analyst• Software Developer• Registered Preliminary and Final Patents
📈 Jan Lock Education Details
-
Information Systems, Computer Science
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
Aero Online
Your AI prospecting assistant
Select data to include:
0 records × $0.02 per record
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.
Start your free trial