FERNANDO CRUZ- SALAZAR

*** - *** **** **.

Mississauga, ON, L5B 3Z4

Phone: 416-***-**** / 647-***-****

acozim@r.postjobfree.com

Fifteen years in IT as database developer, developing, implementing and supporting IT solutions using Oracle 9i/10g/11g and supporting multiple environments (DEV/UAT/PROD). I have wide knowledge developing conceptual, logical and physical data models. Expertise using SQL and PL/SQL language and several programming tools (PowerBuilder, TOAD) and developing/implementing extract, transform, and load (ETL) strategies.

HIGHLIGHTS OF QUALIFICATIONS

- Oracle 10g Certified Associate (OCA)

- PL/SQL programming

- Oracle SQL Tuning

- PMP & Agile Scrum training

- Supporting 24/7 environments

- Fluent in English, French and Spanish

TECHNICAL SKILLS

ORACLE 10g/11g

ASE Sybase

PowerBuilder 10

SAP HANA Fundamentals

Crystal Reports

Business Objects

EMPLOYMENT HISTORY

Database Developer

August 2014 - February 2015

MORGAN STANLEY, MONTREAL, CANADA

- Supporting all database development (model design, scripts) for internal products in DB2 and ASE Sybase

- Part of the support team monitoring all automatic jobs used for database replication (Autosys, PERL, Shell scripting)

- Implementing scripts (Linux and Sybase) for migration processes from legacy system to the internal new Entitlement model

- Part of the global Agile Scrum team

Senior Information Systems Engineer

February 2008 - February 2014

INTUIT CANADA, EDMONTON/MISSISSAUGA, CANADA

- Supporting Oracle 11g instances (DEV/UAT/PROD) by deploying object changes

- Using Export/Import (DBPUMP)/SQL Loader for moving data between from/to environments

- Developing/Implementing/Supporting PL/SQL objects (packages, tables, triggers) for all Oracle instances

- Using SQL to create reports ad-hoc

- Modeling physical data based on customer requirements

- Shell Scripting (Linux) for automating processes

- Coordinating application and database changes into Production

- Implementing changes to PowerBuilder 10 system and coordinating periodic releases

- Building JAVA servlets (J2EE) components for extracting/updating data in our Oracle system

- Implementing and documenting automatic processes

- Gathering business requirements for different projects

Software Developer / DBA

February 2004 - January 2008

INSURANCE SYSTEMS INC., TORONTO, CANADA

- Installing/Upgrading/Configuring Oracle 9i instances

- Defining security policies, roles and application users

- Modeling physical data based on customer requirements

- Developing/Tracking/Maintaining PL/SQL objects (packages, tables, triggers) for all Oracle instances

- Converting (migrating) data from legacy systems to Oracle 9i Database

- Implementing archiving and cleansing data policies for conversion processes

- Gathering business requirements

- Supporting PowerBuilder 9 application at client sites

- Designing ad-hoc reports using BO and Crystal Reports

Software Developer / Technical Support

December 2002 - January 2004

BIRD STUDIES CANADA, PORT ROWAN, CANADA

- Gathering business requirements

- Developing and supporting Visual FoxPro applications

- Converting (migrating) information from Access to SQL Server 2000

- Training external users (Bird Banding Laboratory Maryland-US / Canadian Wildlife Service-Ottawa-ON)

Systems Analyst/ DBA

November 1998 - July 2001

COOMEVA HMO, CALI, COLOMBIA

- Oracle 9i database administration on a cluster environment

- Defining security policies, roles and application users

- Defining backup/recovery procedures using RMAN

- Developing/Tracking/Maintaining PL/SQL objects (packages, tables, triggers) for all Oracle instances

- Converting (migrating) data from legacy systems to Oracle 9i platform

- Implementing archiving and cleansing data policies for conversion processes

- Gathering business requirements and providing support to PowerBuilder 5 applications

- Coordinating developer team (resource allocation, coaching, training)

Systems Analyst / Developer

February 1993 - October 1998

EMCALI PUBLIC CITY OF CALI, CALI, COLOMBIA

- Designing and maintaining a Progress 4GL system

- Administering and supporting Novell NetWare

- Oracle 8i Database administration (Junior level)

- Developing and supporting PowerBuilder applications

EDUCATION & TRAINING

Agile - Scrum Workshop

2014

TEK Systems

PMP - Project Management

2012

SHERIDAN COLLEGE

Developing Applications for the J2EE Platform

2010

KNOWLEDGE UNITED

Oracle 10g Database Administration

2004 - 2005

HUMBER COLLEGE, TORONTO, CANADA

B.S. Systems Engineering

1993

JAVERIANA UNIVERSITY, CALI, COLOMBIA

SQLServer Administration & Implementing Certificate

1999

TECHNICAL EDUCATION CENTER MICROSOFT

Oracle - SQL*PLUS - PL/SQL - SQL*FORM Certificate

1995

ORACLE COLOMBIA, CALI-COLOMBIA

Progress - Power Builder Certificate

1994

EMCALI PUBLIC CITY WORKS, CALI-COLOMBIA

COMMUNITY INVOLVEMENT

Technical Support

August 2002 - November 2002

St. Joseph Immigrant Women Centre

Resource Counsellor

October 2001 - November 2002

Neighbour-to-Neighbour Centre

Research Trainee Position

November 2001 - July 2002

Ministry of Community and Social Services

Contact this candidate