CV (Curriculum Vitae) / Résumé

Profile Summary
I am an Oracle Applications professional with more than 5 years of industry experience. Over the span of my career I have handled a range of roles from Team Lead, functional consultant to being an Oracle Applications Technical developer.

My expertise areas include functional skills in Oracle CRM implementations (specifically Configurator, Customer Support, Contracts and Sales). I have also extensively worked with Oracle technology tools like, Oracle Reports, Oracle Workflow, Oracle Discoverer and other programming languages. My expertise in Oracle CRM data model as well in extensive usage of various Application APIs allow me to engineer custom solutions for client specific scenarios and in solving bottlenecks during implementations.

Having worked across platforms as well as for roles ranging from technical developer, to client business analyst and solution designer, I find it easy to fit into implementation roles in projects with the ability to relate to the end-user community as well as technical staff.

Apart form technical and functional experience, as a part of project management I was involved in estimations for project, Performance appraisal of team working under me.

Technical / Professional Skills:

Engagement Expertise: • Team Lead and Project Estimation for Oracle CRM Implementation,
• Business Analyst Roles for CRM implementations using Oracle Configurator and Oracle Scripting Design and Implementation,
• Thorough knowledge of Performance Tuning for Application Customizations, Oracle Database and Strong PL/SQL coding expertise,
• Oracle Workflow, Oracle Reports Development,
Enterprise Applications Modules: • Oracle CRM (Foundation, TCA Architecture)
• Oracle iStore
• Oracle Scripting • Oracle Marketing
• Oracle Configurator, Oracle Quoting
• Oracle Sales (Customer Support)
Software, Tools & Languages • Oracle Discoverer (Plus, Administration and desktop),
• Oracle Reports 6i/9i,
• Oracle Workflow 2.6
• Unix Scripting • SQL, PL/SQL
• SQL*Plus, TOAD, SQL*Loader,
• C, C++, VB 6.0, Python 4, PHP4, HTML, CSS, Crystal Reports
Methodologies • Oracle Applications Implementation (AIM) Methodology • Accenture Delivery Methodology
DBMS’s • Oracle 10g, 9i, 8i
• Ms-Access, SQL Server • MySql
Domain Expertise and Familiarity • Telecom
• Pharmaceutical • Product Manufacturing

Education:
B.E. (Bachelor of Engineering), Computer Engineering, Mumbai University (1997 – 2001)

Work Experience:

Accenture India Development Centre, Mumbai, Maharashtra, Jan 2006 – May 2007
Team Lead, Oracle CRM Techno-Functional
Oracle Solution Services India Pvt. Ltd. Bangalore, KA, Feb 2005 – Jan 2006
Staff Consultant, Oracle CRM Techno-Functional Consultant, (Oracle EMEA Consulting)
Nicholas Primal India Ltd. Mumbai, MH, Aug 2002 - Oct 2004
Apps Technical Developer
Prangya Technologies Pvt. Ltd. Mumbai, MH, Oct 2001 - Jul 2002
Software Development Engineer

Project Experience:

Applications Customization and Support for Oracle Configurator

Organization: Accenture India Development Center

Client : EMC

Domain : Product Manufacturing

Duration :
Jun 06 – May 2007 Team Lead for Oracle Apps Techno-Functional Development on Oracle Configurator.

EMC is using Oracle Configurator to online sales and product configuration. Configuration options included the entire range of EMC’s storage devices to software’s to third party software’s, solutions.

Roles and Responsibilities
I was managing a team of 4 resources who were responsible for, supporting the customizations for Oracle Configurator and iStore. I was also playing a key role in effort estimations and in project execution monitoring.

Skill Used / Obtained
1. Oracle Configurator Development
2. Resource estimation and Business Analysis
3. Project Control and Monitoring Reports
4. Unit testing
Downtime Instance Report Implementation

Organization: Accenture India Development Center

Client : EMC

Domain : Product Manufacturing

Duration :
Jan06 – Jun 06 Oracle Apps Technical Developer and System Performance Tuning Specialist

EMC had started a project to help them reduce the downtime for Oracle Applications so that their customers world-wide can be supported through out. This provided a challenging situation requiring the Reports specific to sales & service could be pulled out within a very short time window, so that the work of the service and sales representatives is not affected.

Roles and Responsibilities
I was also responsible for providing key technical architecture inputs in meeting Client’s Application performance expectations. My expertise and familiarity with Oracle performance tuning and Oracle Sales and Customer Support Data model allowed me to contribute to the stiff deadlines while meeting the stringent performance criteria set by the client.

