We provide IT Staff Augmentation Services!

Sr. Oracle Techno Functional Consultant Resume

Plano, TexaS

EXPERTISE SUMMARY:

  • A result driven professional with around 9 years of experience in IT, as an Oracle Apps Financial Functional which includes Implementation, upgrades, Testing and Production support on Oracle Applications 11i, R12 versions.
  • Strong experience in developing Test Plans and Test cases using requirements and design documents.
  • Implementation and Support of various financial modules including and not limited to General Ledger, Payables, Receivables, Purchasing, Cash Management, Fixed Assets, E - Business Tax, Inventory, etc.,
  • Multiple project lifecycles experience with Initiating, Planning, Executing, Supporting and Monitoring. Business Analysis, Requirements Gathering including facilitate Workshops, Scope Verification & Validation, Alternatives Identification and Analysis, Functional Design Development, Integration & User Acceptance Testing, Training, Cut off, Go-live and Post-Implementation Support.
  • Conducted requirements gathering workshops, prepared AS-IS(BP-040),TO-BE(BP080), GAP analysis, Application setups (BR-100), Functional design (MD050) documents and Conducted CRP,SIT, UAT sessions and user training sessions.
  • Special expertise in implementation of self-service modules including, Internet Expenses, iSupplier, iReceivables and iProcurement.
  • Expert in Multi-Org, MRC (Multi Reporting Currency), Consolidation, Translation, Revaluation and Intercompany accounting.
  • Proficient is documenting Specifications following AIM Methodology
  • Implemented Financial Analysis Reporting by defining FSG Reports and Oracle Discoverer Business Areas and Workbooks.
  • Proficient working with Oracle Support, creating and following up on SRs. Coordinated and followed on multiple issues based on priority including identifying bugs and follow-up with Oracle Development as well as conducting Oracle Web Conference (OWC) with Oracle Support Team
  • Good working knowledge in implementing FAH for integrating various applications with Oracle EBS/GL for the client complex accounting needs.
  • Good understanding of various Oracle developer tools including Oracle Forms, Reports, SQL, PLSQL, TOAD, UNIX Oracle RDBMS concepts, etc.,
  • Experienced in customization by extension and modification of the standard application suite using Application Object Library (AOL).
  • Proficient in creating UPK’s for user training purposes in financial modules both in Oracle EBS and Oracle Fusion Financials.
  • Experience testing Conversions, Interfaces, Data Migration and various custom RICE components.
  • Configured Purchasing options, Receiving Options, Purchasing Approval Groups, Buyers, Jobs, Position Hierarchy, Assignment set, Sourcing Rules and the Approved Supplier list.
  • Configuration of Approvals Management Engine (AME) for standard Invoice Approval Workflow.
  • Extensively worked on OBIEE along with Oracle Apps. Has experience in gathering business requirements, developing Business intelligence program strategies, Testing/Functional, designing and implementing BI information & analytical solutions using OBIEE, Oracle apps EBS and BI discoverer on windows platforms.
  • Configured HR information to support Purchasing Documents Approval to define Employee, Jobs & Positions, and define & assign Approval Groups to support Job Position Hierarchies & also supported Employee/Supervisor Hierarchy for PO Approvals.
  • Proficient in Training Documentation & Delivering the Training to the End Users.
  • Co-ordinate and follow with offshore team to accomplish the milestones as per project time line.
  • Strong quality bias, self-driven and highly motivated for timely target achievement.
  • Excellent written and oral communication skills with a results-oriented attitude.
  • Critical thinking, decision making, coordination and resource management are skills that I have fined-tuned due to my academic and professional experiences.
  • My experiences have taught me to work efficiently even under pressure both as a team and as an individual.
  • Strong problem solving, Analytical skills & ability to work in a time-constrained and team-oriented environment.

TECHNICAL SKILLS:

ERP Applications: Oracle Applications R12 (12.2.5/12.1.3/12.0.6 ), 11i (11.5.10.2/11.5.8 )GL, AP, AR, FAH, CM, FA, PO, iProcurement, iSupplier, Sourcing, EB Tax, OM, INV, Advanced Pricing, Shipping, iExpenses, AOL, AGIS and AME, OBIEE reporting.

