SUMMARY

• Experience encompasses seventeen plus years of full software life - cycle Oracle database design and development experience, including requirement gathering and analysis, software design and development, testing, user support, and project management.
• Knowledge and experience in Agile software development methodology using Scrum.
• Fifteen years Oracle E-Business implementation and development experience, wif about six years E-Business R12 experience.
• Knowledge and experience in teh following Oracle E-Business modules: Payables (AP), Payments (IBY), Purchasing (PO), Receivables (AR), General Ledger (GL), Federal Vertical (FV), Projects (PA), Project Contracts (OKE), Contract Lifecycle Management (CLM), TCA, Subledger Accounting (XLA), Oracle Service Contracts (OKS), Oracle iProcurement (ICX), Inventory (INV), Oracle HR (PER), Order Entry (OE), Order Management (ONT)
• Working noledge of teh Approval Management Engine (AME)
• Ten plus years designing and developing Oracle EBS RICEW components.
• Fifteen plus years Oracle PL/SQL development utilizing Oracle database 10g/11g/12c
• Ten plus years developing Oracle Forms and Reports
• Eight years Oracle Workflow design and development
• Ten years Oracle BI (XML) Publisher report design and development.
• Five years’ experience extending and personalizing Oracle Application Framework (OAF) pages
• OBIEE experience wif a solid understand of teh physical, business, and presentation layers
• Know ledge and experience in administering Oracle WebLogic Server.
• Knowledge and experience in Data Warehousing wif solid understand of teh ETL process
• Knowledge and experience in Oracle Enterprise Transaction Controls Governor (ETCG)
• Knowledge and experience in Application Access Controls Governor (AACG)
• Knowledge and experience in Oracle Audit Vault and Database Firewall
• Knowledge and experience in Oracle WebLogic Clusters
• Experience wif Oracle replication and materialized views
• Successful in designing and developing solutions to complex tasks on time and under budget.
• Possesses Project Management and Information Assurance noledge.
• Excellent interpersonal, written and verbal communication skills
• Self-motivated, details oriented multi-tasker wif superb analytical, organizational and problem-solving skill.

TECHNICAL SKILLS

• Oracle EBS R12
• Oracle Federal Financials 11i/12
• Oracle 10g/11g/12c
• Oracle Application Framework (OAF)
• Oracle Business Intelligence Tools
• Oracle BI Discoverer
• Oracle BI Publisher (XML Publisher)
• OBIEE
• SQL*PLUS
• PL/SQL
• SQL LOADER
• Oracle Developer 10g (Oracle Forms
• Oracle Reports
• JDeveloper)
• Oracle Workflow
• Oracle Designer
• Erwin Data Modeler
• PL/SQL Developer
• SQL Developer
• TOAD
• PL/SQL Web Toolkit
• Java
• Java Server Pages (JSP)
• XML
• HTML
• JavaScript
• CVS
• Rational ClearCase
• Rational ClearQuest
• Serena PVCS
• Oracle Application Server (OAS)
• Oracle WebLogic
• SVN
• Oracle Enterprise Transaction Controls Governor (ETCG)
• Oracle WebLogic Server
• DataLoad

PROFESSIONAL EXPERIENCE

Confidential, VA

Oracle EGRC/Audit Vault Security Analyst

Responsibilities:

• As teh Audit Vault Programmer Analyst, responsibilities include:
• Configuring, designing, and managing Audit policies and provisioning them to teh database
• Designing and developing audit policies for SQL, Schema Objects, Privileges, and Fine-Grained Auditing (FGA).
• Designing and developing audit policies for Capture rules for Redo Log File auditing
• Developing custom reports in various format
• Customizing teh built-in reports
• As teh EGRC Analyst, responsibilities include
• Teh design, development, and deployment of business objects, models, and controls for Enterprise Transaction Controls Governor (ETCG) and Application Access Controls Governor (AACG), two of teh Oracle Advanced Controls dat run as a Continuous Control Monitoring (CCM) module in Enterprise Governance Risk and Compliance (EGRC) platform.
• Designed and developed XML files to be used as custom business objects for ETCG. These XML files are created using PL/SQL and XML.
• Created Access and Transaction models and deployed these models as controls.
• Created AACG entitlements and global conditions.
• Created access simulation and developed remediation steps for resolving access and transaction control incidents
• Configured email notifications for ETCG and AACG
• Manage access approvals
• Audit Policies are created using teh database packages DBMS RLS and DBMS FGA.

