OBJECTIVE:

A skilled, talented and dedicated IT professional with diverse experience in database, data warehousing and business intelligence looking for a challenging position to utilize my knowledge of implementing and designing solutions for enterprise data integration.

SUMMARY:

• Fifteen years of database programming, data warehousing, administration, and business intelligence and reporting tools experience.

TECHNICAL SKILLS:

OLAP: OBIEE, Informatica PowerCenter, IBM/Ascential DataStage, OWB, ODI, Oracle Discoverer, Oracle Business Intelligence Applications (OBIA), BI Publisher, Crystal Reports, Business Objects, Hyperion, Oracle Financials, SQL Server SSIS

Database: Oracle, SQL Server

PROFESSIONAL EXPERIENCE:

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

Responsibilities:

• SQL Server Integration Services, Learning Tree, 04/2015,
• Project Management, USDA Graduate School, 10/2015

Confidential, Washington, DC

Oracle EBS Developer/Sr. Data Warehouse Developer

Responsibilities:

• Support the Overseas Private Investment Corporation (OPIC) to troubleshoot OBIEE Oracle Loans dashboard built on OBIEE 10.1.3 platform.
• Create, modify, and troubleshoot and administer Informatica PowerCenter 9.6 ETL to create mappings to load AR, AP, GL Oracle Federal Financials tables.
• Migrate mappings between environments using Informatica Repository Manager.
• Setup and administer Workflow Manager and Monitor, troubleshoot and modify OBIEE reports.
• 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 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 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, Patuxent 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.
• Administer Informatica Workflow and sessions.
• Perform data profiling on data warehouse to create new star schemas.

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

Responsibilities:

• OBIEE Developer/Administration and Hyperion Essbase Developer/Administrator (2008)

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. Convert legacy reports to Oracle Reports.
• Manage and oversee daily activities on Oracle databases.

Confidential

Responsibilities:

• Oracle Forms 10G - Oracle University - 09/2005

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.
• Wrote Unix AIX shell scripts to automate ETL process.
• Wrote DB2 SQL queries to test, load, and scrub data.

Confidential

Responsibilities:

• PeopleTools I/II - PeopleSoft University - 11/2003,
• Acential DataStage - Ascential - 6/2004

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.
• Designed and developed a Knowledge Confidential application using Oracle Forms 6i, and Oracle.
• Identify user problems and implement and document procedures.
• Responded to and resolve user problems and issues utilizing PVCS Tracker and Remedy systems.

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. Responded to Heat Tracking system to user problems.