John F. Coyle

** ****** ****** 413-***-****

Springfield, MA 01104-1429 ablnuc@r.postjobfree.com

PROFESSIONAL Uniquely qualified, solutions-driven Data Warehouse Architect/Project Manager

and Senior

SUMMARY Oracle Database Administrator with over 20 years success designing and executing high-

availability enterprise data resources in excess of 1 terabyte. Versatile resource for diverse organizations,

including Citizens Financial Group, Blue Cross Blue Shield of Rhode Island, Scripps Networks Interactive, Cigna

Healthcare, Genworth Financial, Yankee Candle Company, Univ. of Massachusetts and the Holstein Association

of America.

Career highlights include leading the design/implementation of numerous business-critical data warehouse

initiatives, maximizing performance, availability, stability and security of data warehouse databases, creating data

marts to support insurance and healthcare providers and building a data warehouse that facilitated over $700M in

annual sales for industry leader Yankee Candle Company.

• Exceptional ability to translate business-driven objectives into sophisticated technology solutions.

• Outstanding project management skills, delivering critical database projects on schedule and within budget

despite intense pressure and aggressive timelines.

• Adept at leveraging cutting-edge technology to increase organization productivity and reduce operating costs.

KEY Cutting-Edge Technology & Design

Strategic Planning

COMPETENCIES Team Building & Leadership

Standardization & Documentation

Electronic Data Storage & Management Requirements & Functions

Technology Cost/Benefit Analysis Data Analysis Quality & Usage

Direct Report Generation Database Upgrades & Maintenance

TECHNICAL Database: Oracle 10g, 9.x, 8.x, Informix 7.x, IDMS

SKILLS Development: Cobol, UNIX Shell Scripting (k-shell, sed, awk), Star Schema, Oracle

Development Environment, Business Objects 5.1, Oracle

Warehouse Builder, Oracle Discover 4.1.x, Lawson ERP 3.x

Platforms: HP9000-G50, HP9000-RP840/N4000, HP-UX 11.x-9.x, Win2000/NT,

IBM 3090, MVS, DEC Alpha, IBM 4381, DOS/VSE

Software: CICS, TSO, VSAM, ICCF, REXX

PROFESSIONAL Informix Certified Database Administrator

CERTIFICATION

PROFESSIONAL Citizens Financial Group, Cranston, RI 06/2010 – 08/2010

EXPERIENCE (through The Computer Merchant, Ltd) 3 months

Data Architect / Data Modeler

Leading financial provider

Principal resource in the design of new Data Warehouse initiative for this major firm.

Key Accomplishments:

• Instrumental in documenting data warehousing environment.

• Identify portions of corporate ODS to be used within the warehouse.

Environment: Oracle 10g, Solaris, ERwin 7.x, DB2

Blue Cross Blue Shield of Rhode Island, Providence, RI 12/2009 – 06/2010

(through Acxius Strategic Consulting) 7 months

Data Architect / Data Modeler

Leading health care provider

Principal resource in the design and implementation of Data Warehouse initiatives for this major firm. Played key

role in designing ETL processes as the organization identified disparate corporate data sources.

Key Accomplishments:

• Instrumental in documenting data warehousing environment.

• Took initiative to identify portions of corporate ODS to be used in the warehouse.

Environment: Oracle 10g, Solaris, ERwin 7.x, DB2, Netezza

Scripps Networks Interactive, Inc., Knoxville, TN 10/2008 – 03/2009

Data Warehouse Database Administrator 6 months

Media and marketing company dominant in the home, food and lifestyle categories

Delivered full support for 3 Oracle 10g Data Warehouses for this well-known company.

Key Accomplishments:

• Major contributor to database redesign process for the largest of the 3 data warehouses, utilizing SQL and

Oracle utilities.

• Identified ODS environment components that would be critical in warehouse model.

• Completely documented the data warehousing environment.

Environment: Oracle 10g, Solaris, Win2000/NT, ERwin 7.x, TOAD, TOAD Data Modeler

John F. Coyle ablnuc@r.postjobfree.com

Specialized Technology Resources Inc., Enfield, CT 02/2008 – 04/2008

Database Administrator 3 months

Global provider of quality assurance testing

Designed, developed and supported MS SQL Server Data Warehouse databases. Provided senior-level support

for Business Objects reporting, dashboarding environment and development team.

Key Accomplishments:

• Continually ensured maximum performance, availability, stability and security of databases.

• Facilitated design and support of ETL processes.

• Thoroughly documented data warehousing environment using MS Word.

• Created a 100-page standards document for new data models.

• Located components in ODS environment that were important for warehouse model.

Environment: MS SQL Server 2005, Win2000/NT, ERwin 7.x

Cigna Healthcare, Bloomfield, CT 03/2006–02/2008

