Sr. Oracle Application Programmer/security Analyst Resume
EXPERIENCE SUMMARY:
- Experience encompasses fifteen 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.
- Twelve plus years Oracle E-Business implementation and development experience, with about eight years E-Business R12 experience.
- Knowledge and experience in the following Oracle E-Business modules: Payables (AP), Payments (IBY), Purchasing (PO), Receivables (AR), General Ledger (GL), Federal Vertical (FV)
- Ten plus years designing and developing Oracle EBS RICEW components.
- Fifteen plus years Oracle PL/SQL development utilizing several advance features
- Ten plus years implementing performing tuning strategies like table partitioning, explain plan, and trcsess.
- Ten plus years developing Oracle Forms and Reports
- Six years Oracle Workflow design and development
- Seven years Oracle BI (XML) Publisher report design and development.
- Four years’ experience extending and personalizing Oracle Application Framework (OAF) pages
- OBIEE experience with a solid understand of the physical, business, and presentation layers
- Experience with Oracle replication and materialized views
- Knowledge and experience in administering Oracle WebLogic Server.
- Knowledge and experience in Oracle Identity Governance/Manager 11gR2 PS3.
- Knowledge and experience in Data Warehousing with solid understand of the 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 creating MD50/MD70 documents.
- Knowledge and in Oracle Fusion Cloud applications security.
- Successful in designing and developing solutions to complex tasks on time and under budget.
- Possesses Project Management and Information Assurance knowledge.
- Excellent interpersonal, written and verbal communication skills
- Self-motivated, details oriented multi-tasker with 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 12c, BMC Remedy, HPQC ALM, Oracle Identity Governance 11gR2 PS3
PROFESSIONAL WORK EXPERIENCE:
Confidential
Sr. Oracle Application Programmer/Security Analyst
Responsibilities:
- Installed, deployed, and configured Oracle Identity Manager/Governance (OIG) 11gR2 PS3 for high availability using WebLogic Server 12c.
- Configured SSL support for OIG/OIM and GRC.
- Created self-signed custom s (keystore) for use in development and test environments
- Installed and configured pre-defined connectors to include connectors for PeopleSoft, EBS, OUD, Microsoft Active Directory and DBAT using the Manage Connector tool.
- Provisioned users, application instances, roles and entitlements using Request-based and Policy-based provisioning.
- Perform authoritative and account reconciliations from various target and trusted resources.
- Configured approval workflows and workflow policies for various request type to include User Management, Role Management, and Bulk request type.
- Configured definitions for user, role, entitlement, and application instances
- Load users, roles, organizations into OIM using the Bulk Load Utility
- Configured OIM Identity Audit to detect, prevent, and resolve separation of duties (SOD) violations
- Create password policies and associate them with organizational entities like department and branches
- Create user, access policy, identity audit, and entitlement reports among others using BI Publisher.
- Utilized OIM SCIM API for user and role managementl.
- Deployed and configured EGRC/AACG on-premise application
- Configured and setup EGRC for high availability using WebLogic 12c.
- Upgraded EGRC/AACG through the various patch levels up to the most current version
- Liaised with business process owners to design and develop SOD risk libraries.
- Created Access models from SOD risk libraries and deployed these models as controls.
- Created AACG entitlements and global conditions.
- Created access simulation and developed remediation steps for resolving access control incidents
- Installed and configured Preventive Enforcement Agent (PEA) to manage AACG access approvals.
- Applied patches using the OPatch tool.
- Document installation and configuration procedures.
onfidential, Arlington, VA
Oracle EGRC/Audit Vault Analyst
Responsibilities:
- Installed and configured EGRC on-premise application
- Installed and configured Oracle Identity Manager (OIM) 11gR2 PS3.
- Configured and setup EGRC and OIM for high availability using WebLogic 12c.
- Configured SSO and Single Logout for authentication and access to GRC suite of products
- 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
- Managed access approvals
- Created Standard Operating Procedures (SOP) documents for both AACG and ETCG.
- As the Audit Vault administrator, responsibilities included:
- Configuring, designing, and managing Audit policies and provisioning them to the database
- Designing and developing audit policies for SQL, Schema Objects, Privileges, and Fine-Grained Auditing (FGA) using PL/SQL advance features
- Designing and developing audit policies for Capture rules for Redo Log File auditing
- Developing custom reports in various format using BI Publisher
- Customizing the built-in reports
- Audit Policies are created using PL/SQL and 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 the DSAMS, MISIL, and DIFS conversion. SCES is DSCA’s ERP solution, and DSAMS, MISIL, and DIFS are legacy systems.
- Developed automated validation processes for the 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 the 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
Responsibilities:
- Involved in the 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 the 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 the setup and configuration of Oracle Approval Management Engine (AME) to create and define approval hierarchies and approval rules and link them with 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 s/IDVs/Solicitations to include: Modifications, SF30; /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 the AP Invoice Approval Workflow to create separate approval routes for CLM and non-CLM invoices.
- Customized the PO CLM Approval Workflow using AME
- Customized the PA (Project) Budget Workflow to add additional approval roles
- Customized and developed several PA (Project) reports, to include both expenditure and financial reports.
- Developed several BI Publisher reports in both RTF and Excel format with bursting capabilities.
- Developed OBIEE reports using both BI Answers and BI Publisher.
- Performed system administration tasks on the OBIEE such as creating Groups and assigning users to Groups. Also, created new shared folders and assigned Groups to the shared folders and shared Dashboards.
- Created OBIEE Shared Dashboards and shared prompts.
- Customized and enhanced the Federal PAM ACH Payments Format and Federal PAM Check Payments eText templates
- Resolved production break fixes.
- Customized, personalized and enhanced core application forms using forms personalization.
- Personalized OAF pages and developed extensions for view/entity objects, controllers and Application module (AM) attached to Oracle Application Framework (OAF) pages using Oracle JDeveloper 10g/11g
- Added LOVs to OAF page(s) from custom view objects
- Developed and sustained several interface and conversion programs to include:
- 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:
- Involved in the 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 with 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 the OAF Supplier entry page.
- Personalized and develop view/entity object extensions to modify LOVs and add a field to the page and populate it with value from the VO.
- Extended the OAF page Controller to hide/unhide field based on condition that is determined by the value of a field.
- Customized forms functionality by modifying the 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 that loaded data from flat files, validate the data, and move the data into the GL Open Interface table. The specific GL interface include Working Capital Fund interface.
- Designed and developed supplier conversion interface to load data into the 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:
- As the Senior Developer on the team, my responsibilities include leading a team of 4 developers; maintaining the 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 ( Confidential ) screens, and some Java programs.
- Designed and developed custom interfaces using PL/SQL packages, SQL*Loader, and UNIX shell scripts that loaded data from inbound flat files, validated the data, and move the data into the Purchase Document Open Interface table. The 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 the 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, Linthicum, 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 the data and populated the purchase document open interface and receiving open interface tables. Interface worked on include GovTrip/Travel Order. Outbound acknowledgement 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 the data and populated the 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 the data and populated the 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 with 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 gathered during JAD sessions and transformed these requirements into a formal MD50/MD70 documents.
- 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 that it was free from defects, technically sound, and well-integrated
- Conducted functional/technical design and unit test plan walk-through with clients and stakeholders.
- Prepared complete and in-depth functional and technical design; and unit test plan documents.
- Provided on a functional level.
- All development efforts were performed in an Oracle 11g environment on an Confidential AIX platform.
Confidential, Rockville, MD
Sr. Database Developer/DBA
Responsibilities:
- Designed and developed the process for mapping, converting and migration of the legacy SRS and CID databases residing on VMS Alpha platform to the 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 the data replication process to replicate updates, inserts and deletes back to the Oracle 8i instance on the VMS Alpha platform. Created Materialized View and Materialized View Log to facilitate FAST replication.
- Developed stored packages/procedures and database triggers to populate the core and history tables using Oracle 10g, PL/SQL.
- Designed and developed reports using the 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.