RANJITH KUMAR DEVARAJ

Siebel Developer

*** **** ****** *****, *********, New York Ph: 210-***-**** email: ablbnl@r.postjobfree.com

Professional Summary

Experienced Siebel developer with expert in analysis, design, development and configuration skills seeking a

challenging technical position in the area of customer relationship management

• Over 8+ years of experience on Siebel CRM includes but not limited to Siebel Configuration, Scripting,

Product Configuration, Integration EAI, Siebel Server Administration and Siebel EIM (Enterprise

Integration Management) on Siebel versions 7.8, 8.1.x,8.2.xSIA

•

• Worked on large scale implementations with British Telecom, Johnson & Johnson, Slovak Telecom, HDFC

Life Insurance and American Airlines. Talented Siebel developer with a strong back ground in customizing

Siebel applications for various domains like Sales, Telecom, Marketing, Insurance, Call Center, Pharma

and Loyalty

•

• Excellent skills in configuring Siebel enterprise applications using Siebel tools (business objects, views,

applets, business components, user properties, joins, order management, picklist, links, mvgs, workflows,

assignment manager, asset based ordering, product configuration, smart scripts, products & pricing, etc.)

•

• Expert in Siebel integration eai through web services over http protocol, JMS queues, configuring Inbound and

Outbound webservice, configuring integration objects, writing custom business services for vbc integration,

configuring data maps, xslt/xsd transformation, eai queues, using pre built eai business services & siebel adapters

and deploying inbound/outbound web services

•

• Highly experienced in escript, vbc, ebc, party concepts. Followed best coding standards like implementing

try catch finally block, declaring variables inside loop, use of forwardOnly, instantiating the BC/BO only

when required, accurate search expressions, limited use of profile attributes, filtering execution of code

with view name, nullifying the variables in finally block, creating & writing code within functions, etc

•

Page 1 of 10

Ranjith Kumar Devaraj Siebel

Consultant

Phone: 210-***-**** ablbnl@r.postjobfree.com

• Have good knowledge on Siebel open ui architecture and its components physical renderer, presentation

model, proxy. Comfortable with java Script and jquery

•

• Strong experience in Siebel Server Administration, Siebel Component Configuration, Siebel Architecture,

Data Model and Product Configuration. Hands on experience in Siebel Server Installation, configuration of

gateway server & enterprise server, repository migration, db extract, export/import of non-srf objects

through Application Deployment Manager (ADM)

•

• Siebel EIM Integration through EIM jobs with the external system for bulk import of data. Modified and

designed batch jobs to import / export data between Siebel database and legacy systems. Involved in Data

Mapping for loading the Legacy data and prepared complex SQL queries, configured and optimized

configuration (.IFB) files to run EIM job for data load

•

• Extensive experience in analyzing Siebel logs, sql queries, performance tuning and root cause analysis of

performance issues at various client environments

•

• Highly skilled and experienced in agile and waterfall development model for diverse requirements in CRM

•

• Knowledge on Siebel Smart Scripts, Siebel Order Management, DVM, ADM, PDQs, Run Time Events,

Workflow Policies, State Model, Product Administration, Product Pricing, Siebel User Setup, Jobs, Profile

configuration and Siebel Multi Lingual application deployments

•

Key Skills

Siebel CRM Siebel 8.2/8.1.1.11/8.1.1.7/7.8 Tools Configuration, Server Administration, EAI,

eScripts, Business Services, Siebel Adapters, Workflows, VBC, EBC, State Model,

Web Services, Assignment Manager, Asset based ordering, Product Configuration,

Product Pricing, Signals, Application Configuration Parameters, Smart Scripts,

Siebel User Data Model, DVM, Run Time Events, Order Management, Workflow

Policies, Integration Objects, EIM, ADM, PDQ, Jobs, Profile Configuration, Data

Maps, etc.

Applications Siebel Power Communications, Siebel Call Center, Siebel Finance, Siebel Loyalty,

Siebel eSales, Siebel CRM Automotive Solutions

Page 2 of 10

Ranjith Kumar Devaraj Siebel

Consultant

Phone: 210-***-**** ablbnl@r.postjobfree.com

Domain Knowledge Telecom, Insurance, Loyalty, Pharma

Development Process Waterfall Model & Agile Model

Methodology

Tools Soap UI, Toad 10.3, SQL Navigator, PL/SQL Developer 5.1, SQL Query Analyzer,

Quality Center

Languages Siebel eScript, SQL, PLSQL, XML, HTML

Database Oracle – 11g/10g/9i, SQL Server

Career Accomplishments

• Successfully completed 6 months of Infosys training in Mysore, India

• Promoted to Consultant-CRM in 8 months of joining Cognizant Technology Solutions Ltd.

