Summary:

• 6.5 years of experience in Business Applications Development, implementation and Customization of CRM (SIEBEL) applications.
• Over 5 years experience in Siebel integration
• Expert in integration using Integration Objects, Siebel eAI over HTTP, Business Service scripting, Web Services & Virtual Business Components, EAI Data Mapper using scripts & using Data Map Editor.
• Experience with integrating Siebel OnPremise with Siebel OnDemand.
• Hand-on-experience with integrating Siebel with external java application using Java Data Bean
• 1 + years experience in Siebel Analytics customization
• 1 + years experience with Order Management
• Extensive experience in Siebel Order Management, Product Configurator, Eligibility and Compatibility, Pricing.
• Extensive Experience with Siebel Tools Configuration, Siebel Scripting and automating business processes with Workflows
• Extensive experience in star schema design and customization of Siebel Analytics Application RPD configurations, report design/ development, dashboards, guided navigation.
• Hands-on-experience on Analytics Web Services Integration
• Exposure to SQL performance tuning on Oracle 9i
• Experience on end-to-end Siebel Marketing Analytics implementation design and implementation of 24 marketing Programs and campaigns.
• Worked on Actuate reports master detail, composite, combined data stream, multi-lingual reports.
• Exposure to Siebel Mail Response & EIM.
• Exposure to MDM and UCM Workflows
• Currently working as an Independent Consultant

Key Accomplishments:

• Received Quarterly Performance Award for Proof of Concept for a pilot web services project for British Telecom.
• Received Knowledge Management award for contribution of a re-usable tool java application used for testing Siebel inbound/ outbound interfaces.
• Received the Best Project Team award for two projects
• Extensive experience in implementing multi-lingual Actuate reports

Educational Qualification:

• Master’s in Information Technology
• B.Tech. Electronics & Communication,
• XIIth Science with Computer Science

Independent Consultant, Confidential

• OnDemand CPQ Engine Jan 2009 Till Date

CRMantra is developing a Configuration-Pricing-Quoting (CPQ) product offering for Oracle Siebel OnDemand application. This product involves integrating the OnDemand application with the OnPremise CPQ offerings using web services. OnPremise is used as the Product/ Pricing master.

Period January, 09 Till Date

Duration Ongoing

Team Size 6

Software Environment

Siebel CallCenter 8.0, Microsoft SQL Server, Oracle Siebel OnDemand, Flex 3

Role Siebel Consultant

Responsibilities

• Integration Design Lead for integrating OnPremise with OnDemand
• Designed & developed 13 web service based interfaces.
• Designed & developed custom Integration Objects & data maps.
• Developed a local business service to enable dynamic destination for web services.
• Designed & developed the outbound Product sync web service interface between OnPremise & OnDemand.
• Designed & implemented web services to enable Quote object functionalities like Reprice, Copy Quote, Revise Quote & Spread Discount through a Flex based UI in OnDemand
• Designed a web service interface to enable Eligibility & Compatibility check on Quote line items.
• Designed the Flex UI and the web service based integration with OnPremise to define Discount Matrix Meta data for a generic pricing solution.
• Designed & developed custom pricing procedure to be invoked through Flex UI in OnDemand
• Customized OnDemand UI for enabling interfacing with OnPremise application.
• Designed an extremely generic Eligibility & Compatibility framework for implementing CPQ through OnDemand.

Confidential, Mar 2008 Jan 2009
GE Health Care is re-implementing its CRM Solution in Siebel 8.0 that they plan to rollout across the Americas, Europe, Asia and Africa. The application provides a base platform for individual P&L to build up further functionality on. It entails a complete implementation involving designing and configuring the business UI, interfaces to various systems and a re-vamped Order Management System.

Period March, 08 January, 09

Duration 10 months

Team Size 6

Software Environment

Siebel eMedical 8.0, Oracle 10g

Role Siebel Consultant

Responsibilities

• Configured the Quote and Asset objects to enable Service Quoting process from Opportunity to Quotes to Agreement.
• Modified the Dynamic Pricing Procedure to enable client-specific pricing requirements
• Designed and implemented an enterprise-wide automated Price List selection mechanism. The custom pricing procedure to enable this is being invoked in the Quote, Order, Agreement, and Service Request objects
• Designed and implemented custom pricing workflows to enable discounting, various costs, margin calculations, and line level sub-totals, and header-level totals.
• Designed a custom pricing procedure for group-level summary margin analyses on Quotes.
• Enabled specialized manual discounting logic through the configuration of the Spread Discount service and PSP workflows
• Designed and implemented custom Eligibility and Compatibility workflows to support Product Configuration rules based on Product Family, Product Relationships, and an integrated Geographical hierarchy.

Confidential, Oct 2003 Mar 2008

