The Data Services Manager is responsible for all aspects of data architecture, including developing the overall data architecture strategy and creating and maintaining standards and best practices for data provisioning and data integration. The role acts as the data custodian and subject matter expert with the organisation to ensure data goals and objectives are met.

At Rest I was responsible for their Marketing Automation, using the MarketFirst product.Documentation, support and ongoing customisation of the transformation (ETL) of data from the transaction application to the operational date store and CRM databases.Corrections and enhancement to the SSIS and SQL transformations.

Renovations; new gutters and painting.Skippering and Instruction for Sydney By Sail.

WSN was a small team so the application manager’s role was hands on, and encompassed all facets of the project life cycle, including: requirement and functional specification, project management, script development, product selection, test plan development, testing, user training and support. Completed the rollout for SITA of the Mandalay weighbridge application across Sydney. Managed the UAT, conversion verification and the user training. Wrote the integration specifications, numerous functional specifications (the application was not a good fit), the system and user test plans. Seconded a group of three operators to assist with testing, the user training and the site implementation and post implementation support. The System and User testing raised three hundred and forty issues with the vendor. Liaised with the vendor PM and developers to correct or improve the applications functionality and performance. SITA weighbridge application selection visited the sites and wrote a functional specification for the existing application.Working with a developer designing then developing a dimensional data warehouse for transactional reporting. Wrote over eight hundred Microsoft SQL queries for users and management. Used Microsoft Analysis Services cubes to assist with the sale of WSN to SITA.Search, selection and implementation of Pivotal CRM for Customer Service. Search, selection and Implementation of RAMS for the collection business.Ran a project to enhance the RAMS collection application for waste clean-up bookings for over one hundred thousand Sydney residents. Process mapped the first major council collection contract. Managed the data take on and cleansing for this and subsequent councils.Other Process Mapping for:- Council Clean-up bookings, Price rises, and Customer complaints.Project managed several upgrades to the Wasteman weighbridge product, including significant improvements.Completed the rollout of the Wasteman weighbridge app across Sydney.

Responsibilities:Support of the cheque printing infrastructure, the Client Document Project. Development of UNIX scripts.Project management of the Solaris and Dazel upgrades.Co-ordination of the printing services for the Business Continuation Project.Documentation of existing procedures.Project to evaluate the future ownership and management of the Client Document service.

Data Warehouse:Reader’s Digest Continuity Product Lines data warehouse, designed and implemented. Database/Functional designs:Business Process Measurement.E-mail names promotion and results databaseReader Services.Product Forecasting and Product Stock and Price enquiry.Database to Database reconciliation product.Responsibilities:GST implementation started project with a successful pilot mapping exercise with the board. Then facilitated the process mapping of every significant business process with a focus on those with external financial transactions. This resulted in an eight hundred-task project plan and a successful, thorough, and problem free GST implementation.Successfully Project Managed the Y2K Oracle Financials project, this project had a very tight time frame as all efforts had been directed to the mainframe systems. Completed in two months, testing all functionality including 3-month ends and a year-end rollover.Designed the Datawarehouse for the Continuity Product line, specified the use of a Dimensional Data model and lead the design. This was the first Datawarehouse implemented globally and is now being implemented in other countriesDirect supply from manufacturer project, complete the process maps, cycle time simulations, functional and technical specifications.Vantive CRM project he was the business project manager for this project UML was used to document all the business processes Project failed when vendor could not get the daily data exchange performing in a timely and reliable fashionBuilt a pilot BPR measurement database in Microsoft Access. This database reported on the effectiveness of each process improvement initiative against targets. The successful pilot was migrated to Hyperion Essbase.Trustee of the RD superannuation fund for eighteen months.Outsourcing of outstanding debt collection completed the vendor comparison worksheets and technical specifications.

Database design:Customer Statement reporting database, and extensive data dictionary.Wrote the naming/design standards for the database and dictionary. Developed templates for the creation of tables, keys, constraints and indexes. Responsibilities:Project managed the Superannuation Statements and customer documents project, $500k, 6 people, 9 months. Project successfully completed for the year-end statement printing. Application improves customer service by giving the representatives access the exact document images as printed.Coded in VB6 numerous input/output routines, this relieved the workload on the team’s key VB developer.Created the data models (logical and physical) and Data Dictionary for the Bankers Trust Statement project. Creating standards for Data Dictionaries and for migration of data schema changes through UAT and into production.

Managed the national ERP (Promix) implementation (Sales Order Entry, Inventory, and Debtors).Process Mapping was used extensively for Process Improvement and Change Management.Process Mapped the Supply and Fix business, doubling the throughput.Developed and implemented a Transaction Processing Server within the Promix ERP.Developed capacity plans and hardware acquisition proposals.

I am responsible for all aspects of data architecture, including developing the overall data architecture strategy and creating and maintaining standards and best practices for data provisioning and data integration. The role acts as the data custodian and subject matter expert with the organisation to ensure data goals and objectives are met.

Successful conversion of their Securities Management database.Jointly responsible for the successful System testing of the conversion.

Wrote and tested transaction and report programs for their new Lending, Security and Asset recording system.Made significant contributions to their Database, Programming and Development standards. Completed performance tuning of their relational database.