• Received multiple Start of the Month, Good Performer in Team, Truly Dependent awards during

employment with Infosys, Cognizant & Tata Consultancy Services

• Actively participated in Siebel recruitment drives at Cognizant Technology Solutions, Tata Consultancy

Services Ltd

• Actively mentored, trained and supervised new Siebel developer for several months to improve Siebel

Configuration, EAI and debugging skills.

•

Experience

SIEBEL EAI Developer International System Technologies

Xerox, Rochester, NY September 2014 – December 2014

Project Description: The objective of the Atlas application is to cater the needs of the CSR working for Xerox to manage

the customer in various areas like Invoice, collections, maintenance, service request.

Environment: Siebel 8.1.1.11 Power Communications (scomm.cfg), Tools 8.1, Oracle 11g, UNIX

• Developed new Integration services between Siebel and external applications built in Java

• Coordinating with external systems in XSD designing of each interface

• Created Integration Objects, Data Maps, Workflows and deployed as web service in Siebel Application

• Worked on improving the performance of each service to increase the turnaround time

Page 3 of 10

Ranjith Kumar Devaraj Siebel

Consultant

Phone: 210-***-**** ablbnl@r.postjobfree.com

• Developed Siebel Inbound Web Services and published WSDL to middleware. Helped them in testing the web

services

• Fixing the defects raised by testing team and coordinating with them

•

SIEBEL Integration Lead Tata

Consultancy Services

HDFC Life Insurance January 2013 – June 2014

Project Description: HDFC Life Insurance Lead Management System is a project targeted to capture Leads

through various partners & channels, process it and convert the leads into prospective customers to help in the

growth of business. Entire life cycle of the leads with Siebel and with external systems is managed in this project.

Environment: Siebel 8.1.1.7 Financial Services Application (fins.cfg), Tools 8.1, Oracle 11g, UNIX

• Understood the business requirements at enterprise level across systems, identified the services to be built,

planned to reuse the services wherever possible

• XSD designing for the identified services with other stack holders like BPM SOA, Portal, OPN, etc.

• Mentored the team to develop the services and owned the delivery of CRM Interfaces

• Designed, developed, unit tested VBC services to display the run time data in Siebel application without

storing it in Siebel database. Prepared technical design document, Unit Test cases and captured test results

for all the VBC services developed by me

• Configured and customized Integration Objects, Business Component & fields, User Properties, Joins,

Links, multi value group(mvg), multi value links (mvl), Applet, Business Object, Business Services

scripts, workflows, etc.

• Proactively identified the performance issues and fine tuned it through new business components, XSLT

transformation, vanilla business service, user keys, Index, remove sorting, and EAI Queues. By this way

turnaround time of each service is brought below 3ms.

• Debugged Inbound and Outbound web services by increasing the log levels and fixed issues across

environments

• Responsible for migration & deployment of Interface objects between environments including non-srf

objects like LOV, Web Services, Data maps, EAI Queues, Run time events, DVM, etc.

• Helped external teams with proper data set up that is needed in Siebel applications across environments

• Coordinated with testing team to assign, track and fix the defects raised in Quality center

• Implemented Siebel development standards and best practices in the repository

Page 4 of 10

Ranjith Kumar Devaraj Siebel

Consultant

Phone: 210-***-**** ablbnl@r.postjobfree.com

• Reviewed technical design documents, unit test cases, verified test results and performed peer code review

Siebel Configurator / EAI Developer Cognizant Technology

Solutions

American Airlines, Fort Worth, Texas February 2012 – December 2012

Project Description: Ventana Program is designed for Siebel Loyalty Implementation for American Airline

customers. This program divided into sprints/Iterations and releases. Every iteration consists of 5 releases.

Awarding loyalty point to the flying customers and the providing various offers/products to redeem the points is

the main objective of the Ventana program. This program is based on Agile Methodology where the requirements

will given by the client on Iteration basis.

Environment: Siebel 8.2 Loyalty Application (loyalty.cfg), Tools 8.2, Oracle 11g, UNIX

• Created Technical Design Document (HLD, LLD) based on Requirement Document which meets the

Business Requirement along with existing system Configuration.

• Configured and customized the application in Siebel Tools according to customer requirements.

• Created/Modified Business Components, Screens, Views, Applets, MVG Applet, Pick Applets,

Hierarchy picklist, Joins, Links, MV Links, Business Object, Business Services, Workflow etc.

• Worked on Inbound and Outbound Web Services to combine component-based development and

Internet standard protocols that include HTTP, XML, Simple Object Access Protocol (SOAP), and

Web Services Description Language (WSDL).

• Created Outbound Web Service with synchronous response back to implement email send

