Barbeques Galore is Australia's biggest specialist BBQs and outdoor furniture retailer. I was here on a contract basis to build new data models using SSAS Tabular cubes as well as rework some existing models. I was also involved in the refactoring of existing reports and building Power BI reports and dashboards to showcase the business performance.

Company Description: World Vision is a charitable organisation that collects money via donations to provide aid programs in developing countries.Position Description: Develop ETL processes for extracting data from various in house systems into a custom built data warehouse. Technical Skills: • SQL Server • Data warehouse development using star and snowflake schemas• TSQLIn More Detail:The role initially was to write ETL processes to import data from the local Echo system. Later this evolved to be part of the new SODA project in which a custom built ERP system was bought in to replace Echo, and I was involved in data migration and the writing of new ETL scripts. My role also includes some BAU work and gives the client the ability to scale up my hours as new pieces of work are required.

Company Description: Wine Selectors sell memberships to deliver beverages on a monthly or quarterly basis.Position Description: Develop a reporting data warehouse and OLAP cubesTechnical Skills: • SQL Server • Data warehouse development using star and snowflake schemas• SSAS - OLAP Cubes• Visual Studio: SSIS packagesIn More Detail:I was tasked with developing a reporting data warehouse from scratch and then working with the business to determine requirements for reporting cubes. I provide support and maintenance for this system as required.

I operate as a company with a small team of experts in the data warehousing and business intelligence space. Please contact me if you feel I can assist your business in any way.

Company Description: Godfreys sell electrical home aids (mostly vacuum cleaners) via a chain of retail outlets throughout Australia.Position Description: Develop a reporting data warehouse and OLAP cubesTechnical Skills: • SQL Server • Data warehouse development using star and snowflake schemas• SSAS - OLAP Cubes• TSQLIn More Detail:I was tasked with developing a reporting data warehouse from scratch and then working with the business to determine requirements for reporting cubes.

Company Description: Munro Footwear Group (formerly Fusion Retail Brands, formerly Colorado Group) is a leading national footwear and apparel retailer.Position Description: Upgrade and maintain a SQL Server data warehouse and OLAP cubes for business use with pivot tables.Technical Skills: SQL Server 2008 (responsible for upgrade from SQL Server 2000)Datawarehouse development using star and snowflake schemasSSAS - OLAP CubesVisual Studio : SSIS & DTS ETL (Extraction/Transformation/Loading) packagesIn More Detail:My initial task was to upgrade the SQL Server 2000 database to SQL Server 2008, thus greatly improving the speed and stability of processing as well as end user performance. Stage 2 has been to upgrade the SSAS cubes to 2008 and to oversee the rollout to the business. I am the key system owner for one of the most critical business systems which has required an ongoing commitment to change management and quality testing processes.

I was brought in on a temporary short term contract to build a new datamart for reporting purposes. Data was migrated from a variety of SQL Server databases into one central repository using SSIS. This was intended to be a 4 week contract but I completed the task in a much shorter timeframe and have gotten involved with the rollout of Tableau dashboard software as well.

I was brought on board as a developer to build the interface to the new Maple Lake merchandise planning tools. This involves using the Microsoft SQL Server stack to pull data from the existing data warehouse and Oracle AP21 system into staging tables.Over time the role evolved to include ongoing support of the data warehouse and associated systems.

Company Description: Government department concerned with the distribution of funds for community services, and the assessment of outcomes from funded programs.Position Description: Develop a SQL Server data mart and a set of SSRS reports according to specification.Technical Skills: SQL Server 2012T-SQL scriptingSSRS Data mart designIn More Detail:T-SQL scripts were developed in accordance with the department's standard practise. I was responsible for the data mart design in order to satisfy report requirements. Unique challenges were presented in trying to synch and link data between two systems that operate independently.

