SUMMARY

• 9+ years of Technical experience in customizing, PeopleSoft integrations Oracle Applications and Oracle Fusion Financials using PL/SQL.
• Worked predominantly in HealthCare domain for handling HIPAA privacy.
• Experienced in database performance and performance tuning.
• Strong working knowledge in Oracle Fusion Financials implementation and Oracle Identity Management (OIM).
• Extensively worked with Oracle 12c/11g/10g/9i/8i, SQL, PL/SQL, TOAD, Discoverer (10g /4i), XML/BI Publisher, SQL*Loader, WebADI, Forms 6i/10g, Reports 6i/10g, OBIEE
• Very strong development experience in Reports, Interfaces, conversions, and extension (RICE) components in Oracle Applications.
• Good knowledge of key Oracle performance related features such as Query Optimizer, Execution Plans and Indexes and Experience with Performance Tuning for Oracle RDBMS using Explain Plan and HINTS.
• Strong working knowledge on the design and configuration of Chart of Accounts (COA), Multi Org Access Control (MOAC), GL Accounting Cycle and GL Work Flow.
• Extensive experience in all phases of full life - cycle Oracle Applications implementation i.e. Requirements Gathering, Analysis, Application Configuration, Development, Testing, Implementation, Post Go-Live Support, Production support, User Training and Documentation
• Expertise in writing Fast Formulas for Oracle HRMS (OAB) and Compensation Work Bench (CWB).
• Functional & Technical Expertise in OAB Open enrolment processes.
• Prepared Functional (MD50), Technical (MD70), Conversion (CV40/60) and Business Requirement/Mapping (BR100) documents using AIM methodology.
• Very strong development experience in Reports, Interfaces, conversions, and extension (RICE) components in Oracle Applications.
• Strong knowledge in creating RTF templates in MS Word by connecting to XML and BI Publisher, and publish these templates for the reports to view data in OBIEE BI Publisher
• Experienced in developing Conversion Programs, Inbound and Outbound Interface, Forms Customization, and Oracle Alerts.
• Exposure to OFSAA and participated in multiple Oracle apps r12 implementations in multi org/multi-currency scenarios.

TECHNICAL SKILLS

Languages: PL/SQL, UNIX

