Oracle Developer, Data Modeler, SDLC, Agile, GIT, TFS, ADO

Career Profile

Over ** years developing, implementing and supporting IT corporate solutions

Extensive experience with Oracle database administration on 24/7 environments and development using PL/SQL

Experience driving ETL strategies and process automation

Proven track record on designing, implementing, supporting corporate solutions and following SDLC guidelines

Extensive knowledge on SDLC

Highlights of Qualifications

PL/SQL programming

Oracle 10g/11g/12C Database Administration

RMAN – Standby databases

Oracle SQL Monitoring and Tuning

Data modelling (Power Designer)

Supporting 24/7 environments

Technical Skills

Oracle Database Administrator Certified Associate (OCA) - PL/SQL programming

Salesforce (Trailhead)

Oracle, SQL Server

TOAD, PowerBuilder, ODI, Power Designer

Crystal Reports - Business Objects

CVS, JIRA, TFS, GIT

Employment History

Oracle Data Modeler and Developer December 2016 – Current Computershare, Toronto, Canada

Responsible for designing and building all ETL processes for feeding data into the OPTRACK reporting system from external providers using PL/SQL language

Automating different processes eliminating user intervention and allowing execution after business hours

Reviewing standards and best practices complying with corporate policies

Supporting the process for including the source management for the database (Oracle into GIT)

Maintaining the data model using Power Designer

Application Developer September 2016 – November 2016

Manulife Bank, Waterloo, Canada

Designing and developing Oracle APIs using PL/SQL language for IBM ICM (Incentive Compensation Management) and Bank systems integration

Working directly with Marketing and Sales team to implement rules into the IBM ICM system

Database Developer April 2015 - October 2015

Rogers Communications, Brampton, Canada

Designing Oracle APIs for CMS integration

Developed and supported Oracle PL/SQL scripts

Managing export/import process (DBPUMP, EXP & IMP) to refresh QA environments

Tune PL/SQL scripts to improve performance

Technical Associate August 2014 - February 2015

Morgan Stanley, Montreal, Canada

Designed and implemented physical data model and scripts for ASE Sybase database

Monitored and supported replication automatic jobs in Autosys, PERL and Shell scripting

Designed data migration process for legacy application (Powerscript, bash Linux)

Senior Information Systems Engineer February 2008 - February 2014

Intuit Canada, Edmonton/Mississauga, Canada

Installations and Upgraded Oracle 9i/10g/11g instances for development/test/production environments

Developed and supported database design and PL/SQL objects (packages, stored procedures)

Implemented database refresh processes for development and QA environments (Export/Import, Data Pump, SQL Loader)

Implemented Backup & Recovery strategies (RMAN)

Implemented Change Management process for Oracle 11gR2 instances

Developed all automatic jobs (DBMS Scheduler, shell Scripting, J2EE) to manage external vendors

Software Developer / DBA February 2004 - January 2008

Insurance Systems Ins., Toronto, Canada

Developed and implemented Change Management process for client release

Oracle 9i/10g Installation and Administration

Defined and implemented Backup & Recovery strategies (RMAN, Export/Import, Data Pump)

Implemented database security (users, roles, privileges)

Gathered business requirements for application enhancement

Team leader for Conversion processes (Migration) from legacy systems (ETL processes)

Helped to design and implement SQL scripts for ad-hoc reports in BO and Crystal Reports

Software Developer / Technical Support December 2002 - January 2004

Birds Canada, Port Rowan, Canada

Worked directly with users to gather requirements for different solutions and converted into technical specifications

Developed, implemented and supported Visual FoxPro applications

Created all conversion processes (migrating) from the legacy system in Access to MS SQL Server 2000

Trained external users (Bird Banding Laboratory Maryland-US / Canadian Wildlife Service-Ottawa-ON) to use new tools for managing different projects

Systems Analyst / DBA November 1998 - July 2001

Coomeva, Cali, Colombia

Oracle 9i database administration (Installing, upgrading, performance monitoring) on a 24/7 environment

Implementing and Maintaining database security (create and maintain users, roles and assigning privileges)

Defining Backup & Recovery strategies using RMAN

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

Helped to design and implement all conversion (migration) process from Health legacy systems into Oracle 9i, including ETL, mapping structures, archiving and cleansing policies

Coordinating developers team (resource allocation, coaching, training)

EDUCATION & TRAINING

Golden Gate & ODI – Workshop - 2016

Oracle Corporation

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

Systems Engineering – 1993

JAVERIANA UNIVERSITY, CALI, COLOMBIA

SQL Server Administration & Implementing Certificate - 1999

TECHNICAL EDUCATION CENTER MICROSOFT

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

ORACLE COLOMBIA, CALI-COLOMBIA

Contact this candidate