Mokgadi Sekele

Self-managed and result-oriented BI Developer with experience in Information Management Systems and Business Intelligence, accompanied by 2 years' experience in IT support services and Desktop engineering experience. Currently specializing in Data mining and Data consolidations, Data cleaning, Data Analysis and Data Reporting using different data analytics tools and techniques such as SSIS (together with C# in SSIS Script Task), SSAS, SSRS, MSSQL, Teradata, Ab initio, PowerBI, Excel. With basic experience of Assure Cloud computing.

I have worked and managed large data sets and data projects of high value. I have proven capabilities to identify business opportunities through my positive attitude and proven ability to produce high-quality data results that can be used for better decision making.

Senior BI Developer - FNB Premium Core Banking Analytics

(2021-12)

• Coordinate with Business Analysts and internal clients/stakeholders to develop business requirements and specification documentations
• Extract and visualise insights by integrating complex datasets and other Data Analytics Tools within Premium Core Banking Analytics
• Identify and resolve data reporting issues within agreed SLA
• Apply data mining techniques and analysis to ensure reliable, valid, and credible insights are leveraged and shared across the team
• Modify existing Stored Procedures, views, and any related scripts to adapt it to new data analytics methodologies or to upgrade interfaces and improve performance
• Develop and manage stakeholder relations effectively to promote data management across the organization and to support reliable decision-making and appropriate data usage
• Provide reports, including technical reports, as well as information management reports for decision-making purposes
• Ensure alignment between the various data management disciplines to promote cross-functional consistency in providing business value
• Participate in engagements with stakeholders, to ensure Quality Data delivery
• Work Closely with BA's to Create test plans, test data and test packs for each project assigned
• Provide business intelligence services, through BI software development solutions, and Power BI reports visualizations
• Perform business requirements through comprehensive analysis of a business's data
• Review the development of specified new functionality whether provided through internal developers to ensure best practices are followed

BI Developer/Analyst - Flight Centre Travel Group

(2021-05 - 2021-11)

• Responsible for developing and business insights through the constant modification of the existing business intelligence solutions for Flight Centre (RSA)
• Designs, codes, debugs, tests, documents, and supports server-based applications such as SQL Server, with established business requirements and specifications to deliver the highest possible value to the business
• Work closely with Flight Centre Global Data Team (Data Engineers) to consolidate/ingest, transform, and explore FCTG data through Azure Environment (Azure Data Bricks) and to handle multiple tasks and remain functional through SLA timelines
• Design and develop Power BI dashboards and provides technical support and troubleshooting of Power BI reporting solutions, including investigation of data issues, data validation and balancing
• Responsible to assess and provide a long-term strategic goal for BI development in conjunction with end users, managers, clients, and other stakeholders

BI Developer - MiWay Insurance

(2018-02 - 2021-04)

• Sourcing and Analysing data from multiple sources including but not limited Sales, Customer Services, claims data sets and create integrated views that can be used to drive decision within the business
• Responsible for data consolidation, data analysis and reporting for all claims department as well as to generating monthly commission for Claims Team Managers and Advisors
• Developing OLAP or Tabular Model Cubes within a SQL environment (SQL Server 2012 and 2016)
• Write and review SQL Code (Stored Procedures, Views and Cursors) and ETL packages to ensure compliance with the defined standards and best practices, to ensure optimal performance when released to the production environment
• Designing and building reports and Dashboards using PowerBI and SSRS
• Publish SSRS report in SharePoint to schedule report distribution
• Working closely with Management/Team Leaders to present finding of the data that can be used in MANCO sessions
• Perform Monthly commission for Claims Advisors based on the ratings and scores on the floor (Captured vs Finalized Claims)

MIS Development Analyst - SANRAL: EToll

(2015-12 - 2018-01)

• Plan and review MIS development and Analytical task for the delivery of MIS functions in accordance with the department procedure and processes
• Use SSIS for data integration process from live CDR(Gantries) into BI Platform/On_Premises
• Use SSRS report builder to automate and publish reports for different business units
• Identify, monitor, and analyse trends and features of generated data reports for further decision making through prescribed reporting channels
• Identify and escalate solutions to the MIS Section Head for improvements of MIS data development and analysis for service delivery of Business Intelligence services to the company
• Plan daily data development activities that arise through business information request and reviews in accordance with established procedures and processes
• Identify and analyse trends, duplications, redundancies, and anomalies during and after data development and compile information memorandums with accurate and concise solution for review by the MIS Section Head
• Plan activities to reconcile identified data from multiple sources coming into the different data warehouse and review against the MIS operating plans, procedures, and processes
• Compile work instructions documentations and merge all information memorandums and reports in accordance to MIS protocols for the recording of information for contractual, statutory regulatory and reporting deliverables

MPS Data Analyst - Bytes Document Solution: Xerox

(2013-03 - 2015-11)

• Compile Asset Survey data into meaningful and accurate format for presentation to the customers
• Capture survey data into Asset DB and compile current, proposed, and future states strategies
• Perform Office Document Assessment (ODA) work; do walk around to collect customer's devices information on high demand
• Interview customers to understand output requirements (Voice of the customer and Voice of the processes)
• Plotting devices on floor plans and in Assets DB create asset lists for existing and proposed new devices

Data Analyst - Department of Basic Education

(2011-08 - 2013-02)

• Perform the extraction, transformation and loading of data between various data sources for the support of business in the education department
• Carry out on the development of database tools to manage, store and facilitate and EMIS publication process
• Design Organization's Education business processes required for possible solutions to systems issues
• Develop automated data analysis for various EMIS data using VBA (Visual Basics for applications) and Access
• Compilation and updating of data reports using Excel and basic education reporting

BTech - Software Development - Tshwane University of Technology

Masters - Business Information Systems - Tshwane University of Technology

National Diploma - IT: Software Development - Tshwane University of Technology

Certificate - Business Intelligence for Business users - Altron People Solutions

Certificate - Business Analysis - Altron People Solutions

Grade 12 - Semaneng Secondary School (2005)