Thato Mantai

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. Application 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.