PROFESSIONAL SUMMARY:

Around 8 years of experience in Oracle ERP Implementation, Upgrade, Enhancement, Testing and Support of Oracle Applications using 11i and R12

• Strong functional knowledge on Oracle Financials modules R12i/11i Versions
• Exposure to all phases of software development life cycle SDLC .
• Exposure to multinational implementations
• Expert in Oracle Applications R12/11i Implementations, Upgrades, Roll-Outs, Customizations, Migrations, Enhancements, Financial Analytics and Support.
• In-depth experience in Oracle Implementation Methodology AIM including solution design, requirements gathering, functional gap analysis, application configuration, module setup, prototype presentation, training guide preparation, testing, training, data migration, conversions, financial data analysis, reporting and production support.
• Excellent Business Analytical skill and Business Process Design capability.
• Expertise in integrating Oracle ERP with multiple Non Oracle ERP applications
• Extensive experience in planning, managing, and coordinating offshore custom development, integration and testing efforts.
• Expertise in accounting design in accordance with GAAP.
• Expertise in designing and customizing reporting dashboards and financial data analysis tools using OBIEE.
• Experience working with executive teams at various levels.
• Ability to learn new things quickly and to work under pressure.
• Excellent communication, interpersonal skills and presentation skills and ability to interact with people at all levels
• Good understanding of Data Conversion and Data Migration process including vast expertise in Global implementations and working with large group of business users and Onsite Offshore model projects
• Experienced in developing and implementing test strategy for functional testing environments Unit, Integration UAT includes providing functional impact analysis as part of Change Management Process
• Conduct Oracle Web Conference OWC with Oracle Technical Support for all high prioritized and time sensitive issues
• Expert in System Administration in defining users, menus, responsibilities, printer set-ups and maintaining concurrent programs. Defined Custom Applications, which includes new Menus, Request Groups and Responsibilities using Application Developer and System Administrator responsibilities

TECHNICAL SKILLS:

PROFESSIONAL EXPERIENCE:

Confidential

Oracle Functional Consultant

Confidential is a financial services company that provides direct access to a full suite of easy-to-use online investing and banking solutions. E TRADE empower individual investors to take control of their financial futures by providing a comprehensive, unbiased product offering confidence-building research, tools and education and the support and guidance they need to meet their near and long-term financial goals.

Responsibilities

