ADAM W. RUDZIK
Phone: (403) 272-9423 Canada, Email: rudzika@shaw.ca

OBJECTIVE
Database Analyst / Developer
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 analysis
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.

PROFESSIONAL EXPERIENCE
SULPETRO INC., CALGARY, AB June 2007 - Dec 2007
Microsoft 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 Inc.
Involved in analysis, development, coding, testing and implementation of the Excel application.
CARMANAH SIGN GROUP., CALGARY, AB Mar 2004 - Jan 2006
Microsoft Access Database Developer / VBA Programmer
Designed 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.
Created 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 1999
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 privileges.
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
Database Administrator/Analyst/Programmer
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.
EDUCATION AND COURSES
Master of Science in Electrical Engineering - Technology University, Gliwice, Poland.
Computer Programming Certificate - Control Data Institute, Munich, Germany 1990.
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, AB 2002.
TECHNICAL EXPERTISE
Operating 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 (VBA), JavaScript, XHTML, CSS, PHP.
Design/Development Tools: SQL*Plus, PL/SQL, Toad, SQL Navigator, Oracle Power Objects, Visual SlickEdit, Microsoft Office Suite (Access, Excel, Word, Outlook, PowerPoint).