Tejas Hatalkar

ace4x8@r.postjobfree.com +**

961-***-****.

Summary

Sr.Siebel Consultant having 10 years of experience in developing high-

performance technology-driven solutions in the Siebel CRM suite, with

overall 11 years of IT experience. Actively worked on over 10 Siebel

Lifecycle Implementations. Was based in the US since last 4.5 years with a

total International Onshore experience around 5 years.

Possess Valid H1 with 1.5 years of unused Visa, and a 10 yr B1 Visa.

V Expertise in Application Configuration, EAI includes VBCs, EBCs,

Siebel-MQ Series Integration, Datamaps, Integration Objects, Web

services, Workflows, Repeating jobs, E-scripts, User Properties,

DVM, Email Alerts, Asset based Order Management, Product/Price List

Configuration.

V Good Leadership and motivation skills that help me in grooming and

mentoring subordinates

V Won accolades viz "Project Star" for excellent performance in Cap

Gemini (Q3-2012), Affinion Group, US 2009 and in Amicus, London

2006.

V Strong Team Management, Scoping, Estimation, Project Planning,

Delivery and Risk Management skills.

V Oracle Fusion Sales Certified.

V Worked on initial POC on Open UI.

V Well versed with the SDLC and Iterative development methodology.

V Designed and orchestrated Generic Architecture for complex

Interfaces/functionality using best Siebel methodologies.

V Rich experience in business process automation using Workflows,

Repeating jobs, Business Services, and Declarative Alternates to

Scripting in a multi-lingual Environment.

V Participation in all junctures of the Project lifecycle including

Design (Technical Design, Estimation), Implementation, Testing,

Post-Implementation, Support.

V Faster completion of all assigned deliverables ahead of time with

high quality of work.

V Creation of high quality Solution documents containing profound

Technical details.

V Self motivation, dedication, positive attitude and quick learning

capabilities aids in understanding of arduous systems with ease.

Core Competencies:

Design Methodologies Server Side Applications

User Interfaces Product Development

Technical Background

Databases: Oracle 8i/9i/10g, IBM DB2.

Platforms/Tools: Windows 9x, 2000, XP and Windows NT, Red Hat Linux 3.0

(DB servers), Sun Solaris 5.8(App Servers), AIX,

Windows 2003 server, SOAP UI, MS Visio.

CRM: Siebel 7.0.4, Siebel 7.5.2, Siebel 7.7, Siebel 7.8,

Siebel Sales, Siebel Call Center, Siebel Field Service,

Siebel 8.1.1.5 Financial Services.

Other Siebel Siebel Application Configuration, Enterprise

Skills: Applications Integration (EAI) includes

Inbound/Outbound Web-services, VBCs, EBCs, Siebel -MQ

Series Integration, Runtime Events, Business Services,

Siebel Workflows, Integration workflows, EAI Datamaps

and Integration Objects. Workflow Policies, RCRs,

Siebel E-scripts, Browser scripts, State Model,

Localization using Message Categories and Symbolic

Strings, User Properties, Access Control, Server

Administration, EIM,, Order Management, Customized

Email Alerts to Administrators, Correspondence using

Merged Fields, Audit Trail, Screens, Views, Business

Objects, Links, Joins, MLOVs, Task UI on Siebel 8,

Version Control using Subversion, Data Validation

Manager.

Methodologies SDLC, Agile, OUM, Iterative Development.

Entities: Contact, Service Request, Agreement Item, Employees,

Price List, Quote, Orders, Activity, Period, Service

Agreement, Payments, Invoice, Orders, Correspondence,

Recipients, Products.

Work Experience

Cap Gemini Consulting India Pvt Ltd. Oct 2011 - Current

Sr. Consultant

Farmers Insurance, LA, USA

A leading Insurance provider in the US, Service Point

Application is a Siebel Financial Services 8.1 Application

widely used by all Agents of Farmers Insurance to serve its

customers throughout its Service Centers in the US.

Siebel Releases 6.12 - Current Oct 2011 -

Current

Achievements:

o Act as a Project Lead and a Lead Technical Designer/ in

the team for all bi-monthly Releases.