• Analyze, design, and configure the Oracle applications and modules including GL, AP, AR, PO, iProcurement ,iExpense and OTL modules
• Participated and documented the requirement gathering sessions and analyzed the impact of the changes.
• Fully Involved in Conversions of old legacy system data in Oracle Open Purchase Orders, Requisition's, Receipts etc.
• Individually contributed for entire setups of AP, Image Processing Management IPM , ODC and OFR, in route approvals for requisition and Invoice Approval for AP Invoices.
• Worked with Third Party vendor and integrate the Invoice processing system with IPM through Oracle and Import the invoice automatically in Oracle
• Close worked with the Business and Catalog vendors to set up the Catalog and Punch-out for multiple vendors
• Developed AR Invoice interface and Customer interface from Sale force system to Oracle
• Fully Involved in Account Receivable on all set up end to end
• Design and Develop the Approval work flow for Requisition, Purchase order and Invoices using AME
• Conversion of data from the external systems to the Oracle EBS.
• Completely customize the iProcurement responsibility and provide Search functionalities for Invoice, Purchase orders and requisitions with drill down functionality to payments, Bank accounts
• Payables: Suppliers conversion, inbound and outbound interfaces, Data conversion of Invoices
• Customize the Contingent Requisition process and integrated with Oracle Time Labor to enter the time sheet and retrieve the invoices in AP
• Customize the account generator to generate the charge account based on employee records automatically
• Purchasing: Setup like Document Types, Line Types, Approval Groups and Assigned Approval Assignments to the Jobs, Purchasing Options, Receiving Options, Financial Options, Lookup Codes, Payment Terms, etc. and successfully created PO's, Receipts, etc.
• Implemented iSupplier portal Setup includes assign responsibilities to internal user, applying securing attributes to custom responsibilities, enable function security, enable Profile options and manage deliverables functionality
• Implement supplier management includes Flag External Responsibilities, Set Default Application Responsibilities, Set the Web Server URLs , Assign Supplier User Administrator Responsibility
• implemented Prospective vendor registration and profile management includes Plan and Creating supplier management groups, Create customized responsibilities to buyer and assign customized responsibilities to users , create contact directory for existing supplier , migrate account assignments for supplier bank accounts ,Assign Supplier Profile Manager Responsibility to Appropriate Supplier
• Defined the Functional specifications for set ups and reports and transformed the specifications to the Technical Team.
• Perform Root Cause Analysis RCA for various repetitive problems and provided suggestions for speedy problem resolution.
• Maintained the regular interaction with the Client, End users, Technical team, participated in the meetings on regular basis and followed up the progress of work.
• Working with different teams to resolve all issues for the assigned sites. Resarch the issues on Metalink and Open the TAR with Oracle for critical issues. Coordinate with Oracle Support on various TAR's on daily basis through Metalink.
• Tested the interfaces, reports, and processes to ensure that all the functionalities are working correctly.
• Worked with the users and businesspersons in designing and defining the new Reports and Customizing the existing Reports.
• Training to super users and users
• Coordinated Set up activities in UAT and Production Environment of all the modules
• Supported the Team as Subject Matter Specialist in Financial Modules and business Process

Environment: Oracle Applications Oracle Apps R12 12.1.2 S2S Source to Settle , Inventory, iExpense and iProcurement

Confidential

Functional Analyst

• Telamon sources and manages the logistics and movement of medical material from production to consumer. Confidential.
• They are specialized in solutions for telecommunication networks, business process outsourcing, energy efficiency, industrial assembly, and telehealth services. Telamon, the Greek word for support , is uniquely positioned as a minority-owned company. Continuously exceed customer expectations and standards and have been recognized globally through numerous awards and certifications.

Responsibilities:

• Involved in Implementation of Oracle Applications R12.1.3 in Accounts Payables AP , Internet Expense iExpense , General Ledger GL , and Accounts Receivables AR
• Analyze design, customize, configure and test implement detailed Oracle applications and modules including GL and AR Gather, manage and document functional requirements for technical customization including reports, forms, workflows and scripting
• Working on AS IS and TO BE Process reviews and working on RICE objects for the gaps.
• Interacting with the client team to understand the existing business practices and prepared the business requirement definition document.
• Worked on setting up the AMEX Credit Card interface, setting up expense codes, expense policies, customizing the expense report and implementing the Expense Report Bar code functionality.
• Interacting with OBIEE and other 3rd party teams to analyse the interface requirments.
• Gathering and documenting the client requirements, analyzing the system gaps and providing the custom solutions for the gaps.
• Performing system analysis, Conducting Design Workshops, Gap analysis, system setups and system integrations
• Worked on building an interface between Mainframe sales system and Oracle Receivables.
• Worked on processing the invoices from KOFAX system.
• Worked on Document Management system to process expense reports and images to manager reviews and approvals.
• Involved in designing an interface between Mainframe and Oracle for the billing interface.
• Involved in designing an EDI interface between Bank of America and Telamon for lockbox.
• Involved in designing Direct Debit process for customer payments.
• Configured new banks for Canada Organization.
• Involved in developing my MY BILLING for AR for Auto receipt process.
• Involved in generating interfaces to sync the AP suppliers and bank details in both 11i and R12
• Recommend solutions and document findings.
• Client and business interactions.
• Develop new utility application, workflow, interfaces and support tools using SQL and PL/SQL tools.
• System Testing and Regression Testing.
• Production and UAT support.
• Helped the business in the month end closing process.
• Helped the business to close the periods and open the new periods
• Preparation of user manual and user training materials.

