SUMMARY

• 12 years of experience in IT consulting for the service industry. Widely experienced in Software Analysis, Design, Development, Implementation, and Testing of Object - Oriented Applications and Web-based ERP Applications using oracle sql/plsql, forms, workflow and webservices
• Worked extensively in the area Oracle Applications 11i, R12, Cloud Fusion and involved in analysis, design, development and implementation of business applications and user training
• Designed and developed OIC utilities for Fusion ERP integration
• Experience in oracle fusion Cloud reporting, Oracle Fusion Cloud interfaces
• Worked on AP, AR, FA, Projects Costing and Billing, GL, PO and System Administration.
• Experience in various oracle application modules GL,OM, WMS,AR, INV, PO, GL, AP, BOM, AOL and SYSADMIN.
• Involved in release management of whole development and customization cycle, version control of all the codes using ACME
• Proficient in writing stored procedures, packages using PL/SQL, SQL.
• SQL and PLSQL experience 12 years
• UNIX shell scripting 5 years
• JAVA Script 4 years
• Having good knowledge on version control tool like WINSCP, Putty and Toad
• Excellent experience in developing and customizing the Interfaces.
• Experience in creation of executable, concurrent programs, parameters and value set in Oracle application using AOL.
• Analysis of the specifications provided by the clients.
• Developed PL/SQL packages, Procedures, and functions.
• Registering Custom Applications, Concurrent Programs, Request Set Tables
• Defining Request Groups & Menu.
• Development of interfaces and conversion like Items Import interface and Supplier Conversion.
• Involved in Development of AOL objects.
• Developed Control files to load data into tables.
• Experience on Data Migration & Data Conversions.
• Knowledge of using Oracle supplied APIs.
• Quote to Cash experience 12years
• O2C Cycle experience 10 years
• P2P Cycle experience 3 years
• COGS & IB (Install base Management) Module experience 2 years
• Oracle R12 Version (12.1.3) experience 10 years
• Oracle 11i Version experience (11.5.10.2) 4 years
• Involved in GST Implementation project.
• Involved in Oracle Cloud Fusion Implementation Project
• Involved in diagnosing and resolving technical, functional related problems.
• Strong expertise in development of web-based applications using Python, REST Webservices and Oracle Cloud Fusion
• Strong experience in data engineering, Database designs, agile methodologies, coding, testing of enterprise applications and IDE's such as Jupiter Notebook, JDeveloper, SQL developer
• In the role of a Business Analyst, assisted clients and customers in defining business needs, evaluation alternative solutions, made recommendations and helped in implementing approved suggestions

TECHNICAL SKILLS

Programming Languages: SQL, PL/SQL, JAVA

Application/Web Servers: Apache Tomcat

IDEs: Jdeveloper, Eclipse

Web technologies: JSP, JavaScript, jQuery, XML, CSS, JSON

Web Services: SOAP, RESTful

Methodologies: Agile, Waterfall

Modeling Tools: Visual Studio, Rational Rose

Database Servers: Oracle 8i/9i/10g/12c, MySQL

Version Control: CVS, SVN

Platforms: Windows 2000/98/95/ Windows 7 Professional, UNIX

Oracle tools: Forms, Workflow

Report Tools: BI Publisher

PROFESSIONAL EXPERIENCE

Confidential, Atlanta

Senior software Engineer

Responsibilities:

• Interacting and Understanding the client requirements concerning the customization team.
• Being a part of Interface team, worked closely with the business users, technical & functional team.
• Version control using ACME.
• Analysis of the specifications provided by the business user.
• To amend the existing code as per the requirements by the business.
• Tuning the NCR customized oracle objects for improve the performance of the database.
• Worked on integration oracle Finance modules using OIC
• Worked on OIC utilities for Fusion ERP integration
• Developed OIC utilities for migration to UAT and Production
• Provided the Automation to add the freight charge (modifier) which comes from third party after calculation using the standard oracle APIs.
• Provided the new custom Hold definitions, Quick Codes and functionality in Oracle Order Management for achievement of the business requirement.
• Provided ability to perform oracle standard processes receiving, reservation, picks release, pick confirm and shipment of sales order(s) automatically.
• Provided the Automation of sales order lines through the invoice interface activity
• Provided the functionality to Booked/Cancel the sales order lines automatically
• Provided Order management attachment (Modifiers ) functionality
• Provided Defaulting Rules in Oracle Order Management
• Customized project (seiban) number
• Provided Drop Ship Automation for sales order in Oracle Order Management.
• Provided the new custom profile options for the application
• Performed validation for control the Order Enter, Scheduling Order line(s) by creating new processing constraints in Oracle Order Management, configuration creation on base model, Order Copy Method Functionality using Oracle HOOKS, RMA Functionality
• Provided the user friendly functionality to show the sales order line(s) status using CUSTOM.pll
• Provided the facility to capture the information by creating new descriptive flex fields (DFF’s) for the business.
• Developed workflow for sending the different email notification to the CIS on the sales order in the different phases of sales order process.
• Provided Apply/Release Hold Automation in Order Management through workflow AOL Sys Admin Tasks in NCR:
• Created concurrent program executable, definition
• Created different value sets as per the requirement
• Created request groups.
• Created different responsibilities.
• Created users in oracle applications with particular responsibility.
• Added reports definitions, concurrent programs to particular request group.
• Gradually involved in Technical Assistance Request (TAR) with Oracle support team for NCR Customizations.
• Involved in Internal training sessions within organization on ERP - Oracle application 11i, Order Management, Configurator, performance tuning, Advance PL/SQL and Organization business flow
• Worked on customized objects identification for retro fitment.
• Worked on OIC integration oracle cloud AR to ERP Onprem R12 application
• Implementation of OM and AR cloud functionality
• Implementation of quote to cash cloud functionality
• Modified standard objects for business functionality.
• Worked on different modules on OIC