SUMMARY:

• Having 15+ years of experience in software industry.
• Having 14+ years of experience in Oracle Application versions like R12, 11.5.10, 11.5.7, 11.5.5 and 10.7.
• Proficient in Oracle Financials Modules General Ledger, Oracle Payables, Oracle Receivables, Purchasing Order.
• Implementation of Oracle Financials, SCM and Manufacturing modules which include General Ledger, Accounts Payables, Accounts Receivables, Fixed Assets, Purchasing, Cash Management, Lease Management, Order Management, Inventory, Manufacturing.
• Distribution Modules Purchasing, Order Management: Order Entry API’s, Shipping API’s.
• Involving in estimations, system analysis, design, testing, implementation and support of application software.
• Extensively worked with Integration, Migration and Upgradation.
• Experience with business process/requirements analysis, module set up and configuration, documentation, ability to spec customizations and reports, and knowledge transfer experience.
• Extensive experience in development of RICE (Reports, Interfaces, Conversions, Extensions) components.
• Good exposure in Auto Lockbox, TCA Architecture and Workflow.
• Good Exposure on change management, code migration and Release management and effectively used different version control/ migration tools like Kintana/PPM, Sub Version (SVN), PVS, CVCS also design and deploying tools.
• Having Good Exposure in Oracle AIM Methodology and System Development Life Cycle (SDLC).
• Experience in Brio Hyperion Designer and Discoverer
• Onsite coordination experience and work with the offshore team to knowledge transfer and development support.

TECHNICAL SKILLS:

ERP: Oracle Applications (R12, 11.5.10, 11.5.7, 11.5.5, 11.5.3 and 10.7)

Modules Worked: GL, AP, AR, PA, FA, CE, PO, OM, Manufacturing, Procurement, INV, Service Contracts, Install Base, SYSADMIN, AOL

Languages: SQL, PL/SQL, SQL*Plus, JAVA, Oracle JDeveloper, ASP, HTML, C, C++

Database: ORACLE 7.3, 8, 8i, 9i, 10g, 11g.

GUI s: Oracle Reports 2.5, 6i, 10g, Oracle Forms4.5, 6i, 10g, XML Publisher, Hyperion Designer, OAF, BPEL.

Tools: Toad, Developer, Discoverer 9x, 10g, Sub Version (SVC), Harvest, Kintana, HP Quality Center (ALM), Sub Version, Panaya R12 Upgrade Support tool.

OS: Sun Solaris, HP - UNX and Windows-NT/2000

PROFESSIONAL EXPERIENCE:

Confidential, Irving TX.

Lead Techno-functional lead Analyst

Responsibilities:

• Worked with IT and Users/Business teams to understand the business and requirement.
• Understand the existing business, environment and plan for separation.
• Identify all existing tools and custom object that impacts the separation.
• Analysis of existing environment and prepare plan for divesture.
• Analyzed standard interfaces and identify the impacted tables and other processes while importing data.
• Prepared custom scripts and plan to delete non bricks data from the new instance.
• Involved and supported in implementation and testing of the new single Bricks instance.
• Worked with Application DBA’s to clone the existing production environments for development, testing and for production environments for new separated Bricks instance.
• Involved in production cutover plan and supported production implementation.
• Effectively worked with offshore and onsite teams for this implementation.

Environment: Oracle APPS R12, Oracle 9i/10g, PL/SQL, System Administration, Application Developer, General Ledger, Accounts Receivables, Accounts Payables, Fixed Assets, Cash Management, Purchasing Order, Inventory, Order Management.

Confidential, San Jose, CA

Techno-functional lead Analyst

Responsibilities:

• Responsible to support all process related issues.
• Responsible to support any production breakages in the flow, crediting calculation engine, upstream/ downstream systems and any other supporting applications for this.
• Responsible for maintaining workflows for the manual uploads and approval flow.
• Used Remedy Supporting tool for production case.
• Responsible for maintain manual kick off processes part of these tool using $U application.

Environment: Oracle APPS R12, Oracle 9i/10g, PL/SQL, Shell Script, System Administration, Application Developer, General Ledger, Accounts Receivables, Accounts Payables, Purchasing Order, Inventory, Order Management, Sub Version (SVC), Remedy Support Case tracking tool.

