Hire the Best Stored Procedure Development Specialists
in South Africa

I have been designing databases using Microsoft Access, SQL, C#,, VB and VBA for the past 20 years and can create, customise or amend any Access or SQL/ MySQL database as well as develop front-end applications in .NET or Access. I have developed many databases for such a variety of industries. I have expert knowledge of Excel, Access and Word, including VBA. I have 20 years plus corporate experience in the financial industry using Excel and Access for data modelling and calculations as well as creating complicated Word templates - both for corporate identity and for purposes such as bulk mail merging from client databases. I develop SAGE ERP (Accpac) SQL integration using the Accpac API's within Accpac VBA as well as bespoke app development for SAGE Accpac using C#, VB.Net, VB.6.0 and Microsoft Access. I also have databases that connect directly to PASTEL and enable you to directly Email and SMS your clients from the database for bulk marketing campaigns. Other specialties include Excel financial modelling, automating PowerPoint reports from Excel data as well as creating corporate identities by creating Word templates, TRAINING: I can design customised Excel, Access, Word and PowerPoint training courses based on the needs of your business. With 28 years training experience under my belt, including many years of training needs analysis, it has been proven to me that creating customised training programs rather than sending staff on the standard scheduled course can increase the learning absorption by more than double! I have developed all sorts of courses for many corporate clients – in South Africa, the UK and in New Zealand. In order to make sure that any training down is specific to your needs I can: Identify the training need by means of a TNA (Training Needs Analysis questionnaire or direct questions to identify the specific training requirement). Design the customised course specific to the training need identified Schedule the training – either one-one-one or in small groups. Provide telephone support and backup once the training is complete. Computer Skills: SQL Server programming and administration C# and VB .Net programming Visual Basic 6.0 programming Access Database design & VBA programming Excel VBA programming & templates Word VBA macro programming & templates Microsoft Access – all versions Microsoft Excel – all versions Microsoft Word – all versions Microsoft PowerPoint – all versions Microsoft Outlook – all versions Training Skills: Training Needs Analysis Train the Trainer Microsoft Office (all levels, all versions including Word, Excel, PowerPoint, Outlook and Access) Visual Basic for Applications (Word, Excel, PowerPoint, Outlook and Access) Technical Writing Skills: Courseware (manuals and exercises) for all the above courses as per the MOS syllabuses set down by Microsoft. Instructor notes and reference manuals. Database technical manuals to accompany database projects. Database user manuals to accompany database projects. Training and Work Experience: I have been training delegates to use computers for the past 28 years. I have experience in teaching in South Africa, the United Kingdom and New Zealand and have taught learners from all walks of life. I have been creating database and software systems using VB.Net and SQL Server since 2000. More details of my work experience are available on request.

How I Can Help: I have over 15 years experience providing Data Management services and ERP support to help organizations in turning complex, and messy data into clear, and actionable insights that drive better decisions, thereby improving operations, and unlocking growth. Whether you need reliable analytics, data quality, scalable data models or structured reporting, I bring clarity and control to your data environment. What I Do Best: * SQL Development & Data Analysis * Excel and Power BI Dashboards & Reporting * Data Profiling, Quality & Governance * Data take-on * Data Modeling (Conceptual, Logical, Physical for ERD, Dimensional and Data Vault 2.0) * ETL and Data Integration * Source-to-Target Mapping & Data Architecture * Business & Data Requirements Translation Real Business Impact: I’ve worked with large enterprises including the South African Reserve Bank, ABSA Bank, and Transnet to: * Enable effective, efficient data sourcing and lifecycle management – (Collect once, use many) * Remove data silos by modeling the data into optimized structures and integrating the data * Improve data quality and trust across business units * Enable real-time and strategic decision-making using data * Streamline reporting and reduce manual processes * Build scalable data platforms for mature advances analytics Proven Results: * Designed enterprise data models supporting critical financial and operational systems * Delivered dashboards and analytics solutions used for executive decision-making * Reduced reporting errors by identifying and fixing data pipeline issues * Improved data processing efficiency through optimized SQL and ETL workflows * Enabled better visibility into operations through structured, high-quality datasets Why Clients Choose Me: * 15+ years of real-world experience across banking, utilities, and enterprise environments * Strong ability to bridge business needs and technical solutions * Detail-oriented with a focus on data accuracy and reliability * Clear communicator who can explain complex data in simple terms * Proven ability to work independently and deliver high-quality results Typical Projects I Handle: * Data take-on and integration * Data cleanup, validation, and quality improvement * Integrating multiple data sources into a single reporting layer * Designing data models for reporting and analytics * Data manipulation using SQL, Excel etc. * Report and dashboard design from raw or unstructured data * Fixing broken or inconsistent reports (“why don’t these numbers match?”) Let’s Work Together: If your current solution is: * Producing inconsistent or unreliable reports * Too manual and time-consuming * Lacking visibility into key business metrics * Struggling to scale with growing data * Difficult to understand or poorly structured

