SUMMARY

• Over 10+ years of experience in the implementation of Oracle Applications and Customizations.
• Excellent Techno/ Functional knowledge in Account Payables (AP), General Ledger (GL), SLA, Account Receivables (AR), Cash Management (CE),HRMS, Fixed Assets (FA), E - Business Tax (eBTax), Order Management (OM), AME,Purchasing (PO), Inventory Management, Application Object Library (AOL) in R12, 11i (11.5.10.2).
• Experience in Oracle BI Apps (OBIA) - Procurement Analytics and Spend Analytics.
• Strong experience in developing OBIEE Repository (. rpd) at three layers (Physical layer, Business Model & Presentation layer), Interactive Dashboards with drill-down capabilities, using global & local filters, security setup (groups, access/query/report privileges), Analytics metadata objects configuration experience (subject area, table column), Web Catalog objects (Dashboard, Pages, Folders, Reports)
• Proficient in Support, Upgrade and Implementation of Oracle E-Business Suite R12 and 11i.
• Good experience on Procure-to-Pay, Order-to-Cash.
• Involved in AME configuration for sales order returns.
• Expertise in Data Conversion, Data migration, Developing Interfaces in Oracle Applications.
• Experience and Expertise includes Business Requirement Gathering, Requirement Mapping, GAP analysis, Functional architecture, CRP (Conference Room Piloting), Solution Design, Proof of Concept, Unit Testing, UAT and User Training.
• Experience in Oracle 8i/9i, PLSQL, SQL*PLUS, Oracle Reports, Forms, XML Publisher (5.6.3) and Oracle Workflow
• Module implementation for Oracle E-Business 11i (11.5.10.2) and R12 (12.1.3) for Financial Modules.
• Excellent knowledge on Functional Analysis and Implementation, Training the client’s super users and users on the application and conducted Pilot Testing, Integrated Testing, Design Validation and Setups.
• Experience with Other Utilities: TOAD, SQL*Loader.
• Strong experience in Software Development Life Cycle (SDLC) process - Lead business meetings to gather requirements, perform feasibility analysis, design, technical specifications, development and unit testing, integration and production installand support
• Expertise in Configuring, using & Administrating version control systems like Visual SourceSafe (VSS), CVS, PVCS, HP Project and Portfolio Management (PPM).
• A Good team player with Excellent Technical, Communication & Interpersonal skills.
• Motivated and determined to deliver High Quality Deliverables within deadlines with minimal supervision.
• Extensive experience in Source/ Existing/ Legacy system business functionality and preparing the Functional and Technical Design Documents using Oracle AIM Methodology (MD050, MD070, CV040, BR100, MD120).
• Was solely responsible for Production Support issues after the implementations and issues raised from day to day business.
• Familiar with Oracle Applications Framework (OAF) technology, especially with Personalization of existing OA Framework pages.
• Led the design and development of the custom WEBADI templates for AR Invoices and AP Invoices using This custom process validates the data and reject or process based on the successful validation like seeded WEBADI in Excel.
• Good in Identifying the process improvements based on best practices, presented to the Client and Implemented the Functionality

TECHNICAL SKILLS

Languages: SQL, PL/SQL, UNIX Shell Scripting, C, C++, JAVA, HTML

Enterprise Applications: Oracle E-Business Suite R12, 11.5.9 to 11.5.10, OAF Oracle SOA Suite (10g, 11g).

ERP/Modules: GL, AR, AP, OM, CE, FA, EBS TAX,HRMS, AME, INV, PO, AOL, Sys. Admin

Oracle Tools: Reports 6i/9i/10g, Discoverer 4i/10g, Forms 6i/9i/10g, SQL*LOADER, XML Publisher, Oracle Work Flow Builder.

Databases: Oracle 11g/10g/9i, MS Access

Tools: TOAD, SQL* PLUS, SQL Developer, SQL * Loader, PUTTY, ODI 11g

Business Intelligence: OBIEE … Administration, Answers, Interactive Dashboards, Oracle BI Publisher

Operating System: Windows 9x/NT/2000/XP/Vista, MS DOS, UNIX, Linux

PROFESSIONAL EXPERIENCE

Confidential, Detroit, MI

Oracle Application Sr. Techno Functional Consultant

Responsibilities:

• Worked as Sr. Techno Functional Consultant
• Gathering and analyzing user requirements and interacting with onsite team and business users
• Day to day status track of issue logs
• Involved in the project meetings to define/direct project goals and objectives
• Architecting and developing customer specific solutions
• Quality Control and Quality Assurance
• Involved in the post go-live support
• Develop and support oracle Financials and HR for Confidential, involve in the oracleupgrade project from 11i to R12.1.3.
• Developed an automated ACH process from scratch (Automation includes starting from invoice validations/ building payments (PPR), transferring ACH files to bank, sending Fax and Email Emittance Advices to Suppliers).
• Developed an AP Interface between Confidential Loan Servicing System and Account Payables.
• Solely responsible for gathering business requirements and developing numerous Reports/ Interfaces/ Customization as per the requirement.
• Developed useful day to day customized AP Audit reports.
• Developed an AP Interface between Confidential Loan Servicing System and Account Payables.
• Provided technical help on oracle HRMS modules such as Core HRMS, Advance Benefits And helped the team in Open Enrollment.
• Used APEX to build a customized workflow for the GL Approval engine.
• Worked on OAF Screen personalization in iExpense module.
• Worked on OAF Screen personalization in SSHR module.
• Responsible for Monitoring and solving the Interface Programs related to Bank Statements which includes AR, AP, FA and CE.
• Worked on Importing Tax Lines Using the Payables Open Interface
• Created a program to extract balances for reconciliation of GL data conversion that will extract for all balancing entities or a particular balancing entity and year combination.
• Customized the "Requisition Approval Workflow" in order to generate custom approval group using AME rules.
• Working on SOA related issues and completed few functional testing related to SOA and BPEL.

Environment: Oracle Applications EBS R12.1.3 (GL, AP, HRMS, CM, EBS TAX, AME, AOL), Oracle Database 11g, SQL, TOAD, Workflow, WEBADI APEX, XML Publisher

Confidential, Minneapolis, MN

Oracle Apps Techno Functional/OBIEE Consultant

Responsibilities:

• Gathering and analyzing functional requirements and In-depth understanding of the client's business processes and business needs
• Interacting with onsite team and business users and architecting and developing customer specific solutions
• Technical analysis of existing RICEW components of existing components functionality
• Prepared Technical Documents, Unit Test Scripts, Test plans and Test results
• Design,Code, Test, code review and preparation of test scenarios/cases for all technicalcomponents
• Quality Control and Quality Assurance
• Involved in the post go-live support
• Develop outbound interfaces to extract data, encrypt and transfer files on to remote server using SFTP.
• Creating, modifying and filtering requests, and format results in OBI EE Answers
• Administration of OBIEE and the OBIEE Web Catalog.
• Implementing OBIEE metadata (RPD) design and development - including design and definition of logical tables, physical sources, dimensions, columns and aggregation rules.
• Reviewing, refining and validating functional requirements and provide the design specifications for the OBIEE solution.
• Developed many Ad-hoc and standard Reports/ Dashboards with different Analytics Views (Drill-Down, Pivot Table, Chart, Column Selector, and Tabular with dashboard and page prompts) using Siebel Analytics Web.
• Created mappings using different transformations like Source Qualifier, Filter, Router, Aggregator, Lookup, Expression, Sequence Generator and Update Strategy to store the data in target table.
• Understanding from business users of requirements for reporting Metrics, KPIs and standard analytics, transforming these requirements into Business Intelligence solutions available to end users.
• Fixed all the errors and warnings in the repository and web catalog.
• Designed and implemented the new security changes in OBIEE 11G.
• Develop inbound interfaces which would pick up files from remote server, decrypt and import data to oracle.
• Develop batch files to automate encryption, decryption and SFTP process.
• Development of customized forms using Oracle Application Framework (OAF).
• Migrate interface objects from windows to Linux environment.
• Develop shell scripts for migration project to automate encryption, decryption and SFTP process.
• Solely responsible for Standard Sales order and Blanket sales order conversion process along with 4-5 XML publisher reports as per the requirement.
• Oracle Account Payables (AP), General Ledger (GL):
• Developed GL COA information outbound interface
• Developed GL code combinations outbound interface
• Developed checks information outbound interface
• Developed inbound interface program to load data in to AP INVOICES INTERFACE and
• AP INVOICE LINES INTERFACE
• Developed custom program to call the standard payables open interface import to load data from payables interface tables to oracle base tables.
• Developed custom program to create attachments for invoices
• Oracle Inventory (INV):
• Worked on ITEM MASTER CONVERSION.
• Worked on ITEM CATEGORIES CONVERSION.
• Worked on ITEM SUB INVENTORY RELATIONSHIPS
• Worked on ON-HAND QUANTITY (Material Transactions) Conversion.
• Oracle Purchasing (PO):
• Developed vendor information outbound interface.
• Developed PO/Contracts information outbound interface.
• Developed PO receipts information outbound interface.
• Customized existing form to accommodate new fields for vendor site code and finance contract