• Alltel Telecom Siebel Project, USA

A large telecom major has implemented Siebel eCommunication for its Customer Service Representatives. The front end for this is a portal which interacts with Siebel, billing system and a host of other legacy systems. The project involves a lot of integration work with data coming in through EAI and EIM. The client is facing issues with data because of the conflicting design of the EAI and EIM interfaces.

Period August, 07 March, 08

Duration 7 Months

Team Size 15

Software Environment

Siebel eCommunication 7.8.2, Siebel eCustomer 7.8.2, Oracle 9i, WBI

Role Integration Analyst

Responsibilities

• Interacting with the teams from different systems integrated with Siebel to understand the requirements and design.
• Modifying existing business service, workflows and configuration to provide business enhancements.
• Creating new business services/ workflows to map business requirements
• Creating integration objects, scripts & workflows for new interfaces with WBI and portal.
• Design of VBC interfaces using integration Objects, Custom business scripts with WBI acting as a middleware.
• Analyzing the integration architecture to look for any potential future issues and fixing the gap.
• Developing Java Data Beans for purging/ updating data in Siebel DB.
• Recommending design approach/ changes and best practices in consideration with the existing issues with production application.
• Reviewing the code and interface design and suggesting efficient alternate solutions.
• Analyzing the data integrity issues and root cause; altering business scripts to prevent them on a continuing basis.
• Gap analysis between real time and EIM interfaces Field mappings and user keys.
• Developing SQL patches to fix data integrity issues.
• Acted as primary design reviewer for new development projects coming into production.
• Using Siebel Tools for configuring business components, links, MVL, joins, applets etc. for enhancement releases.
• Creating technical design for the interfaces

Confidential, USA
A large Insurance major has implemented Siebel Financial for its Field Technology agents. The application helps them in managing their contacts and leads and all related activities. Over the years the historical data size has grown to unmanageable size. This has led to performance and maintenance issues with the TNC application. This project deals with analysis and purging of data no more required from a business point of view.

Period April, 07 July, 07

Duration 3 months

Team Size 5

Software Environment

Siebel Financial 7.5.3, DB2

Role Technical Analyst

Responsibilities

• Interacting with the client to get the business rules clarified.
• Analysis of the technical approaches and their feasibility direct SQL update, Java Data Bean & Custom Business Service.
• Created custom light weight Business Objects, business components, joins, links & table extensions for the purge script.
• Preparation of Functional Design.
• Reviewing the Technical Design Documents, Test Cases prepared by the offshore team
• Developing and testing the business service to purge the data.
• Ensuring quality of deliverables and meeting timelines.
• Conducting and overseeing the SIT for the client.
• Conducting the production verification testing with the client

Confidential,Plan Management Analytics, USA
A large HR/ Financial Services major had implemented Siebel Analytics integrated with Siebel PRM Portal to manage their customers’ investments and give a 360 degree view of their portfolios. This project entailed the re-design and development of the warehouse schema, reports and additional dashboards to meet the complete client reporting requirements.

Period August, 06 January, 07

Duration 6 months

Team Size 4

Software Environment

Siebel Analytics 7.8.2.3, Siebel eChannel 7.7

Role Technical Lead

Responsibilities

• Interacting regularly with the client to get the requirements & scope clarified.
• Preparation of Functional Design.
• Providing technical approach to requirements.
• Designing and configuring the custom stars, Business layer models and presentation layers.
• Configuring aggregate navigation, dimensional hierarchies, measures, facts, dimensions etc.
• Developing new reports and dashboards Table reports, Pivot Table reports, Bar, pie and 3d Bar graph reports, etc.
• Managing and allocating work for the 3 member offshore team
• Providing technical assistance to resolve issues faced by the offshore team.
• Reviewing the Technical Design Documents, Test Cases prepared by the offshore team
• Keeping track of milestones.
• Providing a weekly project status to the client team.
• Ensuring quality of deliverables and meeting timelines.
• Conducting and overseeing the UAT for the client.
• Conducting the production verification testing with the client

Confidential,
The project was for a Telecom Client in Saudi Arabia. The project involved the development of a CRM solution involving integration with several legacy systems, using Siebel Analytics as a reporting tool and designing marketing campaigns.

Period May, 06 July, 06

Duration 2.5 months

Team Size 22

Software Environment

Siebel eCommunications 7.8.2, Siebel Analytics 7.8.4, Actuate Workbench 7

Role Technical Lead

Key Achievements

• Leading a team of 4 for the design and development of an interface module.

Responsibilities

• Interacting with onsite team on a regular basis to get the requirements clarified.
• Creating technical design document for the interfaces
• Providing technical assistance to resolve issues encountered with the development of the interfaces by the development team business service & configuring the VBCs.
• Wrote the master custom script and the workflow for the VBC interfaces.
• Reviewing the tools configuration (business service, VBCs)
• Reviewing all deliverables to onsite and ensured that delivery schedules were met.
• Prepared weekly work status reports.

