SUMMARY:

• Over 9 years of Oracle AppsTechno - Functional experience, that includes Development and Maintenance of various programs in AP, AR, GL, FA, OM, PO, INV and HRMS modules.
• Functional Knowledge in Oracle Payables, Oracle Receivables, General Ledger, Order Management modules with touch points in Purchasing, Inventory, Fixed Assets and Cash Management.
• Skilled in Oracle Applications - 11i, R12 E-Business Suite.
• Experience of Development, Interfaces & Data Conversion, Implementation, Customizations of Oracle General Ledger, Accounts Payables, Accounts Receivable, Fixed Assets, Purchasing, Order Management, Inventory modules.
• Expertise in Analysis, Customizations, Localizations, Migrations, Conversions, Interfaces and Implementation in Oracle Applications 11i (GL, AP, AR, FA, CM, OM, Service Contracts, Purchasing, Inventory, AOL, System Administration, Workflow, Oracle Applications Programming Interface (APIs), Custom PLL and Open Interfaces).
• Extensive Experience in SQL, PL/SQL Programming, Oracle Reports, SQL Loader, Interfaces, Oracle Forms, XML Publisher Reports (Data templates and RTF templates), Discoverer Reports, BI Publisher 11g, and OBIEE 11g.
• Good understanding of the functional flow in Oracle Applications on Procure to pay (PTP) and Order to Cash (OTC) Cycle.
• Experience in performance and tuning (PL/SQL) using SQL Trace, Explain Plan, TKPROF, Indexing and Hints.
• Extensive experience with Trading Community Architecture (TCA), including HZ APIs.
• Prepared technical design documents for customizations and conversions using AIM documentation methodology (MD050, MD070, CV040, BR100, MD120, and CV060).
• Proficient in writing stored procedures, Packages, Functions and Database Triggers using SQL & PL/SQL.
• Experience in creating SQL*Loader control programs and PL/SQL validation scripts for validating and pre-import processing legacy data from feeder systems to Oracle Applications.
• Developed OBIEE dashboards for manufacturing team to review their sales data.
• Worked in the Onsite-Offshore model and have experience managing remote teams.
• Worked on OA Framework to develop self service pages.
• Fair Knowledge of ADF/SOA.
• Experience in reporting tools like ERWIN for database designing and modeling.
• Good at working as a team player/Technical Lead and also under less supervision.
• Excellent time-management and task-management skills.
• Self-motivated, excellent communication, analytical, interpersonal and presentation skills.

TECHNICAL SKILLS:

Oracle Apps Versions:  R12 & 11i

Oracle Apps Modules:  GL, AP, AR, FA, SLA, PO, SCM, HRMS,OPM, iProc, iExp, iSupplier, eBtax, APPLICATION DEVELOPER, SYSTEM ADMINISTRATION

Apps Technical:  Oracle Forms (6i/9i/10g), Oracle Reports (6i/9i/10g), Oracle Workflow Builder, XML/BI Publisher, JDeveloper, SHH, PuTTY, SQL, PL/SQL, UNIX, Shell Scripting, XML, HTML, C and JAVA

Environment:  Windows 98/XP/ 2000/2003/2007 server,UNIX (HP-UX), Linux, MS-DOS

Databases:  ORACLE 8i/9i/10g/11g and MS Access

Database Tools:  Toad, SQL*PLUS, SQL*LOADER, SQL Developer

PROFESSIONAL EXPERIENCE:

Confidential,California

Oracle Techno Functional Consultant

Responsibilities:

• Regular meetings with the business users.
• Gathering requirements and preparing MD 50, MD 70.
• Assigning tasks to the developers in offshore.
• Analyzing the requirements.
• Worked on complex configurator models.
• Worked on complex functionality ATP dates in configurator.
• Worked on P2P modules and conversions
• Worked in modules Configurator, OM, INV, PO, AP, and AR.
• Worked in JAVA coding developed JSP pages.
• Done functional setups in Order to cash and procure to pay cycle.
• Involved in DBA tasks.
• Involved in performance tuning of sql queries.

