EXPERIENCE SUMMARY:

• Fifteen years of experience in complete systems development life cycle (SDLC) and project life cycle (PLC) - design, development, unit testing, implementation and maintenance, which includes 10 years in Oracle product development at Oracle Corporation.
• Developed Oracle Financials Applications various releases 10.7, 11.0, 11i and R12 specifically iExpenses (OIE), Accounts Receivables (AR) and Confidential Trade Accounting using various tech stacks.
• Strong knowledge of Oracle eBusiness ERP, Financials: General Ledger (GL), Accounts Payable (AP), Accounts Receivables (AR), Oracle Purchasing (PO), Oracle Inventory(INV), Oracle Product Hub(EGO), Fixed Asset (FA), iExpenses (OIE), iProcurement, iSupplier, iReceivables, iPayments (IBY), Sub Ledger Accounting (SLA), EBTax, HR, TCA, Enterprise Asset Management (eAM), Custom Oracle Time and Labor (OTL). Knowledge of Oracle Project Costing and Billing (PA), Order Management (ONT).
• Financial Processes: Oracle Procure-to-Pay, Travel & Expense Management and Customer Transaction to Receipt processes.
• Strong knowledge of Oracle Applications Development tools, Oracle Application Concepts and Apps Tech Stack including Oracle Fusion Middleware SOA Suite (ADF, BPEL), OA Framework (OAF), OAF Personalizations, Forms Personalizations, Jdeveloper, Java, Workflow, SQL, PL/SQL, Performance Tuning, Pro*C, Oracle Forms and Reports.
• Improved Quality by Process refinements, Standards, Guidelines, Performance and Best Practices.
• Performed demos of Expenses product on Oracle Open World demo grounds and provided a fresh insight into Expenses product and highlight the latest innovations.
• Helped number of customers in their Global implementation of Expenses including customer like Google, Cisco, Toyota, Gartner, Enbridge, UPS, Sony etc…
• Received Teamwork appreciation from Confidential Systems as recognition for our efforts and contributions in helping them implement iExpenses.
• Received numerous honorariums as recognition of my personal contribution to various customer projects.
• Successfully lead the role of a facilitator as an On-sight manager by efficiently collaborating the global team through stupendous key communication skills. Generated a team orientation and a sense of ownership of the project in the resources. Always inspired and cheered the team to reach the mark of excellence.
• Reduced maintenance cost and service requests by providing cumulative patches on various releases of Expenses.
• Conducted in-house for support analysts and development resources new to the team.

SKILLS/STRENGTHS:

Operating Systems: Solaris, Unix, Linux, Windows-NT/XP/95/98/2000, Macintosh

N-tier development: ADF/JSF, BC4J/OC4J (Business Components for Java/Oracle Components for Java), Java, XML, JSP, J2EE, JDBC, Web Services, SQL, PLSQL, Oracle 8,9,10g, 11g, Oracle Forms 4.0, 4.5,6i, Oracle Reports 4.0, 4.5,6i, HTML, Javascript, C++, C, Perl, Pro*C, Mod PL/SQL

Applications: Oracle Financials, Oracle Approvals Management, Applications Release 10.7, 11.0, 11i, R12

Middleware: Oracle SOA suite/Oracle Fusion Middleware (BPEL, ADF, ESB, SOA, SOA Consol, XSLT, SCA, SDO, Mediator, Human Task, AMX, Business Rules, Adapters)

Tools: Workflow Builder 2.5, Jdeveloper, SQL*Developer, XML Publisher, SQL*Navigator, TOAD, Arcs, Clear Case, Microsoft Office - Excel, PowerPoint, and Visio

Utilities: SQl*Loader, TKPROF

Methodologies: Agile, Waterfall, V-Model development methodologies, Oracle Application Implementation Methodology (AIM).

Execution: Result Oriented, Good Communication Skills, Responsible, Organized and Accountable, Excellent Managerial Skills, Multi-Tasking and ability to work efficiently under pressure.

