SUMMARY:

• Having 14+ years of IT experience in diversified fields of Application Software System Development, Testing and Implementation . Expertise in requirements definition, business analysis, design, development, systems integration, interface design, implementation, post implementation maintenance.
• Have 13+ years work experience as Oracle Applications Consultant. As Technical and Functional Consultant specializes, in implementation, upgrade, migration, conversion and customization of Oracle e - Business Suite applications (R12, 11i) projects with major focus in Order Management (OM), Inventory (INV), Accounts Receivable (AR), Accounts Payables (AP), Purchasing (PO), WIP, Shipping, BOM, Service, Install Base Contracts and Teleservices modules.
• Good understanding on Order to Cash (O2C), Procure to Pay (P2P), Invoice to Cash (I2C), Inventory, WIP life cycles and Supply Chain business flows, with a good technical expertise on custom and standard designed components.
• Well versed with Oracle Unified Method Standards, Oracle Application Implementation Methodology (AIM), Application object Library (AOL) implementation standards, Trading Community Architecture (TCA) and software Development Life Cycle (SDLC).
• Excellent hands on experience in documenting and reviewing requirement analysis, functional design(MD50), Technical design(MD70), Unit Test Case documents, Conversion, Migration, Data Flow Designs, Production support documents.
• Have good hands on functional experience in configuring setups required in Order to Cash (O2C), Procure to Pay (P2P), Invoice to Cash (I2C) life cycles and Supply Chain business flows.
• Technically proficient in RICEW components (Reports, Interfaces, Conversions, Extensions, Workflows). Good hands-on experience in Data Migration, Report Generation and Developing Interfaces, Conversion programs, within several modules of Oracle Applications.
• Expert in developing new and customizing existing AOL objects. Developed new oracle Alerts, Lookups, Concurrent Programs, Custom Forms, Reports, Quick Codes, Menus, Flex Fields (KFF & DFF).
• Experience in Customizing Oracle Forms with Forms Personalization using Custom.pll and Zoom functionality. Adept in Customizing Oracle reports and developing new reports by using Oracle Report 6i/10g. Expertise coding skills in SQL, PL/SQL, Packages, Functions, Procedures, Triggers, Views and Indexes.
• Experience in developing Data Models, Business Dashboards related to Sales & marketing, Finance in Confidential Environment.
• Ability to Troubleshoot issues, including creation/follow-up of Oracle service requests (SRs) and to handle user defined errors by developing Error-Handling Package using PL/SQL.
• Well versed with tools like SQL*Plus, Toad, Oracle Forms, Reports, Workflow Builder, Kintana, PVCS, VSS, Putty, Quality Center, MS Visio.
• Experience in importing data from legacy systems to Oracle Applications using Oracle Interfacing, SQL LOADER, UTL FILE, Oracle packaged APIs etc.
• Well versed with concepts of Performance Tuning, UNIX shell scripting. Adept in Performance tuning for optimized results using tools like EXPLAIN PLAN, SQL TRACE, TKPROF, HINTS etc.
• Involved in transition activities for migrating developed /customized objects across Development /Stage /Production Instances using version control tools.
• Excellent communication skills, adept in client interaction and understanding business applications. Pro-actively can identify areas of opportunity and work to finding solutions that meet the business needs of the customer. Absolutely capable of working in a fast paced, dynamic, team-oriented environment.
• Ability to communicate within teams, crossflow teams, Interaction with users, fixing bugs, developing test plans understanding requirements of change requests, enhancements to existing components and providing daily production support related snapshots are other key tasks helped projects in meeting the deliverable timelines, thus avoiding any escalations.
• Played key roles in implementing the Planning required in Project Management Related Activities like, Allocation of Work, Track of Review Documents, Estimations, and Contingency Plan etc. Adherence to initial project plan and setting up short milestones for deliverables at various stages of project life cycle ensured to reduce number of defects during test cycle and post production go live.
• Effective communication on unforeseen issues that might cause potential risks for the project, resolving issues in time, good coding techniques following best practices of process improvements and quality standards helped in achieving 100% customer delight in all the projects worked.

TECHNICAL SKILLS:

ERP Applications: Oracle EBS (12/11i) Modules (OM, AP, AR, INV, PO,WIP) Supply Chain Deliver, Service, Install Base Contracts.

Methodology: Application Implementation Methodology (AIM)

Languages/Frameworks: SQL, PL/SQL, Core Java, JSP, HTML, C, C++

GUI/Tools: Forms 10g/6i, SQL*Plus, SQL Developer, Toad, VSS, PVCS, Kintana, Quality Center, Forms Personalization, Confidential Data Sync

Databases: Oracle 11g/10g/9i/8i, MySQL, MS Access, DBAS

Reporting Tools: Reports 10g/6i, Workflow Builder

BI Tools: Cloud BI / Data Sync Tool

PROFESSIONAL EXPERIENCE:

Confidential, San Jose

Responsibilities:

• Working on INV, WIP,AR OM modules, to build the integration for Confidential environment so as to build the Sales & Marketing plant, financial Dashboards.
• Shipment Revenue and Quantity trend by plant by Month, by quarter, YTD & Total Year: Current Year and 2 prior.
• Customer Forecast units and revenue by Month.
• Backorder Charts and drilldowns by plant - $ and units
• Order Sales Performance & Revenue Summary Dashboard
• Working on requirement gathering of Shipping automation Project enhancements, setups related to order types, establishing Customer Item and Customer Item Cross Reference, customizing Business requirements related to Sales Order Form and Project Order Shipment.

Confidential, San Jose

Responsibilities:

• Worked on setup related to enabling the standard Oracle SEPA Payment process to generate the SEPA compliant payment file for France operating unit.
• Worked on setup related to file encryption (PGP) through secured network file transfer via SFTP
• Responsible for End To End Technical build of generating Sepa Files in outbound directory to file transfer them in encrypted mode to bank.
• Worked on Service Contracts Form related customizations & worked on setup for defining roles to do contract approvals.

Confidential, San Jose

Responsibilities:

• Worked on to build the integration for Confidential environment so as to build the Financial Dashboards.

Confidential, Dallas

Responsibilities:

• Worked on development activities related to change requests, new process functionality being bought in Oracle Applications module with major focus in Order Management (OM), Inventory (INV) and Purchasing (PO), iprocurement in phased manner.
• Documentation using AIM methodologies of MD50’s, MD70’s.Perform Unit Testing, Migrate to next environments, assist user testing and closing the tickets.
• Established Purchase Requisition process integrated to Order Orchestration and Approval hierarchy setups to manage non Retail Item purchases in the Organization.
• Customized Order Orchestration process to divert material requests for internal sourcing or external procurement. Involved in customizing requisition approval process and order routing process validation logic as per business needs.
• Fixing Bugs in Forms and Reports previously designed. Extensively working on oracle backend objects like: Database Triggers, Stored Procedures, Functions, Collections, records, views, materialized views and Packages using PL/SQL.
• Proactively tuning SQL queries & Views using Explain Plan, Hints and indexes, SQL.
• Closely interacting with clients in deriving delivery dates of components and driving team in a direction to achieve the same dead lines and Conducting Technical Review & Code Walk through.
• Involving in the analysis of the assigned support tickets including replicating the issue, analyzing the custom processes/API’s/reports/forms and updating the ticket with the appropriate information.
• Simulating and analyzing the reported Problem. This usually involves a code walkthrough of Interfaces, Workflows, Forms & Reports and SQL Scripts.
• Supporting business users of AT & T, for Oracle Application Modules.
• Working closely with Oracle, Sys-admin & DBA teams for regular Patch Applications, Outages, data fix, code fix, scheduling of several scheduled requests.

Confidential, San Jose

Responsibilities:

• Involved in MD50 Analysis and prepared MD70/Technical Specification, Unit Test Case documents. Coding and Unit testing of Forms/Packages/Reports and other PL/SQL objects. Involved in review of other migrated Components related to Xflow track Impact Analysis, QA RTM etc.
• As Techno Functional Lead, Involved in customizing Supply chain process deliver track R12 implementation related components focused on utilizing OTM for estimating accurate transit times for scheduling orders for various route options A, B, C, and D being enabled from various lanes in phased manner.
• As Techno Functional Lead, Worked on Sales Order Form customization and Custom API to automate the system for maintaining Government order to be fulfilled by TAA compliant country of origin. New AOL Lookup, DFF Customizations and existing Database Object changes are other functionality supporting TAA orders wanting the TEP flag enablement.
• As Techno Functional Lead, Worked on Sales Order Form customization and OAF Framework related custom API to enhance Confidential Commerce Workspace Portal used for ordering various products and services from Confidential and worked on customizing packages related to Service Contracts & Install Base modules so as to integrate the Contract Info into Order Management module.
• As Techno Functional Lead, Developed new process to migrate O2C scope functionality from heavily customized Oracle 11i ERP to Oracle R12. Interfaces, Custom API, AOL setup designed for 11i Orders to be copied to R12 for Fulfillment and later updates back Pick Released Orders from R 12 to 11 i for Invoicing.
• As Technical Lead, Developed custom reports in SQL*Plus and Reports 6i for tracking down the Revenue Deferrals with capabilities to show by integrating upstream and downstream such as EDW (Teradata).
• Created entity objects, view objects, associations and view links as part of ADF Data model.
• As functional analyst Involved in Business Requirement Analysis and in gathering Business Requirements and impacted Cross Flow dependent Requirements to implement Brazil Localization. Prepared MD50 required for business functions to implement Oracle’s Brazil localizations and support the majority of Brazilian legal requirements.
• Implemented Inbound, Outbound Interfaces, Data Migration Scripts to implement a 3rd party credit application to manage their Credit review and approval process.
• Worked on Sales Adjustment Form, Customized to cater these needs of R12 AR Advanced collections Concepts in Oracle 11i.
• Implemented Tele Services in Oracle Applications 12, developed Workflow component and related custom API, AOL Objects to cover the lifecycle of a Service Request from initial creation, resolution to closure in addition, Service Request reassignment and Search.
• Expertise in System Administrator responsibility to create users, responsibilities, Values Sets and Request sets, Form Functions etc.
• Single handedly involved & implemented Project Management Related Activities like, Estimations, Allocation of Work, Analysis on project requirement scope, Design, Test Cycle Support, coordinated onsite project management activities with the client, functional team, QA Teams, cross flow track teams, Transition Teams, BSOS at various stages of the project life cycle, ensured smooth go live.
• Mitigated risks & on timely manner raised flag to next level leads/managers on project related issues for smooth delivery of the project deliverables without any major customer escalations.
• Provided contingency plan, Post Go Live Normalization Support and involved in sending critical snapshots on daily status development, defect status daily report, on change request analysis & deployment strategies within team, to client and other Confidential vendor teams, .
• As a value add in Confidential projects, we extensively worked in fixing the existing production issues, provided enhancements to few existing process to reduce manual interventions, various monitoring scripts that would help in identifying the orders started creating as per project scope requirements.

Confidential

Responsibilities:

• Analysis of the requirements provided by the client. Understanding of the process flows, BAA specifications, ERP Upgrade and Consolidation Methodology and Individual Customization Documents
• Upgrading custom objects, messages etc. Registrations of AOL objects. Development of New Reports and Forms. Migration of Reports/Forms/Packages from Oracle apps of 11.0.3 to 11.5.10
• Preparing the Change document and Test checklist. Unit testing of the Packages/Function/Procedures and other objects developed.
• Well versed with Test Director 8.0 and Visual SourceSafe. Involved in doing Peer Review of other migrated Components.
• Provided Post Implementation Support which involved Bug Fixing, Performance Tuning, and Enhancements.

Confidential

Responsibilities:

• Develop forms and reports using Forms 6i, Reports 6i.
• Study the scope of the systems, Prototype demo to the management and users.

Confidential

Responsibilities:

• Study the scope of the systems, Prototype demo to the management and users.
• Develop forms and reports using Forms 6i,Reports 6i, Develop web pages for the site
• Submit post implementation change requirement, errors and bugs for corrections, as per Test Cases.Evaluate post implementation change requests. Functional and user documentation of the system