Service Project
Resume:
Tejas Hatalkar
*****.********@*****.*** +**
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