Oracle PL/SQL Developer Resume


Title
Oracle PL/SQL Developer


Primary Skills
Oracle PL/SQL, SQL, Powerbuilder 4-7


Location
Canada-BC-Vancouver (will consider relocating)

Posted
Mar-22-10

RESUME DETAILS
Overview

I am a senior level database application developer, designer, and analyst, with over sixteen years of experience in a wide variety of business applications, including provincial and municipal government, forestry management, airline fare management, and high volume eCommerce. I am particularly interested in client/server and relational database development and design using Oracle technologies.
I would like to gain professional experience utilizing web based database tools such as Oracle Application Express (APEX), PHP/MySQL, and other Open Source development platforms.

Experience

Rees Communications., Waterloo ON
June 2009 - August 2009 Independent Contractor
Main Role: Web Content Developer (HTML,Javascript, SiteCM)

Assisted in the implementation of Vintage Hotel's new website for six of their hotels.
The site was delivered using Idealever's SIteCM web content management system.
Ported Javascript and other script based proprietary code to SiteCM.

Principia College ., Elsah IL USA
September 2009 -- October 2009 Independent Contractor
Main Role: Oracle APEX 3.x Developer

Designed and developed a functioning APEX data entry application to manage Pad/Pair data for the Rolm 9751 PBX telecomm system The application includes issue tracking , user management, and dynamic reporting capabilities. The system would increase data integrity and consistency, provide more flexible reporting and issue management, and be accessible college wide.

SITA., Burnaby B.C
May 2008 - February 2009 Independent Contractor
Main Role: Senior Developer / Analyst / Designer

Daily Duties included:
PL/SQL programming for the Airfare Databuilder (ADB) backend database, in particular the Government Fare Filing (GFF) subsystem including batch and report processing and dynamic sql generation for Java front end data queries.
Assisted Project Managers and Business Analysts during Plan/Analysis/Design phases of each Agile Programming sprint and QA cycle (four sprint cycles and two UAT cycles).

Major Projects
Airfare Data Builder -- Government Fare Filing
A subsystem of ADB, GFF consists of a data entry/review/workflow application to allow governments to approve airfare data to conform with federal transit regulations. This subsystem will allow SITA to compete in the North American markets.

Skills used: PL/SQL (Oracle 10g), PL/SQL Developer, Oracle development features such as Virtual Private Database, Grouping Sets for Detail/Summary reporting, Analytic Functions, complex dynamic sql generation, system contexts. Development Life cycle Methodology: Extreme Programming -- Agile.

Best Buy (FutureShop) Canada Ltd., Burnaby B.C
November 2005 - January 2008 Accenture Inc. Services Workforce employee
May 2005 - November 2005 Independent Contractor
Main Role: Senior Developer / Analyst / Designer / Change Manager
Minor Role: Business Analyst / Trainer / Subject Matter Expert (SME) / Project Manager

Daily Duties included:
PL/SQL programming for all backend webstore systems (Futureshop.ca / Bestbuy.ca), including Order Management System (OMS), Content Management System (RMSL), Web Inventory and Ingram Micro Shipping Notice/Invoice synchronization.
PL/SQL programming for all interfaces to the above systems, such as Oracle Financials, Sku Inventory (RMS), booked sales into Cognos, and the nightly Content Publish of sku information and pricing for both websites.
All server side UNIX database scripting of processes and reports for both OMS and RMSL, and interfaces to third party vendors such as MUZE (Movie, Music, Game Content Service) and SDL (French Translation Service)
Senior level resource on all projects during the software engineering life cycle. Assisted Project Managers and Business Analysts during Plan/Analysis/Design phases of each project.
Performed BA/PM duties on small to medium size projects with direct contact with business clients gathering requirements and facilitating the QA and UAT phases of each project. Created technical designs and managed offshore/onsite resources during Build and QA phases.
On call support for production severity issues including bug fixes, data issues, server problems, etc.
Training and mentoring of new team members and offshore resources
Responsible for all version control of code and documentation.
Responsible for all change and release management during database/application rollouts of completed projects and maintenance releases into production.
Assisted QA team members to create backend testing scripts and documentation.

