SUMMARY:

• Over 9+ years of strong functional experience in the Software industry that includes experience in designing, developing, implementing, and supporting Oracle Financial and Distributions modules, custom solutions and Federal Financials
• Subject matter expert in General Ledger (GL), Accounts Receivables (AR), Accounts Payable (AP), Purchasing, Order Management (OM), Advanced Collections, E Business Tax and Cash Management (CM). iExpenses, iProcurement, iReceivables, Service contracts,Project Costing and Billing, R12 Federal Financials, Sub ledger Accounting, E - Biz Tax and AGIS.
• Successfully implemented full life cycle projects, hands on process and design implementation and production support experience in Order-to-Cash (O2C) Process, and Procure-to-Pay (P2P) Process .
• Recommended process improvements through best practices and collaborative Conference Room Pilots to successfully implement and support the Oracle R12 and R11i E-business Suite
• Experience in preparing test scripts for using in UNIT, Regression testing, CRP and UAT for testing and developing documentation and HP Quality Center.
• Experience in Application Object Library, OA Framework, Concurrent Manager, Flex-fields Management, and Trading Community Architecture to get a deep insight of product.
• Experience in Customizations, Personalization of Forms and Reports in oracle e-business suite applications.
• Supported end users in the organization in their use of software programs and processes to more efficiently and effectively fulfill business objectives.
• Supported the design, delivery, and improvement of in-house applications/process programs and related courseware.
• Planed, designed, developed, and launched efficient business, financial, and operations systems and processes in support of core organizational functions and business processes.
• Analyzed, specified, and validated the business needs of project stakeholders. This includes interviewing stakeholders and gathering and compiling user requirements to conveying them to development teams throughout the application lifecycle.
• Designed and implemented software and systems, including integration with databases and data warehouses. This includes selecting, blueprinting, gathering requirements, designing, and rolling out solutions to end users.
• Ensured high levels of systems availability through support functions and in-depth testing.
• Developed and assisted execution of test cases and expected outcomes for unit tests, string tests, system tests and user acceptance tests.
• Ensured high level of data quality across the enterprise through the creation and management of sound data management processes.
• Standardized data naming, establishing consistent data definitions, and monitor overall data quality.
• Coordinated the development and implementation of a data quality assurance program for the EBS procurement functionality. The program will focus on defining problems with data, analyzing/identifying causes and improvements, and developing action plans for resolution.
• Research, gather and analyze data in support of business functions, proposed projects, and process knowledge and systems requirements

TECHNICAL SKILLS:

ERP: Oracle Applications 11i (11.5.10/11.5.9/11.5.6 ), 11.0.3 and R12

Modules: Inventory, Purchasing, Order Management, Fixed Assets, Cash Management, Account Receivables, Account Payables, General Ledger, AGIS,Grants and Loans,Federal financials

Self Service Apps I: procurement, iReceivables, iAssets and iExpenses.

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

Operating Systems: WINDOWS XP/2000/NT/9x, UNIX, Windows 2003 server.

Interface Tools: Forms 6i/4.5, Reports 6i/4, Data Loader, MS Office,Autosys.

PROFESSIONAL EXPERIENCE:

Confidential, Maryland

Responsibilities:

• Worked on the HCRs (HIGLAS Change Request) involving several SDLC tasks including requirements gathering, review meetings, business rules and scenarios, functional design, development, configuration, testing and
• Developed and executed test cases/test scripts for HIGLAS R12HCR and Perform the testing
• Prepared BR 100 documents regarding setup changes and performing the configuration changes in test instances.
• Assessed all test plans/scripts to verify functionality within aggressive timeline.
• Performed Pre-Integration and Alpha testing for the R12 .
• Performed APA business process testing (Includes Grants, Procure to pay testing (P2P),sub ledger)
• Perform Testing (Treasury Report on Receivables) reconciliation and resolved reconciliation issues/variances

Confidential, CA

Responsibilities:

• Lead Functional Consultant for O2C,AP, AR and GL.
• Business study and Prepared Process Analysis Questionnaire.
• Led the blue printing sessions and documented the processes; identified gaps from the Global design where applicable.
• Prepared the RD50, BR100, MD50and performed the set ups.
• Actively designing solutions with emphasis on implementing Global design as much as possible
• Designed and created new CHART OF ACCOUNTS and set of books.
• Performed GL,AP AR set ups in Czech Republic, Slovak Republic & French Polynesia .
• Worked on the enhancement and customizations and production support issues related O2C, AR,AP,GL 11i and R12.
• Provided production support for day to day business issues on 11i and R12 and worked on SRs with Oracle.
• Involved in the tokenization testing.
• Worked on O2C CYCLE PROCESS.
• Provided daily user support for Financial modules and applied patches as and when required to resolve the Application issues.
• Worked on Iexpenses and I procurement production support issues.
• Log, view, access, monitor, follow up and close Service Requests (SRs) online through Oracle Metal ink and Oracle Applications Patch Management.
• Resolved all the functional and technical issues for AR, AP, GL, PO,OM and I-expenses Modules.
• Preparation and modification of documents like MD050, BR100 as part of project Deliverables for the change requests for functional and technical configuration changes.
• Post production support and maintenance of the Application and resolved user queries.
• Involved in the month end closure and reconciliation activities to close the periods on respective financial modules.
• Provided production support for day to day business issues and worked on SRs with Oracle.
• Provided daily user support for financial modules and applied patches as and when required to resolve the Application issues.
• Log, view, access, monitor, follow up and close Service Requests (SRs) online through Oracle Metal ink and Oracle Applications Patch Management.

Confidential, KS

Responsibilities:

• As a functional consultant, responsible for studying the business process. Prepared AS-IS understanding document for AP,GL, FA, AR and CM
• Assisted in business process reengineering, created TO-BE process document.
• Captured high level additional requirements Future Business Model (BP 080) for GL, AP and AR FA modules, and done the Impact analysis in current business process due upgrade changes/enhancements.
• Conducted requirements gathering workshops for AR. Analyze and Design the model for Receivables and collections for inter-company transactions as first wave of the Project.
• Interviewed subject matter expertise to understand the requirements and finalize functional setups for AP implementation.
• Mapping the Client requirements with Oracle standard functionality and finding the gaps and then prepared the setup Documents (BR 100) and delivered the solutions in terms of Customizations, workarounds, reengineering and form personalization.
• Writing / executing scripts using SQL Navigator to perform various extracts from database.
• Responsible for configuring GL, AP,AR, FA and CM modules.
• Resolving Interface issues with external systems and oracle modules
• Trained users with the R12 new features relating to AP,PO(Iproc),AR modules
• Defined DFF’s on Invoice and Asset Category in AP and FA to facilitate the additional Requirement.
• Personalized the Sub ledger Accounting to suit accounting requirements of client for Purchasing Period End Accrual Accounting Process.
• Preparing TE040 Documents for GL, AP, FA which are helpful to test the application functions in R12. Testing of various test scenarios of Requisition to Purchase Order cycle in Oracle Purchasing and from Projects and grants.
• Personalized the Payment Batch Process suitable to the user Requirements.
• Created new Web ADI Templates to load Journal Entries and Assets.
• Full CRP1, CRP2, UAT testing cycles, with issue trackers, HP Quality Center and SME’s sign of.
• Provided, Conducted Practice & Additional Business Requirements sessions.
• Design test scripts of all sub-process identified in assessment phase. Unit testing execution for each business process.
• Involved in Support production environments of P2P
• Analyze and test integration with 3rd Parties and legacy systems.
• Supported production environments and users on a daily basis by responding to emergency requests

Confidential, Hightstown, NJ

Oracle EBS R12 Business System Analyst-Enhancement and Production Support

Responsibilities:

