PROFESSIONAL SYNOPSIS:

• Around 9.6 years of strong experience, includes Development, implementation, Support, customization of Oracle Application 11i & R12.2.6 using FIN & SCM P2P Modules (AP, AR, GL, CM, PO, INV, and OM, HRMS (Core - HR Payroll) in System Administrator, Application Developer).
• And Oracle Technologies (Reports 6i, Forms 6i, Forms Personalization, Oracle Discoverer 4/9.0/10g, Oracle Workflow 2.6, Oracle Alerts, Oracle 11.2/10g/8.0/8i/9i and PL/SQL under Windows/UNIX environment.
• Result focused & effectual point contact with strong communicational skills, over 9+ years of experience in IT Industry.
• Proactively identifying & resolving problems.
• Possess motivational management style with a record of building effective team work.
• Possess expertise in multicultural environments with the distinction of understanding, setup/streamline operations, a skilled communicator with exceptional presentation skills and abilities to lead cross-functional teams.
• Played a single point contact role for one of the critical implementation, support and enhancement in Oracle FIN & SCM modules (AP, AR, GL, CM, PO, INV, and OM. Oracle could FIN HCM.
• Ensured implementation & Support as a member owning Finance & Distribution Modules like GL, AP, AR, FA, GL, PO, INV, HRMS (Core- HR Payroll). (EBS R12, and HCM, FIN Cloud)
• Enhanced EBS Techno-Functional support of the current EBS environment
• Working production support team by assisting in application of patches, change control and coordination of system availability. Conduct research and testing of patches necessary to correct bugs and enhance system functionality.
• Provided customized support of the current payment system in AP invoices, attachments, expense, pre invoice workflow payment issues, Process Flow Reconciliation issues.
• Maintain the vendor master list customer master list purchase orders, item master, item details (on hand, cost etc.), and attachments Price lists.
• Involved in AR transactions, adjustments, receipts, customer calls.
• Extensive on-site exposure during Oracle Financials Migration in Saudi Arabia, NGHA (National Guard Health Affair Riyadh in Saudi).
• Worked in Financial implementations and production support. Provided innovative solutions to unique customer requirements.
• Major Involvement/Key member in end to end Oracle Financials implementation.

TECHNICAL SKILLS:

ERP: Oracle application11i/R12.2.4 (AP,AR, GL,FA,CM,PO, inv, OM, AOL System Admin)

Tools: & utilities Oracle Forms 6i, Oracle Reports 6i, Oracle Discoverer 10g, BI Publisher,XMLublisher, Oracle Workflow, SQL* Plus, Toad, FTP, putty, Rational Clear Case, Clear Quest, SVN, RADAR, CA Service Desk, SQL * Loader.

Operating Systems: Windows XP & UNIX

Database: Oracle 9i, 10g & 11

Languages: Sql/ PL/SQL

Domain Expertise: Manufacturing/Retail/BFS/

PROFESSIONAL EXPERIENCE:

Confidential

Module: AP, AR, GL, FA, CM, PO.

Responsibilities:

• Developed GL Account Wise Outstanding Balance As on Date.
• Developed Invoice interface program to fetch third party invoices in to Oracle Payable system.
• Designed the Payment Reverse program to send the payment information to Expense system.
• Developed Employee Interface Program to fetch employee details in to oracle system.
• Design the out bond interface program to fetch invoice Payment Reverse from OGL to third system.
• Design the AME approval Setup for Oracle payable invoice approvals based on approval limit Invoice will trigger for next approval managers.
• Customized the Fixed Asset Register Report to add the some values added IT/Non-IT, Supplier Number, Invoice Date, Cost Retired, Proceeds of Sale, Gain/Loss
• Indent&PO Detail Report to display the requisition PO details and payments information against the PO
• Enhancement TDS Details Report.
• Based on user ad-hoc request we have providing the some report across FIN & SCM environment.
• Involved in supplier customer creations in production support based on help desk request. And involved in local tax issues.
• Involved in AP, AR, period closer issues to do the smooth month end closures.
• Involved invoice payment process issues.
• Closely with Oracle support team for Monitoring the Oracle SR’s which we raised for user facing issues on priority basis.

Confidential

Module: AP, AR, GL, FA, CM, AGIS

Responsibilities:

• One point contact to Contract profitability for any development/ Technical clarifications
• Involved in support issue which we received through it support tool and provide the solution on priority basis by 24/7 support in AP, AR, GL, CM, FA & AGIS Modules.
• Handled application setups and Application configurations for Oracle Projects
• Major contribution on inbound interface like Payable interface and Auto invoice interface where populate the legacy data in to oracle system.
• Involving the Month end activity in AP Closure, AR Closer in finance modules.
• Involved in AGIS Batches clearance activity in daily basis as per the user requests.
• Majorly involved in Supporting Financial & SCM technical modules.

Confidential

Responsibilities:

• Reviewing Business objectives, Understanding the Business processes and the feasibility study for the change.
• Worked on the retro fitment and development of new reports (CFD’s)
• Part of Defects team along with development, handled defects after mock activities
• Creation of project installation guide and release notes for the installation
• Prepared Technical specification for the functional specifications received.
• Provide Development Approach for the Client requirements
• Design and documentation
• Performed Unit testing
• Performed estimation and planning
• Handled defects post mock activities.

Confidential

Module: AP, AR, GL, FA, CM, Discoverer reports.

Responsibilities:

• Developed the discoverer report Confidential -Total Commit values by contract-summery.
• Developed the discoverer report Confidential -Total Commit values by contract-Detail report
• Developed Aria Closed Transaction Report which is displayed RMA information.
• Involved daily syncup call to get requirements from onsite team to implement the client requirements.
• Involved code drop activities from Dev instance to UAT, CRP Instances and get the deployments as per schedule time.
• Worked on the sales force bugs which is raised by user during testing period before migrate the code to prod.

Confidential

Module: AP, AR, GL, FA, CM

Responsibilities:

• Developed the Invoice interface to upload the legacy campus produce campus meat invoices in oracle base tables for the supplier payments. And reporting for the end of the month.
• Developed the AR Interface to upload the Retek ReSA invoices in to base table Using AUTO INVOICE INTERFACE standard programmer.
• Developed invoice hold alert which is send to hold invoices to supplier so that supplier will interact the organization to release those invoices.
• Involved in I expense reports issues resolved in the sense whenever report stopped for managers approval and workflow related issues.
• Responsible for fixing production issues, addressing user queries, adhoc requests within SLA to ensure all business functionalities and applications are maintained.
• Managing and delivering the Change Requests (CR), Problem Records (PR) and Incident Records (IR) within the time of SLA.
• Batch scheduling and monitoring the oracle jobs in production instance.
• Preparing Test scripts and co-ordinate and assist testing team to complete the testing on time.
• Prepared MD50,MD70 and MD120 installation documents
• Developed Discoverer reports and documentation.
• Designed and Customized the Workflows.
• Developed / Customized the following reports using BI publisher,
• Customized / Tuned the following reports
• Invoice Aging Report
• Accrual Reconciliation Report
• Aging By Account Report
• ECE payables VAT register Report

Confidential

Responsibilities:

• Developed Retail Invoice Report which are displayed to customer, invoice and item Information based on the sales order.
• Developed TDS reports in AP which are displayed supplier tax deduction details for issuing the Form-16 for the specific Fin-Year.
• Developed the Creditor accounting ledger report which are displayed the customer outstanding for The Specific period in AR.
• Developed Misc. Receipt report.
• Customized the asset retirement report.
• Monthly uploading of legacy data as and when received from 6 locations into AR, AP and GL.
• Involved in the Month Closing Activities.
• Developed the Purchase order register register report in PO which is displayed PO Number, item, quantity, Tax information.