PROFESSIONAL SUMMARY:

• Oracle Apps Techno Functional consultant (EBS / ERP) with about 7 years of experience.
• Certified “R12 Payables Implementation Specialist” and “SQL Certified Expert”.
• Proficient in SQL, PL/SQL, OAF, Forms, Reports, BI Publisher and Workflow.
• Integrated Markview tool with AP subledger to impart the capability to storing and organizing invoice documents.
• Configured or enabled new entities created in Oracle with Markview and created corresponding process monitors and queues.
• Acquainted with Development and Production Support in Oracle process cycles like Procure - to-Pay (P2P) and Order to Cash (O2C)
• Hands on experience in creating new OAF pages and also personalizing or extending seeded OAF pages.
• Extensive experience in Implementation, Migration, Customization, Production & Support of various modules in Oracle Applications with major focus in Accounts Payables (AP), Purchasing (PO), Order Management (OM), Accounts Receivables (AR), General Ledger (GL) Fixed Assets (FA)
• Technically proficient in RICE components (Reports, Interfaces, Conversions, Extensions)
• Strong knowledge of Application Implementation Methodology (AIM), Application Object Library (AOL) implementation standards, Trading Community Architecture (TCA) and Software Development Life Cycle (SDLC).
• Extensively experienced in Oracle Development namely Stored Procedures, Packages, Functions & Triggers, SQL* Loader, UTL FILE and shell scripting.
• Expert in writing Technical design documents (MD070), Technical Test documents (TE020), Conversion (CV050) and Migration documents (MD0120).
• Worked on 11i and R12 versions of Oracle E-Business Suite.
• Good team leading skills with onsite direct client interaction experience for about a year.
• Good knowledge of Incident management, Change management and Problem management.
• Ability to work effectively with Oracle Support to resolve Service Request (SR) issues.
• Knowledge of Oracle Metalink functionality/technical support area to aid in resolving application problems and finding solutions.
• Proven ability to quickly learn and apply new technologies with strong technical background
• Excellent analytical, problem solving skills and ability to follow through with projects from inception to completion.
• Provided on-call and day-to-day support and worked as a part of team in 24x7 production environment.
• Worked for major clients across domains like Telecom, Retail and Manufacturing.
• Assisted users with Account reconciliation, accounting, journal creations during period close.

TECHNICAL SKILLS:

ERP: Oracle Applications ERP (Rel 12, Rel 11i)

Tools: & Technologies: TOAD, SQL Developer, SQL* Plus, JDeveloper for Oracle Applications Framework,, Oracle Reports/Forms Builder, XML Publisher tool, Workflow Builder

Languages: SQL, PL/SQL, JAVA/J2EE, OAF, Shell Scripting

Operating Systems: Windows, UNIX

Databases: Oracle

• Interfaces/Conversions
• XML Reports
• OA Framework
• Extensions
• AOL
• Win CVS
• HPPPM
• Perforce / P4
• SharePoint
• HP Quality Center

PROFESSIONAL EXPERIENCE:

Confidential, San Jose, CA

Technical Developer

Responsibilities:

• Retrofitted around 50 different file specifications interfaces for Citibank Payment in Oracle from 11i to R12.
• Converted data from Markview (legacy application) to be compatible with in house developed project for Invoice Scanning and Approval.
• Made custom forms like CFX file status, File generator, Loader configuration, Regions to be available and compatible with R12.
• Migrated form personalizations to OAF personalizations/customizations for payment related interfaces from 11i forms to R12 OAF pages.
• Retrofitted touchless payment OAF pages and the underlying program designs.
• Retrofitter reports like 1099 tax report, 1099 suppliers, Unpaid report, Aging report and Invoice analysis reports

Confidential, San Jose, CA

Application Developer

Responsibilities:

• Designed and Implemented CFX payment gateway interface for France, Germany and Bulgaria entities with Citibank. XML payment gateway interface for Canada entity with RBC for which I recieved Confidential YouRock Award.
• Configured or enabled new entities created in Oracle with Markview and created corresponding process monitors and queues.
• Performed scanner installation / Markview Central server configuration and maintenance.
• Used windows services to schedule tasks like data backup to disaster recovery instances.
• Automated the invoice processing with third party systems like GIST, TEAMCONNECT, Plutus.
• Interfaced Application Receivables transactions data from Billing 3 third party system.
• Personalized payment batch form to place invoices on hold when a payment batch is manually voided, Invoice workbench form to hide the bank account details from Inquiry responsibilities.
• Developed workflow to trigger parallel approval for responsibility request making the system SOX compliant.
• Configured AP and PO setups for new Confidential entities and enabled the payment gateway, Tax codes, Withholding taxes, updated the GL accounting, created Wire/Dummy payment documents, enabled Zero payment, Multi currency payments for internal banks accounts, set up bank account for gWires, configured check printing.
• Created On-Time-SLA, fixed issues in VAT Extract report and enhanced Confidential Supplier Payment Account Discrepancy Report to include updates made on the payment schedules tab.
• Designed program which will notify the approver to review supplier after approving invoice.
• Designed custom OAF page for bulk report submission, automatic payment batch creation based on entity and criteria specified, file upload to application server.
• Created a custom form to display the status of payment transactions for host to host payments.
• Used NTL extension to verify the taxes on invoices by checking with Vertex.

Confidential

Systems Engineer

Responsibilities:

• Took up the role of Oracle Apps Techno Functional Consultant to support Confidential ’s financials system closely working on P2P cycle.
• Worked as support analyst to address and resolve issues related to P2P flow of Confidential .
• Monitored the daily feeds which includes invoices, purchase orders from boundary systems which are integrated via EDI.
• Assisted users in payment related issues and transmission to bank server via secure channel.
• Resolved duplicate receipts created due to the same file getting imported twice.
• Created a status report of all the daily interface jobs and published to business users.
• Took action on prolonged runtimes of programs when the feeds are greater than normal and took corrective measures to close the schedules on time.

Confidential

Systems Engineer

Responsibilities:

• Used SQL Loader to load the data of Purchasing, Payables, Receivables received as flat files from legacy system into Oracle custom tables.
• Designed programs to validate the data loaded in custom tables and used standard interface programs to import into Oracle base tables.
• Developed customized reports required for business using XML Publisher.
• Prepared functional, technical design documents based the client requirements as per Application Implementation Methodology (AIM).
• Developed the code as per the technical design document maintaining the coding standards and adhering to TCS security policy.
• Created test case documents, performed test cases and document the results in test result documents

Confidential

Systems Engineer

Responsibilities:

• Undergone training on the end to end functional flow of SCM cycle.
• Performed unit test cases and documented the results using HP Quality Centre tool.
• Developed XML Publisher report to display the output generated by concurrent programs and enhancement of Oracle Reports to include additional information.
• Checked-in the various versions of the project code into CVS tool.
• Acted as release engineer to control the flow of the project code from development to higher environments for testing and then to Production.