SUMMARY

• Over 10+ years of working experience in Oracle Application E - Business Suite Versions R12.1.3/11i to include 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 with the Oracle P2P and O2C flows and possesses good knowledge on modules - General Ledger, Payables, Receivables, Order Management, Purchasing, Inventory, Shipping, e-Business Tax etc.
• Expertise in Oracle RICE (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.
• Extensive experience in OA Framework design, Customization, Extension and MSCA applications.
• Expertise in Procure to Pay modules (Purchasing, Payables, Isupplier, 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 extended seeded pages.
• Worked extensively on complex integrations from Boundary Systems to Oracle Purchasing module, conversions related Requisition, PO and BPA etc. Experience in Supplier, Supplier Site, Supplier Contact and Employee Conversions to migrate legacy Supplier data to Oracle R12 EBS system
• 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.
• Worked extensively on Trading Community Architecture (TCA) and Multi-Org Environment. Good Knowledge of Multi organization Access control (MOAC) architecture. Experience in tuning application using tools like Explain Plan, SQL*Trace and TKPROF for high efficiency.

TECHNICAL SKILLS

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

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

Database: Oracle 9i/10g/11g

Languages: SQL, PL/SQL, UNIX, Shell Scripting, Java

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

Tools: and Utilities TOAD 10.5, SQL Loader, SQL Developer, FileZilla (FTP), JDeveloper 11g, WinScp, Kintana 9.3, Dimensions 10.1, BMC Remedy 7.6, Putty.

Operating Platforms: Windows XP/2000/ 2003/Vista/7/10

PROFESSIONAL EXPERIENCE

Confidential, Davidson, North Carolina

Sr. Oracle Technical Consultant

Responsibilities:

• As a Lead Oracle EBS Technical Consultant, contributed in design and development of Interfaces, Conversions, OAF pages, Web-services and Reports for Oracle R12 in Shipping, Inventory, Purchasing and OTM modules.
• Developed an ASN Process page in OAF which can be used for receiving process where user can manually load the data and submit RTP.
• Implemented various OAF functionalities including Search/Create Pages, Master-Detailed Advanced Tables, Parent Child relationships, Partial Page Rendering, Add/Delete rows, File Uploads, Record Coloring, Procedure calls, Switcher, Conditional rendering of fields, Dynamic enabling/disabling of Checkboxes, Extracts/Reports (configured with BI Publisher), etc.
• Specific OA Framework related experiences include automatic checking of child nodes in Advanced Tables based on checking of parent nodes checkboxes, creation of new VO objects dynamically (using createViewObject” method), adding new VO rows (using “createRow” method), enabling/disabling checkboxes/fields in OAF pages (using SPEL)
• Worked on different BC4J Components for customizations. Extended VO (View Objects) and modified the CO (Controllers).
• Created new LOV search fields in the Requisition Search Page. Modified the existing search criteria ExpSearchCO to in corporate the search with newly added LOV search fields.
• Worked on extending IProcurement requisition page by adding seeded HZ Address DFF for address formatting for Ship to address.
• Worked on different base java class files to identify the exact functions and the flow of the data in iProcurement requisition module for updating and validating functionality
• Worked on Custom Select All/None table properties and handled via fireaction event.
• Integrated OAF with BI Publisher using XDO TemplateHelper Utility to seamlessly download Search results in form of a BI Publisher Report. Used Microsoft Excel Templates as report layout.
• Involved in creating Project tracker to track and monitor the Oracle 11i custom code changes compatible with Oracle R12 standards.
• Worked on P2P Integrations between OTM and Oracle to planning shipments
• Created on custom reports in WMS and Inventory modules
• Directly supported Business Users in Warehouse Plants, assisting them in using the various Solutions (IR/ISO, PO Conversion, etc.) developed and released in UAT/Production instance
• Coordinated with onshore/offshore team during design, development and support phase of the 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.
• Retrofitted customized PO Approval, PO Document Create workflows
• Used SQL*Loader and Control Files to meet Conversion requirement of Supplier, PO data from Legacy system to Oracle.

Environment: Oracle EBS R12.1.3, MSCA, BI Publisher, Oracle Application Framework (OAF), SQL, PL/SQL, XML, Oracle 11g/10g, Workflow 2.6, Oracle Reports 10g, Oracle Forms 10g, JDeveloper 10g, HPQC, JAVA etc.

Confidential, Davidson, North Carolina

Lead Oracle Apps Technical Consultant

Responsibilities:

• Study the legacy systems and understand the business processes. Solution the business processes in Oracle R12 environment by maximum utilization of standard Oracle features. Customer Requirement Study, Preparation of Development Requirements from customer Requirements
• 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).
• Involved in retrofit and development of the interfaces from external systems to EBS R12 - PO, INV, AP, QA, and WMS.
• Coordinated with the infrastructure and DBA team on the instance strategy, instance planning, clone and refresh for development and various test execution cycles.
• Built a custom Promotion Sheet application using OAF to promote the Change requests to Production instance via approvals.
• Created page using Train layout to collect the data from user.
• Worked on controller extension on iSupplier page to include custom reports by extending the seeded pages.
• Created common regions in OAF and used across pages.
• Worked on P2P Integrations between ARIBA & EBS: Interfaces from Ariba for inbound Purchase Orders and Invoices.
• Worked on the Customer/Supplier Cross reference form on OAF and many other Custom OAF pages.
• Worked on the Payment Process to External banks interface (SWIFT) using OAF pages based on custom Tables. Worked on the interfaces like HR Sync Interface, PO Outbound to Multiple Legacy Interface and OTM Inbound and Outbound Interface.
• 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 - Supplier/Sites/Banks, Employee, Requisition, PO etc. Design/Development of conversion and Data Extraction, encryption and file transfer programs
• Involved in Optimizing SQL queries involving large tables. Logging service requests with Oracle and working with Oracle to resolve Applications Software defects.
• 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, MSCA, BI Publisher, Oracle Application Framework (OAF), SQL, PL/SQL, XML, Oracle 11g/10g, Workflow 2.6, Oracle Reports 10g, Oracle Forms 10g, JDeveloper 10g, HPQC, JAVA etc.

Confidential, Davidson, North Carolina

Senior Oracle Apps Technical Consultant

Responsibilities:

• Created 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.
• Participated and executed all phases of Project - Requirements, SIT, UAT, Go Live and post Go Live support.
• Tuned the SQL using Explain Plan, TKProf and Stats pack for better performance. Transferred the data between databases using Export, Import utilities.
• Created custom OAF page for viewing the Configuration data from the legacy systems for CTO items.
• Created database objects like tables, views, Materialized views, sequences, Synonyms, database links and indexes.
• Involved in end-to-end Code reviews by coordinating with development team and resolving defects and performance issues
• Fine Tuned procedures for the maximum efficiency in various schemas across the database using Oracle Hints, Explain plan and Trace sessions for Cost based optimization.
• 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.
• Actively resolved post Go-live code bugs and performance issues.

Environment: Oracle EBS R12.1.3, MSCA, BI Publisher, Oracle Application Framework (OAF), SQL, PL/SQL, XML, Oracle 11g/10g, Workflow 2.6, Forms 6i, Reports 6i, Java etc.

Confidential, Davidson, North Carolina

Oracle Apps Technical Consultant

Responsibilities:

• Developed a feeder program that will transfer the Accounting data from the Legacy Accounting System to the GL Interface table. Developed a custom package to import the GL Journals from the interface table into the GL production tables.
• Developed an OA page which will show all the payments which are needed to be approved by treasury team before sending to bank.
• Used SPEL and PPR for Dynamic page rendering,
• Registered Concurrent programs, forms and Reports to AOL.
• Executing concurrent programs from PL/SQL
• Worked on Personalization and Extension of Oracle standard Pages in PO, QA.
• Developed expertise of planning and executing various phases in the SDLC lifecycle and employed the practices in achieving high-quality and on-time deliveries.
• Continuously mentoring team members to enhance their learning in OA Framework.
• Developed common utility packages for - email distribution program; Common Data Loader program for conversions.
• Responsible for developing the Technical cutover plan and integrating with the overall project cutover plan.
• Developed the XML publisher report with bursting as per the client requirement
• Worked on OAF personalization’s and extensions
• CO & VO extension, personalization on Quality module compliant pages.
• Customized Advanced and Simple Search pages as customer needed.

Environment: Oracle EBS 11.5.10, BI Publisher, OAF, SQL, PL/SQL and Oracle Workflow 2.6.

Confidential

Oracle Apps Technical Consultant

Responsibilities:

• Developed the Project Creation Module using OA Framework (Java/XML) and PL/SQL, which has following functionalities
• ‘Project List’ functionality which replaced Oracle existing Project List functionality.
• Edit Key Members functionality.
• Copy Project functionality.
• Task and Resources page.
• Worked on Oracle Workflow and PL/SQL to in corporate changes in workflow of Project Approval process based on SP and IOU to bring a better visibility to SP PMO and achieve the objective of HSU ISU Collaboration.
• ‘Milestone Entry Using Excel’, which provides user an ease to enter milestones in bulk amount using excel template and proved a major system improvement.
• Developed PL/SQL objects for following system improvement change requests:
• Fetching one Invoice Model while submitting Project Classification Questionnaire, which improved project accounting system and hence reduced ticket count.
• Tuning of Batch which interfaces data from ipms to PA and PA to ipms. This tuning has reduced execution time of batch to 25% of original time and increased frequency of execution. Thus, deadlocks are prevented, and the batch doesn’t go to error resulting in smooth execution of project accounting.
• Worked on Personalization and Extension of Oracle standard Pages in PA.
• Having a good knowledge of complete invoice flow and different interfaces like PA-AP, PA-AR.
• Have proactively worked upon automating the processes so that the manual intervention is reduced to minimal involving PL/SQL.
• Continuous support (for > 40,000 projects) for 24/7 on month ends and 16/7 always to execute all the processes smoothly.
• Worked on Oracle Forms and CUSTOM.pll to in corporate customizations required by TCS.
• Worked on Oracle Workflow for achieving customized level of approvals while Project Approval Process to in corporate smooth flow of business processes.
• Trained team members on PL/Sql and OA Framework (OAF) and continuously mentoring team members to enhance their learning.

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

Confidential, Detroit, Michigan

Oracle Apps Technical Consultant

Responsibilities:

• Development of OA page which retrieves contract pdf from database and user can review and load the signed contracts. 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 notification.
• Search page, create page, update, implemented PPR
• Upload/Download files
• Used External Tables to load test data from CSV files to the database tables from Front end.
• Involved in Optimizing SQL queries involving large tables.
• 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, java etc.

Confidential

Oracle Apps Developer

Responsibilities:

• Developed Customer Conversion and Supplier conversion programs
• Developed SQL*Loader scripts to load the data from external files that is exported from SQL Server.
• Developed new custom forms in Order Management and Account Receivables as per the business needs
• Involved in SQL performance tuning.
• Designed and developed functions/ stored procedures/packages/triggers using PL/SQL.
• System analysis, Designing & Developing, Analyzing Data & Modifying Tables, enforcing constraint on tables.
• Designing Database & enforcing various constraints.
• Extensively used the advanced features of PL/SQL like collections, nested table, v-array & Dynamic SQL.
• Coded and implemented PL/SQL packages to perform Application Security and batch job scheduling.
• Documented business rules, functional and technical designs, test cases, and user guides.
• Analyzed the tables for better performance using Explain plan and Tkprof.

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