Business Analyst, Project manager, PeopleSoft Developer

JOHN F. COYLE *********@*****.***

Database Administrator 413-***-****

With more than 21 years of experience in Information Technology, I have experience designing and executing high-availability enterprise data resources in excess of 1 terabyte. I also have experience in designing and implementing business-critical data warehouse initiatives, maximizing performance, availability, stability, and security of data warehouse databases, and creating data marts.

Major Strengths:

• Translating business-driven objectives into sophisticated technology solutions

• Creating logical data models for systems development and upgrades

• After user acceptance, create physical data models

• Designing ETL processes

• Ensuring maximum performance, availability, stability, and security of databases

• Database redesign processes for data warehouses utilizing SQL and Oracle utilities

• Documenting data warehousing environments

• Providing support for Business Objects reporting, dashboarding, and development teams

• Delivering critical database projects on schedule and within budget

• Experience in Financial, Insurance, Healthcare, Media, Marketing, and Manufacturing domains

Technical Skills:

Development SQL Server Integration Services (SSIS), PL/SQL scripts, Erwin 4.x-7.x, Star Schema, Oracle Development Environment, Business Objects 5.1, Oracle Warehouse Builder, Oracle Discover 4.1.x, Lawson ERP 3.x, COBOL, and Unix Shell Scripting (k-shell, sed, awk),

Platforms HP9000-G50, HP9000-RP840/N4000, HP-UX 11.x-9.x, MS Windows 2000/NT, IBM 3090, MVS, DEC Alpha, IBM 4381, and MS DOS/VSE

Databases Oracle 10g/9.x/8.x, MS SQL Server 2005, Informix 7.x, and IDMS

Software CICS, TSO, VSAM, ICCF, and REXX

Project Experience:

Citizens Financial Group, Cranston, RI June 2010 to August 2010

Data Warehouse Project

As Data Modeler, involved in the design of the new data warehouse initiative. Responsibilities included:

• Participating in meetings with members of the user community to determine the needed entity structures

• Creating Logical Dimensional Model

• Documenting the new components for user acceptance

• Acquiring user acceptance for the first phase of the Logical Model

• Providing DDL to DBA staff for completion of the Physical Database

• Mapping new data mart components for the ETL staff

Environment: Oracle 10g, Erwin 7.x, PL/SQL scripting, DB2, and Solaris

Blue Cross Blue Shield of Rhode Island, Providence, RI December 2009 to June 2010

Data Warehouse Projects

As Data Modeler, involved in the design and implementation of Data Warehouse initiatives. Responsibilities included:

• Attending stakeholder meetings to acquire entities to include in the new initiatives.

• Documenting the new warehousing environment by utilizing MS Visio, PowerPoint and Erwin

• Identifying portions of the corporate ODS to be utilized by the new data marts

• Mapping disparate data sources for the ETL staff

Environment: Oracle 10g, Erwin 7.x, DB2, Netezza, MS Visio, MS PowerPoint, and Solaris

Scripps Networks Interactive, Inc., Knoxville, TN October 2008 to March 2009

Data Warehouse Support

As Data Warehouse Database Administrator, involved in providing support for 3 Oracle 10g data warehouses. Responsibilities included:

• Participating in the database redesign process for the largest of the 3 data warehouses utilizing stakeholder meetings, SQL and Oracle utilities

• Logical modeling of entity structures were performed prior to the physical implementation

• Identifying the ODS environment components that would be critical in the warehouse model

• Documenting the data warehousing environment

Environment: Oracle 10g, Erwin 7.x, TOAD, Solaris, and MS Windows 2000/NT

Specialized Technology Resources Inc., Enfield, CT February 2008 to April 2008

MS SQL Server Data Warehouse Databases

As Database Administrator, involved in the design, development, and support of MS SQL Server data warehouse databases. Responsibilities included:

• Providing senior-level support for Business Objects reporting, dashboarding environment, and the development team

• Ensuring maximum performance, availability, stability, and security of databases

• Facilitating design and support of ETL processes using SSIS

• Documenting the data warehousing environment using MS Word

• Creating a 100-page standards document for new data models

• Identifying the components that were important for the warehouse model which resided in the ODS environment

Environment: MS SQL Server 2005, SQL Server Integration Services, Erwin 7.x, and MS Windows 2000/NT

Cigna Healthcare, Bloomfield, CT March 2006 to February 2008

Multiple Projects

