We provide IT Staff Augmentation Services!

Sr. Oracle Apps Techno-functional Lead Resume

Malvern, PA

SUMMARY

  • 13 Years Experience in Oracle Applications as a Techno Functional consultant with good knowledge in coding and testing of software applications, and in - depth knowledge in Oracle Application 11i/R12(12.0.6,12.1.1,12.1.3,12.2.4), Framework9i, OAF, ADF, SOA, XML/ BI Publisher, Discoverer10g, Oracle9i/10g/11g, Forms6i/10g, Reports6i/ 10g, Oracle Alerts, Oracle J-developer(10g), Oracle Applications, Workflow Builder2.6, PL/SQL, Triggers, Agile Scrum, CRM, Manufacturing modules
  • Extensive experience in implementation, Migration, Customization, Production and support of various modules in Oracle Applications with major focus in Accounts Receivable(AR), Inventory (INV), General Ledger (GL), Accounts Payables (AP), Purchasing (PO), I-Procurement, CM, Order Management (OM)
  • Hands-on experience in Data Conversion, Data Migration, Report Generation and Developing Interfaces within several modules in Oracle Applications.
  • Technically proficient in RICEW components (Reports, Interfaces, Conversions, Extensions, Workflows).
  • Experience in Procure to Pay (P2P), Order to cash (O2C) life cycles and Supply Chain business flows.
  • Proficient in development of interfaces and conversion programs to integrate Oracle Applications modules to import data from various sources into Oracle Applications using PL/SQL, SQL*Loader.
  • Strong Knowledge of Application Implementation Methodology (AIM), Application object Library (AOL) implementation standards, Trading Community Architecture (TCA) and software Development Life Cycle (SDLC).
  • Expertise on designing and implementing Oracle Alerts and Lookups.
  • Worked in customizing existing OAF Screens, forms and reports as per business needs using OAF Substitutions.
  • Performed User and Administration responsibilities in Discoverer.
  • Experienced in Customizing Oracle Forms with Forms Personalization using Custom.pll and Zoom functionality.
  • Customizing Oracle reports and developing new reports by using Oracle Report 6i/10g and XML Publisher (BI Publisher).
  • Developed new Concurrent Programs, Custom Forms, Reports and Flex Field Customizations.
  • Extensively used TCA (Trading Community Architecture) to create customers in AR.
  • Experience in importing data from legacy systems to Oracle Applications using Oracle Interfacing, SQL
  • LOADER, UTL FILE, Oracle packaged APIs etc.
  • Expertise in requirement analysis, system design, Data Flow Designs, support, development, testing, documentation and design reviews.
  • Expert in developing Technical design documents (MD070), Technical Test documents (TE020), Conversion (CV050) and Migration documents (MD0120).
  • Experience in customizing oracle workflows such as the PO approval process, Order/Line Flow to send user notifications based on the business requirement.
  • Strong in Performance Tuning, UNIX scripting.
  • Ability to handle user defined errors by developing Error-Handling Package using PL/SQL.
  • Adroit in Performance tuning for optimized results using tools like EXPLAIN PLAN, SQL TRACE, TKPROF, HINTS

TECHNICAL SKILLS

Oracle Financials: Oracle General Ledger, Oracle Payables, Oracle ReceivablesOracle Projects, Cash Management, Oracle Fixed Assets, I-Expenses

Oracle Distributions: Oracle Purchasing, Oracle order management

Oracle Manufacturing: Oracle Inventory, Oracle order management

Oracle SCM: MO, INV, and PO & CRM

Technologies: PL/SQL, Reports6i/10g, Forms6i/10g, SQL loader, XML Publisher, Workflow, MS office, Toad, SQL Developer, SQL*plus, Shell Scripting, FND loader script, C,C++, Core Java, JDeveloper, ADF, OAF, Putty, Win sap, PVCS, HTML, DHTML,XML, Kintana, Oracle applications Release R12,115.10.2,11.5.10 &11.5.9,oracle 8i/9i/10g, OraRRP tool, Web logic server, EDI, Web ADI

Web Technologies: HTML, DHTML, XML

Advanced Technical tools: OAF, ADF, SOA, Web logic Server, Forms and Reports 11g, BI Reports, OBIEEFusion Middleware

PROFESSIONAL EXPERIENCE

Confidential, Malvern, PA

Sr. Oracle apps Techno-Functional Lead

