EXPERIENCE SUMMARY:

• Siebel CRM Technical/Functional Consultant with 18 years of IT experience, including 16 years on Siebel Enterprise Applications as a Technical/Functional Lead Consultant on multiple engagements. Involved in the design, development, deployment, and administration and production support of Siebel Financial Services, Siebel Public Sector, Siebel HTIM, Call Center, Sales, Marketing and Field Service solutions. Other experience includes a strong background in databases, C++, Visual Basic, SQL Server and Internet Technologies.
• Worked as a Solution Architect, Technical Lead for 6 years, leading multiple CRM projects from JAD sessions, project management, scope management, design, development, testing standpoint and providing production support.
• Providing Technical/Functional consultancy on CRM systems since 16 years in different spanning various roles such as a Solution Architect, Technical Lead, Senior Siebel Developer, Siebel Configurator, and Administrator.
• Over 16 years of progressive CRM consulting experience on various CRM platforms like Oracle Siebel CRM, Salesforce on various platforms such as Windows, Solaris, Linux.
• Experienced in working closely with business teams, analysis team, production support teams in providing the CRM solutions, scoping the work and delivering code.
• Extensive experience in leading technical teams, handling offshore teams, monitoring project development activities on a day to day basis.
• Experienced in handling and resolving production support issues for a CRM Call Center, Sales and Marketing Applications.
• Involved in multiple Siebel upgrade projects, Siebel HI to Open UI migration, from version 7.5.3 to 8.0.0.1 / 8.0.0.6 with Siebel Financial Services Vertical and upgrade from Siebel 2000 to Siebel 7.5.3.
• Extensive experience in building web services and integration of Siebel applications with other third party applications, databases and connectors using various mechanisms.
• Involved in end - end implementations of Siebel Financial Services, Siebel Call Center, CRM Sales Force Automation, Siebel Public Sector, Siebel PRM, Siebel HTIM, Siebel eService, Siebel eCommunications, and Field Service solutions at multiple locations. Excellent knowledge in configuring healthcare applications.
• Extensive experience in Configuration using Siebel Tools, eScript, Open UI, Siebel VB, Siebel EAI, Workflow Manager, Assignment Manager, Enterprise Integration Manager, Database Extension Designer, Siebel Data Model, Siebel Installation, Siebel Upgrade, Performance Tuning, Siebel Remote, Haley rules engine, Oracle Policy Automation, BI.
• Involved in development of Client/Server, Three tiers based systems, middleware and distributed components using COM/DCOM, C++ and Visual Basic, SQL Server.
• Experienced in database design and application development using Visual Basic 6.0/5.0, SQL, and PL/SQL Programmer in multiple engagements.
• Experienced and certified in SQL Server development and administration.
• Excellent Interpersonal skills and have consistently demonstrated the ability to work well and excel in a team environment.

TECHNICAL SKILLS:

CRM Siebel: Open UI/8.2.2/8.1.1.11/8.1.1.7/8.0.0.6, Siebel 7.8.2, 7.5.3, 7.0.3, 2000, 99.5, Siebel Financial Services, Siebel PRM, Siebel HTIM, Siebel Sales, Call Center, eCommunications, Field Service, eScript, Siebel VB, EAI, Workflow Manager, Assignment Manager, EIM, Siebel Report Server, Haley Rules Engine, OPA.

Middle Ware: COM/DCOM, IBM MQ Series, JMS

Languages: C, C++, Java, SQL, PL/SQL, VBScript, JavaScript

Front End Visual Basic: 6.0/5.0, D2k

Databases: MS SQL Server 2014/2010/2005/2000/7.0/6.5, MS AccessOracle: 11g/11i/10g/8i/7.3, DB2 V8/9, Sybase X

ToolsMS: Visual SourceSafe, XML, MS Project, Visio, Princeton Softech, Active Template Library, ADO, Roguewave

Operating Systems: Windows 7,XP, 2000, Win NT 4.0, Win 95/98, UNIX, AIX

Web Technologies: HTML, Active X, ASP, IIS

PROFESSIONAL EXPERIENCE

Confidential

