SUMMARY:

• 13 Years of extensive experience in Analysis, Design, Development, Testing, Customization, Bug fixes, Enhancement, Support and Implementation of Oracle Applications 11i and R12.
• Experience as a Techno - Funcitional consultant/Architect in Oracle EBS with major focus on HRMS, Financials & SCM, General Ledger(GL), Accounts Payables(AP), Account Receivables(AR), Property Manaer (PN), Project Accounting(OPA) & Oracle Time and Labor (OTL), Cash Management(CM), Fixed Assets (FA), Order Management (OM)Inventory (INV), Bill of Materials (BOM), Work in Process (WIP), Project Accounting(PA) and Procure to Pay (P2P) cycle, Record to Report (R2R) and Order to Cash Cyscles (O2C).
• Extensive experience in RICEW components, TAR support, UNIX, Oracle SQL/PLSQL, Workflow, Forms and Reports 6i and SQL Loader, Project assignements include Implementation, upgrade, conversion and support of Oracle Apps systems.
• Extensive experience in creating Discoverer Reports/ XML Publisher(BI Publisher) reports and OBIEE/OBIA using various templates to publish the reports as per user requirements
• Good experience in requirements gathering, Design, Development of custom applications in Oracle application framework (OAF).
• Extensive experience in Oracle Application Object Library (AOL) features like value sets, Flex fields, Concurrent Programs, Profile Options, parameters and standard request submissions in the process of development. and Alert Manager and invoking them from the different applications.
• Having the good experience in all the Conversion/Interfacing activitieis using the API’s and open interfaces in R12 with the core subject of Trading Community Architecture (TCA).
• Strong experience in HRMS integrations with Salesforce/Workday..
• Expertise in inbound and outbound interfaces and creation of automated process using Application Program Interfaces (APIs) and developing the WebADI’s to import the data from flat files.
• Completed the Project Management Professional(PMP) training and involved in workshops, involved in designing the white papers for the project orientation programs.
• Involved in designing the process flow for the legacy systems and creating the bridges between the legacy systems to oracle applications.
• Having the strong experience in OLTP (On-Line Transaction Processing) and OLAP (On-Line Analytical Processing)
• Designed and developed the release process for the objects migration using the various tools and created the centralized documentation.
• Very strong experience in understanding the business, requirements, GAP analysis & Mapping and led the POC for several complex business processes and Data Integrations/CEMLI/RICEW/BI/OBIEE/OBIA.
• Hands on experience with Oracle Discoverer which includes report development, Discoverer Administration, configuring Discoverer and End User Layer (EUL).
• Managing the Sandbox and performed the DBA activities to create the user, roles etc., within the organization and Involved in the all the conversion activities from 11.5.10 to R12 migration as a part of Internal activities.
• Having the good experience in developing in developing the FSG (Financial Statement Generator Reporting (FSG).
• Experience in Oracle Practice Presales, leading coordinated effort for bid management and related activities like solution creation and coordination, knowledge management, quality assurance, presentations, proposals etc in the Oracle practice areas.

TECHNICAL SKILLS:

Operating Systems: UNIX, Windows NT/95/98/2000 Advanced Server, MS-DOS

RDBMS: Oracle 11G/9.x/ 8.x/SQLServer7.0

Application Tools: Reports & Forms 6i, Discoverer 9i, XML/BI Publisher, SQL*Loader,Microsoft VISIO.

ERP: Oracle E-Business Suite EAM (AP/GL/AR/ OPA/OTL/CM/PO/OM/INV,iReceivables, iProcurementiExpenses, HRMS/PAYROLL ):

Languages: PL/SQL,J2EE, C, C++

Internet Technologies: Java Script, JSP, HTML,PythonTools: xManager, TOAD, PVCS, CVS/SVN, Kintana, SQL Navigator, SQL*Loader, FTP, Putty, Filezilla

PROFESSIONAL EXPERIENCE

Sr. Oracle Apps Techno functional Consultant/ Lead Consultant

Roles & Responsibilities:

• Involved in developing and customizations in Procurement to Pay & Order to Cash (PO/AP/AR/GL/CM/OM)
• Conversions from the Legacy systes for the AP/GL/PO.
• Analysis/Design/development on Integrations with 3rd party systesms.

Upgradation activities

• Designing and developing the process for the Upgradation of EBS version from 12.2.3 & 12.2.4 to 12.2.6
• Identifyig the objects impact and retrofitting accordingly.
• Extensively worked on OAF Extensions as part of 12.2.6 upgration activitiy for the below areas.
• iProcurment
• iSuppliers
• iExpenses
• Identifying and modifying the existing AOL Objects to meet the customizations for 12.2.6.
• Involved in modifying the custom.pll and forms according to 12.2.6

Online Patching:

• Involved on object analysis, design and developing the scripts - Unix/SQL/Java/JSON
• Running the standard scripts/reports and preparing new scripts - Part of object analysis and identification
• Creating the shell scripts/sql scripts/Java scripts -- Part of retrofitting the Database/AOL Objects
• Involved in developing the Bank statement Import process for EMEA region.

Monitoring Activities

• Involved and developed the programs/scripts for the following.
• concurrent program job failures.
• Long running jobs
• Auditing reports
• Validation reports

Integrations/Development activtiies

• Involved in designing and developing the database for the the Confidential 3rd party application and also integrated with EBS.
• Involved in designing and developing the iBank 3rd party application which source for all the transactions in EBS.
• Involved in merging the legacy applications with iProcurement and developed the interfaces for the requisition/PO interfaces on schedule manner.
• Created the generic shell script by replacing all the shell scripts from P2P.
• Developed the mailer notifications based on the customer language for the following.
• Supplier onboarding
• Supplier Login Access related
• On creation of Banks/Sites or Both

Sr. Oracle Apps Techno functional Consultant/ Solution Architect

Responsibilities:

• Converting the existing reports to Cloud IO reports.
• Desinged and developed the integration b/w workday/documentum/DWH to Oracle Applications.
• AP Invoice Integration.
• Supplier Integrations
• Employee Integration
• Developing the generic Unix shell scripts for all the workday integrations (HRMS) using the SFTP functionality.
• Creating and and developing the daily alert mailer programs as a part of monitoring process.
• Involved in developing the reports in OBIEE for the external systems data(ETL).
• Preparing the Technicla design documents for the new enhancements for the Procure to Pay and Order to Cash modules.
• Involved in developing the Dashboars in OBIA
• Created the new programs for the User/Resp assignments - AOL activities.
• Involved in designing and developing the New reports in Suppli Chain (SCM).
• Designed and developed the Concur Integration /Workday Integrations with Oracle EBS R12.
• Working with Concur team in designing and developing the data feed mapping.
• SFTP ssh key adding/ developing the shell script for the integration.
• Developing the PLSQL Package and Invoice Import programs.-Financials
• Mailer program with the status of the Imported invoices data and failure records with validation errors.

Offshore activities

• Working with offshore in design/development on new enhancements with ETA’s.
• Developing the Technical design documents and working with offshore team in development activities.
• Prioritizing the Enhancements/Issues and working with team to complete based on the time lines.

Sr. Oracle Apps Techno functional Consultant/ Tech Lead Consultant

Responsibilities:

• SPOC for the business users/functional team in all the development activities, estimations/coordination/Leading the offshore team.
• Supporting for all the applications for US/EMEA regions.
• Involved in connection establishment b/w Oracle applications & JD Edwards for Sales Orders & Purching modules.
• Developing the Inboiund/Outbound Interfaces b/w Oracle & JD Edwards
• Developing the reports/Interfaces/.conversion/unix scripts/OAF pages/ADF pages in Oracle Applications R12.1.2 Financials & Supply chain modules.
• Developed the Shell scripts for the Integration activities.
• Integration and Item Master Conversion/Import Process
• Customization of Auto Invoice Import Program
• Sales Order/Invoice Processes using EDI Integrations
• Preparing the BR100 documents for all the future enhancements & developing the Design plan.

Sr. Oracle Apps Techno functional Consultant/ Tech Lead Consultant

Responsibilities:

• Designing and developing the process for the all the oracle integrations (legacy systems).
• Developing he Unix scripts on FTP/SFTP processes and created the Generic script for all the Integration Scripts.
• Involved in designing and developing the custom interfaces for the Legacy systems in Purchaseing, Payables,Projects.
• Designed the process flow for the release activities and involved creating the centralized documentation.
• Developed the FA Automation Process with the following functionalities.
• Closing all the books at a time.
• Closing the books based on the Regions (APAC/AMER/EMEA).
• Consolidation reports once closing completed
• E-Mail Notifications to Group leaders for APAC/EMEA/AMER.
• Created the Shell scripts to create the directory for period wise and gathering all the report outputs.
• Created the Shell scripts for validating the report outputs and generating the status mail to business.
• Status of Errors in case of any book failed to close
• Developing and customization of the Reports, Interfaces, Workflow components (RICEW components) and Discoverer reports and SQL reports.
• Involved in designing the below integrations & Interfaces.
• Daily Rates Interface
• Bank statement Import
• Invoice Interface
• Developed the design and documentation for dwh/workday/BI programs.
• Designed and developed the Concur Integration with Oracle EBS R12.
• Working with Concur team in designing and developing the data feed mapping.
• Developing the daily/weekly/monthly expense reports in EBS. Scheduling and pointing the SFTP location.
• Importing the data from the GL Currency converstion rates.
• Developing the Prevalidation and Journal Import program to upload in EBS.
• Mailer programs with status and validation reports.
• Designing and developing the below reports.
• Purchasing Reports
• GL Reports
• PA Summary Reports
• PA Transaction Detail Report
• PA Project Planning Reports
• PA Essbase Extract Report
• SPOC for the business users/functional team in all the development activities, estimations/coordination/Leading the offshore team.

Environment:Client server application written in Oracle running on UNIX. Oracle Apps 12i, SQL,PL/SQL,DEVELOPER 2000(FORMS-6i-10g,REPORTS-6i -10g, Discoverer, XML Publisher SQL * Loader, Toad 7.1.7.2 -9.0, SVN Tortoise, CVS, D2K and Dev Suite 10g,BPEL,SOA, Connectivity VPN Client, Microsoft Office.

Sr. Oracle Apps Techno functional Consultant /Lead Consultant

Responsibilities:

• Developed the Reports in Purchasing using the XML Publisher.
• Developed the reports in Payables for the invoice amounts/debts for the critical customers.
• Developed the Customer Conversion using API’s.
• Developed the Custom program in Inventory on Item build for multiple palnts.
• Involved in customization of the OAF pages in Oracle receivables.
• Involved in all the below setups using the data loader.
• Sub inventory
• Shipping Networks
• Cycle count Aliases
• WIP Account Aliases
• Supplier Conversion
• Invoice Conversion
• PO Conversion
• Customizing the Auto Invoic Import Program
• Reciepts interface/conversion.

Sr Oracle Apps Techno Functional Consultant- Lead Consultatnt

Responsibilities:

• Extensively worked on Accounts Payables (AP), Accounts Receivables (AR), General Ledger (GL), Order Management (OM).
• Involved in customization of the existing Open Invoice Import program (AP) using the 3rd party tool to dump the data in Oracle Applications.
• Created the New program for the Journal Import (GL) for the Journals data from legacy systems.
• Involved in designing and customizing the Workflow Notification process for the Project Approval Workflow for PA, PM and FA in Project Accounting (PA).
• Played the Major roles in implementing the Vertex/Sabrix Tax system in Oracle Receivables (AR) and creat
• ed the new tax programs for uploading the files from downloading vertex universal locator
• Worked on the third party Integrations such as IBS, Documentum, MES, and SSS for both Inbound and Outbound Interfaces in Purchase Order Module and Receivables Modules (PO and AR).
• Implemented Auto Lock Box by importing data into staging table by writing control file according to bank transmission format.
• Worked on requirement gathering, design and development of custom application Supervisor Information Management System (SIMS) in OA framework.
• Worked extensively in custom.pll and form personalization for the sales order, customer standard forms.
• Involved in development of new interfaces/reports/customization of the existing reports using the XML Publisher reports in P2P, Order to Cash (O2C).
• Created the lookups/DFFs/Valusets and uploaded the values to identify the critical customers based on the requirement in Inventory (Inv).
• Designed the custom program to cancel the sales order Booked/Pick Release statuses in Order Management and created the oracle alerts & Notifications on the order status for Booked/Pick release in OM.
• Extensively worked on Supporting activities ie Breakfixes/Enhancements and implemented the permenant fixes with repository documentation.

Environment: Client server application written in Oracle running on UNIX. Oracle Apps 12i,11i, SQL,PL/SQL,DEVELOPER 2000(FORMS-6i-10g,REPORTS-6i -10g, XML Publisher SQL * Loader, Sql Developer, SVN Tortoise Tool, CVS Tools, GE Libraries.

Sr.Oracle Applications Techno Functional Consultant/Architect/Lead Consultant

Responsibilities:

• Extensively worked on Order to Cash & Procure to Pay - Order Management, Inventory, Bill of Materials and Work in Process & Accounts Payables, Accounts receivables, General Ledger.
• Customized the existing interfaces in Order Managements.
• Sales Order Import program
• Receipts Interfaces
• Auto Invoice Import Program
• Customized the below reports in Order Management using the BI/XML Publisher report
• Sales Order Acknowledgement report
• Bill of Lading
• Pick Selection List Generation
• Pick Slip Report
• Shipping Execution reports
• Extensively worked on Procure to Pay (P2P), Accounts Payables (AP), Accounts Receivables (AR), General Ledger (GL), Cash Management (CM).
• Extensively worked on devolping/customized RICEW, XML/BI Publisher components in Procure to Pay (P2P), Order to Cash (O2C).
• Created the Shell Scripts to invoke mailer notifications for the standard/custom program for Monitoring activities.
• Involved in designing and developing the Bank Statement Import program in Cash Management (CM).
• Designed and developed the new interface for Kelly Open Invoice Import program (AP) from the Legacy system.
• Customized the reports ie Order Detail Report, Credit Order Summary Report, Orders by Item Report in Order management in oracle rdf and xml publisher.
• Designed and developed custom program to load EDI 850 inbound Orders into Order Management.
• Customized the Credit Analysis Report, Trucking Manifest and Pick Slip reports in Order Management OM.
• Involved in Performance tuning and explain paln to improve the performance by analyzing the trace file/tkprof.

Environment:Client server application written in Oracle running on UNIX. Oracle Apps 12i,11i, SQL,PL/SQL,DEVELOPER 2000(FORMS-6i-10g,REPORTS-6i -10g, XML Publisher SQL * Loader, Toad 7.1.7.2 -9.0, D2K and Dev Suite 10g,BPEL,SOA, Connectivity VPN Client, Microsoft Office

Oracle Applications Techno-Functional Consultant

Roles and Responsibilities:.

• Involved in the folllwing data conversion activities
• i) Customer Conversion ie Extracting the Data from Legacy & 11i Systems and Import.
• ii) Supplier Conversion, Extracting fro 11.5.9 and importing the data into Oracle R12.1.3
• iii) Extracting Buyers data(PO) from 10.7 legacy applications and Importing process
• iv) Extracting the PO Approval Hierarchy (PO) data from the 10.7 and importing process
• v) Developed Conversation activities for Employee Conversation activities (HRMS).
• vi) Involved in developing the custom package validations to track additional information for employee
• and storing the custom DFF’s and plug in the Assignment form.
• Modifying the existing reports prior to converting to R12 based on the table and columns mappings.Involved in preparing the custom lookups and DFF’s to map the columns with target systems prior to loading.
• Personaliztion done for few of the Customer forms to plug the additional columns using the DFF’s and validating from
• PLSQL Package to accommodate the client changes.
• Involved in preparing the coding standard docuaments, delivery packages, repository documents etc.,

