SUMMARY

• 7+ years of IT experience in developing cost effective solutions as an Oracle Technical Consultant using Oracle Applications and experience as anOracle PL/SQLDeveloper in Analysis, Design and Implementation of Business Applications using the Oracle Relational Database Management System (RDBMS).
• Involved in all phases of theSDLC (Software Development Life Cycle)from analysis, design, development, testing, implementation and maintenance with timely delivery against aggressive deadlines.
• Experience withData flow diagrams, Data dictionary, Database normalization theory techniques, Entity relation modelinganddesign techniques.
• Expertise in Client - Server application development using Oracle11g/10g/9i/8i, PL/SQL, SQL *PLUS, TOAD.
• Extensive experience in Oracle Applications e-Business Suite Applications- Supply chain management Modules (OM, INV, SO, PO), Application Object Library (AOL).
• Expertise in extending and customizing Oracle EBS using SQL, PL/SQL, Oracle Forms & Reports, Workflow builder.
• Extensive Experience in CEMLI: Customizations, Extension, Modification, Localization and Integration of Oracle Applications using Oracle SQL/PLSQL, Oracle Application Framework (OAF),Oracle Forms/Reports Builder.
• End to End implementation including analyze business requirements and user requirements, design, document and CRP, Integration and UAT testing using AIM methodology.
• Extensively worked on AIM documents like MD050, MD070, CV040, BR100 and TE010.
• Expertise with migration tools and test management tools like Kintana and HP QC.
• Experience in defining processes relative to Order to Cash (O2C), Procure to Pay (P2P) cycles.
• Effectively made use ofTable Functions, Collections, Analytical functions, Materialized Views, Query Re-Write.
• Developed Complex database objects likeStored Procedures, Functions, Packages and Triggers using SQL and PL/SQL.
• Developedmaterialized viewsfor data replication in distributed environments.
• Experience with Dynamic SQL, Ref Cursor, RecordsandPL/SQL Tables.
• Proficient in mapping business requirements, use cases, scenarios, business analysis, and workflow analysis. Act as liaison between business units, technology and IT support teams.
• Proficient in conducting requirements GAP analysis, Solution Design, Test Methodologies, Implementation, Knowledge Transfer and Application Support.
• Has exposure in working with Onsite - Offshore models. Experience working under extreme stress and delivered desired performance levels within the designated timeline.
• Self-motivated, excellent team player with proven leadership skills & analytical skills.
• Excellent communication and interpersonal skills.

TECHNICAL SKILLS

Oracle Applications: Oracle Apps R12, 11i, Order Management (OM), Purchasing (PO), Inventory (INV), Sales Order (SO), Application Object Library (AOL) and Sys Admin

Database Tools: PL/SQL Developer, SQL*PLUS, TOAD

Oracle Tools: Reports 6i/10g, Forms 6i/10g, Developer 10g, Workflow, FTP, WinScp374 SSH Client.

Databases: Oracle 12c/11g/10g.

Languages: SQL, PL/SQL, XML, UNIX, HTML

Management tool: HP QC, PVCS, HP PPM

Migration Tool: Kintana

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

PROFESSIONAL EXPERIENCE

Confidential, Columbus, OH

Oracle apps technical consultant & PLSQL developer

Environment: Oracle Applications R12.1.3, PO, SO, OM, INV, AOL, Forms 10g, Reports 10g, Oracle 10g, SQL and PL/SQL, Toad, Windows XP, Windows 7, Kintana Migration Tool.

Responsibilities:

