Project Oracle

Resume

Manish Parnerkar Cell : 678-***-****

Oracle EBS Business Analyst

Email: ************@*****.***

About 15 years of experience in Information Technology and Business

Processes in which about 6 years in the field of Oracle Applications

Executive Summary

. Seasoned and dynamic Senior EBS Functional Professional with an eventful

career of over one decade studded with professional brilliance

predominantly in the areas of implementing 11i Oracle Financials (GL,

AP, AR, FA,iExpense and CE), Oracle Manufacturing (Inv, Purchase, OM),

Oracle iSetup, Oracle Setup Manager and Oracle Identity Manager

components. OVD, OAM and working exposure in capacity of System

Administrator for Oracle Applications Release 12.

. Thorough understanding of Oracle Technologies covering Oracle Database,

SQL, PL-SQL, and Oracle Development Tools coupled with rich experience in

AIM (Application Implementation Methodology)

. Comprehensive domain grasp across functional areas and expertise in

Software Development Life Cycle (SDLC) including Project Scoping,

Requirement Analysis & Technical Specifications, Effort Estimates through

Functional Point Analysis, Risk Management, Planning, Monitoring and

tracking, Reporting and Communication Management, Process Compliance &

Process Management, Change Management and Resource Optimization using

ITIL.

. Versatile Professional with sound understanding of Development and

customization of RICE Components to integrate Oracle Application Modules,

Configuration and setup Management, Application Object Library (AOL),

Electronic Data Interchange.

. Decisive leader capable of leading and managing multi-sited project teams

while ensuring judicious resource allocation and utilization.

. Articulate communicator, deft in collaborating with the Global Project

Team Members, ERP Architects and Testing Team Members for successful

execution of projects.

. Enriched with the latest trends and techniques and a wide range of skill

in Project Management, Quality Initiatives, Technology, Critical

Thinking, Troubleshooting, Problem Analysis and Resolution.

Technical and Functional Skills

ERP Technical: Oracle Application R12 & 11i - System Administration

Security Administration, OVD,OAM

ERP Oracle Application R12 & 11i - Implementation of GL,

Functional: PO, AP, FA, AR, CE, Projects, Service Contracts,

INV,iExpense WIP iSetup

Methodology: AIM (Applications Implementation Methodology), CEMLI

Standards

Tools: Oracle SQL/Pl SQL, Oracle Forms 6i, Oracle Reports

6i, Oracle Discoverer 4i, Data loader 3.0, Quest

Toad 8.0, IDM version 3.0.1,HP Quality Center 9.2 HP

PPM Center V 7.1.0,Microsoft SharePoint

2007,Microsoft Visual Studio 2005 Team Explorer,

Microsoft Project 2003, Microsoft Visual Basic

6.0/5.0, Remedy Incident Mgt 7.5, Informia Archive

5.3 and Informatics Sub setting, Hotsos Hawcs Tool

for ERP Performance analysis,Noetix EUL Generator,

Noetix Views.

Databases: Oracle 11g, 10g, Microsoft SQL Server 6.5

Operating RedHat Linux 3.0, OEL 5, Microsoft Windows Server

Systems: 2000/NT

Work / Project Experiences

Client: TD-Ameritrade, Omaha, Nebraska

Duration: Since April'2010

Role: Oracle EBS Business Analyst

TD Ameritrade (TDA), one of the top 10 companies on Wall Street, involve in

trading brokerage, acquired Think or Swim (SWIM) Brokerage Company in June

2009. Investools Inc, an educational division of Think or Swim Inc is using

SAP Business Suite CRM/ERP for managing their business processes. While TDA

is using Salesforce-CRM and Oracle-ERP systems for managing their

businesses. In order to make uniformity of the platforms, TDA initiated

this SAP Migration Assessment project. Scope of this project is to

understand current Investools Inc. SAP CRM/ERP business processes and map

them to the SFDC CRM/ Oracle ERP system. Provide business with a

comprehensive Proof of Concept, Assessment analysis, and Migration

strategy.

Project: Harmony - TDA SAP Migration Project

Accomplishments:

. Understanding Oracle ERP processes at TD Ameritrade.

. Analyzing SAP ERP processes at Investools Inc. and mapping them on

Oracle ERP

. Intensely conducted meetings with business and technology groups at

both organizations

. Business processes streamlining and processes re-engineering

. Providing technical architecture of the target platform, with all

interfaces

. Identifying the need of third party tools, required number of licenses

and users

. Prepared overall financial model for cost benefit analysis between SAP

ERP & Oracle ERP