Major Projects / Accomplishments
In Store Pickup
Enhancement to the web store backend systems to allow online customers to create web orders and then pick up the order at any BestBuy or Futureshop store across Canada. New backend interfaces were created to supply store stock availability counts to the front end website databases, and send sku inventory adjustment back to the pickup store point of sale system.
Gift Card Redemption
Allow online customers to redeem gift cards when creating web orders. The OMS system was overhauled to allow three methods of payment per order versus one. All reports and interfaces with credit card information were updated to also show or supply gift card information as well.
Multi Channel Commerce Platform (MCCP)
As part of a major strategic project to update and create a reusable Microsoft Commerce Server 2007 platform for BestBuy Canada, U.S. and China, the following enhancements to the RMSL application have been developed:
Web Content publish has been completely redesigned from a “once a day” publish to a delta publish utilizing the Infomatica Data Integration Platform to publish sku content and pricing changes via a XML interface to CS 2007. Many PL/SQL components were updated to facilitate this change including the main sku loading components as well as Environmental Surcharges, Product Service Plan (extended warranty) to sku relationships, sale pricing and promotions
Numerous user interface updates to Gemini, the RMSL GUI application
RMS Load interface was overhauled to add more than 20 columns into RMSL to enhance content management
New RMSL Reports
RMSL enhancement to allow end users to create Bundle Skus
Web sku inventory countdown enhancements
Meet The Holidays (Christmas)
MTH is an enterprise wide initiative that readies all IT and operational departments for the Boxing week sales event. For the eCommerce websites, this starts at 5pm on Christmas Eve. For 2007, the following were the main changes to the PL/SQL backed programming of OMS and RMSL:
Tune the majority of OMS batch queries after upgrading from Oracle 9i to 10g
Redesign the Order Inquiry System (OIS) AVS Queue and Dashboard components to run more efficiently by querying the database once no matter how many Java instances of OIS are running on several servers.
Rework and tune the Full Sku Inventory report (200,000 rows, 400+ columns) to run in under 3 hours during Boxing Week. In 2006, the report took 27 hours
Added logic and new data columns to reduce business rule complexity introduced in the Gift Card Redemption project. These columns greatly simplify all batch and reporting queries when retrieving Gift Card and Credit Card billing information.
Other Projects:
Legacy Webstore application and reporting server scripting enhancements and migration to a new Linux server
Upgrades of OMS and RMSL and Oracle Portal databases and Oracle Application Server to Oracle 10g.
Numerous reports such as Cancellation report, Gaming Hardware Sales Report, Fixed Price Promotion Sales report
RMSL Batch process utilizing Excel spreadsheet CSV templates as data source
French translation data import/export automation
Store Credit Realization

Skills used: PL/SQL (Oracle 9i,10g), PL/SQL Developer/TOAD, Unix/Linux, Crystal Reports (Business Objects XI).

Genus RMT, Vancouver B.C
July 2003 - April 2004
Main Role: Senior Developer/Technical Designer

Daily Duties included:
Designed, built, and tested a set of data conversion PL/SQL components for GENUS clients' current forestry management, silviculture and GIS databases.
Assisted Business Analysts with requirements and fit-gap analysis for new clients to the GENUS RMT application suite.
Mapped tabular data from many different data sources for each client. E.g. MS Access, Excel, SQL Server, Dbase IV, flat files.

Major GENUS RMT Clients:
British Columbia Timber Sales (Ministry of Forestry),
Pope and Talbot
Weldwood
Temple Inland (a large south eastern U.S. Forestry company)

Skills used: PL/SQL (Oracle 8), TOAD, and Powerbuilder 7/8

Weldwood of Canada, Vancouver B.C.
June 2001 -- May 2003
Main Role: Senior Developer/Technical Designer

Daily Duties included:

Maintenance of the Forest Management and Roads Systems Powerbuilder applications which integrated with a spatial GIS database (ESRI ArcMap, ArcCatalog, ArcView)
Designed, built, tested new enhancements and reports
Converted all tabular data of the Forest Management and Roads Systems to Canadian Forest Products GENUS application from Informix to Oracle.
Administrated several Informix 7.x databases remotely for each Weldwood mill site.

Major Projects / Accomplishments

Attended all day meetings to discuss GENUS RMT requirements gathering with clients from three of Weldwood mills in 100 Mile House, Quesnel, and Prince George.
The data conversion project to GENUS RMT took over a year. Each of the six mill sites had a beta test version in parallel with production to audit and give feedback. Once all issues were resolved each mill went live sequentially about a week apart.

Skills used: Powerbuilder 7, Informix 7.x/9.x, Oracle 7.3, TOAD, UNIX

City of Prince Albert and Melfort, Saskatchewan
Dec 2000 -- August 2004
Main Role: Senior Developer/Technical Designer

Duties included:
Maintained and created new enhancements to the Municipal Assessment and Property Tax Application (MANTA) and Revenue Collection System (RCS)
Converted the applications from Powerbuilder 4 (16 bit) to Powerbuilder 5 (32 bit) environment.
Tuned the Oracle databases.

Major Enhancements
Base Tax Calculation
Education Property Tax Rebate Program
Special Charge enhancements
Updated RCS to allow exporting of property debit/credit transaction files to Royal Bank, CIBC, and Bank of Nova Scotia flat file formats.

Skills used: Powerbuilder 4/5, Oracle 7.x, TOAD, Norton PCAnywhere, Remote Administrator.