I am a Database Engineer and SQL Specialist with a background in Business Analysis and IT. I have a strong foundation in Business Information Systems, business informatics, and data-driven decision-making. I work at the intersection of business and technology, translating requirements into practical system and process solutions that support organisational goals. I have experience supporting CRM and business application implementations, with a focus on requirements gathering, business process analysis, system configuration, and process optimisation. I enjoy analysing how people, processes, and systems interact to drive efficiency and performance. Alongside my industry exposure, I am also an IT Lecturer, teaching Business Information Systems, SQL, database systems, and networking fundamentals. This has strengthened my ability to communicate complex technical concepts clearly and collaborate effectively with diverse stakeholders.

I help businesses translate how they actually operate into documentation their teams can use - closing the gap between complex operating principles and practical, frontline-ready tools. My background spans chemical engineering, large-scale manufacturing operations, and professional services - which means I understand both the technical depth and the human reality of how processes need to work on the ground. What makes my work different is that I don't just write procedures. I study how a business operates as a system, identify where documentation is creating friction or dependency, and build tools that give teams genuine autonomy. The result is documentation that reduces founder or manager involvement without sacrificing quality or consistency. My experience includes: Translating a complex, enterprise-level manufacturing operating system into practical frontline tools for production operatives - making high-level operational principles usable at the point of work. Developing laboratory equipment SOPs that balanced technical precision with clarity for daily users - ensuring compliance without creating documentation that sat on a shelf. Creating frontline-facing SOPs for production environments where speed, clarity and decision-making under pressure were non-negotiable. Currently working with a professional services firm to build their full operational documentation suite - spanning customer journey, billing systems, collections processes and business development - with a specific focus on reducing founder dependency and building a connected system rather than isolated procedures. I work best with: Business owners who have outgrown informal ways of working and need their operational knowledge captured and systemised. Teams that need documentation built around how they actually work, not theoretical compliance frameworks. If you need someone who can hold the big picture and the detail at the same time, let's talk.

Do you have complex business workflows, enterprise data challenges, or a need for custom Oracle applications that meet strict regulatory requirements? I am a Senior Oracle Solutions Architect with over 15 years of experience building scalable, secure, and high-performance enterprise systems. I specialize in bridging the gap between business logistics and technical execution, ensuring that your software isn't just functional—it’s audit-ready and built to last. My Core Expertise: Oracle APEX Development: Modern, responsive, and data-driven web applications designed for complex business logic. ERP & EBS Integration: Deep experience integrating Oracle E-Business Suite with custom solutions, ensuring data integrity across financial and supply chain modules. Enterprise Logistics & Warehousing: Proven track record in developing systems for bonded warehousing, inventory management, and import/export logistics. Compliance-Focused Architecture: I design with compliance in mind. Whether you are dealing with CQC, financial data, or sensitive enterprise information, I bake security and auditability directly into the system architecture from day one. Why work with me? I don’t just write code; I architect solutions. I understand the "big picture" of your business operations—from financial capitalization to multi-tenant user security. My goal is to provide you with a robust system that simplifies your operations and scales with your growth. Let’s discuss your project. If you need an expert to untangle a complex database challenge, modernize a legacy system, or build a secure, mission-critical application from the ground up, let's connect. I am ready to bring my 15 years of Oracle experience to your next project.