OBJECTIVE:

• Data Warehouse professional seeking a senior role implementing data integration solutions.

TECHNICAL SKILLS:

OLAP: OTBI - E HR Analytics, Informatica PowerCenter, OBIEE, IBM DataStage, Oracle Discoverer, Oracle Business Intelligence Applications (OBIA) data models, SSIS, Oracle EBS, Tableau

Programming: PL/SQL, SAS, Perl, Java, R

Database: Oracle, SQL Server

Security Clearances: Inactive Top Secret SSBI clearance (12/2006, last used in 2011)

PROFESSIONAL EXPERIENCE:

Confidential, Washington, DC

Database Developer

Responsibilities:

• Write SAS scripts to convert Oracle Discoverer and Discoverer Admin EUL to SAS environment
• Write complex SQL and PL/SQL to scrub and cleanse production data issues.
• Perform data analysis of Business Layer for Oracle Discoverer to Tableau migration.
• Test use cases of applications and assist functional team to write new business case scenarios.
• Write SAS code to test and cleanse data for multiple applications.

Confidential, Chevy Chase, MD

Sr. Programmer Analyst

Responsibilities:

• Design, architect, and troubleshoot reports using Oracle Business Intelligence Enterprise for HCM Cloud Data Warehouse sourced from Taleo PeopleSoft 8.9 BI tools.
• Build visualization tools and dashboards reports for Human Resources.
• Design dashboard prototypes for Human Resource managers to assist with improving business processes.
• Produce customer dashboards and visualization tools for the HRIS team to support Human Resources professionals across all regions.

Confidential, Washington, DC

Data Analyst

Responsibilities:

• Create, configure, optimize new data marts using SQL Server database technology, and ETL development.
• Write new reports using various programming methods and tools. Analyze and load large datasets including Bloomberg, CME, ICE, and DDR swaps data repositories.
• Develop solutions using SQL, SSIS packages, and visualization tools to provide statistical analysis on Trading markets, public swaps and Futures contract data.
• Lead the design of a data warehouse to load public swaps data for analytical and time series analysis and reporting for the agency.
• Write T-SQL program to create and load Date dimension table for all time zones and countries. Write data models and algorithms for historical and time series analysis.

Confidential, Washington, DC

Lead Data Warehouse Developer

Responsibilities:

• Support the Overseas Private Investment Corporation (OPIC) to troubleshoot OBIEE Oracle Loans dashboard built on OBIEE 10.1.3 platform.
• Stabilize the operation and maintenance project by streamlining and stabilizing the system from 150 change requests to 10
• Create, modify, and troubleshoot and administer Informatica PowerCenter 9.6 ETL to create mappings to load AR, AP, GL Oracle Federal Financials tables.
• Configure ETL using Data Warehouse Console (DAC) and maintain Financial Analytics OBIA application
• Upgrade OBIEE from 10.1.3 to 11.1.1.0 and install and configure Weblogic middleware, upgrade Informatica from 8.6.0 to 9.6.1.
• Modified ETL to accommodate OFF R12 data structure updates due to upgrade of the source system
• Facilitate report steering committee meeting to provide project status, level of effort estimates for team on change requests and upcoming projects
• Optimize OBIEE reports and database objects for optimal performance
• Setup and administer Workflow Manager and Monitor, troubleshoot and modify OBIEE reports.
• Perform Informatica Administrator duties such as server installation and configuration and upgrades using Informatica Administrative Console.
• Maintain and manage OBIEE metadata, RPD, PL/SQL and materialized views.
• Create and modify Type1 and Type2 slowly changing dimensions to Informatica mappings. Modify Oracle EBS Informatica mappings to in corporate Oracle EBS Release 12 patching changes to base tables.

Confidential, Washington, DC

Business Intelligence/Data Warehouse Lead

Responsibilities:

• 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.
• Provide data support for TM1 Cognos application team
• Provide feedback to government client pertaining to project schedule, milestones, and risks.
• Respond to user and client to resolve data administrative and reporting problems.

Confidential, Washington, DC

Lead ETL Developer/WebFocus Developer

Responsibilities:

• 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.
• As ETL Team Lead, I wrote programs using iWAY DataMigrator and trained ETL team using the tool.
• Write WEBFOCUS programs and reports using FOCUS scripting, Report Assist and InfoAssist tools.

Confidential, River, MD

Sr. Principal Data Warehouse Developer

Responsibilities:

• 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.

Confidential, Washington, DC

Sr. Specialist/Sr. Oracle Developer

Responsibilities:

• 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.

Confidential, Washington, DC

Sr. Oracle Developer/Reports Lead Developer

Responsibilities:

• 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.
• Analyze Business Objects XI reports to determine specifications/requirements for new Oracle Reports Developer reports.

Confidential, Washington, DC

Sr. Consultant

Responsibilities:

• Assigned to the AAUSN OPTI project on the supporting the Secretary of the Navy Council of Review Boards (SCORB) legacy Oracle applications and SCORBweb 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.

Confidential, Alexandria, VA

Programmer Analyst

Responsibilities:

• Created maps and programs to extract, load, and transfer data from Army legacy sources to PeopleSoft EPM Data Warehouse using Ascentia/IBM DataStage.
• Wrote Oracle PL/SQL stored procedures, custom queries in support of PeopleSoft ELM conversion.
• Used SQL Loader to load flat files into database on Windows and UNIX platforms.

Confidential, Washington, DC

Systems Analyst

Responsibilities:

• Provided advanced problem analysis and resolution for the Immigration and Naturalization Service Department’s Claims 4 Oracle 8 production database.
• Wrote and tuned PL/SQL scripts for data manipulation, reporting, and data scrubbing.
• Wrote and tuned ad-hoc queries in Oracle 8 and Access 95/2000 databases.

Confidential, Alexandria, VA

Database Programmer/Report Specialist

Responsibilities:

• Provided a variety of ad-hoc requests by using SQL Plus, Oracle 8, and PL/SQL on UNIX and NT platforms.
• Wrote PL/SQL scripts and complex queries.
• Converted all MS Access monthly reports to SQL and Oracle scripts.
• Assisted Oracle DBA in major projects.
• Designed reports using Crystal Reports as assigned.