PROFESSIONAL SYNOPSIS:

• Over 10 years of Experience on ERP in Oracle and Oracle Related Technologies Including Oracle Financials E Business Suite 11i/R12 / CDS and Microsoft NAV ERP.
• Very Good understanding of the systems development lifecycle, and all its typical phases
• Extensive Development, implementation, Migration, Testing, Production support, Customization and Integration and Change Management Processes in IT industry.
• Oracle certified professional in SQL units.
• Good knowledge and experience in using and implementing Oracle tools (6 years) RICE Oracle 9i,SQL,PL/SQL, SQL - Loader, SQL*PLUS, Oracle Reports, Oracle Forms, BI Publisher tools like XML Publisher, Oracle Discoverer, OBIEE 10g/11g,TOAD,OAF
• Good knowledge and experience in Financials, Oracle P2P & Supply Chain Management modules likeAP,AR, FA, GL,IProc,OM,Inventory,iExpense, HRMS/PAYROLL and OLM of Oracle ERP Applications 11i together with technical skills in designing & development of interfaces and data conversions.
• Experienced in using AOL, system administration and AIM Design Methodology of EBS.
• Having good exposure on database queries, Triggers, constraints, cursors, procedures, Functions, Packages and Performance Tuning Concepts like Indexing, TKPROF, Explain Plan in PLSQL.
• Adhering of the quality and deliverable standards to the client and internal quality control CMM5 and PCMM5
• Worked as a Oracle EBS/CDS ERP Consultant in Perth, Sydney (AUS), London (UK), Tokyo (Japan), Sunnyvale (USA) and Confidential (USA) For Various MNC’s.
• Excellent team player with strong customer interaction skills on technology or business issues.

TECHNICAL SKILLS:

Software Tools: Oracle 9i/10G/11i/ (Backend Programming PL/SQL, Procedures, Triggers, Packages, SQL * Loader, SQL*PLUS, UTL, Developer 2000 (Reports 6i,Forms 6i), OBIEE 1og/11g, Discoverer 4.0, 10G XML Publisher, SQL Developer

General tools: Solve Direct, Lotus Notes, Helpdesk, JIRA, HP Quality Center, Service Center, TOAD, Smart FTP, PUTTY,, Extra Personal Client (ESP), Workstation Director, ETL Data Stage, Oracle Workflow, BI, OAF ,Adobe Captivate, JSP JAVA,ITIL V3

Hardware Platforms: IBM PC compatibles

Operating Systems: Windows NT, Windows 95, XP,2000, Vista UNIX.

Application knowledge: Oracle Applications 11i (PO, OM, AP, GL, Inventory, OLM, PA, iExpense,Istore PA, IPROCUREMENT, HRMS/PAYROLL).

EMPLOYMENT HIGHLIGHTS:

Confidential

Oracle FSS ERP Production Systems Manager

Environnent: Oracle SQL/PLSQL Oracle EBS 11i ERP

Responsibilities:

• Supporting Business users and resolving issues as per SLA’s on Oracle SCM Modules like OM Inventory O2C, PO.
• Day to Day BAU and troubleshooting problems to determine root cause.
• Debugging issues in CRM and EBS 11i like Istore and Iexpenses and providing reports using SQL/PLSQL for the business users using XML publisher and Reports 6i/10G.
• Documenting the changes and writing technical/Functional/Testing and migration Documents like MD50/MD70/TE20 and MD120

Confidential

Environnent: Oracle EBS R12 ,JIRA,SSRS/BI Reports

Responsibilities:

• Involved in Backups and recovery of databases
• Supporting Business users and resolving issues as per SLA’s.
• Designing XML Publisher reports on Purchasing and financial modules.
• Debugging issues in CRM.

Confidential

Oracle ERP

Environnent: Service Desk, Oracle Applications R 12.1.3 Financials, PLSQL, OBIEE,FORMS10G/Reports10G , CDS Order Management, P2P , BO reporting, Toad/SQL developer.

Responsibilities:

• Designing various business reports using various reporting tools like Business objects, RX4 XML publisher, Reports/Forms 10G
• Designing OBIEE Dashboards.
• Creating various layers like BMM Presentation and Physical layers in oracle BI reports

Confidential

Oracle CDS ERP Analyst

Environnent: Solve direct, HP Quality Center, Service Desk, Bonita workflow, Oracle Applications R 12.1.3 Financials, PLSQL, FORMS10G/Reports10G , CDS Order Management,AR,GL, P2P , BO reporting, Toad/SQL developer. Service Desk, Oracle Applications R 12.1.3 Financials, PLSQL,FORMS10G/Reports10G , CDS Order Management, P2P , BO reporting, Toad/SQL developer.

Responsibilities:

• Day to day application support for various studios and businesses like Disney, Universal Sony, Beyond, Hoyts Fox, Universal music.
• Designing various business reports using various reporting tools like Business objects, RX4 XML publisher, Reports/Forms 10G
• Day to Day interaction with end users and resolve critical issues.
• Travelled to Japan to setup the Japan account and provide Hyper care and support.
• Creating change and service requests using HP Quality Center and involved in coding testing and support for various companies.
• Prioritizing, liaising and assigning all database (SQL & Oracle) tickets that come into the service desk from various territories across the world.
• Providing quick fixes and delegating the work load to the off-shore service desk team(India) and getting the tickets resolved according to the SLA’s / KPI’s
• Keeping track of the tickets periodically and updating the status of the ticket as and when the situation of the issue changes.
• Testing the issue in Staging and pre-production environments before rolling the changes into Production environment.
• Keeping the customer/Client in the loop during each phase from opening of the ticket to the closure of the ticket.
• Mentoring of the offshore staff to bring up to speed with regards to the operations of the various studios.

Confidential

Oracle EBS Financials Techno-Functional Consultant

Environnent: JIRA, Oracle Applications R 12.1.3 Financials, PLSQL,FORMS10G/Reports10G , Order Management (Supply Chain Modules), P2P ,GL, AP,AR, FA, Inventory, Istore,procure to Pay,Advanced Pricing , XML Publisher, Barcode ,Functional setups, Panaya ( R12 ), Unicenter,OAF

Responsibilities:

• Technical/Functional and Business Requirement gathering and business Process Mapping.
• Providing Helpdesk Support using JIRA and priortizing issues and delegating work to external contractors and getting the issues resolved with in the agreed SLA’s
• Utilizing ITIL and unicenter to log tickets and resolving SEV1 , 2, 3 issues . Including ITIL processes like Change Management, Release Management, and Incident Management to manage the customer software effectively.
• Raising TAR/SR in metalink and Oracle Support for data corruptions in AP during the upgrade to R12.
• Assisting the project team with the Requirements and Design, implementation, Migration, support and Functional/Technical Testing of Oracle EBS lli/R12 application solutions.
• Liaise with DBAs, Linux administrators, System Administrators and Business Users to diagnose and implement patches/bug fixes in production environments.
• Periodic interactions with internal customers as well as the external clients and updating the status.
• Fixing bugs reported by the end users.
• Conducting QA and User Acceptance Testing deliverables from other team members to ensure that UAT is conducted at a sufficient level of quality to meet project objectives and requirements
• Applying Oracle patches for various instances like DEV, SIT, Testing(UAT) and PROD.
• Team leader experience. Managed a team of 3 Oracle EBS Developers.
• Providing Support on Functional/Technical solutions together with extensive testing of technical and functional components including P2P cycle.
• Developed XML reports and D2K reports on Order Management module of Oracle EBS.
• Design of concurrent programs, executable and parameters, Key and Descriptive
• Flexfields, Oracle Alerts, Menus and Responsibilities and creating qualifiers and modifiers for price lists in Oracle Pricing.
• Forms customizations and personalization oracle forms in 11i/R12.
• Upgrading business solutions from 11.5.10 to R12.
• Customizations of Istore pages using JSP’s and moving the code to various environments using UNIX BOX (Putty/Winscp)
• Involved in the creation of Technical/Functional/Testing AIM Methodology documents such as MD50, MD70, MD120 AND TE20.

Confidential, CA

Technical Project Co-ordinator

Environnent: Oracle 9i, Oracle Applications 11.5.10, PLSQL , General Ledger , Fixed Assets ,(Financial and Supply chain Modules) Hyperion,Projects, Project Accounting,OBIEE, Forms/Reports 6I .

Responsibilities:

• Developed XML reports and D2K reports On General Ledger module of Oracle ERP.
• Involved as a project co-ordinator in the onsite-offshore co-ordination model.
• Involved in the project Hyperion financial management system HFM.
• Created an Oracle package, which is used to transfer GL records from Oracle to Hyperion.
• The extract file is downloaded on to the desktop and a concurrent program is run to transfer the extract into Hyperion
• Fixing bugs reported by the end users.
• Involved in the creation of technical and Testing documents such as MD120 AND TE20 and MD-070 .

Confidential, CA

Technical Consultant

Environnent: Oracle 9i, Oracle Applications 11.5.10, Oracle HR / Payroll, PO(Procurement to Pay P2P), XML Publisher Reports

Responsibilities:

• Utilized Oracle Payroll provided user feature that allows us to call PL/SQL Function from Fast Formula.
• Provided IT support for Oracle HRMS and Recurring activities include interfacing with business users to develop adhoc HRMS reports.
• Developed XML reports like lease summary and lease balances for port.
• Fixing bugs reported by the end users.
• Configure and support Oracle HRMS/Payroll R12 Core Human Resources
• Configure and support Time and Labour (OTL)
• Involved in the creation of technical documents such as MD120 AND TE20 and MD70.
• Review and preparation of test plans, test scripts and test scenarios using test case documents .

Confidential

Technical Consultant

Environnent: Oracle 9i, Oracle Applications 11.5.10,R12, Accounts Payable, Purchasing OBIEE 10g/11g,Oracle Alerts,Reports and Forms 10G

Responsibilities:

• Development and customizations of timesheet details OBIEE Reports and Dashboards.
• Involved in creating reports by extracting data from the database and presenting them on OBIEE Reports. (BMM Business model and mapping, Presentation, Physical layer).
• Developed RPD's for timesheet details report and importing them.
• Importing RPD's for the timesheet details report and registering various layers like business, physical and presentation.
• Involved in the creation of Forms like File ID using Forms6I
• Involved in the development of banking customer information using forms6i.
• Involved in the creation of technical documents such as MD120 AND TE20 and MD70.
• Fixing of various issues raised by the business users.
• Creating dashboards for the timesheet details report for users and creating user prompts and parameters and Creating simple and complex joins for various views.
• Exhaustive testing of RTF’s, RDF’s and Concurrent program parameters and reviewing and preparation of test plans, test scripts and test scenarios

Confidential

Technical Consultant

Environment: Oracle9i, PLSQL, Windows NT, Oracle Applications 11.5.10,R12 Toad, XML Publisher Reports, AP, PO.

Responsibilities:

• Worked on Oracle Financials related Discoverer reports.
• Involved in creating reports on purchase order by extracting data from the database and presenting them on xml Publisher Reports.
• Design and registering of concurrent programs in PO for Asean using sysadmin.
• Developer rtf’s for PO Thailand, HK, China and registering them using xml Publisher responsibility.
• Involved in the creation of technical documents such as MD120 AND TE20 and MD-070 .
• Fixing of production issues on PO raised by the business users.
• Creating various value sets for the parameters in the Reports.
• Developed Forms like average cost update form using Forms6i.
• Project management-project status notifications, setting up business calls and preparing necessary project documents in accordance with AIM methodology.
• Creating ldt’s and migrating the code From Dev to testing and production instances.
• Day to day interaction with the business.

Confidential

Oracle Applications Technical Consultant

Environment: Oracle9i, PLSQL, Windows XP, Oracle Applications 11.5.10, Accounts Payables,Toad, SQL Developer 7.1.4.1390 , BI Publisher Discoverer 10G Reports Admin/Desktop/Viewer/Plus, Adobe Captivate . Oracle Financials (AP/Purchasing)

Responsibilities:

• Involved In the creation of Discoverer10G reports for the presentation of data.
• Worked on the drill down feature of Discoverer 10g Reports by implementing Hierarchies.
• Fixing of technical issues as well as cosmetic issues raised by clients after go live.
• Exporting/importing EUL’s from testing environment to production environment and vice versa.
• Scheduling the workbooks and graning of privilages to the client to view the Report.
• Editing of parameters from Discoverer Viewer.
• Involved in creating CBT’s for smooth transition for new clients using Adobe Captivate on system administration as well as dicoverer 10g.
• Involved in the Creation of Technical Documents such as MD120 AND TE20, MD-070 .
• Conducted presentations on Discoverer to prospective Clients and existing clients.
• Unit testing of Discoverer components and preparation of documents.
• Project documents in accordance with AIM methodology.

Confidential

Oracle Applications Technical Consultant

Environment: Oracle9i, PLSQL, Windows NT, Oracle Applications 11.5.10, Toad, ESP, Workstation, Oracle Workflow,Director,Reports Oracle Financials (AP, Receivables, PO, FA,OM,CM, Iexpenses,Isupplier).

Responsibilities:

• Monitoring of the payment cycle for various countries in AP Module, which is registered as Concurrent program jobs using Extra Personal Client (ESP) and keeping the bad invoices on hold to stop the payment.
• Scheduling the jobs based on predecessor and successor using workstation director.
• Pulling the tickets from Production Queue into Functional queue Using Service Center and updating SC for Sev3 issues by providing level 1 and level 2 support to the users.
• Worked with workflow director and workflow tables to resolve I expense issues.
• Ongoing support and documentation of Technical Deliverables and providing Level3 ERP helpdesk support to the end user, and involved in trouble shooting.
• Co-coordinating with Onsite team, BP’s and getting the tickets resolved according to the SLA’s / KPI’s and reporting to Onsite/Offshore manager.
• Participation in a shared and rotational 24x7 Production Support on-call roster providing after hours support for Level 1 SEV issues.
• Exposure on Performance Tuning concepts like Bulk Collect, and Temporary tables and Indexes.
• Worked on datafix issues in IExpenses module using plsql script and workflow tables and compiling it in sql * plus and updating in Toad and Iexpense front end.
• Resolving Oracle SEV3 incidents and requests on credit cards in Iexpenses and Iproc.
• Worked in a transition project on the testing of discover reports for R12.
• Used Data stage to transfer the records from staging tables to base tables.
• Adhering of the Quality and deliverables standards to the client and internal Quality Control CMM5 and PCMM5.
• Worked on onsite-offshore co-ordination model.
• Knowledge of batch scheduling tool workstation director.