Responsibilities:

  • Designed and developed Sales Order interface program from Data Works to Oracle OTM.
  • Developed the host (Unix) programs to pull or push the files from third party server.
  • Re-designed auto-scheduling and Carrier Pro Number in OTM
  • Worked on OAF VO extension in Penske application
  • Developed the Concurrent program which adjusts the cash in GL
  • Designed the xml publisher reports based on customer requirement
  • Scheduled request set modified as per the picking and order grouping rules.

Environment: OAF, Penske, Quoting, i-suppliers, Oracle PL/SQL, Oracle R12 (12.2.4), Oracle General Ledger, Oracle Payables, Oracle Receivables, Order Management, Inventory Oracle Developer 10g (Forms, Reports and Workflow), XML Publisher, Oracle Database, J-Developer, SQL Developer, Tortoises-SVN, SNOW(Ticketing tool), shipping module, Advanced Pricing, OBIEE

Confidential

Sr. Oracle apps Techno-Functional Consultant

Responsibilities:

  • Developed RMA order details package for USA, Canada, Mexico in Manufacturing domain
  • Return material authorization(RMA) process customized through process transaction interface program
  • Fixed the data fix issues in production instance
  • Developed sales tax break up custom form in order management module
  • Developed Re-stock package in inventory and validated restock items in proper warehouse (inventory transaction interface)
  • Customized standard shipping exception report and shipping labels report in xml publisher
  • Used shipping exception API and created GOC orders in varies countries(OE ORDER PUB,WSH DELIVERY PUB,WSH CONTAINER PUB,wSH DELIVERY DETAILS PUB,WSH TRIPS PUB)
  • Using the API(QP PRICE LIST PUB.Process Price List) Import of Price List records in advanced pricing module
  • OAF page personalization in I-expenses modules
  • OAF CO extension on I-Procurement non-catalog and contract request pages.
  • Used service contracts API's (OKS DELETE CONTRACT PUB,OKS IMPORT LINE PUB,OKS IMPORT SUBLINE PUB)
  • Completed Performance Tuning in complex sql queries.

Environment: OAF, ADF, Oracle PL/SQL, Oracle R12 (12.2.4), Oracle General Ledger, Oracle Payables, Oracle Receivables, Order Management, Inventory Oracle Developer 10g (Forms, Reports and Workflow), XML Publisher, Oracle Database, J-Developer, TOAD, CVS, HP ALM Quality Center, SNOW(Ticketing tool),Primavera, shipping module, Advanced Pricing

Confidential

Sr. Oracle apps Technical Consultant

