SPAARC Email
Client Name : ICICI Prudential
Role : Developed functionality to provide attachment functionality for sending
Emails and to prevent different users to work on same call.
Challenges : Whether to implement pessimistic or optimistic locking.
Architecture : N-Layered Controller Façade
Description : SPAARC Email is an enhancement for SPAARC system, which will provide
functionality of sending emails with/without attachments to a specified user from
the SPAARC EMAIL Screen. It included ability to restrict another user to work on
same call to avoid inconsistency.
Technologies : Asp.net 2.0, sql server 2005, C# 2.0 and JavaScript.

SPAARC CTI (Computer Telephony Interface)
Client Name : ICICI Prudential
Role : Enhanced existing SPAARC system for ICICIPru call center users to be able to
login to spaarc through a web service and be able to log calls from CTI
(Computer telephony interface) without need to open up SPAARC as a separate
application.
Challenges : How to transfer data from CTI to SPAARC system which was needed for
authentication and authorization.
Architecture : N-Layered Controller Façade
Description : SPAARC CTI is an enhancement for SPAARC system, which is used to integrate
CTI (computer telephony interchange) system deployed at ICICIPru with
SPAARC so that once call center users have logged in to CTI they need not to
login again into SPAARC to work on calls by using web service methods.
Technologies : Asp.net 2.0, Web services, SQL Server 2005, C# 2.0 and JavaScript.

SPAARC FMS
Client Name : ICICI Prudential
Role : Developed a module which exposed data through a web service which picked up
the same through tables which were periodically filled by a window service for
FMS team in ICICI Prudential.
Challenges : How to pick up calls from HEAT Database which were created/updated based
on configurable time.
Architecture : N-Layered Controller Façade
Description : SPAARC FMS is an enhancement for SPAARC system where a window service
picked up specific data from SPAARC tables to SPAARC FMS tables, and
exposed the same data through a web service to another team.
Technologies : Asp.net 2.0, Web Service, Window Service, SQL Server 2005, C# 2.0, JavaScript

SPAARC RMC
Client Name : ICICI Prudential
Role : A new tab for RMC was added to SPAARC GUI that contained the details for
RMC.Javascript caching was used to increase the performance and efficiency.
Challenges : How to integrate RMC into existing JavaScript caching in SPAARC.
Architecture : N-Layered Controller Façade
Description : SPAARC RMC is an enhancement for SPAARC system where a new tab for RMC
was added to SPAARC GUI that contained the details for RMC.
Technologies : Asp.net 2.0, SQL Server 2005, C# 2.0, JavaScript

SPAARC Unit Statement and PPC PDF Generation
Client Name : ICICI Prudential
Role : Unit Statement and PPC PDF Generation modules were created for
SPAARC system where PDF reports were being generated fetching data from LA
(Life Asia server maintained by IBM Corp) using ItextSharp PDF Component to
develop PDF reports. Journals were created in SPAARC on creation of PDF
reports and saving of call.
Challenges : Which component to choose for PDF generation. How to fetch data from DB2.
Architecture : N-Layered Controller Façade
Description : SPAARC Unit Statement and PPC PDF Generation is an enhancement for SPAARC
system where PDF reports were being generated fetching data from LA (Life Asia
on server maintained by IBM Corp) using ItextSharp Component to develop PDF
reports. Journals were created in SPAARC on creation of PDF reports and saving
of call.
Technologies : Asp.net 2.0, SQL Server 2005, C# 2.0, DB2, BO, JavaScript

SPAARC MCT
Client Name : ICICI Prudential
Role : Worked on a CR to add a new categorization for calls named (Master Call Type)
to Call log screen of SPAARC.
Challenges : To integrate MCT into existing JavaScript caching system.
Architecture : N-Layered Controller Façade
Description : ICICI Prudential needed one more level of call categorization to be added and for
the same purpose a new dropdown of MCT (Master Call Type) was added to
existing call log screen in SPAARC.
Technologies : Asp.net 2.0, SQL Server 2005, C# 2.0, JavaScript

SPAARC Banca
Client Name : ICICI Prudential
Role : Worked on a CR (Customer request) to modify lead allocation system in SPAARC
for ICICI Prudential agents to facilitate lead allocation.
Description : Earlier users had to manually search for agents and then allocate leads along their
Name. SPAARC-BANCA was developed to facilitate users for automating lead
allocation system by making some UI and functional changes to existing ‘Lead
Allocation’.
Architecture : N-Layered Controller Façade
Challenges : To use XMLHttp for enhancing user experience into existing system.
Technologies : Asp.net 2.0, SQL Server 2005, C# 2.0, JavaScript