SUMMARY:

Professional Programmer/Analyst/Systems Engineer/Technical Architect/Database Developer with over twenty years of industry experience. Has over nineteen years experience with Visual Studion with over thirteen years of VB.NET. Has over ten years experience with Oracle & PL/SQL, and eleven years of experience with MS - SQL Server & T-SQL. In addition has over eighteen years experience with Microsoft Access. Also has over nine years experience with applications such as COM/COM+, DLL and ActiveX. He also has experience with MySQL, SharePoint, ASP, ASP.Net, JavaScript, VBScript, HTML, and Groovy/Grails. Has been working in a Windows NT/XP environment.

TECHNICAL SKILLS:

Operating Systems: Windows 10, Windows 7, Windows XP, Windows 2000, Windows NT, Windows 95/98, Citrix Winframe, Microsoft Terminal Server, Windows for Workgroups, Novell NetWare 3.x/4.x, MS-DOS, OS/2

Applications/Databases: MS Access, Crystal Reports & Crystal Enterprise, Excel, MS Word, MS Exchange, Lotus Notes, Lotus Approach, Novell GroupWise, Microsoft SQL Server (6.5, 7,2000,2005,2008,2012), Transact SQL, Oracle (8i & 9i), PL/SQL, MySQL, SharePoint, Borland Interbase, ASP, COM/DCOM/COM+, DLL, ActiveX, Erwin, DB Artisan, Toad, Installshield, & WISE Installer, Groovy/Grails

