We provide IT Staff Augmentation Services!

Oracle Apps Technical Lead Resume

2.00/5 (Submit Your Rating)

New York, NY

PROFESSIONAL SUMMARY:

  • Total 8+ years of IT experience in Oracle Applications as Oracle Apps Technical Consultant.
  • 5+ years of implementation experience in Procure to Pay(P2P) and Order to cash(O2C) cycles.
  • Having 3+ years of experience in implementation of Core HRMS, Payrolls, OAB.
  • 7+ years of experience in SQL, PL/SQL, SQL*PLUS, TOAD
  • Good experience in business analysis, system integration, design, development, customizations implementation, System/functional and integration testing of ERP applications.
  • Worked extensively onR12 Implementations, Oracle 11i to R12 Upgrades and support experience in Procure to Pay(P2P) and Order to cash(O2C) cycles
  • Diversified technical expertise in Oracle Applications 11i /R12 with extensive exposure in development of Interfaces, Conversions, APIs, dealing with Sys Admin and Application Object Library (AOL).
  • Capable of Performance Tuning, Optimizing SQL and PL/SQL scripts.
  • Extensively worked on Cursors, Functions, Procedure, Packages as business requirements using PL/SQL.
  • Involved in developing Interface Objects for Inbound and Outbound Interface process.
  • Worked on Implementation of Agile projects.
  • Good Knowledge on Informatica, DAC, RPD designing and OBIEE Reports.
  • Used File Transfer Protocol (FTP) program to transfer a file from client machine to server machine and vice versa, when working on different operating systems.
  • Received KUDOS in recognition of outstanding contribution for Q1 2013.
  • Specialized in implementation, Support of Oracle applications specifically Oracle Purchasing (PO), Account Receivables(AR), Account Payables( AP), Order Management (OM), Inventory (INV), Shipping, Core HRMS,Payrolls, OAB.
  • Hands on experience in Developing and Customization Reports, interfaces and Conversions.
  • Hands - on experience in Implementations, R12 Upgrades, Testing, end-user, post-implementation support and customization.
  • Experience in writing Test Cases, Prepared Master Test Plans, did unit and integration testing and also performed Unit Testing for different PL/SQL packages.
  • Experience in SQL Loader, UTL File.
  • Experience in AIM and OUM Methodology.
  • Hands on experience on Shell scripts and developed oracle patches for code migration.
  • Extensively worked on XML/BI Reports.
  • Sound knowledge in Sysadmin Concepts.
  • Hands on experience on working with TCA architecture
  • Involved in functional design solutions for bug fixes and business enhancements.
  • Worked on OAFpersonalization’ Confidential and Good knowledge on ADF

TECHNICAL ENVIRONMENT:

ERP: Oracle Applications 11i, R12 E-Business Suits.

Modules: Oracle HRMS, Payroll, Advanced Benefits, OM, INV, PO,WIP,BOM

AOL: Sys Admin, AOL, Alert Manager

Oracle Tools: SQL*PLUS, SQL *Loader, Sql-Developer, Toad

GUI/Front-End: Developer 2000(Reports6i,10g), XML Publisher Reports.

Databases/RDBMS: Oracle 9i/10g.

Languages: SQL, PL/SQL.

Operating Systems: Windows 2000/XP, and UNIX.

PROFESSIONAL EXPERIENCE:

Confidential, New York, NY

Oracle Apps Technical Lead

Responsibilities:

  • Coordinating with the offshore development team and made sure that the tasks assigned were completed on time.
  • Defining payroll, consolidation sets, element sets, assignment sets
  • Defining recurring, non-recurring, standard, non-standard elements
  • Setting up various payroll processes
  • Conducting parallel runs
  • Developed Pay Group Pay report that can only run after the Payroll Process has passed the Pre-Payment Stage.
  • Developed Funding report that will contains the sum of the elements with specific Element Classification information.
  • Developed Pay Results by Department report. The Intent of this report is to provide employee gross to net information.
  • Developed Pay Input by Period report. Report will pull non-recurring elements on the pay period as well as any open-ended recurring elements at the time (all active elements on the selected pay period).
  • Developed Vacation Liability report. The intent of this report is to provide employee vacation liability as of a certain date.
  • Developed Filed Active Employees report. The intent of this report is to provide employee headcount to the security group.
  • Developed Payroll Reimbursement report. The intent of this report is to retrieve payment details
  • Involved in registration/migration of concurrent programs, executable, Creation of Responsibilities, request groups, menus, values sets, request sets, profile options, forms and functions in System Administration
  • Responsible for Migrations of the technical objects from Development instance to other testing by preparing code patches.
  • Lead the QA team in testing objects that included multiple test scenarios.
  • Documented user matrix and created Custom menu and Responsibility and Report group and Report set and Concurrent program and Executable for the custom programs.

Confidential, Greenville, NC

Oracle Apps Technical Lead

