SUMMARY

• Output polished reports.
• Perform required calculations using Excel, Access, and/or SQL.
• Prepare raw data for import and use in database and calculations.
• Data analyst, VBA programmer, database designer who takes pride in his work. Transforms tedious tasks and calculations into a simple click of an icon. Designs applications with maximum functionality, yet reliable and simple to use. Researches and learns new technologies as the need arises. Samples of work are available.
• SKILLS Application Development
• Identify requirements. Adhere to strict proper programming practices.
• Design solutions in Excel, Word, and Access, using VBA and/or SQL.
• Create interactive Adobe Acrobat forms using JavaScript.
• Data Analysis
• Database Design/Modification
• Work in Access front end with Jet, SQL Server, Oracle, or DB2 back end.
• Write queries in raw SQL. Use ADODB or DAO objects as appropriate.
• Validate results.

SELECT PREVIOUS PROGRAMMING PROJECTS

• Cigna Excel, Access, VBA, SQL Maintained complex Excel tool involving multiple sheets and code modules used by underwriters to price and sales staff to sell health care policies. Implemented change requests and released new versions as scheduled. Used SQL stored procedures to interface with SQL Server database.
• Beazley U.S.A. Excel, Word, VBA Used Excel VBA to design user-friendly interface to streamline entry of data for various insurance products. Used automation to generate Word documents based on user's input. Project performed validations to ensure compliance with company and regulatory standards.
• LEGO Systems, Inc. Excel, Access, VBA Wrote custom Excel VBA application to properly allocate available supply to retailers. Used VBA to convert extracted raw data into form suitable for import into Access database.
• Kollmorgen Electro-Optical Access, VBA, SQL Designed custom VBA application in Access to allow review of data, fast computation of supplier statistics, and display and distribution of reports.
• personal Excel, VBA Designed custom utility in Excel to streamline selection of worksheets in workbooks containing numerous sheets. Enabled use of pattern-matching in selecting or deselecting multiple sheets, as well as other user-friendly capabilities such as invert selection. Also, includes ability to navigate among only members of the array of currently selected sheets.
• SYSCO Access, VBA Wrote VBA routine to automate generation and sending of Access reports previously, the employee had to manually run and send each report. Implemented mechanisms to handle foreseeable errors, such as forgetting to change from employee's own Outlook profile to the report mailer profile or inputting improper date ranges.
• OneBeacon Professional Partners Word, VBA Converted Word documents into interactive Adobe forms. Designed them to be very professional, user-friendly, and functionally logical. Used sophisticated JavaScript to cross reference with other fields and validate entries, and to give a specific alert to the user or take corrective action when necessary. Optimized Java code using functions and loops.
• SYSCO Access, Excel, VBA Took existing Access database utility and designed user-friendly front end form to enable use while no longer requiring the user to navigate the maze of query, table, and macro objects. Results exported to Excel were then further formatted by the script, and unwanted records were deleted, making it no longer necessary for the user to manually filter the data.
• Luvata Waterbury, Inc. Access, VBA Designed database in Access to streamline process of fulfilling customer orders while adhering to strict customer specifications.
• American Red Cross Access Designed sophisticated utility in Access to streamline entry of donor appointments. Used SQL to avoid unnecessary repetitive entry of data, while allowing necessary flexibility.
• Travelers Life Annuity Excel, VBA Designed sophisticated custom utility to properly sort multiple ranges on multiple sheets, able to adapt to different numbers of header rows in the ranges and able to automatically detect correct column location.
• American Red Cross Word, VBA Transitioned poster design from tape and scissors method to elegant PC design designed custom print command and icon to automatically detect pre-printed poster background image, conceal prior to print, and restore after sending to print queue.
• CB Richard Ellis Excel, VBA Improved consolidation of data from multiple workbooks into one central workbook by using automated VBA program instead of old manual method. Effected substantial time and labor savings, while also eliminating possibility of human error.
• OneBeacon Financial Acrobat, JavaScript Wrote macros to streamline modification and conversion of > 1,500 internal Word documents to secure PDF format suitable for external distribution. Saved labor costs and at the same time allowed for project to be completed ahead of schedule. Also, converted paper applications to fillable PDF format.
• Travelers Life Annuity Data Analysis Analyzed pricing and features of competitors' products and compared to those of our own products. Produced reports for use by marketing staff, actuaries, and internal wholesalers.
• SYSCO Food Service of Connecticut Data Analysis Lead project to identify opportunities for market expansion.