Summary
Overview
Work History
Education
Skills
Personal Information
Degree
Affiliations
References
Timeline
Generic

Lee Clifford Grainger

Baulkham Hills,Australia

Summary

Adept at driving complex data migration and integration projects, I leveraged my expertise in Oracle Data Integrator and data architecture at Taysols Pty Ltd, enhancing CRM systems and BI solutions. My strategic planning and analytical skills ensured project success, showcasing a blend of technical proficiency and leadership acumen.

Overview

33
33
years of professional experience

Work History

Senior Consultant

Taysols Pty Ltd
Sydney CBD, Australia
07.2016 - Current
  • For eight years, I collaborated exclusively on-site with an N.S.W. government department as part of a large migration project to a new CRM system based on Salesforce, working in the corporate data warehouse space alongside the Information Management team as a consultant and technical business analyst to provide a new replacement B.I. solution sourced from the new Salesforce CRM. In this role, my duties included gathering business and technical requirements, performing dashboard and report design workshops with stakeholders and business S.M.E.s, performing data analysis and profiling, producing functional and technical specifications, supporting the development process, producing test plans, and performing system, UAT, and post-implementation testing, and assisting in the delivery of the B.I. solution, supporting the Information Management team B.A.s.
  • On completion of the above contract in April 2025, I moved to the support team, where my responsibilities to multiple clients include data warehouse design, integration, data migration, and ETL design, build and support.

Data Consolidation Technical Lead / Data Architect / ETL Designer & Programmer

NRMA Motoring & Services
North Strathfield, Australia
02.2012 - 04.2016
  • In February 2012, I accepted a new role at NRMA as technical lead, data architect, ETL designer, and programmer, responsible for designing and delivering the data consolidation and data migration elements of the G.O.E. (Group Operating Environment) project. This project aimed to replace the existing CRM and finance systems with a new fully integrated G.M.S. (Group Membership System) and G.F.S. (Group Financial System) based on Siebel, Oracle E-Business Suite, and Oracle Fusion Middleware. My initial work on the project was to design a database for the cleansing and consolidation of the customer and transactional data from several dispersed CRM systems within the NRMA group, using design patterns based on Oracle Application Integration Architecture (A.I.A.). and the Open Applications Group Integration Specification (O.A.G.I.S.). I then designed, prepared, and documented the technical architecture, including the development framework and programming standards for the consolidation process, following the development of the complete ETL process for each source CRM system. This involved working closely with the third-party system integrator. I took a leading role in developing the ETL processes using Oracle Data Integrator (ODI) and Oracle Enterprise Data Quality (O.E.D.Q.). Finally, I designed the technical and business reconciliation processes in conjunction with the system integrator and business S.M.E., and developed them using SQL. After the conclusion of the G.O.E. project in December 2015, I moved over to the Business Intelligence team; there, I was involved in user acceptance testing of reports and dashboards in O.B.I.E.E.

Partner & Managing Director

Sit Dharma / Trang Wassana Guesthouse
Trang, Thailand
03.2013 - 11.2014
  • I entered into a business partnership with my wife and one other person to manage a guesthouse business in Thailand, taking over an existing business, implementing a new philosophy, a new management team, and bringing in new ideas, injecting new investment to raise the business to its full potential, and ensuring its longevity in an increasingly competitive market. This included: creating and implementing a business plan, implementing, and directing activities and productivity, developing and maintaining an effective marketing strategy, developing and directing the implementation of policies and procedures, strategic planning, ensuring performance goals are set and met, providing guidance, supporting strategic alliances and partnerships, and setting budgets.

Oracle / Project Consultant & P.L.S.Q.L. Developer

NRMA Motoring & Services
North Strathfield, Australia
01.2010 - 02.2012
  • I returned to NRMA initially to pick up from my previous contract and work on Phase 2 of the 'BusinessWise' application, which included functional analysis and design, design, coding, testing, and implementing a new database, and project consulting. This involved adding newly required functionality, extending existing functionality, and preparing the system for exposure on the internet to our business customers, as part of an initiative called 'Member Self Service'.
  • Functional analysis for phase 3.
  • Responsible for the entire development life cycle of the Oracle database to support an entirely new website for NRMA’s retail customers.
  • Project consultation, technical consultation, training and support for project managers, D.B.A.s and other PL/SQL developers within the department
  • Lead in version control procedures and standards.

ETL / DW PL/SQL Developer