Programming Languages: SQL, PLSQL

Tax Software: Taxware, Vertex One Source IDT

Tools: TOAD, SQL Developer

Development Components: RICEW components designing, testing and debugging

Databases: Oracle Database 9i/10g/11g/R12

Change Management: PVCS, Rational Clear Case

Ticketing Systems: SYSAID, HP Quality Center, HP Service Center, Jira

PROFESSIONAL EXPERIENCE:

Confidential - Plano, Texas

Sr. Oracle Techno Functional Consultant

Responsibilities:

  • Closely worked with the business to get the requirements for AUTOCREATE PO project.
  • Worked with Business and Vendors in creating the Catalogs
  • Worked on mapping the Item Categories, Purchasing Categories & Iprocurement Mapping.
  • Prepared Functional Documents and Business requirement documents.
  • Worked on configuring the Punch outs
  • Created internal catalogs for Confidential with Punch-out
  • Working on Auto PO functionality enablement for the requisitions made from I procurement.
  • Working knowledge on Workflow builder
  • Working with offshore technical team in multiple time zones for implementing the Functional solutions.
  • Created Blanket purchase agreements and Contract purchase agreements
  • Created CPA’s for the suppliers
  • Ran end to end testing for CPA and BPA agreements.
  • Successfully configured Contract and Blanket purchase agreements.
  • Configured External Punch outs with Office Depot and other vendors.
  • Provided Testing Documentation.

Environment: Oracle Applications R12.2.3 (I Procurement), Workflow, Personalization’s, HPALM

Confidential - West Palm Beach, Florida

Sr. Oracle EBS Consultant - Financial/Testing

Responsibilities:

  • Prepared functional documents for the extensions in Payables and SCM.
  • Closely worked and coordinated with the technical teams to deliver the solutions as per the functional designs and customizations.
  • Conducting meetings with Off Shore Team members to discuss about scope and planning of the Project.
  • Configured the setups of tax users and profile option values in EB Tax.
  • Assessed the current use of the Vertex Tax application and the new features in the most recent version of Vertex versus the functionality required it the new Trane Company billing environment
  • System Administrator skills - user creation, defining responsibilities, profile options and securities.
  • Configured the setup for raising Batch invoices and Batch payments. Configured the setups for prepayments and adjustment to payment to suppliers
  • Coordinated and monitored Month End Closing process. Defined Payment process profiles in Oracle Payments.
  • Analyzed the support incidents logged in the remedy system and suggested as well implemented solutions.
  • Responsible for successful Upgrade of Oracle applications for Financial and Purchasing modules.
  • Preparing and tracking the Project plan. Ensure the timelines are met.
  • Performed Oracle Financial Process/ Reporting Review.
  • Conducted User Acceptance Testing (UAT) and collaborated with the QA team by taking the key part in developing the test plans, test cases and test data to be used in testing
  • Proficient in Turkey Automation Testing
  • Leading the offshore technical team and working in multiple time zones for implementing the Functional and technical solutions.
  • Configuring the Oracle Accelerators, which can do the setups automatically in client’s targeted instance.
  • Created End - End Flow for AP, Payables, and Order Management in Turnkey Automation.
  • Responsible for scheduling sessions with requirements gathering sessions with business users and different IT teams.
  • Responsible for creating Manual test scripts for GL, INV, Human Resources and Pricing
  • Responsible for loading the test scripts in HPALM and testing via Sprinter Automation tool.
  • Responsible for approving the test scripts of AR, AP, OM created by the other team members.
  • Author Test Scripts and Test Cases for the Quality Lead on SCM & Functional Modules
  • Tested the Purchasing and Account Payables modules setup for inconsistencies.
  • Setup Modules in SIT and UAT Test instances.

Environment: Oracle Applications R 12.2.5/12.2.6 (SCM, Accounts Receivables, Order Management, Advanced Pricing, Purchasing, Procurement, I Expenses), Workflow, Personalization’s, EB TAX, HPALM, Turnkey.

Confidential - Boca Raton, Florida

Oracle SCM/Financials BA