Roles and Responsibilities:

• Involved in design, estimating the scope, development for different projects based on the release schedule.
• Working closely with Business team, Analysis team in understanding requirements and providing solutions, scoping the work and delivering the code in timely fashion.
• Involved in extensive development, configuration, coding and production support using Siebel 8.1.1.7 Tools, Client for Siebel Financial Services applications.
• Responsible for designing projects and code delivery based on the requirements.
• Responsible for the creation of new Applets, Business Components, Business Objects, Views, Screens based on the business requirements.
• Worked extensively on the Database extension designer to create custom extension columns based on the requirements.
• Involved in design and development of Outbound web services to send real time new activity and updates to Event Management application for Contacts and Accounts.
• Involved in development of Integration objects, synchronous Outbound Web services to send event management updates real time collected from the Siebel application to external application and receiving response identifiers in return.
• Involved in design and development of Inbound web services in Siebel to send contact and account data real time to Outlook, upon setup of a meeting in Outlook, creating activities in Siebel for those entities.
• Involved in design and development of Outbound Web services to pull the contact entitlement, classification and tier data from the legacy systems and displaying the data real time in Siebel Applications.
• Involved in development of multiple application views using EBC’s (external business components) to show groups, research data for accounts and contacts.
• Involved in production support of monitoring and updating activities data for contacts.
• Migration of the Configuration changes from the Development to Testing and Training environments.
• Working closely with testing team to handle JIRA tickets, open issues and resolving them.

Environment: Siebel Tools, Client 8.1.1.7, vbscript, Workflow Manager, Assignment Manager, Soap UI, EAI, SQL Server 2014, XML, MS Visual SourceSafe, EBC, VBC, Windows XP, Visio, Sharepoint.

Confidential

Roles and Responsibilities:

• Involved in design, estimating the scope, development for different projects based on the release schedule.
• Working closely with Business team, Analysis team in understanding requirements and providing solutions, scoping the work and delivering the code in timely fashion.
• Involved in extensive development, configuration, coding and production support using Siebel 8.1.1.11 Tools, Client for Siebel Financial Services and Siebel Marketing applications.
• Involved in migration of Siebel HI client to Open UI Client using 8.1.1.11, IP 2013 and other incremental patch sets.
• Involved with development of Siebel application based on Open UI framework with IP 2013, CSS, java script, jquery and HTML 5.
• Involved in bug fixes during upgrade/migration from Siebel HI to Open UI and modifying required .js files, presentation model and physical renderer files to achieve desired functionality.
• Involved in design and development of Outbound Web services to display the privacy preferences data time from the legacy CCDB systems real time in Siebel Applications.
• Involved in development and design of Salesforce CRM for Contacts Management and integration between Siebel and Salesforce for real time integration.
• Responsible for development of Outbound Web services/ Business Services to write data real time to the privacy preferences database gathered from the Siebel.
• Involved in development of multiple views using EBC’s to show Small Business, Premium Accounts & Clients related data with in Siebel from external databases.
• Involved in development of Integration objects, synchronous Outbound Web services to send prospect data real time collected from the Siebel application to external application and receiving response identifiers in return.
• Involved in development of outbound web services to call an Enterprise profile web service upon creation of prospects and update the prospect data with the response xml.
• Working closely with Testing team to handle QC’s, open issues and resolving them.

Environment: Siebel Tools, Client 8.1.1.11, Patch set 4/8, Workflow Manager, Assignment Manager, Soap UI, EAI, SQL Server 2010, XML, MS Visual SourceSafe, EBC, VBC, Windows XP, Visio, Sharepoint.

Confidential

Roles and Responsibilities:

• Involved in design, estimating the scope, development for different projects based on the release schedule.
• Working closely with Business team, Analysis team in understanding requirements and providing solutions, scoping the work and delivering the code in timely fashion.
• Involved in extensive development, configuration and coding using Siebel 8.2.2 Tools for a Siebel application with Public Sector Vertical.
• Involved in design and development of Enterprise case management Siebel public sector application for City of New York.
• Involved in gathering requirements, prototyping and designing the Siebel solution for Case management for different modules like Incident reporting, Inspections, Cases, Service Requests, Households, activities, Admissions and court orders.
• Involved in prototyping the integration, setup and policy modeling rules of Oracle policy automation.
• Involved in analyzing the legacy systems for conversion and integration of systems into Siebel.
• Involved in scoping the project and providing the estimates for project management.
• Involved in creation of customizing the User Interface, Business layer and data layer to provide the functionality to support different modules like Incident management, Case Management, Inspections, Document management, Release and Housing management.
• Worked extensively on the Database extension designer to create custom extension columns based on the requirements.
• Worked extensively on Appointment booking engine to allow users to schedule inspections.
• Working with IT testing team and Business users to help them understand the new functionalities being rolled out and bug fixes.

Environment: Siebel Tools, Siebel Client 8.2.2, eScript, Workflow Manager, Siebel EAI, Oracle 11g, Toad, PVCS.

Confidential

Roles and Responsibilities:

• Involved in extensive development, configuration and coding using Siebel 8.0.0.5 Tools for a Siebel call center and marketing applications with HTIM Vertical.
• Responsible for design and development of Inbound Web services, Integration objects to send the Consumer data, Product, Pricing and Order information from the Siebel Call Center application to a portal application real time.
• Involved in setting of product, product class, and product catalog and price list information using product configurator.
• Involved in development of Workflows, Integration objects to create and update any consumer data or product based on Outbound Web services.
• Involved in creation of workflow policies, groups to automate the outbound email process.
• Involved in creation of Server Components like workflow process manager, Workflow monitoring agents, custom HTIM Application object managers for US, UK consumers.
• Responsible for setting up a DR environment replicating the existing production setup with multiple Siebel Servers, Web Servers and a Gateway server.
• Involved in installation and configuration of multiple Siebel Servers, Siebel Gateway Server, and Siebel Enterprise server. Setting up load balancing of multiple application servers.
• Involved in development and supporting marketing application by enhancing the functionality of campaigns, segments lists, campaign source code and landing pages.
• Involved in BI administration to support and monitor the marketing applications campaigns being launched periodically.
• Involved in supporting and fixing the issues during the database upgrade from oracle 10g to 11g.
• Responsible for design and development of building a D and B module in Siebel Sales application to support creating and importing prospect data.
• Involved in building functionality to support importing of data from tab delimited text files into D n B tables to store and update prospect data.
• Involved in development of functionality to support the promotion of prospect, contacts data from the prospect stage to Account stage.
• Involved in creation of customizing the applets to provide the functionality to create opportunities and quotes for the new KY users that were being on boarded to Siebel CRM.
• Worked extensively on the Database extension designer to create custom extension columns based on the requirements.
• Involved in export and import of Repositories, SRF to migrate the configuration changes from the Development to Testing and production environments.
• Involved in Systems Integration testing based on the development done and in coordination with the external portal team.

Environment: Siebel HTIM 8.0.0.5, Siebel Marketing, eScript, EAI, Oracle 10g/11g Toad, XML, Soap UI, MS Visual SourceSafe, Unix, AiX, Sun solaris, Visio, Secure CRT, Putty, Win scp.

Confidential City of New York

Roles and Responsibilities:

• Involved in extensive development, configuration and coding using Siebel 8.0.0.5 Tools for a Siebel application with Partner relations Manager Vertical.
• Responsible for design, development of Inbound Web services to send the Channel Partner, Applications, Projects, Budget data from Siebel to a portal application real time.
• Responsible for development of Inbound Web Services to pull data from the JMS MQ and update the Siebel Business/Integration Objects real time.
• Involved in creation of JMS Server Components, Data handling subsystems to configure the MQ queues to pull the data from JMS.
• Worked on workflows to pull the data real time from JMS MQ and update the Siebel business objects.
• Involved in development of Workflows, Integration objects to create/update the Final Report, Projects, Contacts, attachments, etc data pulled from the MQ Series.
• Development of Integration objects, Web services, workflows to send application, report status real time from CRM to external application based on different web service calls.
• Responsible for designing the integration project and code delivery based on the requirements.
• Extensively worked on Siebel Integration objects and Integration components and generated XSD’s and co-ordinate with external teams for integration field mappings.
• Worked on the Database extension designer to create custom extension columns and custom extension tables based on the requirements.
• Involved in migration of the Configuration changes from the Development to Testing environments.
• Involved in Systems Integration testing based on the development done and in coordination with the external portal team.

