SUMMARY:

• I am an Information Technology Professional seeking a position that will utilize my existing skill set. I also hope to expand my expertise by pursuing al opportunities.

TECHNICAL SKILLS:

PROGRAMMING LANGUAGES: MS Access, Visual Basic Applications, VBA, Visual Basic .Net, SQL, C/C++, Assembly Language, Ada, Pascal, Fortran, Lisp

OTHER EXPERTISE: Windows (3. / 2000 / NT / XP / 7), MS Word, MS Excel, DOS, PageMaker, Profitkey, Corel Applications (WordPerfect, Paradox, Quattro Pro), AutoCAD, Shop - Cam, Linux Redhat, Gnome

PROFESSIONAL EXPERIENCE:

Data Analyst

Confidential, New York City, New York

Responsibilities:

• VBA, SQL, Excel, ETL, Jira, and Service Now were used in a variety of different applications. Jira was primarily used for user acceptance testing on Excel applications that used VBA. Several T-SQL scripts were written using SQL Server.

Application Developer

Confidential, Concord, New Hampshire

Responsibilities:

• Access, VBA, SQL, Excel, ETL, and VB.Net were used in a variety of different applications. The VBA was primarily used for the Access Database. ODBC was used to connect with multiple SQL Server databases in a Virtual PC environment. This did entail some data modeling. Data was parsed and managed using Excel spreadsheets. Some troubleshooting was required. A Visual Basic Dot Net application was developed as well.

Application Developer

Confidential, Sacramento, California

Responsibilities:

• Access, VBA, and SQL was used to pull, parse, and process healthcare data for a large SQL Server 2014 database. Data modeling was critical for this project. A lot of troubleshooting and debugging was needed. The SQL Server database used Stored Procedures to import data changes from the United States government and apply them to existing health insurance policies and plans. Excel was used to document the changes to the data and the logic. Several stored functions, views, ETL, and triggers were used for the purpose.

Application Developer

Confidential, Bloomfield, Connecticut

Responsibilities:

• Access was used to develop a Welcome Calls database application for customer service. The database was programmed using VBA and SQL. The forms development was called for. There was also a large collection of Access reports that were developed, based on the data in the application. The user interface management of a logic tree from an Excel spreadsheet was involved, as well as user authentication. This did require troubleshooting, but did work. The contract was extended because of additional work. Microsoft Access was also used to develop an Individual Family Plan database. This also was developed using SQL, VBA, forms, and reports.

Application Developer

Confidential, Newton, Massachusetts

Responsibilities:

• Access was used to migrate and cleanse data from SQL Server. A network of Excel files were converted into a single Access database using VBA and SQL. Some User Interface development was required. The final application had a front end and a back end, and was suitable for multiuser functionality. The database application I created also had a role based security feature.

Data Analyst

Confidential, Waltham, Massachusetts

Responsibilities:

• MySQL, Excel, VBA, and Access were used to develop and modify data in the poster industry. The project required data from Excel files to be parsed and separated into individual fields using Visual Basic for Applications.

Data Analyst

Confidential, Hudson, New Hampshire

Responsibilities:

• This was a short, two week contract. Excel files were modified to update the links contained in the file.

Application Developer

Confidential, Boston, Massachusetts

Responsibilities:

• Microsoft Excel VBA and Access were used to develop and modify applications in the finance, investment, and banking industry. The project required CSV files to be parsed and converted into Microsoft Excel and Microsoft Access using Visual Basic for Applications.

Data Analyst

Confidential, Dover, New Hampshire

Responsibilities:

• The project utilized Microsoft Access and Microsoft Word to develop and enhance the current mail merge system. The scope of this project involved the automated modification of Microsoft Word files and templates for contact purposes. The automation was operated via Microsoft Access.

Application Developer

Confidential, Nashua, New Hampshire

Responsibilities:

• Confidential is a manufacturing company that produces printed circuit boards. The project utilized Microsoft Access and Microsoft Excel to develop a user interface that would handle and modify new and existing users for security purposes. The development of new reporting filters (For example, date range functionality, for data mining purposes) was involved. The scope of the project also included VBA, Queries, Forms, Reports, and Database Relationships.

Data Analyst

Confidential, Boston, Massachusetts

Responsibilities:

• The client needed data converted and cleaned up for conversion to their new application. Some data migration between Microsoft Access and Visual Foxpro was involved. The project involved data cleansing. A new data analysis tool was developed using an Access Form.

Data Analyst

Confidential, Newburyport, Massachusetts

Responsibilities:

• Confidential is an industrial firm that provides and synthesizes chemicals for industry and scientific research. The assignment involved modifications and maintenance to existing Microsoft Access databases in preparation for connection to SQL Server 2008. Some VBA was involved. Much of the project involved modifications to T-SQL scripts in SQL Server. Several of the tables in the databases were linked to other databases. Some ODBC was involved. There were several queries written. Some SQL development was needed. Data had to be imported and exported to and from Access files. This entailed data mining and data migration.

