Tori Sugden
Senior Data Analyst at City of Stonnington- Claim this Profile
Click to upgrade to our gold package
for the full feature experience.
Topline Score
Bio
Credentials
-
Cortex Participant
SASMay, 2020- Nov, 2024 -
SAS-James Cook University Joint Certificate in Advanced Data Science
SAApr, 2020- Nov, 2024
Experience
-
City of Stonnington
-
Australia
-
Government Administration
-
300 - 400 Employee
-
Senior Data Analyst
-
May 2021 - Present
Currently wrangling data for ingestion to a new cloud based DataStack and wowing business users with Power BI interactive reports. The automation and streamlining of an HR Workforce Analysis report led to a 93.75% reduction in resource effort. The Customer Insights & Ops report highlighted broken business processes and brought data from disparate source systems together to increase the visibility of team workload. Set up and run the Power BI Community of Practice to increase knowledge and use of Power BI amongst staff.
-
-
-
Queensland Health
-
Australia
-
Hospitals and Health Care
-
700 & Above Employee
-
Assistant Release Officer
-
Aug 2016 - Apr 2018
As an Assistant Release Officer working in Workforce Management Solutions and Operations, Payroll Portfolio my duties included assisting in the coordination of timely release planning activities to enable business requirements identified by Queensland Health to be analysed, assessed for impact including integration impacts, designed, developed, tested and implemented into production within established frameworks, strategies, standards, methodologies and policies. I also co-ordinated and consolidated release management reports and evaluated progress, risks and issues and reported on these items appropriately to management.
-
-
-
-
Senior Tax Consultant
-
Jul 2016 - Aug 2016
Preparation of individual tax returns: ABNs, rentals, and Capital Gains. Preparation of individual tax returns: ABNs, rentals, and Capital Gains.
-
-
-
-
Tax Consultant
-
Jul 2012 - Dec 2015
Individual tax return preparation. Individual tax return preparation.
-
-
-
-
Photographer
-
Mar 2010 - Dec 2015
Specialising in underwater photograhy Specialising in underwater photograhy
-
-
-
-
Social Media Manager
-
Jun 2010 - Jul 2012
Helping businesses get social Helping businesses get social
-
-
-
-
Analyst/Programmer
-
Aug 2006 - Mar 2010
Hardware : IBM 3090 Language : COBOL Software : MVS, TSO, DB2/SQL, MS-Office, IMS, JCL, Endevor, Fileaid, Quality Center, Telon, Expeditor; Duties included : From February 2008 have been assigned to the Payments Team. From February 2008 until July 2009 worked on several projects impacting the Bills Trading system which is a Treasury system processing negotiable discounted Securities. From July 2009 until March 2010 was assigned to several projects in International Capture systems. Main duty was to perform high level and detailed technical analysis of existing systems. This included the translation of Business Requirements into Detailed Design Specifications, producing very detailed program (IMS and DB2/SQL) specifications, development and review of new processes, responsible for the redesigning of complex Telon programs, all levels of testing including setting up test cases in Quality Centre's Test Director, and producing Operations Support documentation. Prior to this worked in the Technology Banking Australia, Commercial Customer Accounts (CASB application) team. Duties included investigating and making code changes to existing IMS COBOL and DB2 programs for CASB for a variety of projects including the Front End Replacement Program Release 4, Project Austin to introduce a new product, phase 3.2 of the Financial Freedom project and project SIMBA (SMS Banking), writing program specification for a conversion module for the Anti-Money Laundering (AML) project in the Marketing Entity application, all levels of testing including setting up test cases in Quality Centre's Test Director.
-
-
-
-
Senior Solutions Specialist
-
Oct 2002 - Aug 2006
Hardware: IBM 3090 Language: SAS Software : MVS, TSO, SQL, MS-Office, SQLNavigator (OCMS), JCL, Teradata, Marketing Director (CMS), Rational Clearquest; As an A/P working in the Telstra Retail, Technology Solutions area duties included Data Mining to produce regular Pricing Plan Analysis and Site Traffic reports, as well as ad-hoc analysis reports for the Account Executives in the Sales area. Under a restructure transferred to the Customer Relationship Management team in the Telstra Consumer & Marketing area. Additional duties included producing regular and adhoc campaign lists from both OCMS and CMS. In Oct 2004 became a permanent employee as a Snr Data Analyst in the Data & Analytics Team to deliver quality data, reports and customer insights in a timely manner, accountable for providing specialist knowledge and data analysis to support TC&M and other business units; ensure analysis, design and programming performed accurately, to agreed customer specifications, compliant with good software practices and standards, within agreed timeframes; extract data and prepare reports, both routine and ad-hoc, using data repositories such as the TDW, OCMS and CDRLive; document requests in sufficient detail for future reference; maintain quality control safeguards to ensure that data is accurate, meets privacy standards; understand the data requirements, the reasons for the request, the urgency and relative priority of the request; work to automate routine processes; support the other Marketing and Analytics teams by providing subject matter expertise in systems and collating data for large analytical and modelling projects Under a re-structure in late 2005 transferred to Analytical CRM as a Snr Solutions Specialist. Provide input into the Business Information Strategy document in regards to in the transformation of the DW into an Enterprise Data Warehouse; provide quality advice based on the technical knowledge; produce and support ad-hoc queries in SQL and SAS..
-
-
-
-
Analyst/Programmer
-
Sep 2001 - Feb 2002
Hardware : IBM 3090 Language : COBOL II Software : MVS, TSO, CICS, DB2, SPUFI, MS-Office, JCL, Expeditor, Telon, Platinum; Duties included : Commenced as an Analyst/Programmer working the in Lending (IT) department. Duties include running the simulation tests for the December Insurance Renewals, resolving any data problems and supporting the November live runs. Duties also included supporting the live Mortgage system (a system inherited from Bradford & Bingley Building Society (see below)), analysis of current system, liaising with the User department staff to determine their requirements, Technical Design documents, coding new and existing programs, unit testing (including writing unit test plans), writing System Test Design documents, System Test Plans, executing System Testing and the implementation of System changes.
-
-
-
-
Analyst/Programmer
-
Apr 2000 - Sep 2001
Hardware : IBM 3090 Language : COBOL II Software : MVS, TSO, CICS, DB2, SPUFI, MS-Office, JCL, Expeditor; Duties included : Commenced as an Analyst/Programmer on an Estate Agency intranet system developed to match up Properties for sale with potential Buyers and vice versa. Duties included writing process specifications (to receive an XML message from the client, send and receive messages to various host systems and then send an XML message back to the client), writing program specifications, coding new programs (to retrieve/update the data held in DB2 tables on the mainframe), writing unit test plans, unit testing and supporting at various levels of testing. The system went live in November 2000 and from that time worked on supporting the system by investigating any problems raised by the users in the branches and developing enhancements.
-
-
-
-
Analyst/Programmer
-
Sep 1998 - Oct 1999
Hardware : IBM 3090 Language : COBOL II Software : MVS, TSO, CICS, DB2, SPUFI, MS-Office, JCL, Expeditor, Telon, Platinum; Duties included : Commenced in 1998 as a contractor (through Technical Recruitment Solutions) as an Analyst/Programmer on a Mortgage system dealing mainly with changes to the processing of Further Advances to a Main Mortgage. Duties included analysis of current system, liaising with the User department staff to determine their requirements, writing Transaction Descriptions, Technical Design documents, coding new and existing programs, unit testing (including writing unit test plans), writing System Test Design documents, System Test Plans, executing System Testing and the implementation of System changes. Returned as a permanent employee in December 1999 as a Lead Technician on the Customer Relationship Management team. Duties include analysis of existing (VSAM) investment and (DB2) lending systems with respect to the changes required for the new system (database and platform, at that time, to be determined
-
-
-
-
Analyst
-
Mar 1998 - Sep 1998
Hardware : IBM 3090 Language : COBOL II Software : MVS, TSO, DB2, SPUFI, MS-Office, VSAM, Fileaid, JCL, SELCOPY, ROSCOE, Expeditor; Duties included : Commenced as an Analyst on the Offshore Projects team. The team was responsible for the development of work estimated to be less than 1000 hours and intended to be sent offshore to be constructed in India. Duties included writing functional designs, detailed designs (sometimes to a very detailed level), involved in the Quality Inspections of ballpark packages, functional designs, detailed designs, coding and unit test packages and monitoring System Testing. Duties also included monitoring work sent off shore to India, liaising with technical teams and the Client Services department. On occasion, some construction work was undertaken. After 3.5 months took over the responsibilities as Lead Analyst.
-
-
-
Midland Bank
-
Banking
-
1 - 100 Employee
-
Analyst
-
Aug 1997 - Feb 1998
Hardware : IBM 3090 Language : COBOL II Software : MVS, TSO, DB2, ENDEVOR, PROEDIT, SPUFI, MS-Office, METHOD/1; Duties included : Commenced as an Analyst investigating the impact of Year 2000 on various Retail Applications, writing a detailed impact analysis, confirming requirements with end-user support personnel, writing technical specifications for changes to impacted programs, reviewing the code changes, and liaising with the Year 2000 Test Analysts. Then worked on a detailed impact analysis of eight Retail Applications systems that use a database that was to be demised in phases from the third quarter of 1998 through to the end of 1999. This involved using SPUFI and PROEDIT to interrogate the System Catalogue tables to find impacted programs, investigating what data each program requires, how it uses it, where the information will need to be sourced from, and when during the migration from the existing system the changes need to be made.
-
-
-
Telstra
-
Australia
-
Telecommunications
-
700 & Above Employee
-
Change Request Lead, Lead Analyst and Change Request Owner
-
Aug 1996 - Aug 1997
Hardware : IBM 3090 Language : COBOL II Software : MVS, TSO, IMS, DB2, ENDEVOR, PROEDIT, SPUFI, DESIGN/1, MS-Office, MS-Project, MicroFocus COBOL, Table Wizard, SPF/PC, FileAid/PC; Duties included : Commenced back with the FLEXCAB project as a Change Request Lead on a Release Delivery team liaising with technical, functional and business areas of the project, writing Design Packages (in DESIGN/1) for changes to existing programs, reviewing Design Packages to ensure they met the functional requirements and standards of the project, identifying and resolving design issues, supervising up to 5 Analyst/Programmers, scheduling and assigning tasks (using MS-Project), coding and unit testing in the PC environment changes to existing programs, reviewing unit Test Plans and Unit Testing. At the beginning of 1997 assumed the overall lead development responsibilities as the Lead Analyst for the implementation of the Change Request. Duties included liaising with technical and functional areas of the project, monitoring the outstanding program changes still under construction, overseeing the development of the System Test Plan and System Test Model, verifying System Test output, identifying and resolving performance and implementation issues, supporting Production Acceptance Testing, through to the implementation of the Change Request in June 1997. In June 1997 became a Change Request Owner. Duties included understanding the business requirements of several Change Requests and relating these to application requirements, reviewing estimates, identifying synergies, ensuring the application cells understand the requirements, reviewing Detail Design packages, providing one point of contact for technical, functional and business people for the resolution of issues, monitoring the progress of the Change Request.
-
-
-
-
Traveller
-
Nov 1995 - Jul 1996
Travelling throughout South America Travelling throughout South America
-
-
-
Telstra
-
Australia
-
Telecommunications
-
700 & Above Employee
-
Analyst/Programmer and Analyst
-
Oct 1993 - Nov 1995
Hardware : IBM 3090 Language : COBOL II Software : MVS, TSO, DB2, ENDEVOR, PROEDIT, SPUFI, DESIGN/1, MS-Office; Duties included : Six weeks on Production Support and Maintenance supporting the Online Customer Definition programs. Followed by four months on a development team modifying existing online programs. Then three months on the Case Studies team setting up a release of the Training System. After that two months working as an Analyst on the High Priority Change Request team writing Design Packages for changes to existing programs. Followed by sixteen months working as an Analyst on a Release Delivery team writing Design Packages for changes to existing programs, reviewing Unit Test Packages, writing System Test Plans, writing System Test Models, verifying System Test output.
-
-
-
-
Analyst/Programmer
-
Apr 1993 - Oct 1993
Hardware : IBM 3090 Language : COBOL Software : MVS, TSO, IMS, CICS, ENDEVOR; Duties included : Maintenance of Online and batch programs in the AMICUS system. AMICUS is one of NZR's computer-based information and operational systems. Hardware : IBM 3090 Language : COBOL Software : MVS, TSO, IMS, CICS, ENDEVOR; Duties included : Maintenance of Online and batch programs in the AMICUS system. AMICUS is one of NZR's computer-based information and operational systems.
-
-
-
-
Consultant
-
Aug 1991 - Oct 1992
Hardware : IBM 3090 Language : COBOL II Software : MVS, TSO, DB2, CICS, TELON, SELCOPY Duties included : August 1991 to July 1992 assigned to UCB, a fast-growing centralized mortgage lender (UK subsidiary of a French bank) developing a loan administration system. Developed both DB2 batch and TELON Online programs and program test plans. Carried out some system testing. August 1992 to September 1992 assigned to Unichem, a leading British pharmaceutical wholesaler. Developed COBOL batch programs to ensure data integrity between VSAM files. Developed a batch CICS COBOL program to facilitate the maintenance of unique configuration within each of the automats.
-
-
-
-
Analyst/Programmer
-
Jan 1990 - Aug 1991
Hardware : IBM 3090 Language : COBOL Software : MVS, TSO, DB2, CICS, SELCOPY, ENDEVOR; Duties included : Development and implementation of a new batch Weekly Lead Generation system for the Direct Sales Force. Development and implementation of an Online (CICS) system to enquire on, transfer, delete and restore leads. Duties also included writing design and program specifications, system testing, user training and providing technical assistance to junior staff. Hardware : IBM 3090 Language : COBOL Software : MVS, TSO, DB2, CICS, SELCOPY, ENDEVOR; Duties included : Development and implementation of a new batch Weekly Lead Generation system for the Direct Sales Force. Development and implementation of an Online (CICS) system to enquire on, transfer, delete and restore leads. Duties also included writing design and program specifications, system testing, user training and providing technical assistance to junior staff.
-
-
-
-
Analyst/Programmer
-
Jan 1989 - Dec 1989
Hardware : Data General MV4000 Language : COBOL Software : INFOS, CQCS Duties included : As sole Analyst/Programmer for the Leeds Division of INCO (International Nickel Company) was responsible for the maintenance of existing Sales Order and Manufacturing Control systems. Development and implementation of a (CQCS) scheduling system for the Die and Tool department. Hardware : Data General MV4000 Language : COBOL Software : INFOS, CQCS Duties included : As sole Analyst/Programmer for the Leeds Division of INCO (International Nickel Company) was responsible for the maintenance of existing Sales Order and Manufacturing Control systems. Development and implementation of a (CQCS) scheduling system for the Die and Tool department.
-
-
-
-
Programmer/Analyst
-
Dec 1986 - Nov 1988
Hardware : Univac 1100 series Language : COBOL Software : DPS, DMS1100 Duties included : December 1985 to February 1986 employed as a vacation worker during University Christmas break. December 1986 to November 1988 developed and implemented both Online (DPS) and batch programs for a new Fines Accounting and Enforcement system. Hardware : Univac 1100 series Language : COBOL Software : DPS, DMS1100 Duties included : December 1985 to February 1986 employed as a vacation worker during University Christmas break. December 1986 to November 1988 developed and implemented both Online (DPS) and batch programs for a new Fines Accounting and Enforcement system.
-
-
Education
-
2018 - 2020
James Cook University
Master's degree, Data Science -
2015 - 2018
TAFE NSW – Western Sydney Institute
Advanced Diploma of Information Technology Project Management, IT Project Management -
2004 - 2009
Photography Studies College
Advanced Diploma in Photography, Commercial Photography -
1984 - 1986
The University of Waikato
Bachelor of Social Science, Computer Science with Mathematics as major supporting
Community
