SUMMARY:

• Over 11 years of experience in the industry as Siebel CRM Techno - Functional Consultant
• Rich experience in Requirements gathering, Analysis & Design, and customization of Siebel Applications
• Worked with prestigious clients: Confidential (Yellowbook), SYKES Enterprises, Confidential, Cigna Health Care, AXA Financials, Confidential, Confidential, and General Organization for Social Insurance
• Experienced in application development and deployment in Contact Center Management, Health Care, Financial Services, Communications/Media, Banking and Financial Services industries
• Over 8 years of experience in deploying Siebel CRM solutions using Siebel Field Service and Sales 8.1.1.6, Siebel Call Center 7.7, Siebel Financial Services 7.8.2, Siebel eCommunications 6.3/7.7
• Strong experience in customizing Siebel Applications using Siebel Tools 6.3/7.7/7.8/8.1, eScript
• Specialized in Siebel Workflows, Siebel Assignment Manager, Siebel SmartScripts, Siebel EAI, EIM
• Expertise in Siebel Application performance tuning, Redesign implementations
• Possess thorough understanding of Siebel CRM, Siebel Architecture, Siebel Data model, developing and deploying methodology for Siebel eBusiness Applications
• 3 years of experience in analysis, design and development of J2EE applications in MVC architecture design pattern, using JSP, Servlet and EJB, Java Script, XML, HTML
• Strong experience in articulating requirements, preparing design documents, process flow diagrams, system documents
• Experienced in preparing test plans, test cases, test strategies, and performing Unit testing, System testing, Regression testing, and load testing
• Strong team skills in executing and delivery of the projects in onsite/offshore methodology

TECHNICAL SKILLS:

Siebel Applications: Field Service 8.1, Call Center 7.7, Financial Services 7.8, eCommunications 6.3/7.7

Siebel Development Tools: Siebel Tools 6.3/7.0/7.7/7.8/8.1

Siebel Technologies: Siebel eScript, Siebel VB, Siebel Work Flows, EAI, EIM, SmartScripts, Siebel Assignment Manager

Web Technologies: HTML, JSP, Servlet, EJB and XML

Programming Languages: Java, Java Script, C

Application Servers: Weblogic Server (5.x, 6.x, 7.x), JRun 3.0, Apache Tomcat 5.0

J2EE IDEs: Visual Caf 4.5.1, JBuilder 6.0, ANT Build Tool

Databases: Oracle 8i/9i/10g, DB2, SQL Server

Database Tools: TOAD 7.2, Oracle SQL Developer 1.0, PL/SQL Developer 7.0

Data Quality Tools: Firstlogic Global Data Quality Link 2.11, Firstlogic Connector

GUI Design & Modeling Tools: Dreamweaver Ultradev 4.0 & Rational Rose Enterprise Edition 2000

Configuration Mgmnt Tools: Microsoft Visual Source Safe 6.0, Rational Clear Case 4.1

Testing Tools: Mercury Test Director 7.x, Mercury LoadRunner 8.1

Problem Mgmnt Tools: Vantive

Systems Monitoring Tools: Mercury Site Scope 7.9

Operating Systems & Tools: Windows 95/98/NT/2000/XP/7, UNIX, MS Office 2000/2007

MS Office Tools: Word, Excel, Visio 2003

PROFESSIONAL EXPERIENCE:

Confidential, King of Prussia, PA

Sr Siebel Consultant/Developer Analyst

Responsibilities:

