SUMMARY

• Over 13 years of working experience in Oracle Application E - Business Suite Versions R 12.1.3/12.2.4/11 i and Oracle Cloud Financials in lead roles wif 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 noledge 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, wif hands-on experience of various RICE components and Workflow.
• Strong technical skills in Oracle EBS wif 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 wif teh Oracle P2P and O2C flows and possesses good noledge on modules - General Ledger, Payables, Receivables, Order Management, Pricing, Purchasing, Fixed Assets, Cash Management, e-Business Tax, Inventory, BOM, Work in Process etc.
• Ownership of teh development lifecycle and being responsible for managing technical quality deliverable/resource/schedule/risks throughout teh project, working extensively under onsite-offshore model using AIM Methodology. Expertise in writing teh Technical Design Documents (MD070s) based on teh Business Requirement document.
• Good noledge of System Administration wif hands on experience in creating Users, Responsibilities, Request Groups, Menus, registering concurrent programs, defining Value sets and Descriptive Flex fields. Good noledge of UNIX shell-scripting. Conduct code review to ensure teh work delivered by teh 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

Confidential

Lead Oracle Apps Consultant

Responsibilities:

• Development of BI Publisher reports & Oracle RDF reports for Customer Facing Documents - AR Invoices, create/modify reports to make logo and company name changes.
• Development of shell scripts for email notification of teh customer facing documents.
• Preparation of design specifications, unit test cases document, data validation and work wif business counterparts for approvals and sign-off.
• Development of Oracle alerts to send email notifications
• Responsible for development of integration - inbound and outbound:
• Outbound interface for sales orders and AR invoices from Oracle to RevPro
• Outbound interface from Oracle to Concur (employee data), TSPM etc.
• Inbound journal interface from RevPro to Oracle GL
• Worked on teh following components as part of teh IFRS project:
• Development of account derivation functions for revenue and deferred revenue accounts based on business derivation rules
• Modification to custom account generator workflow
• Development of custom OAF pages from scratch related to an UI to display teh journal data interfaced from RevPro to Oracle, enabling correction of error records and re-triggering teh import process.
• Customization of seeded pages - using VO extension, Controller extension and personalizations.
• Involved in supporting integration testing, UAT and cutover issues.

Environment: Oracle EBS Financials - R12.1.3, BI Publisher, XML, Oracle Reports, Alerts, PLSQL, Workflow, OAF etc.

Confidential, Foster City, CA

Lead Oracle Apps Consultant

Responsibilities:

• Responsible for data migration from legacy systems to Oracle Fusion Cloud using FBDI. Involved in teh following conversions:
• Supplier, Sites, Contacts and attachments.
• Supplier Bank Accounts
• Customer Data Migration from SFDC
• Items data migration from SFDC
• Open Payables Invoices
• 1099 Invoices
• Open Sales Orders
• Open Receivables Invoices
• Preparation of conversion design specifications, unit test cases document, data validation and reconciliation documents. Work wif business counterparts for approvals and sign-off.
• Development of Financial Reports - receivables, payables, general ledger etc.
• Developed BI Publisher reports
• Developed OTBI reports
• Developed FRS reports for General Ledger Reports.
• Responsible for configuration of teh security model
• Creation of custom job roles, duty roles to meet business requirements
• Creation of custom read only roles and period close roles
• Create of employees & users using batch load.
• Manage Data Access for various users.
• Involved in teh various data migration dry run activities, support integration testing, UAT and production cutover.

Environment: Oracle Cloud Financials - R12, BI Publisher, XML, FRS Reports, OTBI, FBDI, ADFDi etc.

Confidential, Austin, Texas

Technical Lead

Responsibilities:

• Responsible for interacting wif Business SME’s for requirements and analyzing teh existing processes. Coordinated wif IT and business SME’s to get teh RICEW development tracker.
• Preparation of technical upgrade and test strategy documents.
• Review teh Functional Design Document (MD050s) and prepare detailed Technical Design Documents (MD070s).
• Perform peer review of teh technical design documents, code and unit test documents.
• Involved in retrofit and development of teh interfaces from external systems to EBS R12 - GL, AP, AR, PO, FA and PA.
• Coordinated wif teh infrastructure and DBA team on teh 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 teh 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 teh Projects Accounting & Billing modules - integration wif boundary applications; conversion of data and testing.
• Designed data extraction & interlock approach, reconciliation strategy, encryption for data extraction project. Involved in preparation of teh cutover plan by having meetings wif 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 wif teh business and IT SME’s.
• Responsible for coordinating on various issues wif Oracle through SR’s.

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