Confidential, Alexandria, VA

Oracle EBS Developer

Responsibilities:

• Designed and developed automated validation processes to validate converted data loaded into SCES from teh DSAMS, MISIL, and DIFS conversion. SCES is DSCA’s ERP solution, and DSAMS, MISIL, and DIFS are legacy systems.
• Developed automated validation processes for teh below listed conversion and interface processes:
• Letter of acceptance (LOA) Case data element conversion - Uploads case and case line data from DSAMS and MISIL to SCES Oracle EBS Projects (PA), Order Management (ONT), and Fed Admin (FV) modules.
• Navy Open Requisitions conversion - Uploads Navy open reimbursable requisitions from MISIL to SCES Oracle EBS Order Entry (OE) and Purchasing (PO), and Payables (AP) modules. Open navy requisitions are converted to Sales Order in SCES and purchase requisitions, purchase orders, purchase receipts, and payable invoices are created from these sales orders.
• Navy Contract Procurement PR conversion - Uploads open and closed contract procurement requisitions from MISIL to SCES Oracle EBS Order Entry (OE), Purchasing (PO), and Payables (AP) modules. Contract Procurement requisitions are converted to sales order in SCES and purchase requisitions, purchase orders, purchase receipts, and payable invoices are created from these sales orders.
• Budget Appropriation and Allotment Conversion - Uploads budget transactions data from MISIL to SCES Oracle EBS Fed Admin (FV) module. Budget transactions are uploaded from budget level 3 in MISIL to budget level 4 in SCES.
• Navy Cash Receipt Balances - Uploads Navy FMS customer’s cash balances from DIFS into SCES Oracle EBS Receivables (AR) module.
• Developed PL/SQL program to parse, process and load data received in XML format into custom Oracle tables.
• Developed and enhanced customer bill reports using BI Publisher. These reports utilize teh bursting features of BI Publisher.
• All development tasks are performed in an Oracle 12c database environment on a Unix platform utilizing PL/SQL, SQL, BI Publisher.

Confidential, Reston, VA

Sr. Oracle Developer - Technical Lead

Responsibilities:

• Worked in an Oracle EBS R12.2.4 environment
• Involved in teh implementation, upgrade and support of Oracle E-Business Federal Financials R12.2.2. Modules implemented include General Ledger (GL) Payables (AP), Payments (IBY), Receivables (AR), Purchasing (PO), Federal Vertical (FV), Fixed Assets (FA), Projects (PA), Oracle Contract LifeCycle Management (CLM)
• Assisted in teh implementation and setup of Oracle CLM to include; CLM Profile Options setup; CLM controls setup; Purchasing documents styles setup, Printing setup, and Workload assignments
• Assisted in teh setup and configuration of Oracle Approval Management Engine (AME) to create and define approval hierarchies and approval rules and link them wif CLM documents.
• Developed RICEW components for Oracle EBS R12.2.4. Components developed include Oracle Forms and Reports 10g/11g, Oracle Workflow, custom alerts, Interfaces, BI Publisher and BI Answer reports.
• Customized several XML Publisher templates for Awards/IDVs/Solicitations to include: Modifications, SF30; Award/Contract, SF26; Solicitation, SF33; and IDV, SF26
• Developed and customized several Contract Lifecycle Management BI Publisher reports. These reports include; Print CLM Requisition Report, Print CLM Requisition Amendments Report.
• Customized teh AP Invoice Approval Workflow to create separate approval routes for CLM and non-CLM invoices.
• Customized teh PO CLM Approval Workflow using AME
• Customized teh PA Budget Workflow to add additional approval roles
• Developed several BI Publisher reports in both RTF and Excel format wif bursting capabilities.
• Developed OBIEE reports using both BI Answers and BI Publisher.
• Performed system administration tasks on teh OBIEE such as creating Groups and assigning users to Groups. Also, created new shared folders and assigned Groups to teh shared folders and shared Dashboards.
• Created OBIEE Shared Dashboards and shared prompts.
• Customized and enhanced teh Federal PAM ACH Payments Format and Federal PAM Check Payments templates
• Resolved production break fixes.
• Created ETCG models and controls on teh following business objects:
• Suppliers - Check for duplicates and any updates made over a period.
• Payables Invoice - Identified cancelled invoices on which payments have been made
• Expense Report - Identified suspicious combinations for teh same expense report ID and employee.
• Employee Job/Job Assignment - Identified employees wif blank job and/or job assignments.
• Employee Job Category - Identified employees wif invalid job category
• Generated incident reports from these controls.
• Customized, personalized and enhanced core application forms using forms personalization.
• PersonalizedOAF pagesanddeveloped extensions for view/entity objects, controllers and Application module (AM) attached to Oracle Application Framework (OAF) pages using OracleJDeveloper10g/11g
• Added LOVs to OAF page(s) from custom view objects
• Developed and designed SQL Loader scripts and PL/SQL interface program to populate teh treasury interface tables and move teh data to teh core treasure tables.
• Developed several interface and conversion programs to include:
• PA Payroll Interface Oracle Load
• AR Payments Interface (AutoLockBox)
• AR AutoInvoice
• BEAR Supplier/Supplier Site Import and Load
• IPAC Receipts Creation
• Etravel Interface (PO & Invoice creation and approval)
• PCard Interface
• All development tasks were performed in an Oracle 12c database environment on a Unix platform utilizing PL/SQL, SQL, BI Publisher, Oracle Reports.