Environment: ERP Applications Oracle EBS (12.1.3), GL, PO, INV, AP, PL/SQL, Oracle 10g/9i, Reports 10g/6i, SQL*Loader, SQL*Plus, PVCS, OBIEE, Putty, Winscp.

Confidential, San Jose, CA

Oracle Application Techno Functional Consultant

Responsibilities:

• Worked asLead Oracle Applications Consultant and Programmer Analyst
• Responsible for gathering Requirements, Development of Functional, Technical, Installation and User Documents
• Identifying functional and technical gaps.
• Assisted in business process reengineering, solid understanding of As-Is documentation and created To-Be process document
• Involved in code development, migration and test (Documented for Unit Test Scripts, Test Plans, and Test Results)
• Closely worked with users to understand business needs and objectives
• Technical Activities:
• Was solely responsible for all the Financial and OM related conversion entities (GL Balance, Customer Master, Open Sales Orders, AR Invoice, AP Invoice, INV and Employee Conversion)
• Also, worked on Bank Statement Interface and loader programs.
• Worked on Various inbound and outbound interfaces for example FUTURE 3 interface, EDI INVOICE Interface.
• Major development was a Payables Check on own stationary using XML Publisher template.
• Development of customized forms using Oracle Application Framework (OAF)
• Worked Extensively on XML Publisher 5.6.2 against Applications R12, to develop various reports in GL, AP, AR, OM, INV, PO, FA, PA, CST, BOM and WSH modules.
• Designed and created over 5 XML Publisher Reports from various finance modules.
• Developed the XML check printing report on a blank check stationary, which also includes the electronic signature, Included the XML Bursting program on AR Invoices and Customer Statement to email the pdf reports directly to the customers.
• Created complex templates, using Sub templates, Dynamic images, complex charts, and dynamic parameters to produce the output in PDF and EXCEL formats.
• Involve in BPEL and SOA Support.
• Forms & Reports:
• Check & Validate, Rename, Recompile and Test existing customizations like custom forms, custom reports, and concurrent programs (host, SQL loader, SQL*plus, PL/SQL) in Oracle R12.
• Built the report using Reports Builder 10g and integrated it with the application (based on the descriptive flex fields) to solve the client’s reporting needs.
• Involved in AME configuration for sales order returns.

Environment: Oracle Applications - EBS 12(GL, AP, AR, OM, INV, PO, FA, PA, CST, BOM), Oracle XML/BI Publisher Database Oracle 10G, Windows XP professional, CVS, Oracle Report Builder 6i, Form Builder 6i, Workflow

Confidential

Oracle Application Techno Functional Consultant

Responsibilities:

• Responsible for gathering Requirements, Development of Functional, Technical, Installation and User Documents
• Identifying functional and technical gaps.
• Assisted in business process reengineering, solid understanding of As-Is documentation and created To-Be process document
• Involved in code development, migration and test (Documented for Unit Test Scripts, Test Plans, and Test Results)
• Closely worked with users to understand business needs and objectives
• Technical Activities
• Worked on PO forms and PO Requisition Forms Personalization.
• Worked on RICE components development.
• Independently personalized Oracle PO and PO REQ forms based on the GL budget amount and Purchase Order Amount.
• Was successful in moving the personalization to the production environment using ftp.
• Developed sql*loader control files to load the flat file into intermediary tables finally into RA CUSTOMERS INTERFACE ALL, RA CUSTOMER PROFILES INTERFACE ALL Interacted with the employees and managers of the different Departments and gather the existing data and to understand the system of Oracle Financials, finally preparing the interface data model.
• Developed a XML/BI Publisher template for printing the AP Checks. Added logic for displaying Signature Images dynamically based on the Check Amount.
• Worked Extensively on XML Publisher 5.6.2 against Applications R12, to develop various reports in GL, AP, AR, OM, INV, PO, FA, PA, CST, BOM and WSH modules.
• Completed the XML Report for Request for Quote including the MD.070 and started designing the RFT template for Purchase Orders.
• Customized XML/BI Publisher reports for Oracle Purchasing.
• Created output format in XML/BI, new templates for XML/BI Publisher to display the reports in client requirement format.
• Created PDF/EXCEL outputs for reports based on requirements
• Used Data Templates for generating the XML data.
• Worked on creating Workflow Events with XML Payload and performed WORKFLOW Customizations.

