Summary

• Over 8 years of total experience with more than 7 years working extensively in Oracle applications having excellent functional skills in using Oracle EBS General Ledger, Accounts Receivables, Accounts Payables, Fixed Assets, Order To Cash, Procure To Pay and Cash Management modules
• Adept at analyzing current business processes, determining system requirements, reporting needs and design and development of Oracle applications while incorporating best business practices
• 7 years experience as field consultant implementing EBS applications with progressively increasing leadership responsibilities
• 3 years experience working with Oracle Release 12 financials applications GL, AP, PO, AR, FA, FV, CE, e-Business Tax, Payments, iExpenses, and iProcurement . Conceptual knowledge of Oracle Application technologies and methodologies
• Experienced in using Oracle 11i financials applications GL, AP, PO, AR, FA, CE
• Good experience in study/audit of existing business process and preparation issue logs, collection of functional/technical requirements, client/user interaction, GAP Analysis, technical data mapping analysis and design of technical/functional data process flow charts
• Strong Exposure in preparation of high-level functional design documents for custom application development, Conversions, Interfaces Reports
• Worked on Onsite and Offshore model projects and coordinating offshore team
• Worked extensively in Oracle Applications R12 11i as Functional consultant in Supply chain, CRM and Manufacturing modules in various implementation, support, and up-gradation and rollout projects
• Worked on R12 Financial Modules and SLA, MOA Csetups, TCA, E-Business Tax
• Knowledge of Oracle's self service applications responsibility
• Knowledge of latest technologies towards development of e-Business Solutions
• Expert at gathering requirements, developing solutions and managing implementation of minor enhancements
• Expert at designing configurations, enhancements, conversions and interfaces which may include customizations and workarounds when the delivered functionality is not sufficient to meet the client's business process requirements
• Experience in the preparation of Standard Operating procedures specific to Client's business process with screen prints
• Build appropriate time lines and coordinate cross-functional teams
• Experience in System Administration tasks related to Menus/Functions, Responsibilities and Users
• Ability to be the single point of contact for business users for analysis, prioritization and resolution of production incidents and issues
• Analyze business needs to help ensure Oracle solution meets the customer's objectives by combining industry best practices, product knowledge, and business acumen
• Creating interface specifications for transfer of data between the software and other third-party applications, if necessary
• Experience in developing SQL and/or PL SQL queries, if needed
• Experienced in supporting functional and technical areas to guarantee the set-up and accuracy of deliverables related to Oracle and Fusion Applications and provide clear and concise documentation
• Strong internal-consulting relationships with managers and end-users in functional and technical areas
• Expert in analyzing problems and making decisions and recommendations in a variety of areas relating to financial system policy requirements
• Excellent communication and user interaction skills, capacity to work harmoniously in a group with sincerity and dedication towards work and organization

TECHNICAL SKILLS

Enterprise Resource Planning: Oracle Applications R12, 11i

Oracle E-Business Suite/Modules: General Ledger, Accounts Payable, Accounts Receivables, Purchasing, Fixed Assets, Cash Management, Order Management, Procure To Pay and Order To Cash lifecycles

Technological Environments: Microsoft Windows, Macintosh, Linux and UNIX

Database Tools: SQL, PLSQL, C, C , Informatica, Oracle databases

Office Applications: Microsoft Office Suite MS Word, MS Excel, MS PowerPoint, MS Access, MS Outlook , Microsoft Visio, Apple iWork, Apache Open Office

PROFESSIONAL EXPERIENCE

Confidential

Oracle Applications Functional Consultant

Implementation and Integration

Responsibilities:

• Gathering the client requirements and preparing the documents using AIM methodology
• Analysis of the current system by interacting with business and cross-functional team
• 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
• Worked with R12 implementation team in AP, PO, FV EB Tax, GL iExpenses modules in Multi-Org environment
• Created intercompany transaction, consolidation, elimination entries setups and configuration for use. The use of ADI wizards like Budget wizard, Journal wizard, report wizard simplified work with general ledger
• Configured MOAC setups for various operating units located in different legal entities
• Implementation of Oracle Payables including setup of payment options, payment terms, distribution set, payment format, banks, expense report templates, matching options, tax codes
• Setup, configured and defined the following in Order Management: order transaction types, automatic holds, shipping documents, release sequence rules, pick slip grouping rules, and shipping parameters
• Involved in implementing and providing support for the Financial Statement Generators, AGIS and consolidations
• Oracle Application Framework OAF applications, customization of OAF pages and extensions
• Developing a prototype to validate the purchase requisition approval process solution using oracle purchasing/ oracle approval management
• Supported Procure to pay and FA issues with month end and additional configurations
• Liasoned between the technical staff and the users staff and management . Was also responsible for inter-departmental co ordination between the various teams involved
• Effectively managed internal client services - which allow all users to address questions, report problems, and submit requests related to project implementation
• Prepared the data collection sheets for inventory, purchasing and Order Management modules
• Setup Expense Account Rules based on company, account segments attached to categories as per business requirements
• Documented and communicated changes throughout the user organization, supporting change management and compliance
• Reviewed and improved functional designs proposed by the project team
• Reviewed and approved any configuration change documentation for General Ledger, Cash Management, Accounting Receivables and Accounting Payables
• Worked with the offshore technical team and working in multiple time zones for implementing the functional and technical solutions
• Undertook performance-tuning activities on the Oracle EBS applications, concurrent manager and with exceptions the database tier
• Provided daily user support for fianancial modules as and when required to resolve the application issues
• Participated in user testing and helped in migration to production for BAU activities
• Post-Go-Live production support- performed system audits and troubleshooting
• Helped and contributed to post production support and resolved user issues