functionality to customers when service request is opened and closed.

• Created outbound web service with synchronous response back to implement updating the status

of the request in the Enterprise Contact History database when status is updated.

• Used User Properties to make fields and Business Component read only, to update field based on

another field, to invoke Business Service, Workflow, Business Component method etc.

• Used Siebel development standards and best practices in development.

• Worked extensively on improving the application performance, closely looking at the database query

explains plans and keeping the application functionality unchanged after development.

• Wrote Server Scripts for data validation and data manipulations.

• To read and update the data fields in Siebel from the flat file sent by other applications on the

status of Service Request.

• To add a custom headers to the XML Hierarchy for the outbound web services.

Page 5 of 10

Ranjith Kumar Devaraj Siebel

Consultant

Phone: 210-***-**** ablbnl@r.postjobfree.com

• To calculate SLA for the Service Request based on the data sent by front end applications

• Followed best coding standards like creating functions, nullifying the variables in finally block,

Implementing try catch block, declaring the variables & instantiating the BC/BO inside the loop

• Filtered the code from unnecessary execution by applying view name, added readable comments,

removed all the unused code from repository

• Configured/Modified the Server components, Parameter settings, and restarted Siebel services in all the

servers.

•

•

•

•

•

•

•

Siebel Developer/Product Configurator Cognizant Technology

Solutions

NGCRM - Slovak Telecom, Slovakia May 2011 – January 2012

Description: T-Systems is a division of Deutsche Telekom. It is world-wide operating Information and

Communications Technology (ICT) provider. T-Systems support and provide end-to-end solutions to the

applications of T-Com, T-Mobile and T-Online. NGCRM provides end to end support to the CRM applications of

T-Systems, Europe. CRM Solution implemented for T-Systems is intended to coverage multiple legacy systems to

a single but more stabilized CRM Siebel 8.1 and hence improve their customer reach.

Environment: Siebel 8.1.1.7 Power Communications (scomm.cfg), Tools 8.1, Oracle 10g, UNIX

• Responsible for configuring products in Siebel Application. Created simple products, customizable

Products, bundle products, catalogs, Links, categories, product classes, attributes and applied product

pricing

• Customized products compatibility rules, eligibility rules and constraints to customize the production in

econfiguration UI during order creation/submission in Order line items

• Asset based ordering, account to asset cycle through quotes and orders. Modified workflows, bs user

properties, data maps, integration objects to include custom fields in conversion of quote to order, order to

asset, asset to modify order through SIS OM PMT Service

Page 6 of 10

Ranjith Kumar Devaraj Siebel

Consultant

Phone: 210-***-**** ablbnl@r.postjobfree.com

• Worked on new, modify, suspend, resume & deletion of asset scenarios

• Applied different types of product pricing to products i.e. One time purchase, recurring, non-recurring, etc.

and implemented attribute based dynamic pricing

• Also worked on design, configuration and development of business requirements using Business Object,

Business Components, Screens, Views, Applets, MVG, Constraint picklist, Pick Applet, Joins, Links,

MVL, Business Services, and Workflows etc.

• Created custom business service and scripted it to achieve business functionality. Followed best coding

standards. Reused the code through Custom BS functions and by invoking it from Workflow, BC events.

• Worked on user properties, search and sort specifications, Admin property settings, column extensions,

indexes, scripts in business component events to achieve required business requirements.

• Involved in user maintenance, trouble shooting, break fixes, test scripts development, unit and system

testing, code and configuration review, performance tuning, spooling, database querying and deployment

• Set up Audit Trail and Siebel Wireless components (Modifying the SRF with Applet and Business

component field changes, HTML templates) configuration in the application

•

Siebel Configurator / EIM Developer Cognizant Technology

Solutions

Johnson & Johnson, New Brunswick, New Jersy February 2010 – April 2011

• Description: Client is a leading Pharma devices manufacturer for consumers, Hospitals and businesses.

This application completely dealt with different entities like Accounts, Contacts, Products, Service Requests,

Consignment and Orders. This maintenance project based on “Agile Development Process”, focused on

enhancing existing functionality providing the end users a better and friendly interface to deal with. Huge

number of change requests, Rey Key items, and Problem Reports were part of this module.

Environment: Siebel 7.8 Power Communication Services Application (scomm.cfg), Siebel Call Center

(eSales.cfg), Tools 7.8, Oracle 9i, UNIX

• Resolved technical support issues for a period of 4 months until the project gets stabilized. Identified the

root cause of the issue for the support tickets, Implemented the solution and got UAT approval, pushed few

issues for new CR approval

• Extended the Siebel tables through Custom tables and columns and created User keys and Indexes.

• Configured and customized the Applets, Views, Screens, Business Components and Business Objects