Application Developer

Confidential, Charlestown, Massachusetts

Responsibilities:

• Confidential was founded by Brigham And Women's Hospital and Massachusetts General Hospital. The assignment involved modifications and maintenance to existing Microsoft Access databases in preparation for conversion to SQL Server next year. Some VBA was involved. Much of the project involved modifications to forms in multiple
• Microsoft Access databases to accommodate new functionality for the incoming healthcare laws. Several of the tables in the databases were linked to other databases. Some ODBC was involved. There were several queries written. Some SQL development was needed. Data had to be imported and exported to and from Excel files. This entailed data mining and data migration. The project was completed successfully, and ended on good terms.

Application Developer

Confidential, Westborough, Massachusetts

Responsibilities:

• The client needed an Access Developer to develop a new Access Database. The database was needed to manage electronic manufacturing data for the optical display industry. The actual database was designed to manage travelers for factory jobs that go through their facility. This involved the use of VBA, SQL, and Access Forms. Some database administration was done.

Application Developer

Confidential, Foxborough, Massachusetts

Responsibilities:

• The client needed an Access Developer to manage their Access Databases during an upgrade to Oracle. The primary work involved several changes to an Access Database called, Consolidated Transmittals Some data migration from Access to Excel was done. This also involved the use of VBA, SQL, Access Forms, and Access Reports. Some database administration was done. The client sometimes need database cleanup and administration for purposes of providing desktop support.

Application Developer

Confidential, Portsmouth, Rhode Island

Responsibilities:

• The client needed a Business Information Technologist to handle Microsoft Office functionality while they upgraded. This primarily consisted of Microsoft Access database development using Visual Basic for Applications. Some Excel functionality was involved. This position involved the preparation of Kit Availability reports for weekly presentations.
• These reports were generated using Microsoft Powerpoint. While at Confidential, projects completed included the Hazardous Waste database. This was a Microsoft Access database that was programmed using VBA. They also included the Union Over Time database, which also was written in Microsoft Access. The Master Files database weekly downloads was the biggest of the projects. The databases themselves were Microsoft Access databases, but the development effort entailed a great deal of SQL programming, as the project required maintenance and troubleshooting of several ODBC connections. All of these projects involved extensive use of forms, VBA coding, and SQL. Yours Truly was Six Sigma Certified in the process.

Application Developer

Confidential, Lakeville, Massachusetts

Responsibilities:

• The client needed an Access database that would automate the operation of their current Excel spreadsheets. The database operated on multiple versions of Access including, Access 97 and Access 2000. The purpose of the database was to keep track of audits for recycled cans to compare actual counts to initial audits. The plant manager could then compare the number of cans expected to the amount of recycled aluminum produced for accounting purposes. The new database had a menu driven user interface which deployed Access forms, and some reports.

Application Developer

Confidential, Boston, Massachusetts

Responsibilities:

• The client needed a Lead Access Developer to create a new VAN Database in Microsoft Access. The Confidential sends out a public health van for a variety of free clinics, screenings, health events, and al projects. The VAN database was responsible for keeping track of the events and the clients that attended. The role involved some help and assistance to people with Access questions. The new database used normalized tables, a group of SQL queries, and some VBA code. The final product had three users, and is live today.

Application Developer

Confidential, East Providence, Rhode Island

Responsibilities:

• The project involved additions to an Access database front end connected to an SQL Server 2005 back end. The database needed an errors and omissions report, as well as an approvals piece. The approvals functionality documented the existence and status of approvals for titles, refinance loans, recordings, and purchase loans for real estate agents. The database modifications were performed in a Virtual PC environment for development purposes.

Data Analyst

Confidential, Boston, Massachusetts

Responsibilities:

• The project involved Database Conversions from Microsoft Access 97 to Microsoft Access 2003. There were about one hundred databases to be converted. Several of the databases had an SQL Server back end. ODBC was involved. The databases were tested to insure functionality. For documentation purposes, the status of the applications was recorded in a special Applications database. The contract ended because the work was completed successfully.

Application Developer

Confidential, Boston, Massachusetts

Responsibilities:

