SUMMARY

• 9+ years of experience in Oracle Application systems, Oracle e - business suite (EBS); excellent technical experience with the customization & full implementation/upgradation experience in Oracle Application versions from 10.7 to R12.2.4. Advanced level/High levels of expertise in PL/SQL programming.
• Work in various roles as Technical Lead, Designer, Tester and Developer which includes RICE objects - Reports, Interfaces, Conversions, Extensions, & customizations to different modules of Oracle Applications.
• Technical experience across multiple streams in the product suite - Financials, Supply Chain Management (SCM), Oracle Process Manufacturing (OPM), Human Resources (HRMS), Order Management (OM), Purchasing(PO)
• Experience in Software Development Life Cycle(SDLC) including Analysis, Design, Development, Implementation, Testing and Post Production issues/Support using Oracle Applications R12 (12.1.3), 11i (11.5.9,11.5.10.2)
• Technically experience in Account Receivable (AR), Account Payable (AP), Purchasing (PO), Order Management (OM), Shipping, BOM, Inventory (INV), Advanced Pricing, Process Manufacturing (OPM), E-Business Tax, General Ledger (GL), Service Contracts and Payroll.
• Expertise in the AIM Methodology, Documentation, Configuration of Applications, Testing, End-User Training and Supporting for Oracle Financials R12/11iGL, AP, AR, CM,andFAmodules.
• Good Experience in business flows - Procure to Pay (P2P), Order to Cash (OTC) Cycles.
• Work in Oracle Application Framework (OAF) applications, creation of new OAF pages in JDeveloper 10.1.3 environment.
• Experience in Data mapping the external source files with oracle columns inOracle Accounts Receivables, Accounts PayablesandFixed Assets, OM, Shipping and Purchasingmodules.
• Worked on AOL objects and has knowledge in using FND Library.
• Knowledge in Sub Ledger Accounting & Revenue Recognition.
• Knowledge in TCA architecture.
• Used API’S for conversions & Interfaces.
• Prepare Functional design documents for customizations/conversions using AIM methodology.
• Experience in all phases of the system development/implementation life cycle.
• Experience in development & customization of RDF, XML/BI Publisher and Discoverer Reports and data structures and setup.
• Basic knowledge of forms and workflow.
• Knowledge in Agile and Waterfall processes
• Knowledge in Multi Organizations Access Control (MOAC).
• Experience in Oracle HCM Fusion- SOA.
• Experience in preparingRD020, BP040, BP080, BR100, MD050andTE040documents.
• Develop Complex database objects likeStored Procedures, Functions, Packages and Triggers using SQL and PL/SQL.
• Effectively made use ofTable Functions, Indexes, Table Partitioning, Collections, Analytical functions and Materialized Views.
• Good knowledge on logical and physicalData Modelingusingnormalizing Techniques.
• Experience withPerformance Tuningfor Oracle RDBMS usingExplain PlanandHINTS.
• Migration of legacy data to oracle using SQL*Loader and UTL FILE utilities.
• Experience inOracle Packages, Dynamic SQL, RecordsandPL/SQL Tables.
• Experience in DBA activities -SQLperformance tuningusing Cost-Based Optimization (CBO).
• Partition large Tables usingrange partition and Date partition technique.
• Good knowledge of key Oracle performance related features such asQuery Optimizer, Execution Plans, Table partitioningandIndexes.
• Expertise inDynamic SQL, CollectionsandException handling.
• CreateShell Scriptsfor invoking SQL scripts and scheduled them using crontab.

TECHNICAL SKILLS

ERP Applications: Oracle 11i, R12(ERP)

Reporting: Oracle BIP Reports/XML Reports, RDF Reports

Languages: SQL, PL/SQL, UNIX, SHELL/PEARL scripting, XML, T-SQL.

Databases: Oracle 8i/9i/10g,11g, MS SQL Server 2000/2005/2008 , MS Access

Operating Systems: Windows NT/98/95/2000 & Windows XP, UNIX, LINUX

