SUMMARY:

• Over 20 years of experience in Oracle custom application development, external API integration, and supports.
• Over 10+ years with EBS Financials application and development support.
• Experience Application implementation, support and user for Internal/External customer.
• Experience of automating batch process into event process using oracle rest API (ORDS).
• Experience of web services, creating Rest service using ORDS/Apex 5.01 and integrated with eSignLiv (similar like DocuSign) on existing Oracle custom application.
• Excellent problem solving, analytical and communication skills with ability to work in a team /Global team or individually.
• Proven record, Custom Application Solutionist, Integrator, Result Oriented and fulfill business and IT needs to growing business needs that fits with existing model.
• Experience Developing RICE components related to inventory product image integration
• Experience in Oracle Software development, testing, business analysis, implementation, technical document, design document, and production support, using various Oracle and non - Oracle tools.
• Experience in SAR/TAR management with Oracle Support and work with Application stack holders and DBA.
• Experience in Agile/SCRUM enterprise-scale software development.
• Experience designing Oracle database and data modeling using, writing Package, Stored Procedures, Functions, Types, Views, Sequences and Triggers.
• Experience in RDBMS such as Oracle 12c, 11g, 10g, Developer Suite 12c/11g/10 g, SQL*Loader, Export, Import, PL/SQL, SQL*Plus, Performance Tuning, ETL tools DataJunction v6.5, WebUtil, Oracle WebLogic server 12c/11g, designing and creating custom Oracle Forms & Reports from the ground up (I would make a separate bullet (starting with WebUtil) for Oracle Forms & Reports and the Oracle WebLogic server, with WebUtil)
• Excellent problem solving, analytical and communication skills with ability to work in a team or individually.
• Experience in developing SOA/BPEL integration using JDeveloper and deployed on WebLogic server.
• Experience in developing an event-base plug-in to replace batch file processing, utilizing web-service consuming and porting
• Experience in Oracle Financial 11.5.9/Release 12.1.3 Technical and (AR/AP/INV) Functional.
• Expertise in Interfaces, Customisations, Conversions and Extensions in Oracle Applications R12 (AP, AR, INV).
• Experience in requirement gathering from user/business and setting up QA environment and UAT (User Acceptance Test) coordination with QA and Business stack holders.
• Experience with vendor’s negotiation and its deliverables of application implementation and support.
• Knowledge and Experience creating Virtual Sand Box creating Server Environment for testing POC, and for project pre-approval and create run-book (installation guide) or creating development sandbox.
• Knowledge of data warehousing and business intelligence concepts, design principles, and software architecture.
• Knowledge of Java, and Java servlet, Apache and Tomcat.
• Knowledge of Oracle APEX and develop custom application to integrate with ERP application.
• Integration and implementation of third-party API and software from global vendors and overview SDLC.

COMPUTER SKILLS:

RDBMS: Oracle 12c/11g, MS Access, Clipper.

GUI: WebLogic 12c/11g, Oracle Forms and Reports 12c/11g, JDeveloper 11,1,1,7, SOA 11g, Eclipse IDE, Toad, Data Junction 6.5, PVCS, VSS, VMware, Virtual Box, Hyper-V.

Languages: PL/SQL, SQL*PLUS, SQL*Loader script, Oracle Forms & Reports-10g, Shell Scripting, XSLT 2.0, Java.

O/S: Oracle Linux 5.6, MSDOS v6.2, MS Windows 10/7.

Middleware: WebLogic 12c/0.3.6, Glassfish, Tomcat

WORK HISTORY:

Confidential

Technology Consultant

Responsibilities:

• Creating Database objects, Packages, store procedure, functions, and views using PL/SQL.
• Production, email, and phone support to users and other peers query request.
• Working on Enhancement and extending TCSS application with restful web-service to integrate with COTS application/APIs.
• Worked on to implement, ORDS (Oracle Rest data Service) web service in TCSS system utilizing UTL HTTP.
• Conversion of all batch processes into web-services using ORDS restful service.
• Developing and integrating callback events for processing sign documents.
• Rewriting of TCSS (Transportation Contract Support System) into APEX 5.1, interfacing to EBS 12.1.3
• Currently working on integrating with eSignLive document integration and creating custom solution for document server with in TCSS application.
• Integrate with third party COTS application with existing TCSS application and create customized Document server.
• Mentoring and guiding team members and with oracle forms upgrade process and with web-service development.
• Agile development environment participates daily scrum.

