CAREER SUMMARY:

• Twenty-seven 27 years experience in business/requirements analysis
• User interviews
• Process, data flow, object schema diagrams, and use cases.
• Defining and writing Requirements Analysis, Database Specifications, Data Dictionaries, User Manuals, Computer Operation Manuals, Maintenance Manuals, SQL Training Manuals, and Testing Procedures conforming to IV V standards
• Twenty-six 26 years experience in database modeling logical and physical relational and object-oriented
• Relational and Object-oriented database methodology and structure
• Defining Naming Conventions/Rules/Standards
• Entity-Relation Diagrams
• Seventeen 17 years experience in Oracle
• Twenty-three 23 years experience as a consultant
• Four 4 years experience in Data Warehouse
• Certified in Inmon's latest methodology, DW 2.0
• Authored three 3 books on Oracle SQL v5.1a, v6.0, v7.0

COMPUTER EXPERIENCE:

• Software: Databases: Oracle v11g, Teradata v13.1, SQL Server 2007, DB2 OS/390 9.0
• Case Tools: Designer 2000 v2.1, S-Designer v6.0, ERWin v8, Embarcadero ER/Studio v9.5, SilverRun
• Microsoft: Windows 8, Windows 7, MS Access, Excel, Word, PowerPoint, Visio, SharePoint
• Miscellaneous: Crystal Reports, Photostudio, Brio/Hyperion 8.3, Toad
• Design Methodologies/Processes: Yourdan, Chen, Martin, Booch-Rumbaugh, IDEF, Inman, Kimball, UML 2.0, RUP, SOA, Agile, SCRUM
• Classes: Compiere ERP software - March 2005
• Teradata - June through August 2006
• DW 2.0 Inmon Data Warehouse Methodology - June 2007
• Hyperion - August 2007
• SilverRun - November 2010

PROFESSIONAL EXPERIENCE:

Confidential Consultant/Database Architect

Responsible for designing new logical databases as well as updating current logical databases owned by the Enterprise Data Management Services using ER/Studio. Work is performed in collaboration with the Business Analysts, Technical Architects, Application Developers, and DBAs. Projects assigned utilize either Waterfall, Reiterative Waterfall, or Agile methodology. Software was DB2 and Oracle.

Responsibilities include:

• Working with Project Managers and Application Developers to understand the business rules and user stories for each project.
• Create or update existing logical database models in the ER/Studio.
• Ability to work on multiple projects concurrently.
• Contract terminating.

Confidential Consultant/Database Architect

• Responsible for assisting with the redesign of a product exceptions database. Responsibilities included:
• Working with the Business Analyst to assimilate old documentation against the current database to define the business requirements into one source document.
• Defining the new requirements and incorporating them into the new logical database model.
• Creating data flow diagrams.
• Writing user stories.
• Performing data analysis against the existing database.
• Project completed.

Confidential Consultant/Database Modeler

• Responsible for creating the Sales Order Data Mart. The data mart was comprised of Customer, Product, Sales Order, Sales Representatives, Credit Representatives, Location, Accounts Receivable Documents, and Dispute Management. The data populating these tables was from SAP extractors.
• Responsiblities included:
• Obtaining the business rules.
• Data analysis of the landing tables from SAP.
• Creating the Data Dictionary for the Sales Order Data Mart.
• Data mapping from SAP, SAP Landing tables, JD Edwards SAP is replacing JD Edwards , and the Enterprise Data Warehouse currently being modeled .
• The project was an Agile/SCRUM environment. New tasks and continued tasks defined during each two week sprint.
• Project completed.

Confidential Consultant/Senior Database Modeler

Responsible for the cleanup, modification, and documentation of the Nike Plus database MSP for which is becoming the center model for the Nike Digital Sports Enterprise Data Model. This database stores data from global Users of the Nike Plus website. Data is synced in via different sports devices, apps, or manually.

Responsibilities included:

• Data modeling.
• Data cleansing.
• Working with the development team and the MSP DBA.
• Writing and maintaining all technical documentation.
• Though considered as an Agile/SCRUM environment, the actual design and development utilized an iterative waterfall methodology. The database was under constant modifications as new requirements are added/changed during each two week sprint.
• Projects included preparing a data migration from an earlier version of the Nike Plus database to the current MSP database, migrating the database model from SQL Modeler to Erwin 7.3, and participating with other teams in Nike Digital Sports concerning the design of an Enterprise Data Model and with the business intelligence teams.
• Project completed.

Confidential - Consultant/Data Analyst/Database Modeler

• Worked with a team to create a next-gen Enterprise Identity and Access Management EIAM project for creating and maintaining international identities requiring access to over twenty-five Intel portals. The primary database is Oracle's OIM and OIA products.
• Responsibilities included:
• As-is and to-be requirements gathering and analysis.
• Creation of data flow diagrams UML from several internal departments.
• Writing use cases.
• Performing data analysis of current databases both internal and external to the EIAM team.
• Data mapping of several data sources to OIM and from OIM to data targets.
• Creating and designing relational conceptual, logical, and physical database models in SilverRun and Visio.
• Writing all corresponding technical/support documentation.
• Working with other team members for defining data cleansing rules and defining data quality monitors.
• Restructuring the team's Sharepoint site and became the owner of several documents for different team groups/members incorporating version control .
• Writing two white papers. One paper discussed best practices in database modeling and the other discussed a database architecture for which I proposed over the current architecture plan.
• Serving as a mentor to new team members.
• Project completed.

Consultant/Defense Contractor/Database Architect/Business Analyst Team Lead - Confidential

