PROFESSIONAL PROFILE:

Highly motivated and enthusiastic Oracle Applications Consultant/Developer with proven expertise in both Technical and Functional capacities. Outstanding technical skills in implementing Oracle Financials (several modules).Experienced in writing functions, procedures, packages and database triggers, Unix Shell Scripting. Experienced in Data Conversion Strategies Experienced in tuning SQL statements using proper Hints. Ability to work autonomously as well as a team player. Easily adaptable to change with an eagerness towards learning and expanding capabilities.

SOFTWARE SKILLS:

ERP/CRM: Oracle Applications 10.7SC/11.0/11i/12i AOL, GL, AR, AP, INV, ONT(Order Management), Shipping, PO. SYSADMIN,EDI Gateway(Oracle EC - Gateway), BOM, WIP, MFG, WORK FLOW, Oracle Data warehousing, Service Contracts, salesforce.com, Working knowledge in BPEL(Business Process Execution Language).Retek(10.6)

OS: MSDOS, UNIX (HP,SOLARIS, Confidential AX), LINUX, WINDOWS9x, NT,WINDOWS 2000,Windows XP, Windows Vista, Windows 7

4GL/Case Tools: C, SQL, PL/SQL, COBOL, PERL, SED, AWK, B-SHELL, K-SHELL CL/400, Cobol/400, RPG/400, FORTRAN, BASIC. DEVELOPER 2000(FORMS4.5/5.0/6.0(6i)/9i, REPORTS 2.5/3.0/6.0(6i)/9i),VISUAL BASIC, HTML, CICS, Synon 2e. SQL * Loader, SQL Trace, TKPROF utility, JCL, MVS, SQL Navigator, TOAD, Procedure Builder.PL/SQL Developer. GNOME, KDE, CDE. Pro*C, Designer/2000/6i/9i, Discover3i/4i/9i,A/S400,Synon4(e), Oracle Warehouse Builder, XML, JAVA2, Oracle JDeveloper,(Developing RIA Web applications with ADF), Working knowledge of BPEL(Business Process Execution Language), Cloud Computing, Informatica (ETL)10.X, Oracle BI Enterprise Edition(OBIEE)

DBA Skills: Installation of 9i, 10g, 11g Databases. Creating RAC instances. Administering the DBA tasks using Oracle OEM. Configuring Net using Oracle Net configuration assistant (configuring listeners, Naming methods configuration, Local net service naming configuration, Directory usage configuration). Creating databases, modifying the existing database parameters etc. Creating different kinds of tablespaces, users etc. Exporting, importing data files. Monitoring Users activities. Configuring web based isql* plus etc. Creating Backup schedules, exporting and importing Database Tables info. Web logic Server Configuration.

PROFESSIONAL EXPERIENCE:

Confidential, NY

Sr. Oracle EBS EDI Lead/EDI Architect

Responsibilities:

• Designed Inbound, outbound directory structures and associated archive, error directories. Where sterling to drop the files and from where sterling to pick up the file. Bank files (Payment Order files) to capture in separate directory structure for security reasons.
• Designed and developed automation process for inbound files. Inbound files are coming by country wise. Automation process is designed to handle all files of particular transaction by country are grouped and make a bulk file and file has to be pushed to native process to process.
• Designed and developed the EDI files audit process. In order to keep the data processing in sync we need auditing the files process (file received vs files sent by Sterling and File generated by EBS vs files received by Sterling.) etc. Inbound files are batched by country.
• Designed and developed EDI850 Purchase orders inbound process for stagnated documents.
• Designed and developed the item derivation Process based on lens parameters.
• Designed outbound director process for handling all edi outbound transactions that are created files in outbound directory.
• Incorporated the functionality of auditing the outbound files.
• Designed Customer EDI861 (Customer Receipt Advice info) custom process to hold the invoices until we get the customer acceptance info.
• Designed the report for EDI861 for validating against Shipped Quantity vs Customer accepted quantity.
• Designed and developed the EDI850 POI Wrapper program to process the EDI850 file with legacy address ref and without EDI Location Code.
• Designed and developed ASN wrapper Program.
• Designed and developed INO wrapper program and extension process.
• Designed and developed POAO/POACO wrapper Programs.
• Designed Audit files report, Stage Documents Report, Item validations and deletion of interface data report.
• Designed multi-threaded triggering process for all inbound files.
• Designed multi-threaded triggering process for all outbound transactions.
• Assisted 3PL transactions (940/945) etc.
• Designed ASN, INO re-con reports.
• Designed Inbound ASNI wrapper program.
• Provided Use cases and user in Oracle EDI.
• Resolved several issues with Oracle through Oracle SRs.
• Managed and trained several countries EDI personal for the client.