Environment: Oracle EBS R12(PO, AP, AR, GL, FA, CM), Database Oracle 10G, Windows XP professional, CVS, Oracle Report Builder 6i, Workflow

Confidential

Oracle Application Developer

Responsibilities:

• Worked as Techno Functional Consultant
• Gathering and analyzing user requirements and interacting with onsite team and business users
• Day to day status track of issue logs
• Involved in the project meetings to define/direct project goals and objectives
• Architecting and developing customer specific solutions
• Design, Code, Test and code review Preparation of test scenarios/cases for all technicalcomponents bases on functional designs.
• Quality Control and Quality Assurance
• Involved in the post go-live support
• Extensively performed conversions and interfaces on financial modules for upgrade to Oracle R12.
• Involved in developing interfaces, conversions and reports as a part of R.I.C.E objects development and development required for implementation of P2P process.
• Involved in Design and development of AR Customer Conversion, GL Conversion, and GL Interfaces (Budget and Actual)
• Involved in Requirement Analysis, Data Mapping and Client Interaction. This involves analyzing MD50 (Functional Spec) and then writing MD70 (Technical Spec).
• Utilized Oracle's Application Implementation Method (AIM) approach, and documented the process using the recommended AIM documentation
• Have extensively worked on Oracle Account Payables Open Interface and AP Invoice Interface for Oracle R12.
• Created new Invoices in AP for the Procure to pay process.
• Involved in entering the invoices, approving invoices and then GL transfer for Oracle Accounts Payables.
• Imported the data from legacy systems into the temporary tables in Account Receivables (AR).
• Defined customer profiles, customers, payment terms, payment methods and tax structures, including tax exemptions and exceptions in Accounts Receivables (AR).
• Imported data from Legacy system (Mainframe) to Account Receivables tables using SQL*Loader and validated them using PL/SQL Procedures.
• Involved in Design and Development of Outlook soft to GL, BNA Journal to GL interface and various GL Objects.
• Developed AR Invoice Print Report on Pre-printed Stationery and AP Check Printing Report Using XML Publisher according to the Client Requirement.
• Have done mapping 11.5.10 reports to R12 XML templates, writing Extent and Validation rules, plugging Validation and extends to Payment Process.
• Involved in the design and technical development of Print Purchase Order Reports and Invoice reports using XML Publisher according to the client requirement.

Environment: Oracle EBS R12(GL, AP, AR, PO), Forms 6i, Reports 6i, TOAD, Oracle XML/BI Publisher, Unix, Kintana

Confidential

Oracle Application Developer

Responsibilities:

• Study the Requirements and interact with Onsite Business Analysts and business users
• As a Team member interact with Team lead and manager for Requirements.
• Responsible for developing the assigned RICE components
• Testing the developed components with front andApplications
• Worked as a Technical consultant (RICE Development).
• Worked over Oracle Applications 11i financial modules.
• Have been into discussion with business and identified questions to be resolved.
• Create entries in originating entity and in receiving entity for AP intercompany cross-charges (re-bill to receiving entity).
• Extensive experience in development of various interfaces like Auto Invoice Interface and Customer Interface for AR.
• Customized various transactions in Accounts Receivables like Invoices, Receipts, and Credit Memos and Debit Memos etc.
• Worked on AR Invoice printing programs.
• Create transfer price journal entries for management fees, cost-plus fees, etc.
• Generated these Journal Entries based on the currency codes such as to generate two journal entry lines for functional currency code USD and three entries for NON USD functional currencies.
• Given two different successful logics for generating journal entries for the originating and receiving entities based on the currency codes and the Intercompany segment values.
• Worked on cross charges for billing the receiving entities and generate transfer price journals based on the exchange rates of the receiving entities functional currency.
• Populated the AP Interface tables using the GL journal Entries already generated.
• Create intercompany invoice in PDF format to be emailed to receiving entity Utilized PL/SQL developer tool in developing all back end database interfaces.

Environment: Oracle Applications 11i financial modules (GL, AP, AR), Forms 6i, Reports 6i, TOAD, UNIX, KINTANA