We provide IT Staff Augmentation Services!

Sr. Oracle Apps Techno Functional Consultant/ Lead Consultant Resume

SfO

­

EXPERIENCE SUMMARY:­­­

  • 15+ Years of extensive experience in Analysis, Design, Development, Testing, Customization, Bug fixes, Enhancement, Support and Implementation of Oracle Applications 11i and R12.
  • Having the experience in Oracle Fusion Cloud ERP, Fusion HCM and Strong Experience as a Techno - Funcitional consultant/Architect in Oracle EBS with major focus on Financials, SCM, HRMS 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).
  • Experience Oracle Cloud consultant in the areas of Oracle Fusion HCM Security, Roles, Reports (BIP, OTBI), HDL, Page Customizations, Sand Box, Infolets.
  • Experience in Oracle Service Cloud integration applications in areas of designing the applications for Web Customer Service, Cost channel Contact seller, KM, Policy automation, Field Service managment
  • Oracle Cloud Fusion HCM Cloud consultant in the areas of cloud ERP EPM, Smart View, Finance Reporting Studio reports, Notifications, Alerts, FBDI loading, Spreadsheet loading etc.,
  • 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).
  • Expertise in inbound and outbound interfaces and creation of automated process using Application Program Interfaces (APIs) and developing theEDI & WebADI’s to import the data from flat files.
  • Completed the Project Management Professional(PMP) 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/Mulesoft/Workday.
  • Hands on experience with Oracle Discoverer which includes report development, Discoverer Administration, configuring Discoverer and End User Layer (EUL).
  • Having the strong experience in Microsoft VB & .NET technologies.
  • 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. 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, iProcurement, iExpenses, HRMS/PAYROLL ), Hyperion

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

Internet Technologies: Java Script, JSP, HTML,Python

Microsoft technologies: VB, .NET (VB.NET, XML.NET, C#.NET, JSP.NET)

Tools: xManager, TOAD, PVCS, CVS/SVN,Panaya, Athena, Kintana, SQL NavigatorSQL*Loader, FTP, Putty, Filezilla

PROFESSIONAL EXPERIENCE:

Confidential, SFO

Sr. Oracle Apps Techno functional Consultant/ Lead Consultant

Responsibilities:

  • Developing the new interfaces(inbound/outbound)/shell scripts/reports for Oracle AR
  • Creating the new webpages for the simplifications Banks statements auto reconcillation process.
  • Developing the generic scripts/programs for all the Financial Integrations
  • Designinng and developing the new reports which is a part of daily monitoring activities for all Fin-Integrations
  • Developing the new reports using the XML Publisher part of daily moniting mail generations for the below.
  • Customer Integrations
  • Invoices Integrations
  • Receipts Interfaces
  • Satements Interfaces

Confidential, Menlo Park, CA

Sr. Oracle Apps Techno functional Consultant/ Lead Consultant

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.
  • 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
  • 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.
  • 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
  • Developed several BIP reports with RTF, Excel and e-text templates and interact with onshore for development.
  • Data migration for several modules using HCM Data Loader and having conceptual knowledge on Extracts.
  • Prepared and loaded General Ledger Data of several years using FBDI.
  • Prepared and loaded Payments, Invoices data using FBDI.
  • Prepared and loaded Suppliers, Sites, banks data using FBDI.
  • Prepared report for data reconciliation from Payable to GL, Payments to GL, Receivables to GL, Purchase Receipts to GL, Assets to GL, Projects to GL. etc.
  • Worked on several OTBI reports development for different requirements from HCM and Fusion ERP.
  • Loaded CoA, Cross validation Rules using Rapid Implementation spreadsheets.
  • Loaded Payment terms from FSM by preparing the XML data using XML TREE.
  • Worked on FSR reports and scheduling the FSR reports.

Confidential, SFO

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.

Confidential, SFO

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.
  • Designed and developed the programs to export data for the below out bound interfaces.
  • On-hand Inventory from GIV to SAP IBP
  • Financial Plan from Hyperion to SAP IBP
  • Sales History from Demantra to SAP IBP
  • Demand Plan from Demantra to SAP IBP

Confidential, Sunnyvale, CA

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.

Confidential, WI

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
  • Offshore activities: coordination with offshore team on the following.
  • Supplier Conversion
  • Invoice Conversion
  • PO Conversion
  • Customizing the Auto Invoic Import Program
  • Reciepts interface/conversion.

Confidential, Houston,TX

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, Confidential Libraries.

Confidential

Oracle Applications Technical Consultant

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.

Hire Now