Languages: .NET (VB, C#), Visual Basic 6, VBA, T-SQL, PL-SQL, MVC, ASP, ASP.NET, JavaScript, VBScript, HTML, XML, Groovy/Grails

Hardware/Platforms: IBM PC and PC clones

EXPERIENCE:

Confidential, Rexford, New York

Consultant

Responsibilities:

• Designed, built and hosted a web site to handle day to day operations of a fantasy baseball league.
• Initially created using ASP.NET
• Re-written using .NET MVC/C#
• Uses MS-SQL for backend database

Environment: s: MS-SQL Server (2008, 2012, 2014), T-SQL, Visual Studio, ASP.NET, VB.NET, C#, MVC, Crystal Reports

Confidential

Consultant

Responsibilities:

• Universal Rate Setting: Team member developing the Universal Rate Setting system.
• Primary Duties: Design and maintain Oracle dB
• Secondary Duties:
• Develop in-house VB.Net/C# application to test database functions
• Mentor staff
• Contribute to application design

Confidential

Consultant

Responsibilities:

• Maintenance & Enhancements of a three-tier VB6 application using MS-SQL Server, DCOM. Also uses VBScript to support logon process.
• Re-write of the NetAdmin application using VB.NET
• MS-Access application to generate canned reports against NetAdmin data.
• Module for the Inmate Grievance Application to generate response letters. Written in MS-Access. Uses Word to mailmerge data from SharePoint lists. Created & maintained views against SharePoint lists.
• MSAccess/SQL application to track internal MIS issues.
• MSAccess/SQL application used to track Facility information
• MSAccess/MySQL application used to support Facilities Planning
• Migrated backend database to MSSQL
• Crime Victims Information: MSAccess/SQL application used by Victim Services to track crime victims.
• DRLT: MSAccess/SQL application used to track Deficit Reduction Leave.
• Migrated data from legacy application
• Printer Mapping Utility: VB.Net/SQL utility to assist user in mapping printers
• PSDR: Used SQL to prepare data for transfer to an external agency.
• Redbook: MSAccess/SQL application used to maintain vehicle inventories, equipment inventories, and rosters for emergency responses
• Migrated data from legacy application
• EIU.NET 3-tier VB.NET/SQL application used by the Employee Investigation Unit (EIU) to track pre-appointment screenings, process criminal history background requests, track employee arrests & DMV violations.
• Migrated data from legacy application
• Integrated data from 5 legacy lotus approach application.
• EIU Criminal History Request. .NET(C#)/MVC/SQL application used for submitting Criminal History Background Requests to EIU
• Migrated data from legacy application
• Facility Inmate Grievance Systems: MSAccess application used be individual facilities to track internal inmate grievances
• Migrated data from legacy application
• Inmate Legal Resources Program (ILRP) - 3-tier VB.NET/SQL application to assist Library Services in fulfilling & tracking inmate requests for legal resources.
• Pharmacy Issue Tracker: 3-tier VB.NET/SQL application used to track issues in the latest version of a vendor provided application
• Pharmacy Business Rules: 3-tier VB.NET/SQL application used to track business rules in a vendor provided application
• Facilities Management Re-Write: 3-tier VB.NET/SQL application used to track facility information
• Migrated data from legacy application
• FMS Grails: Proof-of-Concept demonstrating the potential for using GRAILS as a viable development platform: GRAILS/SQL application.
• Inmate Assessment System: 3-tier VB.NET/SQL application used to track responses to screening surveys
• Application Catalog: GRAILS/SQL application to track application & application components used internally.
• Superintendent Grievance Tracking: 3-tier VB.NET/SQL application used to track responses to screening surveys
• PSC Tracker: Team member on .NET(C#)/MVC/SQL application to track internal Public Safety Cluster issues
• Migrated data from legacy application
• Spectrum Justice System: Support of VB6/Oracle application: Used by State Police to track all contact with individuals
• Highway Safety Certification System: VB.NET/MS-Access application: Used by Office of Public Safety to track certification of various electronic devices (Radar, Lidar, & Breath Analysis).
• Migrated data from legacy application

Environment: s: MS-SQL Server (7, 2005, 2008,2012), T-SQL, VB6, VB.NET, SharePoint, MySQL, Oracle, PL-SQL, Crystal Reports, MS-ACCESS, EXCEL, VBA, VBSCRIPT, DCOM, Web Services, WINDOWS 2000/2003/XP/7/10, GRAILS

Confidential

Consultant

Responsibilities:

• Lead developer of web based application using ASP.NET, VB.NET, Web Services, Crystal Enterprise, & Oracle
• Maintenance and Enhancements. A three-tier application using VB6, COM+, Crystal Report, Active Reports, & Oracle
• Maintenance and Enhancements for Capital Projects Updates (CPU). A Web based application using ASP.NET, HTML, JavaScript, VB Script, VB.NET, Crystal Enterprise, & Oracle.
• Re-write of New York Interagency Supported Employment Reporting System (NYISER). Three-tier application using VB6, COM+, Crystal Reports, and Oracle running in a CITRIX environment. With extensive use of oracle packages, procedures, and triggers.
• Lead Developer for re-write of Prior Acceptance Review Tracking System (PARTS). Using VB6, COM+, Crystal Reports, and Oracle.
• Team member for the Child & Adult Integrated Reporting System (CAIRS) project. Using ASP, HTML, Javascript, VB Script, VB6, COM+, Crystal Reports and Oracle.
• Designed and developed Bureau of Residential Affairs Survey System (BRASS). Using VB.Net, Crystal Reports, and Oracle
• Designed and developed Local Provider Incident Reporting system (LPIR). Replaced a legacy system to track incident reported by local providers. Using VB.Net, Crystal Reports, and Oracle
• Team member on the Residential Information System (RIS) project. Designed and developed the reports for the system. Also created the data migration routines to transfer data from the legacy system. Using VB.Net, Crystal Reports, and Oracle.
• Designed and developed an Ad-Hoc Reporting system for the Concerts application utilizing VB6, COM+, Crystal Reports, and Oracle running in a CITRIX environment.
• Re-write of the Blended Case Management (BCM) system using VB6 and MS-Access.
• Designed and developed program modules to support the OMH New York Incident Management Reporting System (NIMRS) utilizing VB6, COM+, ASP programs and stored procedures against an Oracle 8.0 database. Used Crystal Reports, Active Reports and Gigasoft Reporting tools.
• Created an application using Visual Basic and Stored Procedures to migrate data from a legacy MS-Access incident tracking database to NIMRS Oracle 8.0 database.
• Created a workflow application using MS-Access to maintain progress of CAIRS implementation.
• Created an automated application using Visual Basic and Stored Procedures to pre-process an input file for a Human Resources application (ASPEN)
• Utilized the Crystal Reports product to redesign and develop management reports to support the business requirements for the OMH statewide Children’s Placement System (CHIPS).
• In addition to each of the projects worked on, provided mentoring to OMH staff.

Environment: Oracle 8.0/8i/9i, PL/SQL, TOAD, VB.NET, ASP.NET, VB6, ACCESS, HTML, JAVASCRIPT; VBSCRIPT, COM+, CRYSTAL REPORTS/CRYSTAL ENTERPRISE, WINDOWS 2000/2003/XP

Confidential, New York

Information Systems Manager

Responsibilities:

• Managed and implemented all efforts in the IS Department for a small telecommunications company.
• Developed and deployed a billing system to replace outsourced service.
• Administered MS-SQL Server, MDamon Mail Server, and network infrastructure: included four MS NT servers running MS-SQL Server, IIS, MDamon Mail Server, and DHCP.
• Used Visual Basic, MS-SQL Server, ASP, HTML and Access for development and customization of internal applications.
• Created internal reports using Crystal Reports, MS-SQL, Access, and Excel.
• Supported users in daily operations.

Environment: VISUAL BASIC, ASP, HTML, MS SQL, ACCESS, EXCEL, WINDOWS 98/NT, MS SQL SERVER, DHCP, IIS

Confidential, Troy, New York

Programmer Developer

Responsibilities:

• Utilized Visual Basic, Crystal Reports, and MS-SQL server to create custom Client/Server and three tier applications.

Environment: VISUAL BASIC, CRYSTAL REPORTS, MS-SQL, WINDOWS 98/NT

Confidential, Troy, New York

Systems Engineer

Responsibilities:

• Created a custom application for internal use in MS Access to track time and billing for the company.
• Created a custom application for a client in Visual Basic and Crystal Reports to simplify the generation of a variety of pre-filled legal forms and contracts.
• As part of a team, created a custom application for a client written in Visual Basic & SQL to manage a $130 million joint-trust fund for 30,000 members.
• Configured and installed server based networks for various clients.

Environment: MS ACCESS, VISUAL BASIC, SQL, CRYSTAL REPORTS, WINDOWS 98/NT