Environment: Oracle Applications 12i (12.2.3)/ (Oracle Payments, Oracle Field Service, Oracle Depot repair, Oracle e-Commerce Gateway, Oracle Release Management, Oracle Purchasing, Oracle Work In Process, Oracle Bill of Materials, Oracle Enterprise Asset Management (EAM), Advanced Collections, Oracle Quality. Order Management, Warehouse Management, Shipping, Oracle e-Commerce Gateway, Oracle xml gateway, Inventory, Receivables, Purchasing, Payables, Service Contracts, Application Developer, System Administration), Oracle database10g/11g, Oracle Developer 2000 6i, 9i and 10g. SQL Navigator, PL SQL Developer, HP UNIX., RICE. Gentran 4x, XML Publisher (BI Publisher). Biz Talk B2B translator.

Confidential

Sr. Techno-Functional Consultant/EDI Tech Manager

Responsibilities:

• Integration of Oracle Payments System with Third Party Payments System (Tsys) for Credit Card Authorization Funds Capture and Funds Disbursement.
• Configuration of Oracle Payments System.
• Developing the interface INT-CSP001-I for Inbound Scrap Adjustments to Oracle Field Services.
• Developing Confidential outbound Interface for sending Scrap Pos and Requisitions to UPS.
• Developing INT-CSP015-I for Vendor Scrap Adjustments for REPAIR and SORT vendors importing for repair and scrap items into Inventory Miscellaneous Transactions
• Developing the second part of the above interface for REPAIR sourced items to create internal requisitions into Oracle Field Service.
• Coordinating with Other functional teams for information gathering for developing the interfaces.
• Coordinating to peers for their development for interfaces.
• Coordinating DBA team for Oracle recommended setups and generating logs and debug files and uploading to Oracle etc.
• Coordinating off shore team for integration.
• Developing Technical docs (TDD), DOUs etc.

Environment: Oracle Applications 12i (12.1.3)/ (Oracle Payments, Oracle Field Service, Oracle Depot repair, Oracle e-Commerce Gateway, Oracle Release Management, Oracle Purchasing, Oracle Work In Process, Oracle Bill of Materials, Oracle Enterprise Asset Management (EAM), Advanced Collections, Oracle Quality. Order Management, Warehouse Management, Shipping, Oracle e-Commerce Gateway, Oracle xml gateway, Inventory, Receivables, Purchasing, Payables, Service Contracts, Application Developer, System Administration), Oracle database10g/11g, Oracle Developer 2000 6i, 9i and 10g. SQL Navigator, PL SQL Developer, HP UNIX., RICE. Gentran 4x, XML Publisher (BI Publisher). Biz Talk B2B translator.

Confidential, Arlington Heights, IL

Sr. Techno-Functional Consultant

Responsibilities:

