SUMMARY

• 13 years of experience working with Oracle EBS 11.5.10 and R12.
• Played three different roles in Oracle EBS, Techno - Functional Support Engineer, EBS Senior Developer, and EBS Technical lead.
• Techno-Functional experience on Oracle Discrete Manufacturing (INV, BOM and WIP), O2C Cycle (INV, QP, OM, AR) and Financial Modules (GL, CM, and FA).
• Experience on Creation of FSD, TDD, SDLC documentation as long with AIM Methodology MD050, MD070, and BR100
• Participated in 12 projects using different Oracle development tools (RICE) like Discoverer (Administrator, Desktop and plus), Forms, Reports, PL/SQL, BI Publisher, OAF (Oracle Applications Framework), forms personalization, Workflow, and WEB ADI.
• Experience with SQL tuning advisor to improve/fix performance issues.
• Worked with Oracle Support on the creation of SRs (Service Requests) S1 to resolve issues that affect month-end close activities.
• Overseen that custom code has aligned with Oracle EBS best practices (legibility, indented code, avoid performance issues, avoid hard code)
• Worked together with BSA (Business System Analyst) in the creation of an FSD (Functional Specification document) document, plan the testing plan with different scenarios.
• Followed up with developers that every phase (Design, Development, Testing, QA Deployment, Testing with BSA, testing with business users, PROD deployment) of the development is completed according to the timeline plan until they go live in Production
• Worked on integration of Oracle modules with legacy and third-party systems using BI and Web Services for Oracle Cloud integrations.

TECHNICAL SKILLS

Primary Skills: Oracle EBS development tools (RICE), PL/SQL, Forms, Reports, BI Publisher, OAF (Oracle Applications Framework), WEB-Adi, Form Personalization.

ERP Versions: Oracle EBS (11.5.10.2), Oracle EBS (12.2.5)

Operating Systems: Linux, Window 7, Windows 10

Languages: PL/SQL, Java

Modules: Oracle Applications 11.5.10 and R12, AR, AP, OM, INV, PO, QP, GL, FA, CM, WSH, BOM, and WIP.

Development Tools: Toad 13.0, Oracle Forms, Oracle Reports, Discoverer, BI Publisher, WEB Adi, JDeveloper, Workflow Builder.

Database: Oracle 10g, 11g, 12c.

PROFESSIONAL EXPERIENCE

Confidential

Oracle EBS Technical lead

Responsibilities:

• Oversee, review and ensure the development life cycle of a couple of projects in FA, one for cost adjustments and one another for Mass Retirements with the creation of a couple of custom dashboards using OAF
• Participated in the testing plan with the addition of new test cases
• Ensure the code behind every development fulfills the best practices, avoid a full table scan, ensure code is well written and legible for other developers, ensure hard code is avoided (use of lookups), and ensure naming convention of the new objects created, has reviewed SQL plans as well.
• Participated in the creation of SDLC (Software Development Life Cycle)
• Participated in the creation of TDD (Technical Design Document) Documents
• Provided suggestions to avoid performance issues using the SQL tuning advisor
• Has been performed the role such as code reviewer as well

Environment: s: Oracle EBS R12, Forms and Reports Builder, BI Publisher, OAF, PL/SQL, Bursting Utility, OAF, Financial modules: CM, OM, AR, FA, and GL.

Confidential

Senior Oracle EBS Developer

Responsibilities:

