Project Manager Analyst

Malcolm Wanstall

Location:Mobile:please askEmail:*.********@*****.**********:

“Business Intelligence Analyst and Architect with strong Project Management and Stakeholder Management skills.”

Skills Overview

Chronological Skills Experience Chart

Mouse over an area to view the % of life dedicated to that skill at a particular time

Skills Summary

With a background in business analysis, database design and application development, I also have strong interpersonal skills which make the "people" side of business analysis my forte. A definite mix of technical and social skills gives me the ability to sit both sides of the fence relating and working equally as well with managers, customers and business people as I do with support departments such as IT and Finance. Whilst my recent experience has been in the Business Intelligence and Datawarehousing arenas I have broad interests in the general science and economics of business, economics and marketing and have a keen ability to learn new roles and skills quickly.General ProficienciesBusiness Intelligence ArchitectureProgramming Language ExperienceC#MajorHTML/CSS/JS etcMajorC++MinorComputer Application ProficiencyProClarity/PerformancePointSQL Server///SAP (backend)CRM Dynamics (backend)Clarify CRM (backend)Operating System / EnvironmentsWindows XP/Vista/7Windows Server 2000/3Linux (Debian)

Education

Degrees

2001 - 2004

B Business (Information Systems)

University of Western Sydney

Grade Average: Distinction

Key subjects: Project Management, Advanced Business Application Development, Database Design and Development, Statistics

Highlights: 1 Year Project soliciting requirements, designing and implementing CMS solution for a national company. Received High Distinction and offered employment by client.Courses

2008

Business Intelligence Bootcamp

Dimension Data

2008

MS Reporting Services Administration

Dimension Data

2008

MS Analysis Services Administration

Dimension Data

2008

MS Integration Services Administration

Dimension Data

2006

Advances SQL Server 2005

Dimension Data

2006

C# .NET Programming

Dimension Data

2006

SAS Advanced Statistical Analysis

SAS Institute

2006

SAS Programmers Bootcamp

SAS Institute

Memberships

2009 - Current

International Institute of Business Analysts

2009 - Current

International High IQ Society

2006 - Current

Sydney Linux Users Group

2006 - Current

SyPy - Sydney Python Users Group

Employment History

Business Intelligence Analyst / Consultant / Project Manager

Medibank Health Solutions

June 2011 - Current

Achievements:Initiate and manage Greenfield BI/DWH project including:- Elicit Business Requirements and assess current information/reporting capabilities- Build BI/DWH Taskforce to design and implement Data Warehouse based on Business Requirements- Manage project through Discovery phase to build Business Case- More to come as the project progresses...Skills Summary

Business Intelligence Analyst / Consultant

Capiotech (Consulting)

March 2010 - June 2011

Achievements:Embedded with Vodafone Hutchison Australia (telecommunications) working on end-to-end BI systemsFull Universal Layer strategy implementation analysis using Teradata and SAS.Consultant Business Analyst for VHA designing BI dimensions and measures on top of multi-billion row transactional systemsWorking with multiple systems due to Vodafone / Hutchison merger to implement a uniform BI/reporting layerSkills Summary

Business Analyst - Business Intelligence

Roche Diagnostics Australia (Medical)

March 2008 - March 2010

Achievements:Designed and developed Business Intelligence and Datawarehouse system based on Microsoft and Cognos technologies.Developed and deployed new reporting solutions through SQL Reporting Services and SQL Analysis Services and integration through MOSS (~70 Reports).Developed Budget Maintenance Applications to allow immediate business feedback into plans and next day reporting.Gathered requirements, wrote solutions and managed stakeholders for local and regional projects ranging from Contract Review Process to Integrated Business Reports using both Iterative and Agile methodologies.Skills Summary

Technical Business Analyst - Data Warehousing

Case New Holland Australia (Agriculture)

June 2006 - March 2008

Achievements:Designed custom Datawarehouse and Reporting Platform based on Oracle BI Suite consisting of 30 reports and dashboardsDesigned and developed OLAP cubes and interfaced existing reporting systems with OLAP dataRan project to reduce obsolete stock held from $40M to Designed and developed business critical database to support Aftersales staff and services in Obsolescence ManagementDeveloped and implemented custom Warehouse Barcoding System.Implemented Demand Management Systems MRP and designed/developed interfaces to legacy mainframe systems via SAS.Developed reporting solutions and supplied ad hoc Business Intelligence support.Ran ad hoc business queries and analysed data to provide business statisticsSkills Summary

Lead Systems Analyst

Cellix Systems (Software Development)

March 2005 - July 2006

Achievements:Developed custom CMS libraries and integrated several Open Source solutions to create a deployable CMS systemDeveloped and implemented mobile quoting facilities via web-services enabling immediate customer quoting based on defined real time business rules (previous quote-response being 24 hours)Skills Summary

What Makes Me Tick

Interests / Hobbies

Music

Played trumpet since I was 4; also play guitar, dobro, piano, most brass and dabble in other strings. I got through Uni being a part-time music teacher and playing in bands. I still play regularly but mainly guitar only now (my chops aren't what they used to be). I enjoy listening to blues and jazz predominantly but also enjoy classical and rock. Currently in my playlist I have good ol', some and our local boys and the 'finger.

Sport

Really enjoy cricket; am a much better spectator than player but enjoy both. Really like the longer form of the game. To keep fit I enjoy squash and the odd bit of cycling and jogging.

Data Visualisation and User Interfaces

Much of my personal study goes into these areas as they both interest me a lot. With the wealth of data that's being opened up of late there is no end to experimenting with some cool GIS data or some fancy new UI tools.

Emerging Web Technologies

In fact, all emerging technologies. Currently the massive growth of the mobile technologies is keeping me really interested as well as the push to try to cater for the new web with HTML5 and CSS 3 and some craftier web frameworks. It's an exciting time to be alive!

Honours

Lions Club Youth of the Year 2009 Judge

Lions Club Youth of The Year 2007 Judge

Regional Public Speaking Competition Winner 2006

Represented Australia in Montreux Jazz Festival Big Band 2004

Contact this candidate