SUMMARY

• 14+ years’ experience in Oracle Applications as a Techno Functional consultant with good knowledge in coding and testing of software applications and having in - depth knowledge in Oracle Application 11i/R12(12.0.6,12.1.1,12.1.3), Framework9i, OAF,ADF,SOA, XML/ BI Publisher, OBIEE, Discoverer10g, Oracle9i/10g/11g, Forms6i/10g, Reports6i/ 10g, Oracle Alerts, Oracle J-developer(10g), Oracle Applications, workflow Builder2.6, PL/SQL, Triggers, Agile Scrum
• Extensively worked in Oracle Applications Release 11i and R12 covering all Financials which includes Oracle General Ledger, Oracle Receivables, Oracle Payables, Oracle Fixed Assets, Cash Management, Oracle Purchasing, I-procurement, oracle order management,
• Experience in coordinating the calls in Onshore and Offshore Teams
• Good Experience in implementing the entire Order-to-Cash (O2C) and Procure-to-Pay (P2P) life cycles
• Experience in creating, modifying Forms6i/10g, OAF pages for extending and customizing applications as per the business needs
• Served as Team lead for multiple oracle implementations and various key projects
• Documenting business requirements, analyzing impact of the changes, preparing functional, technical specifications, developing, configuring and performing unit testing as well as assisting the users in the UAT phase, all of this following oracle AIM methodology.
• Involved in project rollouts and implementations facilitating the better usage of the system, as well as maintenance and support e-business environments by providing techno functional support of operational business implementations.
• Extensive technical experience in RICEW (Reports, Forms, Interfaces, Conversions and Workflows) Components
• Excellent technical skills in developing Extensions, Interfaces and Conversions in the domain of Oracle Applications E-business suite
• Experience working with Oracle Self Service applications, JDeveloper, Key Flex fields, Descriptive Flex fields, Profile Options, System Administrator activities (Creating Users, Responsibilities, Menus, and Functions) and Oracle Concurrent Manager
• Extensive experience in preparation and Review of BRDs, Gap Documents, MD50, MD70, Test Strategy and Test Plan Documents.
• OracleFusionAccounting Hubexperience
• Extensive experience in communicating with users, Functional team to assist them in gathering requirements and preparation of the MD 50 documents
• Sound knowledge of oracle application Framework and MVC architecture
• TCA implementation for exiting reports and forms
• SCM module implementation
• Excellent Communication skills, interpersonal skills and strong analytical & problem solving abilities
• Agile in learning and doing things in effective manner.
• Good working experience in Demantra Demand Management, Oracle Configurator, I-Supplier,I-Procurement, Advanced Product Catalog (APC), Oracle Workflow, XML Publisher
• Expert in using OBIEE Answers to create queries, format views, charts, and add user interactivity and dynamic content to enhance the user experience

TECHNICAL SKILLS

ERP: Oracle Financials: oracle General Ledger(mass, planning and funding budgets ), Oracle payables, Oracle Receivables, Oracle projects, Cash management, Oracle Fixed Assets, I-Expenses, I-Procurement, ME Oracle Distributions: Oracle Purchasing, Oracle order management, I-Procurement Oracle Manufacturing: Oracle Inventory, Oracle order management Oracle SCM: MO, INV, and PO

Technologies: PL/SQL, Reports6i/10g,Forms6i/10g,Sql loader, XML Publisher, Workflow, MS office, Toad, Sql Developer, SQL*plus, Shell Scripting, FND loader script, C, C++, Core Java, JDeveloper, ADF, OAF, Putty, Win sap, PVCS, HTML, DHTML, XML, Kintana, Oracle applications Release R12,115.10.2,11.5.10 &11.5.9, oracle 8i/9i/10g,OraRRP tool, Web logic server, EDI

Web Technologies: HTML, DHTML, XML

Advanced Technical tools: OAF, ADF, SOA, Web logic Server, Forms and Reports 11g,BI Reports, OBIEE, Fusion middle ware

PROFESSIONAL EXPERIENCE

Confidential, New York

Sr.Oracle PL/SQL

Responsibilities:

• Requisition interface done in I procurement module
• Print perchance order
• Change requisition approval workflow notification.
• Developed Advance pricing from in OM
• DMO Chestnut-Wave3 Project includes study of existing systems and retirement of the current legacy systems and transferring the business activities to the Oracle e-Business Suite Applications 11i. The intent is to simplify the business processes, reduce the high maintenance costs and poor reliability in the current environment.
• This project includes the implementation of Oracle 11.5.10 Install Base (IB), Service Contracts (SC), Field Services (FS), Oracle Quoting and Inventory (INV) modules and uploading the data to Accounts Receivables (AR), Order Management (OM).

Environment: OA Framework, Oracle 9i, PL/SQL, Report Builder 6i, Form Builder 6i, XML Publisher, Discoverer 10G

Confidential, Miami, FL.

Sr.Oracle P2P Technical Lead

Responsibilities:

• Analyze the Functional specification received from client.
• Analyze the Business requirement documents and knowledge transfer sessions.
• Customized the workflow for FA Account Generator Process
• Design and developed user interface components usingADF Rich Faces.
• Integration between the java and oracle applications.
• Customizations and personalization for forms and oaf pages.
• Developed xml reports from the foundation
• Designed and developed migration scripts for all activities and GL migration.
• Used SQL *Loader control file to import the customer information provided in the form of flat files into staging tables
• Developed PL/SQL program to perform validations and to relate customers with addresses, contacts, banks and profiles and move the data from staging table to interface tables
• Loaded existing Purchase Orders of the legacy system through SQL* Loader, validated (in AP) whether those PO’s are paid and finally valid entries are recorded in GL. Also, an exception report was created
• Developed custom reports for billing history by client and Invoices by client report using Discoverer.
• Designed and customized the following reports using Oracle Reports Builder 6i in OM and Service Contracts commission payment details form developed at AR
• Developed technical designs for conversion of Oracle EBS extensions utilizing OAF systems. n-line patching actives and automatically deploy code or configurations done at EBS
• Agile methodologies address many situations for which Plan-driven methodologies are not well suited
• Design and developed multiple web (UI) pages usingJSF,ADFRich Faces, JSP and HTML.
• Responsible for developed, invoking and implemented validations onJSFbacking beans.
• Create and monitor a system of controls, procedures, and forms for the recordation of fixed assets.
• Check for completeness and accuracy of fixed assets sub ledger and month-end closing activities such as account reconciliations, journal entries and adjustments
• Take necessary measures to avoid centralization of knowledge. There should not be any dependency in the project on anybody.
• Quality with on time delivery of agreed deliverable
• Team can approach lead any time for any functional or technical concern
• Tech lead requires balancing between technical and leadership talents.
• Lead should Motivate/encourage the team members
• Especially when team is under pressure with the tight deadline
• Lead should share the limelight with the team
• UsedOBIEE Web Catalogto set up groups, access privileges and query privileges
• Implemented security based onLDAP Authentication

Environment: ADF,OAF, Oracle PL/SQL, Oracle E-biz Applications 11i and R12, Oracle General Ledger, Oracle Payables, Oracle Receivables, Oracle Developer 6i (Forms, Reports and Workflow), XML Publisher, Oracle Database, JDeveloper, SQL Navigator, TOAD,OBIEE

Confidential

Sr.Oracle Techno-functional lead

Responsibilities:

• Developed the BI Publisher reports
• Created the suppliers and employers in purchasing module
• As per the new requirement I have incorporated the intercompany logic at all interfaces
• Created the requisitions and purchase orders
• Fixed the issues at workflow packages.
• Personalized OAF page at I-procurement
• Requirement Gathering and Analysis
• High Level Design
• P2P cycle implementation
• Functional and Technical Documentation
• Development and Coding
• Added new DFF fields at Invoice Summery form 6i
• RICE objects developed
• Execute technical release and business cutover plan
• Worked on different BC4J Components for customizations. Extended AM (Application Module), VO (View Objects) and modified the CO (Controllers)
• Don’t blame anybody publicly for anything
• Work as hard or harder than anyone else in the team
• Focus on the technologies associated with the software or application you are building. Learn those technology thoroughly
• Flexible enough to work under different work environments settings

Environment: ADF,OAF, Oracle PL/SQL, Oracle E-biz Applications 11i and R12, Oracle General Ledger, Oracle Payables, Oracle Receivables, Oracle Developer 6i (Forms, Reports and Workflow), XML Publisher, Oracle Database, JDeveloper, SQL Navigator, TOAD.

Sr. Techno-functional Consultant

Responsibilities:

• DevelopedInterface of Sales Orders Import in OMafter actively participating in the preparation of the conversion mapping documents.
• Expert in requirement gathering, design and development of custom applications, customization of OAF pages, extension and creation of new OAF pages in JDeveloper 9i and 10g environment.
• Data conversion can be defined as a process of converting data from one structural form to another to suit the requirements of the system to which it is migrated. Personalizedi-Expense attachment upload page to include “Note” to the users at the organization level.
• EO,VO,CO Extensions on i-procurement and i-expenses modules in OAF/ADF
• Agile Manifesto doesn’t provide concrete steps. Organizations usually seek more specific methods within the Agile movement.Developed Customers and Projects Interface
• Used Pl/Sql developer to import the customer information provided in the form of flat files into staging tables
• Developed invoice holds report using Discoverer.
• Analyze the Functional specification received from client.
• Analyze the Business requirement documents and knowledge transfer sessions.
• Customize and convert existing RDF reports that will run compatible as per the new multi-org structure and user requirement.
• Coordinated with the offshore team to get the requests done.
• Daily Development Interaction with Technical leads for status and any other outstanding issues.
• Worked as a Member of the Production support system to address day to day issues.
• Prepared the Technical Design documents, Installation documents and Unit Test Case documents.
• Implemented procedures for debugging and integration of all assigned software products.
• I-procurement page personalization and Extension of VO/CO
• Created the DFF and KFF flex filed
• In p2p,supplier conversions and banks created using API
• BC4J Components extensions and VO substitutions, Page personalization's
• Supported technical team members for integration functions with web services and business components.
• Design and developed user interface components usingADF Rich Faces.
• Developed UI fragments, templates and bounded task flows using Jdeveloper 11g, trading community arch-structure (TCA) for AR
• Interface between team and management
• Write quality code, set an example of quality in front of the team members
• Gain the team’s respect with the quality of your work and by doing what you are preaching
• Define early on what success means for you, the team and the business
• Set reasonable expectations in front of the team
• Should be part of the design team
• Should have design vision and understanding Be firm but fair Admit your mistakes
• Build and maintain high team morale
• Prepared monthly journal entries to record fixed asset activity
• Reconciled all Fixed Asset accounts
• Developed metadata repository usingOBIEE Administration toolin Physical, Business Model and Mapping, and Presentation Layer
• ConfiguredBI SchedulerandOracle BI Delivers- iBotsto deliver alerts and publish updated content to subscribed users as per the schedules and requirements
• Task assignment should be fair
• Tasking should be done with the team together
• Match people and tasks based on their skills and their personal preference
• Work the estimate with the team