• Oracle Applications Developer, using Oracle Applications Framework, Oracle Forms, Oracle Reports, PL/SQL, Oracle BI Publisher, and WEB ADI.
• Custom Report using BI Publisher that lists unposted journal entries either are stuck in GL INTERFACE due to errors or unposted in GL transactional tables.
• Custom report using BI Publisher to list who and when has unfrozen any source in GL, this is because by SOX compliance every change in any frozen source needs to be tracked, audit trail has been enabled in table GL JE SOURCES, every change on this table is tracked on GL JE SOURCES TL A
• Implemented a forms personalization in GL to disable the post button if the same user who created the Journal entry is the same user who is trying to post it. By SOX compliance the same user who creates the GL journal cannot be the same users who post it.
• Developed a new form using oracle forms called Global Posting Form, this form was useful to facilitate the close of GL since this allows business users to post journal entries from any entity.
• Create LDT files to set incompatibilities between concurrent programs.
• Used the SQL tuning advisor DBMS SQLTUNE to improve the performance of some custom reports
• Created a custom report to list all the sources and categories available in GL, based on GL JE SOURCES and GL JE CATEGORIES
• Developed a new OAF page to insert BD (Business Dates) days, those business days are used to control holiday dates and when the GL close starts and ends. Data within the page are inserted into a custom table called BD CALENDAR MAPPING.
• FAME Project (Fixed Assets Month End), project to optimize the close in Fixed assets, Depreciation will be run every week for all the active FA Books (Scheduled Program), then, Fixed Assets Create accounting program will be run in Draft mode (Scheduled program), this way will help the FA team to detect issues earlier in the month and simultaneously constricts their timeframe to triage any issues found within business days
• Custom Dashboard to perform Mass Transfers in Fixed Assets with OAF, Business Users will upload assets for Mass transfers via an Excel upload into Dashboard. Regional leads will review this information and provide their approval in the Dashboard. Once the Assets are approved; business users will process them for Mass Transfers in Oracle using the Standard APIs. A custom program will be called to process all the records in Oracle by performing validations
• New custom page in OAF where the user will upload the CSV File to perform Mass Transfers
• The content of the File will be inserted into a custom table
• Custom validations will be performed in the data inserted into the custom table
• If all the validations are passed, data will be inserted into custom transactional tables (Dashboard Tables)
• If errors are found while performing custom validations custom program will complete in Warning and data will not be inserted into custom transactional tables
• The report output (BI Publisher report) will be sent to the user by email providing details
• The business user can inquiry the dashboard and request approval by the regional lead
• The regional leaders will be notified by email to approve or reject the content of the CSV file
• Regional lead will login into Oracle EBS, query the dashboard and approve/reject
• Either the regional lead approves or rejects, the business user will be notified by email
• If the regional leader has approved, then, a business user can submit for final processing
• In Final processing, the content of the file will be passed through the standard APIs for Mass Transfers FA TRANSFER PUB.do transfer
• Custom Dashboard to perform Mass Changes in Fixed Assets with OAF, as part of the project, Business users will upload assets for mass changes via an Excel upload into Dashboard. Regional leads will review this information and provide their approval in the Dashboard. Once the assets are approved, Business users will process them for mass changes in Oracle. A custom program will be called to process all the records in Oracle by performing validations and Calling standard APIs.
• New custom page in OAF where the user will upload the CSV File to perform Mass Changes
• The content of the File will be inserted into a custom table
• Custom validations will be performed in the data inserted into the custom table
• If all the validations are passed, data will be inserted into custom transactional tables (Dashboard Tables)
• If errors are found while performing custom validations custom program will complete in Warning and data will not be inserted into custom transactional tables
• The report output (BI Publisher report) will be sent to the user by email providing details
• The business user can inquiry the dashboard and request approval by the regional lead
• The regional leaders will be notified by email to approve or reject the content of the CSV file
• Regional lead will login into Oracle EBS, query the dashboard and approve/reject
• Either the regional lead approves or rejects, the business user will be notified by email
• If the regional leader has approved, then, a business user can submit for final processing
• In Final processing, the content of the file will be passed through the standard APIs for Mass Changes fa adjustment pub.do adjustment and FA ASSET DESC PUB.update desc
• Custom Dashboard to perform Mass Reclassifications in Fixed Assets with OAF, as part of the project, Business users will upload assets for mass reclassification via an Excel upload into Dashboard. Regional Leads will review this information and provide their approval in the Dashboard. Once the assets are approved, business users will process them for mass reclassification in Oracle. A custom program will process all the records in Oracle by performing validations and calling the standard APIs.
• New custom page in OAF where the user will upload the CSV File to perform Mass Reclass
• The content of the File will be inserted into a custom table
• Custom validations will be performed in the data inserted into the custom table
• If all the validations are passed, data will be inserted into custom transactional tables (Dashboard Tables)
• If errors are found while performing custom validations custom program will complete in Warning and data will not be inserted into custom transactional tables
• The report output (BI Publisher report) will be sent to the user by email providing details
• The business user can inquiry the dashboard and request approval by the regional lead
• The regional leaders will be notified by email to approve or reject the content of the CSV file
• Regional lead will login into Oracle EBS, query the dashboard and approve/reject
• Either the regional lead approves or rejects, the business user will be notified by email
• If the regional leader has approved, then, a business user can submit for final processing
• In Final processing, the content of the file will be passed through the standard APIs for Mass Reclass fa reclass pub.do reclass