Primary Skills: Oracle Fusion Financials, OIM (Oracle Identity Management) R12 General Ledger, Sub Ledger Accounting, Finance Accounting Hub(FAH), Oracle Fusion Accounting Hub, Oracle Reports & Forms, XML Publisher, Core HR, Oracle Advanced Benefits, Financial Accounting Hub. Oracle Applications 11i (Core HRMS, Oracle Advanced Benefits (OAB), Oracle Reports and XML.

Operating Systems: MS Windows 98/NT/2000/XP, Windows Server 2003

Development tools: TOAD, SQL*Plus Navigator Oracle Forms & Reports 6i and Oracle Discoverer (3i and 10i)

Databases: Oracle 8i /9i/10g/11g/12c

ERP: Oracle Applications E-Business Suite 11i & R12, Oracle Fusion.

Oracle Fusion: Financials, OIM (Oracle Identity Management)

PROFESSIONAL EXPERIENCE

Confidential, San Antonio, TX

PL/SQL Technical Consultant

Responsibilities:

• The project involved installation, development, planning, design and coding of various custom solutions as well as new enhancements and taking care of the release of custom code for Fusion Financials Module.
• Customized the delivered API using PL/SQL as per client requirements
• Designed and analyzed the HIPAA and Medicare requirements for migrating purpose.
• Developed a custom program for sending the HIPAA certificate as per the standards expected.
• Designed and developed custom validation program with extensive PL/SQL packages and stored procedures.
• Developed a custom program for sending email notifications to the users when any of the program completed with error.
• Developed Custom wrapper program for automating the jobs with Control M scheduler using PL/SQL and shell scrips.
• Developed a custom solution using post Accounting hook for Accrual reversal for the journals passed through FAH.
• Involved in the Fusion version 10 upgrade and customized the Manual journal upload in the XLA tables. Also installed a fully customized workflow for the same using the SOA services in the Fusion middle ware
• Tuning of PL/SQL Stored Procedures using HINTS in Explain Plan.
• Customized the application roles in OIM (Oracle Identity Management) and designed Custom roles for enabling read only option for the users using PL/SQL.
• Developed a customized code for the foreign ledger configuration and accounting rules set up.
• Performance tuned the database as well as the delivered PL/SQL packages using optimum values and data analysis.
• Custom Roles for enabling the differentiating the access the business and implementation user.
• Configured the Open enrollment with new plans, rates, extracts and eligibility profile.
• Designed and developed Full C extract for EOI and underwriting files.

Confidential, TX

Oracle Pl/SQL Consultant

Responsibilities:

• Designed, created and tested enhancements to a high performance OLTP client server system processing for both daily and scheduled financial transactions.
• Involved in designing Technical Design Documents based on health care Business requirements.
• Extensively used advanced PL/SQL concepts (e.g., varrays, PL/SQL tables, cursors, user defined object types, exception handling, database packages, nested tables) to manipulate data
• Wrote packages and procedures to move data from one table to another.
• Created indexes on tables to improve performance of the queries
• Used BULK COLLECT to fetch large volume data.
• Used Control - M a third-party tool to schedule various others batch processing jobs.
• Involved in the performance tuning of various database queries. The queries retrieved data from different tables in multiple databases.
• Used EXECUTE IMMEDIATE to execute dynamic SQL.
• Used Explain Plan, TK Prof in tuning queries.
• Used analytical functions like LEAD, LAG.
• Raised Siebel exception using PL/SQL packages.

Confidential

Oracle Finance Technical Consultant

Responsibilities:

• Worked on requirement health care Documentation.
• Involved in Creation of database objects like tables, views, procedures, packages using Toad, SQL* Plus.
• Used Sql Loader for loading data from flat file to staging tables.
• Used Bulk Collect in Pl Sql block of code for loading data from staging tables to main tables.
• Used Explain Plan, TK Prof in tuning queries.
• Developed different procedures, packages and triggers in Toad.
• Designed and developed Oracle PL/SQL scripts for Data Import/Export.
• Worked on various backend packages with Procedures and Functions using PL/SQL.
• Wrote PL/SQL stored procedures, functions, packages as required in the health care system.

Confidential

Oracle PL/SQL Technical Consultant.

Responsibilities:

• Development of concurrent program to extract date from the Oracle database to .csv files to be loaded in to the legacy database by using UTL FILE.
• The R12 migration of all the Oracle modules was carried out successfully from 11i. This involved modifying the custom solution to make them work on R12 platform, bring new and advanced features into use so as to benefit the client
• Custom P2P (Procure to pay) Process: The process of procuring material from the organization and getting paid for the process of handling material. This process picks the PO’s which have AP invoice option defined in DFF and create Requisitions and creates against the Supplier.
• Designed and executed ‘Data migration’ strategy for master and transactional data. Post go-live support.
• Developed several XML publisher reports for Oracle HRMS and Fusion Financial modules.
• User interaction and requirement gathering for new enhancements and resolved ongoing support tickets.
• Fine-tuned the interface using SQL*Trace and TKPROF and worked on a couple of patches for year-end processing.
• Extensively resolved issues in the GL Accounting cycle (Translation, Revaluation, Conversion, Consolidation)

Confidential

Oracle PL/SQL Technical Consultant.

Responsibilities:

• Enhanced of the existing interface using PL/SQL Developer for File transfer.
• Developed RDF Reports and XML reports using Reports 6i/10g and XML Publisher
• Worked on configuration changes for Brazil New entity (R12)
• Configured Audit Trial for the Mapping sets to enhance the security while DML operations.
• Analyzing issues reported by business in standard and custom oracle functionality and finding fixes for the issues.
• Preparing Understanding documents, Design Documents, Unit Test Plans.
• Gathered the requirements, enhanced and fine-tuned the Interface program using PL/SQL.
• Developed the custom validation program using PL/SQL and the outcome of the validation will be sent out as a PDF reports to the users.

Confidential

Oracle PL/SQL Consultant

Responsibilities:

• Designed Derived Factors, Life Events, Standard Rates, Variable Rates, and Coverage Calculations, Actual Premiums etc.
• Form customization to enable COBRA Subsidy and developed Fast Formulas.
• Developed OAB fast formulas for Person Change Cause Life event, Enrolment Coverage Start Date, End Date, Rate Start Date, Rate End Date, Coverage lower and upper limits, Dependent Eligibility rule, and Length of Service Date, Waiting Period Value and UOM formula types.
• Developed outbound interface programs for OAB as per HIPAA compliance for Medical, Dental, Vision, COBRA and FSA Benefits information using System Extract processes to send interface files to third party providers.
• Handled Annual Open Enrolment for two prestigious customers of Fidelity - Confidential & Alstom
• Developed custom date track forms to maintain employee union benefits and integrated with Oracle HR.
• Created complex reports (On demand, Adhoc Reports, Summary Reports, and Letter Formatted, Graphical etc.) using XML Publisher and ODBI Reports.
• Preparing Understanding documents, Design Documents, Unit Test Plans.
• Designed and configured the grade structure
• Involved in the configuration of ODI.