PROFILE

2000\\7\\7.7\\8.0 Siebel Certified Consultant, Siebel 7.0 Certified Business Analyst and Microsoft certified DBA with over ten years of experience in specific areas of SFA (Sales Force Automation), Siebel Call Center, Siebel eLifesciences (ePharma), and eAutomotive and Siebel eCommunications. Bobby also has two years of experience in implementation and utilization of SAP R/3 system for SD Module and trained in SAP CRM. Bobby Kapoor combines the advanced knowledge of business concepts like Supply Chain Management, Customer Relationship Management, Business Intelligence and dataware housing concepts. Familiar with various implementation methodologies like Rapid Application Deployment (RAD), Business Process Re-Engineering (BPR), and Business Process Simulation (BPS). Actively participated in Prototyping, Configuration, Customization, Documentation, User Training and Reporting phases.

CERTIFICATIONS

Siebel 8.0 Certified Consultant
Siebel 2000, 7 & 7.7 Certified Consultant
Siebel 7 certified Business Analyst
Siebel 2000 Customer Certified Consultant
Microsoft Certified DBA
Administering SQL Server 7.0
Design and Implementing Databases with Microsoft SQL Server 7.0
Designing and Implementing Data Warehouse with Microsoft SQL Server 7.0
Installing, Configuring and Administering Microsoft Windows 2000 Server

August 2009 to Present Siebel CRM
Confidential, (Toronto, Ontario)
Platform Siebel Specialist
Siebel Public Sector 8.1.1, Oracle 10g

• Participated in detailed design and applied the best practices for combination of healthcare and public sector verticals.
• Participated and documented configuration tasks for new screens, screen tab icons, views, applets, business components, table extensions and eScripting etc.
• Analyzed the requirements to implement with Siebel validation tools (business component user properties, applet user properties, state model, data validation tool and personalization rules etc) to reduce the Siebel scripting.
• Actively participated and prepared the detailed deployment plan for various environments.
• Troubleshooted production issues and fixed existing defects for subsequent phased migrations.

June 2008 to August 2009 Siebel CRM / Siebel portal / Oracle BI SME
Confidential, (North York, Ontario)
Platform Senior Software Engineer
Siebel Call Center 7.8, Oracle 9i, Oracle Discover, Hummingbird search 5.3

• Estimated and laid out the project plan for customer (eService) portal and Oracle BI solution projects in MS Project and worked with stakeholders and negotiated at various levels for approval.
• Organized workshops to gather the TAS (Technical Account Selling) requirements. Designed and configured the TAS module for radio frequency division.
• Installed and configured Siebel eService and Hummingbird search engine 5.3 with Siebel 7.8.2.9 version.
• Created and modified products using Product Configurator with complex business rules and also configured price lists in ePricer.
• Participated in design and development activities with heavy hands on configuration tasks developing new screens, views, applets, personalization rules, state model's, access control mechanism, quotes, orders and asset modules.
• Actively participated in testing and training of end users. Worked with super users to debug the application and provide new enhancements for better performance and usability of application.
• Designed and implemented the automated email generation using workflow manager and run time events.
• Organized workshops to gather sales and service requirements to extract the data for central decision support system (DSS) and Discoverer dataware house.

January 2008 to May 2008 Siebel SME / Capgemini
Confidential, (Chicago, IL)
Platform Infrastructure and Reporting Lead
Siebel Call Center 8.1, Linux SUSE 9, Oracle Http web server, Oracle 10g

• Designed the architecture and installed, configured and administered the development environment on Linux for onsite and offshore resources.
• Established the best practices for migration between environments for repository and non repository changes, designed and configured the initial organizational hierarchy.
• Created the questionnaire for requirement gathering for reports, also defined the final functional design template.
• Presented the team with OBI EE overview with aspects for functional capabilities and possible integration points between Siebel CRM and OBI EE.

