SUMMARY:

• Around 11 years of experience as an Oracle Applications Technical Consultant (E - Business Suite 11i & R12) with expertise in Financials modules (AP, AR, GL, FA and CM), Oracle SCM Modules (INV and PO) and Project Accounting (Costing & Billing). Experience in Implementation (11.5.10.2, 12.0.4, 12.1.3) Support and Upgrade projects (12.0. 4 to 12.1.3)
• Hands-on involvement in business requirement, GAP analysis, process mapping, solution analysis, development, source control and deployment.
• Extensive experience in developing and supporting Oracle ERP modules (GL, AP, AR, FA, INV, PO, PA) and custom solutions.
• Involved in full life cycle Implementation Projects of Oracle E Business Suite 11.5.10.2, 12.0.4, 12.1.3.
• Technically Proficient in designing, developing and troubleshooting Forms, Reports, Interfaces, Customization and Extensions (FRICE) in Oracle Applications.
• Experience in implementing EBS Business cycles like Procure to Pay (P2P) and order to cash (O2C) cycles.
• Extensive experience in source/existing/legacy system business functionality and preparing the Technical design documents (MD070), Technical Test documents (TE020), Conversion (CV050) and Migration documents (MD0120).
• Expertise in design and development of Interface/Conversion programs to import data from legacy systems and integrate it into Oracle Applications using open interfaces and APIs.
• Experience in XML/BI Publisher reports and using various templates to publish the reports as per user requirements.
• Experience on Outbound Interfaces to extract the data from Oracle Application database to data files using UTL FILE utility
• Expertise in the Oracle Applications Technology layer like: Oracle Applications Object Library (AOL/FND), System Administrator.
• Good Experience in Forms Personalization’s and Alerts
• Experience in Oracle Application Framework Technology (OAF) and MVC architecture.
• Experience on VO, EO and Controller Extensions of OAF Pages
• Strong programming experience in creating Packages, Procedures, Functions, Triggers and other database objects using SQL and PL/SQL.
• Experience creating SQL*Loader control programs and PL/SQL validation scripts for validating and pre-import processing legacy data from feeder systems to Oracle Applications.
• Ability to communicate well at the user level and technical levels and to breakdown complex problems into manageable parts and develop alternative solutions
• Self-starter with potential, initiative and a positive attitude. Able to meet very stringent deadlines and always deliver the package
• Keen and enthusiastic with constant desire to learn and a commitment to excel.

TECHNICAL SKILLS:

Oracle EBS: Oracle Apps 11.5.10.2, 12.0.4, 12.1.3

Modules: Project Costing and Project Billing (PA), Payables (AP),Receivables (AR), General Ledger (GL),Fixed Assets(FA), Purchasing (PO), Order Management (OM), Inventory (INV)

Tools: /Utilities: D2K (Reports 6i/10g, Forms 6i/10g), XML/BI Publisher, Workflow Builder, J Developer(OAF), SQL* Plus, SQL * Loader, SQL Developer, WINSCP, TOAD, Putty

Databases: Oracle 9i/10g

Languages: SQL, PL/SQL, UNIX

Operating Systems: Windows XP/7/Server 2003, Linux

WORK EXPERIENCE:

Confidential

Assistant Consultant (Senior Oracle apps Technical Consultant)

Responsibilities:

• Development of on Supplier Conversion using Open Interfaces
• Implemented custom logic to the existing Customer Interface Program.
• Designed and developed database packages (Migration Programs and Interfaces), procedures, and functions on Oracle 10 g databases
• Defined flex fields using Application Object Library (AOL). Registered Concurrent Programs and standard request submission in AOL during the process of development.
• Developed Event based alert for sending payment advice by mail to vendors on completion of payment.
• Implemented form personalization’s like restricting in not selecting advance accounts in standard invoices and only selecting advance accounts in AP
• Involved in testing various custom programs and process flows.
• Analyzed defects and defect fixing
• Analysis of Functional (MD050) & Technical (MD070) Specifications and appropriate modification of concerned object.
• Worked as a Support Consultant on various modules like financial, Inventory and Purchasing.
• Resolved client issues/problems and prepared root-cause documents. If the issue was with the standard process, worked with Oracle support team and implemented the necessary changes in oracle applications.
• Developed the custom reports, Oaf Personalization’s as per the business requirement.
• Performed thorough testing before moving the changes/objects to the production.
• Prepared all necessary documents to move any object into the production environment.

Solution Environment: Red Hat Linux, Oracle 10g databases, Oracle EBS 12.1.3