Skill Used / Obtained
1. Performance tuning
2. PL\SQL
3. Concurrent program & application setups
4. Unix shell scripting: install scripts
5. Documentation: Technical doc, Install doc, unit testing doc.
Instance Upgrade to 11.5.10

Organization: Oracle Solution Service India Pvt. Ltd.

Client : Telia

Domain : Telecomm

Duration :
Jun 2005 – Jan 2006 Oracle Apps Techno-Functional Consultant

Oracle had implemented Oracle Applications at Telia in phase 1. After implementation successfully, it was decided that Telia will go on for an upgrade. Since the customizations carried out were complex, it was a challenging task to migrate them to higher version of applications. Another challenging task was to identify those customizations that were part of 11.5.10 applications and to do away with them.

Roles and Responsibilities
I was given the responsibility to identify if a particular customization that were mainly carried out in modules like Order Management, Configurator and install base, needs to be installed, based on the functionality provided in 11.5.10 version.
Install the customizations and then test them, make changes in the custom component whenever required and then update the related documents. .

Skill Used / Obtained
1. Testing custom components
2. Workflow, Reports customizations.
3. Executing and creating shell scripts
4. Testing custom components in the new environment
5. Technical, install, testing documents.
Pre-Sales demo for implementing telecoms solution using Oracle Applications

Organization: Oracle Solution Service India Pvt. Ltd

Client : Telstra

Domain : Telecoms

Duration :
Mar 2005 – May 2005 Oracle Apps Techno-Functional Consultant

Customizations were needed to accommodate buying and selling of telecoms products. The idea was to allow the customer to book their orders from the web using iStore. The ordering was designed such that the customer could choose from various products offered by the company. This was made possible with the help of Configurator, which would help the customer to choose from the available list of products, such that the final list of products or services is a valid combination

Roles and Responsibilities
I was responsible for Requirement gathering and implementing customizations in Oracle Workflow and Order Management APIs, and designing flows for Oracle Configurator.
Developed APIs, PL/SQL packages and concurrent programs for integrating with other modules.
Develop and design configuration models and published them, also designed the UI for the configuration Models.

Skill Used / Obtained
1. Oracle Configurator Design and Development (CDL)
2. Workflow, PL\SQL
3. Customizing Order Management API’s.
4. Creation of shell scripts
5. Install-documents, and design documents
Applications Customization: Creating a module
In Application to handle Special phone numbers

Organization: Oracle Solution Service India Pvt. Ltd

Client: Casema

Domain : Telecoms

Duration:
Feb 2005 – March 2005 Oracle Apps Technical Consultant

Casema Telecomm solution needed a custom module that could handle special numbers.

Roles and Responsibilities
Creating APIs, PL/SQL packages and concurrent programs for integrating the module with other Oracle Applications modules like Order Management and SFM.
Oracle Reports and PL/SQL were used to generate custom reports and APIs, required for the solution. Oracle modules related to this custom module were Service Fulfillment Manager (SFM), Installed Base, Order Management.
Customizing Workflow for Order Management.

Skill Used / Obtained
1. PL\SQL, Applications API’s
2. Workflow Customization
3. Technical, Install, setup and testing Documents.
Marketing - Sales data model design & Discoverer Security Implementation

Organization: Nicholas Piramal India Ltd.

Client: In-house implementation

Domain : Pharmaceutical

Duration : Jun 2003 – Oct 2004 Oracle Apps Technical Consultant

This project was also completed as part of the on-going CRM implementation project at Nicholas Piramal. This project involved the data modeling for Business Analytics based on the reporting requirements at Nicholas Piramal and then using Oracle Applications data security to be reflected at Discoverer Admin and End user layers.

Roles and Responsibilities
I was responsible for the requirements assimilation as well for the creation of code-units that handled the security components that were used for dynamic filtering in Oracle Discoverer.
Report development using the Discoverer as well as designing the business areas through the Discoverer Administrator

Skill Used / Obtained
• Oracle Discoverer (Admin & Client)
• PL\SQL
• Oracle Database 9i.
• Design and technical Documentation
Oracle Applications Implementation & Customization

Organization: Nicholas Piramal India Ltd.

Client: In-house implementation

Domain : Pharmaceutical
Duration :
Oct 2002 – Oct 2004 Oracle Apps Technical Consultant

