PROFESSIONAL SUMMARY

• Over 9 years of experience in Design, Development and Customization of supply chain modules like Order Management (OM), Account Receivables (AR), Bills of Materials (BOM), Inventory (INV), CRM modules like Services (CS), Service Contract (SC), Install Base (IB) and Human Resource Management System (HRMS - CWB).
• Extensive experience in Implementations, which includes full-cycle implementations in Order to Cash (O2C), procure to pay (P2P).
• Experience in Oracle/Discoverer Reports, Interfaces, Conversions and Extensions (RICE) and Oracle Alerts.
• Excellent knowledge of AOL (Application Object Library) and System Administration Modules.
• Expertise in creating stored procedures, Packages, Triggers, Functions, Indexes and Views.
• Worked on Advanced PL/SQL Concepts (PL/SQL Tables, Record type, Bulk Collects).
• Experience in writing UNIX shell scripts.
• Expertise in Customizing developing new reports by using Oracle Discoverer 4i/10g.
• Experienced in Customizing Oracle Forms with Forms Personalization, Custom.pll on Forms 6i/4.5.
• Well versed with client server environment and tools like Developer/2000, SQL*Loader, SQL Developer, TOAD and OBIEE.
• Expert in preparing Technical specifications (MD070), Functional Specification (MD050), Conversion Mapping Documents (CV050), Conversion Data Mapping (CV040), Conversion Technical Design Document (CV060), Installation Document (MD120), Test Case Document (TE040), and user training manuals.
• Strong communication skills.

TECHNICAL SKILLS

ERP Oracle: Applications E-Business suite (EBS) 11i, R12 Modules OM, AR, INV, BOM, SC, IB, HRMS, OTM

Programming Languages: SQL, PL/SQL, C, C++, Java, Shell Script, HTML/DHTML

Software Products: SQL*Plus, SQL-Loader, SQL Navigator/TOAD/SQL Developer, Oracle Forms (v 4.5 and 6i), Workflow 2.5, Oracle Discoverer (v 10g), Microsoft Office

Operating Systems: Sun Solaris 5.x, Windows 2000/XP/7

PROFESSIONAL EXPERIENCE

Confidential, Sunrise, FL

Oracle Applications Technical Consultant

Responsibilities:

• Working as a technical consultant for CRM modules Services and Service Contracts.
• Worked on design, development and deployment of service requests, service request assignments, deductibles calculations and service checks.
• Developed complex API’s for assignment and reassignment of service partners to service requests, calculate and prorate deductible amount proportionately between claims, perform checks on claims etc.
• Used TCA API's for creating Parties, Party Accounts, Contacts, and Account Sites.
• Developed PL/SQL Procedures to convert data in custom tables to service requests using Service (CS) APIs.
• Providing development estimations by analyzing the development objective and technical complexities involved.
• Development of Concurrent programs using PL/SQL procedures.
• Application setup for concurrent programs and oracle forms.
• Unit testing, performance testing and integration testing of the objects.
• Interacting with business and functional owners for requirement gathering, creating functional and technical design document, test case and installation documents.
• Provide knowledge transitions to end users.

Technical Environment: Oracle Applications R12 modules (CS, SC, IB, and AR), Oracle 11g, SQL developer

Confidential

Oracle Technical Lead

Responsibilities:

• Working as team lead on Order management system (OMS) application which is developed using oracle PL/SQL.
• Leading team of 4 team members.
• Responsible for requirement analysis, creating project plan and estimation, design and development and deployment of the application software.
• Assigning project tasks to team members and testing the project deliverables to ensure the client standard are met and quality of the deliverables is excellent.
• Involved in writing the SQL scripts using SQL analytical functions and aggregate functions on aggregate data like first purchase 6 months sales, discount, cost etc.
• Creating control files to load the data from Oracle data mart tables to Alterian data mart tables.
• Created PL/SQL Functions and procedures for distance calculations of the customers and prospects data.
• Involved in writing SQL scripts and PL/SQL procedures to load the data from data warehouse tables to oracle data mart tables.
• Creating Functional Design and Technical Design Document using Aim methodology.
• Responsible for assessing teams job performance and conduct performance evaluations.
• Ensure timely project completion, monitor testing activities and defect resolution and product deployment.
• Provide technical support during production deployment.
• Involved in communicating with all front end teams to integrate the application with the backend catalog developed using oracle API’s.
• Involved in knowledge transfers to offshore resources and helping them in solving the issues.
• Involved in meetings with Architects, DBA, developers and managers regarding the upcoming releases to know the business functionalities in advance and gave suggestions to eradicate the production issues proactively.

Technical Environment: Oracle 10g, SQL, PL/SQL, Oracle SQL Developer, SQL*LOADER.

Confidential, Redwood City, CA

Oracle Applications Consultant

Responsibilities:

• Responsible for Analyzing, Designing, Development and Implementation of conversions in AR and INV applications.
• Designed and implemented the plan for upgrade from 11.5.10.2 to 12.1.3.
• Experienced in converting Item Routing using Routing Interface.
• Experienced in converting Item Categories and Item Category Assignment using standard Item Category API’s.
• Responsible for creating staging tables and loading the staging tables with the legacy data using SQL Loader and dblinks.
• Responsible for creating CV040, CV060, MD120 documents for all above objects.
• Developed the Shell Script Program to move the files between different Servers.
• Responsible for unit testing and performance testing of above objects.
• Responsible for training Users and designed training documents for users.
• Technical support during production deployment and data migration across instances.

