Stuart Mildren
Information Analyst, Data Warehouse
- Location
- Darwin Area, Australia
- Industry
- Information Technology and Services
As a LinkedIn member, you'll join 225 million other professionals who are sharing connections, ideas, and opportunities.
- See who you and Stuart Mildren know in common
- Get introduced to Stuart Mildren
- Contact Stuart Mildren directly
Stuart Mildren's Overview
- Current
-
- Information Analyst, Data Warehouse at NT Government
- Past
-
- Systems Support Officer, Data Warehouse at Department of Health, Northern Territory Government
- Web Manager at Department of Health, Northern Territory Government
- PHP, MySQL Web Developer at Hotelpacc Group Services Ltd
- PHP, MySQL Web Developer at Mistermildren
- PHP, MySQL Web Developer at Rising Sun Pictures
- Education
-
- Charles Darwin University
- Recommendations
-
3 people have recommended Stuart
- Connections
-
124 connections
Stuart Mildren's Experience
Information Analyst, Data Warehouse
NT Government
Government Agency; 501-1000 employees; Government Relations industry
June 2008 – Present (5 years 1 month) Darwin Area, Australia
A general description of my position as an Information Analyst is to deliver end-to-end Data Warehouse solutions for the various clients I engage. This includes assisting clients to understand their source data, helping them develop the day to day routines for capturing and historically storing the data and building fast loading, logical and accurate reporting of the data based on the projects KPI’s. The role is also heavily focused on developing and refining the structure of the Data Warehouse system architecture, from source data extraction techniques, through the levels of the Data Warehouse (ETL and Oracle) to the many Data Marts and Business Objects Universes we manage.
Typical duties include:
• Responsible for monitoring and mentoring of the Technical Analysts and System Support Officers
• Participate in the recruitment of Data Warehouse staff and client staff
• Responsible for designing, developing, monitoring and trouble shooting of various daily, weekly, monthly, quarterly and annual ETL processes
• Technical data support for clients, usually Business Objects Reports, Universe or interrogating client data from source through the Data Warehouse to reports
• Identify and analyse new and existing business systems. Develop and implement procedures to capture, store and utilise information from these systems
• Review quality of data collections and initiate procedures to improve data quality (Data Profiling, staging environments, error capture and reporting design)
• Relational and dimensional database modelling, design, development and maintenance
• Develop DataStage jobs to deliver ETL solution for business requirements, including BO Universe Design for reporting requirements
• Technical and functional specification design
• Leading or participating in planning and strategy meetings
• Liaising with clients and assisting with remote data capture installations and the maintenance of these installations including various databases and web sites
Systems Support Officer, Data Warehouse
Department of Health, Northern Territory Government
August 2007 – June 2008 (11 months) Darwin Area, Australia
• Responsible for the monthly, quarterly and annual ETL procedures for various program area’s within DHCS CCIS, including correcting any problems that arise during this process
• Responsible for the maintenance and backup of data
• Management of multiple projects often under difficult deadlines and with multiple program areas, leasing with stakeholders and managers to adjust and determine work priorities in order to meet objectives under pressure
• Technical design and documentation of projects, participating in group planning and strategy meetings, design of Data Warehouse structures, Data Marts and Business Objects Universes
• Implementation of projects using different Data Warehouse methodologies, such as Dimension Modelling and Normalised Modelling
• Liaising with Business analysts with Data Mining, correcting data problems, improve ETL and reporting systems, design or improve Data Marts, design or improve Data Extracts and provide advice on Web Sites, Database, Warehouse, Data Mart and ETL processes.
• Liaising with government officers off site assisting with remote Data Capture installations and the software maintenance of these installations including Databases and Web Sites
• Work with the Data Warehouse team to provide assistance and acquire assistance with any issues that arise in day to day activities, often collaborating in areas outside of my primary role
• My role requires that I meet and discuss complex technical issues with many different people from different backgrounds. I have a good ability to communicate technical topics to people who may not have much exposure to the technology.
• My tasks require proficient knowledge and use of: Oracle, DataStage, Toad, SQL Server, JADE, Access, Word, Excel and other tools
Web Manager
Department of Health, Northern Territory Government
April 2007 – August 2007 (5 months)
• Provide strategic advice on, and operational management of, the development, implementation, maintenance and evaluation of Internet communications and resources to meet business objectives, in line with DHCS and whole of government polices and standards
• Direct and manage multimedia support officer/external web contractor(s) activities within available resources, organisational objectives and corporate and whole of government guidelines
• Perform DHCS website Site Master duties, including maintenance and quality control, and management of external inquiries via the DHCS website
• Provide technical advice to roll out new web based systems and technologies.
• Acted in the selection committee with regard to targeting the best technology to upgrade the DHCS intranet and internet sites
PHP, MySQL Web Developer
Hotelpacc Group Services Ltd
August 2005 – December 2006 (1 year 5 months) 96 Baker Street, Marylebone, London, U.K.
• Programming web applications in various web languages including OOP PHP, MySQL, HTML, Javascript, CSS, AJAX etc.
• Analysing and developing web applications through a tailored software development lifecycle which I personally developed for the company including introducing cost and time saving practices, such as the use of various diagramming procedure and documentation practices to ensure stable collaboration between stakeholders within the company
• Leading the team in business analysing efforts to bring business concepts and ideas onto a web platform successfully
• Training staff in the correct use and procedure with regard to developing software within the software development lifecycle
• Developing large and stable databases using MySQL: interfacing with these databases through various tools including direct command input and introducing better schema and general database design practices
• Some graphic design and multimedia: my primary focus was working with designers to ensure that usability was a primary focus to ensure beneficial outcomes for the customer and the company: prior to my first promotion within the department I was the lead graphic designer
• Maintaining existing internal and external web based systems including those which were engaged in online transactions between the company and various banking sources within the U.K.
• General team management duties such as guiding team members through company procedures, policies and standards
PHP, MySQL Web Developer
Rising Sun Pictures
Privately Held; 51-200 employees; Motion Pictures and Film industry
March 2001 – October 2002 (1 year 8 months) Adelaide Area, Australia
Stuart Mildren's Courses
-
Deferred combined Information Technology and Business
Charles Darwin University
- Kimball University Dimensional Modeling In Depth
- Kimball University ETL Architecture In Depth
- Thomset International Project Management: Essential Techniques Workshop
- Introduction to Business Objects XI Reporting
- IBM DataStage Essentials for Server Edition
- Northern Territory Government Recruitment and Selection
Stuart Mildren's Skills & Expertise
- Dimensional Modeling
- Data Quality
- ETL
- Data Integration
- Data Modeling
- Microsoft SQL Server
- Master Data Management
- Star Schema
- Databases
- Database Administration
- Oracle
- Logical Data Modeling
- Data Warehouse Architecture
- Information Analysis
- Datastage
- Relational Data Modeling
- Data Profiling
- Business Analysis
- PHP
- SQL
- HTML
- JavaScript
- Flash
- Photoshop
- XML
- MySQL
- CSS
- Technical Documentation
- Functional Specifications
- OLAP
- Business Intelligence Tools
- Change Management
- Project Management
- Data Migration
- Information Management
- Data Marts
- Stakeholder Management
Stuart Mildren's Education
Charles Darwin University
Deferred combined Information Technology and Business
1998 – 1999
Stuart Mildren's Additional Information
- Groups and Associations:
-
-
Contact Stuart for:
- career opportunities
- consulting offers
- new ventures
- job inquiries
- expertise requests
- business deals
- reference requests
- getting back in touch
View Stuart Mildren’s full profile to...
- See who you and Stuart Mildren know in common
- Get introduced to Stuart Mildren
- Contact Stuart Mildren directly