Confidential,

A Financial Services major is implementing a Siebel Financial Services based CRM solution for managing interaction with its clients. A large part of the solution consists of moving customer, asset and relationship data from disparate sources into Siebel with the aim of providing a complete view of customer worth and interactions to its Sales and Client management teams.

Period Feb, 06 April, 06

Duration 3 months

Team Size 6

Software Environment

Siebel Analytics 7.7.1.4, Siebel eFinance 7.5.3.9

Role Analytics Developer

Responsibilities

• Design and configuration of custom stars.
• Configuring Analytics Repository creation of measure, dimensional hierarchies etc.
• Developing reports and dashboards.
• Preparation of Technical Design Documents, Test Cases and Review Documents

Confidential,Australia

A large automobile manufacturer committed to providing a global Siebel CRM solution to each of their regions, intends to use this global initiative to their advantage and leverage as much work as possible to develop a Australia specific CRM solution. Project involved the design, build and deployment of Marketing Campaigns and Answers Reports. The client’s marketing requirements and expectations could be met using the Siebel 7.5 Marketing with Siebel 7.7 Segmentation Bridge.

Period August, 05 January, 06

Duration 5.5 months

Team Size 10

Software Environment

Siebel Automotive 7.5.3, Siebel Marketing 7.5.3, Siebel Analytics 7.7

Key Achievements

• Handled the design and build of marketing campaigns.
• Wrote complex Unit Test queries in SQL to test campaign functionality Contact Load, ELF count etc.

Role Marketing Consultant

Responsibilities

• Interacting with client and getting the functional specifications baselined.
• Configuring custom stars for marketing and reports requirements.
• Customizing the analytics repository.
• Design and configuration of all marketing campaigns.
• Design of CLF, ELF, segmentation catalogs & segments.
• Co-ordination with integration middleware team based in Bangalore for interfaces’ integration testing.
• Preparation of Technical Design Documents, Test Cases, User Guide and Review Documents for Quality Control.
• Preparation and execution of System Test Cases, Performance Test Cases and Regression Test Cases.
• Assisting the client user with User Acceptance Testing.

Confidential,

This is a localization project for a large automotive client in North America. The project was basically a Lead Management and Tracking system. The implementation required localization for North America on the client’s globally deployed CRM repository. The team comprised of 22 members.

Period December, 04 July, 05

Duration 8 months

Team Size 22

Software Environment

Siebel Automotive 7.5.3, Siebel eDealer 7.5.3, Actuate Workbench 6

Key Achievements

• Handled the complete design & configuration of interfaces with Siebel (both inbound and outbound)
• Nominated for training in Analytics

Role Siebel Developer

Responsibilities

• Design and configuration of all inbound and outbound interfaces over HTTP using Integration Objects, workflows and custom/ vanilla business services.
• Configured the EAI Dispatch Service to design a single entry workflow for all inbound HTTP interfaces.
• Designing and developing inbound/ outbound web service as proof of concept for client. Designed a workflow and a custom business script for the inbound web service.
• Wrote a custom script to alter the incoming XML
• Configured a VBC interface with XML Gateway as the broker service.
• Configured outbound interface to send a MIME attachment.
• Co-ordination with integration middleware team situated in Bangalore for interfaces integration testing
• Developing Actuate reports Combined stream, Master Detail.
• Preparation of Technical Design Documents, Test Cases and Review Documents for Quality Control

Confidential,

Worked on a project for a large automotive client as a Siebel Technical Consultant. The project was for the development and deployment of a CRM solution for the dealers of the client in Canada with Siebel Automotive and Siebel eDelaer.

Period February, 04 September, 04

Duration 8 months

Team Size 6

Software Environment

Siebel Automotive 7.5.3, Siebel eDealer 7.5.3, Actuate Workbench 6

Key Achievements

• First to develop multi-lingual reports using Actuate eReporting Workbench
• Configured the application for multi-lingual deployment
• Nominated for training in Actuate Reports

Role Siebel Developer

Responsibilities

• Carrying out Server Administration tasks.
• Configuration of the application using Siebel Tools and scripting.
• Developing reports for Siebel using Actuate eReporting Workbench.
• Preparing the Technical Design Document, Test Cases and part of the testing team for the application.
• Configuring the application for multi-lingual deployment.

Training:

Siebel specific Training

• Trained for configuration on Siebel 7.5.x
• Trained for Siebel Analytics
• Trained on Siebel Marketing

Trained internally on

• Oracle/SQL
• Web Programming
• DBMS FOR CRM
• SQL
• JAVA