Responsibilities:

  • Involved in requirement gathering and authored MD 50 documents for the various reports and Interfaces which includes Inventory and AP invoice Interface.
  • Drafted requirement and mapping document for FAH
  • Built FAH solution design and maintained Documents I.E., Functional Design, BR100
  • Worked on New & updating BR100 for setups required for iprocurement, PO, AP and GL, Inventory & OBIEE .
  • Proficiently worked with Data Loaders for loading values to apps.
  • Having multiple sessions with users and IT to work and track the schedule is running as per plan.
  • Creating the PO for the Finance to check the approval hierarchy.
  • Creating and managing the day to day activities and reports in OBIEE for users.
  • Designed, documented and implemented Interface programs to import ITEMS from a legacy system into Oracle Inventory.
  • Implemented the 810 inbound invoices and the 820 outbound payments for supplier payments and all employees including expense reimbursement. Extensive experience setting transactions and troubleshooting issues in Ecommerce gateway and end to end process of implementing 820 and 810 EDI transactions.
  • Proficiency in EDI gateway configuration and data mapping.
  • Delivered the functional solution for the FAH and Ledger configuration changes.
  • Designed and authored functional specifications for many OM reports like Pick Slip, Packing Slip, and Mailing Label for Shipping and Orders by Item, Order Detail & Summary Reports.
  • Defined AR transaction types, customer classes and customer profiles.
  • Actively involved in setting up PO matching options, Invoice tolerances, Distributions options, Payment terms, Holds, etc. in SIT instance and perform End to End Testing
  • Setup of SCM Modules in PRE-SIT and UAT instances and handing over of UAT instance to Testing
  • Defined testing methodologies, designed test plans and test cases for system test, Product Integration Testing for UAT and post-integration support
  • Designed and configured Custom extension using Order Management processing constraints to restrict cancellation or updates of a Sales Order once the PO is created for a Back to Back process.
  • Configured the Oracle Fusion Cloud modules like Self-Service Procurement, Purchasing, Supplier Portal, Supplier Qualification, Sourcing, Payables, Product Information Management, Enterprise Contracts and Expenses
  • Provided Functional support for Oracle Inventory, Oracle Purchasing and Oracle Receivables.
  • Carry out set ups in TEST and PROD instance and assist in conversion activities prior to sgo live.
  • Interacted and worked with the development team to solve various code bugs and develop new functionality enhancements required as part of the go-live.
  • Worked and interacted with business users, technical team, Supplier business users and supplier's technical team globally.
  • Configured Pricelists, Modifiers and Qualifiers in Advanced pricing for complex pricing system.
  • Supported Post-Implementation phase for Oracle SCM & Financials Modules
  • Supported Payables & Receivables users on a day to day basis on Payment and Billing related issues in Oracle R12
  • Configured RDC & Min/Max levels for the sub inventories added after post go live.
  • Actively supported Field in Production Support in resolving the ongoing stuck transaction issues.
  • Resolved the day to day issues logged by the end users
  • Managed the issues and documented the resolutions using the ticketing tool Manage Now
  • Actively involved in the P1 Trainings sessions on Inventory and Order Management.
  • Logged SR's with Oracle on issues and worked with them on resolving them; tested patches provided by Oracle support
  • Created new OBIEE reports and managed existing for Business and Field users using different views and tables from Noetix.

Environment: Oracle Applications R12.2.5 (SCM, Cash Management, Accounts Receivables, Order Management, Advanced Pricing, Purchasing, Procurement, IExpenses, FAH), Workflow, Reports, Forms Personalization. OBIEE

Confidential - Atlanta, GA

Oracle Financial SME