Environment: Oracle Applications Oracle Apps R12 12.1.2 - GL, AP, AR, EBTAX and iExpense

Confidential

Oracle Functional Consultant

Confidential. is an integrated energy company engaged primarily in electric power production and retail distribution operations in the Confidentials. It is headquartered in the Confidential.

Responsibilities

• Analyze, design, and configure the Oracle applications and modules including GL, AP, AR, PO, iProcurement ,iExpense and OTL modules
• Participated and documented the requirement gathering sessions and analyzed the impact of the changes.
• Fully Involved in Conversions of old legacy system data in Oracle Open Purchase Orders, Requisition's, Receipts etc.
• Individually contributed for entire setups of AP, Image Processing Management IPM , ODC and OFR, in route approvals for requisition and Invoice AME for AP Invoices.
• Worked with Third Party vendor and integrate the Invoice processing system with IPM through Oracle and Import the invoice automatically in Oracle
• Close worked with the Business and Catalog vendors to set up the Catalog and Punch-out for multiple vendors
• Developed AR Invoice interface and Customer interface from Sale force system to Oracle
• Fully Involved in Account Receivable on all set up end to end
• Design and Develop the Approval work flow for Requisition, Purchase order and Invoices using AME
• Conversion of data from the external systems to the Oracle EBS.
• Completely customize the iProcurement responsibility and provide Search functionalities for Invoice, Purchase orders and requisitions with drill down functionality to payments, Bank accounts
• Payables: Suppliers conversion, inbound and outbound interfaces, Data conversion of Invoices
• Customize the Contingent Requisition process and integrated with Oracle Time Labor to enter the time sheet and retrieve the invoices in AP
• Customize the account generator to generate the charge account based on employee records automatically
• Purchasing: Setup like Document Types, Line Types, Approval Groups and Assigned Approval Assignments to the Jobs, Purchasing Options, Receiving Options, Financial Options, Lookup Codes, Payment Terms, etc. and successfully created PO's, Receipts, etc.
• Defined the Functional specifications for set ups and reports and transformed the specifications to the Technical Team.
• Perform Root Cause Analysis RCA for various repetitive problems and provided suggestions for speedy problem resolution.
• Maintained the regular interaction with the Client, End users, Technical team, participated in the meetings on regular basis and followed up the progress of work.
• Working with different teams to resolve all issues for the assigned sites. Resarch the issues on Metalink and Open the TAR with Oracle for critical issues. Coordinate with Oracle Support on various TAR's on daily basis through Metalink.
• Tested the interfaces, reports, and processes to ensure that all the functionalities are working correctly.
• Worked with the users and businesspersons in designing and defining the new Reports and Customizing the existing Reports.
• Training to super users and users
• Coordinated Set up activities in UAT and Production Environment of all the modules
• Supported the Team as Subject Matter Specialist in Financial Modules and business Process

Environment: Oracle Applications Oracle Apps R12 12.1.2 P2P Procure to Pay , Inventory, iExpense, iProcurement and Oracle IPM

Southern Company Services, Atlanta, GA Sep 10 to Jun 11

Oracle Functional Consultant

Responsibilities