• Produced Technical design documents (MD70) based on Business requirement, Effort estimation, impact analysis, design and development of new system change request.
• Produced, Installation Instructions documents (MD120) which includes all the components developed as part of the requirement like value sets, lookups, concurrent programs, request sets.
• Created Multiple Documents like Mapping Documents, Migration Documents, BR100, MD070, TE020, Code review checklist for each component developed.
• Interacted with the client to get the requirements clarified and to perform requirement analysis, preparing technical design document, code development, code reviews, testing on multiple instances, and support during mock conversions, Integration testing issue resolution.
• Worked on an interface to import the data from legacy system to oracle.
• Designed and developed Inbound Interfaces as per the Functional Specifications in OM and wrote Technical Specifications for the same.
• Involved in setup and customization of Inventory (INV), Sales Order (SO) & Purchase order (PO).
• Data conversion from legacy system into Oracle Applications.
• Designed, developed, registered customized forms, tables and reports using AOL.
• Manage Concurrent Processing and Concurrent Manager.
• Created new reports as per business user’s requirement.
• Worked on the item freight interface to apply the freight terms while creating a sales order.
• Created different sales orders to test the item freight interface.
• Create Users and Responsibilities for Security and limit permission as per business needs.
• Worked on form personalization to limit permissions to normal user and grant all permissions to super user.
• Analyzed and developed business requirements as necessary using PL/SQL programming, Oracle Forms & Reports etc.
• Creation of database objects likeviews, materialized views, procedures and packagesusing oracle tools like Toad, PL/SQL DeveloperandSQL* plus.
• Created tables, sequences and packages for each interface developed.
• Review of technical design documentation and code walkthrough of developed components.
• Created value sets and prepared test cases and test scripts and executed test cases in various instances.
• Migration among different environment (Dev\Test\Prod) using ITG Migration (Kintana).
• Performing Code Reviews for customization of existing stored procedures and Packages as per the requirement.
• Worked on bug fixes and production support to the client.
• Attending client status calls and daily status reporting to client.

Confidential, Piscataway Township, NJ

Oracle Apps Technical Consultant & PLSQL developer

Environment: Oracle Applications R 12.1/11.5.10.2 , INV, PO, SO, AOL, Forms 10g, Reports 10g, Oracle10g, SQL and PL/SQL, Toad, Windows XP, Windows NT and Windows 7.

Responsibilities:

• Involved with study of existing system, preparing Functional (MD50) design documents as per business requirements using AIM Methodology.
• Involved in various activities like preparing technical documents, discussions with client regarding proposed solution, PL/SQL programs scripts, related reports and forms, unit level testing and user acceptance testing.
• Designed interfaces between legacy systems and Oracle Apps.
• Interacting with the business users on the new enhancements to finalize the design and flow of the component and accordingly prepares the technical design and the source code.
• Created temporary tables using PL SQL and developed SQL*Loader control files to load data from Legacy system into temporary tables.
• Involved in designing and developing various reusable packages and stored procedures which were utilized by various programs.
• Extracted the Closed Purchase Orders information from Purchase Orders using Outbound Interface and uploaded them to third party application.
• Developed, designed and personalized Customer Form and added new fields for forms to enter extra information as per business user requirements using AOL.
• Customized the Oracle Seeded Order Management Transaction Type workflow to add workflow functions for email Notifications when the order is booked using Workflow Builder.
• Worked on the Sales Order Interface program for importing the Sales Orders.
• Responsible for Code Development, Unit Testing and participated in Business Testing.
• Developed and executed test cases for Functional, Technical, Performance and Regression testing.
• Perform Code Reviews for customization of existing procedures and packages as per the requirement.
• Create Users and Responsibilities for Security and limit permission as per business needs.

Confidential, New York, NY

Oracle Apps Technical specialist & PLSQL Developer

Environment: Oracle Applications R12, UNIX, SO, PO, OM, Purchasing, Oracle Database 10g, SQL, PL/SQL, SQL Loader, OM, Purchasing

Responsibilities:

• Developed the interfaces listed below: Sales Order Extraction interface from R12 to Servigistics. Requisition Import Interface from Servigistics to R12. Purchase Order Import Interface from Servigistics to R12. Part Master Extraction Interface from R12 to Servigistics. Customizing standard ‘Receipt Traveller’ Report in R12.
• Responsible for understanding functional mapping document MD050, writing PL/SQL programs, technical design document, test case document and installation documents.
• Responsible for Unit-testing, fixing issues during functional testing and Integration testing.
• Involved in technical design, development, Unit testing, creation of patch, and support for the concurrent programs for creation of Prepayment Invoice, Reversal of Prepayment Invoice, Application of Prepayment Invoice to Final Invoice and custom forms to launch the creation of prepayment invoice, match prepayment invoice and show the details of the prepayment invoices matched to final invoices.
• Involved in form personalization for enabling the menus for accessing all the custom forms, restricting the reversal button and changing of On Account Amount in Receipts Screen in AR module.
• Responsible for writing Technical Design Document for CRs.
• Responsible for production support of the existing solution.
• Responsible for understanding the client requirement, analyzing the feasibility and giving estimates accordingly.
• Responsible for developing code, Unit-testing and creating patch.

Confidential

Oracle Apps Technical specialist & PLSQL developer

