SUMMARY:

• Over 12 years of working experience in Oracle Application E - Business Suite Versions R 12.1.3/12.2.4/11 i in multiple Oracle Application lead roles with excellent technical project, team & task management skills. Proven ability to plan, co-ordinate and implement Full Life Cycle of Oracle EBS Implementation. This includes requirements gathering, technical design, testing, deployment, migration/cutover planning, production support and transition planning.
• Well versed in Oracle e-Business suite and demonstrated, deep hands on expertise in Oracle RICEW (Reports, Interfaces, Conversions, Extensions and Workflow) development. Extensive working knowledge in Analysis, Design, Development, Documentation and Deployment. Involved in implementation, Upgrade and Support of Oracle Applications E-Business Suite using SQL, PL/SQL, Developer Suite 10g, with hands-on experience of various RICE components and Workflow.
• Strong technical skills in Oracle EBS with experience in - conversions, interfaces, reports, BI Publisher, OAF applications extensions and personalization, forms personalization and extensions, oracle workflow and coding database objects.
• Expertise in Procure To Pay modules (Purchasing, Payables, iProcurement) and worked extensively on integrations, conversions (AP Invoices, Suppliers, Purchase Orders), workflows - requisition approval, po approval, create po and complex OAF extensions involving both creation of applications from scratch and also extended seeded pages.
• Worked extensively on complex integrations from Boundary Systems to Oracle Projects module, conversions related to - projects, tasks, events, agreements, miscellaneous transactions import etc. Also worked on seeded API’s related to – Budget Creation, Project Creation on various projects.
• Well versed with the Oracle P2P and O2C flows and possesses good knowledge on modules – General Ledger, Payables, Receivables, Order Management, Pricing, Purchasing, Fixed Assets, Cash Management, e-Business Tax etc.
• Ownership of the development lifecycle and being responsible for managing technical quality deliverable/resource/schedule/risks throughout the project, working extensively under onsite-offshore model using AIM Methodology. Expertise in writing the Technical Design Documents (MD070s) based on the Business Requirement document.
• Good knowledge of System Administration with hands on experience in creating Users, Responsibilities, Request Groups, Menus, registering concurrent programs, defining Value sets and Descriptive Flex fields. Good knowledge of UNIX shell-scripting. Conduct code review to ensure the work delivered by the team is of high quality standards.

TECHNICAL SKILLS:

ERP: Oracle E-Business Suite (11.5.10, 12.1.3, 12.2.4)

Work Areas: SQL, PL/SQL, SQL*Loader, FNDLOAD, D2K Forms, Forms Personalization, Reports, BI Publisher, OA Framework Extensions/Personalization, Oracle Workflow, Exposure and hands-on to Fusion Middleware - Oracle SOA & Oracle ADF.

Database: Oracle 9i/10g/11g

Languages: SQL, PL/SQL, UNIX, Shell Scripting, Pro*C

Reporting Tools: BI Publisher Desktop, Developer suite 10g, Oracle Discoverer

Tools and Utilities: TOAD, SQL Loader, SQL Developer, FileZilla (FTP), JDeveloper 11g, WinScp, STAT, Subversion.

Operating Platforms: Linux, Windows 2003, MS-DOS

PROFESSIONAL EXPERIENCE:

Oracle Developer

Responsibilities:

• Develop custom forms for the point of sale system. Develop custom reports as per the client business requirements.
• Involved in the backend processing for activation of the customer through OTAF (Over the Air Provisioning Functionality).
• As part of this was involved in creating database objects, Views, Packages, procedure, functions, triggers etc. Developed interfaces in TIBCO for flow of information between OSS.

Environment: Oracle 9i – SQL, PLSQL, TOAD, forms6i, reports6i, TIBCO, TOAD, Pro*C, exceed, UNIX.

Technical Lead

Responsibilities:

• Responsible for interacting with Business SME’s for requirements and analyzing the existing processes. Coordinated with IT and business SME’s to get the RICEW development tracker.
• Preparation of technical upgrade and test strategy documents.
• Review the Functional Design Document (MD050s) and prepare detailed Technical Design Documents (MD070s).
• Perform peer review of the technical design documents, code and unit test documents.
• Involved in retrofit and development of the interfaces from external systems to EBS R12 - GL, AP, AR, PO, and PA.
• Coordinated with the infrastructure and DBA team on the instance strategy, instance planning, clone and refresh for development and various test execution cycles.
• Responsible for technical design of Journal Interface abstraction layer from external systems - Constab, Microsiga etec.
• Worked on P2P Integrations between ARIBA & EBS: Interfaces from Ariba for inbound Purchase Orders, Receipts and Invoices.
• Worked on complex integrations between Change Point to Oracle PA (Projects Costing & Billing) – Projects, Tasks Hierarchy, Timecards, Expenditure Items etc, inbound customer interface from external application, invoice interfaces – inbound and outbound between EBS instances.
• Worked on Oracle Application Framework – creation of new pages (UI), personalization and extension of seeded pages.
• Technical Lead on divestiture engagements involving segregation of data through configuration and performing master and transactional data conversions. Lead and design & build effort for the conversions which include - Customers, Supplier/Sites/Banks, Projects, Tasks, Agreements, Budgets, Events, etc. Design/Development of conversion and Data Extraction, encryption and file transfer programs
• Involved in the Projects Accounting & Billing modules – integration with boundary applications; conversion of data and testing.
• Designed data extraction & interlock approach, reconciliation strategy, encryption for data extraction project. Involved in preparation of the cutover plan by having meetings with key stakeholders from EBS and external applications. Responsible for execution of cutover and reporting status to leadership and client group.
• Contributed to CEMLI objects / integrations and customization in Federal project.
• Resolve issues identified during System Integration Testing, User Acceptance testing and Post Production Support by working with the business and IT SME’s.
• Responsible for coordinating on various issues with Oracle through SR’s.

Environment: Oracle EBS R12.1.3, 12.2.4, BI Publisher, OAF, SQL, PL/SQL, XML, Workflow, Forms, Reports etc.

Lead Oracle Apps Technical Consultant

Responsibilities:

• Create technical design documents (MD070), development and review of code. Review of deliverables – technical designs, code and technical unit testing etc. and perform peer testing to log defects in HPQC and assign to developers.
• Worked on XML Publisher translation utility which consisted of development of OAF custom pages: Loader program to load the translatable text – source to target language into the repository.
• Custom User Interface developed in OAF page that displays the translations in the repository, add new translations to the repository. This includes creation of a Query Page to display translations in the repository and Create/Modify page to create or modify existing translations loaded.
• Page which uses the XML API’s to generate the XLIFF template for each target language based on the translations loaded into the repository.
• Involved in the development of the following RICE objects: Purchase Order Outbound based on Japanese layout; Import bank statement; Monthly Invoices and Refund reports in Receivables; Custom OAF page to upload data from excel used by different custom extensions.
• Cutover Activities: Prepared the Cutover kick off deck and the detailed cutover plan by coordinating with various teams. Execution of the cutover and report cutover status to leadership.

Environment: Oracle EBS R12.1.3, BI Publisher, Oracle forms, reports, OAF, SQL, PL/SQL and XML, Workflow, HPQC, Subversion.

Lead Oracle Apps Technical Consultant

Responsibilities:

• Developed modifier excel upload utility, interfaces from Solution Builder to Oracle EBS on pricing modifiers/qualifiers, price.
• Worked on OM order header and line workflow customizations.
• Worked on development of Custom Order Inquiry portal and dashboard using Oracle ADF tech stack.
• Development of Oracle Alerts – Order Management, Bill of Material, Engineering etc. Developed custom forms, forms personalization and xml reports.
• Worked on OAF personalization’s and extensions
• Development of User Interface to display the BOM Explosion Details.
• Developed common utility packages for - email distribution program; Common Data Loader program for conversions.
• Worked on Sales Order Interfaces using process order API; performed POC for BOM explosion for PTO kit items etc.
• Responsible for developing the Technical cutover plan and integrating with the overall project cutover plan.

Environment: Oracle EBS R12.1.3, BI Publisher, OAF, SQL, PL/SQL and Oracle Workflow.

Senior Oracle Apps Technical Consultant

Responsibilities:

• Worked on development and maintenance of conversions – AR Transactions conversion; Customers Conversion.
• Worked on building a common data loader program to load legacy data for all the conversions.
• Built custom oracle forms ex: Quote and Order query forms to meet with business needs. Worked on reports like – Claims Aging, Claims Letter, Quote Document, Sales Order Acknowledgement etc. with XML Bursting included printing output documents.
• Worked on extensions, forms personalization, customization using CUSTOM.pll modifications. Worked on Oracle Payables – generation of Payment Files (for Check and EDI printing) using XML Publisher RTF and e-text templates.
• Worked on Customer Facing Document i.e. XML Based Receivables outbound invoice using Bill Presentment Architecture feature (BPA) in Oracle. Well versed with the setups in BPA. Worked on customizing the seeded LCT’s ex: forms personalization to suite project object’s migration needs.
• Worked on generating custom EDI outbound process for PO – 850 and PO Change – 860. Worked on PLSQL API’s and packages, procedures and functions for Tally Based integration
• Create a custom application from scratch using oracle OAF (Query Bean, Create Page – Tables, Advanced Tables, Shuttles, Invoking DB procedues/API’s and workflows etc.)
• Coordinated with team members in resolving defects and participated in peer reviews for objects. Involved in unit test and system integration testing phases support.

Environment: Oracle EBS 12.1.3, Oracle Forms, Oracle Reports, XML Publisher, Oracle 10g, PL/SQL, SQL Developer, Oracle Workflow, Putty etc.