October 2007 to December 2007 Business Intelligence SME/EagleCreek
Confidential, (White Plains, NY)
Platform OBI EE and BI Publisher
Oracle Business Intelligence 10.1.3.3.1 10g, Informatica 8.0, Solaris 10, Oracle 10g

• Designed and developed 4 Dashboards and 30 reports with executive summaries using column selector, view selector, narrative, ticker, pivot tables views etc.
• Established the best practices to design dashboards and reports for display and for downloads and printing purposes in pdf format and briefing book downloads.
• Designed the object and data level security requirements for Pernod Ricard.
• Installed, configured and integrated BI Publisher with OBI EE to deliver reports in rtf and excel formats.
• Reviewed, analyzed the log files and debugged rpd to improve the performance and recommended database changes.
• Researched the CSS style sheets and skins and presented the client with the options to change the GUI.

July2007 to Oct 2007 Business Intelligence SME/Capgemini
Confidential, (Stamford, Connecticut)
Platform OBI EE Service Analytics
Oracle Business Intelligence 10.1.3.2.1 10g, Oracle applications 7.9.2, Siebel Call Center 8.0

• Supervised and verified the installation and configuration of OBI EE server, OBI applications with service analytics component, Informatica and DAC servers.
• Installed and configured the integrated sandbox (Siebel CRM and OBI EE) environment with configured action links and reports displayed in applets in Siebel CRM action on home page, accounts and contacts screens. Developed custom screens, views, and applet, modified existing Business components and Business objects to accommodate the design for prototype.
• Prepared the questionnaires and facilitated the workshops to gather the requirements, analyzed the gathered attributes and measures and presented the gap analysis.
• Prototyped and presented 3 major reports, pulling the data from .mdb files, metadata development, created reports and dashboards to stakeholders.
• Prepared and finalized the requirements for sign off, finalize the metadata design, wire frame mockup design and prototyped dashboards for business user validation.
• Researched and prototyped Oracle BI publisher and various types of options for BI security layers.

May 2007 to June Sr. Consultant/Eaglecrk
Confidential, (Los Angeles, California)
Platform Web Portal Project
Siebel 7.8.2.4 eAutomotive, eDealer portal, Oracle 9.2.0.6

• Designed the server architecture to host around 500 portal and 100 internal users.
• Helped infrastructure team to build best practices for installation, designed the multi org implementation for dealers using partner relationship management (PRM), call center and eDealer portal.
• Organized initial requirement gathering sessions to gather the raw requirements for gap analysis and prepared the screen mockups.
• Designed and configured email integration and configured fax integration with Captaris Right Fax.

September 2006 to April 2007 Sr. Technical Lead/CNC Global
Confidential, (Toronto, Ontario)
Platform Ongoing Enhancement Project
Siebel 7.8.2.4 eCommunications, Oracle 9i, Informatica 7.2.2, Analytics 7.8.2.4

• Assisted participated in project planning, mainly in high level and detailed WBS (Work breakdown structure) estimation and resource planning.
• Modified existing product, pricing procedures for ongoing enhancements using product configurator. Defined and prototyped the procedure to retire the funnel products.
• Modified existing and introduced new agreements, defined new mappings and proposal templates for automated agreements and welcome letter for customers.
• Lead the team to implement newly acquired division under Bell Canada org chart. Designed and configured new set of screens, views, applets and extended tables, also provide the administration of newly created division, positions and responsibilities etc.
• Provided expertise for performance enhancement, seed data automation, bug fixes and fixing java files and web templates for 7.8.2.3 product configurator upgrade.
• Modified the EIM jobs to update the existing assets for modified products for MACD orders. Modified the logic PL\\SQL logic to add the newly added columns and reload the data.
• Developed the ADM (Application Deployment Manger) to migrate the seed data like Responsibilities and increased the out of the box character length limitation for views names from 50 to 100 to resolve the failures for longer view names.
• Resolved the action link issues from Siebel Analytics dashboards to Siebel CRM application.