Environment: OAF, Oracle PL/SQL, Oracle R12 (12.1.3), Oracle General Ledger, Oracle Payables, Oracle Receivables, Oracle Developer 6i (Forms, Reports and Workflow), XML Publisher, Oracle Database, JDeveloper, TOAD, Projects and ADF, OBIEE

Confidential

Sr.Oracle Techno-functional

Responsibilities:

• Rebuild charge account for oracle application frame work.
• Responsible to do analysis and find out process gaps on recurring issues and publish a “Root Cause Analysis Report”.
• Invoice hold approval workflow, I expense workflow, Purchasing Requisition workflow(add some part of code above packages)
• Print purchase order xml Report extension
• Interacting and working with the Users for the issues and the bug fixing.
• Liaisoning with the business Analyst in gathering and freezing requirement and the continual meetings with them throughout the phase and supporting the users during UAT Testing
• Involved in Preparing the clarification document, Technical documents as per AIM methodology, Test case Documents
• Developed new scratch from at AR
• Define and communicate technical release and business cutover plans with relevant cutover steps and communications needed with external business partners and stakeholders

Environment: OAF, Oracle PL/SQL, Oracle E-biz Applications 11i and R12, Oracle Order Management, Oracle Advanced Pricing, Inventory, Oracle General Ledger, Oracle Payables, Oracle Receivables, Oracle Developer 6i (Forms, Reports and Workflow), XML Publisher, Oracle Database, JDeveloper, SQL Navigator, TOAD.

Confidential, TX

Oracle Functional

Responsibilities:

• Involved in Development & testing of NA LCOM Customer changes.
• Preparing the technical design document.
• Supplier search form developer from starting and register in purchasing responsibility
• Extended VO & CO
• Added some columns in existing region
• Change the business logic in process form request
• Developed PPR page in Inventory
• Collecting inputs and providing the specifications in a functional design document to technical team to develop the reports and customizations for the client.
• Preparing weekly status reports to be send to client

Environment: OAFramework10g, Workflow builder2.6, Oracle 9.2.0.5.0, 10g Release 2, Oracle Apps R12.0.6, Discoverer 10 G, Report Builder 6i, 10g, Form Builder 6i, 10g UNIX and TOAD

Confidential, Boston, MA

Oracle Developer

Responsibilities:

• Developed and Reviewed & tested the deliverable components as per standards and guidelines provided by client
• Testing rdf /xml reports in client’s testing environment(Development, QA, Production)
• XML reports on OM, AR, OPM and AP.
• Discoverer reports in development.
• Workflow developments for OPM module.
• Developed Interfaces for OPM module
• New oracle apps forms developed varies modules

Environment: Report Builder 6i, Form Builder 6i, XML Publisher, Discoverer 10G

Confidential

Oracle Developer

Responsibilities:

• Responsible for preparing Test scripts, Setup documents, Standard Operating Procedures, Other documents.
• Preparing Problem Description note highlighting the issue as well as the expected behavior (capturing screen shots and error log files of problem areas wherever necessary)
• Resolving tickets related to Financial Modules in Remedy tool set by user.
• Providing production Support
• The PO approval hierarchy assignment as well as providing hierarchy details as per client request
• Provided report that would show the remaining quantity details as of date for any PO as per client requirement
• New Supplier creation and assigning bank to the corresponding supplier at site level.
• Automation process for supplier Invoice upload
• Customized oracle standard cheque print report to print cheque as per Indian rupee format and fields included as per client requirement
• Bill Run process.
• Journal import and AR Period closure.
• Automated the process for assigning sales person to the corresponding customer site level.
• Monitoring and support of daily run customer interface

Environment: Oracle applications R12 for Finance modules (GL, AP, AR, CM, FA, PO, INV, OM) Oracle 9.2.0.5.0, 10g Release 2