SUMMARY

• Over 8 Years of IT experience and major experience in Oracle Applications (E - Business Suite) with emphasis in manufacturing modules.
• Expertise in Technical and Functional aspects of Oracle Applications R12, 11i Financial, Supply chain, Order to cash and Manufacturing Modules which include Order Management (OM), BOM, General Ledger (GL), Accounts payable (AP), Inventory (INV), Shipping (WSH), Purchasing (PO), AOL, Oracle E Business Suite logistics.
• Have hands on experience in Oracle Release 12 Manufacturing Modules and Order Management.
• Good knowledge in Procure to Pay (P2P) business flows.
• Experienced in requirements gathering, system analysis, design, development, testing, implementation, support, documentation and design reviews.
• Developed Interface Programs and Extensive experience in Oracle backend objects like: Database Triggers, Stored Procedures, Functions, and Packages using PL/SQL.
• Extensive experience in Analysis of Database.
• Good Exposure to Oracle Application implementation methodology (AIM).
• Expertise in creating inbound and outbound feeds, creation of automated processes using Application Program Interfaces (API)
• Data Conversion from Flat files to Oracle using Oracle SQL* Loader and SQL*Loader scripts.
• Experienced in Developing Functional design documents(MD50), Technical design documents (MD070), Conversion technical design documents (CV060) and Migration documents (MD0120).
• Comfortable working on SQL*Loader, SQL* Plus, UTL FILE, CONCSUB Utility, Oracle Import/Export utilities and SQL* Navigator.
• Good understanding of Oracle databases, Strong in Inventory, WMS, AR and AP modules. Comprehensive knowledge in Purchasing and MRP (Materials Requirement Planning).
• Good Expertise in Query and Performance tuning in Oracle. Having working experience in analyzing the Oracle SQL Raw Trace and TKPROOF Trace files in working query and database performance issues.
• Experience in designing, developing, testing, performance tuning and supporting data base applications using Developer Tools (Reports 6i/9i/10g, Discoverer4i/9i/10g, XML/BI Publisher), PL/SQL on UNIX and Windows platforms.
• Registering of Custom Applications/Table/Schemas in Oracle Applications.
• Worked on Oracle Alerts and exception handling.
• Excellent analytical, problem solving, communication and inter-personal skills.
• Provided on-call and day-to-day support and worked as a part of team in 24x7 production environment.
• Interaction with the offshore development team for development of reports and changes needed in the requirements.

TECHNICAL SKILLS

ERP: Oracle Applications E-Business Suite of versions R12/11i (AP, AR, OM, GL, WIP, BOM, PO, INV, AOL, WMS, Service Contracts)

Databases: Oracle 8i/9i/10g, MS SQL Server 2000, MS Access, MySQL

Scripting: SQL, PL/SQL, UNIX Shell Scripting

Programming Languages: C, C++, Java, JSP, HTML/DHTML, XML, ASP, VB

Operating Systems: MS-DOS, UNIX, Solaris, Linux (Red hat, SUSE 9.2/9.3), Macintosh, WINDOWS 98/2000/NT/XP/VISTA.

GUI: Oracle Developer - Reports 6i/9i/10g, Discoverer4i/9i/10g, XML/BI Publisher

Query Tools: TOAD, SQL Navigator, SQL Developer, SQL*PLUS

Other Tools: SQL*Loader, Erwin, Smart Draw, MS Office, MS Excel, MS Visio, MS Project

PROFESSIONAL EXPERIENCE

Confidential, MO

Oracle Techno Functional Analyst

Responsibilities:

