SUMMARY

• 13+ years of experience as Techno - Functional Consultant in implementation, upgrade and customization of Oracle e-Business Suite of Applications Release R12 (12.1.3), 11i (11.5.10.2) and 11i (11.5.9).
• Highly motivated, enthusiastic professional with a high degree of commitment to succeed. Worked in different capacities in the area of designing, coding, documentation and implementation of projects using Oracle EBS 11i and Oracle EBS R12.
• Worked extensively in Oracle EBS RICEW (Reports, Interfaces, Conversions, Extensions and Workflows), OAF pages customizations and development of Interfaces using SOA/BPEL.
• Experience working as a Functional consultant, Techno Functional consultant. Experience handling project technically and functionally. Worked for 7 implementation projects.
• Worked on developing Oracle APEX Forms and Reports using Oracle Application Express version 5.0,
• Developed New Mobile Supply Chain Application (MSCA) pages for Shop floor yield enhancements.
• Profound knowledge in implementation, Migration, Customization and Production support of various EBS modules including Trading Community Architecture (TCA), Accounts Receivable (AR), Order Management (OM), Shipping (WSH), Advanced Pricing (QP), Inventory (INV), General Ledger (GL), Fixed Assets (FA), Oracle Projects (PA), Purchasing (PO), Account Payables (AP), Service Contracts (OKS), Install Base (IB), Bill of Materials (BOM), eBtax, XLA(Sub Ledger Accounting), HRMS and Application Object Library (AOL).
• Proficient in forms customization using Custom.pll and Forms Personalization.
• Experience in Workflow Business Events and XML publisher bursting.
• Experienced in Tuning of SQL queries and PL/SQL code.
• Developed Interfaces using APIs and Interface tables
• Proficient in writing UNIX shell scripting.
• Sound functional knowledge of Order to Cash (O2C), Plan to Manufacture (PTM) and Procure to Pay (P2P) life cycles.
• Proficient in development of interfaces and conversion programs to integrate Oracle Applications modules to import data from various sources into Oracle Applications using PL/SQL, SQL*Loader.
• Good experience in Production support projects.
• TEMPHas good Knowledge on DB, File and JMS adapters.
• TEMPHas good knowledge in XML, XPath and WSDL.
• Ability to work under pressure in fast-paced, time-sensitive environments
• Developed Inbound and Outbound interfaces using SQL*Loader, UTL FILE, PL/SQL Packages and SOA/BPEL.
• Sound knowledge of Oracle Application tables, Schema, Interfaces, Application Program Interface (APIs) and MOAC.
• Documentation experience, keeping in line with the AIM Methodology (MD70, MD50, CV040, CV060 MD120).
• Experienced in Oracle Sysadmin and AOL - Registering Concurrent Programs, Request Sets, Form Functions, Creating Users, Defining Profile options and creating context sensitive DFFs using Application Developer & System Administration.
• Ability to work on Oracle ADF and Oracle SOA 11g Mediator, DB Adapter, BPEL and OSB.
• Well versed in the Code Migration process, efficiently utilizing Version Control software like Rational Clear Case, Tortoise SVN, HPQC and Kintana and creating Promotion/Migration documents.
• Well experienced in writing custom classes using core Java API, including JDBC, input/output streams and Servlets classes.
• Experienced in various test cycles like Unit Testing (UT), System Integration Testing (SIT), User Acceptance Testing (UAT) and Testing Strategy like entry/exit criteria, test plan, test scenarios and test cases.
• Having Technical and functional knowledge which gives an edge over others to understand and troubleshoot the problem TEMPeffectively. Experience in training End-user and supporting ERP systems.
• Experience in creating, managing Oracle Service Requests through Meta link.
• Extensively used Technical Reference Manual and Metalink to debug technical issues.
• Ability to work directly with business users to elicit business requirements, analyze/translate into functional requirements and develop specifications to meet deadlines and handle multiple tasks, decisive with strong leadership qualities, flexible in work schedules and possess good communication skills.
• Good in designing and developing:
• Reports using Report builder, XMLP, BI Publisher
• Interfaces using SOA/BPEL, SQL, PL/SQL, UNIX
• Conversions using SQL, PL/SQL, SQL*Loader
• Extensions using D2K Forms, OAF Forms, Workflows.
• Enhancements/Customizations using ADF Forms, D2K Forms, CUSTOM.pll, Forms Personalization, OAF personalization, Workflows and AME.
• Oracle APEX Forms and Reports using Oracle Application Express version 5.0
• Ex-employee of Deloitte, Confidential (erstwhile Sierra Atlantic), Confidential, Confidential (CSC).

