|
|
THOMAS V. FLAHERTY JR. www.linkedin.com/in/tomflaherty 617-283-4447 Seasoned IT professional with
very strong technical and analytical skills, specializing in Data
Warehousing. STRENGTHS ·
Logical and Physical Database Design and Implementation ·
Database and SQL Performance Tuning ·
Business Analysis and Modeling ·
Systems and Infrastructure Architecture EXPERIENCE 2001 - Present: Principal and Founder, Data
Warehousing Practice Birch
Hill Technology Group, ·
Highlights: ·
Staples Inc: Supported and led a number of Enterprise
Data Warehouse initiatives including, conversion of Informatica
Data Mart ETL system from flat-file to time-sensitive ODS sourcing; Time
dimension upgrades, Corporate Dashboard feeds, and tuning DB2 ETL Stored
Procedures to use DPF memory more efficiently. ·
Ahold USA (Stop&Shop parent company): Team lead for Data Cleansing, Profiling and Reconciliation effort, as part of a larger
Data Migration to ORACLE’s RMS product suite.
Responsible for overall design and development of Informatica
ETL process to integrate legacy Product, Supplier, and Location data in
ORACLE; then Profile, Cleanse and Match data across 3 separate operating companies,
in support of reconciliation and migration into an Enterprise PIM. ·
State Street Bank: Conducted a 2
month evaluation of State Street’s Fund Accounting Data Warehouse and
Data Mart environment. State Street
required a comprehensive review of these environments, including suggestions
for improvement, to respond to expected data growth and business process
change. ·
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. Also developed a very
complex portion of the ETL process. ·
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:
Analyzed the architecture and infrastructure of a telephony order-flow system
that was performing poorly. Presented a
comprehensive, prioritized list of infrastructure, ORACLE database and
application improvements, which were subsequently implemented by the client’s
in-house staff. ·
Shetland Investments: Upgraded
applications environment to SQLServer2005/Windows 2003, migrating all
previously built applications and databases, seven years after building them. ·
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. 1994 - 2001: Senior Project Manager,
AT&T Broadband (formerly Media One), ·
Hands-on Project Manager responsible for a number of
critical, high-profile development initiatives. ·
Highlights: ·
CRM: ·
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 ·
ORACLE10g: 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/9.5:
implementation, configuration, administration Extensive
DB2 tuning and Stored Procedure development Websphere queue-base Replication (MQ) and
Table-Partitioning. ·
Informatica Power Center 8.5.1: Installation, configuration,
and administration of PowerCenter Server. Design and development
of ETL Mappings, Sessions and Workflows. Experience with Flat-file, ORACLE, DB2 and VSAM sources. ·
Multi-dimensional
Data Warehouse/Data Mart Design (Kimball) ·
ErWin, Power Designer,
Data Modeling tools ·
Perl. Extensive
programming of Perl-database interaction (DBI) with ORACLE, SQL-Server 2000/2005 and DB2 V8.2; CGI development. ·
Query/reporting
tools (Business Objects, IQ Software, Microstrategy) ·
Unix/Linux
installation, configuration, admin, tuning, shell scripting ·
Microsoft SQL
Server 2000: implementation, admin, tuning, DTS, stored procedures. Extensive experience with
SQL-Server 2000 Replication. ·
Microsoft
SQL Server 2005: Installation and configuration. ·
System
Management Tools (BMC Patrol, ORACLE Enterprise Manager, HP Glance) ·
Remedy ARS
Development ·
Quest "Shareplex" ORACLE replication tool ·
HTML, Javascript, CGI/Perl, Active-Server Pages (ASP) ·
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 1990:
Promoted to Captain 1991 - 1994: Field Artillery Battery Commander OTHER Elected Official: Brookline, NH School Board
(2004-2006) Musician: Drums (20+ years) |
|
|
|