Consultancy Profile

 Details about past projects and consultancy background can be found here.

 In doubt, please ask.

Professional Services - Home | Consultancy Profile | Data Management | Education | Contact Us || Site Map || Last Modified: 12 October 2019

 

Consultant Profile: Pascale Stendell

Pascale has developed specialist competencies in the Data Management area since joining Oracle in 1996 as a Data Modeller and Oracle Designer (CASE) education consultant. She also trained on Java and participated in early reviews of Oracle 8i in San Francisco given her University research focus on Object Orientation. Since 1998 she has primarily consulted in the areas of Data Governance and Data Architecture Management, Data Development with a focus on Data Modelling, Reference & Master Data Management, Data Warehousing and Enterprise reporting, and Data Quality Management. She shared some lessons learnt at the ACS Conference 2010 in the Data stream on behalf of DAMA-Canberra and continues to share her experience and seeks to learn from her peers for the improvement of the industry.

Presentations made to the industry include:

Pascale also provides pro-bono consulting to community and not-for-profit local organisations typically helping in the areas of data management and information sharing over the web. Such projects come with other sets of challenges with a greater emphasis on user buy-in. Such experience complements her other professional assignments as successful implementations are those supported by people who believe in the solution and wish to be involved. The human factor proves to be the greater risk and requires a greater focus than the underpinning technology.

Formal qualifications, Certifications, and Professional Membership

Bachelor Degree in Applied Mathematics and Computer Science (Honours) from the French Engineering school ENSEEIHT, Polytechnique University, Toulouse, France. This included one year at the Research Department of the School of Computing Science at the University of Technology, Sydney. Research involved Object Orientation, Eiffel, and compilers. Further education include a Graduate Diploma of Education from UTS, Sydney, and a Certificate IV in Training and Assessment (TAA). Certifications include Microsoft Certified Professional (MS Access), Oracle Masters in System Analysis, and Sybase PowerDesigner Data Modelling Professional. Access Pascale's full professional profile on LinkedIn. Pascale is a member of the DAMA association and uses the DAMA DMBOK as a framework to guide project activities to solve data management issues.

 

Consultancy Profile: Services and Solutions provided to organisations of any size and any business sector.


IT Matters clients benefit from broad industry knowledge - as per the below list of projects - which extends to Air Traffic Control, Community Work, Meat Business from farming to retailing, Legal Costing.

 

 

Small Businesses

Corporations

Government Departments

 

Projects