Confidential

Techno-functional Analyst

Responsibilities:

• Understanding the existing Seagate ERP 11i environment and list out required setups.
• Responsible to support all development and CRP R12 instances AOL setups.
• Responsible to support all development and CRP R12 instances Data Base setups.
• Responsible in monitoring standards of Database Objects and applications.
• Responsible for application setups like GL, AGIS, AR, AP, OU’s, Inventory ORG’s etc.
• Work with Multi org setups for the application environment.
• Hands on application development activities with all RICE components and involved end to end implementation.
• Hands on support/debugging/bug fixing part of different test stages of the application.
• Working with new migration tool called Sub Version (SVC) to setup and training to the team.
• Worked with ERP and Global Trade Management (GTM) integration to support supplier data updates.
• Worked with Panaya R12 up gradation Support tool to analyze the gaps in code.
• Responsible for user access provisioning and de provisioning for the bulk users part of go live and post go live activities.
• Worked with AOL API’s for responsibility maintenance, user creation, assigning responsibilities etc.
• Extensively work with code migration using Sub Version and Harvest.
• As we are part of the infra team, involved in release management, preparing release checklists, coordinating with the teams and updating the schedules for each release.
• Worked with HP Quality center (ALM) to track or manage test cases.
• Supporting different stages of testing CRP, SIT and UAT.

Environment: Oracle APPS R12, Oracle 9i/10g, Reports 6i/10g, Forms 6i/10g, XML Publisher, PL/SQL, Shell Script, System Administration, Application Developer, General Ledger, Accounts Receivables, Accounts Payables, Fixed Assets, Cash Management, Purchasing Order, Inventory, Order Management, Sub Version (SVC), HP Quality Centre, Harvest, SQL Developer.

Confidential, San Jose, CA

Techno-functional Analyst

Responsibilities:

• Understanding the existing Cisco R12 and custom environment and worked with the Cisco business to gather the business requirement and recommended for the missing requirements with respective integration and migration of data.
• Identify the gaps and involved in solution design and technical development.
• Designed functional and technical specification documents in different areas
• Lead onsite and offshore teams and share / translate the requirements and support for the development.
• Work with the cross functional teams then Design and develop the extensions that required for integration and other needs.
• Worked with the creation of Suppler which required for this integration.
• Design and developed ad hoc reports which required to the business to understand the data.
• Involved in Code development, code reviews and unit testing.
• Worked with the offshore teams and sharing the knowledge in designing the solution documents.
• Developed Functional specification documents (FSD), Technical Specification documents (TSD) and Test Scripts.
• Involved in different Test cycles to support the development activity.
• Part of this assignment extensively used Kintana /Project Portfolio Management (PPM) for code migration, HP Quality center tool to track and support the testing activity.

Environment: Oracle APPS R12, Oracle 9i/10g, Reports 6i/10g, PL/SQL, Shell Script, Accounts Receivables, General Ledger, Purchasing Order, Inventory, Order Management, BOM, Shipping, Kintana, HP Quality Centre.

Confidential, Winston Salem, NC

Techno-functional Analyst

Responsibilities:

• Work with the users and understand the old EBS 11i system and custom objects.
• Identify all custom objects and prepare the documentation to support the R12 upgrade system
• Prepared the technical documentations for the custom objects to support the R12 system.
• Worked with the data mapping and environment set up for the Upgrade.
• Work with functional setups in the R12 system part of this upgrade process.
• Worked with the custom integrations and upgraded AP Invoices, AR Invoices, Bank interfaces and GL Interface.
• Actively involved and support end to end custom integrations upgrade process.
• Involved in customization of Payment process for checks and ACH.
• Created Templates, Payment Process documents. Also customized the .rtf documents to support the Essent and Triad check payments as per bank standards.
• Extensively with Positive Pay and NACHA custom payment processes and involved with multiple bank associates while in the process of ACH format approvals.
• Work with functional setups in the R12 system part of this upgrade process.
• Responsible for review and preparing the test scenarios and documentation.
• Involved in end to end testing with all custom integrations.
• Actively supports multiple CRP’s before going to the UAT.
• Involved in development, code reviews and unit testing.
• Developed and customized Oracle and XML Publisher reports as part of the upgrade using Different modules.
• Developed Mapping, technical development and Installation documentation using AIM Methodologies.
• Worked with testing, user training and Development documents.
• Supported pre production system while testing and training with the new R12.
• Extensively used SBM for support tracking system and Serena PVCS for code migrations.

