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:

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

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.

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.

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.

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..

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.

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.

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.

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