Greg Cooper Email & Phone Number

Sydney, Australia

Determining stakeholder requirements and supplying the Datawarehouse aspect of solutions to them, incorporating the Microsoft BI stack (SSIS/SSAS/SSRS).

North Sydney

Developing cubes in SSAS, reports with SSRS and ETL using SSIS, to satisfy the requirements of Marketing and other areas.

Used SSIS and developed complex SQL stored procedures and functions.

Implemented a major transport industry compliance system, liaising with Government (Federal and State), mapping suppliers, software suppliers locally and in India, joint venture partners and their contractors.Specified requirements for software suppliers, set up and ran acceptance testing and wrote detailed specification of fixes for developers at joint venture partner and in India. Analyzed requirements and collaborated in the design of SQL Server 2005 databases central to the… Show more Implemented a major transport industry compliance system, liaising with Government (Federal and State), mapping suppliers, software suppliers locally and in India, joint venture partners and their contractors.Specified requirements for software suppliers, set up and ran acceptance testing and wrote detailed specification of fixes for developers at joint venture partner and in India. Analyzed requirements and collaborated in the design of SQL Server 2005 databases central to the solution.Used SQL Server Integration (SSIS) to extract and load data for unit testing and User Acceptance Testing (UAT).Investigated complex SQL queries written by third party developers and specified corrections/improvements/enhancementsDeveloped complex SQL queries as needed to resolve issues identified by the State Jurisdictions (eg. NSW RTA) using the system, liaised with those authorities.Collaborated in aspects of SQL Server 2005 administration – improving performance of queries, using SQL Profiler to resolve issues, replication, backing up databases etc.Converted digital maps supplied by Pitney Bowes/MapInfo to proprietary format using MapInfo Pro and the company’s own conversion tools.Streamlined, then outsourced this mapping conversion to India and Malaysia, training personnel in Mumbai and later in Kuala Lumpur. Both sites were self-sufficient after my handover.Retained customers by delivering customized reports which met their requirements (using Transact-SQL and Crystal Reports).Demonstrated the more complex aspects of the company’s telematics offering (eg. Scheduling) to assist the sales force.Liaised with colleagues in UK to resolve difficult software and mapping issues, significantly reducing resolution times. Show less

Developed and installed computer systems and software for beef and dairy breed societies in Australia, New Zealand and Canada (in French and English). My successful implementation with our first Canadian customer in Calgary paved the way for further business throughout North America. These systems included accounting capabilities and complex reporting.Used 4th generation Cognos software, relational databases, Create!Print for report formatting and DEC/Compaq hardware.

70-433 Microsoft Sql Server 2008 Database Development

70-448 Microsoft Sql Server 2008 - Business Intelligence Development And Maintenance

Graduate Certificate, Management

Graduate Diploma In Computing Studies, Systems Analysis, Programming Techniques

Bachelor Of Science (B.Sc.), Geophysics, Pure Mathematics