o Authored the Technical design for Siebel - MQ Series

Integration for the Chat

Implementation with Siebel (in a 3 tier Enterprise

Architecture).

o Implemented the solution including configuration of MQ

Receivers, EAI workflows.

o Co-ordinate with SMEs(Subject Matter Experts) of Farmers

and participate in Technical Design Sessions.

o Communicate with program leadership team regarding risks,

changes in priorities, and issues.

o Created Function Specifications, Use Cases, Data Flow

Diagrams using MS Visio.

o Currently working in pilot implementation of Open UI.

o Won the Prestigious Company wide "Project Star" award for

the Quarter Q3 - 2012 for excellent Project leadership and

contribution to the most ambitious Client Project - Chat

Implementation in Farmers.

o Lead a team of 6, co-ordinate with Onsite Co-ordinator,

track Status of deliverables, give periodic demos to

Client, and participate in Design Review Sessions.

o Part of the Upgrade to Open UI 8.1.10, performed UAT on

Open UI patch.

o Modified manifest, theme files on Open UI for desired

results.

o Involved in Scoping, Planning, Resource Allocation, Team

Management Activities.

o Completion of the Chat Project in less than 200 hrs of

record time which had an estimation of 700 hrs thus gaining

respect and recognition from Managers.

o Acted as a Technical Lead ensuring the delivery of the Chat

Implementation with Inbound Service Request creation and

Policy Query Interface from the Chat portal.

o Implemented the Redesign of Outbound Siebel-MQ Integration

with usage of Runtime Events and competent Workflows.

o Created Technical Design documents for the launching of

ExternalApplications(eAgent) from Siebel using

Browserscripts and Business

Services.

o Redesigned and implemented the existing APPS interface

using Siebel best practices and EAI methodologies with

improved Error handling and reuse of Business Services.

o Created Technical Design for implementation of Inbound

Email Integration involving creation of Service Requests

from any Email Source.

o Designed and Implemented solution for notification to

Admins for several MQC bugs on an SR using EBCs.

o Implemented a "Recent SR" functionality aiding Agents to

view SRs for last 5 days on the click of a button. Also

included "Red" color identifier on the Applet control for

Households with more than 1 SRs in 24 hrs (via Browser

scripts).

o Provide MQC bugs resolution support to the Testing team in

UAT, Regression Test cycles.

o Performed Data Loads and Delete of Service

Requests/Accounts via EIM.

o Integrated MQC with Siebel using EBCs.

o Develop relationships with the Client SMEs.

o Quicker turn around in Implementation and Designing helps

in working on 3

simultaneous Releases at any point of time.

o Aid and mentor junior team members by bringing them on pace

and provide technical assistance in Construction/UAT phase.

Affinion Group Inc, Columbus, USA Nov 2008 - Aug

2011

Sr.Programmer Analyst

1) Siebel Releases 2.27 June - Aug 2011

Affinion Group is a global leader in marketing, building

comprehensive customer engagement and loyalty solutions that

enhance and extend relationship of millions of consumers with

many of the largest and most respected companies of the

world. Some of the Membership based Products include

Autovantage, CardCops, Travelers Advantage, Privacy Guard,

Shoppers Advantage.

Project Summary: Participate in the routine Siebel Releases

which include

Change Requests, Performance Tuning, and new Enhancements to

the existing Call

Center 7.7 Application.

Achievements:

o Made modifications, fine-tuned the Billing workflow

processes developed in Inception.

o Configured Audit Trail functionality for

Employees/Position/Responsibility screens to enable

capturing of unauthorized modify/delete by users in these

Screens.

o Implemented new approach to the Cardcops View based on VBC

to create Monitors in the external System by running VBC

code in the background.

o Created Technical Design Documents for upcoming "Project

Royal Bank of Scotland" based on the Inception framework.

o Created, tested, and implemented Asset based Order

Management with tools like Data Maps, workflows, Data

Transformation Engine for Order-Asset propagation of new

Order type ADD MEMBER for RBS.

o Setup of Products, Price lists.

o Implemented downgrade functionality "Benefit Resell" on

subscriptions by creation of new subscriptions, Trial

