Frank Smith Email & Phone Number

Brisbane, Queensland, Australia

Brisbane, Australia

Brisbane, Australia

Redevelop Marketing Campaigns using SQL Server as part of the migration of customers to Dynamics 365

Brisbane, Australia

Responsibilities:• Develop T-SQL stored procedures to extract data for Automotive Club’s (RAA, RAC, RACQ, RACT and AANT) Finance systems• Develop stored procedures to extract data to be used by each Club’s Business Intelligence teams.• Design, develop and maintain a process to replicate data to four (4) Club data bases in real-time.• Using SSRS, develop a dashboard of real-time reports for Clubs to monitor roadside assistance service levels.• Run ad hoc T-SQL queries to support the various test teams and business usersMajor Achievements:• Implemented a process of filtered transactional replication to ensure Clubs only viewed information they were entitled to see.• Implemented a dashboard of 11 real-time reports and associated security principles

Murrarie

Responsibilities:• Liaise with business users to confirm requirements for the content and output from the warehouse• Data analysis of the source data using SAS and SQL• Use of Infosphere Information Data Architect to assist in data base modelling and development• Develop and maintain technical mappings for the movement and transformation of data from source to target systems• Prototyping ETL logic using SAS to substantiate mapping rules• Advise and assist in the ETL development using DataStage• Assist test team with the development of test scripts• Diagnose problems observed in System and User Acceptance Testing• Participate in daily Agile Scrums and maintain story cards to highlight progress and impediments in the project• Develop interface agreements with various data providers to document roles and responsibilities for the passage of dataMajor Achievements:• Part of the successful implementation of a warehouse containing over four years of policy history as part of RACQI’s migration from COGEN to PolicyCenter• Successful re-design and implementation of Insurance Data Marts• Implemented Data Vault Methodology• Designed and developed data marts to support Tableau reports• Develop and test technical rules for the consumption of data by an external company hosting a marketing automation tool (Unica)• Extract data from Unica for reconciliation back to source• Created SAS datasets from various RACQ sources to be used by the Pricing and Actuarial areas• Designed and developed data marts to record call centre data• Designed and developed staging and target tables to record member insurance discounts for use in the Member Value Statement

Responsibilities:Provide business and data insight to assist with the day to day operation of the Customer Data Mart (CFDM).Review proposed enhancements to ensure changes are fit for purpose, adhere to standards, maintain simplicity in design and do not impact performance.Obtain in-depth knowledge of source systems to determine suitability for use in the CFDM.Develop Interface Contract Documents (ICDs) with source data owners for the provision of data to the CFDM.Devise, implement and execute test strategies.Ongoing analysis and profiling of customer and product data through the use of SAS.Provide support to the CFDM user community.Major Achievements:Assisted with the development, testing and implementation of phase one of a corporate-wide Customer Data Mart (CFDM) initially with SUN/GIO customers only.Developed extracts from several key systems for input to the CFDM.Acceptance testing of a new centralised view of customer in CFDM following the integration of customers as part of the Promina Group acquisition.Provided assistance to the centralisation project for the acquisition of risk or cover-level product data from a number of Cogen (GIO) and Protect (AAMI) insurance systems.Designed, developed and implemented a suite of re-useable SAS programs to execute test strategy.Analysis, design and testing of continued CFDM data acquisition around Life Risk products.

Responsibilities:Design, develop and implement marketing campaign extracts using SAS.Design, develop and execute non-standard campaign-specific tracking reports.Develop reports on customer behaviour and product holdingsMonitor and support computer jobs running in the marketing schedule.Mentor team members on campaign development.Maintain continual improvement through the introduction of campaign standards, coding rules and summary data files (SAS data sets).Major Achievements:Developed a repository of customer and product information for Business Bank to relationship manage their customers. Developed a product profitability algorithm to improve targeting of the customer base.Developed customer segmentation reporting used throughout the organisation not just Marketing.Developed a suite of reports (Dashboard) enabling the tracking of customer acquisitions/defections, penetration and cross-sell opportunities.Implemented key infrastructure to simplify campaign design and development.Improved productivity with the introduction of automated scheduling of regular Marketing extracts, reports and campaigns.Developed delta extracts to push data to campaign automation toolset hosted by an external company.

Project Manage several concurrent Y2K remedial projects for hardware (ie. IBM, Compaq and DELL) and software such as Microsoft NT, NT Server and Office 97Supervise up to five Y2K remedial personnelMajor Achievements:Successfully achieved Y2K Compliance of Desktop SOE software on over 5000 networked and standalone devices throughout Australia.Ensured Y2K hardware and software compliance of some 250 mission critical devices (eg File Servers).Performed logistics co-ordination to establish the Y2K Response Centre that was the hub for all IT related problems for the millennium cutover.Performed a vendor selection for the facilities management of all SML printed output that eventually led to the appointment of Lexmark as a strategic partner.

Maintain asset registers of IT hardware and softwarePerform all purchasing of IT related equipment and track expenditureAdminister equipment lease contractsSupervise two administrative personnelMajor Achievements:Developed MS Access system to track expenditure that also produced the expenditure voucher required by the accounts payable area for payment. This greatly simplified the pre-processing of invoices.Implemented a process for the mobile sales force to acquire notebooks under a lease agreement. This enabled standardisation of technology and simplified the acquisition process.Successfully project managed the implementation of $1.2m of technical infrastructure for the centralisation of claims processing to the Brisbane CBD. This also included the establishment of a TeleClaims Call Centre.Project Manage the establishment of IT infrastructure for the Suncorp Metway QIDC merger committee.

Supervise a small team of support staffPerform second level help desk support function primarily for hardwarePurchase and install IT infrastructure for the head office retail operations including the Suncorp Call Centre and retail branch networkMajor Achievements:Supervised the relocation of IT Infrastructure for retail operations, including the Call Centre, from Fortitude Valley to new premises in the City in 1994.Project managed the establishment of an overflow Call Centre in the Valley premises in late 1994.Project managed the relocation of the Valley Call Centre operation to the City in 1995. Successfully trained team members in understanding and supporting a new NT server based branch system that was implemented in late 1995.

Responsibilities:Manage the help deskSupport head office retail operations, including Call Centre, plus network of 102 branches, 60 agents and 5 Area Business CentresPurchase, implement and support Novell LANS, Windows PCs and MS Office productsPerform security administration of user’s mainframe (RACF) and PC accessMajor Achievements:Implemented IT Infrastructure for the first retail Call Centre.Installed a laser printer in each retail branch as a means to produce output other than through traditional passbook printing devices.Established one of the first Standard Operating Environments (SOEs) for head office computers in an effort to combat widespread personalised customisation.

Support end-users in the use of mainframe and microcomputer toolsSecurity administrationConduct instructor led trainingMajor Achievements:Successfully upgraded 20 PC/XT systems with new 286 motherboards and 3.5" floppy drivesParticipated in scheme to equip and train staff with their own home PCs. This proved to be popular with 50 families participating and attending in-house training after hours over a 4 week periodRedeveloped a series of SQL queries that reduced processing time by 90%. This achievement was formally recognised by the then General Manager.

Develop and maintain COBOL and EASYTRIEVE computer programsPerform statistical samplingEvolve new Computer Aided Audit Techniques (CAATs)