Malcolm Speedie Email and Phone Number

Managing the team that provides workforce and organisational development data and analytics for over 60K employees working in public sector health in Western Australia.

Design, develop and implement new and enhanced business processes whilst managing functional activities associated with the overnight batch processing, for example pay calculation.Project management for business process changes (whether legislative, industrial, policy or administratively based) for application system projects, identify opportunities for business process improvement and initiate projects to make improvements with or without deployment through the application.Implement legislation, awards and agreements into the Human Resources Management Information System.Develop and maintain knowledge of client business processes in relation to human resource management and make an active contribution to the improvement of these processes.

Product design, database design, overall architecture of data objects.Lead the design of how we identify, process and update data as part of the dgMasker and dgDiscover product lines.Developed over 10,000 lines of sophisticated PL/SQL code.Guided the DBA in best practices for our Oracle instances.Mentored best development practices including code walk through and QA.Developed technical documentation, test plans and end user documentation.Developed data feed to Dashboard.Evaluated third party tools to expand our database repertoire.Worked with both Oracle (11 and 10) and DB2 (9.5, 9.7).

Provided technical support of Discoverer, Oracle HR, Self Service HR, Compensation Workbench, HR2R, and XR2R.Assisted with the System documentation, Business Requirements, Functional Requirements, Technical Requirements, Quality Assurance as well a deployment of numerous enhancements to interfaces, reports, data loads and task automations.Provided guidance, oversight and mentoring on best practices.Scrum Master working with local and off-shore team.Developed and managed AME set up.Managed reporting for HR including Discoverer setup and Administration.Trained in Agile development and changed our processes to be scrum based.Completed ITIL training and steered our processes to match the ITIL model.

Helping clients with Business Analysis as it relates to Human Resources, specifically using the Oracle HR application as the primary technical framework.

Provide technical support of the Oracle HR, Application Object Library, Alerts, Approval Management Engine, and personalizations. Migrated from 11.5.9 to 11.5.10. Moved from a shared to a full install of Oracle HR. Migrated data from the Abra HR application to Oracle HR using a combination of data pumps and APIs. Developed personalizations for employee and manager self service to meet specific business needs. Discoverer Administrator.

Provide technical support of the Oracle HR, Advanced Benefits, Internet Expense, Service and Application Object Library. Migrated from 11.0.3 to 11.5.8, 11.5.9 and we have started the move to 11.5.10. Provide mentoring to other IT staff on Oracle database, HR, Alerts, APIs, Work flow, Personalizations and Approval Management Engine. Developed tools to aid the DBA in systems management. Developed a mechanism to optimize sales plan disbursements to HR via the batch element entry interface. Developed a access reporting tools for SOX that I presented at Northern California Oracle Application Users Group 2006 Training Day. Discoverer Administrator. Server on the change control board. Above and Beyond award winner. On team that won most valuable team award (for 11.5.9 roll out).

Assisted clients Oracle ERP system, specializing on HR issuesAssisted a client with the migrated from 11.0.3 to 11.5.6 version of Oracle ERP applicationDeployed HR Self Service

Managed the team implementing our application for clients. Designed Oracle architecture for enterprise using Advanced Replication for fail over. Provided robust CRUD interface used application developers. Developed best use practices for Oracle development. Database Administration and tuning. Assisted in sales and marketing activities.

Developed Stored procedures, triggers, tables, etc. to enhance the application. Worked closely with Java developers to provide optimal usage of oracle result sets. Documented the schemas and made recommendations for optimization. Managed and tuned the Oracle Databases. Assisted in Migration of production databases from ASP to run internally.

Developed Single Sign-on web technology for internal use. Worked on an EDI interface. Reengineered feed mechanism for Global Employee database to use replication. Mentor and Troubleshooter for Oracle Applications. Started as senior analyst, promoted in less than a year to manager. Manager of HRIS supervising a team of six people to support HRIS for Oracle US. Managed the global roll out of a standard HR application (pre-web based). Customer Advocate award winner for superior customer focus and satisfaction.