Senior Data Modeler Enterprise Data Architecture Group 2 years

One of nation’s top healthcare providers

Created logical data models for systems development or upgrades. Communicated physical data models to

database administration staff and incorporated all metadata prior to physical implementation.

Key Accomplishments:

• Designed a Member Centric Data Mart for the Clinical Insights Department, a 2-phase project comprised of a

tactical phase (created and loaded for Proof of Concept) and a logistical phase (a data mart with data

warehouse concepts and implementation structures).

• Successfully upgraded pricing/GLSS models using development documentation.

Environment: DB2 UDB, Oracle 10.g, Win2000/NT, Star Schema, ERwin 7.x/4.x, Visio 2003

Genworth Financial, Richmond, VA 02/2005–03/2006

Database Warehouse Architect & Project Manager/Database Developer 1 year

Major provider of insurance products and financial management services

Project lead managing on/offshore staff in design/development of multiple data marts within the data warehouse.

Team used Star Schema approach to enable faster data access for reporting. Supported actuarial, risk and

valuation users with data-related activities.

Key Accomplishments:

• Successfully designed/implemented Group Long Term Care Insurance data mart.

• Replaced legacy data structures with Star Schema data mart, providing updates in real-time instead of

quarterly. Created audit reports using Business Objects.

• Ensured valuation user access privileges within secured environment.

• Converted mainframe SAS process to an Oracle reporting process.

Environment: Oracle 8.x, Sun OS 5.9, K-shell Scripting, Win2000/NT, Star Schema, Informatica

PowerCenter 6.2.1, Business Objects 6.5, ERwin 4.x, Visio 2003, MS Project 2003

Yankee Candle Company, South Deerfield, MA 09/1995 – 02/2005

Corporate Database Administrator/Database Services Team Leader 9+ years

Leading US manufacturer of premium scented candles

Drove the design, deployment, integration and administration of all high-availability enterprise data resources,

including an 8-server/1Tb Oracle database environment and a 150Gb sales/inventory data warehouse.

Spearheaded strategic technology planning, software acquisition, development, deployment and data access

supporting 1500+ users. Supervised Oracle and Informix database administrators and contract staff.

• Headed conversion of 3000-user payroll processing system to a new software suite.

• Supported storage of retail store POS/Internet data and catalog customer files.

Key Accomplishments:

• Standardized the company-wide back-end environment on Oracle, achieving ongoing 99.9% database

availability.

• Successfully designed and implemented a 300Gb sales and inventory data warehouse, data mart and ERP

solutions within the allotted 1-year time schedule, yielding report run times of minutes instead of hours.

Environment: HP9000-RP840/N4000, HP-UX 11.x/10.x, Oracle 9.x-8.x, Informix 7.x, K-shell/sed/awk

Scripting, Win2000/NT, Star Schema, Oracle Warehouse Builder, Oracle Discover 4.1.x, Business Objects

5.1, Lawson ERP

President's Office, Univ. of Massachusetts, Amherst, MA 06/1994 – 09/1995

5-campus land-grant university 1 year

Senior Analyst/Programmer

Page 2 of 3

John F. Coyle ablnuc@r.postjobfree.com

Major contributor to the development and enhancement of Human Resources payroll/benefits system

components supporting over 32,000 employees.

Key Accomplishments:

• Planned and coordinated enhancements to W2 processing.

• Designed/implemented a reduction-in-force business initiative, providing appropriate payouts for 1,000+

employees.

• Developed innovative approach for altering data storage mechanisms within the payroll system, freeing up

substantial disk storage resources.

Environment: IBM 3090, MVS, CICS, TSO, COBOL, VSAM, DEC Alpha, Oracle Development Environment

Holstein Association of America, Brattleboro, VT 05/1989 – 06/1994

Organization tracking the lineage of dairy cattle in the US 5 years

Project Leader

Directed the code conversion of mainframe to UNIX and the migration of an IDMS network database structure to

an Informix relational model.

Key Accomplishments:

• Successful replacement of mainframe process with UNIX system slashed run time from 1 week to 24 hours.

Instrumental in acquiring new high-revenue client.

• Created a Cobol-based bulletin board allowing real-time customer data access, a key element in attracting

200+ new global customers. Received Outstanding Achievement Award.

• Built a PC-based development environment embedded within the mainframe shop, applying PC editors and

Cobol compilers for mainframe coding simulation.

Environment: IBM 4381, DOS/VSE, CICS, ICCF, VSAM, REXX, IDMS, COBOL, HP9000 G50, HP-UX 9.x,

Informix 5.x

EDUCATION Virginia Tech, Blacksburg, VA

M.S., Fisheries and Wildlife Sciences

Page 3 of 3

Contact this candidate