Oracle / Teradata Data Architect, Systems/Solutions Architect

ROLAND JOHANNES THERON

HOME ADDRESS *** ***** ****** *, *** 5

Kirkland

Washington

98033

CONTACT NUMBER 425-***-**** (Mobile, Preferred)

EMAIL ******.******@*****.***

USA RESIDENTIAL Permanent Resident/Green Card

STATUS

AFTER SCHOOL B.Sc. Computer Science & Applied Mathematics

QUALIFICATION B.Sc. Hons. In Computer Science, Specializing in:

Artificial Intelligence, Database Management Systems (Oracle)

Decision Support Systems, Linear Programming

Image Processing

SUMMARY I'm an experienced Systems/Solutions Architect with a proven track

record of implementing large, cross-functional enterprise solutions.

They typically include multiple business areas; hardware and software

technologies; software and software design and development. I also

provide organizational support and coordinate deployment resources.

My primary focus is Oracle based data warehouse implementations

(Big Data) and their supporting solution infrastructure, with a

secondary focus on Teradata based warehousing environments

CORE SKILLS: Oracle 9i, Oracle 10g, Oracle RAC 11g, Oracle ASM for RAC,

Senior Oracle PL/SQL development

Software Design at Product Solution Architecture level

Software Development Team management

System/Solution design at Systems Architecture level

Teradata v10, v13 and v14 Data Warehouse design and

implementation

Clustered Solaris 10 implementation for ETL

EMC VMAX Clustered and Dedicated storage,

EMC ISILON OneFS and SyncIQ for NFS

ACHIEVEMENTS Successful end to end system architecture, design and delivery of a

400 terabyte near transactional Oracle RAC 11g Data Warehouse -

the largest of its kind worldwide, associated deliveries included:

• Detailed storage forecast models for database and ETL platforms

proven to be within 95% accurate of actual storage requirements

• Significantly reduced manual support and delivery resource

requirements, and increased delivery quality through the

development of multiple supporting Oracle Data Definition

Manipulation processes & packages, for use in most common

customer change requests and data interface updates/upgrades

• Custom development and delivery of specialized data interfaces in

PL/SQL

• Managed the custom development team responsible for providing

the delivery of multiple specialized data interfaces. All

customization met, and often exceeded, data quality and

availability measurements established by the customer

• Responsible for multiple product software enhancement design

and new components to meet the customer’s specific needs

• Responsible for leading the team through all phases of the project

from analysis and requirements definition to production

implementation

EXPERIENCE

AIRCOM International (USA Hub Office) October 2009 to

Current

Systems Architect, AT&T Optima project

PRIDE Teradata platform implementation/migration:

• Design end to end systems Architecture for a distributed collection and

mediation layer supporting an Teradata v14 warehouse

• Design and plan the migration from the Original Oracle RAC system and

attached mediation to the PRIDE Terada warehouse (EDW) platform

• Guide product research and development to align future product release with

Client and Teradata specific requirements to ensure a ‘fit for purpose’ approach

to the Teradata solution

• Provided key input in product level Solution Requirement Documentation (SRD)

and High Level Design (HLD) documentation

• Owned quality assurance by verifying delivered product against solution

requirements and highlight all deltas on an ongoing basis

• Consolidate customer requirements and feedback with Product Architecture and

Development teams as the primary point of contact for technical matters on the

PRIDE Teradata migration project

• Provide technical guidance and process documentation for modular migration of

Oracle based interfaces/data areas to the PRIDE Teradata platform

• Manage the Custom Scorecard Interface (CSI) specialist team including a

solutions Architect, developer, and delivery engineers and their end deliverables

– CSI is a highly specialized reporting layer consisting of complex aggregation

of data and the final presentation of that data for reporting purposes. These

reports and their underlying data sets typically span all major areas of the data

acquired into the Optima warehouse

Original Oracle RAC implementation:

• Design Optima performance management solution for AT&T mobility across all

American markets and all vendor technologies integrated into the AT&T mobile

network, including the upcoming LTE network

• Architect the design and maintenance of a Oracle RAC Cluster system scoped

at approximately 270 TB in size for the ongoing acquisition of the performance

