Objective To seek Data Warehouse Lead position to solve advanced technical problems.

• Summary Thirteen years of Oracle database programming, data warehousing, administration, and business intelligence and reporting tools experience.
• Computer Skills
• OLAP: OBIEE, Informatica, Oracle Business Intelligence Applications OBIA , Oracle Federal Financials, IBM DataStage, Oracle Discoverer 10G, , BI Publisher, Crystal Reports, Hyperion
• Database: Oracle 10G/9i/8i, SQL Server 2000, Teradata training
• Operating Systems: UNIX Sun Solaris, Tru64, HP-UX , Windows 95/98/2000/NT MS Dos
• Software and Knowledge: Oracle Application Express APEX , Erwin, Oracle Designer, Subversion, SQL Loader, TOAD, Dimensional Modeling
• Security Clearances: Inactive Top Secret SSBI clearance

Experience

Confidential

Informatica ETL Architect/OBIEE Adminstrator

• Support the Overseas Private Investment Corporation OPIC to troubleshoot OBIEE Oracle Loans dashboard built on OBIEE 10.1.3 platform. Troubleshoot Informatica ETL to create mappings to load AR, AP, GL Oracle Federal Financials tables. Currently migrating Federal Analytics to newest application suite. Upgrade OBIEE 10.1.3.4 to 11.1.1.7.0. Upgrade Oracle Federal Analytics to 7.9.6.4. Install, configure, administer Weblogic 10.3.6. Upgrade Informatica PowerCenter 8.6.0 to 9.5.1. Migrate mappings between environments using Informatica Repository Manager. Setup and administer Workflow Manager and Monitor. Troubleshoot and modify OBIEE reports. Conduct code deployments to Production environment. Create and modify data models using Kimball method. Infrastructure and Environment setup using Repository Creation Utility and Informatica Administrative Console. Create and modify Type1 and Type2 slowly changing dimensions to Informatica mappings. Modify Oracle EBS Informatica mappings to incorporate Oracle EBS Release 12 patching changes to base tables. Perform server and data migrations to sync environments. Install and configure Informatica, Oracle Business Suite and Financials. Administer and implement report requirements into OBIEE Repository.
• Support the Export Import Bank of the US to implement Oracle R12 application suite consisting of Accounts Receivables AR , Accounts Payables AP , General Ledger GL , and Oracle Loans. Write interface programs using PL/SQL to pull in legacy data at real-time. Write and edit interface design documents.

Confidential

Business Intelligence/Data Warehouse Lead

• Support the Department of Navy, Military Construction MILCON and Finance Management Division to implement new Business Intelligence solution. Facilitate tasks and provide mentoring to junior Data Warehouse staff in loading data, database programming using Oracle Warehouse Builder. Database Management services for all database structures. Assign and manage tasks to team of Data Warehouse Developers and Oracle Financial Analyzer developers. Set priority and manage project deadlines and schedules. Write and modify data dictionaries to ensure Navy data standards. Planning and project allocation of resources. Provide continuous feedback to government client pertaining to project schedule, milestones, and risks. Respond to user and client to resolve data administrative and reporting problems.
• Training: Oracle Essbase, OBIA Supply Chain module, OBIEE 11 Administration

Confidential

Lead ETL Developer/WebFocus Developer

Support the Department of Justice, Federal Bureau of Investigations FBI , Financial Support Unit in migrating the Financial Information System FIS mainframe application to new Oracle environment. Convert VSAM file structure data system to relational Oracle platform. Write ETL programs using iWAY DataMigrator. Train ETL team in DataMigrator ET L tool. Write PL/SQL to support new database. Install Oracle 10G database suite. Conduct data load risk assessment and report to Project Management. Implement DataMigrator and WebFOCUS software tools for developers within division. Configure environment for data warehouse environment. Implement security policies and manage database objects. Establish data and security policies to help streamline division policies. Design data model database and network server on new system. Work with Virtual team to write security plan and design new Virtual WebFOCUS server. Write WEBFOCUS programs and reports using FOCUS scripting, Report Assist and InfoAssist tools. Respond to user maintenance and software enhancement requests to fix WebFOCUS reports. Create and modify relational database model using Erwin.

Confidential

