Summary:

• Around 10 years of experience in Analysis, Design, Development, Testing and Implementation of Software Applications using Oracle Applications 11i/11.0.3 spreading across Implementations, Version upgrades, Data conversions.
• Extensive experience in Oracle Applications 11i Oracle Financials GL, AP, PO, FA, PA, AR,OM, INV, I-Expenses, I-Procurement
• Extensively worked in Oracle back-end programming and Front-end development using tools like PL/SQL, SQL Plus, Oracle Forms 6i/4.5, Oracle Reports 6i, Workflow, SQL Loader, UNIX shell scripts
• Extensive experience in Conversions and interface coding for various modules
• Extensive experience in customizing OBIEE dashboards and reports
• Excellent proficiency in data and object level Security in Siebel Analytics/OBIEE
• Expertise in developing OBIEE repository with Physical, Logical and Presentation layers build reports/dashboards from the repository using OBIEE Siebel Answers and troubleshoot various technical issues and bugs
• Expert in cache management, Repository migration, data level and object level security in OBIEE Analytics
• Extensive experience working with Business Analysts to understand business needs
• Proficient in creating menus, responsibilities and any system administrator functionalities
• Strong programming experience in creating Procedures, Packages, Functions, Triggers and other database objects using SQL and PL/SQL.
• Excellent analytical, problem solving, communication and interpersonal skills with the ability to interact with individuals and teams at all levels.
• Clear written, oral presentation of ideas, proposals and concepts. Strong interpersonal, analytical and trouble-shooting skills.
• Expertise as a Functional/ Technical Team Lead in Oracle Application implementations
• Had experience with India Localization implementation and Up gradation Projects

Technical skills:

Work Experience:

Confidential

Responsibilities:

• Requirements gathering for enhancements from Business Managers for R12 Payments and Payables.
• Enhance and implement the new requirements of the Business.
• Performed complete setup for R12 Payments module in UAT.
• Designing of Payment file Structure for various countries.
• Have done mapping 11.5.10 reports to R12 XML templates, writing Extent and Validation rules, plugging Validation and extends to Payment Process.
• Understanding on R12 ebTax module, creating Document for it, sharing analysis with team.
• Testing R12 SLA reporting, Finding Bugs, keeping track of Bugs and providing regular updates.
• Development of XML Templates for Payments files.
• Worked Close to Product Dev. Team of Oracle APPS for modifying functionality for R12 Payments Module.
• Developed Registration Scripts for Moving Objects from one environment to another.
• Coordinated with Business User, Banks ABN AMRO, CITIBANK for UAT and payment file verification.
• Trained end user for R12 Payments and R12 Payables Modules Functionality.
• Wrote scripts for creating tables, Indexes, Grants and Synonyms and made modifications for the existing tables as per business logic.
• Worked on Production Support Quarter End / Month End AP Close Issues, which included Accounting issues, trial balance Issues, data corruption issues.
• Single point of Contact for discoverer reports, developed reports, modified business areas, Crated Custom Folders.
• Coordinated with R12 Discoverer team for testing of disco R12 migration.
• MOAC has been assigned to users.
• Financial reports have been modified as per R12 setup.
• Modified custom packages as per R12 Structure.
• Tested entire P2P process in R12 after up grading to R12

Confidential

Responsibilities:

• Developed Alert for Auto reminders related to I-expenses.
• Created Packages for deactivating unused Credit Card Transactions and Cash withdrawal Transactions.
• Developed dcl files to send PO pdf as attachment through email using Optio tool.
• Developed Custom rdf reports in OM, INV
• Customized reports in PA Projects and FA Modules
• Customized packages in OM, INV, PO
• Provide production support issues and enhancements related to OM, Purchasing, Inventory and Legacy related interfaces.

Confidential

Responsibilities