PROFESSIONAL EXPERIENCE:

Oracle Financials and Procurement Consultant

Confidential

Responsibilities:

• Upgrade Oracle Applications, RICEW objects 11i to 12.1.3.
• Deliver MD070’s.
• Build OAF Extensions and Personalization’s for iProcurement requisition process flow.
• Retrofit 11i Form Personalization’s and Customizations/Extensions from custom.pll to Buyer Work Center, Supplier OAF Pages.
• New OAF extensions in Buyer Work Center and Supplier pages.
• Function Security through Function/Menu exclusions.
• Review and correct custom menus to be compatible with R12 menu structure.
• Upgrade PO Document Print and Email to be compatible with R12.
• With the standard code DFF works only on Buyer Work Center or Purchase Order Form does not work on both. Extended Buyer Work Center pages to enable and default values so that DFF work in both at same time.
• Create custom search views, extended to show custom columns
• Implement 12.1.3 iExpenses Duplicate Detection feature.
• Upgrade custom code around Financials modules.
• Upgrade SQL reports - make them compatible with R12 data model (Internal and External banks, SLA tables for reconciliation..)
• Providing Post Production support for Purchasing and Financial modules.

OAF OTL Consultant

Confidential

Responsibilities:

• Enhance and Implement Custom Oracle Time and Labor (OTL) application to support multiple operating units.

Development Lead

Confidential

Responsibilities:

• Upgrade financial instance to 12.1.3 and implement new modules Enterprise Asset Management (eAM), iSupplier, Procurement, Inventory, and Projects.
• Train developers on Oracle Workflow, Approval Management (AME), OA Framework.
• Deliver design and coding standards.
• Review MD050’s, write MD070’s.
• Develop extensive OA Framework extensions i.e, code New Pages, Lov’s dependent on internal or external user responsibility, Embed reusable OAF regions in standard eAM pages, Controller extensions, VO substitution, OAF page personalization’s, Forms personalization’s, Invoke OAF pages from forms, invoke forms from OAF pages, Add dependent lov’s through personalization, defaulting of fields, Synchronization of data between custom and standard pages, Show detail attributes etc
• Print BI publisher report from OAF page
• Invoke Activity Workbench form from eAM work order OAF page and default to Create Activity block and default other field values and transfer additional details from work order to the newly created activity upon save. Navigation, defaulting and calling procedure to transfer details were performed using forms personalizations.
• Include additional menu option on standard operations and maintenance routings and invoke OAF page upon selecting the custom menu option to capture additional information related to standard operation and operations on Activity. Performed using forms personalizations.
• Develop File Download and File Upload, parse and load data
• Navigate to standard page from custom search pages
• Securing attachments based on internal or external user responsibility.

I2R Track Lead, SME, Oracle Financials

Confidential, San Jose, CA

Responsibilities:

• Lead I2R team (iExpenses, iSupplier, AP, CM, Payments).
• Analyze complete P2P and supplier data for the US Financial instance upgrade and merge.
• Consolidated FSD’s, BR100’s from various releases and update FSD’s, BR100’s for Bedrock 2.0 release (11i to R12 upgrade and merge instances).
• Identify and Analyze all internal and external invoice interfaces and provide solution design for invoice interfaces and invoice approval and processing after merge to R12.
• Analyze custom solution for interfacing report outputs to VistaPlus and provide solution design for replacing VistaPlus with ECM/EDM.
• Analyze Bolt-on tool WebEC and provide solution design for replacing WebEC with iSupplier.
• Provide solution design for Confidential Intercompany process.
• Provide solution design for maintenance of supplier information in one instance and synchronization process to other instance where supplier information is required.
• Present the solution designs to Project IT, Business Analysts, Delivery team, Dependent teams, End Business and obtain sign-offs.
• Provided support for critical issues (AP Trial Balance issues) for Year End Closure.
• Perform case analysis for issues logged since Bedrock release and provide detail analysis report to management.
• Deliver custom code inventory and report analysis for upgrade.
• Identify test scenarios and perform extensive testing of consolidated patches identified during Month End, Year End Closure and other business critical issue, ensure customizations are validated and ensure smooth migration of patches to production.
• Help resolve some of the usability issues.
• Help Test Automation team resolving TA Script errors.
• Responsible for delivering multiple ER’s and fixes for critical issues.
• Work closely with Project Business, Delivery, TA, ITDS Support and Oracle teams.