period and Renewal SRs and Invoices for the same.

o Act as a Mentor to new joinees and fresh graduates from

schools. Also aid in bug resolution and solving technical

glitches..

2) Client: Inception Oct 2010 -

Apr 2011

Sr.Programmer Analyst

Affinion Group is a global leader in marketing, building

comprehensive customer engagement and loyalty solutions that

enhance and extend relationship of millions of consumers with

many of the largest and most respected companies of the

world. Some of the Membership based Products include

Autovantage, CardCops, Travelers Advantage, PrivacyGuard,

Shoppers Advantage.

Project Summary: Inception is a new Order Management based

framework and was proposed as an alternative to the existing

Subscription based Siebel 7.7 Call Center Application (multi-

lingual).

Achievements:

o Lead Developer in the Project actively involved through the

Design, Implementation, Post-Implementation stages of the

project.

o Created the High Level Design and implemented 'Add

Product'' Inbound Web service for new Product additions and

Upgrade/Downgrade of Registered Products, actively

participated in the Billing module, Customization of the

Asset based-Order Management module.

o Developed new Business Services/workflows/Integration

Objects based on the Technical design for Consolidated

Billing, Correspondence, Asset based- Order Management with

effective usage of date/time/string handling functions.

o Created Asynchronous workflows to incorporate process

automation and improve performance on Order Confirmation -

Correspondence.

o Designed new RCRs for the Billing and Asset workflows and

ensured high performance of these Repeating jobs using

suitable indexes.

o Configured Access Control for Orders with Organization,

Multi Org Visbility.

o Performed POC on Task UI in Siebel 8.1 for an existing

process in 7.7.

o Created, tested, and implemented EAI Data Maps using Data

Transformation Engine for Order-Asset propagation including

for NEW ENROL, CHANGE PAYMENT, CONFIRM ORDER, MODIFY ASSET

Orders.

o Created workflows invoked on Order confirmation that

validated Order headers, executed Data Maps for Order-Asset

mapping and upsert Assets.

o Provided faster resolution of strenuous bugs raised in

QA/SIT testing and provided support to the SIT/UAT team

throughout Release of code to the Test/Staging system also

aiding in Data Setup.

o Participated in Estimation and proposed accurate/realistic

timelines for all deliverables.

o Implemented generic Enterprise-wide approach for 'Exception

handling' in server jobs, web-services.

o Produced 'Dev Summary' Documents outlining the Process,

implementation changes made to the System.

o Received excellent feedback from the Project Manager for

exceeding Expectations on the performance throughout the

project.

3) Client: Germany Online - Haspa Bank Mar 2010 - Sep

2010

Project Summary: Haspa Bank, client of Affinion International

is one of the largest banks in Germany. The requirement was

to enable Retail customers to register new Assets like

Bicycle, Vehicle, Documents including Passports, Bank

Deposits, Bank Accounts via Retail Online site integrated

with the Siebel 7.7 Call Center Application (ENU/DEU).

o Created new Screen/Views for a Member to register new

Document/Bicycle/Vehicle Assets. Added validation rules for

Registration and raised custom Error messages using Message

Categories.

o Created new Merge fields for Correspondence in

Correspondence and Recipients BC, modified concerned User

Properties.

o Added code to existing Business Service to generate and set

Merged field information for Welcome Packs.

o Created Templates for Correspondence.

o Designed/Implemented Asset Inbound/Outbound web-services to

sync data from the Haspa website to/from Siebel.

o Created automated workflow processes triggered by workflow

policies for the sync process.

o Provided warranty support for UAT team after Go-live in

Production.

o Implemented Siebel localization for Applets, Views, Screens

using Symbolic Strings and Message Categories.

o Provided faster resolution of strenuous bugs raised in

QA/SIT testing and provided ongoing support to the

SIT/UAT/Integration Testing team throughout the release of

code to the Test/Staging system including workarounds and

Data Setup issues.

o Collaborated with the Online Team and created Mapping

document to simplify Online-Siebel integration.

o Created/modified Business Objects, Business Components,

Joins, Links, Drilldowns, data validation scripts.

