PROFESSIONAL SUMMARY:

• Expert data architect and enterprise architect looking for full time, hands - on leadership role in data architecture and enterprise architecture.
• Specialist in data modeling and database design, both operational (OLTP) and analytical (OLAP) systems.
• Expert in requirements gathering, analysis, and design, single system and enterprise.
• Have designed, developed, integrated and deployed software systems many times over, with a proven record of success.
• Experienced with many software development methodologies: Agile, Rational Unified Process (RUP), DevOps.
• Five years of management experience.
• B.S. Computer Science, The Pennsylvania State University.

PROFESSIONAL EXPERIENCE:

Confidential, Philadelphia, PA

Data Architect Consultant

Responsibilities:

• Designed and implemented data warehouse databases - staging database, historical operational data store, and star schema presentation database - in the health assessments subject area. Implemented a common pattern for multi-source, historical dimensions, presenting both data source values and conformed reporting values.
• Wrote functional specifications and source to target mappings.

Environment: ERwin, SQL Server, SQL.

Confidential, West Chester, PA

Data Modeler Consultant

Responsibilities:

• Designed and implemented the database for an OLTP product management system.

Environment: ERwin, SQL Server, SQL.

Confidential, Philadelphia, PA

Data Architect Consultant

Responsibilities:

• Designed and implemented staging and dimensional databases for reporting, business intelligence, and adhoc analytics. Subject area was prescription claims.
• Implemented security views to provide external client access to their own data (database tables are multi-tenant). Designed and managed user security groups.

Environment: ERwin, Netezza, SQL.

Confidential, Wilmington, DE

Data Modeler Consultant

Responsibilities:

• Developed and implemented dimensional models for the enterprise data warehouse, in the subject areas of bank account transactions, and marketing campaigns.
• Wrote functional specifications and mapping documents for ETL programming.

Environment: ERwin, Oracle, SQL.

Confidential, West Chester, PA

Data Modeler Consultant

Responsibilities:

• Developed normalized logical and physical data models for supply chain system enhancements. Developed dimensional models for the enterprise data warehouse.

Environment: PowerDesigner, Oracle, DB2, SQL.

Confidential, Wayne, PA

Data Architect Consultant

Responsibilities:

• Developed the physical data models for four databases comprising a system for gathering, analyzing and making recommendations about prescriptions.

Environment: ERwin, Oracle, SQL.

Confidential, Norristown, PA

Data Architect Consultant

Responsibilities:

• Designed the normalized data structure for storing the historical record of electric grid equipment changes over time. This data model was compliant with a global industry standard, and was implemented in multiple Confidential databases.
• Designed a slowly-changing electric grid equipment dimension, used by many data warehouse facts. Specified the functionality for maintaining this dimension.
• Designed numerous electric grid facts, such as alarms, and load snapshots.
• Designed a normalized OLTP database for a custom rules-based system which included the following subject areas: electric grid equipment, rules-based operational procedures, and grid events triggered by the rules.
• Implemented the same data model as an object model in the rules engine (Tibco).
• Designed the messages between the subsystems (the rule-builder UI, the rules engine, and the dispatcher UI) in the form of XSD’s.
• Performed message design for systems communicating over an Enterprise Service Bus.
• Wrote test plans, tested, managed defects, and designed resolutions.

Environment: PowerDesigner, Oracle, SQL, PL/SQL, XMLSpy, XML.

Confidential, Philadelphia, PA

Data Warehouse Architect Consultant

Responsibilities:

• Developed a data warehouse combining subject areas of crime, child welfare, juvenile justice, shelter, and attendance in various programs throughout the City of Philadelphia.
• Gathered and documented all business requirements.
• Designed the overall architecture of staging and presentation databases.
• Specified the ETL functionality.
• Defined the data structure in the Cognos reporting tool.
• Wrote test cases and performed quality assurance testing.
• Developed and conducted user training courses.

Environment: ERwin, SQL Server, SQL, T-SQL, SSIS, Cognos.

Confidential, Plymouth Meeting, PA

Information Systems Architect

Responsibilities:

• Designed the integration between IKEA’s legacy systems and a purchased warehouse management system. Specified all interfaces. Specified database changes, programming changes, and new programming. Oversaw and directed the programming. Completed the project on time in one year. Designed the conversion from the old software to the new software. Installed the software systems at two Confidential warehouses.
• Designed the next generation of IKEA’s warehouse order management system, also integrated with the purchased WMS, using the same interfaces. Gathered requirements and developed the functional specifications. Functional requirements included store replenishment business rules, planned (not coincidental) cross-docking, integration with two different customer order systems, customer order fulfillment, integration with the WMS, and integration with a traffic management system. Developed the normalized data model and database design. Negotiated and wrote all interface specifications. Performed code reviews. Provided quality assurance. Directed the work of the technical lead and six software engineers.
• Designed the conversion from the legacy systems to the new order management system. Led the deployment team. Successfully deployed in a warehouse operating 24 X 7, with 24 hours of downtime. Customer satisfaction was high, and deployment proceeded in six other warehouses.
• Designed each new release of the software, preparing data models, functional specifications, and test cases.
• Documented the overall Confidential North America system landscape (enterprise architecture) of systems and interfaces. Designed the future landscape. Began the conversion.

Environment: Oracle Designer, Rational Rose, Oracle, SQL.

Confidential, Newtown Square, PA

Senior Systems Engineer

Responsibilities:

• Developed the logical and physical data models for Confidential ’s internet advertising databases, consisting of a normalized model for operations and a dimensional model for reporting. Wrote functional specifications. Performed quality assurance testing.

Environment: ERwin, Visio, Oracle, SQL.

Confidential, Malvern, PA

Senior Advisory Software Engineer

Responsibilities:

• Designed the integration between Confidential ’s ERP system and external supply chain planning software packages. Developed data models and functional specifications for enhancements to Confidential ’s ERP software.

Environment: Oracle Designer, Visio, Oracle, SQL Server, SQL.

Confidential, West Chester, PA

Data Administrator

Responsibilities:

• Developed project-specific data models and designed the resulting project databases.
• Designed denormalized star schemas implemented in the corporate data warehouse.

Environment: System Architect, Oracle, SQL Server, SQL.