• The project began with a set of reconciliation reports. Used for financial accounting purposes, these Access Reports extracted data from an SQL Server database that was used for keeping track of truck permits. When a truck needs a permit so that it can carry extreme weights, a special permit is needed. The application can be done online.
• The actual purpose of the reports was to keep track of payments and fees for the truck permits, and check for financial discrepancies. The main task in the project was to merge the district databases. The client had a set of five Access Applications (One for each district) which operated as an Access front end and an Access back end, for each application. The project involved converting all five applications to a single SQL Server back end using DTS Packages, Enterprise Manager, Query Analyzer, and SQL. Some Data Transformation Services and Data Migration was involved. DTS Packages were chosen so that the client could repeat the procedure on the production server and on live data without any complications. The project was tested on a development server with old data. The end result was an Access front end connecting to an SQL Server back end, that contained data for all five districts.
• The User Interface had the same look and feel as the original five applications. This means the user would not notice the difference, nor need any special . The application would work as it did before, only now it was possible to examine data for all districts collectively. When the user was given the correct SQL Server permissions, they could access all five districts in one place. When a user was not given permissions, they could only access data from their own district. Documentation was provided. The project ended on good terms.

Application Developer

Confidential, Quincy, Massachusetts

Responsibilities:

• Confidential is a provider of Health Insurance to individual persons and corporations. When employers offer employees health insurance under a group plan, the employer applies for the group plan, and the employee applies for coverage under the plan. The original assignment was the development of a group database that would track enrollment operations for health insurance groups. The task involved the development of a new Microsoft Access database which served as a front end, and a new SQL Server database which served as a back end. This involved Client Server technologies and SQL Stored Procedures. A synchronization issue came up because the client requested that we use an MDB file, and not an Access Data Project. Then data was migrated into the SQL Server database from the original MS Access application that did not use SQL Server at all. The project was extended because there was additional work.
• The new assignment was the development of a Batch Tracking database for Document Control Management, which was an Access Data Project on the front end, connected to an SQL Server Database on the back end. This was a brand new project with no previous data or application. The application was developed using VBA, Stored Procedures, Query Analyzer, Enterprise Manager and Stored Functions. The use and deployment of a Bar Code Scanner was involved. Yours truly was the architect of the new Batch Tracking database. Both projects required the development of complex reporting tools. The contract ended on good terms. The people in charge of the project gave me a gift card at Best Buy. They also took me out to lunch with the department heads on the last day.

Application Developer

Confidential, Norwood, Massachusetts

Responsibilities:

• Confidential is the developer of ATM management software for the banking industry. This contract assignment involved an Access Database on the front end, and an SQL Server database on the back end, the connection was validated using NT authentication. Using Visual Basic for Applications and
• SQL, s include the addition of a dynamic hyperlinks functionality. This functionality was table driven, and therefore expandable without any practical upper limit. Another was a table driven saved search functionality that allowed users to custom design their own searches and validation within the ATM management software without having to understand the SQL language. Some data migration was involved. The contract ended on good terms.

Data Analyst

Confidential, Boston, Massachusetts

Responsibilities:

• Access database conversions on a large group of databases located in various positions on a VERY secure network. This was a short two week contract.

Data Analyst

Confidential, Boston, Massachusetts

Responsibilities:

• This is an advertising agency in Boston. s entailed some data mining, as well as an export functionality that handled a database of some 300,000 records. This involved migration to Excel. The database had to be split because the size of the database exceeded two Gigabytes.

Application Developer

Confidential, Cambridge, Massachusetts

Responsibilities:

• I created a pharmaceuticals database using Microsoft Access, VBA, and SQL. The database functioned on Access 2000 and Access 2003. One of my tasks was to test the database to determine if the new Access application would function on the version of Access the corporation was planning to upgrade. This was accounted for successfully. Another of my s was the design of a simple user interface. Using Access forms, I provided a friendly user interface which allowed the user to select parts, lots, process changes, and regulatory assessments dynamically. The user could add, edit, and remove any of these, simply by clicking the item they wanted, and then clicking a button.
• My s also include report functionality. The final project contained a number of reports that mined the data from the database, and presented in a readable manner to the user, both in preview and on paper, at the user's pleasure. Some data mining was involved. The project was completed and tested successfully. This was a contract position which ended on good terms.

Application Developer

Confidential, Montvale, New Jersey

Responsibilities:

• Confidential is the rovider of pharmacy coverage for large corporations. My first as a Database Consultant at Confidential was to perform revisions to 16 reports that operated on an Access Data Project. The ADP was connected by an ADO Connection to an SQL Server back end. This entailed the use of SQL commands across a connection string. Other s include migration of data between Access and Excel, the creation, development, coding, and manipulation of a newly created TreeView object, using Microsoft Service Pack 6, which connected and filtered the contents of an adjacent listbox object, several Data Manipulation routines written in VBA, and the design and development of a Hiperstation User Interface that connected to the web. This position was a contract position which ended on good terms.

Application Developer

Confidential, Marion, Massachusetts

Responsibilities:

