SUMMARY:

• Over 16 years experience. A genuine love for technology and solution building.
• Have been working with Visual Basic 6.0 for 10 years. Have been working with Classic ASP and IIS for over 9 years.
• Have been developing both Internet and Desktop solutions for clients since 2001.
• Ability to understand and assimilate complex concepts quickly, including technical and non - technical, business-related concepts.
• Creative ability to formulate solutions for business problems with available technologies.
• Strong desire and ability to learn new concepts and technologies.
• Excellent communication skills both technical and non-technical.
• Excellent organization skills, ability to work independently or as team member.

SOFTWARE:

Visual Basic 6.0, Classic ASP, SQL Server 2000/2005, T-SQL, Query Analyzer, ADO, VBScript, HTML, Javascript, Wise Installation Studio, ASP.NET, COM, COM+, MTS, IIS 4.0, 5.0 + 6.0, RDO, MS-Access, DAO, Visual Sourcesafe, SQL Server 7.0, ODBC, Oracle 11, SQL, PL/SQL, SQL Navigator, Erwin 4.0, Sybase Sys 10/11, SQL Advantage, Desktop DBA, MS-Excel Macros, MS-Word Basic, VBA, Windows 95, Windows 3.1, Cobol, XGEN (4GL), DMSII, WFL, DASDL, CANDE.

EXPERIENCE:

Confidential, Hoboken, NJ

Responsibilities:

• Member of development team on Taxstream Enterprise Version.
• Developing application to test recently created Class Modules and Stored Procedures.
• Application written in VB6, stored procedures written in PLSQL (Oracle). Short-term contract.

Confidential

Responsibilities:

• A desktop software application for Customer Management, Dispatching, Estimating, Job Costing, Invoicing, Reporting and Performance Tracking.
• Built using Visual Basic 6.0 with an MS Access back-end database, using ADO(Connection, Command, Recordset objects) for all calls to Database stored procedures.
• Using both, dynamic SQL statements and pre-built queries in the Access Database.
• Integrated the application with QuickBooks using Intuits QuickBooks API (QBFC7).
• Designed and built the reporting engine which can produce text-based view, an Excel export or an HTML view of the data.
• Users are able send text messages from the application.
• See the link above for an online demonstration.
• Built installation package in MSI format using Wise Install Editor from Altiris.
• Wrote all user manuals and training documentation.
• Have used Webex Support Center to provide online, real-time training and support.
• Program is currently being sold throughout the United States.

Confidential, Hartford, CT

Responsibilities:

• Designed and built a VB6 application for the gathering of data from multiple sources in multiple formats for the purpose of consolidation into an MS Access Database.
• The database is then used in the monthly invoicing process for Copy, Print, Fax, UPS Charges and Postage.
• This application literally saves the user days of processing every time it is used.
• Written in Visual Basic 6.0 using VBA to interface with MS Excel objects, File System Object, ADO.
• Wrote user manual in MS Word.

Confidential

Responsibilities:

• Designed and built the “ Compendium Management System” (CMS) used by various personnel employed by the Connecticut Confidential .
• Web-based application used for the management of course-description documents and lesson plans for classes available to the population housed in the various correctional facilities throughout the State of Connecticut.
• Responsible for designing the database structure and creating all web pages, software and database objects necessary.
• All documents are visible online and downloadable as MS Word documents. Word documents are updated by users and then uploaded to the site.
• After upload, the document is parsed and all information is added to the database for later searching.
• Application provides the following functionality: User Maintenance, Category Management, Program Maintenance, Searching capabilities, Various Reports.

Technologies: DLLs written using Visual Basic 6.0, Word Basic, SQL Server 2000 database, Transact-SQL, Active Server Pages, VB Script, Javascript, HTML.

Confidential

Responsibilities:

• A Web-based application used for the management of all recipes and recipe images provided to cookbook publishers and displayed on the public websites.
• Users are able to create new recipe entries, update recipe entries, upload photos, associate recipes to photos, download recipes in Word Document format and search for recipes by multiple categories and/or key words. Search for images by multiple categories and /or key words. Multiple user levels with various access privileges.
• Admin login can control all aspects of the application.
• Responsible for designing the database structure and creating all web pages, software, technical documentation, user documentation and database objects necessary.
• Designed and wrote DLL to create XML file(s) containing recipe information that was then FTPed to the Commercial(Public) recipe websites.

Technologies: DLLs written using Visual Basic 6.0, Word Basic, SQL Server 2000 database, Transact-SQL, Active Server Pages, VB Script, Javascript, HTML.

Confidential

Consultant, Lead Developer

Responsibilities:

• WINDOWS DNA, VB 6.0, COM+, VBSCRIPT, JAVASCRIPT, HTML, ASP, ASP.NET, OLE DB, ADO, SQL SERVER 7.0/2000, MS-ACCESS, T-SQL
• Was Responsible for Data Modeling of existing system in order to add new scalability and new functionality. Used ERWIN for all data models.
• Was Responsible for the creation, and modification of multiple dynamic web pages using ASP technology with Windows DNA.
• Sites include an Online Catalog where the participants are able to search for a desired product or drilldown through a list of categories. Shopping cart, checkout and printing of order confirmation are included. Pages contain VBSCRIPT, JAVASCRIPT and Native HTML. Pages use creation and calling of COM objects located on the Web Server for database queries and updates.
• Responsible for creation of Desktop Applications used to administer the back-end information for web-based sales-incentive programs. The application uses multiple MDI forms as well as modal popup forms. Used third party components from Sheridan and APEX. Data is retrieved from the SQL Server 2000 database through the Internet using RDS to link to the off-site database server. Application uses ADO objects for data retrieval and manipulation. In an early version, the connection string was stored in the registry of the server and retrieved via an Active X DLL.
• Responsible for creation of Active X DLLs in support of the web sites and the Desktop tool.
• Responsible for creation of Active X EXEs using MSXML to keep order status up to date via XML status files supplied via FTP by outside vendors.
• All DLLs and EXEs were written using VB 6.0.
• Responsible for creation of, and modifications to, multiple stored procedures written in Transact-SQL.
• Responsible for creation of data models in order to best achieve the desired functionality of the applications.
• Responsible for creation of all back-end reports using MS-ACCESS.
• Responsible for creation of all back-end reports using CORDA Technologies - PopChart.
• Primary client contact for gathering of specifications for modifications to existing projects as well as the design and specification creation for new projects on a continuing basis.
• Responsible for directing the work of the other programmers on the project.

Confidential

Systems Analyst

Responsibilities:

• Responsible for developing all phases of Microsoft-centric Internet applications.
• Data modeling for new functionality using ERWIN 4.0. Writing of all PL/SQL code to create new Oracle tables, modifications to existing Triggers and new stored procedures (Packages).
• Coding of Front-end web pages using VISUAL INTERDEV for Active Server Pages, VBSCRIPT files, HTML editing, HTA files (hypertext applications).
• Coding of back-end DLLs needed to handle editing of data entered on the Web Pages.
• Written using VISUAL BASIC 6.0.
• Coding of back-end DLLs needed in the Data tier to process queries and updates to the database.
• Writing of test plans and interaction with Quality Assurance personnel as the project moves through that department.
• Writing of both technical documentation and user documentation. Provide user training for project rollout.
• Responsible for producing new data model and specifications for changes to an MS Access based application.
• Redesigned to allow scalability and preservation of historical data.
• Produced data model using ERWIN 4.0. Modified queries, forms, reports and modules to accommodate new table structure.
• Wrote Modules to automate data feeds from Oracle database.

Confidential

Consultant, Lead Developer

Responsibilities:

• Responsible for designing, coding, testing, debugging and documenting multiple Windows-based applications using Visual Basic 6.0 with data retrieved from either MS-Access 97, Btrieve using Pervasive's ODBC interface or from an AS/400 database using a Client Access ODBC interface. Data access was done using ADO, RDO and DAO.
• Many applications access one, two or all of the data sources mentioned above, both simultaneously and individually. Some applications used Microsoft Excel to produce spreadsheets for reporting purposes.

LABEL GENERATOR

Confidential

Responsibilities:

• Uses ADO to access the Btreive information and DAO to access the MS-Access database.
• The Access database is local to the PC running the application, while the Btrieve data is remote.
• The user enters the data for a particular label through a GUI front end that resembles the finished label.
• The data is then verified against the remote database and the user is asked to add an item if it was not found in the database.
• The data was then added to the appropriate database tables.
• A template file containing printer codes is opened, the appropriate substitutions are made and the file is sent to a remote label printer.

Confidential

Responsibilities:

• Uses API calls to populate a listbox on a form for the user to choose the desired Data Source Name.
• Connects to the chosen data source, opens another form with a listbox populated with all the available tables in the chosen database.
• Once a table has been chosen, two flexgrids are populated, one with field information including name, type and size, the other is populated with all index information for the chosen table.
• A “create table” statement is then generated and placed in a text box Confidential the bottom of the form.
• All information is derived from the system tables in the chosen database using ADO.

Confidential

Consultant, Lead Developer

Responsibilities:

• Application opens a configuration file containing a list of databases and their respective DSNs.
• The program displays a form containing the appropriate number of check boxes and labels to display the databases listed in that file.
• The form is dynamically sized to fit the amount of database names that are to be displayed.
• The user may choose one or more of the data sources listed.
• Once the choice(s) is (are) made, the program makes the connection(s) to the databases and the main form is displayed.
• The user then enters an inventory item number in a text box and can either press the enter key or click the appropriate command button.
• The program goes through the chosen databases and retrieves inventory information for the item entered.
• Both detail and summary information is displayed in two flexgrids.
• If the size of the form is changed, the grids are resized as well.

Confidential

Responsibilities:

• User enters start and end dates via text boxes and chooses detail and/or summary via check boxes. Report uses ADO to gather data. Report(s) are generated in MS Excel.
• The user chooses from 1 to 5 reports via check boxes. The reports range in level of detail from simple item/total quantity to a full data dump.
• Once the user has chosen their desired reports and clicked on the “Go” command button, the program checks the form for the checked reports, opens an Excel Workbook, runs the appropriate queries against the database using RDO, populates the Worksheet(s) within the Workbook and brings up the Common Dialog to allow the user to save the new Workbook where ever they would like.
• Batch program with a GUI for starting and monitoring progress.
• Program uses data obtained from a file containing recent physical inventory of entire warehouse to load new master inventory table. Throughout process edits are done on scanned locations as well as item numbers.
• Newly created locations and item numbers are added to their respective tables and written to a log file when necessary.
• Quantity information is checked against the Barcode tables for accuracy.
• Updates are done to both a LAN-based Btrieve database and an AS/400 based database.
• Break logic is applied during processing for proper summing up of quantity information while still allowing individual processing of barcodes, which are unique to each container.
• Used class collections instead of arrays in order to speed processing and assure that an individual location or item number would only be edited once during the process.
• All data access is accomplished using RDO.
• Also, during this assignment completely re-wrote the RF system used in the domestic warehouses to control the production process and gather the inventory information.
• The tool used is a VB-based development tool known as RF Assistant.
• It is used to generate the screens that are sent to he RF scanners and process the information returned by them during daily operations.
• It uses RDO to attach to the data sources, which were the same ones used by the VB programs outlined above. The language used is VB with some added built-in functions.
• Wrote many stored procedures in order to do the back-end processing required by the RF system.

Confidential

Project Leader/Technical Consultant

Responsibilities:

• Responsible for designing, coding, testing, debugging and running of Visual Basic 5.0 programs used to update database tables from flat files, update database tables from a database on one server to a database on another server, and create flat files from a Sybase database for export to the mainframe.
• All programs are created with a GU Interface to either choose the file to be updated, choose the type of export to be done, monitor the progress of the operation being performed, or combinations of these processes.
• All programs write to a log file for a history of the job execution.
• Programs also write to tables in a remote Access database used by the Mainframe group to keep statistics on the files being FTP'ed to the Mainframe IP address.
• Use of MS Access database as a data repository, as a tool for updating the flat files and as a tool for manual updates to a Sybase database using attached tables.
• Wrote a VB program that generated an HTML file from various recordsets in order to display the information on the MERCK Intranet.

Confidential

Senior Developer

Responsibilities:

• Responsible for maintenance, modifications, enhancements, documentation, data cleanup and user support for an application using MS-ACCESS 2.0 as the front end and SYBASE SYSTEM 10 as the back end database.
• Modifications to ACCESS forms within the front end as well as modifications to the ACCESS BASIC code to accommodate the new functionality of those forms. Modifications to stored procedures in SYBASE to accommodate new functionality.
• Modifications to ACCESS BASIC code for optimization.
• Writing of stored procedures for data cleanup.
• Writing of test plans in Lotus Notes for use by the QA department for testing of all modifications and enhancements.
• Wrote the entire process for consolidation of proprietary codes tables caused by a change in business rules for the firm. The process included sixteen stored procedures using multiple cursors and temporary tables.
• All stored procedures written in TRANSACT-SQL using DESKTOP DBA as the interface to SYBASE.

Confidential

VISUAL BASIC, MS-ACCESS Developer

Responsibilities:

• Understanding of all aspects of the application in order to act as backup person to the application's architect and project manager. Aspects include; all VISUAL BASIC 4.0 code, all ACCESS 95 SQL (both embedded queries and database resident queries), proficiency with Windows NT (both server and workstation), complete understanding of Website technology and CGI technology as they related to the application. Understanding of all production support activities. Design and development of application enhancements as required by the project manager. Design and development of independent applications to be used as production support tools, including the integration of EXCEL with ACCESS 95 using VISUAL BASIC 4.0. Design and development of back end reports as required by the project manager.
• Previously the application was LAN-based and used ACCESS 2.0 and ACCESS BASIC
• Development, execution, and e-mailing of all back end reports.
• Development and execution of all database updates related to production support and monthly reporting. Development and maintenance of 'user' databases linked to the production database tables including queries and forms (screens) for access-literate users to do their own investigation of available data. Development of algorithms to interpret available data in different ways as required by management. Automation of reports and updates using forms and macros in MS ACCESS.
• During transition from LAN-based (13 individual LAN's along the East Coast) to internet-based (centralized) responsibilities included:
• Development of Multi-use form (screen) for the moving of employees and their related data from each individual LAN to the central database. Used Network addressing to access the remote LANs.
• Used Access Basic features to link to the appropriate tables in the remote databases.
• Developed functions using embedded SQL and DAO to ensure no redundant data would be loaded to the central database. Form also had the ability to query the central database and do deletes from individual and multiple tables.