SUMMARY:

• Over 10 years of experience in Information Technology as Oracle Functional Consultant in successfully implementing enterprise applications with global clients.
• Implemented and Supported Oracle EBS R12\11i & Fusion Cloud Applications (R11 & R12)
• 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 and SCM modules including - iExpenses, iProcurement, Inventory, Purchasing, Order Management, Payables, Receivables, Fixed Assets, 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.
• 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 allocatedAppropriations and Segregations.
• Modified EntireRollup Structurefor Chart of Accounts and definition of newSummary Templates.
• POC andImplemented Encumbrance Accountingfor 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
• Experienced in iProcurement/PO approval routing through Oracle R12 AME, Fusion Cloud BPM Rules and workflow
• Expertise in the AIM Methodology, Documentation (RD020, BP040, BP080, BR100, MD050, TE040, etc.), Configuration of Applications, Testing, End-User and Supporting for Oracle Financials Fusion Cloud, R12, &11i iniExpenses, iProcurement, Inventory, Purchasing, Order Management, 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 ofRevenue Recognitionsolutions
• 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.
• Experienced in Data mapping the external source files with oracle columns inOracle Accounts Receivables, Accounts Payable,Fixed Assets, General Ledger and Cash Management modules
• Experienced in FSM, BPM, IDM, FBDI, FRS along with Fusion Financials Applications
• Prepared OUM Documents i.e RD030, RD011, AN100, TE050, TE020, DO070 etc.
• Manage on-site and off-shore development and support teams

TECHNICAL SKILLS:

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

Oracle Supply Chain Applications: Purchasing, Inventory, Order Management

Oracle iModules: iProcurement, iExpenses

Other Tools: 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

Life Cycle Experience: Requirement Analysis, Functional Modeling, Legacy Systems Integration, Business Process workflow modeling

PROFESSIONAL EXPERIENCE:

Confidential, Cincinnati - OH

Functional Consultant Oracle Fusion Cloud

Responsibilities:

• Analyzed the current system by interacting with business and cross functional teams.
• Involved in System Configuration and prepared documents by following OUM Methodology
• Worked on Fusion Financial Applications to support day to day application user issues
• Completed setups for new Business Units
• Working with FR Studio Reporting, Smart View, Account Inspector and Account Monitor, OTBI Reporting
• Setting up roles to user as per their responsibilities in OIM (Oracle Identity Manager)
• Preparation of Custom Job Roles for Employee to provide access to relevant tasks.
• Effectively worked with Oracle support team to resolve product related issues and bugs.
• Configuration and modification of Approval processes in Business Process Management.
• Conducted Key User to Business users
• Worked on configuration changes.
• Analyzed the issues on Production System and resolved them meeting SLA.

Environment: Oracle Financial Applications Fusion Cloud R12 (Purchasing, iProcurement, iExpenses, Payables, Receivables, Fixed Assets, General Ledger, E-Biz Tax and Cash Management)

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

Functional Consultant Oracle Fusion Cloud / Team Lead

Responsibilities:

• Managed a team of 20 members during Implementation Life Cycle
• Understood client business process
• Mapped the Business Processes with Oracle Fusion application standard functionality
• Conducted prototype sessions (CRP) to business to get requirement sign-off
• Handled UAT Sessions and prepared documents i.e RD030, RD011, AN100, TE050, TE020, DO070 etc.
• Configured System for all financial application in the environment of Functional setup manager (FSM)
• Configured COA, Calendar & Ledger, Business Units, Companies & Legal Entities, Natural Accounts, Financial Sequences, CVR, Payables and Other modules setup data using Rapid Implementation Spreadsheets
• Defined Approval Rules through BPM
• Worked on Setting up Job role, duty role, data roles and abstract roles as per business requirement
• Completed testing for all financial applications (Unit & Integrated)
• Created users by giving role provisioning in OIM
• Worked on FR Studio and Smart view.
• Enabled Business Unit functions
• Configured Common Options for Payables and Procurement
• Loaded Master and transactional data using Rapid Implementation and FBDI Templates
• 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.
• 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 iExpenses, iProcurement, Purchasing, Payables and General Ledger
• Prepared Functional Design Documents FDD’s based on the requirements gathered

Environment: Oracle Financial Applications Fusion Cloud R12 (iExpenses, iProcurement, Inventory, Purchasing, Payables, Receivables, Fixed Assets, General Ledger, E-Biz Tax and Cash Management)

Confidential

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 teams.
• 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 and reengineering
• 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 entities.
• Coordinated with Cross Functional teams for customizations and calling out key issues.
• Gave the overview on functional modules to technical team.
• 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 (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 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, Order Management, Payables, Receivables, Fixed Assets, 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, Fixed Assets and General Ledger)

Confidential

Software Engineer

Responsibilities:

• Implemented Oracle Financials along with integration of Legacy Systems (IPOS for creating Purchase Orders, Homisco System for Post Paid revenue recognition and Active Retail System for Prepaid revenue recognition) as per Client’s Business requirements.
• Responsible for Requirements gathering, Functional Specification, and Design.
• Studied and documented the As-Is and To-Be process.
• Performed fit-gap analysis of functional areas between legacy systems and Oracle ERP.
• Provided an optimized solution considering post fit-gap analysis findings.
• Defined a phased data migration strategy by collaborating with client.
• Documented BR100, Functional and Report Extensions documents through MD 050 and MD 070
• Implemented data migration - collected data from client systems, cleansed and migrated to newly integrated systems.
• Functional spec for Conversion of legacy data into AR and its validation
• Developed Test Scripts, Material, Knowledge Transfer and User .
• Supported issues after GO Live in the areas of Auto Invoice, Receipts and month end closing.
• Creation of Item Masters; Category Sets and Codes
• Supported in the month end close process and resolved issues

Environment: Oracle Financial Applications R12 (Inventory, Purchasing, Payables, Receivables, Fixed Assets, Cash Management and General Ledger)

Confidential

Business Analyst Oracle EBS

Responsibilities:

• Led feature enhancement of existing modules, which includes Oracle General Ledger, Payables, Receivables, Fixed Assets and Cash Management.
• Coordinated with various business teams in arriving at the right solutions.
• Documented RD020, BP040, BP080, BR100, MD050, TE040 as per Oracle AIM standards.
• Coordinated with Cross Functional teams for customizations and calling out key issues.
• Worked on Preparation of Menus and in setting up various roles & responsibilities in AP, AR FA, GL and CM Modules.
• Designed and implemented cross validation Rules as per business need.
• Designed and implemented customized solutions to integrate client’s 3rd party purchase and revenue systems data into Oracle systems.
• Implemented Oracle Purchasing, Inventory to meet late add client requirements, meeting critical deliverables within accepted schedule.
• Conducted Functional Testing in CRP3 before its replication to UAT.
• Coordinated with various teams of business and trained end users.
• Extended and Support in month end close process

Environment: Oracle Financial Applications 11i (Inventory, Purchasing, Payables, Receivables, Fixed Assets, Cash Management and General Ledger)