SUMMARY:

• Seven years of total IT experience in software technologies and providing cost effective solutions in Oracle and Application Domain.
• Over Six years of experience in requirement gathering, analysis, solution design, development, implementation, set up, testing, customization, trouble shooting, maintenance, support, and data migration.
• Strong Functional knowledge in OM, INV, Shipping, Pricing, AR, AP, PO and Manufacturing Modules (BOM, WIP, MPS, ASCP) in Oracle apps 11i and R12 environment.
• Expertise in debugging the issues related with development or support by documenting the solution design to accomplish the requirement technically or through functional setups..
• Experience in designing custom Reports for users and registering AOL setups in Oracle applications.
• Experienced in designing MD50/MD70’s for Conversion programs/interfaces for both inbound and outbound to integrate Oracle Applications modules with third party systems like EDI, EMEA, B2B and B2C.
• Strong Knowledge in standard business processes of SCM modules i.e. Order to Cash, Procure to Pay and have exposure in the functionality/standard business processes of the Manufacturing modules like ASCP, MRP and MPS.
• Proficient in developing AOL components and help the development team in the testing.
• Experience in testing the business flows like Order to Cash (O2C) and Procure to Pay (P2P) w.r.t the functional setups created as part of customizations in UAT environment
• Experience in utilizing standard Oracle API’s and testing applications by preparing test data or developing PL/SQL packages.
• Experience in development of RICE components using PL/SQL and have knowledge in FTP scripting for Data migration in different instances..
• Knowledge in Code Deployment, Testing of Customizations (Forms, Interfaces and Reports) and help resolve UAT issues.
• 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.
• Strong Team leadership skills with an ability to turn ideas into detailed executable strategic and operational plans.

TECHNICAL SKILLS:

ORACLE ERP: Oracle Applications 10.7/ /11i/R12, AOL Setups, Business Setups, Documentation (MD50/MD70).

LANGUAGES: PL/SQL, SQL, FTP Scripting.

OPERATING SYSTEMS: MS-DOS, Windows95/NT/2000/XP.

TOOLS: /UTILITIES: SQL Developer, PLSQL Developer, TOAD.

E-BUSINESS Suite (EBS) Modules: Order Management, Inventory, PO, Shipping, Pricing, AOL, AP, AR, GL, WMS, BOM, WIP and Oracle Workflows.

PROFESSIONAL EXPERIENCE:

Confidential, CA

Oracle Apps Techno Functional

Responsibilities:

• Involved in designing MD050/60 for customization.
• Involved in uploading the master data and open transactions for different development tasks.
• Coordinated activities with Testing and the Technical team to help with Design and development scenarios.
• Facilitated discussions with end-users / managers to gather functional requirements on their issues.
• Worked on high priority issues related with WMS module in 11i.
• Developed outbound interface using PLSQL and AOL components for the implementation of Mexico which involves business flow Order to Cash and this customization will update the Delivery and Sales Order information in the custom table for the corresponding PO receipts. The PO receipt information is inserted in custom table through Java interface.
• Created OM and PO related setups for the existing functionality and test it before deploying in the production instance.
• Involved in new setups for order types, line types to meet business needs such as for Customer Sales Rebate program.
• Developed Customized alerts and email notification in custom top whenever the GL period is closed as per the business needs.
• Customized shipping reports namely pick slip, packing list in OM
• Experience in performance tuning and writing SQL scripts for high priority tickets related with OM, PO and AP modules.
• Developed the strategy for the Order Flow functionality in Order Management module.
• Involved in conversion from Legacy System to Oracle 11i.
• Involved in analyzing the legacy data for conversion into Oracle. Data mapping was done with the inputs from Business Analysts. Gaps for the same were identified and rules created.
• Creating test scripts for user acceptance and system integration testing and suggesting design modifications, where necessary
• Involved in the testing of Interface programs and conversions end to end.
• Effectively handled System Administrator responsibility for creating Users, Responsibilities, Value Sets, Request Groups and Request Sets.

Environment: Oracle 11i OM, PO, AR, AP, P2P, O2C, Reports, PLSQL, Discoverer, TOAD 10,Order Management, Shipping Execution, Inventory, PO, AP, AR, WMS modules.

Confidential, CA

Oracle Apps Techno Functional

Responsibilities:

• Developed Setups and PLSQL scripts for invoice sequence numbering.
• Developed ADHOC queries to provide the business the information related with taxes related with PO, Receipt, invoice and Order lines form.
• Involved in integration testing and created test cases based on the customizations related with Oracle R12 EB-Tax, OM and PO modules.
• Coordinated offshore team in development activities for R12 AP and AR reports, interacting with business for requirement gathering.
• Developed and assisted development team in the customization of auto invoice functionality to create invoice number sequencing based on the operating unit.
• Executed the Business cycles related with OM and PO i.e. Order to Cash, Procure to Pay to test the customizations related with taxing on Purchase order and Sales Order.
• Designed and implemented Summary based NL VAT Tax Report, Sales Journal by GL Account Report, Purchases - VAT/GST Registers, Tax Audit Trail Report, Media Tax Report, Sales Vat Register, APPLE consignment ZKB Report, Payables Account Analysis Report and Use Tax Accrual Report for various operating units in multi org setup.
• Implemented XML Publisher Italian Input VAT Register Report/ Italian Output VAT Register Report in other language based NON US Countries like Italy and derived the report in Italian.
• Create and maintain custom responsibilities and menus
• Scheduled the concurrent/customized programs to meet the customer requirements, like Invoice Tax summary report in regular intervals for management purposes
• Experience in utilizing standard Oracle API’s for conversion programs
• Participate in business meetings.
• Guide offshore functional testing and Confidential specific processes.
• Review the technical documentation prepared by offshore team.
• Review functional test case/ results.
• Involved in the Design of MD50’s for Italian reports, Receivables and Payables.
• Documented business rules, functional and technical designs, test cases, and user guides.

Environment: Oracle 12.1.3 OM, PO, AR, AP, P2P, O2C, Order Fulfillment, PO creation, RICE Development in R12, Windows 7.

Confidential, CA

Oracle App SCM Techno Functional

Responsibilities:

• Involved in the MD50 design for various customizations related with SCM modules and created functional setups as part of it.
• In case, if the issue requires the support of development, then transfer the issue to development team with the inputs. Monitor and help development team to complete the task or develop the new requirement from onsite.
• In case, if the issue requires to run diagnostics requests, SQL’s or any other required to identify or resolve the issue, then run those required (data fix SQL’s when Required) and update SR’s and co-ordinate with oracle support team till closure.
• In case, if the issue requires the support of Database Technical Consultants/DBA, then Describe and transfer the issue to Technical Consulting team with the inputs. Monitor and help Technical team to complete the task.
• Preparing Test Cases, Test Data & testing.
• Developed the PLSQL packages for printing Bill Trust and Get Paid invoices sent to various customers for cross verification purposes
• Setups and scripts developed to invoke in Processing Constraints to resolve Return Orders Performance issue.
• Monitored the scheduled requests completing in error relating with Work Order Extraction, Pick Release
• Designed MD50 for Commercial invoices for the US region and supported production issues related with it.
• Worked on the Credit Card Authorization Functionality to customize the IBY PAYMENT ADAPTER PUB and include the AUTH for both order price and freight charges.
• Worked on the interfaces and customizations related with Cyber source and its integration with Oracle.
• Worked on CSE P2P interface packages to accept the changes done in CSE third party system and interface back to Oracle.
• Developed SQL queries to find out the orders having incorrect customer relationships, Move orders having same line ID, Order scheduling.
• Developed the custom package to reschedule the B2B orders.
• Worked on the Custom Order organizer form to customize the Order fill % based on the reservation set.
• Worked on the production issues on Generic FTP Shell Script to improve the performance.
• Developed or customized the order import issues from different sources like B2B, B2C, iSFA, iFLOW.
• Worked on the Auto invoice import errors in PROD when completing with user defined exceptions and Snapshot too old Exceptions.
• Worked on the Mass update change form standard error and provided the solution for the functionality.
• Created MD50 or assisted the development team for the new changes/Enhancements on AR Interfaces like BillTrust, GetPaid and O2C functionality like Interface Trip Stop Errors.
• Developed the Forms personalization to not to create the delivery to address for the incorrect customer relationships.
• Proficient in SQL tuning the packages, procedures and enhance the performance related issues in real time environment.
• Developed Various PLSQL/SQL scripts to fix the issues in PROD data like Move orders should be same for the same line item for the delivery, Invalid account relationships, AMEX invoices.
• Developed a control file to load Customer information from flat file into interim tables using SQL/Loader then validated data and written customized program to insert data into the interface table using PL/SQL for AR Auto Lockbox implementation.
• Worked on ATP Reservation and Demand issues and investigated the standard hard reservation data not being populated into demand tables.
• Provided Solution on the Workflow issues and fixed the package scripts interfacing the data through workflows and AQ queuing.
• Worked on the Tax code related issues on the sales order form and provided the solution for the same.
• Worked on the Work Order extraction and configuration of the custom club orders and the end-to-end process of Pick release and Ship confirmation.
• Developed Conversion packages for Employee, Customer, PO, SO from 11i to R12.
• Assisted the development team in MD70 documentation, requirement gathering and design solutions and Migration checklist activities.
• Involved in requirement gathering, analysis and development of functional designs for legacy data conversion to Oracle applications.
• Interacted with end users, involved in functional and technical discussions for collecting the information for various customizations.
• Involved in preparing the Data Mapping specifications.

