Sreejit Sreedharan

Siebel Consultant

CALL: 403-***-****

aca19q@r.postjobfree.com

CALGARY (AB) CANADA

[pic]

PROFILE

8+ years of strong IT experience in software

analysis, design, development, project management

including more than 8+ years in full cycle

Implementations of Siebel Applications covering

eCommunications, Public Sector, eLoyalty, eSales,

eFinance, UCM and Call Center

Lead the planning, design, development, and

deployment of new applications, and enhancements to

existing applications

Lead business process and technology walk-through and

design sessions for the purpose of effectively

scoping and assessing the impact of desired

enhancements or changes to business processes,

operations, and information process flow.

Experience in overseeing the planning, design,

development and implementation of Siebel

Siebel Application Development through Siebel Tools,

Scripting, Business Services, Workflow, EAI and EIM

Good experience working with relational databases,

Oracle/SQL

Knowledge in entire Siebel Project Delivery life

cycle including Requirements Gathering, Business

Analysis, testing & documentation

Excellent written and verbal communication skills

EXPERIENCE SUMMARY

CGI Information Systems and Management Consultants

Inc.

Senior Consultant, Victoria, BC

Proposal: Siebel Public Sector & eLoyalty, OBIEE,

UCM

Nov 2010 - Sept 2013

Description

Assisted in the development of proposal for a major

transportation industry client is among the many

proposals worked on. Contributed functionally in

identifying vanilla functionality and customizing

effort in the requirements in areas of Siebel

eLoyalty and UCM. Developed POC for demonstration of

eLoyalty functionality.

Areas of assessments are Member management, multi

tiered Loyalty Program management, Card Management,

Employee Pass administration, offline Payment and

card transactions, Marketing and Campaign analytics

management.

Project: Third Party Liability (TPL), BC Ministry of

Health

Role: Senior Siebel Developer

August 2011 to Present

Description

The TPL application was originally intended to

interface with Health Ideas Data Warehouse as well as

with the BC Ambulance Billing Data generated via the

PC-DES. This effort is to enable these important

interfaces to improve efficiencies and data quality.

Verified the design and enabled the interfaces and

other functional requirements successfully.

Preparation of a Technical design document to

implement the requirements.

Built an integration interface using EBC (External

Business Component) to import data from an external

database.

Configuration of Server components and Siebel objects

to enable the interface.

Environment: Siebel Public Sector 8.1.1.3, Oracle 11g

on Unix Server, Windows Server 2003

Project: Student Tracking and Registering System, BC

Ministry of Education

Role: Technical Lead

Nov 2010 - present

Description

The purpose of STaRS2 implementation was to replace

the aging STaRS1 system and enhance business

capabilities to meet the requirements of the Ministry

of Advanced Education and Labor Market Development.

Responsible for leading and/or participating in all

aspects of the design, development, and deployment of

the Siebel solution and related components (e.g.,

interfaces, conversions, etc.). Provided leadership

in all technical aspects of a Siebel initiative.

Solution design of project requirements to meet

business needs

Lead business process and technology walk-through and

design sessions for the purpose of effectively

scoping and assessing the impact of desired

enhancements or changes to business processes,

operations, and information process flow

Create, maintain and manage technical team's

schedules

Developing and execution of Unit Test plan, execution

and reporting to client.

Supervising application build, test, and deploy

activities

Development and Implementation of Siebel Access

Control

Planning and executing data migration activities for

Contacts and Addresses

Implementation of Field Service - Appointment Booking

and case management

Migration of Contacts, Immigration Information and

Assessments from the legacy system into Siebel using

EIM.

Coach and mentor Developers on Technical and best

design practices

Environment: Siebel Public Sector 8.1.1.3, Oracle 11g

on Unix Server, Windows Server 2003

Toyota Financial Services, Torrance

June - Sept 2010

Role- Siebel Technical Lead

Project - Suppression Privacy

Description

The role is to configure UCM and build the logic to