Environment: Oracle APPS R12, Oracle 9i/10g/11g, Reports 6i/10g, XML Publisher, PL/SQL, Shell Script, Workflow, Serena PVCS SBM, Accounts Payables, Accounts Receivables, General Ledger, Cash Management, Purchasing Order.

Confidential, Cincinnati, OH

Techno-functional Analyst

Responsibilities:

• Worked with CRM OD/AccPac system and Champion business users to understand the system.
• Worked with the data mapping and environment set up for the data integration.
• Work with functional setups in the R12 system as per the integration requirement.
• Created required X-reference files and tables for the Integration.
• Implemented Invoices integration end to end process for CRM OD and AR Integration by using Auto Invoice and Invoice API.
• Implemented Receipts integration end to end process for CRM OD and AR Integration using receipt API.
• Implemented different Deposits, Receipts, Adjustments, Refunds and Reversals integrations with R12 using different AR standard API’s.
• Actively involved in implementation of customer integration using Customer API.
• Integrated AccPac Invoices, Receipts and Customers to the ERP.
• Involved in AP integration and post production support for AP Invoices.
• Developed SQL*Loader control files to load the legacy data to the Staging table.
• Involved in development, code reviews and unit testing.
• Developed and customized Oracle, Discoverer and XML Publisher reports as part of the integration using Different modules.
• Developed Mapping, technical development and Installation documentation using AIM Methodologies.
• Worked with user training and Development documents.
• Support Pre and Post production.

Environment: Oracle APPS R12, Oracle 9i/10g, Reports 6i/10g, XML Publisher, Discoverer 9x, 10g, PL/SQL, Shell Script, Workflow, Accounts Receivables, General Ledger, Accounts Payables, Purchasing Order, Cash Management.

Confidential, San Jose, CA

Techno-functional Analyst

Responsibilities:

• Understanding the Cisco 11i system and new R12 System and worked with the Cisco business to gather the business requirement and recommended for the new and missing requirements with respective Cisco localization implementation.
• Worked with the Brazil business team and Synchro support team to understand and design of the solution.
• Designed functional and technical specification documents in different areas
• Lead onsite and offshore teams and share / translate the requirements and support for the development.
• Work with the Auto Invoice, which includes pre, standard and post process.
• Worked with Synchro solution as part of the Brazil legal requirements to get the approvals for the Nota Fiscal (Invoice)
• Designed batch sources and Transaction types which required for the localization, especially to support for the Auto Invoicing and Nota Fiscal approval.
• Analyzed and recommended required DFF to support the Auto Invoice and Approval process.
• Design the extensions that required for Synchro integration to extract data for sending approval and importing status data from Synchro.
• Worked with BPEL to integrate Synchro tool with Oracle Application R12.
• Work with the cross function support teams where approval process impacting. Example with Auto lock box, create accounting, Revenue reorganization, Credit check and collections.
• Worked with data mapping which required for the localization and Nota Fiscal (Invoice) approvals.
• Worked with the Customer TCA and HZ schema to maintain the Brazil customer data.
• Involved in order creation to make sure that is creating properly as per the Auto invoice requirements and supports the Brazil legal requirements.
• Worked with Custom NG CCRM development.
• Actively involved in up gradation of Contract Management system (CMS) to ECLM system with respective to NG CCRM.
• Involved in designing NG CCRM and ECLM / CMS integration to get the contract information to the NG CCRM.
• Involved in code reviews and unit testing.
• Worked with the team and designed End-to-End business flow for supporting to complete project.
• Effectively used Kintana Project Propel Management (PPM) tool in the development activity to get quick solution from internal, external and X functional teams.
• Worked with the IBM offshore teams and sharing the knowledge in designing the solution documents.
• Developed Functional specification documents (FSD), Technical Specification documents (TSD) and Test Scripts.
• Involved in different Test cycles to support the development activity.
• Effectively used HP Quality centre tool to track and support the testing activity.