Environment: Siebel Tools, Client 8.0.0.5, eScript, Workflow Manager, Siebel EAI, Oracle 10g, Toad, XML, Soap UI, MS Visual SourceSafe, Windows XP, Windows Server 2003, Visio, RTDS.

Confidential

Roles and Responsibilities:

• Involved in extensive development, configuration and coding using Siebel 7.8.2.13 Tools for a Siebel Call Center and Siebel Marketing application with Financial Services Vertical.
• Involved in design and development of Outbound Web services to display privacy preferences data from the legacy CCDB systems in Siebel.
• Responsible for development of Outbound Web services/ Business Services to write data real time to the privacy preferences database gathered from the Siebel Applications.
• Involved in design and development of outbound Web services to support the SSL authentication for web services.
• Involved in development of Integration objects, Web services to send prospect data real time collected from the Siebel application to external application.
• Worked extensively on creation and modification of Web Templates to get the desired user interface based on the business requirements.
• Involved in integrating the Siebel outbound web services with Merrill integration framework to call windows API’s for supporting Wealth Management Applications.
• Worked extensively on the Database extension designer to create custom extension columns based on the requirements.
• Migration of the Configuration changes from the Development to Testing and Training environments.
• Involved in writing Unit Test cases, Systems Integration testing based on the development done and in coordination with business users.

Environment: Siebel Tools, Client 7.8.2.6, 7.8.2.13, vbscript, Workflow Manager, Assignment Manager, Soap UI, EAI, SQL Server 2005, XML, MS Visual SourceSafe, EBC, VBC, Windows XP, Visio.

Confidential

Responsibilities:

• Worked as a Technical Lead in leading a team based in off shore and involved in monitoring their development activities.
• Worked as Technical Lead leading multiple project from estimates, requirements, analysis, design, development, testing standpoint and providing production support.
• Responsible for designing projects and code delivery based on the requirements.
• Involved in extensive development, configuration and coding using Siebel 8.0.0.3/7.5.3 Tools for a Siebel Call Center Application with Financial Services Vertical.
• Involved in development of Inbound Web services to provide real time data from the Siebel database to an external application.
• Involved in development of Outbound Web services to pull data from the legacy systems and displaying the data in Siebel Applications.
• Involved in development of Form Redirect, iFrame based Symbolic URL’s to integrate Siebel with other third party applications.
• Experienced in Email Integration module in the Siebel Call center applications to send out emails externally when subscribers opt out or opt in for Paperless EOB enrollment.
• Built External Business Components (EBC’s) and Virtual Business Components (VBC’s) to write the data real time into a mainframe system based on DB2.
• Experienced in Archive and Purge of data entities like Service Request, Activities, attachments from the database using PST, a third party application external to Siebel.
• Responsible for developing and providing support for multiple Assignment manager rules based on the business requirements to assign SR’s to CSR’s.
• Developed and provided support for multiple Workflow rules/processes on Service Request and Activities based on the business requirements.
• Involved in integration of multiple transactions in Siebel application with mainframe applications using Workflow, eScript and XML.
• Worked extensively on Web Templates to get the desired user interface based on the business requirements.
• Involved in an Upgrade project from Siebel 7.5.3 to Siebel 8.0.0.3
• Responsible for UI, debugging and testing all the Siebel eScript coding, Assignment rules, Workflow processes during the upgrade process.
• Involved in installation the Siebel Enterprise Server, Siebel Gateway Server and Siebel Database Server for the Development and Testing Environments.
• Responsible for the extensive customization of the Siebel Financial Services Application using Siebel Tools using HIPAA guidelines.
• Migration of the Configuration changes from the Development to Test and from Test to Production Environments.