maintain Account Master Data and their interfaces

with other systems in the network. The activities

include setting up the UCM Survivorship Engine

properties, Auto merge and Manual review threshold

values and building integration interfaces. TFS plans

to allow registered customers to suppress their paper

statement delivery and provide them with an

electronic copy through their website. The paperless

billing service is expected to save Toyota over $2M a

year.

As a Siebel Technical Lead, I was engaged in the

planning and design of the Siebel application

interfaces to support the paperless statement and

marketing preferences projects executed with the

support of members from the off-shore team.

Engage in JAD sessions with other disciplines and

business.

Build interface using JMS Transport and TIBCO hub

Used Symbolic URL to embed IFrame based web pages

Set UCM survivorship rules Merge threshold values.

Deloitte Inc, Vancouver.

May 2010

Role - Siebel Consultant.

Project - BC Healthlink Proposal.

Description

This role is to prepare an effort-estimation through

client workshops and Functionality Requirement

Document and to assist the project team in

preparation of the high level Implementation plan.

Suggest on the integration channels to be adopted for

interfacing with other systems

Identify OOTB processes to support the functionality

Suggest data migration entities to support the Case

Management process

Assess CTI integration effort and screen pop-ups

Suggest system environments to support the

implementation process

Support in assessing the effort during the Analysis,

Design, Build, Test & Deploy phases

Proposed Environment: Siebel ICM application, BI

Publisher, Siebel CTI, Oracle CCA, OBIEE Application,

Case Management Analytics

Affiliated Computer Services, Dallas.

Feb 2009 - Nov 2009

Role - Senior Siebel Developer/OBIEE Developer.

Project - New York State Disbursement Unit (NYSDU).

Description

This Role involves development of solutions to

business processes within Siebel8 functionality.

Development of eSales Standard Interactive UI.

Resolution of reporting data in Analytics and Resolve

Data Discrepancies in the environment.

Reporting Dashboards related to the Subject Areas

Activity were 're-casted' with SA Service Request to

correct reporting inaccuracies (Verified Count of

records in OBIEE dashboards)

Modified the underlying logic in Business layer,

Repository Variables, Initialization Blocks, Creating

Dimensions and the respective Month Ago aliases in

the physical layer

Implemented dashboard prompts in "Between" date

validation for engage the user to manage entry

errors.

Created new dashboards/reports and made

recommendations to report layout with reference to

table, narrative, pivot, chart views in Siebel

answers and embedded them into pages

Enhancements/modifications to Task Based UI structure

and functionality.

Developed Siebel Integration workflows and Data Maps

to establish integration between Siebel and 'Gateway'

applications for Case Management.

Modifications and enhancements to eSales Standard

Interactivity UI.

Environment: Siebel 8.0.0.3, OBIEE Application

10.1.3.3.3, Oracle, Windows Server 2003

MLC College of Business and Technology, Calgary, AB.

Apr 2008 - Feb 2009

Role - SAP Instructor

Description

This Role involves serving customers and internal

learning needs by providing innovative and effective

knowledge transfer of SAP Material Management/Plant

Maintenance modules.

Responsibilities:

Educational design:

Contribute to design and structure of curriculum,

support in evaluating training requirements per

target group, Create instructional design documents

and course outlines, Coordinate and review of

instructional design

Education Development:

Write conceptual and functional course content,

Create demos and exercises, Create interactive

simulations, Build and maintain training systems

Delivery and Evaluation of the subjects as per Course

Outline. Guide and facilitation on course projects.

Environment: SAP 4.7, ECC 5

Bell Canada, Calgary, AB

Sept 2007 - Mar 2008

Role - Siebel Int gration Consultant

Project - goSeeEOM Migration Project

Description

This Role involves with managing the VITRIA hub and

dealing with the changes of Integration Objects and

process parameters pursuant to the migration of the

Siebel instance to EOM (Bell Toronto).

Responsibilities:

Redesigned and developed a solution using the Vitria

