SUMMARY

• Around 8.4 years of professional IT experience as Oracle Application Technical Developerin roll - outs, implementation, upgrade and customization ofOracle e-Business Suite Applications(R12, 11i). This includes system study, design, development, post implementation maintenance and support of Oracle EBS.
• Experienced in areas like Product Development, Implementation, upgrade, Migration, Customization and Support projects.
• Technically proficient inRICE components (Reports, Interfaces, Conversions, Extensions).
• Proficient in development ofinterfacesandconversionprograms to integrate Oracle Applications modules to import data from various sources into Oracle Applications usingPL/SQL, SQL*Loader.
• Expertise in 1EDI, EDI HQ, Appworx, FNDLOAD commands & APIs.
• Strong knowledge in SCM modules of Oracle application like Order Management (OM), Purchasing (PO), Inventory (INV).
• Strong knowledge of versioning tools like Share point, PVCS, Tortoise SVN, WinCVS etc.
• Hands-on experience in Data Conversion, Data Migration, Report Generation and Developing Interfaces within several modules in Oracle Applications.
• Strong Knowledge of Application Implementation Methodology (AIM), Application object Library (AOL) implementation standards and software Development Life Cycle (SDLC).
• Expertise on designing and implementingOracle Alerts, Concurrent programsandLookups.
• Proficient in Customizing Oracle reports and developing new reports by using Oracle Report 6i/10g andXML Publisher(BI Publisher).
• Strong inPerformance Tuning, UNIX shell scripting.
• Strong application/ enhancement testing skills, Analytical skills, Solution providing skills and result oriented.
• Expertise in developing Technical design documents (MD070), Technical Test documents (TE020), Conversion (CV050) and Migration documents (MD0120).
• Expertise in Troubleshoot issues, including creation/follow-up of Oracle service requests (SRs).
• Expertise in Roll-Out Projects, post production support and knowledge transition activities.
• Specialized in developing stored procedures, functions, packages and database triggers using Oracle SQL and PL/SQL to improve query performance.
• Skilled in understanding business needs, its strategic direction and identifying initiatives that allows a business to meet those strategic goals.
• Adept at all stages of project lifecycle, from business requirements and technical definitions to development, testing, user acceptance testing (UAT), production support, and completion.
• Superior communication, organizational and interpersonal skills.

SUMMARY

Software & Tools: SQL* Plus, Oracle Forms 6i, Oracle Reports 6i, XML Publisher, BPEL, QTP, 1EDI, EDI HQ, Appworx, PVCS, Winscp, Tortoise SVN, Putty,WinCVS.

ERP: Oracle Application 11i, R12

Modules: AOL, OM, PO, INV

Database: Oracle10g/9i

Languages: SQL, PL/SQL, Shell Scripting

Operating System: Windows 2000/XP/7/8, Windows NT, UNIX.

Database Tool: TOAD, SQL Plus, SQL Developer

PROFESSIONAL EXPERIENCE

Confidential

Technical Lead

Responsibilities:

• Worked on Customization, Enhancements, Interfaces, PLSQL, Forms Personalization and Reports.
• Provide technical solutions in the areas of Oracle Applications and custom developments.
• Participate in status calls with client and the internal team on regular basis.
• Involved in fixing technical issues on the components related to the project.
• Worked on creation of custom procedures, functions, packages, ad-hoc queries per the business requirements.
• Worked on customizing the Delivery note report, AR invoice monthly report.
• Involved in UAT testing of code components for smooth transition to Production environment.
• Wrote Technical documents (MD70), Test case documents (TE20)
• Involved in Post production support activities.
• Part of Self learning curve - dived into Oracle Fusion concepts of File based loader, HCM extracts, HCM Connects on technical front for data integration between two systems.

Environment: Oracle PL/SQL, Oracle applications R12, XML Publisher, Oracle Forms, Reports, Order Management, Purchasing, Advance Pricing, Oracle 10g, Winscp, Putty, SQL Developer.

Confidential

ERP Sr. Engineer

Responsibilities:

• Worked on Customization, Enhancements, Interfaces, PLSQL and Reports.
• Defined & developed Custom programs for Automation of Shipment Notice (DESADV), Sub-Inventory Transfer (PRODEX) messages - Inbound interfaces using Oracle standard APIs.
• Analyse and defined maps on EDI HQ translator tool to handle the EDIFACT message format.
• Handled validations as per the custom business requirements
• Involved in thorough testing of the EDIFACT messages.
• Involved in post-production support, was the single point of contact to the business for above EDIFACT messages.
• Worked on Reports customization (Purchase Order Report) for multiple orgs using oracle reports & XML Publisher tools.
• Worked on On-hand Quantity conversion for multiple orgs.

Environment: Oracle PL/SQL, Oracle applications 11i, XML Publisher, Reports, Order Management, Purchasing, Oracle 10g - 9/8i, Winscp, Putty, Toad, EDI HQ, Appworx, AS2 server, PVCS, SharePoint, JIRA.

Confidential

Technical Consultant

Responsibilities:

• Worked on development/Customizing the Customer facing documents (PO Document, Pick Slip Report, Packing Slip report) for multiple regions.
• Worked on On-hand quantity, Supplier data conversion
• Was involved in analysing EDI process from the scratch - from the patch level & was able to successfully complete the end to end functionality by implementing the 855,856 messages for Hypercom Project using 1EDI as the translator.
• Analysed and worked on Barcode printing on packing slip reports.
• Worked on inbound Interface, EFT payment batch programs.
• Creation of Control file, Soft links, Staging Tables, Validation routines, usage of relevant APIs.
• Creation of procedures, functions, packages to achieve business functionality.
• Define Oracle Alerts, Concurrent programs, Value Sets, Request groups, database triggers.
• Involved in data migration activities for User acceptance testing (UAT) purpose using FNDLOAD scripts.
• Schedule concurrent programs using APPWORX as the tool.
• Documentation per AIM methodology and backing up of code components using version control tools (PVCS).
• Involved in in fixing technical issues as part of post-production support activities.
• Mentored junior folks in the team as and when required.
• Participate in status calls with client and the internal team on regular basis.

Environment: Oracle PL/SQL, Oracle applications 11i, XML Publisher, Reports, Order Management, Purchasing, Inventory, Oracle 10g - 9/8i, Winscp, Putty, Toad, 1EDI, Appworx, AS2 server, PVCS.

Confidential

Associate Consultant

Responsibilities:

• Worked as Support Team Lead in areas of Order Management (OM), Service Contracts & Install base.
• Involved in fixing the licensing portal technical/functional issues in terms of the customers portal.
• Maintenance activity of the customers licensing portal by using SQL server
• Ad-hoc development based on the business requirements.
• Participate in status calls with client and the internal team on regular basis.
• Worked on the helpzilla ticketing system.
• Imparted training to team members to help them support the custom portal in an efficient way.

Environment: Oracle PL/SQL, Oracle applications 11i, XML Publisher, Order Management, Service Contracts, Install Base, Inventory, Confidential Licensing Portal, Oracle 10g - 9/8i, Winscp, Putty, Toad, SQL server, WinCVS, Helpzilla, JIRA.

Confidential

Technical and Functional Support Analyst

Responsibilities:

• Involved in fixing the EBS system issues in order management track.
• Worked on 10G CU2 UAT2 Upgrade Testing.
• Worked on QTP, Empirix Tool.

Environment: Oracle PL/SQL, Oracle applications 11i, Order Management, Purchasing, Inventory, Oracle 10g - 9/8i, Winscp, Putty, Toad, WinCVS.

Confidential

Oracle Apps Technical Developer

Responsibilities:

• Involved in writing technical design documents, test documents, installation documents, prepare code packs
• Worked on BPEL,PLSQL components
• Worked on customization of Sales Order Acknowledgement report.
• Worked on Sales, Freight rate, UOM Conversion data integrations (Outbound Interfaces) which passed respective information to the legacy system in a near-real time manner. To achieve this functionality a combination of Business Events and BPEL Integration was used.
• Worked on custom extensions on Sales Order form as per the business requirements.

Environment: Oracle PL/SQL, Oracle applications 11i, Order Management, Purchasing, Inventory, Business Events, Oracle 10g - 9/8i, Winscp, Putty, Toad, WinCVS, JIRA, BPEL.