• Review Configuration Requests and analyze impacts to business processing.
• Configure GL/AGIS development and production environments
• Collaborate with Business, Development and QA teams as required.
• Review Solution Changes Requests - document, analyze for impacts.
• Testing Solution Changes and review results with Business
• Day-to-day operational support as required including Close
• Configured both intra and inter company transactions
• Created new Web ADI Templates to load Entries.
• Configure the E-business tax setups for AGIS
• Full CRP1, CRP2, SIT and UAT testing cycles, with issue trackers (HP Quality Center) for enhancements.
• Provided, Conducted Practice & Additional Business Requirements sessions.
• Testing solution functionalities as a result of Configuration updates and review results with business.
• Involved in Support production environments of P2P
• Design test scripts of all sub-process identified in assessment phase. Unit testing execution for each business process.
• Preparing TE040 Documents for GL, AGIS and E-Business Tax which are helpful to test the application functions in R12.
• Involved in designing the functional specifications
• Writing / executing scripts using SQL Navigator to perform various extracts from database.
• Resolving Interface issues with external systems and oracle modules
• Preparing GL setup documents for assigned sites and do setups in the instance using Data loader & Oracle Web ADI tools
• Configured Multi-Org, MRC, and Intra-Company and Inter-Company setups for USA, Mexico, Asia- Pacific and Latin America.
• Supported production environments and users on a daily basis by responding to emergency Requests
• Configured the setup for AGIS organizations, customer supplier relationships
• Trained Users in creating non-invoicing AGIS transactions, a taxable intra-country AGIS transaction, AGIS transaction where tax is not expected an AGIS transaction where tax withholding is expected on the AP invoice, Create and run the netting batch.

Environment: Oracle Application (R12), GL, AGIS,AP, AR, CM, PO, OM, iProcurement, iExpenses, PA, Applications Developer,SLA,E-Business-Tax,Service Contracts

Confidential, Foster City, CA

Lead Financial Functional Consultant

Responsibilities:

• Involved in Support production environments of P2P and R2R
• Supported production environments users on a daily basis by responding to emergency requests
• Developed test plans and scripts and conducted testing for quality assurance.
• Performed set up for GL, AP, AR,CM,EBTax,I-procurement, advance collections modules for R12.
• Performed requirements gathering, gap mapping. Responsible for initial setups using Accounting Setup Manager.
• Mapping the Client requirements with Oracle standard functionality and finding the gaps and then prepared the setup Documents (BR 100) and delivered the solutions in terms of Customizations, workarounds, reengineering and form personalization.
• Work with the developers to develop conversions, interfaces, reports (MD50’s).
• Corrected wrong currency problem in AR Invoice, Debit Memo & Credit Memo.
• Perform the month end scheduled jobs and created new approvals.
• Performed month end close activities for AP and AR
• Defined Payment Options, Payment terms, Distribution Set, Payment format, Internal Banks in AP.
• Corrected customer Profile class setup & statement to avoid multilingual statement printing. Wherever required.
• Created New Credit Card When Making Payment Through Advanced Collections
• Fixed the advance collection payment processing screen not defaulting credit card info
• Corrected the advance collections Dunning letters do not print as of date
• Corrected the revaluation of cash/clearing accounts on PL and SL.
• Configured the setups for prepayment to employees and defined employee expense report.
• Created new Web ADI Templates to load Journal Entries and Assets.
• Created new AGIS relationships.

Environment: Oracle Application (R12.1.1), GL, AP, AR, CM, PO, INV, Advance collections, credit management, OM,Planning, iProcurement, iExpenses, PA, Reports Manager, Alerts, Applications Developer,SLA,E-Business-Tax

Confidential

Business Analyst

Responsibilities:

• Involved in testing of Oracle FinancialR12 GL, AP,AR and CM modules
• Involved in requirement gathering and analysis and design of the application.
• Developed test plans and scripts and conducted testing for quality assurance.
• Performed requirements gathering, gap mapping. Responsible for initial setups using Accounting Setup Manager.
• Determine business requirements for integration, including review of Chart of accounts to ensure adequate coverage for financial and statutory reporting.
• Configured DFF’s for PO Distribution, Invoice Distribution to enter AR Number (EGS recognizes Assets based on AR number) and bring it over to Asset Key Flexfiled using a Custom Concurrent Program.
• Work with the developers to develop conversions, interfaces, reports (MD50’s).
• Wrote functional specification for reporting requirements in AP
• Created custom responsibilities to which were attached specific menus, forms and reports for restricted user access.
• Created responsibilities assigned to users and set profile option.
• Created new Web ADI Templates to load Journal Entries and Assets.
• Full CRP1, CRP2, UAT1 and UAT2 testing cycles, with issue trackers(HP Quality Center) and SME’s sign of.
• Supported production environments and users on a daily basis by responding to emergency requests
• Provided, Conducted Practice & Additional Business Requirements sessions.
• Design test scripts of all sub-process identified in assessment phase. Unit testing execution for each business process.