William J Ritchotte II
Manchester, NH 03103
603-860-3331
dbguru@comcast.net	


Senior Database Consultant


Consultant has enjoyed a long and successful career in database centered environments as an expert resource in complex ANSI SQL, TSQL, and PL/SQL in combination with applications and reporting in Access, VB, VB.NET, PHP, ASP, Crystal, DTS, and Business Objects.

Technical Skills:

Hardware: Intel Based Pentium PC’s and Servers, Compaq PCs, HP PCs, and IBM PCs and Servers.

Operating Systems:	MSDOS, DOS, Unix, Linux, MS Windows 2000, XP, 98, 95, 3.1, Server 2000

Programming Languages:	PL/SQL, T-SQL, Transact SQL, Visual Basic (vb) Version(s) 3,4,5,6, and .net (dot net), Visual Basic for Applications, MS Access Basic, Access SQL, ANSI SQL, SQL, MY SQL, UML, HTML, VBScript, and PHP.

Technologies/Tools:	SharePoint, COM, COM+, DAO, ADO, RDO, ODBC, OLTP, OLAP, ActiveX, Active Reports, Microsoft Visual Source Safe, MS-Project, MS-Office, MS Analysis Services, Excel, SQL Loader, SQL Server Agent, Seagate Crystal Reports (11), Cognos 8 Business Intelligence, Hyperion / BRIO Reports, Clear Access, Access Reports, Microsoft Data Access Projects, SQL Query Analyzer, Triggers, Stored Procedures, Alerts and Jobs, Database Modeling and Design, Backup and Restore, DDL, performance and tuning, CRON Jobs, MP3 IV3 Tagging, Total Visual Agent 2000, ASP, Solaris Shell Scripting, TOAD, SQL Navigator, and query optimization.

Concepts: Data warehousing for oracle 9i and 10g – developing data marts, star schemas, design. 

RDBMS: MS-SQL Server 2005/2000/ 7.0/ 6.5, MS-Access 2005/2000/ 97/ 95/ 2.0, Oracle 7/ 8/ 8i/ 9i/ 10g, DB2, MYSQL, and Paradox.


Professional Experience: 
Contracts listed were performed under BJ Gordon & Co:
e-Dialog – Lexington, NH				       8/20/07-Present
Role: Database Programmer
* Programming ETL with PL/SQL for company clients
* Programming ETL using proprietary product DataSync

Liberty Mutual – Portsmouth,NH			  8/28/06-8/17/07
Role: ETL (PL/SQL) Programmer and Senior Technical Resource on PLANIT_RPT Data warehouse.
* Accomplished a portion of Release 2 as part of the PLANIT_RPT Team. Design and unit test ETL programming with PL/SQL.
* Designed the ETL to bring in Daily Time Slices from Clarity to be used to create Fiscal Time Reporting in data warehouse.
* Designing and Testing Hyperion reports. 
* Consultant is a top-level site administrator for SharePoint by Microsoft.
* Performing training and user help desk for SharePoint.
* Writing and executing test plans for upcoming releases of Clarity.
* Ongoing production support of PlanIT Reporting data warehouse and PlanIT Hyperion Reporting


Fallon Community Health Plan-Worcester,MA   5/25/06-8/24/06
Role: ETL (PL/SQL) & Crystal Reports Programmer
Preparing designs for ETL within the Fallon data warehouse for reporting. Create crystal reports and the PL/SQL for it on an ad-hoc basis.
This contract was supposed to go to perm and when the prospect was removed to do so I found another temp-to-perm above.


American Satellite & Entertainment-Concord,NH  3/17/06-5/4/06
Role: TSQL (SQL Server) & VB Script (DTS) Programmer
Worked with Tivo to ensure their web and operational processes are in order.
Coordinating client problems, needs, and priorities with bug tracking software.
Creating automated DTS processes that email, FTP, or both, files to client’s servers.

Scott Plourde’s Speed & Precision Cycles Manchester, NH
Role: Marketing, Tracking, and Reporting Consultant
Created a marketing website that can be indexed and tracked in a MYSQL database. Created reports on tracking figures.

