Data Architect, ETL DeveloperApr 2006 - Feb 2013 OLP - TelecommunicationsNew York Wayne, NY PA
Design, create and test Logical and Physical data models, as well as prepare, generate, test and implement install scripts (DDL, DML, DCL, TCL) to support the creation of an Enterprise Data warehouse employing Dimensional Data Modeling techniques.
Design of Order Management Subject Area based on Agile Beam Model Storming sessions, analysis of source system, data model review sessions, and Data Profiling results.
Owns development and updates of project artifacts and deliverables such as the Data Model, Data Profiling results, and the Event Matrix.
Employs Agile techniques for collaborative Dimensional Modeling from Requirements to Whiteboard to Star Schema.
Design, create and test Logical and Physical data models, as well as prepare, generate, test and implement install and upgrade scripts (DDL, DML, DCL, TCL) to support product development projects for Business Intelligence Product solutions.
Design, develop and test ETL code to populate STAGE, ODS, Data Marts, and XML files for extraction for a new Reporting Data Warehouse product.
Optimize and help solve SQL solutions for the Business Objects Reporting team for the Data Warehouse.
Design and develop performance test plans, improve ETL performance 50% based on Method R strategy improving customer satisfaction.
Design, code and test PL/SQL packages to support Data Warehouse ETL process.
Provide DBA services.
Data Architect, DBAApr 2004 - Apr 2006 Civic DevelopmentEdison, NJ
Provide day-to-day Oracle DBA services, including DB security (user/role maintenance) Perform database and application tuning, performance monitoring, troubleshooting, and capacity planning.
Design, code and test complex data profiling PL/SQL packages.
Develop Oracle Security techniques including Fine Grain Access Control FGAC and Virtual Private database.
Create and present analysis documents, design, and implementation of ER Diagrams including OLAP, Security, and Work-flow Work Queue data models.
Develop UML diagrams to present an enterprise view of the data, business architecture and the major business processes.
Bachelor of Arts: Mathematics Computer Science1989 King's College Wilkes Barre, PA