Shobana Ashok
About
Detail
Senior Oracle Application Developer at Pitney Bowes
United States
Contact Shobana regarding:
work
Full-time jobs
Résumé
Jobs
verified_user
0% verified
Senior Oracle Application DeveloperPitney BowesApr 2013 - Current (13 years 5 months)Worked on various Financial and manufacturing modules (GL, AP, AR, PO, FA,OM, INV, SCM,CRM). Configuration of General Ledger for multiple sets of books and integration with AP & AR. Hands on experience on Oracle EBS R12 P2P (iProcurement, AP, PO, iSupplier) modules. Hands on experience on Oracle EBS R12 SCM, BOM and WIP modules. Performed data conversion from legacy system to oracle modules using SQL*Loader. HRMS integration with other Oracle Applications, including Shared and Full installation considerations. Implemented Oracle Demantra applications like demand management, sales & operations planning, and trade promotions management solutions. Worked on integration interface, workflow, methods, series and system parameters of Deman- Senior Oracle Application DeveloperGEApr 2011 - Mar 2013 (2 years)Worked on SQL* Loader to load all the data given in flat files with various special characters and comma delimiters. 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 asINV, OM, SHIPPING, AR, PO and AP. 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. Developed PL/SQL Packages, Procedures, Functions for validating the invoices and payment information from the legacy system and imported into Oracle Application using the Payables Open Interface Import programand populated in
- Oracle Application DeveloperW. R. Berkley CorporationSep 2009 - Mar 2011 (1 year 7 months)Developed interface to update On Hand Quantity for the items upon receiving Shipment Receipt. Developed inbound interface to create sales order lines. Developed PL/SQL programs to dump the data from staging tables into Base Table. Imported data from flat files located in legacy system into database table using SQL * Loader. Worked on outbound interface to load the data from base tables to staging tables. Developed an outbound interface to extract out the goods receipts information by weekly from Oracle to upload into Reject DB system. Prepared MD70 document for inbound interface. Worked with business analysts to identify requirements. Responsible for writing several pl/sql procedure, functions, triggers. Create reports such as payment statu
- TOracle Application DeveloperTCS e-Serve International Ltd.Sep 2007 - Aug 2009 (2 years)Created interface vendor validation program and also Created Initial vendor load program and Procurement New Vendor Load program. Customized the Standard Payment Batches form (check run form) and Invoice Entry form through custom.pll. Mapping of fields of CSV file to columns and imported the reconciliation data into the Oracle Cash Management Using UTL_FILE. Developed a script for Oracle custom Payment Format program in AP for check formatting and printing. Development of inbound interface custom package to validate and import invoices data into oracle applications AP Payables open interface tables from external system. Performed reconciliation of payables transactions through Cash Management module, which involves monitoring of bank statem
Education
verified_user
0% verified
- The Maharaja Sayajirao University of Baroda — Master of Business Administration (M.B.A.), Computer ScienceThe Maharaja Sayajirao University of BarodaJan 2003 - Dec 2007 (5 years)