Florida Power and Light @ Seabrook-Seabrook,NH 10/3/05-12/31/05
Role: Oracle 9i PL/SQL Developer, Crystal 11 Developer
Perform pl/sql jobs plus reporting to include, stored packages, stored programs, functions, procedures, and triggers in an implementation of the Sentinel vendor product.
* Completed work on security badge reports for St Lucie and Turkey Point sites. Crystal 11
* Completed report for class schedules by class id. Crystal 9
* Completed pl/sql batch interface from Portacount Respirator Fits database to Sentinel. 
* Completed pl/sql batch interface for PADS database upload from Sentinel
* Completed Health Physics reports for Sentinel Migration to Production.
* Completed ETL processes from the main frame to oracle for the sentinel release

MasterCard International For Blue Cross Blue Shield of Rhode Island - Providence, RI	03/2005 to 09/2005
Role: Oracle 9i PL/SQL Developer / Junior Architect / Jr. DBA tasks
Analyze, design, and implement multiple stored programs, table designs, and advisory help with PEGA Release Project for Blue Cross Blue Shield of Rhode Island
* Completed stored packages, procedures, and functions for Membership.
* Completed stored packages, procedures, and functions for a 3rd party database conversion from files to production data for MACESS as well as procedures to access summary and detail data.
* Completed analysis of data dictionary for Grievance and Appeals Unit (GAU), script to convert old GAU database to new data dictionary, and stored package and procedures to convert and use new data dictionary fields and tables.

First Notice Systems – Boston,MA			9/2004 to 1/30/2005
Consultant performed building of client related web pages within the client’s application software as well as unit testing.
Note: This was a filler contract to keep income flowing and shown here for continuity. 


Lifecycle Business Partners
Salem, NH								11/2002 to 09/2004
Role:	 Financial Reporting and Reporting Programs Consultant 
Developed, coded and implemented in Visual Basic 6 & Dot Net, MS Access 2000, Excel 2000, and VBA (VB6) Lease Disposition Applications, Crystal Reporting Systems, Received Weight, and Daily Received Goods along with the administration of several ERP databases in Sql Server 2000; created several tables, queries, stored procedures, triggers, forms and reports.
* Developed Crystal 8 and MS Access 2000 reporting solutions to bypass inefficient BEST ERP to provide quick financial, inventory, inventory transactions, yearly, quarterly, and monthly sales reports.
* Developed Received Weight Application to identify costs associated with weight and freight.
* Developed Daily Received Goods application to identify the types of goods received on the loading docks to pre-estimate sale probability.
* Developed Raytheon Lease Disposition application to process client returns on leasing contracts and track their progress from entry to resale. Conversions of Excel 2000 tracking system for leases to VB/SQL allowed for ease of use and training as well as reporting in Crystal and Excel 2000.
* Developed more than forty SQL Server Agent jobs to maintain and backup the databases of company ERP.
* Developed open dialog with CEO to identify the necessity of written business systems and policies and procedures as an asset toward growing the business within an overall business plan. Growth, safety, and processes within the business can be described with ease when speaking with potential clients and investors.

Syskoplan Consulting
Woburn, MA							12/12/2003 to 12/31/2003
Role: Crystal Report 9 Consultant 
Using my skills as a SQL Server 2000 programmer/administrator and Crystal Reports 9 programmer to perform conversions of close to thirty asp.net web reports to Crystal 9.

Digital Presence New England
Nashua, NH						07/01/2002 – 11/01/2002
Role:	Project Manager and Principal Database Designer
* Developed an MS Access 2000 database to track individual media, tags, tracking codes and misc. information.
* Developed and administered all information systems for web archiving services.
* Formed alliances with several strategic partners to improve traffic through the increases of bandwidth on the T1 at the web site and our customers’ sites, connect internal IP addresses to their public ones, set name servers, redirect domain names, setup email, manage IIS and Server 2000 for services like FTP and Telnet.
* Developed, at launch, a significant market presence which led to a top 7% ranking in the world 

Contracts below were performed under Rockwall Software:
Rockwall Software
Manchester, NH						12/01/2001 to 07/01/2002
Role:	 Information Systems Consultant
Consultant oversaw the 24/7 DBA responsibilities of all Oracle 8i, 9i, and MS Access databases.
* Developed 100’s of stored procedures, tables, triggers, jobs, sql statements in PL/SQL for the Admin and programming of various databases. 
	