Note that the details of the organisations may have changed - including name, website link, and logo - especially government departments whose port-folios are redefined over time.

 
  • Corporate Standards, Data Modelling ... Back to client list
    NSW DPI: Pair development of the Information Management Framework and Data Strategy inclusive of the Enterprise Data Modelling Framework - developing the Enterprise Contextual, Conceptual and Logical models - based on published patterns incorporating standards, and project models. Facilitate the integration of the EDMF in NSW DPI Software Life Cycle and Business Teams. Promote collaboration and architecture.
    Environment: Sybase PowerDesigner, SQL Server, Oracle
     
    AFMA: Pair development of the Information Management Framework and Data Strategy based on DAMA DMBOK. Peer-review of data governance, and database administration strategies; develop data definitions, and data modelling strategies including standards for data modelling using PowerDesigner
    Environment: Sybase PowerDesigner 11 and 12, Twiki
     
    IBM, USA: Beta testing of Rational Data Architect, and further useability testing
    Environment: Rational Data Architect
     
    AusIndustry: Develop a Corporate Data Model in the context of a new system for the electronic processing of application and delivery of grants.
    The project included the development of data modelling standard, training staff to use Oracle Designer (CASE tool) to document data holdings, providing technical advice
    Environment: Oracle 8i, 9i on Unix and NT, ERWin, Oracle Designer 6i, Oracle Reports R6i, Rational Requisite Pro
     
    Air Services Australia: Develop prototype data models and designs to support the drawing of maps and routes whilst considering the conflicting peculiarities of a variety of international and national data and standards.
    Environment:Oracle Designer
     
    Australian Customs: Provide support to the data management team in regards to the data models for the Cargo Management Re-engineering project
    Develop the standards for Data Modelling for the future releases of the project. Facilitate the adoption of generic concepts and entities to make the model more complete and generic in order to fit into the Corporate architectural framework
    Environment: Cool:Biz, Cool:Gen
     
    IP Australia: Develop the corporate standards for Data Modelling, Database Design and PL/SQL programming.
    Participate in the validation of the Data Model for the Corporate Customer database. Creating the Data Model for the New Patent System.
    Participate in the analysis of the National Archives requirements for documents in the context of the data model.
    Facilitate the analysis of the requirements for the financial interface from the adopted EDMS to SAP.
    Environment: Oracle 8, Unix and NT 4, Oracle Designer 6i, Rational Rose, Objective EDMS, XML, SAP.
     

  • Executive Reports, Data Warehouse, Data Migration ... Back to client list
    NSW DPI: Various executive reports to support compliance of NLIS, and to support management decisions across the BioSecurity division. Includes provision of data for the purpose of mapping.
    Environment: SQL Server 2008 and 2012, Business Objects 4, Crystal Reports, ArcGIS
     
    AFMA: Business Process and Data Modelling to integrate Observer data in the datawarehouse. Develop wiki content to increase user awareness towards better information management. ETL of ISMP data to datawarehouse. Provide input in evaluation of ETL toolset.
    Environment: Sybase PowerDesigner 11 and 12, Oracle 10g and 11g, TOAD, Visio, SourceSafe, Twiki, MS-Access
     
    Immigration: Build a new Integrated Data Store to support datamarts for the Compliance project - including alignment to the Corporate Data Model artefacts and intent, and to the Corporate Business Process Model.
    Environment: Modelmart and ERWin 7.3.5, DB2 v9.1
     
    ATO: Map Siebel Conceptual model to Enterprise Data Model in the context of data warehouse design - involving liaising with Siebel development teams to get consensus on business rules. Include such rules in the ERWin Siebel logical data models so as to be quality input to the Enterprise Data Model. Working closely with the ATO Enterprise Data Modelling team.
    Environment: MS-SQL Server, Siebel 7.7, Teradata, ERWin; Large team of over 300 consultants
     
    Family and Community Services: Conduct data migration workshops and develop SQL reports and programs for Release 3 of the F(aCS) O(nline) F(unds) M(anagement) S(ystem).
    Environment: MS SQL Server - Enterprise Manager, Query Analyser, MS Access, Siebel 7.7
     
    eBusiness, ITR: Develop a Data Warehouse to support the web publishing of data for Executive reports - including the facilitation and implementation of enterprise-wide customer definitions to support enterprise reporting.
    Environment: Oracle 9i database; Oracle Designer; Microsoft .Net framework
     

  • Education and Training ... Back to client list
    BHP, IT: Provision of educational services: course delivery and course design; a database design course was designed in cooperation with BHP IT in Newcastle.  
    Oracle: Provision of ad-hoc delivery of Oracle scheduled courses in the CASE, Web, and Java streams (Adelaide, Brisbane, Canberra, Melbourne, Sydney)  
    State Rail Authority: Provision of services for Upgrade, Installation, and Training for Oracle Designer 6i.
    Review current Oracle Designer environment, Provide recommendations as to preferred framework; Install software; Negotiate Course Outlines; Create Training Material and Deliver courses
    Environment: Sun Solaris - Oracle Designer 6.0, 6i Release 4 - Oracle 8i
     
    TAFE Training Division: Acted as course reviewers for the NSW TAFE Information Technology Training Division. State wide courses such as C++ for C programmers, Unix.
    TAFE Plus: Developed and Delivered C++ courses for TAFE Plus.
     

  • Grant Management System ... Back to client list
    ONHMRC: Data Modelling, Database Design, Web Development to support an eCommerce application based on Java and Oracle technologies for the lodging of medical grants and the management of allocated funds.
    Environment: Oracle 7, and 8, Unix and NT 4, Oracle Application Server v3, Toad, Oracle Designer, JavaScript, HTML, XML, Source Safe
     

  • Small Business Projects ... Back to client list
    Meat Retailer: Development of a web-based solution to support ordering of fresh meat online.
    Environment: Excel; HTML
     
    Australia Post Franchise: Development of a database solution to support post office box allocation and management. Ordering and Management of stock.
    Environment: MS-Access; Windows 95
     
   
ABN: 49 961 107 252 IT Matters Consultancy Profile