SUMMARY

• Having 8 years of Experience in implementation, development, customization, testing and production support in all financial domains mainly in accounts receivables, accounts payables, general ledger, fixed assets, advance pricing and advance collections, TCA.
• Actively involved in various stages of application development and solution definition including business requirements gathering, gap analysis, process mapping, solution design configuration and development, quality assurance systems, integration, implementation, end user training and post production support activities.
• Configured Virtual Trader to capture and process sub ledger journals (AP, PO, FA, CE, XTR and Web ADI), generate cross - book accounting, add custom journal line descriptions (PO Numbers on Invoice lines, deal numbers, deal and product types on Treasury lines) before importing and posting in GL
• Having experience in CEMLI
• Extensive experience in Implementation, Migration, Customization, Production and Support of Oracle (R12 & 11i) applications/EBS with major focus on Financial modules (GL, AP, AR, FA, CM), SCM Modules (PO, OM, Advanced Pricing, INV, Shipping, WIP, BOM), HRMS, Oracle CRM (Service Contracts and Install Base), P2P, O2C life cycles
• Assisted business in identifying entities across the global for adding to the scope of Oracle Cash Management based on banking activity and material impact.
• Conducted knowledge sharing sessions in financial modules AR, GL, AP, FA and CM.
• Excellent understanding of project development lifecycle and testing.
• Adept at development and customization of Reports, Interfaces, Conversions and Extensions (RICE components) in the domain of Oracle Applications E-Business Suite (Oracle EBS) using SQL, PL/SQL, UNIX Shell scripts and SQL*Loader in the domain of Oracle Applications.
• Extensively worked on System Administration responsibilities such as registration of concurrent programs, creation of Users, Responsibilities, Forms, Functions, Menus, Value sets and Flex fields in Oracle Applications.
• Solid Knowledge and understanding of AOL/FND architecture and Application
• Experience in Implementing Trading Community Architecture (TCA) to support complex trading communities.
• Expertise in Design and Development of interfaces and conversion programs to integrate Oracle Applications modules to import data from various sources into Oracle Applications using Oracle open interfaces and Oracle Public API’s.
• Extensive experience in developing and customizing numerous Forms using Oracle Forms 10g/6i/4.5, Reports using Reports 10g/9i/6i implementing bind and lexical parameters and also generated various XML/BI Publisher reports, which included working on report development objects like data templates and RTF’s.
• Experienced in Unit Testing and SIT, UAT and design issues resolutions.
• Expertise in writing PL/SQL Packages, PL/SQL Procedures, Functions, Triggers, Packages and Advanced PL/SQL (PL/SQL tables, Record type, Bulk Collects, Bulk Binds) and SQL * Loader scripts.
• Designed, developed and customized Workflow process for providing responsibilities and notifications during the changes in life events.
• 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 requirement
• Expertise in data conversion and interface development.
• Worked closely with users during requirements gathering, solution designing, solution build, testing and production support
• Programming experience in Oracle 10g/9i/8i, SQL, PL/SQL and XML.
• Ability to handle multiple tasks and work independently as well as in a team.
• Highly motivated, hard working, able to meet tight deadlines in project completion and possess excellent communication and analytical skills

TECHNICAL SKILLS

Modules: Account Receivables, Account Payables, General Ledger, Fixed Assets, Cash Management, Inventory, Purchasing, Order Management, iExpenses, iProcurementsApplication Developer and System Administrator,isupplier,BOM,WIP

ERP Versions: Oracle Applications R12 and 11i (11.5.10.2/11.5.9/11.5.6 )

Methodology: Oracle E-Business Suite Application Implementation Methodology (AIM)

Programing Languages: SQL, PL/SQL, Report &Form Builder, Discoverer, Unix shell Scripting

Interface Tools: Data Loader, SQL loader

Database: Oracle8i/9i/10g, 11g

Operating Systems: Windows 95/98/2000/2003/ XP/windows7,LINUX, UNIX, Solaris

PROFESSIONAL EXPERIENCE

Oracle Financial Functional Consultant

Confidential, Cleveland

Responsibilities:

• me is a key member in various Oracle Implementation/Support projects and has worked with professionals. My Strengths includes:
• Supported day-to-day and month-end issues related to misclassification of GL Accounts, WEB ADI, Mass Allocations, Standard/Custom reports, Eliminations, Translations, Revaluations, Consolidations, Posting, XTR/CE Journal issues, AP Invoice Holds and Matching issues, VT processing issues, issues with AP Invoice and Payments, FSAH file processing and ADR rule issues
• me is also responsible for Analysis and Design of applications on above mentioned modules, designing MD50, MD70 &DS30 Document, coding standards, reviewing and validation. me is experienced to plan and execute the following phases of software life cycle starting with User Requirement Study, Design Business Model, Implementation, Deployment, Training, Communication and Co-ordination.
• Ability to understand the requirement clearly and the capability to articulate it has given me the privilege of becoming a key member of the team.
• Responsible for maintaining the daily business operations within the Oracle ERP system of Activision Blizzard with respect to Oracle Apps 11i Finance modules (GL, FA, AP, AR, CE, XTR).
• Extensively worked on Interfaces and conversions such as:
• Creating Contracts and Billing of contracts.
• Preparing Unit test plans and execution.
• Involved in Peer review of code, Technical design and UTP scripts.
• Designing the Technical design template and coding standards.
• Highly involved in interface unit testing.
• Analyzing, requirement collection, building FD's and developing new work Request.
• Business Requirement from client, building FD and finalizing solutions.
• Preparing Requirement Analysis Document (RAD).
• Performed functional testing for existing modules to understand existing business process, created documents to understand functional requirements for interfaces.
• Impact analysis on other functionalities and objects.
• Worked on Forms.
• Creation of value sets, Concurrent Programming Registration and knowledge in AOL functionality.
• Worked with functional experts to define requirements for interfaces.
• Performed GAP analysis and prepared solution presentation.
• Participated in the Unit and Integration Testing along with the end-users.
• Provide support to the Testing team and to create Test cases.
• Involved in Oracle System Administration activities such as registering the New Users and assigning responsibilities in Oracle Apps.
• Expert in handling ADF technology
• Enabling Key Flex Field and Descriptive Flex Field.
• Knowledge Transfer to the support team.

Environment: PL/SQL, SQL, Oracle Financials Applications R12/11i, AR, AP, GL, FA, OM, INV, SQL, Net, Oracle Workflow

EBS Functional consultant

Confidential, Seattle, WA

Responsibilities:

• Development and customization of Interface, Conversion, Reports, Forms, Application Forms Personalization and Functional Knowledge of Oracle CRM Modules on Oracle E-Business Suite 11i.
• Worked with R12 implementation team in AP, AR, GL modules in Multi-Org environment Gathering the client requirements and preparing the documents using AIM methodology
• Analysis of the current system by interacting with business and cross-functional team
• Responsible for developing designs for key business requirements and integrating partner solutions within the current Oracle framework.
• Responsible for implementing future versions of the Oracle ERP suite and enhancements of current Oracle architecture through small and large scale projects while streamlining processes and operations to increase productivity, quality, efficiency and user experience domestically and globally.
• Worked on designing interfaces in coordination with the Business and the technical teams, writing functional specifications (MD50), testing, performing configurations as part of the Oracle Quarterly Release projects/enhancements
• Expert in Customization, Extension, Modification, Localization, and Integration.
• 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
• 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
• Reviewed and approved any configuration change documentation for General Ledger, Cash Management, Accounting Receivables and Accounting Payables
• Liaison between the technical staff and the users (staff and management). Was also responsible for inter-departmental co ordination between the various teams involved
• Developed Customer Interface in Receivables worked with various HZ tables, Interfaced data from the Flat Files into Interface tables of Oracle Receivables using SQL*Loader, Validated and imported the data into AR base tables using Oracle standard Customer Import Program.
• Involved in AR Invoice Interface to load Invoices Periodically.
• Developed Auto lockbox Receipt Interface program to automate the receipt processing. Loaded the data into AR PAYMENTS INTERFACE ALL. Validated and imported the data into AR base tables.
• Worked on Oracle Application Framework (OAF) BC4J Components to develop custom solutions forHRMSmodule performing AM, VO, Controller extensions.
• Developed interfaces to load the GL Data from legacy system into GL JE BATCHES, GL JE HEADERS and GL JE LINES base tables using journal import concurrent program.
• Developed GL interface for importing journals from legacy systems into GL INTERFACE table.
• Defined customer profiles, customers, payment terms, payment methods and tax structures, including tax exemptions and exceptions in Accounts Receivables (AR).
• Developed AP Check Printing Report to produce check file in the Oracle Accounts Payables to complete the correct formatting for checks processed from Oracle payables through check printing software using Reports6i and XML/BI Publisher.
• Provided daily user support for financial 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

Environment: Oracle Applications 12.1.3(GL, AP, AR, FA, CM, PA, Purchasing, iSupplier, iExpenses, EB ax), Oracle 10g, (SQL, PL/SQL), TOAD.

Oracle Functional Consultant

Confidential, CA

Responsibilities:

• Implemented full upgrade of FA from multiple legacy systems to oracle R12.1.3 and Production support for previous implementation
• Configured Oracle AR, AP, GL modules from scratch and simultaneously created BR100 documentation for the setups.
• Implemented Auto Lock box Functionality in AR
• Participated in module configurations for GL, AP, PO in various projects (Oracle implementations in acquired business units)
• Supported all Oracle Applications patching, upgrades and maintenance activities by testing and troubleshooting functional issues
• Led functional acceptance testing of enhancements, patches and upgrades
• Performed system troubleshooting in a production support environment for the Oracle Financials application modules such as GL, AP and FA
• Assisted users in solving both functional and system issues within agreed-to service level agreements (SLAs)
• Provided end-user instruction, training and support to resolve application issues
• Managed Oracle Service Requests (SR's) to resolution TEMPeffectively
• Partnered with business to gather requirements, designed new process end-to-end flows for the track and implemented the system in all the regions of the company
• Gatheird all the required operations performed on the assets and prepared test cases.
• Performed the customizations for sub ledger accounting like creating new custom rules and assigning custom functionality to retrieve the code combinations of accounts different from standard functionality
• Developed sales Order inbound interface which picks the order message information, transforms to record structure validates the data and used process order APIs to create order header and line information and do the pick confirmation through API.
• Created newLOV search fieldsin theRequisition SearchPage. Modified the existing search criteriaExpSearchCOto in corporate the search with newly added LOV search fields.
• Developed and customized reports like Min-Max Planning report, Inactive Item Report, Cancelled Sales Order Report and cancelled purchase orders using Oracle Reports 6i.
• Developed reports like Pick Slip, packing Slip, Mailing Label for shipping and Credit Order Detail, Orders by Item, Order Detail & Summary Reports for Order Management and also created new reports as per client requests using Reports 6i.
• Imported ITEMS from legacy system to Inventory base table MTL SYSTEM ITEMS B using the standard item import program through a custom package dat validates individual records.
• Created loader file, porting invoices into the AP INVOICES INTERFACE and AP INVOICE LINES INTERFACE tables using SQL*Loader and tan using Payables Open Interface to import the data into the actual tables.
• Worked on Auto Invoice Conversion Program to validate, load credit memos, debit memos and invoices from legacy system.
• Development of stored procedure dat extracts data from AR, AP and PO modules or reconciliation according to business requirement.
• Activities also involved migration of deliverables such as PL/SQL packages, LDTs, shell scripts, rdfs, and rtf templates to various environments.
• Worked with FND PROGRAM package to Register, Delete the Concurrent Programs and Used FND SUBMIT Pub to Submit Requests, Request Sets from the backend
• Whenever the SLA changes are made performed regression testing for all the events and make sure all the custom functionality is working as expected.
• Performed setups of chart of accounts mapping for corporate and stat books.
• Trained the users on month end activities, reconciliation and functionality of custom SLA
• Gatheird the requirements from business users and prepared the MD50 for many custom reports.
• Opening and closing the periods in GL, posting journals, reconciling the balances posted from fixed assets to GL and setup accounting code combinations.
• Creating and Posting manual journal entries if their are any adjustments needed.
• Prepared projects and interfaced to assets as part of testing End to End test cases

Environment: Oracle applications R12 (Technology: GL, AP, AR, Cash Management, Fixed Assets, Advance Collections, Advance Pricing, Sub Ledger Accounting, e-Business Tax,OM, INV and PO), Oracle database 9.x, 10.g, SQL, PL/SQL, TOAD

Oracle Functional Consultant

Confidential, Irvine, CA

Responsibilities:

• Updated Organization Parameters, Receiving Accounts, Expense AP Accrual Accounts, P&L Accounts, Clearing Accounts, Cost Group Valuation Account
• Updated Purchasing (PO), Receiving (AR), and Payables(P2P) options
• Involved in setups of AP and FA, multi reporting currency
• Changed Auto Accounting rules to accommodate the new organizational structure
• Set-up Banks, Receipts, Transactions, Plus training for invoicing, Receipts, Adjustments, and Period closing.
• Participated in test reviews and defect report meetings periodically
• Setup the Approval Hierarchies in oracle Purchasing module.
• Involved in troubleshooting issues on Auto Invoice Import Program.
• Registered concurrent programs for various data fixes in an user friendly way like PO encumbrance data fix, Release encumbrance data fix and others given by oracle.
• Developed PL/SQL procedures for fixing reduced quantity encumbrance data fix, PO shipment data fix and others
• Worked on Order import using Order Management OE ORDER PUB API to import data into Oracle. Developed PL/SQL Packages for Validations of data. And populated the data into base tables.
• Developed Auto lockbox Receipt Interface program to automate the receipt processing. Loaded the data into AR PAYMENTS INTERFACE ALL. Validated and imported the data into AR base tables.
• Designed and developed Payables Interface Import Program to load invoices from the legacy system into the Oracle Payables Base Tables.
• Imported Journal Entry Transactions into GL INTERFACE table using SQL*Loader and successfully created the Journal Entry's in GL using Journal import.
• Developed various Custom reports, Customized existing reports (PO Purchase Order and Releases Detail Report) according to the functional specifications using Reports 6i/XML publisher.
• Developed GL Consolidation Process, Configured Consolidation Rules and Implemented GL Consolidation
• Worked on Requirements Gathering, Analysis, Design, Solution Design and prepared TestCases and Deliverables
• Worked with a team in implementing oracle financial modules for us and international operations.
• Train users in fundamental and functional changes from 11.0.3 to R12
• Worked with functional department to design and implement new business process.
• Involved in support for Procure-to-Pay life cycle (P2P)
• Configured AP, FA, PO module
• Setting up of financial options, payable options, invoice, supplier, supplier sites.
• Involved in full cycle accounts payable including review of travel and expense reports
• Defined currency conversion, revaluation and set the profile options for GL
• Involved in maintaining of cash and bank records such as bank deposits and reconciliation
• Define fiscal years, calendar, flex fields, registering the locations of assets, defining asset books in FA module
• Configured mass additions and mass transactions in Assets Module
• Performed depreciation for the assets
• Performed system option settings for receivables

Environment: Oracle Applications 12.1.3(GL, AP, AR, FA, CM, PA, Purchasing, iSupplier, iExpenses, EB Tax), Oracle10g, (SQL, PL/SQL), TOAD.

Confidential, Salt Lake City, UT

Responsibilities:

• Implemented new Auto accounting rules for Receivables to help drive the right accounting
• Conducted study on the existing business practices, gatheird requirement specifications and performed Gap Analysis for implementing GL, AR.
• Involved in AP AR Netting control Account/ Bank accounts/ configure AP AR netting Receipt Class/ Netting agreement.
• Defined Sub ledger accounting (SLA) rules to handle third party transactions in Receivables (O2C)
• Supported procure to Pay issues with month end and additional configurations.
• Defined the prorate convention, prorate calendar, depreciation rate and calendar, fiscal calendar and system controls
• Grouped assets associated with a specific project, department, and location to track CIP assets in the organization
• Designed and created test scripts and user-manuals for the modules.
• Resolved any month end related issues involving and data fixes /configuration changes
• Configured AGIS for mainstream to handle intercompany transactions along with defining intra company rules
• Configured AGIS for mainstream to handle their intercompany transactions along with defining Intercompany rules
• Implemented Dunning letters in Receivables for customers to send on a monthly basis based on the aging of the invoices
• Worked on all the setups for the Revenue Recognition, FAH and AR (O2C) modules
• Provided solution for cleaning up Security access with the appropriate responsibilities as per the employee position
• Correct any auto invoice errors while importing the invoices and while working with Oracle wherever necessary
• Resolved month end issues with Projects and helped import successfully any accounts or invoices related
• Provided post production support for all financial modules with month end closing related as well as regular issues.

Environment: Oracle Apps 12.1 (GL, AP, AR, PO, SLA, INV, iProcurement, iExpenses, FA)

Confidential, Reno, NV

Responsibilities:

• Responsible for gathering user requirements, data conversions, customizations and testing.
• Gatheird business requirements prior to project design and implementation from users
• Conducted root cause analysis of issues and worked with lead and development to provide fixes
• Documented requirements using BR100, RD-50 and MD-50 respectively
• Accurately created test cases and conduct unit, integration and user acceptance testing
• Developed Auto Invoice Interfaces in the AR.
• Efficiently used Quality Center for bug reporting and defect tracking
• TEMPEffectively designed and deployed business reports using Oracle Discoverer and XML publisher
• Conducted user acceptance, unit, integration, usability, and regression testing of the Oracle ERP.
• Ensured identification of software issues accurately wrote easy-to-follow bug reports and logged them into bug tracking database; monitored the development and verified fixes on SRs.
• Recommended and applied industry best practices to meet business requirements.
• Carried out primary integration testing between various modules.
• Deliverables included needs analysis, functional mapping, gap analysis, BPR, finding solutions,
• Involved in business analyst activities, partnered with business to gather requirements, design new process, end-to-end flows.
• As a Business Analyst Designed detailed Process Flow, establish Security And Control Requirements.
• Worked on the Item Conversion in the INV Module.
• Developed a Custom Report from the Scheduled data in the Custom tables in WIP Module.
• Developed a Custom form for the Line flow Schedule data in WIP Module.
• Developed Custom Journal Import Program in GL Module.
• Coordinated Users Acceptance Testing (UAT), go-live activities & implementation support.
• Defined Value Sets, Descriptive Flex fields, and Custom Profile Options for modules.

Environment: Oracle Application 11.5.9, GL, AP, AR, PO and Inventory, Oracle Applications Implementation 11i