Oracle Management Developer .Net Manager Asset

Location:

Ottawa, ON, Canada

Posted:

March 12, 2014

Contact this candidate

Resume:

Mike Ferris ** Stonepath Crescent Stittsville, Ontario K2S1S4 613-***-****

*************@*****.***

HIGHLIGHTS

10+ years Oracle DBA and development experience

•

Oracle Certified Professional DBA

•

ITIL Certified

•

Thrive on solution and data architecture

•

Proven management team experience

•

Expert PLSQL developer

•

Both developed in and supported ERP systems

•

Managed a .net development team

•

Extensive experience with Oracle Data Integrator and Oracle APEX development

•

Comfortable supporting web technologies including Weblogic, OAS, XMLDB, IIS, and Apache

•

Well rounded, eager to learn team player

•

EMPLOYMENT HISTORY

Hydro Ottawa Limited 2008 – 2014

2011– 2014 Supervisor of Programming

Oversaw release cycles and source control for all internal development

•

Created and supported the PLSQL backend for the 24/7 outage reporting system used to notify the media,

•

city councilors, and Hydro Ottawa staff when power outages occur.

Built a single sign on pass through application in .NET for network users to reach a secure third party site

•

Implemented an event driven identify management solution using Oracle RDBMS and Active Directory

•

that synchronizes Hydro Ottawa’s ERP system with active directory and Halogen hosted services.

Supervised the team responsible for all reporting standards and development using JD Edwards ERP, BI

•

Publisher and Create!Form

Wrote a number of common packages including one to leverage mime types and full html emails from

•

Oracle as well meeting requests directly from a PLSQL on any internal database.

Working with internal resources, created a software classification, reporting, and license tracking

•

application written in Oracle APEX using Heterogeneous services to mine data from Microsoft SMS

Developed a completely code based holiday/workday calculator using PLSQL now used for time of use

•

calculations on HydroOttawa.com

Page 1 of 4

Created and supported the Hydro Ottawa service desk application, leveraging web services, APEX,

•

PLSQL, and ODI to send service quotes to customers, book appointments, and manage the full workflow

of the service desk

Implemented an auditing and notification PLSQL package for the JD Edwards ledger periods and close

•

dates

Created a secure routine for handling form posts from the public website to internal applications

•

Hydro Ottawa Limited 2008 – 2014

2008 2011 Database Administrator (Management Team)

Primary DBA for production databases at Hydro Ottawa

•

Provided 24/7 operational support for critical systems

•

Used ODI (Oracle Data Integrator) to create interfaces between JD Edwards and IBM Clarity

•

Developed and maintained packages for Time of Use xml processing using ODI

•

Created ODI and PLSQL interfaces for numerous data exchanges, including services on the physical card

•

access system, Active Directory, MS Outlook, Fleet Management, SMS, and, JD Edwards ERP

Monitored and identified software and hardware issues before they affected performance

•

Worked closely with the rest of IT to identify and resolve network and hardware issues

•

Ensured database backups were consistently created and were available and usable when needed

•

Patched and upgraded databases on a rigid routine schedule

•

Constantly reviewed tuning opportunities, making adjustments and recommendations

•

Sizing and capacity management to project hardware requirements for new as well as growing databases

•

Created the data and application architecture for the Hydro Ottawa outage reporting solution

•

Worked with functional analysts to implement the functional data conversion for the 2010 JD Edwards

•

upgrade project, migrating from GAAP to IFRS

Jupiterimages Corporation 2000 – 2008

2004 2008 Manager, Digital Asset Management Systems

Managed the development team responsible for the Jupiterimages’ Digital Asset Management System

•

• Responsible for system and database architecture

• Collaborated with the IT department in NY to maintain performance and availability across the WAN

• Worked with business groups and end users to understand and document new business requirements

• Responsible for proposals, documentation, and technical training materials

2002 2005 Software Developer

• Created and maintained asset management workflow

• Built retail and OEM products on a release schedule including the mastering of DVD and CD releases

• Automated the box product content preparation process for many JupiterImages’ products

Page 2 of 4

2000–2002 Supervisor, Content Production

Managed in house graphic production team of 14 along with overseas contracts

•

Coordinated and executed photo shoots on a release schedule based on business and marketing criteria

•

Strategic Relationship Systems 2007 2009

Database & ASP.net Developer (contract)

• Built the company website

• Using a SQL Server database with ASP.net pages I delivered a data driven solution

Corel Corporation 1998 2000

QA & Lead Photographer

• Designed and implemented Corel’s in house imaging QA standards

• Worked closely with Corel designers to produce imagery used in image collections as well as high profile