TECHNICAL SKILLS

Oracle Applications: Techno-Functional Consultant

RDBMS: Oracle 11g, Oracle10G & Oracle 9i

Languages & Frameworks: PL/ Sql, Java, JavaScript, HTML, JDBC, OAF and Oracle ADF. Oracle SOA/BPEL.

Tools: Oracle Workflow Builder, Jdeveloper, Oracle Reports Developer, Oracle Forms Developer, SQL Developer, TOAD, SQL*Plus, SQL Loader, Kintana, WinSCP, Putty and HP Quality Centre..

Operating Systems: Windows, UNIX, DOS.

PROFESSIONAL EXPERIENCE

Confidential, Sacramento, CA

Oracle e-Business Suite Financial Consultant

Responsibilities:

• Perform data analysis and mapping activities in support of conversion efforts.
• Identify Oracle E-Business Suite data fields that will be extracted into a staging area.
• Collaborate with users to analyze current operational procedures, identify problems and learn user requirements.
• Lead and execute with CLIENT SME’s and consultant’s data mapping of legacy data to new client conversion formats.
• Perform data extraction and cleansing activities in support of conversion efforts.
• Create technical design documents for each data extract program written.
• Create, write and test data extract programs for each of the data elements identified in the conversion effort.
• Create data validation routines to ensure conversion data meets quality thresholds.
• Support and modify the data extract programs through the CLIENT conversion effort.
• Guide and assist CLIENT staff by providing expert knowledge for interactions with the System Integrator on issues regarding legacy systems data cleansing and other data migration activities.
• Provide knowledge transfer and documentation to CLIENT technical staff for each of the data extract programs and cleansing routines developed.
• Work with data owners to verify and obtain approval to ensure that any transformed data retains its accuracy.
• Take ownership of design, development and testing of all data transformation, extraction and migration activities.

Environment: Oracle Applications 12.1.3 (Oracle Projects, Account Receivables, Account Payables, Oracle Financials), SQL/PLSQL and UNIX.

Confidential

Technical Consultant

Responsibilities:

• Interact with Client stake holders to understand functional requirements.
• Build technical design and development activity for proposed RICE Components.
• Developed new OAF Page which lists down the details of Credit Memos pending for current user approval.
• Design and develop Custom objects based on Client requirements.
• Built interfaces using SQL/PLSQL, WEB ADI, SOA/BPEL processes.
• Developed various inbound and outbound interfaces, which are run on the periodic basis, including Journal Import in GL, GL Journal Export to Concur interface, Supplier Outbound extract, PO and Invoice Import, Payments Extract, AR Transactions import, Item Import in Inventory, Sales Order Import, Requisitions Import from Order Management for Back to Back sales Orders etc.
• Developed New Mobile Supply Chain Application (MSCA) pages for Shop floor yield enhancements.
• Developed custom reports using Report Builder and XML Publisher. Some of the reports include Natural Account report, Un-posted Journal entries, GL interface report, Customer Outstanding report, Open Order report, Cost Tracking report.
• Designed and developed interface process to import invoices information from third party legacy systems into Oracle payables on a daily basis. Automated the process of file handling, data validation and load into the interface tables and created request sets to submit import process along with the File handling, SQL*LOADER, Data validation and loading.
• Developed New Oracle APEX (Application Express ) Forms and Reports.
• Personalized Oracle Core Forms by using Form level, Item Level and Block Level Triggers in several modules such as AR, AP and OM, as per the Business requirements.
• Prepared Deployment/Promotion and integration documents for moving custom objects from the development instance to production after coding/ testing. Extensively used Rational Clear Case for Version control and Kintana for code migration.
• Utilized FND LOAD utility, for migrating AOL objects from one instance to other, including menus, responsibilities, Form Personalization, Flex-fields, lookups and Concurrent Programs.
• Authored Technical Specifications for various custom Extensions, interacting with users on a regular basis.
• Monitor offshore team with work allocation, design and deliverables. Support users mainly by providing adhoc reports and answering user queries and issues.
• Developed custom forms to trigger and monitor price extensions and custom order creation processes.
• Defect fixing.