Confidential

Oracle Applications FunctionalConsultant

Implementation and Support

Responsibilities:

• Oracle Application Framework OAF applications, customization of OAF pages and extensions
• Managing a team for functional support of Oracle Financials GL, AP, FV, CM FA modules
• Overseeing the training and support of Oracle GL, AP, FA, FV, CE and AR Modules, resolution of issues logged in by the end users updating the online issue database
• Developed customized solution for clients. Coordinating with business users and functional team members for the functional requirement
• Evaluating, and adjusting where appropriate, the company setup tables relative to the client business practices
• Responsible for functional design, configuration change, setup, test and implementation
• Developed the Ad-hoc journal reports using FSG as per the end-user requirements
• Standard General Ledger reports and Oracle Payables reports such as Trial Balance, Payment Register and Invoice Register using FSG as per the functional specifications
• Modified Sub Ledger Accounting SLA definition as per client's requirement and resolve problems with SLA
• Managing a team for functional implementation of Oracle Financials GL, AP, CM and FA modules with localization across the organization
• Responsible for implementation of FSGs, AGIS and consolidations
• Rendering complete support and maintaining Oracle R12 financials modules
• Team up with functional teams and customer's staff and produce desirable results
• Integrating the invoices and payments data from Accounting Payables to General Ledger
• Preparing functional/technical specifications for reporting, interfaces and customizations
• Translate business/functional requirements to technical team
• Performed fit/gap analysis between the client's business processes and their intended use of the software, identified and communicated the solutions for the problems to the client
• Contributed to the overall strategic vision, and integrated a broad range of ideas regarding implementation and support
• Approving as well as correcting the accounting entries transferred from Oracle Payables to cover receipt accruals, invoice distributions expense, Work in Process , payables liability and disbursements
• Defined the auto-invoice in Accounts Receivable and confirmed the auto applications
• Assists in obtaining the approved/signed Final Acceptance Sheet from the client on his/her own module s within the project
• Attended to, researched and fixed issues that emerged from production environment

Confidential

Oracle Applications Functional Consultant

Implementation

Responsibilities:

• Coordination with offshore team to enable them to understand the process and to familiarize them with the issues that normally generate and the probable ways of resolving them
• Led the requirements gathering and finalizing the process flow for distribution modules
• R12 Implementation of Order Management, Purchasing and iProcurement Modules
• Set up suppliers, supplier sites, bank accounts and process documents
• Configured Payables system options, and financial options and defined Payment terms, Payment set ups, and distribution sets
• Involved in implementation of Oracle Financial Applications R12 GL, AP, EbTax, AR, FV, PO, EAM, FA and some service modules iProcurement, iExpenses
• Oracle Application Framework OAF applications, customization of OAF pages and extensions
• Responsible for the implementation of Receivables AR E-Business Tax
• Configured transaction types, sources, receipt classes, banks and bank accounts
• Set-up of invoices, debit and credit memos, guarantees, deposit transaction types
• Involved in analysis, design, and business process mappings for Integration project
• Defined Tax Regimes, Taxes, Tax Status, Tax Jurisdictions, Tax Rates, Party Tax Profiles, Tax Zones in E-Business Tax eB-Tax
• Log, view, access, monitor, follow up and close Service Requests SRs online through Oracle Metal ink and Oracle Applications Patch Management

Confidential

Senior Oracle Functional Analyst

Implementation and Support

Responsibilities:

• Providing solutions for doing different kind of transaction to capture financial transactions in AP and AR modules
• Worked on Oracle Metalink for troubleshooting of bugs/issues by raising TAR or by following existing documents
• Preparation of the Business Process definition document as the deliverable in the business study phase for the AR, OM and Cash Management Modules
• Review with business the business study deliverable, incorporation of business feedback and getting business sign-off for the same document
• Order to Cash cycle starting from order booking till order gets closed in oracle
• Worked on identifying and resolving the errors during pick release and ship confirm with the help of various tools like ENT Error Notifying Tool and EMON, these tools are used to trace and process the records stucked during the releasing/processing of the order because of validation fail
• Worked on processing the records and get the order released and closed in oracle
• Created advance pricing, modifiers qualifiers for overrides and discounts
• Created primary and secondary pricelists for each agreement
• Created customer order quantity, order type or various complex qualifiers
• Bank statement reconciliation in Cash Management
• Providing post-production support to the end users on standard Oracle Application modules along with the customized Oracle Apps
• Supported production and non-production instances and coordinated with DBA's and other tech team for on time solution
• Provided daily user support for financial modules and applied patches as and when required to resolve the application issues