SUMMARY:

• I am an experienced Enterprise Information Architect, Data Architect, Data Warehouse Architect, Data Quality Analyst, Business Analyst, Database Administrator, Data Modeler, Process Modeler, BI Developer, ETL Developer, and Project Manager with over 30 years of experience. I have enclosed my resume as a first step in exploring the possibilities of employment.
• Four more recent experiences include developing mappings and workflows in a Data Warehouse environment, performing Data Warehouse and Data Quality health checks, designing and implementing data reprocessing of incorrect transactional records, designing and implementing of quality measures, and identifying and constructing the information flows from Operational applications to ODS and Data Warehouse data structures and processes including Staging, Certification and Launching using the Informatica suite of tools (Power Connect, Power Exchange, Power Center, Power Analyzer).
• I bring a focus on communication and quality to all aspects of the information development life cycle.
• Confidential has thirty - four years of progressive IS experience primarily in relational IBM DB2/UDB, SQL Server, Oracle, and Sybase environments. He is especially proficient as an Enterprise Information Architect, a Data Architect, a Data Quality Analyst, a Data Warehouse Architect, and a Project Manager or as a Business Process Improvement Analyst.
• He has served in many IS functions including Enterprise Information Architect (Data and Process), Project Manager, Database Administrator (DBA), Data Quality Analyst and ETL and BI Developer.
• Further qualifications include extensive experience in Insurance, Investments, Retail Credit, Banking, Manufacturing and Analytical Laboratory industries.
• He is a Certified Practitioner of Inventory Management (CPIM) in a closed looped manufacturing environment and has participated in numerous MRP, MRP II, CDI, MDM, SCM, CRM, SFA, ERP and Data Warehousing initiatives.
• Confidential has excellent interview skills, is a strong team player, and has proven communication skills, providing him with the ability to effectively work and communicate with a variety of audiences.

TECHNICAL SKILLS:

Database: DATACOM, DB2 (UDB), SQL, IMS, IDMS, SYBASE, PROGRESS, ORACLE, TERADATA

Design and development: INFA POWER CONNECT, INFA POWER CENTER, SYBASE POWER DESIGNER, METADATA MANAGER, DATA ARCHITECT, POWER DESIGNER PROCESS ANALYST, SYSTEM ARCHITECT, ERWIN, COOLGEN, COMPOSER, IEF, ADW, IEW, EXCELERATOR, PL SQL, SQL, COBOL II, MICROFOCUS COBOL, RPG, PL1, FORTRAN

Reporting: SAS EG, INFA POWER ANALYZER, BUSINESS OBJECTS, DISCOVERER, EZTRIEVE, WEB FOCUS, CRYSTAL

Application: MAC PAC, FIN PAC, COPICS, MAPICS, MSA, AMAPS, CINCOM, CULLINET, FOURTH SHIFT, HOGAN, BANKPRO, CAMS, SHAW

Content development: Microsoft Word (Windows), WordPerfect

Graphics: Microsoft PowerPoint, Lotus Freelance, Visio

Project management: Microsoft Excel, Microsoft Access, Microsoft Project

Communication: Microsoft Outlook, Microsoft Mail, Lotus Notes, TAO

Web & Connectivity: Netscape, Internet Explorer

PROJECT EXPERIENCE:

Data Architect

Confidential

Responsibilities:

• responsible in part for the 3NF model for the go forward Aviation Data Warehouse and the semantic or consumption layers using the Teradata mLDM and MDM practices.. responsible in part for the completeness of the Source Inventories and the mappings to the new models.
• Responsible for the designing of a Data Quality Management set of rules and measures based on the content of the incoming source data.

ETL Lead

Confidential

Responsibilities:

• created the 1st Informatica development group to support Power Center, Power Exchange, Informatica Data Quality and Data Explorer, SAP and SFA adaptors, etc.
• Duties included hiring, training, work direction and planning for multiple $1 million dollar efforts.

Data Architect

Confidential

Responsibilities:

• developed a go forward 3NF Data Model to accommodate multiple serviced Clients.
• Worked with sister companies to develop data models to meet their client’s needs.

ETL Developer

Confidential

Responsibilities:

• Developed the movement of Health Coach Information to the Data Warehouse.
• This included the movement of source into warehouse data, audit and control table structures for process control.

Information Architect / ETL Developer

Confidential

Responsibilities:

• Designed and developed the movement of external supplier invoice data from a web-based source application to the client secured server to be moved into supporting tables, altered by a workflow application and posted into Confidential .
• This included the movement of source data into warehouse data, audit and control table structures for process control.

Information Architect and ETL Developer

Confidential

Responsibilities:

• Designed, developed and implemented the movement of Reservation, Travel Agent and Property information to and from an external 3rd party vendor for payment of fees. This included the creation of normalized table structures with control tables for audit ability and monthly financial reporting and reconciliation.
• Designed, developed and implemented the movement of frequent Guest Earning and Award information for a Frequent Guest Program. This included the creation of normalized table structures, dimensional table structures and control tables for process control.

Information Architect, Project Leader

Confidential

Responsibilities:

• Led, designed, consulted and implemented the movement of Advice information from internal and external OLTP applications to ODS applications. This included developing an Abstract data model allowing for disparate external data sources to be certified and stored in a single data structure. Developed a SAS EG reporting process to report and graphically display key performance measures using the abstract model.
• Assisted in developing the “roadmap” of Advice related efforts for the next 8 quarters.
• Performed numerous data quality checks to provide (DB2, VSAM, IMS, UDB)
• An assessment of Data Quality (Reference Data, Data Awareness, Data Values and Ranges, and Metadata)
• A go forward plan for looking for interim, midterm and longer term quality initiatives, benchmarks and costs
• General consultation in ETL, BI and data architecture.

Confidential

Information Architect

Responsibilities:

• Designed, mentored, developed and implemented the movement of information from OLTP applications to ODS applications.
• Helped mentor and develop team members with their skills in logical, physical and dimensional data modeling.
• Helped mentor and develop team members with their skills in Informatica data movement.

Project Manager

Confidential

Responsibilities:

• Identified history and messaging requirements for a conversion to ADP.
• Interviewed, hired and assigned work tasks to team members.
• Maintained the project plan to be consolidated into the program plan.
• Coordinated data inventories from source applications to conversion mappings.

Information Architect and Data Quality Analyst

Confidential

Responsibilities:

• Designed, mentored and implemented the movement of information from OLTP applications to ODS applications and the interaction with a Customer Data Hub. These included normalized table structures that sourced operational data, sent the data to a CDI web service, received the acceptance or rejection of information and updated the operational system.
• Sent and received for reporting Reservation and Stay information to the corporate Teradata EDW.
• Created the standard ETL process (editing, rejection, mapplet creation) for each ODS layer.
• Created the CHW data naming conventions.
• Standardized content for all reference data.
• Maintained WebFocus Master File definitions.

Information Architect

Confidential

Responsibilities:

• Designed, mentored, developed and implemented the movement of information from OLTP applications to ODS applications.
• Helped mentor and develop team members with their skills in logical, physical and dimensional data modeling.
• Assisted in creating the Thrivent data naming conventions.
• Standardized content for all reference data.
• Maintained Power Analyzer semantic layer and Business Objects Universe definitions.
• Designed, developed and implemented the movement of information from OLTP applications to ODS and Data Warehouse applications.
• Helped mentor and develop team members with their skills in logical, physical and dimensional data modeling.
• Maintained Power Analyzer semantic layer and Oracle End User Layer definitions.
• Developed specifications and information flow for a Java based Contact Management application.
• Created control table where new products could be added or new qualifications could be put into place without changing the Java code.
• Created Oracle and Informatica semantic layers for reporting from the mormalized and dimensional table structures.
• Facilitated the Enterprise view of Data, Information and Knowledge including structured and unstructured data types for eventual migration of legacy applications (mainframe and distributed) to an Enterprise Information environment.
• Helped develop data and process design principles and project plans to support the new environment.
• Performed a thorough analysis of the Investments division for data and process improvement opportunities.
• Assisted in the architecture of the front office view for 1400 bank branches.
• Performed requirements gathering, data and process modeling, specification writing, project plan facilitation and testing.

Database Architect and Data Modeler

Confidential

Responsibilities:

• Helped address data model and database concerns regarding insurance product offerings.

Database Administrator and Project Leader

Confidential

Responsibilities:

• Designed and built an application that records the progress of global Analytical Requests throughout their life cycle.
• Performed requirements gathering, logical data modeling, physical data design, table creation, process modeling, data base administration, and project leadership.
• Made extensive use of BLOB tables to support the storing and retrieval of Request findings whether they were text, spreadsheet, drawing, audio, or video.

Information Architect and Project Leader

Confidential

Responsibilities:

• Designed and built a Credit Fraud application resolving Claimant disputes with their accounts that are determined to be fraudulent.
• Performed project chartering and scope, logical data modeling, technical data design, process and procedure creation, navigation development, window development and code generation.

Data and Process Modeler

Confidential

Responsibilities:

• Helped design and build a reporting application that records the details of incidents (crime) against the organization.
• Performed logical data modeling, technical data design and interface development.

Data and Process Modeler

Confidential

Responsibilities:

• Helped deign and build a reporting application that records the details of investigations (potential crime) against the organization.
• Performed logical data modeling and technical data design.

Business Process Consultant

Confidential

Responsibilities:

• Identified and gathered client requirements, developed system specifications, and coordinated client activities including development and support for new product releases.
• Developed process flow requirements across the banking institutions in 13 states.
• Developed test plans, test cases, and development implementation strategy for the project. Consulted in development of Graphical User Interface (GUI) standards.
• Applications developed included Consumer and Commercial Credit Authorizations systems for banking products using Confidential as the scoring and decisioning tool, Consumer and Commercial Deposit systems, and relationship management systems.

Data Base Administrator (DBA)

Confidential

Responsibilities:

• Responsible for installing and fully supporting a Progress relational database.
• Developed and implemented data base standards.
• Developed uniform standards dictated for ISO 9001 certification.
• Developed course curriculum for IS personnel in relational technology. Performed DBA duties regarding usage and performance of the database and its development tools.
• Developed disaster recovery plans across a multi-national organization.
• Helped develop specifications for the procurement and implementation of a Configure to Order (CTO) tool and a Computer Aided Software Engineering (CASE) tool.