Environment: Oracle 12.0.4, MSCA, Supply Chain Modules, Order to Cash, Order Management, Manufacturing(Inventory, Routings, Bill of Materials), Oracle Financials, SQL/PLSQL, Oracle Forms/Reports, Unix, SOA/BPEL 11g

Confidential, Foster City, CA

Techno-Functional Consultant

Responsibilities:

• Built interfaces using PL/SQL and SOA/BPEL processes.
• Worked on raising SR's with Oracle Support and followed in resolving.
• Provided regular metrics on open, resolved and closed issues.
• Propose process /functionality changes or upgrades to business process.
• Maintained historical records of problems solved and recurring issues to build a knowledge base for future issues.
• Working on minor and major Change requests.
• Involved in Performance tuning of PL/SQL programs/Reports.
• Worked on interfaces involving Workflow Business Events and SOA/BPEL processes.
• Developed new XMLP reports and concurrent programs.
• Involved in customizing workflows in Purchasing (PO), Order Management (OM), and Project Accounting (PA) modules.
• Building use cases and unit testing scripts.
• Create ITSM change requests and present the change requests for new/modified custom objects in CAB meetings.
• Support during month-end closing. Assisted users in completing the transactions.
• Mentoring junior team members and assisting them in resolving various technical/functional issues.
• Review business requirements and helping business to create BRDs ( MD050s ) for new RICEW components.
• Prepared Deployment/Promotion and integration documents for moving custom objects from the development instance to production after coding/testing. Extensively used SVN Tortoise for version control.
• Utilized FND LOAD utility, for migrating AOL objects from one instance to other, including menus, responsibilities, Form Personalization, Flex-fields, lookups and Concurrent Programs.
• Authored Technical Specifications for various custom Extensions, interacting with users on a regular basis.
• Monitor offshore team with work allocation, design and deliverables and ensuring Deloitte Quality Standards are met. Support application users by providing adhoc reports and answering user queries and issues.
• Resolving P1 (Priority 1), P2 (Priority 2), P3 (Priority 3) and P4 (Priority 4) issues for OTC Order to Cash, PTM Plan to Manufacture, RTR Record to Report, PRJ Projects and PTP Procure to Pay tracks.
• Worked on P5s (These are Enhancements to current functionality) for all the tracks (OTC Order to Cash, PTM Plan to Manufacture, RTR Record to Report, PRJ Projects and PTP Procure to Pay tracks).
• Worked on CIs (Continuous Improvements) for the Business Process for Gilead.
• Ensured prompt resolution of issues and participated in formation of technical solutions.
• Worked extensively as functional consultant for OTC Order to Cash and PTM Plan to Manufacture tracks

Environment: Oracle 12.1.3, SQL/PLSQL, SOA/BPEL, AME, Oracle Reports, Unix, Supply Chain Modules, Order to Cash(Inventory, Order Management), Oracle Purchasing, Oracle Financials modules.

Confidential, Jasper, Indiana

Techno-Functional Consultant

Responsibilities:

