PROFESSIONAL SUMMARY:

• Accomplished finance functional professional with total experience on IT Industry of16years, of which13+years as Oracle Applications Financial Functional Consultant - R12 / 11i
• Worked extensively on General Ledger (GL), Accounts Receivable (AR), Revenue Recognition, Accounts Payable (AP), Fixed Assets (FA), Order Management (OM) and Cash Management (CM).
• Have done2full life cycle Implementations,40+Rollouts for18Countries and4support projects.
• Handled support desk for multi-org setup, Root Cause Analysis, providing timely resolution for ERP Issues and attending enhancement requests /Report Requirements. Documenting the Functional Specifications of Enhancement requirements/Reports.
• Responsible for managing the ERP business requirements and key role in configuring Financial & Oracle Supply Chain Modules in Implementation, Upgrade, Enhancement, Testing, Production Support, Customization of Business Applications, Conversion, User Training and gathering Business requirements
• Hands on expertise in Business Requirements gathering, Requirements definition, mapping to future business models, solution design and testing deliverables
• Conducted and lead various workshops with different Financial groups to gather business requirements and responsible for writing Project Specific Documents and Business Requirements Documents. Troubleshoot questions/problems from the user community with Oracle Application issues
• Imparted User/Core User training, Client Interaction for all the Implementations and Rollout Projects off shore and onsite.
• Very good understanding of enhance features of R12 (SLA/E-Biz Tax)
• Experience in Master Data Conversion and Closing Process in Oracle.
• Experience in integration development, support and maintenance for Enterprise Application Solutions for financial operations.
• Interfaced with users, identifying functional and technical gaps, estimating work, architecting system interfaces, designing custom solutions, programming, leading developers, scheduling, producing documentation and providing production support
• Used AIM Methodologies for various Functional Designs-Setup, Test Scripts flows etc
• Worked on Rally with Agile methodology
• Troubleshooting and coordination with Oracle Customer Support for resolution of issues.
• WRICE (Workflow, Reports, Interfaces, Conversions, Enhancements)
• Knowledge of Quality Process in building Standard Process documentations for Oracle Applications.
• Adept in managing small and medium sized teams with synergistic team player, strong and excellent interpersonal skills
• Good Performance rating throughout professional career
• Multiple awards at different level of the organization for outstanding performance
• Multiple customer appreciations for technical expertise, leadership skills, innovative problem solving skills and effective communication.
• On the sport Award from Client partner for two times
• AR System Options, AR Receipts, Lockbox, AR Quick Codes, Customer profile classes, payment terms, AR distribution sets, Auto Cash Rule Sets, Invoicing rules, accounting rules, Territories, Invoice Sources, receivable activities for miscellaneous receipts, finance charges, bank charges, defined collectors, aging buckets, statement cycle to profile classes. transaction types, Assigning the necessary tax exemptions to the eligible customers
• Internal & External supplier Banks for payable use, Special Calendar for Recurring Invoice, Payment Terms, Payable Quick Codes, Payment Attributes, Payment Formats, Payable Documents, financials options, payables System options, bank documents, bank codes, expense report templates, purchasing quick codes, invoice distribution, Tax Code, Tax group, Rates using E-Business Tax, Withholding Tax Setups, Payable Transfer to GL
• Payment setups, Payment process profiles, Requests Formats, XML Publisher Templates and Bank accounts to facilitate the Check and EFT Payment process.
• System Options in CE, Cash forecasting, Reconcile AP with bank statement in Cash Management, Configured I expense templates and travel policy.
• Involved with migration of historical data for Accounts Payables and Accounts Receivables.
• Master Data and Transaction Data (FA and AP Transactions) migration using Application Desktop Integrator, Data loader and migration interface, testing for data migration
• Technical Development skills in developing Reports, Interfaces, Conversions and Forms (Oracle RICE & CEMLI Components).
• Good Knowledge on Coding standards & Oracle AIM technical Documentation.
• Reliable perception in Sys Admin assigning Responsibilities, Registration of forms and reports, Executable and concurrent programs.
• Revenue Recognition Invoices to recognize the revenue over period of time, Auto-Invoice Import Process, Receipt creation method, receipt class, receivable activities, handling Refunds
• Definition of State, County, City, Tax Regimes, Tax, Tax Rates and Tax Rules in eBusiness Tax module
• Assigned receivable account, revenue account, unbilled account, freight account, cleared account, and unearned account to transaction types
• Custom Customer invoice print templates, Trained users on guarantees, deposit, credit memos, debit memos, lockbox
• Good Working knowledge on Oracle Workflows, Discoverer, Oracle XML Publisher (BI Publisher), Form Customization/Personalization and Alerts
• Configured and implemented Chart of Accounts, Value Sets, Ledger, Security Rules, Cross Validation Rules, Calendar, Journal Source, Journal Category, Designed Financial Reports using Financial Statement Generator (FSG) tool, Setup General Ledger, consolidation ledgers, AGIS for intercompany transactions, FSG reports (Income statement, Cash flow statement, and Balance sheet statement.
• GL Data Access Sets and to Multi OU through security profile in a secured environment, Advanced Global Intercompany Systems, Resolve user’s issues in using WEBADI, Design and Implement GL Journal Entry Approval, Currency setups.
• Defined journal source, category, enable freeze functionality for deferent source, Journal Import validation process, formulas for Mass Allocation, Recurring Journals, Mass Allocations, privileges for users, rollup group, summary accounts, suspense accounts for automatic balancing journal entries from particular sources and categories.

PROFESSIONAL EXPERIENCE:

Confidential, California, San Jose

IT Analyst

Environment: Database: Oracle 12.1.0.2.0 Software: Oracle Apps R12.1.3 O/s: Linux Hardware Unix

Responsibilities:

• Worked on Revenue Recognition process
• Worked on CSPP applications, it is a new application and new setups, Test Cases Review, Test Result review which are created by QA team.
• Done the setups for new applications called CSPP(Cisco Service Partner Program)
• Worked on Cisco Offer Attribution, Cisco Service Partner Program, Cisco Two Tier, Cisco Partner Rebate and Cisco open RMA
• Worked on Partner Rebate interface program for FY17 Q3 Production Move.
• Preparing test data for VIP Reserves standalone & Bundle items scope.
• Wrote user stories in Rally and Reviewing Test cases and test results executed by QA team.
• Worked on Cisco VIP Rebate Reserve Details and Cisco VIP Rebate Reserve Summary Report.
• Analyzed all applications business functionality and code logic.
• Working on Agile methodology in Rally.

Confidential

Functional Consultant

Environment: Database: Oracle 10g Software: Oracle Apps R12.1.3 O/s: Linux Hardware Unix

Responsibilities:

• Working on eprentise to migrate from existing CoA to new CoA.
• Working on Panaya tool to get the impacted components and interfaces.
• Redesign the Chart with Ledger Sets, Secondary Ledgers, Sub ledger Accounting, Advance Global Intercompany system (AGIS).
• Priorities testing based on CoA change impact.
• GL Rules changes cross validation, Mass Allocation Security Rules.
• Plan and manage rule setup changes.
• Identifying number of rules and elements are touching each segment.
• Preparation of Project Documentation, Test Scripts.

Confidential

Functional Consultant

Environment: Database: Oracle 10g Software: Oracle Apps R12.1.3 O/s: Linux

Responsibilities:

• Rolled out 31+ ledgers for Asia Oracle for 23 Countries covering finance modules GL, AP, AR and FA
• Solution design, mapping of client’s requirements to standard functionalities, identification of gaps and suggestions / work around.
• Modification in the solution design based on the test results analysis, final testing and sign off.
• Preparation of data conversion strategy, data conversion into Production Instance
• Preparation of Project Documentation, such as Test Scripts, Standard Operating Procedures, Training Material and Setup Documents.
• Overseeing the UAT and assisting the Key users
• Involved in the Data Migration from Legacy Systems.
• Monitoring the team deliverables during each phase of project
• Analyze and Design the new operating model for integration of new branches.
• Address operational problems, concerns, and questions posed by users.

Confidential

Functional Consultant

Responsibilities:

• Provided analysis, design, and mapping of client’s requirements to Oracle
• Designed customized reports, fit gap analysis,and all documentation and deliverables.
• Developed interfaces and data conversion programs for applications
• Report and coordinate activities with customer project manager
• Handled connection issues, bank related problems, and printer installations.
• Maintenance of issue logs at each stage of project and their resolution
• Address operational problems, concerns, and questions posed by users
• Involved in the Data Migration to external systems.
• Preparation of data conversion strategy, data conversion into Production Instance
• Preparation of Project Documentation, such as Test Scripts, Standard Operating Procedures, Training Material and Setup Document
• Modification in the solution design based on the test results analysis, final testing and sign off.
• Preparation of data conversion strategy, data conversion into Production Instance
• Preparation of Project Documentation, such as Test Scripts, Standard Operating Procedures, Training Material and Setup Documents.
• Overseeing the UAT and assisting the Key users
• Involved in the Data Migration from Legacy Systems.
• Analyze and Design the new operating model for integration of new branches.

Confidential

Functional Consultant

Environment: Database: Oracle 9i Software: Oracle Apps 11i O/s: Linux

Responsibilities:

• Participated in various kinds of issue resolution for financial functional issues and was responsible for areas such as GL, AP, AR, FA, EB Tax, Daily business intelligence.
• Involved in resolving the day-to-day issues, which are faced by the end users but not limited to, like the errors that are generated, not progressing with actual flow of the functionalities, making use of certain new functionalities.
• Responsible for supporting the applications based upon the functional requirements of the client taking into their considerations by discussions, Teleconferences.
• Also, responsible for configuring the Daily Business Intelligence for Financial modules.
• Trained end users on these modules and prepared the training documents.
• Uploaded data through Data Loader
• Coordinated with core users with regard to solution for Service Requests raised by them with Oracle
• Helped Technical Consultants in preparing the conversions, documentation and helped them in preparing the reports by providing them with the functional aspects.

Confidential, St. Louis

Consultant

Environment: Database: Oracle9i Developer2000, XML Publisher, OAF O/s: Linux Hardware Unix

Responsibilities:

• Added New Re-enter Email Field to the iSupplier Registration screen that validates with existing standard Email Field.
• Enhanced the Adjustment Register standard report with new copy report called MCI Adjustment Register. Modified almost all the Layouts, few columns and additional parameters.
• Created a process of HSBC Bank Statement that contains all the HSBC Account Number whose data need to be filtered.
• Developed a custom program called MCI Custom File Transfer Program. Which create a process of Bloomberg Rates into Oracle Treasury for MCI Corporate Treasury.
• Implemented a program called MCI Corporate Contracts Expansion - Project Contracts and Contract Images are available in external environment. These details should be brought into Oracle Applications for maintaining at the same location.
• Worked on Complete data migration part AP Uploader, AR Uploader, Customer Loading, Supplier Loading through specific templates.
• Understands all the Functional and technical requirements from Client and Business user.
• Giving solution to the team on Module Setups and Interface developments and Customs Reports.
• Creates and executes project work plans and revises as appropriate to meet changing needs and requirements.
• Identifies resources needed and assigns individual responsibilities.
• Manages day-to-day operational aspects of a project and scope.
• Reviews deliverables prepared by team before passing to client.
• Effectively applies our methodology and enforces project standards.
• Prepares for engagement reviews and quality assurance procedures.
• Minimizes our exposure and risk on project.
• Ensures project documents are complete, current, and stored appropriately.

Confidential

Team Member

Environment: (with skill versions) Database: Oracle9i, XML Publisher O/s: Linux Hardware Unix

Responsibilities:

• Calculate Due Date Exclusion Change program.
• Added a link to the supplier registration screen that includes some information.
• Worked on the custom report “JCP: 1099 Forms - Comma Delimited Format”
• GL Inbound Change program.
• Added a custom help screen for each iSP responsibility.
• Involved in Continuous discussion with Functional Consultant.
• Interacting with business users for understanding the critical issues/requirements where necessary.
• Participating in technical discussions with third party teams for identifying solution.
• Fixing issues in existing development during post production.
• Developed few reports based on the business requirement.

Confidential

Team Member

Environment: Database: Oracle9i, XML Publisher O/s: Linux Hardware Unix

Responsibilities:

• Implemented the Engineering and Similar-to customizations to Order Line Workflow.
• Customized different OM forms to include the Region Solutions in the search criteria.
• Developed a new dynamic layout form to implement DFF like functionality.
• Developed programs to apply holds using OE HOLDS PUB.APPLY HOLDS API.
• Involved in development of the SO conversions using OE ORDERS PUB.PROCESS ORDER API.

Confidential

Team Member

Environment: Database: Oracle9i Developer2000, XML Publisher O/s: Linux Hardware Unix

Responsibilities:

• Involved in the design and development of workflows.
• Customized the Order Line Workflow.
• Developed the task creation programs using jtf Create task API.
• Extensively used FORMS PERSONALIZATION in customizing Forms.
• Design, Analysis and Development of the interface for the oracle financial module AR.

Confidential

Team Member

Environment: (with skill versions) Languages: SQL, PL/SQL Database: Oracle Developer2000 O/s: Linux Hardware Unix

Responsibilities:

• Developed item Demand Histories Upgradation.
• Involved in the development of Item Attachments Upgradation.
• Customization of Forms.
• Registering of Concurrent programs, Forms to AOL
• Developed custom packages to develop Upgradation programs.
• Design, Analysis and Development of the interface for the oracle financial module AR.

Confidential

Team Member

Environment: (with skill versions) Languages: SQL, PL/SQL Database: Oracle Developer2000 O/s: Linux Hardware Unix

Responsibilities:

• Customization of Forms & Reports.
• Involved in the development of Item Conversions.
• Worked custom.pll to trigger message and to make certain mandatory on
• Validated the business requirements.