Project Oracle

Synopsis

- ** years of IT experience (** yrs on Oracle Applications).

- Oracle Application Lead for PA, AR and OTL

- Expertise in managing time bound development, support and implementation

projects and multiple time zones team co-ordinations

- Certified Oracle Fusion Applications Project Portfolio Management

Presales Specialist

- Part of Oracle Fusion Applications SWOT team created by Oracle Corp 2010

- Leading Fusion Expertise group in HP, preparing for Fusion V1.0

- Specialties - Implementation, Customization, Upgrades, Merger, Production

support, Oracle Project Portfolio Management (Project Costing, Project

Billing, Project Resource Management PJR), Oracle Financial ERP suite

(AR, OTL/OIE, GL), data warehousing

- Oracle Practice Manager for Oracle Community driving team enrichment

initiative for Knowledge Sharing

- Expertise in analyzing the legacy system business functionality and

writing the Functional and Technical specification for designing and

building by using Application Implementation Methodology

- Experience on Oracle Workflow and Oracle Discoverer.

- Awareness of SOX initiatives to make Support, Customization and

Implementation SOX compliant.

- Strong Verbal, Written Communication and Interpersonal Skills.

Professional Experience

Sep 2007 - Till Oracle Application Project Accounting (FRM)

Date Client Towers Perrin has Project Accounting, AR, OTL, AP, GL

Client: Towers and FA implemented.

Watson, My Role included

Philadelphia Oracle Project Management

Consultant Managed several Oracle E-business development projects.

Architect Lead for Project Accounting, Project Billing, Project Costing,

Hewlett Packard Intercompany OTL, FA, AR & GL.

(HP) Enterprise Lead for R12 upgrade/reimplementation for PA, AR and OTL.

Services Manage monthly releases cycles for enhancements on production.

Coordinating with client and HP developers to resolve

production issues

Oracle Techno-functional Role

Design and develop oracle E-business solutions.

Work on complex issues related to Oracle Project Billing,

Project Costing, Intercompany, Borrowed and lent, OTL

Work on issues related to PA interface with HRMS, OTL,

Financials and FA

Work on custom interfaces, client extensions, custom forms etc

as a part of solution

Support 11.5.10 and R12 releases

Communicate with Oracle Support for SRs and product

enhancements

Involved with user training, support during training and

defects resolution.

Presented Lawson Vs Oracle features to client that helped in

decision making.

Oracle Practice Role

Oracle Practice Manager for community communication and

practice enrichment activities like "Team Collaboration" for

knowledge sharing and communication within team of 100

Oct 2006 - Sep Oracle Practice lead for Oracle Fusion Application V 1.0

2007 related analysis, information sharing and team development.

Client: Towers Involved with pre-sales activities for Oracle Practice

Watson

Philadelphia Oracle Application 11i Project Accounting (FRM)

Oracle 11i Techno- Towers Perrin is in process of implementing Oracle Project

Functional Accounting, OTL and Accounts Receivable with vendor Cap Gemini

Consultant and transitioning it to EDS for support.

My Role included

Implementation lead for HP team.

Project lead for the customization and support on Oracle

Projects.

Involved with transition activities for HP.

Mar 2006- Oct 2006 Involved with Knowledge transfer coordination for AR, PA and

OTL

Client: EMC Corp Involved with design and development of Employee Bill Rate

Oracle 11i Overrides

Techno-Functional Involved with user training, support during training and

Consultant defects resolution.

Designing the process flow for support and customization

activities as per SOX.

Oracle Application 11i Project Accounting System (PAS)

EMC has an implementation of Oracle Applications in 46 OUs,

with lot of customizations, interfaces and client extensions.

It has Project Accounting on 11i and AR, Order Management on

11.0.3. Various interfaces are designed to import data from

11.0.3 to 11i and back.

My Role included:

Support lead for Production support

Mar 2003 - Feb Implementation and setups of PA for Russia OU

2006 Development lead clean up scripts for Synergy R2

Oracle Corp. Development for Time and Material Billing Extension.

IT Consultant 2 Production Support(Peregrine, ControlM, Harvest) Month end and

(Techno Functional Qtr end Support

Consultant) Customizing the interfaces from Order to PA and PA to AR

Creating concurrent programs (SQL reports) for daily exception

queries

Oracle Applications 11i (APPSIT-FC) Project Accounting (PA)

Oracle Projects is a central part of the complete software

solution for project-oriented companies, providing you with a

flexible approach to defining and structuring projects, tasks,

and budgets by which to monitor project status and generating

revenue and invoice for the work done and interfacing it to

other applications like GL and AR

Key Features:

Oracle Projects Setup, Project Costing/ Billing

iTime & iExpense, Oracle Time and Labor (OTL)

Interface to AR, GL, AP, HRMS

My Role included:

To support, implement, customize and create reports for Oracle

Project Accounting application used globally in Oracle

Corporation

Implementation

Project Accounting Implementation and setups for new countries

Implementation of Labor cost rate schedules.

New expense related expenditure type setup.

Implementation of Bill rate schedules and multicurrency

setups.

Involved with Inter-company Implementation.

Implementation of Auto-accounting Setups for people-soft

migration UBR.

Customization

Customization of Oracle iTime approval workflow.

Worked on MD50, MD60 and MD70 for customizations.

Customization of concurrent request interfacing PA data to AR

Developing custom reports using Oracle Discoverer.

Developed reports on revenue reconciliation.

Support

Worked on 11.5.8, 11.5.9 and 11.5.10 multi-org environment.

Provided production support during month-end, quarter-end and

year-ends.

Provided Production support for iTime, OTL and iExpense with