Abbott Labs/Medisense Products
Bedford, MA						01/05/2002 to 03/1/2002
Role: Project application coordinator
* Developed customer insurance tracking software with Visual Basic and Oracle 9 to find an insurance or welfare solution for the purchase of their diabetic insulin-tracking devices. 
* Lead a small teams development and managed another consultant through a process that saved close to $10,000.00 since it’s completion was three weeks ahead of schedule.
* Developed technical and CSR documentation for the CSR personnel to use the finished application.

Au Bon Pain
Boston, MA						01/10/2001 to 11/01/2001
Role: Principal IT Consultant - Catering
Coordinated all related IT and IS processes and procedures for the Catering Department and later developments for the Help Desk; Oracle 6.5, Visual Basic, MS Access 2000, and Crystal 8 were used.
* Provided services for the Catering and Help Desk Departments with responsibility over technical and software assets 24/7.
* Developed admin procedures and improved code performance to reduce down time from daily to bi-monthly.
* Developed a problem tracking software for the Help Desk department to allow better variations of information tracking and reporting.
* Developed technical manuals with policies and procedures for emergencies relating to software and database breakdowns along with manuals for the software that was improved or created.
* Redesigned the Zephyr Catering application to minimize errors, breakdowns, and increase speed.

Argenesis Corporation 
Boston, MA						08/10/2000 to 12/01/2000
Role: Database programmer and SQL script editor
* Developed SQL code to improve the performance and remove bugs from dozens of scripts in the Landmark 2000 program.

American Tower Corporation
Boston, MA						05/01/2000 to 6/30/2000
Role: MS Access 2000 & MS SQL Server 2000 Consultant.
* Developed a set of four wizards for the Acc-Pac accounting system that would generate the general accounting totals for job costing of tower builds throughout the world.

UMASS Medical/Commonwealth Medicine
Shrewsbury, MA						02/12/1999 to 08/15/1999
Role:	 Technical Coordinator of the Disability Emergency Services application. 
* Redesigned and developed the DES application so the number of users could be increased to fifty and so daily problems could be reduced to bi-weekly and then monthly. The application and database were developed in MS Access. 
* Developed a security system in MS Access to protect the system from fraud.
* Wrote user and technical manuals for in house CSR’s and Help Desk personnel.

Previous Contracts Pre-1999
1. FundStation financial reporting with SQL server and Access
2. Creator: Statewide Guaranty Assessment Program for Mass Mutual - access, visual basic, crystal
3. Online Overtime and Attendance Program for John Hancock Advisory Group 
4. Forensic analysis and reconstruction of financial reporting program using visual basic and crystal reporting program for the Merrin Trading system used by Boston Partners Mutual Funds Group
5. (1998) Database analysis of the co-op payments access program for Ocean Spray Cranberries. (Access and SQL)
6. (1997) Recreation of the Serialization 7 program to aid the shop floor program in the shipping department for MKS Instruments. (VB, Access, DB2, SQL, Crystal)
7. (1997) Financial and Risk Management reporting for Liberty Mutual in Portsmouth, NH (ANSI SQL, SQL, Crystal Reports)

Additional Writing Credits:
1. 1991-1995 Wrote business system’s manuals for Venture Environmental Corporation’s janitorial and maintenance staff.
2. 1998 Wrote Y2k remediation manual and remediation manual for the O.A.T.S. Program for principal consultants at John Hancock Advisory Group.
3. 1998 Wrote technical report to explain a fifty-four-query macro and how it worked to determine profit splits with cooperative farmers at Ocean Spray Cranberries.
4. 1997 Provided SQL code descriptions for non-technical personnel on over 300 SQL queries at Liberty Mutual.
5. 2000 Wrote functional specification to manage the maintenance of contracts and rate schedules at Boston Gas

Education:
1. Oracle University
a. Advanced PL/SQL Course I & II (9i & 10g)
b. Data Warehousing (8 & 9i)
c. Enterprise DBA Part 1: Architecture and Administration for Oracle 8 & 8i
d. Introduction to Oracle for Experienced SQL Users PL/SQL and SQL course
2. Visual Basic 4,5,6 courses through WROX and CompUSA
3. Southern NH University
a. Economics and Finance
b. CIS
4. Boone & Young Consulting and Training
a. U.S. government contracting and project admin.
5. Cognos 8 Business Intelligence Course with Lab work.
6. Introduction to data warehousing and data warehousing concepts (oracle)