RESUME

ANDREW SOBCZAK

cell: 1-705-***-**** (Canada)

email: ac3lvw@r.postjobfree.com

--- PROFILE ---

An information systems professional working with client/server architecture and technology. Proficiency in : business analysis and reporting

strategic planning

capacity planning

systems analysis

data modelling

database design, administration, performance tuning, disaster recovery data warehouse design and administration

GUI design

object oriented development, all phases of SDLC

Quick learner performing effectively in a team environment as well as independently. Strong interpersonal, communication, and organizational skills, highly ethical behaviour and dedication. Excellent verbal & written communications skills.

Canadian citizen with government security clearance. Methodologies:

data flow diagrams

process modelling

prototyping

pseudo code

structured analysis, design and development

Technical Skills Summary:

Business reporting (Oracle Reports & Forms, SQL*Plus, Pro*C, Powerbuilder, Crystal Reports), 12 years Oracle database administration, design, performance tuning, 14 years Oracle data warehouse design and administration, 2 years Oracle PL/SQL, SQL*Plus, database back-end development and code optimization, 15 years Data modelling (logical and physical) for enterprise data warehouse with Erwin 4, 5 years Oracle Financials (General Ledger), 1 year (Nortel in Brampton) Oracle 9i Developer Suite (JDeveloper, Designer, Forms, Reports), 1 year (CFG in Mississauga) Oracle Developer 6i Suite (Designer, Forms and Reports), 1 year (Nortel in Brampton) Oracle Forms 3.0 and Developer/2000 Suite (Forms, Reports), 1 year (Nortel in Milton and Brampton) Oracle server and tools installation and configuration, 1 year MS SQL Server Transact SQL database development, ~ 1 year Perl, JSP, XML, Java programming, shell scripting on Unix, Apache Web server, 1 year (CFG in Mississauga, AGF in Toronto and Nortel in Brampton)

VisualBasic, MS Access, 2 years (RBC Insurance in Mississauga) C programming on Unix (Pro*C), 3 years and VAX/VMS, 8 years Powerbuilder objects design and development, 10 years Prograph CPX (visual programming framework) on Macintosh, 2 years Operating Systems:

VAX/VMS, Unix (HP, Digital, Sun Solaris, SGI Irix, IBM AIX, RedHat Linux), Apple Macintosh OS, Microsoft Windows. Applications:

Oracle Financials GL, Oracle Developer Suite (JDeveloper, Designer, Forms, Reports), Oracle PL/SQL, SQL*Plus, Oracle Application Server, Oracle IFS, Oracle Workflow, Oracle Pro*C, Toad, SQL Navigator, PL/SQL Developer, Powerbuilder, C compiler on VAX/VMS and Unix, Prograph CPX on Macintosh OS, ERWin, Perl, Unix shell scripting, Apache Web server on Unix, StarTeam, PVCS Tracking, CVS, MS Visual SourceSafe, MS VisualBasic, Crystal Reports, Remedy - Ticket Tracking System, Lotus Notes. Databases:

Oracle, MS SQL Server, MySQL, ButlerSQL, FoxPro, VAX RDB

--- PROFESSIONAL EXPERIENCE

On Georgian Bay Real Estate Inc. brokerage in Victoria Harbour, real estate broker 2003 to present Omtronix Engineering Corp, Mississauga, Oracle DBA and PL/SQL developer, contract April 2005 to Dec 2016 Engineering Oracle 12 DBA, PL/SQL, Pro*C, and Powerbuilder developer. Database development supporting research and development of hardware and software solutions for industrial (mold, tool, die, aerospace, rapid prototyping) automation and DNC and CNC machining. Developed a framework of applications with Powerbuilder 12 on Windows frontend including: parts and equipment inventory database, research data analysis, simulation and reporting tool, marketing contacts and accounting/billing database. Enterprise web site development and maintenance using MySQL and Adobe Creative Suite.

ESI Canada, Mississauga, Sr Programmer Analyst, contract July 2004 to March 2005 Dental and Pharmacy benefits management system. Maintenance of Dental Claims application written in Visual Basic, Pro*C, PL/SQL with Tuxedo application servers and Oracle backend. HP Unix, MS Windows XP and Oracle 8 environment.