middleware to integrate Metasolv provisioning

application with goSeeEOM Siebel instance.

Modified logic of the following integration

processes: Billing Item Maintenance, Billing Account

Maintenance, OSM & Metasolv Account Maintenance

processes that integrate Siebel with billing app.

SingleView and provisioning app Metasolv.

Customized Java code to handle the transformations

and update Siebel and Metasolv databases using Siebel

JavaBeans and Metasolv API respectively.

Prepared test scripts for unit test against test plan

executed and reported

Environment:

Siebel eCommunications 7.8, Vitria 3.1.7.18, Unix

Server environment

Bell Canada, Calgary, AB

March 2002 - Mar 2007

Role - Siebel Programmer/Analyst

Project - Siebel Maintenance

Description

Work as part of the technical team to upgrade,

design, implement, maintain and perform enhancements

to the functionality of Siebel CRM versions 6.3 &

7.5. The job also calls for problem identification,

trouble shooting and problem fixing.

Responsibilities:

Perform technical design, configuration and unit

test changes

Meet with Business Owners to capture requirements

Participate in integration, system and performance

testing

Fix defects and performance problems

Build new customizable products and administer price

changes

Plan, manage analyze and document business

requirements.

Escalate issues and provide status to management

Major Initiatives:

CONTRACT STREAMLINING: Duration: 6 months, Team size:

4. Role: Analyzed requirements using the Business

Process Model and Activity Flow Diagrams. Designed

and implemented the process to capture and maintain

DATA and VOICE agreements in Siebel. The process was

capable of maintaining two levels of agreements,

generated and maintained documents and recorded sales

compensation. Agreement document templates were

tightly bound to the product being sold. Design

involved elaborate customizations involving creation

of links, views, applets, business components,

business service, and workflow using Siebel tools.

Reports were developed using Actuate.

Important highlights:

Creation of BusComps and Link objects, hierarchical

Picklists, views and screens

Design and development of Actuate reports - List and

Master Detail reports with composite data-streams and

data-filters

Developed BS to compute Salesman compensation

Developed Workflows to retire Agreements

automatically

Used EIM to move data into Siebel

PRODUCT SKINNING DOWN: Duration: 5 months, Team size:

3. Product obsolescence leads to operational

difficulties in modifying old assets through a MACD

process. It was necessary to periodically 'clean' up

Assets, Orders and Quotes of instances of obsolete

products. This initiative was undertaken in phases to

replace products at different levels of the product

hierarchy.

Primarily responsible for developing the BS, suggest

testing methods and undertook study to identify

performance improvements.

Developed a Business Service using eScript to replace

obsolete product references in Quotes, Orders and

Assets base tables with the current product model

Strategically separate BS was developed for high

volume products using different transformation logic.

The BS referenced an excel spread sheet with the

necessary mapping information on the obsolete and

target replacement products.

Separate passes to map products and attributes.

SIEBEL 7.8 PROTOTYPE: Duration: 1 month, Team size:

2.

Installed the Siebel Server environment in the

sandbox

Created complex products in 7.8 sandbox environment

to demonstrate use with the improved Configurator.

Developed customizable products, relationships,

linked items and constraints

NEW PRODUCT INTRODUCTION: Duration: 3 months, Team

size 7

Role: Develop some of the 'Managed' Products,

complete with Pricing and Vitria integration mapping

and development

Develop configurable products complete with classes

of attributes, relationships and constraints

Install prices

Update XSLT and Java classes of Vitria, the

integration hub, with the appropriate product maps

between Siebel and SingleView and integration logic

SIEBEL UPGRADE 6.3 TO 7.5: Duration: 7 months, Team

size: 18.

Role: Part of the core configuration team involved in

areas of data mapping/Conversion, Workflow, Business

Services, Views/Screens.

Worked on the database upgrade from version 6 to

version 7. Identified configuration issues that

caused the upgrade process to break and created

pre-upgrade solutions that might minimize such