Projects issues.

Testing the application upgrade, applying patches and raising

bugs against the application

Involved with 11.5.9, 11.5.10, FPM upgrades and WESIAP, Japan

and CRM Merge.

Worked extensively on contract projects with multicurrency

setups

Involved with People-soft Migration.

First point contact for Oracle Discoverer related issues.

First point contact for performance related issues.

Providing application related training, support and

coordinating with users

Coordinating with support teams in US, EMEA and APAC.

Supporting integration of PA with AR, GL, AP and HRMS.

Ensuring SOX compliance for support and customization process.

Oracle Time and Labor OTL

Oracle Time and Labor is an independent application that meets

time entry needs for employees and contractors for the entire

E-Business Suite.

Key Features

Integrations to Oracle Projects

Automated notification and approval process using Oracle

Workflow.

Implementation

Involved with OTL implementation for non-Exempt employees in

US

Involved with OTL implementation for US consulting.

Set up time entry validations and approval styles, Set up

preference

Customized the layout for timecards.

Oracle Applications 11i (APPSIT-FC) Project Resource

Management (PJR)

Oracle Project Resource Management is a self-service

application to manage the deployment and capacity of your

resources in a global environment. You use this application to

manage your project resource needs, project profitability, and

organization utilization, by locating and deploying qualified

and available resources to your projects across your global,

extended enterprise.

Key Features

Based on OA Framework it's a self-service application.

PJR has Role based security, automated notifications &

approvals using Oracle Workflow

Automated notifications and approval process using Oracle

Workflow

Interface with Oracle Sales online.

My Role included:

PJR Implementation and support for 3 months in Oracle UK.

Implementation

Involved with PJR implementation in 10 APAC Countries

Support for PJR implementation in 12 European countries.

Creating PJR responsibilities and assigning the profile

options.

Creating PJR Roles and competencies

Organization setup for PJR, Defining calendars

Customization

Work on MD50, MD60 and MD70 for customizations.

Customizing PJR application as per business requirements

Customizing the workflow notifications

Customizing security package, Transaction control

customization.

Customizing PJR forecast reports.

Personalization of the application for different

responsibilities.

Support

Production support for PJR for 40 countries

Coordinating with Product development to provide timely

solutions for the bugs.

Using Oracle Workflow Builder for resolving issues with

notifications.

Using OA framework to resolve user's issues

Training other resources in IDC on this application.

Involved in PSFT merge project.

Oracle Discoverer

Key Features

Ad-hoc query, reporting, analysis, and Web-publishing tool

Discoverer Plus, Discoverer Desktop and Discoverer admin

My Role included:

First point of contact for oracle discoverer for Projects and

PJR

Customization of discoverer folders using Oracle Discoverer

Admin

Adding new custom folders to the business area.

Coordinating with users to understand the functional

requirements and map it with the field available.

Involved with resolving all kind of performance issues with

discoverer reports.

Requirement Analysis for KPI and Operational Metrics

In the process to help business to enhance and simplify the

processes and functions we decided to understand the

requirement for KPI (Key performance indices) and Operation

Metrics and to provide the same in the form of discoverer

reports.

My Role included:

Understand the process that business follows.

Get the details of statistics they maintain and information

they daily require for KPI

Creating functional design Docs MD50 for the requirements

Create a data model to get the information from the product

tables

Coordinate with business and developers to explain the

requirements.

Validate the reports created by the reporting team.

Analyze the performance issues with the reports and resolve

them.

Create custom folders in Oracle Discoverer for the

requirement.

May 2001 - Mar Gracess

2003 Requirement to convert its nine applications currently running

Tata Infotech Ltd on IBM's mainframe environment to NT/Oracle-Java environment.

Pune, India

Associate System My Role included:

Engineer Junior DBA for the project.

Member of conversion team for PL/I to PL/SQL and Java.

Writing PL/SQL procedures for business logic.

Working on Struts framework.

Generating reports on Crystal Reports 8.5 using the PL/SQL

procedures.

Working on Reporting API in Java using Crystal Enterprise 8.5

United Nation Budget Information System

Enhancement from legacy system to windows platform and web

based. Data Migration from IMS DB to Oracle 9i.

My Role included:

Working on Technical Design, Working on Database Oracle 8i,

Oracle 9i.

Coding for the screens using VB 6.0, working on application

security.

Creating PL/SQL Procedures and Functions for the requirement.

IT Systems and Technologies

Programming PL/SQL, Java, JSP, VB, C, C++, ASP, HTML, PL/I, CSP

Languages OA Framework, Struts Framework

Frameworks Unix, Windows NT/2000, OS 390 and MS-DOS

Operating Systems Oracle 8i/9i/10g, DB2, IMS, MS Access.

Database Management Oracle Discoverer 4, Toad 7.6, SQL * Plus, Oracle Workflow

Systems Builder, Visual Age for Java, Visual Age Generator

Tools and Techniques 4.5,Crystal Reports 8.5, Oracle Reports, VB 6.0.

Certification for SQL Tuning Training, IBM Certified DB2

Certifications Professional

Academic Qualifications

Jul 1999 - Apr 2001 Master of Business Administration (MBA)- Information Systems

OOPS, RDBMS, ERP, Software Engineering, Information

Institute of Technology, Oracle 8, Developer 2000, C++, C, Unix.

Management Studies, Financial Management, Cost Accounting, Financial Accounting,

Devi Ahilya Business economics, Strategic Management, Organizational

Vishwavidhyalaya, Behavior

Indore

Manish Karamchandani

Ph: 612-***-****

**********@*****.***

Contact this candidate