• Analyzed requirements, Process Flows, data dictionaries for Approvals, Service Requests, Dashboard Appointments, Contracts, Contract Line Items, Sales Orders, Proposals, and Acknowledgement Letters, Asset Management, Opportunity Products, Errors, Escalations views, Account Partner Reps Assignment and other functionality of Client Engagement Portal Application
• Designed and developed solutions using Siebel out of the box functionality and features
• Developed and Configured Siebel Objects: Screens, Views, Applets, Business Objects, Business Components, Business Services, Virtual Business Components, Links, MVLs, Joins, User Properties
• Developed EBCs, and respective Screens/Views for the identified functional areas
• Designed, developed solutions for Complex requirements on Service Requests using State Model, Activity Plan, Activity Template based Auto Activity Creation for SR Status transitions, Approvals, Waivers, Claims, and Retentions
• Designed and developed solution for Complex requirements on Proposal Acknowledgement Letters using VBCs, Workflows, Outbound Communication Manager Methods, Communication templates, eScript functions on Business Services
• Designed and developed Yellowbook “Asset Management” functionality using Siebel Workflows, Business Services, Communication Templates, all other Siebel Objects for Asset Management UI
• Developed/Modified Email Response based Workflows for Opportunity creation
• Designed and developed solution for Opportunity Assignment to Account Primary using Dynamic Candidate Assignment Concept, Interactive Assignment, Batch and Dynamic Assignments
• Designed and developed solution for Account-Partner Rep assignments using the Dynamic Candidates, Batch and Dynamic Assignments
• Developed solutions using Activity Templates, Simple and Advanced Communication Templates, Solutions setup on Communications, Solutions, Activity Templates Admin views
• Developed several functions on Business Services, Siebel Objects, Object level events using eScript
• Triggered functions using eScript, Workflows, Workflow Simulator, Business Service Simulator, and Configuration approach using User Properties on Siebel Objects
• Researching, troubleshooting, debugging issues with Activity Templates, Communication Templates, Workflow and Business Service Simulation and eScript Functions debugging using Tools
• Deploying and Monitoring and debugging Workflows using Business Process Admin views
• Siebel Tools, Client Base Installation, Patch and Fix Pack Installation, and troubleshooting issues with Patch installations, OS and Virtual Machine level issues
• Prepared Test Data, Unit tested developed code and components using Simulators in Siebel Tools, Developer and Web Clients, and SOAP UI tool
• Participated in Requirements review and Design Discussions, Daily Standup Meetings, Project Progress Review Meetings

Environment: Siebel Application: Siebel Field Service and Sales 8.1.1.6 Development Tools: Siebel Tools 8.1.1.6 Scripting Languages: Siebel eScript Database and Database Tools: Oracle 10g, SQL Developer Operating System: Windows 7 Remote Access Tools: Juniper NetConnect VPN, VMware View Client Simulators and Test tools: SOAP UI Tool MS Office Tools: Word, Excel, Visio 2003

Confidential

Sr Siebel Consultant

Responsibilities:

• Gathered, analyzed requirements from Clients and proposed Cost effective, optimal Solutions for their various business scenarios
• Prepared SmartScript Process Flow diagrams and Design documents
• Designed and developed Siebel SmartScripts for Culligan Call Center Agents
• Created and customized the SmartScript Objects: Scripts, Pages, Questions, and Answers
• Developed Common Functions in custom Business Services for all Culligan SmartScripts
• Developed event level script for Scripts and Questions using eScript
• Created new Custom Columns, Fields, BCs, Applets, Pick Applets, MVG Applets
• Designed and developed components for Culligan email notifications
• Developed EBCs and utilized distributed join concepts to implement cleint specific requirements
• Studied and Analyzed underlying Applets, BCs, existing SmartScripts
• Redesigned, restructured the existing code and SmartScript for better maintainability
• Defined, developed Performance tuning approach for different application instances
• Implemented Performance tuning guidelines for eScript functions behind the existing SmartScripts
• Developed SQL queries, Procedures for Data storage verification, and data cleansing using Oracle PL/SQL Developer
• Performed Server Administration, Application Administration, Repository Migration, and developer database extracts
• Troubleshoot real-time reported incidents with Siebel Application in End User PCs
• Administer, Monitor and Support Siebel Calendar Functionality and SSSE with real-time user support
• Research issues reported for XML based integrations implemented using Workflows, Integration Components, Business Services
• POC for Data Quality implementation for Culligan using FirstLogic GDQ Link, and Firstlogic Connector
• Developed EIM Job to load non-sales employees into Siebel using scheduled Batch Job
• Regression testing of functionality for various Windows update releases, Siebel patch releases

Environment: Siebel Application: Siebel Call Center 7.7.2.12 Development Tools: Siebel Tools 7.7.2.12 Scripting Languages: Siebel eScript Data Quality Tools: Firstlogic Global Data Quality Link 2.11, Firstlogic Connector Database and Database Tools: Oracle 9i, PL/SQL Developer 7.0.3 Operating System: Windows XP MS Office Tools: Word, Excel, Visio 2003

Confidential, Franklin, MA

Sr Siebel Consultant

Responsibilities:

• Performance Tuning of Snapshot views
• Study and Analysis of underlying Applets, BCs, Applet level scripts and the links of Accounts, Contacts, Activities, Attachments, Notes, Opportunities, Account Products entities
• Identifying the MVLs, Joins, scripts, fields causing the performance issues
• Developed a new UI design for the Prospects/Clients Snapshot view
• Analyzing the SQL spool files and log files for the potential SQLs to tune the business layer objects
• Comparison of Vanilla and Cloned BCs for inactivating the unused MVLs, Joins and Fields
• Developed SQLs on the Repository tables to generate tracking sheets of Applet level s, BC and Business Service level s of the BCs to be tuned
• Impact analysis of the identified performance tuning tasks and detailed design of the configuration
• Prepared Test data and Unit tested the configured components
• Creating developer database extracts and resolving the issues with local DB initialization
• Provided support for VBC and XML Gateway based interface with external Java application

Environment: Siebel Application: Siebel Call Center 7.7.2 Development Tools: Siebel Tools 7.7.2 Scripting Languages: Siebel eScript Database and Database Tools: IBM DB2 8.0, Toad for DB2 2.0 Operating System: Windows XP, UNIX

Confidential

Sr Siebel Consultant / Lead Developer

Responsibilities:

• Participated in the requirement analysis and design discussions of PG Phase II and Plan Design Rewrite and prepared screen mockups and design documents
• Implemented new business rules for RSU users in Activities Screen, eScripts in the Applets and BCs, new statuses in the picklists
• Designed and developed components for Performance Guarantee, Sub Accounts, PG Metric template administration, Notes functionality
• Customized Applets, Pick Applets, MVG Applets, Business Components, Picklists, links, MVLs, Joins
• Configured the extension of table columns, intersection table relationships in the data objects layer
• Configured ‘Go To’ buttons and relevant script validations for Accounts and Opportunities
• Implemented macros in word document Form Changes for RSU group
• Developed custom validations in Applet and Business component level events using Siebel eScript
• Redesigned and implemented new changes in Siebel 7.8 for Product Administration components
• Implemented the new Business Object and Business components for Product Administration
• Conducted impact analysis and implemented the changes in the Product administration components viz links, MVLs and in the UI layer and related s in the eScripts
• Study and analysis of the iSell interfaces for EPM and UPM systems
• Resolved defects in the EPM - iSell interface working on the workflow process properties
• Developed custom Business Services to implement new business rules and improve error handling
• Prepared and executed the System Test Scripts and Regression Test Scripts
• Provided Tier 3 Technical Production Support for the trouble tickets
• Performed Application Administration for Organizations, Divisions, Users, Employees, Positions, Responsibilities, List of Values
• Developed SQL queries for Periodic Extract Reports per Production Support Extracts Calendar
• Defined, Established Process, Roles & Responsibilities for iSell Production Support Team
• Trained in CIGNA Problem Management and adopted Vantive Tool for iSell Production Support
• Prepared Production Support Run Book, iSell Application Software Infrastructure and Inventory document, iSell Application Overview, System Manual, Use cases, Detail Design Documents, Project Induction Manual and KT Plan
• Weekly Status Review meetings with various stake holders
• Migrated SRFs across different environments and managed developer mobile clients
• Monitored State Models, Workflow Processes in different environments
• Coordinated with Siebel Support Web on Siebel support tickets

Environment: Siebel Application: Siebel Financial Services 7.8.2 / 8.0 Development Tools: Siebel Tools 7.8.2 / 8.0 Scripting Languages: Siebel eScript Database and Database Tools: Oracle 10g, Oracle SQL Developer 1.0, TOAD Testing Tools: Mercury Test Director 8.0 Problem Management Tools: Vantive Operating System: Windows XP MS Office Tools: Word, Excel, Visio

Confidential, New York, NY

Siebel Developer/Analyst

Responsibilities:

• Setup Siebel 7.8 local environment
• Understand the impact of upgrade on Workflows, Interfaces, Business Services Scripts
• Pre-upgrade preparation activities with interfaces and workflows
• Configured the upgrade impacted workflows and interfaces
• Post upgrade development and resolving trouble tickets
• Enable / Disable the new features viz., suppress Tool bar items, Applet menu items, button controls provided in Siebel 7.8 based on the business requirements
• Implemented the performance tuning guidelines at Applet level and BC level properties and scripts
• Configuring Pick Applets, MVG Applets and Shuttle Applets
• Configuring UI level changes in Applets Fields, List Columns, label Styles and alignments, runtime controls, picklists, Screen View Hierarchy
• Configuring Applets, MVGs for ‘CUT Address’ BC changes
• Implemented Application Administration Changes related to LOVs, PDQs, Views
• Study and define an approach to use SARM for WebStation application
• Enable the Siebel Test Automation in different environments
• Prepare Unit Test and System Test Plan and Strategy concept specific to Siebel upgrade project
• Coordinate and manage Defect tracking and build roll out to AXA QA team
• Understand the WebStation performance Requirements
• Study and analysis of the functional Scenarios for Load Testing
• Understand the WebStation Application Environments and their topology
• Preparing the pre-requisite test data sheet for different load testing scenarios

Environment: Siebel Application: Siebel Financial Services 7.0.5/7.8.2 Development Tools: Siebel Tools 7.8.2 Scripting Languages: Siebel eScript Database: Oracle 10g Testing Tools: Mercury LoadRunner 8.1 (Analysis, Controller, Virtual User Generator), Mercury Test Director 8.0 System Monitoring Tools: Mercury Site Scope 7.9 Operating System: Windows 2000 Professional

Confidential, Tampa, FL

Lead Developer Analyst - Siebel CRM

Responsibilities:

• Gap Analysis and Functional mapping between InfoPro 6.3 and 7.7 applications for Quoting moduleQuote Configurators:
• Study and Analysis of VB source Code of CQI Application and Siebel VB scripts in Siebel 6.3 application for understanding the functionality and transaction flow
• Mapping the functionality in the Siebel 7.7 application
• Prepared transaction flow documents for Quote Configurators and Siemens Import
• Developed common frame work business Service for Quote ConfiguratorsSiemens Import:
• Prepared Detailed Design/Psuedo code for the import process
• Configured the workflow and developed Business Service in eScript
• Unit tested the import process and Integrated the source code in the development environment
• Demo to the development team on the Siemens import implementationSales Hierarchy Interface:
• Requirements discussions/Analysis/ high level design of Interface
• Preparation of Detailed Design for Work flow / Integration Objects / Psuedo code of the Business Service for Batch run of Employees & Positions update
• Development and unit testing of Interface
• Integrated source code in development environment performed dry run tests in different environments
• Status reporting to clients on a regular basis.
• Demos to the Verizon IT team on the progress of development work
• Conducted Knowledge Sharing Sessions on Quoting transaction flows and pricing logic
• Provided Tier 3 Technical level Production Support and participated in on-call rotations

Environment: Siebel Application: Siebel eCommunications 6.3/7.7 Development Tools: Siebel Tools 6.3/7.7 Scripting Languages: Siebel eScript, Siebel VB Database: SQL Server Middleware Tools: IBM MQ Series Testing Tools: Mercury Test Director 8.0 Configuration Management Tool: Microsoft Visual Source Safe 6.0 Operating System: Windows 2000 Professional MS Office Tools: Word, Excel, Visio

Confidential, Tampa, FL

Lead Developer Analyst - Siebel CRM

Responsibilities:

• Technical and functional lead for the implementation of project Activities
• Studied the existing configuration and Scripts in Siebel VB for maintenance quoting
• Impact analysis on the existing system for the implementation of Maintenance Part Numbers
• Prepared the low-level design and configured Screens, Views, List Applets, Form Applets, Pick Applets, Associate Applets, MVG Applets, BOs, BCs, Links, Joins, Scripts in eScript for the impacted items: Products, Quote and Agreements
• Developed Business Services using Siebel VB for Reprice, Calculation of Quote Total and Grid Calculations
• Configured Applets based on VBC for Reprice, Calculation of Quote Total and Grid Calculations
• Periodic presentations to the client team on the implementationAgreement Component item prices:
• Analyzed requirements and prepared low-level design documents
• Developed Siebel Business Service for applying factors
• Analyzed existing highly complex Siebel VB Code for ‘Calculate Quote Total’ functionality
• Prepared flow diagram and functional document for Maintenance Quote Pricing logic
• Analysis and development of ‘Enterprise Advance Revenue’ initiative in Opportunities
• Provided Impact Analysis for the Incident Reports and configured the Applet level, BC level changes
• Participated in design discussions on using Assignment Manager for Orders processing
• Prepared Unit Test Specifications and Coordinated QA reviews for defect fixes and enhancements.
• Status reporting to onsite coordinator and clients on a regular basis.
• the new project inductees on the functional/technical and process aspects of the project
• Provided Tier 3 Technical level Production Support and participated in on-call rotations