RBC Insurance, Mississauga, DBA, contract July 2003 to May 2004 Marketing DBA, monthly data refresh (Home and Auto Insurance, Critical Illness Insurance and Travel Insurance)

(data upload with SQL*Loader), conversions and validations. Business logic PL/SQL code maintenance and new development of marketing reports (using SQL*Plus) and PL/SQL stored procedures validating data being migrated. Developed logical data model for enterprise data warehouse, in compliance with the enterprise data standards with Erwin 4. Involved in data migration from Oracle to NCR Teradata data warehouse. Oracle 8i, MS Windows 2000 environment.

Ministry of Natural Resources, Peterborough, Systems Analyst, contract Apr 2003 to May 2003 The OC ADS System project for integration between the CTT ADS IVR System and the OCIS database management system. Development of detailed functional specifications, programmer specifications, writing code, conducting unit tests. Oracle 8i, MS Windows NT 4, Pro*C, Vax/Open Vms environment. CFG, Mississauga, DBA and Analyst/Developer, contract Mar 2002 to Apr 2003 Oracle 9i database design, administration, maintenance, performance tuning on Linux, Sun Solaris Unix, MS Windows 2000 and Macintosh OS X platforms. Oracle software installations, upgrades and troubleshooting. Development of a Web-based publishing management system developed with Oracle Application Server, Workflow 2.6, IFS, Designer, JDeveloper 3, JSP, PL/SQL, SQL*Plus, Java, MySQL and CVS source code control system. AGF (CGI client), Toronto, Database Analyst, contract Aug 2001 to Mar 2002 Database performance tuning, SQL and PL/SQL code maintenance and optimization of mutual funds applications: error correction of processed wire orders, XML based system processing wire orders, data amalgamation process. Oracle 8i and Unix HP environment. Data modeling with ERWin 3.5. Development tools: Oracle PL/SQL, SQL*Plus, Powerbuilder 7, Toad, SQL Navigator, StarTeam.

Nortel Networks, Brampton, Support Analyst and Developer, contract Jul 2000 to Jul 2001 Oracle SQL (SQL*Plus), PL/SQL, Pro*C, Perl 5.6.1, Unix shell scripts code maintenance and optimization of a corporate finance reporting system developed in-house. Participated in the migration from Oracle Financials 10 (HP Unix 10) to 11i (HP Unix 11). Re-write of business logic from Oracle Forms 4.5 to 6i. Data modelling with ERWin 3.5. Installation and configuration of Apache 1.3.19 Web server for a Web-enabled financial reporting application. Implementation of a global user authentication technique based on URL redirection scheme. Provided hotline technical support for production environments and users responding to emergency requests using Remedy ticket logging and tracking system.

Toronto Dominion Bank, Toronto, DBA, part-time contract May 2000 to Jun 2000 Oracle software installation, configuration on Oracle 8.0.5 and IBM AIX 4.2 Unix back-end. Database design and administration.

News America Marketing, Norwalk, Connecticut, USA, Database Analyst, contract Nov 1999 to May 2000 Oracle 7.3 SQL (SQL*Plus), PL/SQL code maintenance and enhancements of an in-store marketing analysis system developed with Powerbuilder 5 on MS Windows. Sun Solaris 5500 Unix server.. Developed techniques for database performance tuning. Data modeling with ERWin 3.5.

