Scott Mitchell

• Developed 150 jobs in order to integrate a new source system for tracking provider services into the existing Aged Cared Data Warehouse.
• Assisted the data modelling team in understanding existing SAS DI Studio jobs and validated mappings to ensure accuracy and completeness.
• Translated technical concepts and information into terms parties could easily comprehend.
• Contributed ideas and suggestions in team meetings and delivered updates on deadlines, designs, and enhancements.
• Estimated work hours and tracked progress using Scrum methodology.
• Tuned various jobs to enhance performance.
• Coordinated deployments of new jobs and bug fixes in keeping with departmental processes and standards.
• Acted in the role of Lead Developer, supervising the work of subordinate programmers, undertaking code reviews, providing feedback and offering assistance as required.

Achievements:

• Created a Data Lake solution on Google Cloud Platform, utilising BigQuery, Cloud Functions, Data Catalog, Cloud Storage and Cloud PubSub products using the Python language.
• Designed, documented and delivered a bespoke paperless (previously 500+ pages per day) workflow management solution using the SAS Add-In for Microsoft Office in concert with Base SAS.
• Replicated and reconciled legacy PL\SQL queries, increasing the frequency in which the reports were generated and reducing manual interaction by 50%.
• Replicated, reconciled and documented a series of legacy T-SQL queries, producing an automated reporting solution which reduced report preparation time from one month to less than a single day.
• Designed, documented and delivered a SAS development environment for a Greenfield site.
• Designed, developed and reconciled Source, Staging and Reporting layers, documenting and clearly defining their usage within the organisation.
• Identified 15 inconsistencies in the way manual reports had been created historically and regenerated the results using the newly implemented solution.
• Developed a series of SAS Macros used to ensure consistent and efficient transformations and data interactions in an organisation where staff had no programming experience. Jobs were designed to be controlled by values in Excel control tables which could be manipulated by appropriately trained staff, without needing to be versed in how to write SAS code.
• Designed and built a proof of concept for a Persistent Staging Layer which would allow departments to undertake time series analysis.
• Designed and built a proof of concept for Human Resources dashboards using SAS Visual Analytics.
• Designed and built a proof of concept for Data Explorations using SAS Visual Analytics.
• Presented the outcomes of the proof of concepts to the CIO, Directors and mid-level management. The outcomes were very positive, with the CIO and Directors expressing their gratitude for achieving so much within a very short engagement.

Internal Achievements:

• Designed and developed the corporate website using Joomla.
• Designed and configured the Jira and Confluence applications.
• Documented the organisations naming conventions\standards\style guide.
• Developed document templates to ensure all external communication had an identical look and feel.

Client Achievements:

• Reviewed 100+ production jobs and documented recommendations to improved efficiency as well as consistency, reducing execution times by 20%.
• In concert with the Senior SAS Administration Consultant, analysed the existing SAS production environment and identified 150 issues resulting in poor performance and system outages. Although the recommendations were not implemented a conservative estimate would suggest a 15% improvement in performance and a 95% reduction in server down time.
• Gathered\documented requirements, designed\developed ETL processes and produced Visual Analytics dashboards for a SAS Visual Analytics Greenfield site.
• Performed and documented requirements gap analysis.
• Performed Source to Target analysis and mapping for various reports and disparate source systems.
  

Achievements:

• Undertook peer reviews of code and Data Vault definitions to ensure that met relevant standards.
• Modelled Data Vault entities for an initial SAS driven proof of concept.
• Assisted in the development of dynamic Data Vault table loading routines.
  
• Developed test plans for the dynamic Data Vault loading routines.
• Produced a series of custom SAS functions used to enhance the Data Vault table loading routines.
• Performed testing, and documented outcomes of, the Data Vault table loading routines.

Achievements:

• Designed, developed and implemented exception reports identifying customers whose interest rate was incorrectly applied.
• Developed and implemented an ETL process for backloading 14 years of accounts data for an environment without a Data Warehouse.
• Designed, developed and implemented exception reports identifying clients who were charged various account keeping fees erroneously.
• Recalculated historic balances across 14 years for accounts impacted by the incorrect application of interest rates and fees and identified the amount of refund to be credited to the account holder.

Achievements:

• Assisted with the development of the corporate style guide.
• Developed graphics for the business’s Facebook page and posts, in keeping with the corporate style guidelines and reflecting key stakeholders briefings.
• Development of key datasets used to make strategic decisions by management.
• Managed relevant changes to datasets as requested by the appropriate stakeholders.
• Report and reconcile tax and superannuation contributions quarterly
• Developed invoicing templates as instructed by key stakeholders.
• Developed weekly, fortnightly and monthly reporting schedules.
  

Achievements:

• Automated Claims and Underwriting monthly reporting using Microsoft Excel and Access, reducing data preparation and report delivery times from 30 days to two weeks.
• Automated Claims and Underwriting monthly reporting using SAS, reducing data preparation and report delivery times from two weeks to six hours. This also allowed for the allocation of human resources to undertaking data analysis and to creating daily and weekly operational and management reports.
• Supervised and assisted Junior Analysts with automating the Assessing, CTP, Re-Insurance and Contractor Management reporting using SAS, reducing data preparation and report delivery times from 30 days to one week.
• Successfully lead a team of analysts to perform a server migration from SAS 9.1.3 to SAS 9.3, requiring significant re-factoring of code and making greater use of metadata. In addition, introduced Development, UAT and SIT environments and processes for migrating code between environments. Implemented a new scheduler and developed Powershell scripts to simplify, reduce complexity and improve consistency when migrating schedules between environments.
• Designed, developed, reconciled, documented and implemented datasets from a new Claims Management System used for strategic and tactical decision making. Increasing the frequency of the datasets from monthly to daily. Successfully delivered the datasets within 2 months, after a 2 year project failed to produce a reconcilable result.
• Identified $8.5M leakage within the General Ledger and wrote code to identify and remedy the appropriate transactions.
• Created a daily reconciliation between the Claims Management System, Accounts Payable\General Ledger Service and the consolidated General Ledger to identify transactions not being processed end to end. Developed exception reports for the vendor to investigate reconciliation issues identified.
• Nominated for the RACQ Insurance Living the Values - Innovation Award 2011 and 2012. Nominations provided by peers and approved by the Senior Executive Committee.
• The central point of contact for data related queries for Actuarial, Pricing, Management, Senior Executive Committee, Auditors (both internal and external), APRA, as well as the Insurance Council of Australia and various media outlets.
• Achieved average performance scores over the period of employment of 3.4 out of 4.0 indicating performance exceeded the organisations expectations of the incumbent. Performance bonuses in excess of those documented within the employment contract were paid for each period.

Achievements:

• Oversaw the greatest period of growth in the organisations history to become the largest insurer of motor vehicles in Queensland.
• Lead a team of analysts to implement the organisations pricing and rules engine, reducing the time to implement pricing changes from several days manually to under 2 minutes using an XML uploading process. The rules engine increased the consistency of rules application and risk acceptance. These implementations increased profitability by 11%.
• Lead a team of analysts to implement a high risk vehicle insurance product and associated pricing model. Allowed the organisation to capture risks which were previously seen as undesirable and rate them separately to ensure profitability.
• Implemented and priced the "1 free windscreen per year" product.
• Lead a project team of Pricing Analysts and Actuaries to produce an automated pricing model. Analysis of the solution suggested a review of all vehicles would be undertaken within 20 days as opposed to 7 years manually. The saving in human resources allowed the organisation to be more responsive to constantly changing market conditions, as well as focusing more on competitor and demographic analysis.