SUMMARY

• Oracle Certified Associate with overall experience of around 8 years of experience (11i, R12) in Oracle Applications Business Suite(EBS).
• Strong working experience as an Oracle Apps Techno Functional consultant in Oracle Applications.
• Excellent Working knowledge in Oracle modules like Oracle HRMS, iExpenses, Order Management (OM), Inventory (INV), Purchasing (PO), Oracle Financial modules like General Ledger (GL), Account Payables (AP), Account Receivables (AR) and Fixed Assets (FA), Oracle CRM modules like Oracle Service Contracts, Oracle Install Base, Project Accounting(PA).
• Experience in Procure to Pay (P2P), Order to cash (O2C) life cycles and Supply Chain business flows.
• Expert in developing Functional Design Documents (MD050), Technical design documents (MD070), Technical Test documents (TE020), Conversion (CV050) and Migration documents (MD0120).
• Technically proficient inRICEW components (Reports, Interfaces, Conversions, Extensions, Workflows).
• Extensive Experience in Oracle waterfall methodology and Agile methodology.
• Worked on the OAF pages’ development from scratch including extension of seeded OAF Pages, Controller Objects(CO), View Objects(VO) as well as OAF personalization.
• Experience in AOL concepts like Concurrent Programs, Key Flex Fields and Descriptive Flex Fields. Creating users, Responsibilities, Menus, Request Sets, Request Groups, Value sets, Lookups, Profile Options, Form functions and Security, Forms Personalization.
• Experience in importing data from legacy systems to Oracle Applications through SQL*Loader and UTL FILE using interface programs and conversion programs.
• Experience in Oracle back - end PL/SQL Development I.e. Stored Procedures, Packages, Functions & Triggers using SQL*Loader, SQL developer, Toad, PL/SQL editor as development tools. Created and maintained Database Objects like Tables, Views, Materialized Views, Inline views, Indexes, Constraints, Ref cursors, Global temporary tables, Bulk collect, Sequence and Synonyms. Building complex integration with UI application using plsql object types and dynamic queries (For Advanced search operations).
• Experienced in Performance Tuning and Explain plan, Tkprof, SQL loader, FNDLOAD, UTL File, Indexes, Import and Export.
• Experience in opening, managing and Resolving Oracle TAR's (Service Requests) with Oracle Support on 24*7 basis.
• Good working experience in registration of forms and reports, tables and columns, Oracle Databases, RDBMS Concepts.
• Experience in all phases of Software Development Life Cycle (SDLC) including Requirement gathering, Analysis, Specification, Development, Maintenance, Testing and Documentation.
• Experience in designing and coding applications following specifications using the appropriate tools.
• Excellent interpersonal, communication, documentation and leadership skills. Strong technical aptitude, proven ability to rapidly assimilate and design practical applications of new technology. Exceptional career track marked by motivation, dedicated follow-through, and unwavering commitment to excellence.

TECHNICAL SKILLS

Tools: TOAD 9.0, JIRA, Clearcase, HP Quality Center, Putty, Editplus, SVN, MS Visual Source safe 6.0, Oracle JDeveloper 10.1.3.4, 9i (9.0.3) for OA Framework, Java Decompiler, SQL Developer (3.0.04),Forms 6i/9i,Reports 6i/9i,XML Publisher(5.6.3)

Modules: OM, Service Contracts(SC), PO, AP, AR, GL, FA, CORE HR, Iexpenses

Packages: EBS 11.5.10.2, Oracle R12.1.3

Programming Languages: SQL, PL/SQL, OAF

Database: Oracle 10g Database, Oracle 11g

Application Server: Oracle Application Server 10g

Operating System: Window 98, Windows XP, Windows 8, UNIX

PROFESSIONAL EXPERIENCE

Confidential, Philadelphia, PA

Oracle Apps Technical Developer/OAF Consultant

Responsibilities:

• Implementation of Inbound Interface to automate the addition of project bill and cost rates details. Acted as single point coordinator for OLB processes (Online Billing process). Developed Self Service Utility (OAF pages) for OLB process and customizations.
• Worked on Scramble routine of employee data in HRMS along with performance tuning.
• Developed OAF Page for Advanced Collections and form personalization for adding a new menu in tools ‘Consolidated Invoice Form’ which on click in turn invokes a request submission.
• Implemented AP Outbound Interface Program to extract the Invoice data from base tables to flat file using UTL FILE package.
• Extended InvoicesearchResultsVo in ireceivables page (OAF).
• Customized the Lockbox feature in AR (call the API of submit, validation import program of lockbox in plsql) to add business validation with use of external table.
• Worked on XML Publisher reports and XML bursting features.
• Involved in developing AP Bank Branch Interface by using public APIs IBY EXT BANK PUB. Worked on Dunning statements in AR to send email notifications to customers.
• Created a new approval workflow using oracle workflow builder.
• Customized PA project approval workflow, added one more level of approval while changing the project status from submitted too active.
• Worked on Advanced PL/SQL - Tables, Record type, Bulk Collects and Bulk Binds.
• Proactively tuned SQL queries and views using indexes, explain plan and tkprof.
• Imported orders using Order Import and OE header iface all interface tables and deleted orders using OM API OE ORDER PUB.PROCESS ORDER
• Created condition in processing constraint in order management(OM) to restrict orders with quantity more than a numeric value and not allow orders to be deleted when in booked status.
• Customization of PO Account Generator workflow logic.
• Performed the unit testing for the code and migrated the files through SVN tool.
• Worked on SR with Oracle On demand and Oracle metalink support access.

