SUMMARY

• Having more than 8+ years of experience as Oracle Finance Techno Functional Analyst in ERP transformational and maintenance engagements which includes Oracle Applications Implementation, Post Implementation Support, Enhancements, Roll out projects and Upgrade.
• Oracle EBS and Cloud functional consultant with extensive experience in full life cycle implementations, upgrades and extensions of Oracle EBS 11i/R12 and Oracle Cloud ERP/Financials R12/R13 applications.
• Expertise in implementing and maintaining ERP based business solutions and best practices across process areas of Procure - To-Pay and Order to Cash.
• Involved in E2E activities like requirement gathering, GAP Analysis and mapping the requirements with Standard functionalities, Configuration, Documentation, Regression, QA and End user testing, Preparation of End user manuals and End user training.
• Worked on process improvements to interfaces between Oracle and 3rd party tools, Inspyrus (Supplier invoice integration with ERP), Coupa ( Procurement solutions), Concur
• Carried out Full Life Cycle Implementation of Oracle Finance Modules and Support in different industries and various versions of Oracle ERP R12 (12.1.3 and 12.2.6) and 11i (11.5.10).
• Integration of Oracle Advanced Collections and Credit Management with Oracle Receivables and other EBS Modules.
• Prepared Implementation Life Cycle Documents based on AIM Methodology.
• Solid knowledge in General Ledger, Account Payables, Purchasing, I supplier, I Expense, Order Management modules.
• Hands on experience in supporting Oracle EBS Applications Accounts Payables, Purchasing, Fixed Assets, Cash Management, I expense and Order Management.
• Successfully completed 2 EBS Finance Implementation, 2 EB-Tax (VAT) Implementation and 1 GST Implementation and 12+ support, upgrade and Rollout Projects Costing and Billing and Property Management Implementation.
• Worked with business users and technical teams in successfully translating business requirements into functional specifications and deliverables.
• Have working experience of configuring Oracle EBS Finance modules which includes, General ledger, Accounts payables, Accounts Receivables, Cash Management, Fixed Assets, Sub ledger Accounting, Advanced Global Intercompany System, E Expenses and E-Business Tax.
• Worked in Onsite and Offshore model projects including coordinating and leading offshore team.
• Good analytical and problem-solving approach with appropriate decision analysis and resolution.
• Experienced in ticketing system tools like Atlas Remedy and Service Now.
• Extensive experience in full Implementation Lifecycles of complete suite of Oracle EBS and covering Definition, Elaboration, Build, Test, Transition and Support.
• Proficient in Data retrieval using SQL queries and supporting the necessary service requests logged with oracle. Ability to assist and guide technical team in Technical Design and Development of business requirements.
• Strong analytical, diagnostic and troubleshooting skills with the ability to work in a fast-paced and team-oriented environment. Professional Experience
• Strong Knowledge and domain experience in Oracle Finance and SCM modules with Technical and Functional expertise.
• Successfully worked with clients in the Manufacturing, Shipping and Travel Industries.
• Technical Expertise in PL/SQL, Interfaces (Inbound and Outbound), Conversions, Oracle 6i, Oracle Workflow, Oracle XML Publisher Reports and RDF Reports (I.e. Definition, High Level Design, Detail Design, Development, Deployment, Testing, Integration and Maintenance.
• Proficient with documentation using Oracle ERP AIM Methodology (i.e.MD50, MD70, MD120, TE20) or any other client specific implementation methodology.
• Created detailed test plans/scripts and have successfully coordinated all the testing cycles; unit testing, system integration testing, system testing and user acceptance testing (well versed with both manual and automated testing).
• Extensive experience with Oracle Trading Community Architecture - worked on designing the structures like Parties, Accounts, Sites, Contacts, Contact Points, and Relationships.
• Excellent judgment skills in identifying areas of high-risk, critical business areas, early in an application and prioritize my tasks to focus my efforts when time is limited.
• Strong cross functional business knowledge in process streams such as Procure to pay, Order to cash and account to close or budget to report.
• Co-ordinate with developers to develop custom solutions, test the custom solutions through multiple iterations of testing and corrections.
• Every project was designed to pass through several stages starting from gathering requirements, analyzing the standard and custom solutions, solution design, process flow documentation, preparing functional specifications, preparing technical specifications, Testing the custom solutions, Bug fixing, User acceptance testing, production migration and post production support.
• Worked well with people at various levels in the project like Business analysts, project managers, programmers, functional and technical lead etc.

TECHNICAL SKILLS

• Toad
• SQL Developer. RDBMS Oracle 10g/9i/8i
• SQL Server 6.5/7.0/2000. Oracle Tools Forms 10g/9i/6i
• Reports 10g/9i/6i
• Discoverer 10g/4i
• Oracle Workflow Builder 2.6.3.5
• Developer 2000
• XML Publisher
• . Other Languages C
• C++
• Java
• JSP
• Python
• SQL
• PL/SQL
• HTMLOracle ERP
• CSS
• Java Script
• Spark. Document Methodologies MD.070
• MD.050. Oracle Release 12 - AP (Accounts Payable)
• Oracle EBS 12.2.3 AR (Accounts Receivable)
• GL (General Ledger)
• OM (Order Management)
• PO (Procurement)
• CE (Cash Management)
• AC (Advanced Collections)
• CM (Cost Management)
• LNS (Loans Management)

PROFESSIONAL EXPERIENCE

Oracle Finance Consultant

Confidential - Lexington, MA

Responsibilities:

• Designed and Developed an Oracle enhancement using PL/SQL to create custom holds on supply chain finance invoices which have a pay site of secondary pay. This helped invoices to be paid as part of Automated Clearing House payment run to avoid invoice aging by sending Custom Alerts to the Shared Accounts Payable department to change the pay site to secondary pay.
• Analyzed and provided Vertex solution at the ERP mapping level for the AP tax reconciliation process that helped the compliance/tax filing processes.
• The Purchasing implementation covered Configuration of Oracle Purchasing module like Item definition, item category, sourcing rules, procurement limits, document approval rules, approval hierarchy, and document revision criterion.
• Designed and developed a custom "Received but Not Delivered Report" on XML to provide a custom view to extend On-hand inventory valuation, Business intelligence report to provide true on hand inventory valuation to higher management.
• Understand the requirements of the client in functional scenario and analyzed, tested the standard functionality in Oracle EBS to meet the specific requirement of the client.
• Also Implemented R12.2.4 Oracle EBS, AGIS, SLA and Oracle Fusion FAH coexistence with Oracle R12,R12 Implementation of various Financials and Supply Chain modules.
• Co-coordinating with the other teams, which are integrated with Oracle Projects billing/ Costing (Travel & Living, My Time, Accounts Payables, Receivable, General Ledger)
• Provided custom solution to integrate third party Tax API (ADP), to Oracle EBS
• Designed and Developed a Custom PL/SQL object named "RBC Bank Statement Program" to achieve transaction number populate process by populating payment document numbers and cash receipt numbers in Cash Management Interface Tables to achieve auto reconciliation whenever possible. The design is based on comparative matching of payment document numbers and cash receipt numbers.
• Establish timelines and identify transition time to point integrations. Expertise in Project Costing, Project Billing, General Ledger, Cash Management, Oracle Time & Labor.
• Extensive experience in requirements gathering, fit-gap analysis, requirements mapping, application setup and functional designing.
• Bring on board Oracle product for support during various milestones like CRP-1, CRP-2, UAT, Go-Live to mitigate risk.
• Identify patch release and keep log of timelines to make sure existing configuration is not impacted in a milestone instance.
• Escalate system level performance issues to Oracle product group and identify timings and mitigate performance issues.
• Identify master data and transactional data and keep a periodic log of the conversion runs to understand timing required for production cutover/go-live.
• Prepare solution design documents and configuration cookbooks for various module extensions like Procurement, Payables, expenses, General Ledger, Accounts Receivable.
• Mapping the client requirements with Oracle standard functionality and finding the gaps and delivering the solutions in terms of workarounds, re-engineering and form personalization
• Recommend and design strategy for to do cutover and go-live to minimize business operational impact.
• Help and monitor financial reconciliation for finance business to make sure there is no impact to trial balance because of conversion or any other cutover related activity.
• Also Implemented R12.2.4 Oracle ERP, AGIS, SLA and Oracle Fusion FAH coexistence with Oracle R12
• Working with Oracle Release 12 financials applications (Oracle Project Costing, Project Billing, General Ledger, Accounts Receivables, Oracle Time & Labor, Order Management, cash Management, Procurement tools). Conceptual knowledge of Oracle Application technologies and methodologies.

Oracle Finance Consultant

Confidential - Seattle, WA

Responsibilities:

• Setting up chart of accounts and business structure for business unit based on the brands
• Data conversion functional spec from various legacy systems like DDMS, Counterpoint to Oracle.
• Approval configuration for various business units using business process manager.
• Identifying reporting needs for various stakeholders and working closely with technical team on custom reports wherever applicable.
• Track and research orders thru downstream systems such as GCM (Governance and Compliance Mgmt. tool), OMEGA (Oracle EBS) and etc.
• Advise on new solutions for enterprise business applications integration and functionality activation. Understand the impact of process changes and be able to guide process definitions accordingly.
• Analyse and solve complex problems, provide documentation, guidance and instruction to users at all levels.
• Proactively work with Accounting, IT and internal business partners to provide assistance and advice with the implementation of new or enhanced Oracle financial applications and systems.
• Supported user community with daily reports that include, order status, accounting reports for UAT results validation in OMEGA ( Oracle EBS R12)
• Managing the Project/Production issue assignments, lead weekly project status meetings, monthly customer update meetings, monthly global IT support meetings, coordinated Global testing for major Oracle Patches, guiding and mentoring Mainframe system analysts while they transition to Oracle.
• Consult with end-users to analyse and understand needs, objectives, desired features, and input and output requirements. Provide end-user instruction and support to resolve application issues.
• Provided custom solution to integrate third party Tax API (ADP), to Oracle EBS.
• Develop, coordinate, and implement plans to test business and functional processes and quality assurance testing. Lead functional acceptance testing of patches and upgrades. Train and document processes.
• Develop test scripts, process flows and functional specifications for the process improvement projects.
• Performed setups for Oracle Accounting Rules, Loan Types and Loan Event Actions - this included workflow.
• Documented AR and AP B.R.100 and M.D.50s Loans for disbursement to Invoice Interface.

Oracle Finance Business Analyst

Confidential, the Woodlands, TX

Responsibilities:

• Designed and developed custom Workflow components using Oracle Workflow builder to fulfil client business rules to process sales order.
• Involved in debugging various Pricing, OM, Pricing module related Functional Issues.
• Debugged various workflow related issues related to OM module.
• Involved in debugging various PIM related issues.
• Developed various new custom reports in AP and PO Modules.
• Define and set up DFF's using Application Developer responsibility for Purchase Order Header to identify Contract Retention Invoices.
• Created and customized reports using XML Publisher/BI Publisher in AP, PO, AR, PIM, and INV.
• Create and define template and data definitions for Open Purchase Order report. Conditionally display company logo information based on run time parameters.
• Involved in debugging various interface related issues in AP and Order Management.
• Involved in debugging various OAF related issues and Enhancement requests (OA Extensions).
• Developed various Extensions and Personalization's in OM.
• Created custom Shell scripts to handle the loading the data file into the custom tables and archiving of the data file.
• Identification of Gap & put collaborative effort with the Technical team to address the same through Technical Specification.
• Facilitated Pricing & IT Business to obtain clarity on the Business Rules and capture the same.
• Worked for the Category & Mapping data migration to meet the go alive deadline.
• Jointly worked with the QA team in formulating the Test Cases & Test Scenarios.
• Assisted Business for Business Acceptance Testing and obtain Sign off.

Oracle Finance Business Analyst

Confidential - Clayton, MO

Responsibilities:

• Involving in the business meetings with SME'S stake holders to discuss the business process flows.
• Validation of Business Change requests, requirements and processes.
• Analysing and providing the solutions for the support tickets as per the SLA.
• As a programmer analyst analyzing the program for any gaps.
• Do the necessary programming to correct the system using Oracle Technologies.
• Documentation of design specifications for technical development.
• Conducting workshops to gather the business requirements as per the SLA.
• Preparation of business blue print document.
• Taking business sign off on completed programs.
• Handling a team of programmers and analysts.
• Monitoring the work of team and making everything go as per the timelines with daily meetings.
• Reporting the work to management in weekly meetings.