Andre User

Migrated SAP Hana Data Analytics, Calculation Views, and BI Reports to Snowflake ELT and Reports. Converted code from SAP Hana to Snowflake, migrated Stored Procedures, views, data import, calculated views, and reports.

Set up and corrected local SSIS and BI development report environment, deployed BI reports to live server, and corrected C# SharePoint component in SSIS. Collaborated with COO, CEO, and director to present company profits and projected future profits using PowerBI Insights.

Worked as part of a 4-member team, assisting with IBM InfoSphere job analytics and code conversion tasks, migrating IBM InfoSphere DataStage Jobs to Snowflake, and creating training manuals for Snowflake Super users and Analysts.

Maintained database integrity, optimized SQL servers, and developed PowerBI reports as a senior DBA and BI developer.

Maintained database integrity, optimized SQL servers, and developed T-SQL queries to prevent server strain and improve query results for parcel tracking across South Africa.

Responsible for database performance maintenance, writing stored procedures, and developing new modules for Innova software. Also involved in general IT and server maintenance, network troubleshooting, and Pastel licensing and support.

Maintained and assisted with queries of SAS Business Intelligence Reports to Attorneys, SQL Server Integration for backups and importing of new data into their Legal Smartsystem.