SUMMARY

• I am a driven and motivated individual looking for challenging opportunities where I can prove my mettle. I am a quick learner and very interested in learning new technologies, have a natural drive to delve deep and figure things out if necessary.
• I am looking forward to taking a different path in my career which can help build my profile and where my experience can be an asset in the future opportunity.
• I have more than 17+ years of experience in design, development, customization, implementation and documentation of various business applications in different platforms using Client - Server Technologies. Extensive experience in Oracle Applications 11/11i/12.1.3, SQL, PL/SQL, Developer 2000 (Forms 4.5/5.0/6i/10g, and Reports 2.5/3.0/6i/9i/10g) and Oracle 7.x/8.x./9i/10g/11g/12c. Responsibilities handled include requirement analysis, system design, support, development, testing, documentation and design reviews. Exposure to Sales Force Object and schema design, permission sets, APEX Coding and JAVA web service API’s.
• 14 years in Implementation and customization of Interfaces, forms & reports in Retail.Net(Tomax) Application. Custom interfaces and Support of Oracle Applications 11i/R12.1.3 Financials modules (AP, GL).
• 10 years in Implementation and Customization of Oracle Applications 11/11.i/12.1.3 (11.5.3, 11.5.9, 11.5.10,12.1.3). Strong background in conversion, customization and interfaces of ORACLE General Ledger, Accounts Receivable, Accounts Payable, Fixed Assets, Cost Management, Purchasing, Order Management /Order entry and Oracle Inventory modules.
• Extensive knowledge in Conversions and Interfaces using SQL, PL/SQL, SQL*Plus, SQL*Loader, Linux shell scripting & PHP scripts. Also used Java, XML and HTML.
• Experience in customization and development of complex Reports in Tomax Retail.Net (Reports run from forms/menu using packages).
• Experience in customization of complex Oracle Developer 2000 Reports.
• Extensive knowledge of new forms development, reports, creating concurrent programs, creating value sets, defining form functions etc. Tuning of customizations and reports.
• Development and support of Ecommerce and Email Marketing Interfaces between several systems. (Market Live, Order Motion, Bronto, Yesmail).
• All aspects of Application Object Library, Application Diagnostics, and setting up Oracle Alerts in Oracle Applications. Supported Oracle Workflows and Notification mailer.
• Used different kinds of version control systems (PVCS, Confidential Edge, and Tortoise etc.).

TECHNICAL SKILLS

Operating Systems: MS-DOS, Windows NT/2K/XP, UNIX (HP, Sun Solaris), LINUX (Red hat)

Programming Languages: SQL, PL/SQL, XML, C, C++, Pascal, HTML, VC++, VB, and JAVA.

RDBMS: Oracle 12c, 11g, 10g, 9i, 8i, SQL.

Protocols: OSI Reference Model, TCP/IP, FTP, UDP, Socket Programming.

Tools: SQL*PLUS, SQL*Loader, Toad, Developer 2000, Oracle Forms 4i/6i/10g Reports 6i/9i/10g, Oracle Developer, Oracle Discoverer, Borland C++, XML, Oracle Workflow.

Applications: Tomax Retail.Net, Oracle Financials 11,11i,R12 (AP, AR, GL, FA, CM, INV, OM/OE and Workflow), Sales Force.

Methodologies: AIM, Object Oriented Analysis

PROFESSIONAL EXPERIENCE

Confidential, Rockaway, NJ

Oracle Programmer

Responsibilities:

