SUMMARY

• Having 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 Workflow2.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 teamwork. Possess expertise in multicultural environments with the distinction of understanding, setup/streamline operations, skilled communicator with exceptional presentation skills and abilities to lead cross-functional teams.
• Played a single point contact role for one of the critical implementations, support and enhancement in Oracle FIN & SCM modules (AP, AR, GL, CM, PO, INV, and OM. Oracle could FIN HCM.
• Ensured implementation& Supports 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.
• 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 application: 11i/R12.2.4 (AP, AR, G L, FA, CM, PO, OM, AOL System Admin)

Tools: &utilities: Oracle Forms 6i, Oracle Reports 6i, Oracle

Discoverer: 10g, Publisher, XML Publisher, 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/Entertainment

PROFESSIONAL EXPERIENCE

Confidential, Kansas City

Oracle Functional Cosultant

Responsibilities:

• Developed payment unaccounted invoice details BI Report.
• Developed oracle form which is showing the invoice approval master details.
• Developed the oracle alert which is showing invoices exceeds 10k and send it to business stake holders on daily basis.
• Involving Support business for period closing activity on account payables (AP) and account Receivables (AR), GL, FA,CM.
• Proactively working on productive 24X7 support to end users for Oracle ERP application by Work on the production issues, defects and fix them on time.
• Working with oracle support team on critical production issue to get the permanent solution on 24/7 support manner.
• Developed AP Invoice Details Report - By Payment Date reports.
• Developed sales invoices credits report which is displayed customer invoices and credit memos and payment details.
• Developed the cash receipt creation interface.
• Developed the GL Interface Processor
• Developed AR - miscellaneous receipt interface
• Developed Supplier Bank Account Create interface Program
• Developed Supplier novice aging report
• Developed the Payables Aging Report
• Hands-on experience in debugging problems through logs, backend programs.
• Developed Rent Variance Report Generator

Confidential, Kansas City

Responsibilities:

• Developed Invoice interface program to fetch third party invoices into Oracle Payable system.
• Developed the outbound interface in payable to send the supplier remittance details into csv file.
• Developed Misc. Receipt report.
• Customized the asset retirement report
• Resolved Production Support tickets with a quick turnover time.
• Documented the development process as per AIM standards and for each object along with the test cases.
• Designed and developed the AR Conversions during obsolescing the Operating Units.
• Customized the standard oracle reports such as AR Aging Report, AR Invoice Print Report, Inventory Cycle Count Report, Transaction Register Report Payment Receipt Report etc. and converted them to XML Publisher format
• Created triggers on order lines to perform custom validations.
• Provided Level 2 support to the business users to identify the problem and give a quick solution.
• Actively interacted with users in gathering requirements for development.
• Prepared standard AIM documentation for each object undertaken.

Confidential

Responsibilities:

• Developed GL Account Wise Outstanding Balance As on Date.
• Developed Invoice interface program to fetch third party invoices into Oracle Payable system.
• Designed the Payment Reverse program to send the payment information to Expense system.
• Developed Employee Interface Program to fetch employee details into oracle system.
• Design the outbound 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 some values added IT/Non-IT, Supplier Number, Invoice Date, Cost Retired, Proceeds of Sale, Gain/Loss
• Indent Detail Report to display the requisition details and payments information against the PO
• Enhancement’s Details Report.
• Based on user ad-hoc request we have providing 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

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

Responsibilities:

• Developed the discoverer report SDP-Total Commit values by contract-summery.
• Developed the discoverer report SDP-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 migrating the code to prod.