Name: Brian Clear

E-Mail: bclear@eircom.net

Homepage: http://www.brianclear.com

Third Level: 1990-94: Waterford Regional Technical College

Degree in Applied Computing (Honours 2.2)

Programming: Visual Basic 3/4/5/6, Visual C++ 4/6,

Development: MFC, COM, ActiveX Controls, ActiveX DLLs/ Servers (EXEs) in VB, VB OLE Automation, ODBC, DAO/RDO/ADO, EDI (ANSI X.12, EDIFACT), VB Add-Ins, OOD using OMT and System Architect,

UML using Visual Modeller.

Web Development Tools: MS Frontpage 97/98, HTML, DHTML, JavaScript, VB Script, Active Server Pages, Internet Explorer, Netscape Navigator,

Databases: MS Access 2 to 7, Oracle through VB, RDO, DAO, ADO, Database Design/ Normalisation,

Other Tools: Crystal Reports, Microsoft Office, Lotus Notes, Internet Explorer 3/4/5, Citrix Windows 95 Client, Citrix Web Client for IE/NN, WRQ Reflection Terminal Emulation, MS Source Safe/ Source Integrity, BISON/FLEX (versions of yacc/lexx)

Personal Use: Macromedia Dreamweaver, Macromedia Flash, Paint Shop Pro, Caligari TrueSpace 3D software, MS HTML Help, MS Agent,

Beech Hill, Clonskeagh, Dublin, Mr. Darragh Sinnott

Main skills: Visual C++ 6, Visual Basic 6

• Visual C++ 6 /MFC: Worked on developing a migration tool which copied data from a Customer's Phone System to a Y2K Compliant version of that system. The migration tool was developed in Visual C++/MFC and accessed the Customer's System using an RPC DLL which came with the system.

• Visual Basic 6: Tested and fixed bugs in an application that talked to one of Ericsson’s Phone Systems. Again the tool accessed the phone system using the same RPC DLL.

• Sole developer of 3 frontends to Eircell’s terminal based legacy system, answerable to up to 6 managers and 60+ users.
• The first frontend consisted of a data entry web page using JavaScript and hosting ActiveX controls running on IE.
• The ActiveX controls were developed in VB5 and used OLE automation to control Eircell’s terminal based system. They used VB advanced features such as collections and classes.
• The Frontend was used by 60+ users which I also provided support for.
• The second and third Frontends were VB applications, which were used by Eircell Agents in their stores.
• It ran using Citrix Thin Client for Windows for security reasons.
• It ran lookups and updates on an Oracle DB using DAO/RDO/ADO.
• It printed reports developed in Crystal Reports, which replaced the hand written reports normally filled out by customers and agents.
• I also began the process of migrating the project to a 3-tier (GUI, Business Objects and Data Objects) application with heavy use of ActiveX DLLs and VB Classes and collections.

• Developed an EDI / sales product using Visual C++ 4, MFC, COM and Access based on a previously existing VB 3 product.
• Was part of a 6-person customisation and localisation team that spent 6 months in Colorado and then returned to Ireland to set up the European development and localisation operation.
• The product used OLE COM technology to provide easy customisations for each customer.
• We developed the C++ application using OMT (Object Modelling Technique).
• The product strictly followed Microsoft’s standard for software layout and localisation.
• I was present for the full product lifecycle from design to delivery and worked closely as part of a team with developers in the US, Ireland and India.
• I developed, along with a contractor, the Software Licensing and Enabling System which produced license diskettes for the software
• I produced individual EDI transaction DLLs for some clients (EDI Warranty Claim for Ransomes UK, Inbound Invoice, Wholegood Allocation and Product Registration for Polaris US)
• I developed a translator for EDI transaction definitions using BISON/FLEX (versions of yacc/lexx) which produces code from text descriptions of EDI transactions. It standardises and greatly reduces the development of each new transaction.

Visual Basic

• Improved current Visual Basic 3 product, delivering customisations for the Australian market.
• Developed Database Utilities in Visual Basic 5 used with main C++ product.

• Also developed a Web/ASP version of the existing Parts Lookup VB application for management to demonstrate how the product could be moved to a web environment.

• I was the sole developer of a frontend database to store and print the records of meat exported from this meat factory.
• The database was a multi-user database, with a single DB to store the data and a frontend on each users machine to maintain and print the data. Both were developed using MS Access.
• The development used all the advanced features of Access such as Access Basic, DAO, SQL and reports.
• I developed a frontend in VB3 that replaced Program Manager to handle the varying levels of user skills.
• As the only IT person I provided maintenance for other weighing systems in the factory.