Environment: Oracle APPS R12, Oracle 9i/10g, Reports 6i/10g, XML Publisher, PL/SQL, Shell Script, Accounts Receivables, General Ledger, Purchasing Order, Inventory, Order Management, Project Accounting, BOM, Shipping, Collections, e-Credits and CLM, Service Contracts, Install Base, BPEL, Synchro NFe Manager, Project Propel Management (PPM), HP Quality Centre.

Confidential, Santa Barbara, CA

Techno-functional Developer

Responsibilities:

• Worked with business users to understand the current system and worked with the AHNU team to understand the data.
• Worked with Genero Desktop Client (GDC) to extract the data from the AHNU Legacy system.
• Worked with the data mapping and environment set up for the data conversions.
• Work with functional setups in the R12 system as per the conversion requirement,
• Created required X-reference files and tables for the conversions.
• Extensively worked with the AR open Invoices conversion end to end process for converting AHNU AR Invoices.
• Extensively worked with the AP open Invoices/ Payments conversion to bring AHNU AP Invoices.
• Involved in working with the Open PO conversion.
• Analyze the Project Account related invoices while these conversions.
• Worked with the customizing work flows.
• Developed SQL*Loader control files to load the legacy data to the Staging table.
• Involved in code reviews and unit testing.
• Developed required .ldt, Shell Scripts, .ins for installation support.
• Developed and customized Oracle reports and XML Publisher reports as part of the integration using Different modules.
• Customized existing Discoverer reports after the AHNU Conversion to bring some AHNU specific data.
• Developed Mapping, technical development and Installation documentation using AIM Methodologies.

Environment: Oracle APPS R12, Oracle 9i/10g, Reports 6i/10g, XML Publisher, Discoverer 9x, 10g, PL/SQL, Shell Script, Demantra, Workflow, Accounts Receivables, General Ledger, Purchasing Order, Inventory, Order Management, BOM.

Confidential, Cupertino, CA

Techno-functional Developer

Responsibilities:

• Worked with users and functional teams to understand the current system.
• Worked with the business users and functional team to gather the requirements.
• Translate requirements to the team and lead in application development and support activities.
• Developed, Customized and involved in the support for the conversions to the custom system which was involving Payable, General Ledger, Receivables, Project Accounting, Billing, Order Management, Service contracts, install base and custom modules.
• Worked with Financial Accounting Hub (FAH) to create detailed reconcilable accounting for external source systems.
• Involved in Support and maintenance of sales order interface to Shipping and AR module.
• Developed custom Interfaces to load the daily data from the different regions to the custom system.
• Developed the process to splits the amounts to their related products based on their percentages.
• Developed the payable process to the rep groups after the product splits happened.
• As part of this payable process created a custom code to calculate the payable amounts and loading to the Interface tables and used Payables Open interface to load the data to the base tables.
• Developed and customized procedure, packages, triggers, concurrent programs and value sets as part of the development.
• Developed data scripts as part of data validation and missing/ history data loads.
• Customized and developed DRR, Oracle reports, XML Publisher, and Discoverer reports.
• Developed SQL*Loaders control programs to load the data.
• Involved in development of Snapshots to refresh the data from various systems.
• Worked with the various levels of documentation and approvals.
• Involved in code reviews and unit testing.
• Developed various levels of documents for Technical design and Unit testing.
• Worked with Per Force for code Migration for different levels after development.
• Involved in unit testing.

Environment: Oracle APPS 11.5.10, Oracle 9i/10g, Reports 6i/10g, XML Publisher, Discoverer 9x, 10g, PL/SQL, Shell Script, Accounts Receivables, General Ledger, Purchasing Order, Inventory, Order Management, Service

Confidential, CA

Techno-functional Developer

Responsibilities:

• Worked with users and functional teams in gathering requirements.
• Understanding the requirement and develop the MD 50.
• Developed Database triggers on Item tables when any updates or inserts happened in the critical attributes. This will update a custom table with the updates or new items.
• Involved in developing the custom forms using OAF to monitor the updates against Attribute.
• Customized Order/Invoice detail report, Order by item report, Sales Order Workflow status Report, Order on credit check holds Report in Order Entry/Management.
• Customized and developed Discoverer custom reports.
• Extensively used Discoverer administrator and Discoverer desktop versions.
• Developed Business Area for Revenue reorganization.
• Customized business areas simple and complex folders using discoverer administrator and customized and created new reports using Desktop.
• Developed and Customized Business Areas for fixed assets, Cash Management, Order Management, Project Accounting, Project Billing and Service contracts.
• Generated ad-hoc reports in end user layer.
• Developed XML Publisher reports using custom tables to find the updates and new items.
• Customized Oracle 6i Reports as per the business requirement.
• Developed various level of documents like MD070 for Technical design, TE020 for Unit and Functional testing, MD120 for Installation.
• Worked with Kintana and CVS code Migration tools to migrate the code for different levels after development.
• Involved in report unit testing.

Environment: Oracle APPS 11.5.10, Oracle 9i/10g, Reports 6i/10g, XML Publisher, Discoverer 9x, 10g, PL/SQL, Shell Script, Accounts Receivables, Gene ral Ledger, Purchasing Order, iProcurement, Inventory, Order Management, Service Contracts, Costing, Projects Accounting, Cash Management, fixed Assets.

Confidential, Solon, OH

Techno-functional Developer

Responsibilities:

• Understanding the Existing and Legacy system
• Worked with the functional team while extracting non-Oracle data and Converting to Oracle with validations.
• Work with functional setups to create AP invoice sources, Accounting flex field, Chart of accounts.
• Customized various transactions in Accounts Receivables like Invoices, Receipts, Credit Memos and Debit Memos etc.
• Designed and developed Journal Import interface to import journals from legacy system.
• Have Good understanding of Reconciling, Period Close Processes, Global Accounting Engine, Billing and pricing Engine across various Modules.
• Worked with Financial Accounting Hub to create detailed reconcilable accounting for external source systems.
• Extensively work with the RICE components.
• Worked with the GL Journal Import, AP Invoices, AR Invoices, Item conversions.
• Worked with the auto lockbox interface in receivables in order to transfer receipts from bank to AR.
• Worked on Oracle Order Import API to validate and load the PO information from the interface tables into Oracle Order Entry (OE/OM).
• Created custom program for creating internal sales orders.
• Customized standard Reports in Order Entry/Management to segregates the different companies data.
• Worked with functional team to prepare the chart of accounts cross-reference data to load the chart of accounts, Journals data and Invoices data.
• Developed SQL*Loaders control programs to load the data from Legacy data to the Temporary table
• Developed PL/SQL Programs to validate data and insert into the interface tables. Then used standard import programs to load the data from interface tables to base tables.
• Support the users when loading AP Invoice and other payment activities like printing payment registers and checks.
• Worked in customizing the Expense report that shows the different brad and expense type information for each.
• Customized standard and existing custom reports that will bring or segregates the different companies data. Like Checks printing reports, Dunning letters, Tax which includes property tax Reports, 1099 form reports to IRS and Supplier, Bank Reconciliation, Assets Retirement, Cash Forecasting, etc.
• Customized and created new reports for Payment, Invoice using advanced collection modules.
• Extensively used Discoverer administrator and Discoverer desktop versions.
• Developed and customized business areas and custom folders using discoverer administrator and customized and created new reports using Desktop.
• Generated ad-hoc reports in end user layer.
• Extensively worked with the XML Publisher reports development, Customization and support.
• Developed new Custom Oracle 6i, SQL, PL/SQL Reports as per the business requirement.
• Extensively worked with the analysis and documentation R12 future up gradation using R12 vision database.
• Analyze and provided documentation of the new table structure in R12, schemas, reports and XML publisher modifiable formats in financials.
• Working with creating snapshots for Open Orders Data, Purchase Orders, Advance Planning, Forecasting, Inventory Measures and Item Master.
• And Developed Concurrent Programs and PL/Procedures to refresh those snapshots and sending email to the business owners about the status.
• Involved in Developed Advanced Shipment Notice (ASN) process and printing.
• Worked with creating extension forms using OAF to ASN.
• Designed and Developed the Commission payments project, which loads the all rep groups and percentages information to the custom tables. And calculations of the commissions on each customer transactions for all rep groups, and process to that commission payments
• This Commissions project required couple of custom reports to verify and signoff commission calculations and before loading Payment information to the AP interface tables.
• Developed new and customized existing Oracle and Discoverer reports as per the user request.
• Involving in testing existing FSG reports.
• Developed AIM Documentations for the components.