CRM implementation for Nicholas Piramal India Limited. : This project covers the implementation of CRM covering modules like Sales, Marketing, and Services. This includes the customization of the process in accordance with the business requirements of the company. The marketing, sales and service force of the company will be able to access the data from the Palm as well as by JSP’s. The development Platform included Oracle 11i Apps, Workflow 2.6, PL/SQL, JSP, Portals, and Oracle Reports 6i/9i.

Roles and Responsibilities
• Mapping the requirements for the list generation process on to the Discoverer and setups for the same in the Marketing Module.
• I was responsible for working on the customizations in the Sales and Marketing modules. This involved designing of new workflows and creating PL\SQL program to support them
• Creating interfaces for uploading data into applications.
• Developing customized reports using Oracle reports 9i/6i.
• The project also required support after implementation.

Skill Used / Obtained
• Report builder 6i/9i
• Interface development, data cleaning and data loading
• SQL Loader
• SQL, PL\SQL
• Workflow builder.
• Documentation: Technical, testing & install docs
X-Docs (Export Documentation System)

Organization: Nicholas Piramal India Ltd.

Client: Hetero International

Domain : Pharmaceutical

Duration:
Sep 2002 – Oct 2002 Developed and designed the application for generating Export Documentation

This application is developed for export houses to make the process of export documentation faster and automated. The screens designed capture data and the standard documentation was created using crystal reports. The Development Platform used for this project included Windows 9X, VB6.0, Crystal Reports, Oracle8i, and PL/SQL

Roles and Responsibilities
I was responsible for Database design, Coding, designing screens to capture user data, as well as customer interactions

Skill Used / Obtained
Windows 9X, VB6.0, Oracle9i, Oracle Reports6i, PL/SQL
Attendance Monitoring System

Organization: Nicholas Piramal India Ltd.

Client: Tata Shares Registry Ltd

Domain : HR

Duration:
Aug 2002 – Sep 2002 Developed and designed the application for processing attendance data, generating standard reports

This application is developed mainly for the tracking of attendance related data and processing the same. The data from swipe machine is uploaded and then processed as per the rules followed in the organization. The development platform used was Windows 9X, VB6.0, Oracle9i, Oracle Reports6i, and PL/SQL.

Roles and Responsibilities
I responsible for Database design, coding, designing screens to capture user data, making help files, creating reports and documentation.

Skill Used / Obtained
Windows 9X, VB6.0, Oracle9i, Oracle Reports6i, PL/SQL.
Develop a Custom ERP for Manufacturing Company

Organization: Pagnya Technologies Pvt. Ltd

Client: Sagarika Agnostics Ltd

Domain : Manufacturing

Duration:
Oct 2001 – Jul 2002 Develop & design custom Libraries and generic modules to support various business processes.

Designing of standard components for the application. These components could be used across applications. Following modules were developed as the part of the application:
Session Class: Development Platform: PHP4, Linux as O.S. This class is designed so as to implement the session handling. This gave the programmer to manage the user sessions and related information with more flexibility. This internally used database files to store the information.
User Admin: Development Platform: PHP4, Python, Linux as O.S.This is a module, which can be plugged into different applications to control the user access to different modules. Through this application we can also manage the user passwords, create, update or delete the user i.e. the complete user management.
Storage Class: Development Platform: Python, Linux as O.S.This class is designed so as to store data temporarily. This class provides the programmer to store information in the hash table, which internally uses a database file to store this information. This was used in the business logic layer.
Developing UI: Was responsible to design the User Interface for the application. This included designing the screens using PHP and HTML, writing the design docs, creating flowcharts and coding the logic. The back end used was MySQL.

Roles and Responsibilities
I was responsible for designing the standard libraries that could be used across the project. I was also involved in development of the User interface.

Skill Used / Obtained
Python 4, PHP, HTML, CSS, MySQL, Linux
Delivery Status of Shipment Goods

B.E Final year project

Client: Suiti Exports Ltd.

Duration:6 Months Developed a Module for the Company’s website where in a Customer could view the status of his/her shipment Online

The development platform used included ASP, HTML, and Ms-Access. This project involved the making of an interactive website for Suiti Exports. The main feature this website is to allow the clients to know the delivery status of their shipments online, which was earlier done on phone. Through this software the clients could easily know the status of their shipments by logging on to the website of the company.

Roles and Responsibilities
I was responsible for System Design, Coding and Implementation.

Skill Used / Obtained
ASP, HTML, CSS and MS-Access


Contact/Other Details
Work Authorization Status: Dependent Work Permit

Employment History

Education