William I Lemieux
Methuen Massachusetts 01844
********@***.***
Software Engineer / Programmer Analyst / Information System Consultant
SUMMARY OF QUALIFICATIONS
1. Vast knowledge of software design and development.
2. Experience in Custom Programming, database design, evaluating new and
existing software,
creating reports, and system utilities.
3. Comfortable in either technical or business environments with a proven
ability in software
development, software integration as well as project management.
4. Ability to meet deadlines and coordinating multiple tasks.
5. Demonstrated strong interpersonal skills with the ability to work
effectively alone or within a team
environment, can report directly to upper management and have
leadership skills in
motivating others.
6. Extensive experience developing software within Manufacturing, Retail
Sales, and Office
Automation.
TECHNICAL SKILLS AND CERTIFICATIONS
7. Languages: Visual Basic, SQL, P/L SQL, Cobol, Dibol, Vax Basic, DCL,
JCL (mainframe) .
8. Databases: MS SQL Server, SQL Express, Oracle 9i, MS Access, RMS,
SyBase.
9. Operating Systems: Windows 98/2000/ME/NT/XP, Vista, VAX/VMS.
10. Tools: ODBC, CONNX, TOAD, MS OFFICE, Visual Source Safe, ROBO Help,
InstallShield, Phonetree 3500, MAXCIM.
11. Reporting tools: Crystal Reports.
PROFESSIONAL EXPERIENCE
11/2009- Present W.I.L. Associates IT Consultant /Tech Support (self
employed)
Clients: Jan 2010- Present Armstrong Machine Beverly Massachusetts
Jan 2010 TowerHill Towing Lawrence Massachusetts
12. Computer tasks Consists of: Computer Support and Technical
Resource.
13. Custom Programming Visual Basic NET.
14. PC maintenance and new PC software setups.
15. Data File conversions and reformatting, data merging. New database
creation and file organization. Database changes, edit /new data
input screens.
16. Creation of Custom reports. Static Web site building and
implementation.
11/2006 - 11/2009 (laid off due to the company's business declining by
40%)
HB Software Solutions N. Andover MA Tech Support /
Senior Software Engineer
17. Software development, programming and database support for
distributed Commercial Transportation Software System.
18. Programs written using Visual Basic and Oracle Forms MS SQL SERVER,
PL/SQL, T SQL, ORACLE, Stored Procedures, Functions, Packages and
Toad.
19. Provide Ad Hoc SQL Data Extracts and Reports.
20. Manage SQA of HBSS Software System, Version release, Tracking,
Packaging.
21. Provide Level 2 and Level 3 client user support.
22. Management and Support of an Issue Tracking System for tracking
bugs and enhancements.
23. Supervise and mentor junior programmers and support technicians.
05/2006 - 11/2006 SunGard Securities Finance Salem NH Programmer
/Analyst
24. Primary responsibility is software programming and database support
for SunGard's Financial Software Systems.
25. Programs written in Cobol and Visual Basic using MS SQL Server.
26. NT batch scripting for the job streams.
27. Production batch processing using Argent and the UC4 job scheduler.
28. SQA Test and Release of Sungard Software to Clients Computers.
1/1999 - 11/2005(Company Closed) Petra Fashions Inc., Peabody MA Senior
Programmer/Analyst
29. Developed, maintained, and supported Client Server Business
applications written in Visual Basic 6 using SQL Server, MS Access,
CONNX database drivers, ODBC, and ADO.
30. Designed and developed an order entry system written in Visual Basic
6. This system was used nationally and distributed to a 3000 plus
sales force. Orders were validated and uploaded to Home office via
the Internet. This reduced data entry staff by 75%, thus 98% of all
orders arrived through this system.
31. Redesigned programs and increased data input validation reducing the
average time to ship orders by 3 days.
32. Designed and developed VB applications to support Customer Service
and Order Fulfillment, this increased productivity and reduced the
length of time personnel spent on phone calls and inquiries thus
reducing staff in those departments by 50%.
33. Design and develop a VB interface that allowed inventory control and
manufacturing to manage raw material and finished goods, at multiple
locations. Merging data from a 3rd party software system with VMS
legacy RMS files and SQL server databases. This reduced manual steps
and increased inventory turnover.
34. Develop VB applications and Crystal Reports that utilized the VMS
Legacy RMS data structures.
35. Used Installshield to distribute VB applications on many platforms
and have experience implementing applications on W95, W98, ME, XP,
NT and Windows 2000.
36. Responsible for creating, debugging and testing new releases of
programs, bridging and migrating the VMS legacy system to the
desktop, office automation, and programming support on the Alpha
Open VMS legacy system.
37. Co-support for hardware and software for day to day operations of
the data center. The data center consists of a Full T1 voice + data,
a Phonetree 3500 system, 8 servers, (hosting our own web site), 1
Alpha Open VMS (legacy), 3 test machines (w98, OS 2000, OS2003).
38. Provide technical phone support of varied complexity for 3600 active
external consultants.
39. Help Desk responsibilities for network issues, hardware and software
user support of 60 PC's running W98, W2000, WXP, 10 high speed
printers, scan guns, and bar code printers.
4/1995-12/1998 TAD Technical Services Corporation Contract
Programmer/Analyst and Consultant
40. Create and maintain manufacturing programs coded in Visual Basic,
MS Access,
Vax Basic, MAXCIM system, Cobol, IBI Focus, and SQL.
41. User Support and programmer for shop floor quality reporting
system.
42. Writing and supporting programs for statistical evaluations for
use within the manufacturing build process.
10/1994-4/1995 Holland Mark Martin Senior programmer/analyst and
consultant
43. Consultant to junior programmers and project leaders.
44. Main responsibility was for maintaining marketing database's
additions, deletions, and updates along with the creation of
selection subsets for purposes of direct marketing. This was a
SYBASE database and was maintained using interactive SQL and SQR
procedures.
9/1994-10/1994 Key Polymer Corporation Contract Programmer / Consultant
45. Duties were that of programmer/analyst and as consultant. They
had a problem with some custom code and I was contracted to
debug, fix and re-write a huge portion of that BASIC code. This
was on a DG-UNIX system running a third party package "CPS" by
Datalogix.
12/1980-8/1994 Digital Equipment Corporation
Information Systems Consultant and Principle Software Engineer.
46. Analyze requirements for proposed system specs and enhancements.
Design and develop functional specs, project plans, schedules,
write programs and procedures.
47. Design and develop on the PC platform a prototype of a
Requirement Planning System.
This working prototype became the distributed system that will
be used in USA and Europe as the planning system. This was
programmed in MS ACCESS using an ACCESS database and an RDB
database utilizing ODBC and SQL services.
48. Integrated a 3rd party software forecasting tool with this PC
prototype. It consisted of taking feeds from the ACCESS
database as input to "Forecast Pro" and back
into the ACCESS system with updated plans.
49. Design and develop a data capture system for the tracking of
hazardous material used in Digital products and the
Vendors who supplied the material. This system was
programmed in VISUAL BASIC using an ACCESS Database.
50. Design and develop a tracking system for the removal of Digital
equipment by employees. This system was programmed in VISUAL
BASIC using an ACCESS Database.
51. Consult to World Wide Demand Supply Organization on Office
Automation. This work consisted of evaluating current and
future computer requirements, recommending desktop PC
configuration and also what solutions software to purchase, or
code.
52. Technical Project Leader and developer of a Requirements Planning
System. I was responsible for planning much of the technical
design and the development of the system. Within this work I
defined and documented the deliverables for the project and
completed the System Construction phase for the first release. I
also was responsible for writing the code to the screen interface
for this project which included well over 300 objects. Developed
using RALLY (4GL), BASIC,SQLMOD, COBOL, IMBEDDED SQL.
53. Develop of a data capture system for World Wide Demand Supply
Finance group. As Project Consultant I was responsible for
delivery and implementation of the system. I Provided technical
consulting and was a key developer of the Database design and the
system code. This system was developed using RALLY, COBOL, C and
RDB.
54. Consult/Develop/Support of 8QTR Volume Planning system. As part
of project team wrote design specs, and coded programs for the
data capture and reporting modules using RALLY, FOCUS, COBOL,
BASIC and RDB.
55. Developer of Supplier Profile data capture and evaluation system
for World Wide Purchasing. Wrote design specs, coded and
documentation.
56. Software support for Manufacturing Engineering New Product Start-
up. Duties included writing programs and soft tools for the
management and use of new product design data.
57. Software installation and support of an MRP II System (MAXCIM)
with the integration of a Factory Data Collection System in stage
1 and stage 2 manufacturing facilities. System was coded
utilizing BASIC, COBOL and RMS.
58. Design and develop software to support the Manufacturing
Engineering personnel. Coded programs to manage the tracking of
personnel's training and education classes.
59. Design/Spec/Develop programs to support Corporate Purchasing,
Material Acquisitions and Factory Data Collection system. System
included process routing and serial tracking with Bar code
readers on the shop floor. Developed Automated Verification Test
software. Provided soft tools and program support for the capture
and reporting of test.