We provide IT Staff Augmentation Services!

Senior Oracle Application Consultant Resume

SUMMARY

  • Over 12 Years of professional experience as Senior Oracle Application Consultant in Analysis, Design, Development, Testing and Implementation of Software Applications using Oracle Applications R12/11i spreading across Implementations, Migration / Version upgrades, Data conversions.
  • Extensive Technical / Functional expertise in Oracle Applications R12/11i SCM /Manufacturing and Finance modules modules OM, PO, INV, AP, AR, GL WSH, Isupplier,Iprocurement,BOM,WIP,ASCP, Install Base, Service contract and FA.
  • Experience in Production support for Oracle Order Management (O2C) and Procure - to-Pay (P2P) , Advance supply chain planning module (ASCP), HR, Payroll, AME for various clients.
  • Experience of Development, Interfaces & Data Conversion, Implementation, Customizations ASCP, Accounts Payables, Accounts Receivable, Purchasing, Order Management, Shipment,Prcing,Insatll Base and Inventory modules.
  • Hands-on involvement in business requirement, GAP analysis , process mapping, solution design, configuration , setups , work arounds, interfaces and user training.
  • Expertise in Design, Development and Customization of RICE W (Reports, Interface, Data Conversions and Extensions/Customization) using tools like PL/SQL, SQL*Plus, Oracle*Forms 10g/6i/4.5, Oracle*Reports 10g/6i, Workflow, Oracle Business Intelligence 11g, XML/BI Publisher tool, SQL*Loader, UNIX shell scripts, OAF and ADF .
  • Extensive Industry Experience in implementing and testing Order-to-Cash (O2C) , Procure-to-Pay (P2P) , Sales Orders to ASCP , WIP to ASCP , ASCP to WIP and ASCP to Purchase Supply Business Process flow s .
  • Strong programming experience in creating Procedures, Packages, Functions, Triggers and other database objects using SQL, PL/SQL and Adv. PL/SQL.
  • Experience in creating and customizing existing reports using BI and Reporting Tools like Oracle Discoverer, Reports 10g/6i/4i, Oracle Business Intelligence 11g,and XML/BI Publisher tool.
  • Extensive experience in Conversions and interface coding for various modules and Performance tuning
  • Expertise in preparation of AIM Methodology Documents like MD70, MD120, TE120, CV40, CV60,CV80,CV90 CV120 and BR100 .
  • Involved in various testing phases (unit testing, functional, system integration, volume and user acceptance) of implementation projects and Go-Live activities like Technical checkout, doing functional setups and components functionality checkout by executing couple of key test cases in existing production environment.
  • Extensive experience in Implementation/Support/ Migration of various Oracle Applications releases.
  • Developed Interfaces/Conversions (inbound and outbound) using Open Interfaces and API’s. Also developed Extensions to add additional validations and functionality to seeded oracle processes to meet the client’s requirements. Customized seeded forms using forms personalization and CUSTOM pll
  • Performance Tuning by implementing materialized views with query rewriting, creating appropriate indexes, usage of hints, rebuilding indexes and also used the Explain Plan.
  • Experience in Application System Administration activities like application user setup, defining responsibilities, value sets, flex fields, registering menus, forms, reports, concurrent programs and migration tool KINTANA and FNDLOAD script.
  • Experience in creating, managing and resolving TAR/SR (Technical Assistant Request or Service Request) with Oracle Support. Managed and monitored TAR’s for several P1 issues.
  • Very Good understanding with Trading Community Architecture (TCA).
  • Excellent analytical, problem solving, communication and interpersonal skills with the ability to interact with individuals and teams at all levels.

TECHNICAL SKILLS

Application Technology: Oracle Applications 11i & R12

Modules: OM,PO,Pricing,WSH,WMS,INV,MES,BOM,WIP,ASCP,AP,AR,Isupplier, iProcuremen, Billing, and Install Base

Languages: SQL / PLSQL, C, Java

Database / RDBMS: Oracle 8i, 9i,10g,11g

Tools: Toad / JDeveloper , PUTTY, Win SCP, KINTANA, FTP, SQL * Loader, Data Loader , Workflow, Business Intelligence, BI Publisher, Discoverer, Oracle Forms and Reports 6i and 10g,QC,Service Now, PVCS,VSS and CVS.

Operating Systems: MS Windows 2000,Windows server 2003, Unix, Linux and Solaris

Graphic tools: MS Visio

Document tools: MS Office.

PROFESSIONAL EXPERIENCE