o Developed 'German name' transformation routine which

converted special German words that appear in German First,

Last Names like 'Von', 'Der', 'Van', 'Zu' to lower-case

using string manipulation functions.

3) Lets Go/Rapido Oct 2009 - Mar 2010

Project Summary: Rapido and Lets Go are 2 new promotion

products launched by Affinion International, UK allowing

users to select from available Interests like Movie, Travel,

Dining etc. Promotions are sent to the Members based on the

selected Interests. These websites were integrated with the

Siebel 7.7 Call Center Application

o Modified existing Web service 'Enroll Member' to copy

Promotion Interests listed on the Package that the member

wishes to subscribe to the Membership during an Online

Enrolment.

o Modified existing Web service 'Update Profile' to update/de-

select the Promotion Interests that Member wishes to update

through the Online Channel.

o Created a new EAI web-service 'Find Related Member' to

retrieve Secondary/Joint Members and their subscribed

Packages/Products using intricate search expressions.

o Created custom BCs based out of XM tables to store Member

Interests for a Member.

o Reported and overpowered Siebel Product defect of inability

to search records when special characters like ' ' '

are present in a record.

o Added error logging to the web-services by adding Error

Properties in the Response of the web-services in the event

of an exception.

4) HSBC CardCops/QL2 Apr 2009 - Sep

2009

Project Summary: CardCops is a web based product offered to

HSBC's bank customers enabling them to register a no of

Cards which are continuously monitored for fraudulent

activity. QL2 Datasweep is another product which notifies

user if it finds his name/phone/address displayed on a no

of listed sites integrated with the Siebel 7.7 Call Center

Application.

o Consumed External WSDL to create Integration Objects and

Proxy Business Service.

o Solutioned detailed Technical Design document for CardCops

Inbound Integration using inbound Webservices and a VBC.

o Created bespoke Business Service to invoke the external

service for CardCops monitoring.

o Implemented Siebel localization for Applets, Views, Screens

using Symbolic Strings and Message Categories

o Return results obtained from the Outbound webservice to a

VBC and display in custom Siebel Screen/View.

o Performed POC on a proposed design for Outbound Webservices

with 2 VBCs in a View.

o Implemented "cardcounts" limiting a Member to only register

defined no of cards for CardCops.

o Implemented modify/cancellation of CardCops registration

for all Members in the Membership using Workflow policy and

repeating job.

o Participated in SIT/UAT/Integration Testing.

5) UK Event Booking Oct 2008 -

Mar 2009

Project Summary: New functionality to allow RBS/Natwest

customers to book

Movie/Travel/Concert/Event tickets through the Call

center and earn

Cashback/Discount on tickets.

o One man show - project, the only Lead Developer in the

Project with participation in design, implementation,

testing, UAT support, customer interaction.

o Created new "Event Booking" Screen/View to enable booking

of tickets by creation of Service Request/Orders.

o Allowed agents to book multiple tickets under multiple

categories, and calculate

Cashback/discount payable to the Member.

o Developed bespoke service to calculate Cashback/Discount

amount based on the Cashback/Discount % set on the Package

and Ticket category.

o Developed automation script invoked on Order Confirmation

which collected Payment from the Member, generate Invoice

and send Confirmation letter (ticket details) to the

Member.

o Also developed workflow and Business Service to calculate

cashback and confirm the Order for Orders loaded through

the Interface channel. Developed Policy conditions which

invoked the the workflow thereby generating Invoice/Payment

and sending Confirmation letters to the Member.

o Worked on the enhancement on the project to send email

confirmations to the Member by invoking Email Service on

External System.

o Created Cashback Summary View under the Member which listed

historical data of Cashback obtained by the Member.

o Configured Exchange Conversion from to to E for Invoice

calculation in the service.

o Supported project during SIT/UAT/Go-live and interacted

with Call Center agents for UAT Issues.

6) Siebel Releases 2.16, 2.17, 2.18 Jan

2008 - Sep 2008

Project Summary: Participate in the routine Siebel

Releases which include

Change Requests, Performance Tuning, and new Enhancements

to the existing multilingual Call Center 7.7 Application.