through Joins, Links, MVGs and MVLs.

Page 7 of 10

Ranjith Kumar Devaraj Siebel

Consultant

Phone: 210-***-**** ablbnl@r.postjobfree.com

• Designed and mapped the columns required for loading data into Siebel base tables. Modified and

designed batch jobs to import / export data between Siebel database and legacy systems.

• Prepared EIM jobs integrating with the external system for bulk import of data. Involved in Data Mapping

for loading the Legacy data and prepared complex SQL queries, configured and optimized configuration

(.IFB) files to run EIM job for data load.

• Using SQL plus database application tool wrote complex SQL queries against other Legacy Systems to

retrieve data and validate it for Siebel Import process.

• Involved in creating Unit Test case and in Preparation of Test Logs which is used for Designers to Review

the Technical Implementation.

• Coordinated the design review with the client

•

•

Siebel EAI Configurator / Siebel Administrator Infosys Technologies

Ltd

Oracle-Infosys, Bangalore, India February 2008 – January 2010

Project Description: ORACLLAB is an Internal Project developed for End to End Telecom Domain. They

provide Integration between various Telecom Applications like Oracle BRMS, Oracle OSM, Inventory, PIM and

Oracle Fusion with Oracle Fusion as Middleware. This project is being started from the scratch to develop the End

to End Implementation for Telecom domain with Oracle Products.

Environment: Siebel 7.8 Power Communication Services Application (scomm.cfg), Tools 7.8, Oracle 9i,

Windows Server 2003

• Installation of Siebel servers and monitoring of Gateway, Siebel Servers and its components

• Supported daily tasks like Compilation, Database Extraction for Developers, applying changes to the

tables in Tools (DDL Synch), import and export of SIF objects, workflows across environments,

maintaining the version control and Repository migration between environments

• Troubleshoot Siebel crash log files using FDR by turning on FDR in Siebel application

• Monitor and maintain the Development, Test, Performance and UAT environments.

• Non-SRF objects migration between environments through ADMs

• Created detailed technical system design documents

• Wrote Unit Test Plan and prepared Test Cases

Page 8 of 10

Ranjith Kumar Devaraj Siebel

Consultant

Phone: 210-***-**** ablbnl@r.postjobfree.com

• Extensively involved in creating new Siebel Interfaces to exchange real time data with external

applications through fusion middleware. Created Integration Objects, User Keys, workflows, data maps,

eaiqueues, MVG, MVL, links, User Properties, business service to deploy Siebel web services

• Responsible for role of Release coordinator in which all system integrations and impacts were focused

• Supported System Integration testing defects and fixes. Defect tracking & updating in Quality Centre (QC)

• Data set up & Smoke Testing in all the environments

•

•

•

Siebel Developer Infosys

Technologies Ltd

British Telecom, Hyderabad, India January 2007 – February 2008

Project Description: Client is a leading mobile and handheld devices manufacturer for consumers, mobile

professionals and businesses. This application completely dealt with different entities like Accounts, Contacts,

Products, Assets, Service Requests, Activities and Orders. This development project based on “Agile Development

Process”, focused on enhancing existing functionality providing the end users a better and friendly interface to deal

with. Huge number of change requests, Rey Key items, and Problem Reports were part of this module.

Environment: Siebel 7.8 Power Communication Services Application (scomm.cfg), Tools 7.8, Oracle 9i, UNIX

• Analysis and understanding of business requirements and functional specifications from business analysts

• Configured / Customized using Siebel Tools to meet Client specific business requirement

• Created detailed technical system design documents

• Prepared Unit Test Cases

• Developed and Configured static picklist, dynamic picklist, MVG’s, Applets, Screens, Views, Links, Joins,

Business Objects and Business Components

• Designed Positions, Responsibilities and set the visibility according to organization structure

• Created custom business service and functions in it through escript

• Unit tested the development work, captured test results and helped SIT team in testing it

•

Page 9 of 10

Ranjith Kumar Devaraj Siebel

Consultant

Phone: 210-***-**** ablbnl@r.postjobfree.com

Education

• Bachelor’s degree (Apr 2006) from Bharathiar University, Coimbatore, India

• Infosys Trained Siebel Resource

Certifications

Oracle Partner Network (OPN) Certified in below Assessments

• Siebel 8.0 Integration Champion Assessment

• Oracle Siebel Support Champion Assessment

• Siebel CRM 8.0 Sales and Marketing Presales Champion Assessment

• Siebel CRM 8.0 Sales and Marketing Implementation Champion Assessment

Page 10 of 10

Ranjith Kumar Devaraj Siebel

Consultant

Phone: 210-***-**** ablbnl@r.postjobfree.com

Contact this candidate