Project Manager Oracle

Sumit Sinha Email: ********@*****.***

Oracle Apps Consultant Phone: +91-944*******

Experience Summary:

15+ years of IT experience on various Oracle Modules such as Financials, SCM, and Process Manufacturing.

Domain Experience on Manufacturing, Retail and Finance.

Experience in Supporting Multiple ERP System like Oracle Applications, ROSS, Navision, Marel, Bizerba and RF scanners, Weighing scales interfaces, Label printing.

Job profile includes Preparation of Project Charter, Initiation, Execution, Support and Maintenance.

Managed multiple support projects on Oracle Applications includes Financials, SCM, OPM.

Working experience on agile methodologies.

Conducting daily scrum meetings among team members.

Experience on Stakeholder management and Vendor Management.

Have used tools and techniques to gather business requirements through workshops and questionnaire.

Prepared requirement mapping solution and test strategies documents for custom requirements

Techno Functional experience in Oracle General Ledger (GL), Account Receivables (AR), Account Payables (AP), Fixed Assets (FA), Purchase Orders (PO), Order entry (OM), Shipping (WSH), Inventory (INV) and OPM Applications.

Had managed seven members’ offshore OPM IT Development and Support teams from 2007 to Nov 2013.

Followed and prepared MD 50, MD 70, and MD 120 and TE.020 Oracle AIM documentation standards.

Experience in Project Scheduling, Resource Requirement Analysis and Budgeting.

Developed a SOP Documents for the Business teams

Enrolled as Member of PMP and attended workshops.

Technical experience on Oracle Technologies such as Reports 6i, Forms Personalization, Oracle Discoverer 4/9.0/10g, Oracle Workflow 2.6, Oracle Alerts, API Programming. Oracle 10g/8.0/8i/9i and PL/SQL under Windows/UNIX environments.