Confidential

Senior Oracle Application Consultant

Responsibilities:

  • Work closely with the Business Analysts and Functional Consultants to gather requirements for conversions, Transformation / HCM extracts and reports for Oracle fusion HCM implementation .
  • Develop technical design and documentation for data transformation - HDL / PBL objects from ADP system.
  • Prepare data templates for core HR objects - Basic Worker, person information, assignment, Bank, Profiles and contacts.
  • Participate in the design, development and maintenance of Conversions, Transformations, Extracts, Interfaces to/from Oracle’s Suite of Business Applications and BIPI /OTBI reports.
  • Participate in the design, development and maintenance of technical design Extracts for Fusion HCM to Benefit Integration.
  • Design, Document and Perform Unit Testing to validate product functionality.
  • Supporting issues related to O2C / P2P cycles and involving in process and smooth execution of both process
  • Working on outbound, inbound interfaces and customized packages in P2P and O2C cycles for bug fixing and enhancements.
  • Perform user acceptance and other required activities for Oracle implementation projects.

Environment: Oracle Fusion HCM 11g, Oracle e-Business Suite 12.2.3, ADP, PL/SQL, BI publisher, Oracle Business Intelligence 11g,SQL loader, Oracle Forms 10g, Oracle Reports 10g, STAT,SVN, WINSCP, Control- M and Putty.

Confidential

Senior Oracle Application Consultant