Environment:Client server application written in Oracle running on LINUX. Oracle Apps 12i,11i, Polar Application, SQL,PL/SQL,DEVELOPER 2000, GCN,Sun Specific tools, SQL * Loader, Toad etc.,

Oracle Applications Technical Consultant

Roles and Responsibilities:

• Extensively worked on RICE components (Reports, Interfaces, and Conversions).
• Involved on this project and given the support for APAC region in the financial modules and Oracle Project Accounting (OPA).
• Involved developing the interfaces FFD, FEX, FPO, FEB in OPA 11.0.3
• Developed the tool i.e polar application to raise the requisitions for user friendly.
• Creating the object delivery package and creating the LDT scripts for the concurrent program and request group.
• Developed the and documented the time estimation report for all the objects development.
• Involved in developing the Mail program to transfer the all the purchase orders based on the business validations.

Environment: Client server application written in Oracle running on LINUX. Oracle Apps 12i,11i, 11.0.3, 10.7 Polar Application, SQL,PL/SQL,DEVELOPER 2000, REPORTS-6i -10g, XML Publisher SQL * Loader, GCN,Sun Specific tools, Toad, Putty etc.,

Oracle Applications Technical Consultant

Roles and Responsibilities:

• Involved in requirement gathering, analysis, design, planning, documentation, estimation and resource allocation.
• Actively participated in implementing the Property Manager Module upto end.
• Designed and developed the following Conversions.
• Property Conversion
• Location Conversion
• Lease Conversion
• Assignment Conversion
• Developed the alert mechanism for
• Payment expiry
• Lease expiry
• Insurance Expiry Alerts and user notification mails.
• Involved in the Form Personalization for the Assignment, Building, Floors, Offices Screens and the Property Screens and involved in creating the Employee Eligibility Criteria for the forms etc.,
• Involved in preparing base Report which contains the whole existing module information based on the filter criteria using the XML Publisher.

