Mohammed Kajee

My role involves leading the digital and interactions data teams within the retail area. My responsibilities include managing projects, staff, business expectations which ultimately generate value through cross-functional IT team collaboration, decision support and strategy execution and delivery. I also am very hands on t technically lead the team in processes of our SDLC that involve idealization, architecture and research and development. Our outputs include explaining gaps in our digital and other interfaces to better understand how to contact and convert our consumers in the most efficient ways. Since then technologies spanning open source technologies like python have been integrated to internal systems leveraging Google Marketing as well as Google Cloud Platform to bridge operational acquisition and interface technologies, to data and analytical capabilities to create a digestible story for our decision managers about who our clients are, what they desire, and how to help them. These efforts has seen us improve client journeys and unlock close to R100 million worth of previously dropped loan applications. Awards received: Innovation and Pioneer.

• Improved operations through consistent hard work and dedication.
• Used critical thinking to break down problems, evaluate solutions and make decisions.
• Oversaw daily operations to ensure high levels of productivity.
• Developed and implemented performance improvement strategies and plans to promote continuous improvement.
• Led projects and analyzed data to identify opportunities for improvement.
• Managed team of 6 employees, overseeing hiring, training, and professional growth of employees.
• Stimulating the teams knowledge, growth and performance - leading the changes from norming to performing
• Leading the digital business intelligence and analytics teams within FNB
• Drove Innovation and Idealization
• Architected a first of its kind, self service reporting solution, integrating DC, Google Analytics and Internal data, to provide a view of digital performance metrics
• Architected and Implemented Gamification for all teams or information delivery utilizing a Chrome Web Kit driven by a SQL model that could display SSRS, Datazen, PowerBi dashboards, as well as Youtube and FB Live videos.
• Assisted with Pulse Idealization, (Award received: Wingman)

My focus at Pick and Pay was around creating a reporting platform to support real-time gamification within all operational areas within a single store as well as decision support in identifying efficiencies. This effort was part of optimizing the already lean processes that occur within retail stores, but drive it from the store staff's intrinsic internal need to be the best and competitive, driving better customer experience and job satisfaction, driven by data. These operational areas were unpacked and distilled to 25 key Kpi's. Pick and Pay is one of South Africa’s largest retailers, taking into account the need to compare a stores 25 Kpi's within the different quartiles of all stores within its region and the country and the immense trading volume was an immense and rewarding challenge once delivered, through collaboration and architecture that saw a rollout to 600+ stores. Operational gamification saw an increase in customer experience and trading volumes due to increased efficiencies in picking and packing. Low performing stores saw an uptick as rewards for improving low KPI areas became a focus.

• Research of the market and industry as well as lean methodologies
• Championed technical delivery and architecture to deliver insights and solutions to business problems
• Delivered decision support data, visual analytics, store availability patterns as well as stock forecasting and financial budgeting to the executive as well as operational user base
• Utilized big data platforms: Greenplum, SAP BW and Hana as well as analytics tableau and static SSRS
• Championed data security with role-based access tiered through security platforms
• Implemented efficiencies in Store Processes using Availability reporting
• With the availability reporting, championed the architecture to achieve sub second reporting per store over hundreds of millions of rows of data
• Implemented SSRS and Tableau over a Big Data platform
• Sql 2014 Poc, utilizing in Memory analytics and reporting
• SAP HANA Migration planning and testing
• POC Design Studio vs Tableau
• Availability and Gamification per store

Assisted with the architecture and development of a trading terminal with local and international company exchange financial, statistics and meta data utilizing MDX and .Net.

Implemented best practices around Business Intelligence, Data analytics and Database development.
Assisted Product Managers by implementing a self service reporting approach

• Inet is South Africa’s leading market data and analysis platform
• My roles here included technically leading the team implementing high performance sql and analytics technologies utilizing, SSIS SSRS SSAS and development methodologies to supplement their real-time products
• Analysing their current infrastructure and developing solutions to assist the company achieve its goals
• Finalized their global matching universe using sql models and Ssrs
• Assisted with their partitioning strategy both with SQL and SSAS
• Implemented a central notifications engine to supplement their operational intelligence
• Sql 2008 R2, Sql 2012, Sql 2014 SSIS, SSAS, SSRS Qlikview

At Capitec, I lead a very diverse and qualified team in delivering information to the business as well as implementing its long term Big Data strategy through the Microsoft Parallel Data warehouse.

One of the biggest problems faced when entering Capitec, was their Mis platform, which lived on the same hardware cluster as their banking platform. Being responsible to consume and deliver data to 600+ branches is no easy feat and especially so on demand days like monthend. That was never more clear than on days, when staging processes would run past 5pm. rendering branches useless on month ends, losing customers to the stigma that a small bank stands no chance physically to its competitors.

This was my first major win. With risk and SDLC protocols adhered to, and insights into the performance counters of the Servers involved, custom Server performance logs and counters with a layer of SSRS charting (operational intelligence), which assisted in decisions that saw an increase of almost 6 hours saving in run-times and assisting branches and staff by having an operational banking system at month ends. Further to that the team grew with consultants and MVP’s that implemented the first Microsoft PDW in Africa through implementing BIML and supporting architecture for rapid application development.

• Navigated AML and KYC legislative requirements
• Architected the plan and process of moving from a Kimball SQL model to a shared SMP MPP model
• Championed the use BIML for Rapid Application development and deployment
• Stimulated the team with external resources as well as MVP's Jody Roberts and Gail Shaw

My responsibilities at Kalahari.com revolved around the price engine, variable markup systems, and general data load and data quality issues by identifying system gaps that were harming customers and the business. This resulted in a number of efficiencies as a result of data exploration and collaboration with other teams.

• Responsible for the Kalahari.com Sql, Bi infrastructure, operational and development environment
• Brought in to establish best practices around Sql, Ssis, Ssrs and Ssas.
• Responsibilities included the completely redesigned pricing engine, Variable mark-up systems, Reporting, Data loading.
• Methodologies needed to be adhered to were Agile and Rad.
• Accomplishments ● Central Notifications Hub. ● Operational dashboards. ● SSAS implementations. ● Documentation strategy. ● Qlikview fraud detection

Identify design and maintain Financial Business Intelligence Models, according to company and business specified processes, reporting on these integrated systems as well as Front End development to compliment the BI system.

This included Data Cleaning, ETL Development, Relational database design and redesign (Normalization, SDLC, Stored Procedures, Triggers) OLTP, as well as cube development, Hyper Cubes, Dimensions, MDX, Named Calculations, Excel development with Cube Data-sources, Reporting on Data, MIS Stats, Dashboard Development, Data analytics.

Consulted for ● Foodcorp ● Tiger Brands ● Adcock Ingram