Environment: Oracle APPS 11.5.10, R12, Oracle 9i/10g, Reports 6i/10g, XML Publisher, Discoverer 9x, 10g, PL/SQL, Shell Script, Accounts Payables, Accounts Receivables. Gene ral Ledger, Purchasing Order, Fixed Assets, Cash Management, Inventory, iProcurement, Advance Planning, Order Management

Confidential, Glendale, AZ

Techno-functional Developer

Responsibilities:

• Extensively worked with tuning for Custom PL/SQL Packages, SQL and .rdf Reports.
• Worked with multi language support systems and set up different Lookup Types and makes use for printing different language.
• Extensively worked with the development of RICE components
• As part of the upgradation work with the AP Invoices Conversion to convert the invoices data
• AP Invoice Interface to load Payables Invoices from legacy system
• Worked with Bechtel P11D Payables Extracts to extract the payables data and sending the data file to the assigned users (in PD11) by using SEND EMAIL shell Scripts.
• Developed Bechtel payment and invoice Reports
• Worked with Upgrading FA reports and adding language specific data on the reports for China.
• Worked with Asset retirement, depreciation reports in Fixed Assets.
• Worked with Cash Management Bank Reconciliation, Cash Forecasting and Cash positioning with Bank wise details reports.
• Involved various labor and non-labor reports in custom CARDS system.
• Worked with Snapshot refers programs. This will download the data from different systems and refresh all the snapshots and send alerts on the status of the refresh to the assigned users.
• Worked with the custom workflow to sent approvals for the employee status updates to the respective manager.
• Extensively work with deferent Reports using, XML Publisher, SQL, .rdf and PL/SQL Packages.
• Involved with support team for Post GO-Live issues and production issues.
• Worked more interactively with the international users when gathering the requirements, testing and knowledge transfer on new developments.
• Extensively used Harvest Change Manager Version control system for code moving.
• As part of the Customer Support team have used Serena Customer Support Issue team Track. By using this any one can track the status of the issues and can follow-up for the further movement
• Involved in Technical documentation while in the upgradation process.

Environment: Oracle APPS 11.5.9, Oracle 9i & 8i, Forms 6i, Reports 6i, XML Publisher, PL/SQL, Shell Script, Accounts Payables, Accounts Receivables. Gene ral Ledger, Purchasing Order, Fixed Assets, Oracle Lease Management (OLM), Cash Management.

Confidential, Arlington, VA

Techno-functional Lead/Developer

Responsibilities:

• Worked with the Client and Functional team to understand the requirements for the business change.
• Lead onsite and offshore teams and share / translate the requirements to support the development.
• Work with the AP Invoices Conversion to convert the Open and History invoices data in the same instance from all the eGroup set of books to the ebank set of book.
• Work with the GL Journals Conversion to convert the Open and History data in the same instance from all the eGroup set of books to the ebank set of book.
• Worked with the auto lockbox interface in receivables in order to transfer receipts from bank to AR.
• Understand the Existing custom RICE (Reports, Interfaces, conversions and extensions) components.
• Understanding the new system and requirements and Prepare the documentation for the changes required to run those components for the business changes.
• Onsite Coordinate with the offshore team to knowledge transfer built support and code review.
• Actively involved in new development, customizations, implementation and AIM Documentation of various RICE components.
• Worked with Custom interfaces in AP, AR, GL, PO and made changes against the code to make it run after the merging.
• Worked in customizing the ADP Payroll and ETRADE Pro Finance Auto GL Journal Import Interface.
• Worked with FedEx Invoice upload and Custom extensity expense report import interface.
• Worked in customizing Mutual funds and Receivables outsourcing invoice Interface.
• Worked with Custom Reports in AP, AR, GL. And made changes against the code to make it run after the merging.
• Worked with the Discoverer Business Areas and folders to updating the report queries after merging set of books.
• Developed the technical specification documents for each and every Interface, Report that required changes when comparing with the existing built.
• Involved in code reviews and unit testing.
• Involved in testing of changed components to test the functionality.