Environment: Siebel 8.0.0.1/8.0.0.3, Siebel Financial Services 7.5.3, eScript, Siebel VB, SQL Server 2000/2005, DB2, XML, SOAP, MS Visual SourceSafe, Windows NT/2000/XP, MS Project, Visio.

Confidential

Roles and Responsibilities:

• Involved in extensive development, configuration and coding using Siebel 7.5.3 Tools for a Siebel Call Center Application.
• Involved in the creation and modification of Applets, Business Components, Business Objects, Views, Screens based on the business requirements.
• Involved in creation and modification of joins, links, pick applets, pick lists, MVG’s.
• Worked extensively on Database extension designer, Siebel VB, created subroutines and function modules for specific client requirements.
• Worked on real time integration (Virtual Business Components) to integrate Siebel with legacy system to display data in Siebel application using Siebel EAI.
• Worked extensively on Web Templates to get the desired user interface based on the business requirements.
• Responsible for developing, maintaining multiple Assignment manager rules in development, production environments based on the business requirements.
• Developed multiple Workflow rules/processes on Service Request and Activities based on the business requirements.
• Involved in continuous performance tuning of the Siebel Call Center Application.
• Involved in an upgrade project from Siebel 2000 to Siebel 7.5.2
• Responsible for configuration/UI, converting, debugging and testing of all the Siebel vb script coding to Siebel eScript during the upgrade process.
• Installed the Siebel Enterprise Server, Siebel Gateway Server and Siebel Database Server for the Development and Testing Environments.
• Migration of the Configuration changes from the Development to Test and from Test to Production Environments.

Environment: Siebel Financial 7.5.3, Siebel 7.0.3, Siebel 6.0.23, eScript, Siebel VB, EIM, SQL Server 7.0/2000, XML, LDAP, SQL Queries, MS Visual SourceSafe, iDataStore, Windows NT/2000/XP.

Confidential

Siebel Configurator/Developer

Responsibilities:

• As a consultant was involved in Siebel implementations of eCommunications Call center, Field Service, Siebel Sales for different clients.
• Involved in the analysis and design phase based on the requirements for the call center application and sales application.
• Responsible for the configuration of new Applets, Business Components, Business Objects, Views and Screens based on the business requirements.
• Worked on Siebel VB, created subroutines and function modules for specific client requirements.
• Configured the Accounts, Opportunities, Assets, Contacts, and Service Requests management modules.
• Worked extensively on the Siebel Database to create extension columns to accommodate data based on the user requirements.
• Responsible for creation of reports using Actuate Work Bench based on requirements.
• Involved in installation of the Siebel Enterprise Server, Siebel Application Server, Siebel Data Server and Siebel Remote for the Development environment.
• Involved in data migration of Accounts, Contacts, Positions, Service Requests, Assets, Opportunities and seed data using Siebel EIM Import.
• Involved in interfacing with the production support team to migrate the changes from development to production.
• Involved in migrating the development changes in to Testing, Production environment using dev2prod utility.

Environment: Siebel 6.3 eCommunications call center, Siebel Sales 2000, Siebel Field Service 2000, Siebel Tools 6.3, Siebel tools 6.0.1, Siebel VB, EIM, Oracle 8i, SQL Server 7.0, Windows NT/2000.

Confidential

Software Engineer/Senior Software Engineer

Responsibilities:

• Involved in the Design, Development, and Management of SQL databases.
• Involved in development of Business logic layer using C++ for three tier architecture applications using COM/DCOM technologies.
• Involved in application development using Visual Basic tools to customize form, views and screens.
• Coded Functionality for saving the data captured to the database using ADO.
• Attended training classes on COM/DCOM, IIS Server, and Microsoft Transaction Server.
• Performed complete maintenance of data and administration using SQL Server.
• Participated in testing and debugging system.
• Developed the stored procedures, triggers, functions for the backend using SQL and Pl/SQL.
• Delivered training in SQL-Server implementation and administration, Windows-NT, and Visual Basic

Environment: Visual Basic 5.0/6.0, SQL Server 6.5/7.0, ASP, Oracle 7.3/8i, ADO, Windows 95/NT, C, C++, COM/DCOM.