Confidential, Germantown, MD

Sr. Oracle Developer

Responsibilities:

• Worked on teh EBS R12 upgrade. .
• Involved in teh upgrade of Oracle E-Business Federal Financials from R11i to R12. Modules implemented include General Ledger (GL) Payables (AP), Payments (IBY), Receivables (AR), Purchasing (PO), Federal Vertical (FV), Fixed Assets (FA)
• Developed RICEW components for Oracle EBS R12. Components developed include Oracle Forms and Reports 10g, Oracle Workflow, custom alerts, AP/PO/GL interfaces, BI Publisher and BI Answer reports.
• Developed and enhanced custom AP, PO, AR forms using Oracle forms 10g
• Developed and tested custom alerts,
• Developed Oracle BI (XML) Publisher reports in both RTF and Excel formats wif bursting capabilities.
• Designed and developed custom Oracle Reports using Oracle Reports 10g/11g
• Developed OBIEE reports using BI Answers.
• Customized, personalized and enhanced core application forms using forms personalization and custom.pll library.
• Developed extension and personalization for teh OAF Supplier entry page.
• Personalized and develop view/entity object extensions to modify LOVs and add a field to teh page and populate it wif value from teh VO.
• Extended teh OAF page Controller to hide/unhide field based on condition dat is determined by teh value of a field.
• Customized forms functionality by modifying teh CUSTOM.pll file
• Developed and enhanced interfaces for AP, PO and GL.
• Developed custom payable open interface program for AP using PL/SQL packages, SQL Loader and UNIX.
• Developed custom purchase document open interface program (PDOI) and custom receiving open interface (ROI) for PO using PL/SQL packages, SQL Loader and UNIX.
• Designed and developed a custom GL interface using PL/SQL packages, SQL*Loader, and UNIX shell scripts datloaded data from flat files, validate teh data, and move teh data into teh GL Open Interface table. Teh specific GL interface include Working Capital Fund interface.
• Designed and developed supplier conversion interface to load data into teh AP Suppliers and AP Supplier sites tables.
• Developed Web-ADI interfaces.
• Used ADI to load conversion Fixed Assets data from legacy system into Oracle Financials FA Mass Additions tables.
• Utilized several Trading Community Architecture (TCA) APIs to create parties and party sites.
• Utilized a combination of performance tuning strategies including subprogram Inlining, DBMS Result Cache, stored outline, hints, and indices to tune SQL statements operating on a production database over 1 TB in size.
• All development tasks are perform in an Oracle 11g database environment on a Unix platform utilizing PL/SQL, TOAD.

Confidential, Ashburn, VA

Sr. Oracle Developer -Technical Lead

Responsibilities:

• Confidential is a highly customized Oracle E-Business system dat enables ONR to manage its financial data; principal investigators to submit grant proposals; ONR Program Officers to, view, select, and file proposals electronically. Moreover, Confidential allows for teh processing and awarding of contracts and facilitates teh generation of award documents. Teh system utilizes several E-Business modules including, Oracle Contract Core, Oracle Project Contracts, Oracle Purchasing, Oracle General Ledger, Oracle Fed Admin, and Oracle Human Resources. Confidential also interfaces wif other external systems like PRISM, STARS, and Defense Travel System (DTS).
• As teh Senior Developer on teh team, my responsibilities include leading a team of 4 developers; maintaining teh system; and designing, developing, and implementing new enhancements. These development and maintenance efforts include maintaining and enhancing custom Oracle Forms and Reports, Oracle Workflows, Oracle Discoverer Reports, Oracle Application Express (APEX) screens, and some Java programs.
• Designed and developed custom interfaces using PL/SQL packages, SQL*Loader, and UNIX shell scripts datloaded data from inbound flat files, validated teh data, and move teh data into teh Purchase Document Open Interface table. Teh specific interfaces include: PRISM, STARS and DTS.
• Maintained and modified custom PO, Project Contracts (OKC/OKE) forms using Oracle Forms 6i
• Develop and customized/enhanced existing reports using Oracle Reports, Oracle BI (XML) Publisher, Oracle BI Discoverer reports.
• Customized, personalized and enhanced core application forms using forms personalization and custom pll library.
• Developed new workflows and customized several workflows including teh purchasing and requisition account generation processes; contract change requests processes, and contract communication action processes.
• Utilized a combination of performance tuning strategies including subprogram Inlining, DBMS Result Cache, stored outline, hints, and indices to tune SQL statements operating on a production database over 1 TB in size.
• All development efforts are performed in an Oracle 10g/11g environment on a Linux platform utilizing PL/SQL and Java.

Confidential, MD

Managing Consultant

Responsibilities:

• Responsibilities included design and development of custom programs to include data migration/conversion, interfaces, reports and extensions for Oracle Federal Financial modules (Payables, General Ledger, Purchasing, Receivables, Federal Admin, Grants).
• Designed and developed conversion processes/programs to map and migrate data from CMS internal and external legacy systems to Oracle E-business Federal Financials. External legacy systems included data from all Medicaid/Medicare contractors.
• Designed and developed custom purchase document open interface program (PDOI) and custom receiving open interface (ROI) for PO using PL/SQL packages, SQL Loader and UNIX. Interface program loaded data from inbound flat files, validated teh data and populated teh purchase document open interface and receiving open interface tables. Interface worked on include GovTrip/Travel Order. Outbound acnoledgement extract files were generated
• Developed custom payable open interface program for AP using PL/SQL packages, SQL Loader and UNIX. Interface program loaded data from inbound flat files, validated teh data and populated teh AP open interface tables. Interface worked on include GovTrip - Travel Voucher, Travel Advances.
• Developed custom receivable open interface program for AR using PL/SQL packages, SQL Loader and UNIX. Interface program loaded data from inbound flat files, validated teh data and populated teh AR open interface tables. Interface worked on include GovTrip/ Sponsor Travel Invoice.
• Designed and developed custom forms and reports using Oracle forms 6i/9i, Oracle Reports 6i and PL/SQL.
• Designed and developed Oracle BI (XML) Publisher reports.
• Designed and developed Oracle Discoverer reports.
• Customized purchase order and requisition account generation process using Oracle Workflow.
• Designed ETL processes to populate data warehouse tables utilizing Informatica.
• Designed Informatica mappings (Stage) to include source tables, mapping parameters and variables, target objects and mapping transformations (maplets).
• Maintained Informatica workflow processes and tasks.
• Interfaced on a regular basis wif project sponsors, stakeholders including project team members to define business needs and determine requirements for database design, data migration and conversion, interfaces, and reports.
• Analyzed requirements and business rules gatheird during JAD sessions and transformed these requirements into a formal functional/technical specification document.
• Designed conceptual and logical data models from these business rules using Erwin Data Modeler.
• Designed and developed technical programming specifications for RICEW components for all modules including complex forms and reports, interfaces, conversions, and extensions.
• Utilized a combination of performance tuning strategies including subprogram Inlining, stored outline, hints, and indices to tune SQL statements operating on a production database over 1 TB in size.
• Developed system, user acceptance and regression test plans and test cases; validated system requirements by thoroughly testing software to ensure dat it was free from defects, technically sound, and well-integrated
• Conducted functional/technical design and unit test plan walk-through wif clients and stakeholders.
• Prepared complete and in-depth functional and technical design; and unit test plan documents.
• Provided training on a functional level.
• All development efforts were performed in an Oracle 11g environment on an IBM AIX platform.

Confidential, Rockville, MD

Sr. Database Developer/DBA

Responsibilities:

• Involved in teh development and programming of a new custom system for teh Food and Drug Administration called SRS/CID. Teh Substance Registration System/Center Ingredient Dictionary system replaced teh SRS and CID systems and combined teh features of these systems wifin a modern application environment dat integrated teh MDL software wifin a J2EE environment. Teh objective of dis project is to enable Confidential to efficiently, effectively and reliably maintain unique identifiers for substances in drugs, biologics, foods and devices and make them available for use in health information systems.
• Designed and developed teh process for mapping, converting and migration of teh legacy SRS and CID databases residing on VMS Alpha platform to teh SRS/CID database of Oracle 10g (10.1.0.2) on Solaris (UNIX) environment.
• Designed Informatica mappings to include source tables, mapping parameters and variables, target objects and mapping transformations (maplets).
• Designed and developed teh data replication process to replicate updates, inserts and deletes back to teh Oracle 8i instance on teh VMS Alpha platform. Created Materialized View and Materialized View Log to facilitate FAST replication.
• Developed stored packages/procedures and database triggers to populate teh core and history tables using Oracle 10g, PL/SQL.
• Designed and developed reports using teh Oracle Reports tool.
• Performance tuned long running SQL statements in a production environment using a combination of hints, stored outlines, and single/multi attribute indexes.
• Performed basic database administrative functions including instance creation, instance startup and shutdown, backup and restoration.

Confidential, Washington, DC

Sr. Oracle Developer

Responsibilities:

• Member of teh VN-FAS development team responsible for providing a system to perform hedge effectiveness testing as per FAS133 regulations on stand-alone derivative portfolios.
• Interfaced wif users to determine requirements for database design, screen layouts, backend processes and reports generation.
• Designed logical and physical data models using Oracle Designer 2000.
• Designed and built front-end web interfaces using Oracle PL/SQL, Java, Java Server Pages (JSP), HTML, JavaScript, and JDBC.
• Developed backend processes including stored packages/procedures, servlets, database triggers and Unix Korn Shell scripts, using Oracle 9i/10g, PL/SQL, Oracle XML API’s, Java.
• Developed complex web reports using Oracle Reports 9i, OracleBI Discoverer Plus, PL/SQL and Oracle XML.

Confidential, Rockville, MD

Sr. Oracle Applications Developer

Responsibilities:

• Member of teh AIMS development team responsible for teh design, development, conversion and rollout of several Oracle web-based tracking applications for teh Food and Drug Administration. Applications worked on include: Federal Register Tracking System, Dockets Repository, Ethics Tracking System, Disclosure FOI System Correspondence Tracking System and teh Intercenter Consult Review Tracking System. dis development effort included converting from SQL Server 7 to Oracle 9i.
• Interfaced wif users to determine requirements for database design, screen layouts, backend processes and reports generation.
• Analyzed requirements and business rules gatheird during JAD sessions and designed conceptual and logical data models. Conducted logical data model walk-through; addressed data integration issues; assisted in teh design and implementation of teh physical database structure.
• Designed and built front-end web interfaces using Oracle PL/SQL web Toolkit, HTML, JavaScript and Java Server Pages (JSP).
• Developed backend processes including stored packages/procedures, servlets, database triggers and Unix Korn Shell scripts, using Oracle 9i, PL/SQL, Java and Java Server Pages (JSP).
• Converted SQR reports to Oracle reports.
• Developed complex web reports using Oracle Reports 9i and Oracle PL/SQL web Toolkit.
• Prepared in-depth programming and system documentations.
• Provided formal classroom training.

Confidential, Washington, DC

Senior Oracle Applications Specialist

Responsibilities:

• Member of a development team responsible for teh design, development and deployment of an Oracle web portal for teh Research, Education and Economics Information System of teh Department of Agriculture.
• Installed Oracle 9i Application Server.
• Configured Oracle HTTP Server and 9iAS Portal.
• Extracted, transformed and loaded data from various source systems using Oracle Warehouse Builder (OWB), Sql Loader, Pl/Sql and Oracle 8i/9i.
• Designed and built front-end web interfaces (pages, folders, content areas, forms) using Oracle Portal wizard, Oracle PL/SQL web Toolkit, HTML, XML, JavaScript and Forms 6i.
• Designed and built web reports using Oracle Portal report builder, Oracle 9ias Discoverer, Oracle Reports 6i and Oracle PL/SQL web Toolkit.
• Designed and built custom search engine for deployment on teh web site using Oracle interMedia Text, Oracle Text and Ultra Search. Different kinds of searches, including keyword, fuzzy, stem and thesaurus search operators are utilized.
• Prepared complete and in-depth functional and technical design document.