SUMMARY

• Around 8 years of extensive experience as Oracle Applications Techno - Functional Consultant in implementation, upgrade and customization of Oracle e-Business Suite Applications. This includes system study, design, development, post implementation maintenance and support of Oracle EBS
• Extensive experience as Oracle Applications e-Business Suite Consultant and Technical Developer in Design, Development and Implementation of Oracle Applications R12/11i.
• Extensive experience in Implementation, Migration, Customization, Production and Support of Oracle (R12 & 11i) applications/EBS with major focus on Financial modules (GL, AP, AR, FA, CM), SCM Modules (PO, OM, Advanced Pricing, INV, Shipping, WIP, BOM), HRMS, Oracle CRM (Service Contracts and Install Base), P2P, O2C life cycles
• Around 4 years of experience in Application Development using Oracle SQL, PL/SQL, and Developer Forms and Reports
• Expert in Oracle Application Framework (OAF) applications, customization of OAF pages, extension and creation of new OAF pages in JDeveloper 9i and 10g environment
• Expert in requirement gathering, design and development of custom applications in Oracle Applications Framework (OAF) environment
• Technically proficient in RICE components (Reports, Interfaces, Conversions, Extensions)
• Extensively experienced in Oracle PL/SQL Development i.e. Stored Procedures, Packages, Functions & Triggers.
• Strong Exposure in preparation of high-level functional design documents for custom application development, Conversions, Interfaces & Reports
• Proficiency with tools used to support Oracle Applications development including PL/SQL, Forms, Reports, Workflow Builder, and XML Publisher.
• Created and maintained Database Objects like Tables, Views, Indexes, Constraints, Sequence, Synonyms, Database link, Roles and privileges.
• Experienced in Database Design, Data Modeling, Migration, and Systems Architecture, Planning, Testing and Trouble Shooting.
• Well versed with client-server environment and tools like SQL* Loader, Toad, SQL Developer.
• Worked on AOL modules for creating Concurrent Executable, Concurrent Programs and Setting Profile Options as per the requirements.
• Technical Experience in custom form development, Zoom functionality, Custom.pll and Form personalization
• Strong exposure on Trading Community Architecture (TCA) and multi-org in 11i and R12.
• Performance Tuning by implementing parallel Execution, Table Partition, materialized views with query rewriting, creating appropriate indexes, usage of hints, rebuilding indexes and also used the Explain Plan.
• Good in creating multiple Financial Statements and ad-hoc reports using Financial Statement Generator (FSG)
• Experience in creating, managing and resolving TAR/SR (Technical Assistant Request or Service Request) with Oracle Support. Managed and monitored TAR’s for several P1 issues.
• Worked extensively in Data Warehousing environments to handle bulk loading of data.
• Worked in designing various Technical and Functional DocumentslikeBR100, MD070and MD120 and Conversion MappingCV060usingAIMMethodology.
• Experience in design and development of inbound and outbound interfaces integrating Oracle Apps with Legacy System using SQL*Loader.
• Demonstrated ability to identify root causes/ debugging of problems and troubleshoot, considering both long and short-term impact of proposed solutions and developed workable solutions.
• Excellent technical background for the accurate evaluation of customization efforts. Strong business, analytical and technical problem solving skills.
• Excellent verbal and written communication skills with leadership qualities, analytical and problem solving skills and open to innovative ideas to develop a creative solution for challenging client needs.

TECHNICAL SKILLS

ERP: Oracle EBS (12.0.3) /11i (11.5.8, 11.5.9,11.510.2)/11.0.3

Modules: (GL, AP, AR, FA), Supply Chain -- (INV, PO, OM), Manufacturing - (BOM, WIP),CRM,ASCP,iProcurement,iExpenses, Service Contracts, TeleService, iSupport.

Tools: Toad, SQL * Loader, PL/SQL Developer, Discoverer, Data Loader BI/XML Publisher, Load Runner

GUI: Developer 6i, Developer 2000,Forms 6i/10g, Reports 6i/10g

Programming Languages: SQL, PL/SQL, C, C++, Java, HTML5, PHP, UNIX Shell Scripting

Databases: Oracle 11g/10g/9i/8i, MySQL, MS Access

Reporting Tools: Reports 10g/6i, XML/BI Publisher, Oracle Discoverer 10g/9i, Workflow builder

Operating Systems: Windows 98/2000/NT/XP/7/8, Unix(Solaris, HP-UX), Linux

PROFESSIONAL EXPERIENCE

Confidential, Teaneck, NJ

Sr.Oracle EBS Consultant

Responsibilities:

• Worked with R12 implementation team in Accounts Payables (AP), Purchase Order (PO), EB Tax, General Ledger (GL) & iExpenses modules in Multi-Org environment
• Created intercompany transaction, consolidation, elimination entries setups and configuration for use.
• The use of ADI wizards like Budget wizard, Journal wizard, report wizard simplified work with general ledger
• Customized requirements, reviewed & maintained AIM documents and configured INV, WIP, BOM modules in SCM environment
• Worked on Oracle Application Framework (OAF) to develop custom solutions for iExpense and iProcurement module.
• Development involves analysing MD50 (Functional Spec) and then writing MD70 (Technical Spec) rendering) select option, committing data through EO (Entity Objects)
• Implementation of Oracle Payables including setup of payment options, payment terms, distribution set, payment format, banks, expense report templates, matching options, tax codes
• Creating New Forms, Menu Items, and Defining Concurrent executables, Concurrent Request for Customized Oracle Forms Applications, Oracle Reports, Oracle PL/SQL procedures and packages for Oracle 11i Application extensions
• Developed Custom Forms and reports for CRM modules as per customers’ requirements
• Created new OAF pages which includes custom simple search, advanced search, PPR (partial page
• Importing and exporting data in and out of the CRM on demand system in MS Excel format
• Developed UNIX Shell scripts to FTP the Flat file from External Server to Oracle UNIX Server location
• Involved in setting up Key Flex fields, Descriptive Flex fields, Special information types, extra information types for HRMS module and maping of Costing fileds with Oracle finantial
• Implemented Order to Cash (O2C) modules: Order Management (OM), Inventory (INV), Warehouse, Purchasing, Receiving and module integrations with Order Management (OM), General Ledger (GL), Accounts Receivables (AR), Cash Management (CM) and Inventory (INV) with in EBS System
• Developed Employee Interface where the data will be extracted from other system called EPIW through DB link and used standard HRMS APIs
• Involved in implementing and providing support for the Financial Statement Generators, AGIS and consolidations
• Setup of Procure to Pay (P2P) modules: Inventory (INV), Purchase Order (PO), Payables and module integrations with Order Management (OM), General Ledger (GL), Accounts Payables (AP) and Inventory (INV) with in EBS System
• Interacted regularly Order Management (OM) Team, Accounts Receivable (AR) and Accounts Payable (AP) departments to review EDI systems in place, and troubleshoot any discrepancies or problems
• Developed custom Forms and Reports as per client requirements and making them web enabled using Oracle Reports builder 10g and Oracle Forms builder 10g respectively
• Supported Procure to Pay (P2P) and Fixed Assets (FA) issues with month end and additional configurations
• Developed Employee Interface where the data will be extracted from other system called EPIW through DB link and used standard HRMS APIs for the creation/update of employee, employee addresses, employee locations and manager assignments.
• Reviewed and approved any configuration change documentation for General Ledger (GL), Cash Management (CM), Accounting Receivables (AR) and Accounting Payables (AP)
• Used Informatica power center for (ETL) extraction, transformation and loading data from heterogeneous source systems
• Carrying out Users Acceptance Test (UAT) scripts, go-live activities and Post implementation support
• Undertook performance-tuning activities on the Oracle EBS applications, concurrent manager and with exceptions the database tier
• Provided daily user support for fianancial modules as and when required to resolve the application issues

Environment: Oracle Applications R12, 11.5.10.2 (GL, AR, AP, Purchasing, OM, INV, PO), Reports 9i/10g, Forms 9i/10g, Oracle 10g, SQL*Loader, Toad, Workflow, UNIX, XML Publisher, Discoverer

Confidential, NY

Sr.Techno-Functional Consultant

Responsibilities:

• Worked on different reports involving different modules like OM, AP, AR, GL, INV.
• Worked on physical data modeling and involved in developing database by PL/SQL, functions, procedures, triggers, packages and materialized 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.
• 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.
• Developed executive level reports for Inventory listing, Inventory wholesale value, Inventory retail value, listing by quantity, listing by cost, listing by date using Reports Developer 6i, Discoverer 4i.
• 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.
• Involved in troubleshooting issues including creation/follow-up of Oracle service requests (SRs). Conducted quality reviews of code developed by other development staff.
• Worked extensively on the general ledger systems of the client.
• Made sure that the configurations (GL/AP/AR/iReceivables/iExpenses) are streamlined and optimized
• Customized Approval workflow for adding email notification workflow function for changed process.
• Customized the existing workflow by adding notifications at the time of
• Raising TARs with oracle for different issues and following up till resolution
• Involved in process to validate receiving data, insert data into interface tables and call receiving transaction processor and concurrent program
• Wrote technical design documents MD-70 for conversions, extensions, interfaces, and reports.
• Customizations of Functional specification MD-50 & also Development of customization requirements.
• Resolution of issues raised during CRP sessions by Managers, key users, end users and regression testing team.
• Developed forms to correct errors in interface process which are used to correct errors in staging and interface tables.
• Created output format in XML/BI, new templates for XML/BI Publisher to display the reports in client requirement format.

Environment: Oracle E-business Suite11i, Account Payables, Accounts Receivable, Inventory, Order Management, WIP, Oracle 9i, XML/BI Publisher Discoverer 6i, Reports 6i, SQL*PLUS, SQL*Loader, TOAD, UNIX.

Confidential, CA

Sr. Oracle Techno Functional Consultant

Responsibilities:

• Performed GAP Fit analysis, made design recommendations, and conducted architecture reviews
• Guided technical teams with the setup, interfaces, conversion, reports, and other adhoc needs
• Streamlined process tracks - Procure to Pay, Acquire to Retire, Book to Report, Bill to Collect
• Understood business architecture methodologies and defined process models to support cross functional work streams
• Worked on the Production support tickets that involve customizing the packages related to Financials (AR, AP) and OM.
• Understood business needs and made application configurations (entitlements, setups, flex-fields, sub ledgers, reporting ledgers, custom libraries, profile options, forms, reports)
• Created design documents, business requirements, technical specifications and test plans
• Managed fellow consultants - resource planning, work allocation, and coordination
• Reviewed requirements with legal and compliance to obtain signoff
• Worked for Procure to Pay (P2P) Process and Order to Cash (O2C) Processes and module integrations with Accounts Receivables (AR), General Ledger (GL), Accounts Payables (AP), Order Management (OM) and Inventory (INV) with in EBS System
• Assigned to the implementation of Oracle 8I database for HRMS/PAYROLL on UNIX platform
• Provided application demos, presentations, and status reports to senior management
• Trained resources, interviewed candidates, and played key role in improving team morale.
• Maintained excelled relationship with end users by establishing credibility and being a good listener
• Created user documentation and provided training
• Spent time with end users and tech teams to understand business processes, supporting applications
• Prepared and presented Business Case to senior management for proposed solutions highlighting benefits, costs/savings, risks, etc.
• Lead user sessions for requirements, functional design, user cases, process diagrams, test plans

Environment: Oracle Financials EBS R12 GL/AP/AR/FA/CM/XTR/iReceivables/iExpenses, SQL Plus, Java, Java script, WebSphere, Oracle db, XML Publisher, Oracle Discoverer, Visio, RUP, Agile, Quality Center

Confidential, Reno, NV

Sr. Oracle Functional Analyst

Responsibilities:

• Involved in requirement gathering, design and development of functional specifications for General Ledger (GL), Accounts Payables (AP), Accounts Receivables (AR), Purchase Order (PO) and Fixed Assets (FA) modules
• Conducted Business Process Review (BPR) and GAP analysis to determine business requirements and prepared documentation accordingly
• Implemented General Ledger (GL) by defining chart of accounts, calendars (Accounting & Transaction), currency types, conversion periods, conversion rates, flex fields and values sets to deal with multi-currencies
• Involved in set up for consolidations and customizing FSGs and generating reports using RXi Reports tool along with month end close processes for GL and sub-ledgers
• Implemented Purchasing (PO) module by setting up organizations, inventory organizations, locations and customers, buyers, payables options and purchasing options
• Performed buyer set up to facilitate PO creation and approval process by defining various approval groups and approval limits with default approval routing hierarchies
• Acted as a liaison between the client and technical team to enable product development with a close fit to client requirements

Confidential

Techno-Functional Consultant

Responsibilities:

• Worked with the functional team while extracting non-Oracle data and Converting to Oracle with validations.
• Upgrade of 11i Custom objects from Release 11i (11.0.3) to 11.5.10.2 in all modules.
• Developed Sales order conversion using standard API.
• Developed Purchase order conversion using standard interface.
• Worked on Customer conversion to import data from Legacy System into Oracle Account Receivables by using Customer Interface.
• Created SQL*Loader control programs and validation procedures to execute along with Customer Interface (AR).
• When an item is created in inventory, workflow needs to be launched and it should collect the details of the item created and sends a notification to group of users along with the details and link to master item form.
• Developed PL/SQL Packages, Procedures, Functions for validating the invoices and payment information from the legacy system and imported into Oracle Applications using the Payables Open Interface Import program and populated the base tables, which involved in Releasing Invoices from Hold, Approval of invoices and creating of New Invoices.
• Developed Warehouse Rules and Production Batches interfaces in OPM.
• Extracted data from AP tables and sending a flat file (checks cut in a period) using UTL FILE package at periodic intervals.
• Involved in Custom.pll and Form personalization.
• Tuned the reports to improve performance.
• Developed the reports and Forms as per the current requirement by using reports6i and Forms 6i.
• Uploaded all the concurrent program details into another instance by using FNDLOAD commands.
• Validated test scenarios and test cases to ensure that the delivered unit is valid after incorporating the changes.

Environment: Oracle Apps Implementation Release (11.5.10.2), Oracle 10g, PL/SQL, SQL

Confidential

Jr. SQL Developer

Responsibilities:

• Performed daily monitoring of databases for availability and performance metrics
• Reviewed log files from overnight and batch processes for significant events
• Review SQL and PL/SQL for Production and sub-environments to ensure accuracy and optimization
• Manage and monitor failover/standby environments for the production system
• Designed, tuned and developed packages, procedures and functions to perform database activities
• Assisted in optimizing existing SQL, PL/SQL packages
• Developed work flow diagrams, data flow diagrams and data mapping documents
• Assisted Database Administrators, Web Administrator, Release Manager, Quality Assurance Manager, and other ITO staff, as warranted to expedite software fixes that affect production, data quality, and access