SUMMARY:

• 19+ years of Information Technology experience in Order to Cash (OTC), Supply Chain Management, Financials and Customer Relationship Management implementations in a wide variety of environments.
• Involved in designing custom solutions, working with business to implement those solutions, scheduling, documentation, and production support.
• Experienced with complete software development cycle including analysis, designing, development, implementation and 24/7 production support.
• Proficient in C, VC++, Windows SDK, Developer 2000, Designer and have good Knowledge of UNIX Shell Scripting, HTML, OAF, XML, Java and Javascript.
• Strong individual contributor and a good team lead and player with proven abilities to interact, Train, and communicate with Users, Peers and Clients.

TECHNICAL SKILLS:

Oracle Apps: R12, R11i (11.0.3 - 11.5.10.2 ), R10.7, OM (Order Management/Shipping), Inventory,), Advanced Pricing, Workflow, ASCP, TCA, iSupplier, AR (Accounts Receivable), Adavanced Collections,iReceivables, Order Information Portal, AP (Accounts Payable), GL, Costing, Purchasing, Oracle WMS, MSCA, WIP, BOM, (Depot Repair, Scripting, Installbase, Alerts, AOL (Application Object Library), Concurrent Manager, Flexfields, Upgrades, Customizations and Extensions, Interfaces and Data Conversion. Bigmachines, Oracle CRM on-Demand.

Oracle: 7.x - 11g, 12c, SQL, PL/SQL, SQL Loader, WEB-ADI

GUIS: Developer 2000 Forms 4.5/5.0/6i,10g, Reports 6i, 10g

Tools: Designer 2000, TOAD, SQL Navigator, wincvs, PVCS, RCS, VSS, SCCS, Datastage, AutoSys (Platinum Job Scheduler), Loftware

OS: UNIX (Solaris, HP-UX, Compaq Tru64), Windows 95/98/NT/XP, MS-Dos

Languages: C/C++, VC++, shell scripts Windows SDK, JAVA, HTML, JAVA Script, Post Script

PROFESSIONAL EXPERIENCE:

Confidential, New York, NY

Senior EBS Developer

Responsibilities:

• Worked in the IT Department in enhancing their business flows and supporting existing systems.
• Involved in Designing and development of following:
• Designed and developed a new Returns process with predefined Surcharge applied during WEBADI upload and Manual entry.
• Designed and developed a Custom View Pricelist availability form adding new fields deriving values from ASCP Plan.
• Designed and developed various Custom Reports using XML Publisher and pl/sql.
• Actively working with Oracle support in resolving the Service Requests.
• Designed and developed various enhancements in Inventory, Puchasing, Quality, isupplier modules.

Environment: Oracle Applications R12, OM, INV, BOM, ASCP, AR, Oracle 12c SQL, PL/SQL, Forms (6i), Reports 6i, XML Publisher, OA Framework, workflow, UNIX (Sun Solaris)/Linux, TOAD, JIRA.

Confidential, Secaucus, NJ

Senior Application Architect

Responsibilities:

• Work with business and stake holders to understand the requirements and write functional design documents.
• Experience in coordinating with multiple teams, Vendors in successfully streamlining the business flows
• Also involved in assigning the tasks and mentoring the team.
• Involved in testing and reviewing the results with Business Users, obtaining Approvals and getting promoted to production and verification.
• Worked in Agile environment as a Team member and SME for OTC Flow activities.
• Involved in testing Tokens for the Credit Card processing with cybersource.

Confidential, Secaucus, NJ

Senior Application Architect - Consultant

Responsibilities:

• Identify the mismatch in the Custom and Oracle Aging Reports and resolved them.
• Tune the Custom Aging reports that were running forever and bring down to acceptable levels.
• Redesign and setup the BudgetCode/Divisions relations.

Environment: Oracle Applications R12, R11.5.9; OM, INV, BOM, AR, GL, AOL, OAF, Big Machines, CRM OnDemand(cloud), Service Contracts, Oracle 9i, 11g, SQL, PL/SQL, Forms (6i), Reports 6i, XML Publisher, OA Framework, workflow, UNIX (Sun Solaris)/Linux, TOAD, JIRA.

Confidential, Webster, NY

Lead Architect

Responsibilities:

• Importing items (INCOIN), Item categories (API) and updates the item attributes/categories to Oracle Inventory 11i.
• Involved in various interfaces including onhand balances.
• Created custom workflow processes for RMA’s, Sales orders (OEOL) and Custom zoom forms
• Involved in creating custom lookup codes, value sets, concurrent managers, scheduling and monitoring the jobs.
• Performed physical adjustments and resolve various pending transactions for successfully closing the periods.
• Customize the Item zoom form in Inventory to in corporate additional attributes information.
• Involved in unit, integration and volume testing and effort estimations.
• Raising TAR (Service Requests) with Oracle and performed around the clock support to resolve the C-1 issues.
• Knowledge of various functional setups in Inventory and Order Management.
• Developed custom forms 9i, reports 9i and interfaces.
• Adhere to the procedures and functions of Sarbanes Oxley standards.
• Involved in testing the patches and progressing to production.
• Involved in resolving the performance issues.
• Production support including 24/7 on-call services.

Environment: Oracle Applications R11.5.9; OM, INV, PO, Costing, Workflow, WIP, BOM, AR, AOL, Oracle 9i, SQL, PL/SQL, Forms (6i), Reports 6i, UNIX (Sun Solaris), TOAD

Confidential, Danbury, CT

ERP Architect

Responsibilities:

• Involved in writing Use Cases and Functional specifications for linearizing the Master Schedule Demand.
• Involved in designing, developing and testing the Custom Forms
• Performed customizations related to Sales Order Form.
• Data extraction for Forecasting, ASCP requirements.
• Involved in designing and developing the Forecast and Demand loads to Oracle.

Environment: Oracle Applications R11.5.9; ASCP, OM, INV, PO, WIP, BOM, Oracle 9i, SQL, PL/SQL, Forms (6i), Reports 6i, UNIX (Sun Solaris), TOAD

Confidential, Webster, NY

Lead Architect

Responsibilities:

• Production support including 24/7 on-call services.
• Importing items (INCOIN), Item categories (API) and updates the item attributes/categories to Oracle Inventory 11i.
• Involved in various interfaces including onhand balances.
• Created custom workflow processes for RMA’s, Sales orders (OEOL) and Custom zoom forms
• Involved in creating custom lookup codes, value sets, concurrent managers, scheduling and monitoring the jobs.
• Performed physical adjustments and resolve various pending transactions for successfully closing the periods.
• Customize the Item zoom form in Inventory to in corporate additional attributes information.
• Involved in unit, integration and volume testing and effort estimations.
• Raising TAR (Service Requests) with Oracle and performed around the clock support to resolve the C-1 issues.
• Knowledge of various functional setups in Inventory and Order Management.
• Developed custom forms 9i, reports 9i and interfaces.
• Adhere to the procedures and functions of Sarbanes Oxley standards.
• Involved in testing the patches and progressing to production.
• Involved in resolving the performance issues.

Environment: Oracle Applications R11.5.9; OM, INV, PO, Costing, Workflow, WIP, BOM, AR, AOL, Oracle 9i, SQL, PL/SQL, Forms (6i), Reports 6i, UNIX (Sun Solaris), TOAD

Confidential, Denver, CO

Sr Programmer Analyst

Responsibilities:

• Customized the Scripting launching form
• Developed Depot Repair Outbound Interfaces for Returns
• Customize the Service Request, Repair orders interfaces from external systems.
• Fix the post-production issues involved in Scripting Panels and Install base.
• Involved in unit testing and resolving performance issues.

Environment: Oracle Applications R11.5.9; Depot Repair, Oracle Scripting, Install Base, Services, OM, INV, WIP, AOL, Oracle 9i, SQL, PL/SQL, Forms (6i), Reports 6i, SQL*Loader, UNIX (Sun Solaris), TOAD, Shell Scripts, PVCS

Confidential, Webster, NY

Lead Architect

Responsibilities:

• Involved in analysis and design of interfaces to and from legacy systems and external entities for Inventory, Purchasing, Order Management, and Oracle Pricing in Oracle 11i.
• Importing items (INCOIN), Item categories (API) and update the item attributes from various legacy systems to Oracle Inventory 11i, includes Item conversion and daily item import feeds.
• Customized the working functionality of Oracle WMS for processing License Plate Numbers
• Customized the Pick Confirm (pick drop) process of Mobile Applications.
• Developed custom codes to streamline the Oracle procure to order functionality.
• Developed UNIX shell scripts for execution of jobs, execution of SQL programs and concurrent job requests/Sets.
• Developed new customized forms and reports in Forms 6i and Reports 6i for custom functions.
• Developed database objects (tables, stored procedures, views, and triggers) to provide custom functionality within the Oracle Applications.
• Involved in Documentation/Development Process support.
• Developed various barcode reports for barcode printers (intermec) and Confidential Printers
• Developed labels using Loftware with Oracle WMS integration.
• Knowledge and experience of working in Mobile supply chain module.
• Interacting with Oracle support (Metalink) in logging TARs and resolving the issues.
• Implementation experience in Multi-org (operating units) system.
• Performed unit testing, integration testing, volume testing and production support.
• Developed oracle forms for customizing the Mobile supply chain PO/ASN LPN Receiving.
• Adhere to all the procedures and functions that meet Sarbanes Oxley standards.
• Creating shipping networks and inter-org accounts.
• Customization of Inter-Org transfers of the LPNs and creating deliveries in the destination warehouse.

Environment: Oracle Applications R11.5.9; OM/Shipping, INV, PO, CST, TCA, Advanced Pricing, AOL, WMS, MSCA, AP, AR, iSupplier Oracle 9i, SQL, PL/SQL, SQL*Loader, Forms (6i), Reports 6i UNIX (Sun Solaris),TOAD, Shell Scripts, RCS, Loftware

Confidential, Manhattan, NY

Senior Software Engineer - Oracle Applications Developer

Responsibilities:

• Implemented custom interface that receives Return Orders (RMA) and creates Return Receipts (after many validations against various data including original order, previous adjustments) and automatically receives into inventory (INV), and pushes the appropriate credit memo to Accounts Receivable (AR).
• Developed Item master outbound transaction, where changes in the Items master information is sent to warehouse to update their system and to receive acknowledgments.
• Developed new customized forms and reports in Forms 6i and Reports 6i.
• Implemented Purchase Order Outbound and Inbound (Receipts) interfaces to warehouse.
• Customized the Purchase Order screen for flexfields populations and modified print PO reports.
• Created various Oracle Alerts to inform users of periodic events.
• Worked with Oracle support on the issues by opening TAR’s.
• Developed database objects (packages, procedures, triggers, views) to provide custom functionality within the Oracle Applications.
• Involved in execution of the Autosys jobs through Platinum job scheduler.
• Prepared various technical documents, created data flow charts and unit test plans.
• Performed unit and system testing and involved in volume testing.
• Used VSS in maintaining different versions of the programs and documents.
• Developed various UNIX shell scripts for execution of jobs, ftp files, archiving, and execution of SQL programs and for concurrent job requests.
• Extensively used SQL Loader scripts for uploading the data into Custom Interface tables.

Environment: Oracle Applications R10.7, R11i; OM, AR, INV, AP, PO, AOL, Oracle 8i: SQL, PL/SQL, SQL*Loader, Developer/2000, Forms (6i), Reports 6i UNIX (HP-UX, Compaq), SQL Navigator, Shell Scripts, VSS and Autosys (Platinum job scheduler).

Confidential

Programmer Analyst

Responsibilities:

• Coded various triggers and stored procedures for heavy batch processing in PL/SQL.
• Performed tuning of stored procedures by removing the bottlenecks of the procedures/packages to improve performance of the batches.
• Migrated the data from flat files to the existing oracle database using Ardent Datastage (Dataware housing tool).
• Created and Maintained ER diagrams.
• Wrote Unit test plans and test cases of the Territory Allocation Module.
• Maintained and controlled the versions of the source code using Visual SourceSafe (VSS)
• Prepared the user manuals for the application that helps the end-users in successfully operating the application. Prepared scripts for installing the application into the client’s system.

Environment: ORACLE 8.0, SQL plus, PL/SQL, TOAD, DATASTAGE, VSS.