Environment: Oracle applications EBS 11i (11.5.10), R12, GL, PL/SQL, SQL*Plus, TOAD, Developer 2000(Reports 6i/10g and Forms 6i/10g), Oracle Designer 6i/10g, OAF, SQL Developer, XML Publisher, BI Publisher, SQL*Loader, Windows XP, JAVA.

Confidential,SilverSpring, MD

• Working as a techno functional consultant in Confidential project analyzing GTAS, IPAC, SAM and PAM treasury mandates. Changing the custom solution designs to fit treasury mandates in Oracle Federal Finance.
• Prepared BR 100 documents regarding setup changes and performing the configuration changes in several development, test and production instances in Oracle Federal Vertical.
• Updated As-Is Process Flows and Functional Specification Design documents.
• Involved in trouble shooting
• Analyzed custom value sets, personalizations, lookups for treasury mandates impact and recommended solutions for them.
• Analyzed impact on OpDiv Specific IDDA interface and proposed a Global IDDA solutions that fits treasury requirements.
• Completed design documents for Global IDDA interface.
• Supported FY 2013 Year end activities in monitoring the performance of Confidential Production system
• Performed QA on Global and OpDiv Specific Change requests and provided recommendation to deploy them on time.
• Conducted/Participated in Solution Reviews for PMR's (Problem Management Records) and Working Group Sessions for GTAS
• Functional & Technical Analysis and Troubleshooting of post-production issues on various Business processes

Environment: Oracle EBS Federal Finance Apps 11i, ORACLE 11g, PL/SQL, Toad 9, SQL*PLUS, UNIX.

Confidential, Atlanta, GA

Responsibilities:

• Designed Technical documents (CV60) and developed AR Conversions like Invoices, Receipts, and Resources to bring data from different Legacy systems.
• Designed Technical documents (MD 70) and developed Cash Management Bank statement Interface to load BAI2 files from different banks for reconciliations.
• Developed Custom form to maintain Voucher details, Cost Allocations and mapping to GL Accounts.
• Designed Technical documents and developed Conversions and Interfaces for GL to import Journals from different systems.
• Developed OAF page to view and updated Customer credit rules for Customer holds and generate the reports.
• Created JSP pages to upload files manually to run interface on demand.
• Created Dunning plans for sending custom letters via manual dunning process to 3rd party systems
• Customized OAF Controller class to change the labels by creating messages from Application Developer and assigning default values.
• Publish dashboard reports on current projects and issues. Review escalated Issues and work with the team to ensure a resolution plan.
• Provided Change Management on-call support for Emergency Changes. Processing CAB exceptions efficiently.
• Involved in post Implementation support and providing training to end users.

Environment: Oracle EBS Apps R12, ORACLE 10g/11g, PL/SQL, Toad 9, SQL*PLUS, UNIX.

Confidential, Palo Alto, CA

Role: Oracle Applications Techno Functional Consultant

Responsibilities:

• Developed Custom Interface programs using API’s to update Service entitlements and products in Service Contracts.
• Developed Keystone - TCA-Detailed Customer Master Architecture.
• Developed forms to maintain Customer Volume Purchase Program (VPP), pricing benefits they can get for future orders based on the points earned on existing orders.
• Developed Order import program to create different orders like ELA Order, Redemption, NFR, Downgrade.
• Developed Zoom form in Order manger to get license details for the Customer.
• Issue resolution, incident management, coordinating with Business Analysts and end-users, attending weekly review calls with business, developing hot fixes through e-CAB and taking part in the CAB Review/Approval meeting.
• Customizing Order management workflows as per Business requirement.
• Created outbound Interface to inform consignment suppliers about the item demands.
• Handling quality metric management for tickets by ensuring SLA is met and the key words are in place for tickets.
• Developed Interfaces and reports to accommodate generated flat files to be transferred to external systems using custom UTIL package.
• Customized several reports in OM, INV and Telesales as per Business requirement.
• Developed Custom Interface programs using API’s to update Install Base Parties and Licenses.
• Customized Oracle standard report “Payables Account Analysis Report” to meet the business needs.
• Created PDF/EXCEL output’s for reports based on requirements.
• Created Data fixes in OM, SC, BOM and IB for issues.
• Developed deployment documents for data fixes.
• Developed Workbooks based on the Custom Folders and calculations using Discoverer Desktop.

