CURRICULUM VITAE
PERSONAL DETAILS
Full Names
: Ntomb’futhi Lydia Mvakali
Known As
: Ntomb’futhi
Nationality
: South African
Demographic
: Black
Languages
: English, Swati, Sesotho
CRITICAL CRITERIA
5+ years’ experience
SSRS, SSAS, SSIS
Microsoft SQL Server 2008 upwards
CAREER ACHIEVEMENTS
-
Being able to do a dashboard report for one client which lead the company to give me resource to do for all clients which also lead us from using SQL Agents to using SSRS
-
After my MCSE course, I was able to create packages for them which saved us time on monthly reports
QUALIFICATIONS
2006
Grade 12 (Matric)
(Obtained)
Mayflower Secondary School
2007
Advanced Diploma – Information Technology
(Incomplete)
Jeppe College
COURSES
Torque IT:
Microsoft Certified Solution Expert
Microsoft Certificate Professional
PROFESSIONAL AFFILIATIONS MEMBERSHIPS
Microsoft Certified Professional – 2016
Implementing a Data Warehouse with Microsoft SQL – 2012
Administering Microsoft SQL 2012
Developing Microsoft SQL Server 2012
Querying Microsoft SQL Server 2012
-
CAREER HISTORY OVERVIEW
Date
Company
Position
June 2017 – Present
Concourse IT, Randburg
BI Developer
Apr 2017 – June 2017
HNL Applications, Krugarsdorp
SQL Developer / SQL Report Writer
Nov 2012 – Mar 2017
Pinnacle Health Solutions (EOH), Waterfall
SQL / BI Developer
Jun 2011 – Jun 2012
Boleng Advisory Services, Randburg
Junior Programme
Nov 2009 – Oct 2010
Bheka Management System, Rivonia
Detail Checker
RECENT CAREER DETAILS
CONCOURSE IT, Randburg (Insurance)
June 2017 - Present
Position : BI Developer
Using (SSRS) to create reports
Using SSIS, creating packages to share data on clients Sftp sites (FileZilla)
Experience in creating and maintaining an extraction, transformation and loading process from source systems or files in various files. ETL (export and import data)
Creating Stored procedures , Triggers and views
Implementing Power BI
Querying the database
Creating Functions
Viewing and automating daily reports
Using Microsoft Excel 2013
Managing data from multiple sources including internal, external and third party data
Monitoring and maintaining the databases. Implementation and maintenance of database
Experience in creating and maintaining an extraction, transformation and loading process from source systems or files in various files. ETL (export and import data)
Tuning and Optimizing T-SQL queries to improve performance
Motivation for change: To grow, to learn more technologies and implement in the working environment.
HNL APPLICATIONS, Krugarsdorp
(Mining)
Apr 2017 – June 2017
Position : SQL Developer / SQL Report Writer
Using Dev Express to create reports
Using ETL (export and import data)
Database Development for clients
Querying, implementing and designing
Databases
Databases daily backups and recovering
Creating stored procedure, Triggers
Viewing and automating daily reports
Microsoft Excel 2010
Restore database
Creating packages using SSIS
Managing data from multiple sources including internal, external and third party data
Developing SQL stored procedures, views and triggers
Monitoring and maintaining the databases. Implementation and maintenance of database
Experience in creating and maintaining an extraction, transformation and loading process from source systems or files in various files / formats
Tuning T-SQL queries to improve performance
Motivation for change : Financial and job instability within company
PINNACLE HEALTH SOLUTIONS (EOH), Waterfall
(Financial Services)
Nov 2012 – Mar 2017
Position : SQL / BI Developer
Using SSRS 2012 for creating reports,
Using SSIS to create packages
ETL to import and export files
Creating interface files,
Database Development for clients,
Querying, implementing and designing
Databases,
Databases daily backups and recovering
Databases,
Creating stored procedure, Triggers,
Viewing and automating daily reports, - Creating SQL jobs using SQL Server - Agent and Microsoft Excel 2010.
Restore databases from backup
Morning checks on databases, to check if all is in order and applications linked to database are running correctly
Morning checks on backups, automating reports that run database backup
Managing data from multiple sources including internal, external and third party data - Developing SQL stored procedures, views and triggers.
Setting up reports to automatically run on a daily basis, to monitor and maintain the databases
Implementation and maintenance of database
Experience in creating and maintain an extraction, transformation and loading process from source systems or files in various files / formats
Tuning T-SQL queries to improve performance
Creating reports using BIDS or Report builder 3.0 (SSRS and SSIS)
Motivation for change : Future career growth goals were not aligned with company plan
BOLENG ADVISORY SERVICES, Rivonia
(Retail)
Jun 2011 – Jun 2012
Position : Junior Programme (Internship)
Helping in database development, coding using asp.net, c#, .NET, html and java script
Extracting simple queries, application development using same languages above mostly exposed to application design
Motivation for change : Internship came to an end