Environment: Toad 9.0, Oracle PLSQL, Oracle Workflows, Oracle R12.1.3, Oracle RICE, Oracle HRMS, PA, AP, AR, PO, OM, Advanced Collections, Receivables Module, XML Publisher Reports, OAF Development, Customization, Unix, SVN.

Confidential, Baltimore, MD

Oracle Apps Lead Developer

Responsibilities:

• Designed the system to process the Data points and build the rules and calculation engine for Annual evaluations.
• Requirement gathering for the Business validations and Report layouts.
• Worked on the Functional MD50 and Technical MD70 documentation.
• Worked on the Interfaces and Reports using the Oracle RICE Objects.
• Worked on bulk notification in Oracle Learning Management(OLM) using WEB ADI integrating with OAF by using BULK notification API.
• Loading External data (SLO, SPM), Setting up the metadata, Building the pre-process, Building the PLSQL rules and calculation engine to perform the Business validation, Score calculations and Annual Ratings calculations.
• Developed the XML Publisher Report for Teacher Annual evaluation report which is accessible to the teachers through employee self-service responsibility.
• Worked on the OAF Customizations to develop the Questionnaire fields for supervisors to enter the Surveys.
• Performed Root cause analysis and Fixed critical issues in the last minute in the Production environment.

Environment: Toad 9.0, Oracle PLSQL, Oracle R12.1.3, Oracle RICE, Oracle Learning Management(OLM), Oracle Performance Management System (OPMS) Module, XML Publisher Reports, OAF Customization, WEB ADI.

Confidential, New York

Oracle Apps OAF Consultant

Responsibilities:

• Customized seeded Iexpense OAF pages to include business requirements. Implemented OAF dialog pages.
• Developed Oracle Discoverer Reports - custom Invoice Register Reports.
• Worked on OAF Dialog pages in iExpenses module. Also customized seeded OAF Pages.
• Integrated oracle workflow with OAF. Created a dependent Lov,
• Worked on purging of AP tables. Worked on Version Control software to check-in codes and used clearcase for file migration.
• Used FND-LOAD to migrate concurrent programs, request sets, forms menus and Personalization, by downloading the LDT files.
• Fix defects encountered in any of the testing phases. Ensure quality in coding and testing, conforming to Standard JPMC Protocol.
• Worked on Shell scripting to send mail and move files to backup folder and remove them after 6 months using CRONTAB.

Environment: Oracle PLSQL, Oracle R12.1.3, Oracle RICE, Expenses, AP, GL Module, OAF, Oracle Discoverer, Unix, Clear Case, HP Quality Center

Confidential

Oracle EBS developer

Responsibilities:

• Analyze customer attribute from PSION and perform gap analysis against Customer, supplier and item attributes in Trilogy.
• Performed System Integration Testing (SIT) & UAT with the involved teams.
• Interaction with customer to show the profiling reports, receive feedback and incorporating appropriate profiling rules.
• Prepared the CV040 Customer conversion data mapping document for mapping customer attributes from SMART Systems (third party legacy system) to Oracle R12.
• Define and document the technical designs of conversion and data cleansing programs from SMART Systems to Oracle R12.
• Co-ordination with team to gather the business requirements and guide juniors in providing solution to the Customer data quality and migration activities.

Confidential

Oracle Apps Technical Developer

Responsibilities:

• accounting location, delivery center) in project accounting(PA) after the project status has turned active.
• Sent multiple notifications using Roles in oracle workflow by APIs CREATE ADHOC ROLE and ADD USERS TO ADHOC ROLE.
• Oracle Application Framework(OAF): Designed/build screens that interact with database, extending seeded VO, CO and AM, performing Personalization, Partial page rendering, External LOV, switcher, dependent LOV, Validation View Objects. Created tab menus for OAF pages.
• Worked on Forms development 6i/Reports 6i. Worked on form development for error tracking and created custom oracle reports for AP trial balance Invoice report.
• Project Costing: Importing raw costs as Expenditure items from other source systems, creation and adjustment of the expenditure items in Projects.
• Defining Resource List, Cost Budget, Revenue Budget, Creation of Project templates, tasks with transaction control set ups.
• Project Billing: Defining Agreements, funding from agreements, from creation of Draft Invoice to making them accepted in Account Receivables. Interfacing Draft revenues to GL.
• Extensions: Done customizations on PA Client extensions to add business validation while changing project status from approved to active using extension packages(PA PROJECT CLIENT EXTN), worked on form personalization and Custom. pll.
• Created new OAF pages from scratch (self-service utilities) and custom oracle workflows.
• Added a custom QA check for service contracts.
• Worked on Xla journal entries PUB API for manual entry of journals in Sub ledger accounting(SLA).
• Conducted code reviews, performed unit testing, fixes, and requirement validations, accomplished database design, and modeling through data flow diagrams at conceptual, logical and physical levels.
• Responsible for tracking of high priority tickets and resolution of escalated support incidents.
• Answer technical support queries and implement fixes for application problems.

Environment: Oracle PLSQL, Oracle R11.5.10.2, R12.1.3 Oracle RICE, PA, AR, GL, AP, SLA, Service Contracts(OKS) Module, OAF, Oracle Workflow, Oracle Reports 6i,Oracle Forms 6i,Unix,MS VSS, Windows XP