• Retail.Net Application - Oracle Interfaces, Extensions, Forms & Reports Developed and worked on multiple interfaces, extensions, Reports and Forms for Party City and Halloween City.
• MarketPlace Interfaces: Orders, Inventory, Purchase Order, Shipment confirmation Interfaces to and from Channel advisor through which multiple market places have been implemented at party City. Multiple market places implemented were Amazon, Amazon FBA, Google, Rakuten, Walmart etc. Reporting and Alerts for the interfaces to track performance, exceptions etc.
• Ecommerce Interfaces: Sku Interface, Vendor Interface, Shipments Interface, PO interface, on hand interface, Adjustments Interface, Xml Invoices Interface, UPC Interface, ASN Interface, Weekly Recap, Cash box Reconciliation. Order Motion Sales Interface - Post period Invoices, Used google site radius package to update invoice data with site radius etc. Receiving interface - reopen pos when a document is received against it, add process to post ASNs. Order Motion Items upload(XML & API’s). KITSKU and Bulk Sku Export. Order Reconcilition interface to reconcile orders between Order Motion, Market Live, Fifty One.com. WEB Price Interface to track everyday price changes and promotions from Market Live and OrderMotion. Ecom sales and Invoice interfaces to load custom fields, multi currencies, multi org Data.Modified interfaces to use php scripts, to use a new and better connection timeout and error trapping logic. Worked on other miscellaneous ECOM Interface Fixes like order mismatches, missing documents etc. Husa(Halloween USA) Sites Upload, Ipsites download, Site Budget Upload, Husa Sales Download, ASN Interface, po download, sku & upc download, store transfer interface.
• Retail.Net Interfaces, Extensions: Product Hierarchy, Market Basket, GunLaw, Daily PO Cancel, New Hires, Card Orders Trigger Program, PO ON Order Interface. TRECS Interface, Gunlaw Status Class, PO Invoice Cost Alert. By Site Discontinued Flag Maintenence, Time Clock email Alert, IDM Unprocessed Alert, Update Kiosk Sale Site, Employee Attributes Upload, Aspect Sku Download. Wrote an interface for Vendor Product Sync, Wrote new interface for Skillport-Skill Soft. Employee Data Download, Inventory Adjustments Load, Physical Inventory Load.
• UPS Interface: UPS Quantum view data download, parsing and processing the data files to upload package shipment data into RetailNET.
• BRONTO,YESMAIL,MARKETING CLOUD (Email marketing Provider) Interfaces: Email data download to send to bronto, using bronto apis to push the email data into Bronto, and keep track of what has or has not been successfully sent to bronto, update sales statistics for customer email addresses in bronto and keep track of what has or has not been successfully sent to bronto. Ereceipts data download to bronto and to deliver the ereceipts to customers via bronto. Bronto interfaces, to send welcome emails and create new contacts, thank you emails and update sales statistics. Interfaces to Send and track confirmation and Ready for pickup emails for Balloon Orders.
• ARGIX Interface: ARGIX Freight data download, processing the data files to upload package shipment data into Retail NET.
• Market Live Interfaces:Wrote new Interface to import Market Live Products, Categories, Staging data for Party city and Halloween City.
• Forms: Cashier Cashbox Limits, Copy Cashier, Update Items, Create Count Sheets,Update Items.
• Reports: Ecom Royalty Report, Ecom Sales Report. Balloon Report, Card Ordering Compliance Report, DSR Report, PA Daily Budgets Report, PC Daily Store Hour Report, Store Daily Sales Report, Physical Inventory Discrepancy Report, PO Print Report, Posting Counts Status, PO Print Report, Price Change Label Selection, Performance Report,Store Labor Analysis, Balloon Report, DSR Report, ASN Report, Operations Report, Negative On Hand Report, Low out Discrepancy Report, Gross Margin Sales Report. Balloon Report, Cycle Count Outs Report, Operations Report, Organization Discount Report, Store Freight Report, Time Clock Punch Report, Time Clock Hours Report.
• Oracle Applications - Interfaces, Forms & Reports
• Designed and developed interfaces in Payables(Invoice import/supplier imports), Receivables (customers,locations,invoices import) General Ledger in Oracle Financials.
• Supported Oracle Apps R12.1.3 Interfaces, modules.
• Worked as a System Administrator managing user profiles and system profiles. Assisted the users in connection issues. Managed workflow Notification Mailer. Receiving stale data error (cache issue) while accessing forms in oracle. Resolved Gather Schema statistics Errors.
• Worked on resolving the ADI Setup Issue.
• Worked on EIS connections (XL Connect/GL Connect), Reports and issue resolution.
• Worked on 1099 Implementation, yearly application of 1099 patches.
• Worked on Positive Pay Automation.
• Worked on and resolved several miscellaneous production issues like:
• Unable to process a PPR or other PPR issues.
• Assisting users with Journal Import issues.
• Investigated issues when the periods could not be closed (pending invoice adjustments, .. etc)
• Assisted in Canada Implementation, Oracle Financials upgrade, Conversions and Interfaces required during the oracle upgrade, 1099 implementation, and Production Support
• Worked on resolving ACH payment issues, Positive pay issues. Wrote a custom script to consolidate and ftp all relevant positive pay files for the day to the Bank.
• Check printer support. Desktop integrator issues & Oracle blocking session issues

Environment: Tomax Retail.Net, Oracle 10g, Oracle 11g, Oracle Applications 11i, Oracle Applications R12, GL, AR, AP, FA. Forms and Reports 10g, PL/SQL, SQL*Plus, TOAD, LINUX, UNIX, Shell scripts, PHP scripts, Sales Force, Apex, Java, Net Beans.

