SUMMARY:

• Over 10 years of experience in Information Technology as Oracle Techno Functional Consultant in successfully implementing enterprise applications with global clients.
• Understood and Studied the current business processes/requirements and future business flow in order to provide an integrated information system solution to meet the business needs of the company.
• Multiple Implementations of full system development life cycle(SDLC) across financials include - iexpenses, iprocurement, Inventory, Purchasing, Payables, Receivables, Confidential, Cash Management, Subledger Accounting, E-Business Tax and General Ledger modules.
• Possess working knowledge and also have Solid experience in defining processes relative to Procure to Pay, Order to Cash, Record to Report and Close Processing.
• Experienced in iProcurement/PO approval routing through AME Rules and workflow
• Expertise in wide range of Oracle Applications modules which includes Oracle Purchasing, Oracle Inventory, Order Management, Iprocurement and Isupplier Applications.
• Conducted the Gap Analysis in order to understand the 'as-is' and the 'to-be' scenarios
• Designed new Budget Structure in GL based on State allocated Appropriations and Segregations.
• Modified Entire Rollup Structure for Chart of Accounts and definition of new Summary Templates.
• POC and Implemented Encumbrance Accounting for the New Budget setup.
• Defined Budget Organization, Budget, Budget Journals, Uploaded Budgets, Budget Formulas, Mass Budget. Enabled Budgetary Control, Encumbrance Types, Enter & Post Encumbrances Carry forward Encumbrances. Revaluation, Translation, Consolidate set of Books and worked on Year End Process
• Defined formulas for Mass Allocation and Recurring Journals. Completed setup of options required to perform Mass Allocations. 
• Good Exposure to Reconciliation of Sub-Ledger modules with GL, Accounting Setup Manager, Inter Company Accounting and MOAC.
• Well-versed with E-Biz Tax configurations, setup configuration owner tax options, created Party Tax Profiles, Tax Regimes, First Party Legal Entity Party Tax Profile, Tax, Tax Status, Tax Jurisdictions, Recovery Rates, Tax Rates and Tax Rules
• Configured Banks, Bank Branches, Bank Accounts and Bank Transaction codes
• Worked on integration of Cash Management with Payables, Receivables and General Ledger.
• Worked on reconciliation process - Manul clearing process, manual reconciliation, automatic reconciliation
• Entered Bank statements manually and imported bank statements for file formats BAI2 and Swift 940 by running Bank Statement Import program
• Reconciled Bank statement lines by running AutoReconciliation Program, highlighted un reconciled lines
• Worked on transferring balances from one bank account to another bank account by configuring Intra / Inter company setups in GL
• Conducted Oracle CRP sessions to demo the out of box functionality on the Financial modules
• Conducted Functional Testing, Systems Integration Testing, Regression Testing, User Acceptance Testing (UAT) and Smoke Testing by preparing test plans, test cases and test data to be used further by collaborating with QA team
• Expertise in the AIM Methodology, Documentation (RD020, BP040, BP080, BR100, MD050, TE040, etc.), Configuration of Applications, Testing, End-User Training and Supporting for Oracle Financials Fusion Cloud, R12, &11i in iexpenses, iprocurement, Inventory, Purchasing, AP, AR, FA, CM, E-Business Tax and GL modules.
• Mapped the Legacy system functionality to what was available in the Oracle applications for Requisition, PO, AP modules, identified gaps and offered solutions.
• Designed and executed several Customizations and Setups in ERP as part of Revenue Recognition solutions
• Supported the production environments and users on a daily basis by resolving user issues.
• Analyzed user needs, conferred with users to improve procedures and implemented optimized solutions.
• Logged, viewed, accessed, monitored, followed up and closed the Service Request (SR) with Oracle Support.
• Experience in Data mapping the external source files with oracle columns in Oracle Accounts Receivables, Accounts Payable,  Confidential, General Ledger and Cash Management modules
• Manage on-site and off-shore development and support teams

TECHNICAL SKILLS:

Oracle Financial Applications: Receivables, Payables, General Ledger, Confidential, Cash Management, SLA and E-Biz Tax

Oracle Supply Chain Applications: Purchasing, Inventory, Order Entry, Advanced Pricing, Shipping Execution, Demand Planning, Material Planning, ASCP

Oracle iModules: iProcurement, iSupplier, iExpense

Other Tools: AIM, Web ADI, Dataloader, TOAD, HP ALM

Programming Languages/Databases: SQL, PL/SQL, SQL*Plus

Operating Systems: Windows 95/ 98/ NT/ XP/ 2003/2010/2013/2016

Project Management tools: MS Word, Visio, Power Point, Excel, Project, Remedy,JIRA

PROFESSIONAL EXPERIENCE:

Confidential

Systems Analyst / Team Lead

Responsibilities:

• As part of the Finance Transformation Program
• Analyzed the current system by interacting with business and cross functional teams.
• Conducted Key User Training to Business users
• Worked on configuration changes.
• Analyzed the issues on Production System and resolved them.
• Worked on Production support related incidents and resolved incidents meeting SLA

Confidential, Alpharetta, GA

Business Analyst Oracle EBS

Responsibilities:

• As part of the assignment worked on this in house project by coordinating with client on the requirements gathering phase As-Is and design of To-Be process