Environment: Sues Linux, Windows 10, Oracle 12c/11g, SQLDeveloper v18, TOAD v8, Oracle Developer suite 12c/11g, WebLogic 12c/11g, APEX 5. MS Office, Eclipse and JDBC Putty, WinSCP.

Confidential

Principle Software Development Analyst

Responsibilities:

• Creating Database objects, Packages, store procedure, functions, and views using PL/SQL
• Production, email, and phone support to users and other peers query request.
• Working on Enhancement and extending TCSS application with restful web-service to integrate with COTS application/APIs.
• Worked on to implement, ORDS (Oracle Rest data Service) web service in TCSS system utilizing UTL HTTP.
• Conversion of all batch processes into web-services using ORDS restful service.
• Developing and integrating callback events for processing sign documents.
• Rewriting of TCSS (Transportation Contract Support System) into APEX 5.1, interfacing to EBS 12.1.3
• Currently working on integrating with eSignLive document integration and creating custom solution for document server with in TCSS application.
• Integrate with third party COTS application with existing TCSS application and create customized Document server.
• Mentoring and guiding team members and with oracle forms upgrade process and with web-service development.
• Participate daily scrum.

Environment: Suse Linux, Windows 10, Oracle 12c/11g, SQLDeveloper v18, TOAD v8, Oracle Developer suite 12c/11g, WebLogic 12c/11g, APEX 5. MS Office, Eclipse and JDBC Putty, WinSCP.

Confidential, FL

Oracle Developer

Responsibilities:

• Gathered and analyzed requirement for a new project and provided timely statuses.
• Designed, and developed complex views, store procedure, functions, and performance tuning to SQL queries and PLSQL process tuning.
• Designed, Developed & Supported a concurrent Jobs in EBS r12 on for various EBS Modules AR/AP/OM/PIM.
• Experience managing consultants; Daily project status meeting and reviewing impediments, participated in Code review and extended help on any impediments, monitor progresses and projects, and once complete, integrated/ported custom solution into existing application.
• Customized Build-To-Shelves and Build-To-Order from MES (custom application) to EBS INV modules interfaced using BPEL SOAP service and integrated with concurrent program via utl http.
• Implemented custom solution for Order to Cash, Build to Order MES finished inventory, to attach inventory to Orders.
• Invoice import from webstore Orders and returning back Invoice number and final order confirmation using SOAP service.
• Integrated Build to Order method, with (MES system), inventories from MES to INV module, and register inventories to invoice, integrate with receivable, and generated custom SOAP service to generate fulfillment event, to submit to DemandWare, to trigger order completion event to generate fulfillment email to customer.
• Implemented Triggers, Views, Synonyms, Hints, indexing. Extensive work on the performance tuning of Oracle ETL processes, related store procedure, and functions.
• Using JDeveloper 11.1.1.7 created a SOA Composite to integrate various inbound and outbound data integration (SQL Server, and Sybase, to EBS Oracle database).
• Developed PL/SQL procedures/packages to invoke BPEL processes and scheduled via concurrent job.
• Developed forms and reports to extend EBS functionality and interfaced to Oracle Applications.
• Create APEX application & reports using APEX 4.0 and generated data entry screen on custom tables to interface into EBS.
• Developed custom concurrent programs interfacing various internal and external applications using utl http consuming event base data feeding to concurrent jobs.
• ETL - Extracted data from different flat files, XML, MS Excel, MS Access and transformed the data based on user requirement using JDeveloper, Eclipse, and SQL*Loader
• Performed ETL using SOAP based web services via XSLT 2.0 for data mapping, transforming and conversing, transformed XML data into Oracle table
• Cross application integration using adapters, JMS File Adapter and DB Adapter, FTP/SFTP adapters.
• Participated in re-write/enhancement project for storefront website to deploy accomplished full product life cycle and worked with vendor providing product related feed and other webstore front data.
• Integrated and interfaced inbound data to oracle staging for Order Management, Receipts and Customers.
• Managed and track project progress and validated delivered solution from vendors and participated project time and object delivery negotiation.
• Supported day-to-day activity, support end-user queries, and respond to tickets.

Environment: Linux 5.8, Putty, WinSCP, Windows XP, Oracle 8i,9i/10g, PL/SQL Developer, TOAD v12.06, Oracle Developer suite 10g, JDeveloper 11.1.1.7, WebLogic 11g, APEX 4.02 MS Office, Eclipse, apache, TomCat, ODBC, JDBC, TFS, Oracle SQL Developer.

Confidential, CT

Oracle Application Developer

Responsibilities:

• Designed, Developed & Supported a home grown Entry and Contract system using oracle Forms and Reports using 10g Forms developer.
• Gathered and analyzed requirement for a new project and provided timely statuses.
• Managed outsourced team who designed and developed custom forms and reports, and integrated in current environment.
• Integrated and interfaced Service Contract and Order Entry system into Oracle Financial.
• Used Agile/SCRUM modular-scale software development methodology which reflected on each software module task and development time-line.
• ETL third party data to oracle applications pre staging tables for aircraft lease contracts on oracle contract modules.
• Developed custom application using Forms 10g interface to EBS R12, supporting Accounts Payable.
• Involved in Developing RICE (Reports, Interfaces, Conversions and Enhancements/Extensions).
• Created a Custom Form Interface for AR, AP and Service Contract Module in Oracle Financial.
• Managed and integrated third party solution into existing system, and provided custom solutions for ongoing business needs.
• Help legacy report conversion from Oracle report to PHP.
• Supported and Setup oracle forms application server 10g for WebUtil in development.

Environment: SunOS 5.9, Putty, WinSCP, Windows XP, Oracle 8i,9i/10g, PL/SQL Developer, TOAD v9.7, Oracle Developer suite 10g, MS Office, MS Excel, MS Access, ODBC, PVCS.

Confidential, NJ

Oracle Application Specialist

Responsibilities:

• Designed, Developed & Supported a homegrown legacy system converting it into oracle Forms and Reports using 10g Forms developer.
• Used WebUtil to provide excel report from Forms 10g.
• Gathered and analyzed requirement for a new project.
• Designed ETL process to integrate a Store Inventory Adjustments, Store Sales Transactions & Oracle retail into Oracle Financials inventory module.
• Supported day-to-day activity and support end-user queries.
• Created a Custom Interface for AP/AR Customers for an acquired company in multi-org Oracle Financial Systems.
• Helped to convert PATHMARK back-end system into current setup, and help retire old systems.
• Implemented Triggers, Views, Synonyms, Hints. Extensive work on the performance tuning of Oracle ETL process, which was flat file to oracle table via SQL*Loader.
• The entire interface program converted from SQL*Loader to external table.
• Converted 6i forms and reports to 6i into 10g, when migrating form oracle 11i to Release 12.
• Experience managing and integrating global vendor product integration, integration project management, monitor/Code review, development progresses, and integrated custom solution into existing application.
• Involved in Developing RICE components related to inventory product image integration
• Developed custom Forms and Reports Migration from 6i to 10g.

Environment: IBM AIX UNIX, Putty, WinSCP, Windows XP, Oracle 8i,9i/10g, PL/SQL Developer, TOAD v7.1, SQL Navigator, Oracle Developer suite 10g, MS Access, ODBC, MS Visio, PVCS.

Confidential, NY

Core Application Developer

Responsibilities:

• Data analysis and requirements gathering from for Order Entry System (ATLAS).
• Wrote PL/SQL Packages, Procedures, Functions, views, and triggers to manipulate and scrub data.
• Analyzed/Resolved tickets for users experiencing problems with application (OE/CSI - CRM Tool).
• Responsible for analysis, design, modification, testing and implementation of Order Entry System (transaction base system called ATLAS)
• Designed ETL process to load AR & AP data from various flat file into pre-staging database tables.
• Designed concurrent program to interface for AR & AP
• Automated all day-to-day activities using Oracle forms and Reports.
• Created a requirement document and sent to outsourcers; monitored/reviewed development process, and testing before presenting business users.

Environment: SUN UNIX, Windows XP, Java. XML, Oracle 8i,9i/10g, PL/SQL Developer, TOAD v7.1, SQL Navigator, Developer 2000 6i, MS Access, ODBC, MS Visio, VSS.

Confidential, Hempstead, NY

Database Programmer Analyst

Responsibilities:

• Responsible for analysis, design, modification, testing and implementation of Oracle applications across major modules, including Accounts Receivable, Accounts Payable, Cash Management, General Ledger.
• Monitor/Troubleshoot daily Journal (AR/AP/GL/CE) transfer to GL accounts and postings.
• Create responsibilities and assign to requested users.
• Automate all day-to-day activities in Oracle Forms and Reports.
• Created a custom ETL for bank statements using O/F Bank Statement Interface.

Environment: Windows XP, Oracle 8i, PL/SQL Developer, TOAD v7.1, SQL Navigator, Developer 2000 6i, DataJunction cosmos, FoxBASE+, MS Access, ODBC, MS Visio, PVCS.