Michael Hamilton

CV. Michael Hamilton Architect PERSONAL DETAILS Last Name: Hamilton First Name/s: Michael Nationality: South African ID Number:- Location: Cape Town Gender: Male Race: White Languages: English PROFILE SUMMARY Overview: 23 + years of IT experience. Highly skilled Technical resource, with experience in most technologies available in the IT sector. Hard working and delivery orientated, self-starter, and dedicated. Managing Director and Co-Founder of DataSimplified PTY (Ltd) – Start up delivering services in Data Solutions to the SME and banking market. Specialising in Data Integration, ETL and BI with DWH. Responsible for all aspects of the business, including growing and implementing a partner network (IBM, Microsoft, Clover ETL, Ab Initio, Tableau, Dundas, ACI, etc.), business development, and Product management. New product creation (SaaS), Product life cycle from inception to deployment of SaaS solution in the Human Resources sector. Taking our Banking customer to next levels in reporting and business process improvements. Being appointed as the Innovation and Technology partner for our banking customer after implementing a Data Quality, Data staging, Enterprise Data Warehouse and Universal sub leger solution to allow universal reporting across all banking alliance partners and internal core banking systems. Also implementing a new communications platform to allow integration between the banks and the central clearing house in South Africa (BankServ) for all electronic interactions. Have experience on all levels of Development (Back end, Front end, DB, ETL, QA, Mobile and also Application Support). Working in Agile and Waterfall project delivery on medium to large scale projects. Have extensive experience in IT and support for company IT systems, from servers (VM and Physical) to networks, vendor management and other IT supporting services. Past role at Syntell (Pty) Ltd in Exco roll and managing 3 business units, eCommerce, Centralised Development and Group IT services (CIO). Implemented all standards required to turn around the Development and IT divisions that was not performing. Initiation and design of a new B2B eCommerce Platform for B2B services (SaaS) and implementing new technology platforms like Nutanix (Hyper Converged platforms) and VOIP phone system. Upgrade of IT Infrastructure and IT Strategy to future proof the systems. Reduce Fraud and loses on e-Commerce business by 90% in 6 months. Implement new online payment integration to reduce PCI compliance and reduce settlement issues. Was responsible for the Design of the Customer 3D ETL layer for Vodacom (Vodafone) before starting at Syntell. Many years of experience in Integration between different systems and technologies, including Mobile to Enterprise back end systems, enterprise to enterprise systems, Web to Enterprise systems, etc. As a Solutions Architect the requirement is to visit potential customers and understand their needs and problems, come up with solutions that address these in a cost effective and simple (but robust) solution. Was responsible for the delivery of an International Development Project to Saudi Telecoms Company, with remote development from South Africa to Saudi Arabia. Delivery roles on project included face to face meetings with customer (at Director Level), Technical lead, Project management, onsite FAT and UAT testing cycles, and new Business Development opportunities. (Technologies involved: Ab Initio, Siebel, Teradata, GoldenGate, Data stage) Responsible for Development, Maintenance and Support (3rd level) for Vodacom Back end systems, as well as implementing the new Customer 3D architecture. EDUCATION & QUALIFICATIONS Date Institution/Organisation Degree/Diploma/Certificate/Course/Training 1994 - 1996 Cape Town Technikon Electrical & Electronics Engineering (S1 - S3) 1993 Western Cape Technikon Electronic Engineering (N2 - N4) 1988 - 1992 Durbanville High Senior Certificate (STD 10/Matric) OTHER QUALIFICATIONS Date Institution/Organisation Certificate/Course/Training 2002 Bytes (Internal training) Logistical management (Parts storage & returns) 2001 Bytes (Internal training) Soft Skills Training 2001 Bytes (Internal training) Management 2000 CTIQ MSCE +I, IT - Networking 1998 Spicer Specialised Services A+ and N+ certifications PROFESSIONAL EXPERIENCE August 2017 to - Present DataSimplified PTY (Ltd) Roles: Managing Director Shareholder Co-founder Responsibilities/Contributions: Started a new company called DataSimplified. www.datasimplified.co.za Data Simplified focus on ETL and other Data Services in a consulting space, focusing on the Financial sector with most development done for banking customers. Company budget, Forecasts, etc. Company Finances and accounting Company Registration and other Regulatory requirements. Customer management Contractional responsibilities New contracts – Support, Operational, other agreements Negotiate, draw up, sign, etc, Proposal writing for customers Project managements Solution Design Partner engagement – Partners are Microsoft, IBM, Clover DX, Tableau, Dundas, etc. Management reporting New Sales and Business Development Company Agreements like Rental, Infrastructure, etc. Marketing Online for products and company services Website design and implementation Product management Product road map define Develop new SaaS offering (HR Simplified) Manage company delivery against Budgets Company Strategy Implementation and reporting on Strategy First year of operations R5.8 million in revenue. Reason for leaving: Still employed PROFESSIONAL EXPERIENCE February 2015 to – August 2019 Syntell PTY (Ltd) Roles: General Manager eCommerce (payCity and related services) General Manager Group IT General Manager Development Responsibilities/Contributions: Development of a new eCommerce offering for Business to Business offering called www.paycitybusiness.co.za that deliver Fleet management solutions for business/fleet owners in 9 months, while still supporting the existing Consumer eCommerce offering www.payCity.co.za As General Manager at Syntell you are part of the Executive team, reporting into the CEO of Syntell. The eCommerce and IT divisions at Syntell was in need of a strong IT and Development person to correct the lack of Processes and Standards implemented in their systems and environments. (Some IT and Development project was outstanding for more than 24 months) Most time was spent redesigning the Server platforms and networks layout to cater for Disaster failover and stability. Main production datacenter was built at Teraco and business critical systems was moved to Teraco for availability. New Hyper Converged platform was installed to cater for all ways on servers. (Nutainx was implemented). New Firewalls (GateProtect) installed and corrected all Security vulnerability on the network Project for replacement of Core network switches because of stability and complex network setup that as designed over 10 years. All IT process was implemented, including new standard forms like Change Requests, capacity planning, monitoring of critical systems and reporting to Executive level. Currently implementing ITIL v3. Development division was totally lacking any structured development methodology, this was corrected and standard SDLC processes was implemented with very good results on delivery. A mix of Agile and Waterfall project deliver was designed and implemented to support the 51 Development resources that deliver on the more than 10 products that is under constant development. Production systems was stabilised and upgraded to the current versions of Windows and other OS. Code repository was implemented, centralised document store was implemented, as well as standard Document templates. Coding standards and other frameworks were implemented. Great focus on a new Data warehouse that was created for Reconciliation processes between different payments systems. PCI compliance was reduced to a lower level by implementing a Redirect payment method rather than a direct payment method, removing the requirement to store Credit card details. The Development division performance increased so much that Company Development has just been centralised and moved under Development Division as a Delivery into the company. Reducing the outsourcing of development work to partners drastically, hence reducing overall cost. Current projects include centralisation of Systems and platforms to enable automated DR Failover. (Developing a load balancing layer to introduce automated fail over between Biztalk switching environments) Implementing VOIP phone platform to increase Unified communications, and reduce cost of communications. Linking all 8 national branches onto the same platform reduced external calls to internal dialling (Reduced expense) Development of a Sighting system using images from Vehicles sightings to identify Cloned number plates being used on the roads by different vehicles. . eCommerce strategy Development strategy New Design and development of payCity Business B2B offering (Just launched in August 2016) Group IT Strategy (Acting CTO position) eCommerce budget Development budget Group IT budget Reason for leaving: New opportunities PROFESSIONAL EXPERIENCE October 2004 to – Feb 2015 Altech ISIS/ Altech Swisttech (sub-contracting to Vodacom) Responsibilities/Contributions: Company IT IT Support teams Design of IT systems Vendor management Management of ETL, Front end, Back End and Database Development Teams Design and Architecture od Development systems and Products Performance considerations Data Modelling, Integration and BI Mediation – ABMED project Subscriber Mediation Project to deliver current and historical views of subscriber/ customer systems including GAP analysis and completeness checking. 700 million customer profiles in the profile store. Solution Architecture role on all projects in the Business unit, and also new business opportunities where a Solution is required by a customer Integration Responsible for High Usage reporting project – solution integrates with Microsoft Exchange Server and downloads mails from external sources, strips Excel and CSV attachments, processes data. Data is then enriched from an External Subscriber Mediation system and rated against different exchange rates to calculate total spend per customer based on different tariffs and profiles. Responsible for XDR project –solution takes the data from Mediation systems via data queues, network data and subscriber data. Data is loaded onto Sybase IQ and Oracle databases while updating control tables for reporting purposes. Responsible for Billshock system – when a customer requires his usage to be analysed. Solution connects to 7 external data sources to collect data per customer to correlate all data sources for the customer’s reporting purposes. Responsible for the Party Subject Area -In the Enterprise Data Warehouse (EDW) the full Customer 3D (360) is the “Party Subject Area”. All information related to Party (Name used to refer to a “Customer”), is calculated, loaded and enriched as required to build up a Single profile for all customers, taking into account the whole Enterprise Data Warehouse and all it’s subject areas. This solution is very complex with auto generated Surrogate keys, and pending data queues to cater for specific business needs and to ensure that the view of the Party (Customer) is exact and up to date at all times. Responsible for the delivery of a new Consumer Market product to Altech Netstar customers, this product includes a Website and a Mobile app, with a Tax logbook extension. Was involved in this project from Inception to design, UX and UI design, implementation, integration and final Delivery. Key technical role on product. Experience in managing different technology teams, like Front End development (ASP .NET, Silverlight 5, PHP, Java scripts, JSON), Mobile Development (HTML 5, Java Script), Back end Development (C/C++), ETL (Ab Initio, Clover ETL, MS SSIS with SSRS), Data Base (Oracle, MS SQL Server, MySQL) Many years of experience in the SDLC process, and defining the processes for better delivery (Currently busy with a CMMI adoption process, and earlier ISO 9000 implementation) Extremely knowledgeable on all IT related technologies, as required for a Solution Architect type of Role. This includes technologies like NFC, Mobile Wallet, Telematix systems, Big Data, Hardware and Software products, etc. Customer management CRM (International Customers) IT Strategy Development Strategy Technology Strategy Technologies used include: Oracle, Silverlight, Web Services, Ab Initio, C++, Sybase, Terra Data Warehouse Reason for leaving: would like a new challenge PROFESSIONAL EXPERIENCE January 1996 - October 2004 Sanlam – subcontracted via Bytes Specialised Solutions Project Manager: Responsibilities/Contributions: Responsible for the Sanlam National Desktop support contracts, and all Desktop customers of Bytes in Western Cape. Branch manager for Sanlam Head Office Onsite branch from where all Sanlam Operations were run (including an onsite Parts store, Workshop, and Call center) Responsible for Sanlam Head Office Onsite branch (All aspects of being a Branch manager) Responsible for the N1 City Desktop Technician teams for all Other Western Cape Desktop customers of Bytes. Responsible for suppliers relationships with IBM HP DELL LEXMARK Weekly reporting to Bytes on Sanlam SLA management, and other customers Reporting to Sanlam for all SLA calls Sanlam negotiations on new yearly SLA agreements Service Request management Warranty claims management Logistics reporting on Stock returns from Technicians (boot stock) Responsible for Compaq Carry-in warranty service for all Western cape consumers Customer management KPA’s for all reporting staff HR management for all reporting staff Team size N1 City Branch: 24 Team size Sanlam HQ Branch: 10 Total team size: 34 Reason for Leaving: retrenched SELECTED ACCOMPLISHMENTS 1. Currently responsible for the Design of the Customer 3D ETL layer for Vodacom that is being developed in Ab Initio 2. Was responsible for the delivery of an International Development Project to Saudi Telecoms Company, with remote development from South Africa to Saudi Arabia. Delivery roles on project included face to face meetings with customer (at Director Level), Technical lead, Project management, onsite FAT and UAT testing cycles, and new Business Development opportunities. (Technologies involved: Ab Initio, Siebel, Teradata, GoldenGate, Data stage). TECHNICAL PROFICIENCY Software: Windows (all versions up to 8.1), Microsoft Office up to 2013, SharePoint up to 2013, MS Servers (Most versions – Exchange, AD, SQL, IIS, etc.), Clover ETL, Ab Initio, Sparks EA Architect, Linux, Unix, Oracle, MS SQL, MySQL Hardware: Server Platforms, Internet connections (ADSL, Fibre, Copper DSL, Wireless), Mobile Technologies (2G, 3G, 4G LTE), Nutanix, SAN, GateProtect Industry Telecommunications industry: Networks, mediation systems, operational data stores, data warehouses, fraud investigation systems, Data analysis, customer management, Geospatial systems. Telematics (Vehicle Tracking) industry: Processing platforms, Special Database implementations, Integration between Telematics platforms and Map servers. Mobile app delivery, Big data initiatives Financial industry: Operational Data stores, Integration layers between systems. Online payment in eCommerce (iVery and myGate), PCI compliance Design, implement and run USL (Universal Sub ledger) at a banking customer, implement Enterprise Data Warehouse for Banking. Implement Open Banking API, as well as Generic BankServ communications platform for services. Media (News) industry: Consumer News portal and product development, Logistical stock tracking for street vendor, mobile payment integration, customer satisfaction survey systems Electrical Power Engineering: Quality of Municipal Electrical Power Supply system, with Operational Data Store loading, Data profiling, Reporting and Alerting eCommerce industry: payCity consumer (www.paycity.co.za), payCity for Business (New system), Fine payments, Prepaid Electricity vending Road Safety industry: Opus fine managing platform. (Life cycle management of Traffic offences), Traffic controllers and road side furniture, ASOD violations (Avg speed over distance), AARTO integration (RTIA and eNatis), Licence Disk renewal, Vehicles sightings systems.