|
Transcentive-Web Application Developer
|
2000 Q4 thru 2001 Q1
|
|
|
Developed a proof of concept for an architecture for a new web-based version of the companies software product. Application ran as a series of Visual Basic objects running under IIS/ASP and support MS IE 4+ and Netscape 4+ as well as SQLServer, Oracle, SQLAnywhere, and Access.
|
|
|
|
Tools: Application-Excel, Application-PowerPoint, Application-Word, Client/Server-MS VB 6.0, Client/Server-MS Visual Basic, Database-MS Access, Database-MS SQL Server, Database-Oracle, Database-Sybase SQL Anywhere, Internet-Active Server Pages, Internet-HTML, Internet-JavaScript, Internet-VBScript, Internet-XML
|
|
|
|
http://www.WordGamez.com
|
2000 Q4 thru 2001 Q1
|
|
|
Designed and Developed the application that builds the entire website. The code for the site looks and functions very similar to an ASP Site except that the pages are all built up front during a batch build process. The database is SQL Server but backwards support for Access is included and the site supports Netscape 4+ and Explorer 4+. Also, constructed an AvantGo channel which required reworking portions of the existing content to meet the constraint of a very limiting platform using it's custom subset of HTML and JavaScript. AvantGo (http://wwwAvantGo.com) is a tool which allows web based content to be viewed on handheld devices.
|
|
|
|
Tools: Client/Server-MS VB 6.0, Client/Server-MS Visual Basic, Database-ADO, Database-MS Access, Database-MS Access 97, Database-MS SQL Server, Internet-AvantGo, Internet-HTML, Internet-Java, Internet-JavaScript
|
|
|
|
http://www.LetsLearnHTML.com
|
2000 Q4 thru 2001 Q1
|
|
|
Authored the entire website. It is currenty going through continual refinement and is targetted for completion before the Q2 of 2001. The website is published off an Access (or MS SQL Server) database by a Visual Basic Program. This approach has allowed for very simple extending of content without needing to muck with the vagueries of editing HTML. But since it is not ASP based it has none of the overhead (or cost) of needing NT/IIS hosting.
|
|
|
|
Tools: Client/Server-MS VB 6.0, Database-MS Access 97, Internet-HTML, Internet-JavaScript
|
|
|
|
CMS-Web Application Developer
|
1999 Q4 thru 2000 Q4
|
|
|
Rewrote a simple 20 page, seat of the pants inquiry ASP program into a 150+ page ASP application. Created libraries for common functions, standard format for HTML, JavaScript, and ASP, database interaction layer, and detailed security. Also created links to external systems utilizing XML and WinSock and two visually interesting portions of the system, a graphical organization chart in real time and an event calendar. The system also included features like a time-sensative password protected backdoor for phone support to use and all the little niceities like when you timeout you must relogin, but then are returned to the requested page.
|
|
|
|
Tools: Application-ERWin, Application-PowerPoint, Database-MS Access, Database-MS SQL Server, Database-Oracle, Database-Sybase SQL Anywhere, Internet-Active Server Pages, Internet-HTML, Internet-JavaScript, Internet-SMTP, Internet-VBScript, Internet-WinSock, Internet-XML
|
|
|
|
Yankelovich-Survey Statistics
|
1999 Q3
|
|
|
Developed a system to parse data from international survery results and present it using dynamic report generation. Required quite elaborate string parsing and checks to make sure data wasn't misinterpreted.
|
|
|
|
Tools: Client/Server-MS VB 6.0, Client/Server-MS Visual Basic, Database-MS Access 97, Database-MS SQL Server, Internet-Active Server Pages
|
|
|
|
CMS-Data Conversion Specialist
|
1999 Q2 thru 1999 Q4
|
|
|
Developed a dynamic process to migrate customer data from a competitors database structure to the database used by the client's comparable product. All developed one-off processes for migrating from other existing data formats into the client's product. Required working with the software developers and the end users to ensure the data delivered was accurarate and complete. Responsibilities also included training team members on Visual Basic and SQL.
|
|
|
|
Tools: Client/Server-MFC, Client/Server-MS VB 4.0, Client/Server-MS VB 6.0, Client/Server-MS Visual Basic, Client/Server-MS Visual C++, Database-ADO, Database-Clipper, Database-dBase, Database-FoxPro, Database-MS Access 1.0, Database-MS Access 97
|
|
|
|
Order History Database
|
1999 Q1
|
|
|
Developed an order database to allow comparing prior quotes to help in developing future quotes. (migration from VB3)
|
|
|
|
Tools: Database-MS Access 97, Language-MS Access 97
|
|
|
|
HCIA-ProView
|
1998 Q3 thru 1999 Q1
|
|
|
Worked as part of a team developing a Browser based release of the company’s main product, ‘Starting Line’ (being released under the name 'PROView'). Developed Client-Side HTML, Java, and VB OCXs as well as Server Side VB DLLs, Active Server Pages, and Stored Procedures. Responsible for the design of the Server-Side Error handling, Database Access, Security, overall ASP and Server approach. Developed Java prototypes of screens and architecture for future migration of screens for future migration of system.
|
|
|
|
Tools: Client/Server-MS VB 5.0, Database-ADO, Database-MS SQL Server, Database-Oracle, Database-Sybase SQL Anywhere, Internet-Active Server Pages, Internet-HTML, Internet-JavaScript, Internet-VBScript, Internet-WinSock
|
|
|
|
MLN-Online Loan Origination Forms
|
1998 Q3
|
|
|
Developed the prototype of a Dynamic HTML based Internal Load Survey consisting of 100s of questions that interacted with each other. The survey was generated off of database tables that managed the hierarchy and interaction of the questions. Also setup a number of quick-n-dirty ASPs pages and Database Import / Management tools in VB.
|
|
|
|
Tools: Database-MS Access, Database-MS Access 97, Database-MS SQL Server, Internet-HTML, Internet-JavaScript
|
|
|
|
AIM-MCAD System
|
1998 Q1 thru 1999 Q4
|
|
|
Architected a Marketing Program Management "Package" that is being customized and installed at multiple clients. Responsibilities included: developing the overall application infrastructure, providing object-based security, automated refresh of expired data between windows (and users), and currently implementing many of the core system components. The client-specific components of the system are either table driven or have "Designer" screens that allow for interactive customization. Developed and implemented Unit and System test scripts.
Also developed the prototype for Web migration of the application. Using Client-Side HTML and JavaScript and Server-Side ASP and MTS.
|
|
|
|
Tools: Application-Excel, Client/Server-MS VB 5.0, Client/Server-MS VB 6.0, Client/Server-MS Visual Basic, Database-ADO, Database-MS Access, Database-MS Access 95, Database-MS SQL Server, Database-Oracle, Database-RDO, Database-Sybase SQL Anywhere, Operating System-Windows 95 / 98 / ME, Operating System-Windows NT 3.51
|
|
|
|
Customer Packaging/Mailing Database
|
1997 Q4
|
|
|
Developed a Customer Packaging/Mailing Instruction Database for use in the shipping area in Access 97.
|
|
|
|
Tools: Database-MS Access, Database-MS Access 97, Language-MS Access 97
|
|
|
|
ComCast-Lead Management System
|
1997 Q4 thru 1998 Q1
|
|
|
Phase 1: Developed a lead distribution system using E-Mail as a communication medium. The system would generate Excel Spreadsheets (w/ VBA) transmitted via E-Mail to the Sales Force. After the spreadsheets were used and updated in the field they would be forwarded back to a data collection mailbox. A Visual Basic Program was developed to update the database with the results of the spreadsheets beginning the cycle over.
Phase 2: Developed a custom Web-Based Contact Management Package including most of the baseline functions you would expect in such a system. Currently in final testing and are rolling this functionality out to the field. Responsibilities included: setting-up structured development standards, development core code libraries for ASP development, developing core code library for VBScripting, developing and testing server side scripts, setting up centralized server-side error-handling, designing and implementing numerous web pages.
|
|
|
|
Tools: Application-Excel, Client/Server-MS VB 5.0, Internet-Active Server Pages, Internet-HTML, Internet-VBScript
|
|
|
|
HCIA-Assorted Projects
|
1997 Q3
|
|
|
Provided technical expertise and programming skills to three projects. The tools were primarily VB 5.0 and SQL Server but also included: VB 3.0, VB 4.0 16-bit, and VB 4.0 32-bit), MS Access, VC++ 4.2, Borland Delphi, Nestor Recognition Software, MAPI E-Mailing, and GammaFax boards. The primary function of the system was the management of survey information, this included distribution functions, information collection functions (via a Web Page, Fax, VB Form, or Bubble Sheet and No 2 Pencil), scoring of results, and reporting.
|
|
|
|
Tools: [none]
|
|
|
|
COBOL Crash Course
|
1997 Q3 thru 1997 Q4
|
|
|
Developed a COBOL Training Curriculum for a 12-week 96-hour course in COBOL. The course consisted of an introduction to programming, COBOL Basics, COBOL in the business world, Relational Databases, and Online programming with COBOL and CICS. The focus was on real-world examples and labs with a series of twelve progressive labs that intertwined with the curriculum. Due to delays in scheduling the course I was unable to act is the instructor.
|
|
|
|
Tools: Database-DB2, Mainframe-COBOL, Mainframe-JCL/JES, Mainframe-MicroFocus COBOL, Mainframe-VSAM
|
|
|
|
Compuserve-Membership Reporting
|
1997 Q3 thru 1998 Q1
|
|
|
Developed a high-volume SQL Server Reporting System which primarily involved running comparisons between two ~8 million row tables and building summary reporting tables. Responsibilities included: tuning the performance of SQL Server and NT Server, Determining which steps were I/O bound and which were CPU bound, Optimizing the portions along the critical path. Developed and implemented unit and System test scripts and developed repeatable scripts for baseline testing and performance testing. Also developed a Web based interface for the reports.
|
|
|
|
Tools: Client/Server-MS VB 5.0, Client/Server-MS Visual Basic, Database-MS SQL Server
|
|
|
|
AIM-Lead Management System
|
1997 Q2 thru 1997 Q4
|
|
|
Sole Implementor of a custom marketing database front-end over an Access database. Key components of the system included: Ad-hoc search capabilities, powerful reporting interface, Rapid Development through the use of key design considerations and development aids (code generators and function libraries), import capabilities from ACT!, and simplified maintenance procedures. The system was structured around a greatly simplified version of the architecture implemented for 'FlightSafety International' below. Responsibilities included: developing and tuning the database, programming, testing, converting existing data, etc.
|
|
|
|
Tools: Client/Server-MS VB 5.0, Database-DAO, Database-MS Access 95, Database-RDO
|
|
|
|
|
|
Developed both a VB ActiveX Control and MFC/C++ OCX to wrap a specialized Bar Code DLL the company had purchased. The wrapper hid the technical details of conversing with the DLL from the firms' novice programmers. They were now able to manipulate the Bar Codes through Properties and Methods, which was a familiar environment for them. Also wrote a sample application that utilized the control as part of a label design tool.
|
|
|
|
Tools: Client/Server-MFC, Client/Server-MS VB 5.0, Client/Server-MS Visual C++
|
|
|
|
Academy Management System
|
1996 Q3 thru 1997 Q2
|
|
|
Planned, Designed, and Implemented an extensive reusable Visual Basic Architecture that provided standardized support for the common function and an infrastructure for navigation within the application. The following functions were implemented as zero or minimal code features: Report Request, Find, Codes Files Maintenance, Menus, Selection Forms, and mapping Grids to the database. The architecture also had many built-in features an application could choose to use: Security, Database Object Locking, Error Handling, Asynchronous Background Processing, and a Database Layer that wrapped the differences between Access, SQL Server, and ODBC. Authored very detailed Programming and Database Design standards that gave a very consistent look across the breadth of the system. Developed a series of tools that supported the development: Visual Basic Add-Ins that provide more powerful features than those built in, Source Code and Database Compare utilities, a Custom/Enhanced SQL Server Up-Size wizard, a SQL Server Down-Size wizard, a Code Generator that builds full-featured ready-to-run screens.
Designed Constructed a Relational Database (over 100 entities) based on user requirements and programmed multiple pieces of the business functionality for the system.
|
|
|
|
Tools: Client/Server-MS VB 4.0, Client/Server-MS VB 5.0, Client/Server-MS Visual Basic, Database-DAO, Database-MS Access 95, Database-MS Access 97, Database-MS SQL Server, Database-RDO, Operating System-Windows 95 / 98 / ME, Operating System-Windows NT 3.51
|
|
|
|
CIGNA-List Bill
|
1995 Q1 thru 1996 Q3
|
|
|
Lead member of a development team creating a custom Visual Basic system for entering, maintaining, and viewing Client Billing information. Responsible for developing an object based VB architecture (creation of objects and standard constructs) and implementing many of the forms and background processes. Resolved issues such as development of “Wrapper” functions for the “Screen Scraping” API, development of extensive language extensions for simplified programming, development of central error handling and program flow control, and maintaining the integrity of local data stores relative to central data stores. Created a C DLL that replaced some of the common functions within the system to improve performance. Implemented programming standards which allowed the data layer which called the mainframe to be replaces with a module which used access to allow for off-line testing and development. Trained and supported team members and other projects with Visual Basic, Microsoft Access, and Windows API expertise.
Technical Team Lead through the planning and design phases for a new billing system which would reuse much of the VB and Mainframe architecture developed in the previous project. Responsibilities included assignment of tasks and developing estimates and alternatives.
|
|
|
|
Tools: Client/Server-MS VB 3.0, Client/Server-MS Visual Basic, Database-DB2, Mainframe-CICS, Mainframe-COBOL, Mainframe-JCL/JES, Mainframe-MicroFocus COBOL, Mainframe-VSAM, Operating System-Windows 3.0 / 3.1 / 3.1.1
|
|
|
|
Name and Address Repository
|
1994 Q3 thru 1994 Q4
|
|
|
Part of the development team of a Client-Server Central Repository for consolidated Policy information. Participated in and provided technical expertise to the development of the Visual Basic components, developed several of the common mainframe modules used by the MS Visual Basic apps, and developed several COBOL / CICS online and batch programs.
|
|
|
|
Tools: Client/Server-MS VB 3.0, Mainframe-CICS, Mainframe-COBOL
|
|
|
|
Sikorsky-Standard Cost Mod
|
1994 Q2 thru 1994 Q3
|
|
|
Part of the design team for a critical retrofit to an existing Standard Cost system. Conducted technical and functional training on the existing system and participated in the detailed design of the required enhancements.
|
|
|
|
Tools: Application-ABC Flowcharter, Mainframe-COBOL, Mainframe-JCL/JES, Mainframe-VSAM
|
|
|
|
Allmerica-Test Coordinator
|
1994 Q1 thru 1994 Q2
|
|
|
Filled the role of system test coordinator. The responsibilities included coordinating the efforts of the user community to conduct the test and the testing technical support staff, and planning and tracking the testing effort.
|
|
|
|
Tools: Database-DB2, Mainframe-Assembly Language, Mainframe-COBOL
|
|
|
|
Allmerica-Document Repository
|
1994 Q1
|
|
|
Completed the design and development of a Visual Basic documentation presentation tool. The application served as a means of communicating technical and business information to members of the Systems area. It used an MS - Access database to track the available documents that were out on the LAN and the VB application to perform keyword searches, present the documents, and allow them to be printed.
|
|
|
|
Tools: Application-Word, Client/Server-MS VB 3.0, Client/Server-MS Visual Basic, Database-MS Access
|
|
|
|
AC-Personnel Planning and Tracking
|
1993 Q2
|
|
|
Sole designer and developer of a Personnel planning and tracking system. The system was written in Clipper, Genifer (a screen painting and code generation tool), and R&R Report Writer.
|
|
|
|
Tools: Database-Clipper
|
|
|
|
Sikorsky-Revaluation
|
1993 Q1 thru 1993 Q4
|
|
|
Lead designer for the final module of an integrated Standard Cost system. Beyond being lead designer, responsibilities included: project planning and tracking, writing specs, database design, and programming. The system was Flat File, DB2, IMS DB/DC, VSAM with formatted downloads and uploads to/from Lotus 1-2-3.
|
|
|
|
Tools: Application-ABC Flowcharter, Mainframe-COBOL, Mainframe-JCL/JES, Mainframe-VSAM
|
|
|
|
Sikorsky-Standard Cost
|
1992 Q1 thru 1992 Q4
|
|
|
Lead designer and module leader assistant for three modules of an integrated Standard Cost system. Responsibilities included facilitation of JAD sessions following a Yourdan decomposition methodology, development of normalized data models, writing program specs, supervising a team of eight to ten programmers, coordinating and conducting system test, and post-implementation support.
Developed COBOL Programming Tools and Project Tracking Tools in a combination of Visual Basic and Visual C++.
|
|
|
|
Tools: Application-ABC Flowcharter, Application-ERWin, Mainframe-COBOL, Mainframe-JCL/JES, Mainframe-VSAM
|
|
|
|
CIGNA-Life Insurance Illustration System
|
1991 Q1 thru 1991 Q2
|
|
|
Participated in reverse-engineering the formulas used in a QuickBASIC application that had outlived its usefulness and lacked proper (any) documentation. Responsible for technical support for the project team and technical verification of the team’s results. Developed tools in both QuickBASIC and C to support the reverse engineering.
|
|
|
|
Tools: PC-DOS-MS C 6.0, PC-DOS-MS QuickBasic 4.5
|
|
|
|
AETNA-Customer Installation Management System
|
1991 Q1 thru 1991 Q4
|
|
|
Lead Designer and Programmer for a leading edge PC-based system. It used Spinnaker PLUS (a HyperCard clone) to provide and object-oriented user interface and FoxPro for a database. Underneath the oop UI was a Rule-Based Project Schedule generating engine that was developed in C (and later migrated to C++ when C 7.0 was released). The system ran identically on both the PC and Macintosh platforms and interfaced tightly with Microsoft Project, Microsoft Excel, and Microsoft Mail. Responsible for overall functional and technical design, wrote specifications, and programmed portions of all of the modules, and managed the programmers who wrote the rest.
Participated in an extensive process review of current Health Care Network development practices and development of recommendations for improvements both from a Quality and Cost Savings standpoint.
|
|
|
|
Tools: Application-HyperCard, Application-MacDraw, Application-Word, Client/Server-MS VB 1.0, Client/Server-MS Visual Basic, Database-DB2, Database-dBase, Database-FoxPro, Language-Spinnaker PLUS, Operating System-Macintosh, Operating System-Windows 3.0 / 3.1 / 3.1.1, PC-DOS-MS C 6.0
|
|
|
|
AC-CAPS Instructor
|
1990 Q4
|
|
|
Taught new hires a 3-week crash course in MicroFocus COBOL, DB2, and CICS. Instructed a group of students from a variety of backgrounds including Germany, Switzerland, Spain, and Italy.
|
|
|
|
Tools: Mainframe-COBOL, Mainframe-MicroFocus COBOL
|
|
|
|
CDOT-Bridge Maintenance System
|
1989 Q3 thru 1990 Q4
|
|
|
Wrote specs, coded, and tested multiple new programs and several enhancements. The programs were a combination of on-line and batch and executed on a UNISYS (Sperry) Mainframe. The system was a custom system for planning., budgeting, tracking, and reporting on proposed and on-going construction projects across the state. Designed and Programmed a graphical prototype for the resource leveling algorithms in C++. After working with the users to optimize the algorithm the program with converted to a COBOL specification.
|
|
|
|
Tools: Database-DMS1100, Mainframe-COBOL, Mainframe-ECL, Mainframe-MicroFocus COBOL, PC-DOS-Borland C++
|
|
|
|
CDTA-Rider Info System
|
1988 Q3 thru 1989 Q2
|
|
|
Developed a series of QuickBASIC programs to process files downloaded from a mini-computer. Several of the processes were written in C++ or Assembly Language to eek some performance out of the PC’s and AT’s they were running on. The most interesting application was a rider information display that could be installed at major bus stops that worked similarly to the flight information boards at airports. It provided for dial-up updates to the schedule and for providing advertising space on the screen.
|
|
|
|
Tools: PC-DOS-Assembly Language, PC-DOS-Borland C++, PC-DOS-MS QuickBasic 4.5
|
|
|
|
UNH-College Tutoring
|
1983 Q3 thru 1984 Q2
|
|
|
Tutored students in Fortran, COBOL, and Assembly Language in the “Good Old Days” of punch cards and 4 hour compile waits. Also worked in the computer room monitoring jobs and providing a technical (programming) help desk
|
|
|
|
Tools: Mainframe-Assembly Language, Mainframe-COBOL, Mainframe-Fortran
|
|
|