Tools: Oracle Applications R12, Oracle Reports 6i, IntecSingl.eView Billing system, Billing and Revenue management system (Oracle BRM), TOAD, SQL Plus, Report Builder, SSIS, SSRS, SSMS, SQL Developer, JDeveloper 10.1.3, Squirrel, Oracle Discoverer, ETL, SQL* Loader, Clear case, HP PPM Kintana, HP QC ALM, Clear quest, FTP

Domain Knowledge: Telecom, Finance, Insurance, Products and Manufacturing

PROFESSIONAL EXPERIENCE

Confidential, Seattle, WA

Oracle Application Lead Developer

Responsibilities:

• Involve in Analysis, Designing, implementing and testing of the code and documentation.
• Work on custom report in Order Management (OM) which sends store order details to the suppliers in an email.
• Work in Oracle Application Framework (OAF) applications, creation of new OAF pages in JDeveloper 10.1.3 environment to develop custom solutions in Purchasing module.
• Created new search and update OAF pages which includes select option, updating data through EO (Entity Objects).
• Work on Production issues.
• Map the Client requirements with Oracle standard functionality and finding the gaps and delivering the solutions in terms of Customizations, workarounds and reengineering.
• Work on customization of BI Publisher/XML reports.
• Develop components as per the business transformation rules with coding standards.
• Perform Database Administration of all database objects includingTables, Indexes, Views, Sequences, Packagesandprocedures.
• Performance tuning of Oracle Databases (DBA activities) and User applications.
• Extensively used the advanced features of PL/SQL likePragma Autonomous Transaction, Records, Tables, Collections, Object typesandDynamic SQL.
• Extensively usedBulk collectionin PL/SQL objects for improving the performing.
• Handle errors usingException Handlingextensively for the ease of debugging and displaying the error messages in the application.
• Extensively involved in usinghints to direct the optimizerto choose an optimumquery execution plan.
• Createdrecords, tables, collections(nested tables and arrays) for improving Query performance by reducing context switching.
• Responsible for the end to end activities in HP QC ALM (creating/uploading test cases, executing, defect analysis, assigning defects to the concerned team and regular meetings on defect resolution).
• Handle SIT & UAT issues in reports & Conversions.
• PerformedSQL and PL/SQL tuningand Application tuning using various tools likeEXPLAIN PLAN, SQL*TRACE, TKPROFandAUTOTRACE.
• Develop major enhancements required for business process in Order to Cash (OTC) and Procure-to-Pay (P2P) cycles.
• Writing backend scripting - procedures, functions, triggers etc.
• Ensuring the built solutions are thoroughly tested during Unit Testing phase and the build team supports onshore team during product test, User Acceptance Testing.
• Code Promotion/Migration of the components.

Environment: Oracle Applications R12.2.4, OAF using JDeveloper 10.1.3, Oracle 10g/11g, SQL * Plus, TOAD, SQL Developer, UNIX.

Confidential, Morrisville, NC

Sr. Oracle Applications Consultant

Responsibilities:

• Involve in Analysis, Designing, implementing and testing of the code and documentation.
• Work on conversions in financial module Accounts Receivable (AR)-AR Open Invoice Interface and Order Management (OM), Customer.
• Design and developItem Interfaceby loading the data files into the base tables.
• Developed conversion programs for CRM Service Contracts using Oracle PL/SQL to load into the Siebel base tables.
• Knowledge in Sub Ledger Accounting & Revenue Recognition.
• Map the Client requirements with Oracle standard functionality and finding the gaps and delivering the solutions in terms of Customizations, workarounds and reengineering.
• Work on customization of BI Publisher/XML reports.
• Develop components as per the business transformation rules with coding standards.
• Migration of legacy data to oracle using SQL*Loader and UTL FILE utilities
• Perform Database Administration of all database objects includingTables, Indexes, Views, Sequences, Packagesandprocedures.
• Performance tuning of Oracle Databases (DBA activities) and User applications.
• Extensively used the advanced features of PL/SQL likePragma Autonomous Transaction, Records, Tables, Collections, Object typesandDynamic SQL.
• Extensively usedBulk collectionin PL/SQL objects for improving the performing.
• Handle errors usingException Handlingextensively for the ease of debugging and displaying the error messages in the application.
• Extensively involved in usinghints to direct the optimizerto choose an optimumquery execution plan.
• Createdrecords, tables, collections(nested tables and arrays) for improving Query performance by reducing context switching.
• Responsible for the end to end activities in HP QC ALM (creating/uploading test cases, executing, defect analysis, assigning defects to the concerned team and regular meetings on defect resolution).
• Handle SIT & UAT issues in reports & Conversions.
• Wrote Unix Shell Scripts to process the files on daily basis like renaming the file, extracting date from the file, unzipping the file and remove the junk characters from the file before loading them into the base tables.
• DevelopUNIX Shell scriptsto automate repetitive Database processes.
• PerformedSQL and PL/SQL tuningand Application tuning using various tools likeEXPLAIN PLAN, SQL*TRACE, TKPROFandAUTOTRACE.
• Develop major enhancements required for business process in Order to Cash (OTC) and Procure-to-Pay (P2P) cycles.
• Writing backend scripting - procedures, functions, triggers etc.
• Ensuring the built solutions are thoroughly tested during Unit Testing phase and the build team supports onshore team during product test, User Acceptance Testing.
• Code Promotion/Migration of the components.

Environment: Oracle Applications R12, Oracle 10g/11g, SQL * Plus, TOAD, SQL Developer, UNIX.

Confidential, Cleveland, Ohio

Lead/Oracle Applications Consultant

Responsibilities:

• Involve in Analysis, Designing, implementing and testing of the code and documentation from 11i to R12 upgrade.
• Prepare Business and functional specification document.
• Application Enhancement and Support forFinancial modules -Accounts Payable(AP), Accounts Receivable(AR) and on Manufacturing Modules.
• Analysis of the current system by interacting with business and cross functional team.
• Mapping the Client requirements with Oracle standard functionality and finding the gaps and delivering the solutions in terms of Customizations, workarounds, reengineering and form personalization.
• Customization designs and work around for various business requirements in R12.
• Develop RDF & XML/BIP reports and convert the output into PDF, MS-Word, Excel etc. based on the client requirement.
• Convert RDF reports to XML/BIP reports.
• Customized existingOracle Reportsin Inventory Module (INV),Pricing, Purchasing, AP, AR and OM.
• PrepareRD020, BP040, BP080, BR100, MD050documents for each financial module.
• Prepare TE040 Documents, which is helpful to test the application functions.
• Create Technical Designs of high quality based on the functional designs within delivery timelines for Conversions and Reports.
• Develop components as per the business transformation rules with coding standards.
• Work on Conversions, Interfaces, Extensions and Reports.
• Worked on ‘Item Categories’ conversion that is used to extract active categories from 11i, validate and then call the standard API
• Worked on ‘Items’ conversion to extract data from 11i to R12.
• Worked on ‘Batch ticket’ Interface.
• Oracle Process Manufacturing-Worked on ‘Recipe’ & ‘Recipe Validity Rules’ conversion to extract data from 11i, validate and calls the standard API ‘GMD RECIPE DETAIL.Create Recipe’ & ‘GMD RECIPE DETAIL.Create Recipe VR’ respectively for creating recipe & recipe validity rules for each record inserted.
• Create R12 concurrent programs for reports and conversions.
• Implementation experience with Oracle Release 12(R12) for different Countries like China also.
• Analyzing the issues on Production System and resolving them.
• Responsible for the end to end activities in HP QC ALM (creating/uploading test cases, executing, defect analysis, assigning defects to the concerned team and regular meetings on defect resolution).
• Also responsible for Migrations of the technical objects from Development instance to other testing instances and production using the migration tools such as Putty, HP PPM and SVN.
• Wrote conversion scripts usingSQL, PL/SQL, Stored Procedures, Functionsandpackagesto migrate data from legacy to Oracle database.
• Performed Database Administration of all database objects includingTables, Indexes, Views, Sequences, Packagesandprocedures.
• Performance tuning of Oracle Databases (DBA activities) and User applications.
• Extensively used the advanced features of PL/SQL likePragma Autonomous Transaction, Records, Tables, Collections, Object typesandDynamic SQL.
• Extensively usedBulk collectionin PL/SQL objects for improving the performing.
• Handle errors usingException Handlingextensively for the ease of debugging and displaying the error messages in the application.
• Extensively involved in usinghints to direct the optimizerto choose an optimumquery execution plan.
• Createdrecords, tables, collections(nested tables and arrays) for improving Query performance by reducing context switching.
• Wrote Unix Shell Scripts to process the files on daily basis like renaming the file, extracting date from the file, unzipping the file and remove the junk characters from the file before loading them into the base tables.
• DevelopUNIX Shell scriptsto automate repetitive Database processes.
• PerformedSQL and PL/SQL tuningand Application tuning using various tools likeEXPLAIN PLAN, SQL*TRACE, TKPROFandAUTOTRACE.
• Develop major enhancements required for business process in Order to Cash (OTC) and Procure-to-Pay (P2P) cycles.
• Involve in creating Discoverer reports to generate Purchase Order reports.
• Writing backend scripting - procedures, functions, triggers etc.
• Ensuring the built solutions are thoroughly tested during Unit Testing phase and the build team supports onshore team during product test, User Acceptance Testing.
• Code Promotion/Migration of the components.

