Garry Farrell Email & Phone Number

Sydney, Australia

St Leonards

As the Principal BI Consultant I am responsible for pre-sales, internal strategy, project management, and building the BI practise.

Sydney, Australia

Technical Project Manager - Multi department data warehouse system using SSIS, SSAS, SSRS and SharePoint BI. Designed extracts from SAP, Oracle Financials, Chris21, MRI, Sybiz. My team consisted of MS stack BI developers, DBAs, a BA, Tester, and document writer.

Sydney, Australia

Engaging client businesses at the Executive level. Designing a BI solution and change program. Development of custom business solutions utilizing the Microsoft BI platform, Analytic Software, Cognos 10 and forecasting software.

Sydney, Australia

Datawarehouse management and reporting from SQL Server BI platform. Involved with SSRS, SSIS and SSAS.Roche has many different product lines which are sold through different business units. Each business unit has significantly different business logic which makes for a challenging evironment as a BA.

Responsible for Marketing direction, brand development, web site design, SEO and SEM, traffic growth, and advertising budget. Developed brand strategy and business automation systems. Smeeko is a new startup company in 2009.

Responsibilities/Achievements: Constructed a VMWare automation system which automates the task of creating new servers.Part time my responsibility of General Manager included to set the marketing direction for Smeeko, direct and sign off on the web site design, create an automated system to insert new clients into the billing system, Implement Google Adwords advertising campaign.CA Ingres BI platform report writing and cube design.

Developed at completely automated VM-Ware based hosting system. User would sign up on in the web site and chose the OS and applications, the client was added to the automated billing system, the server was provisioned. PayPal payments.

Internal group consultant/project manager for Cognos BI tool systems and IBM Assest Management softwares.

6 years Business Intelligence architecture/analystDesign of web and database systems, SQL Server, DTS, T-SQL.Analysis, Change/Project Management of IBM Cognos reports and Cubes, web and IBM Asset Management systems.Automated system to deliver reports via email.IBM Cognos Systems upgrade and TrainingEnd of Life Change Management and planning.Major Achievements:Group IT IBM Cognos Enterprise Reporting System. Pagetracker project key technology consultant, change and quality control, analysis and user requirements. The project involved T-SQL, DTS, MS SQL Server, automated report emails, DBA, IBM Cognos Business Intelligence software and reporting and networking. Coordinated project team across 2 sites, wrote documentation and presented training.Project Manager of the Business Intelligence system and the continuous improvement plan including Business Case Reviews to ensure alignment of the project and the business case.Major IBM Cognos software system upgrade and configuration.Windows Server build with clustered SQL Server for IBM Cognos platform.Project Manager PeopleSoft to IBM Maximo interface project for two sites, Sydney and Melbourne, and liaising with Head Office. Develop change intervention strategy and change control process. Developed functional specification as the Maximo and SQL Server database expert and project programmer, VB.net, SQL, SQR, DTS, MS SQL Server. Coordinated project team, documentation and training.Project Manager of IBM Asset Management Systems Upgrade project managing internal clients, management, supplier and technical personnel. Ensuring project specifications met business requirements and internal technical specifications. Development of change management program, training plans, implementation and contingency plans. Also performed all technical aspects including data mapping for upgrade, writing reports and testing. MS SQL Server, VB.net, SQR, event based notifications.

Responsibilities/Achievements: Business Analysis / User Requirement gathering / Change Management / Project Management of three major developments. Hotel Room booking system with Room Service Ordering and Accounting Reports, Restaurant Ordering and Account Reports, Shop barcode scanning POS system.

Responsibilities/Achievements:Responsibilities:1.IT Infrastructure, desktop management system, desktop application support/training.2.Communications Engineering3.PLC Automation system programming. Enterprise scorecard/metrics display programming.Major Achievements:1.Implementation of PLC Automation system programming. Enterprise scorecard/metrics display programming.

Gccm, Change Management

Post Graduate Change Management

Bachelor'S Degree, Electrical Engineering

Activities and Societies: UNSW Taeknowdo team. Pairs Forms Demonstration Champion.Institution: Australian Graduate School of Management.

Be, Electrical

Activities and Societies: Taeknowdo Competition TeamElectrical Engineering. Thesis on Satellite Tracking GPS.

Bachelor Of Engineering - Be, Electrical, Electronics And Communications Engineering