SUMMARY:

• Having 12+ Years of Experience in Oracle Applications EBS 11i/ R12(12.1, 12.2) as Techno - Functional Consultant and have Knowledge on Oracle Fusion Cloud Applications SaaS and PaaS.
• Worked on various phases of projects like Oracle EBS Implementation, Production Support, Oracle EBS R12 Up gradation and Oracle EBS R12 Migration. Good Knowledge with R12 New features and up gradation activities.
• Worked Extensively with Oracle modules Financials (AP, AR, SLA and GL), SCM (PO, INV and OM), and Knowledge on HRMS, Manufacturing and and Oracle Projects.
• Hands on experience with the components like Forms, Reports, Interfaces and Conversions and XML Publisher Reports.
• Good Knowledge in Developing and customizing Shell Scripting.
• Good Understanding of MD050, MD070, CV040, CV060, CV070, TE020, TE040 and MD120 documents of AIM methodology.
• Developed Custom tools to generate SOD Conflicts (Segregation of Duties) and SOX Compliances which helps Internal Audit.
• Involved in 24/7 kind of Production support if required to resolve issues.
• Involved in Performance Tuning using Tracing Techniques.
• Good Working experience on Discoverer, Workflow Builder, WEBADI and OA Framework.
• Good Working experience on Oracle GRC (Governance, Risk and Compliance).
• Knowledge on Oracle Cloud PaaS OIC to build integrations between external systems to Cloud ERP.
• Involved in building BI Publishers reports in ERP Cloud SaaS applications.
• Have sound knowledge in design, development and deployment of n-tier architecture.
• Supported Production systems and developed many tools to help support activities.
• Strong knowledge of tweaking and stream lining applications for improving performance
• Strong analytical skills, disciplined delivery standards and dedication to develop and enjoy making high quality software systems.

PROFESSIONAL EXPERIENCE:

Confidential

Senior Principal Consultant

Responsibilities:

• Developed AP, AR and GL Interface code to Integrate with other systems.
• Developed Integration between AR Invoices and Salesforce using EBS SOA Gateway.
• Developed preprinted reports which meet customer specific layouts and requirements.
• Developed E-text Templates for ACH Nacha and Separate Remittance reports.
• Involved in defining setups on modules FIN (AP, AR, GL) and SCM (OM, INV, PO)
• Developed Interface code between Maximo and Oracle Projects/tasks.
• Supported Month end Activities and Interacted with Oracle SR team to fix the bugs.
• Involved in cleaning up Interface Stuck data on weekly basis.
• Interacted with SOA middleware teams to fix interface errors.
• Handled the migration team and worked as part of the team.
• Prepared documentation based on client requirement.
• Involved in tuning queries in Oracle SQL and PL/SQL.
• Review of code changes, test procedure, test plans and other deliverables.

Confidential

Senior Principal Consultant

Responsibilities:

• Enabled migration from 12.1 to 12.2:
• Developed PA, PO, AP and AR conversion code and migrated the data into new R12 system.
• Developed preprinted reports which meet customer specific layouts and requirements.
• Involved in defining setups on modules AP, AR, GL, PO, INV, OM.
• Developed custom workflows from scratch and customized the standard workflows.
• Developed Custom tools to generate SOD Conflicts and SOX Compliances which helps Internal Audit.
• Migrated custom reports, packages and host files from 12.1 to 12.2 by customizing necessary changes as per New version.
• Involved in SIT and UAT Phases.
• Handled the migration team and also worked as part of the team.
• Developed XML/BI Publisher reports from scratch.
• Reviewed progress of issues with Project Manager.
• Prepared documentation based on client requirement.
• Involved in tuning queries in Oracle SQL and PL/SQL.
• Review of code changes, test procedure, test plans and other deliverables.
• Involved in ERP Cloud Finance configurations.
• Involved in Fusion Security activities like User creation, Custom Roles creation, Providing Data Access through Spreadsheet etc..,
• Involved in loading master data and transactional data using FBDI spread sheets.
• Involved in integrating External system with ERP Cloud using PaaS OIC and DB.
• Developed below Integrations to push data from external systems to ERP Cloud by using PaaS OIC and DB.
• Customers Integration.
• Suppliers Integrations.
• AP Invoices Integrations.
• AR Invoices Integrations.
• GL Journals Data Integrations.

