Data Warehouse Consultant
MIP
Total years of experience :17 years, 8 Months
MIP - Sydney
Period January 2013 - Present
Position Data Warehouse Consultant
Responsibilities • Using Wherescape RED to build 3rd normal form data warehouses, data stores and star schemas.
& • POC's using Tableau 7 and Tableau 8 to build business intelligence dashboards and data visualizations.
Achievements
Qantas Frequent Flyer - Qantas Airways Limited - Sydney
Period January 2011 - January 2013
Position Senior Business Intelligence Developer: Group Loyalty IT Services
• Lead Designer in high-profile income generating project for finance. The scope of the project is matching
orphaned demographic data from credit card partners to member information in the Loyalty DWH.
Development and implementation of an orphans matching data-model on a Teradata warehouse and developing a reporting solution in Hyperion 9.3 Interactive reporting to track points sweeping for orphaned members.
• Process improvement for reviewing matched data and follow-up with credit card partners.
• Building star-schemas and semantic views on core DWH for Cognos 10 reporting.
• Publishing & maintaining Cognos 10 Framework Manager packages on Cognos production and development
servers.
• Lead Designer in the implementation of Cognos 10 Cubes for Self-Service reporting using Analysis Studio
Responsibilities • Development of POC for Cognos Mobile 10.1.1
& • Develop new Cognos 10 reports to source data from the new DWH for Loyalty.
Achievements • Administration of Cognos 10 Production environment, user access and security, synchronization with development, report migration and server/database audit trail.
• Lead a POC to compare features of Tableau 7 Vs Cognos 10.
• Administration of Tableau 7 Server for Loyalty Analytics, setting up connectivity to Teradata and Cognos
mdc cube files, maintaining active directory users and publishing dashboards for business users.
• Monitoring of daily batch processes for Loyalty DWH using Oracle Data Integrator.
• Automation of member point reconciliations performed by the Operations Team. Designing reconciliation
data-models and building a user interface in Hyperion 9.3 for users to import files into the model and publish reconciliations and reports to the Loyalty DWH.
• Development and deployment of Teradata transform views for application specific layers.
St George Bank - Sydney
Period April 2010 - November 2010
Position Technical Lead - Senior Solution Designer: Enterprise Business Intelligence
• Technical lead for the design and implementation of GDW extracts to CRCE (Credit Risk Calculation
Engine) for APRA reporting & Basel II accreditation for the Transaction Managed Portfolio.
• Analysis of GDW (Group Data Warehouse) source systems and negotiating with the Westpac project team
alternate GDW sources for commercial data required for SME Retail segmentation within CRCE.
• Involved in all aspects on the design, build, test and delivery of the Transaction Managed stream within the
Responsibilities
St. George Group Data Warehouse for Customer Behavioural Scoring.
& • In-depth analysis for 200 customer and account variables over 26 months of history data. Documenting
Achievements
detailed impact assessments in light of changes to derivation rules and sources of data for the TM stream
• Reconciliation of GDW data sources for Margin Lending, Scottish pacific and Treasury products.
• Providing recommendations and design options for current GDW processes for CRCE.
• Conduction walkthroughs on the HLD (High-Level design) and TDD (Technical Design Document) for approval by TM project stakeholders.
Vodafone Australia - Sydney
Period September 2008 - March 2010
Position Technical Lead - Solution Designer: Business Intelligence
• Created a BI prototype application for executives and general managers on Blackberry devices (Bold & Responsibilities Storm) . A big winner with a slick interface and customer experience, the purpose was delivery of customer
& activity, channel sales, top 3 daily prepay and post-paid product sales and monthly revenue and financials.
Achievements Devised the architectural framework for the application on the data warehouse using the EDM framework.
Created the mechanism for daily file transmission and collaborated with external vendors to facilitate the
-2-
successful project launch.
• Led the delivery and deployment of a sustainable tactical solution for Customer Value Management. This
involved defining scope requirements and developing an application specific layer to publish a monthly
reporting suite consisting of 15 reports. The reporting pack provided insight into APRU, churn,
segmentation, usage and revenue. Trend reports provided insight into customer value band movements and prepay and post-paid product penetration across market segments.
• Designed and implemented, in collaboration with Campaign Insights and Marketing, a pre & post campaign
analysis tool to monitor campaign performance, alerting on target contact customers for sales and retention
campaigns. Implemented using Hyperion 9.3 Interactive Dashboards.
• Designed and implemented a consolidated reporting solution for the release of the 3R project (Revenue
Recognition & Reconciliation), a high-profile project for treating revenue generated from post-paid capped
plans. Implemented using Hyperion 9.3 Interactive Dashboards.
• Analyzed, built and deployed a Project Status Dashboard for Business Intelligence Analytics for tracking
project requests and communicating project timelines to business stakeholders. Trained users on using the application.
• Managed the introduction of a prototype environment for agile project deployments. Developed and released tactical and strategic implementations of numerous BAU reporting projects.
• Recognized for a Star Award for the successful delivery of Customer Inflow/Outflow Reporting, shifting
business perception in a positive direction on the capabilities and attitude of the Business Intelligence
team.
• Collaborated in the rationalization of published reports on the Hyperion web portal.
• Minimized recycles for ETL streams of the Enterprise Data Model by investigating root cause,
implementing modifications and production release.
ASIC - Australian Securities & Investments Commission - Sydney
Period June 2008 - August 2008
Position Data Warehouse Analyst - Systems Architect: ASIC
• Designed and developed logical and physical data models and data dictionaries on IBM Informix data
warehouse. Utilized System Architect Modeling tool to publish logical entity relationship diagrams & physical representations of the Complaints Management System and Company Registry model.
Responsibilities
• Utilized conceptual and analytical problem solving skills to create 3rd Normal Form physical models for & data-loads from Lotus Notes databases. Overcame challenges of populating data-models from a non-
Achievements
relational database source which involved developing data-cleansing streams and ETL processes.
• Developed reports using BI Query and assisted end users with data warehouse queries.
• Migrated existing BI Query reports to a Cognos 8 Impromptu reporting platform.
Commonwealth Bank of Australia- Sydney
Period November 2007 - May 2008
Position Data Warehouse Consultant/Senior Software Developer: Premium Business Services - MIS
• Designed a robust and scalable Reporting & Reconciliation solution (Hyperion 9 Dashboard) for the
Finance Improvement Program. The application provided dynamic reporting on balance sheet accounts,
MTD and YTD profit & loss reports, spot & average balance reports and balance movement reports by accounting period.
• Solely involved in all aspects of the analysis, design, modeling, build and population of the reconciliation
reporting data-model (Teradata platform) and liaising with business stakeholders to refine requirements.
• Worked closely with business users to prepare detailed functional specifications and refined existing
processes for reconciling product system feeds for home loans, direct deposits and the credit card system.
Responsibilities
• Maintained & synchronized environments on Teradata for development, user acceptance testing and pilot- & production releases. Ensured issues raised were resolved in a timely manner within the SDLC process.
Achievements
• Developed a back-end automated process on a UNIX platform to run the monthly reconciliation process.
• Performed stress and volume testing on the Reconciliation & Reporting Dashboard and ensured
consistency of functionality in both Interactive Reporting Studio and the Hyperion thin-client (web
client/portal), a new technology adopted by the bank.
• Designed and implemented a Hyperion 9 Dashboard for the Data Migration team which incorporated drill- down capabilities on data loads from product systems onto a Teradata platform. The dashboard identified
data quality issues on the GDW and facilitated quick resolution of issues with source to target load
processes.
AMP - Sydney
-3-
Period September 2007 - October 2007
Position Business Analyst: Business Intelligence
• Coordinated business requirements for the BI Consolidation Project in the Enterprise Data Warehouse at AMP. Initiated the implementation of DOORS for Requirements Management. (Dynamic Object
Oriented Requirements System by Telelogic) . Standardized business requirement templates and
Responsibilities
consolidated specifications in a single repository.
& • Involved in resolving production support issues and ensuring the changes are implemented in the
Achievements
production environment by the due date.
• Hired as a business analyst for Project EDGE (Electronic Document Generation), project funding was
not approved. This role was a short term consulting contract as a result.
Optus - Sydney
Period July 2007 - August 2007
Position Data Warehouse Consultant: DWS
• Worked in the Consumer Sales division on Project Blue, developed Teradata macros required for the
Responsibilities data cleansing process for the Business Intelligence layer used by Cognos reporting.
& • Physical & Logical Model representation for Project Blue using the Erwin Modeling Tool.
Achievements • This role was a short term consulting contract. During my time at Vodafone, the company Globalsoft was
sold to DWS and I resigned from DWS only 2 months after I was consulting at Optus.
Vodafone Australia - Sydney
Period June 2005 - June 2007
Position Data Warehouse Consultant: Globalsoft / DWS Business Solutions
• ETL stream developer for Customer, Account and Subscription facets of the Enterprise Data Model.
Modeled the Product Hierarchy facet and was involved in all aspects of SDLC for ETL processes in populating the EDM.
• Released numerous ETL streams for Program SAM. Trained staff on the EDM Framework & Script
Generator.
• Developed and implemented the release of Brio / Hyperion reports for the Finance Reporting Project.
Responsibilities
• Subject matter expert for the Customer, Account & Subscription facets of the EDM.
& • Developed the process and extracts for downstream feeds for LARA IVR, Superset feeds and Handset
Achievements
Upgrades. Ensured the data warehouse extracts were ready for the successful project launch date.
• Performed detailed reconciliation of 3R (Revenue Recognition & Reporting) for prepay and post-paid
customers.
• Gathered requirements from business users and documented Business Requirement Specifications
(BRS)
• Working closely with Marketing, CRM and Revenue Assurance to ensure 3R UAT was fully supported.
Position Analyst / Programmer: Equities IT \[Dec 2002 - May 2005\]
• Primary point of contact for daily production support issues related to the in-house P&L system used by
Equities Controlling (Cedar) . Developed equities commissions, trading positions and settlement reports.
• Developed and supported Brio/Hyperion EIS (Executive Information Screens) for Management,
Controlling, and Operations & Compliance. Automated journal extracts from Cedar to SAP GL.
• Automated the equities position reconciliation, Cedar to Shares to General Ledger. Change
management. Bug fixes. Disaster Recovery testing for equities systems.
Responsibilities
• Monitoring and support of overnight batch processes, data-feeds and extracts to various internal and & external sources.
Achievements
• Developing and automating the process of reporting the Deutsche Bank Installment Warrants P&L.
(Sybase stored procedure back-end development / user interface in Cedar (PowerBuilder application) and Brio/Hyperion dashboard/EIS)
• Administration of Brio Broadcast Server Service. Resolved application security issues raised by Audit.
• Developed equities commissions, positions and settlement Brio reports by analyzing user requirements and data.
Deutsche Bank - Sydney
Period June 1997 - May 2005
Position Software Engineer: Equities IT \[Jan 2001 - Dec 2002\]
Responsibilities • Led the completion of a migration project of MIS reports developed in Microsoft Access to Brio/Hyperion
& reports.
-4-
Achievements • Developed & Supported Executive Information Screens for cash equities traders, management,
controlling, operations & compliance. Brio Broadcast Server and On-Demand Server administration.
• Gathered business requirements for new product releases in the in-house profit & loss system.
• Developed Brio reports, specifically commission reports used by equities traders, shares position reports for Equities Controlling and trading/settlement reports for Equity Operations.
Position Accountant: Equities Controlling IT \[June 1997 - Jan 2001\]
• Performed all month-end accounting responsibilities such as general ledger reconciliation, month-end
journal postings and balance sheet and P&L reconciliation and reporting.
Responsibilities • Responsible for daily reporting of the cash equities P&L for Australian Equities and Offshore P&L
& consolidation reporting. Designed and deployed a Lotus Notes database for Cash Commissions.
Achievements • Monthly reporting of corporate revenues and commissions generated by Deutsche Bank Australia & New Zealand together with market activity information to Global Markets.
• Trained new staff on the P&L process and cross training on the trading and derivatives P&L process.
Egyptian Fund Management group - Egypt
Period June 1995 - March 1997
Position Fund Accountant
• Weekly calculation of the market value of the Mutual Fund Investment Certificate of the Egyptian American
Bank and the Bank of Alexandria. Managing Fund cash balance by channeling it into treasury-bills and time
Responsibilities deposits.
& • Daily tracking and follow up of Fund-related stock exchange trade transactions.
Achievements • Financial analysis of balance sheets which included ratios and cash flow statements.
• Involvement in Initial Public Offerings of major prospectus (Helwan Cement Co. & Nasr City for Housing and Development)
Institution Helwan University City/Country Cairo, Egypt
Bachelors of Business Administration. Recognized equivalent to Australian degree by COPQ. Completed 1993 Institution St. George's English School City/Country Rome, Italy
Qualifications O Levels Completed 1987 The following certified courses were completed: • Sybase - Fast Track to PowerBuilder 8.0 - Fast Track to Sybase SQL - Brio Query EIS development • Understanding the Unix environment - Advanced Unix Shell scripting Professional • Wherescape RED - Integrated Development Environment