Confidential

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 teh translatable text - source to target language into teh repository.
• Custom User Interface developed in OAF page that displays teh translations in teh repository, add new translations to teh repository. This includes creation of a Query Page to display translations in teh repository and Create/Modify page to create or modify existing translations loaded.
• Page which uses teh XML API’s to generate teh XLIFF template for each target language based on teh translations loaded into teh repository.
• Involved in teh development of teh following RICE objects:
• Purchase Order Outbound based on Japanese layout;
• Import bank statements (Japanese Zengin format) using Bank Statement Loader.
• Development of Monthly Invoices and Refund reports in Receivables;
• Development of Custom OAF pages to upload data from excel used by different custom extensions.
• Worked on iSupplier - OAF personalization and customizations of teh seeded pages - View Purchase Order/Invoices etc.
• Worked on importing / creation of receipts and generation of direct debit files for transmission to bank.
• Cutover Activities: Prepared teh Cutover kick off deck and teh detailed cutover plan by coordinating wif various teams. Execution of teh 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.

Confidential, Schaumburg, Illinois

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 personalizations and extensions in iProcurement and iReceivables modules.
• CO & VO extension, personalization on iProcurement non-catalog request pages, ps page etc. to default attributes, add new fields to List of Values.
• Worked on POC for i-Receivables to i-Store integration. Involved in development of OAF personalization and extensions.
• Development of User Interface to display teh BOM Explosion Details.
• Developed search page and drill down to details for displaying teh details /components wifin a BOM/Assembly Item. Components such as HGrid, Advance Table, Query Beans etc. were used for teh custom page development.
• Worked on Price Agreements, Modifiers, Price List, Sales Order conversion etc.
• Worked on conversions - Items, Item Categories, On Hand Quantities, BOM etc.
• 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 teh Technical cutover plan and integrating wif teh overall project cutover plan.

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

Confidential, Texas

Senior Oracle Apps Technical Consultant

Responsibilities:

• Worked on development and maintenance of conversions - AR Transactions conversion; Customers Conversion, Supplier/site/contacts, banks, assets etc.
• Worked on building a common data loader program to load legacy data for all teh conversions.
• Built custom oracle forms ex: Quote and Order query forms to meet wif business needs. Worked on reports like - Claims Aging, Claims Letter, Quote Document, Sales Order Acnoledgement etc. wif 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 wif teh setups in BPA. Worked on customizing teh 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 wif 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.

Confidential, Atlanta, Georgia

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 teh 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
• Shuttle for assigning teh resources to a project.
• Eis Reporting Solution - Developed an OAF page for submission of FSG reports. This page was built using HGrid to display teh 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 teh Technical documents and teh code.

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

Confidential, Atlanta, Georgia

Senior Oracle Apps Technical Consultant

Responsibilities:

• Documented technical specifications and testing scenarios for Custom Reports and Forms. Loading transactions into projects interface wif teh relevant POET information. Developed custom forms and customization of existing seeded forms.
• Developed oracle alerts for identifying teh manual journal entries in GL wif invalid journal entries and send email to teh business users for correction. Worked on forms personalization to meet teh 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.

Confidential, Milwaukee, Wisconsin

Oracle Apps Technical Consultant

Responsibilities:

• Worked as on-site Technical Developer. Worked on forms personalization and custom.pll modifications to meet teh 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 teh 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 teh open interface tables.
• Worked on modification and customization of reports. Design and build different database objects such as tables, views, indexes and synonyms. Worked wif 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 teh Receivables Invoice Preview using Bill Presentment Architecture (BPA). Prepared AIM documents MD070, MD120 and worked wif 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 ps; Restricting teh List of Values on teh Deliver-To-Location; Restricting teh Select List pop list on teh 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.

Confidential, Edinburg, Texas

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.

Confidential

Applications Engineer

Responsibilities:

• Worked on teh oracle e-business suite product development as an application developer and responsible for following tasks:
• Tax Codes migration - Involved in teh tax codes migration from R11i to R12 and XBUILD sanity checks to verify teh migration process and fix/resolve defects.
• Involved in debugging teh API’s (database packages, procedures, functions) for Tax Calculation and taxation related services.
• Development/modification of XML publisher RTF templates, Oracle reports for teh 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 teh seed data configuration (coding teh LCT files) for teh 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.

Confidential

Oracle Developer

Responsibilities:

• Develop custom forms for teh point of sale system. Develop custom reports as per teh client business requirements.
• Involved in teh backend processing for activation of teh customer through OTAF (Over teh 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.