About Me
I have over 10 years’ experience within the Accounting and Analytics segments. I have also gained 3+ years of experience within Project Management (Agile methodologies). This experience is gained from private sector orga…
I have over 10 years’ experience within the Accounting and Analytics segments. I have also gained 3+ years of experience within Project Management (Agile methodologies). This experience is gained from private sector organizations as well as various industries including chemical, transportation and financial. My analytic skills have been demonstrated through my current position in terms of analyzing growth for various companies. I have demonstrated expertise in Advanced Excel, PowerBI, SSMS, Project Management, SSAS, Qlikview, Dax, Tableau, SAP, Alteryx, Visual Studio, Hadoop, Hive, Azure, Java, Python, Jira, Confluence, Kanban Boards, MS Projects, Fluid and SQL reporting. My strengths lie in my analytical abilities and the innovative way in which I develop solutions and my commitment to delivering work of high quality.
Experience
Business Intelligence Analyst
In charge of the credit facility within the bank. All documentation and processes. Use of all BI tools to facilitate the processes. I work closely with the credit manager and the Business Intelligence manager and I contribute to the innovation in the department.
Project Manager/, End to End Developer
<p>Building and maintaining good relationships with all stakeholders.<br>
Ensuring all projects follow through the project management cycle.<br>
Adhering to budget + timelines for all projects<br>
Ensuring project governance is adhered to at all times.<br>
Monitoring all tasks via MS Projects, Fluid, Confluence and Kanban boards.<br>
Assigning tasks to the relevant teams and tracking progress on all tasks until completion.<br>
Managing all meeting cadence for the teams involved in the projects.<br>
Communicating with 3rd party vendors to acquire data and facilitate the process.<br>
Communicate with stakeholders all changes to the project plan that may require additional time + resources if necessary.<br>
Manage blockers and risks within projects and full support provided to eliminate the blockers+ risks.<br>
Ensure all documentation is managed from LBC through to Tech spec and sign off on variation orders.<br>
Manage all the team’s expectations involved in the project and provide full support in terms of leading and facilitating the full process.<br>
Assist in sprint planning to incorporate all project tasks while aligning to project timelines and tracking project milestones.<br>
Monitoring ETL jobs in alignment with SAP DS jobs<br>
Ensuring all records and reports are kept accurate and updated timeously<br>
Building out Alteryx workflows to optimize processes<br>
Creation and maintenance of Tableau dashboards for the various stakeholders<br>
Project management for Data Lake projects<br>
Provide technical support to my team assigned to the various projects.<br>
Overall responsibility of all adhoc analysis in terms of aligning databases between the various systems and SQL.<br>
Implementing new and efficient ways of reporting<br>
SQL coding for analysis and upkeep of the databases<br>
Ensuring the correct ingestion of data into the databases and assigning the various timestamps and checksums to maintain accuracy and monitor changes made to the data.<br>
Utilizing the data lake as the new source for all reporting (move over and creation of reports and dashboard in Tableau Prep)<br>
Cloud reporting<br>
Maintenance of the most secure environment in Massmart within which all data flows.</p>
BI Developer
<p>Building and maintaining good relationships with all stakeholders;<br>
Analyzing each individual companies' data – cleaning the data loading of the data into the cloud service (Azure) manipulating the data within SSMS and SSAS (Visual studio), building all relevant DAX measures for each company then loading this data into production (Azure).<br>
Thereafter, connecting Powerbi to Azure data source and building of all reports and dashboards, datasets and workspaces for each individual customer.<br>
Ensuring all records and reports are kept accurate and updated timeously<br>
Monthly revenue reports to our main stakeholders<br>
Displaying Corporate & Individual sales growth and analyzing revenue for each customer for better decision making.<br>
Overall responsibility of all adhoc analysis in terms of aligning databases between the various different systems internally & externally<br>
Implementing new and efficient ways of reporting<br>
SQL coding for reports<br>
Importing corporate data into our database and maintenance of the database</p>
BI Analyst
<p>Building and maintaining good relationships with all stakeholders.<br>
Providing full support to the technical team with regards to the ecommerce project for MTN. (new way of billing)<br>
Managing meeting cadence with the teams for the project.<br>
Full engagement with all stakeholders with any changes related to the project – timelines, resources and similar to.<br>
Provide solutions to potential problems within the project proactively and reactively.<br>
Ensuring every process was properly documented for audits.<br>
Analyzing the company’s insurance sales volume, monitoring all new business, insurance rate changes and growth.<br>
Ensuring all records and reports are kept accurate and distributed timeously<br>
Monthly revenue reports to our main stakeholders<br>
Ad hoc analysis for all billing (weekly)<br>
Analyzing claims of all devices, maintaining Corporate & individual databases, reporting through different channels and analyzing revenue growth / decline over successive periods<br>
Provide assistance to the entire call centre<br>
Provide ad hoc training for all Sales employees on Excel & Power BI<br>
Reporting on Corporate & Individual sales growth and analyzing revenue brought in from the various channels<br>
Maintaining two different mail boxes and ensuring ad hoc requests completed within 48 hours<br>
Overall responsibility of all adhoc analysis in terms of aligning databases between the various different systems internally & externally<br>
Generating monthly packs for customers presentations based on business for the month and - these included reports such as the overview/summary, claims data, debit order premiums, and report visuals.<br>
Implemented new and efficient ways of reporting (projects with IT)<br>
SQL coding for reports as well as concluding billing on the postman app.<br>
Importing corporate data into our database (maintenance of the EBU database)</p>
Business Analyst
<p>Building and maintaining good relationships with all stakeholders;<br>
Analysing the company’s TMW growth and rate per day, variance and contributions.<br>
Ensuring all records and reports are kept accurate and distributed timeously<br>
Analysing accident stats, traffic fines, MIS reports, Sales Graph reports, forward reservation reports, savings reports, C02 reports on Cognos and SQL<br>
Provide training for all Sales employees on Cognos & SQL systems<br>
Reporting on Microsites (online reservations) and analyzing revenue brought in from the various channels<br>
Maintaining two different mail boxes and ensuring ad hoc requests completed within 48 hours<br>
Building of ad hoc reports as to ensure more efficient reporting<br>
Generating quarterly packs for customers presentations based on business for the quarter- these included reports such as the overview, length of rental, lead time, damage analysis, upgrade analysis,<br>
Implemented new and efficient ways of reporting (projects with IT)<br>
Oversaw provisional rebates for a period of 6 months.<br>
Preparing the Diver Stats based on all car rental companies<br>
Provide support with the contribution model (new rates)</p>
Sales Administrator
<p>Overall responsibility of the Salesforce program, this included daily maintenance of the program, provided technical support at all times, ensuring the program correlates to the main system- Wizard, reviewing and reporting CSI for all KAMS and coordinators either weekly or monthly, provided training for all KAMS’s and coordinators on the use of the system<br>
Management of fleet vehicles, which included license disks, odometer readings, traffic fines and admin fees and collection of fees, all information logged on an internal program<br>
Responsible for Corporate Business plans and Travel Business Plans<br>
and support for all preferred members, provided support to the sales team at all times, ensuring every deadline was met</p>