Summary of Qualifications:

Seasoned, customer focused web and database developer with 20 years of experience. Specializing in object oriented application design and development for database centered, large volume, highly personalized, content or commerce based web applications. Known for consensus building, strong problem solving skills and rapid adaptability.

Technical Skills:

Database

IBM DB2, SQL Server 6.5, 7.0, 2000, 2005, 2008, Oracle 8.0.5, 8.1.6 PL/SQL, ERWIN, Designer 2000, PowerDesigner, Sybase, Sybase SQL Anywhere

Languages

Java, WebSphere 4, 5, 6, WSAD 5.1.2, VB 6.0 / COM / MTS, ASP, HTML, XML/DTD, IBM MQ Series

Basics

Windows 8, Windows 7, Vista 64, Windows Server 2003, Windows XP, Windows 2000, Windows 95 98, Windows NT 4.0, Miicrosoft Office 97 - 2010 Word, Excel and Access

Audio Production

Pro Tools 10, Propellerheads Reason, Emagic Logic Platinum, Sonic Foundry's Acid SoundForge, Fruity Loops, Cubase SX, MIDI

Video/DVD Production

Sonic MyDVD, TPMGEnc, MPEG Video Wizard 2003

Professional Experience:

Confidential

• Department of Labor, Office of Federal Contract Compliance Programs,
• Division of Management Administrative Programs, Branch of Information Technology

Database Systems Analyst

The Systems Plus contract is responsible for the maintenance and enhancement of the Case Management System CMS, Executive Information System EIS . Also maintained and enhanced the OFCCP Internet and Intranet web sites and the WebSphere Applications linked to by the web sites through December 2012.

Business Requirements Analysis

• Worked closely with DPO to understand a 13 page list of new business requirements to be implemented in the CMS and EIS applications and to interpret the requirements into specific changes to specific areas of the supported applications. Proposed Business Rule changes to CMS in order to increase the data entry accuracy in CMS. More strict data entry rules were well received by all audiences including the end users. Proposed comprehensive changes to be made to CMS and EIS in support of new VEVRAA and Section 503 Regulations that not only add support for the new Regulations, but normalize the way Violations, Discrimination Indicators and Financial Remedies are described so that more meaningful data analysis can be achieved. The additional changes will also make is possible for CMS to produce all Letters regarding Violations that are sent to Contractors in the future.

Technical Requirements Analysis Translated agreed on Business Requirements into Technical requirements from Data Models, to screen shots with explanations of how each control will function on the screen. Continued to provide requirements clarification throughout development cycles.

Data Analysis DB2, MS Access, Excel

DB2, Excel Quarterly Reports Historical Data Extracts covering all aspects of work done in the agency and used to create reliable statistics that are used in all data representations for the quarter. Topics cover Compliance Evaluations, Complaints, Violations, Financial Agreements, Construction evaluations, Enforcement Activities and Contractor Timeliness. DB2, Excel Staff Timeliness Reporting Implemented reports that are used by management to hold regions and district offices accountable for making status entries and processing candidates in a timely manner. It is expected that this will not only increase timeliness, but data accuracy and ultimately make cases more enforceable. DB2, Excel Provide Excel Reports in response to Ad Hoc Data Requests ranging from simple data extracts to requests that require substantial analysis be done to create meaningful aggregates about such things as the processing of compliance evaluations or the results of completed compliance evaluations or how financial remedies and/or violations relate to various protected groups. Frequently Ad Hoc Data Requests become scheduled reports or are requested repeatedly in one-off format. A catalog of reports was created to more rapidly respond to these requests over time. DB2, Excel, MS Access Created reports that demonstrate the flow of compliance evaluations through the process over time. A table with statuses across the top and months down the left side showed how many cases entered each status each month which made it visually obvious where the process bogs down.

Confidential