o Tuned a '30 Day - Open Service Requests' PDQ frequently

used by DEU Application by analyzing the query, PLAN

generated and creating an apt index on the table.

o Implemented Re-Instate Cancelled Members functionality by

developing a new Screen and enforced checks on limited

usage of Cancelled Members not limited to ordering new

products, Correspondence, processing of Invoices, Service

Requests.

o Implemented Siebel localization for Applets, Views, Screens

using Symbolic Strings and Message Categories

o Developed an Inbound webservice for querying no of Active

"Shoppers Advantage" cards registered for a Member.

o Implemented "Red color" functionality to the Member Status

field when it is in Cancelled status by using Icon Maps and

Bitmap Categories.

o Configured Access Control for Payments and Invoices.

o Monitored Policy groups for stuck policies and workflows.

o Performed Repository migration from Dev to Test

Environment.

o Performed Application Administration tasks like

import/export of Workflows, LOVs import/export, setup of

new Correspondence Templates.

o Added new Merge Fields to DEU Correspondence letters.

o Used configuration to invoke Business Service from a

Calculated field and update "Invoice refund flag" on

Invoices if Payments under it were refunded without having

the need to drilldown an Invoice.

o Proposed development of an Error logging Screen, performed

POC and developed functionality for sending Email alerts to

Administrators when an error was logged in the Error

table/BC.

7) Payment Card Protection Online (PCP) July 2007 - Dec

2007

Project Summary: New Product PCP launched for Affinion

Members enabled the Members to register their Credit/Debit

cards online for protection against fraud.

o Created Technical Design Document for the "Update Profile", "Tier Change"

Inbound webservice.

o Performed POC on the Inbound webservice with usage of

workflow exposed as a

Business Service.

o Created/modified Integration Objects for Update Profile,

Tier Change.

o Developed bespoke Business service "Update Profile" to

parse the incoming XML, perform validation, raise error and

upsert Siebel with incoming Address/Email updates.

o Developed Business service to simulate the existing UI Tier

Change functionality, to be invoked by the Online website

using Webservices.

o Participated in Design workshops with the Online,

representing the Siebel team.

o Provided support in the Integration Testing/SIT/UAT cycles

of the project.

Perficient Inc/Epairs, USA Apr 2007- June

2007

Siebel Consultant

Achievements:

o Worked on a POC for a client of Epairs Inc.

o Participated in the Design of the Call Center Application.

o Installed Siebel Servers and setup local environments for

the Users.

o Took part in the rapid Implementation and presented to

prospective Clients of the company.

o Prepared Project Report for the same.

o Trained new recruits in the company in Siebel.

Worked as a Consultant in Affinion from July 2007 - Oct 2008

as an Employee of Perficient Inc, project details as above.

ATOS Origin May 2005 - April

2007

1) Client: Department for Work and Pensions, UK Dec 2006-

April 2007

(Support)

Sr.Siebel Developer

Summary: - The call center agents use Lauren Siebel

application across the UK to

book appointments of clients. This application was integrated

with SMART and

MSRS (Medical Service Referral System). Siebel application is

used in scheduling

the appointments.

Achievements:

o Perform Repository Migration and other Administrative

activities on the Dev Server.

o Implement the RFCs involving enhancements to the existing

code, refining code to involve usage of User Properties.

o Developed/Exposed a Business Service to be invoked by the

External Legacy System through WebServices and tested it

through XMLSpy.

o Act as a Lead Siebel Developer and act as a Backup Team

Lead.

o Implemented code using Siebel Best Practices, also refined

existing code with usage of User Properties.

o Designed Business Services, Workflows and created Design

Docs.

o Developed an "Import Tool" for automating Zip Codes upload

through excel sheets using COM Scripts

o Restricted User to enter limited Text in Comments, Zipcode

Fields using Field Level User Properties.

Environment: Siebel 7.8.2 Employee Applications (Siebel

Service), Windows XP, Oracle 9.1.2

2) Client: Amicus Union, London, UK May 2006 -

Nov 2006

Sr. Siebel Developer

Project Summary:

The Siebel Public Sector 7.8 Application was implemented

