ANGIE ABUEDE

Phone: 301-***-****

cELL 301-***-****

e-mail address: acsrqj@r.postjobfree.com

Summary

Oracle Certified Application Developer.

Experience professional with expertise in designing and developing relational database applications. Strong technical programming and documentation skills necessary to produce resolution to complex issues. Strong background in Database Administration, PL/SQL, interfaces, and the Oracle Developer toolset

Strong verbal and written communication skills, result oriented and Self -motivated, team player. and good organizational time management skills.

COMPUTER SKILLS

Oracle 7/8i/9i/10g/11g/12c Oracle Federal Financials11i/R12 TortoisesSVN

Designer 6i/9i/10g MySQL

OracleForms 4.5/6i/9i Unix Shell Scripting

Reports 2.5/6i/9i HP Quality Center.

PL/SQL & SQL Clear Case

HTML/CSS Oracle Business Intelligence EE 11g

Unix/Linux Oracle Data Warehouse Builder, SQL Loader, TOAD, SQL Developer, PL/SQL Developer, Informatica 9.1, informatica 9.5, power Center, power Exchange

EXPERIENCE

Computer Science Corporation Feb 2011 – Present

Center For Medicare And Medicaid Services, Columbia MD

Assigned to the Hospital Reporting group of CMS, Creating store procedures, functions, and packages to display data in Oracle Business Intelligence Enterprise as desire by the clients.

Solid working experience with Oracle SQL & PL/SQL to design database procedures functions, packages, types, indexes, and triggers

Write database DDL and DML scripts

Develops, document, te and debug applications software and systems

Coordinates development and maintenance of a test and QA environment including procedures for migration to production environment;

Design database access controls

builds, and implements changes

.

Design, Develop, Modify, unit test and debug new and existing programs according to the business requirements and report findings as necessary.

Performing software testing to validate system functionality and performance tuning.

load data from feeder systems into staging tables and data /target warehouse tables.

Ensuring the application meets appropriate performance and security measures.

Supporting and providing quality client service in the development, production and integration of software applications and systems that enable clients to successfully meet the specified goals.

Supporting the maintenance of existing software applications.

Generate complex queries and reports.

Test programs according to functional business requirements.

Reviewing and analyzing technical and functional requirement specifications for integrated software application and systems.

Verifying functionality of system solutions using current quality assurance guidelines for technical design specifications.

Participate in design, development, acceptance testing, and implementation of software programs and/or computer equipment. Develop flow diagrams and/or pseudo-code. Test and debug programs according to detailed business requirements.

EXPERIENCE

Computer Science Cooperation April 2008 – Feb2011

Defense Agency Initiative, Business Transformation Agency, Crystal City, VA

Part of a RICEW development team extending Oracle Applications E-Business Federal Suite using SQL and PL/SQL programs, packages and in conjunction with SQL Loader, Oracle Reports and forms and web personalization to fill gaps in functionality required by the customer.

Wrote preliminary PL/SQL packages to perform testing feasibility of conversion approach options.

Investigating, analyzing and selecting tools methods for improving the performance and software quality throughout the life cycle.

Resolving critical issues affecting the configuration setup of the application.

Performed system, functional and regression testing on seven DAI applications.

Wrote technical documentation for data conversion from legacy mainframe and various systems to Federal Oracle E-Business R12 Project module.

Writing technical design documentation (MD70s) using the AIM methodologies.

Working with functional team to gather and clarify requirements.

Involve in the planning, developing, scheduling and conducting systems acceptability test products..

Worked closely with development and other team members to ensure 100% deliverable product.

Works well with others, Excellent problem solving skills.

Experienced with project deadlines and schedules.

Experienced with test procedures and specifications.

EXPERIENCE

Computer Science Cooperation April 2005 – March2008

Internal Revenue Service (IES/EFDS) – Oracle Database Engr Sr Prof

Assigned to the Electronic Fraud Detection Systems group.

Using industry best practices and methodologies design, develop, and implement extract-transform-load (ETL) processes using Oracle Warehouse Builder.

Develop annual load project using Oracle Warehouse Builder to load (PRISON/PRISONER, IMF, IRMF, and BMFENT) into the EFDS database for a particular tax period.

Develop annual load project using Oracle Warehouse Builder to load (BMFRTF) into the BMF database for a particular tax period.