Tools: /Modules: SQL, PL/SQL, Oracle-reports, XMLP, Oracle-Workflow and OAF, PO, INV, AP, AR, GL

Confidential

Sr. Oracle Apps Developer

Responsibilities:

• Actively involved in the development of Custom applications like Bill Tracking System, Logistics Module, Export-Import Logistics Module etc.
• Also involved in developing interface of above mentioned applications with oracle payables module and raising bills for the same system.
• Developed Client Billing Module and provided interface from custom billing generated events to create invoices in projects modules (PA).
• Developed Custom Measurement Book forms to measure various types of works.
• Projects also involved integration of custom HRMS module with oracle apps and bringing important data from custom application to oracle apps environment
• Created a custom workflow with 12 approver levels for custom purchase order(PO) pre-approval process
• Reviewed MD-50 and Created MD-70 documentations.
• Developed Host 2 Host Integration module to push data of all the payments made on bank to bank site for making online transfer of payments.
• Developed Scrap Application for enabling Scrap sale and raising Scrap Sale order in System.
• Co-ordinated with the functional consultants and gathered requirements.
• Defined Descriptive Flex fields, value sets and also registered PL/SQL stored procedures, SQL*Plus scripts etc.
• Developed Many MIS Reports like Cash flow, L1and L2 level reports using XML publisher.
• Developed ledger reports, Ageing reports on advances, Bills Payable Bills in Accounts Payable (AP) module Developed Sales Register, Sales Summary and Ageing reports in Accounts Receivables(AR) module
• Developed PO Register Report which provides details of Material Receipts and Invoices raised on a Purchase order
• Developed many other reports to meet the Client Requirements.
• Developed many forms personalization’s to implement business controls on invoices(AP) and purchase order (PO)screens
• Worked on Performance related issues and fine-tuned system processes which improved the operational efficiency.
• Involved in development of new enhancements and helped the team members understand the processes.

Solution Environment: Red Hat Linux, Oracle 10g databases, Oracle R12 EBS (12.1.3)

Tools: /Modules: Toad 7.6, xml publisher, Oracle Forms, Reports, BI Publisher, Oracle Workflow Builder 2.6., INV, PO, PA, AR, AP, GL.

Confidential

Oracle Apps Technical Consultant

Responsibilities:

• Actively involved in the development of major interfaces and Data Migration.
• Implemented Projects (PA), SCM (PO, INV) and Finance (AP, AR, GL) modules for the Clint.
• Developed custom components in Projects and SCM modules to consolidate the different streams.
• Worked on Auto Invoice Interface Program to validate and load credit memos, debit memos and invoices from legacy system.
• Worked on Purchase Order Import Interface which validates Purchasing & inserts into Interface Tables and calls import Standard Purchase order program to create Purchase Orders.
• Co-ordinated with the functional consultants and gathered requirements.
• Involved in developing code for data migration activities.
• Gained knowledge in the processes involved in Project Modules.
• Developed Reports using XML publisher.
• Customized AR Invoice Aging Report as per the client requirements
• Developed Many Financial Reports to meet the Client Requirements.
• Worked on Performance related issues and fine-tuned system processes which improved the operational efficiency.
• Involved in development of new enhancements and helped the team members understand the processes.
• Bug fixes and Performance Tuning
• Involved in impact Analysis and done EQA for many components.

Solution Environment: Red Hat Linux, Oracle 10g databases,, Oracle 10g databases, Oracle R12 EBS (12.1.3)

Tools: /Modules: Toad 7.6, xml publisher, Oracle Forms, Reports, BI Publisher, Oracle Workflow Builder 2.6., INV, PO, PA, AR, AP, GL.

Confidential

Oracle apps Technical Consultant

Responsibilities:

• Actively involved in running the scripts suggested by oracle for up-gradation
• Changed custom components like forms and reports to meet the up gradation standards
• Customization changes for interfaces, PL/SQL Packages and procedures
• Defined new Lookups, DFFs
• Co-ordinated with the functional consultants and DBA’s for upgradation without any issues.
• Involved in developing code for data migration activities.
• Worked on Performance related issues and fine-tuned system processes which improved the operational efficiency.
• Involved in impact Analysis and done EQA for many components.
• Technical Specifications, MD-070, Design Documents
• Unit Test Specifications, Integration Testing

Solution Environment: RHEL/Solaris 5.9, Windows NT & XP, Oracle 10g databases, Oracle R12 Applications

Tools: /Modules: Toad 7.6, xml publisher, Oracle Forms, Reports, BI Publisher, Oracle Workflow Builder 2.6.