Responsibilities:

  • End to end Implementation of Oracle Payables, Payments Receivables, Order Management, Advanced Pricing and Ecommerce gateway and actively involved in OBIEE reporting creation.
  • Designed many custom interfaces and processes to work with the client's highly-customized R12 environment, which centered on a custom Journal Portal built with FAH.
  • Created and designed Subject Area in Analytics Repository (RPD).
  • Created custom and packaged Interactive Dashboards with Drill Down, Dynamic, Criteria Filters, Security, Pivot Table, Chart, Aggregation, Logical Columns and Filters.
  • Carrying out requirement gathering, requirement analysis, high level and granular level mapping, GAP analysis, setups, functional and technical extensions and modifications, unit testing, stress testing, integration testing, and CRP’s related to the split scenario and post production data cleansing.
  • Study of Current business processes, future business flow & identification of GAP/Workaround to provide an integrated information system solution to meet the business needs of the company
  • Designed Oracle FAH to process and account interfaces from multiple external billing systems.
  • Worked in developments of analytics Reports using OBIEE Answers and assign them to specific Dashboards with Oracle Financials EBS as source of data from the modules like AP, GL, OM and FA
  • Configured Security and Cross validation rules to restrict the usage of departments and companies belonging to one Company by the other in sub ledger transactions.
  • Prepared BR100 Application setup for Payables, Receivables, Order Management, Payments and Ecommerce Gateway.
  • Policy, bank setups, Payment methods, Approval limits, Receipt workbench, month end closing for AR and bank reconciliation.
  • Resolved issues related to payment processing, payment authorization, and suppliers.
  • Resolved issues related to credit card refund, return, bills only, freight charge return, credit card authorization, consolidated invoicing and receivables.
  • Resolved the issues related to automatic clearance of receipts, aging bucket report, credit snapshot report, customer statement report.
  • Created accounting flex field segment values, creating new / updating the existing cross validation rules and security rule
  • Involved in requirement gathering and authored MD 50 documents for the various reports and Interfaces which includes AR Invoice and AP invoice Interface.
  • Designed, documented and implemented Interface programs to import ITEMS from a legacy system into Oracle Inventory.
  • Prepared CV040 for Suppliers and supplier banks conversion from Macola to Oracle Account Payables.
  • Implemented the 810 inbound invoices and the 820 outbound payments for supplier payments and all employees including expense reimbursement. Extensive experience setting transactions and troubleshooting issues in Ecommerce gateway and end to end process of implementing 820 and 810 EDI transactions.
  • Documented current state, designed future state to automate treasury functions including cash position, daily investing, cash forecasting, cash general ledger entries and debt facility accruals.
  • Configured banks, bank accounts and documents for different needs like AP processing.
  • Coordinating with Offshore development and Functional Team to resolve Issues.
  • Prepared TE040 Documents, which are used to test various aspects of application functionality.
  • Involved in defect fixing of custom workflows like OM export compliance, Return Merchandise notification and credit management.

Environment: Oracle Applications 11.5.10.2/R12.2.5 ( Accounts Payables, Cash Management, Accounts Receivables, Order Management, Advanced Pricing, Purchasing, iExpenses, FAH, EB-TAX, AME, AGIS, eCommerce Gateway ), Workflow, Reports, XML Publisher, Forms Personalization.

Confidential - German Town, Maryland

Sr. Oracle Applications Functional Consultant

