SUMMARY

• I am an experienced information technology professional with a thorough grounding in business.
• I have over twenty - six years of experience in analysis, design, development, testing, and implementation of complex state-of-the-art business information systems.

TECHNICAL SKILLS

• PowerDesigner
• Siebel 2000
• Siebel Tools
• PL\SQL
• ERwin
• Designer/2000
• SQR
• Business Objects
• Ab - Initio
• DataStage
• COBOL
• OS/JCL
• VSAM
• IMS/DB
• CLISTS
• TSO/ISPF
• Panvalet
• S-Designor
• Visio
• MS Project
• Prism
• SQL
• Sybase
• Teradata
• DB2
• Oracle
• MS SQL Server
• MS/DOS
• Windows
• UNIX
• HP/UX
• IBM/3090
• MVS/XA

PROFESSIONAL EXPERIENCE

Confidential, Des Moines, IA

Systems Architect

Responsibilities:

• Consulted with business partners and technology leaders to identify ways to accelerate the delivery of new services and products to market while meeting company’s risk and cost reduction objectives
• Collaborated with business subject matter experts and architects to convert key strategic objectives in to governable and actionable designs and roadmaps
• Analyzed technology and business challenges, suggested solutions and assessed costs associated with the solutions.
• As a solution architect, led the analysis and design of various data warehousing and business intelligence projects. Worked with business system analysts to gather the requirements, developed the interface and data architectures, developed the lifecycle cost estimation and analysis, and governance
• As a solution architect for Confidential ’s ICD-10 program, developed the roadmap for making Confidential ’s claims subject area in the Enterprise Data Warehouse ICD-10 compliant.
• Developed information delivery standards
• Participated in the technology governance reviews
• Participated in vendor evaluations

Confidential, West Des Moines, IA

Data Warehouse Architect

Responsibilities:

• As an Information Architect, provided technical leadership for multiple data warehousing/data mart projects
• Participated in design reviews

Confidential, Des Moines, IA

Consulting IT Architect

Responsibilities:

• As a Project Architect, led the design, development, and implementation of the Confidential for Confidential ’s Independent Channel.
• Led the migration of the Confidential from a DB2 platform to a Teradata platform.

Confidential, Chicago, IL.

Principal Consultant

Responsibilities:

• As a Data Architect, participated in the design, development and implementation of data warehousing model for a property and casualty insurance company. Analyzed and validated customer information requirements and data sources. Identified alternative and recommended appropriate course of action. Created dimensional models using Erwin based on business requirements. Validated Data Model conformance to customer and systems requirements. Provided Project Manager and Development Leads with time and resources estimates.
• Acted as Project manager for a decision support system (DSS) team for a major bank. Designed the technical architecture for the DSS. Managed a team successfully through the design and implementation of an operational data store. Business Objects was the business intelligence tool, and Informatica was used for the ETL process.
• Acted as a data architect to develop the logical and physical data models for a universal life policy administration. Documented the data dictionary in the corporate repository. Participated in JAD/facilitated sessions with business customers and business analysts to derive data requirements and data design information.

Confidential, Chicago, IL.

Manager, Business Intelligence Services Practice

Responsibilities:

• Acted as project manager for a data warehouse assessment project for a major managed-care organization.
• Evaluated the current state architecture of the organization’s operational and decision support systems and recommended a future state and a roadmap for transformation.
• Team leader for a decision support systems team in a re-engineering project. Developed the architecture to support creation of operational reports and evaluated the feasibility of using Business Objects version 5.1 in the proposed architecture for a major financial services company. Led a facilitated session team to drive out the requirements and assess the technical feasibility of the requirements and reviewing use cases.
• Participated in the development of the architecture for an executive information system for a major automobile manufacturer. Participated in the development of the data model and database design for the executive information system using ERwin. Developed the scripts for generating the tables for an Oracle 8i database. Led a team of developers to test and implement the extraction, transformation, and loading of data into executive information system using Ab-Initio.
• Managed a team of architects that developed the data model for a revenue accounting system as part of a re-engineering project for a major airline.
• As team leader for a Siebel implementation project for a major bank, gathered and reviewed requirements, developed the conceptual and detailed designs, and configured and customized the quote module for Siebel 2000 to meet client’s specifications.

Confidential, Chicago, IL.

Senior Consultant

Responsibilities:

• Participated in the development of the data model and database design of a merchandising promotion system using Designer/2000.
• Mapped data from the legacy systems to the new system. Created Ab-Initio graphs and scripts to extract, transform and load data into tables in an Oracle 8 database.
• Conducted a gap analysis of two reporting systems for a major insurance company, determined the cost associated with closing the gaps, and identified approaches for closing the gaps.
• Managed a team that re-wrote operational reports for a third party claims administrator. The team identified redundancies in the current reporting system and consolidated over two hundred reports to only twenty reports.
• Participated in the development of the data model and database design of a data warehouse for a major insurance carrier using Designer/2000. Developed the scripts needed to create the tables and indexes in the database.
• Managed a team of analysts that developed business intelligence reports using Business Objects for a pharmacy benefits system. Developed and maintained the Business Objects universes.
• Developed Ab-Initio graphs and scripts to extract, transform, and load data from OLTP systems into the data warehouse of a pharmaceutical services company.

Confidential, Chicago, IL.

Project Manager

Responsibilities:

• Architected and managed the development of a strategy to enable existing date oriented system code to process correctly for Year 2000.
• Directed a team of Coopers and Lybrand consultants that performed the year 2000 assessment of the personal insurance unit management information systems.
• Developed the project plan and estimated the resource requirements for the Year 2000 project.
• Directed the merger of two companies’ historical data by extracting, cleansing, translating, and processing the data of the first through the back-end systems of the second.
• This allowed an annual cost reduction of $6M and consolidation of historical data for both companies.
• Directed a team of business analysts that developed business rules for the personal insurance management information systems.
• Managed relationships with vendors: Coopers and Lybrand; Key Resources
• Developed business requirements and specifications for the implementation of a territorial rating decision support system for the actuarial and pricing unit.
• Documented business requirements and participated in development of the data model for a data warehouse using Erwin.
• Developed, modified and maintained application product management efforts.
• Interfaced with and interviewed multiple levels of business personnel and other subject matter experts to develop financial information and processing requirements.
• Developed the requirements, systems specifications and design, unit and systems test plans for various projects. Worked with end-users to develop user acceptance test plans.
• Participated in the enhancement of the customer database.
• Initiated and managed the expense allocation process improvement project that resulted in 90% reduction in data processing costs and cycle time.
• Analyzed the current process to identify the inefficiencies, proposed, developed, and implemented a new process.
• Developed and implemented internal procedures for processing end-user requests.
• Analyzed the feasibility of end-user requests and determined the costs and benefits of such requests.
• Developed and maintained application programs for the life financial system.
• Renovated and tested the programs for the life financial system to make them year 2000 compliant.
• Developed and maintained application programs that evaluated the company’s life insurance business using GAAP and statutory accounting principles.
• Developed selected program modules to implement the DEFRA tax code in the systems that supported the company’s individual and group health products.