Cecilia Mostert Email & Phone Number

Shoal Point, Qld, Au

Mackay, Queensland, Australia

Broadbeach, Gold Coast

● Development, testing and maintenance of: o Various ETLs (SSIS & SQL) feeding from various internal and external sources (CSV, Excel, JSON, XML, etc.)o Data process flows o Internal and external data feeds and integration o Data mastery processes (including VB forms for capture, SSIS for ETL, scripting and SQL for fuzzy matching, manipulation, mapping and morphing)o Monitors that report source system schema changeso Financial reports, daily statistics, performance reports, process tracking, leaderboards and ad hoc reporting (SSRS)o Dashboards (SSRS and Power BI)o Internal data management apps (VB forms & ASP)o Data Extracts● Data Standardization & Sanitation (Switching, Morphing, Hierarchies, Fuzzy Matching, Views etc.)● General business reporting and statistics (SSRS & Power BI)● Administrative reporting (SSRS & Power BI)● Performance tuning of stored procedures, functions, views etc.● Database administration & tuning. Index monitoring & maintenance.● Data recovery due to unforeseen problems such as instance failure related to space issues on server etc.● Data discrepancy audits (source systems)● Documentation of the ETLs, data flows, databases and architecture that underpin the reporting and business intelligence platform.

Southport, Queensland, Australia

Short-term Contract During COVID-19 Crisis Gold Coast University Hospital is a major health facility offering tertiary level health care for the Gold Coast, Australia.● Patient Master design & POC Build● Development & implementation of coding standards and conventions● Reconfiguration and standardization of existing SQL code● Refactoring of existing SQL code● Unit testing

• Hands-on design and development team lead for the Solar Master Data system (SQL Server 2012 / 2014 / 2016 (incl. MDS, DQS, SSIS and SSRS), QlikView, ASP.Net and Natural/ADABAS). • Hands-on team lead for the design, development and maintenance of the National Treasury Reporting facility (SQL Server 2008 R2 / 2012, VBA, ASP.Net). • Gather requirements from various stakeholders (Management, senior, mid-level and junior colleagues).• Analysis of source data• Data modelling and database design (relational (landing / staging) and warehouse (Kimball)) • Design and build ETL processes with SSIS to populate data from the source systems and source files into the landing and staging databases• Design and develop data cleansing, profiling and quality processes using the SQL Server DQS tools and services • Design and develop processes and objects required to populate the data warehouse with master data maintenance using SQL Server’s MDS tools and services. These include: T-SQL Queries, Stored Procedures, functions (scalar, table-based etc.), Triggers, Synonyms, Sequences, Views, User-defined Data Types, Hierarchical data structures, Common Table Expressions, etc • Publish the master data for consumption by reporting services (SSRS), analysis services (SSAS and QlikView) and self-service requirements.• Research and produce innovative solutions to business and technical issues• Conduct technical workshops• Mentor junior team members in one-on-one discussions as well as team discussions• Present proposed solutions and alternatives to stakeholders at all levels• Produce system documentation, e.g. business requirements, technical requirements (including ERDs, data transition graphs, integration models and database schemas etc.), process flows, templates, solution models, user manuals, configuration and standard guides, hand-over documentation etc. • Prioritize and delegate workload• Plan product upgrades and deployments• First- and second tier customer support

• Research and find innovative solution to business and technical problems• Mentor junior team members in one-on-one discussions as well as team discussions• Design, development and maintenance of programs and First- and second-tier customer support• Produce system documentation e.g. technical requirements, solution models, user manuals, hand-over documentation etc. • Develop and maintain the Revenue sub-system functionality (Natural/ADABAS), including database objects (Files, DDMs, FDTs, Locals, Include Code etc.), ETL, data extracts, reporting, statistics, error tracing, tuning and optimization, 3rd party system integration etc.• Production support for all functions of the Revenue sub-system (Natural/ADABAS)• Gather requirements from all stakeholders. (Management, senior, mid-level and junior colleagues).• Mentor junior team members in one-on-one discussions as well as team discussions• Share business knowledge and experience within our team, as well as with other teams.• First- and second-tier customer support

• Analyse, design and document various facets of the integrated AMARTA solution for life assurance.• Configuration management, including the inception and documentation of all standards and naming conventions etc. (ORACLE database on UNIX platform).

• On-site development and maintenance of the Revenue sub-system specifically for the client as required, (file design, ETL, data extracts, reporting, statistics, error tracing, integration with 3rd party systems etc.)• First-tier production support for the Venus Revenue system at City of Johannesburg (Natural/ADABAS)• Stand-by for site manager (Allocate tasks to team members, mentor and facilitate development efforts)• Gather and document requirements from all stakeholders. (Management, senior, mid-level and junior colleagues).

• Gather and document requirements from all stakeholders.• Analyse data and requirements. • Design, document and develop an intelligent ORACLE 9i database to support a new bucket ordering system.

• First-tier production support for the legacy production system. • Hands-on team lead for re-development of the commissions system.• Gather and document requirements from all stakeholders • Data analysis, system analysis, design, documentation, development, implementation and maintenance of functionality for the New Business capture system (Clipper) and AMARTA (Oracle)• Design and develop integration between legacy systems and the AMARTA system. • (ORACLE, Clipper, dBase, Delphi)• Design and develop a Delphi system for the tele-servicing department to service queries (IVR) • Design and develop portions of the Underwriting system (Clipper) • Research and find innovative solution to business and technical problems

• Develop and maintain functionality for the Venus Revenue sub-system, including ETL, data extracts, reporting and statistics• Gather requirements from all stakeholders.• First-tier production support for the Venus Revenue system (Natural/ADABAS) • Standby for departmental manager (Maintain databases, monitor and resolve UNIX-related issues, allocate tasks to team members, mentor and facilitate development efforts)

• Develop, tune, deploy and maintain functionality for the student system, the registration system and the asset system from specifications received from my supervisor. These systems were developed with Natural/ADABAS.

Bachelor Of Science (Bsc) Hons, Information Systems

Bachelor Of Science (Bsc), Information Systems

National Diploma Data Processing

Matric