PROFESSIONAL SUMMARY:

• Professional with more than 12 year of experience in Oracle financials and Supply Chain transformation, implementation, upgrade and support for technology services business requirement Worked with various clients across globe on Oracle ERP with institutions such as GE, Cisco, UN, Qantas Airways, Oxford University, FT, Mineral Technology Inc., PPG, Charter Steel, Confidential and Key energy.
• On IT improvement initiatives, implementation, upgrade and support assignment with references available on request Expert Oracle Applications Consultant(RICEFW\CEMLI) in EBS 11i/ R12 /R12.1.3 /R12.2 with P2P Financial and SCM Module (INV/PO/BOM/WIP /iExpense/iProc/AP/AR/CM/PA /FA /OM/ GL) Experience in AGIS / AME / BI Publisher/APEX / OAF / ADF / SOA / SLA and MOAC related components Global experience in leading the team with onsite offshore model ITIL Certified and well versed with ITIL/ITSM concepts.
• A cohesive team player, quick learner who can work individually as well as lead the teams by building professional relationships and in other areas to achieve beyond targeted productivity. Worked on Various Oracle tools and technology like.

TECHNICAL SKILLS:

Front End: Forms 6i, 9i,10g and Reports 6i,9i,10g OAF, ADFRDBMS Oracle 8i, 9i and 10g,Data Partition,VPD,SQL using Explain Plan, TKPROF &SQL Trace

Oracle ERP:   Oracle Financials 11i, R12, R12.1.3, R12.2.2 (AOL, INV, iProc, PO, BOM, WIP, iExpense, AP, AR, CM, PA, FA, OM, GL)

Oracle Tools: SQL*Plus, PL/SQL, TOAD, BI Publisher, AME, Oracle workflow& Discoverer Report

Programming Languages : SQL, PL/SQL, JAVA, C, C++, COBOL, Basic

Web Technologies : JavaScript, XML, CXML, ASP, HTML

Packages : MS - Office, MS Visio, WIN-CVS

Version Control Tool : PVCS, Kintana, SVN, VSS

Operating Systems : MS-DOS, Windows9x/2k/XP, UNIX

Others : $Universe, Data loader, WebADI, ADF Data Integrator

Tracking Tool : Jira, BMC Remedy,Support Center,Bugzilla, Microsoft share point

WORK EXPERIENCE :

Confidential

Oracle Techno Functional Consultant

Key Activities:

• Complete Migration of Document Repository system from Alfresco to SharePoint
• Requirement analysis and system Design for Integration, Get Applied to Account Receivable
• iProc Punch Out : New Supplier Setup
• OAF/Forms Extension and Personalization
• Workflow changes for Oracle Project, Budget approval (PABUDGWF)
• Changes related to AME and Workflow
• Custom reports development for EAM(Labor booked by Employee)

Confidential, US 

Oracle DW Consultant

Key Activities:

• Requirement analysis and system Design Data warehouse Component
• Worked on Packages, Stored procedures, Function and Oracle Objects
• Oracle utilities SQL * loader to load the data in to the Oracle database
• Design and code reviews and documented best practices, and ETL procedures, Unix Shell scripting
• Prepared deployment script for code migration to CRP / UAT and SQL Reports for cross validation

Confidential

Senior Consultant

Key Activities:

• Participated in requirement analysis and prepared code guideline standard
• Requirement gathering for EAM, prepared field mapping and template creation for conversion
• Developed generic, reusable code to migrate EAM,Inventory and Supplier,code review, unit test case
• Deployment script for code migration to CRP / UAT and other instances
• Technical specification (CV40, CV60, TE20, TE40 and MD120 ) with respect to conversion requirement

Senior Oracle Consultant

Key Activities:

• Worked on Packages, Stored procedures, function and custom table and oracle objects as to reflect R12.2.2
• Worked on report and Edition views to upgrade to R12.2.2 and preparation of deployment script
• Test review related to test cases for uplifted objects (TE20, TE40)
• Analysis and review of the oracle application patches,worked on design, re-engineering, development, deployment and fine-tune of Oracle Stored Procedures and Packages (MD70)

Confidential

Senior Oracle Consultant

Key Activities:

• Prepared, performed and reviewed unit test cases ( TE20, TE40,MD70)
• Oracle utilities SQL * loader to load the data for customer conversion
• Worked on development and deployment of script for customer conversion
• Prepared technical specification document ( MD70, TE20, TE40 ) for conversion requirement /upgrade and reimplementation requirements (MD70)

Confidential

Senior Oracle Consultant

Key Activities:

• Post Production Support for all modules related to Confidential (PO, iExpense, AP,AR,PA and OM)
• iProcurement punch out /PO approval routing through AME Rules and workflow
• Analysis, Estimation and deployment of new enhancement
• Conducted root cause analysis and fix for Bank transaction reconciliation in AR lockbox and other related issues
• Prepared technical specification document with respect to changes in Support Assignment

Confidential

Senior Oracle Consultant

Key Activities:

• Conducted requirement gathering and high level technical design ( MD70,CV40,CV60 and TE20 and TE40 )
• Analysis, estimation and development for component to stabilize the system,RCA (Incident, service request)
• Leverage the knowledge and practice about ITIL process

Confidential

Senior Oracle Consultant

Key Activities:

• Data Conversion and migration (PO, AR and OM ) - Requirement gathering and data Analysis
• Prepared technical specification document ( MD70, CV40, CV60,TE20,TE40) for conversion requirement
• Worked on Packages, Stored procedures, Function and custom table and oracle objects
• Worked on BI publisher report for customization - AR Invoice Print and Customization - Remittance Advice

Confidential

Senior Oracle Consultant

Key Activities:

• Worked on requirement gathering, analysis and high level design for SFDC Integration
• Prepared mapping of SFDC fields with Oracle teleservice and their data type
• Lock Mechanism and Message service build to cross check,Service Request across the System (OTS / SFDC)

Confidential

Senior Oracle Consultant

Key Activities:

• Customized sales order workbench Forms as to hold booked order with more than 90 days (SOX 90 day policy)
• Development of technical specification document (MD70, TE20, TE40 )

Confidential

Oracle Consultant

Key Activities:

• Worked on development of technical specification document (MD70, TE20, TE40 ) and Support documentation
• L3 Support for Qantas eBS Oracle Finance and worked with end client to advise on business Improvements
• Conducted knowledge transfer to Qantas eBS (Oracle financials,11i ) and worked on user provisioning

Confidential

Oracle consultant

Key Activities:

• Worked on migration of R12 for travel module from oracle financials 11.5.9
• Development of technical specification document (MD70, TE20, TE40 )
• Customization of workflow for travel module in R12 and Audit report in XML publisher

Confidential

Oracle consultant

Key Activities:

• Responsible for development, enhancement and support activity
• For Issue analysis - worked on root cause, replicated the issue in Dev/Stage, oracle support to fix problem
• Worked on issues related to oracle workflow Builder, background process and code walk through
• Scheduling of concurrent request and monitored jobs on $Universe

Confidential

Oracle consultant

Key Activities:

• Requirement analysis for the project, development and Testing
• Design for the screen and Involved in data dictionary design with DBA
• Developed PL/SQL code, for form and Report
• Development and implementation of forms and report followed by V testing model