• Involved with Business teams and worked closely with the Oracle Order Management, Warehouse Management Systems (WMS) Inventory and Quote to Cash Cycle.
• Worked on creating various functional design and requirement gathering to create documents(MD50) and design documents(MD70).
• Worked on gap analysis for moving from legacy system IBM Alice to Oracle Apps.
• Involved in CRP meetings to discuss the issues and concerns regarding various requirements gathering and designing reports and forms.
• Worked on cross functional teams for resolving various oracle functional issues and gathering appropriate requirements.
• Worked closely with the business teams to understand the intricacies of the business and document accordingly.
• Acted a liaison between the Business users and Technical team to understand the business requirements to implement WMS in Oracle R12.1.3.
• Involved in the implementation of pick position conversions on Functional side.
• Involved in creating various sales orders with different pricelists, different order types for different business units of BULK, KCN and SecurePak.
• Involved in creating sales orders with different ship methods, ship dates, pricelists and order types, creating LPN’s, pick releasing and ship confirmation processes.
• Involved in creating purchase requisition, internal requisition, running internal order requests and importing orders to Order Management.
• Worked on the requested ship dates and restrictions on the pick releasing accordingly.
• Worked on functional design for conversions to import pick positions from legacy system to Oracle applications.
• Wrote interfaces on inbound and outbound FEDEx terminals for sending out order tracking information and ship confirmation done at FEDEx terminal.
• Worked on customer item cross reference report to specify the oracle internal number and the customer item numbers according to different warehouses.
• Worked on setting up organizations under different business units for various warehouses around US. Worked on setting up org locations accordingly.
• Setting up of item category sets and adding items to the list.
• Setup items and manual adjustments for miscellaneous receipts.
• Worked on setting up Concurrent programs, executables, valuesets, lookups, menus, functions and user profile options.
• Knowledge on various base tables on Oracle R12 in WMS, INV, Accounts Receivable and Order Management.
• Customized and designed various reports in INV and OM like Pick Slip Reports, Pack Slip Reports, Bill Of Lading Reports.
• Worked on BOL to customize the weights of the pallet by adding the pallet weight to the weight of the items.
• Analyzed and functionally designed Custom forms for ATP and On hand Quantity aspick position maintenance form.
• Involved in the technical design and coding for interfaces and custom application development. Several inbound tables, snapshots, views, procedures, triggers and packages were built during the application development. The core part of the application development was in pl-sql.
• Designed and developed strategy to capture the legacy data and API to ORACLE database. XXCNC pickposition interface were populated during interfacing and insertion in to Oracle base tables.
• Developed orders interface to populate the wsh delivery details and wsh delivery assignments. Similarly a custom interface program is developed to send information to FedEx terminals.
• Coordinated and worked on testing all the custom reports and forms developed.
• Worked on inbound and outbound interface testing.
• Resolved various issues during the cross functional, System Integration and Customer Acceptance testing phases.
• Worked with Microsoft Test Manager (MTM) for uploading requirements.
• Worked on creating defects on MTM and assigning concerned development team for resolutions.
• Worked closely with business users to analyze the developed forms and reports.
• Coordinated with BI reporting team for pulling the data from Oracle and inserting in cubes for better reporting veiws.
• Worked on DataLoader for moving objects from development to test instances.
• Worked on creating MD57 for Oracle BULK Pick Slip Reports, Internal Sales Order Report, Bulk Pack Slip Report, KCN Pick Slip report, KCN Secure Items report, KCN Property Items Report, Bill Of Lading, Min-max planning report, Item categories report, Warehouse Inventory Report, Item cross-references listing, Daily Item Usage Report, Inbound and Outbound FedEx terminal.
• Worked on Internal Sales Order Pick and Pack slip report for warehouse to warehouse, onsite to onsite and onsite to warehouse transfers. Worked on the daily usage of the item and the number of days reserve at the destination warehouse.Worked on different item categories like secure items and property items.
• Worked with system administrator on various issues of concurrent programs, setup of printers in Oracle and profile option validation.

Environment: Oracle Applications: 12.1.3 (WMS, INV, and OM), RDBMS: 11.2.0.2.0 , SQL, PL/SQL, Reports 6i, SQL Developer, TOAD, BI reporting tool, Data loader.

Confidential

Oracle Techno Functional Developer

Responsibilities:

• Involved with Business Services team and worked closely with the Oracle ASCP, Accounts Receivables, Order Management and Quote to Cash Oracle systems.
• Interacted with all Business users and Technical team to understand the right approach and Information to implement the implementation of OM and Demantra in Oracle R12.
• Worked on the development of Interfaces, Data Conversions, Developing new Forms, Reports.
• Imported Legacy Journals data into GL using Journal import interface
• Developed Order Import Interface for business applications to load header and line details by creating Staging Tables and performing validations by writing PL-SQL package into the Order Import (OE) headers and line interface tables and then to OE base tables.
• Worked on Pick release public API and used WSH PICKING BATCHES PUB package for creating and releasing batches.
• Worked on Freight costs public application program and used WSH FREIGHT COSTS PUB package for updating, validating and deleting freight cost records.
• Developed conversion program to import PO Requisitions from flat file to PO Interface table using different validations like verifying vendor Id, charge account, code combination Id, Unit of Measure.
• Worked on Auto lock box open interface to outsource the accounts receivable payment processing and for automatic generation of receipts.
• Involved in Customer Conversion to load Customer details into HZ tables by creating staging tables and performing validations and finally loading them in to base tables using TCA APIs.
• Designed and developed the Functional Docs (MD.020), Technical Specification Docs (MD.070), and Unit Test Cases Docs (MD.120).
• Created concurrent programs, collections in ASCP to run and import safety stock data into the Oracle DB from PeopleSoft.
• Worked on the issues of Manual demand, collections, safety stocks and clearing cache.
• Worked on custom stored procedures using PL/SQL. Writing SQL scripts for identifying the issues related to Orders, Demands, safety Stocks in the database.
• Registered custom tables on Oracle R12 (Accounts Payable, Accounts Receivable, ASCP and Order Management).
• Worked on SQL Loader to load all the data given in flat files with various special characters and comma delimiters.
• Worked with the Oracle Framework (OAF) to create custom page of Manual Demands.
• Worked on installing patches and JDev for Oracle R12.
• Worked on Framework (OAF) to create Entity Object, View Object and Application Modules for the Demands search, create and update.
• Worked on validating the Due dates and Designator dates.
• Worked on creating sequence in OAF.
• Worked on deploying the page from local machine to APPS instance.
• Worked on Java code to rectify various errors in JDev.
• Worked on creating Oracle Frontend functions, menus, messages.
• Attaching the menus to the respective responsibilities.
• Worked on XL reports for submission of reports regarding all the order local and international amounts.
• Worked on executing various procedures to upload new and updated data into various tables.
• Worked on various triggers, constraints, temporary tables procedures, Lookups table and DB links.
• Worked on inserting or updating data into tables using various execute procedures.

Environment: Oracle E-Business Suite R12 (ASCP, INV, AP, PO, AR, OM, Demantra), Oracle 9i, PL/SQL, Reports 6i, Demantra, AIX,Apache TomCat,OC4J, J.D.Edwards, People Soft, Jdev, Java, OA Framework OAF, Benthec, SQL Navigator, SQL Developer, TOAD.

Confidential

Oracle Techno Functional Developer

Responsibilities:

• Involved with Business Services team and worked closely with the Oracle Accounts Receivables, Order Management and Quote to Cash Oracle systems.
• Interacted with all Business users and Technical team to understand the right approach and Information to implement the integration between the Confidential and Verisign Oracle ERPs.
• Developed the Hierarchy and design for creating all the Interfaces using Oracle Pl/sql.
• Gathered business requirements and then translated business needs into functional specifications and technical documents MD 50 VeriSign UA Bookings and VeriSign QTC integration.
• Prepared project-initialization documents, Mapping Information Guides and functional specifications.
• Worked on complete integration between the Verisign and Confidential Oracle ERP.
• Worked on Conversions to import orders and invoices from VeriSign Oracle ERP to Confidential Oracle ERP.
• Designed and developed the Functional Docs (MD.020), Technical Specification Docs (MD.070), and Unit Test Cases Docs (MD.120).
• Created Alerts which send mails to the support teams when any concurrent request runs for more than an hour.
• Worked on the issues of Orders with Pick release, Ship Confirm processes, and Order status.
• Worked on custom stored procedures using PL/SQL. Writing SQL scripts for identifying the issues related to Orders, Deliveries in the database.
• Registered custom tables on Oracle 11i (Accounts Payable, Accounts Receivable and Order Management, Service Contracts and Install base).
• Conversion of Sales orders from Legacy to Oracle 11i
• This involved the API OE ORDER PUB.PROCESS ORDER
• Conversion of BOM and Routings from Legacy to Oracle 11i,
• This involved standard interface methodology
• The APIs involved are BOM BO PUB.PROCESS BOM and BOM RTG PUB.PROCESS RTG
• Responsible for all Manufacturing conversions viz., Items, Item Catalogs, Item Categories, Bills of Material, Item Templates, Item cross references, Item Costs.
• Worked with Journal Import to bring legacy journals from AP, AR and Posting in Oracle General Ledger.
• Wrote interfaces like MGR FPA.BOOKING MAIN DL PKG, BOOKING OM DL PKG, BOOKING REGION UPDATE PKG, BOOKING RENEWAL DL PKG to pull all the orders and invoices from Oracle VeriSign ERP into Oracle Compensation Modules.
• Customized the code to change the Licensee Country, Sales territory, Compensation amounts for particular orders according to the functional specifications.
• Ran scripts or wrapper like BOOKING GLOBAL DL RUN UA to pull the load on daily basis from VeriSign to Confidential Database.
• Worked on pulling all the orders for Oracle Compensations Module in order to compensate Sales Representatives.
• Worked on SQL Loader to load all the data given in flat files with various special characters and comma delimiters.
• Worked in Data fixing for various duplicate and errors in data.
• Worked on debugging the code to find the missing orders, missing sku descriptions, transaction types and various other order identifications.
• Worked on missing data due to Shareplex issues.
• Worked on verifying the various orders and invoices using the Order types, Item descriptions, Transaction types, etc.
• Worked on gathering information from the business and the technical team to create test scripts for validating the Orders, Invoices and the Payments moving from the target to the source systems.
• Worked on HP Quality center to upload the test scripts and work on test cases.
• Worked closely with Functional testing team to resolve all the issues regarding code changes .
• Worked on Perforce for version control, submitting and migrating code.
• Worked with the Oracle middleware system i.e SOA and Oracle Fusion during the processing of invoices from the source (Oracle) to the target systems (Oracle Compensation).
• Worked on XL reports for submission of reports regarding all the order local and international amounts.
• Worked on executing various procedures to upload new and updated data into various tables.
• Worked on various triggers, constraints, temporary tables procedures, Lookups table and DB links.
• Worked on inserting or updating data into tables using various execute procedures.