• Confidential is a software development firm that specializes in boatyard management software, but also does work with the Cranberries industry. The development tools I worked as a Programmer with on a regular basis included, SQL Server, Microsoft Access, VBA / Visual Basic for Applications, Visual Basic Dot Net, Enterprise Manager, and Query Analyzer, usually operating Windows 2000 or Windows XP. Working within a team of four people, we developed the security functionality for boatyard software. This is a role based security system programmed in VBA that operates on a network using SQL scripts for scalability and transportability. We then documented this project using a web based program called Test Track, and tested it using Vmware. Work also was done converting the application to Visual Basic Dot Net. The new application was designed with a new user interface to interact with an SQL Server back end.
• Using Virtual Computing Machines, it is now possible to simulate the operation of an entire computer, and the operating system that goes with it, simply by storing the Virtual Machine on a backup device such as a DVD, with the operating system and software already installed. This allows for testing the newly developed applications on different operating systems like Windows XP, Windows ME, Windows NT, or Windows 98 on short notice. The boatyard program also interacted with various versions of PeachTree Accounting and Quickbooks. I also did thread programming using Visual Basic Dot Net. I was laid off from Confidential because there was no work.

Application Developer

Confidential, Moorestown, New Jersey

Responsibilities:

• Confidential is a software-consulting firm that specializes in the insurance and financial industry. Working within a team of some 13 people, we produced insurance policy software for the providers of hospital insurance. The details of our obligations were spelled out in more detail in documents written in MS Word and MS Excel. My first was the tail quoting system for the Institutional Policy System. The Institutional Policy System was an Access 97 database that functioned on Windows 98 and Windows NT. This database was programmed in Visual Basic for Applications. We later upgraded to Windows 2000.
• The client needed a Tail Quote system that did the work of their MS Excel spreadsheets, and spared their people from the tedious task of manually entering the data. This involved migration from MS Excel to MS Access. I developed a Tail insurance quoting system that allowed users to automatically create a Tail insurance policy and offer it to the doctor. The system, (Also programmed in VBA) automatically calculated premiums, accounting for the doctor, the doctor? specialty, the doctor? history, and state laws that applied at the time. The Tail Quote system was tested using test plans that were written in MS Word. I developed the Corporation Endorsement functionality. The Corporation Endorsement features allowed users to report certain events that happened. Then, the computer automatically adjusted multi-million dollar insurance policies to account for the changes. I developed the Master
• Lists functionality. Master Lists Endorsements are changes to hospital insurance policies that had obscure consequences. For example, a doctor gets married and changes her name. The Endorsements project had a download aspect. When information had been processed in times past by the client, using MS Excel, the data had to be downloaded into MS Access, while accounting for user errors. The process was done using Visual Basic, and had to be accounted for in all endorsements, because the referential integrity was frequently effected by omissions of data, errors in data, and, most notorious of all, punctuation marks in data. Although I did not recommend it, many of our queries included highly integrated SQL unions, and dynamically generated SQL text strings, which can be very complicated if the strings entered by users contain an apostrophe. A web-based application written with an Oracle Database needed testing. I was a tester. I went through its functionality and attempted to detect errors. My attempt to find errors was successful. My last name contains an apostrophe. The programmer that developed the web page included dynamically generated SQL statements in the application. That’s what did it.

Application Developer

Confidential, Northampton, Massachusetts

Responsibilities:

• Confidential is an ISO 9001 Certified manufacturer of temperature sensing electronic devices. My IT service at Confidential included various works in PageMaker, Profitkey, AutoCAD, Shop-Cam, Novell Clientware, and Dos. I installed a number of brand new computers to our Novell network. Some hardware installation was required. During Y2K, Confidential ? job scheduling database software for the entire corporation became outdated. It was written in Dbase, and was not Y2K compliant. My task as a Database Developer was to create the new job-scheduling program in Microsoft Access from the ground up. The new program was written using Access Basic and Visual Basic for Applications. It had to be written this way because the original programming started on Microsoft Access, Version 2.0, using MS Windows 3.1. But then it was converted to Microsoft Access 97 on Windows 95 during the upgrade of our Novell
• Clientware network. We later upgraded our operating system to Windows 98 as well. The program was called Schedule Menu. It? roll in the area of process mapping was defined by its handling of time. This project, when completed, enhanced the production of product by planning the time schedule for the product, and by tracking the passage of jobs between departments. It would then report any late jobs to the QA manager, so that if a job was behind schedule, the correct people became aware of the problem, and could take corrective action. When the program was completed, there was a substantial collection of modules, procedures, and functions, a smaller number of queries and macros, some forms, and about three reports. The number of forms that were deployed was small because I standardized the Graphic User Interface, so that the program worked the same way in all its parts. The project was constructed from the ground up using a clean, Object Oriented Design
• The final product was a multi-user database that had to function on a Novell network with some 25 workstations, 1 server, 1 print server, 3 routers, and a good deal of wiring. I had to coordinate the job scheduling of 5 different major departments of an entire factory. It came with a 23-page technical instruction manual for users, written by Yours Truly on MS Word.