. Estimating migration project efforts

. Providing the migration strategy from SAP ERP to Oracle ERP in phase

wise model

. Configuration of the OM,INV, AP,AR,GL, CE, iExpense, Projects on the

send box as part of the POC

. Mapping processes like Order Management, Billing/Invoicing, Inventory

and Pricing Management, Revenue Recognition processes, Refunds,

Cancellations, Cancellation of partially paid orders Profitability

Analysis of different educational business events in Oracle ERP

. Presentations to stack holders by demonstrating As-Is and To-Be

business processes

. Deliverables : As-Is System Study, To-Be system Study, POC

configuration documentation, Assessment Analysis (on ROI and

Financials), Migration Strategy, High level data migration plan,

Interfaces between different External systems, customization efforts,

Integration plan with third party systems like Vertex, Pay metric and

Echo.

. Recommendation report for upgrade from 11i to R12 in accordance with

study of As-Is and To-Be analysis

Client: Odebrecht, Coral Gables, Florida

Duration: November'2009-March' 2010

Role: Oracle EBS Business Analyst

Odebrecht is a pioneer organization based in Brazil, involved in businesses

like PetroChemicals, Constructions globally and one of the leaders in

Brazil, expanding business in Air Port, Arena Constructions, in US and

Latin American countries. Odebrecht uses Oracle Applications Suite (12.0.6)

as its main system for its Finance/supply chain Management in business

along with external system application for inventory management globally.

Project: Odebrecht Global Sourcing Implementation Project

Odebrecht is having a Multilanguage single global Instance of Oracle

Applications R12 for managing day-to-day operations of the business

includes modules for Financials, Supply Chain, iProcurments, Sourcing

across globe. OGS is one sourcing subsidiary in the umbrella of companies

scoped for implementation of Oracle R12.

Accomplishments:

. Collaborated with the Brazil Team to schedule Key User testing and

scenario testing of the OGS

. Instrumental in planning Pre-Prod deployment preparations, creation of

BR100 Documents or the support team to move this new project in

production UAT testing strategy to ensure smooth deployment of the

project in the production with the security and change management

policy of the Client

. Instrumental in configuring Back-to-Back order processing cycle in the

QA environment and creation of the BR document

. Worked on translation of all the AOL, COA components in the

application for this MLS project with base language as Portuguese and

other languages Spanish and English (US).

. Worked with Oracle support teams for the issues management and fix

with the Oracle Support Team

. Creation of the BR100 for Translations of all the components in

English for GL, AP, PO and AOL components.

Client: Dell Inc., TX

Duration: June'2009 - October'2009

Oracle EBS Consultant (Lead)

Dell is a SOX compliant Organization which uses Oracle Applications Suite

(11.5.10) as its main system for its Finance Management in business along

with external system applications for Supply Chain, Distributions,

Manufacturing functions, payroll, and HR functions and consolidations.

Project: Global Oracle 11i Hardware Upgrade Project (64 bit)

Dell is currently implemented there Oracle 11i (11.5.10.2) Financial

Applications on the Oracle 10.2.0.4 database on Red Hat 3.0 Linux

platform with 32 bit DBTier on the Dell's 2850 server for Apps Tier and

Dell's 6850 servers on the DBTier. The scope of this project is to upgrade

Database to 11.1.0.7, on 64 bit DBTier on OEL 5 Linux platform on Dell's

2950 series server for Apps Tier and Dell's R900 series servers on the

DBTier with Flashback Recovery Area feature. This project overall impacts

globally as all the 300+ RICE Components with about 100+ Interfaces with

the external systems needs to be interlocked and need to be tested to avoid

any business Impact which are scheduled over a period of time with Dell's

Manufacturing applications.

Accomplishments:

. Collaborated with the EMEA/APJ and AMERICAS External System Team to

schedule testing of the interfaces in co-ordination with the SIT Team.

. Instrumental in planning Pre-Prod phase I and phase II SIT and UAT

testing strategy to ensure smooth deployment of the hardware in line

with the security policy of the Client

. Engaged external systems teams during Pre-Prod phase II testing, for

string and penny test between their production boxes and 11i Pre-Prod

boxes.

. Coordinated with the Dell's Support Teams - Engineering, Security, DBA

Teams, Grid Control Team, and Global Server support Team etc. for

preparing MD120 Document for the Upgrade Project.

. Integration Testing and Support for all systems with Active Directory,

IIS which are using OVD as part of the identity Management used by the

Oracle EBS.

Project: Implementation of the Global Scheduling Tool BMC's Control-M for