Confidential, Pittsburgh, PA

Sr. Oracle Applications Developer

Responsibilities:

• Documenting the mapping and requirements for the interfaces and conversions between the source and Oracle Applications for 11i to R12 upgrade project.
• Work on Configuration forFinancial Modules-General Ledger (GL), Accounts Payable (AP), Accounts Receivable (AR),andFixed Assetsas per the client needs.
• Work on Interfaces, Conversions and reports in Oracle HCM / US Payroll.
• Work on HRMS Inbound/Outbound Interfaces using Fusion-SOA Interface.
• Hands on experience in using Fast Formulas and defining an Element.
• Defining Key flex fields and values sets.
• Work on few tough Payroll reports like ‘Statistical Labor Detail and Employee Cost’
• Create Flow Charts, developing Logic and testing.
• Analyzing the issues on Production System and resolving them.
• Giving the overview on functional modules to technical team.
• Prepare BR100 Documents for business users and addressing training (KT) sessions to users.
• Create Technical Designs of high quality based on the functional designs within delivery timelines for Conversions and Reports.
• Create R12 concurrent programs for reports and conversions.
• Work on few Purchasing, P2P and OM reports like ‘Change of AP Invoice Number’, ’Daily Schedule Reports’, ’Inventory Adjustments’, ’Min Max Report’, ’Receiving History by PO’ and ’Shipment summary for Customer and Item’, ’Bill of Lading’ etc.
• Develop components as per the business transformation rules with coding standards.
• Develop most critical RDF & XML/BIP reports and converting the output into PDF, MS-Word, Excel etc. based on the client requirement.
• Convert RDF reports to XML/BIP reports.
• Uploading the developed components from dev instance to UAT and PROD instances using Kintana HP PPM.
• DevelopPl/SQL Packages, Procedures, Functions, Triggers, DDL scriptsaccordance with Business Requirements for loading data into database tables.
• Involve inUnit Testing Stored ProceduresandFunctions.
• CreateMaterialized Viewsandpartitioning tablesfor performance reasons.
• Create PL/SQLStored Procedures, Functions and Packagesfor moving the data from staging area to data mart.
• Create scripts to createnew Tables, Views, Queriesfor new enhancement in the application using TOAD.
• DBA Activities-CreatedIndexes on the tables for faster retrieval of the data to enhance DatabasePerformance.
• Involve inDefragmentation of tables, partitioning, compressing and indexes for improved performance and efficiency.
• UsePragma Autonomous Transactionto avoid mutating problem in database trigger.
• Extensively used the advanced features of PL/SQL likeRecords, Tables, Object typesandDynamic SQL.
• Handle errors usingException Handlingextensively for the ease of debugging and displaying the error messages in the application.
• Ensuring the built solutions are thoroughly tested during Unit Testing phase and the build team supports onshore team during product test, User Acceptance Testing including end-user documentation.
• Code Promotion/Migration of the components.

