Cory Lievers (http://www.cory.lievers.ca/)

:: Employment Projects

While I have been involved with various kinds of projects and tasks, these are a few of the ones that stand out. Please Note: These projects are career related, as opposed to general jobs / tasks.


Net Dimensions

Support Site

Purpose: To create a new ASP.NET support website for Wonderville Website.
Duration: 2 months
URL: http://support.wonderville.ca
Role: Design, Application Developer

  • Improvements: increased usability, increased performance, branding, new technologies, security, forum tool
  • Creation of support site, integrate purchased Forum tool into the site.
  • Extend the Forum tool to include Client-required customizations
  • Override some of the Forum functionality based on Client requirements
  • Security for accounts and protected content
  • Implementation on Client servers

Document Delivery System

Purpose: A secure web-based file-sharing application developed for service companies involved in the oil and gas industry. It is designed to enhance communication and facilitate immediate access to project documents.
Duration: 1.5 Years initially, On-going
URL: http://www.netdimensions.ca/dds/
Role: Design and develop a Java application with a MySQL back end and a JSP/Servlet front end using the Jakarta Struts Framework

  • Database Design for MySQL, Application Design
  • Script creation for database access and population, maintenance, etc
  • Development of Application
  • Testing
  • Upgrades, new functionality

Document Delivery System: Back-end Utilities

Purpose: To develop command-line utilities for database and file synchronization, between a Companies internal information, and their externally hosted information (for Client access).
Duration: 1 Month
Role: Design and develop Java application command-line utilities

  • Development of Utilities
  • Testing
  • Upgrades, new functionality

Online Bookstore Maintenance and New Development

Purpose: To maintain a Client's Online Bookstore and any new development required
Duration: 2 Months initially, On-going
URL: http://www.selfconnection.ca
Role: Maintain the current website. Any new development for the Client.

  • Uses the Data Migration Tool, mentioned below, for the population of the Online Bookstore's data.
  • Continual front-end development, upgrades

Data Migration Tool

Purpose: To develop an application that will migrate new and updated information between MySQL databases
Duration: 1 Month
Role: Design and develop a Java application with a MySQL back end

  • Field mapping between a single table (source) and multiple tables (destination)
  • Insertion of new records; updating existing records
  • Generate SQL script file to execute on host provider

Focus

Avanti Human Resources & Payroll Implementation

Purpose: To implement a Human Resources & Payroll application to make use of newer technologies.
Duration: 6 months
Role: Provided data transfer services:

  • Mapped an existing data structure (multiple databases in SQL Server, imported files from AccPac) with Avanti's (SQL Server)
  • Developed Transact-SQL scripts to transfer the initial information: Employee, Benefits, Payroll history
  • Developed Stored Procedures that, for each pay period, obtains Employees' time and applies rules that determines Regular Time, Overtime, Statutory, etc depending on the Pay Group they are in
  • Multiple rounds of quality assurance to ensure data integrity
  • Maintained the highest level of confidentiality with the information being dealt with
  • High interaction and communication with the Client (Human Resources and Payroll)
  • High interaction and communication with Avanti to work with their system

Build an Invoicing Application

Purpose: To automatically retrieve non-invoiced jobs from Wind2 FMS and allow Accountants to create invoice files to send to their Clients. This would eliminate the need for an individual to manually enter this information.
Duration: 1 month
Role: Design and develop a VB.NET Win32 application

  • Gather requirements from the Client (Accounting) and maintain communication to ensure an excellent product was delivered
  • Develop Stored Procedures to pull the necessary information from the database (SQL Server)
  • Develop a Win32 application using VB.NET that, based on user-input, would create the necessary standardized files Accountants can upload to their Clients via the Internet

Web-based Suite of Geomatics Applications

Purpose: To have a various web-based applications ranging in functionality from properties to assisting in law enforcement to emergency response.
Duration: 2+ years
Role: Application Developer

  • Originally developed in VB6. It provided access to a standard database for crimes and property tracking. It also provided address searching, and graphical and statistical analysis. MapGuide was used for mapping crimes, property parcels, owners, buildings, etc.
  • With the release of the .NET framework, this application was upgraded to make use of the newest technologies such as ASP.NET, VB.NET, and ADO.NET
  • Many various components were developed that provided additional functions and that were customizable on the back-end through XML

Internal Applications

Purpose: To develop and maintain a suite of enterprise web-based solutions, in an integrated environment, delivered through a Corporate Intranet
Duration: On-going
Role: Application Developer, Maintenance, Support

  • Tools used include VB.NET, ASP.NET, XML, VB6, MTS, SQL Server
  • Client: Tracks Clients, Offices, Contacts
  • Job Books: Tracks job and drawing information for different departments, used in Surveying and Engineering. Interaction with Wind2 FMS (Accounting application) to transfer job, client, and contact information
  • Time sheets: 3-tier application used for office time entry and field time entry. Interaction with Wind2 FMS (Accounting application) to transfer billable time to job numbers
  • Crew Tracking: Track field crews on-site
  • Accounts Receivable Tracking System: Developed for an increased turn-around time for sending invoices

Other

Website Security

Purpose: To provide information regarding website security
Duration: A few hours
Role: Provide Information and Create security files

  • Information on IIS security
  • Information on Apache security
  • Create Apached security files to protect directories

<< Back to Projects