Company Description:WOW was a chain of electronics superstores with a growing E-commerce business.Position Description:Extend and improve the existing OLAP data cube, as well as diagnosing and fixing day to day problems with data loading and reports. Position terminated after 3 months due to closure of company.Technical Skills:SQL Server 2008 R2SSAS & MDXSSISReport ServerIn More Detail:I was bought on board (by ex-Colorado colleagues) specifically to improve the existing SSAS OLAP data cube. During my time here I also added alerting to the overnight processes, updated the SSIS packages to bring more data into the warehouse, wrote Reporting Services reports, investigated EDI issues and updated applications that had been written in house for the purposes of Auto Replenishment of stock.

Company Description: Cook manufacture and sell medical products worldwide. Position Description: Develop and maintain a global data warehouse and deploy Business Objects XI, thus empowering users by providing easy access to company information.Technical Skills: Business Objects XI R2 & 3.1 : universes, security, scheduling, deski/webi reports, training usersSQL Server 2005Data warehouse development using star and snowflake schemasOLAP CubesCrystal Reports XI Visual Studio : SSIS ETL (Extraction/Transformation/Loading) packagesSSAS - Analysis for database optimisationIn More Detail:I was responsible for all reporting solutions in Asia Pacific and have designed and developed a replicated global data warehouse in conjunction with the US and EU teams. I used SSIS ETL tools to populate this from a variety of sources (SQL Server / Oracle / flat files) across the region. I installed Business Objects XIR2, upgrading from v6.5 and converting the existing Crystal Reports over to Webi/Deski documents. More recently I have migrated this system to BO XI 3.1.

Company Description: Transtoll produce hardware and software solutions for tolling systems globally. Position Description: To take responsibility for the reporting aspects of the tolling and account systems. Technical Skills: C#.NETCrystal Reports v10 Oracle databasePL/SQLIn More Detail:Initially I was employed as a contract Crystal reports analyst. These reports were to be loaded through a web enabled C#.NET web interface, however the interface itself was incomplete and contained a number of prominent bugs and I soon took over the development of this site to ensure that my reports were being delivered satisfactorily to our clients. Later on in the project I was asked to produce reports for parts of the database system that had not been developed. I taught myself to develop in PL/SQL and produced complex database functions that periodically aggregated large volumes of traffic data into manageable and meaningful figures for time critical reports.

Contract position. My role was to add new functionality to the grants tracking web-database system and to develop and modify reports.

Company description:PriceWaterHouse Coopers provides industry-focused assurance, tax and advisory services.Position description:To develop custom Human Resources software, as well as providing first level support internally.

Managing testing aspects of the projectProduction of user manualsTechnical supportInvestigating new components for inclusion in projectLiaison with HR staff to ensure requirements were metLiaison with software development team to have problems corrected; Company description:XtremeLok produce licence management and anti-tampering software.Position description:To identify, document and carry out test cases. Technical skills:Developing tests to measure system performance, potential concurrency issues, usability and existing/new functionality,Carrying out testing on multiple platforms,Setting up testing environments,Liaison with software development team to have problems corrected,Producing technical documentation including specifications and user manuals, Administration of defect tracking system (Test Director)Input into system design and web GUI

Company description:d-Cypha are a provider of key electricity data management services to the New Zealand market, and have been responsible for national reconciliation since the market was deregulated.Position description:Employed as the expert on the Avalon database and software, I was responsible for ensuring that the latest version of the meter data software functioned correctly. Technical skills:Oracle v8 administrationSQL query developmentSet up and administration of custom database software (windows and web)Developing test scripts to measure system performance, potential concurrency issues, usability and existing/new functionality,Administration of defect tracking system (ClearQuest)Liaison with software development team in Finland,Producing technical documentation including specifications and user manuals, Devising and implementing a system security policy Reviewing system upgrade documents, Took the initiative to create a central documentation repository, then organise and update all documents relevant to this project.

Company description:Enermet provide solutions for energy information management.Position description:Install, customise and support a web-integrated database system for energy metering data. Technical Skills:Oracle v8 (development and administration)ASPSQL query developmentSoftware testingEvaluating system requirements and performanceClient training and technical support internationallyPreparation of technical documents for: Operations and Training manuals Hardware and Software specifications Service Level Agreements Service Continuity Plans (disaster recovery)