measurement data, this includes high level storage array distribution, RAC node

distribution across host machines and domains and node affinity definition

across the entire platform

• Architect and develop any specialized data acquisition processes including

CMPM configuration management data synchronization between Optima and

various external systems

• Define and Architect ongoing vendor interface integration into the Optima

system to ensure manageability across the AT&T Optima platform

• Architect and manage the hardware and storage environment for the ETL layer

or “Mediation Layer” aimed at acquiring raw performance data, pre processing

this data and loading data into an enterprise Oracle RAC cluster

• Audit and Maintain system solution specification and design documentation

relating to the AT&T Optima platform

Skills: Oracle RAC 11g, Oracle ASM for RAC, Oracle PL/SQL, Teradata 13,

Teradata 14, Solaris UNIX, EMC VMAX, EMC ISILON OneFS, ETL

Standard Bank of South Africa June 2008 to October

2009

Build Manager/Metadata Specialist

Build Manager (Infrastructure Services)

• Coordinate and manage all new database installations across the enterprise

environment

• Track and manage all DB team resources across DB2, Oracle and SQL

environments

• Represent Infrastructure Services in all new and upcoming project meetings

Metadata Specialist (Enterprise Data Warehouse)

• Project Manager for the IBM Information Server 8.01 POC

• Project Coordination between Vendors and Data Warehousing division

• High level metadata design requirements for business

• Data Quality involvement

Skills: IBM Information Server 8, IBM DataStage, IBM Information Analyzer,

Teradata v10, DB2, Oracle, Oracle RAC, Microsoft SQL, Project Management,

Master Metadata Management (MDM)

AIRCOM International (South African HUB) June 2006 to June

2008

Product/Solutions Architect

• Subject matter expert for rapid Optima deployment implementation development,

tools assisting deployment engineers

• Rapid Optima deployment tool development, design, testing, documentation and

knowledge transfer

• Continued knowledge input for the development sector based in the UK, with

focus on deployment tools

• Post deployment support management

• Resource and knowledge Allocation

• Technical Optima solutions development

• Continued consultation with Management of clients on all major accounts

• Pre sales activities include solution development/feasibility analysis

• Client technical requirement gathering & analysis

• Configuration Uniformity management across all recent/new deployments

• In house standard Uniformity management methodology development for

recent/new deployments

• Specialist systems Optima development and deployment in Oracle platform

• In house standard Uniformity management methodology development for

recent/new deployments

• Optima remote Patch development and deployment

• Advanced Oracle (9i) development in PL/SQL, focus on high speed access to

bulk data – for specific application in performance measurement statistics in the

Telecommunication industry

• Project management whilst deploying on Site

• Extensive travel for deployments throughout Africa, including Kenya,

Mozambique, Gabon, Madagascar, DRC, Nigeria

Skills: Oracle 9i, Solaris UNIX, Oracle PL/SQL, Perl, Project/team leadership

e-Logics/Volition, Pretoria offices 2004 to 2006

Engineer/Consultant

• Advanced Oracle (9i) development in PL/SQL, focus on geometric data

conversion and normalization for optimal use in .Net/C# developed software

• Metadata design and implementation in Oracle 9i and MS SQL in an object

orientated application environment

• Oracle (9i) deployment and database administration

• Development in MS SQL server

• GIS development data analysis & automated data transfer to/from multiple

database environments using metadata similarity

• Development in MS Visual Studio .Net, C#

• Software design and metadata specification development whilst managing

software development of a metadata configuration and management software

• Numerous Software demonstration & User testing and improvement

presentations for clients including Spoornet, MIBFA and the Metal Engineering

Industry Bargaining Council on Client Senior management level as well as end

user level

• Logistic infrastructure design specification for projects including Spoornet and

the Metal Engineering Industry Bargaining Council

• Vast experience in rail infrastructure, asset management and rail condition

assessment, and data “clicking” or asset data capturing

• Sole database and metadata development and deployment on a recently

completed project for the Metal Engineering Industry Bargaining Council

Skills: Oracle 9i, Development tools: Microsoft Visual Studio .NET, C#, GIS, Oracle

PL/SQL, Microsoft SQL, Metadata Design

Contact this candidate