Project Manager Data
Resume:
George N. L. Swan, CCP, CBIP, CDMP
**** **** ******** *****, *** N3 E-mail: *****@*********.***
Lakeland, FL 33803-3456 Mobile: 863-***-****
CAREER OBJECTIVE PROJECT ROLES
Ø
I am pursuing a full-time permanent expert-level Application Designer/Developer
Ø
position within the business intelligence or data Business Analyst
Ø
warehouse domain. I would like to be part of an Business Executive
Ø
organization that provides the environment and tools Curriculum Developer
Ø
necessary to enable individual success, in a position Data Analyst/Architect
Ø
that is challenging and enables professional growth. Data Warehouse/Technical Architect
Ø ETL Architect/Developer
Ø
SUMMARY OF QUALIFICATIONS Project Manager/Technical Lead
INDUSTRIES
I have over twenty-five years experience in software
disciplines of the IT industry involving almost all
Ø
aspects of the development lifecycle. Financial Services (Banking, Insurance, Securities)
Ø Healthcare (Payer, Pharmaceuticals, Provider)
Ø
My key strengths include Business Requirement Hospitality and Interval Ownership Sales
Ø
Definition, Information Modeling, Project Leadership, Manufacturing
Ø
Systems Analysis and Design, Team Development, Telecommunications
Ø
Technical Training and Mentoring, and Full Lifecycle Transportation
Ø
Implementation using Structured Methodologies. Wholesale Distribution and Retail Sales
PROFESSIONAL CREDENTIALS (Current through 2012)
I have over fifteen years experience with the design
and implementation of Data Warehouse and Business
Ø Certified Computing Professional (CCP), Institute for
Intelligence solutions. I am familiar with various
modeling, ETL, OLAP, and query tools and have the Certification of Computing Professionals (ICCP)
Ø Certified Business Intelligence Professional (CBIP),
worked with most of the databases commonly used in
BI implementations. The Data Warehousing Institute (TDWI) in
cooperation with ICCP
Ø Certified Data Management Professional (CDMP),
My highly developed facilitation and interviewing skills
have resulted in the development of effective business The Data Management Association International
and technical requirements. My knowledge and use of (DAMA) in cooperation with ICCP
Certification Specialties
JAD and JAR sessions have greatly reduced the time
• IT Management (Formerly CDP), Initial
and expense necessary to establish successful
application, process, and workflow designs. My over certification - 1984
• Systems Development (Formerly CSP), Initial
two decades of database design experience has
enabled me to provide appropriate, extensible, and cost certification – 1985
• Data Warehousing (Mastery Level), Initial
effective solutions. My focused approach to team
leadership has ensured that projects are delivered on certification - 2004
• Data Management (Mastery Level), Initial
time, within budget, and to specification.
certification – 2009
Languages Operating Platforms Applications
Systems/Databases
COBOL DB2 AlphaMicro/Fujitsu (Pick) Cognos PowerPlay (data analysis tool)
Pick DataBasic HP-UX General Automation (Pick) Cognos Impromptu (SQL tool)
SQL Informix HP (HP-UX/UniData) ERwin Data Modeling tool
MS SQL Server IBM RS6000 (AIX/PickBlue) Informatica PowerCenter (ETL tool)
MS Windows McDonnell Douglas/Microdata Innovative Systems’ Data Quality Suite
Oracle (Pick) MS Office (including Access)
Pick Sequoia (Topix/Pick) MS Project
Sun Solaris Sun MS SQL Server SSIS (ETL Tool)
Teradata Various PC Models Summit Ascendant (Methodology tool)
UniData (DOS/Windows/Pick) SQL*Plus (Oracle SQL tool)
Page 1 of 4
George N. L. Swan, CCP, CBIP, CDMP
Work Experience:
Hewlett-Packard (Information Management Practice, formerly Knightsbridge)
Information Systems Architect Jul 05 to May 08
Ø Project Roles: Data Architect, Project Manager, Technical Architect
Ø Industries: Financial Services, Healthcare, Hospitality, Publishing
Ø Technologies: ERwin Data Modeler (v4 & v7), Informatica PowerCenter (v7), MS Office 2003, MS
Project 2003, Oracle (v8i & v10g), SQL Server 2000
Ø Accomplishments: Created conformed dimension standards for data warehouse projects.
Established data object naming standards data warehouse design best practices for data warehouse
initiatives. Analyzed existing business requirements and developed logical data models for data
warehouses and data marts. Conducted data, technical, and development process evaluations for
data warehouse strategy engagements. Enhanced HP/Knightsbridge’s data warehousing SDLC
methodology.
RCG Information Technology, Inc.
Senior Manager, Business Intelligence Practice Mar 04 to Jan 05
Ø Project Roles: BI Practice Leader, Consultant, Data Architect, Data Warehouse Architect, Project
Manager, Team Leader
Ø Industries: Retail, Telecommunications, Transportation
Ø Technologies: COBOL, DB2, ERwin Data Modeler (v4), MS Office 2000, MS Project 2000, MS SQL
Server 7, Teradata (v10)
Ø Accomplishments: Managed RCG’s Business Intelligence Practice for the Florida region.
Conducted mini-assessments to uncover prospective client’s high level data warehouse needs.
Conducted analysis on candidate data sources, created logical data models and ETL source to target
mappings. Provided technical input and leadership to assessment engagements.
Freelance Consultant Jan 04 to Mar 04
Ø Project Roles: Test Item Developer
Ø Industries: Professional Certification
Ø Technologies: MS Office 2000
Ø Accomplishments: Worked with the ICCP to develop the initial set of questions for their data
warehousing certification exam. This exam has been adopted by The Data Warehousing Institute as
a prerequisite for their Certified Business Intelligence Professional certification.
CIBER, Inc. (Custom Solutions Group)
Principal Consultant, Business Intelligence Practice Feb 02 to Dec 03
Ø Project Roles: Consultant, Data Architect, Data Warehouse Architect, ETL Architect, ETL Developer,
Project Manager, Team Leader
Ø Industries: Financial Services, Hospitality, Retail
Ø Technologies: Cognos Series 7, ERwin (v3.5), Informatica PowerCenter (v5.2), MS Office 2000, MS
Project 2000, Oracle (v8i), Summit Ascendant SDLC Methodology, Sun Solaris
Ø Accomplishments: Provided leadership and data/technical architectural evaluations for data
warehouse assessments. Developed conceptual, logical, and dimensional models for business
intelligence solutions. Architected, managed, and developed data warehouse solutions. Enhanced
CIBER’s Data Warehouse SDLC Methodology.
Page 2 of 4
George N. L. Swan, CCP, CBIP, CDMP
Marriott International, Inc. (Marriott Vacation Club International)
Senior Director, Strategic Applications Jan 01 to Feb 02
Ø Project Roles: Business Executive, Data Architect, Data Warehouse Architect, ETL Architect, ETL
Developer
Ø Industries: Hospitality
Ø Technologies: Cognos Series 7, ERwin (v3.5), Informatica PowerCenter (v5.1), Informix (v7), MS
Office 97, MS Project 97, Oracle (v8i)
Ø Accomplishments: Provided executive oversight for MVCI’s data warehouse and web development
teams. Exercised management responsibility over a combined budget of over $3 million and staff of
20 resources (internal and external). Assessed the environment and developed a renovation plan for
the current data warehouse. Developed data marts. Implemented Informatica and established a
comprehensive training program for both the tool and basic data warehousing concepts.
Knowledge Partners, Inc.
Senior Consultant, Information Architecture Apr 00 to Dec 00
Ø Project Roles: Consultant, Curriculum Developer, Data Architect, Project Manager
Ø Industries: Financial Services, Hospitality
Ø Technologies: DB2, ERwin Data Modeler (v3.5), HP-UX, Informatica PowerCenter (v5.1), MS Office
97, MS Project 97, Oracle (v8i)
Ø Accomplishments: Architected data structures and transf ormation/load specifications for data
warehouse initiatives. Led the implementation phase of a multi-tier data warehouse. Conducted an
initial data quality/ETL assessment and developed the on-going load cycle validation process for a
data warehouse initiative. Developed modules for a data modeling course.
CIBER, Inc. (Custom Solutions Group)
Senior Consultant, Information Architecture Aug 98 to Apr 00
Ø Project Roles: Consultant, Curriculum Developer, Data Architect, Data Warehouse Architect, ETL
Architect, Project Manager
Ø Industries: Financial Services, Hospitality, Transportation
Ø Technologies: ERwin (v3.5), MS Courseware, MS Office 97, MS Project 4, Oracle (v8i)
Ø Accomplishments: Authored the Gathering Business Requirements and Data Warehouse/Data Mart
Design modules for Microsoft’s Data Warehousing using SQL Server 7 course. Assessed data
warehouse architectures and developed plans for their remediation. Analyzed source systems,
designed target databases, and developed the transformation rules for data warehouse initiatives.
Managed the business analysis, information architecture, middleware selection, and ETL
development components of data warehouse initiatives.
Innovative Systems, Inc.
Principal Consultant Jan 97 to Aug 98
Ø Project Roles: Consultant, Data Architect, Data Quality Architect, Data Warehouse Architect
Ø Industries: Financial Services, Telecommunications
Ø Technologies: COBOL, DB2, MS Office 97, Innovative Systems’ CDI and Data Quality tool suite
Ø Accomplishments: Designed the data quality and clienting processes for data warehouse and
customer information system initiatives. Architected an implementation approach for the Innovative
tool suite that enables high-frequency data loads. Developed the design specifications for a product
that v alidates non-customer data types and a clienting/householding product which is capable of
processing incremental transactions in real-time.
Page 3 of 4
George N. L. Swan, CCP, CBIP, CDMP
Marriott International, Inc. (Marriott Vacation Club International)
Director, Database Operations for Sales and Marketing Feb 94 to Jan 97
Ø Project Roles: Data Analyst, Technical Architect
Ø Industries: Hospitality
Ø Technologies: Cognos Impromptu (v 3), Cognos PowerPlay (v4), ERwin Data Modeler (v3.5), HP-
UX, Informix (v5), Innovative Systems’ CDI and Data Quality tool suite, MS Office 4, MS Project 4
Ø Accomplishments: Developed functional specifications, data models, and design documentation for
various initiatives within the Sales and Marketing Department. Designed and directed the
implementation of a customer contact information positive control process. Managed the design and
development of a customer information system (CIS). Established and managed a centralized in-
house direct mail list fulfillment operation. Researched, evaluated, selected, and installed software
and hardware for specialized internal projects.
Swan Consulting, Inc.
President and Principal Consultant Jul 85 to Feb 94
Ø Project Roles: Business Analyst, Business Executive, Consultant, Data Analyst, Programmer, Team
Leader
Ø Industries: Hospitality, Manufacturing, Retail, Wholesale Distribution
Ø Technologies: MS Project 4, Pick, UniData, Topix
Ø Accomplishments: Complete life-cycle involvement in the implementation of software applications.
Provided project leadership for multi-vendor software development efforts utilizing traditional
structured methodologies. Designed, developed, and implemented a 4GL applications development
environment for the Pick operating system. Recommended, procured, and installed computers,
peripherals, and site wiring. Generated high quality process and project documentation,
correspondence, proposal presentation materials, and fiscal planning documentation. Directed a
successful consulting firm that developed and implemented database solutions for business
applications, and provided support for selected third-party software modules.
Tingley Systems, Inc.
Senior Systems Analyst Sep 84 to Jun 85
Ø Project Roles: Business Analyst, Consultant, Data Analyst, Programmer
Ø Industries: Healthcare
Ø Technologies: Pick
Ø Accomplishments: Complete life-cycle involvement in the implementation of medical insurance
billing and patient tracking applications using the Pick operating system. Designed, developed, and
implemented a code generator for data entry screens.
Augmented Computer Technologies, Inc.
Director of Application Development and Support Jan 82 to Sep 84
Ø Project Roles: Business Analyst, Consultant, Data Analyst, Programmer, Team Leader
Ø Industries: Hospitality, Manufacturing, Retail, Wholesale Distribution
Ø Technologies: COBOL, Pick
Ø Accomplishments: Directed all facets of Augmented’s software development, installation, and
customer support activities. Designed, developed, and implemented a multi-location electronic mail
module. Re-engineered Augmented’s mainstay application, a warehouse distribution and financial
accounting system. Implemented a comprehensive configuration and version control process.
Provided product support for 20 customers using Augmented’s various business applications.
Developed an automated process to convert an IBM mainframe dataset to a Pick database.
Page 4 of 4
Contact this candidate