• the Confidential team in RLM setups for Frozen, Firm, Forecast demand needs,
• EDI gateway setups.
• Correcting Customer, Item X refs, Customer Cross setups.
• Correction of Forecast Source lists by customer etc.
• Creation of mapping templates for the above two transactions.
• Guiding X12 mapping team for Oracle ERP suitable file translation.
• Unit testing, flow through testing for the above two transactions.
• Developing Gap Documents for Customer ASN transactions.
• Developing technical document Using Extensible Architecture for Customer ASN Transactions.
• Whirlpool Consignee order shipments and ASN Customization.
• Assisting Whirlpool IRSO transactions etc.
• Assisting Order Management/Shipping related issues etc.
• Designing Inbound Product activity Data Transaction EDI852.
• Developing Process for EDI852 Process.
• Assisting Auto-invoice issues.
• Assisting Receiving Transaction issues.
• Toyota Customer DSNO Pre-Validation Report Process design.
• Honda Customer DSNO Pre-Validation Report Process design.
• Developed RLM Transactions Trouble Shooting Strategies.
• Designed Testing Strategies for RLM Transactions.
• Creation of MD50, MD70s for Consignee Order DSNO process.
• Creation of MD50, MD70s for Consignee Org Receipt Process.
• Creation of Oracle SR for Global Forecast List usage for RLM and resolving the issue.
• User for RLM transactions.

Environment: Oracle Applications 12i (12.1.3)/ (Oracle e-Commerce Gateway, Oracle Release Management, Oracle Purchasing, Oracle Work In Process, Oracle Bill of Materials, Oracle Enterprise Asset Management (EAM), Advanced Collections, Oracle Quality. Order Management, Warehouse Management, Shipping, Oracle e-Commerce Gateway, Oracle xml gateway, Inventory, Receivables, Purchasing, Payables, Service Contracts, Application Developer, System Administration), Oracle database10g/11g, Oracle Developer 2000 6i, 9i and 10g. SQL Navigator, PL SQL Developer, HP UNIX., RICE. Gentran 4x, XML Publisher (BI Publisher). Biz Talk B2B translator.

Confidential, Venice, FL

Sr Technical Consultant

Responsibilities:

• Designed and Created Wip to Bom Sub inventory Transfer process for Decoration and Label Items.
• Designed and created Discoverer Reports (Many of them have the Pre-process PLSQL packages). Some of them are,
• Enhancements for EDI 944 Transaction for Blanket Pos.
• Enhancements for EDI943 Transaction.
• Enhancements for EDI945 Transaction.
• Flow Testing from 3PL warehouse to EBS and EBS to 3PL warehouse via Biz Talk services.
• Configuring the Dunning Letters of different degrees using Advanced Collections/Receivables.
• Modifying the Dunning Letters suitable to Tervis Needs.
• Creating Different Kinds of FSG reports.
• Enhancements for Integration processes for Flow Schedules, Price Lists, Items, BOMs, Store Locations etc.
• Designed and created process for internal requisitions integration and receipt against internal requisitions.
• Creating Migration Scripts to move database objects from instance to instance to instance.
• Data reconciliation for deliveries, orders, customer, items, requisitions between EBS, RMS, MES, WCS etc.
• Creation of data discrepancy reports across instances and across multiple platforms.(EBS, RMS,MES,WCS, EMU, SIT, UAT etc.).
• Creation of SRs with Oracle and resolving them.
• Creation of process for Internal Org Transfers.
• Resolving Freight Amounts info from 3PL Warehouse Ship Confirmation Messages on Invoices.
• Performance and Tuning for Sales Orders Outbound View and Manufacturing Data Collection Pre-Processor.
• Provided User on RMS -> EBS -> RMS internal requisitions and internal sales orders.
• Configuring Smart Bare QA Complete/Test Complete. Selenium software for Testing.
• Configured Oracle Data Integrator (ODI) for data imports into custom tables from Flat Files, to replace informatics tool.
• Configuring Ignite Software for Database Performance monitoring.
• Configuring Web-logic Server for SOA.
• Configuring BAM and SOA servers.
• Developed standalone ADF pages for Manufacturing Data Collection, Integration Processes, EDI Processes.
• Technical Resource planning and Tasks Planning.
• Organized Technical discussions with other peers and associates. Functional discussions with end users.
• Trained end users in Applications Navigation, and running reports etc.
• Involved in designing ‘Double Blind Shipments’ process. And modifications for Pick slip and Pack slip reports for this kind of shipments.