Environment: Oracle EBS Apps 11i, ORACLE 10g/11g, PL/SQL, Reports 6i/10g, Toad 9, SQL*PLUS, UNIX.

Confidential,Spokane, WA

Oracle Applications Techno Functional Consultant

Responsibilities:

• Coordination of a 7-member development team, evaluate and implement changes to all customizations and extensions.
• Prepared Functional and Technical design Document for Reconciliation Summary and detail report.
• As a technical lead in support analyst I handle escalated issues.
• Handled quality metric management for tickets by ensuring they meet SLA and the key words are in place for tickets
• Managed all development aspects of an Oracle Applications 11.5.10.2 to R12.1.2 upgrade.
• Analysis COA changes (Client Requirement) impact after upgrading.
• Place all new alternate accounts in both setups and open transactions.
• Preparing unit test plan with COA changes and R12 futures.
• Worked on Period closure reconciliation Issues.
• Validating open transactions in all finance modules & matching the same with the GL balances, as part of upgrade activity.
• Customized OAF pages by using personalization in iExpenses.
• Customized standard workflows in Project Accounting for approval hierarchy.
• Implementation of Search pages in OAF.
• Responsible for modifying & creating Business Areas using Oracle Discoverer Admin for changed & new reports.
• Created Workbooks based on the Custom Folders with multiple parameters and calculations using Discoverer Plus and Discoverer Desktop.
• Responsible for developing new reports in Oracle XML/BI publisher.
• Created output format in XML/BI, new templates for XML/BI Publisher to display the reports in client requirement format.
• Created PDF/EXCEL output’s for reports based on requirements.
• Used the Totals/Subtotals/group/sort features of XML/BI Publisher to make data intense operations happen at the template level.
• Customizing the application forms to meet the specific business needs using built in features available with (Template.fmb) form, built-in stored procedures and attached libraries.
• Involved in the design & development of user interface in Forms and table design using Oracle.
• Developed various Business and ad-hoc Reports.
• Extensively worked in tuning the SQL queries using Explain Plan, Tkprof, SQL*Trace.
• Involved in Interface designing and Documentation and implementation of these as per AIM.

Environment: Oracle EBS Apps R12, ORACLE 9i/10g, PL/SQL, Oracle Workflow, Discoverer, XML/BI Publisher, UNIX.

Confidential 

Oracle Applications Techno Functional Consultant

Responsibilities:

• Developed Interface by using API for creating Notes corresponding.
• Developing components for the Middle Tier using COM implementing various business rules.
• Developed Interface by using API for creating Notes corresponding Customers and Leads.
• Developed Interface by using API for Converting Quotes to Booked Orders.
• Coordinate with Oracle Support determining the bugs incurred in 11i with EVENTS and counters and fix them applying appropriate patches. Resolved issue in Service pricing with oracle support.
• Documentation and maintenance of Technical work done.
• Resolving the issues on Telesales Module.
• Resolving the issues on PO components like Requisitions, Purchase Orders and Receiving.
• Resolving the issues on AP components like Invoices, Payments, and Banks & Suppliers.

Environment: Oracle EBS Applications R12, Oracle Database 10g, Discoverer9i/ 10g, UNIX, BI Reports and Forms.

Confidential 

Oracle Applications Techno Functional Consultant

Responsibilities:

• Developed Interface by using API for creating Notes corresponding.
• Developing components for the Middle Tier using COM implementing various business rules.
• Developed Interface by using API for creating Notes corresponding Customers and Leads.
• Developed Interface by using API for Converting Quotes to Booked Orders.
• Coordinate with Oracle Support determining the bugs incurred in 11i with EVENTS and counters and fix them applying appropriate patches. Resolved issue in Service pricing with oracle support.
• Documentation and maintenance of Technical work done.
• Resolving the issues on Telesales Module, iprocurement and iexpense.
• Resolving the issues on PO components like Requisitions, Purchase Orders and Receiving.
• Resolving the issues on AP components like Invoices, Payments, and Banks & Suppliers.
• Experienced in using the performance tuning methods like TKPROF, Explain plan, Trace and creating indexes.
• Worked on creating application mode End User Layer, building business areas, and building discoverer workbooks.
• Developed reports in AP, GL and AR modules using Reports9i.
• Built custom forms using TEMPLATE.FMB to fulfill the business requirements like implementing the calendar feature, WHO columns, defining DFFs etc.
• Developed the Request sets that are scheduled to submit concurrent programs in a desired sequence as per the functional document.
• Customizing the application forms to meet the specific business needs using built in features available with (Template.fmb) form, built-in stored procedures and attached libraries.
• Involved in the design & development of user interface in Forms and table design using Oracle.
• Experience in customization of XML Publisher reports.
• Created output format in XML, new templates for XML Publisher to display the reports in client requirement format.