Confidential

Oracle apps Technical Consultant

Responsibilities:

• Actively involved in the development of major interfaces.
• Developed custom components in Inventory module (INV) like Material Receiving Register (MRR), Material requisition cum issue voucher (MRIV), Material Return Voucher (MRV) and interfaced the same with standard inventory module.
• Customization changes for interfaces, PL/SQL Packages and procedures
• Defined flex fields using Application Object Library (AOL). Registered Concurrent Programs and standard request submission in AOL during the process of development.
• Worked on Purchase Order Import Interface, the interface validates Purchasing & inserts into Interface Tables & calls Import Standard Purchase order program & creates Purchase Orders.
• Worked on Supplier Conversion to import the Suppliers from the existing legacy systems into Oracle.
• Analysis of Functional (MD050) & Technical (MD070) Specifications and appropriate modification on modification of concerned object.
• Involved in developing code for data migration activities.
• Developed Reports using XML publisher.
• Used UTL FILE to read and write data from the files located on the server.
• Developed many custom reports like cash flow statements, Ageing of payables and receivables and Schedules as per Local Govt. Requirements
• Developed Fixed Asset Register and Asset Account Analysis report in FA module.
• Worked on Performance related issues and fine-tuned system processes which improved the operational efficiency.
• Involved in development of new enhancements and helped the team members understand the processes.
• Responsible for developing Custom Packages, Procedures and Functions using PL/SQL.
• Proactively tuned SQL queries leading to significant improvement in system response time and efficiency.
• Involved in impact Analysis and done EQA for many components.
• Technical Specifications, MD-070, Design Documents
• Unit Test Specifications, Integration Testing

Solution Environment: RHEL/Solaris 5.9,Windows NT & XP, Oracle 10g databases, Oracle R12 EBS(12.0.4)

Tools: /Modules: Toad 7.6, xml publisher, Oracle Forms, Reports, BI Publisher, Oracle Workflow Builder 2.6.PA,INV,PO,AP,AR,GL,FA,CM

Confidential

Technical Consultant

Responsibilities:

• Actively involved in End to End process of Implementation from requirements gathering to Post Production activities
• Worked closely with Functional Team to get the required inputs on MD-50's and involved in design review sessions.
• Involved in creation of technical design document(MD070)
• Developed Invoice Load interface from Legacy System to Account Payables.
• Worked on Supplier Conversion to import the Suppliers from the existing legacy systems into Oracle.
• Worked on Trial Balance Reports in General Ledger(GL)
• Involved in development of new enhancements
• Involved in development of custom reports and customization of standard oracle reports
• Creation of Lookup sets, value sets
• Enabled descriptive flex fields to facilitate additional information.
• Involved in impact Analysis
• Worked on Forms Personalization to meet business requirements.
• Involved in Automation of daily routine activities through scheduled scripts
• Worked as an Oracle System Administrator for the project with major activities including creating Concurrent Programs and managing Users.

Solution Environment: RHEL/ Solaris 5.9, Windows NT & XP, Oracle 10g databases, Oracle EBS 11i (11.5.10.2)

Tools: /Modules: Toad 7.6, Forms 10gi, Reports 10g, Oracle Workflow Builder 2.6., Oracle Applications PA,INV,PO,AP,AR,GL,FA,CM

Confidential

Oracle Developer

Responsibilities:

• Requirements gathering and Analysis.
• Preparation of components for entering time sheets and Customer Billing Process
• Prepared configuration documents and test cases
• Preparation of reports for employee evaluation and billing to clients and reports for analyzing.
• Provided SIT and UAT Support.
• Involved in performance tuning of forms, reports and stored procedures
• Involved in creation of Packages, Procedures, Functions, Triggers, Tables, Views

Solution Environment: Oracle 9i, Oracle Developer, UNIX.

Tools: T.O.A.D, PL/SQL, Oracle Forms, Reports

Confidential

Oracle Developer

Responsibilities:

• Requirements gathering and Analysis.
• Preparation of components for Store Activities like Material Receiving, Material Requisition and Issue, Material Return, OSR and Damage, Road Permits etc.
• Prepared configuration documents and test cases
• Preparation of reports for various analysis like stock card, OSRD, Material Receipts like supplier and item wise, Material issue like Contractor wise and item wise
• Involved in creation of tables, views, triggers and stored procedures
• Provided SIT and UAT Support.

Solution Environment: Oracle 9i, Oracle Developer, UNIX.

Tools: T.O.A.D, PL/SQL, Oracle Forms, Reports