Sr. Siebel/Oracle Managing Consultant

Summary of Experience:

* ***** ** ********** **** Siebel/Oracle Technologies and Data Migrations.

Strengths:

• Excellent work ethics, self-motivated, quick learner and team player with strong analytical and leadership qualities

• Detail-oriented leader with accelerated analytical and problem solving skills

• Dedicated team player with exceptional communication skills

• Works well independently and interdependently across multiple functional and business teams

Summary of Qualification:

• Siebel 7.7 certified professional with extensive hands on experience with Siebel Configuration and eScripting across multiple versions

• Designing and developing Siebel EIM process to import into various Siebel base tables in Call Center and Financial Applications

• Expertise in designing and developing Business Services and Siebel Workflows to validate and manipulate data

• In-depth understanding of Siebel Installation and setting up required environments

• Solid understanding in Siebel Architecture and Siebel Data Model, Integration and Migration methodologies

• Designing and developing Data Migrations from Siebel to vendor applications across Oracle and MS SQL servers

• Extensive experience in Siebel Design, Development and Siebel Upgrading

• Hands on with Siebel Administration and Production Support including deployment, migration activities from Development to Production environment

• Working knowledge of Salesforce.com APIs, Price Books and Authorizations

• Extensive experience in creating complex PL/SQL procedures, packages and functions

• Proficiency in Performance Tuning through analyzing execution plans, spool and log files

• Hands on experience with creating CRON jobs and NT schedulers for periodical executions and shell scripting

• Good understanding of ETL process using Informatica within Oracle and MS SQL server environment

• Solid management skills, demonstrated proficiency in leading and mentoring individuals

• Excellent communication, organizational and presentation skills

• Experience working at client sites for tighter alignment with IT planning and delivery teams

Technical Skills:

CRM: Siebel eBusiness Version 7.5 and 7.7, Salesforce and Fulcrum Search

Database: Oracle 10g, Oracle 9i, MS SQL 2000/2005

Scripting: SQL, PL/SQL, eScripting

Tools: Siebel, PL/SQL Developer, TOAD

Data Migration and Integration: EIM, EAI, Informatica, Data Migrations on Oracle and MSSQL environment, Oracle Streams

Projects:

1. Client : Autodesk Inc. Feb 2009 – Current

Project title : Siebel SOE Implementation

Description: Single Order Entry (SOE) is a process of creating and renewing subscription assets with new product version released by Autodesk. This needs accounts, contacts, products and assets data accurate, based on which products will be shipped to customers. This also needs to make sure consistent data across multiple in-house and vendor applications.

My Involvement in the project:

• Creating and configuring Business Components, Applets and views to Include access to SAP related data

• Developing Enterprise Integration Manager process to import product, product line, service requests and entitlement entities

• SQL and EIM Performance tuning to process millions of data meet SLAs with end users

• Enhancing existing EAI workflows, Integration Objects and Integration Components to be in line with business needs

• Created data mapping for Integration Objects

• Designing and developing workflows to be in sync with business process

• Processing and Scheduling NT and UNIX jobs for weekly data reports

• Validating and reconciling existing data for consistency across multiple applications

• Responsible for building and mentoring offshore team for ongoing support

2. Client : Autodesk Inc. Aug 2008 – Jan 2009

Project title : Salesforce.com - Partner Portal

Description: As part Salesforce.com pilot implementation, account, contact, product and product authorization data has been migrated to SFDC. This includes API modifications to match Siebel data structure with salesforce.com data model.

My Involvement in the project:

• Analysis of business requirements and existing process

• Customized Siebel objects to Include interface to Salesforce.com

• Extending Siebel tables, business components and applets

• Developed Siebel EIM process to import new responsibilities

• Implemented procedural validations to have mandatory data

• Saleforce.com API modifications for user authentication, compatible data model

• Siebel partner portal migration to SFDC using Informatica

• Created price books for product authorizations

• Strategic planning for phase wise project delivery

3. Client : Autodesk Inc. Mar 2007 – Jul 2008

Project title : ODS Migration – Oracle Streams

Description: One Data Source (ODS) has been developed with the aim of making single data source for all non-OLTP applications within Autodesk. During first phase of project, all Accounts, Contacts, Adress, Assets and subscription data from Siebel has been streamed/replicated to ODS. Within ODS, multiple triggers, SQL functions and procedures make Data cache updated for millisecond response.

My Involvement in the project:

• Analysis of required DB objects including tables, Index, procedures and packages

• Designed and developed DB schema for ODS

• Creating packages, stored procedures, cursors and functions to feed Tibco requests

• Created materialized views to simulate replication

• Using SQL loader to import data from flat files

• SQL Performance tuning using execution plan

• Scheduling DB jobs to monitor temporary table data

4. Client : IndyMac Bank Aug 2005 - Feb 2007

Project title : Siebel Upgrade

Description: This project was aimed to upgrade from Siebel 6 to Siebel 7.5. This also includes migrating all functionalities from third party applications ‘HCL’ and ‘Goldmine’ to Siebel. Migration consists of data objects Opportunities, Accounts, Contact and Activities

My Involvement in the project:

• Creating COM objects to instantiate Siebel Application

• Creating DTS and Stored Procedures to move data to temporary tables

• Data segregation to suit the Siebel data model

• Data standardization and data parsing

• Dealing with post upgrade configuration issues and fixing them as per client requirement

• Designed and developed EIM to load data into Siebel

• Designing and developing of required workflows

• Developed Business Services to manipulate data and feed to workflows

• Developed VB scripting objects

• Goldmine data analysis to determine data type and size in each table

• Installing / setting up required environments for testing purpose

• Integrating XL tool with Siebel

• Leading and mentoring the team of 8 for smooth transition for onsite-offshore model

• Resolving the issues with post ‘upgrep’

5. Client : Siebel Systems Inc. Aug 2003 – Jul 2005

Project title : Siebel Technical Support

Description: This project is designed to support Siebel worldwide customers. As part of that, IBM has set up its own centre for Siebel System Inc. in Bangalore. Based on severity of service request submitted to centers, this centre will provide technical capabilities to customers to resolve the issue in the effective manner.

My Involvement in the project:

• Resolving different Configuration and Scripting related technical issues submitted to the Siebel Global Queue

• Analysis of Customer Relationship Models implemented using Siebel technologies

• Installing / setting up customer specific environments for testing purpose

• Training new team members to cope up with the functional area requirement

• Handling customer escalations on need basis

• Siebel Performance tuning on customer environments

Educational Qualifications:

• Masters Program in International Business (MPIB) at Institute of Management, PSG College of Technology, Coimbatore in collaboration with IIFT, New Delhi (1999-2001)

• Bachelor of Science (Mathematics, Physics and Chemistry), Sri Venkateswara University, Tirupati (1995-1998).

Recognitions:

• Above and Beyond award from Cognizant.

• Recognition for the best Customer Solution Practice from Cognizant.

• Excellent (Bravo!) award from IBM within 3 months of join.

Contact Details:

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

Cell: +1-832-***-****

Contact this candidate