Snr BI Developer - CyberPro Consulting - Standard Bank (Data-Services: HUB Consolidation)
(2018-10)
- Decommissioning from the current set up on Data Stage (MOD-server), migrating to the new Reservoir which is in Microsoft platform by utilizing Microsoft SSIS ELT tools across all African countries to the new Common Data Store (CDS) also known as Reservoir.
- Provide development and delivery of Business Intelligence data sourcing using ETL (MS SSIS) functionality.
- Involved in assessing Deployments via code reviews, ensuring that the developers followed the right standards.
- Taking juniors and intermediate developers under my wing and provide training and mentoring to technical staff as required
- Work closely with stakeholders to see through the work delivered to them is consistently maintained and running successfully. Also teaming up with PMs, BAs and technical staff to set deadlines and agree project deliverables and deliver accordingly
- Clean up decommissioned feeds (i.e. Batch files) before migrating
- MS Transact SQL Management Studio (SSMS)
- MS SQL Server Integration Services (SSIS)
- Control M – scheduling tool
- Support daily Reservoir Jobs on controlM and resolving issues as they arise
- Support and maintain the Data product script on Reservoir
- Create configs for new files from source system as per business request
Snr BI Developer - CyberPro Consulting - Capricorn Holdings (Bank Windhoek)
(2018-01 - 2019-06)
- Use advanced T-SQL (SSMS) to script and resolve issues logged on the management system i.e. records that exist on the bank channel but not in the core system.
- Design and build Data-Warehouse with dimension and facts tables
- Monitoring daily ETL (SSIS) for Datawarehouse
- Create / edit reports as per client request (SSRS & Power-BI)
- Create Metadata report (source target – ODS – EDW)
- Create / edit tables as per the client's requests
- Enhanced the existing ETL
- MS SQL Server Integration Services (SSIS)
- MS SQL Power-BI (Reporting / Visualization tool)
- MS Visual Studio
Intermediate BI Developer & Production Support - Multichoice
(2017-05 - 2017-12)
- Create and edit stored procedures/ functions, views for reporting purposes
- Support and optimize existing SQL queries
- Creating and troubleshooting SSIS projects and packages
- Troubleshoot SSAS solution for any failure
- Troubleshooting Batch file that execute the package
- Create Reports (SSRS) to monitor the daily run
- Monitoring SQL agent jobs
- Investigating SQL agent jobs failures and fix the errors
Intermediate BI Developer & Production Support - Goldenrule (Consulting at Multichoice)
(2016-10 - 2017-04)
- Create and edit stored procedures/ functions, views for reporting purposes
- Support and optimize existing SQL queries
- Creating and troubleshooting SSIS projects and packages
- Troubleshooting Batch file that execute the package
- Troubleshoot SSAS solution for any failure
- Report (SSRS) to monitor the daily run
- Monitoring SQL agent jobs
- Investigating SQL agent jobs failures and fix the errors
Intermediate BI Developer & BI Production Support - LightStone Property
(2015-03 - 2016-10)
- Enhance and stabilize the Production environment
- Rewrite some of SAS code to SQL code with the help of SAS Developers
- Gather the business requirement and Create New Business reports
- Monitor the Production job in case of failure, alert the relevant developer
- Amend the existing report
- Create ETL to monitor the files on Production for space creation
BI Developer - Multichoice (under IT Business)
(2014-03 - 2015-02)
- Create ODS reports for Customer Care center
- Assist Business Analyst to gather the business requirements
- Create ETL package as requested by the business.
- Create a complete ODS from flat files using ETL (SAP files)
- Create users and groups
- Grant Access on ODS environment
- Grant Users access on specific reports
- Monitoring Daily Load on ODS
- Create script for data quality
BI Developer - MTN (under IT Business)
(2012-09 - 2013-12)
- Tasked with all reporting dash boarding for Customer Relations subject area
- Extraction, transformation and loading of data from Contact Centre systems such as Rockwell, UIP, Qmatic, IVR
- Cube Development and Maintenance
- Publishing of reports onto SharePoint
- Coordinate with customers and Business to analyze business requirement
BI Developer - Phumelela (under IT Business)
(2011-11 - 2012-08)
- Monitor the Datawarehouse environment end to end: Data extraction, Transformation and Loading, Ensure timeous availability of reports, Environment usage, capacity and availability
- Development of new requirements using Microsoft BI Stack (SSMS / SSRS / SSIS / SSAS)
- Development of OLAP cubes and associated reports and dashboards (SSAS)
- Liaising with source system owners for data availability
- Report state of environment to Operations Manager
BI Developer - Investec (Under Youngblood)
(2010-07 - 2011-10)
- Create the tables on Operational Data Store by using the structures of the Source systems
- Create dimensions and fact tables on Dev Environment
- Create SSIS packages to load the dimensions and Fact tables and present my work to my senior for testing then deploy these packages to Testing Environment.
- Monitor batch jobs that load data from Source system to the Operational Data Store and to the Datawarehouse
- Create the report using SSRS based on the clients need
Junior DBA - Youngblood
(2009-03 - 2010-10)
- To monitor the jobs and Manage Database on SQL server 2000, 2005 and 2008 and create a report based on the outcome before the business operation.
- Monitor database space usage and availability
- Check the database states
- Monitor SQL Server error logs
- Monitor and resolve dead locks process
- Transaction Log file usage
Network Support Technician - SASSA
(2008-03 - 2008-09)
- PC and Printer Repair
- Install operating system
- Establishes email accounts and IP addresses
- Install software programs
- Connect Pc in a network
- Solve employee's technical problems