• This is a Product in development on OBIEE from Cozent Technologies targeted for small and Mid-range Companies that use Oracle Apps Business suite for their business Analytical Propose. The work for Oracle apps team involves Analysis of standard apps reports, extend the functionality, come up with programs to extract and translate the apps data to warehouse marts and develop custom Requests on Apps side for initiating various processes to make it easy for Apps users to use the Product. It also involves building data security at operating units, inventory orgs, set of books and FA security Profiles on the Dash Board and Answers side. A total of 470 standard oracle apps reports across 11 modules are in development for extraction and transformation. Also Involved in tech support work for PSAV client for Oracle Apps 11i apps
• Creating OLTP views
• Developing ODS and VDM scripts for ETL
• Developed Packages and sql queries in apps schema that will be used for reporting in .net platform
• Involved in Gaap analysis
• Writing Technical Doc's
• Developing custom reports Scripts for extractions and transformations.
• Assist in integration of the custom interfaces with workflow
• Unit test of the interfaces, reports forms
• Unit, integration and system testing for all components in OBIEE. Test cases have been prepared and documented the results
• Customized the OBIEE Repository physical, BMM, and presentation layers .

Confidential

Responsibilities

• Got to speed up the V 11.5.10 Upgrade within a short period of time by performing intensive Functional and Interface Testing in AP, AR,PA,OM,INV and GL modules.
• Customized various reports using Reports 6i such as the Payment batch Format Report so that the IBAN number has to be displayed in Format Report output as per user requirements.
• Involved in SR closure activities.
• Involved in the modification of code to validate data and integrate with Auto Invoice.
• Worked with a team of Business system Analysts and provided on-call Production support.
• Attended Weekly Meeting with key business users that helped understand business needs.
• Registered custom applications, Responsibilities, Menus.
• Provided production support with Purchase orders, requisitions, receiving, invoices and payment issues.
• Involved in data conversion from OPA 11.0.3 to 11i PA.
• Pro-actively updated testing scripts to support the team's initiative to keep the reference repository up-to-date and serve as a template for future version upgrades.
• Involved in Customer Support based on Service Desk tickets.
• Involved in auditing the performance of team in handling the SDT's.
• Involved in Release Management Process for the Code Release in various stages.
• Troubleshooting, cross training with other developers.
• Support ongoing Change Requests and defect resolution.

Confidential

Responsibilities:

• Involved in Coding Custom PL/SQL to validate the data to interface with Oracle Applications Auto Invoice.
• Coordinated with the functional team in the complete set up of Oracle Receivable that included defining System Options, Accounting Rules, Auto Accounting Rules, Aging Buckets, Approval Limits, Banks, Auto Cash Rule Sets, Transaction Types, Payment Terms and Dunning Letters
• Customized various reports using Reports 6i like AR customer statement report and interacted with the end users to make changes as required.
• Created interface Program to validate the invoice data and insert into interface tables. Performed necessary setups for payables conversion.
• Involved in Release Management Process for the Code Release in various stages
• Modified PO Requisition workflow to interchange the requestor and preparer ids.
• Designed and developed purchase order interface to load open PO's from legacy system to apps.
• Developed GL Outbound Interface to generate CSV Files with the help of UTL FILE.

Confidential

Responsibilities:

• As an Oracle Application Technical Consultant, was involved in Conversions and Interfaces for GL, AP and AR modules
• Customized the Payables Interface for loading the payables Headers Information into application tables from legacy system using SQL Loader.
• Involved in writing the validations before importing of data into the interface tables.
• Involved in educating users of the system environment, solving day-to-day problems in oracle application.
• Designed and developed the interface for data validation for Journal Import, GL INTERFACE .
• Developed programs for Oracle Payable Invoices and conversions.
• Worked with the functional team to setup recurring invoices, prepayment invoices in AP.
• Modified evergreen check format as per client requirements.
• Design and Develop Interface for Customers RA CUSTOMERS INTERFACE ALL .
• Registered all customized reports, concurrent programs using Application Object Library.
• Worked on Tuning of many queries of the Custom Reports to minimize the time of execution by utilizing diagnostic tools.
• Created users and allocated responsibilities using System Administrator.

Confidential

Responsibilities:

• Creating users modifying the privileges for users. Creating appropriate roles and assigning it to users.
• Loaded data into oracle tables using SQL Loader and dbms utility package.
• Performed several outbound interfaces.
• Involved in Release Management Process for the Code Release in various stages
• Reviewed MD.050 functional document and prepared MD.070 tech design for the development work done.
• Wrote a package containing different procedures and functions using PL/SQL to cross validate invoice information and load automatically invoices into AP invoice interface tables.
• Designed and developed the interface for data validation for Journal Import, GL INTERFACE .
• Modified evergreen check format as per client requirements.
• Registered all customized reports, concurrent programs using Application Object Library.