Management Software

LARRY C. DUNCAN

**-**** *** **, **********, Ontario L7N 1N1 289-***-****

*********@*****.***

Sr .Net Programmer / SQL Server position November 20, 2013

Flexstaf IT

I am a dedicated, thorough, meticulous and passionate Programmer with over six years of programming

experience.

My most recent position was with Children’s Education Funds as a Senior Programmer for their highly complex,

three-tier application servicing the RESP industry. This application provided dynamic web data to end users and

regional offices across Canada and to internal staff with portals and data access modeled to user type. One of my

responsibilities was the programming and support of the data interchange processes. These processes exchanged

data with federal and provincial government grant systems (requiring ultra strict adherence to data interchange

structures and transaction relationship integrity), financial institutions (banks, credit card co’s), Air Miles, and

various government compliance organizations. This system represents just under 1 terabyte of SQL data which is

managed by an extensive array of stored procedures and back end code. It also encompasses electronic storage

and retrieval of all client correspondence and all printed reports. My role in the support and enhancement of this

end to end custom application has continued to evolve my skills and expertise in the design, programming and

support of multi-tier architecture systems.

Related to your manufacturing request, I recently designed, programmed and implemented a highly complex,

specialty manufacturing application for the food industry. The application encompassed end to end functionality

including purchasing, product manufacture, inventory management, order processing, invoicing, costing and

traceability. The manufacture component incorporated a Bill of Material with on-the-fly raw material substitution

and a product rework for sub product generation, while maintaining full product traceability. The inventory

management controlled a serialized item, barcoded inventory. The Traceability component provided forward and