Environment: Oracle Applications R12.1.3, 11.5.10.2/11 i, SO,OM,PO,INV BOM, AOL, Forms 6i/10g, Reports 6i/10g, Oracle9i/10g, SQL and PL/SQL, Toad, SQL Developer, WinScp374, SSH Client, Windows XP.

Responsibilities:

• Developed a process to load the routing data from a flat file into staging tables, import data from legacy system into staging tables using SQL*LOADER and perform validations prior to transferring data into OM Open Interface tables.
• Developed a custom interface to load the routing data from staging tables to interface tables and used standard import program to load the data to the base tables, used standard Order Import to load the Open Orders from the interface tables to the standard OM tables.
• Created Customized Invoice report for client by modifying standard Invoice Report provided by Oracle
• Enabled descriptive flex fields to facilitate additional information.
• Developed PL/SQL programs like packages, procedures, triggers, functions. Registered concurrent programs, request groups for reports.
• Created business areas, Created joins, Created conditions, Created new folders based on user requirements.
• Design and development of change requests as per business requirement.
• Worked on Forms Personalization to meet business requirements.
• Create Users and Responsibilities for Security and performed Administrative tasks like adding security, granting privileges, scheduling and sharing of reports
• Worked on AOL setups.
• Migration among different environment (Dev\Test\Prod) using ITG Migration (Kintana).
• Enhancement based on change request mechanism of Dev Track.
• Providing support at customer site by solving bugs/problems and providing requested business information by building queries and/or extracting required data.

Confidential

Oracle Apps Technical specialist & PLSQL Developer

Environment: Oracle Applications 10g, Oracle10g, SQL and PL/SQL, Toad, SQL Developer, Windows XP.

Responsibilities:

• Developed AdvancePL/SQL packages, procedures, triggers, functions, IndexesandCollectionsto implement business logic usingPLSQL developer and SQL plus.
• Generated server sidePL/SQL scriptsfordata manipulationand validation and materialized views for remote instances.
• Responsible for database application development, Query Optimization, Performance Tuning following the process of System Development Lifecycle
• Developed Shell Scripts forData loadingandDDL Scripts.
• Developed conversion scripts usingSQL, PL/SQL, stored procedures, functionsandpackagesto migrate data from SQL server database to Oracle database.
• Developed packages to fetch complex data from different tables in remote databases using joins, sub queries and database links.
• Performed Database Administration of all database objects includingtables, clusters, indexes, views, sequences packagesandprocedures.
• Designed and developedOracle forms & reportsgenerating up to 60 reports.
• Performed modifications on existingformas per change request and maintained it.
• Involved inimplementing Physical Database design.
• UsedSQL*Loaderas an ETL tool to load data into the staging tables.
• UsedDTS Packagesas ETL tool for migrating Data from SQL Server 2000 to Oracle 10g.
• Developed and modified a number ofFormsfor various modules. Also responsible for following up bugs reported by various users and suggesting possible patches to be applied.
• Responsible for Unit-testing, fixing issues during functional testing and Integration testing.
• Worked in Production Support Environment as well as QA/TEST environments for projects, work orders, maintenance requests, bug fixes, enhancements, data changes, etc.
• Provided user training and production support.
• Improved the performance of the application by rewriting theSQL queries.
• Attending client status calls and daily status reporting to client.

Confidential

Oracle Apps Technical specialist & PLSQL Developer

Environment: Oracle Applications 10g, Oracle10g, SO,OM,PO,INV,BOM, SQL and PL/SQL, Toad, SQL Developer, Windows XP.

Responsibilities:

• Responsible for maintenance and enhancement of Oracle ERP application.
• Responsible for development of all the custom components using PL/SQL developer.
• Worked in the customized backend PL/SQL packages to interact with ERP system through middleware (SOA).
• Bug-fixing the components that have issues using PL/SQL developer.
• Participating in team discussions in understanding requirements for each component.
• Performing root cause analysis of the recurring incidents and preparing RCA document.
• Impact analysis of business flow change requests and addition of the new business processes according to the request of the client.
• Coordinating database patching and environment upgrade for Production and intermediate regions with admin teams and other vendors.
• Providing solutions and investigating on several incident raised by client.
• Creation of database objects likeviews, materialized views, procedures and packagesusing oracle tools like Toad, PL/SQL DeveloperandSQL* plus.
• Involved in understanding the entire system and analyzing the entire data structure of the system.
• Propose the solution and way of implementation of new business requirements and prepare the high level and low level designs of business flow change requests.
• Monitoring daily batch jobs, and preparing daily incident reports
• Interact with Onsite development team for requirement gathering.