SUMMARY:

• Over 7 years of experience in IT consulting as an ERP Oracle E - business Suite business/functional analyst in multiple business domains in analyzing, implementing and training of Oracle applications which includes GL, IPPO, FA, AP, AR, CM, E-Business Tax, iExpense, Order-to-Cash and Procure to Pay
• Strong experience in various versions of Oracle Applications such as R12, 11i.
• Extensive experience in implementing and testing Oracle Financial Modules including Order to Cash (O2C) and Procure to Pay process (P2P).
• Experienced Software Quality Assurance with strong custom programming and direct end-user support skills
• Experience in developing PL/SQL and SQL statements in databases such as ORACLE SQL, MS SQL and MySQL.
• Hands on experience in variety of Oracle application such as HR, PO, PA, GL, AR, AP, iprocurement, e-sourcing and isupplier.
• Expertise involving system analysis, programming and Software Quality Assurance (using HP Quality Center, QTP, TOAD, and SQL Developer).
• Completed End-to-End Implementations Testing in Oracle applications R12i/R11i from requirement gathering to post production.
• Expertise and hands on experience with implementation of Hyperion planning and Budgeting solution including Finance & Workforce Planning, Management Reporting and Hierarchy Management. Well versed with the planning application and Essbase cubes being developed in Oracle EPM.
• Creation of Supplier Oracle access in isupplier module
• Updating the Verbiage of iprocurement approval notification, loading Item through XML schema.
• Support of production and test instances for upgrade/regression/integration/User acceptance testing. Trained users and developed training material.
• Functional understanding of the workflows and its configurations.
• Creating financial statements and ad hoc reports using FSG (financial Statement Generator).
• Support of production and test instances for upgrade/regression/integration/User acceptance testing.
• Expertise in reconciliation of Sub-ledger modules with module.
• Good exposure and understanding of integration of iprocurement Module with Purchasing.
• Expertise in Client Interaction, Requirement Gathering and Functional Design documentation.
• System administration skills include defining request groups, responsibilities, users, assigning responsibilities to user setup of profile options and maintaining concurrent programs.
• Experienced in Sub-ledger Accounting (SLA), Accounting Setup Manager, Multi Org Access Control (MOAC).
• Proficient in the concepts of Multi-Org, Global Consolidation System, Multiple Reporting Currencies and Flex field setups.
• Good Knowledge of Cut-over Strategies.
• Good experience working with Business owners and users; Gathering business requirement; Solution Design; Preparing specification documentation; Designing process workflow; Identifying and resolving Gaps; Providing functional inputs for specifications, Good understanding of business process, and Post implementation Support.
• Excellent communication, team building and project management skills.
• Designed solutions to enhance standard oracle flows for Order to Cash(O2C), Procure to Pay(P2P), Assets to GL, Inventory, TCA, Credit Card Transactions, GL Accounting processes.
• Proficient in designing and requirements for RICE (Reports, Interfaces, Configuration, Enhancements) Implementation, Conversion, Data Migration.

TECHNICAL SKILLS:

Databases: Oracle RDBMS V7, 8i, 9i and 10g

Languages: JAVA, COBOL, BASIC, PL/SQL, SQL*Plus, HTML, XML

Tools: Oracle Portal, PL/SQL, SQL*PLUS, Application Object Library, Developer2000, Developer 6i (Oracle Forms 10g, Form 6i, Forms 5.0, Forms 4.5 & Reports 10g, Report 9i, Reports 6i, Reports2.5), Oracle SQL*Loader, Oracle Enterprise Manager, Hyperion Essbase 9.x, Hyperion Planning 9.x PL/SQL Developer, TOAD, HP ALM/Quality Center, QTP, JIRA, Confluence

Applications: KFS(Kuali Financial System), SciQuest, TSM(Total Supplier Management), Administration, Human Resources (Release 11.5.10),Oracle General Ledger (Release 11i/ 11.0/ 10.7), Oracle Accounts Payable (Release 11i/ 11.0/ 10.7), Oracle Purchase Order (Release 11.5.10), Project Accounting (Release 11.5.3). Oracle iprocurement, Oracle Sourcing, Oracle isupplier.

Operating System: UNIX (SUN Solaris, HP-UX), Windows 7, Windows XP, Windows 2000, Windows NT, Windows 98, Windows 95

Methodologies: Agile, Water Fall, Oracle AIM 3.0

PROFESSIONAL EXPERIENCE:

Confidential

Oracle Functional Consultant

Responsibilities:

• Involved in setups for Ledgers, Responsibilities Multi org, financial options, Payable Options, Suppliers, Tolerances, and Banks.
• Closely worked on a project called Account Standardization at Citi for different countries (implemented around 23 countries) where all the GL accounts were aligned to UNSPSC mapping based on commodity.
• Provide solutions to functional issues and involve in testing of the application releases
• Leading an initiative where PRENAX (subscription management company) was on-boarded and integrated with P2P.
• Closely worked with business users to understand the business processes and prepare the business requirements definition documents
• Participated in Setting up Asset Key Flex fields, Asset Categories, Asset Locations, and Asset Calendar.
• Gathered requirement data, mapped data elements to Oracle functionalities, reviewed gaps, defined work-around solutions to proactively reflect company’s business future outlook. Used descriptive flex fields to cover additional data and to reference historical data during transaction processing.
• Successfully merged multiple sub-ledgers in FAS to one consolidated sub-ledger, responsible for conversion and migration of fixed assets from the Legacy system into oracle,
• Ability to impart Functional training in Oracle General Ledger, Account Payables and Purchasing
• Participating in CRP phases. Train the team members in Sub Ledger Accounting (SLA), Multi Org Access Control (MOAC).
• Supported Oracle R12 Applications - Human Resources, Payables, iProcurement, iExpense, General Ledger, Web ADI and timesheets.
• Create/Maintain/Administration of Hyperion Financial Reporting, applications in HFM & FDM
• Installation of Hyperion Planning, Essbase, HBR, Reports, Analyzer, HAL & license server for new production environment.
• Created SR’s with Oracle for supporting Oracle R11 support tickets and for patch analysis and its implications.
• Creating iprocurement Category hierarchy, punchout catalog setups, setting up content zone and stores.
• Patch analysis and Pre-requisites for one-off and rollup patches for oracle projects and iexpense
• Extensive work with Hyperion Essbase administration, User privileges, creating filters, tuning and optimization of cubes
• Resolved support issues for iprocurement approval testing and payable accounting process.
• Document existing functionality for iprocurement and HR for process improvements.
• Cutover Planning and Management
• Built and maintained detailed (450+ steps) MS Project technical/functional cutover plan used for production cutover and rehearsals
• Managed cross-team integration (including independent data warehouse/reporting group) throughout cutover process