Technical Environment: Oracle Application 11.5.10.2, Oracle Application12.1.3, PL/SQL, Oracle 10g

Confidential

Oracle Applications Techno Functional Consultant

Responsibilities:

• Lead the efforts of development from India for Discoverer Reports.
• Design and develop Discoverer Reports like Employee’s Absence Report, Qualification Details Report, and New Starters Reports in HRMS and Payroll system for Lancashire County Council.
• Creating custom EUL, database folder and custom folders.
• Creating database objects such as view and materialize views.
• Design and develop the technical objects like extensions, oracle alerts, and concurrent programs for new HRMS system.
• Develop concurrent program to create Element Links for payments using SQL Loader.
• Creating Functional Design and Technical Design Document using Aim methodology.
• Worked as system admin to create value set and register concurrent program.
• Responsible for unit testing and performance testing of above objects.
• Responsible for training Users and designed training documents for users.
• Data migration across instances.

Technical Environment: Oracle Applications (11.5.9), HRMS, Oracle 10g, Discoverer 4i, SQL*Loader, SQL developer, UNIX

Confidential, Santa Monica, CA

Oracle Applications Techno Functional Consultant

Responsibilities:

• Lead the efforts of development.
• Design and Implement the technical objects like extensions, oracle alerts, Fast Formulas, User Hooks and Concurrent Programs including development.
• Development of concurrent program for creating Special Information Type (SIT) Performance Rating in Compensation Workbench module (CWB) of HRMS.
• Development of concurrent program to upload the legacy data available in CSV file into Special Information Type (SIT) ‘Performance Rating’ in Compensation Workbench module (CWB) of HRMS.
• Creating Functional Design MD050, Technical Design MD070 and Installation Document MD120 for all above objects.
• Worked as system admin to create value set, register concurrent program, creating oracle alerts.
• Responsible for unit testing and performance testing of above objects.
• Data migration across instances.

Technical Environment: Oracle Applications (11.5.9), Oracle 10g, SQL*Loader, PL/SQL developer, UNIX

Confidential, Brea, CA

EBS OTM Integration

Responsibilities:

• Worked as an Integration consultant for EBS OTM Integration.
• This project involved integration of WMS with the Pick to Light (PTL) and Warehouse Control Systems (WCS) and integration of OTM with a small parcel manifesting system for rating and manifesting.
• Responsible for integration of WMS entities like Items, Deliveries and Locations from EBS 11.5.9 to OTM 6.1
• Development of PL/SQL procedures using collections.
• Converted five years of historical data from EFRS system into OTM which allowed BCI to run historical reports out of Fusion Transportation Intelligence (FTI) and phase out EFRS reporting.
• Run Reports Using FTI in OTM.
• Creating Functional and Technical Design document, Test Case and Installation documents.
• Responsible for OPM implementation to cover and implement client’s manufacturing business operations.
• Responsible for mapping and design of conversions like Item, Item Categories, Item Catalogs, Formulas, Recipes, Purchase and Sales Orders.
• Developed complex Multi Batch form using TEMPLATE.fmb and customized existing forms in the OPM module according to the client’s requirements.
• Played a key role in design and implementation of multi-batch and Batch Output functionality by customizing Multi Batch forms functionality.
• Development extensions and concurrent programs in PL/SQL.
• Application setups for concurrent programs and forms.
• Development PL/SQL procedures using collections.
• Unit testing, performance testing of the objects.
• Creating Technical Design document, Test Case Documents and Installation Documents.

Technical Environment: Oracle Applications (11.5.10) modules (INV, OPM, OM), Sun OS 5.8, Oracle 10g, Forms 6i, PL/SQL, Toad

Confidential, Tempe, AZ

Oracle Applications Technical Consultant

Responsibilities:

• Oracle E Business Suite Up gradation from 11.5.10.2 to 12.1.3
• Modifications of Procedures and Packages according to new Oracle standard tables in R12.
• Requisition Details loading using SQL * Loader and PL/SQL. Developed validation routines to validate values for each requisition line.
• Developed CTL files for loading CSV files from shared drive to server using SQL * Loader into Staging Tables.
• Developed packages to validate and to load data from staging table to Interface tables. Then, using standard Item Import program to load Items into Inventory.
• Developed the program to import invoices into receivables using AR Auto invoice program.
• Creating Staging tables and sequences for loading the POs into Purchasing using SQL * Loader.
• Registering Request Sets in AOL.
• Registering Custom Applications, Concurrent Programs.
• Defining Concurrent Programs and Executables in Application Object Library.
• Analyzing the business requirements and suggesting the best possible solution to the client.
• Development of Concurrent programs and Interfaces using PL/SQL procedures in Order management.
• Worked on PL/SQL for writing packages, procedures, functions and triggers.
• Worked as functional consultant and was responsible for setups related to consolidate Invoicing in O2C module of apps.
• Application setup for concurrent programs and oracle forms.
• Unit testing, performance testing and integration testing of the objects.
• Creating Functional and Technical Design document using AIM methodology.
• Read PO’s in EDI Format and to create ATO and standard orders through standard order interface.
• Attach services to the order before the order is booked through a custom PLSQL program.
• Identify the oracle configurator processing techniques and implement the same in batch configurator.
• Identify and complete the setups required for the processing of an ATO order.
• Create invoices in EDI Format once the order is shipped and confirmed.
• Supported all go-live activities and post-production troubleshooting.

Technical Environment: Oracle Applications 11.5.8 module O2C, PL/SQL, SQL Oracle Forms 6i