Environment: Oracle 12.1.3 OM, INV, PO, AR, AP, P2P, O2C, BOM, WIP modules, Cybersource, Forms6i, Reports 6i Oracle, XML Publisher, PL/SQL, Shipping Execution, Drop Shipment, Internal Orders, Workflows, CTO, ATO.

Confidential, CA

Oracle Apps SCM Techno Functional Developer

Responsibilities:

• Team member of development team, involved in customizations of various Oracle manufacturing modules like Order
• Management, Inventory, BOM, PO, AP and AR.
• Developed different extracts and reports related with SCM Modules, BOM, AP, PO, AR, and INV.
• Developed PL/SQL components and used standard API’s for BOM Implosion and Explosion.
• Developed Data Extract Queries for BOM Routings and Vendor Extract to capture the miscellaneous data.
• Involved in designing and developing various reusable packages and procedures, which were utilized by various programs in INV.
• Involved in the functional aspect of MRP, MPS and ASCP as part of requirement gathering.
• Worked on Miscellaneous transactions to be created through a PL/SQL package associated with a Concurrent program along with appropriate validation through SQL*Loader.
• Handled performance related issue using hints, tkprof and explain plan.
• Effectively handled System Administrator responsibility for creating Users, Responsibilities, Value Sets, Request Groups and Request Set.
• Created Stored Procedures at back-end and integrated them with front-end systems.
• Responsible for developing and customizing reports using Reports (6i) & Oracle XML Publisher generating output in the format of RTF, PDF, HTML and EXCEL as per Client requirement.
• Used Clear Case for Code Deployment and Mercury Kintana for Code Migration.
• Used Test Director for Defect Tracking.

Environment: Oracle 11i OM, INV, PO, BOM, WIP, Oracle PL/SQL, Shipping Execution, Order to Cash, BOM Routings.

Confidential, Palo Alto, CA

Oracle Apps SCM Technical Developer

Responsibilities:

• Team member of development team, involved in customizations and Process flows in various Oracle ERP Modules like OM, PO, INV, BOM, MRP/ASCP.
• Developed reports for printing invoices sent to various customers for cross verification purposes
• Worked on the Item Cross References and developed PLSQL API's to upload new SKU’s as part of the SDP Project.
• Created PL/SQL View and Materialized views for the Price Book Generation.
• Worked on the Product Category Upload from Spreadsheet Template. Developed a new PL/SQLAPI and registered as an executable for the Concurrent Program.
• Generated Error File as Excel Sheet and send it to the appropriate Email through PL/SQL package concurrent program.
• Customized QP Custom Package by adding a PL/SQL procedure to override the price from ARIA.
• Preparing the Solution Design documents and Technical Design documents
• Testing all the application AOL and PL/SQL components for providing quality assurance using TkProf Util and various kinds of hints and outer joins.
• Tuning all the application components for better performance and throughput.

Environment: Oracle Applications 11i (OM, Pricing, INV) Oracle R12 database, SQL*Loader, Discoverer Report 10, UNIX FTP, Windows

Confidential, NY

Oracle Apps SCM Techno Functional Developer

Responsibilities:

• Involved in Requirement gathering and GAP analysis during the initial phases of the project.
• Developed the inbound interface package, which is used to extract the Order information and create orders/ cancel orders. Creates customers on the fly and then stage them into a custom table.
• Created a concurrent program which import purchase orders from one instance to other oracle instance by dumping standard tables OE HEADER IFACE ALL, OE LINES IFACE ALL data to load into the custom interface tables
• Developed the custom code in order fulfillment to determine the sourcing warehouse that will ship the product to the ship to location (internal and external) based on specific criteria
• Developed a consolidated view for the downstream applications to pull the pick released delivery lines data for all of the Supplies warehouses.
• Developed the Plsql procedures and functions to derive the COGS account only for the supplies transactions. Done forms personalization using these functions and procedure on the Misc Transaction form of Inventory Module to populate the COGS account in the account field of the form.
• Developed an application form Confidential Warehouse Restrictions containing with Triggers, Alerts, Multiple Windows and LOVs using built in features available with Template.fmb. This form allows customer to restrict the ordered items to be picked from warehouse entered in this form.
• Migrated and customized the form Confidential Supplies Default Warehouse Hierarchy from one instance to other using standard AOL functionality CUSTOM.pll library.
• Modified and migrated the materialized views, which access the tables of other instance through the DB, link and contain the ETA values of the warehouse by ground.
• Created and modified custom and standard lookups, profile options, value sets and descriptive flex fields according to the user needs.
• Developed several stored procedures, functions and packages extensively involving with the collections and records such as PL/SQL records, PL/SQL tables, VARRAYs, TABLE index by binary integer, sorting the PL/SQL Tables and reading them by using multiset operator, reference cursors, parameterized cursors, global temp tables, DBMS SQL Package, UTL FILE package for OM, and INV modules
• In the custom view, wrote the logic to calculate the separate shipment quantity for different delivery of the same line item after they are pick released.
• Handled the data errors with appropriate exception handling and printing the corresponding sqlerrm and SQL code.
• Developed custom trigger on table WSH delivery assignments and submitted DBMS JOB of executing the package to derive the values used in the custom view.
• Developed and tuned complex queries to retrieve different bin locations in the order of picking order.
• Created Miscellaneous Transactions to adjust the INV, pick releasing, back ordering, splitting the order lines, making the orders to go on hold, to test the functionality by Oracle. Used MTL SYSTEM ITEMS B, MTL PARAMETERS and MTL UOM CONVERSIONS, MTL ONHAND QUANTITIES tables.Created Dummy reservation API INV RESERVATIONS INTERFACE.RSV INTERFACE BATCH PROCESSOR
• Used WSH DELIVERY ASSIGNMENTS, WSH NEW DELIVERIES, WSH DELIVERY DETAILS and related tables to include appropriate left, right outer joins in the view to reduce its execution time for retrieving huge volume of pick released orders.
• Implemented Oracle Order management by loading data from flat files into Oracle Applications using conversion and interface programs
• Responsible for maintenance and tuning of my development units to enhance the speed by utilizing Indexing, Explain Plan and Hints.
• Implemented number of techniques to eliminate redundancies in the Database.
• Scripts in PL/SLQ to read file from remote server and import the lines into custom tables for Point of sale data and present the data to the users using custom forms
• Creating test scripts for user acceptance and system integration testing and suggesting design modifications, where necessary
• Documented business rules, functional and technical designs, test cases, and user guides.

Environment: Oracle Applications 11.5.7/11.5.10 Purchasing, SCM Modules, OM, INV, Manufacturing Modules such as Purchasing, Shipping Execution, Drop Shipment, Internal Orders, CTO, ATO cycles, Oracle 11i, SQL*Loader, Forms 6i, Reports 6i, Lotus Notes, SSH (UNIX), Windows 2000 Forms 6i, Reports 6i, Discoverer 4i, SSH Secure FTP.

Confidential, NY

Oracle Apps SCM Techno Functional Developer

Responsibilities:

• Involved in the complete life cycle of software development: Analysis, Design, Development, Testing and Implementation
• Created complex validation units based on Value Sets and list of values by creating various views and tables
• Created Value Sets and attaching those value sets to the value set name for the parameters of the report or PL/SQL Packages.
• Created Custom forms for specific users and assigned those forms to their menus to restrict their accessibility
• Defined concurrent program and assigned to request groups
• Created and register Tables in Oracle Application
• Developed custom XML reports using Report 6i for generating the orders that have got the invoices. Also, validated the date columns by writing PL/SQL script in the value set at the front end
• Designed and developed numerous packages and procedures utilizing various seeded APIs to UPDATE task assignment status from one to other and also to load data from temporary tables into Oracle base table
• Created DB Triggers, Functions, Packages, Stored Procedures, Views, Sequences, Synonyms at the back end using SQL and PL/SQL
• Development and Refinement of Oracle Forms functionality including navigation, Master/detail Co-ordination, commit consistency, and context awareness customization of Oracle Forms including label changes, addition of fields
• Worked on forms personalization on various oracle standard forms of modules INV, Field Service and Debrief screen as part of customization

Environment: Oracle Applications 11.5.10 OM, SCM, INV, Field Service, Service Contracts Oracle 10g database, SQL*Loader