ERP: Oracle Process Manufacturing (OPM) modules, EAM modules Oracle Financials (General Ledger (GL), Accounts Payables (AP), Accounts Receivable (AR), Oracle Purchasing (PO), Application Developer, AOL, Flex Fields, Request Groups.

Responsible for understanding and analyzing the provided RICE component specifications and developing solutions by using Developer 6i and 9i and PL/SQL.

GUI: Developer 2000 (Forms 6i and Reports 6i)

Reporting Tools: Oracle Reports 6i, Oracle Discoverer 4.1.37/9.0..2.0.0.

Database: Oracle 8.0/8i/9i, Application Server: Oracle Application Server 10g, and Oracle Workflow 2.6.

Operating System: Windows, UNIX. IBM AIX.

Domain expertise in the areas of Retail.

Worked on Discoverer, Forms Personalization, PL/SQL and SQL.

Worked on EDI and e-com modules.

Technical Skills

ERP Oracle Applications 11i, ROSS, Navision, Marel, Bizerba

Tools & utilities Oracle Forms 6i, Oracle Reports 6i, Oracle Discoverer 10g, BI Publisher, Oracle Workflow, SQL* Plus, API Programming, Toad, FTP, Putty, Rational Clear Case, Clear Quest, CA Service Desk, Service Centre, SQL * Loader

Operating Systems Windows, UNIX

Database Oracle 9i, 10g, 11g

Languages PL/SQL

Education & Professional Certificates

Master in Computer Application (M.C.A.).

Bachelor of Commerce, UTKAL University, Orissa, India.

Oracle Applications 11i Apps. DBA /Developer from Oracle University.

Certificate Course in Visual Basic 6, Enterprise Development, Oracle 7 / 8, Oracle Developer 2000 (Forms 6i & Reports 6i). Both from authorized training centers of Microsoft and Oracle respectively.

Brain bench certified RDBMS Concepts & Oracle Developer 2000 Programmer.

Achievements

Received a value award from IT Country Manager.

Received Star of the Moment Award.

Received a boundary less behavior award from IT director.

Spot award from US business.

Completed Silver Certification in Retail Management

Projects

1.ORGANIZATION: TESCO, Bangalore From Oct 2006 till Date

Tesco is a Fortune 500 Company, UK's leading and the world’s third largest retailer. Tesco operates over 2300 stores across 13 countries. Tesco HSC is the Global Services Arm, building competitive advantage for Tesco. The shared service centre provides IT and Business services to make the Tesco experience better, simpler and cheaper for over 300,000 Tesco employees and 15 million Tesco customers worldwide.

In 2006, Tesco announced that it planned to move into the United States by opening a chain of small format grocery stores in the Western states (Arizona, California and Nevada) in 2007 named Fresh & Easy.[

Currently leading Manufacturing support team which is responsible for providing production supporting on Multiple ERP Manufacturing Application such as Oracle Process Manufacturing (OPM), ROSS, Navision, Marel, Bizerba.

Started US operations support from Oct 2006 and successfully transitioned financials support from IBM to TESCO HSC, moved to OPM and supporting and managing till date. In 2010 fresh and easy acquired Wild rocket and two sisters manufacturing units and thus successfully transitioned other ERP systems like ROSS, Navision

Contribution:

Business Requirement, Scope Management Documents Preparation.

Managing Support and Development Projects Since 2012

Developed a SOP documents on period process for Sub ledger applications

Preparing Technical specifications MD70 and MD120.

Preparation of Test scenarios.

Training for Key users.

Worked on Setup Document (BR-100) and was responsible for configuring financial application setups in Gold instance

Configuration of MSCA and OM Modules as per project requirement in non production instances.

Identification of Key Performance Indicators

Define SLAs for 24/7 support operations based on KPI’s.

Application support for Fresh and Easy – Level 2 and 3.

Developed onshore and offshore models

Implementation of Service Management

Requirements elicitation and Solution design

Prepared Oracle Applications Roadmap

Created a SOP documents for Shop floor activities

Prepared weekly and monthly dashboard reports for management.

10:20:30 IM reduction commitment.

Techno functional Contribution:

Custom Program developed for Move Immediate using standard API.

Custom Program developed for automation of Batch Production batch close process using standard API.

Successfully migrated inventory items for the new inventory organization.

Custom FSG reports designed as per the business requirements.

RUP7 patch upgrades.

Mobile Supply Chain Application (MSCA) module configured as per business requirement on non prod instance.

To provide 3rd level support to business and ensure issues are logged via Service Centre and business is kept informed about the progress.

To interact with the In Country 2nd level team and the business on day to day basis to ensure issues are resolved and delivered as per agreed SLA.

Participate in Service Review Call to decide on support SLA and OLA Rags for different countries

Development/Customizations of PL/SQL programs, Oracle Reports, Discoverer and preparing BSD, TSD and Test Scripts for the same.

Developed / Customized the following reports using BI publiser,

Yield Variance report, Inventory Valuation report, Batch Close Variance Report.

To provide service improvements by identifying key business areas.

Worked EDI ecommerce modules along with TIMS and GSX’

Worked on WEB EDI.

2.Computech Enterprise Solutions, Hyderabad India Continuing

from Jul 2005 to Oct 2005

I was working for the client of Computech which is known as Independent Software Technology India known as (INTEC) Bangalore.

Project Description:

IOFS Project is a middleware which is interfaced with some of the modules of Oracle Apps i.e. GL, AR, AP, PO. It receives the data file from the CDR billing system. After that the data is put into the IOFS module. By running certain procedures like Mapping, Accounting, Grouping and condensing the billing data is pushed to Oracle Apps for accounting purpose and generating customer wise invoices and other related reports.

Contribution:

Custom concurrent program designed and developed for IOFS system.

3. Riyam Computer Services LLC, Muscat, Oman from Sept 2001 to Sept 2004

Worked as Analyst/Programmer in software solutions for large-scale business, Manufacturing and Banking sectors in OMAN and GCC Countries. Applications are mainly on Client / Server environments and highly oriented towards distributed group computing. Currently I am looking after the implementation of our product developed on Oracle at a reputed cosmetic & Toiletries manufacturing company at Muscat. I am independently handling the implementation of the above said company. Riyam Investment & Trading Company is the manufacturing company it produces cosmetics and toiletries and one of the leading manufacturers in this area. Other one is Riyam Marketing and Services, which is trading cosmetics and toiletries in Oman. Further, I am looking after the technical support of Waleed Pharmacy a leading distributor of medicines and surgical items with more than 10 retail out let’s all over Oman. Support to the banks namely Bank Dhofar and Oman International Bank.; Recently bank Dhofar acquired another bank called Majan bank, I was involved with the data migration from Majan banks old system to our Oracle based system at Bank Dhofar successfully

Roles and Responsibilities

:

Consulting with the Project manager on total Implementation of Riyam’s mini ERP Package called FLEXI 2000 and reporting to him on developments.

Customizing the MIS systems as per the client’s requirements apart from the existing report available in flexi.

Developing, customizing, and testing as per the client’s requirements, reporting to Project manager about the developments. Currently working on forms6i, reports6i backend as 9i & 8i. Data transfer using SQL * Loader from old system to oracle database.

Monitoring client requirements and day-to-day user requirements/problems.

Maintenance Support for Client and infrastructure facilitation for the same.

4.Adroit Infomatics Private Limited, Bhubaneswar, India from June 2000 to August 2001

Worked as a Consultant in software solutions for large-scale business sectors in India and abroad. Applications are mainly on Client / Server environments and highly oriented towards distributed group computing. I am also involved in Web Application Development for the company’s wide clientele who are under transition into 3-tier architecture.

PROJECT 1:

Project Monitoring and Support software solution for Cuttack Urban Services Improvement Project (CUSIP), Cuttack, Orissa, India. CUSIP is a project of Department For International Development (DFID), a Department of the British Government.

My specific job responsibilities are:

Study and analysis of the Systems and preparation of the System Requirement Study (SRS) document. Proper follow up of client’s requirements and negotiating upon scope of work.

Consulting with the Project manager on total structure of software development process and reporting to him on developments.

Designing the Functional Application Logic and Data Flow diagrams with root level validations and clear definition of guideline for coding.

Delegating the whole work amongst the coders after proper explanation about the coding to be done.

Conducting the dry run of the whole system.

Implementing the software at the client-end and tuning the software as per the client requirements.

Maintenance Support for Client and infrastructure facilitation for the same.

Contact this candidate