Business Intelligence Bi Consultant
Alef Education
Total years of experience :15 years, 0 Months
I create intelligence and reporting using SQL queries (Redshift and SQL Server). I build data marts, data warehouses, Power BI reports and other end-users dashboards for analytical purposes.
I design data warehouses and data structures using the Ralph Kimball methodology.
Oversee and lead the organization in Digital Transformation and improvements. Introduced self-service BI and other DT improvements.
Managed a staff complement of 6 developers and other developers indirectly. I assessed business requirements and delegated tasks, work and projects accordingly. I led technical projects with my team from the inception of BA to deliverables and managed data risks, business time consumption, and user performance.
I analyse business processes and current workflows in Business Intelligence. I work with the organization to improve the current solutions and create an architecture that is cloud-based primarily using Microsoft Azure products as Teambase is MS Partner. I create data flows, task dependencies, ETL flows, Enterprise Data Warehouses and lead a team to create a solution that is industry leading and flexible. We assist clients with Azure IaaS, PaaS and SaaS technologies by migrating on-premise data and systems to the Azure. I create comparative analysis and predictive analysis for business users to streamline their business and day-to-day operations. I spearheaded 3 projects with data migration for OSN Sports, in-house Application DW Development and Azure data migration for TECOM Group. I have improvised the current EDW by introducing governance and BI policies in the environment.
Responsible for managing the data requirements and reporting functions of the organization. I introduced cost saving reporting solutions and other alternatives to license-based software solutions. Integrated the QAs and Coaches to the Agents using SSRS reports so that a more intuitive monitoring process could be performed. The analytics produced a more effective management tool for the Executive team and the floor staff. I reduced costs of up to R200 000 in the first month of employment by using industry standard techniques for reporting and dashboard design.
Managed a staff complement of 2 developers and other developers indirectly. I assessed business requirements and delegated tasks, work and projects accordingly. I led technical projects with my team from the inception of BA to deliverables and managed data risks, business time consumption, and user performance.
Responsible for managing the data requirements and reporting functions of the organization. I introduced cost saving reporting solutions and other alternatives to license-based software solutions. Integrated the QAs and Coaches to the Agents using SSRS reports so that a more intuitive monitoring process could be performed. The analytics produced a more effective management tool for the Executive team and the floor staff. I reduced costs of up to R200 000 in the first month of employment by using industry standard techniques for reporting and dashboard design.
Managed a staff complement of 2 developers and other developers indirectly. I assessed business requirements and delegated tasks, work and projects accordingly. I led technical projects with my team from the inception of BA to deliverables and managed data risks, business time consumption, and user performance.
QlikView dashboard development and reporting using the DAR (dashboard-analytics-reporting) principle for Morgan Stanley. Created automated reports using CIA Enterprise Reporting software and NPrinting. Wrote intricate algorithms in QlikView and SQL Server to reduce data processing times and manage load balancing. Presented several project proposals and designs to senior executives and stakeholders.
Implemented latest technology to utilize fast-moving data, trends and world changes in BI and big data. Transformed large sets of data from inception to analytics using Alteryx, Lavastorm, SQL Server, Excel, and QlikView. Modeled data warehouses based on Ralph Kimball's methodology.
Developed SSRS web reports for International companies. Coordinated projects in Uganda for Umeme Prepaid Electricity and in Angola for EDEL. Was entrusted to finalise the project and deliver professional services to the client. Spearheaded in-house reports & data driven subscriptions using SSRS and SQL Server 2008 R2. Developed DTS and SSIS packages for ETL jobs to run of multiple DBs for various purposes such as dashboard and analytical reporting.
Developed and maintained intranet SharePoint portal site. Created structured and well tiered SQL data warehouses using integrated data modeling techniques.
Developed and maintained a DW environment using ETL tools such as SSIS and SQL Server stored procedures. Perform daily DW extracts and loads into OLAP models and OLTP tables in SQL Server.
Managed a staff complement of 1 developer and other support staff indirectly. I assessed business requirements and delegated tasks, work and projects accordingly. I led technical projects with my team from the inception of BA to deliverables and managed data risks, business time consumption, and user performance. I introduced new methods and industry leading technologies and practices to enhance the company’s operational efficiency. Measured staff performance and helped develop their strengths and improve areas of weakness by working closely with individuals.
Implemented business intelligence primarily using MS SQL Server R2 2008 and the subsidiary systems include SSAS, SSBS, SSIS, SSMS, SSRS, MS Visual Studio 2008 and 2010 to create processes and functions for the group to extract critical data and services that keep the different regions working with the data they require.
Create reports using MS Reporting Services and MS Business Intelligence Development Studio. Analyse Business Intelligence reporting structures such as QlikView. Dashboard designs using best practices and Stephen Few's methodology.
Maintain group and department information sharing site using MS SharePoint.
Provide the highest level of remote support for SPAR stores nationally. Principal knowledge included retail, operations, networking and store functionality and trained users nationally.
Developed and programmed SQL Server transactional script reports, maintained and optimized the source and staging DBs. Enhanced DB performance and efficiency using governance industry standards. Introduced high-level reports and business intelligence.
Worked closely with the Group BA, developed BRDs, UMLs, and URDs for training and facilitating user development.
Student Number: 200307006 1st Year Modules CSC101S: Introduction to Computer Science and Programming. MAT101S: Calculus. PHY101S: Mechanics; Matter, Waves. STA101S: Introduction to Probability & Statistics. CSC102S: Basic Concepts in Computer Science. MAT102S: Calculus and Algebra. STA102S: Introduction to Estimation Procedures. 2nd Year Modules COMP200: Object-Oriented Programming. MATH211: Fundamental Concepts. MATH213: Advanced Calculus. STAT230: Probability Distribution. COMP201: Data Structures. COMP202: Computer Organisation & Architecture. MATH224: Linear Algebra. MATH244: Mathematical Methods. STAT240: Statistical Inference. 3rd Year Modules COMP300: Comparative Programming Language. COMP302: Operating Systems. COMP306: Database Systems. COMP307: Graphics and Modelling. MGNT101: Management 110 COMP301: Software Design. COMP304: Artificial Intelligence. COMP308: Data Communications and Networks. MATH345: Optimization. MATH346: Introduction to Financial Mathematics.
English (HG) Afrikaans (HG) Physical Science (HG) Computer Studies (HG) Mathematics (HG) Biology (HG) Positions of responsibility held at school (representative) Cricket (1st Team) Under 14 Cricket (1st Team) Under 16 Cricket (1st Team) Under 18 Soccer Under 16 Soccer Under 18 I represented the School in Old Mutual Mathematics Challenge 2002.
Student Number: 200307006 1st Year Modules CSC101S: Introduction to Computer Science and Programming. MAT101S: Calculus. PHY101S: Mechanics; Matter, Waves. STA101S: Introduction to Probability & Statistics. CSC102S: Basic Concepts in Computer Science. MAT102S: Calculus and Algebra. STA102S: Introduction to Estimation Procedures. 2nd Year Modules COMP200: Object-Oriented Programming. MATH211: Fundamental Concepts. MATH213: Advanced Calculus. STAT230: Probability Distribution. COMP201: Data Structures. COMP202: Computer Organisation & Architecture. MATH224: Linear Algebra. MATH244: Mathematical Methods. STAT240: Statistical Inference. 3rd Year Modules COMP300: Comparative Programming Language. COMP302: Operating Systems. COMP306: Database Systems. COMP307: Graphics and Modelling. MGNT101: Management 110 COMP301: Software Design. COMP304: Artificial Intelligence. COMP308: Data Communications and Networks. MATH345: Optimization. MATH346: Introduction to Financial Mathematics.
