Data Engineer
Request a quote with no obligation
Over 18 years of extensive work experience as a SQL Server Developer and in depth proficient experience in Microsoft Business Intelligence stack, OLTP, Operational Data Source (ODS), Tabular & Multidimensional Modeling, Performance Tuning, Data Warehouse, OLAP and database technologies. Demonstrated expertise in designing, developing and deploying Business Intelligence solutions using SSIS, SSRS and SSAS in BIDS.
Experience in installation, upgrade and configuration of Microsoft SQL Server databases. Over 15 years of extensive experience in T-SQL Programming in developing Stored Procedures, Views, Triggers, User defined functions, cursors, derived tables, common table expressions (CTEs) XML and Complex Queries on SQL Server 2000/2005/2008/2012/2014/2016/2019. Broad experience in Query Optimization and performance tuning of TSQL stored procedures, functions, SSIS packages, SSRS Reports etc.
Over 3 year's Strong experience in SSRS development skills, experience including tablix, Matrix, chart, graphic scorecard reports, Performance Summary Dashboards, sub-reports.
Experience in creating Adhoc reporting ready universes using Business Objects Universe Designer. Have good understanding of Tableau architecture, development and end user experience.
Clusters specializing in tuning & monitoring of high availability in Oracle & SQL Server. Over 4 year's experience in utilizing ETL tools, including SSIS, DTS and ETL Package design.
Experience in maintenance and Administration of SSIS by creating Jobs, Alerts, SQL Mail Agent, and schedule DTS/SSIS Packages through scheduler such as Autosys and SQL Server Agent. Over 3 year's experience in SSAS (SQL Server Analysis Services) 2000/2005/2008/2012/2014/2016/2019. Have good experience with designing and implementing MDX queries, OLAP architecture, MOLAP, ROLAP and HOLAP.
Experience in development of coding in VB.NET, C# while working with SSIS. Interaction with the Users and Business Analysts for better understanding of business & reporting requirements.
I am a problem-solver with a strong inclination towards numbers. My strengths are in SQL, Data Warehousing, Business Intelligence, and the delivery of data (analytics and insights), and data visualization. When not structuring and manipulating data structures, I am usually playing around with scripting languages such as Python, Ruby, and JavaScript, frameworks, and libraries such jQuery, AngularJS, React and Backbone, Cordova/PhoneGap.
My areas of expertise include Strategic Domain Requirements Gathering and Business Case Development, Program and Project Planning and execution, Business Process Analysis and Design, Business Intelligence Solution integration and Architecture, System configuration and Implementation, Training, and Facilitation.
I have extensive experience in understanding a client’s problem space, the business drivers, and transforming them into concepts and models that are easily understood. I have excellent communication skills, both written and verbal, and possess a thorough understanding of the role technology plays as a business enabler.
My experience and background span across Banking, Retail, Finance, and Education, and Insurance industries.
Degree/Diploma/Training CoursesInstitutionYear CompletedHonours Degree University of Western Cape CurrentISETT-SETA IT Engineer Skills Development Programme Prestige College, Cape Town,December 2003Information Technology – National Diploma Technikon Witwatersrand, JohannesburgDecember 2001
MatricUnicom High School in Tweespruit (Free State)December 1997CertificationCertification NumberCertification/VersionAchievement DateMicrosoft Certified Solutions Associate (MCSA)E134-9747Windows Server 201201/18/2013Microsoft® Certified IT Professional ﴾MCITP﴿D502-6095 SharePoint® Administrator 201009/29/2011Microsoft® Certified Technology Specialist ﴾MCTS﴿D501-2548SharePoint® 2010, Configuration09/29/2011Microsoft® Certified Technology Specialist ﴾MCTS﴿D494-9334SQL Server® 2008, Database Development09/22/2011Microsoft® Certified Technology Specialist ﴾MCTS﴿D398-4785SQL Server® 2008, Implementation and Maintenance06/30/2011
Exam IDDescriptionDate Completed70-417Upgrading Your Skills to MCSA Windows Server 2012 January 18, 201370-667TS: Microsoft Office SharePoint 2010, Configuring September 29, 201170-433TS: Microsoft SQL Server 2008, Database Development September 22, 201170-432Microsoft SQL Server® 2008, Implementation and Maintenance June 30, 201170-668PRO: Microsoft SharePoint 2010, Administrator January 24, 2011