Develop, update, and maintain OWB ETL scripts and other Loads related UNIX shell scripts

Make significant changes to some shell scripts to reflect Production Release changes for the specific year.

Develop data models to store data in a manner that supports Questionable Refund Program (QRP0112).

Write Procedure, Function and Package to support Questionable Refund Program (QRP0110).

Determine the relationships between data elements, tables and other Objects in the database.

Determine the business rules that apply to each data element.

Determine processes and procedures to examine input files and apply changes to existing codes as related to Production Release changes

Provide support to SAT, AQT during transmittals testing.

Analyze and fix item resulting from either AQT, SAT or Production.

Modify and make changes to C program to reflect Production Release for the year.

Assess and evaluate test data and make necessary change to the program for the year.

RDA Consultant Inc. Dec 2004 – March 2005

College Board - Oracle Database Consultant

Providing DBA support for the new Scholastic Aptitude Test online application.

Tuned complex queries.

These queries where originally timed in hours and I reduced the time to minutes or milliseconds.

I used the latest tuning hints and SQL coding methods.

Recommended Database Design enhancements for more efficient operation.

The customer was very satisfied.

Created database objects to support modification of some of the queries.

Discover ambiguous use of sql operator in most of the statement.

Validate the init.ora parameter file for appropriate setting.

Help to schedule batch job to run periodically.

MBA Management Inc. July 2004 – Dec - 2004

Veterans Benefit Administration &Veterans Health Administration

Writ Procedure/Packages to load data from various facilities to stage area, dimension tables, and fact table.

Reviewing and assessing existing data processing methods and techniques

Extracting data from legacy systems, transform and load data to the warehouse using Procedures/Packages.

Migrate Oracle Discoverer 3.0 to Discoverer 9i

Created SQL, PL/SQL and shell scripts to extract, transform and load data using SQL Loader.

Review, conversion and integration of Access forms into oracle forms using Oracle 9iAS application forms and reports.

Converted MS Access extract queries to oracle SQL queries.

Creating and managing primary objects such as tables, views and indexes

Performed quality analysis testing of all application modules.

Performed application, database and SQL codes tuning.

Performed applications’ performance tuning, SQL tuning, procedures, packages for optimal query executions.

Thoughtmills Solutions September 2002 – 2004

Principal Consultant.

Developing and maintaining the Metadata repository

Designed Violations Data Warehouse repository for educational system.

Designed ETL methods and star schema for reporting.

Developing data marts and data warehouses

Created conversion tables to serve as temporary staging areas for data transformation and scrubbing before loading

Revising existing systems and procedures to correct deficiencies and maintain more effective data handling, conversion, input/output requirements, and storage

Ensure integrity and recoverability of database structures.

Ensuring the recoverability of the database structure

Working with managers and users to develop business requirements and to analyze/model current and proposed business process flows

Performing database performance tuning and re-organizations

Implement and maintain database structures

Monitor and tune the database environment for improved application and system performance

Tuning SQL statements and PL/SQL using Explain Plan, SQL Trace & TKPROF, Hints.

Design and scheduling the database maintenance plan.

Backup of Database (Making Backup Schedules depending upon Business Strategy: Daily Backup, weekly Backup etc.)

Recovery of Database(Recovering from Media Failure, Recovering tables dropped accidentally, Recovering data files, Recovering from Block Corruption).

Taking Backup & Recovery of Database Using Logical (Export & Import) & Physical

(Online & Offline) Backup.

Creation of shell scripts to automate extraction, transfer, and encryption of extracted data between Best Buy and TWC on weekly basis.

Application performance testing.

Quality analysis testing of application, and Production support.

Process documentation and preparation of training manuals.

Preparation of detail project assessment and costing documentation.

Assisted in sourcing of resources and selection processes.

Performed extraction and loading of data for database refreshes on a regular basis to support the development and QA units.

Developed SQL and shell scripts to generate statistical report in identifying anomalies within the active subscriber services accounts.

Carried out regular application and database performance tuning for the Reliance applications.

OCTOBER 2000– SEPTEMBER 2002 Datascan Technologies

Software Engineer

Responsible for the development and maintenance of Screen Forms, Report, PL/SQL Procedures, Functions and Packages in the support of the WMS-EE product.