March 2006 to September 2006 Siebel Solutions Architect/Capgemini
Confidential, (Mississauga, Ontario)
Platform Off Shore-Transition Project
Siebel 7.5.3, 7.7.2.4 and 7.8.2.0 eAutomotive, Oracle 9.2.0.4, Solaris 8, Siebel Analytics 7.7.1.4 and Informatica 6.1

• Responsible for strategizing, scheduling, facilitating the knowledge transfer sessions for 6 Siebel environments.
• Prepared detailed questionnaires to take the infrastructure, application and process related details to replicate the environments in Mississauga data center and to provide the uninterrupted pre-prod and production support
• Hands on experience installing and configuring all the Siebel environments including Siebel OLTP and Siebel OLAP environment. Prepared documentation for the back office staff to support and develop the environments.
• Lead the central team for knowledge transfer sessions with the incumbent vendors from UK, Australia, Thailand, US and Canada in their specific time zones.
• Installed and configured Siebel Analytics 7.7.1.4 integrated environment with Informatica 6.1. Configured connection pools for rpd file and maintained the repository and administration for Siebel analytics and informatica.
• Strategize and migrated the OLTP and OLAP environments including LOV values, templates for OLTP and Webcat, .rpd, NQSConfig.ini, dbfeature.ini, nqcluter.ini, XML config files, Custom Images and Messages for OLAP environments.
• Installed and configured Siebel application servers on UNIX servers (Solaris 8 & 9), document server on windows. Installed and configured fulcrum search engine, trillium and actuate reports servers on unix server.
• Designed the application and server administration strategy, adding new users, creating positions, responsibitlies, lov's, activating new columns for developers and trained transitioned to offshore consultants.
• Created Siebel Dashboard to demonstrate Siebel Dashboard capabilities and Configured analytics repository with logical dimensional modeling using Star Schema (Facts and Dimensions). Configured metadata by using Siebel Analytics Administration Tool.
• Reviewed existing informatica mappings using sq, aggregator, expression, lookup and filter transformations and suggested the changes for better performance.
• Using small set of data, populating the Siebel Data warehouse through ETL, modifying the ETL mappings.

September 2005 to March 2006 Sr. Consultant/Accenture
Confidential, (Ottawa, Ontario)
Platform Global Case Management System D2
Siebel 7.5.3.1 eGovernment, SQL Server 2000, Siebel data warehouse, Analytics and Informatica (ETL designer)