DB2/Erwin Maintain Erwin Diagrams depicting Functional, Logical and Physical Data Models for all databases. Work with Technical Writer to maintain Data Dictionaries documentation. DB2 Correct data entry errors and improperly loaded company information with approval from DPO. DB2, AIX Load data into CMS, EIS, EEDS, EERD, and FPDS databases in support of CMS, EIS and various Web Applications. Import CSV files that are processed through AIX Shell Script based SQL Statements and Export/Import commands to move data from the Staging Database into the various databases that are accessed by the applications. Notepad, DB2 Cleaned and loaded VETS100 data into the EIS database. DB2, AIX Shell Scripting Provide monthly data extracts that are the source data for the Enforcement Database that is made available to the public on by OCIO.

Confidential

MS Access Created Help Desk Tracking and Change Control Request Tracking applications in MS Access. Change Control Requests are exported from the CCR system to request Test and production Deployments. Help Desk applications keeps track of each email request from end users we receive and allows us to report by Region, User, and Type of Question being asked. DB2 Created and Modified Tables, Stored Procedures, Stored Functions, Triggers and Queries in support of new and updated features in CMS, EIS, the Internet and Intranet Websites such as:

DB2 The Triage Report which rates then ranks Discrimination Indicators to create a list of Compliance Evaluations in order of processing priority. Created new tables where data entered by Compliance Officers are stored through the CMS application

DB2 Changed the Stored Procedures in CMS that implement the Business Rules, specifically the order of data entry within the system, with the goal of improving data entry quality over time.

DB2, AIX Weekly DPO Reports are used by Management to keep them informed about staff utilization, current workload, and fall out rates for candidates loaded into CMS. Initially they were manually run but eventually they were automated by the creation of tables, stored procedures and SQL statements called by the Nightly Batch AIX Shell Scripted cron job. The EIS application retrieves out the most recent weeks' data with SQL that was provided and presents the results in Excel Spreadsheets.

DB2 New Tables for WebSphere applications such as the Suggestion Box, Employee Directory, VEVRAA Benchmark Database.

DB2, AIX, Java Made changes to the FCSS List loading process. Worked with DPO to define a new Load File format. Mapped fields from File through to final Database Tables to eliminated fields that were not needed, add new fields that were needed and resize all fields in all databases to be consistently sized. Updated SQL Statements, AIX Shell Scripts and Java Code that moves the data from one stage to the next stage.

DB2, AIX Create Change Control Request Documentation and Deployment Packages that allow new features and data to be released to the Test and Production environments including SQL statements, Shell Scripts and Importable Data Extracts. DB2, Delphi 7 Troubleshooting issues with CMS and EIS that are reported by users of the system.

Confidential

HTML/Notepad Proof of Concept web pages for new Intranet Design that was used in Regional Managers Meeting Demonstration. HTML/Notepad Updated existing and implemented new static HTML Pages for Internet and Intranet websites. IBM WebSphere/RAD Debug and resolve issues with existing WebSphere Applications. Implemented new HTML/JavaScript and WebSphere code for

HTML/JavaScript, IBM WebSphere/RAD Suggestion Box

IBM WebSphere/RAD Intranet Employee Directory

IBM WebSphere/RAD VEVRAA/Section 503 Resource Directory

IBM WebSphere/RAD Data Editing tools for the ERRD and VEVRAA/Section 503 Resource Directory.

Confidential

Software Engineer III, Applications Development Team

Software Developer charged with the maintenance legacy VB/ASP websites and taking over projects in crisis status and delivering them in a reasonable amount of time. Shared Technology Services Group, Inc. provides IT services to six companies who provide Personal Auto, Commercial Auto, and Homeowners Insurance in four states.

IBM WebSphere Java Web Service, Servlet, and JSP Pages IBM DB2 Control-M Automation: Audit, Balance and Controls ABC is an automated auditing software solution designed to identify out of balance monetary transactions between different systems i.e. to reconcile the systems, before they become large accounting headaches. Delivered 32 new Control Points in 8 weeks and re-architected the initial solution provided by contractors to eliminate deployment issues that had been the norm for the previous 6 months. Refined and rolled out control points to 5 additional insurance companies. Worked with Control-M team to automate control points and validate daily results. ABC is an IBM WebSphere Service that is interfaced with via a Web Interface that allows file uploads, displays aggregated results.

