Profilbillede af DWHAndBIGuy
@DWHAndBIGuy
Flag for Australia Cherrybrook, Australia
Medlem siden 24. juli 2019
0 Anbefalinger

DWHAndBIGuy

Online Offline
Over the last 20 years I have specialised in designing and developing corporate data warehouses and the associated business intelligence reporting systems. I am an experienced project manager adaptable to any software development projects and project management methodology. I have skills in data analysis that leads to the design and development of the databases that underlie data warehouses, together with strong developer skills in SQL.
$75 USD/hr
0 anmeldelser
0.0
  • N/AJobs udført
  • N/AIndenfor Budget
  • N/ATil Tiden
  • N/AGenansættelsesfrekvens

Portfolio

Nylige bedømmelser

Ingen bedømmelser.

Erfaring

Data Warehouse & BI Project Manager / Project Architect

Aug 2015 - May 2019 (3 years)

Design BI strategy Built a new BI team of 9 Develop the Data warehouse Automated security processes Deploy Cognos Analytics dashboards to 280+ users Design & build a system to collate data from multiple corporate systems into TM1 cubes & reports to generate Cognos reporting outputs to a national Aged Care benchmarking program Integrate MS PowerBI

Data Warehouse & BI Project Manager / Technical Design Manager

May 2013 - Aug 2015 (2 years)

Designer of the architecture & software infrastructure modules for their private cloud based data warehouse based reporting solutions. Market research for this project involved contact with potential clients to determine the viability of the resulting products. Negotiated with key clients to provide beta testing sites for the systems

Business Process Re-engineering Architect / Project Manager / SQL Developer

Jan 2012 - Apr 2013 (1 year)

Worked with the Managing Director (& owner) to critically examine and re-architect their software development, support teams and technology platform. Designed a new version of their flagship Aged Care product to remove bottlenecks and data replication issues. Designed & built the SQL Server backbone of the system, including the database connectivity and manipulation scripts. Demonstrated a functioning prototype data warehouse and BI reporting solution to overlay their SAP ERP system.

Data Warehouse & BI Project Manager / DWH Architect / SQL Developer

Feb 2011 - Jan 2012 (11 months)

Proof of concept Data Warehouse & BI reporting system Designed & built the Prod SQL-Server based data warehouse and the Finance BI reporting system. The primary data came from SAP ERP New data warehouse and BI system around the proprietary Land Title registrations data source Master Data Management project to merge the Finance and Property information

Data Warehouse & BI Project Manager, System Architect

Sep 2006 - Feb 2011 (4 years)

The initial assignment was to design & build a data warehouse and BI system off their AS/400 data sources for Australia & New Zealand Aggregating data from 9 countries in the Asia Pacific region into a single data warehouse. Data from 6 different source platforms located all over the Asia Pacific. SQL-Server data warehouse. Regional BI via the internet. The BI system provided near-real time reporting

Data Warehouse & BI Project Manager, Technical Design Manager

Feb 2002 - Aug 2006 (4 years)

Reverse engineer OROS a proprietary database platform Extract OROS data to data warehouse system (100 million rows of data/month) BI reporting system for banking profitability analysis

Senior BI Project Manager

Apr 1999 - Jan 2002 (2 years)

Managed 16 data warehouse and BI projects for Cognos clients at the request of the Cognos Professional Services Asia Pacific Manager Provide project consulting to various Cognos clients running data warehouse projects. Provide post-implementation review services for Cognos Mentored junior managers and developers within Cognos Professional Services

Certificeringer

  • US English Level 1
    77%

Verifikationer

  • Facebook forbundet
  • Foretrukken Freelancer
  • Betalingsverificeret
  • Telefon Verificeret
  • Identitet verificeret
  • E-mailverificeret

Gennemse lignende freelancere