Oracle ERP

Client is having a global scheduler (BMC's Control-M), which is a installed

organization wide; all applications which are running their scheduled jobs

need to use this tool, viz. (Linux cron jobs, Oracle backup jobs,

Concurrent Jobs etc) as per the security policy, in order to track changes

on the server side jobs for any scheduled jobs in production for 11i

application. As part of its implementation

Accomplishments:

. Actively involved in researching pre-requisites for the Control-M

implementation with Oracle Applications, and identifying current

scheduled jobs in the Oracle ERP Production.

. Installed Control-M agents on the test servers, configured control-M

owner accounts for running cron jobs, scheduling control-M jobs and

testing the notifications & impacts

. Created and conducted knowledge transfer sessions for the Production

Support Team and created MD-120 production deployment.

Project: Implementation of the Oracle iSetup for Oracle 11i Global

Instance.

Dell's Oracle Financial Application is having a Quarterly Release process

for introducing any Change Requests, New Project in production, there are

different streams for the production Trouble tickets, new project, in order

to have all these instances in-synch for any code delta and setup, they

opted iSetup Module.

Accomplishments:

. Identification of the patches needed for the implementation of the

iSetup in the existing 11i

. Creation of the iSetup Dev instance with support of DBA Team with

mapping to all Release Environments

. Supporting Project Testing team in closing environment/Functionality

related defect logged in Quality Center

. Working with Oracle Support for logged SR / Bugs identified related to

iSetup Module

. Preparing Technical Training document for the Production Support Team

as part of the Production Transition Requirement.

. Preparing MD120 Doc for the iSetup Production deployment.

Client: Greatbatch Inc., NY

Project: Oracle E-Business Suite 11i AP Close process implementation and

maintenance

Duration: January'2009 - May'2009

Role: Oracle EBS Analyst

Greatbatch Inc. is a $400M company, leading supplier of enabling technology

to the implantable medical industry and for critical commercial

applications.

Project involved analysis of existing business processes, designing and

implementation of AP close processes for their France operating unit.

Accomplishments:

Functional: involved GAP Analysis of existing processes and Deliverables

comprises of AIM Documentation (BR100, MD50, MD70 and MD120 documentations

for AP Core setups. Actively involved in planning and managing Payable

Period Close Process and Activities from user perspective, training to the

user for the Period close processes.

Technical : required to work with offshore development and apps DBA team

members in defining and implementing strategies such as Instance

Management, Code Migration and application Patching Application License

Identification and management, preparation of TA-50 documentation.

Client: Dell Inc., Austin, TX

Project: Novora 11i Oracle Applications (Finance) upgrade from 11.0.3 to

11.5.10

Duration: July'2006-October'2008

Role: Oracle EBS Analyst

This is a Global implementation with all regions across global in a single

instance, for the 3 regions - APJ, AMER and EMEA. They have more than 72

Sets of Books and more than 100 interfaces and customized components. My

scope being GL configuration I am involved in the following tasks:

Accomplishments:

. Complete GL setup from Chart of Accounts, Currencies, Calendars,

Flexfield Structure, Accounting Flex field Values, Descriptive Flex

fields, Set of Books, Legal Entities, Operating Units, Profile Options

to Journal Categories, Journal Sources, Document Sequencing and other

transaction related setups with deliverable as BR100.

. Setting up CRP, SIT, Conversion and GOLD instances in a multi org

environment

. Testing and updating the Test Directory (Mercury Quality) and

resolving functional issues

. Setting up FSGs

. Troubleshoot issues arising in Interfaces and Conversions

. Preparing Business requirement document and Functional specification

to develop code

. Prepare User Test plans along with Test cases

. Review User Test plans

. Extensive use of Data loader for uploading Segment and Crosswalk

values, Period Rates, etc

. AFF Segment value maintenance - updating from 11.03, renumbering them

to 11i values

. Preparing training documents for the Systems Control Group (SCG),

which is responsible for the functional maintenance of the application

post go-live

Post Go-Live (Jun 07), involved in Functional and System administrator

tasks for the ongoing Release Management schedule of the client.

. Interview key subject matter experts to determine current IDM/security

hardware and software profile.

. Performed Requirements Gathering for a Proof of Concept to be

implemented into their environment in development.

. Reviewed current architecture and business requirements for an

Identity Management Solution

. Analyze current network layout, services and resources to determine

required access.

. Determine user roles and responsibilities, classifying like users into

groups to ease maintenance and rule implementations controlling access

to resources appropriate to user and group classifications.

. Analyze and document (both existing and potential) solutions for the

following: User account provisioning/de-provisioning, Password

Management, Role-Based access control, Strong Authentication,

Centralize Database Account and Role Management.

. Provided a detailed solution document with multiple vendors listing

the benefits and disadvantages between each of the suggested product

suites and combinations.

. Integration of Microsoft Share Point application having Active

Directory, LDAP for authentication and authorization using OVD

. Troubleshooting issues - AP and GL

. Additional/amending setups as and when required

. Closing support

. Functional Security, Data Security

. Managing Concurrent Programs and Reports, Profile Options

. Oracle User Management and Auditing System Resources

Client: Unisource, St.Louis, MO

Project: Data conversion

Duration: August'2005 - June'2006

Role: Oracle Techno-Functional Consultant

Accomplishments:

. Involved in Design, Development, Implementation and Testing of

Conversions, Interfaces and Reports for Oracle Application modules AP

and PO.

. Worked in Legacy data conversions for customer, vendor, salesperson,

Invoices and receipts

. Interacted with Business users during the design and user acceptance

Testing.

. Post acceptance training schedules for proper integration of

interfaces to the technical team using manual and to specially core

accounting and Order processing department employees.

. Scheduling of all UAT training and Training material preparation

(Classroom and CBT)

. Understanding the future report requirements & interacting with the

technical team for building the same

Company: Spider Systems Pvt. Ltd., Pune, India

Duration: July'2004 - July'2005

Role: Oracle Applications Technical Consultant

Worked for different clients (like Idea, RUCHA, KPIT etc) for their

implementation, support and ERP User Training projects.

Accomplishments:

. Client Interaction from techno-functional perspective, study

technicalities involve in achieving Client Requirement.

. Conversion of data from legacy system to oracle application using

Customer Item Import, Daily Currency Interface, Budget Upload

Interface.

. Designed MD70 Technical Design Document for various Interfaces

. Responsible for Corporate Training to Users on the ERP applications on

the client site involving Client Project Management Team.

Company: DT Treasury, Finance Deptt, MP

Duration: March'1995 - June'2004

Project: State Finance Monitoring System (SFMS Version 1.0)

Role: System Administrator

This project mainly deals in the monitoring and controlling of State

Finances using Information Technology as tool which comprises online

operations of about 262 Treasury offices.SFMS covers 9 modules (Master/

Payment/ Receipt/ PD-ED-Deposit/ Pensions / Stamp & Strong Room / Pay Roll

Management / Non Banking Treasuries/HRMS) along with almost 70 sub modules

with about 300 transaction forms, and 270 Report forms on the application

Server. This is an ERP application for catering management of Financial,

Human Resources of the State of Madhya Pradesh Government for adequate

decision making on the HR and Financial Policies of the Government.

Accomplishments:

. Responsible for preparing SRS, SDD for the SFMS Software application

as per Treasury code of Govt. of India, in capacity of project team

members from Department of Treasury, Govt of MP, as per Treasury Code.

. SRS and SDD Review

. Preparation of Test Cases for the SFMS application Software,

. User Acceptance Testing of Application Software

. System Administrator responsibilities like Patch Management,

Implementation at Treasury sites.

. This Project won the prestigious Golden Icon Award for the best IT

project among all Govt and public sector undertakings across India.

. Designing of Interface for integration of Agent banking software and

Oracle Custom application (SFMS) for the smooth transfer of data.

Earlier Employment Details:

Company: Satisfaction Marketing Pvt. Ltd., India

Duration: June' 1994 - February'1995

Role: Systems Officer

Company: Baba Saheb Ambedkar National Institute of Social Sciences, India

Duration: Oct'1992 - May'1994

Role: Data Analyst- IT

Academic and Professional Credentials

Master of Business Economics from Devi Ahilya University, India

Post Graduate Diploma in Computer Science & Applications, Vikram

University, India

Bachelors in Sciences, Vikram University, India

Professional Training and Certification

Oracle University Training on EBS R12 "Installation, Patching, Application

Maintenance"

Oracle University Training on "11i eBusiness Suite Essentials for

Implementer Ed 4"

PMP PDU Credits, St. Edwards University, PEC, Austin, Texas

Oracle 8i Certified Professional Database Administrator, Oracle

Corporation

Redhat Linux 2.1 Training

Larson & Toubro Ltd - Advance Training on Network system administration

Microsoft Certified Professional in Developing Applications with Visual

Basic 5.0

Microsoft Certified Professional in Implementing Database Design on SQL

Server 6.5

References & Supporting Documents Available upon Request

Contact this candidate