OBJECTIVE:

A challenging technically oriented position in which I can use my education, experience, and skills to be a value adding member of a team in pursuit of the best possible solution(s) to business problems.

SUMMARY:

• Data Architect with 20+ years experience in following: data modelling, business analysis, data - driven systems design, process modelling, and methodology driven software development through Joint Application Design sessions with the use of CASE tools
• 13 years, Model Manager: 7.5 years, Oracle Designer: 1.5 years, Bachman: 2.5 years), and databases DB2, UDB, Oracle, and SQL Server.
• Proven team oriented, short and long range thinker indicated in the quality solutions provided on all assigned projects.
• Demonstrated commitment to delivering a quality product by providing thorough documentation of the meta-data of the system projects assigned in the appropriate repository.
• Have used Datacom Data Dictionary repository: 3 years.
• Excellent communication, presentation, project management, and facilitation skills.
• Agile methodology trained, knowledgeable about service oriented architecture and object oriented design.

SKILLS AND ABILITIES:

• Excellent PC knowledge and skills
• Installed and trouble shot hardware items with PC Tools, Norton Utilities, and DOS utilities while in Air Force
• Knowledgeware's Application Development Workstation, WordPerfect, MS Word, MS Powerpoint, MS Excel, Lotus 123, Quattro Pro, XTree, Ventura Publisher, Corel Draw, DrawPerfect, Windows, DOS, OS/2, Stacker
• Experienced user of Oracle’s Designer 2000 CASE Tool
• Excellent understanding of and experience using LBMS Methodology
• Excellent understanding and experience in data modeling
• Above average understanding and experience in process modeling
• Above average understanding of and experience using Business Area Analysis
• Above average understanding of and experience using Business Analysis Techniques
• Above average understanding of the logical-physical design of databases
• Basic understanding of designing graphical user interfaces
• Experience with the following programming languages: Pascal, COBOL
• Experience in budgeting and forecasting as RRRP Manager
• Experience with Lotus Notes

STRENGTHS:

• Teamwork Oriented
• Positive Attitude
• Hardworking
• Long & Short Range Thinker
• Objectivity
• Flexibility
• Dedication
• Organizational Skills
• Analytical Skills
• Leadership Skills
• Quick absorption of concepts

TECHNICAL SKILLS:

• Fast Track to Sybase
• SQL Programming
• SQL Windows
• New Programmer Training
• Basic JCL
• Advanced JCL
• Oracle Advanced SQL & SQL Plus
• Oracle Develop Data Models & Design Databases
• Oracle Developer/2000 Forms I
• SAP MDM100 - Master Data Management

PROFESSIONAL EXPERIENCE:

Confidential, Jacksonville, Florida

Data Architect

Responsibilities:

• Performed data analysis, interviews, and led jad sessions to document existing system structures and to enhance current security system without breaking the existing security system structures in Object Star, Oracle, SQL Server, UDB and DB2.
• Contributed to the architecting of XML Schemas on all projects.
• Designed modifications to Guidewire Claim Center Claims system which is an object oriented design.

Confidential, Milwaukee, Wisconsin

Contractor Data Architect

Responsibilities:

• Performed data analysis, interviews, and led jad sessions to document existing system structures and to enhance current security system without breaking the existing security system structures in Oracle.

Confidential, Milwaukee, Wisconsin

Senior Systems Analyst—Dimensional Modeler

Responsibilities:

• Performed data analysis, interviews, and led jad sessions to document existing system structures in DB2, Oracle, and SQL Server and to add structures as necessary to ensure the data requirements were met.

Confidential, Des Moines, Iowa

Contractor Data Analyst

Responsibilities:

• Performed data analysis and interviews to validate and assess the quality of the data for further analysis by the data architect.

Confidential, St Louis, Missouri

Contractor Data Architect

Responsibilities:

• performed data analysis, interviews, and led jad sessions to document existing system structures and to enhance current security system without breaking the existing security system structures in SQL Server and DB2.

Confidential, Overland Park, Kansas

Senior Consultant, Data Architect

Responsibilities:

• documented the operational system through analysis of the system data, interviews with SST employees, review of existing documentation, and review of pseudo code.
• Mapped system columns to the Metro2 credit bureau reporting file fields.

Confidential, Alton, Illinois

Contractor Business Data Analyst

Responsibilities:

• perform data analysis of cleansing requests, create cleansing specifications document for development team, analyze and design new information requirements for inclusion in the data warehouse, create Cognos Impromptu reports to verify that cleansing task was performed properly.

Confidential, Overland Park, Kansas

Contractor Senior Data Analyst

Responsibilities:

• performed data analysis and data modeling and documented business requirements for assigned projects, created the first cut physical design of the database, generated the data definition language for the structures to be implemented in the database, documented the mappings from the data sources to the data warehouse structures.

Confidential, Alton, Illinois

Contractor Business Data Analyst

Responsibilities:

• Perform data analysis of cleansing requests, create cleansing specifications document for development team, analyze and design new information requirements for inclusion in the data warehouse, create Cognos Impromptu reports to verify that cleansing task was performed properly.

Confidential, Kansas City, Missouri

Database Analyst

Responsibilities:

• designed the table structures in Oracle for Retail Data Mart that replaced a MCIF DOS system developed data modeling standards for information technology department, contributed to start of development methodology, developed Data Stage jobs to load a star schema, developed data models for assigned projects designed and developed Data Stage jobs for 1.5 years; nearly 5 years experience with data warehousing data structures; managed and studied the implementation of the test Model Manager for Confidential ; was the only data modeler for the entire organization covering commercial and retail banking systems.

Confidential, Overland Park, Kansas

Senior Data Architect

Responsibilities:

• Designed the table structures in SQL Server for all Networx system enhancements resulting in better data quality which enabled senior management to make better business decisions; assisted in the design of the Networx data mart in Oracle
• Assisted in the design of the new Contracts system in Oracle; began revamping contracts design in Networx; 6 months experience with data warehousing data structures in Oracle.

Confidential, Kansas City, Missouri

Data Analyst

Responsibilities:

• Designed the database in UDB (DB2/2 at the time) for the new Voice Response System resulting in a more easily managed system; designed the conversion tables in DB2 for the Kemper Mutual Fund System; maintained the Datacom Data Dictionary Repository; nearly 3 years experience with Confidential 's Data Management Methodology
• Additional nearly 3 years experience with ADW (renamed Key) Case tool; nearly 3 years experience with Bachman Case tool; 6 months experience with data warehousing data structures; 1 years experience with object oriented techniques in conjunction with data management best practices.