Lee Casaru Email & Phone Number

Sydney, New South Wales, Australia

Principal Consultant working on multiple clients.Dulux – Role – Principal Consultant. Design and Build One Stream Landing Pages to client's specifications. Design and Implement Task Manager to clients' specifications.Coles – Role – Principal Consultant. Design and Build One Stream Landing Pages to client's specifications. EBOS – Principal Consultant – Design and Build Power BI Dashboards and Models using One Stream Data Adapters and OneStream API.Les Mills – Role – Principal Consultant. Integrate Board Finance solution with CRM Financials and Snowfalke Database. Design and Build UI Design for Les Mills Application.Zimmerman - Principal Consultant. Integrate Board Finance solution with CRM Financials and Snowfalke Database. Design and Build UI Design for Zimmerman Application.Ingenia – Role – Principal Consultant. Design and Build and Custom Snowflake DWH. Using Azure Data factory to integrate Oracle JDE, CRM Dynamics and NewBook Booking System. Design and Build of Multiple Power BI Data Models and Reports. Sydney University – Role – Principal Consultant. Enhancements to Power BI Dataflows and Power Automate scripts. Connecting to Multiple Sources solutions SAP Ariba, People Soft, Service Now. Sydney University – Role – Principal Consultant. Migrating Hyperion Financial Reporting to Power BI Paginated Reporting. Migration of 30+ Reports from Financial Reporting.Downer – Role – Principal Consultant. Design and Build Reports, replicating HFM and TM1 reports in Onstream (80 +). Delivering both Cube View Reports and Cube View excel plug in reports. Wesfarmers – Role – Principal Consultant. Design and Build One stream Landing Pages for group and divisions. Design and build of dynamic landing pages with Interactive and logos, setting users POV and Workflow. Landing Pages. Working with OneStream API to extract Cube Views to Power BI Data Flows.Ateco – Role – Principal Consultant – Design and Build Board reporting packs.

Sydney, Australia

Senior Consultant working on multiple clients across many industries.Yoma Bank – Myanmar – Senior BI Consultant – Mentoring and consultancy to ensure best practices where followed during the implementation of OBIEE 12C and Oracle Exadata.Cochlear – Role – Senior BI Consultant. Working closely with manufacturing team to build integration via Informatica and DAC to load step by step manufacturing processes into Data warehouse from EBS. Australian Stock Exchange (ASX) – Working with Finance to develop Customer Story Dashboard. Developed and easy to use a suite of reports which followed the Customer Journey tracking 10-year window of customer and product trends and relationships. CBHS - OBIEE 11 - 12C Upgrade. Upgrade hardware, Databases from SLQ Server 2008 - 2016. SSIS Upgrade, Microsoft Server upgrade, and 11g - 12c Migration.Macquarie Telecom Group - Design and Build MTG budget and planning reports using Board 10.3, Develop PNL, Financial Statements, Capex, Opex, and Financial Statement reporting.Choice.com.au – Using ODI 12c to integrate several Cloud-based Solutions (Engaging Networks, Informizely, SMFC) into their existing Cloud DWH. Design and Document API and Data Mapping between Cloud solutions, build staging and Dimension and Fact Tables to incorporate external data into Cloud-based corporate Data Warehouse.SoneparPacific – Upgrade OBIEE 11g to 12c. Migrate 300 Oracle Discoverer Reports to OBIEE Answers and Dashboards. State Cover Mutual - Updated SSIS migration process to include new hierarchy data from Source systems.Brookfield – Tasked with integrating Chatham Financial Services with existing Data Warehouse using ODI. Enhancements to Treasury OBIEE Dashboards and the creation of Mobile Application using HTML 5.Multiplex - Install and implement OBIEE 12C Environments for Green Field BI Project.

Sydney, Australia

Appointed by LSNSW as Senior Consultant, responsible for implementing a green fields OBIEE 11g solution as part of the LSNSW Database Modernisation and Migration Project. A project to migrate from a legacy Unidata and SB+Client platform to an Oracle Fusion SOA integrated solution. My role was to design built test and implement through all stages of the project life cycle a holistic Business Intelligence Solution to meet the needs of the 16 business units of LSNSW. • Install OBIEE 11g DEV, SIT, UAT, PRD Environments• Design, Build, Test and implement Custom built data warehouse to meet multiple business functions within the LSNSW.• Design, Build, Test and implemented ETL (Oracle Data Integrator 12c)• Design, Build, Test and implemented custom OBIEE RPD.• Design Build, Test and Implement Dashboards and Reports • Upgraded OBIEE 11g from 11.1.1.7 to 11.1.1.9• Integrated BI Publisher with Oracle SOA Solution for form and legal letter delivery• Design, Build, Test and implemented NSW Land of Sale Contract online solution using BI Publisher 11g as delivery method for Land of Sale contracts.

Sydney, Australia

Senior ConsultantSiebel, SSSE, CTI, Usage Accelerator, BI Publisher. OBIEE 10g to 11g upgradeJoined News in April 2007 as Siebel CRM/BI Specialist working on the Siebel Upgrade project focusing on Enterprise Build, OBIEE 10g Installation and Setup, EIM Data Migration, PIMSI configuration, Hummingbird Search Actuate Reporting. Since Go Live have worked on future releases of OBIEE 10g and Implementation of BI Publisher to replace Actuate. Implemenation and Roll out of Siebel CTI Tool bar and GPlus Adapater. Currently Working on the OBIEE 10g to 11g Upgrade.

Australia

As a Senior Consultant employed as Solution Architect working with British American Tobacco Australia, working across large scale Projects, ran within this busy department.

As a Senior Consultant at Ciberion, I initially started in the development team, drawing up design specifications to client’s requirements, then configuring Siebel 6 to meet those specifications. I then worked upon the integration components and ETL components of the solution, integrating Siebel with a custom designed Data Warehouse and with back office ERP solution. On completion of Integration and Performance testing, I then progressed to work as a Senior Consultant on the Implementation team.

Involved in the Global Rollout of Siebel 97 through Siebel 99.6 Fields Sales Solution.