Environment: Oracle E-Business Suite 11.5.10 (INV, AP, PO, AR, OM, Service Contracts and Install base), Oracle 9i, PL/SQL, Reports 6i, Perforce, SharePlex, Hyperion, SQL Navigator, TOAD.

Confidential

Oracle Techno Functional Developer

Responsibilities:

• Involved with Business Services team and worked closely with the Oracle Accounts Payables, Project accounting and financial systems team supporting Oracle’s R12 ERP.
• Interacted with all Business users and assisted Technical and testing team with the right approach and Information Guides.
• Developed the Hierarchy and design for the Interfaces using Counsel Link and Brain ware as the Middleware.
• Gathered business requirements and then translated business needs into functional specifications used by Application Development for technical approach/design.
• Prepared project-initialization documents, Mapping Information Guides and functional specifications. Ensuring that the development team has a thorough understanding of the functional specifications and providing additional information to the Development Team as needed.
• Worked on gathering information from the business and the technical team to create test scripts for validating the Invoices and the Payments moving from the target to the source systems.
• Involved in the implementation of OM Shipping on Technical side
• Worked on Conversions to import orders and invoices from legacy system
• Wrote interfaces between OM and Shipping by using Shipping APIs
• Customized various reports in OM, Shipping Reports (Bar Code used), Pre Pick LPN Detail Report, and Customer Sales Representative
• Customized Discrete Jobs Dispatch report, Discrete Job Pick List Report, Discrete Job Routing Sheet report
• Customized the Packing slip, Pick Slip and sales order Acknowledgement report
• Developed Custom forms to modify License Plate information.
• Customized Commercial Invoice and Bill of Lading reports
• Worked on HP Quality center to upload the test scripts and work on test cases.
• Worked with the Oracle middleware system i.e SOA and Oracle Fusion during the processing of invoices from the source (Oracle) to the target systems (Counsel Link).
• Worked on creating MD50 Clinical Trial Data for Complete Spend and design documents.
• Worked on creating the Roadmaps for various business cases.
• Worked for understanding, analyzing and reporting on general Counsel Link usage and behavior.
• Worked for producing standardized, scheduled reporting as well as ad hoc reporting related to testing and changes to the Counsel Link Sandbox.
• Worked for developing new insights and analyses that inform decisions and help improve Sandbox site.
• Effectively communicate results of analyses to key decision makers.
• Worked on mapping of various invoice, payments, Vendors, Suppliers, Allocation and Product IDs.

Environment: Oracle E-Business Suite R12, 11.5.10 (INV, AP, PO, AR, PA), JDE, People soft, Oracle FusionSOA, Counsel Link, Sandbox, Oracle 9i, PL/SQL, Reports 6i, TOAD

Confidential

Oracle Developer

Responsibilities:

• Took part in the entire phase of the project which includes, initial operations analysis, business process re-evaluation, documentation and implementation.
• Worked on Cisco Order to Quote cycle with Smart care systems.
• Worked on various custom tables and custom API’s.
• Interacted with various business users to get the data migration information on various tables to be fixed.
• Worked on CDETs and Kintana Clear case to get most of the bugs resolved.
• Developed Migration programs to convert data fix various numbers and location ids, names and party site ids etc.
• Worked on various GUI’s working on Java with database backend using Oracle Plsql.
• Worked on various Oracle forms like, Order Entry, Item Master, Material Transactions.
• Involved in documenting technical and functional design for Cisco International Brazil project.
• Provided on-call and day-to-day support and worked as a part of team in 24x7 production environment.
• Worked on application support.
• Created various UNIX Shell Scripts for scheduling various data cleansing scripts and loading process. Maintained the batch processes using Unix Shell Scripts.
• Involved in design, development and Modification of PL/SQL stored procedures, functions, packages and triggers to implement business rules into the application.

Environment: Oracle E-Business Suite 11.5.10 (INV, OM, PO, PA, BOM, Routings), Oracle 8i, PL/SQL, Forms 4.5, Reports 2.5, ANT, UNIX, Apache Tomcat, TOAD.

Confidential

Oracle Apps Consultant

Responsibilities:

• Worked as a Oracle Applications Techno-functional consultant responsible for the implementation of Oracle Shipping, OM and MFG Modules: INV, PA, AR, OM and WMS.
• Worked on creating requirement document and design documents.
• Worked on gap analysis.
• Involved in the implementation of Sales order Delivery Information on Technical side
• Involved in creating various sales orders for domestic and international customers.
• Involved in pick releasing and ship confirmation processes.
• Worked on the requested ship dates and restrictions on the pick releasing accordingly.
• Worked on Conversions to import customer data and pricelists from legacy system
• Wrote interfaces on Sales orders and customer information for the delivery of information to third party logistics.
• Worked on setting up various responsibilities requested for third party logistics team.
• Worked on setting up menus, functions and user profile options for each responsibility accordingly.
• Knowledge on various tables on Oracle R12 in TCA, Accounts Payable, Accounts Receivable and Order Management).
• Worked on Documentation for the upgradation from Oracle 11i to R12.
• Created various UNIX Shell Scripts for loading process. Maintained the batch processes using Unix Shell Scripts.
• Created UNIX Shell Scripts during data conversion process.
• Worked on creating various alerts like ONTC SP 3B13 SHP NOTIFICATION, ONTC SP 3B11 STAGING ERROR, ONTC SP 1A1 NOTIFICATION EXP and all.
• Customized various reports in AR and in shipping like Shipping execution Reports.
• Customized Commercial Invoice and Bill of Lading reports
• Customized Warehouse Inventory, Reverse Logistics report, Daily sales, Mtl Shortage Report, Shipped pending report and many more
• Involved in the technical design and coding for conversions, interfaces and custom application development. Several inbound tables, snapshots, views, procedures, triggers and packages were built during the application development. Was involved with OE-OM, AR, MRP, CRM, PO, FA and HR modules. The core part of the application development was in pl-sql.
• Designed and developed strategy to capture the legacy data and API to ORACLE database. Ontc interface were populated during conversion and API inserts the information to Oracle base tables.
• Populated base tables with legacy customer information. Developed orders interface to populate the oe order headers all and oe order lines all. Similarly a custom interface program is developed to inform shop floor about the open orders and related customer information from Oracle WIP and ORDER tables.
• Worked on creating workflows and customizing workflow.
• Coordinated testing team to get the testing information from all the tracks.
• Worked on inbound and outbound interface testing
• Resolved issues during the System Integration and Customer Acceptance testing phases.
• Worked with Quality center for uploading requirements.
• Worked with business users to analysis graphs as required.
• Worked on the defect analysis and how to make various defect tracking.
• Worked on the reporting team for pulling the data from the brio reports into the Enterprise Data Warehouse environment.
• Worked on data mapping to check the tables on the DWH from where the data is being populated for reports
• Worked on data mapping to get to the source of the tables in DWH(CGISS, SMS)
• Worked on the servigistics extracts and analysis of data. Which table the data is coming from
• Worked on the RPSD screens to check the VB.net backend and traced out the tables from which this data is getting extracted.
• Worked as a Business System Analyst to analyze the data source for the RPSD screens, Servigistics and Brio Reports.
• Developed MS Excel feeds using Discoverer Reports for Revenue Recognition, Product Shipped and various other requirements.
• Developed functional mapping for existing legacy system to Oracle Apps. (Utilizing functionality of Key flex fields and Descriptive flex fields)
• Worked on creating lookups according to the requirements.
• Used Oracle TCA tables for Customer contact, Customer contact point’s information.
• Worked on Kintana and clear case for moving from development to test instance.