Environment: Client server application written in Oracle running on LINUX. Oracle Apps 12i, SQL,PL/SQL,DEVELOPER 2000, GCN,Sun Specific tools, SQL * Loader, Toad etc.,

Oracle Applications Technical Functional Consultant

Roles and Responsibilities:

• Involved in Developing all the Reports in rdf’s & XML Publisher
• Involved in the data Migration Activities from the Feeder Systems DMS, NGSC, RAPID etc., for all the outstations.
• Interfacing the data using the TIBCO for the AP & AR Interfaces.
• Preparing the Technical Documentation.
• Involved in all the activities developing, customization, implementation, Migration activities.
• Preparing the Delivery package and moving all the objects into the production using the ldt scripts and shell scripts.
• Implemented conversion and reports in Property Manager (PN) Module.
• Extensively involved in integrations with Financial modules including Property Manager.

Environment: Client server application written in Oracle running on LINUX. Oracle Apps 12i,11i,, SQL,PL/SQL,DEVELOPER 2000, GCN,Sun Specific tools, SQL * Loader, Toad etc.,

Oracle Applications Technical Consultant

Roles and Responsibilities:

• Developed New Reports in PO and AP and customization of the standard are reports.
• Involved in the Documentation (Preparing MD070, MD120, Creating the Scripts).
• Involved in preparing the MLS Reports in PO, GL using XML Publisher.
• Preparing the Lookup values, Parameters and registering the reports.
• Involved in Preparing the Packages, Procedures, and Functions to implement MLS Concept through backend.
• Preparing the KM Assets for organizational review based on the Project.
• Developed Inbound Interfaces for Oracle Receivables, Oracle Payables and Oracle General Ledger based on requirements submitted by the client.

