Chronological Resume
Mike Paolucci
Information Technology Skill set
Languages:
Perl, HTML, JavaScript, SQL, XML, C++, Java, Visual Basic
Databases:
Oracle, MySQL, PostgreSQL, SQL Server, Access, Sybase
Hardware:
RS/6000, Sun SPARCstations, PC
O/Ss:
UNIX, Linux, Solaris, AIX, Windows
Miscellaneous:
UML, SQL Navigator, DBI/DBD, PVCS, PPDM, E-commerce
Education
1987
Master of Science, Applied Mathematics
University of Calgary
1978
Bachelor of Science, Mathematics
University of Manitoba
Experience
Mike is a Systems Analyst and Software Developer with extensive experience in all aspects of the software development lifecycle: from analysis and design, through implementation, documentation, and support. This experience means he knows what works and what doesn’t, and this makes for much more efficient use of time and superior end results.
Dispensing Solutions Inc, Santa Ana, California
May 2006 – present
- DSI is the leader in prepackaged medications, and the original creator of eDispense - a web application that manages physician and payor networks and performs billing services for the administration of benefits related to medication therapy and patient management.
- Initially, Mike was Lead Developer but as a result of cutbacks Mike became the sole developer responsible for enhancements and maintenance of eDispense 4. Mike successfully gathered user requirements for fixes and enhancements, not only keeping the application functioning but also evolving the application to meet changing business needs.
- Next, Architect and Developer for eDispense 4.0 to 5.0 data mapping program. With the introduction of eDispense 5, users (and their data) needed to be migrated from eDispense 4 to 5. Mike designed and developed a Java application to pull legacy data from a MySQL database AND a SQL Server database and migrate the raw data by Java object method calls into the new PostgreSQL database.
- Currently, Mike is Senior Systems Analyst for all DSI client-facing systems. Duties include gathering user and management requirements, creating Analyis and Design documents, overseeing software development, and creating reports for management.
- eDispense 4 environment: Linux, Perl, HTML, JavaScript, SQL Server, MySQL, Apache, Subversion, TortoiseSVN
- eDispense 5 environment: Linux, Java, HTML, JavaScript, SQL Server, PostgreSQL, JBoss, CVS, IntelliJ
Quality Track International Inc., Toronto, Ontario
2004 – 2006
- QualityTrack is the world's largest provider of mystery call shopping assessments exclusively for the hotel industry.
- Designed and developed numerous web-based applications for data entry, system maintenance, and reporting.
- environment: Linux, Perl, HTML, JavaScript, PostgreSQL, Apache
- Designed and developed the GroupMetrix web-based application for gathering and reporting conference rate data.
- environment: Windows 2000 Server, Perl, HTML, JavaScript, SQL Server 2000, IIS 5.0
Skymarx Solutions, Canmore, Alberta
2005
- Skymarx sells a web-based software product called xFlow for MLM businesses.
- Customized the software to meet clients' specific requirements.
- Implemented online payment processors: ePayment, Uni-Clear, and Kortathjonustan
- environment: Linux, Perl, HTML, MySQL, Apache
Glendon College, York University, Toronto, Ontario
2003 – 2004
- Designed and developed a web-based Project Tracking application.
- Analysis and design, data modeling, development, and testing.
- Three levels of access (roles): Administrator, Manager, Worker.
- Depending on the role, the user can create/modify projects and tasks, assign workers, update progress, and produce reports.
- environment: Linux, Perl, HTML, JavaScript, MySQL, speedyCGI
International Datashare Corporation, Calgary, Alberta
2001 – 2002
- 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.
- environment: Windows 2000, OO Perl, Oracle 8i, PL/SQL, SQLLDR, PPDM
Massage Garage Inc., Calgary, Alberta
2001 – 2010
- Developed an online appointment booking application.
- Designed, developed, and maintained a client/appointment tracking website, as well as reporting and maintenance subsystems.
- Technical and DBA support for the website.
- environment: Linux, Perl, HTML, JavaScript, MySQL, SSL, speedyCGI
Learn Canada / Wind-Net Computer Solutions, Toronto, Ontario
1998 – 2006
Developed numerous Internet applications. Examples are:
- Learn Canada ( http://www.learncanada.org )
- Online course registration (secure website)
- Instructors can setup (announce) courses
- Students enroll in courses
- Instructors can view / modify course and student data
- E-commerce
- online course enrollment
- online textbook purchasing
- Online course registration (secure website)
- Wind-Net Computer Solutions / Aurora Internet Consultants
- Online label ordering -- Label Bank Asia (
http://www.labelbankasia.com )
- 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
- Online "Jobtracker" (secure website)
- Employees enter their time against tasks
- Management views progress reports
- Online label ordering -- Label Bank Asia (
http://www.labelbankasia.com )
- For secure websites, demos arranged by request
- environment: Linux, Perl, HTML, JavaScript
Alliance Pipeline, Calgary, Alberta
2000
- 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
- environment: WAN, Windows NT, Perl, DBI/DBD, Oracle
Westcoast Energy, Calgary, Alberta
1998 – 2000
- Developed applications in Visual Basic, PL/SQL packages & triggers, and SQR
- Data mining to determine source of unaccounted for missing gas
- Maintained and enhanced a pipeline Gas Management (GMS) system
- environment: Windows NT, RS/6000, AIX 4.3, Oracle 7.4, Pro*C, Java, Visual Basic 6, SQR, PVCS
NrG Information Services, Calgary, Alberta
1997 – 1998
- Maintained a metadata database used to dynamically create pipeline reports
- environment: Windows NT, Access, RS/6000, AIX 4, Sybase 11
Syner-Seis Technologies, Calgary, Alberta
1997
- Developed a data entry and graphic display application for seismic geometry, using VBA for Excel
- environment: Windows 95, Visual Basic for Applications, Excel 97
MCI Systemhouse, Calgary Alberta and Greenville South Carolina
1996 – 1997
- Developed VB dialogs for network mappings, installing and running applications
- environment: Windows 95, Visual Basic 4, NetWare 4.1
QCData Petroleum Services, Calgary, Alberta
1995 – 1996
- Enhanced a GUI viewer that retrieves and downloads well log data
- New GUI development via Liant (C++) base class inheritance
- environment: Sun SPARCstation 5, Solaris, C++, Liant, PVCS
Gemini Learning Systems, Calgary, Alberta
1995
- Taught UNIX and Oracle courses
- environment: Linux
FTP Software, Calgary, Alberta
1994
- Designed and developed software tools to access Microsoft OLE Files
- Developed a program to convert graphics files from WordPerfect to CGM format
- environment: DOS, Windows, C, Novell, PVCS
Applied TerraVision Systems, Calgary, Alberta
1993 – 1995
- Developed programs to upload data into a PPDM Oracle database
- environment: RS/6000, AIX, Oracle, Pro*C
Goldman Sachs, New York
1993
- Designed and developed a financial database
- Developed programs to statistically filter data and compute returns for an Asset Allocation Model
- environment: Sun SPARCstation 10, UNIX, Sybase, C, C++
Nova, Calgary, Alberta
1990 – 1992
- Developed a compressor station model in a pipeline simulation
- Maintained and enhanced the software
- environment: Sun SPARCstation, UNIX, DOS, C, Novell, PVCS
Pulsearch, Calgary, Alberta
1989
- Designed and developed software to compute the position of a pipeline in 3D space
- environment: MIPS 2000, UNIX, C
D & S Petroleum Consulting Group, Calgary, Alberta
1988
- Developed mathematical and artificial intelligence software for a well log interpretation package
- environment: PC, XENIX, C
1987: research assistant to several professors at the University of Calgary, Alberta
1983 – 1987: graduate student at the University of Calgary, Alberta
1978 – 1983: employed in seismic data processing, and on a land seismic field crew in SE Asia
Languages
- Spanish