• Coordination with Functional Team and Client Key users for Gathering requirements, analyzing, solution design & deliverables.
• Worked on development and modification of XML/BI Publisher, Oracle Alerts, Form Personalization, Interfaces, Conversions, Unix Shell Scripts, Customization of Standard PL /SQL Programs, AOL, OM & SYS Admin Tasks.
• Performance tuning of PL/SQL programs, forms and reports.
• Designing, development and providing support of various interfaces,
• Extensions, and reports involving Order Management, Shipping,
• Build and maintain repository for deliverables & business development documents.
• Development of new enhancements as and when need arises from the business and proficient in Post-production activities.
• MD50 Review, preparing MD70, Test Plan, Updating of MD70 / UTP, final Testing and review (MD70/UTP/CODE), Code review as per Code review check list.
• Interacting with functional BA on designing and proposing the technical solutions.
• Clarifying any gaps in requirements with business users.
• Co-coordinating with offshore team explaining the design and make sure about object delivery within time frame by daily attending handshaking calls with offshore team.
• Designing Technical solutions, Coding, Self testing and filling up Test Results.
• Interacting/Coordinating with other technical teams on objects delivery and issue resolution.
• Peer Review and helping other team members.
• Go-live support and post-go live support.
• Imparting training to users.
• Worked on technologies Forms, Custom.pll,forms personalization, Reports, XMLP, BI Publisher, OAF, WF, PL/SQL concurrent programs.

Environment: Oracle R12, SQL, PL/SQL, Oracle Reports, XML Publisher, JDeveloper 11g, Unix, Order to Cash, Supply Chain Planning, Procure to Pay, CRM, Inventory, Costing, Advanced Pricing, Material Planning, Bills of Material(BOM), Routing, Work in Process(WIP), Engineering, Order Management, Sales Order, Purchasing, Accounts Payables, Accounts Receivables, General LedgerJune 2010 - April 2011

Confidential, Phoenix Arizona

Techno-Functional Consultant

Responsibilities:

• Involved in Data mapping of Oracle functionality with Business requirements, historical conversions, interfaces and customizations.
• Participated in the design discussions of the project, contributing to deliverables like to-be process flows.
• Developed custom web pages with OAF technology.
• Understanding and developing technical design documents.
• Creating unit test plan and Unit Testing.
• Interacted with functional team, track leads and core business analysts for MD.050 sign off and to gather technical requirements in depth
• Coordination of RICEW design, development, testing and delivery with offshore team.
• Conducted review and audit on technical designs to ensure the Deloitte’s quality on client deliverables.
• Status update to key stake holders on daily/weekly basis regarding RICEW development and other risks associated.
• Managed RICEW development, delivery schedules and quality of deliverables.
• Interaction with functional person to understand the client’s requirements and functional design document (MD050)
• Enhancements/Creation in XML Reports, PLSQL Reports, Workflows etc
• Preparing Functional Designs and Technical Design documents. Acting as a Team lead to ensure the deliverables are delivered on time and with high quality.
• Worked on BOM Routings Conversion, Purchasing Quotations Conversion, Sourcing Rules and Sourcing Assignment Sets Conversion, Proforma Invoice Report and Commercial Invoice Report, COGS Account Generator Workflow.
• Involved in Post Production Support

Environment: Oracle Application 12.0.4, PL/SQL, Forms & Reports, XML Publisher, Discoverer 10g, Unix, Order to Cash, Order Management, Advanced Pricing, Oracle Quoting, Inventory, Purchasing, Accounts Payables, Accounts Receivables, Material Planning, Bill of Material (BOM), Routing, Work in Process (WIP), Install Base

Confidential, Houston, Texas

Techno-Functional Consultant

Responsibilities:

• MD50 Review, preparing MD70, MD120, Test Plan, Updation of MD70 / UTP, final Testing and review (MD70/120/UTP/CODE), Code review as per Code review check list.
• Issue resolution with onsite designer.
• Actively participate in forming the technical solution by working with on-site team to understand the functional design.
• Designing Technical solutions, Coding, Self-testing and filling up Test Results.
• Peer Review and helping other team members.
• Co-ordinate with end user and gather business requirements. Create technical documents.
• Coding and creation of workflow, Reports and PL/SQL programs.
• Create unit test cases and perform testing.

Environment: Oracle Applications 12.1.3, Oracle Workflow, Oracle Reports, Oracle Alerts, SQL, PL/SQL, Inventory, Order Management, Sales Order, Advanced Pricing, Bill of Materials (BOM), Routing, Purchasing.

