SUMMARY

• Around 7 years of strong experience in the IT Industry on Oracle Development Tools, Oracle E - Business Suite (Oracle Applications)
• Experience in Design, Development, Interfaces, Customization and Implementation of business applications using Oracle Applications
• Very good in creating Procedures, Packages, Functions, Forms, Triggers views, records, constraints and other database objects using SQL and PL/SQL
• Good in implementing Oracle Financials and Supply chain modules with AR, AP, GL, FA, Purchasing, Inventory, Order management, BOM, Shipping, WIP, iSupplier
• Strong working knowledge of development tools such as Oracle Developer (Forms 6i/9i and Reports 6i/9i), Workflow Builder, XML Publisher in Oracle 12 environment and have rich experience in RICEW (Reports, Interfaces, Conversions, Extensions & Workflow) components
• Experienced in the customization of forms and modification within the AOL
• Knowledge in System Administration which includes defining responsibilities and managing users
• Extensive experience in Procure to Pay and order to cash
• Design and implementation, Resource planning and financial system evaluations are done proficiently
• Strong experience in gathering requirements, write functional (MD050), (BR.030) and (BP080) document and technical (MD070), (BR.100) document, provide recommendations for user
• Extensive knowledge of DBMS and Distributed Databases
• Performed detailed analysis, gathered requirements and specifications in Software Development Life Cycle process and performed unit testing, integration and production install and support
• Modifying and developing Reports (2.5,6i,9i), Discoverer (4i,6i), Forms (4.5,6i,9i) and registering them with Application Object Library (AOL)
• Good Knowledge in Architecture and Implementation of Oracle Release 12 Upgrade and Implementation
• Responsible for maintaining and improving the Finance and Purchasing business processes, Oracle Configuration and data reporting while ensuring regulatory compliance
• Completed five full life cycle Oracle Finance implementations of General Ledge (GL),Accounts Payable (AP), Accounts Receivable (AR), Purchasing (PO), Fixed Assets (FA) Order Management (OM), Inventory (INV), 11.03 and 11i (latest version 11.5.10.2)&R12 using AIM
• Ability to work hard as an individual and in a team to achieve desired results
• Ability to meet deadlines and handle pressure in coordinating multiple tasks in the work environment
• Good communication and analytical skills and ability to adapt and learn new things in organized way

TECHNICAL SKILLS

ERP: Oracle Applications R12 / 11i, OBI

Modules: GL, AP, AR, OM, PO, INV, BOM, System Administration

Databases: Oracle 11g/10g/9i

Operating Systems: Windows 95/98/NT/XP/Vista/7, UNIX, Linux

Programming/ Scripting Languages: C, HTML, SQL, PLSQL, Shell and Java Scripting

Tools: / Utilities: Toad, Putty, PLSQL Developer, Reports and Forms, Oracle Work flow builder, SQL Plus

Office Tools: Microsoft Word, Excel, Outlook, Access, Visio

PROFESSIONAL EXPERIENCE

Confidential, Pittsburgh, PA

Oracle Apps Consultant

Responsibilities:

• Analyzed business and technical requirements, design and interfaces
• Responsible for analyzing, designing, developing and providing test and production support for business functionality of the Purchase Orders
• Involved with business users in the process of managing the users in iSupplier and End dating them who not logged in for given time
• Design and Developed Complex Forms, Record Groups, Object Groups, Visual Attributes, Menus, Reports, Graphics, Parameters, System Variables, Master-Details Forms and PL/SQL Libraries
• Developed OBI user interface objects
• Performed analysis, presentation and reporting
• Experience in developing, customizing, modifying forms, reports existing in Oracle Applications according to the business requirements and specifications
• Design and development of Custom process Integrated with Oracle
• Developed new Work Receiving custom Form
• Created a new Backlog report based on existing Oracle EBS tables and integrated application tables
• Interacted with the end users, deployed and documented
• Hands on experience in procedures, packages, functions in PL/SQL programming
• Involved in Production support
• Involved in troubleshooting errors, fixing the bugs and fulfilled the new business requirements
• Created UNIX Shell Scripts for automating programs, data loading and interface process in Custom and Oracle Applications
• Extensively involved in SQL tuning, troubleshooting, debugging and fixing the codes/scripts
• Was part of the team which converted the current order management (COM) system to web based applications
• Worked on Oracle Order Management, Shipping, Purchasing Distribution and customizing existing material transactions
• Designed interface tables for Order Management, Purchasing and iSupplier
• Defined and reviewed the coding standards while analyzing the existing code and made the changes according to the new business requirements
• Involved in technical documentation from the specifications
• Interacted with users to resolve any issues during the production, development and enhancement phases

Environment: Oracle E-business suite 11i/ R12, Order Management, Purchasing, iSupplier, Shipping, Inventory, Oracle 10g/9i/6i, XML/BI Publisher 5.6.3, Reports10g, SQL*PLUS, SQL*Loader, TOAD, UNIX.

Confidential, Boston, MA

Oracle Apps Developer

Responsibilities:

• Involved in business requirements, development, testing and support stages of software development life cycle
• Experienced on Inventory, Manufacturing, Order Management, Shipping and Purchase Distribution
• Involved in the inventory setup, shipping networks, installation base, service plans, transactions of the order
• Worked with multi-org and multi-currency orders
• Created custom forms like Receiving Notification Form to notify the suppliers about the orders from buyers
• Developed PL/SQL Procedure for pricing Sales Orders and did ad hoc query and reporting
• Developed, implemented interfaces using tools for integration of system
• Developed concurrent programs to validate the configurations
• Used Java Scripts to load data and interface process
• Performed testing based on requirements
• Designed responsibilities based on business requirements for testing and development
• Experience in developing, customizing, modifying forms, reports existing in Oracle Applications according to the business requirements and specifications.
• Made analysis based on existing code and made changes according to the new business requirements
• Experience in developing packages, procedures, cursors, constraints, functions
• Involved in development, enhancement process and issue resolution during production
• Met the functional requirements in coding, testing

Environment: Oracle E-business suite 11i, Order Management, Work in Process, Purchasing, Shipping, Inventory, Oracle 10g/9i, Discoverer 10g, Reports10g/6i,Forms 10g/6i SQL*PLUS, SQL*Loader, TOAD, UNIX.

Confidential, Alpharetta, GA

Oracle Apps Developer

Responsibilities:

• Customized and developed Oracle Forms/Reports workflow and Data conversion in AP, AR, GL Project Modules, and sub ledger accounting
• Interacted with the business users and collected the technical requirements
• Involved in Development, Customization of the Interface Applications
• Worked on different reports involving different modules like OM,AP,AR,GL
• Worked on physical data modelling and involved in developing database by PL/SQL functions, procedures, triggers, packages and materialised views
• Used tables, objects, error handling, shell scripts of Unix for execution process
• Involved in purchase order to insert data into interface tables and validating the data
• Developed new forms for single and multiple table and blocks, made use of menus, alerts, attributes and libraries to make interface user friendly
• Involved with Production support and troubleshooting at different stages of the project
• Designed programs to speed up the error correction and improve the workflow using standard OM,GL API’s and customized order header and link level workflow to custom activities
• Wrote technical design documents for conversions, extensions, interfaces, and reports
• Involved in troubleshooting issues including creation/follow-up of Oracle service requests (SRs). Conduct quality reviews of code developed by other development staff.
• Worked extensively on the general ledger systems of the client
• Customized Approval workflow for adding email notification workflow function for changed process
• Involved in process to validate receiving data, insert data into interface tables and call receiving transaction processor and concurrent program
• Developed forms to correct errors in interface process which are used to correct errors in staging and interface tables
• Developed Projects Custom reports
• Developed reports for Order management, BOM modules Created procedures and SQL*Loader Scripts to populate Customer interface tables with data such as Customer Profiles, Phone Contacts at various levels, Payment Method data and Customer Bank data.

Environment: Oracle E-business Suite11i, Account Payables, Accounts Receivable, Inventory, Order Management, WIP, Oracle 10g/9i (9.2.0), XML/BI Publisher 5.6.3, Discoverer 10g, Reports10g, SQL*PLUS, SQL*Loader, TOAD, UNIX.

Confidential

Oracle Apps/EBS Developer

Responsibilities:

• Developed Oracle Applications using PL/SQL, SQL*Plus, Workflow Builder, Application Object Library, Forms and Reports
• Used Oracle E-Business Suite applications for accounts payable/accounts receivable (AP/AR), general ledger, fixed assets, and cash management and validation
• Designed and generated database objects and Oracle Forms, Reports, and Libraries through Oracle Designer
• Created shell scripts to load data into staging tables of expenditures, tasks, events and projects of project accounting using SQL*Loader direct path
• Handled database packages, procedures, functions and triggers using PL/SQL
• Written PL/SQL interface programs which feed the data into Oracle
• Worked with users through all Software Development Lifecycle (SDLC) phases
• Creating budget reports summary and project implementation steps
• Study of the current Business Process, Suggestion of future Processes and GAP Analysis
• General Ledger Setups configuration in the new environment
• Worked on Accounts Payable modules, Accounts Receivable and general ledger accounting cycle
• Good exposure on Period activities of AP, AR, and GL with auto invoice setup and configurations of Collections work bench
• Worked on the Internet Expenses setups of the Expense report and the credit card functionality for the clients business
• Experience on create, Itemize, update, and approval of the expense report
• Customization of reports like Adjustment Approval Report, Accounting Rules Listing Report, Publish RX Report, Account Status Report, Auto Reconciliation Report, Bills Receivables Summary Report
• Implemented Multi-Org, Multi-Reporting in accordance with Global Accounting environment
• Worked on setups of Oracle E-Business Tax Responsibilities and transactions
• Worked on the invoices and Bank payments processing of the Accounts Payables module
• Worked with business leads for process design, design finalization, configuration of Oracle applications.
• Worked on Client team in understanding the business process and assisted the team in preparing the BR(Business requirement) definition document.
• Identifying Consolidations across the General Ledger Business Process
• Setting up of customer tasks and Invoice management in AR
• Performed transactions on GL and receivables cycle and interfaced it to GL components
• Created profiles for classes to supply groups and reports on supplier payment status and enabled tax setups for GL

Environment: Oracle EBS 11.5.8 (GL, AP, AR), FA SQL Plus, PL/SQL