EXPERTISE:

• VB.Net, ADO.Net (6 yrs.)
• MS - Access VBA (10 yrs.)
• SQL Server v2008-v2012 (6 yrs.)
• Confidential /Optimization (10 yrs.)
• SSIS & SSRS (5 yrs.)
• Excel (VBA) large scale projects (8 yrs.)
• VB.Net Click-Once Deployment
• Visual Studio v2008-v2012 (7 yrs.)
• VB.Net COM Add-ins
• Oracle 9i Security Design (1 yr.)
• Async/Parallel/Multi-Thread .Net Programming
• Knowledge of Calculus and Inferential Statistics
• Basic understanding of electronic theory.
• DevExpress - WINFORMS (4 yrs)
• Regular Expressions (7 yrs)

EMPLOYMENT HISTORY:

Database Designer

Confidential

Responsibilities:

• Developed two VB.Net/ADO commercial applications that use OLE automation to perform sophisticated searching and tracking of Excel workbook contents.
• Converted numerous DTS packages to SSIS and VB.Net.
• All project reports were developed using Microsoft SSRS Report Builder.
• Created a flexible SSIS package to parse fixed column width data files based on a SQL control table that defined the column widths of various inputs.
• To do this, I created a custom SSIS VB.Net Source Component which served as the source data in the SSIS processing.

Confidential, Northampton, MA

Confidential and software development

Responsibilities:

• Developed a multi-user MS-Access report engine as a front end to the college-wide Banner Oracle database.
• Produced a runtime version of the report engine for distribution throughout the organization.
• Instructed over fifty Confidential employees in the use of MS-Access and the Banner Access Report Engine.
• I currently provide ad hoc support and development.

Confidential, Boston, MA

Lead developer

Responsibilities:

• I helped develop a commercial MS-Access database product designed for the Confidential .
• The completed software system was used at power plants throughout the United States.
• After the major project was successfully completed, I subsequently designed and developed approximately ten engineering database applications for internal use.
• Designed and developed several MS-Access VBA commercial software products for the energy industry.
• Designed and developed a commercial VB.Net WINFORMS project for the Confidential ; the software is sold to power plants worldwide.
• Developed a number of SSIS packages to perform ETL operations on SQL Server databases, MS-Access databases and Excel workbook sources.
• Over the last 15 years, I have provide ad hoc support and development.

Confidential, San Francisco, CA

Software design and development

Responsibilities:

• Designed, developed and or maintained over one hundred Excel VBA applications.
• Designed and developed a number of VB.Net/ADO applications based on BGI best practices.
• Designed and administered an Active Directory/NTFS security plan for a corporate wide shared file server dedicated to tactical spreadsheet development and deployment.
• Used SSIS and Regular Expressions to parse and transform input data in various formats, i.e. Word, Excel and CSV etc.

Confidential, San Francisco, CA

Software design and development

Responsibilities:

• Maintained and enhanced the primary commodity trading system in support of all traders on the trading floor.
• Designed and maintained internal MS-Access/SQL Server applications, Excel VBA and VB.Net applications.
• Visual Studio 2005 development included: Excel and Outlook VB.Net Add-ins, Click-Once Deployment for VB.Net applications and several smaller .Net applications.
• Designed and implemented an Oracle 9i security plan that included the design of roles, resource accounts and complex object permission matrices.

Confidential, MA

Commercial software development

Responsibilities:

• Developed a commercial MS-Access/SQL Server database product that used complex DTS data transformations.
• Developed several VB.Net WINFORMS projects to do complex data processing; all WINFORMS project reports were developed using Microsoft SSRS Report Builder.

Confidential, Boston, MA

Software development

Responsibilities:

• Designed and implemented a multi-user MS-Access database that tracks a term life product from customer contact through policy issue.
• The system imports daily feeds from the telesales department, allows users to view, modify and report on this data, and then exports updated data back to the telesales department.

Confidential, MA

SQL Server admin. & software development

Responsibilities:

• Responsibilities included administrating a five node network running MS-SQL Server.
• Designed & developed an imaging database using MS-Access, and SQL-Server.

Confidential, Marlboro, MA

Consultant & system designer

Responsibilities:

• Designed and implemented a multi-user “failed trade” tracking system using MS-Access.
• The system imports daily failed trade data, allows users to validate the failed trades, and issues invoices for overdraft charges.
• Failed trade history is tracked so that approximately twelve different MIS reports can be generated.
• The Failed Trade Tracking system also incorporates automated Email and Faxing capabilities.

Confidential, Boston, MA

Consultant and system designer

Responsibilities:

• Designed & developed several trading systems using MS-Access.
• Developed MS-Excel VBA programs to import fund accounting information into TAX compliance spreadsheets.
• Designed & developed a multi-user project tracking system using MS-Access.