Ernest Smith

Ernest Smith

Cape Town, South Africa
Hire Ernest
Scroll To View More
Ernest Smith

Ernest Smith

Cape Town, South Africa
Member since April 9, 2015
Ernest began his career as a computer operator, but then transitioned to a programmer and finally a systems analyst. Using his evolving skill set, he started his own fraud prevention software company with two friends. Ernest also has experience in stock trading and IT.
Ernest is now available for hire
Portfolio
Experience
  • T-SQL, 20 years
  • SQL Server, 14 years
  • HTML, 8 years
  • JavaScript, 5 years
  • CSS, 5 years
  • Bootstrap, 3 years
  • jQuery, 3 years
  • Perl, 6 years
Cape Town, South Africa
Availability
Part-time
Preferred Environment
Windows, Linux, Visual Studio, Eclipse, SVN, Git
The most amazing...
...thing I have developed is a complete workflow system based on Petri Nets used by the Receiver of Revenue. I adapted the system to be used as a decision engine.
Employment
  • Database DEveloper
    Peak Games
    2015 - PRESENT
    • Worked on the performance issues the client had that were associated with their data warehouse.
    • Recommended a star schema design.
    • Analyzed the worst performing queries.
    • Looked at using newer technologies.
    Technologies: Vertica
  • Senior Systems Architect/Developer
    RevenueRED
    2008 - PRESENT
    • Developed mobile phone applications for Windows Phone and Web.
    • Developed a decision engine for financial processes.
    • Designed and developed a Revenue Recovery System.
    • Designed and developed a workflow solution for large companies.
    • Helped design a scorecard system for retailers.
    Technologies: SQL Server, HTML, CSS. JavaScript, .NET, C#, Perl
  • SQL Developer
    Artificial Medical Supplies (via Toptal)
    2015 - 2015
    • Addressed a large amount of deadlocks that the client had that were impacting performance and data integrity.
    • Monitored the database to get to the root cause.
    • Identified the root causes and implemented a strategy to fix the problem.
    • Successfully implemented my recommendations to the client's satisfaction.
    Technologies: SQL Server Database, .NET Framework
  • Database Developer
    GIS Workshop, LLC (via Toptal)
    2015 - 2015
    • Client needed to consolidate their database with that of a third party.
    • Normalized the third party database.
    • Made the third party relational database.
    • Developed upload processes for the client and the third party's data.
    • Added a relationship between the databases.
    Technologies: SQL Server Database
  • CEO
    ATC Clearing Centre
    2004 - 2008
    • Involved in all aspects of application development including project management, system design, analysis, application development, testing, and implementation.
    • Managed version control.
    • Maintained the company's image.
    Technologies: Visual Basic, SQL Server
Experience
  • Mobile Field Worker System (Development)

    This system sends tasks to a mobile device from a web interface. The mobile worker is tracked and his location recorded periodically. When the worker completes a task, the results are transmitted to the controlling system for immediate processing. The worker's progress is monitored and if need be new tasks can added to the mobile device and existing tasks can be withdrawn.

  • Workflow System (Development)

    Dynamically designed and versatile workflow system that has been used to perform the core functionality of an Estates Tax System. Implemented systems include Insolvency Tax System, Municipal Revenue Protection System, Score Card System, and Financial Management System to name a few.

  • Decision Engine (Development)

    Designed a versatile decision engine which accepts rules in XML and makes decisions based on these rules.

Skills
  • Languages
    T-SQL, COBOL, CSS, JavaScript, JCL, HTML, PL/SQL, C#, Perl
  • Tools
    Visual Studio, Git, Eclipse, VisualSVN, Microsoft Project
  • Storage
    SQL Server, MySQL, DB2, Oracle
  • Frameworks
    ASP.NET, Bootstrap, AngularJS, .NET
  • Libraries/APIs
    jQuery, Facebook API
  • Platforms
    Windows, Linux, Windows Phone, Android
  • Paradigms
    Scrum
Education
  • Cerificate degree in Computers Analysis Design and Development
    Computer Users Council - Cape Town, South Africa
    1995 - 1995
  • Diploma degree in Datametics
    Unisa - Pretoria, South Africa
    1992 - 1993
  • Cerificate degree in Computer Programming
    Computer Training Academy - Cape Town, South Africa
    1989 - 1990
I really like this profile
Share it with others