Responsibilities:

  • Involved in implementation of all phases of ASAP Methodology to do a thorough study of Activity flow.
  • Responsible for End-to-end Oracle Applications (GL, AP, AR, PO) implementation project from assessment to production support as a Functional Analyst.
  • Worked on the design of FAH (Financials Accounting Hub) for future deployment.
  • Work with Implementation Team and gain thorough understanding of Oracle R12 design for subledgers, FAH, AGIS, SLA.
  • Responsible for developments of analytics Reports using OBIEE Answers and assign them to specific Dashboards with Oracle Financials EBS for multiple modules as required by business.
  • Financial Reports related to AP vendors, vendor sites, Invoices and distribution lines in AP, FA Locations, GL Journals, balance sheets and statements etc from Oracle Financials as Source through OBIEE.
  • Study of the current Business Process and GAP Analysis using AIM documents,
  • Analyze and Design the model for Receivables and collections for intercompany transactions as first wave of the Project
  • Delivered of BR100, Common Set-ups doc, Sys Admin Set-ups documents, Involved in the production support of AP and AR modules and worked closely with end users in resolving their issues.
  • Produced technical design documents for conversions, extensions, interfaces, and reports.
  • Troubleshoot issues, including creation/follow-up of Oracle service requests (SRs). Conduct quality reviews of code developed by other development staff.
  • Assisted in design of tables, databases, forms, and reports; connected forms with Oracle Applications.
  • Gathered application requirements and provided design recommendations.
  • Helped design custom data models that integrated with Oracle Applications.
  • Set up suppliers, supplier sites and payable options in E-Business Suite.
  • Defined period types, calendars, Distribution sets, Tolerances, bank accounts payables documents, payment terms, approval groups and approval assignments.
  • Worked on setups of AME roles.
  • Setup Receipt Classes, Receipts Sources and Payment Methods. Defined Quick codes for Employees and Purchasing.
  • Configured GL, SLA and FAH in the test and production instances. FAH was used to capture accounting entries from custom billing systems.
  • Configured the setups of tax users and profile option values in EB Tax.
  • Assessed the current use of the Vertex Tax application and the new features in the most recent version of Vertex versus the functionality required it the new Trane Company billing environment
  • System Administrator skills - user creation, defining responsibilities, profile options and securities.
  • Created and Executed Test Plan and Test Strategy document and defined testing scenarios.
  • Developed and Executed the Test cases & scripts for Smoke, Functional, System, Regression, Integration, Performance and UAT.
  • Involved in direct interaction with the business users and collecting information required for resolving support incidents.
  • Conducted knowledge sharing sessions for the team members in the functional areas of known modules
  • The Cash management implementation covered the Bank setups, the Bank Transaction codes setups, Bank statement mapping and customization of Bank statement import process for previous day and current day bank statements, Cash positioning and Cash forecast etc.
  • Designed conversion strategy for conversion of Fixed Assets from legacy system into Oracle Assets, carried out conversion, verified the asset balances, maintained the books for a number of periods and transitioned the books to the users for maintenance.
  • Performed functional analysis which implemented gathering user requirements accounts receivable system. Implementation included defining the System and Profile Options, define receivables lookups, define payment terms, defining transaction types and sources, define receipt classes and payment methods, and define Customer.
  • Used Accounting Rules to determine total revenue to be recognized (Revenue Recognition) in each accounting period. Setup Auto Accounting to recognize revenue based on Sales Order line.
  • Provided functional review & impact analysis on proposed changes with the existing functionality and prepare MD-50 for the module extensions.
  • Coordinated the rest of team members in identify and test interfaces between AP, PO and FA modules.

Environment: Oracle EBS R12.1.3 (FAH/XLA, EBTAX, AP, GL, AR, CM, PO), Workflow, Reports, XML Publisher, Forms Personalization. OBIEE 10.1.3.x,DAC 10g, OBI discoverer 10g, BI Apps.

Confidential - Denver, CO

Oracle EBS Specialist

Responsibilities:

  • Implementing all the financial modules for a new Fujitsu entity, Fujitsu Technology and Business of America, Inc.
  • Configured and set-ups for all financial Modules like AP, SLA, GL, PO, FA, CM, iprocurement,, iSuppler, iExpenses.
  • Resolving defects logged by Business Users.
  • Analyzing the User requirement s for Demand Requests(DR’s)
  • Writing Functional Specifications, Business Requirements and Business Rules to prepare test schedules
  • Identifying Test Requirements/Scenarios.
  • Designing Test Cases, Test Scripts, Test Date and Test Plans.
  • Participating/Coordinating with Business/Functional users in Application Configuration Set-ups.
  • Point of contact for OBIEE reports. Trained and presented to end users on how the OBIEE reporting works.
  • Created Subject Areas, Tasks, Execution plans in DAC and monitored and scheduled the ETL routines.
  • To pull reports bi-weekly to review along with end users to understand the accuracy.
  • Built new reports with the help of filters to edit the reports as required by business.
  • Created Subject Areas, Tasks, Execution plans in DAC and monitored and scheduled the ETL routines.
  • Involved in ETL Mappings and Workflows using various Transformations.
  • Worked as a functional support as well in Oracle EBS financials AP, GL, PO, FA modules and worked on Discoverer 10g reports and solved user issues.
  • Worked with subledger leads to test SLA and FAH entries in the GL and resolve issues from subledger postings. Reconcile SLA and FAH entries with the GL and subledgers.
  • The Cash management implementation covered the Bank setups, the Bank Transaction codes setups, Bank statement mapping and customization of Bank statement import process for previous day and current day bank statements, Cash positioning and Cash forecast etc.
  • Designed conversion strategy for conversion of Fixed Assets from legacy system into Oracle Assets, carried out conversion, verified the asset balances, maintained the books for a number of periods and transitioned the books to the users for maintenance.
  • Performed functional analysis which implemented gathering user requirements accounts receivable system. Implementation included defining the System and Profile Options, define receivables lookups, define payment terms, defining transaction types and sources, define receipt classes and payment methods, and define Customer.
  • Used Accounting Rules to determine total revenue to be recognized (Revenue Recognition) in each accounting period. Setup Auto Accounting to recognize revenue based on Sales Order line.
  • Provided functional review & impact analysis on proposed changes with the existing functionality and prepare MD-50 for the module extensions.
  • Carried out module configuration, solution design, process analysis, and implementation of Oracle Financials General Ledger, Accounts Receivable, and Accounts Payable including setups stated below.
  • Supervised the period close and quarter close processes by ensuring that all financial transactions have been accounted for accurately and on a timely basis in Oracle GL.
  • Provided support during the unit test, System Integration Testing and UAT.
  • Preparing AIM documentations that include BR100, TE0 40 and Process flow documents for Financial Modules.
  • Involved in Pre-and Post-GO LIVE supports.