for one of the largest Employee Unions in the UK to mainly

manage the Subscriptions, Memberships for the its

Registered Members.

Achievements:

o Developed Custom Business Services for Arrears and

Termination of Member functionality and invoked those using

Batch jobs.

o Designed Business Services, Workflows and created Design

Docs.

o Effectively used Outbound Emails for Exception Handling.

o Implemented Audit Trail facility to track field values for

certain users.

o Creation of Joins, Links, Pick Applets, MVG Applets for

entities such as Contacts, Orders, Accounts, Employers and

other custom entities as per the requirement

o Implemented complex configuration tasks using Data

Validation Administration screen reducing Validation e-

scripts.

o Designed and developed generic Inbound Integration

Workflows with Legacy Systems using EAI Dispatch Service

and JMS Receivers.

o Developed generic Outbound Integration Workflows to send

Payment Information to the external system.

o Involved with Direct Client Interaction, and screening

demos of the Build.

o Developed Workflows for Validation of Members, Activation

of Members, and Calculation of subscriptions.

o Performed Server Administration tasks such as Repository

Migration, database extracts, monitoring of components,

monitoring server boxes for performance, creation of new

users, broadcasting messages.

o Effectively used Workflow policies, Applet/BC User

Properties to invoke Workflows.

Environment: Siebel 7.8.2 Employee Applications (Siebel Field

Service), Windows XP, Oracle 9.1.2

3) Client: Department for Work and Pensions, UK June 2005 -

April 2006

Sr.Siebel Developer

Department for Work and Pensions is an Employee Benefits

Organization

promoting employment and employee benefits to large no of

users in the UK.

Project Summary: The Siebel 7.8 eService Application was

developed to aid

Employees enjoy the medical benefits. The Employees call

the Call Center and fix

Appointments for Medical Examinations based on availability

of Practitioners and Appointment Slots.

Achievements:

o Designed and developed Siebel Workflows that catered to

various functional requirements.

o Designed and developed Customized Business Services for

desired functionality (Booking of Appointments, Validation

of Appointments, and Validations of Appointment Slots).

o Created Applets, Views and Customization of existing

Vanilla Suite to suit client needs.

o Created new objects such as Applet Toggles, Drilldowns for

conditional navigation.

o Performed Server Administration tasks such as Repository

Migration, database extracts, monitoring of components,

monitoring server boxes for performance, creation of new

users, broadcasting messages.

o Extensively used BC/Applet User Properties to invoke

workflows, enable/disable functionality (button clicks),

make fields read only based on conditions.

o Configured Conditional deletion of records using User

Properties.

o Configured Hierarchical Picklists for desired client

functionality.

o Developed Customized Business Services for Plan and

Sessions Management.

o Used State Model to limit conditional transition of fields,

limit updating /deletion.

o Implemented broadcasting of Emails for Issues tracking

using Outbound Communications Manager.

o Automated Business Processes to run as Batch Processes at

predetermined intervals in a week.

o Customized Audit Trail functionality and implemented it.

Environment: Siebel 7.8.2.2 Employee Applications (Siebel

eService), Oracle 10g,

Windows XP.

Deloitte Consulting Inc. April 2004-

May 2005

1) Client: Agilent Technologies.

Responsibilities: Siebel Admin/Configurator.

Feb 2005 - May 2005

Project Summary:

Agilent is a Worldwide leader in development of Scientific

tools and

Measuring instruments. The Siebel Application deployed

over 5 geographies

helped Agilent maintain their client base and their Site

Engineers troubleshoot issues

using the Siebel Field Service module.

o Perform Siebel Server Administration tasks such as

monitoring of Server logs, Components, Repository

Migration, database extracts.

o Performed Application Administration tasks such as addition

of users, responsibilities, LOVs, setting up System

Preferences, Predefined Queries

o Developed and configured Order Management for Field Service

users.

o Developed Business Services for Service Orders, Invoices,

Service Agreements

o Developed Siebel VB COM Scripts for requisite

functionality.

o Configuration/Customization of OOB Objects, Joins, Links,

MVGs and Pick Applets.

