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. 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, APEX, 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,Texas

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, Microsigaetec. Worked on Interfaces from Ariba for inbound Purchase Orders, Receipts and Invoices.
• Design of Interfaces from Change Point to Oracle PA - Projects, Tasks Hierarchy, Timecards 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 also performing master and transactional data conversions - Customers, Supplier/Sites/Banks, Projects, Tasks, Agreements, Budgets, Events etc.
• 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.
• 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.

Confidential

Lead Oracle Apps Techno-Functional 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.
• Page which uses the XML API’s to generate the XLIFF template for each target language based on the translations loaded into the repository.
• Building Custom User Interface in OA Framework to display and edit the translations that are loaded into 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.

Confidential 

 Lead Oracle Apps Techno-Functional 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.
• 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
  • CO & VO extension, personalization on iProcurement non-catalog request pages, preferences page etc.
  • Worked on POC for i-Receivables to i-Store integration. Involved in development of OAF personalization and extensions.
• Development of User Interface to display the BOM Explosion Details.
  • Developed search page and drill down to details for displaying the details /components within a BOM/Assembly Item.
• Worked on Price Agreements, Modifiers, Price List, Sales Order conversion 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 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.

Confidential, Texas

 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 i.e. custom application functionality built using oracle OAF.
• 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.

Confidential

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 Shuttle for assigning the resources to a project.
• 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.

Confidential 

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..

Confidential,Wisconsin

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.