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.
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
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.
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.
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