Environment: Oracle EBS R12.1.3 GL, AR, AP, CM, FA, EB, FAH Support & Testing of Conversions & Integration of Business Objects from external legacy systems into Oracle EBS and vice-versa.

Confidential - Dayton, OH

Oracle Functional Consultant

Responsibilities:

  • Preparing BR100, MD050, TE40, TE50, CRP execution, User training and coordinating with technical teams on Oracle Apps related Custom design validation for integration between Oracle Apps and legacy applications.
  • Designed interfaces to port data from Oracle RMB (Revenue Management Billing) to Oracle FAH
  • Worked on the Configurations of AP, GL, AR, Cash Management, I-Expense, I-Receivables.
  • Conducted Regression testing to examine the effects of a new Org on the previous Org.
  • Successfully provided Technical and Functional support to the users, testers and Business System Analysts.
  • Communicated with business users about the Upgrade and requirement gathering questionnaire, explaining oracle’s functionality extension from R12 vs. 11.5.10.2 within oracle financials
  • AR- Defined invoicing information including payment terms, invoicing and accounting rules, territories and invoice sources. Defined accounting options, methods of accounting, realized gain / loss account, unallocated revenue account, auto cash rule set.
  • Responsible for preparing upgrade plan for GL, AP, PO, AR, Fixed Assets and I-Expenses with all customizations and form personalization.
  • Developed functional specifications for interfaces and conversions to the GL, FAH and AGIS. Work with the technical team to build and test these interfaces. Put in place a functional test plan to test these custom interfaces and conversions.
  • Setup Oracle Payables includes Payment Terms, Banks and Bank Accounts, Define Quick codes, Define Financial Options and Payable Options and Defined Corporate books, fixed assets categories, assets keys etc.
  • Preparing of all the Functional Specification Documents (FSD), Business Requirement Documents (BRD), Data Mapping Documents (DMD) and Functional Testing Documents.
  • Worked in the process of unit testing, System Integration Testing (SIT), performance testing, regression testing.
  • Documented Functional Design, Applications Setups & User Manuals Provided with useful training to the users in GL, AR, OM, INV and PO Modules.
  • Developed UPK simulations for Oracle EBS Inventory & Quality, PS (Production Scheduling), and Siebel CRM (Customer Relationship Management) application and Developed basic navigation UPKs and training courseware

Environment: Oracle Applications Release 11.5.10.2/R12.1.3 (General Ledger, Account Receivables, Account Payables, Order Management, Credit Management, E-business Tax, INV, Purchase Order, Fixed Assets, FAH), PL/SQL, MS Visio

Confidential

Oracle Functional Consultant.