Confidential, New York City, NY

Oracle Applications Senior Technical Consultant

Responsibilities:

• Purchasing Project - Designed and Developed Custom Supplier interface program using Vendor API’s. Designed and developed a custom report to list the successes and rejections in the supplier interface Import for suppliers, sites & contacts in one report.
• Purchasing Project - Designed and developed custom invoice interface & a custom report to list the pre processing errors (Ex: invalid legacy supplier site reference, invalid code combination for distributions etc…).
• Purchasing Project - Designed and developed code for exporting Payments (interface) to the legacy system.
• Purchasing Project - Designed and developed code for exporting GL Segments (interface) to the legacy system.
• TM1 Project - Designed and Developed code for exporting GL Actual Balances (interface) to the legacy system.
• TM1 Project - Customized the existing Custom Budget Import interface to deal with the invalid account code combinations.
• BP Financials Project - Designed and developed custom report for AP Volumes to List all processed Invoices at Summary and detail level based on the Username or Invoice Source.
• BP Financials Project - Customized the existing Asset Additions by CAR Number Report to include adjustments, transfers and reclassifications.
• BP Financials Project - Assets by Location Report - Designed and developed Custom Assets by Location Report to include Summary and Detail level information of Asset Inventory grouped by location.
• Developed code bundles (Shell scripts required to migrate the database objects, concurrent program registration details etc., related to RICE objects from one instance to another).
• Developed Technical Design Documents for the custom Interfaces, Reports, and Conversions.

Environment: HP-UX 11.11, Oracle 9.2.0.6, Oracle Applications 11i/11, GL, AR, AP, FA, AOL, PO, OM/OE, CM. Forms 6i and Reports 6i/9i, PL/SQL, SQL*Plus, TOAD, UNIX, Shell scripts.

Confidential, Rockville, MD.

Oracle Applications Senior Technical Consultant

Responsibilities:

• Designing Technical Documents for the custom Interfaces & Development.
• Designed and developed code for interfacing ACH & CREDIT CARD Receipts using Receipts API from Treasury to FDA.
• Developed procedures and packages required for the interface, to book the orders and create invoices through the program after the payments are received through Lockbox from Bank, then create and apply receipts.
• Developed Flexible PL/SQL Scripts/Packages for Data Objects Creation such as Tables and Procedures, Packages required for the Interfaces, data conversion.
• Designed and developed custom program to download an xml data file from legacy server to oracle server.
• Designed and developed code to save xml data file in oracle and parse it to extract specific information, to be used to interface ACH and Credit card receipts to oracle.
• Developed code to alert the user via e-mail, whenever the data to be interfaced is.
• Designed and developed Custom PLSQL package to receive payments through Lockbox for Orders and Invoices, then process the order booking and auto invoicing for the orders and create and apply cash for the payments received against the orders/invoices.
• Designed and developed code bundles (Shell scripts required to migrate the database objects, concurrent program registration details etc., related to a rice object from one instance to another).
• Involved in constant interaction with the DBA team for DB Link creation, Synonym creation and the migration of objects from one instance to another.

Environment: SUN Solaris 9, Oracle Applications 11i/11, GL, AR, AP, AOL, OM/OE, BOM. Forms 6i and Reports 6i/9i, PL/SQL, SQL*Plus, TOAD, UNIX, Shell scripts.

Confidential, Irvine, CA

Oracle Applications Senior Technical Consultant

Responsibilities:

• Designed Technical Documents for the custom Reports, Conversions & Development.
• Designed and Developed code for Formula Conversion, Process Instructions and Manufacturing instructions Conversion (These conversions were done using both Public and Private API’s from ‘PICK’ to Oracle).
• Developed code for AP Open Invoices Conversion.
• Designed and developed code for Item Costs Conversion from EPICOR to Oracle.
• Developed Flexible PL/SQL Scripts/Packages for Data Objects Creation such as Tables and Procedures, Packages required for the Conversions, Reports.
• Designed and developed the customizations for the Barcode Reports (Pick Slip Report, Interorg transfer In Transit Manifest Report, LPN Report)
• Designed and developed code to run the Interorg In transit Manifest Report, when an interorg transfer takes place through Telnet and print the report automatically.
• Developed code to alert the user, to update costs for the ODM Items whenever a cost update is run for the OPM Items.
• Designed and developed the customization for Invoice on Hold Report.
• Designed and developed code bundles (Shell scripts required to migrate the database objects, concurrent program registration details etc., related to a rice object from one instance to another).
• Involved in constant interaction with the DBA team for DB Link creation, Synonym creation and the migration of objects from one instance to another, Barcode generation.