Environment: Oracle Application 11.5.10, R12, Oracle Manufacturing (INV, BOM, WIP, PA, OTC, P2P, Shipping, Order Management, PO), TOAD 7.6.0.11, Visio 2000, Shell Script, Kintana and clear case, CGISS DWH, SMS DWH, Brio reporting tool, VB.net, Informatica, ORacle and Yantra.

Confidential

Oracle Apps Consultant

Responsibilities:

• Developed custom reports like PO returns report and Bin replenishment report.
• Involved in attaching new BOM components to the existing BOM structure according to the rules provided by the Business.
• Involved in the technical design and coding for conversions, interfaces and custom application development. Several inbound tables, snapshots, views, procedures and packages were built during the application development. Was involved with BOM, INV, WIP, OE-OM, MRP, CRM, PO, FA and HR modules. The core part of the application development was in sql, sql-plus, and command shell scripting.
• Designed and developed strategy to capture the legacy data and API to ORACLE database. Bom bill of mtls interface and bom inventory components interface were populated during conversion and API inserts the information to Oracle base tables.
• Populated base tables with legacy customer information. Developed orders interface to populate the oe order headers all and oe order lines all. Similarly a custom interface program is developed to inform shop floor about the open orders and related customer information from Oracle WIP and ORDER tables.
• Involved customizing the Pick Release and the Allocation process.
• Developed MS Excel feeds using Discoverer Reports for Revenue Recognition, Product Shipped and various other requirements.
• Developed functional mapping for existing legacy system to Oracle Apps. (Utilizing functionality of Key flexfields and Descriptive flexfields)
• Customized various reports in INV like Customer Items Report, Customer Item Cross References Report and Inactive Items Report
• Using Oracle TCA tables for Customer information report.
• Developed technical design and test documents complying with Oracle AIM standards