Paratech Innovations, Mississauga, DBA, part-time contract Oct 1999 to Feb 2000 Oracle 8i software installations, upgrades and troubleshooting on Unix (Sun Solaris 7, SGI Irix 6.5), MS Windows NT 4 and Macintosh OS 9. Database design and administration Development of Oracle PL/SQL stored procedures. Cott Beverages, Mississauga, DBA and Analyst/Developer, contract Dec 1998 to Nov 1999 Oracle 7.3 SQL (SQL*Plus ) and PL/SQL code maintenance and optimization on HP Unix and NT 4 servers. Database administration, maintenance and performance tuning. Supported development of corporate business reports with Powerbuilder 6.5 on Windows 95. Y2K code maintenance. POS application code troubleshooting and optimization in Powerbuilder 6.5 and Oracle 8.0.5. Allstate Insurance, Markham, DBA and Analyst/Developer, contract Oct 1997 to Dec 1998 Oracle 7.3 data warehouse design, administration and maintenance. Home and Auto and Travel Insurance data. Oracle SQL (SQL*Plus), PL/SQL and Pro*C code development and performance tuning on Digital Unix server. Development of an analysis system generating summarized insurance reports with PowerBuilder 5 on Windows 95. Implementation of a process feeding data (monthly and daily) into an Oracle data warehouse. Developed techniques maximizing the process throughput. Data modelling with ERWin 3.5. CIBC Mellon Trust, Toronto, DBA, contract Aug 1997 - Oct 1997 Oracle database design, administration, performance tuning. Oracle SQL (SQL*Plus) and PL/SQL code programming, optimization and testing. DBA support for large group of PowerBuilder developers, coaching them through code optimization process.

AL’s Cartage, Kitchener, DBA and Analyst/Developer, contract Jun 1997 - Aug 1997 MS SQL Server 6.5 database design, maintenance and performance tuning on MS Windows NT 4 server. Development of a truck dispatch system in PowerBuilder 4 and Transact SQL. Implementation of a process migrating production data from a proprietary system into new MS SQL Server database. Developed techniques to optimize the process throughput.

Northern Telecom, Milton, Database Analyst and Developer, contract Dec 1996 - May 1997 Oracle 7.2 SQL*Forms 3.0, SQL (SQL*Plus), PL/SQL and Pro*C code maintenance, enhancements, and optimization on HP Unix back-end. Developed techniques to boost performance in database and reporting module of the application. Development of a customs duty management and corporate finance reporting system. AGF Management Inc., Toronto, Database Analyst and Developer Mar 1996 - Oct 1996 Oracle 7.2 SQL (SQL*Plus )and PL/SQL code maintenance and optimization on Unix server. Development of a mutual funds inquiry application with PowerBuilder 5 on MS Windows 95. Developed techniques to optimize reporting process.

20/20 Funds Inc., Oakville, DBA and Analyst/Developer Jun 1994 - Mar 1996 Merged with AGF Management Inc. in March 1996.

ButlerSQL databases design, administration and maintenance on Macintosh platform. Development of a mutual funds inquiry application in Prograph CPX on Macintosh with Cobol/RPG and AS/400 back-end. Also development of a document workflow management program archiving scanned documents on optical jukebox in Prograph CPX with ButlerSQL database on Macintosh.

KPMG Peat Marwick Thorne, Toronto, DBA and Analyst/Developer Aug 1993 - Jun 1994 ButlerSQL database design, administration, and maintenance on Macintosh platform. Development of an office automation application (sending data from PC to IBM mainframe via MS Mail server) in Prograph CPX with ButlerSQL database on Macintosh.

Infonet, Toronto, Analyst/Developer Feb 1993 - Aug 1993 Developed a phone banking application with Borland C++ and FoxPro on MS Windows 3.1, DecForms and VAX RDB database on VAX/VMS 5. GUI design, code optimization in Borland C++ on PC and DecForms on VAX. Carswell, Scarborough, Systems Analyst Apr 1991 - Feb 1993 BRS Search flat-text database design, administration and maintenance. Development of legal publishing applications in VAX DCL, BRS Scribe on VAX/VMS 4.5. GUI design in BRS Menu on VAX.

--- EDUCATION ---

Master Degree in Electronics, Telecommunication Faculty, from Warsaw University of Technology in Poland.

--- PROFESSIONAL DEVELOPMENT ---

- Fast Track to PowerBuilder 5 at Visual Systems, Toronto, 1996.

- Project Management Course at York University, Division of Executive Development, Toronto, 1994.

- Oracle Database Technology seminars, Toronto, 1992.

- On-going self education Internet based in Information Technology field.

Contact this candidate