• Analyze design, customize, configure and test implement detailed Oracle applications and modules including AR, AP, GL, iExpense, CE, PO, etc. Gather, manage and document functional requirements for technical customization including reports, forms, workflows and scripting
• Perform system analysis, requirement studies, specifications generation, system setups and system integrations Develop creative solutions to support business needs, and help determine opportunities for exercising additional application capabilities
• Assist with functional configurations, implementations, and production support activities Perform system configuration required to satisfy requests from end-users for fixes, changes, and enhancements to financial/accounting management functionality.
• KBD57 Task - Setup AR, AP for 4 agencies SWE, TPO, SGB, and SGF to keep them separate as per Govt. regulation also involved in conversion of Customers and Suppliers for the agencies using Data loader.
• iExpense Setups: Expense Report Templates, Expense Types, Payment Terms, Pay Group, Payment priority
• Validate DFF Setups for iExpense in AP, GL reports and AP reports in prod and other instances
• Involved in creating Responsibilities with appropriate menus and functions for specific job roles in GL, AP, AR
• Involved in Regression testing for AR, AP, GL, Pay Terms in AP
• Working on production support issues 24x7 for iExpenses, AP, AR, GL and PO.
• Designed and prepared MD50 for customization of interface to load Journals for Reconciliation.
• Define, analyze, document business and systems user requirements Configure dimension rules, datasets, balance rules, data sources, loading metadata Perform data extracts to and from Oracle modules such as GL, FA, AP and AR Write detailed descriptions of project needs, program functions, and steps required to develop or modify computer programs
• Design of Accounting Flex Field Structure: Helped in arriving to an appropriate Chart of Accounts structure, which was simple to grasp and yet captured all reporting requirements.
• Security and Cross Validation Rules: Created security and cross validation rules for restricting the use of account code combinations by company and department
• Review computer system capabilities, workflow, and scheduling limitations to determine if requested program or program change is possible within existing systems Study existing systems to evaluate effectiveness and develop new systems to improve efficiency and workflow.
• Working with different teams to resolve all issues for the assigned sites. Resarch the issues on Metalink and Open the TAR with Oracle for critical issues. Coordinate with Oracle Support on various TAR's on daily basis through Metalink.

Environment: Oracle Financial Applications 11i 11.5.10 P2P Procure to Pay , O2C Order to Cash , and iExpense

Confidential

Oracle Apps Functional Consultant

Responsibilities

• Study of the current Business Process and GAP Analysis using AIM documents,
• Preparation of BR100, Common Set-ups doc, Sys Admin Set-ups documents.
• Troubleshoot issues, including creation/follow-up of Oracle service requests SRs . Conduct quality reviews of code developed by other development staff.
• Gathered application requirements and provided design recommendations.
• Assist in functional design with respect to custom data models that integrated with Oracle Applications.
• Involved in Sarbanes-Oxley SOX compliance testing process by including paper-based evidence, e.g., invoices, delivery receipts, purchase orders, bank statements and expense receipts
• Defined period types, calendars, Distribution sets, Tolerances, bank accounts payables documents, payment terms, approval groups and approval assignments.
• Participated in customization and personalization of iExpense pages.
• Configure complete GL including Org Structure, Rollup groups, parent child accounts, CVR's Value sets.
• Defined Ledgers and Ledger sets, Journal sources and categories.
• Defined Legal Entities and Operating Units for AP configuration. Configured Financial, Payable and Payable System options.
• Created Payment terms and Payment Process Profiles.
• Participated in setting up of tax users and profile option values in EB Tax.
• Configured GL Tax options and Ledger options for E-Business Tax functionality.
• Involved in setting up of Tax Configurator in EB Tax. Defined Tax defaults and Tax rules.
• System Administrator skills - user creation, defining responsibilities, profile options and securities.
• Defined roll up groups to provide the customize reports to the top management with drill down features.
• Involved in regression testing and UAT.
• Configured the setups for prepayments and adjustment to payment to suppliers
• Coordinated and monitored Month End Closing process.
• Generated various reports in GL, AP and SLA. Changed the submission instructions on the iExpenses page
• Established control over data access with creation of Menus and Responsibilities and by setting up flex field security rules.
• Involved in the production support of AP and CE modules and support Month End close process as well

Environment: Oracle Applications 11i GL, AR, AP,iExpense, AOL, Forms 6i and Reports 6i, PL/SQL, SQL Loader, SQL Plus, TOAD, UNIX, Shell scripts.