Environment: Oracle Applications 12i(12.1.3)/ (Oracle Purchasing, Oracle Work In Process, Oracle Bill of Materials, Oracle Enterprise Asset Management(EAM), Advanced Collections, Oracle Quality. Order Management, Warehouse Management, Shipping, Oracle e-Commerce Gateway, Oracle xml gateway, Inventory, Receivables, Purchasing, Payables, Service Contracts, Application Developer, System Administration), Oracle database10g/11g, Oracle Developer 2000 6i, 9i and 10g. SQL Navigator, PL SQL Developer, HP UNIX., RICE . Gentran 4x, XML Publisher(BI Publisher). Biz Talk B2B translator.

Confidential, Oak Brook, IL

Tech Lead Oracle EDI

Responsibilities:

• Designed and created process for Account Receivables and Account Payables finance documents uploading and downloading from various banks.
• Designed and created reconciliation process for their day to day EDI transactions between Oracle EBS suite and Confidential in-flight.
• Designed and created Supplier ASNs (EDI856 Inbound) post process, to bring the suppliers purchasing sites from purchase orders and triggering mail system to send mails for AP department if the Purchase order is for PRE-PAID terms etc.
• Designed and created Supplier Invoices (EDI810 Inbound) Post Process to get the functionality of bringing GL accounting structures for Miscellaneous Charges, Freight Charges, Taxes etc.
• Designed and created Consolidation/Automation process for all EDI transactions, except Customer Pos
• Designed and created Consolidation Process as a separate process for Customer Pos.
• Designed and created custom EDI945 Process to do ship-confirmation automatically.
• Created XML Publisher Reports for Customs submission purpose, Supplier ASN receiving, Ap Invoices, Customer Trading Partner Setups and Supplier Trading Partner setups and Reconciliation reports for various EDI transactions
• Designed and Created secure ftp process from Oracle EBs to ITC servers followed by ITC to City Bank Servers.
• Created MD120s, MD80s for the implementation.
• Provided User
• Designed and created adhoc Process for re-generating the various EDI transactions after first pass.
• Provided queries to users for day to day enquiries.
• Created OBIEE Answers and Dashboards.
• Involved in Trading Partner data conversion, and Transactional data conversions like Open Pos, and Open Sales Orders and Open AR and Open AP Invoices.
• Developed several crystal reports for EDI transactions.

Environment: Oracle Applications 12i(12.1.3)/ (Oracle Purchasing, Oracle Work In Process, Oracle Bill of Materials, Oracle Enterprise Asset Management(EAM), Custom schemas XXELKAY TOP, XXDAZ TOP, Order Management, Warehouse Management, Shipping, Oracle e-Commerce Gateway, Oracle xml gateway, Inventory, Receivables, Purchasing, Payables, Service Contracts, Application Developer, System Administration), Oracle database10g/11g, Oracle Developer 2000 6i, 9i and 10g. SQL Navigator, PL SQL Developer, HP UNIX., RICE. Gentran 4x, XML Publisher (BI Publisher)

Confidential, Boca Raton, FL

Techno-Functional Consultant

Responsibilities:

• Designed EDI856 both incoming and outgoing process and developed the process for supplier ASNs and Customers ASNs.
• Designed and created Advanced Advanced DSNO process (ADSNO) for customers who need ASN for pre load and post load trucks.
• Created Assumption Based Scanning process for bringing all labels info to the delivery details.
• Designed and created Pre-generation of ASN numbers for certain customers like SEARS Canada and modified the DSNO process to use the pre-generated DSNO process.
• Designed and created automation process for both inbound and outbound transactions.
• Created process to push the CANADA SEARS customers Assumption based scanning requests and DSNO as high priority.
• Designed and Created Supplier ASNs cancellation process, which are already staged in Oracle receiving tables.
• Designed and created process to create Supplier LPNs into warehouse LPNs system.
• Designed and developed Customer Electronic invoices (EDI810) process.
• Designed and developed Canada Label printing process using EDI864 transaction. It is still ongoing implementation at this point.
• Developed several crystal reports based on custom tables for all customizations.
• Designed and developed Customer Credit and Debit adjustments process (EDI812).

Environment: Oracle Applications 12i(12.1.3)/ (Oracle Purchasing, Oracle Work In Process, Oracle Bill of Materials, Oracle Enterprise Asset Management(EAM), Custom schemas XXHHF TOP, XXDAZ TOP, Order Management, Warehouse Management, Shipping, Oracle e-Commerce Gateway, Oracle xml gateway, Inventory, Receivables, Purchasing, Payables, Service Contracts, Application Developer, System Administration), Oracle database10g/11g, Oracle Developer 2000 6i, 9i and 10g. SQL Navigator, PL SQL Developer, HP UNIX., RICE . Gentran 4x, XML Publisher (BI Publisher

Confidential, Atlanta, GA

Techno-Functional Consultant

Responsibilities:

• Involved in Conversion process for new acquisitions (ARS06), which include converting ROUTES, CUSTOMERS, PROJECTED PURCHASE ORDERS, ITEMS, PRICE LISTS, AR TRANSACTIONS, CUSTOMER NOTES which include general notes, delivery notes, driver instructions etc.
• Modification of meter millage process for updating meter reading taken dates.
• Modification of Future filtration report to provide selection for active and inactive contracts.
• Modified Pre-route report to include customer lockout names, message displays etc.
• Modified Special Price activity report to show the web pricing and differences from regular and web price.
• Customized Create Po Documents work flow to create purchase orders automatically once the EAM requisitions get approved.
• Generating reports for all objects using special profile option, which includes sql statements, packages, procedures, functions, reports, forms etc.
• New form design and creation for EAM resource charges info entered via EAM web browser.
• Production support for issues like penny difference, printing issues etc.
• Created Inbound Mapping for supplier invoices using Sterling Map editor for X12 format to OAGXML format.
• Created Outbound Mapping for customer Invoices using Sterling Map Editor for OAGXML format to X12 format.
• Created new applications forms for Invoice and Collateral Payments.
• Resolving issues related to Customer Address Change workflow, Customer Termination Workflows
• Modified the payment acquisition report, future filtration call list report etc according to functional needs.
• Modified Acquisition Payout report, Tax Exempt Expiration info report etc.
• Created and modified several crystal reports for finance department.
• Designed and created Concurrent program to update the serial numbers in install base item instances table, via APIs.

Environment: Oracle Applications 12i(12.0.4)/ (Oracle Purchasing, Oracle Work In Process, Oracle Bill of Materials, Oracle Enterprise Asset Management(EAM), Custom schemas SWGDD, SWGCUS, SWGCON etcOracle e-Commerce Gateway, Oracle xml gateway, Inventory, Receivables, Purchasing, Payables, Service Contracts, Application Developer, System Administration), Oracle database10g/11g, Oracle Developer 2000 6i, 9i and 10g. SQL Navigator, PL SQL Developer, HP UNIX., RICE . Gentran 4x, XML Publisher(BI Publisher

Confidential, Phoenix, AZ

Techno functional consultant/Programmer Analyst

Responsibilities:

• Designed the data architecture(DFDS, ERDS, Tech Specs etc.) and created the PLSQL Package process EDI940(Warehouse shipping info) to extract the pick released orders from Confidential and to send to K & N. Performed the EDI Setups and Validations for this process. Communicated with OneEDI Source (The translator) for mapping issues and modification in process whenever it is required.
• Designed the data architecture (DFDS, ERDS, Tech Specs etc.) and created the PLSQL process EDI861 (Warehouse Receipt Confirmation) to create the receipts in Purchasing based on the Receipt confirmation info from K & N.
• Designed the data architecture (DFDS, ERDS, and Tech Specs etc.) Edi945(Warehouse Ship confirm) process to do the ship confirm automatically for all the pick released and waiting for the ship confirm for the orders which Edi940 sent to K & N.
• Designed the data architecture (DFDS, ERDS, and Tech Specs etc.) and created the PLSQL process for Po Receipts extraction for the newly acquired Euro (Thales) Project. BABTEC, the Germany Org required the receipts info once the receipt is created in the purchasing. Designed and created the po receipts extraction process, which extracts the receipts info into custom tables based on the Germany organization. Also designed and created Items Interface and Suppliers Interface to BABTEC.
• Designed the data architecture (DFDS, ERDS, and Tech Specs etc.) and created interface for Sweden Postal Department labeling system (PACSOFT) using Oracle PLSQL. Confidential supposed to send the customer and orders information to Sweden Postal Department after pick releasing the order.
• Customized Spain org Pack Slip report, Receipt Traveler Report, Printed Purchase Order Report etc.
• Imported Sweden Service contracts via APPLOAD tool and written custom PLSQL process for creating Service Contracts billing and scheduling, creating service contracts sales credits and service contracts updates. Designed and created custom process for re-newel service contracts amounts updates.
• Imported item on hand quantities to oracle inventory via APPLOAD tool, Imported Purchase orders into Oracle Purchasing via APPLOAD tool. Designed and Created process to import Customers conversion data and Interfacing data to Oracle Applications for France and Belgium customers. Designed and Created process to import Invoices conversion data and interfacing data to Oracle Applications for France and Belgium customers.
• Created custom process for integration between Oracle HRMS and Microsoft ILM (Active Data Directory) for employee’s termination, delete and updates for active employees.
• Modified several reports for Germany Organization such as Pick slip report, Pack slip report, Order Acknowledgment report, Invoice Report, Supplier Audit Trail report, Customer Vat Tax report, Serial numbers report etc. Created new reports for repair orders.
• Designed the data architecture (DFDS, ERDS, and Tech Specs etc.) and created Customers and Invoices import for France (FRT, FRW) and Belgium Organizations (FBT) using PLSQL. Created Automation process UNIX Shell Scripting for the invoices and customer files. Created reports for users to know statistical analysis of knowing the import loads etc.
• Designed the data architecture (DFDS, ERDS and Tech Specs etc.) and converted Euro (FR, Sweden) Price lists.
• Created Process flows, Added attributes, validations etc while creating the JSF pages.
• Installation and configuration of OBIEE.
• Created repository files, Creating OBIEE Answers, Creating Dashboards, ibots etc.
• Also worked on Electronic purchase orders EDI850, Invoices EDI810, Advance shipment Notices EDI856 (For both suppliers and customers).

Environment: Oracle Applications 11i (11.5.10.0.2 )/12i((12.1.1.0)(Order Management, EDI, Oracle e-Commerce Gateway, Inventory, Receivables, Purchasing, Payables, Service Contracts, Bill of Materials, Oracle HRMS, Application Developer, System Administration), Oracle database10g/11g, Oracle Developer 2000 6i, 9i and 10g. Oracle Discoverer 3i/4i/6i/10g, SQL Navigator, PL SQL Developer, HP UNIX., RICE . OneEDI Source, Gentran 4x, AppLoad. XML Publisher (BI Publisher), Oracle JDeveloper 11g (11.1.1.2.0 ) (11g ADF (Application Development Framework), OBIEE (10.1.3.4)

Confidential, Fond Du Lac, WI

Techno Functional Consultant/Programmer Analyst

Responsibilities:

• Successfully implemented the Release Management for the customer Confidential Davidson. Created the processing rules for Order Management level. Communicated the Translators and end customer for SPSI and SSSI transactions. Created Matching rules. Resolved the stagnated demand schedules from transaction work bench. Resolved the issue of release id not going through Advance shipment notices. Provided user how to enter the orders for Confidential Davidson via Release Management.
• Did the setups for Payment Remittance transaction (ECEPYO) for Bank of America e-Payables project. Did the setups for vendors, vendor sites, payment terms, format program etc. for this purpose. Did the setup on Oracle e-Commerce side for the BOAEPAY as trading partner and associated TP with supplier sites. Generated the e-payables file.
• Supplied queries for the users for their day to day verification of data from the base tables. Used Oracle PLSQL procedural language to create custom packages, procedures and functions. Used UNIX k-Shell scripting to modify the lock box process etc. Created procedures for Oracle Transportation management for planned deliveries.
• Created reports using Oracle reports and XML Publisher for end users day to day analysis, how many electronic invoices went by customer by date? How electronic Purchase orders may went to suppliers by day and by date etc. Created reports to know the ASNS not went through by date etc.
• Performed user to the end users when they have trouble in understanding the processes. Created test plans to perform UAT whenever code modifications done with new functionalities.
• Correlated with DBAs whenever the performance issues for the custom codes etc. Tuned the custom programs for optimum performances.
• Creating OBIEE Answers, Creating Dashboards, ibots etc. Modified existing Dashboards, Answers by adding column inserts, views insert and created shared filters etc.
• Suggested the top Management about the requirements for enhancements of existing programs and need of new programs with proper justifications. Suggested the different soft wares based on cost and utilities and provided the acceptable reason for the need.
• Modified and Generated EDI specifications for POS, INVOICES, DESDEVS using EDIFECS.
• Data mapping using Informatica tool for data warehousing.
• Developed Several ADF pages for EDI transactional data staged in staging table, using Oracle JDeveloper
• Integrated Oracle EDI with Confidential and it associated B2B partners with internal shipments.
• Worked on EDI Trading partner setups for EDI862 Shipping Schedules with Release Management in relation to Gentran Integration. Trouble shooting the orders that were created with EDI862.

Environment: Oracle Applications 11i (11.5.10.0.2 )(Order Management, Oracle Transportation Management 5.5, EDI, Oracle e-Commerce Gateway Order Entry, Inventory, Order Management, Receivables, Purchasing, Payables, i-Procurement, Application Developer), Oracle database (9.2.0.5)/10g, Oracle Developer 2000 6i, 9i and 10g. Oracle Discoverer 3i/4i/6i/10g, TOAD, SUN UNIX., RICE tracking database tool, PVCS. Gentran NT, EDIFECS, and GIS. Oracle Warehouse Builder. Oracle System Administration. Autosys, XML Publisher, Informatica 10.0, OBIEE (10.1.3.4), Oracle JDeveloper 10g.

Confidential, Evansville, IN

Techno Functional Consultant/Programmer Analyst

Responsibilities:

Release Management, e-Commerce gateway (Oracle EDI).

• Designed and architect the Director process for all inbound transactions. This includes shell program, making bulk process by transaction, triggering the respective transaction processes.
• Designed and architect the add on processes for EDI850 inbound process. This includes the shell scripting, created orders report, sales order notes process procedures etc.
• Designed and architect the add on processes for EDI810 outbound process. This includes the extensible architecture, file creation by trading partner etc.
• Designed and architect the add on processes for EDI856 outbound process. This includes the extensible architecture, file creation by trading partner etc.
• Designed and architect the add on processes for EDI857 (Billing and shipping info) outbound process.
• Designed and architect the add on processes for EDI846 (Electronic BOL) outbound process.
• Designed and architect the add on processes for EDI855 (Electronic SO acknowledgment) and EDI865 (Electronic SO change acknowledgement) processes. This includes Sales order Booking Workflow customization, extensible architecture etc.
• Edi Trading Partner setups, cumulative quantities setups and transactions setup for EDI830 Planning Schedules, EDI862 Shipping Schedules, EDI866 Production sequences with release management. Coordination with mapping team in relation to Gentran Integration.
• Designed and Architect the return goods management process (RGA).
• Created Return orders and associated items info report for users. Created Return goods automation process to run automatically the return goods interface program and report once the return orders are created. Written the Open order extraction program to extract open orders of particular item category of one business unit to send to another business unit. Added functionality to override Credit option based on customer, item, return type etc.
• Designed and created custom package to inform the users if any automated edi process is error out or not started after any interruptions.
• Designed and created custom package to monitor all concurrent programs, and to notify the DBAs and Sysadmins if any of the concurrent program is error out or not started after any interruptions.
• Designed and Architect the custom process to cancel order lines for all open orders for the give item and to add new line item for the same order.
• Written custom package for EDI835 Outbound Catalogue price, items on hand quantities and their associated discounts.
• Written custom shell scripts for EDI856 Inbound.
• Written Custom package for EDI810 Inbound validation for drop ship orders. Written custom Shell script to run the custom validation process and ECEINI process followed by the Ap Invoices Import program.
• Designed the data architecture for Open orders extraction process from AIRTEX org to ASC org. created the process.
• Created sales data extraction program for sales data analysis discoverer reports. Created Warranties extraction program to extract the warranties info based on date range. Created Sales Data Analysis report for particular business unit for the given date range, customer and bill tos as parameters. Modified the Margin Analysis report to run with new set of parameters Customer Sales Channel, Industry, Territory Codes.
• Created Popularity Items Report in Oracle suitable to legacy report in JDE for items and their yearlong quantities. Provided the percentages. Provided numerical sort and item sort information in the report for the user to know the rank of the item among the numerical sort.
• Modified the AR statements report for sort order level. Added functionality to sort the statements based on Customer Division, Customer Number and followed by Customer Name. Created Interfaces between Oracle Order management, Oracle Shipping and Oracle Transportation Management for planned shipments.
• Involved in maintenance, analysis of critical production issues and time to time fixing the programs as the user requirement changed, testing in Development and controlled test environments. Making request to migrate to production after obtaining user satisfaction of the modified results. Assisted sysadmins in creating and registering the concurrent programs and assigning them to respective responsibilities. Assisted sysadmins to create the custom responsibilities based on business units.
• Used EDIFECS to generate ANSIX12 specifications.
• Datawerehouse data mapping using Informatica.
• Created Oracle Data warehouse mapping and transformed the online transaction data to Data warehouse tables using Oracle Data warehouse builder. Performed system administration using Oracle system administration for creating users, assigning responsibilities, registering printers, configuring printers, creating value sets, creating custom menus, creating custom menu functions, creating concurrent executables, creating concurrent programs, creating concurrent request sets, modifying system profiles at user level, responsibility level, application level, site level. Performed workflow administration.
• User and production support in purchasing provided. Customized and created several reports in purchasing

Environment: Oracle Applications 11i (11.5.10.0.2 )(Order Management, Oracle Transportation Management 5.5, EDI, Oracle e-Commerce Gateway Order Entry, Inventory, Order Management, Receivables, Purchasing, Payables, Release Management, i-Procurement, Application Developer), Oracle database (9.2.0.5)/10g, Oracle Developer 2000 6i, 9i and 10g. Oracle Discoverer 3i/4i/6i/10g, TOAD, SUN UNIX., RICE tracking database tool, PVCS. Gentran NT and GIS. EDIFECS, Oracle Warehouse Builder. Oracle System Administration, Informatics (ETL) Tool