A.M.P.
Circular Quay, Australia
08.2009 - 01.2010
  • Design, code, test, and implement ETL processes using PL/SQL procedures, functions, and SQL Loader.
  • Schedule processes using Control-M.
  • As a member of the data warehouse team, I worked on two projects. Both primarily involved producing ETL processes in PL/SQL and scheduling using Control-M.
  • Sourcing data from various external third-party systems, internal systems, and data marts, I created processes to perform ETL to consolidate data into the main data warehouse.
  • This involved processing records in excess of 100 million.

PL/SQL Developer / Oracle Analyst

NRMA Motoring & Services
North Strathfield, Australia
05.2007 - 03.2009
  • Design, code, test, and implement PL/SQL procedures, functions, and packages.
  • Design relational databases.
  • Support and maintain Oracle-based systems and applications.
  • Business analysis and design.
  • Requirements gathering.
  • Oracle Database Consultant.
  • As a PL/SQL developer, I worked on a new web-based (N.E.T.) application called 'BusinessWise' developing the business logic contained primarily in the database. After six months and the conclusion of that project, I moved to the business application support team. There, I supported and maintained the new application and several other existing systems, which included requirements gathering, analysis, and design for ongoing improvements and new functionality.
  • In the last nine months of the contract, I was involved in two high-profile projects. On the 'One Member View' project, I was primarily a PL/SQL developer, coding ETL procedures to collect and consolidate customer data from several large databases into a single customer data hub. This involved processing large volumes of data, in excess of 7 million records. On the 'Analytics Project,' I was responsible for the complete life cycle and successfully delivered four key objectives: analytics database and campaign management system synchronization and integration, QuickAddress Batch API for regional classification and geospatial analysis of customer addresses, Central Email Repository Phase 1, and Central Email Repository Phase 2 functional requirements.

Oracle Team Leader / Senior Oracle Developer

Certegy Ltd
Edgbaston, UK
01.1999 - 01.2007
  • I started at this company as a Senior Oracle Developer. After two years, I accepted a promotion to Oracle Team Leader, maintaining my developer role.
  • During my time here, I designed their four main back-office applications, and I was involved in developing and implementing these systems. This included a fully integrated security system to control access to the applications and database, including full encryption and access control of cardholder data to meet PCI (Payment Card Industry) standards.
  • Other projects include: the building of six 10g application servers and the upgrade of all Oracle Forms applications to version 10g for deployment over an intranet.
  • Making recommendations and overseeing the first application using JDeveloper, including J2EE design patterns, database connectivity, data persistence, programming standards, and design methodology. Systems analysis, design, prototyping, development, testing, and implementation.
  • Support for existing Oracle systems.
  • Oracle Developer Champion.
  • Responsible for the production and enforcement of G.U.I., programming, and testing standards within the Oracle development team.
  • Responsible for the production of development process standards, and quality control procedures.
  • Involved in the IT department, achieving CMM Level 2 certification.
  • Internal training for other team members in all aspects of Oracle Developer, development standards, and quality control.
  • Oracle team leader, including mentoring, performance reviews, objective setting, and all aspects of management.

Technical Consultant / Software Engineer

Systems Guidance Logistics
Stoneleigh, UK
01.1998 - 01.1999
  • Software design and build of warehouse management systems for customers such as E.M.I., Littlewoods, and Cow & Gate.
  • Designer and Developer Champion.
  • Adviser to all project teams on programming standards, testing procedures, and quality management.
  • Internal technical consultancy for designers, developers, across all projects within the organization.
  • Internal training for other employees in all aspects of design, development.
  • Improvement to the company’s development process by introducing new programming standards, testing procedures and quality control, including employee training in these areas.

Senior Software Engineer

A.T. & T. UK Rover Services
Birmingham, UK
01.1994 - 01.1998
  • I started as a trainee developer, and was quickly promoted to a senior position.
  • Software design and build on a four-year Just-In-Time project for the Rover Group.
  • Prototyped large areas of the Just-In-Time system for proof of concept and customer demonstrations.
  • Designer and Developer Champion.
  • Responsible for the production and enforcement of G.U.I., programming, and testing standards within the project.
  • The position of monitoring quality within the project. Aid in the definition of company-wide quality procedures, and Rapid Application Development methodologies into all areas of the project to increase productivity and improve quality. These methodologies were also included in the company-wide quality management systems.
  • Internal technical consultancy for designers, developers, R.A.D., and quality across other projects within the organization.
  • Internal training for other project members in all aspects of design, development, R.A.D., and quality.
  • Team leader for a short time.
  • Database administrator for the development of environmental databases.
  • High level of technical knowledge and an aptitude for producing high-quality, robust software.
  • Instrumental in the company’s ISO 9000/BS 5750 accreditation.