o Developed Common Issues and Best Practices papers for the

Business Users.

o Participated in the Release Management Activities such as

creation/maintenance of Release Notes, Metadata creation.

o Developed BC level scripts for validations.

Environment: Siebel Field Service 7.0, Oracle 9.1.2.

2) Client: HP.

Responsibilities: Siebel Configurator Nov 2004 -

Feb 2005

Summary: HP, US is a leading brand in Computer Desktop

accessories and Printers.

The Application in Siebel Sales helped the Organization

boost it's Sales and aided the

Sales & Marketing team to sell its products to end-clients.

Achievements:

o Performed Configuration tasks such as Creation of

Customized Applets, Views, Screens with OOB(Out of the Box)

Business Components.

o Configuring Calculated Fields and adding them to

appropriate Screens for achieving field totals and

Discounts functionality.

o Developed function to nullify the impact of seconds on

Opportunity creation.

o Aided in the creation of Technical Design Documents.

o Created Joins, Links, MVGs and Pick Applets as per the

Technical Design.

o Developed validation scripts on Business Component Events

for discount validation.

o Developed runtime workflows to achieve desired

functionality.

o Developed Calculated Fields to display rolled up totals

from Child records.

o Designed code for Business Service to extract few

characters from zipcode.

Environment: Siebel 7.5.3.2, Siebel Sales Module, Oracle

9.1.2.

3) Client: Home Depot May 2004 - Oct

2004

Responsibilities: Siebel Integrator

Home Depot is one of the leading brand in home accessories and

upholstery in the US. The Siebel Application was integrated

with the Legacy Application to have an Integrated solution to

phase out the existing System.

Achievements:

o Collaborated with the Onsite team and assisted them in the

evolution and upgradation of Design Documents.

o Developed Custom Business Services achieving client

required functionality extensively in E-scripts.

o Developed DTDs based on client requirements.

o Configured Applets, Views, MVGs for Customer, Products on

client needs.

o Developed functionality to open PDFs in the internet

explorer.

o Resolved and implemented Change Requests assigned.

o Created EAI Workflows and tested them.

o Created and tested Outbound Webservices.

o Created External Integration Objects, Integration

Components based on the DTDs.

o Created Validation Business Service for validating required

fields in incoming XML.

o Created Data Maps for mapping Legacy Objects to Siebel

Integration Objects.

Environment: Siebel 7.5.3.2, Mercator Series, Oracle

9.1.2.4.

Non Siebel Projects:

Cap Gemini

1) Client: Visteon. Aug 2003 - Apr 2004

Responsibilities: Primary Analyst

o Application Maintenance of Critical Applications developed

in Visual Basic, Centura with Oracle 8i as back end.

o Troubleshooted and Developed database scripts to manipulate

and maintain the Client Database in Oracle 8i.

o Successfully implemented and follow CMM Level 5 Quality

processes.

o Developed Visual Basic code to implement client

requirements.

Summary: Visteon Corporation is a recognized brand in the

Automotive Industry and one of the biggest suppliers to Ford

Motors. The IT solution used a variety of Applications to

maintain, and develop new automotive parts across its plants

in the US.

Environment: Visual Basic 6, Centura, Oracle 8i.

Education

o Post Graduate Diploma in Advanced Computing CDAC, Mumbai.

o Bachelors of Engineering, Mumbai with specialization in

Computer Engineering.

Certifications /ACHIEVEMENTS

* OCA Oracle Certification exam 9i Paper I

* OUM Level 1 Certified.

* Completed Harvard Business School's "Management Essentials"

Certified e-learning program.

* Voted as the "Champion of the Week" at Amicus, London 2006

for exceptional performance at the Client.

* Won the "Project Star" Award in Q3 2012 in Cap Gemini.

* Train new joinees on the Project with a detailed Knowledge

Transfer.

* Part of the panel for interviewing new Siebel candidates in

ATOS Origin and Affinion Group Inc.

* Received Above Expectations ratings in Affinion Group Inc, US

for 2 years in a row.

* Completed "Personal Branding" softskill Training.

* Completed the "Nurture" Budding Managers Training Program.

Contact this candidate