Environment: R11- General Ledger, AP, AR, Fixed Asset, CE, Alerts, Order Management, Report Manager, iProcurement & iExpenses, Hyperion Essbase 9.x, Hyperion Planning 9.x

Confidential

Oracle EBS Functional Consultant

Responsibilities:

• Involved in implementation and testing of Oracle Applications Financial R12 GL, AP,FA and CM modules
• Involved in requirement gathering and analysis and design of the application.
• Worked with the client team to understand the current Business Process.
• Developed test plans and scripts and conducted testing for quality assurance.
• Configured GL, AP modules in R12 Environment.
• Worked on requirements gathering, gap mappings, and various functionalities in General Ledger.
• Working on Payables and Cash Management setups and issues.
• Determined business requirements for Asset summary by category report, Asset register report Customized Asset addition by cost summary report, Asset category report, Asset retirement report, Asset additions report, Annual additions report.
• Worked on Setting Instances for new acquisitions.
• Reviewed and refined the Common Apps setup steps shared across modules like Oracle SYSADMIN, GL, AR, AP, PO, INV, and PO (such as Set of Books, Currency (enabled), Locations, Organizations, Customers, Suppliers, Tax- Codes, Key and Descriptive Flexfields and UOM).
• Involved in implementation, migration and validation for Hyperion Essbase upgrade from V6.5.4.2 to V7.1.6
• Maintained Essbase databases using Planning application to meet financial requirements. Developed applications using Hyperion Financial Management (HFM) Suite for automation and reporting process.
• Working on post upgrade support and interacting with Business users on Issue resolutions.
• Fixed assets setting up of Asset Categories, Asset Keys, Locations, Fiscal Years, Book Controls, Calendars, Prorate Conventions, Depreciation Methods, Bonus rules, Ceilings and Security.
• Prepared Module design (MD050) Documents for Customizations.
• Implemented a major Enhancement “Journal entry creation for Cash management Entries” to perform reconciliation of Treasury entries which saves significant cost & Benefits the Customer to avoid manual intervention.
• Worked on Setting up and customizing dunning letter, statement cycle in Accounts Receivable module.
• Developed FSG Reports in GL like (Income statement, Dept Expenses, Inter Company Summary).
• Created custom responsibilities to which were attached specific menus, forms and reports for restricted user access.

Environment: Oracle Application R12, Oracle General Ledger, Oracle Payables, Oracle Receivables, Cash Management & Fixed Assets, Hyperion Essbase 7.1.6, Hyperion Financial reporting9.x, Hyperion Application Link

Confidential

Financial Functional Consultant

Responsibilities:

• Interacted with the Business users for understanding the Requirements and subsequently developed the functional design to meet the client requirement.
• Responsible for gathering Business Requirements (RD 020), Identifying Gaps & Fit Gap analysis (BR 010).
• Designed & implemented a Customization on “Refund process” (with the help of Technical team) to refund the amount to the Customer by cutting a check in AP.
• Implemented a major Enhancement “Journal entry creation for Cash management Entries” to perform reconciliation of Treasury entries which saves significant cost & Benefits the Customer to avoid manual intervention.
• Evaluating the Reports and testing them for the desired outputs after development as Per the Business requirements.
• Gathered requirement data, mapped data elements to Oracle functionalities, reviewed gaps, defined work-around solutions to proactively reflect company’s business future outlook. Used descriptive flex fields to cover additional data and to reference historical data during transaction processing.
• Used systems options, profile options, financial, payables, purchasing options to control data usage and integrity, to default list of values into forms and windows, and restrict access to functions when users were unauthorized to view or access data.
• Responsible for Baseline configurations for Accounts Payables, Accounts Receivables & Cash Management.
• Providing solution for Revenue Recognition for Pacific Bio Sciences orders in AR.
• Helping technical team develop a customized Revenue Recognition program in AR.
• Developed and executed test scripts and drove resolution of fixes to the system prior To User Acceptance Test.
• Responsible for end to end testing on Accounts Payables.
• Testing the entire process of Payables transfer to GL, AP Assets creation and mass Additions create through Payables.
• Performed hands on configuration setups for GL and AP, including budgets, multi-org & multi reporting currency.
• Participated in setting up of Multi-Org for managing multi-org setups.
• Set up of Desktop ADI and test the creation of Journals along with WEB ADI.
• Evaluating and adding account combinations so Account Generator runs smoothly for Depreciation run.
• Played significant role in system Integration testing.

Environment: R11- GL, AP, AR, FA, CE, IPPO, Project Accounting.