Relocated to Colorado

• Clients included the Ballistic Missile Defense Simulation Support Center BMD SSC at the Joint National Test Facility JNTF at Shriever Air Force Base in Colorado Springs, U.S. West telecom , D2K Data Warehouse/ETL software firm , Sprint-Paranet, IGS, Inc. in Boulder, WestMed medical manufacturing , Product Development Corporation, EchoStar/Dish Network, Alpine Access customer service , and Excalibur Associates Federal contractor - security .
• Database and data warehouse types designed during this time were for missile simulation, telecommunications 2 , banking/financial, retail back end database for a sporting goods website, address directory, contracts, product/manufacturing, satellite TV, and Customer Service both Dish Network and Alpine Access - understanding of IVR. ICM, and Avaya.

Responsibilities included:

• Conforming to business or SDLC methodologies.
• Performed business/requirements analysis, created data/process flow diagrams, wrote use cases, as well as worked closely with the client.
• Held weekly internal and external status meetings and performed internal and external walk-thrus to ensure that the data processes captured were correct and to address questions and concerns.
• Defined standardized naming conventions, business rules, and conventions.
• Created the logical and physical design of a relational or objected-oriented database utilizing Oracle's case tool, Designer, Erwin, and Embarcadero.
• Created the indices, constraints, data types, tables, and tablespace sizing.
• Wrote all related documentation including data dictionaries and the detailed database specifications.
• Created test databases as well as wrote testing procedures.
• Data validation and data cleansing.
• Performed quality and user assurance testing when needed.
• Established/adhered to Change Management/Version Control Standards.
• Trained/mentored new team members.

Confidential - Data Sourcing Manager/Data Warehouse Group

• Managed a seven person team to upgrade of the Informatica PowerMart tool from version 3.5 to 4.0.
• Redesigned the mappings and transformations for an enterprise data warehouse and data stores.
• Updated automation of all processes from loading data from Oracle as well as outside load files, completing the transformations, and loading the data into Red Brick via Unix flat files.
• Reason for leaving: Better opportunity which allowed relocation to Colorado.

Consultant/Defense Contractor/Database Architect/Business Analyst Team Lead Confidential

• Clients included several defense and federal contracting firms as well as a few telecommunications firms, such as MCI and WinStar. On most of these contracts, I served as the Team or Project Lead. I managed between four and twenty-two team members.
• Database types designed during this time were for satellite communications defense and telecommunications , the Presidential budget at the C3I level at The Pentagon, financial information for the Department of Education, military relocation, justice information Health and Human Services as well as the intelligence sector , and a redesign of an information database utilized by the Joint Chiefs of Staff during and after Desert Storm. Two of these were VLDBs, consisting of over 2000 tables.
• For all projects:
• Conformed to MCI or DoD SDLC guidelines.
• Performed business/requirements analysis IDEF, process and data flow diagrams, team and one-on-one interviews, etc. and worked closely with the client.
• Held weekly internal and external status meetings and performed internal and external walk-thrus to ensure that the data processes captured were correct and to address questions and concerns.
• Defined standardized naming conventions, business rules, and conventions.
• Created the logical and physical design of a relational or objected-oriented database utilizing Oracle's case tool, Designer, ERWin, or MS Access.
• Created the indices, constraints, data types, tables, and tablespace sizing.
• Wrote all related documentation including data dictionaries and the detailed database specifications.
• Three database projects were a redesign. For these projects:
• Data mapping
• Reformatting of existing data
• Data cleansing/scrubbing
• Data loads using SQL Loader
• Established/adhered to Change Management/Version Control Guidelines per DoD.
• Between June 1994 and August 1994, as a Consultant to the Federal Aviation Administration FAA , I wrote my third book, in class notes style, on Oracle SQL for v7.0 to be used to train FAA Employees.
• Between December 1992 and February 1993, while consulting to Unisys Corporation on a joint military project for the Army at Fort Belvoir, Virginia, I wrote my second book, in class notes style, on Oracle SQL for v6.0 to be used by Unisys Education for their training classes.

Defense Contractor/Database Architect/Business Analyst - Confidential

• Worked for Defense Contracting firms including Syscon, Technology Applications, and Advanced Technology
• Clients included the Navy NAVSEA and NAVAIR , Army RDAISA , Strategic Defense Initiative Organization SDIO , and DISA.
• For all projects:
• Conformed to DoD SDLC guidelines.
• Performed business/requirements analysis IDEF, process and data flow diagrams, team and one-on-one interviews, etc. and worked closely with the client.
• Held weekly internal and external status meetings and performed internal and external walk-thrus to ensure that the data processes captured were correct and to address questions and concerns.
• Defined standardized naming conventions, business rules, and conventions.
• Created the logical and physical design of a relational database.
• Created the indices, data types, tables, and tablespace sizing.
• Wrote all related documentation including data dictionaries and the detailed database specifications.
• For two projects:
• Wrote database testing standards, conforming to IV V standards.
• Wrote database testing procedures.
• Established/adhered to Change Management/Version Control Guidelines per DoD.
• Between August 1990 and December 1990, wrote my first book on Oracle SQL for v5.1 as well as designed and created a corresponding database to the book to offer hands on training to other employees.
• Between May 1989 and July 1989, using a graphics software package, designed and created a computer based training CBT package for the NAVSEA project. This tool allowed the end user to be trained to use the database our team had designed and developed for them. It was installed on their PC and served as a refresher of their classroom training. The tool emulated the database menus and forms as well as the Help and Error messages.