Objective

To continue to learn new platforms applications and methodologies while contributing to the expertise of the IT team. I wish to use my experiences as a C C VB.NET ASP.NET MVC PowerBuilder relational database programmer to help strengthen the productivity of the IT department.

Experience

Confidential

Part of pilot Sustaining Engineering team whose duties include software maintenance for all company products. Members of this team will be allocated to a respective production team once training in MVC Agile methodologies Ruby and all facets of TDD development is completed.

I have completed a variety of tasks that involved internal proprietary development platforms for MRI software along with testing using RubyMine automation and manual unit/integration testing.

Confidential

Responsible for creating 16 interfaces to import and modify data between Oracle database and Sql Server2008 for Maine Department of Labor. The interfaces run off of a scheduling program and populate staging tables read and update Oracle and Sql Server tables and email personnel when interfaces have run or if exceptions occur. The interface pages employ a ASP.Net front end in the form of a customized web application.

Created SSRS reports for the Interfaces that OneFlow employs to synchronize data between the databases. Reports are emailed to recipients via subscriptions.

Confidential

SSIS SSRS Sharepoint 10

Responsible for creating and maintaining standalone utilities and interfaces which complement the company s order entry system OFS .Interfaces include VB.NET and MS Access applications to process freight charges and Cold Finish production.

Authored a VB.NET stand-alone application to allow the Cold Finish sales and planning staff to accurately assess inventory and reorder stock to efficiently meet order demand. In addition I created SSIS jobs to send current inventory statuses to select customers via FTP.

In-house Powerbuilder programmer for the internal order entry system OFS . Responsibilities include replacing dependence on Ghostscript with Adobe PDF Writer and various other changes to improve efficiency. Adopting this role saved the company 25k per month in 3rd party fees.

Created numerous SSRS reports for the Commercial Production Planning Cold Finish and Metallurgical departments. I also created and maintained subscriptions to send the various reports to departments and customers.

Responsible for updating content of the Republic Steel public website

Wrote a C standalone application which assists the help-desk and network systems department troubleshoot SQL Server blocking and locking problems.

Responsible for keeping nearly all of the legacy VB6 MS Access and SSIS packages running until time can be allocated to bring their functionality into a new ERP system.

Involved in assessing MP2 material inventory packages as well as EHS software for the Environment and Safety department. Accounting to be purchased based upon my recommendations.

Confidential

I was responsible for updating and adding functionality to the company Reseller Website which allows resellers and internal support personnel the ability to download company documents and review client demographics. The secure site uses windows authentication to allow resetting of passwords in an Active Directory scheme.

I was responsible for making modifications to and reports for Microsoft CRM 4.0. New functionality included importing large telesales solicitation files via SSIS custom workflows for emailing and converting leads and implementing rollups.

I was solely responsible for upgrading and implementing new functionality for the in-house Office application which manages the client accounts for the company and generates reports to run the business. The application is built using Powerbuilder 12.0 and Sybase 9.0. My final project was to convert the orders taking process for the office application away from the reseller site so that all processing could be streamlined and orders projections could be more useful for the accounting department. This process has been recognized as the foundation for future sales revenue projections.

.

Confidential

Authored Web Service which accesses Oracle database to retrieve inventory for C application on handheld PC 2003.

Created VB.NET application to convert Excel spreadsheet data into records for Oracle Database for Cimplicity application.

Created C utilities to monitor MSMQ activities for all Delphi plants. One service will page support personnel when queues grow past acceptable levels.

Support for Cimplicity HMI application in all Delphi plants.

Confidential

Wrote Visual C application to alter Oracle 8.1 database for realtime manufacturing concern.

Wrote 5 Visual C realtime data gathering control systems for several metal extrusion companies. The application creates relocatable custom graphic controls at run-time and employs shared memory to communicate with a PLC to gather data and control the extrusion process. Data can then be viewed through a C ASP.NET application that allows the operator to print reports via Crystal Reports 9.0 viewer

Authored a C /ASP.NET 2.0 application which presents 6 Dundas Charts and several Crystal Reports for the purpose of data analysis.

Restructured a master set of Excel 2000 spreadsheets which drove the quoting estimates for the company. Using VBA I was able to force the spreadsheets to conform to the requirements of the Solomon accounting system recently installed.

Authored a VB application that polls an AB PLC for various register settings send information via rs232 to 2 online remote machines to monitor cheese production for a major dairy concern. In addition the program will utilize SQL server to store and receive cheese recipes.