Environment: Oracle Application 11.5.10 Oracle Manufacturing (INV, BOM, WIP, OTC, Shipping, Order Management, TOAD 7.6.0.11, Visio 2000, Shell Script.

Confidential

Oracle Apps Consultant

Responsibilities:

• Involved in Customization of whole end-to-end process from Order to Cash.
• Interacted with functional users and handled the Order Processing issues and work on the solution to fix the problem.
• Designed and developed the Functional Docs (MD.020), Technical Specification Docs (MD.070), and Unit Test Cases Docs (MD.120).
• Created Alerts which send mails to the support teams when any concurrent request runs for more than an hour.
• Worked on the issues of Orders with Pick release, Ship Confirm processes, and Order status.
• Worked on custom stored procedures using PL/SQL. Writing SQL scripts for identifying the issues related to Orders, Deliveries in the database.
• Registered custom tables on Oracle 11i (Accounts Payable, Accounts Receivable and Order Management).
• Conversion of Sales orders from Legacy to Oracle 11i
• This involved the API OE ORDER PUB.PROCESS ORDER
• Conversion of BOM and Routings from Legacy to Oracle 11i,
• This involved standard interface methodology
• The APIs involved are BOM BO PUB.PROCESS BOM and BOM RTG PUB.PROCESS RTG
• Outbound Interface for UPS shipping, delivery and Inbound Ship confirm API
• WSH DELIVERY DETAILS PUB.Update Shipping Attributes,
• WSH FREIGHT COSTS PUB.Create Update Freight Costs,
• WSH DELIVERIES PUB.Delivery Action
• Created Bills of Materials (BOMs) from front end using applications.
• Responsible for all Manufacturing conversions viz., Items, Item Catalogs, Item Categories, Bills of Material, Item Templates, Item cross references, Item Costs.
• Worked with Journal Import to bring legacy journals from AP, AR and Posting in Oracle General Ledger.
• Responsible for importing, reconciling and posting journals from different modules to GL.
• Developed a Custom API for Item and BOM Import.
• Worked on Performance Tuning using tools TOAD, HINTS, EXPLAIN PLAN and Auto trace.
• Developed Custom Reports like Aging Analysis, and Outstanding Invoices.
• Providing Super User and End User Training including preparing training material.
• Assisting in Go-Live and providing support to the Production system and resolving issues.

Environment: Oracle Apps 11i (11.5.10), OE, OM, WSH, AP, AR, GL, Oracle 9i, Pl/SQL, SQL*Plus, SQL*Loader, Forms 6i, Reports 6i, TOAD, Discoverer 9i, Windows XP, UNIX.

Confidential

Oracle Technical Consultant

Responsibilities:

• Documented functional features and behavior of required customizations using AIM methodology. Prepared and involved in analyzing conversion documents CV 40, CV 60 and MD70.
• Worked on the development of Interfaces, Data Conversions, Developing new Forms, Reports, Customizing Oracle Reports in Order to Cash, Procure to Pay Cycles touching various modules such as INV, OM, SHIPPING, AR, PO and AP.
• Developed Order Import Interface for business applications to load header and line details by creating Staging Tables and performing validations by writing PL-SQL package into the Order Import (OE) headers and line interface tables and then to OE base tables.
• Worked on Pick release public API and used WSH PICKING BATCHES PUB package for creating and releasing batches.
• Worked on Freight costs public application program and used WSH FREIGHT COSTS PUB package for updating, validating and deleting freight cost records.
• Designed and developed Interface for import of vendor information and Vendor site information into the system
• Developed conversion program to import PO Requisitions from flat file to PO Interface table using different validations like verifying vendor Id, charge account, code combination Id, Unit of Measure.
• Worked on Auto lock box open interface to outsource the accounts receivable payment processing and for automatic generation of receipts.
• Involved in Customer Conversion to load Customer details into HZ tables by creating staging tables and performing validations and finally loading them in to base tables using TCA APIs.
• Defined customer profiles, customers, payment terms, payment methods and tax structures, including tax exemptions and exceptions in AR
• Updated Profile Options for related modules and successfully upgraded to Multi-org functionality.
• Designed and developed interface program to capture shop floor data through a custom API process.
• Developed Discoverer Reports in Purchasing(PO) Module like, Purchase Price Variance(PPV) and Invoice Price Variance Reports(IPV)
• Developed XML Reports like (AR Invoice Report, Debit memo, Credit Memo, PO Printing Report, Requisition Printing Report)
• Customized Workflows for sending notifications using workflow 2.6.3. Prepared functional and technical specifications according to Organizational wide standards.
• Involved in Training the end users on the functionality of Procure to Pay modules.

Environment: Oracle E-Business Suite 11.5.9(INV, OM, PO, AP, AR and GL), Oracle 9i, PL/SQL, Forms 6i, Reports 6i, Work Flow 2.6, Discoverer 9i, UNIX, Apache Tomcat, TOAD.

Confidential

Oracle Developer

Responsibilities:

• Took part in the entire phase of the project which includes, initial operations analysis, business process re-evaluation, testing, training, conversions, customizations and documentation and implementation of modules.
• Created Sets of Books in GL by defining Key Flex Fields, segments, value sets, accounting calendars, currencies.
• Worked on Deduction Override interface in FA.
• Personalization of Oracle forms like, Order Entry, Item Master, Material Transactions and various other forms using custom.pll, as per the client’s requirements, using Oracle Forms
• Involved in customization of several standard reports to serve important business processes very specific to the client. Such reports include Purchase Order Detail Report in PO, OM reports like Pack List Main Report, Summary Pack List Report, Sales Acknowledgement Report, Order Holds Report and Inventory Movement from one inventory org to another inventory org in INV
• Used AOL features and Reports extensively while working on Invoice aging reports, stopped payment report, invoice audit report. Registered these reports as concurrent program in AOL and modified request group to add the programs
• Created various UNIX Shell Scripts for scheduling various data cleansing scripts and loading process. Maintained the batch processes using Unix Shell Scripts.
• Involved in design, development and Modification of PL/SQL stored procedures, functions, packages and triggers to implement business rules into the application.

Environment: Oracle E-Business Suite 11.5.10 (INV, OM, PO, BOM, Routings), Oracle 8i, PL/SQL, Forms 4.5, Reports 2.5, ANT, UNIX, Apache Tomcat, TOAD.