Franco Gates Email & Phone Number

City Of Johannesburg, Gauteng, South Africa

Data specialist.SQL specialist.SSRS & Power BI specialist.ETL specialist.Automation innovator.Experience in Insurance, Banking, Debt Collection, FMCG, Logistics, Inventory, and Manufacturing.

Roodepoort

- Onsite frontline server, client and website support to client Nedbank for their customized Sybrin solution (cheque signature verification)- SQL data analysis of the Sybrin solution for history, trends, data clean-up- Power BI development and ETL for near real-time solutions for current day monitoring- Implementation/Changes/Support of the customized solution - Coding for Building/Configuration/SQL queries/Report designs - Using SQL, Sybrin 7, C#, VBScript in solutions

Sunninghill

- Analyse and test new and existing versions of the SYSPRO software- Comprehensively testing the software front-end, SQL and C-ISAM database backend, and the XML business objects- Collaborating with developers to effect the quality and robustness of the product- Ensure compliance with business practices- Ensure compliance with SYSPRO standards

Centurion

- SQL report development, maintenance and improvement- Data take-ons: migration of a company’s in-house database system into SQL and integration into the Excalibur debt collection software (data import/export, bulk data analysis and movement)- XML scripting for SQL reports- “Outside-the-box” solution development within a Windows and SQL environment; automation and integration of file management with SQL

Midrand

- Creating and managing the reports for the purchasing of materials for the clients’ item range needs- Creating and managing the reports for monitoring the efficiency and disposal of excess & expired materials- Coordinating the monthly MRP run- Coordinating the bill of material changes to products- Managing staff to achieve the Inventory objectives & maintaining healthy relationships with departments (Buyers, Client Services, Costing and Warehouse)- Systems used: SQL Query Builder; Syspro; advanced excel with SQL queries, formulas, vlookups & pivot tables; various in-house platforms, DemandSys.

Midrand

- Resolution of daily stock variances across the 3 companies KFC, King Pie & Managed Freight- Maintenance of the ERP (Warehouse Management System) software from a stock, warehouse structure and system development point of view- Coordination of a comprehensive damages management process- Extensive use of excel pivot tables and vlookups for financial & capacity reports, forecasts and large data historical investigations drawn from the Great Plains/Dynamics platform- Daily & weekly financial adjustments and posting to ledger accounts for stock balances on Great Plains- Tracking & auditing the Purchasing manager’s stock holding levels to balance safe holding within DC capacity, and date rotation

Midrand

- Movement, placement and flow planning of all JHB Clicks stock- 6000+ SKUs: approx value R500 million DC- Resolving all internal and external stock queries- Auditing all departments (Receiving, Macops, Inventory & Picking) towards process compliance- Compilation, analysis and communication of stats, graphs, forecasts and reports regarding the DC position daily, weekly, monthly & quarterly- Understanding and effecting the end KPI of DC Shrinkage- Accountability for the Inventory budget

Bsc, Informatics

C# Programming Certificate, C#

Microsoft Certified Technology Specialist (Mcts), Sql Server 2008

SQL Server 2008, Business Intelligence Development and Maintenance SQL Server 2008, Implementation and Maintenance

Education record

Investment & Share Trading Seminars (x7 complete) Institution: CTI (19 November 2001 - 16 October 2002) Qualification: Information.