Responsibilities:

  • First Canadian Title Insurance Company uses GEI system to interface AP, AR Invoices and GL accounting transactions to Oracle. These invoices originate from various source systems like Time, Motion, etc. and will be interfaced to GEI. GEI will send this information to Oracle through an interfaces .
  • Writing technical /Functional specifications for RICE components, delivering MD50, MD 70, MD 120, TE20, CV60/80/90 and CV120 .
  • Involved in design and implementing code for Process.
  • Involved in design and developing all the packages (Interfaces, Conversions and Reports (RDF/ BI Publisher / Business Intelligence) needed for the custom process.
  • Involved in Unit Testing, QA, Integration Testing, Regression and UAT of different Modules.
  • Worked on Oracle Managed File Transfer (MFT) for file transfer to and from external system.
  • Worked on outbound (Workday, EDI and Salesforce), ADP EMP inbound interfaces and customized packages in finance modules for bug fixing and enhancements for other orgs.
  • Working with oracle support team for smooth execution business process and fixing oracle standard functional issues.
  • Provided On-Site support to the Client in resolving Cases (issue). Also create new Service Requests or if necessary in Meta-link to solve the issues by applying additional Patches if required.
  • Supporting issues related to O2C and P2P cycles and involving in process and smooth execution of both process.
  • Worked on form, OAF personalization and form Customization and report customization using Forms 10g, Reports 10g, Oracle Business Intelligence and BI Publisher.

Environment: Oracle e-Business Suite 12.2.3, AP, AR, HR, Payroll and GL, PL/SQL, Oracle Workflows, Oracle Forms 10g, Oracle Reports 10g, BI publisher, Oracle Business Intelligence 11g,SQL loader, OAF, STAT,SVN and OAT,WINSCP, MFT and Putty .

Confidential

Senior Oracle Application Consultant

Responsibilities:

  • Writing technical /Functional specifications for RICE components, delivering MD50, MD70 & MD120 .
  • Monitoring and supporting Standard / Legacy Data Collection ASCP (value chain planning) plan run process for smooth execution of planning process.
  • Provided On-Site support to the Client in resolving Cases (issue). Also create new Service Requests or if necessary in Meta-link to solve the issues by applying additional Patches if required.
  • Supporting issues related to Q2O, O2C and P2P cycles and involving in process and smooth execution of both process.
  • Working with oracle support team for smooth execution business process and fixing oracle standard functional issues.
  • Working on outbound (SOA, EDI and Salesforce), inbound interfaces and customized packages in SCM /ASCM (ASCP) modules for bug fixing and enhancements.
  • Working on form, OAF personalization and form Customization and report customization using Forms 10g, Reports 10g and BI Publisher.

Environment: Oracle e-Business Suite 12.1.3, OM, WSH,INV, PO, BOM, WIP,ASCP, PL/SQL, Oracle Workflows, Oracle Forms 10g, Oracle Reports 10g, BI publisher, SQL loader, OAF,JDeveloper, WINSCP,KINTANA,CVS,QC.

Confidential

Senior Oracle Application Consultant

Responsibilities:

  • Writing technical /Functional specifications for RICE components, delivering MD50, MD70 & MD120 .
  • As a part of Kinaxis (Planning) Rapid Response implementation, have developed new interfaces to support data import from ERP to Kinaxis (Planning ) and file transfer process using unix scripting.
  • Monitoring and supporting Standard / Legacy Data Collection ASCP plan run process for smooth execution of planning process.
  • Provided On-Site support to the Client in resolving Cases (issue). Also create new Service Requests or if necessary in Meta-link to solve the issues by applying additional Patches if required.
  • Supporting issues related to O2C and P2P cycles and involving in process and smooth execution of both process.
  • Working with oracle support team for smooth execution business process and fixing oracle standard functional issues.
  • Designing the custom collection and plan cycle in oracle ASCP
  • Working on outbound, inbound interfaces and customized packages in SCM /ASCP (Value Chain Planning) modules for bug fixing and enhancements.
  • Customization in the ASCP collection hooks to manipulate data before loading to ASCP base tables as per business requirement.
  • Working on form personalization and Customization and report customization using Forms 10g .
  • Creating New Forms, Menu Items, and Defining Concurrent executables, Concurrent Request for Customized Oracle Forms Applications, Oracle Reports, Oracle PL/SQL procedures and package.

Environment: Oracle e-Business Suite 12.1.3, OM, WSH,INV, PO, BOM, WIP,ASCP, GOP,PS,,GL,Kinaxis, PL/SQL Developer, Toad, Oracle Workflows, Oracle Forms 10g, Oracle Reports 10g, Data Loader, SQL loader, Advanced Queuing and WINSCP,Kintana,CVS,Service Now.

Confidential

Technical Lead

Responsibilities:

  • Analyzed, designed, and implemented various support and enhancement activities.
  • Involved in Functional Point Estimation and Time Estimation for Deliveries and also involved in repository Migration from Star team to Subversion as well as arranging technical sessions for the team.
  • Handled a team and managed on-time deliveries with zero defects. Trained new team members by arranging KT sessions.
  • Assisted in project planning and delivery schedule for the project.
  • Responsible for preparing function point estimation, Project Metrics, Defect tracking and root cause analysis reporting.
  • Provided functional support for various modules of the Oracle Applications: HRMS Suite like User Interaction, Core-HRMS, Payroll.
  • Analyze and develop reports using Oracle Reports / BI publisher Reports and Tableau and Form personalization .
  • Worked on Standard API, outbound, inbound interfaces and customized packages in HRMS Module.
  • Worked on outbound interface which integrate Sales Force and done the end to end testing.
  • Regular interaction with the Client Managers, End Users, Vendors of Client, System Administration experts, Subject Matter Experts, System Architecture team and QA - all belonging to different teams - during the execution of each production release of the project to ensure the seamless communication and defect resolution.

Environment: Oracle e-Business Suite 12.1.3, Oracle PL/SQL, Sales Force, Tableau, Toad, Oracle Workflows, Oracle Forms 10g, Oracle Reports 10g, Data Loader, SQL loader WINSCP,Kintana,CVS and Service Now.

Confidential

Technical Lead

Responsibilities:

  • Provided On-Site support to the Client in resolving Cases (issue). Also create new Service Requests or if necessary in Meta-link to solve the issues by applying additional Patches if required.
  • Writing technical /Functional specifications for RICE components, delivering MD50, MD70 & MD120 .
  • Handled a team and managed on-time deliveries with zero defects. Trained new team members by arranging KT sessions.
  • Assisted in project planning and delivery schedule for the project.
  • Responsible for preparing function point estimation, Project Metrics, Defect tracking and root cause analysis reporting.
  • Monitoring and supporting Standard / Legacy Data Collection ASCP plan run process for smooth execution of planning process.
  • Re-designed Buyer assignment interface program to improve the performance.
  • Developed GL Submit Syteline Import Journals interface.
  • Technical Design Documents and reviewed other TD's.
  • Extensively used FND APIs like FND FILE, FND SUBMIT, FND MESSAGE, FND PROFILE, FND PROGRAM and FND REQUES T.
  • Solved functional based queries from user.
  • Involved in functional setups includes (Profiles, Lookups, Employee details modifications, Buyer, Sales persons )
  • As part of Enhancement, added new business logic in existing customer workflow .
  • Worked on outbound, inbound interfaces and customized packages in (OM, PO, INV, BOM, WIP,EAM, AP, AR, AME,I-supplier, I Procurement and MRP/ ASCP) modules for bug fixing and enhancements.
  • Worked on form, OAF personalization, customization and report customization using Report 10g.
  • Worked on XML publisher reports Enhancement.
  • Customization of custom LOVs using VO Extension in OAF page and changed the logic using Java programming.
  • Used SQL trace facility and TKPROF accurately to assess the efficiency of the SQL statements when application runs & used tools with EXPLAIN PLAN.
  • Creating New Forms, Menu Items, and Defining Concurrent executables, Concurrent Request for Customized Oracle Forms Applications, Oracle Reports, Oracle PL/SQL procedures and package.
  • Undertook performance-tuning activities on the Oracle EBS applications, concurrent manager and with exceptions in database tier.

Environment: Oracle e-Business Suite 12.1.3, OM, INV, PO,BOM, EAM,WSH,WIP,ASCP, AR, AP,GL, PA, PL/SQL Developer, Toad, Oracle Workflows, OAF,Oracle Forms 10g, Oracle Reports 10g, Data Loader,SOA,Sytline,JDEdwords Jdeveloper, Core Java,SQL loader,WINSCP,Kintana,CVS,Service Now.

Confidential, CA

Techn ical Lead

Responsibilities:

  • Worked on rebuilding the Interfaces and Customizations on OM and WSH modules.
  • Analysis and design strategy for conversion of Legacy Data into Oracle R12 Project Accounting (PA) module.
  • Handled a team and managed on-time deliveries with zero defects. Trained new team members by arranging KT sessions.
  • Assisted in project planning and delivery schedule for the project.
  • Responsible for preparing function point estimation, Project Metrics, Defect tracking and root cause analysis reporting.
  • As an Oracle Technical consultant responsible for Enhancements and Production support of RICE components in OM, WSH with Oracle Forms 10g and Report 10g.
  • Performed several setups in Inventory (INV), Order Management (OM) and Shipping (WSH) modules.
  • Worked on testing the flow of Order to Cash and Procure to Pay cycles.
  • Customized several oracle standard forms using CUSTOM.PLL and Forms Personalization.
  • Validation and code fixing of all database objects in Oracle Applications R12 OM and WSH modules.
  • Customized standard Oracle Reports by adding extra field or extra parameter to sort data in a report for order and shipment Modules.
  • Developed reports and data extracts in OM, WSH.
  • Worked on oracle standard API using PL/SQL in Order Management and advanced pricing modules.
  • Developed Finance Reports like: Comparative Sales Report, Daily Sales Report using Reports 10g.
  • Performance Tuning of Custom PL/SQL Packages.
  • Developed SQL queries to compare summary information of the standard and custom reports in Order Management.
  • Handled a team and managed on-time deliveries with zero defects. Trained new team members by arranging KT sessions.
  • Assisted in project planning and delivery schedule for the project.
  • Responsible for preparing function point estimation, Project Metrics, Defect tracking and root cause analysis reporting.
  • Performed SIT (System integration testing), End to End testing and supporting UAT (User Acceptance testing)

Environment: Oracle Applications EBS 10g/11.5.10/R12 (PO, OM, WSH and INV), Reports 6i/10g/11g, Forms 6i/10g/11g, SQL* Loader, OAF, QC, PL/SQL, Workflow builder 2.6, XML publisher, TOAD, Windows XP, WINSCP, Kintana, PVCS.

Confidential, CA

Oracle Applications Technical Consultant

Responsibilities:

  • Technical Consultant to implement deliverables on Oracle Application 11i including legacy data conversions into OM modules, custom reporting using Oracle Reports.
  • Developed Discrete Manufacturing ( Routings and BOM ) logic and used the Standard Interface Program to import.
  • Importing of BOM Resources, BOM Departments, BOM Standard Operations using Oracle API’s Bom Resources Pkg, bom departments pkg, B Std Op Pkg.
  • Designed and Developed the Item Import & Item Assignment and used the Standard Interface Program to import.
  • Prepared technical and Unit Test Case (UTC) design documentation
  • Developed item conversion to load data about the Items form legacy system into oracle applications by writing SQL loader scripts and PL/SQL scripts.
  • Involved in optimizing the performance of database objects
  • Designed Technical specs in MD 70 using Standards AIM

Environment: Oracle Applications EBS 11i (OM, INV, WSH, AR, GL), Reports 6i, Forms 6i, SQL* Loader, PL/SQL, TOAD, Windows XP, PVCS, Kintana, Winscp and QC.

Hire Now