• Responsible for functional and technical design of 7 major custom objects.
• Heavy hands on configuration experience (including new Screens, Business components, Business Object, Vews, Applets, Pick Applets, MVG's, Links etc).
• Created all objects for bilingual support, English and French.
• Worked on technical specifications of Fins Validation to reduce the scripting load. Designed and prototyped pop the custom messages to make fields dynamically required and read only.
• Responsible for bug fixes and implemented Siebel Expert Services recommendations.

May 2005 to August 2005 Senior Business Analyst/Capgemini
Confidential, (Bridgewater, New Jersey)
Platform Clinical Trial Management System
Siebel 7.5.2 eClinical (CTMS)

• Responsible for tier 1-helpdesk operations with offshore facilities in Belgium, Mumbai India and Banglore India.
• Responsible for coordination and facilitation between these groups using technologies like messenger and VoIP.
• Responsible for rationalizing the business processes, document user feedback and gaps for future releases.
• Responsible for creating, updating and maintaining assignment rules (assignment manger) for assigning the leads to reps for batch processing quarterly.
• Responsible for updating the data using super admin screens, designing and running the EIM jobs to update the user data and provided application admin support to create new users, positions, list of values etc.
• Responsible for identifying and troubleshooting Siebel remote synchronization problems and Siebel to outlook synchronization.

November 2004 to May 2005 Senior Technical Lead/Imperial Oil (Exxon Mobil)
Confidential, (Toronto, Ontario)
Platform IOL 7.5 upgrade eOTC\\eBuyback
Siebel 7.5.8 eEnergy, SQL Server 2000, web methods

• Defined the guidelines and strategy for upgrade from 7.0.4 to 7.5.3.8 for customer facing high interactive applications.
• Hands on experience with upgrade tasks, and fine-tuning the application configuration, scripting and workflow processes after the upgrade.
• Hands on experience with post upgrade configuration, fixed workflows and runtime events.
• Troubleshooted and documented Siebel - Actuate connectivity, Actuate report server administration including reports administration tasks and scheduling.

Platform IOL 7.5 SI Conversion
Siebel 7.5.8 eEnergy, SQL Server 2000, web methods

• Designed and Prototyped the strategy of converting the environment from high interactivity to standard interactivity for customer facing applications.
• Recommended and Prototyped functions that were not supported in standard interactivity (E.g. Browser Scripts).

Platform GMB\\eOA
Siebel 7.5.8 eEnergy, Oracle 9i, web methods

• Analysis and rationalization (for global deployment) of Siebel positions, responsibilities and views in Siebel application.
• Deep analysis of business problems (including technical and functional) documented and recommended solutions for business processes with technical aspects.

August 2004 to October 2004 Technical Architect/Accenture
Confidential, (Ottawa, Ontario)
Platform Global Case Management System D1
Siebel 7.5.x eGovernment, SQL Server 2000, Siebel data warehouse, Analytics and Informatica (ETL designer)

• Analysis of data growth and impacts on production environment and missions abroad in different countries.
• Analyzed the data volume (around 4 terabyte) and proposed a data archival strategy based on active-inactive strategy. Business agreed to archive the x number of years old data with no updates. Provide architecture of secondary storage to reduce a major chunk of data and improve performance.
• Parallel Siebel environments were created to minimize the changes to conversion scripts and use EIM to upload the data and maintain the referential integrity and unique id (row_id) for integration purposes. Custom Unique customer Id was used to related the data, as row_id's were different in both environments.
• Prototyped the secondary storage (for global deployment) and configured new views with VBC based applets querying secondary storage siebel environment and EAI based interface for ongoing data move to secondary storage environment.
• Used ERWIN tool for representation of logical data objects with in Siebel schema and outside data sources.
• Analysis of Siebel Remote (replication manager) for distributed environment for missions abroad. Advised a strategy for custom tables and columns for docking rules and new routing rules for limited replication.
• Prototyped the distribution of various siebel anywhere upgrade kits to dedicated web clients, mobile clients and regional nodes using component based and employee based distribution strategy.

March 2004 to July 2004 Sr. Consultant/IBM
Confidential, (Winnipeg, Manitoba)
Platform Customer One Project
Siebel 7.5.3.5 eCommunications, Oracle 9i, Technical Order Management

• As a Product\\Pricing Architect, defined guidelines for Product\\Pricing\\Proposal\\eAdvisor implementation.
• Defined templates for requirement gathering of product\\pricing and worked with process team to bridge the gap between process and technical team. Participated in workshops and helped in defining process maps and Use Cases.
• Lead for Wireless product structures, including Voice, Data, Paging and FleetNet deliverables. Designed and prototyped one plan from each category for signoff.
• Used Access control mechanism for visibility control of Product Catalog. Defined Price lists, Account specific price lists and promotions, customizable products, product features etc.
• Researched, documented and prototyped Siebel Proposals and eAdvisor (interactive tool with finding right product for customer based on series of answers).
• Assisted and troubleshoot the High Interactivity upgrade for 7.5.3.5 and infrastructure routines.

August 2002 to March 2004 Sr. Consultant/CGI
Confidential, (Toronto, Ontario)
Platform Go See Project
Siebel 7.5.2.214 eCommunications, Oracle 8.1.7, LDAP, Resonate dispatch, MS clustered servers

• Defined Products approach, modeled products, defined classes, attributes and sub-products for customized products using eConfigurator (Technical Order Management). Used linked objects to Business components, scripts and customized web templates for UI controls to enforce the business logic.
• Through knowledge of working with Multi-Lingual application and related issues. Through knowledge of RAL language to write business rules for products.
• Used ePricer for attribute based, component based, price factors and scripting based pricing for econfigurator products. Used Access control mechanism for visibility control of products.

Platform Level 4 Project
Siebel 7.5.2.211 eCommunications, Oracle 8.1.7, LDAP, Resonate dispatch

• Server and Application administration of siebel 7.5. Used release management approach and migrated changes throughout the environment, ran Genbscripts, migrated products, workflows and web templates. User creation using LDAP for Single Sign On (SSO). Installation and configuration of various environments like UAT and Training. Post implementation support, resolving trouble tickets using Siebel tools and ongoing enhancements.
• Product Administration, Modeled product approach, defined classes, and attributes for customized products and also defined simple products. Edited Virtual business components and product templates.
• Used browser side and server side scripting to force business logic, data manipulation and forced users to fill appropriate data. Manually adjusted the scripts and web templates for upgrade.
• Used release management approach for parallel development of projects using merging the repositories.

November 2001 to August 2002 Team Lead/TDit
Confidential, (Toronto, Ontario)
Platform
Siebel 6.0.1 Sales force automation, Oracle 8.1.5

• Post implementation support, configuration using Siebel tools and ongoing enhancements.
• Analysis, Architecture review and Performance tuning of Siebel application.
• Modified PL/SQL scripts for data transformation, created batch files and EIM for loading into Siebel.
• Ongoing Siebel Application administration and configured siebel 2000 smart script.
• Implemented Quality management techniques for various projects and defined test strategy for HVC Call Routing Project.
• Defined various test procedures and regression scripts for consistent environments.
• Tested Siebel 7 in a separate environment for upgrade.

July 2001 to Sep 2001 Technical Architect/NovaChemicals
Confidential, (Sarnia, Ontario)
Platform
Siebel 6.0.1 Call Center, Oracle 8.1.5, SAP 4.6B, Siebel-SAP Connector (EAI).

• Defined post implementation strategies to cleanup the system and for on going support.
• Analysis of Development, QA and Production System (Archive projects from production compared to Dev and QA) and resulted in stable environments.
• Configuration using Siebel Tools and Configured Siebel Anywhere to reduce the time and to be more efficient.
• Clean up and restructuring of SAP connector build on Siebel EAI (Integration fields and User keys)
• Manipulated the Sequencing of Integration Components, User Keys and re-mapped to the Business Components using EAI.
• Researched the Data flow errors with EAI and designed error handling module using workflow manager.

August 2000 to June 2001 Technical Architect/Deloitte Consulting
Confidential, (Mississauga, Ontario)
Platform
Siebel eLifesciences 6.0.2, SQL server 6.5, 7.0, 2000, Siebel EAI, JDE, AS/400, Data Mirror, ERWIN 3.5.2.

• Involved in Strategy team and worked exclusively with strategy sub-stream "Profitability".
• Provided the expertise in assessment of IT infrastructure; designed the development strategies like backup & migration strategies etc. Tested Siebel handheld synchronization in a test environment.
• Provided Functionality assessment of siebel core application vs siebel eLifesciences, Web based applications including siebel echannel leads management and made recommendations.
• Used Remote Replication for Server and Regional node with visibility rules.
• Actively participated in gathering data requirements and was part of the technical team to define the requirements to capture data and proposed the data integration.
• Used ETL (Extraction, Transformation and Loading) concepts and created custom designed ETL tool using Data Mirror, SQL server 2000 and Siebel utilities. Using ERWIN tool, defined ERD's (Enterprise Relationship Diagrams) to demonstrate relationships in RDBMS.
• Used ERWIN tool to define Data Transformation process (Data Quality) in data repository and uploaded to Siebel through EIM and created a continuous process using Siebel EAI and Workflow Manager.

Feb 2000 to July 2000 Infrastructure Lead / Deloitte Consulting

Confidential

Platform

Siebel 99.5.6 on NT environment. Sun Enterprise 3500 servers, Veritas Cluster manager, Net backup, Unix and Oracle 8.0.5, ERWIN 3.5

• Installed and Configured the Development, Test, Data, Uat, Training and Production environments.
• Performed System Administration and provided assistance in DBA responsibilities.
• Used different scripts like Install.ksh, Imprep.ksh, ddl.sync, and dev2prod.ksh to configure stable and same environments.
• Used the siebel Packager Utility to create a package with custom configuration file and custom .srf file.
• Played a key role in Deployment for two phases and key role for GM Certification.
• Installed and configured the Fulcrum Search Engine and created a documentation and using AT command scheduled it for regular update of indexes.
• Performed Server Administration and Application administration. Creating Employees, Positions, Responsibilities, Predefined Queries and Lov's etc.
• Configured Correspondence Screen and provided the new view for Managers "My Teams Correspondence" and configured with mail merge.
• Worked closely with testing and training teams.
• Configured batch files to distribute the latest .srf file on daily bases for testers and training people.

March 99 to Jan 2000 System Admin & Configurator / Confidential
Confidential, New York

• Responsible for developing the architecture that includes setting up of Siebel Database server, Siebel file system, Siebel Gateway server, Siebel Enterprise server and the Siebel server and the physical installation of the Siebel 99 software and the third party tools namely Actuate and fulcrum.
• Performing Database extracts and backup of repositories files for tools enhancements.
• Actively participated in creating visibility and security rules, created different environments UAT (User Acceptance Test, Development, Production, and Y2K).
• Configuring Components to support Workflow Manager, Assigning data with Assignment manager, Defining assignment rules and running the Assignment Manager, Siebel Anywhere.
• Created Y2K Server and client and tested for different dates and run different utilities for different dates like server Manager, assignment Manager, Enterprise Integration Manager Etc.
• Defining Remote Server Component
• Setup of Remote server for mobile clients.
• Created local Database Extract.
• Actively participated in configuration of Forecasting Module.
• Used Siebel tools to produce a custom application that included defining /modifying Screens views, applets, queries, LOVS (List of values).
• Defining Siebel application Architecture.
• Defining Object Definitions, which includes Data Object Layer, Business Objects Layer, Business components and User Interface Layers.
• Created upgrade kits and distributed configuration changes and third party tools.
• Used assignment manager for assigning sales people to different sales team.
• Used Assignment Manager to assign the tasks, defined assignment rules and criteria.
• Documented and prepared the process of Replication Manager in test environment.

Nov 98 to Feb 99 Installation & System Admin/Senior Consultant
Confidential

• Participated in the installation of Siebel, server administration and remote administration.
• Configured Siebel applications using Siebel Tools.
• Using Siebel tools worked with Siebel VB to bring some custom buttons on tool bar.
• Exclusively worked with Siebel Server administration, and System administration.
• Helped in maintenance of EIM, doing bulk imports and deletes for different business purposes.

Jan 97 to Dec 97 Functional Consultant/ Confidential
Ramsoft Systems

• Involved in the Documentation, Configuration and Customization of the Sales & Distribution (SD) module using IMG (Implementation Guide), Process Models using business engineering workbench tools.
• The areas Configured were Sales, Shipping, Billing and Basic Functions.
• Involved in Unit Testing and Integration activities.

March 96 to Jan 97 Programmer/Analyst
Confidential

• Involved in the Development of the Client Server based system for the Medical Equipment Company to keep track of the customer data, invoicing, receipts etc.
• Involved in customization of various reports using Crystal Reports.
• This system was developed using Visual Basic 4.0 as front-end and Oracle 7.x as Backend.