Environment: AIX 5.3, Oracle Applications 11i/11, GL, AR, AP, AOL, OM/OE, BOM, GMA, GMD, WMS. Forms 6i and Reports 6i/9i, PL/SQL, SQL*Plus, TOAD, UNIX, Shell scripts.

Confidential, TX

Oracle Applications Technical Consultant

Responsibilities:

• Designed Functional & Technical Documents for the custom GL interfaces from CIS and ADP.
• Designed and Developed code for GL interfaces from CIS to Oracle and from ADP to Oracle.
• Involved in Data loading for the three GL interfaces developed.
• Developed Flexible PL/SQL Scripts/Packages for Data Objects Creation such as Tables and Procedures required for the Interfaces.

Environment: Sun Solaris 9, Oracle Applications 11i/11, GL, PL/SQL, SQL*Plus, TOAD, UNIX, Shell scripts.

Confidential, Tulsa, OK.

Oracle Applications Technical Consultant

Responsibilities:

• Designed Functional & Technical Documents for the customization of reports and Legacy system procedures (PRO C Programming)
• Developed and customized the PRO C code of Legacy System (PointMan & MISLS) in order to import AR Invoices and other Costing Information.
• Developed and customized various reports in AR, AP. (Print Selected Invoices Report, AR statements Report, Post Quick Cash Execution Report, Miscellaneous receipts Register, Report to compare the customers in legacy system and oracle, Report to retrieve the Receipt activity in pre conversion data)
• Designed and Developed code for AR Invoices Interface and Vendor Conversion (11.5.10).
• Designed and Developed Code for FA Tax Upload Interface to update the estimated lives of the Assets.
• Designed the Control file for Lockbox Interface.
• Designed, documented and worked on various Bank file formats (ACH Direct Debit (Nacha), AP EFT (Nacha), Positive Pay, Bank Statement Loader etc.)
• Developed different Notifications for AR & AP (for Direct Debit)
• Involved in Data loading for all the interfaces and Conversions.
• Maintained the Conversions (AP Invoices, AR Receipts) and Interfaces (AR Invoices) developed by the Offshore Team
• Developed Flexible PL/SQL Scripts/Packages for Data Objects Creation such as Tables and Procedures required for the reports and Conversions.
• Tuning of customized application including reports and back end programs by using different application tuning techniques (TkProf etc.).

Environment: HP-UX 11, Oracle Applications 11i/11, GL, AR, AP, AOL, OM/OE, BOM. Forms 6i and Reports 6i/9i, PL/SQL, SQL*Plus, TOAD, UNIX, Shell scripts.

Confidential, Mahwah, NJ.

Oracle Applications Technical Consultant

Responsibilities:

• Designed Functional documents (MD50) for Customization of Reports in Accounts Receivable, Fixed Assets, Demand Planner, Cost Management, BOM and General Ledger based on client requirements.
• Interacted with the Business users for constant updates, required upgrades and discussing the possibilities of extent of customization.
• Designed and developed Technical Documents for the reports in AR, FA, DP, and Cost Management. Involved in development of logic for the reports queries.
• Constant interaction with the offshore development team with regard to the development of reports, requirement changes and discussing the feasibilities.
• Development of Demand Sources Report in Advanced Supply Chain planner using DB Link.
• Customized Margin Analysis Report to include details of statutory and Management costs of items sold to all the customers (Internal and External).
• Merged and developed the Inventory at Statutory Cost and Inventory at Management cost reports into Total Inventory Statutory and Management Cost Report.
• Merged and Developed the Fixed asset Hyperion Detail Report by merging the Standard Cost Detail, Reserve Detail Reports and also the details required for comparison of the custom report to legacy system report.
• Involved in constant interaction with the DBA team for DB Link creation, Synonym creation and the migration of objects from one instance to another.
• Involved in development of Overpayment and Short Payment Reports for the receipts generated by auto Lockbox.
• Developed Flexible PL/SQL Scripts/Packages for Data Objects Creation such as Tables to store data generated by two different reports for data retrieval of FA Cost and Reserve Detail Report.
• Tuned custom applications including reports and PL/SQL procedures and packages by using different application tuning techniques.

Environment: Linux, Oracle Applications 11i/11, GL, AR, AP, AOL, OM/OE, BOM. Forms 6i and Reports 6i/9i, PL/SQL, SQL*Plus, TOAD, UNIX, Shell scripts.