Candidates About

 

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 Port Of Oakland (USA) For Various MNC’s.
• Excellent team player with strong customer interaction skills on technology or business issues.

 

Education Certifications and Training

• Oracle certification in SQL units.
• Oracle applications (DBA) training from Oracle University.
• Masters in Computer Applications (MCA), completed in Apr 2004.
• Bachelor in science (Computer science), completed in June 2001.

 

SKILLS SET:

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:

Veritas Consulting (Contract)

Role:                      Oracle FSS ERP Production Systems Manager

Duration:              Nov 2016– Mar2017         

Environnent: Oracle SQL/PLSQL Custom ERP FSS (Food Service Suite), CRM

·         Supporting Business users and resolving issues as per SLA’s in FSS (Food Service Suite),

·         Day to Day BAU and ensuring FSS and the front end Portal which is a CRM tool is in sync with the business operations.

·         Debugging issues in CRM and FSS and providing reports using SQL/PLSQL for the business users.

·         Manage IT production Systems and be responsible for the smooth running of the ERP System FSS

 

Scientific Games(Backfill)

Role:                      Microsoft Navision ERP

Duration:              Aug 2016– Nov2016         

Environnent: MS Dynamics Navision, Visual Studio,JIRA,SSRS/BI Reports

·         Involved in Backups and recovery of databases

·         Supporting Business users and resolving issues as per SLA’s in Microsoft Navision ERP

·         Designing SSRS reports using SQL server.

·         Debugging issues in CRM.

 

GJames

Role:                      Oracle ERP

Duration:              Feb 2016– May2016         

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

 

·         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

 

SONY DADC Sydney AUS)

Role:                      Oracle CDS ERP Analyst

Duration:              Aug 2014 – Feb2016         

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.

 

 

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

 

 

MSS Coventry’s  Perth AUS (Contract Role)

Role:                      Oracle EBS Financials Techno-Functional Consultant

Duration:              Aug 2012 – May 2014      

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

 

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

 

 

 

JJ Placements and Consultants, India. (Contract Role) 

Project:                 Netapp. CA, USA

Role:                      Technical Project Co-ordinator

Duration:              Mar 2011 – Mar2012        

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.

 

Description:

 

NetApp provides an integrated solution that enables storage, delivery, and
management of network data and content to achieve your business goals.

 

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

 

Project:                 Port Of Oakland. CA, USA (Contract Role)

Role:                      Technical Consultant

Duration:              Sep 2010 – Feb-2011        

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

 

Description:

 

The gateway to US commerce, the Port is located on the Oakland waterfront and is host to Oakland's tourism, estuaries and waterfront parks. 

 

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

 

Collabera Technologies, Bangalore, India (Contract Role) 

Project: PETROFAC, KPMG

Role:                      Technical Consultant

Duration:              JAN 2010 - MAR 2010 (3 months)                

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

 

Description:

Petrofac is an international provider of facilities solutions to the oil and gas production and processing industries.

 

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

 

Project:                 KPMG (APC by Schneider electric) (Contract Role)

Role:                      Technical Consultant       

Duration:              JUN 2009 - DEC 2009 (7 months).

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

 

 

Description:

KPMG is the global network of professional services firms whose aim is to turn understanding of information, industries, and business trends into value. KPMG offers its clients a full range of services, including financial and business advisory, tax and regulatory, and risk advisory services.

 

Responsibilities:

     Reports Development: 

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

 

 

 

PCL-IT, London, England (Permanent Role) 

Role: Oracle Applications Technical Consultant,

Project: Liberata Outsourcing, London.

Duration:              Sep2008– Mar2009

 

Description: Liberata has 30 years experience of delivering award winning service provision innovative business process outsourcing solutions.

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

 

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

 

Covansys India Pvt Ltd., Bangalore, India (Permanent Role) 

Role:  Oracle Applications Technical Consultant,

Project: GAP Inc, www.gapinc.com (Retail Chain)

Duration:              April2007– May2008

 

Description:         Gap Inc. is a leading international specialty retailer offering clothing, accessories and personal care products. Gap Inc headquarters offices are based in the San Francisco Bay Area and our product design offices are located primarily in New York City, San Francisco and London. We also have offices around the globe to support our store management, distribution and product manufacturing operations.

 

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

 

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

 

 

Project: 2

Duration:                Oct 2006 to March2007

Client:                     PWC (De Lage Landen -Rabo bank Netherlands)

 

Description:           De Lage Landen provides flexible asset-based financing products to help manufacturers, vendors and distributors market their capital goods in Europe, the Americas, Asia Pacific, Australia and New Zealand. In the Dutch home market, we offer a broad range of leasing and trade finance products directly to the marketplace and to clients of local Rabobanks.

 

Environment:        Oracle9i, PLSQL, Windows NT, Oracle Applications 11.5.10, Toad, Oracle Lease Management.<