We provide IT Staff Augmentation Services!

Database Developer Resume

Washington, DC

SUMMARY:

Technical professional with 16 years specialized experience in business intelligence tools, data analytics, data science, and Data Warehousing/ETL. With experience serving in the United States Army, I have a diverse background in leadership, conflict management, and the ability to adapt to any environment which helps in critical IT projects with tough deadlines and various personalities.

PROFESSIONAL EXPERIENCE

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

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

Database: Oracle, SQL Server, MySQL, DB2

Certifications: Oracle 9i SQL (IZO-007)

PROFESSIONAL EXPERIENCE

Confidential, Washington, DC

Database Developer

Responsibilities:

  • Write SAS programs to convert Oracle Discoverer and Discoverer Admin EUL to SAS environment.
  • Write complex SQL and PL/SQL to scrub and cleanse production data issues.
  • Create ETL scripts using SAS Data Integrator
  • Create analyses and data visualization tools for ad-hoc reporting using Tableau
  • Designed data masking procedures to ensure security of all Personally Identifiable Information (PII) of all TTB’s databases using DataMasker tool.

Confidential

Sr. Programmer Analyst II

Responsibilities:

  • Design, architect, and troubleshoot reports using Oracle Business Intelligence Enterprise for HCM Cloud Data Warehouse sourced from Taleo PeopleSoft 8.9 BI tools.
  • Produce customer dashboards and visualization tools for the HRIS team to support Human Resources professionals across all regions.
  • Build visualization tools and dashboards reports for Human Resources.
  • Design dashboard prototypes for Human Resource managers to assist with improving business processes.
  • Lead the design, development, and testing of an Executive Dashboard for the Regional Directors to provide predictive analysis of HRIS data for the purpose of streamlining the processes of the company’s human resources processes.

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.
  • 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.
  • Lead the design of a data warehouse to load public swaps data for analytical and time series analysis and reporting for the agency.
  • Major participator and Lead Developer of the TSD project which required applying Master Data Management (MDM) procedures to consolidate all external sources into the Swaps Data Repository for cross system statistical 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.
  • 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
  • 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 incorporate Oracle EBS Release 12 patching changes to base tables.
  • Stabilize the operation and maintenance project by streamlining and stabilizing the system by eliminating the backlog of 150 change requests/trouble tickets to 5.
  • Upgrade OBIEE from 10.1.3 to 11.1.1.0 and install and configure Weblogic middleware, upgraded Informatica from 8.6.0 to 9.6.1.

Confidential, Washington, DC

Business Intelligence/Data Warehouse Lead

Responsibilities:

  • Support the Department of Confidential 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, 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 Confidential .
  • 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 Confidential  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.

Hire Now