As Senior Data Modeler - Enterprise Data Architecture Group, involved in various projects. Responsibilities included:

• Creating logical data models for systems development and upgrades

• Incorporate all metadata into the logical model prior to creating the DDL for the physical implementation

• Communicating physical DDL to database administration staff for physical implementation

• Designing a Member Centric data mart for the Clinical Insights Department

• This project was a 2-phase project comprising of a tactical phase and a logical phase

• The tactical phase incorporated creating and loading a Proof of Concept database

• The logistical phase incorporated the creation of a star schema data mart within the corporate data warehouse

• Upgrading pricing/GLSS models using development documentation

Environment: DB2 UDB, Oracle 10.g, Star Schema, Erwin 7.x/4.x, MS Visio 2003, and MS Windows 2000/NT

Genworth Financial, Richmond, VA February 2005 to March 2006

Data Warehouse Project

As Database Warehouse Architect/Project Manager/Database Developer, responsible for the design and development of multiple data marts within the data warehouse. The Star Schema approach was used to enable faster data access for reporting. This project also involved supporting actuarial, risk, and valuation users with data-related activities. Responsibilities included:

• Designing/implementing the Group Long Term Care Insurance data mart

• Replacing legacy data structures with a Star Schema data mart

• Real-time updates were used for the new data mart which replaced a quarterly update system

• Creating audit reports using Business Objects

• Ensuring valuation user access privileges within the secured environment

• Converting the mainframe SAS process to an Oracle reporting process

• Supervised on-shore and off-shore contract staff for development of Business Objects reports

Environment: Oracle 8.x, K-shell Scripting, Star Schema, Informatica PowerCenter 6.2.1, Business Objects 6.5, Erwin 4.x, MS Visio 2003, MS Project 2003, Sun OS 5.9, and MS Windows 2000/NT

Yankee Candle Company, South Deerfield, MA September 1995 to February 2005

Multiple Projects

As Senior Database Administrator/Database Services Team Leader, led a team in the design, deployment, integration, and administration of all high-availability enterprise data resources, including an 8-server/1Tb Oracle database environment and a 150 GB sales/inventory data warehouse. My responsibilities included:

• Designing the sales/inventory data warehouse

• Logical modeling of the data warehouse was created as a star schema with Erwin

• Spearheading strategic technology planning, software acquisition, development, deployment and data access supporting 1500+ users

• Supervising Oracle and Informix database administrators and contract staff

• Heading conversion of the 3000-user payroll processing system to a new software suite

• Supporting storage of the retail store POS/Internet data and catalog customer files

• Standardizing the company-wide back-end environment on Oracle

• Designing and implementing 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: Oracle 9.x-8.x, Informix 7.x, K-shell/sed/awk Scripting, Win2000/NT, , Erwin 4.x, Star Schema, Oracle Warehouse Builder, Oracle Discover 4.1.x, Business Objects 5.1, Lawson ERP, HP9000-RP840/N4000, and HP-UX 11.x/10.x

President's Office, University of Massachusetts, Amherst, MA June 1994 to September 1995

Human Resources Payroll/Benefits System

As Senior Analyst/Programmer, involved in the development and enhancement of Human Resources Payroll/Benefits system components supporting over 32,000 employees. Responsibilities included:

• Planning and coordinating enhancements to W2 processing

• Designing/implementing a reduction-in-force business initiative, providing appropriate payouts for 1,000+ employees

• Developing an innovative approach for altering data storage mechanisms within the payroll system, freeing up substantial disk storage resources

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

Holstein Association of America, Brattleboro, VT May 1989 to June 1994

Multiple Projects

As Project Leader, led a team in various projects, which involved directing the code conversion of mainframe to Unix and the migration of an IDMS network database structure to an Informix relational model. Responsibilities included:

• Replacing the mainframe process with Unix system, slashing run time from 1 week to 24 hours

• Being instrumental in acquiring new high-revenue client

• Creating a COBOL-based bulletin board allowing real-time customer data access, a key element in attracting 200+ new global customers

• Building a PC-based development environment embedded within the mainframe shop, applying PC editors and COBOL compilers for mainframe coding simulation

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

Education:

• Bachelor of Science in Fisheries and Wildlife Sciences, Univ. of Mass., Amherst, MA

o Graduated: Summa Cum Laude

• Master of Science in Fisheries and Wildlife Sciences, Virginia Tech, Blacksburg, VA

Certification / Training:

• Informix Certified Database Administrator

Contact this candidate