SUMMARY:

• 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 like Supply Chain Modules
• (OM, INV & PO) & Financials modules (AP, AR, GL,) & Service Contracts, TCA Architecture custom solutions.
• Involved in full life cycle Implementation Projects of Oracle E Business Suite 11.5.10.2, 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 order to cash (O2C) & Procure to Pay (P2P) 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 usingUTL FILE utility
• Expertise in the Oracle Applications Technology layer like: Oracle Applications Object Library (AOL/FND), System Administrator. Concurrent Program, Form, Request group, Responsibility, Menu, Flex field Registeration.
• Good Experience on ERP Forms Personalization s and Alerts
• 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.
• Around 12 years of experience as an Oracle Applications Techno Functional Consultant (E - Business Suite 11i & R12) with expertise in Oracle SCM Modules (OM, INV and PO), Financials modules (AP, AR, GL,) & Service Contracts, TCA Architecture. Experience in Implementation (11.5.10.2, 12.1.3) Support and Upgrade projects (11i to R12)

TECHNICAL SKILLS:

Oracle Applications: Order Management Inventory Receivables Purchase Order Service Contracts TCA Architecture AP & GL Workflow Builder Flex fields Oracle API/Open Interfaces Oracle System Administration Reports / XML Publisher Form Personalizations

Technology and Tools: Oracle AIM MS Office PVCS, Kintana,SVN and APPDB Migration Oracle Developer 6i / 10g Mercury Quality Center Oracle Forms 6i / 9i / 10G /12C Oracle SQL*Plus/ PL/SQL/ SQL*Loader Mongo DB Quest TOAD,Visio

PROFESSIONAL EXPERIENCE:

Confidential, CA

Lead Consultant (Oracle apps Techno Functional Consultant)

Responsibilities:

• Worked on the 10+ Custom Oracle reports ( Holds Dollar, Active Line, Shipment Extract report ect…) in Order Management.
• Worked on the Custom Order Copy functionality for copying the 11i (Hybrid Order) into R12 for full fillment.
• Developed Custom ZOOM form for the extension of sales order form to store the additional details( Contract, serial number & Order Contacts info).
• Designed and developed database packages (Migration Programs and Interfaces), procedures, and functions on Oracle 11 g databases
• Developed the Custom Workflow Porgress program for progressing the workflow, Order Cancelations.
• Worked on the Cisco Acquisition integrations ( Like Meraki, Refurbished…)
• Part of the Meraki, Refurbished acquisition integrated the cisco ERP with external fulfillment systems through Workflow modification & PLSQL packages.
• Developed the Custom Order Copy functionality for the copying orders form SOWB.
• Registered the flex fields, LOV, Look ups, concurrent Porgrams, Profiles, form registrerations using Application Object Library (AOL) / Sysadmin Responsibility.
• Customer Creation form changes for based on the operating unit enablement.
• Customized shipping reports namely pick slip, packing list in OM, and Open Purchase order reports in PO.
• Developed Outbound Interface in Oracle Inventory module to extract the from Inventory base tables to Flat file by using the UTL FILE Package
• Developed Purchase Order Inbound Interface.
• Analysis of Functional (MD050) Technical (MD070) Specifications and appropriate modification of concerned object.
• Worked as a Support Consultant on various modules like Order Management, Inventory and Receivables.
• 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, form Personalization’s as per the business requirement.
• Go-Live Activities & Post Production Support
• Publishing reports dash board and metrics to Management and cross flow stakeholders.

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

Confidential

Monthly Release Development (Agile Process) - Lead Consultant

Responsibilities:

• Working on the Proudction bugs and enhancements based on the business impact.
• Designed and developed new database packages (Migration Programs and Interfaces), procedures, and functions on Oracle 11 g databases
• Registered new Concurrent Programs, Reports, LOV & Lookups using Application Developer resp.
• Worked on the custom order workflow enhacements.
• Prepared the Technical (MD070) Specifications with Design, Unit testing & impacted object details.
• Worked as a Support Consultant on various modules like Order Management ( Order booking,Hold definition, full fillment, invoice interface) Inventory ( Item Setups),PO, Receivables ( AI Pre Process Customizations, Reports), AP & GL.
• Resolved client issues/problems and prepared root-cause documents. If the issue was with the standard process,
• Raised the Oracle SR’s and worked with Oracle team for the same.
• Developed the custom Revenue, Invoicing ( Revenue transactions, Collector Extended Aging..) reports, form Personalization’s as per the business requirement.
• Performed thorough testing before moving the changes/objects to the production.

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

Confidential

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
• 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 for many components.
• Technical Specifications, MD-070, Design Documents
• Unit Test Specifications, Integration Testing
• Go-Live Activities & Post Production Support
• Publishing reports dash board and metrics to Management and cross flow stakeholders.
• Trade Collaborator

Confidential

Responsibilities:

• Developed the PL/SQL Package interfaces for Sending and Receving data from other DB.
• Prepare MD70 documents & Test documents
• Execute unit testing for all code components in Dev
• Migrate the code to test cycle environments for QA testing
• Fix the defect identified by QA in test cycle enviroments.
• Conduct daily meetings with onsite team and update the status.
• Setup up meetings with QA teams and help them understand code fixes being done
• Participate in Go-Live activities.
• Post Go-Live support to and fix any issues on priority.
• Provide technical KT to production support team.
• Country Enablement 3.0. Responsible for end-to-end execution of Oracle application. Developed some Customized reports for cisco based on reports 6i
• Prepare MD70 documents & Test documents
• Reports developed using Reports 6.0
• Reports registered in oracle apps as concurrent programs
• Execute unit testing for all code components in Dev
• Migrate the code to test cycle environments for QA testing
• Fix the defect identified by QA in test cycle enviroments.
• Conduct daily meetings with onsite team and update the status.
• Setup up meetings with QA teams and help them understand code fixes being done
• Participate in Go-Live activities.
• Post Go-Live support to and fix any issues on priority.
• Provide technical KT to production support team.
• Module Lead - Gams East Project (From Jan-2007 to - Jun 2009) - GE USA,
• Provided Enhancements, Production & Monitoring Support on Oracle Application 11i
• Providing SME support for all technical queries regarding Order managements & Purchase order
• Handled P1/P2 issues under production support.
• Monitoring activities in Production environments.
• Supported release activities for the development teams.
• Handled EBF and Data fixes as part of production support.
• Worked in customizing the forms and tables and Oracle applications work flow using PL/SQL.
• Involved in PL/SQL code reviews and providing Design documents including reviews with cross functional teams.
• Team Member - Agilent Technologies USA - India (From ) - Involved in development of various components in Oracle Applications 11i.