We provide IT Staff Augmentation Services!

Oracle Techno Functional Consultant Resume

SUMMARY:

  • Over 10 years of experience in software industry in the Analysis, Design, Development, Migration, Implementation and Customization of Implementation of Software Applications.
  • Proven Techno - Functional skills in all aspects of software development Life Cycle, Conversion, Testing, Installation, Support, troubleshooting and enhancements.
  • Good expertise in RICEW (Reports, Interfaces, Conversions, Extensions, Workflow, OA Framework) components, integrating with 3rd party products to Oracle Applications.
  • Extensive experience in Oracle Back-end (server-side) PL/SQL Development i.e. Stored Procedures, Packages, Functions & Triggers using SQL Navigator and Toad as development tools. Created and maintained Database Objects like Tables, Views, Indexes, Constraints, Sequence, and Synonyms.
  • Working knowledge in Performance tuning of the database using utilities like Explain plans, TKPROF, Tuning Lab, AWReports.
  • Worked extensively on Oracle Application Framework on jDeveloper 10.1.3.3.0
  • Development experience in SOA Web services on jDeveloper 11.1.1.6.0
  • Working Knowledge in Oracle Applications (E-Business Suite 11i/R12) Oracle Inventory (INV), Oracle Purchasing (PO),Order Management(OM), Oracle Advanced Supply Chain Planning, Oracle Advanced Pricing, e-Commerce Gateway(ECE) Trading Community Architecture (TCA),HRMS, Payroll, Advance benefits, BOM, WIP, Install Base, OIC, Warehouse Management System(WMS), Oracle Product Lifecycle Management(PLM), WEB ADI, General Ledger (GL), Accounts Payables(AP), Accounts Receivables(AR), Fixed Assets (FA),Procure to Pay, Order to Cash, Demand to Distribution, Budget to Close, Project Accounting, Costing, calendar/financial period change and Self Serviced Applications such as iProcurement, isuppliers, iReceipts, iPayments, iExpenses, iStore, Quality, Purchasing, Supply Chain Management, Workflow, Self Service Web Applications, Cost Management, Planning Products, and Work In Process, System Administration, Application Object Library, and Oracle Alerts.
  • Well Versed with the various versions of Oracle Applications viz. R12.1.3, 11.5.10/11.5.9/11.5.8 /11.5.7/11.0.3/10.7 .
  • Worked extensively and has strong experience in the Oracle Application E-Business Suite development tool-set (Oracle 8i/9i/10g, SQL*Plus, PL/SQL, Developer 2000, Developer 6i (Forms and Reports), Jdeveloper 10g, Discoverer, BI Publisher, OBIEE, TOAD, XML Publisher, Shell Scripting,OAF,ADF, Forms Personalization,Form Customization using CUSTOM.pll, Customizing and Developing Workflows and using Oracle Applications API’s).
  • Performed various roles like Team Leader, Technical Lead, Architect, Software Engineer and Technical Consultant.
  • Implementation Methodologies like AIM (MD200/MD50/60/70/120, BR100, TE50, Process Documents).
  • Excellent communications and interpersonal skills. Well versed in gathering requirements from customers/clients. Conversant with Project Management and Quality procedures and working with Oracle Support, Creating Service Requests, and Visual Safe Source to maintain source code.
  • Extensive experience in Creating Users, Responsibilities, Request Sets, Request Groups, Profile Options and registering Executables, Concurrent Programs, Form Functions, Reports by using Application Object Library (AOL), System Administration.
  • Proficient in Interface Programs and Conversion Programs for importing data from Legacy Systems using SQL LOADER.
  • In depth knowledge of Order to Cash (OTC), Budget to Report and procure to pay (P2P) processes.
  • Implementation and Supporting experience on business applications like Concur, Mark view and SunGard payment gateways

TECHNICAL SKILLS:

Oracle Applications: R12.1.3, 11i (11.5.10/11.5.9/11.5.6 ), 11.0.3, SOA Webserivces, OAF, ADF

Modules: Purchasing, Order Management, Account Receivables, Account Payables, General Ledger, SLA, Internet Procurement, Inventory, Advance pricing, Sys Admin and AOL Modules, Alerts, Costing, ASCP, Install Base, HRMS, iExpenses