Developer

R.A.F. Stanbridge
Leighton Buzzard, UK
01.1992 - 01.1993
  • This was an 18-month placement as part of my university degree.
  • Analysis, design, and development of an Oracle Forms 3.0 / Pro.
  • C application and Oracle 6 database.
  • Assistant System Administrator.
  • I aided the system manager in maintaining and supporting their network system.

Education

B.Sc. (Hons) - Computing Science

Staffordshire University
Stafford, Staffordshire, UK
01.1994

BTEC National Diploma - Computer Studies

Sandwell College of Further and Higher Education
Smethwick, West Midlands, UK
01.1990

Skills

  • ETL, data migration, data integration, and data consolidation
  • Data warehouse design, database design
  • Data architecture
  • Data analysis and profiling
  • Business and technical analysis and design
  • Testing
  • Dashboard and report design
  • Software quality control and software methodologies
  • Azure Data Factory
  • Snowflake
  • Informatica Cloud
  • Oracle Data Integrator (ODI) 11g/12c
  • Oracle Enterprise Data Quality (OEDQ)
  • OBIEE 11g
  • Power BI
  • Oracle Database
  • SQL Server / SSIS
  • Python
  • C / C

Personal Information

  • Date of Birth: 02/24/72
  • Gender: Male
  • Nationality: Australian British
  • Marital Status: Married

Degree

B.Sc. (Hons) Computing Science

Affiliations

  • Published author and novelist; I self-published my first novel in May 2020, and currently writing my second.
  • Powerlifter: I am a non-competing powerlifter.

References

References available upon request.

Timeline

Senior Consultant

Taysols Pty Ltd
07.2016 - Current

Partner & Managing Director

Sit Dharma / Trang Wassana Guesthouse
03.2013 - 11.2014

Data Consolidation Technical Lead / Data Architect / ETL Designer & Programmer

NRMA Motoring & Services
02.2012 - 04.2016

Oracle / Project Consultant & P.L.S.Q.L. Developer

NRMA Motoring & Services
01.2010 - 02.2012

ETL / DW PL/SQL Developer

A.M.P.
08.2009 - 01.2010

PL/SQL Developer / Oracle Analyst

NRMA Motoring & Services
05.2007 - 03.2009

Oracle Team Leader / Senior Oracle Developer

Certegy Ltd
01.1999 - 01.2007

Technical Consultant / Software Engineer

Systems Guidance Logistics
01.1998 - 01.1999

Senior Software Engineer

A.T. & T. UK Rover Services
01.1994 - 01.1998

Developer

R.A.F. Stanbridge
01.1992 - 01.1993

B.Sc. (Hons) - Computing Science

Staffordshire University

BTEC National Diploma - Computer Studies

Sandwell College of Further and Higher Education

Similar Profiles

  • Mekondjo Johannes

    Mekondjo JohannesMekondjo Johannes

    Human Resources Superintendent at Blue Sea Fishing Company (PTY)Ltd, Pereira Seafood Company (PTY)Ltd, Hatutungu Fishing Company (PTY)Human Resources Superintendent at Blue Sea Fishing Company (PTY)Ltd, Pereira Seafood Company (PTY)Ltd, Hatutungu Fishing Company (PTY)

  • Mekondjo Johannes

    Mekondjo JohannesMekondjo Johannes

    Human Resources Superintendent at Blue Sea Fishing Company (PTY)Ltd, Pereira Seafood Company (PTY)Ltd, Hatutungu Fishing Company (PTY)Human Resources Superintendent at Blue Sea Fishing Company (PTY)Ltd, Pereira Seafood Company (PTY)Ltd, Hatutungu Fishing Company (PTY)

  • Shane Harkin

    Shane HarkinShane Harkin

    Electrician at Nxgen PTY LTD/ UGL PTY LTDElectrician at Nxgen PTY LTD/ UGL PTY LTD

  • Dorsa Mirzabeigi

    Dorsa MirzabeigiDorsa Mirzabeigi

    Store Manager at BayAudio Hearing Service - AmplifoneStore Manager at BayAudio Hearing Service - Amplifone

  • Sudipa Ghosh

    Sudipa GhoshSudipa Ghosh

    Technical Sales / Customer Support Engineer at Xylem Water SolutionsTechnical Sales / Customer Support Engineer at Xylem Water Solutions

CREATE PROFILE
Lee Clifford Grainger