occurrences in subsequent upgrades. Eg: one of the

upgrade scripts concatenated 2 characters to all the

List of Value Type fields. This caused certain

records (30 characters) to go above the column length

(30) - these were identified and pre-upgrade tasks

were created to resolve such issues.

Participated in various workshops with the Business

Analysts in order to determine the new process that

the users will use when working with Siebel 7. Eg:

Went through the various Entry points that the users

could use to first enter the Siebel Order Management

Module and it was determined that the best entry

point would be from the Customer Portal which in turn

could be accessed from the Account

Re-Developed Order entry process, to run everything

through Quotes module to conform to Siebel 7 best

practices. Implemented changes in several areas of

the application (accounts, quotes, orders, and

workflows) to support customers' business processes

while following Siebel 7 process flows.

Re-created the customized Inter Services Centre (ISC)

screens and views, Links, BusComps and fields.

Environment: Siebel eCommunications 7.5.2, Oracle

8.1.7 on AIX, Windows 2000 Client, Actuate Reports

Server, eCommunications 6.3

iRevolution Consulting Inc., Calgary

Sept 2001- March 2002

Siebel Developer

Project - Siebel Universal Driver, Bank of Montreal

Description

Siebel eFinance 2000 implementation - Bank of

Montreal - Siebel Financial Services 6.0.2, Windows

NT Workstation Client, Aspect Enterprise Contact

Server 5.1 Nortel Edition, Nortel Meridian Option 11

with Nortel Symposium, Universal Siebel Driver,

Visual Basic 6

Responsibilities:

Added Aspect Repository Server access functionality

to Universal Driver

End to end testing of CTI functionality, provided bug

fixes and customizations to accommodate Nortel

platform-specific functions into the Universal driver

Drive requirements gathering process, conduct JAD

sessions explaining available functionality and

customization options. Explained impact of IVR

project on screen pops and pushed for more joint

design effort

Customize screen pops, screen transfer with call, CTI

speed dial buttons and other functionality

Environment: Siebel 2000, Siebel eFinance, Windows

2000, Oracle 8.1.6

Pentafour Software Ltd., Bombay

May 1998- May 2000

Application Consultant

Project-Arvind Mills, Ahmedabad:

Implementation of SAP commenced in 1998. After the FI

module, MM, SD and PM were implemented together.

Role: Part of the core team doing the implementation

Sales & Distribution (SD) Functional consultant.

Configuration and customization of the SAP SD module.

Project - CR Seals Ltd, Bangalore:

Implemented an Order Management System to track the

execution of Indents on their foreign suppliers.

Role: Information gathering, mapping the business

process. Create demo application for obtaining

customer approval. Developed UI screens in VB. Data

stored in Oracle.

WORK HISTORY

2010 Nov onwards : Senior Consultant, CGI, Victoria

2010 July/Aug: Siebel Technical Lead, TFS, Torrance

2010 May: Siebel Consultant, Deloitte Inc., Vancouver

2009- 09: Siebel Consultant, iRevolution Consulting,

Calgary

2008 -09: MLC College: SAP Instructor

2007-08: Integration Consultant, Bell Canada, Calgary

2005-07: Siebel Developer, Bell Canada, Calgary

2001-05: Senior Siebel Consultant, iRevolution

Consulting Inc. Calgary

2000-01: Object Oriented Software Tech., University

of Calgary

1998-00: Application Consultant, Pentafour Software

Ltd, Bombay

EDUCATION & PROFESSIONAL DEVELOPMENT

Siebel 7 Core Consultant Course, Calgary

Certified Associate in Project Management[CAPM],

Project Management Institute

Object Oriented Software Technology[OOST], U of C

Bachelor of Engineering [ BE(Mech.) Hons], University

of Allahabad (India)

Visual Basic.Net credits from SAIT

REFERENCES ARE AVAILABLE UPON REQUEST

[pic][pic][pic][pic]

Contact this candidate