Responsibilities:

  • Involved in registration/migration of concurrent programs, executable, Creation of Responsibilities, request groups, menus, values sets, request sets, profile options, forms and functions in System Administration &AOL.
  • Interacting with client, analyzing CEMLI requirements, impact analysis, and implementation of the same. Preparing MD70 from MD50 provided by Business & creating TE20 and testing the changes and implementing the same in Test environment & production.
  • Responsible for Migrations of the technical objects from Development instance to other testing by preparing code patches.
  • Maintaining patches history and issues list to keep environment stable by optimizing the patches during respective iterations.
  • Developed Item Conversion.
  • Developed PO Requisition Conversion.
  • Developed Purchase Order conversion.
  • Extensively worked on P2P process cycle and developed multiple custom reports.
  • Developed Interface of Sales Orders Import in OM after actively participating in the preparation of the conversion mapping documents.
  • Developed Production Schedule report which displays the details of work orders.
  • Developed Project Expenditure report. The report will pull data elements relating to projects from different modules in oracle, i.e. Purchasing, Payables and Fixed Assets.
  • Worked on ACH extract payment method.
  • Developed Commission import XML report.
  • Coordinating with the offshore development team and made sure that the tasks assigned were completed on time.
  • Conducted multiple load iterations and Load tests.
  • Documented test scripts for user testing.
  • Helped PMO with user documentation.

Confidential, New Jersey, NJ

Senior Apps Techno Functional Consultant

Responsibilities:

  • Responsible Co-ordination with Client and analyzing the Design and functionality (Agile methodology).
  • Participated in all cross-functional project activities, co-ordinate the tasks to maintain the seamless integration of the application with other systems.
  • Involved in registration/migration of concurrent programs, executable, Creation of Responsibilities, request groups, menus, values sets, request sets, profile options, forms and functions in System Administration &AOL.
  • Ensured technical stability, timely support and successful integration of enhancements.
  • Lead solution sessions with the offshore technical team and cross track teams.
  • Worked with the cross functional teams to ensure the end-to-end solution works.
  • Worked with offshore Technical team to fix any issue during support.
  • Documented test scripts for user testing. Helped PMO with user documentation.
  • Developed Asian Payrolls (Indonesia, Korea, Hong Kong, China, Philippines and Thailand) Outbound interfaces.
  • Developed US ADP (US Payroll Personal Changes, US Payroll Tax Data, US Payroll 50K. Insurance, US Payroll Email Address) Outbound Interfaces.
  • Developed Delta Dental Benefits Outbound Interface.
  • Developed US Medical Benefits HCM to Blue Cross Blue Shield Outbound Interface.
  • Developed Vision Service Plan Benefits Outbound Interface.
  • Developed Bluefin Benefits Outbound Interface.
  • Developed 401K Indicative from HCM to Fidelity Outbound Interface.
  • Developed PayFlex Cobra Benefits Outbound Interface.
  • Coordinating with the offshore development team and made sure that the tasks assigned were completed on time.
  • Responsible for Migrations of the technical objects from Development instance to other testing by preparing code patches.
  • Maintaining patches history and issues list to keep environment stable by optimizing the patches during respective iterations.
  • Lead the QA team in testing objects that included multiple test scenarios.
  • Successfully handled the technical issues, communicated with senior management, resolved conflicts that arose and recommended the optimal approach.
  • Post Production Support for US entity which involves in understanding the business processes and the present setup’ Confidential .

Confidential, New York, NY

Senior Technical Consultant

Responsibilities:

  • This is an R12.1.3 Upgrade Project for the client Confidential . This project consists of close to 1500 CEMLIs for R12 Upgrade and it involves various modules like PO, INV, AP, PA.
  • Analyse all the CEMLIs, components that are in scope of this project, identify the high level changes that need to be done
  • Involved in unit testing of the CEMLIs.
  • Customized existing Oracle Reports in P2P cycle mainly on custom po reports and payables reports.
  • Co-ordinate with offshore Lead and functional persons and take weekly status calls.
  • Conducted multiple Upgrade iterations and Load tests.
  • Responsible for Migrations of the technical objects from Development instance to other testing by preparing code patches.
  • Ensured technical stability, timely support and successful integration of enhancements.
  • Organizes and document process changes and RICE object changes.
  • Maintaining patches history and issues list to keep environment stable by optimizing the patches during respective iterations.
  • Coordinating with the offshore development team and made sure that the tasks assigned were completed on time.
  • Prepared Technical design documents for CEML’ Confidential assigned.

Confidential, Houston, TX

Staff Consultant

Responsibilities:

  • This is an R12.1.3 Upgrade Project for the client SBEC. This project consists of close to 700 CEMLIs for R12 Upgrade and it involves various models like PO, INV, AP, PA
  • Analyzed all the CEMLIs, components that are in scope of this project, identify the high level changes that need to be done
  • Redesigned customer shipping reports and invoices reports
  • Developed purchase order status report.
  • Developed details po requisition summary report.
  • Involved in unit testing of the CEMLIs.
  • Developed open and closed invoices report.
  • Conducted multiple Upgrade iterations and Load tests.
  • Responsible for Migrations of the technical objects from Development instance to other testing by preparing code patches.
  • Ensured technical stability, timely support and successful integration of enhancements.
  • Organizes and document process changes and RICE object changes.
  • Maintaining patches history and issues list to keep environment stable by optimizing the patches during respective iterations.
  • Coordinating with the offshore development team and made sure that the tasks assigned were completed on time.
  • Prepared Technical design documents for CEML’ Confidential assigned.

We'd love your feedback!