Environment: Client server application written in Oracle running on LINUX. Oracle Apps 12i,11i, Polar Application, SQL,PL/SQL,DEVELOPER 2000, REPORTS-6i, XML Publisher, Filezilla, SQL * Loader, Toad etc.,

Oracle Applications Technical Consultant

Roles & Responsibilities:

• Involved in Developing the reports in Sql, rdf and XML Publisher reports
• Creation of Templates and Data Definitions and Registering.
• Involved in preparing delivery package of the objects i.e Creating the Ldt Scripts for the
• Concurrent Program, Request Group, and Lookup values etc.,
• Involved in developing documentation of MD120 Installation documents, CM040 Test Scenarios.
• Involved in developing the Packages for MLS purpose to derive the labels in different scenarios.
• Involved in Client interacting for the business process.

Environment: Client server application, Oracle Apps 11i, SQL,PL/SQL,DEVELOPER 2000(FORMS-6i-REPORTS-6i -10g, XML Publisher SQL * Loader, Toad, D2K and Connectivity VPN Client, Microsoft Office.

Oracle Applications Technical Consultant

Roles and Responsibilities:

• Involved in developing the various Reports implementation and Customization of the existing reports in various modules and interfaces and Conversions in various modules of Finance and Manufacturing.
• In this project I have done the Invoice Conversion, Supplier Conversion, and Journal Import Interface and involved in developing various Reports.

Environment: Oracle Apps 11i, SQL,PL/SQL,DEVELOPER 2000(FORMS-6i & REPORTS-6i, SQL * Loader, Toad D2K and Dev Suite, VPN Client, Microsoft Office etc.,

Oracle Applications Technical Consultant

Roles and Responsibilities:

• Involved in Customization of the existing and developing the new reports sql and Oracle D2K in Purchasing.
• Involved in Developing the interface in CE, Bank Statement Import & Auto Reconciliation Interface.
• Involved in Developing the Supplier Conversion from the Legacy database i.e 11.0.3 to 11.5.10.
• Preparing the MD70, MD120 documentation and preparing the FUT’s
• Preparing the CV 60 documentation and the CV70 for the test cases.

Environment: Oracle Apps 12i,11i, SQL,PL/SQL,DEVELOPER 2000 (FORMS-6i-10g,REPORTS-6i -10g, XML Publisher SQL * Loader, Toad, VSS,D2K and Microsoft Office.

Oracle Applications Technical Consultant

Roles & Responsibilities:

• Involved in Developing and Customizations of Reports & Interfaces. Development of Custom Reports, Packages, Procedures & Functions using Oracle 8I & D2K.

Reports & Interfaces:

• Purchase Order Report (PO Print Report)
• Vendor Volume Analysis Report
• Invoice Aging Report
• Sales Order Acknowlegement
• Buyer Listing.
• Involved in developing the Journal Import Interface in GL.

Confidential

Oracle Developer

Responsibilities:

• 1.Developing the Objects (Reports, Interfaces).
• 2.Coding and Unit Testing.
• 3.Preparing Technical Documentation.