IBM Websphere WebService IBM DB2 Microsoft Visual Basic 6 Microsoft SQL Server: Enterprise ChoicePoint ECP is an IBM WebSphere Web Service that provides the interface to ChoicePoint for each of the Insurance companies' websites and all internal processing applications. It requests Credit, Motor Vehicle Records, Insurance Payment and other reports from ChoicePoint and caches the results using Hibernate. Caching reports saved money and lowered policy acquisition costs considerably. Supporting this application also included continued support of iSolutions Visual Basic Components and SQL Server Database as well as being the primary interface with ChoicePoint technical staff to resolve development and production issues.

IBM WebSphere Java Application IBM DB2 Control-M Automation: Fully automated interface to acquire data from the Massachusetts Merit Rating Board. MRB is a java command line application, scheduled to run in Control-M that runs in two modes Inquiry Mode and Response Mode. In Inquiry Mode it connects to a DB2 database, obtains data required for the creation of the MRB Inquiry file. In Response Mode it parses the response file and uses Fiserv Policy Star Web Services to update policies with official accident and violation information.

Microsoft Visual Basic 6 COM / Interfaces, ASP, SQL Server XML Stored Procedures: Designed and Implemented 2.0 architecture for websites that included the use of VB6 Interfaces, a shared ASP Controller Pattern and SQL Server XML Stored Procedures for multi-row updates. This architecture was first implemented for the Massachusetts Commercial Automobile Policy Entry Website and was refined for all private passenger auto websites.

Microsoft Visual Basic 6 COM, ASP, SQL Server: Implemented Website for Agent entry of NH Auto Policies in VB and ASP. This website was an extended one-off of an existing CT application that included minor re-architecting and customization of VB6 iSolutions components for connectivity to ChoicePoint through VB applications.

Microsoft Visual Basic 6 Application COM, ASP, SQL Server: Integrated VB 6.0 Call Center application with GoldMine contact management system. Optimized performance reducing time to sync data between applications from 2 minutes to 5 seconds by replacing DDE calls with SQL Statements.

Microsoft Visual Basic 6 COM, ASP, SQL Server: First line support for NH, MA, and CT private passenger auto new business and inquiry applications as well as general go to person for all VB and ASP questions.

Confidential

Principal Programmer Analyst

Software Developer tasked with various development projects often building stronger relationships with other teams or partnering with them to deliver their requirements. Bridged the gap between development and the DBA Team guaranteeing that the design needs of both groups were met simultaneously.

Partnered with merchandising and usability teams to select a Web Analytics vendor and define detailed implementation requirements. Defined and documented architecture strategy for implementation.

IBM WebSphere: Attended 7 week Java/J2EE boot camp program taught using IBM WSAD. Mentored co-workers on final project which involved building a front to back end J2EE architecture using standard design patterns.

CenterRun, VB6 COM, ASP, SQL Server: Implemented a proof of concept Application Deployment using CenterRun of the full Staples.com website, application servers and SQL Server Databases. Project involved full installation and upgrade installation deployments of Staples.com website code, MQ Series configurations, and database scripts.

VB6 COM, ASP, SQL Server: Implemented a new version of the Staples Catalog Browsing functionality based on the Brand Stores design see two bullets down . This was implemented to reduce the overall page load time while browsing the Staples.com website and was successful in its purpose. This was intended to be released along with a change to a database stored session management solution which increased the overall page load time.

VB6 COM, ASP, SQL Server: Implemented Favorite Items widget. After the new StaplesUser membership was implemented we added some new user customizable features to the website including the Favorite Items widget which allowed a user to add items to their favorites list and for an individual to see their company's favorite items list. Implementation included addition of new Membership Attributes to the database, new VB6 COM component to obtain data for items in the list and new presentation logic.