Tools: BI Publisher, Oracle Discoverer, JDeveloper 11.1.1.6.0, 10.1.3.3.0, Developer (Form 9i/6i/4.5 and Reports 9i/6i/2.5), SQL Loader, TOAD, SQL Navigator, SQL Developer, Mercury quality center, jMeter

Languages: Advanced PL/SQL, SQL, C, JAVA, Shell scripting, PERL

Operating System: WINDOWS 7x/XP/9x, UNIX, Windows 2003 server.

PROFESSIONAL EXPERIENCE:

Confidential

Oracle Techno functional consultant

Responsibilities:

  • Integrate legacy ERP systems to internal Oracle financial systems to report all transactional data.
  • Automate Oracle AR system adherent to Amazon vendor agreements.
  • Integrate Amazon data ware house transactions with oracle AR systems
  • Automate invoice printing and uploading to external systems
  • Enable new geographies or market place to record AR and AP transactions in Oracle R12 systems.
  • Integrate various legacy applications like: Vendor Central, Virtual Trader using Amazon Web services.
  • Enhancements and development UI and workflow for internal Migration process.
  • New Invoice printing automation and formatting for Payable and Receivables.
  • Design and develop to automate AR invoice printing, emailing and uploading to external parties or applications.
  • Oracle to Vendor central integration development for invoicing and invoice PDF upload.
  • File integration and download utility from Amazon Web services to Oracle.

Confidential

Oracle Techno functional consultant

Responsibilities:

  • Upgraded from release 12.1.1 to 12.1.3
  • Implemented iExpenses replacing with Concur.
  • Developed and enhanced several SOA wsdl web services using jDeveloper 11.1.1.6.0
  • Implemented oracle Installed base over Remedy systems for asset tracking and product installations.
  • Critical oracle Patch implementations and maintenances.
  • Quarterly Audit support.
  • HTML reporting development across the modules.
  • Configured Java Mail in oracle apps to be used for all concurrent programs.
  • Developed various BI Publisher reports
  • Customer renewal reporting tool
  • Self-service query web application for ad-hoc user data requests
  • HR employee upgrade and sync up with legacy systems
  • AT&T employee mobile billing system with reporting in BI Publisher and Workflow approvals
  • Developed BI Publisher sub templates with generic organization standards to be maintained across the concurrent programs.
  • Month end monitoring and support activities across the modules.
  • Created Business event subscriptions for patch up or reporting business purposes.
  • OIC setup and enhancements
  • Invoice resolution business improvements.
  • Prepayments setup with full cycle review.
  • Support and resolution under SLA guidelines.
  • User training on new module rollouts.
  • Business process improvements.
  • Developed various Purchasing printable templates

Environment: Oracle Applications EBS R12.1.3, Middleware 10.3.6.0, Database:11.2.0.3, BI Publisher, SOA Web services, ADF, AOL, GL, IB,BOM,OM,INV, AR, AP, PO, HRMS, Advance PL/SQL, SQL*Plus, Toad, Reports 10g, Forms 10g, Jdeveloper 11.1.1.6.0

Confidential

Techno Functional Consultant

Responsibilities:

  • Post implementation and enhancement support of procurement operations.

Confidential

Techno Functional Consultant

