Resume by Expertise


Mike Paolucci

Profile in Brief

Mike Paolucci is a software developer and consultant involved in all aspects of the software development lifecycle: from analysis and design, through implementation, documentation, and support.

Mike has over 20 years experience in software solution analysis and development. He specializes in developing database-driven websites. His expertise covers a number of different programming languages and a variety of operating systems.

He has worked internationally for a variety of companies in the oil and gas, pharmaceutical, and educational sectors.

Information Technology Skillset

  • Programming Languages: Perl, HTML, JavaScript, SQL, XML, C++, Java, and Visual Basic
  • Databases: Oracle, MySQL, PostgreSQL, SQL Server, Access, Sybase
  • Hardware: RS/6000, Sun SPARCstations, PC
  • Operating Systems: UNIX, Linux, Solaris, AIX, Windows
  • Miscellaneous: UML, SQL Navigator, DBI/DBD, PVCS, Subversion, TortoiseSVN, PPDM, E-commerce

Education / Certification

  • M.Sc. (Applied Mathematics) from the University of Calgary, 1987
  • B.Sc. (Mathematics) from the University of Manitoba, 1978

Expertise

  • Web-based Data Management Solutions
    1. Designing / developing numerous web-based applications for data entry, system maintenance, and reporting
      • For Quality Track International Inc., Toronto 2004 - 2006
      • From qualitytrack.com (http://www.qualitytrack.com): "Quality Track is an Internet based reservation shopping service that addresses the needs of the hospitality industry through real-time distribution of reservation shopping services"
    2. Designed and developed a web-based Project Tracking application
      • Online tool for tracking time, labour and costs in small to medium sized-projects
      • Analysis and design, data modeling, development, and testing
      • Three levels of access (roles): Administrator, Manager, Worker
      • Glendon College, (http://www.glendon.yorku.ca) York University, Toronto: May 2003 to January 2004
    3. Designed, developed, and maintained a web-based client appointment tracking website, as well as reporting and maintenance subsystems
      • For Massage Garage Inc., (http://www.massagegarage.com) Calgary 2001 to 2003
      • Technical and DBA support for the website
    4. Developed student secure online course registration and course management environment
      • Instructors can setup (announce)courses
      • Students enroll in courses
      • Instructors can view / modify course and student data
      • Developed for Learn Canada (http://www.learncanada.org)
    5. Designed and developed secure online "Jobtracker" for logging and analyzing work (time and task)
      • Employees enter their time against tasks
      • Management views progress reports
      • For Wind-Net Computer Solutions (http://www.windnetcs.com) / Aurora Internet Consultants
  • E-commerce Solutions
    1. Online payment processors
      • Implemented Internet Secure for Learn Canada (http://www.learncanada.org)
      • Implemented ePayment, Uni-Clear, and Kortathjonustan for Skymarx (http://www.skymarx.com)
    2. Online barcode label ordering system
      • Clothing label information are specified (layout, quantity, etc.)
      • Rule-based validation of the information is performed
      • A Pro Forma invoice is generated, including shipping cost if applicable
      • A secure "viewer" allows LBA to review orders and invoices
      • For Label Bank Asia (http://www.labelbankasia.com)
  • Database Design and Development
    1. Designed and implemented OO Perl code to parse several different formats of Land Sale documents.
      • Perl-Oracle interaction to acquire cross-reference codes.
      • Flat files output from the parsers were uploaded to an Oracle 8i PPDM database.
      • Wrote PL/SQL packages to process the uploaded data.
      • For International Datashare Corporation, Calgary: July 2001 to November 2002 (URL n/a)
      • environment: Windows 2000, OO Perl, Oracle 8i, PL/SQL, SQLLDR, PPDM
    2. Developed a Perl application to query an Oracle database for files to be deployed over a WAN
      • Copy the files (defined by UNC) to the appropriate destinations
      • Download data on the status of previously deployed files
      • Update the database with the above data
      • For Alliance Pipeline (http://www.alliance-pipeline.com), Calgary: May 2000 to December 2000
      • environment: WAN, Windows NT, Perl, DBI/DBD, Oracle
    3. Developed applications in Visual Basic, PL/SQL packages and triggers, and SQR
      • Data mining to determine source of unaccounted for missing gas
      • Maintained and enhanced a pipeline Gas Management (GMS) system
      • For Westcoast Energy (now Duke Energy, http://www.duke-energy.com), Calgary: 1998 to 2000
      • environment: Windows NT, RS/6000, AIX 4.3, Oracle 7.4, Pro*C, Java, Visual Basic 6, SQR, PVCS
    4. Maintained a metadata database used to dynamically create pipeline reports
      • For NrG Information Services, Calgary (URL n/a): 1997 to 1998
      • environment: Windows NT, Access, RS/6000, AIX 4, Sybase 11
    5. Developed a data entry and graphic display application for seismic geometry, using VBA for Excel
      • For Syner-Seis Technologies (http://www.oiloffice.com), Calgary: 1997
      • environment: Windows 95, Visual Basic for Applications, Excel 97
    6. Developed programs to upload data into a PPDM Oracle database
  • Software Development
    1. Developed programs to statistically filter data and compute returns for an Asset Allocation Model
      • Designed and developed a financial database
      • For Goldman Sachs (http://www.gs.com), New York: 1993
      • environment: Sun SPARCstation 10, UNIX, Sybase, C, C++
    2. Enhanced a GUI viewer that retrieves and downloads well log data
      • New GUI development via Liant (C++) base class inheritance
      • For QCData Petroleum Services (http://www.qcdata.com), Calgary: 1995 to 1996
      • environment: Sun SPARCstation 5,Solaris, C++, Liant, PVCS
    3. Designed and developed software tools to access Microsoft OLE Files
      • Developed a program to convert graphics files from WordPerfect to CGM format
      • For FTP Software, Calgary: 1994 (URL n/a)
      • environment: DOS, Windows, C, Novell, PVCS
    4. Developed VB dialogs for network mappings, installing and running applications
      • For MCI Systemhouse, Calgary and South Carolina: 1996 to 1997 (URL n/a)
      • environment: Windows 95, Visual Basic 4, NetWare 4.1
    5. Developed a compressor station model in a pipeline simulation
      • Maintained and enhanced the software
      • For Nova (now TransCanada Pipelines, http://www.transcanada.com)): 1990 to 1992
      • environment: Sun SPARCstation, UNIX,DOS, C, Novell, PVCS
    6. Designed and developed software to compute the position of a pipeline in 3D space
      • For Pulsearch, Calgary (URL n/a): 1989
      • environment: MIPS 2000, UNIX, C
    7. Developed pharmaceutical dispensing software for a pharmaceutical networking company
    8. Developed mathematical and artificialintelligence software for a well log interpretation package
      • D & S Petroleum Consulting Group, Calgary: 1988 (URL n/a)
      • environment: PC, XENIX, C

Miscellaneous

  1. Instructor: taught UNIX and Oracle courses
  2. Research assistant to several professors at the University of Calgary: 1987
  3. Various supporting roles in research projects as a graduate student at the University of Calgary: 1983 to 1987
  4. Seismic data processing, and on a land seismic field crew in South East Asia from 1978 to 1983

Languages

  • Spanish