Confidential

Technical Lead

Responsibilities:

• Developed AP and AP Aging Reports for the client which shows all account information and currency information which helps the customers to tally the data easily.
• Developed new workflows on PA and PO modules.
• Involved in defining setups on modules AP, AR, GL, PO, INV and OM.
• Developed Tool to assess custom objects in the system for better upgrade from 12.1 to 12.2.
• Developed AP and AP Aging Reports for the client which shows all account information and currency information which helps the customers to tally the data easily.
• Developed new workflows on PA and PO modules.
• Created Business events on AR module to customize the accounting code combinations.
• Developed OAF Page to display customer and supplier related information.
• Created new form personalization’s and customized existing oracle custom forms.
• Leading team of 5 technical and 1 functional consultant.
• Prepared project status excels weekly and sent to higher management.
• Provided training to users to understand and use the application.
• Developed Data fixes and Code Fixes to resolve the production issues.
• Involved in SIT and UAT Phases.
• Defined setups for AACG and TCG configurations as part of Oracle GRC Implementation.
• Handled the migration team and also worked as part of the team.
• Developed XML/BI Publisher reports from scratch.
• Reviewed progress of issues with Project Manager.
• Prepared documentation based on client requirement.
• Involved in tuning queries in Oracle SQL and PL/SQL.
• Review of code changes, test procedure, test plans and other deliverables.

Confidential, Atlanta, Georgia

Technical Lead

Duties & Responsibilities:

• Developed an interface for min-max planning from legacy to standard Oracle standard base tables of Inventory.
• Developed PO ASL (Approved Supplier List) interface by using standard API’s.
• Developed custom workflows from scratch and customized the standard workflows.
• Created control files for SQL loader to load data from text files.
• Customization and development of reports and interfaces.
• Defined the AOL objects like concurrent programs, executables and value sets etc.,
• Developed XML/BI Reports as per client requirements.
• Customized packages/reports based on client requirements.
• Reviewed the progress of issues with project manager.
• Prepared documentation based on client requirement.
• Developed Code for Creating the Product Family, Product Family Version, Suite, Application, Tables, Columns, Objects, Translations etc., without Meta builder help.
• Involved in defining Approval Groups in PCG.
• Involved in Defining setups like Audit and Change Control in PCG.
• Involved in Defining setups and Configurations in regards to AACG and TCG like:
• Data Source Configurations
• Perspectives
• Roles
• Users
• Entitlements (AP, AR, OM, PO, GL, PA)
• Controls

Confidential, Coral Gables, FL

Team Lead

Responsibilities:

• Enabled migration from 11i to R12:
• Extraction and migration of Items data, supplier’s data, employee’s data, projects & tasks data and supplier bank details from 11i to R12.
• Migrated custom reports, packages and host files from 11i to R12 by customizing necessary changes as per R12.
• Involved in SIT and UAT Phases.
• Handled the migration team and also worked as part of the team.
• Developed XML/BI Publisher reports from scratch.
• Developed scripts using API’s.
• Reviewed progress of issues with Project Manager.
• Prepared documentation based on client requirement.
• Involved in tuning queries in Oracle SQL and PL/SQL.
• Review of code changes, test procedure, test plans and other deliverables.
• Developed an interface for min-max planning from legacy to standard Oracle standard base tables of Inventory.
• Customization and development of reports and interfaces.
• Defined the AOL objects like concurrent programs, executables and value sets etc.,
• Developed XML/BI Reports as per client requirements.
• Customized packages/reports based on client requirements.
• Reviewed the progress of issues with project manager.
• Prepared documentation based on client requirement.

Confidential, New York, NY

