THOMAS V. FLAHERTY JR.

617-283-4447

 

I am a talented, experienced IT professional with very strong technical and analytical skills.  I have over 15 years of experience working with industry leading relational database products and more than 10 years of UNIX experience.  I am an ORACLE Certified Professional DBA.

 

STRENGTHS

 

·         Database Design and Implementation

·         Database and SQL Performance Tuning

·         Systems and Infrastructure Architecture

·         Business Analysis

·         Workflow Design

 

EXPERIENCE

2001 - Present: Principal and Founder, Data Warehousing Practice, Birch Hill Technology Group, Brookline, MA.

 

·         Highlights:

·         Plymouth Rock Assurance Company: Member of a team that designed and architected a Business Intelligence system that provides Policy Premium and Claims analysis and reporting to the enterprise.  Directly responsible for physical design and implementation of DB2/UDB8 ODS, Staging, Data Warehouse and Data Mart platforms and databases to support this effort.

·         FleetBoston Financial: Member of a team that designed and architected a Business Intelligence system that provides Customer Risk Assessments to Fleet relationship managers.  Directly responsible for physical design and implementation of three ORACLE9i Data Warehouse databases to support this effort.

·         Southern Skies Entertainment: Designed the workflow and integration of a custom XML-based Enterprise Application Integration (EAI) system for this startup Broadband provider.  This involved 5 different applications, including Ordering, Billing, Provisioning, Customer-Care and Inventory.

·         Conversent Communications: Developed an automated process to support Revenue Assurance initiatives.  Uncovered $48,000/month in supplier overcharges.

·         Conversent Communications: Analyzed the architecture and infrastructure of a telephony order-flow system that was performing poorly.  Presented a comprehensive, prioritized list of infrastructure, database and application improvements, which were subsequently implemented by the client’s in-house staff.

·         Shetland Investments: Completely rebuilt a 1980’s vintage DOS/Btrieve stock market analytics and trading system on Windows2000 Server/Visual Basic/SQLServer 2000.  This was a large and complex system.  All original functionality was rebuilt and significant enhancements were added across all application areas.

·         Shetland Investments:  Upgraded applications environment to SQLServer2005/Windows 2003, migrating all previously built applications and databases, seven years after building them.

 

1994 - 2001: Senior Project Manager, AT&T Broadband (formerly Media One), Lowell, MA.

 

·         Hands-on Project Manager responsible for a number of critical, high-profile development initiatives.

 

·         Highlights:

·         CRM: Enterprise Ticketing Engine: MediaOne's platform for Trouble Management, Call Tracking, Provisioning, and Service Order Management.  Supported their Cable modem and telephony business lines.  Built on the Remedy platform with Oracle.  Managed the team that designed, developed and deployed this system.  Starting from nothing, the team grew the user base to over 4000 users (1500 concurrent), supporting process re-engineering efforts across the enterprise.  Mission critical OLTP environment operating 24x7.  Team of 8, small budget, tactical, very high profile.

·         Data Warehousing: Launched the initial data warehousing initiatives at Media One.  Created processes to feed data from the billing mainframes to user accessible analytical databases that are still in use today.

 

1990 - 1994: Database and Application Engineer, UNIFI Inc. (formerly Fax International), Lowell, MA.

 

·         Ground-floor employee of this start-up business.  Designed the product support architecture for a worldwide fax delivery service.

·         Highlights:

 

·         Designed the databases for Sales, Customer Service, Billing and Document-Delivery.

·         Built Sales and Customer Service applications using ORACLE*Forms, SQL*Reports and SQR.

·         Developed a Billing system, which processed $1M+ in monthly revenue.

·         Integrated the Billing System with numerous internal and 3rd party systems including Vertex, ORACLE Financials and EMIS Empire, and Xerox Document Services.

 

SKILLS/TOOLS

 
  • ORACLE9i: design, implementation, administration, tuning (Oracle Certified DBA)

Extensive experience with Partitioning, Materialized Views and Parallelism

PL/SQL, SQL*Plus, Pro*C

  • DB2/UDB V8.2: design, implementation, administration, tuning

Extensive experience with DB2 Websphere Queue-base Replication (MQ) and Table-Partitioning; extensive DB2 Stored Procedure development.

  • Microsoft SQL Server 2000: implementation, admin, tuning, DTS, stored procedures.
  • UNIX installation, configuration, admin, tuning, Korn shell scripting
  • Perl.  Extensive programming of Perl-database interaction (DBI); CGI development.
  • Multi-dimensional data warehouse design (Ralph Kimball)
  • Power Designer, ERWin, Silver Run CASE Tool (E/R modeling, process flow, database design)
  • Query/reporting tools (Business Objects, IQ Software)
  • System Management Tools (BMC Patrol, ORACLE Enterprise Manager, HP Glance)
  • Remedy ARS Development
  • Quest "Shareplex" ORACLE replication tool
  • Windows 2000 Server, build, install, configure
  • Object Oriented Analysis and Design (Coad/Yourdan)
  • Netscape LDAP directory server admin, development
  • HTML, Javascript, CGI/Perl, Active-Server Pages (ASP)
  • Netscape, Apache Web Servers
  • MapInfo "MapMarker" Geocoding C-API development (ORACLE8 Spatial)
  • Microsoft Project, Access, ODBC, NT, FrontPage, IIS

 

EDUCATION

1987 ‑ Fitchburg State College, Fitchburg, MA

B.S. ‑ Computer Science (Cum Laude)

 

Currently Attending: Boston University, Tyngsboro, MA

Degree Program: M.S. Computer Information Systems (part time)

 

MILITARY

1981-1994: US Army (MA/NH Army National Guard) (Secret Clearance)

1981: US Army/IBM COBOL Development School

1984: Commissioned Officer (2nd Lieutenant) US Army, Field Artillery

1986: Promoted to 1st Lieutenant

1990: Promoted to Captain

1991 - 1994: Field Artillery Battery Commander

 

OTHER

Elected Official: Brookline, NH School Board (2004-2007)

Musician: Drums (20+ years)