SUMMARY:

• 3 years’ experience designing and developing a Confidential . During this time, gained broad understanding of EV5 data structures to accommodate Employee, Job History, Position Vacancy History, Positional Hierarchy, Organizational Hierarchy (tree structures), Confidential, Benefits, Out of Class, Accumulators, and other major HR data structures. Developed user - acceptance reports of HR data vs. EMR and EV5 for user acceptance.
• 8 years’ experience in Data Analysis and Architecture, using AllFusion Erwin Data Modeler, Oracle Designer, Sybase Power-Designer, and Oracle Data Modeler 3.1 of both Transactional and Data Warehouse applications. Mapping of Business Rules to Logical Data Models to Physical Data Models to generation of Database DDL, data definition language.
• 9 years’ experience in Oracle database design and development in both OLTP and Data Warehouse architectures, using PLSQL packages and Oracle Data Integrator, ODI.
• 6 years’ experience in ETL and Data Warehousing for Microsoft Zune, Confidential Transformer and Framework Manager, on a Sybase IQ data warehouse for the Dept. of Energy. For Seattle City Light, developed a HR data warehouse and Real Estate data warehouse, using Oracle Data Integrator, Confidential Framework Manager and Confidential Reports.
• Lead for migration and relocation of major Confidential database that tracked airplane manufacturing logistics. Migrated all data with no problems. Sized and configured new database instance. Wrote SQL-creating-SQL scripts reading Oracle’s data dictionary to assure valid and complete security accounts and roles and synonyms. Implemented data validation reports to assure completeness and validity of migrated data.

PROFESSIONAL EXPERIENCE:

Confidential, Washington

BI Analyst / Developer

Responsibilities:

• Did analysis, design, development, and maintenance on Business Intelligence applications for Corporate Performance. Designed and deployed the staging and data mart schemas in Oracle 12g databases. Developed the ETL processes in Oracle Data Integrator, ODI. Developed the middle-tier BI interface in Confidential Framework Manager. Developed Confidential Reports and Graphs; and, developed a Confidential Report Template to brand and standardize report presentation.
• Developed a full HR Data Mart with transactional and snapshot facts. The dimensions accommodated Employee, Demographics, HR transactions, Positional, Out-of-Class, and Accumulators, Benefits, and Confidential measurements by Year and Month from 2000 thru today. Developed row-level security employing a Position Hierarchy. Provided ability to do metrics on Out-of-Class and Organizational Turnover and Attrition; all capable of historical comparable analyses. Developed Data Dictionary and Data Mappings for all of the HR Data Mart.
• Developed a full Real Estate Data Mart that matched up the Real Estate data to the financial data. Designed and developer full BI life cycle of staging, to data mart, to Confidential Framework Manager middle tier. Worked with Finance and Real Estate stake holders to gather requirements and provide guidance for User Acceptance testing. BI Reporting compared Expected revenue against Actual Revenue on a monthly basis over 10 years. Also provided Discrepancy reports and visibility to overdue accounts.
• Provided daily production ETL support for HR, Real Estate, and Financials.
• Authored ETL documentation, Target-to-Source data mappings, and Table and Column definitions, and Fact-to-Dimensional links, deployed in spreadsheets and made available in Confidential Reporting interface. Authored both technical and business-user documentation.

Confidential, Oregon

Erwin Data Modeler

Responsibilities:

• Designed and developed Logical and Physical Data Models for Confidential ’s integration into the Health Exchanges for the states of Washington, Oregon, Idaho, and Utah; using CA Erwin Data Modeler.
• Gathered application requirements and developed logical models to support these requirements.
• Defined all Table and Column definitions.
• Generated Oracle database tables, indexes, sequences, and triggers.
• Developed Oracle PLSQL packages.

Confidential, Washington

Application Developer

Responsibilities:

• Wrote application interface documents to the Confidential application, which provides the work flow of assembling different Confidential airplane programs and models. The Confidential application was being upgraded and business rules were changing. There were 24 downstream applications. I wrote 24 interface mappings and documents. I wrote the legacy views to accommodate those applications that could not change their interface. I wrote the new mappings for those applications that could adapt to the new interface. I wrote the testing plan to compare the legacy application interfaces to the new application interfaces. I coordinated notification of changes and deployments to the consumer applications.
• The Confidential 787 Change Process and Systems. HP-Unix box to run cron jobs for nightly ETL, SQLPlus Reporting, UNIX scripting to run batch jobs, reports, and ftp to customers. Logical Data and Database Design and PLSQL Development and daily customer support to for in-house customers.
• Specified all Confidential reports that were used to report the archived change requests and affected organizations of the Change Request Application, located in Long Beach, California. Coordinated the application archival into an existing Confidential data warehouse. Both application and data warehouse databases are Oracle 10g databases. Retired the legacy Oracle databases.

Confidential, Washington

Data Warehouse Architect and Developer

Responsibilities:

• Sybase IQ data warehouse developer and architect Using Confidential for remote load of three Oracle data sources and Excel spreadsheets into a Sybase data warehouse.
• Design and implementation of all ETL staging tables and procedures and the front-end star-schema data warehouse that was 1 terabyte.

Confidential, Richland, Washington

Oracle Developer

Responsibilities:

• Development of Oracle 10g PLSQL stored procedures and triggers for Confidential project to standardize world-wide management of a Confidential .
• Integrating an Oracle manufacturing application into a Nuclear Fuel Global Supply Chain.
• Development of Oracle Forms and Reports 6i and 10g on a nuclear fuel manufacturing application.

Confidential, Washington

Data Warehouse Engineer

Responsibilities:

• Writing Oracle PLSQL for ETL processes. Data Warehouse was 4 terabytes. 10 to 20 million transactions per day over five years.
• Designed and Deployment of development, quality assurance, and production Confidential BI schemas.
• Development and implementation of automated batch processing of Confidential cube creation and reports for daily, weekly, monthly, and quarterly financial and marketing BI reporting for the US, Canada, Great Britain, France, and Germany.
• Conversion of Confidential 7.3 to Confidential 8.3 BI Application for Reports, Transformer Cubes, Framework Manager, Configuration, Security, and Administration.

Confidential, Washington

Oracle Consultant

Responsibilities:

• Analysis and documentation of Confidential financial data warehouse that was fed by SAP and Siebel enterprise applications. Data profiling and data mapping of the SAP data source. Writing staging and ETL on a financial data warehouse. Enhancing the legacy reporting database due to SAP application changes.
• Making adjustments to the data warehouse tables to accommodate multiple data sources and slowing moving dimensions, etc.
• Lead Developer and the liaison between the technical team and the end-users.

Confidential, Washington

Application Developer

Responsibilities:

• Application Developer an Oracle 9i in-house Medical Insurance application, writing Oracle PLSQL and queries for data mining and analysis which resulted in improved auto-adjudication rate of medical claims.
• Microsoft SQL Server and Reporting Services Developer, writing T-SQL stored procedures and queries. Perforce was the configuration management software.