Confidential, Houston, Texas

Techno Functional Consultant

Responsibilities:

• Gathering business requirements from onsite counter parts, and involved in designing MD050 documents.
• Review functional design documents.
• Identify potential risks and recommend issue resolutions.
• Business process analysis include understanding the existing business processes and designing the future processes with the standard Oracle functionality.
• Involved in reviewing the FD’s drafted version and responsible for maintaining issue logs.
• Managed offshore team of 10 Oracle EBS technical consultants.
• Perform peer reviews of Functional Designs, Technical Designs, Code and Installation Documents. Build and review code Involved in design, development and support.
• Design Interface development standards.
• Support to onsite during Integration testing phase
• Understanding the requirements, developing and reviewing the Technical Design document.
• Prepare Unit test cases and perform testing.
• Involved in Conference room pilot (CRP) testing.
• Coding and Review of code based on the Technical design documents.
• Creation of Interface and conversion programs to migrate data from Legacy system to Oracle Applications.
• Creation of UNIX Shell scripts.
• As a Team Lead, Developer and Designer, responsible for Development of Conversions, Interfaces, Extensions and BI publisher Reports. Below are my key responsibilities in this project:-
• Understanding the Functional Specifications (MD050).
• Preparation of Technical Design Documents (MD070).
• Conducting code Review of other developer’s programs
• Preparation of Installation Documents (MD120)
• Preparation of Unit Test Plan (UTP) Documents.
• Assigning work to resources
• Customer Conversion/Interface.
• AR Transactions inbound interface.
• GL Balances Conversion/Interface.
• Upload tax book Assets Interface.
• Install Base/Asset Tracking module’s custom programs.
• Inbound Journal import interface.
• Fixed Assets module custom programs.
• Created AutoLock box interface to upload files provided by banks.
• Asset Audit Report.
• Asset Sold To Report.
• Asset Details Report.
• AP Invoice Distribution Report.
• Requisition Account Generator Workflow customizations.
• PO Account Generator Workflow customizations.
• Project Supplier Invoice Account Generator Workflow customizations.
• New OA Framework Page: "Asset Disposional Approval Page" for disposing of the assets.

Environment: Oracle Applications 12.0.4, SQL, PL/SQL, Oracle Forms and Reports, Unix, Order Management, Inventory, Bills of Material (BOM), Routing, Work in Process (WIP), HRMS, Purchasing, Accounts Payables, Accounts Receivables, General Ledger (GL), Order to Cash and Procure to Pay.

Confidential, Boston, Massachusetts

Techno-Functional Consultant

Responsibilities:

• Working on Conversions, XML Publisher Reports, Interfaces, Form Personalization’s and Alerts which are required for Confidential Business needs as a part of the implementations project.
• Acting as a “Team Lead” for Technical Team involved in the Implementation Project. Also done work on “Chart of Accounts” restructuring based on the Confidential needs for the already existing Cantata’s E-Business Suite of Oracle Applications Ver 11.5.10.2.
• Created “As-Is” and “To-Be” (Gap - Analysis documents) system documents to show the current state and future state processes and functionalities of the system

Environment: Oracle 11.5.10.2, SQL, PLSQL, Oracle Reports, BI Publisher, Supply Chain Planning, Procure to Pay(PTP), Order to Cash, Order Management, Inventory, Purchasing, Accounts Payables, Accounts Receivables, CRM(Install Base, Field Service and Service Contracts).

Confidential, Bedford, Massachusetts

Technical Consultant

Responsibilities:

• me was involved in the Phase II of the project which TEMPhas customizations/new developments on Workflows, XML Publisher reports, JSP pages for Quote module, forms etc.
• me was also involved as the “Team Lead” for Confidential AMS Project Application Maintenance and Support after the go-live that TEMPhas happened in May, 2008

Environment: Oracle 11.5.10, Oracle Reports, SQL, PL/SQL, Order Management, Inventory, Bills of Materials (BOM), Routing, Quote, Work in Process (WIP), Purchasing, Accounts Payables, Accounts Receivables, General Ledger(GL)