Environment: Siebel Application: Siebel eCommunications 6.3 Development Tools: Siebel Tools 6.3 Scripting Languages: Siebel VB Database: IBM DB2 7.2 EAI Tools: IBM MQ Series Testing Tools: Test Director 7.2 Configuration Management Tool: Microsoft Visual Source Safe 6.0 MS Office Tools: Word, Excel, Visio Operating System: Windows NT/2000 Professional

Confidential, Charlotte, NC

J2EE Developer

Responsibilities:

• Setting up offshore environment for MAR/RPR Application
• Resolving connectivity/technical issues
• Involved in estimating the enhancements and defect fixing activities
• Carrying out defect fixing and enhancements for MAR/RPR
• Preparation of Unit Test Specifications
• Coordinating the QA reviews for the defect fixes and enhancements
• Ensuring process compliance for all the deliverables
• Coordinating with onsite coordinator on a regular basis regarding the project activities
• Status reporting to onsite coordinator on a weekly basis

Environment: Programming Language: Java Web Technologies: HTML, JSP, JavaScript, Servlet and EJB Application Server: Bea Weblogic Server 7.0 IDE: ANT Build Tool Database and Database Tools: Oracle 8i, TOAD 7.2 Configuration Management Tool: Microsoft Visual Source Safe 6.0 Operating System: Windows NT/2000 Professional

Confidential, Charlotte, NC

Project Leader - Offshore/J2EE Developer

Responsibilities:

• Setting up offshore development environment
• Interacting with the users of the system for gathering the requirements
• Planning activities at offshore
• Carrying out development for Risk Management module
• Unit testing of developed components to improve and ensure quality of the components
• Conducting peer reviews for the developed components
• Coordinating with onsite coordinator on a regular basis regarding the project activities
• Status reporting to onsite coordinator on a weekly basis
• Project Progress reporting to the Management
• Setup GPAT offshore environment and resolved connectivity/technical issues
• Planning, coordinating project activities and Project Audits at offshore.
• Carrying out defect fixing and enhancement activities.
• Conducting and coordinating the QA reviews for the defect fixes and enhancements.
• Coordinating with onsite coordinator on a regular basis regarding the project activities.
• Status reporting to onsite coordinator on a weekly basis.
• Project Progress reporting to the Management in Project Management Reviews.

Environment: Programming Language: Java Web Technologies: HTML, JSP, JavaScript, Servlet, EJB Web Server: JRun 3.0 Application Server: Borland Enterprise Server IDE: JBuilder 6.0 Database and Database Tools: Oracle 8i, TOAD 7.2 Configuration Management Tool: Rational Clear Case 4.1, Microsoft Visual Source Safe 6.0 Operating System: Windows NT/2000 Professional

Confidential

J2EE Developer

Responsibilities:

• Prepared Sequence Diagrams and Class diagrams based on the Use Cases
• Developed prototype for Financial Accounting & Budget modules using HTML/JSP screens
• Installed and setup environment of Weblogic Server 6.1 and Visual Café 4.5.1
• Prepared Low Level Design and user manuals for Financial Accounting & Budget modules
• Developed technical components using JSP, Servlet and EJB for Invoices, Recurring Receivables and Recurring Payables functionality of Financial Accounting
• Developed front-end validations using Java Script
• Implemented Workflows for Invoices, Recurring Receivables and Recurring Payables
• Unit tested developed components of Financial Accounting module
• Designed process flow for online batch run for all the components of Financial Accounting module.
• Implemented interfaces between Financial Accounting and Investments modules

Environment: Programming Language: Java Web Technologies: HTML, JSP, JavaScript, Servlet, EJB GUI Designing Tool: Dreamweaver Ultradev 4.0 Modeling Tool: Rational Rose Enterprise Edition 2000 Application Server: Bea Weblogic Server (5.x, 6.x) IDE: Web Gain Visual Caf 4.5.1 Database: Oracle 8i Configuration Management Tool: Microsoft Visual Source Safe 6.0 Operating System: Windows 95/98/NT/2000 Professional