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.