Environment: s: Oracle EBS R12 (12.2.5), PL/SQL, BI Publisher, OAF, Bursting functionality, Reports and Forms builder, Financial Modules: FA, GL, AP.

Confidential

Oracle EBS Techno-Functional

Responsibilities:

• Provide support to business users on Daily operation of Oracle EBS through SLA (Service Level Agreement)
• Provide Support for financial month-end close activities within CM, FA and GL Modules
• When required, working on enhancements required to the current Functionality.
• Working with Oracle Support Following Service Requests S1, S2
• Daily handoff meetings with Offshore support team
• Create complex SQL Queries to provide data extracts according to Auditors requests
• Provide support to users when they are requesting new responsibilities within Oracle EBS
• Monitor from back end concurrent programs that are important for close in GL such as Mass allocation
• Monitor from back end concurrent programs for Revaluation, Translation
• By SOX compliance ensure once a Frozen source in GL needs to be unfrozen request authorization
• Monitor GL INTERFACE table to check transactions stuck due to errors
• Provide data extracts from back end to business users when a monthly reversed journal is not reversed
• Every time a new entity is created in EBS perform the manual steps to set up the entity in GL
• Every time a new entity is created in EBS perform the manual steps to set up the entity in FA
• Enable the Audit trail on table GL JE SOURCE to catch when the source is unfrozen and who did it
• Provide support to business users when they were not able to post a batch in GL.
• Provide data extracts based on GL table GL JE BATCHES, GL JE HEADERS and GL JE LINES
• Inform business users when a code combination is GL is end dated and it is used in GL JE LINES
• Inform the business users when a transaction in a cash management statement is not yet reconciled
• Monitor CM interface tables for errors while importing to CM transactional tables
• Creation of custom reports using BI Publisher report listing unposted GL transactions within the current open period
• Provide support to business users when they were trying to create Assets in FA using WEB ADI
• Enhancement to WEB ADI template to create Assets in FA, making DEPRECIATION FLAG column enabled at header level instead of lines level
• Monitor of table FA MASS ADDITIONS to check FA Assets stuck in the interface table
• Provide support to business users with Split functionality in FA
• Provide support to business users with Merge functionality in FA
• Provide support to business users because of several times when running the program
• Mass Additions Create it did not create FA Records in FA MASS ADDITIONS table
• Helped the business users on teaching how to run CM Reports like:
• Bank Statement Detail Report and Bank Statement Summary Report
• Provided support to perform FA Mass Transfers, Mass Changes, Mass Revaluations
• Mass retirements and Mass reclassifications.
• Monitor concurrent program “Run Depreciation” from fixed assets
• Monitor JERL report in fixed Assets
• Perform the manual creation of FA Corporate books in Fixed Assets
• Performed the manual creation of FA Categories

Environment: s: Oracle EBS R12, Toad, BI Publisher, Reports, Forms, PL/SQL, Bi Publisher, workflow Builder, OAF, Financial modules: CM, FA, GL