Senior Oracle Apps Technical Consultant

Responsibilities:

• Development of Eis Reporting and Time Entry Solution. This solution consisted of building custom applications using OA Framework for the User Interface, Oracle Workflow for approvals, PLSQL APIs for backend, XML Publisher for reporting.
• Worked on development of custom pages for reporting and time entry solution.
• Search page, create page, update, implemented PPR
• Used Advanced Table, Shuttle regions for time Eis time entry solution
• Eis Reporting Solution - Developed an OAF page for submission of FSG reports. This page was built using HGrid to display the reports under each category.
• Involved in development of reports Journal Details, GL Daily Activity report, Payables to General Ledger reconciliation report etc.
• Developed database packages, procedures, functions, views, synonyms etc. Worked on unit testing and system testing activities etc. Reviewing the Technical documents and the code.

Environment: Oracle Applications 11i, SQL PLSQL, Oracle forms, reports, XML Publisher, OA Framework etc.

Senior Oracle Apps Technical Consultant

Responsibilities:

• Documented technical specifications and testing scenarios for Custom Reports and Forms. Loading transactions into projects interface with the relevant POET information. Developed custom forms and customization of existing seeded forms.
• Developed oracle alerts for identifying the manual journal entries in GL with invalid journal entries and send email to the business users for correction. Worked on forms personalization to meet the business requirements.
• Prepared unit test cases as part of testing activities. Prepared AIM documents – technical design MD070 and installation/deployment document MD120. Worked on Customizations using Oracle Apps standard API & Packages.
• Worked on migrating concurrent programs using FNDLOAD. Report Development (using Report Builder and XML Publisher). Worked on Code Migration and Migration Documents. Post production of custom developed objects.

Environment: Oracle Applications 11.5.10, Oracle Forms 6i, Reports 6i, Oracle 9i, PL/SQL, TOAD, Workflow, WsFtp, Windows, Sub-version.

Oracle Apps Technical Consultant

Responsibilities:

• Worked as on-site Technical Developer. Worked on forms personalization and custom.pll modifications to meet the client’s requirements. Customized workflow processes - PO requisition approval; PO Approval etc.
• Worked on a generic SQL*Loader program that is used to populate custom staging table given the data file, control file, remote ftp server details etc. Worked on Payables Open Interface to import invoices - developed SQL*loader and PL/SQL programs to load the open interface tables.
• Worked on modification and customization of reports. Design and build different database objects such as tables, views, indexes and synonyms. Worked with System Administration responsibilities for registering custom programs, creating Value Sets and Flex Fields etc.
• Created Concurrent Programs of types PL/SQL Stored Procedures, Host, Oracle Reports, SQL *Loader. Modified the Receivables Invoice Preview using Bill Presentment Architecture (BPA). Prepared AIM documents MD070, MD120 and worked with Oracle Support by logging SR’s etc.
• Worked on OA customizations (personalization and extensions) in i-Procurement and custom page development. Some extensions involve – defaulting requestor name in i-Procurement preferences; Restricting the List of Values on the Deliver-To-Location; Restricting the Select List pop list on the Shopping lists page etc.

Environment: Oracle Applications 11.5.10, Oracle Forms 6i, Reports 6i, Oracle 9i, PL/SQL, TOAD, Workflow, OAF, Jdeveloper 10g, WsFtp, Putty, UNIX and Windows, Star-team.

 Oracle Apps Technical Consultant

Responsibilities:

• Worked on Miscellaneous transaction import to load miscellaneous transactions into Oracle Projects using Open Interface. Creation of budgets in Oracle Projects using budget creation API.
• Customization of forms and workflow. Involved in preparing unit test cases. Worked on debugging code and fixing defects. Preparation of MD070 technical design documents for projects worked on.

Environment: Oracle Applications 11i, Oracle Forms 6i, Reports 6i, Oracle 9i, SQL, PL/SQL, TOAD, Workflow etc.

Applications Engineer

Responsibilities:

• Worked on the oracle e-business suite product development as an application developer and responsible for following tasks:
• Tax Codes migration - Involved in the tax codes migration from R11i to R12 and XBUILD sanity checks to verify the migration process and fix/resolve defects.
• Involved in debugging the API’s (database packages, procedures, functions) for Tax Calculation and taxation related services.
• Development/modification of XML publisher RTF templates, Oracle reports for the Tax Reporting Ledger (TRL) using XML Publisher.
• Worked on enhancement of OAF pages and bug fixes as part of XBuilds and Financials QA testing. Involved in building the seed data configuration (coding the LCT files) for the tax entities using FNDLOAD utility. Worked on defaulting and validation API invoked from sub-ledgers.

Environment: Oracle Applications R12, SQL PLSQL, Oracle Forms reports 10g, XML Publisher, OA Framework etc.