Responsibilities:

  • Implemented Concur replacing with iExpenses.
  • Developed rule based recognition auto invoice creation program.
  • Created rule based engine Form from scratch to identify the expense key parameters.
  • Customized OAF pages to create client specific Iprocurement.
  • Developed XML publisher report for handling long check printing format.
  • Development of program to restrict Citi counterfeit card transactions.
  • Visa Rec5 validation API development
  • Concur region wise policy configuration setup
  • Performance improvement program for Confidential Card interface.
  • Worked on the merchant interface to load get the file from oracle and load the data into Confidential system.
  • Worked on Balances Conversion using API’s.
  • Worked on the interface to create element entries for the employees.
  • Configured the Budgets through change order in Project Management.
  • Tested various Allocation methods to achieve the target.
  • Involved in setting up project template, accounting rule, etc.
  • Defined Project related setup options, Project calendar, Project Period and identified Project types, Project Templates, Task related setup and Project related workflow and profiles.
  • Documented requirements and created functional specifications to implement expense report.
  • Developed test scripts for unit testing, system testing, and integration testing.
  • Developed custom responsibilities for application end users.
  • Trained Users on the Sungard, CitiDirect applications.
  • Gcard Auto Payment (Location specific changes, get individual payments thru file processing, Email automation and Dunning notifications, handling individual payments.
  • Concur (Expense Handling Application) Maintenance and Upgrades.
  • Workflow customizations for Finance approver/CEO/CFO injection in hierarchy.
  • Developed and customized reports using oracle reports, Discoverer and XML publisher.
  • Many HR reports.
  • Exception Report.
  • Payment Distribution Journal report.
  • Costing Details Report.

Environment: Oracle Applications EBS R12.x, (11.5.10.2), Sys Admin, AOL, GL, AR, AP, PO, HRMS, Advanced Benefits and Payroll, Oracle 10g PL/SQL, SQL*Plus, Toad, Reports 10g, Forms 10g, Discoverer, BI Publisher, SQL* loader.

Confidential

Techno Functional Consultant

Responsibilities :

  • Part of 11.5.10.2 up gradation team for P2P track.
  • Worked on the Accounts Payables Invoice interface in accounts payables .
  • Gathered and mapped requirements to Confidential procurement custom environment functionality.
  • Developed interface to have “Add new line” requisition line feature.
  • Customized some of the reps info form. Added a tab canvas to the existing content canvas and added the fields to the tabs in the canvas.
  • Customized an AR Credit Memo Approval Request Work Flow in Advanced Collections.
  • Developed a new report in INV to get the Inventory on hand quantity details and the back flush details.
  • Payment Solutions:
  • Support and Development in Oracle Applications 11.5.10i AP,PO, HRMS Modules.
  • Oracle Integrations,Invoice Workflows
  • Bug Fixing, Enhancements and Maintenance of Procure to Pay modules (Oracle Applications 11.5.10i AP,PO,HRMS)
  • Expense Reporting & Employee Credit Cards( Known for Confidential as Gcard):
  • Gcard Auto Payment (Location specific changes, get individual payments thru file processing,Email automation and Dunning notifications, handling individual payments.
  • Concur (Expense Handling Application) Maintenance and Upgradations.
  • Procurement Operations:
  • Complete evaluation of requisition approval workflow for improvements.
  • Spend Authority Exceptions and Changes.
  • Work with business Users on determining and working on strategic direction and initiatives.
  • Developed and customized reports using oracle reports, Discoverer and XML publisher like.
  • Statement of Changes to Net Assets.
  • Participant Detail Report.
  • Statement of Changes to Net Assets - summary by investment class.
  • Schedule of assets held for investment report.
  • Transaction History by Fund Report
  • Filing summary for schedule Hold report.
  • Worked in the support system, performed the responsibility of system administration which involved creating users, setting up the user profile, registering and managing the concurrent programs.
  • Customized the existing Auto lockbox interface in Accounts Receivables.
  • Customized various transactions in Accounts Receivables like Invoices, Receipts, and Credit Memos and Debit Memos etc.
  • Creation of SQL*Loader control programs and PL/SQL validation procedures to execute along with customer interface and vendor programs to support the interface requirements.
  • Developed a GL interface module using SQL LOADER for data loading. For preprocessing of data used PL/SQL and for integration with Oracle Applications developed UNIX shell scripts to import Journal entries from external source.
  • Creation of SQL*Loader control programs and PL/SQL validation procedures to execute along with customer interface and vendor programs to support the interface requirements.
  • Customized check printing report in AP as per the specific requirements
  • Developed Backlog Report, This is a custom report basically finds all the orders lines which are not full filled. Order lines that are not shipped. I have developed a procedure which picks up all backlog lines into a temp table and prints on a report.
  • Worked in creating menus, functions, sub functions, defining responsibilities and Segregation of Duties.
  • Worked on Error Handling System in storing all the errors that occur during interfacing and loading.
  • Created the database schema objects like tables, views, synonyms, indexes, procedures, functions.
  • Generated ad-hoc queries to analyze underlying data for inconsistencies and integrity issues to find data issues.

Environment: Oracle Applications EBS (11.5.10.2), Sys Admin, AOL, GL, AR, AP, PO, HRMS, Advanced Benefits and Payroll, Oracle 10g PL/SQL, SQL*Plus, Toad, Reports 10g, Forms 10g, Discoverer, BI Publisher. Advance Pl/sql, Pl/sql, Sql, Forms6i, Reports 6i, Unix, Shell Scripting, Performance Tuning, Oracle Discoverer, XML, Java script.

Confidential

Techno Functional Consultant

Responsibilities:

  • Part of Upgradation team for 11.5.7 to 12.0.1
  • Worked on Creating Data Source, Users, Roles, and Assigning Roles to Users, developing BI publisher reports in OBIEE.
  • Developed two custom OAF Pages by creating Entity Objects, View Objects and Controllers and registered them in Oracle Applications.
  • Lead the development team and consultant’s teams globally.
  • User training and production support of Oracle Applications 11i/ R12 (Procure to Pay, Order to Cash, Demand to Distribution, Budget to Report, Project Accounting, Costing, calendar/financial period change and Self Serviced Applications such as iProcurement, suppliers, iReceipts, iPayments, iExpenses, iStore, Quality, Inventory, Bills of Materials, Purchases, Order Management, Advanced Pricing, APS, Workflow, Self Service Web Applications, Cost Management, Engineering, Planning Products, ADF, WEB ADI, Work In Process, Advanced Supply Chain and Planning, DEMANTRA, and HRMS ).
  • Involved in the Customization of Pricing Attributes for Advanced Pricing and FA Account Generator (Workflow). Involved and reviewing the MD50’s and MD70’s for designing and developing Interfaces, conversions and reports for the Phase II
  • Developed internal Service Request system by customizing Oracle Forms, alerts and reports
  • Utilized AIM METHODOLOGY and created MD50, MD70 and CV40 documents for supporting applications
  • Generating the Code Combinations using Account Generator and Workflow
  • Developed PL/SQL program for Loading the Data from the file into Oracle Custom tables using UTL File utility
  • Developed PL/SQL program for Processing the Data for customer and vendor validations and insert into AP & AR interface tables
  • Worked on Auto Invoice, Auto Lockbox, and Customer Interfaces in AR module
  • Customized the Variances reports for executive business requirement
  • Customized the Depreciation Reports for Fixed Assets
  • Customized the ACH and Positive pay process for sending to Bank
  • Designed and developed the Sales Forecast, Raw Material Forecast and Planned Order demand reports by using the Supply Chain and Order to Cash Applications
  • Customized the AR Lockbox process.
  • Designed and developed the Custom Check printing process
  • Designed and developed the Service Request system internally to maintain all the bugs/enhancement requests.
  • Designed and developed the Procurement Card Transactions process.
  • Designed and developed Global Inventory Details by Account reports.
  • Personalized and customized various forms (Shipping and HRMS, zoom functionality, etc,..) based on the business requirement
  • Designed and developed Pick Slip and Packing Slip reports to include the Barcodes and additional business requirements.
  • Designed and developed the interfaces to send the data into Content Management System (CMS)
  • Designed and developed the WIP inbound and outbound process to load the data from the shop floor to Oracle directly and sends the details back to shop floor system.
  • Customized Standard Oracle Un-Received Shipments using reports 6i to include the new required functionality.
  • Involved in Unit Testing.
  • Imported Customer Information by using Customer Interface in Receivables. Worked on Auto Invoice to import Invoices, Debit Memos and Credit memos
  • Created SQL Loader script to load data into temp tables from AS/400 data files and build program to validate the data for business rules and load the data to Auto invoice interface tables
  • Created programs to validate the data received from banks and developed program to create lock box interface lines and header records to lockbox interface tables.
  • Performed system administration functions such as Creation of Users, Creation of Responsibilities and Set up user profiles specific to applications
  • Designed and developed ADP inbound and outbound interfaces for HR, Benefits, OTL and Payroll requirements.
  • Working with global users to gather the requirements.
  • Involved in user meetings for Gap Analysis
  • Coding the Custom Packages, Procedures and Functions for Custom Reports for all the various modules using PL/SQL programs.

Environment: Oracle Applications EBS (12.1.1), Sys Admin, AOL, GL, AR, AP, PO, HRMS, Advanced Benefits and Payroll, Oracle 10g PL/SQL, SQL*Plus, Toad, Reports 10g, Forms 10g, Discoverer, BI Publisher. Advance Pl/sql, Pl/sql, Sql, Forms6i, Reports 6i, Unix, Shell Scripting, Performance Tuning, Oracle Discoverer, XML, Java script.

Confidential

Techno Functional Consultant

Responsibilities:

  • Handled Multiple roles and responsibilities; Lead, Developer and Performance Changes in the Consumer Lending Flexcube programs.
  • Java Upgrade of Flexcube to Flexcube Java for Consumer Lending Module.
  • Flexcube FCJ Benchmarking and Performance Tuning of the Application.
  • Flexcube Archival and Purging Business Logic Development
  • Identifying the Various Unit areas for Performance Tuning.
  • Creating the Virtual Users and taking the Readings using JMETER. Metadata Collection for all the modules given as a requirement.
  • FLEXCUBE - FCJ10.0 Release Migration and Conversion Tool Development from older Systems.
  • Post Implementation support of Flexcube in Western Europe.

Environment: Oracle 9i, SQL, PL/SQL,JavaScript, Win 2000/XP, TOAD 7.5, SQL, PL/SQL,JSP,Javascript,Forms6i, JDeveloper,MSXML4.0 XSL, SOA.

Confidential

Techno Functional Consultant

Responsibilities:

  • Trained as Oracle Application Developer in SQL STAR INTL
  • Oracle Certified Professional in Oracle 9i
  • Key project implementations as team member
  • ICDS-CARE (Integrated Child Development Services).
  • Developing the forms and reports using forms9i and reports9i.
  • Creating the tables, sequences, views, triggers and other data objects required.
  • Creating responsibilities and assigning them to a particular application.
  • Involved in development, customization and data migration into Oracle Applications project.
  • Involved in the creation of database and database activity, performance tuning.
  • Utilized Application modules, e.g., PO, INV and PA. Involved in the customization of forms and reports using developer/2000 tools and loaded legacy data into Oracle applications modules.
  • Familiar with registration of new programs in Oracle Applications as concurrent programs. Involved in data load using Interfaces to load legacy data into Oracle modules,Used SQL * Loader and PL/SQL to load data into Apps production tables from flat file via temporary tables, Worked as a member of Oracle Applications ERP Data Migration Support Team, Responsible for registration of new programs in Oracle Applications as concurrent programs, Used UTL FILE packages, DBMS Packages and PL/SQL to develop batch programs.
  • Developed “Electronics File Transfer Payment” programs to automate payment transfer.
  • Wrote Shell scripts that were directly called from Oracle Applications, Conducted training on SQL, PL/SQL and Oracle Developer.
  • Prepared design and deployment documentation provided deployment and data migration services and assisted with user training, Involved in registering the reports, screens and batch programs, unit testing, and verification with users.
  • Sarvotham TMT
  • Implemented several change requests to customize functionality in Oracle 11i Finance, Manufacturing and Order Management packages, in full conformance with RICE processes and documentation standards.
  • Designed and developed interfaces to legacy systems
  • Customized and developed Oracle Reports and Forms in AP,AR and PO Module.
  • Creating responsibilities and assigning them to a particular application (Sys Admin).
  • Unit Testing on AP,AR setups designed by Functional Consultants.
  • Designed and setup Oracle batch jobs across entities.
  • Provided technical and investigative support for functional users on interfaces, defects, change requests, debugging issues, testing, service pack upgrades and adhoc report requirements
  • Continued support for production issues as third level production support specialist. Supported user community in defining Service Level Agreements (SLA)
  • ScheduleXpert - Product Development
  • Developing the PSP’s (PL/SQL server Pages) by embedding the JavaScript in PL/SQl code,
  • Developing packaged functions and procedures, triggers, indexes etc.,
  • Customizing and developing the PSP’s for each and every client specification.
  • Creating responsibilities and assigning them to a particular application.

Environment: Oracle 9i, SQL, PL/SQL,JavaScript, Win 2000/XP, TOAD 7.5.,Oracle Financials, 11i,XML,jDeveloper,Forms 9i,Reports 9i, Oracle r12

Hire Now