Phone: (403) 272-9423
Canada, Email: firstname.lastname@example.org
SUMMARY OF QUALIFICATIONS
Over 20 years of
international experience in information system analysis, consulting,
programming, software design and development, trouble-shooting, testing
and performance tuning.
12 years of experience as accomplished IT professional including Oracle/Sybase
Administration and Database Analysis, PL/SQL, C, Pro*C and VBA Programming,
MS Access, MS Excel and other Applications Development.
Oracle9i Certified Database Associate (OCA) bringing over six years
of Oracle experience as Oracle Database Administrator, Analyst and PL/SQL
Developer and over three years as Microsoft Access/Excel Developer.
Involved in creating, redesigning and testing dynamic, database driven
websites using PHP and MySQL. website tracking, web statistics and website
Strong analytical problem solver, vast experience in client/server assignments
covering all the major roles from Application/Systems Developer, Tester
and Programmer to Database Analyst and Administrator.
SULPETRO INC., CALGARY, AB June 2007 - Dec 2007
Excel / Access Developer and Systems Analyst
Created and developed an application for automatic generation of
the LPG Supply Yearbook on MS Excel from the LPG Almanac on MS Access
- a project for Sulpetro Inc. The LPG Almanac and NGL Supply
Yearbook are distributed to the energy industry in Canada and the USA.
Analyzed, coded and automatically created an Excel application with
Detail of NGL Extraction at Gas Processing Plants for all provinces
in Canada and all states in the USA.
Designed and devoloped customized Excel spreadsheet templates with initial
results and printer friendly version, including all headers, footers,
totals information and automatic page numbering. Created a special user
form to accept certain data and transfer specific information from the
form to the worksheets.
ARSENAL ENERGY, CALGARY, AB Oct 2006 - Jan 2007
Microsoft Excel Data Analyst and Developer
Automated complex and repetitive tasks (opening files, searching,
converting, moving and copying data) in Excel spreadsheet documents
by using Visual Basic for Applications - a project for Arsenal Energy
Involved in analysis, development, coding, testing and implementation
of the Excel application.
CARMANAH SIGN GROUP., CALGARY, AB Mar 2004 - Jan 2006
Access Database Developer / VBA Programmer
and developed Microsoft Access database application - Pricing Model
Wizard - a project for Carmanah Technologies Corp. The purpose of this
project was to quote any number of signs based on various factors, such
as: type of sign, sign dimensions, extrusion colors, mounting system,
LED types and artwork evaluation.
sophisticated Quotation form with all needed calculations by using VBA
Class Modules, Property Procedures and Functions, ActiveX Data Objects
and different controls. Designed tables, queries and other forms (for
Customers, Users and Report Options) and a special password protected
Administration form). Created Quotation Summary and Major Components
reports for the quoted signs.
Achieved scalability and high performance of Access application by integrating
Microsoft Access with SQL Server (linking SQL Server database tables
to Access database through the ODBC connection). Participated in analysis,
design, quality control testing, troubleshooting, implementation and
deployment of the application.
WADEAN COMPUTER CONSULTANTS INC., CALGARY, AB Oct 2001 - Mar 2004
Oracle 9i / Microsoft Access Database Analyst and Developer
Planned, configured, installed and managed Customer Information
Database in Oracle 9i environment - project for Wadean Computer Consultants.
Performed various administration tasks, including: managing an Oracle
instance and security, creating and dropping a database, managing tablespaces,
undo data, tables, indexes, users, etc.
Designed, developed and tested stored procedures, functions and PL/SQL
packages for Customer Information Database. Customized error conditions,
exceptions and messages by defining PL/SQL triggers and cursors. Implemented
various business rules for data conversions by creating functions and
using special database tables.
Converted Customer Information Database from Oracle 9i to MS Access
2000/2003 making extensive use of SQL, ADO, VBA and robust error handling.
Exported Customer data from Access tables and reports to a set of static
HTML pages and XLS spreadsheet data. Imported Excel spreadsheet data
and XML documents into Access 2003 tables.
EDS OUTSOURCING CENTRE, CALGARY, AB June 2000 - Aug 2001
Oracle PL/SQL Developer and Systems Analyst
Participated in analyzing and developing EDI application (E-Business
- Interline Train Sheet Information) - project for CP Railway. The purpose
of this project is an automated process of exchanging inbound and outbound
information with foreign railroads about expected train arrivals at
various interchange points.
Designed, coded, tested and documented Oracle portion of the Application
Server using Oracle PL/SQL programming (specifically Quest's SQL Navigator)
and largely developing PL/SQL packages, stored procedures and functions,
cursors and triggers (Oracle8i Enterprise Edition Release 8.1.7 in HP-UX
11 environment). Tested and verified application data covering all events
within the specified parameters. Used Common Error Log facility to capture
error messages, warnings and bad data.
Actively involved in analysis, coding, testing, and reviewing Shell
scripts, MQs, Pro*C and C portion of Application Server and Data Server
in combination with Common Module Data Server on HP-UX 11 platform.
Participated in all phases of the EDI project working closely with Business
Analysts, Data Architects and other Developers.
DMR CONSULTING GROUP INC., CALGARY, AB Oct 1999 - Mar 2000
Database Analyst and Senior Systems Developer
Responsible for one of the most complex and challenging areas of
the CIMS (Contract Information Management System) Enhancement project
for TransCanada - Create and Approve Termswap Applications (changes
to the terms and volumes on customer contracts to flow gas on the Alberta
portion of the TransCanada pipelines).
Designed, coded and performed code reviews/walkthroughs - enhanced existing
Omnis 7.3 code, re-designed and created new procedures for the application,
built complex spreadsheets (in EXCEL format), reports and RTF documents
sent out to the customers.
Performed analysis of database objects, their relationships and optimal
joins required for modules identified for the project and improved processes
for creating and approving Termswap applications. Re-defined database
views used by the system and improved numerous SQL queries, applied
Batch SQL Transactions to the application which rapidly speeded up the
Create and Approve Termswap processes. The CIMS Enhancement application
worked in both Oracle and DB2 environments.
Participated in specification generation by working with Business and
Project Analysts, Recovered specifications from existing code into system
documents, readable not only by the user Community but also by other
developers. Prepared unit and functional test cases for various areas
of the CIMS Enhancement project and created for them the adequate documents.
VELA INFORMATION TECHNOLOGY PROFESSIONALS, CALGARY, AB Feb 1997 - Oct
Oracle/Sybase DBA and Analyst, Systems Developer
Responsible for the Database Administration and Analysis of the
development server (Oracle 7 running on Windows NT server): created
database instances, database objects, wrote triggers and stored procedures
for various databases, created and maintained roles, users and their
Performed database creation for the Athlete Registration application.
Added features to allow for a more sophisticated method of dealing with
teams and event entries results.
Worked as contractor at TCPL for a US company - Iroquois Gas Transmission
System on the following projects: Migration GTAS (Gas Transportation
Accounting System) historical information from Oracle 7 to Sybase 10
& 11 environments and Business Reference Datafeed changes.
Part of team working on an Omnis client server application for validation
server project (AFS) involving analysis, design and development of system
components for gas transmission contracting (project for NOVA Gas Transmission
Ltd.) AFS was a part of already existing large application called CIMS
- Contract Information Management System. Application worked with both
an Oracle and DB2 databases.
DYAD DATA SERVICES (CANADA) LTD., CALGARY, AB Nov 1995 - Feb 1997
Maintained seismic, land and well databases implemented in VAX RDB
using SQL and VAX Pascal /RDO. Responsible for data update, data loading
software, and data maintenance routines written in Pascal for VAX RDB.
Created Spatial Data Files (SDF) for P.I. Culture/Grid environments
and converted them to Argus comma delimited (CSV) format with help of
Spatial Data Loader. Created indexes and built SQL queries to extract
data from PIDM Culture tables.
Involved in development of backup and recovery strategy for VAX RDB:
Analyzed VAX database structure, dumped database files, analyzed space
utilisation, verified database contents, moved storage areas to different
devices, reduced snapshot files, backed up and restored database files.
ACCUWARE BUSINESS SOLUTIONS LTD., CALGARY, AB May 1993 - July 1995
Client/Server Consultant, Oracle/Omnis Developer.
Performed analysis, design, development, implementation and support
of cross platform client server applications using Omnis 7 and Oracle
relational databases on both Mac and Windows based machines. Wrote external
'C' Subroutines for Omnis applications.
Involved in designing, developing, testing, writing enhancements and
implementing of Enroller Seven - a large enrolment/registration system
- project for Computer Dynamics (Texas, USA). Provided technical and
analytical support for this Oracle based system which is now being used
by Dale Carnegie, Amdahl and other organisations.
Designed, modified and enhanced Resource Librarian application - library
management system for Carewest (a community of caring). Provided technical
and analytical support for the application.
of Science in Electrical Engineering - Technology University, Gliwice,
Computer Programming Certificate - Control Data Institute, Munich, Germany
Oracle 7.3 DBA Courses at Oracle Corporation Canada, Calgary, AB 1998.
Sybase DBA Courses at TransCanada, Calgary, AB 1999.
Computer Programming Certificate - Southern Alberta Institute of Technology,
Calgary, AB 2000.
Oracle8i Database Certificate - Southern Alberta Institute of Technology,
Calgary, AB 2002.
Oracle9i Certified Database Associate (OCA) - Oracle Corporation, Calgary,
Systems: UNIX (HP-UX 10 & 11, DEC ALPHA), VAX/VMS, MS-Windows
95/98/NT4/2000/XP, MS/DOS, Mac OS.
Databases: Oracle 7/8i/9i Enterprise, Sybase 10/11, DB2,
Microsof Access 2000/2003, MySQL.
Languages: Oracle SQL, PL/SQL, Pro*C, Sybase Transact-SQL,
C/C++, Assembly, Object Pascal, Fortran, Visual Basic for Applications
Design/Development Tools: SQL*Plus, PL/SQL, Toad,
SQL Navigator, Oracle Power Objects, Visual SlickEdit, Microsoft Office
Suite (Access, Excel, Word, Outlook, PowerPoint).