SUMMARY:

• Over 30 years of experience in business and government environments as Data Warehouse Architect, Business Intelligence Architect, Business Analyst, Database Administrator, ETL Administrator and Team Leader.
• Excellent writing and communication skills. DOJ Secret clearance.
• Over 30 years of experience in the development of Data Warehouse and Business Intelligence (BI) systems.
• Extensive experience with dimensional modeling and the design of multi - dimensional data warehouses and data marts in very large database environments.
• Extensive experience with Oracle Business Intelligence (OBIEE) supporting end user layers used for analysis, reporting and dashboards.
• Extensive experience with Extract Transformation and Loading (ETL) of data into data warehouses using Informatica, Oracle Data Integrator (ODI), Oracle Warehouse Builder (OWB), Oracle PL/SQL and other tools.
• Over 30 years of experience as an Oracle DBA, database analyst, designer, developer and administrator.
• Over 30 years of experience with data modeling, business analysis, requirements gathering and full life-cycle development methodologies in both traditional waterfall and iterative methodologies associated with Business Intelligence.
• Experience defining use cases and functional decomposition. Ten years of experience with Rapid Application Development (RAD), Joint Application Definition (JAD) and prototyping.
• Experience modeling data ( Confidential and Dimensional) and master data management.

SKILLS:

Databases: Oracle (11g), Progress, SQL-Anywhere, Paradox, DBase and R-Base.

Development Environments: Informatica (Ver 9.5), Oracle Data Integrator (ODI), Oracle Business Intelligence (OBIEE), Oracle Data Warehouse Builder (10g/11g), Oracle Designer, Oracle APEX, J-Developer (Version 10), Oracle Data Mart Suite, Oracle Developer Suite, ERWin (V3.5 to V7), S-Designor (V5.2), Sagent, Data Junction, Information Engineering Workbench (IEW), EasyCase, Excellerator

Languages: SQL, PL/SQL, PowerBuilder (Versions 3.0 - 5.0), Visual Basic (Versions 1.0 - 5.0), Lotus Notes (R1.0 - R4.5), Lotus Script, Progress (Versions 1.0 - 7.0), VB Script, Delphi, HTML, BrioQuery.

Operating Systems: Windows XP, 2000, NT, 95/98, UNIX (AIX, SOLARIS), DOS, OS2, PRIME, VAX, DEC, BTOS

Networks: TCP/IP, SPX, Novell, 3-Com, SQL*Net

EMPLOYMENT:

Confidential

Principal OBIEE Consultant

Responsibilities:

• Responsible for the administration, design and development of Dimensional Models, Oracle Data Warehouse Schemas, ETL processes using Oracle Data Integrator (ODI), OBIEE Repository Administration and OBIEE Dashboard & Reports supporting the Confidential, Tobacco and Firearms Case Management.
• Designed and developed Geographic Information Systems supporting the Bureau’s Enforcement and Inspection Programs in Oracle.
• Integrated the GIS system with OBIEE reporting system. Integrated data from multiple source systems using ODI.

Confidential

Technical Lead

Responsibilities:

• Stood up technical team supporting the Confidential Headquarters Enterprise Management Decision Support system.
• Data Warehouse Architect/Designer/Developer moving data from 18 source systems to Data Warehouse environment.
• Duties included Oracle DBA, Endeca Administrator, Clover ETL Designer/Developer and OBIEE Administrator.
• Contract cancelled by Government.

Confidential

Principal Database Design Engineer

Responsibilities:

• Designer and Developer for Oracle 11g data warehouses and data marts, OBIEE (Oracle Business Intelligence) and Informatica 9.1 (ETL and reporting) systems.
• Supporting the Department of Homeland Security in multiple roles and aspects of building Business Intelligence solutions to integrate multiple financial data sources.
• Strong experience with the requirements of the DATA Act.
• Extensive experience in data modeling of Data Warehouse ( Confidential ) and Dimensional models.
• Experience with Big Data models and architecture. Administered, designed and delivered ETL mappings and workflows in Informatica.
• Administered, designed and delivered OBIEE business and presentation layer designs, reports and dashboards.
• Experience with the Common Government-wide Accounting standards and use in a Business Intelligence environment for Federal Financial reporting.

Confidential

Data Architect / Data Warehouse Architect / ETL Lead & Designer / Database Architect & Administrator

Responsibilities:

• Data Architecture at Logical and Physical levels for the Enterprise Data Model and Data Warehouse ( Confidential ) and Dimensional Modeling and associated Data Marts using ERWin 7.
• ETL Lead using Oracle Warehouse Builder (10g/11g). ETL Developer using Informatica. Oracle Business Intelligence Enterprise Edition (OBIEE) design and administration.
• Oracle Answers Developer to produce end user standard and ad hoc analyses and reports.
• Analyzed customer requirements, data sources, data mapping, data architecture, data base design

Confidential

Data Warehouse Architect/Specialist

Responsibilities:

• Supporting complex ETL processes (Oracle PL/SQL (10g), Data Warehouse Builder, Sagent), Data Modeling (ERWin 7).
• Data Warehouse Architecture (ODS and Dimensional models), End User Reporting tools (Sagent, Cognos, Oracle Discoverer, Oracle Business Intelligence) supporting all aspects of Sales, Communications, Accounting and general Business Intelligence.

Confidential

ETL Specialist

Responsibilities:

• Complex PL/SQL extract, transform and loading procedures supporting a data warehouse of clinical records at Confidential .
• Experience with Oracle Data Warehouse Builder and Oracle 10g.

Confidential

Database Administrator

Responsibilities:

• supporting the re-engineering of the PCIS2 system for the Confidential, Confidential .
• Design database tables and Oracle PL/SQL to support a web based application supporting the delivery of services to the disabled.
• Extract, transformation and loading specialist specializing in data warehouse staging design, ETL coding and data warehousing operations.
• Extensive Oracle 9i experience with SQL and Unix shell scripting and PL/SQL to cleanse, transform and load very large databases with medical information.

Confidential

Database Developer/Business Analyst

Responsibilities:

• Architect, design, implement and administer enterprise Oracle databases used to support international on-line tutoring system for K-12 students.
• Support web based applications for customer support, publishing, tutoring and accounting systems.
• Recommend strategies and methodologies for implementation of scalable, robust databases to support operations.
• Design and implement data marts for reporting on business critical information via the internet and Oracle Discoverer.
• Established project scope definitions, project team compositions and provided project planning. Defined requirements for business processes including: requirements definition, functional decomposition, entity relationship diagrams, data flow diagrams, process specifications, user interfaces, calling structures and documentation of each component.
• Conduct working meetings with developers to communicate RAD prototyping and technical requirements based on the user requirements.
• Coded and implemented procedures and packages to implement data server processes.
• Created test procedures to validate coding and processes to compare deliverables against design specifications.
• Communicated verbally and in writing with senior management regarding requirements, analysis, design, implementation and testing processes.

Confidential

Sr. Manager

Responsibilities:

• Data Warehouse Project Manager. project definition, architecture and implementation.
• Defined business reporting and analysis needs through user interviews with senior management.
• Communicate project status and plans to senior management.
• Defined project scope, business definitions, team compositions and project plans to implement data warehouse project.
• Project ended when the company went bankrupt.

Confidential

Data Warehouse Architect / Data Base Administrator

Responsibilities:

• Lead technical consultant in the design and implementation of data marts in the Banking and Pharmaceutical industries using Oracle Designer 2000, Oracle Data Mart Suite, Oracle Developer 2000, Oracle Discoverer 3.0, ERWin, Brio, Cognos and Sagent Data Mart tools.
• Responsible for E/R, star-schema and database designs supporting ODS, DSS and OLAP environments.
• Designed, implemented and delivered Oracle databases in NT and UNIX environments.
• Defined, coded and delivered extract, transformation and loading (ETL) procedures used to populate the data marts in SQL, PL/SQL and Sagent environments.
• Designed and delivered End-User Layer on-line business intelligence systems in Oracle Discoverer 3.0, Brio, Cognos and Seagate Analysis.

Confidential

Senior Member Technical Staff

Responsibilities:

• Under contract to the Social Security Administration and to Confidential as Senior LAN/ Microcomputer Analyst and Programmer, Oracle Developer and DBA, Oracle Support and Work Order Manager/Technical Leader developing information systems in Oracle and PowerBuilder.
• Completed several short term projects using Lotus Notes, Delphi and C.
• Responsible for database conceptual modeling, physical design and implementation using S-Designor Data Architect and ERwin.
• Completed the design, development, installation and delivery of several Oracle 7.x database servers supporting multiple instances and multiple databases.
• Responsible for installation, upgrade, security, backup and recovery of data server.
• Extended experience as technical lead / work order manager for GUI application design, development and implementation using PowerBuilder 5.0.
• Responsible for the completion of projects on time and within budget.