Responsibilities:

  • Involved in Implementation and customization of Release 11.5 Oracle Applications (E-Business Suite).
  • The modules worked were Order Management, AR, AP, GL, FA, PA and CE respectively.
  • Developed several Reports using FSG, used open Interface to Import Journals by GL Interface and Budget Transfer to GL by using GL-Budget-Interface.
  • Used PL/SQL for validating the data from legacy system to interface tables. Run Journal Import to load the data into Oracle application tables.
  • Defined Descriptive flex fields necessary for form customizations, and distribution sets and bank related information.
  • Defined payment terms, locations, periods, tolerances etc. Integrated Payment reconciliation information and Purchase Order information with AP.
  • Validated the data and populated the Payables interface table through a Concurrent program which in turn submits a standard Payables Interface program.
  • Imported Requisition Details (Requisition Import) using SQL * Loader Modified the Reports like Invoice History, Invoice Aging, Prepayment Status, and Invoice on Hold Reports.
  • Entered and processing various transactions such as Invoice, Debit Memo, Credit Memo and Deposit. Worked on Auto Invoice and Customer Interface, Entered Receipts and Receipt Information.
  • Developed various reports such as Detail Payment reports with reference to Salesperson, Branch Level Transaction report and Customer’s outstanding report.

Environment: Oracle Application 11.5 of Oracle Financials, GL, AR, AP, CM, FA, EB, TOAD, FILEZILLA.

Confidential

Oracle Financial Analyst

Responsibilities:

  • Support end-users in Finance, Accounting, and Administration for the maintenance of Oracle ERP. Involved in resolving functional issues related to financial modules like GL, Accounts Payables, Receivables, Fixed Assets, iExpense, Ebtax.
  • Defined and maintained payment terms, supplier, supplier sites, and banks and other related setups as per requirement for payables.
  • Created Subject Areas, Tasks, Execution plans in DAC and monitored and scheduled the ETL routines
  • Knowledge of DAC and out of the box prebuilt BI Apps.
  • Defined and maintained Customers, customer profile classes, payment terms, distribution sets, Auto Cash Rule Sets, receivable activities as per requirement for receivables.
  • Establishing quality processes and ensuring processes are followed as per defined standards and guidelines.
  • Prioritized outstanding defects and system problems, ensuring accuracy and deadlines were met.
  • Responsible for Monthly/Quarterly and Yearly closures for AP, AR & GL.
  • Responsible for reconciliation of month-end/Quarter end reports.
  • Preparing Setup Documents, Functional Specifications for Customizations, Test Scripts & Training material.
  • Liaison with technical resources to resolve problems and ensure seamless transition from the Analysis phase to the Release phase. Configured auto Bank Reconciliation process via CE (Cash Management) module & Automatic Reversal of rejected receipts, and the ability to clear payments and receipts before Reconciliation with the bank.

Environment: Oracle Application 11.5.8/11.5.10.2 Oracle Financials, GL, AR, AP, CM

Confidential

Oracle Functional Analyst

Responsibilities:

  • Worked on the project by using AIM methodology.
  • Involved in End to End Implementation Life Cycle of Oracle Financial modules.
  • Analyzed client's current business events and process based on client discussions.
  • Setup of Security rules, Cross validation rules and values for Value sets.
  • Configured Financial Options and Payable Options.
  • Defining Payment terms, Distribution set Internal Bank account and Supplier Bank Account.
  • Defined Corporate books, fixed assets categories, assets keys etc.
  • Document the main setup steps, definitions and implementation issues.
  • Configured the Test Instance as per the setup document.
  • Prepared the Functional Document required for the business - Future Process module and Mapping design.
  • Setup the Access control for the users based on the responsibility.
  • Involved in CRP and UAT. Given training to End Users
  • Setup Financial Modules in TEST, DEV Instances
  • Testing of Setups done in the above instances
  • Prepared BR100, TE040 and MD050 Documents as per the requirement
  • Providing the User with relevant Test Scripts to test the instances and helping them on Functional issues.
  • Setup of Financial Modules in PRE PROD and PROD instances and handing over of PROD instance to Users.
  • Upload supplier & Customer Details from the legacy to the application.
  • Done System Integration testing with the sub-ledgers to the General ledger.

Environment: Oracle Application 11.5.10.2 (GL, AP, AR, CM & FA), AME, AIM Documentation, Windows XP, TOAD, Rational Clear Case, Mercury Quality Center.

Hire Now