VB6 COM, ASP, SQL Server: Implemented transition of Staples.com from the Site Server LDAP Membership service to custom built SQL Server, VB6/COM, and ASP membership solution. This included the data model for the new StaplesUser database, creation of the VB6 COM Component that accessed that database and the replacement of existing ASP Include files that accessed the old Membership Objects. Lead team to enhance the performance of newly developed code which soon exceeded QA's expectations. Ultimately the code changes resulted in a substantial gain in site performance, stability, and supportability. It also included the migration of the existing 2,000,000 user profiles from the LDAP database to the new StaplesUser database. The migration resulted in data shrinkage from 60 Gigs to 6 Gigs and new data model made troubleshooting Membership issues easy.

VB6 COM, ASP, SQL Server: Implemented Brand Stores for Staples.com, for example the 3M Brand Store. Implemented a new model for accessing the StaplesCatalog database that reduced round trips to the database from many down to one using a recursive stored procedure to traverse the catalog tree when levels of the tree were skipped. Also created a single new VB6 / COM Component to access the new tables and stored procedure as well as new ASP Pages to present the Brand Store. This new model reduced the overhead of the existing StaplesCatalog Implementation dramatically by not creating unnecessary objects and not going back and forth to the database repeatedly.

SQL Server: Automated database build scripts therefore reducing the time required to build a clean development environment.

Confidential

Senior Web Developer / SQL Server DBA Architect

Senior Developer at a very small .COM serving multiple roles including Architect, Developer, Mentor, DBA, Business Analyst and Project Manager.

ASP / SQL Server 7 Converted website from FrontPage 98 to 100 ASP / SQL Server 7.0 site.

ASP / SQL Server 7 Architected and developed personalization paid membership model including data model, stored procedures and ASP code.

Architected and developed pregnancy calendar which presented personalized content for women in their various stages of pregnancy from Conception, through Pregnancy then through Childhood. Content included regional events, chat schedule, baby ASP / SQL Server 7 book and journal entries and content relevant to their stage of pregnancy.

ASP / SQL Server 7 Architected and developed system to send personalized newsletters to end users. Included user subscribe/unsubscribe, mechanism to physically send personalized emails, web presentation of newsletters, and link click tracking.

ASP / SQL Server 7 Architected and developed logging and reporting mechanism for tracking site usage, specific site events ex registrations and newsletter subscriptions, and errors ex 404 and 500 .

Confidential

Software Engineer Advanced Development Group

Key contributor in Advanced Development Group responsible for version 3.0 Architecture. Wrote several architectural documents about data replication methodology and implementation, application partitioning and architecting the service for upgrades requiring zero downtime and no redundant hardware.

Software Engineer Development Group

• Architected data structures for the 2nd Generation Platform for MS SQL Server 6.5. Adding referential integrity, keys, and indexes to previously disorganized schema. Introduced concept of Design tools to staff.
• Managed the conversion of the 2nd Generation Platform database from MS SQL Server 6.5 to Oracle 8.0.5 including table and procedure and data conversions.
• Provided analysis of product group requirements and development of table structures and procedures for interim releases.
• Was involved in the hiring of several Oracle database developers.
• Developed Opinion Feature using ASP for 2nd Generation Platform.

Confidential

Systems Architect / On-line Community Manager

• Implemented and moderated On-Line community using NNTP News as a replacement for CompuServe and MSN Forums. The newsgroups served to allow end users to ask and answer questions about use of the products supported.
• Architected and developed client/server and distributed web based applications to maintain Newsgroup, Moderator, Team Powersoft / Sybase information in a Sybase SQL Server OLTP Database.
• Developed processes to aggregate and report on news server usage as well as archive messages.
• Designed, implemented maintained the Powersoft Forum on MSN.

Confidential

• Isolated customer issues and where possible provided direct answer, education or sample code to meet customer's needs.
• Packaged up examples of bugs to send to CIR team. Documented enhancement requests to submit to Product Manager Team.
• Met or exceeded 10 call requirements daily with availability time often reaching 90 .

Confidential

• As one of the original four frontline engineers was involved in the implementation of the frontline support engineer role and the establishment of guidelines for moving calls from the frontline to the backline.
• Role consisted of validating users as appropriate support contacts, entering in problem descriptions, attempting to solve the issue in a set period of time and promotion of Automated Technical Services such as CompuServe, MSN, www/ftp, FactsLine and our InfoBase CD ROM.