Confidential, New York - NY

Business Analyst Oracle EBS/Team Lead

Responsibilities:

• Contributed as Team Lead at Confidential in the Finance Transformation Programme (FTP), which involves
• Business and Technology change programme to drive QBE Finance towards their vision.
• Responsible for Implementing Oracle Financials Fusion Cloud for all of the QBE’s divisions in European Operations (EO);
• North American Operations (NAO), Australia & New Zealand (ANZ); and Emerging Markets (both Asia Pacific and Latin America)
• Led successful Oracle EBS upgrade project (from 11i to R12.2.3 to Fusion CLoud); completing it within the budget and timeline along with smooth first month closing.
• Implemented iexpenses, iprocurement, inventory, purchasing, Payables, Receivables, Confidential, General Ledger, SLA, E-
• Biz Tax and Cash Management modules in Oracle Financials and Fusion Cloud,
• Managed a team of 20 members during Implementation Life Cycle
• Worked on implementing internal requisition and internal sales orders as a solution for intercompany transactions.
• Worked on solution design and setup of Inventory, Purchasing & Order Management as per the client requirements and suggested business process changes.
• Requirement gathering, Configured Inventory, Purchasing and Order Management during the implementation life cycle.
• Provided solution to better manage recalls in all the locations around the globe.
• Setup and maintenance of all the alerts and notifications.
• Worked towards the proof of concept and involved in defining the organization structure.
• Worked on item conversions and prepared conversion documents (CV10, CV040)
• Handled conversion stages for Inventory and Purchasing modules. Designed dataload scripts for manual conversions
• iProcurement & Centralized Purchasing - Implementation of centralized purchasing process to ensure a specific group within ORG manages corporate purchasing and implement iProcurement self-service requisitioning application
• Master Data Cleanup - Suppliers, Customers, Trading Community, Supplier Merge etc.
• Worked on various interfaces, conversions where QBE integrates its Financial data to and from various third party source systems
• Designed workflows as per the business need in iExpense, Purchasing, Payables and General Ledger
• Prepared Functional Design Documents FDD’s based on the requirements gathered

Environment: Oracle Financial Applications R12/Fusion Cloud (iexpenses, iprocurement, inventory, purchasing, Payables, Receivables, Confidential, General Ledger, SLA, E-Biz Tax and Cash Management)

Confidential, San Jose, CA

Oracle Support Analyst/Lead

responsibilities:

• Managed a team of 25 members to support business users by providing solution on the issues raised
• Prepared Business and functional requirement document for the RAE project.
• Analyzed the current system by interacting with business and cross functional team.
• Responsible for all deliverables including Data extract programs, Reports and $U programs.
• Mapped the Client requirements with Oracle standard functionality and finding the gaps and delivered the solutions in terms of Customizations, workarounds, reengineering and form personalization.
• Worked on configuration changes for new entities.
• Analyzed the issues on Production System and resolved them.
• Thoroughly Tested the functionality of new enhancements for new entitles.
• Coordinated with Cross Functional teams for customizations and calling out key issues.
• Gave the overview on functional modules to technical team.
• Analyzed the current system by interacting with business and cross functional teams.
• Responsible for preparing the Artifacts, Kintana migration - components from one instance to other instance by using the PVCS for version control.
• Lead the offshore technical team and worked in multiple time zones for implementing the Functional and technical solutions.
• Prepared BR100 Documents for business users and addressing training (KT) sessions to users.
• Triage and identify root causes for complex end-user issues and come up with effective solutions by coordinating with client and Oracle
• Resolved user’s troubleshooting issues during Create Accounting; workflow - reassign, delegation, process stuck, deferred etc for the PO, iExpense, approval processes.
• Worked in Fin Recon Team - work involved preparation of Weekly / Monthly Fin Recon Reports and resolution of reconciliation related issues
• Provided extensive user support Analysis: Research solutions to problems, answer client questions and provided consulting and training as required. Track software and documentation issues.
• Worked on Production support related incidents and resolved incidents meeting SLA
• Created Oracle Support Requests (SR) using metalink, provided action plan updates, applied data fixes, patches as applicable. Ensured thorough testing (UAT) from IT and business users before moving changes into Production.
• Assisted Testing Team in validating UAT Test Scripts
• Pro-actively lead initiatives to validate corner case scenarios to reduce potential defects by 25%
• Implemented custom solutions to improve user experience by streamlining complex processes, business work-flow and reduce operational cost
• Effectively managed patch releases ensuring the quality of the product meeting SLAs

Environment: Oracle Financial Applications R12 (iexpenses, iprocurement, inventory, purchasing, Payables, Receivables, Confidential, General Ledger, SLA, E-Biz Tax and Cash Management)

Confidential

Oracle Support Analyst

Responsibilities:

• Configured the system, and provided optimized solutions to meet client’s critical requirements.
• Led the peer review and validated all the BR100’s with the user stories gathered from the client.
• Configured the system using automation and created fld’s and Ldt’s through Oracle isetup and xml generations.
• Raised Service Requests for critical requirements with Oracle, interacted closely with Oracle and provided optimized solutions.

Environment: Oracle Financial Applications R12 (Payables, Confidential and General Ledger)