Environment: Oracle APPS 11.5.10, Oracle 9i, Forms 6i, Reports 6i, Discoverer 9x, PL/SQL, Shell Script, Accounts Payables, Accounts Receivables. Gene ral Ledger, Purchasing Order, CVS Version Control system.

Confidential, Washington DC

Oracle Reports Developer

Responsibilities:

• Thoroughly understand the legacy reports and client requirement.
• Prepared the design for the new reports layout.
• Work with the users to under stand the functional requirements to develop the functional documents and will technical documents.
• Worked with the third party Oracle Compusearch Interfaces (OCI) to get the reports for the electronic payment approval process system.
• Mapped the legacy report data element s to the Apps database and developed the SQL for the reports.
• Compared the Existing legacy reports and reports requirements with the Existing Standard reports and the find the gaps.
• Worked with custom extensions for oracle standard reports.
• Developed the functional and technical specification documents for each and every report.
• Developed reports using oracle reports builder 6i.
• Developed many custom reports for excel output based on requirements.
• Responsible for the Unit Testing and Trouble Shooting of the issues of the developed custom reports.

Environment: Oracle APPS 11.5.10, Oracle 8i, Forms 6i, Reports 6i, PL/SQL, Shell Script, Oracle Receivables, Oracle Lease management, Accounts Payables, Gene ral Ledger, Purchasing Order.

Confidential, Atlanta, GA

Reporting Consultant

Responsibilities:

• Communicate with all process leads and gather the report requirements.
• Thoroughly understand the requirements and prepare the workbooks.
• Developed Functional solution documents MD50, CF250.
• Analyze Oracle standard functionality reporting capability and recommended reporting tools.
• Providing the possible solution and recommend the required reporting tools.
• Compared the Existing reports and reports requirements with the Existing Standard reports and the find the gaps.
• Worked with Asset retirement reports in Fixed Assets.
• Worked with Cash Management Bank Reconciliation, Cash Forecasting reports.
• Worked with purchasing cost, invoice matching with Purchase Order, Site-specific Supplier, Open PO buyer reports in Purchasing module.
• Mapping data elements to the standard Oracle report fields
• Onsite Coordinate to work with the offshore team to knowledge transfer and development support.
• Involved in documents and code reviews.
• Developed Technical solution documents MD200.
• Developed Unit Test scripts TE 20.

Environment: Oracle APPS 11.5.10, 11.5.5, Oracle 8i, Reports 6i, Brio Hyperion Designer, Discoverer 4.1, PL/SQL, SQL* Plus, Accounts Payables, Accounts Receivables, Gene ral Ledger, Purchasing Order, Fixed Assets, Cash Management, Lease Management, Project Accounting.

Confidential, Palo Alto, CA

Technical Consultant

Responsibilities:

• Designed, developed tuned AR Monthly rolling revenue report,
• Carry forwarded customizations from 11.5.5 to 11.5.10.
• Customizations of Project Accounting Periods report.
• Customization of Sub time Report.
• Responsible for designing, developing, unit testing, implementing and maintaining the custom extensions for Oracle Applications.
• The Extensions included the interfaces, conversions, customization of forms and reports.
• Worked on item conversion on Inventory Modules
• Developed OCI, custom reports and user support
• Used SQL*Loader to load data from flat files
• Investigation on Apps Forms, Reports for possible Impacts while upgrading the system
• Production support and user assistance while in upgrading the Oracle Applications
• Work with the database Synchronizing for the investigation purpose to find the Discrepancies
• Synchronizing the all existing Brio Data Models (BQY) for the investigation purpose to find the Discrepancies against the 11.5.10
• Process different queries on impacted tables columns and check with the two different Apps data base instances 11.5.5 and 11.5.10
• Find the alternate tables columns for Impacted tables and columns
• Prepare the Documentation on the Impacted tables columns and possible achievements for the discrepancies.

Environment: Oracle APPS 11.5.10, 11.5.5, Unix, Window NT, Oracle 8i, Reports 6i,Forms 6i,TOAD, Brio Hyperion Designer, SQL*Loader, PL/SQL, SQL* Plus, AP, AR, GL, PA, FA, Order Management, Procurement, Manufacturing.