John Castillo Email & Phone Number

Fairfield, VIC, AU

Australia

As part of the Marketing Infrastructure team, conduct analysis, data modelling, migration assessment and SME guidance around NAB's Marketing Data

Melbourne, Victoria, Australia

Working with the Enterprise Data Modelling team - assist with the migration of major source systems from Legacy Teradata platform to On-Cloud big data AWS platform (NDH).- Define the Adobe Campaign sourced raw data vault and corresponding business content zone layer.- Define the Adobe Analytics sourced raw data vault and corresponding business data vault.

Melbourne, Australia

Working with NAB's Marketing team to improve interfaces between the campaign tool (Adobe) and Teradata, and to define the data layer in a new cloud based (AWS) instance of Adobe Campaign.- Mentor/train new starters in DM concepts and Adobe Campaign techniques.- Create and maintain Adobe Campaign data schemas.- Assist the Data Architect to analyse existing.

Melbourne, Australia

• Lead a small tech team providing maintenance and enhancement of an adhoc collection of processes. Processing written by various pockets of the NAB business were bundled and managed by the BMIT team.
• Teradata database admin (space usage, index redefinition, stats collection, performance tuning)
• Unix, SAS and Teradata scripting
• password encryption/SAS connectivity (SAS EG for Teradata, Oracle and server connectivity) and SSH encryption.
• Process automation, enhancement and documentation.

Melbourne

• As a member of the IBM Test Team supporting the upgrade of NAB's Teradata platform and related infrastructure to a Big Data platform (Hadoop):
• provide SME consultation to the test team around NAB's infrastructure
• define tests of a more complex nature requiring specialised Teradata knowledge
• execute tests and capture results
• assist with TSR documentation

Melbourne, Australia

• As a member of an Agile team within the Enterprise Data Warehouse development train:
• Conduct evolve kick-offs, requirements refinement sessions and User Story definition for various initiatives
• Conduct build, test and deployments of above initiatives using:o Teradata scripting and Datastageo Control-Mo SQLSAS for BI reportingo GIT for software configurationo CUCUMBER and Jenkins for testingo several.

Melbourne, Australia

• NAB’s Customer Analytics suite of applications facilitate CRM and communication management. At the core is the Teradata CM (Communication Manager) tool. Data is extracted from the Data Warehouse and operational.
• As an SME in several aspects of the Customer Analytics applications, provide consultation to Customer Analytics Business representatives, as well as mentoring of other team members. Also involved in serveral iterations.
• High Level Design
• Technical lead of the development phase of several projects.
• Technical design
• Develop software using ODI (Oracle ELT tool), Teradata scripts for BTEQ, MLOAD, MACROs, and COBOL/IMS/MQ/Teradata online transactions

Melbourne, Australia

• Telstra’s Wholesale Data Repository (WDR) is a large data warehouse running on UNIX servers attached to a Teradata RDBMS. ETL is implemented with both Teradata scripts and DataStage load jobs. My involvement:
• Write Teradata scripts
• Write Unix execution scripts
• Define Control-M schedules
• Assist with End To End testing by writing complex check SQL based on the Data Model
• Build DataStage load jobs

Melbourne, Australia

• Telstra's Retail DWH.Tasks included:
• Data Validate the Warehouse. (initial load of the Warehouse, then adhoc SQL queries to validate)
• Team Lead a three person review team. Reviewing Teradata Code and technical specifications. Producing Coding Standards and Guidelines.
• Adhoc mainframe tasks such as implementing COBOL routines and mainframe SAS modules
• Production Support. Including:o Problem resolution of complex problems not solvable by first level support o Monitoring first-time run jobs for stability o Definition of CONTROL-M scheduleso RACF mainframe security.

Melbourne, Australia

• Telstra's Retail DWH system was developed initially using ETI to generate Teradata scripts. However, early in the project, ETI was withdrawn, and Teradata scripts were written manually.Tasks included:
• Review design documents and write system specification documents
• Construct import/export modules using Teradata SQL and ETI
• Prepare unit testing plans and conduct Unit and Integration testing
• Mentor less experienced team members
• Assist in team leader functions, including assuming the role during team-leader absence, liaising with other teams and advising on standards and procedures

Newcastle, England

• Write high-level design specifications for data access components and request server.
• COOL:Gen coding of the above specified enhancements.
• Conduct reviews of documentation and participate in reviews of my work. The Accord Project delivered new applications to the British Department of Health and Social Services. We used Lotus Domino to version control.

Melbourne Area, Australia

S&M DWH Project==============Assisted a large team in the establishment of a Data-Warehouse and related infrastructure. The Data-Warehouse was to be the main knowledge base for Telstra's Sales and Marketing arm. It was to contain all Customer and Sales related data to be used for marketing campaigns, trend analysis and adhoc queries. My involvement.

Dandenong - Victoria

Testing for Y2K remediation of several General Motors applications.

Melbourne Area, Australia

SUPPORT OF NATIONAL MUTUAL PERFORMANCE DATABASEAs a member of a small team, supported the NM MXG Performance Database System. This system was built using the SAS 4GL. The system provided a warehouse of computer-related usage, performance and capacity related data. Data was sourced from the SMF repository, the various PABXs (for telephone usage data), IMS.

Bachelor Of Science, Computing, Faculty Honors

High School Certificate