EXPERIENCE SUMMARY

• Over 10+ years of experience in design, development, support, customization and implementation of Oracle Applications (ERP).
• Experience in working at the Client Locations and with end - users for support and understanding the functional requirements.
• Experience in Conceptual understanding and developing new requirements in Service Contracts (OKS), Service Requests (CS), Install Base (IB), Order Management (OM), Depot Repair (CSD), Warehouse Management System (WMS), Logistics modules.
• Good quality working knowledge of all the stages of Software Development Life Cycle (SDLC) and worked on define phase, build phase, test and deploy phase.
• Hands on programming experience in SQL and PL/SQL (stored procedures, database triggers, packages and functions).
• Experience in Conversions from legacy system to PO, AP, GL, OM, CS into Oracle Applications using PL/SQL, SQL*Loader.
• Developed Inbound and Outbound interfaces.
• Experience in developing Oracle Reports, Oracle Alerts, Oracle forms and customizations on Oracle workflows.
• Excellent skills in designing and developing different types of Reports using Oracle Reports 6i, Discoverer 4i & XML Publisher.
• Experience in Bug fixing and interaction with Oracle Support.
• Expertise in requirement analysis, system design, support, development, testing, documentation and design reviews.
• Create Business Requirement documents (BR doc), Functional Requirement Specification (FRS), Technical Requirement Specification (TRS).
• Worked in fine tuning of queries for faster retrieval of data and involved in resolving various troubleshoot issues.
• Expertise on Oracle Reports (RDF/XML), Oracle Forms 6i, Interfaces, Conversions, Workflows and other extensions.
• Excellent perspective on converting the client requirements into functional specifications and technical design and development using SQL, PL/SQL and Developer 6i.
• Good expertise on Release Management Tools (Kintana) and Change Management Process (CRs).
• Experience of working in R12 Implementation.
• Involved in month end activities and had done month end process which includes in closing the books and opening the periods for next cycle.
• Experience in managing and leading a team as a team leader and Project Lead and onsite-offshore coordinator.
• Ability to plan, monitor, support and deliver on time while within the budget in high pressure environments, proactive initiation and solution oriented proposition contribution.
• Excellent team player with good problem solving approach having strong interpersonal, communication, leadership skills and ability to work in a time constrained and team oriented environment.
• Proven ability to handle multiple tasks with strong technical aptitude and learning skills to adapt the rapid changing technologies and implementing the same at work.

TECHNICAL SKILLS

ERP PACKAGES: Oracle Applications 11i/R12 (Warehouse Management, Logistics, Teleservices, Service contracts, Install Base, Depot Repair, Service requests, Order management).

Programming Languages: SQL,PL/SQL.

Development Tools: Forms 6i/10g, Reports 6i/10g, Developer 2000, Toad, XML Publisher, Oracle Workflow.

Databases: Oracle 9i/10g.

Other Tools: Unix, WinSCP, Putty, Reflection X, VSS, MWA.

PROFESSIONAL EXPERIENCE

Confidential

Functional consultant/Business Analyst.

Responsibilities

• Defined audit trail for the tables related to service request, task, task assignment, repair orders, sales orders and derived a logic to show the transactions history in a report format.
• Defined Release rules, release sequence rules, pick slip grouping rules.
• Defined Document sets, shipping parameters like freight carriers, cost types, transit times.
• Defined customers, grants and role definitions, defaulting rules.
• Created order management transaction types and assigned respective workflows.
• Defined hold sources for the products failed QA and hold the products awaiting shipping.
• Created Sales order conversion package using the standard API's.
• Created a defaulting rule package to derive default attributes on the sales order. i.e. Schedule ship date.
• Having a good knowledge on Order management to Service Contract flow.
• Worked on Service Contract flow for subscription items.
• Assisting the business in Order creation, releasing and shipping the sales order. Helping the users in finding the issue with the orders and the required setups.
• Solved the issues during month end which are stuck in shipment corrections form, pending inventory transactions, pending shipping transactions.
• Conducted requirement gathering sessions, POC sessions with business users.
• Worked with the development team in delevloping reports, interfaces, conversions, forms, etc.
• Created multiple reports to show repair order diagnostic codes, repair history reports, POA turn around reports for repair and replace orders, product calibration, repair order lines with no notes.
• Developed service contract conversion program.
• Developed item reservations package to reserve the orders based on specific sub inventory and locator.
• Developed service contracts renewal notification mailer program which sends notifications to the users when contracts are expiring in next 6 months.
• Created a new service contract template which can be used to create new contract automatically without entering the fields information everytime.
• Developed Install Base interface program to create item instance, update item instance.
• Developed Contract Inbound Interface for Oracle Service Contracts.
• Involved in Field Service Setups for CRM Foundation, Install Base, and Service Contracts.

Confidential

Business Analyst/Technical Analyst.

Responsibilities:

• Understanding the business process and help them in solving issues.
• Handling month end process. Co-ordinate with business, warehouse, third party logistics and IT to see month end goes smooth. Close accounting books on time.
• Defining picking rules, put away rules.
• Defining WMS setups which include sub inventories, locators, Pick wave rules, Cycle count, Warehouse management rules such as item attributes, material status, cost groups.
• Designed an interface to handle TPL transactions which involve material receiving, movement, picking and shipping.
• Hands-on on MWA (Mobile Warehouse Application) gun operating through the navigations which involves picking, shipping, receiving.
• Handles printer issues. Setting printer in oracle, assigning printers to documents, uploading zebra label format scripts to the new printers.
• Worked with kewill for shipping label generation. Created requests for the issues. Co-ordinated with shippers like FedEx and UPS.
• Fix the emergency issues occur during month end. Project the issue to CCB, get approvals from managers, work with DBA for migration, close the issue before month end close.
• Get the requirements from the business and produce the issues to change control board and get them approved for development.
• Prepare functional design documents and elaborate the issue what business is expecting.
• Assigning the work to the development team. Assisting them when struck with issues.
• Coordinating with the development team on regular basis to know the progress on the issues.
• Arrange WebEx calls with the development team when they need more information on the requirement and to understand what they are upto.
• Create test cases and test the functionality in all possible ways to check the deliverable meets the business requirement and there won’t be any interruption to the existing process.
• Assign the deliverable for user to test the functionality from user point of view.
• Work with the quality team and DBA team to get regular approvals and migrations done properly to move the object to production.
• Get the approvals from the business when the deliverables meet the business criteria.
• Work on critical and priority issues and help business in having a smoother process.
• Work with oracle to create service requests and get a better solution.
• Schedule meetings and give cross functional training to IT and also to business. Make business user friendly with the oracle ERP application. Assisting the business on time.
• Key player in few projects which needed a change in third party logistics for a better and fast process of inventory allocations, shipping holds, item inspection process.
• Managed multiple sites across the globe.
• Analyzes the feasibility of, and develops requirements for, new systems and enhancements to existing systems; ensures the system design fits the needs of the users.
• Defines and documents customer business functions and processes.
• Experience in handlings external customers and partners.
• Conduct the change impact analysis to assess the potential implications of changes and documents court business rules, functions and requirements.
• Participate in all the reviews with External and Internal stakeholders.
• Participates in User acceptance testing, Business acceptance testing of new system functionality.

Confidential

Technical Consultant / Team Lead.

Responsibilities

• Created a new program in R12 which will create service request automatically whenever the contract is Active and the service request will fire the tasks respectively based on the contract terms and conditions.
• Customized the Order lines workflow and enabled DFF in the parts requirement form, so that the shipping method which is entered in the DFF should show in the orders.
• Created a new program such that the call closes automatically whenever the contract expires.
• Customized CUSTOM.pll and changed the record group used for the LOV to display records.
• Created new alert for the records that are error while debrief call closing.
• Customized the post sales custom form to display email address in place of user id column and made the email field as mandatory.
• Modified and customized the custom forms as per the requirement.
• Developed a package to create an Automate Sales Order by doing upload of the data from the flat file.
• Worked on CUSTOM.pll to solve some issues related to forms.
• Solved support issues on forms and packages which requires small changes to be done in order to have a smooth business flow.
• Created an oracle alerts which sends required information to the recipients, so that user can easily check the transactions happening on daily basis.
• Worked on install base API’s which will create an instance and also on install base transaction API.

Confidential

Technical Consultant

Responsibilities

• Developed new package for Automatic closure and updating opportunity based on sales order customization.
• Developed new form which is going to displays the information about items quantity details in the query mode.
• Developed new package for the install base using an API in order to update or create the install base.
• Developed a package such that, if there is change in the SR for customer address or customer basic info from install base, need to create a package which automatically updates the customer information into the install base.
• Customized Physical inventory tags printing report. This report currently prints one tag for page. Customize the report to have two copies of same tag per page, one should label as data entry and another as post on product.
• Modified the custom workflow which will show the credit memo invoice for the parts requested. This workflow needs to have comments displayed in the header section for referral purpose.
• Allocating work items for resources and tracking.
• Providing technical assistance to the team.
• Implemented onsite and offshore resource model.
• Reporting the status to IT manager/PMO, during the design phase doing LLD.

Confidential

Technical Consultant

Responsibilities:

• Designed and developed AP, GL related Interface programs to synchronize the data between existing Legacy system and Oracle Database
• Involved in setup of Set Of Books(Currency,Calendar,Chart of Accounts).
• Developed Oracle inventory outbound interface to extract the data from tables into the Legacy flat files.
• Developed new form which is going to displays the PO information related for a particular supplier and site.
• Customized Oracle standard form to call another form which is going to call another form by using ZOOM functionality.
• Customized Sales order acknowledgement report which will displays the customer sold to and other information.
• Developed PO-Release Report which will displays the information about the Released BLANKET PO’s.
• Responsible for TAR creation and follow-up with Oracle consultant for a standard issue.
• Co-ordination with end-users during the entire course of the project
• Customized Purchase order print report.
• Customized Oracle standard form to enable zoom functionality and as well as enable the Menu option.
• Prepared Program Specifications of Reports and developed them in Oracle Reports 6i.
• Development and enhancement of forms in Oracle Forms 6i.
• Developed interface program to Upload items into GL interface tables from Legacy System in Oracle General Ledger and Used SQL * Loader to upload data from Flat Files to Pre-interface table and wrote a PL/ SQL Procedure for all the business validations.
• Developed Out bound interface to upload Back Order data from base tables to flat file.
• Developed PO and AP Analysis Report.