Responsibilities:

  • Automated emails for purchase order transmission
  • Auto flip purchase requisitions to purchase orders
  • Validate the categories on the purchase requisition/order from and OAF page.
  • Requisitions project LOV modifications
  • PO output communication xml report implemented 21 operating Units (China, APAC, NALA, and EMEA)
  • Prepared code migration script MD120 document for OAF page personalization’s
  • Fixed Data conversion issues at SIT and CRP
  • Changed suppler name sorting and email as read only at OAF page
  • Implemented projects module in i-Procurement
  • Implemented flex-ket item process in Manufacturing industry
  • Designed charge account interface based on project details.
  • CO extension for Need by date filed in I-procurement requisition screen.
  • Incorporated in projects module in requisition line level
  • AME account expanse rules data loaded through data loader in 21 OU’s
  • Requisition account generator workflow customized based on projects(Capex)
  • Developed Supplier mass updated program using
  • Integrated web ADI templates in general ledger module using data load import to tables.
  • Import and update schedule programs using ADI
  • Developed custom reports as per client requirement in OPM Forecasting module.
  • (SQL*Loader and API’s (ap vendor pub pkg.update vendor,ZX PARTY TAX PROFILE PKG.update row, ap vendor pub pkg.update vendor site,iby disbursement setup pub.update external payee)
  • Customized Flat File Formats in EDI process.

Environment: OAF, Oracle PL/SQL, Oracle R12 (12.1.1), P2P, Oracle General Ledger, Oracle Payables, Oracle Receivables, Oracle Developer 10g (Forms, Reports and Workflow), XML Publisher, Oracle Database, J-Developer, TOAD, CVS, HP ALM Quality Center, Oracle Project Accounting (PA) module (Project Costing and Project Billing),HRM

Confidential, Knoxville, TN

Sr. OAF Developer

Responsibilities:

  • Worked at page personalization's and CO extensions
  • Prepared MD120, MD70, Unit test case documents and migration scripts
  • Below validations done at Customer Standard OAF page
  • Validate Customer Address2 to 40 Characters
  • Validate Customer Address3 to 40 Characters
  • Validate Customer Address4 to 40 Characters
  • Disable fields and Tabs on Customer Addresses
  • FedEx Address validation1: Initialize Local Variables
  • FedEx Address validation2: Derive Local Variable1
  • FedEx Address validation3: Derive local variable2: Display message1
  • FedEx Address validation3: Derive local variable3: Display message2
  • FedEx Address validation4: Display Exception Message
  • Email-User Name Constraint
  • Retail- Validate Ship-To Address has a Bill-To
  • Telephone number mandatory insert Item into pricelistusing the api qp price list pub in advance pricing
  • Developed Warehouse Rules and Production Batches interfaces in OPM.
  • Defined interface data files so that application data can interface with EDI translators
  • Loads valid data into the appropriate Oracle Application Open Interface tables for the transaction EDI gateway

Environment: OAF, Oracle PL/SQL, Oracle R12 (12.1.3), P2P, Oracle General Ledger, Oracle Payables, Oracle Receivables, Oracle Developer 10g (Forms, Reports and Workflow), XML Publisher, Oracle Database, JDeveloper, TOAD, Projects

Confidential

Sr. Oracle Technical Consultant

Responsibilities:

  • Expert in requirement gathering, design and development of custom applications, customization of OAF pages, extension and creation of new OAF pages in JDeveloper 9i and 10g environment.
  • Worked on the development of interfaces, Data Conversions, developing new Forms, Reports, Customizing Oracle Reports in order to Cash cycles touching various modules such as AR, PO and AP, GL.
  • Implemented AP Invoice import through Payables Open Interface Import Program.
  • Involved in Customer Conversions to load Customer details into HZ tables by creating staging tables and performing validations and finally loading them in to base tables using TCA APIs
  • Developed an outbound interface for open Payable Invoices, Suppliers, Supplier Sites, Supplier Contacts, Banks, Bank Branches, and Bank Accounts, etc. from legacy system to Payables.
  • Customized various transactions in Account Receivables like Invoice, Receipts, Credit Memos and Debit Memos etc. Customizations of Requisition Approval, PO Approval & Auto Create Workflows.
  • Developed custom templates for the invoice reports by calling sub templates in XML/BI Publisher.
  • Designed and implemented custom Summary Billing Utility in AR with integration to Trading Community and Receivables
  • Customized AR-CE Bank Reconciliation Batch Info Report.
  • Developed PL/SQL procedures, functions, packages, triggers to validate the data and insert the validate data into Oracle Standard interface tables.
  • Created Workbooks based on the custom Folders with parameters, cascading parameters, conditions, calculations using Discoverer Plus and Discoverer Desktop.
  • Customize and convert existing RDF reports that will run compatible as per the new multi-org structure and user requirement.
  • Skilled in development and implementation of revenue recognition process improvements
  • Prepared Revenue journal entries for operated and non-operated properties.
  • Personalized Oracle standard and custom Forms using oracle forms builder as per the Client requirements.
  • Customized Sales Order form to add customer fax, email and phone number contacts.
  • Developed Master Detail forms using TEMPLATE.FMB and registered them in Oracle Application.
  • Prepared the Technical Design documents, Installation documents and Unit Test Case documents.
  • Improving performance of application by porting client side queries to server side
  • Design and Development of Oracle BI Publisher Reports Layouts Templates and Data Templates using Oracle SQL and Web Services as Data Source.
  • Managed a team of 2 at offshore
  • Different components of a Benefits Design(OAB)

Environment: OAF, Oracle PL/SQL, Oracle R12 (12.1.3,2.4), P2P, Oracle General Ledger, Oracle Payables, Oracle Receivables, Oracle Developer 6i (Forms, Reports and Workflow), XML Publisher, Oracle Database, JDeveloper, TOAD, Projects and ADF, CRM,HRMS

Confidential

Oracle Apps Technical Developer

Responsibilities:

  • Developed the BI Publisher reports
  • Created the suppliers and employers in purchasing module
  • Implementation and up gradation of Oracle financials Suit. (AP, GL, AR)
  • Written a Segment extraction program to extract the Chart of Accounts segment values and related information. This program Written in PL/SQL and made it as concurrent program.
  • Designed and developed two custom data entry forms to maintain data in custom tables. Modified existing reports.
  • Migrated GL and AP custom interfaces and reports, during oracle financials upgrade project.
  • Developed test cases and templates to test the custom report migration process.
  • Customizing Accounting Flex Fields, Cross Validation Rules and Security Rules Setting of profile options at various levels.
  • CO Extensions on i-procurement (Account Generator workflow) and i-expenses (Detail Summery report calling at expanse page) modules in OAF/ADF
  • Involved in the functional team and client meetings to discuss on business requirements.
  • Reviewing/creation of functional and technical design documents.
  • Developed interfaces to extract the data from OM, AR, GL tables to VT interface table for processing by VT.
  • Developed/customized the reports as per the business requirement.
  • Creating code runner batches to migrate the changes to various instances.
  • Participated in QA meetings during transition phase to discuss on the defects raised.
  • Assigning/resolving the post production defects raised until normalization phase.
  • Presenting support transition presentations with support team before go-live.
  • Involved in Go-live activities to migrate the changes to production.
  • Preparation of migration Documentation
  • Development and modification of the existing and new reports.
  • Preparation of Test Cases related to the developed and modified objects
  • Developed the XML, BI Publisher reports
  • Fixed the issues based on technical defects raised by QA team
  • Expert in requirement gathering, design and development of custom applications, customization of OAF pages, extension and creation of new OAF pages in JDeveloper 9i and 10g environment. i-procurement page personalization and Extension of VO/CO

Environment: ADF, OAF, Oracle PL/SQL, Oracle E-biz Applications 11i and R12, Oracle General Ledger, Oracle Payables, Oracle Receivables, Oracle Developer 6i (Forms, Reports and Workflow), P2P, XML Publisher, Oracle Database, JDeveloper, SQL Navigator, TOAD, Advanced Java, i-expenses

Confidential

Sr. Oracle Techno-Functional Lead

Responsibilities:

  • Worked on invoice conversions by designing, developing style sheets and generating XML files using Oracle PL/SQL, Oracle AR, BI Publisher, XMLDOM package
  • Developed PL/SQL Procedures for Customer interface using TCA in Accounts Receivables according to Client Requirements.
  • AR Aging discoverer report converted to xml publisher
  • Frequently worked with defining accounting and descriptive flex fields, writing validations to custom forms.
  • Developing Adhoc reports using Discoverer to analyze data and compare with General Ledger.
  • Helping financial service people to understand and reconcile data between custom module and Oracle financials. Also designing and developing custom procedures and Reports (Pl/SQL, Reports 6.0).
  • Writing scripts to automate reports to run in batch for given time period
  • OAF page personalization in I-expenses modules

Environment: ADF, OAF, Oracle PL/SQL, Oracle E-biz Applications 11i and R12, Oracle General Ledger, Oracle Payables, Oracle Receivables, Oracle Developer 6i (Forms, Reports and Workflow), P2P, XML Publisher, Oracle Database, JDeveloper, SQL Navigator, TOAD, Advanced Java, i-expenses

Confidential, Miami, FL

Sr. OAF Developer

Responsibilities:

  • Involved in the day to day activities of production support of Oracle applications environment in AP, PO, OM
  • Work on the development activities as part of issue resolution. Perform Unit Testing, migrate to next environments, assist user testing and closing the tickets.
  • Customized forms using custom.pll to change the functionally of the standard forms.
  • Design and developed user interface components using ADF Rich Faces.
  • Developed AR Credit memo and AR Customers forms
  • Customizations and personalization for forms and oaf pages.
  • Designed and developed migration scripts for all activities and GL migration.
  • Developed various Custom reports, Customized existing reports (PO Purchase Order and Releases Detail Report, Purchase Requisition Status Report) according to the functional specifications using Reports 10g and
  • XML publisher.
  • Loaded existing Purchase Orders of the legacy system through SQL* Loader, validated (in AP) whether those
  • PO’s are paid and finally valid entries are recorded in GL. Also, an exception report was created
  • Developed custom reports for billing history by client and Invoices by client report using Discoverer.
  • Developed technical designs for conversion of Oracle EBS extensions utilizing OAF systems.
  • Worked on Form Personalization in Order Management.
  • Create and monitor a system of controls, procedures, and forms for the recordation of fixed assets.
  • Responsible for global recording of revenue and cash in the general ledger
  • Developed a program to inactivate the vendors.
  • Testing of Boundary systems SI data collaboration with oracle in various financial business processes (P2P)
  • Worked with Sales Order Open Interface in Order Management module to import Sales Orders from flat files.
  • Lead should Motivate/encourage the team members especially when team is under pressure with the tight deadline
  • Optimize sourcing procedures to attain maximum efficiency
  • Troubleshoot Java errors in J-Developer

Environment: ADF, OAF, Oracle PL/SQL, Oracle E-biz Applications 11i and R12, Oracle General Ledger, Oracle Payables, Oracle Receivables, Oracle Developer 6i (Forms, Reports and Workflow), XML Publisher, Oracle Database, JDeveloper, SQL Navigator, TOAD

Confidential

OAF Developer

Responsibilities:

  • Rebuild charge account for oracle application frame work.
  • EO, VO, CO Extensions on i-procurement and i-expenses modules in OAF/ADF
  • Responsible to do analysis and find out process gaps on recurring issues and publish a “Root Cause Analysis Report”.
  • Invoice hold approval workflow, I expense workflow, Purchasing Requisition workflow (add some part of code above packages)
  • Print purchase order xml Report extension
  • Interacting and working with the Users for the issues and the bug fixing.
  • Liaisoning with the business Analyst in gathering and freezing requirement and the continual meetings with them throughout the phase and supporting the users during UAT Testing
  • Involved in Preparing the clarification document, Technical documents as per AIM methodology, Test case Documents
  • Performed weekly and monthly Revenue analysis for Senior Management.
  • Develop a Program for the Auto Invoice Interface to import Customer Invoices, Credit & Debit Memos in Receivables AR.
  • Testing of P2P process end to end while providing support to users for the same
  • Posted monthly revenue and reconciled revenue general ledger accounts and system revenue reports and implemented correcting actions
  • Define and communicate technical release and business cutover plans with relevant cutover steps and communications needed with external business partners and stakeholders
  • OAF page enhancements in i-Expanse module.
  • Imported shipping orders using API (OE ORDER PUB,WSH DELIVERY PUB,WSH CONTAINER PUB,wSH DELIVERY DETAILS PUB)

Environment: OAF, Oracle PL/SQL, Oracle E-biz Applications 11i and R12, Oracle Order Management, Oracle Advanced Pricing, Inventory, Oracle General Ledger, Oracle Payables, Oracle Receivables, Oracle Developer 6i (Forms, Reports and Workflow), XML Publisher, Oracle Database, JDeveloper, SQL Navigator, TOAD. JAVA, Shipping module

Confidential

Oracle Technical Consultant

Responsibilities:

  • Involved in Performance tuning of various queries and stored procedures.
  • Designed and Developed Stored procedures, Functions and Triggers in PL/SQL to implement complex business rules.
  • Involved in Customization of Standard Trail Balance Report using Reports builder as per the business Requirements.
  • Customized Inactive Item Report and Cancelled Sales Order Report.
  • Extensively worked on Report Triggers and Formula Columns.
  • Preparing the technical design document.
  • Supplier search form developer from starting and register in purchasing responsibility
  • Extended VO & CO
  • Added some columns in existing region
  • Change the business logic in process form request
  • Developed PPR page in Inventory
  • Collecting inputs and providing the specifications in a functional design document to technical team to develop the reports and customizations for the client.
  • Preparing weekly status reports to be send to client
  • Involved in customizing the Project Accounting suite for reporting activities in order to record and see the monthly P&L by Project Number.

Environment: OAFramework10g, Workflow builder2.6, Oracle 9.2.0.5.0, 10g Release 2, Oracle Apps R12.0.6, Discoverer 10 G, Report Builder 6i, 10g, Form Builder 6i, 10g UNIX and TOAD, JAVA, Oracle Project Accounting (PA)

Confidential

Oracle PL/SQL

Responsibilities:

  • Requisition interface done in I procurement module
  • Print purchase order report
  • Change requisition approval workflow notification.
  • Developed Advance pricing form in OM
  • Consolidated the existing CRM systems into one to-be system.
  • Developed and maintained customizations in Oracle Field Service (11i and R12)
  • Worked on Oracle Field Service Afterhours implementation for the client

Environment: OA Framework, Oracle 9i, PL/SQL, P2P, JAVA, Report Builder 6i, Form Builder 6i, XML Publisher, Discoverer 10G, CRM

Confidential

Oracle Technical Developer

Responsibilities:

  • Developed and Reviewed & tested the deliverable components as per standards and guidelines provided by client
  • Testing rdf /xml reports in client’s testing environment (Development, QA, Production)
  • XML reports on OM, AR, OPM and AP.
  • Discoverer reports in development.
  • Developed Interfaces for OPM module
  • Documentation using AIM methodologies of MD50’s, MD70’s.
  • Extensive experience in database query tuning (Explain Plan and TKPROF utility) of Reports.
  • Customized seeded reports such as Invoice print report, Commercial Invoice, Customer Invoice report, Print Selected Invoice, transaction detail report, Account Status report in AR.
  • Developed Reconciliation Report using XML Publisher (BI Reports) Reporting Tool
  • New oracle apps forms developed varies modules

Environment: Report Builder 6i, Form Builder 6i, XML Publisher, Discoverer 10G

Hire Now