Team Lead

Responsibilities:

• Developed configuration control governor (CCG) content for the 12.1.3 Version.
• Developed code for creating the product family, product family version, suite, application, tables, columns, objects and translations etc. from backend without Meta builder.
• Involved in defining approval groups in preventive control governor (PCG).
• Involved in defining setups like audit and change control in PCG.
• Defined setups for AACG and TCG configurations. I have involved in building Custom Objects and also involved in building Custom Adapter to connect GRC with other applications like Hyperion and some other Java Applications by using Protégé and ODI (Oracle Data Integrator) and Restful API’s.
• Developed Code for Creating the Product Family, Product Family Version, Suite, Application, Tables, Columns, Objects, Translations etc., without Meta builder help.
• Involved in defining Approval Groups in PCG.
• Involved in Defining setups like Audit and Change Control in PCG.
• Involved in Defining setups and Configurations in regards to AACG and TCG like:
• Data Source Configurations
• Perspectives
• Roles
• Users
• Entitlements (AP, AR, OM, PO, GL, PA)
• Controls

Confidential

Team Lead

Responsibilities:

• Involved in the Migration of Data from 11i to R12.
• Involved in Data validations part to compare both 11i and R12 data.
• Retrofitting of reports from 11i to R12.
• Developed custom positive pay report by using e-Text templates.
• Developed custom separate remittance report by using e-Text templates.
• Developed custom ACH Nacha report by using e-Text templates.
• Extended the standard package on part of customization of standard e-Text templates.
• Defined oracle payment administrator setups like payment process profiles, payments formats etc.,
• Developed some fix scripts for solving some functional issues.

Confidential, Cumberland, RI

Team Lead

Responsibilities:

• Analyzed specifications provided by the clients.
• Worked on supporting tickets based on priority.
• Developed plsql package to customize IPV and PPV accounts.
• Developed PL/SQL packages, procedures, and functions.
• Developed and customized discoverer reports.
• Creation of value sets in various modules of the application.
• Developed outbound interface to extract back orders data from base tables to flat file using the UTL FILE utilities in order management module.
• Development of various interfaces and reports in INV, AP, OM, AP, GL.
• Developed control files to load data into tables.
• Executing concurrent programs from PL/SQL by using API’s.
• Development of reports using XML publisher report.
• Defined concurrent programs, executables, and value sets.
• Prepared end user training materials for users in power point and words as well.

Confidential

Senior Consultant

Responsibilities:

• Analyzed specifications provided by the clients.
• Worked on supporting tickets based on priority.
• Developed plsql package to customize IPV and PPV accounts.
• Developed PL/SQL packages, procedures, and functions.
• Developed and customized discoverer reports.
• Creation of value sets in various modules of the application.
• Developed outbound interface to extract back orders data from base tables to flat file using the UTL FILE utilities in order management module.
• Development of various interfaces and reports in INV, AP, OM, AP, GL.
• Developed control files to load data into tables.
• Executing concurrent programs from PL/SQL by using API’s.
• Development of reports using XML publisher report.
• Defined concurrent programs, executables, and value sets.
• Prepared end user training materials for users in power point and words as well.

Confidential

Trainee Consultant

Responsibilities:

• Working as an Oracle Apps Developer mainly involved in developing technical deliverables-XML Publisher Reports, Interfaces and conversions.
• Developed packages, procedures for Interface/conversion programs and sql scripts for reports as per business requirement.
• Developed Sales Order Import Interface to Import the Sales Orders from Legacy System.
• Customization of reports and Development of new reports.
• Involved in registration of concurrent programs, executables, Creation of responsibilities, request groups, menus, value sets, and functions in System Administration, AOL.
• Developed control files to load data into tables.
• Executing concurrent programs from PL/SQL by using API’s.
• Development of reports using XML publisher report.
• Defined concurrent programs, executables, and value sets.
• Prepared end user training materials for users in power point and words as well.

ENVIROMENT & TECHNICAL SKILLS: