Ray Duncan
Principal Consultant, Tenzing Ltd
- New Zealand
- +64 291231194
- ray.l.duncan@icloud.com
Data Integration - ETL - Data Migration - Data Warehousing - BI - Data Quality - Data Modelling - Business Analysis
(SFIA: DATM 6)
General: Delivered strategy for data management and information architecture; developed and published plans for consistent information, retrieval, profiling, validation, pattern recognition and transformation; implemented data classification, security, retrieval and retention policies and processes; advocate of DAMA-DMBOK.
Data architecture: data integration (ETL), data migration, data warehousing, BI, UML, Sparx EA, TOGAF data domain, Zachman enterprise framework.
Master Data Management: linking, matching and de-duplicating.
Data Quality: improvement by profiling, parsing, cleansing and identity resolution (MDM).
Data Security: data classification, administration, authentication and auditing.
Meta-data Management: integration and delivery using centralised repositories.
Data Development: analysis, data modelling, database design and implementation.
Database Management: design, build, integrity, security and support for databases.
Data Governance: defined strategic enterprise data needs, data strategy, data policies, resolve data issues, regulatory compliance.
Big Data: hands-on training with Hadoop, HDFS, Apache Spark, MapReduce.
(SFIA: IRMG 6, SCTY 4, INAN 5)
Information Management: Complied with QGCIO policies and standards within QGEA framework; Developed enterprise data definitions, standards and architecture; Identified impact on information use and developed strategies for compliance; Implemented controls to measure performance and to assess and manage risk; Advised on business implications of information mined from business systems; Reviewed proposals and provided specialist advice on information management; Maintained a repository of information assets; Managed access requests; Familiar with TOGAF and Zachman frameworks.
Information Security: Devised security strategies and ensured adoption and adherence to standards. Conducted security risk, vulnerability assessments and business impact analysis on complex information systems. Contributed to information security policy, standards and guidelines. Advised on the application and operation of physical, procedural and technical security controls.
Analytical Techniques: Applied analytical techniques to create information to support and promote business decision-making using a variety of analytical and visualisation techniques.
(SFIA: BUAN 6, REQM 5, BSMO 5, RLMT 6)
Business Analysis and Requirements Definition: Managed business analysis across business areas; defined strategies; guided senior management; worked interactively with stakeholders to reach formal agreement; facilitated workshops, focus groups and interviews; investigated operational requirements; validated business needs, scope and priority; delivered business solutions; managed requirements traceability; improved information management; established baseline for solution delivery; developed detailed business models; BABOK.
Business Modelling: Promoted business strategy across multiple business functions; initiated modelling activities; reviewed models with stakeholders; developed process models (BPMN, UML, IDEF0, IGOE), data models (conceptual, logical, physical) and other (SWOT, state transition, value chain); TOGAF business domain.
Stakeholder Relationship Management: Promoted stakeholder objectives, requirements and overall vision; assessed communication needs and implemented a communications plan; managed issues, risks and action points; facilitated open communication, discussion and negotiation to promote understanding.
(SFIA: DESN 5, DBDB 6, DTAN 4)
Systems Design: Specified and designed complex systems; selected design standards, methods and tools; reviewed system designs to ensure appropriate technology, efficient use of resources and integration of multiple systems and technology; delivered impact analysis on major design options; assessed and managed risks; ensured design achieves functional, service quality, security and systems management requirements.
Database Design: Set strategies for effective use of database technology; provided expertise in use and operation of database management systems, tools and facilities; advised on selection, provision and use of database architectures, software and facilities; maintained specialist knowledge of database concepts, object and data modelling techniques and design principles; analysed data requirements to deliver data models and interpret into an appropriate database schema.
Data Analysis: Analysed corporate data and information requirements; applied business data mapping (CBDM certified), data analysis and data modeling (conceptual, logical, physical) techniques; managed data structures and associated entities, relationships and attributes; applied quality assurance techniques; catalogued data and information specifications using data dictionary repositories; database design.
(SFIA: ARCH 5, RSCH 5, INOV 6, BPRE 5, BURM 5)
Solution Architecture: Delivered logical models of components and interfaces to develop systems architectures; produced detailed specifications and designs for for implementation; provided technical advice on system development and integration; ensured technical strategies, policies, standards and practices are applied correctly.
Research and Innovation: Spearheaded research, identified goals, generated original solutions with strategic application.
Business Process Improvement: Analysed business processes, identified alternative solutions, assessed feasibility and recommended solutions to exploit technology; established requirements to implement changes in business process.
Risk Management: Assessed risk for functional business areas; quantified and documented probability of occurrence and impact; consulted domain experts; developed mitigation and contingency plans.
(SFIA: PRMG 5, SINT 5, TEST 4, METL 6)
Project Management: Responsible for definition, approach, facilitation and satisfactory completion of small to medium-scale projects with direct business impact and firm deadlines; identified, assessed and managed risks; delivered risk and communication plans; achieved agreement on deliverables, timescale and resources; coordinated project schedule; achieved project closure.
Systems Integration: Designed and built integration components and interfaces; improved tools, methods and approaches; defined integration builds for software generations; delivered software builds from developer modules.
Testing: Delivered test cases from in-depth technical analysis of functional and non-functional requirements; ensured traceability back to requirements; executed and documented complex test scripts; recorded test results; managed defect register; reported on system quality; collected test metrics.
Methods and Tools: Promoted innovation in techniques, methodologies and tools to match business requirements.
(SFIA: CHMG 5, RELM 5, CPMG 4, ASUP 5, DBAD 5, USUP 4)
Change Management: Delivered implementation plans for complex change requests; assessed service environment risks; promoted improvement to change management governance; assessed, developed and implemented change requests.
Release and Deployment: Planned, designed and scheduled release packages; assessed risk; liaised with business and IT partners; ensured release processes are applied.
Capacity Management: Monitored service component capacity and initiated actions to resolve shortfalls.
Application Support: Maintained procedures and documentation for applications support; managed enhancements for business improvement; collected performance statistics; investigated and resolved issues; advised on application security, licensing, upgrades, backups and disaster recovery.
Database Administration: Managed database configuration, installed and upgraded software; maintained procedures and documentation; managed database security and integrity; monitored database activity and resource usage; optimised database performance; forecasted resource needs.
Incident Management: Diagnosed and prioritised incidents, investigated and resolved causes; escalated unresolved incidents.
Bachelor of Business (Computing), University of Southern Queensland.
Masters - Computer Science (Distinction), University of New England.
Enterprise Architecture with TOGAF 9.1 Part 1 (June 2016)
Enterprise Architecture with TOGAF 9.1 Part 2 (June 2016)
Enterprise Architecture for Managers and IT (IES, 2016, Cert UC-L68H8403)
Rapid Delivery Methods for Enterprise Architecture (IES, 2016, Cert UC-D7GKBZUV)
Certified Business Data Modeller (CBDM) (IES, 2016, Cert UC-MQ7SYPS4)
The Internet of Things (King's College London, 2016)
Big Data: From Data to Decisions (QUT, 2016)
Big Data: Data Visualisation (QUT, 2016)
Big Data: Statistical Inference and Machine Learning (QUT, 2016)
Business Analysis Foundations (Business Analysts, July 2013)
Oracle Database 11g: Administration (Oracle, June 2010)