Projects - Analyst-Programmer Soluco
16817
page-template-default,page,page-id-16817,page-child,parent-pageid-15234,ajax_fade,page_not_loaded,,qode-theme-ver-13.1.2,qode-theme-bridge,wpb-js-composer js-comp-ver-5.4.5,vc_responsive
 

Projects

Projects and Analysis

Here are some projects I worked on​​.  A careful analysis is always done before I start any coding. I use layer object-oriented design for all my new projects.

 

Click on a project line for more details.

My Latest CV

Macplus (Retailer Restoration)

Tools

  • Vb6
  • Crystal Report
  • TAPI
  • FTP
  • Telson
  • Inforecorder

Functions

  1. Reads the information from different cash registers and punch systems.

  2. Sends the information to various payroll systems.

  3. Places orders on BBS.

  4. Imports recipes.

  5. Supports stock taking.

  6. Produces various reports.

Centralized Update (Retailer Restoration)

Tools

  • Visual Studio 2008 (Windows service  )
  • Visual Studio 2008 (Web Service )
  • Visual Studio 2008 ( Windows Program )

Functions

  1. Each PC sends a list of information (name and version of each program installed ) to its local server.

  2. Each local server communicates with the central web service to see if there are updates available.

  3. Each local server sends updates to its PC.

  4. A report of all Canadian licenses and their version is produced.

Notaire plus (Quebec notaries)

Tools

  • VBA
  • Access
  • Word

Functions

  1. Enters the customer data in a database.

  2. Generates comprehensive contracts in Word by using the data and a Word template.

Report Generator (Accounting)

Tools

  • Visual Studio 2008
  • Excel
  • Access

Functions

  1. Reads the trial balances of several ERP.

  2. Reads an Excel template spreadsheet.

  3. Manages grouping of G/L accounts.

  4. Creates a copy of the Excel template file and  pushes the consolidated trial balances and G/L  group  (ie final balance).

PDF Creator ( Unix et Windows)

Tools

  • Visual Studio 2010 (Windows Service )
  • Ms SQL
  • Visual  Stydio 2010 (Asp.net)
  • Itextsharp
  • Unix Scripting

Functions

  1. Sends reports to a Windows service.

  2. Creates PDF files with hidden codes for each page received.

  3. Creates an entry in a database for each PDF file.

  4. Gives a controlled access to each PDF file through intranet for printing or emailing.

Mass email

Tools

  • Visual Studio 2010 (Asp.net)
  • Itextsharp
  • Ms SQL
  • Entity Framework

Functions

  1. Separates PDF files into smaller PDF files using the hidden codes in each page.

  2. Sends all these small PDF files to different email addresses  (ie invoices, account statements).

Tank Inventory Management ( port )

Tools

  • Visual Studio (2010)  asp.net
  • Entity Framework
  • Ms SQL
  • Visual Studio (2010)  Windows
  • Crystal Report
  • Weigh-Tronix Scale
  • Topaz Signature Pad
  • Zebra Printer

Functions

  1. Automatically weights trucks.

  2. Gets electronic signatures from truckers.

  3. Prints the electronic documents.

  4. Full inventory system with automatic inventory adjustments depending on temperature.

  5. Prints various inventory and billing reports.

EDI File Creator (manucfacturier)

Tools

  • Visual Studio 2012 (Windows Service)
  • Entity Framework

Functions

  1. A Windows service reads an XML file which gives instructions on how to read each source file, its location and where to create a destination file.

  2. As soon as a source file is detected, the service detects the type of transaction and creates a EDI file.

Zebra Print Layer (manufacturier)

Tools

  • Visual Studio 2012
  • Entity Framework
  • Zebra Designer
  • Zebra Printer

Functions

  1. As soon as an XML file is created, the program reads the number, the model, the destination and the label data.

  2. The program reads the correct template ( file created by Zebra Designer ).

  3. The program prints the label.

System of estimates and orders (manufacturing)

Tools

  • Visual Studio (2010) asp.net
  • Entity Framework
  • Ms SQL
  • Crystal Report
  • Google Maps Api

Functions

  1. Creates estimates and orders.

  2. Validates the address of each client with Google Maps.

  3. Creates custom Google maps.

  4. Monitors production.

  5. Prints order, estimate and shipment reports.

  6. Prints sales statistics reports.

  7. Exports sales to Accpac ERP .

Purchase System (importer)

Tools

  • Visual Studio 2008 ( asp.net)
  • Entity Framework
  • Ms SQL
  • Crystal Report
  • Monarch Printer

Functions

  1. Manages purchases of items with sizes and colours.

  2. Accumulates multiple orders into one shipment.

  3. Receives and creates labels.

  4. Calculates the landed cost.

  5. Sends the information to an old ERP system.

Management of logins and peripherals ( IT )

Tools

  • Visual Studio 2012  (asp.net)
  • Entity Framework
  • Ms SQL
  • Crystal Report

Functions

  1. Imports clients’ information from Advantage ERP.

  2. Creates contact networks, logins and passwords.

  3. Associates devices and IP addresses to each network.

  4. Advanced queries to locate devices and contacts .

If you have any questions : daniel@devsoluco.com