Support Inferx Corporation on iNFADS project. Create reports using Oracle Reports Builder 10G for the Department of Navy. Convert existing MS Access reporting application to an Oracle 10G environment. Import dump files using Data Pump and loading utilities. Create Forms and Reports using Oracle APEX. Participate in all phases of development life cycle KIMBALL and RUP methods including requirements gathering, development, testing, and deployment of Oracle products, Gathered the requirement, completed the proof of concept, Designed, Developed and Tested Physical Layer, Business Layer and Presentation Layer of OBIEE. Created the OBIEE and OWB environment for Development, QA and Production environment. Designed, Created and Tested Report in the Dashboard and created the adhoc report according to the client needs. Migrated the Tested Code from Dev to QA and QA to Production of Repository, Dashboard Reports and ETL mappings and workflows. Designed the logical and physical data model to store OLAP data. OBIEE Admin work: New Id creation, Account modification of existing users, Password reset and Deletion of accounts. High Level Design and Detail Design for Data Warehouse and OWB.

Confidential

Sr. Principal Data Warehouse Developer

Create Informatica ETL programs using Informatica PowerCenter 8 to move data from various legacy and data marts for the Department of Navy. Write shell scripts to manipulate data files. Create Star Schema data models. Write PL/SQL scripts for data manipulation and data staging purposes. Administer Informatica Workflow and sessions. Perform data profiling on data warehouse to create new star schemas.

Confidential

Sr. Specialist/Sr. Oracle Developer

• Support the Department of Homeland Security, Transportation Security Administration TSA . Create, modify, and troubleshoot custom reports using Oracle Reports Builder for PARIS application. Write and modify requirements. Write custom PL/SQL code for report optimization. Write and modify custom views for report generation.
• Training: OBIEE Developer/Administration and Hyperion Essbase Developer/Administrator 2008

Confidential

Sr. Oracle Developer/Reports Lead Developer Contractor

Create, edit, and modify reports using Discoverer Desktop for Whistleblower and Partnerships applications for Department of Labor, OSHA department. Create and administer End User Layers in Oracle Discoverer Business Intelligence 10G. Convert all existing Business Objects reports onto Oracle Discoverer platform. Create and modify Oracle Forms 6/9/10G applications. Analyze Business Objects XI reports to determine specifications/requirements for new Oracle Reports Developer reports. Develop Oracle Portlets and configure user access using Oracle Portal. Write materialized views for reporting optimization and performance. Modify data model using Oracle Designer and design tables and views for all environments. Write and modify PL/SQL packages, stored procedures, triggers, and functions.

Confidential

Sr. Consultant/Sr. Oracle Developer Department of Navy

• Assigned to the AAUSN OPTI project on the supporting the Secretary of the Navy Council of Review Boards SCORB legacy Oracle applications. Wrote SQL Loader scripts and PL/SQL programs to migrate data from MS Access to Oracle 8i database. Troubleshoot, enhance, and design new Oracle Forms and Reports for Naval Discharge Review Board, National Clemency and Review Board, and Physical Evaluation Board systems. Convert legacy reports to Oracle Reports. Write PL/SQL to enhance and update day-to-day existing processes. Install and configure Oracle database software on user's machines and servers. Manage and oversee daily activities on Oracle databases.
• Assigned to the AAUSN OPTI project on the SCORB Web project supporting the Department of the Navy. The project focus is to consolidate existing legacy systems into .NET/Oracle Web application. Perform Data Mapping between legacy and target databases from Oracle 8i to Oracle 9i. Install Oracle Server, configure multiple databases in preparation for data migration. Write PL/SQL and SQL Loader scripts for Extract, Transformation, and Loading of data from various data sources to Oracle 9i target database. Create new Oracle databases for migration, development, testing, and reporting environments. Use TOAD and Enterprise Manager to manage existing database, monitor performance, and oversee day-to-day activities.
• Assigned to the DIMHRS US Army project. Analyzed requirements for over 100 US Army legacy systems in preparation to be subsumed by the new application. Created proprietary software used to gather each requirement for every legacy application.
• Training: Oracle Forms 10G Oracle University 09/2005

Confidential

Programmer Analyst eHRS/DIHMRS Project Dept of the Army

Created maps and programs to extract, load, and transfer data from Army legacy sources to PeopleSoft EPM Data Warehouse using Ascential DataStage. Wrote Oracle PL/SQL stored procedures, custom queries in support of PeopleSoft ELM conversion. Test and validate data from multiple data sources. Used SQL Loader to load flat files into database on Windows and UNIX platforms. Wrote Unix AIX shell scripts to automate ETL process. Wrote DB2 SQL queries to test, load, and scrub data. Performed Data Mapping between source and target locations. Created maps using Informatica ETL tool. Write Cognos reports using BI Developer.