Create PL/SQL procedures, functions and packages to support applications.

Designed, developed, and create data warehouse using Oracle Warehouse Builder.

Peforming GUI interface through Oracle Forms, and Oracle Reports.

Updated data within the data warehouse on a weekly basis using job scheduling tools within the Oracle Enterprise Manager (OEM), as well as with customized scripts created using PL/SQL packages, and procedures.

Mined and analyzed warehouse data using Oracle Discoverer, Oracle Reports, and Oracle Query Builder

Developed patches using a combination of C language, SQL*PLUS, and PL/SQL coding to develop functions, triggers, procedures, scripts and packages to resolve reported bugs from clients, and upgrade of such resolutions into new releases.

Created new tables for application enhancement, and load data into the tables using the SQL Loader.

Responsible for report development pulling data from an information repository using crystal 8.5 to create and generate reports for end users

Create modules based on established requirements using Oracle Forms 6i

Undertook several tuning efforts to ensure a high performance in the database by either creating new index or droping existing ones as the case maybe.

Enforce integrity constraints of database with primary key, unique, check, and reference constraints.

JANUARY 1997 – OCTOBER 2000 Scientific Games International.

Programmer Analyst:

Created and modified various applications, reports, pop-up windows, INOUT windows, function keys, error messages, and use of PL/TRIM SQL and C language in application customization.

Used Oracle Designer 2000 on Oracle 7.3 database to generate table constraints and codes, entity relationship and module diagrams.

Responsible for the development and maintenance of Screen Forms, Report, PL/SQL Procedures, Functions and Packages in the support of the SGI-NET product.

Transferred data from old system to new using PL/SQL Procedures, Functions, and Packages.

Write various kind of script to track goods from warehouse to their destination, ensure stolen tickets are not validated and to reconcile the total number of goods delivered to each retailer.

Built and customize forms for database objects.

Construct triggers, procedures, and functions to enhance operational functionally of applications.

Develop client/server applications using Oracle Developer/2000, SQL, and PL/SQL.

Peforming GUI interface through Oracle Forms, Oracle Reports and Oracle Graphics.

Customize and generate report using Oracle Report and SQL*PLUS.

Enforce integrity constraints of database with primary key, unique, check, and reference constraints.

Created tables and views utilizing SQL.

Performed DBA functions such as creating synonyms, tablespaces and indexes and established datafiles, control files, and redo log files.

1992 – 1996 Comet Merchant Bank Limited Lagos, Nigeria

Treasury Manager:

Established/serviced professional clientele accounts.

Expedited investments in treasury bills, repurchase agreements, CD’s, retirement accounts and discount brokerage for bank clients.

Documentation of systems improvements and changes.

Application of bug patches.

Troubleshooting and resolution of database and user problems

Database and applications tuning

Management of applications used in monitoring and collection of overdue loans to individuals and corporate organizations.

Summarized monthly financial results and reported to upper management and the Central Bank of Nigeria.

Monitoring the banks’ total cash portfolio with the central bank of Nigeria.

Trading with other banks in terms of placement/takings funds as the situation requires.

Attend inter-bank meetings and report recommendations to top management.

Marketing, preparation and processing of loans to blue chip companies.

Marketing and management of corporate and individual investors.

Education

Bachelor of Mathematics Edo State University Nigeria.

Major in Computer System.

Certified in Oracle Programmer (OCP, 2001).

CERTIFICATIONS

Certified in Oracle Programmer (OCS, 2001).

Certified in Oracle Business Intelligence Foundation Suite 11g Essentials ( 2013).

CLEARANCES

U.S. Treasury MBI

Secret Clearance

Award of Excellence in recognition of contributing to the 2007 filling season for the

successful implementation of EFD Client/Server system, Internal Revenue System - July 2007.

Award Of Excellence in recognition for my contribution to the implementation and success of the Defense Agencies Initiative DAI - 2011 Fiscal Year.

Training

R12 Oracle Financial Functional Foundation Ed1

R12 Extend Oracle Applications: Customizing OA Framework Applications Ed1

Oracle BI Publisher 10g R3: Fundamentals

ORACLE BI 11G R1: CREATE ANALYSES AND DASHBOARD

ORACLE DATA INTEGRATOR ADMINISTRATION and DEVELOPMENT RI 11.1.1.6

Contact this candidate