backward traceability, enabling any field product (by Lot #) to be traced backward to its raw material (Lot #)

items, then forward traced by raw material (Lot #) to identify raw material in stock, related product in stock and

customers who purchased related product. This project proves my capabilities in designing and programming

complex, multi-tier manufacturing applications.

My previous experience in IT Infrastructure Support was almost exclusively in the manufacturing sector,

providing additional knowledge & experience applicable to your requirements. While I am not proficient in

SSAS and SSIS technology, a good programmer always needs challenge, and coupled with my experience I

sincerely feel I have much to offer in lieu.

If your organization is interested in a local Burlington employee willing to engage for the long term and always

eager to learn, then I would be very interested in meeting with you to discuss further details of this position.

Thank you for taking the time to review my resume and I look forward to our next communication.

Sincerely,

Larry C. Duncan

*********@*****.***

LARRY C. DUNCAN

90-3333 New St, Burlington, Ontario L7N 1N1

289-***-**** • *********@*****.***

Senior

Senior .Net/SQL PROGRAMMER

Seasoned professional with over 6 years experience in designing and programming software applications for the

Financial, Insurance, Transportation, and Manufacturing industries. This is complimented with 10 years experience in IT

Infrastructure Support providing design and implementation of multi-server, multi-site Enterprise Information Systems.

AREAS OF EXPERTISE:

• •

Software Design & Programming Database Design & Administration

• •

Multi-Tier Application support Virtual Platform Implementation

• •

Excellent Reverse Engineering skills Paperless Technology

• •

Project Management New Technology Research & Evaluation

TECHNICAL PROFICIENCES

Technology: C#, VB.Net, ASP.Net, JavaScript, OO programming, Visual Basic, VB Script, VBA,

HTML, XML, CSS, Classic ASP, Visual Studio 2010/6, Source Safe, IIS,

SQL (stored procedures, triggers, functions, views), T-SQL, SQL Database Design,

SSRS, Crystal Reports XI, Visio 10, SharePoint, Bartender, Act, EDI,

Active Directory, Exchange, Paperless processing, SaaS

Databases: MS SQL 2012/2008/2005/2000, MySQL, PostgreSQL, MS Access 2010/2007/2003

Platforms: VMWare 4.1/3.5, Windows 2012/2008/2005/2000/NT/7/XP, Linux RH/SUSI, Novell 4/3/2, DOS

Learning:

EDUCATION AND CERTIFICATIONS

• •

MCSE Equivalency Experience 3 Years College (Electronics)

• Novell Network Engineer

PROFESSIONAL EXPERIENCE

ROFESSIONAL

Programmer – Children’s Education Funds, Burlington, ON Jan 2012 – Sep 2013

Programming & support for Financial Industry three-tier application

Key Functions:

- company size: $970 million in assets, $84 million in sales, branches Canada wide(per public website)

- web based dynamic data access for external subscribers, field agents and internal users

- data exchange with banks & Credit Card Co's (PAP), federal & provincial government grant agencies, Air Miles

- highly complex system with many interactive layers of specialized RESP industry functionality

Re-write of financial data migration process for stale dated funds

Enhancement of government grant process for new Saskatchewan & BC processes

Project Lead and programmer for paperless initiative

Environment: C#, VB, ASP.Net, classic ASP, OOP, JavaScript, VB Script, HTML, XML, Visual Studio 2010, IIS,

MS SQL 2008 R2/2000, T-SQL, extensive use of Stored Procedures & COM objects, SQL Triggers, Functions, &

Views, Crystal Reports XI, Visio 10, Microdea Synergize Enterprise paperless system, Kofax VRS scan software,

Windows 2008/2000/7/XP, VMWare 4.1

Programmer – City of Hamilton (DARTS) Hamilton, ON Sep 2011 – Jan 2012

Design, programming, & implementation of two-tier specialty transit application

Key Functions:

- equipment route scheduling management by vehicle class & period

- personnel scheduling management by driver license class & period

- generation & management of new scheduling period prior to implementation

- historical archiving of scheduling data by period

Environment: VBA, MS Access 2010/2007, Windows 2008, Windows7

Continued…..

LARRY C. DUNCAN

Page 2

Programmer – Thornloe Cheese, Guelph, ON May 2008 – Jun 2011

Design & programming of specialty manufacturing three-tier application for the Cheese Industry

Key Functions:

- “unique to cheese industry” sold by unit quantity but priced by accumulated weight invoicing process

- “unique to cheese industry” bill of material with on-the-fly raw material substitution

- unique weight with serialized barcode per unit finished product Inventory Management

- bulk material (silo) & raw material Inventory Management.

- product rework with automated inventory adjustment & product re-labeling

- lot number based forward & reverse traceability from raw material to customer sale

- raw material & finished product purchasing, invoicing, costing & quality control

Software design & development utilized a modular approach with module prototype development, proofing &

acceptance in MS Access followed by module migration to Visual Basic & MS SQL for production version.

Programming of Motorola Wireless Barcode Scanners for all Inventory Management functions.

Programming of Toledo Weigh Scales for incorporation of production line product weight into Manufactured

Product Inventory system.

Programming of DataMax Industrial Label Printers for Manufactured Product labeling incorporating serialized

inventory management Barcode, UPC Barcode, Lot No. Nutrition info, Ingredients, unit weight & pricing.

Programming of data integration between Toledo Weigh Scales & DataMax Industrial Label Printers

Implementation of Virtual platform, Windows servers, MS SQL, Terminal Services, Wireless LAN, Wireless Barcode

Scanners, Barcode Printers, & Weigh Scales for above application

Environment: Visual Basic, MS SQL 2005, VBA, MS Access 2007, BarTender Enterprise Label software,

Windows 2003, Windows XP/7, Terminal Services, VMWare 3.5, Toledo Scales, Motorola Barcode Scanners,

DataMax Industrial Label Printers

Gencor Foods, Kitchener, ON Jun 2005 – May 2008

Implementation of Virtual platform & consolidation of multiple Windows servers onto platform achieving performance

& reliability improvements while substantially reducing hardware & operational costs.

Implementation of 64bit SQL server including migration of manufacturing software providing dramatic performance

improvement in time sensitive production reporting.

Participated as project team member for migration of in-house developed Procurement software from Microsoft

Access to MS SQL/Web platform achieving improved process control, better reliability & significantly greater

performance.

IT Management & support of multi-site, multi-server IT systems, ERP, Manufacturing software, SQL servers,

Terminal servers & plant floor data collection systems, Exchange email, centralized ant-spam & ant-virus,

centralized backup.

Grand River Poultry, Cambridge, ON Jun 2005 – May 2008

Planned, built & implemented IT System upgrade to multi-server system without productivity disruption to

accommodate company growth.

Designed & implemented Active Directory structure achieving superior security for departmental data while

simplifying security management.

Management, operation & support of EDI system servicing multiple international grocery distribution partners. This

system utilized multiple VAN services as well as AS2 services for EDI processing. Achieved rapid problem

resolution capability ensuring efficient order processing & high product distribution partner satisfaction.

Participated as project team member for migration of Manufacturing software from Unix to Windows/SQL platform

achieving minimal disruption to production.

Participated as project team member for implementation & testing of new Time & Attendance software and Time

Clocks. Designated as primary system management resource & responsible for training department management

staff.

IT Management & support of multi-site, multi-server IT systems, Terminal servers, SQL servers, ERP, EDI,

Manufacturing software, Payroll, Time & Attendance, Time clocks, & plant floor data collection systems,

Exchange email, centralized ant-spam & ant-virus, centralized backup.

REFERENCES

Available upon request

Contact this candidate