Environment: Oracle Applications R12, Oracle11g, SQL * Plus, TOAD, SQL Developer, UNIX.

Confidential, Whiteplains, NY

Oracle Applications Techno consultant

Responsibilities:

• Resolve issues and troubleshooting by following up with the end users; and monitoring the tickets and raising the tickets to apply the break fixes in controlled environment.
• Handle the most critical tickets within the given deadlines.
• Customize the code when needed in resolving a ticket.
• Create R12 concurrent programs for Extensions.
• Experience inQuery Optimization and Performance Tuning.
• Develop advanced PL/SQL Packages, Triggers, Functions, Indexes and Collections.
• Develop new customized reports as per business requirement.
• Prepare issue and risk tracker and submit to client weekly basis.
• Was one of the key resources in handling month-end process, in which the users run all the Interfaces in a short span of time by prioritizing as Severity1 issue.
• Prepare the required documents and test cases for every ticket resolved.
• PrepareRD020, BR100, TE040(Test Scripts) and End User Training Manuals.
• Prepare the Test Plans and test cases for every ticket in HP QC ALM.
• Coordinate activities concerned with developments, scheduling and resolving tickets and test cases with the team members.
• Assign tickets and helping out the entry level team members in growing technically.

Environment: Oracle Applications 11i, Oracle 10g, SQL * Plus, TOAD,SQL Developer, UNIX.

Confidential

Sr. Oracle Apps Developer/Technical Lead

Responsibilities:

• Create Technical and Functional Designs of high quality based on the functional designs within delivery timelines for Conversions and Reports for 11i & 11i to R12 upgrade.
• Application Enhancement and Support for Finance & SCM.
• Develop RDF & XML/BIP reports and converting the output into PDF, MS-Word, Excel etc. based on the client requirement.
• Convert RDF reports to XML/BIP reports.
• Work on AP and AR setups.
• Prepare TE040 Documents, which can helpful to test the application functions.
• Gather the Client Requirements and preparing the documents using AIM Methodology.
• Verify data between legacy and existing system for customer and business implementation.
• Coordinate with onsite and other teams at offshore to meet the deliverables of the Modules.
• Identify the Loop holes in the system of the same in synchronizing the customer database between legacy and current billing system.
• Acting as active coordinator between Functional and Development teams.
• Analyzing of Source and Target Systems.
• Develop and modifytriggers, packages, functionsandstored proceduresfor data conversions and PL/SQL procedures to create database objects dynamically based on user inputs.
• WroteSQL, PL/SQL, SQL*Plusprograms required to retrieve data using cursors and exception handling.
• Createindexeson tables to improve the performance by eliminating the full table scans and views for hiding the actual tables and to eliminate the complexity of the large queries.
• Fine-tuned PL/SQL queries for maximum efficiency in various databases usingOracle Hints, for Rule based optimization.
• Partition large Tables usingrange partition and date partition technique.
• Analyzing query plans and query tuning using the tools such asEXPLAIN PLANand useHINTS wherever required.
• Developmaterialized viewsfor data replication in distributed environments.
• Preparing the mapping sheets between source and target systems.
• Develop a batch file in which the process runs all the stages i.e. source, staging and loading which has reduced the time for ETL process.

Environment: Oracle Applications 11i, Oracle 9i, 10g, SQL*Plus, PL/SQL, Toad, SQL developer.