Sierra Systems, Vancouver, BC
September 1993 -- May 2000
Main Role: Developer/Technical Designer/Analyst

Duties included:
Created and maintained new client/server enterprise database applications for several of Sierra System's key public and private sector clients
Regularly discussed application requirements and production issues directly with business clients
Created technical and user documentation for new systems
Migrated, translated or upgraded applications and databases to new versions or platforms.

Major Projects / Accomplishments

2000
Investigated n-tier architecture and the use of such technologies as Jaguar, CORBA, and Java based applications. Created middle-tier components from existing client/server code using PowerBuilder 7 and PowerJ. Created Java, PowerBuilder, and web clients that accessed these components to demonstrate the flexibility of using Sybase EAServer.
1996-2000
Municipal Assessment and Property Tax Application (MANTA) and RCS (Revenue Collection System)

The Manta application:
Contained all property tax and assessment information for the municipality
Created Assessment and Tax Notification and Tax Bills annually for all properties
Generated AP and AR transactions on each property account and assessed penalties for arrears accounts and discounts for timely payments.
Day, Month and Year End accounting procedures
Generated user requested reports such as Tax Certificates, Tax Statements.
Bilingual support
Multiple provincial municipal tax regulations supported

Using a pilot version of Manta and RCS for the City of Saskatoon, the applications were installed and modified to the client's needs in the following Canadian cities: Regina, Moose Jaw, Melfort, Prince Albert, Winnipeg, London, Kitchener, and Oshawa.

The target platform environments consisted of a Windows NT or UNIX server running SQL Server or Oracle databases with many Windows 95/98/NT client PCs. The application was developed using PowerBuilder 4.0/5.0/7.0 and PL/SQL (Oracle 7.x) / Transact-SQL (SQL Server 6.x/7).

1994-1996
Unicon International provides survey and insurance services for shipping containers and chassis' to transportation companies worldwide.

The UNITRAC application included:
customer administration
customer billing
repair administration
contractor management and payment
survey validation and correction
global/summary reporting
interfaces to existing systems in UNIOCN local and world wide locations

The target platform environment consists of a Windows NT Server 3.5 running SQL Server and many Windows for Workgroups client PCs. The application was developed using Visual C++, Integra VDB, Help Magician, and Crystal Reports Professional.

1993-1996
Several Foxpro 2.0/2.5 for DOS applications including:

Ministry of Transportation and Highways - Development Approvals System
Major enhancements included
converting to a multi-user system
advanced searching capabilities
providing print preview of all reports
consolidating district data at the regional level

Wolverton Securities - Treasury Order System
Created a new system (TOS) for the Vancouver Stock Exchange that would interface with the existing Stock Analysis System.

Developed enhancements to Sierra Systems' internal Payroll, Accounts Receivable and Accounts Payable systems.

Skills used: Powerbuilder 4-7, Oracle 6.x/7.x, TOAD, Visual C++ 1.5, SQL Server 4.x-6.x, Foxpro for DOS 2.0/2.5, Dbase IV, Crystal Reports.

Education
1989--1993 Principia College Elsah, Illinois USA
B.Sc. Computer Science and Mathematics

August 2004 Langara College Vancouver, BC
.NET Solutions Developer Certificate ( Summer Intensive Program ).

Skills
Skill Name

PL/SQL 7.2 - 10g
Oracle 7.2 -- 10g
PL/SQL Developer / TOAD
Oracle Application Express
Unix (shell scripting, Cron, Autosys)
Oracle Application Server 10g
Windows 95,98, NT, XP, Vista
Crystal Reports (BusObjs XI)
PowerBuilder 4.0-8.0
PFC (5-7)
Informix 7.x, 9.x
Transact-SQL
SQL Server 4.x -- 2000
Jaguar (Sybase)
Visual Studio .NET
C#, ADO.NET, ASP.NET
Visual C++
FoxPro for DOS
Skill Level

Expert
Expert
Expert
Intermediate
Intermediate
Novice
Expert
Novice
Expert
Expert
Intermediate
Intermediate
Intermediate
Novice
Novice
Novice
Intermediate
Expert
Experience

12 years
12 years
12 years
1 year
4 years
1 year
15 years
1 year
8 years
5 years
2 years
3 years
6 years
< 1 year
1 year
1 year
2 years
3 years
Last Used

Current
Current
Current
Current
Current
2 years ago
Current
2 years ago
6 years ago
7 years ago
8 years ago
8 years ago
8 years ago
9 years ago
6 years ago
6 years ago
12 years ago
13 years ago


Certifications
See above

CONTACT DETAILS

You must be logged in and have a current resume access subscription. Login or Register »

Related: Programmer / Developer Resumes | IT Resumes in Vancouver, BC | IT Resumes in British Columbia