Project Lead, Oracle Financials

Confidential, Redwood Shores, CA

Responsibilities:

• Successfully delivered various releases of Expenses, Oracle Receivables and ARTA - CPG Trade Accounting with high quality.
• Involved in design, coding, unit testing, maintenance of Internet Expenses, Account Receivables, CPG Trade Accounting.
• Performed demos of Expenses product on Oracle Open World demo grounds and provided information to harness the product to the fullest extent.
• Worked closely with customers and helped them in resolving Functional and Technical issues that arose during Expenses implementations.
• Wrote Technical Detail Design documents (TDD) based on Functional Design documents ( Confidential ).
• Managed, Lead and Mentored global development resources. Provided a positive and productive environment by cheering the star performers through meaningful employee recognition and thus inspired the other resources to reach the mark of excellence.
• Improved customer satisfaction, reduced maintenance cost and reduced SR count by providing cumulative patches which avoid applying multiple patches and include fixes for complete known issues.
• Maintain high quality by avoiding issues due to file dependencies, by introducing branching on files, code reviews, patch reviews and patch verification process.
• Ensure product is stable by performing complete code reviews and patch verification before patch is released.
• Prioritize and efficient allocation of tasks among the resources and maintain product stability.
• Work closely with product management to prioritize enhancement requests and resolve functional issues.
• Work closely with support and BDE to resolve customer queries and issues
• Work closely with release during patch set, maintenance pack or rollup patches to resolve build and other issues.
• Work closely with QA to test code fixes and flow tests done.
• Work closely with other teams to resolve integration issues (AP, HR, PA, AME, IPM), performance issues and help resolving issues faced during benchmarking (performance team), tech stack issues (AOL, OAF, WF).
• Solely responsible for 11i, R12 Expenses maintenance and enhancements.
• Hire new developers, Conduct internal on product functionality and build the team.
• Intimately involved with prioritizing multiple, nearly always conflicting priorities across software development projects. Intertwine the activities of multiple projects to continuously improve the product and the efficiency of the team.
• Review Functional and Technical detail designs.
• Moderate weekly team meetings and provide updates and go through the status of various tasks.
• Central point of contact for Support, COE, Strategy, QA, PM, IT and other integrating products.
• Review Enhancement requests and prioritize along with the product management.
• Perform employee Performance Appraisals.
• Coordinate with QA for s.
• Perform code reviews and Enforce standards are followed.
• Step in and provide functional and technical help to the team members.
• Review and Prioritize developer’s tasks.
• Ensure developer’s workload is balanced.
• Update management with the status on a weekly basis.
• Identify, recommend and schedule developer s to build the required technical, functional and communication skills to develop better skill set in the group and prepare the development team for the next hurdle they might face.
• Weekly calls with support team to clarify issues.
• Co-ordination through bi-weekly calls with Global IT team to help with their issues.
• Monthly calls with support managers and reciprocate each other with feedback on areas with feasibility of further improvement.
• Design and develop IPM (Imaging) integration using ODC, OCR, IPM, BPEL and ADF Attachment Service.
• Worked on ADF for iExpense application for integration with IPM. Create ADF web services for adding attachments.
• Worked on ADF Business components: Entity Objects, View Objects, Application Modules, View Accessors and View Links.
• Created ADF Pages with Master Detail Tables, Master table Detail Form and read-only pages.
• ADF exception handling to display user friendly error/warning messages
• Enhance expense approval process to Support Oracle Approvals Management (AME).
• Enhance expense approval process by implementing AME parallel Approvals for faster approvals.
• Enhance confirmation page to display AME Approval list and status to track approval.
• Enhance project, grants and cost center approvals.
• Enhance approval process to support approvals on project or cost center aggregate amounts.
• Enhance approval notification to provide information related to cost center and project approvals.
• Include AME approval history in approval notification.
• Enhance expense workflow to support Expense Allocations and new detail/itemization.
• Cleanup/Reorganize for better readability and ease maintenance.
• Rebuilt Expenses using OAF (MVC design pattern) J2EE based.
• Integrate expense entry flow with the new detail-itemization page.
• Implement expense header level DFF in General Information page, provide default validation logic in custom validation hooks.
• Worked on various pages, General Information Page, Credit Card Transactions Page, Cash and Other Multi row page, Details page and read-only Details page.
• Enhance Itemization Page.
• Credit Card transaction upload and validation.
• Support credit card feed from various card providers AMEX, MasterCard CDF3, VISA VCF 4.0.
• Maintain various releases of Internet Expenses 10.7, R11.0 Pastel, 11i Blue/Gray, R12.
• Maintain case and seed changes.
• Fix issues identified in all modules.
• Perform code reviews.
• Stabilize DFF in OAF pages.
• Resolve data corruption issues, performance issues, JavaScript performance issues and handle upgrade issues.
• Help support, consultants, customers and other groups on resolving issues.
• Enhance and Maintain iExpenses, application built on Mod-PL/SQL and JavaScript.
• Perform the standard setups Key Flex fields, key flex segment values, Define parent child values, Define Rollup Groups using Account Hierarchy Manager, Define Shorthand Aliases, Accounting Calendar, Define Currencies, Conversion Rate Types, Daily rates, Define Journal Sources, Journal Categories, Security Profiles, Define and Assign Security Rules, Transfer to General Ledger, Submit Journal Import.
• Design, code and maintain various forms, setup Payable Options, Financial Options, Define Signing Limits, Holds and Releases, Payment Terms, Distribution Sets, Invoice Import processes, Invoice Approval Workflow, Document Sequences, Document categories, Sequence Assignment.
• Maintenance
• Receipts Workbench
• Transactions Workbench
• Lockbox
• Auto Receipts
• Transaction API iPayment integration.
• Resolve data corruption issues.
• Resolve performance issues.
• Development of ARTA 11.5.1
• Work involved schema merge: move all TA Schema objects tables, views, value sets, Flex fields - descriptive and key, concurrent programs, messages, menus etc, rename Packages and Procedures and install into AR schema.
• Testing and Certify.
• Convert forms 4.5 to forms 6.0.
• Integrate Confidential TA into Core AR (ARTA 7.5) and avoided making the Confidential functionality on each of the workbenches and other parts of the code for each release of AR.
• Unit testing of various releases of AR (AR.S to AR.W) to make sure ARTA 7.5 does not break.
• Development of various releases of Confidential TA 2.2 to 2.4 and point releases in each release.
• Cut development and maintenance cost by developing patch (CPG 2.4TA) which avoids performing TA changes on AR forms for each release of AR and got all customers on various version to common version of Trade Accounting and AR (AR patch set 16.1.AR.S and ARTA 7.5).
• Y2K Compliant for Confidential TA.
• Develop multiple forms
• Create Deductions
• Deduction Assignments
• Deduction Split/Merge
• Enhance Customer Credit Summary
• Credit Agency Data
• Customer Reporting Hierarchy (View and Enter parent child customer relationship)
• Enhance Receipt Profile Assignments
• Receipt Processing profile
• Promotion Payment Types
• View and enter promotions
• Define Rules
• Define Rule Sets
• Status Mappings
• Print statements ESS Information (View ESS information), Cash Application Details, Unmatched Payments
• Deductions Interface
• Promotions Interface.

Consultant

Confidential, Cupertino, CA

Responsibilities:

• Involved in development, maintenance, writing test plans and test Confidential Trade Accounting.