Kiran Kumar Chalamalasetty
E-mail : abh3ru@r.postjobfree.com
Mobile : +1-805-***-****
Experience Summary
. Over 8+ years of total IT experience and 7+ years of Siebel experience
in different activities of Siebel product implementation including
functional specification, prototyping, configuration, customization
and deployment.
. Rich work exposure in software development with responsibilities as
Functional Analyst, Technical Analyst, Module Lead, Production Support
Lead, Data Management Lead, Senior Developer,
and Programmer.
. Good domain knowledge in Siebel Sales, Siebel Call Center, Siebel
Partner Portal, Siebel Partner Manager and Siebel Financial Services
applications in Siebel.
. Strong understanding of Siebel architecture including Gateway Server,
Enterprise Server, Siebel Server, Web Server, Database Server and
Siebel Data Model
. Experience in configuring Workflows, Policies, Run Time events and
troubleshooting workflows.
. Experience in Siebel EAI, Inbound and Outbound integrations using Web
Services, HTTP Services,
Business Services and Workflows.
. Proficient in integration technologies viz., HTTP, XML, XSD, DTD,
SOAP, WSDL.
. Exposure in developing BI Publisher reports.
. Configured VBCs and EBCs to show external data inside Siebel
Application.
. Strong Siebel Administration skills in managing Server Components,
Data base extracts,
Repository migration.
. Expertise in building SQL queries, Siebel Performance Tuning using CBO
execution plans, indexes, db statistics.
. Expertise in customizing Siebel application using Siebel VB and Siebel
eScript.
. Integrated Siebel application and CTI using Genesys.
. Successfully performed Siebel Upgrade from Siebel 7.5.3 to Siebel 7.8.
. Expertise in Siebel application Localization in 12 languages.
. Expertise in implementing Smart Scripts as per business requirement.
. Experience in UNIX and Shell Programming.
. Excellent communication skills, strong problem solving skills,
proactive and creative approach towards work.
Skills
CRM (SIEBEL) : Siebel 7.5.3.4, Siebel 7.8.2.5, Siebel
8.1.1.2
Languages : C, Visual Basic, PERL, HTML,
JavaScript.
Operating Systems : Windows 2000/NT/XP, UNIX, Linux.
DBMS/RDBMS : Microsoft SQL Server 2000, Microsoft SQL
Server 2005, Oracle 9i.
Certifications & Trainings
. ORACLE certified "Siebel 8.0 Integration Champion".
. Trainings
o Oracle Policy Automation.
o Application Deployment Manager.
o BI Publisher Reports.
o Siebel Upgrade.
Projects
Project #10
Title CRN Redesign
Client Farmers Insurance Group, CA
Duration Apr 2009 to till date
Role Technical Analyst/Senior Siebel Developer
Descriptio The objective of the project is to redesign existing CRN application
n in Siebel 8 application and integrate all applications using Common
Integration framework.
Contributi . Extracted 500+ business rules by analyzing VB & VC++ custom
on components, business
services, workflow processes, RCRs.
. Developed Manual Coverage integration transactions for homeowners
LOB using web
services.
. Developed functionalities using run time events and workflows.
. Configured EBCs to display archived claims in Siebel application.
. Resolved performance issues using by tuning the configuration and
by adding indexes.
. Performed application design reviews, script reviews and code
reviews.
. Integrated ActiveX control for I-LOG functionality.
Environmen Siebel 8.1.1.2 / Win XP / Oracle 9i
t
Project # 9
Title Customer Restoration Network (CRN)
Client Farmers Insurance Group, CA
Duration May 2008 to Mar 2009
Role Production Support Lead
Descriptio Customer Restoration Network in Farmers Insurance is a project
n undertaken to restore the customer as quickly as possible after any
kind of loss. It involves the process of creating, processing,
investigating and final payments of claims. The system aims at
speedy settlement of claims and interfaces with other modules of
Insurance viz. Policies and Customer Database (Mainframes),
Subrogation, Salvage involving third party agencies and other
investigating agencies involving an accident or calamity.
Contributi . Assigned tickets and touch points to the team members
on . Prepared Weekly and Monthly ticket reports and communicated to the
client
. Resolved tickets on Claim Closure, Pick Policy, Coverage,
Reserves, Payments etc.
. Carried out daily touch points on Claims Intelligence, Center of
Dependability Vendors
. Delivered Adhoc Requests to the client meeting the SLA
. Carried out Weekly status meetings with Onsite Mangers and Onsite
Coordinator
. Prepared SMTD, Ticket Review Tracker documents.
Environmen Siebel 6.0 / Win XP / Oralce 9i
t
Project # 8
Title Global CRM
Client Microsoft Corporation, WA
Duration Nov 2007 to Apr 2008
Role Data Management Lead
Descriptio Linking Global CRM accounts with the Microsoft Individual and
n Organization (MIO) master will set the foundation for 360 degree
organization views and improve the visibility of information quality
in the CRM system.
Contributi . Written SQL stored procedures to audit the Taxonomy and
on Transformation Jobs
. Coordinated with World Wide data analysts to clean up data for
Production Issues like Serbia-
Montenegro Country split, Invalid Parenting levels, Sales Geo
Updates etc.
. Analyzed the Initial data load for Siebel CRM - MIO Integration
and prepared data validation
reports.
. Collaborated with Dev and Test team and fixed all data issue bugs.
. Resolved User Support SRs within the specified SLAs
. Defined SLAs and set expectations for the upcoming CRM - MIO
Integration support.
Environmen Siebel 7.5.3.15 / Win XP / SQL Server 2005
t
Project # 7
Title PSM 5.0
Client Microsoft Corporation, WA
Duration Sep 2007 to Oct 2007
Role Senior Siebel Configurator
Descriptio The objective of this release is to continue to improve Partner
n Sales Management (PSM), update Siebel Sales, and address additional
taxonomy changes.
Contributi . Localized Siebel eChannel Application for an unshipped Language
on (Russia).
. Analyzed, designed and developed the error message localization
for Russian language not
supported by Siebel.
. Investigated top ranked Performance issues in Production and
proposed solutions.
. Helped Production Support and User Support team on any queries
related to existing
functionality.
. Prepared Detailed Technical Design for ERP auto calculation.
. Fixed issues pertaining to Russian Localization like Row Counter
Map, Failing Workflows,
Missing strings in Query Assistant & SWE Applets.
Environmen Siebel 7.5.3.15 / Win XP / SQL Server 2005
t
Project # 6
Title CRM Compatibility Prototype 1.0
Client Microsoft Corporation, WA
Duration Feb 2007 to Aug 2007
Role Senior Siebel Configurator
Descriptio To upgrade existing Siebel Application from 7.5.3.15 to 7.8.2.5 to
n simply user interface actions, streamline navigation, improves data
presentation with overall objectives to increase productivity and
accelerate end-user adoption.
Contributi . Involved in reviewing object conflicts, obsolete objects and
on deleted objects.
. Corrected code in Business Services to retain the existing
functionalities lost after the
upgrade.
. Reconfigured Product Functionality due to major changes happened
in 7.8 version.
. Fixed the layout issues (Grid Layouts, Control widths) for all the
applets.
. Extensively used String Conversion and Consolidation utilities to
transform existing strings
into the new symbolic model.
. Fixed Localization issues due to by design missing controls in the
applets after the upgrade.
. Removed the new navigation model and configured the application to
be in line with 7.5.3
navigation as per the client business requirements.
Environmen Siebel 7.8.2.5 / Win XP/ SQL Server 2005
t
Project # 5
Title Partner Sales Management 4.5
Client Microsoft Corporation, WA
Duration Dec 2005 to Feb 2007
Role Siebel Business Analyst / Module Lead
Description The goal of the overall Partner Sales Management (PSM) project is
to provide an integrated partner management platform to support
partner facing employees and partners across the business cycle. In
addition of providing a partner management platform, PSM will also
offer a sales engagement process that will track opportunities and
relationships with partners.
Contributio . Involved in analyzing business requirements, writing functional
n: specification
documents.
. Designed workflows for Partner generated and Microsoft generated
Opportunities.
. Involved in various phases of requirement reviews like BRD and
Functional spec
reviews.
. Analyzed the functional specs and prepared detail technical
design based on the
functional specs.
. Localized Partner Portal Application in 10 languages and Partner
Manager Application
in 8 languages.
. Fixed Code defects, performance and Localization bugs in the
stabilization phase.
. Customized the Partner Portal Log off behavior by creating new
web templates and configured the application attribute properties.
Environment Siebel 7.5.3.15 / Win XP / SQL Server 2005
Project # 4
Title Siebel GetHealthy
Client Microsoft Corporation, WA
Duration Nov 2004 to Nov 2005
Role Siebel Configurator
Descriptio The overall goal of GetHealthy project is to improve the Siebel user
n productivity experience. Objectives of this project include (1)
Identify root cause of Siebel experience issues across Adoption,
Infrastructure and Application areas. (2) Identify and implement
actions to improve the Siebel experience to a level acceptable to
the field and sales management. (3)Identify recommendations for
immediate term, short term, and long term Siebel experience
improvements
Contributi . Performed Root Cause Analysis and proposed solutions to many
on production Issues like
'F9 in French Application', 'Data mismatch in S_ORG_BU and S_ORG_EXT
tables',
'Service Request Closure', etc.
. Resolved 200 bugs with Issue types Code Defect, Performance, and
Localization.
. Extensively used VBCs to pull data from external systems and
displayed the data in
Siebel Applets.
. Created Indexes, extended columns, mapped EIM Tables.
. Cloned Object Managers to provide ENG Date Formats for UK Users
since ENG
Language Pack was not provided by Siebel.
. Done development for Computer Telephony Integration (CTI) for
Siebel Sales and Call
Center Applications. Customized Genesys Commands to suit to the
Microsoft Call
Center business functionalities.
. Performed Integration with Quick Address for Siebel (QAS) to look
up addresses.
. Modified Web templates to extend the number of list columns in
List Applets.
. Modified the .SWT files to change the application appearance of
Screen Tabs, View
Tabs.
Environmen Siebel 7.5.3.4 / Win XP /
t
Project # 3
Title MS Siebel 4.0
Client Microsoft Corporation, WA
Duration Oct 2003 to Oct 2004
Role Technical Configurator
Descriptio First Siebel Offshore-Onsite model for Microsoft. Reimplementation of
n MS requirements in Siebel 7.5 on a unified SQL Server DB. Goal is to
provide Integrated user experience supporting information across
systems - 360 degree view of customer/partner Integrated opportunity
/ account reporting and analysis Resource / task coordination of
extended team (including services/partners) and finally enhanced
Account Planning
Contributi . Preparing detailed Technical design based on the functional design.
on
. Configuration and customizations of Views, Applets, Business
Components, Business Objects
using Siebel Tools.
. Written browser and server side script in Siebel VB to achieve
requirements and resolved bugs.
. Performed MLOV Configuration for all columns to display Multi
Lingual List of Values
corresponding to each language.
. Localized the Siebel sales application and Call Centre Applications
in the languages: Japanese
(JPN), German (DEU), Portuguese-Brazilian (PTB), Italian (ITA),
French (FRA), Spanish (ESN),
and Chinese Traditional (CHT).
. Frequently performed string extracts, imports and generated
localized SRFs.
. Analyzed performance bugs and fine tuned the application.
. Investigated many production issues and proposed the solution for
the problems.
. Performed system administrative tasks like import repository,
export repository, check-in, check
out, Database extract etc.
. Written DOS Batch File Utilities to automate the tasks like
compilation, database extracts,
generate new database template, initialize new DBF.
Environmen Siebel 7.5.3 / Win XP
t
Project # 2
Title Fragment Finder
Client IISC/Bioinformatics, India
Duration May 2003 to Oct 2003
Role Software Programmer
Descriptio FF (Fragment Finder) is a web-based interactive search engine
n developed to retrieve the user-desired similar 3D structural
fragments from protein chains. Additionally, the queried motifs can
be superimposed to find out how similar the structural fragments
are, so that the information can be effectively used in molecular
modeling.
Contributi . Designed the Data model to store the motifs of sizes 3 - 12 in
on MySQL database.
. Parsed motifs from the protein chain files (>4K) and inserted
records into appropriate
tables.
. Written SQL statements that will search motifs based on user
input.
. Written PERL Scripts to display the superimposed 3D structure with
the color coding
scheme for easy identification.
. Integrated 3D program STAMP (Structural Alignment of Proteins)
with the software to
display the superimposed 3D structure of protein data.
Environmen PERL / CGI / HTML / JavaScript
t
Project # 1
Title THGS
Client IISC/Bioinformatics, India
Duration Oct 2002 to Apr 2003
Role Software Programmer
Descriptio Transmembrane Helices in Genome Sequences (THGS) is an interactive
n web-based database, developed to search the trans membrane helices
in the user-interested gene sequences available in the Genome
Database (GDB).
Contributi . Designed the Database Schema structure in MySQL to store the
on transmembrane
helices present in the genome database for easy retrieval.
. Written PERL Scripts to parse the genome sequences from text file
and inserted
database records.
. Generated dynamic HTML code using CGI/PERL scripts in response to
a user action
on the web page forms.
. Integrated 3D program RASMOL with the software to display the
three dimensional
structure of helices.
Environmen PERL / CGI / HTML / JavaScript
t
Education
. Bachelor of Engineering (B.E.) in Computer Science from Vellore
Institute of Technology, Vellore (India).