Environment: Oracle EBS Apps 11i, ORACLE 9i/10g, PL/SQL, Forms Reports 6i/10g, Toad 8, Discoverer, XML/BI Publisher.

Confidential 

Oracle Applications Techno Functional Consultant

Responsibilities:

• Defining the Approval Group by utilizing the Position Hierarchy.
• Customizing Accounting Flex Fields, Cross Validation Rules and Security Rules.
• Designing and development of customized object/programs in Oracle Database/Applications as per the business requirements and Apps Schema standards.
• Setup transaction types, document numbers, and processing constraints.
• Implementing control points in business processes by developing Form Personalization.
• Created alerts, for sending mails to users and receiving response mails from users.
• Resolving the issues on OM components like Sales Orders and Sale Returns.
• Resolving the issues on AP components like Invoices, Payments, and Banks & Suppliers.

Environment: Oracle EBS Applications Release 11.5.10.2 (CRM), Oracle Database 9i, SQL *Loader, Reports 6i, Forms 6i.

Confidential

Oracle Applications Technical Consultant

Responsibilities:

• Creating Flex fields for Location, Defining Systems Option parameters
• Creating Customers, Profile Classes & Bank information
• Creating Distribution Sets, Receipt Sources, Receipt Classes & Payment Terms
• Defining Application Rule Sets, Auto Accounting Rules & Auto cash Rule Sets
• Creation of Transactions & Source and Customization of check printing report
• Importing Legacy Journals in General Ledger using SQL Loader and Journal Import
• Created BOM Interface using API.
• Created Item and Invoice Interfaces
• Developed interface programs to integrate Legacy System with the AR module to import customer information using the Customer Interface. Defined descriptive flex fields
• Testing and Code review.
• Implementing control points in business processes by developing Form Personalization.

Environment: Oracle EBS Apps R12, SQL, PL/SQL, Oracle Forms 6i, Oracle Reports 6i, Oracle 9i, TOAD and UNIX.

Confidential

Oracle Applications Technical Consultant

Responsibilities:

• Developed Invoice Report in XML Publisher.
• Created Discrete Job Pick List Report using in XML Publisher.
• Created the RMA Received Report using Discoverer4i.
• Created PWAV Commercial Invoice Report in XML Publisher.
• Customized And Developed Many Forms as per Different Client Requirements.
• Created Procedures in Custom.pll.
• Created Personalization in WIP and INV.
• Supporting Production Issues for Inventory, Order management, Install Base and Payables.
• Created Alerts as per Client Requirement.
• Developed Reports in Project Accounting Module by using Discoverer tool.
• Developed Item Cost Interface to update the Item Costs.

Environment: Oracle EBS Applications Release 11.5.10.2 Toad, Shell Scripts, SQL, PL/SQL, Oracle, Oracle Reports 4i, Windows NT/XP.

Confidential

Oracle Applications Technical Consultant

Responsibilities:

• Developed interface programs for upload of GL Interface from legacy system after validate the data.
• Created HDFC AP Withholding Tax Report.
• Created HDFC GL Trial Balance Report.
• Customized Standard Reports in AP, PO in D2K.
• Developed New Reports in GL and AP in D2k.
• Conversion of data from legacy system to Oracle application system by using SQL*Loader.
• Developed New Audit Detail Reports.
• Developed Reports in Property Manager Module by using Discoverer tool.

Environment: Toad, Shell Scripts, SQL, PL/SQL, Oracle, Oracle Reports 4i, Windows NT/XP.