Oracle Applications -techno Functional Consultant Resume
IL
SUMMARY:
- Strong Techno - Functional consultant with 13+ years of experience in Oracle Applications in areas like Finance, SCM and manufacturing. The modules include Purchasing (PO), Inventory, Cost Management, Accounts Payables(AP), Accounts Receivables (AR), iExpense, General Ledger(GL), Alert Manager and AOL.
- Has experience in ORACLE SQL, PL/SQL, D2K and Performance Tuning of the Applications, XML Publisher and ASP.
- Expertise in Procure to Pay (P2P) and Record to Report business flows.
- Played roles of Functional Consultant, Business Systems Analyst, Module Lead and worked with team members and cross-functional team to deliver solutions across various business units.
- Oracle Certified consultant in Payables and Receivables.
- Implemented end to end setups for multiple GL ledgers.
- Adept at development and customization of Reports, Interfaces, Conversions and Extensions (RICE components) in the domain of Oracle Applications E-Business Suite (Oracle EBS) using SQL, PL/SQL, UNIX Shell scripts and SQL*Loader in the domain of Oracle Applications.
- Expertise in third party system Concur Expenses (SAP product). The works involved Requirement gathering, Developments, Credit card interface, Testing, Validations and Post production support
- Expertise in Vertex O Series system. The works involved Application and Server maintenance, Production support, Monthly tax updates, Maintaining TEC’s (Tax Exemption ) and Handling SR’s with Vertex support.
- Expertise in Design and Development of interfaces and conversion programs to integrate Oracle Applications modules to import data from various sources into Oracle Applications using Oracle open interfaces and Oracle Public API’s.
- Extensive experience in developing and customizing numerous Reports using Reports 10g/9i/6i and also generated various XML/BI Publisher reports, which included working on report development objects like data templates and RTF’s. Also used the Form Personalization for achieving the custom functionalities.
- Good Knowledge on the EDI inbounds, out bound Process and UNIX shell scripting.
- Preparing test cases, setting up test environment, assisting business in UAT testing.
- Experience in Handling the Oracle SRs and resolving with the production go live issues and other bugs.
- Excellent analytical skills in Analysis and business requirements gathering from end users to the client and experience in design using MD50, MD70, Code Review Checklists and user-documentation documents
- Strong Experience in Incident Management, Change Management and Problem management.
TECHNICAL SKILLS:
Operating Systems: Windows Family, Unix
Languages: SQL,PL/SQL,HTML and ASP
RDBMS: Oracle 8i/9i/10g/11g.
ERP: ORACLE Apps 11i and R12
ERP Modules: PO, AP, iExp, AR, FA,GL, Alert Managers, OM and Inventory
Tools: ORACLE Reports 10G, Forms 6i, SQL *Loader, PL/SQL Developer, Toad, Oracle BI/XML Publisher and UTL FILE
Third Party Systems: Concur System (SAP) and Vertex Cloud (O series 6.0)
PROFESSIONAL EXPERIENCE:
Confidential, IL
Oracle Applications -Techno functional consultant
Responsibilities:
- Requirements Gathering, Analyzing the requirement, Data Migration, Extensive work on RICE components that include Reports (RDF and XML Publisher), Conversions, Interfaces, Customizations, Data Mapping, Technical Design, Code/Script Development, issues resolution, Performance Tuning, Documentation (AIM).
- Prepared MD 70 for the Technical document.
- Created and customized reports using XML Publisher/BI Publisher in AP,AR and PO.
- Developed SQL * Loader and PL/SQL programs for data conversions.
- Responsible for performing the configuration related setups.
- Customized standard oracle reports.
- Responsible in creating Value sets, Concurrent Program Definitions, Executables, Template and Data definitions.
- Developed Inbound and Outbound Interfaces.
- Providing Vertex application maintenance and production support
- Providing Concur Expense management development and production support
- Involved in debugging various interface related issues in AP, GL and PO.
- Good at development of interface and conversion programs using PLSQL and Oracle Standard APIs.
- Participated in discussions with IT owners and preparing mapping documents in between Legacy and Oracle R12.
- Migration of legacy data to oracle using SQL*Loader and UTL FILE utilities.
- Tuning and Performance Improvement of SQL Queries.
- Experience with UNIX and Shell Scripts.
- Prepared unit test case documents and user document for the new developed components
- Coordinated with the client for the user testing process and fixing the bugs and addressing the concerns raised while user testing.
- Fixing of oracle custom report bugs and layout change as per the requirement of the customer.
- Enhancements to existing functionality using PL/SQL.
- Supporting cross system/cross functional team to deliver the capabilities on time.
- Involved in code migration activities through Kintana.
- Developed Common error handling report to capture errors in interface execution and will send email notifications to users.
Environment: Oracle Apps 11i and R12, Oracle 10g, SQL, PL/SQL, Reports 10g, UNIX Shell programming
Confidential
Oracle Applications: Techno functional consultant
Responsibilities:
- Involved in knowledge transition which focused on the existing application setup, interfaces, customizations, enhancements and history of support calls and tickets.
- The data center has been migrated and supported the newly migrated Oracle eBS and its related applications where Service Level performance is measured.
- Involved in bug fixing (Layout change due to environment change) in the custom reports.
- Performed end-to-end testing of custom components.
- Performed end to end testing of iExpense functionality and custom components during the data base upgradation.
- Involved in L2-Production Support
- Tracked the issues as Incidents through the tool called CCM.NET
- Acknowledged the incident, analyzed the issue, provided permanent resolution to the issue
- Involved in creation of new iExpense policy setups and update the existing policies based on user requirement.
- SME for iExpense module and handled relates iExpense issues
- Involved in problem management to identify the root cause for the severity incidents, recurring issues and provided permanent solution to prevent the issues.
- Handled the new enhancements and minor developments through change requests in CCM.NET
- Analyzed the business requirements and developed the custom components and prepared technical design documents.
- Fixing of oracle custom report bugs and layout change as per the requirement of the customer.
- Customization of forms using Form Personalization to meet the customer requirements.
- Enhancements to existing functionality using PL/SQL.
- Prepared unit test case documents and involved in end-to-end testing to ensure the functionality working as per the requirement.
- Coordinated with the client for the user testing process and fixing the bugs and addressed the concerns raised while user testing.
- Co-ordinate with the clients on the project meetings, Weekly review meetings, status of the project tasks (Incidents and Change Requests) and activities.
- Supported post implementation changes and maintenance.
Environment: Oracle Apps 11i, Oracle 10g, SQL, PL/SQL, Forms 6i, Reports 10g, Unix Shell programming
Confidential
Oracle Applications -Technical consultant
Responsibilities:
- Gather requirements from Functional Team and Users
- Preparation of Technical Design Documents
- To Implement and Handle the Mail Alert System
- To develop Exception Reports using Mail Alert
- To Develop XML reports based on audit requirements
- Involved in the Interface Testing
- To Tune the existing objects like Reports, Procedures and Value Sets
- Involved in the development customized reports using techniques like temporary table for the performance tuning of queries
- Customizations (Functional Design/Technical Design, Unit Testing, Integration Testing) writing Application Logic, Coding for customization using Oracle 9i database objects, SQL, PL/SQL programming, including effective use of Oracle Packages, stored procedures, database triggers and tools like SQL*Plus, PL/SQL Developer, Toad.
- Go-Live and Post implementation support
Environment: Oracle Apps 11i, Oracle 9i, SQL, PL/SQL, Forms 6i, Reports 10g
Confidential
Oracle Applications -Technical consultant
Responsibilities:
- Business Requirements Gathering Analysis and Prioritization of requirements.
- Product demos & Final recommendation of best fit
- As-Is Analysis & To-Be Analysis
- Preparation of Technical Design Documents
- Involved in analysis, design and development of the UI and business logic using Forms and PLSQL procedures and packages
- Involved in the development customized reports using techniques like temporary table for performance tuning of queries
- Involved in Form Personalization.
- Customizations (Functional Design/Technical Design, Unit Testing, Integration Testing) writing Application Logic, Coding for customization using Oracle 9i database objects, SQL, PL/SQL programming, including effective use of Oracle Packages, stored procedures, database triggers and tools like SQL*Plus, PL/SQL Developer, Toad.
- Comprehensive usage of data-warehousing and performance enhancing tools in Oracle like SQLTrace, Explain Plan, indexes, materialized views, Global temporary tables, autonomous transactions.
- Experience with file loading using SQL Loader.
- Development of Custom API using PL/SQL Involved in the development procedures which can be used as data preparation logic for data presentation tools like oracle reports and oracle alerts.
- Data Migration packages for moving data into oracle interface tables
- Worked with Data loading using SQL Loader, file manipulation and emailing capabilities of Oracle using in-built packages
- Written Oracle Back-end Packages, Procedures and Triggers required for Processing Batch Details
- Go-Live and Post implementation support & Year End Finalization Support
Environment: Oracle Apps 11i, Oracle 9i, PL/SQL, SQL, Forms 6i, Reports 10g on AIX
Confidential
Developer (D2K)
Responsibilities:
- Identifying business requirements
- Requirement analysis
- Co-ordination with team members
- Involved in Design Reviews and Code Reviews.
- Involves Software Design, Development, Testing, Implementation and Maintenance
- Involved in the development customized reports and Forms
- Extensive working in design, development and maintenance of Oracle 7i database objects, SQL, broad experience in PL/SQL programming, including effective use of Oracle packages, stored procedures, database triggers and tools like SQL*Plus
- Written Oracle Back-end Packages, Procedures and Triggers required for Processing Batch Details
- Enhance and maintain existing functionality
Environment: Oracle 9i, PL/SQL, SQL, Forms 6i, Reports 6i