Jagdish Chandra Sabat EXPERIENCE SUMMARY: 11+ Years Experience in s/w Development out of which 8 Years of experience in CRM Consulting using Siebel (Siebel 2000 and 7.5,7.7,8.x), Vantive, Actuate Reports (Ver. 3,4,6,7,8.x), Remedy in B2B Marketplace. 3 Years in CTI Development. Experience Involved working with Clients such as Deloitte Consulting(Spain), EDS(Italy), Telefonica(Sao paulo), AOL(Singapore), ACN(USA), Cap Gemini(UK), Samsung(Korea), TIBCO(US), Genesys(US), NetApp (CA, USA). EDUCATIONAL QUALIFICATION: · Bachelor of Engineering, Electronics and Telecommunications (81.5%) – 1991 · Actuate 7 Certified. · ORACLE – DBA from SQL Star International. · Informatica, Erwin from EDS training institute. · PMP i.e, (Masters Certificate in Project management) from SP jain Inst, Mumbai. Countries visited on job – USA, Germany, Austria, Italy, Spain, UK, Brazil. Companies Worked Nu Info Systems Apr 2008 Onwards Siebel 8, Actuate 8 INFOGAIN 3 ½ Years Siebel 7.7, Actuate 7 ALTECH STAR INC 10 months Actuate 7, Siebel 7.7 Cap Gemini Earnst and Young(India) - 1 Year – Siebel 7.5, Actuate 6 Usinteractive Inc (USA)– 3 ½ Years – Siebel 6, Vantive, Actuate, Remedy Information Technlogies India Limited – 3 Years - CTI, Telecom TECHNICAL ENVIRONMENTS: Operating System: Primary Skills: Windows NT, Windows 95, Windows 3.11,Windows 2000,Windows XP Secondary Skills: Unix, Solaris, Novell 4.11. Language: Primary Skills: Siebel(Siebel Tools, Siebel-Actuate Report, E-script, EIM, EAI, Assignment Manager, Workflow, Siebel Administrator), Vantive(Client, Tools , Form Designer and Vantive Object Studio) , Remedy , Van Web, CTI, C, VC++, MFC, Oracle DB,ORACLE DBA, Informatica, Er-Win, VB, HTML, JavaScript, Actuate Report, Internet Information Server, Web Publishing, SQL Server, Citrix ,VPN. Secondary Skills: Siebel Analytics, Portal Billing System, Turbo C, Win32 API, Java1.2 and 2, JDBC, Internet / Intranet Programming, Web Publishing, MS Access. Concepts: Primary Skills: eCRM, B2B, B2C, Four Tier Architecture, e2e Hub, EAI, Middleware-BEA Tuxedo, Billing Systems for Telecom Industry (Portal), CTI, OOP, Genesis T-Server, PBX, Telephony, SCCS, VSS, Siebel CTI, G-Plus Adapter. Secondary Skills: TSAPI, TCP/IP, Kenan Arbor Billing System. MAJOR ASSIGNMENTS: Organisation: Nu Info Systems(WWW.NUIS.Com), Florida Apr 2008 to dec 08 1. Project: - Net Apps V8 Siebel Implementation. Client: - Net Apps, Sunnyvale , California, US Duration :-April 2008 to Dec 2008 Role: - Consultant Siebel Sales Upgradation from 7.5 to 8.0 and Actuate Upgrade from 7.5 to 8.1 . Worked for NetApp's Siebel(Sales Module) Upgrade project. As a Siebel Actuate Consultant I have worked with the Siebel Team for the Actuate Report Upgradation Task.Role Involves upgradation of Actuate Reports and creation of new reports. Interacted with the development team's track owners for different modules to get update on the module and get updated the changes from 7.x application. · As a Actuate Report Analyst I have Gathered Report related Information from the Client. · Upgraded the Actuate 7.x reports to Actuate 8.x reports as a part of Application Upgrade. · Worked with List, Master Detail and Composite data stream reports. · Upgraded the Quote Proposal templates and deployed in Application. · Incorporated the new Field change functionality in 8.x reports. · Prepared the new Reports Mockup by Interacting with BA'a and the Client. · Developed the New Reports for Siebel 8.x Application, And Deployed in Application. · Wrote the VB Codes necessary for the data manipulation inside the reports. · Made changed to the Existing reports for supporting Different Language at Report Footer. · Worked In Siebel tools for the Report library generation. Environment: SIEBEL 8.0, Actuate reports 8, Oracle 10g, Organisation: INFOGAIN India(www.infogain.com) Oct. 2004 to Apr 2008 2. Project: - VMWARE Siebel CTI Implementation Project. Client: - Genesys Telecommunications Labs, California, US Duration :-July 2007 to Mar 2008 Role: - Project Manager (Technical) VMWARE wanted to implement Siebel CRM Call centre and Service module for their Partners and as well as personal use. Responsibilities: · To Implement Siebel Server and Work environment. · To coordinate and replicate the same environment as VMWARE at India. · Deploy the changes made from offshore team by establishing connection via VPN from INDIA. · Develop and track the Changes made by team. · Create Assignment manager Rules. · Do the EIM task to transfer data. · Create ADM tasks for Deployment of Data transfer. · Installing Genesys G- Plus Adaptor, Configuring the Agents in Siebel to enable the CTI Comm from Siebel end. · Creating Agents in Siebel as per the Client requirement to be used by CTI. · Monitoring the Configuration Server, Configuration Manager, T-Server. Environment: SIEBEL 7.7.2.6, Oracle 10g, Genesys CTI. 3. Project: - Genesys Siebel CTI Project. Client: - Genesys Telecommunications Labs, California, US Duration :-May 2005 to July 2007 Role: - Project Manager (Technical) Genesys Telecommunication’s labs implemented Siebel call centre application to replace Scopus application for the Internal and external customers. The newly implemented Siebel Application is integrated with SAP, Genesys CTI, EPMS (Microsoft projects) and other applications. The Application keeps track of Product, Order and Quote also including the Project Tracker (defect tracking system). The application integrated with Genesys T-server to provide CTI functionality. The application also integrated with MS-Outlook to provide email Response Functionality. There are few Scheduled EIM Jobs to get data from SAP to Siebel application on periodic basics. Responsibilities: · Get the KT and train the team members of the Siebel team on India. · To provide Level 2 Support to the clients by connecting via VPN from INDIA. · Bug fixing and enhancement of reports in Siebel(7.7) as well as in Actuate Reports(ver 7) . · Application bug fix raised by user. · User Administration. · Application administration. · Development of new reports (Combined Data stream reports, parameterised report,etc..). · Making changes in the application as per users report requirement. · Job allocation to the Team and monitoring and controlling the activities. · Project Reporting (to the management as well as client) and SQA Activities. · Direct Interaction with Client to understand the technical requirement and resolution. · Monitoring and debugging the T server, Configuration manager for CTI activity. · Resolving the CTI Related tickets raised by users. Environment: SIEBEL 7.7.2.8, Actuate reports 7, Oracle 9i, 10g, Genesys CTI. 4. Project:- TIBCO Siebel Upgrade Project. Client :- TIBCO, California, US Duration :-10/2004 to May 2005 Role :- Project Lead The project is upgradation of Siebel 6.0.2 to Siebel 7.7. The modules are Service and Training. The majority of this phase of the Project is to have the same functionality as of 6.x. The client should be able to access all functionality via web client. Primarily the project involves Bug fixing and provide client with OOTB siebel functionality. In addition, the Installation and configuration of Actuate Report Server and access the reports from siebel-thin client as well as siebel-dedicated client. Actuate Reports upgradation to Actuate 7.New Report Creation in Actuate and writing the VB Scripts to achieve functionality and enhancing the report performance. Responsibilities: · Upgradation of Siebel 6.0.2 to Siebel 7.7 . · Upgrade of Actuate 4.0 to Actuate 7.2. · Development of Complex Reports, Report server Installation and configuration, mgmt console and active portal. · Development of New Reports in Actuate. Writing VB Scripts to achieve complex reports functionality. · Expertise in Siebel Tools 7.7 (Configuration), Siebel VB, E-script, Actuate Reports. · Expertise in Email Response, Workflow. · UI Bug Fixation after upgrade. · Knowledge of EIM, Datawarehousing. · Installing and configuring Actuate e.reporting server and Siebel report server access. Environment: SIEBEL 7.7, Actuate reports 7 and Oracle 9i. Organisation: ALTECH STAR INC 01/2004 to 10/2004 Trained in Actuate-7 by Actuate Corporation and Actuate Certified. The training course include, · Creating Grouped and parameterised report · Creating Cross tab report, parallel and sequential report · Creating Dynamic text control, charts and hyperlinks. · Page level Security, XML Report and Information Object. · Using Requester API and Configuration file. · Customizing sub report, library, page, data stream. · Using filters. · Developing dynamic report content. · Optimising reports. · Publishing report on web, · Actuate I server, Management Console concepts. Environment: Actuate reports 7,Actuate Management Console, and Oracle 9i. 5. Project:- Siebel Upgradation Project (Siebel Call Center). Client:- RICOH, France Duration :-04/2004 to 09/2004 Role:- Team lead The Project is a Upgradation Project from Siebel 6.0 to Siebel 7.5.3.Oracle 8i to Oracle9i, Actuate 4.1 to Actuate 6. The main focus of the client is to have the existing functionality accessed via web client. Primarily the project involves Bug fixing and provide client with OOTB Siebel functionality. In addition, the Installation and configuration of Actuate Report Server and access the reports from Siebel-thin client as well as Siebel-fat client. Responsibilities: · Client interaction. · Gap Analysis. · Database upgrade to Oracle 9i. · Pre upgrade task. · Resolving conflicts. · Upgrading to Siebel 7. · Upgrade web client. · Installing Actuate Report Server. · Upgrading Actuate reports. Environment: SIEBEL 7.7, Actuate reports 7 and Oracle 9i. Organisation: Cap Gemini Earnst and Young(India) 03/2003 to 01/2004 6. Project:- Lloyds Register Siebel Customisation. Client:- Lloyd Register of Shipping, UK Duration :-03/2003 to 01/2004 Role :- Senior Developer The Project is maintenance and enhance project for the LR Shipping Corporation. LR using the Siebel Service module. And the application integration with email response system for managing the document management system. Also new report development. Responsibilities: · Expertise in Siebel Tools 7.5.2 (Configuration), Using Siebel VB, E-script, Actuate Reports. · Server Administration, User Administration, Application Administration, Email Response. · Expertise in Remote Offshore Support using Citrix, Remedy EARS. · Knowledge of EIM. · Expertise in Siebel Integration With Microsoft Outlook. · Installing and configuring Actuate e.reporting server and Siebel report server access. · Developing Actuate Reports(Ver 6.0). As a Sr. CRM Consultant, developed the Ships Information view using Siebel Tools (Siebel 7.5.2.100), Which shows the Ship information. Creating picklists and MVG’s. Configuring MS Outlook and Creating Email Response groups. Working in providing Offshore support via CITRIX Client to the Current Siebel Clustered Environment. Attending Service Requests via Remedy Electronics Action Request System (EARS). Creating/Modifying User/User Groups, Assigning positions and Responsibilities. Also Implementing Change Requests by adding new Functionality’s. Installing and configuring Actuate e.reporting server, Siebel report server access and Developing Actuate Reports(Actuate 6.0) to meet the Client requirement. Environment: SIEBEL 7.5.2.100, Actuate reports 6.0 and Oracle 8.1.7. Organisation: Usinteractive Inc(Former Softplus Inc), CALIFORNIA,USA 06/99 to 02/2003 7. Project:- Siebel Telco care Development. Client : - Deloitte Consulting Duration :-01/2002 to 02/2003 Role :- Senior Developer · Expertise in Siebel Tools (Ver 6,Configuration) , Siebel VB, E-script, Siebel Actuate Report. · Expertise in EIM, Assignment Manager and Workflow. · Knowledge of EAI. · Expertise in Siebel Integration With Third party Billing System using Tuxedo. Responsibilities:- Team member, I have developed the Contact Information Screen, Address Screen, Payment Info screen, Cases and Fulfilment Screen using Siebel Tools ,Which shows the Contact information applet, Address information Applet, payment Information applet and a Tree Applet Showing the Customer Summary of cases .Worked on Customer Information Business Component, Account Business Component, Payment Info Business Component , Address Business Component , Cases Business Component and Fulfilment Business Component on Contact Business Object. Created Applets, Views and Screens and Its wrote the corresponding Siebel-VB Code. Environment: SIEBEL 2000(Siebel 6), Actuate reports , BEA Tuxedo-middleware, Oracle . 8. Project: Telefonica Project(Implemented Order management module using Vantive) Client :- Deloitte Consulting(Spain, Austria, Brazil). Duration : 06/2000 to 01/2002 Deloitte Consulting, Spain. Having its client Telefonica to implement telecom solution all around Europe and South America. Deloitte chosen Telco care ( vantive developed by Softplus Inc) to implement at all it’s client (Telefonica) site. As a Team leader I was responsible for following: · Knowledge Transfer (KT) sessions with the client, which involved fully understanding module functionality and coming up with technical solutions. · Architectural design of the application. · Developed a common S&G (Standards and Guidelines) for Order Management Process in Vantive, Billing System and the Middleware using Tuxedo. · To map prepare the workflow in BPD(Business Process Designer) of ConnectEx and TPV(Third Party Verification(Like Equifax)). · Preparation of High Level Design and Low level Design. · Development of the application using Van Tools, Van Design, Vantive Client In Unix Environment. · Designing the database using Oracle 8i. · Designing database queries for updating, insertion and retrieval of data. · Normalisation of the database. · Source code management using SCCS. · Session bean for client interaction with the application. · Normalising the tables and developing database. · Testing and code review strategies. · Responsible for Pre-UAT testing and Implementation of the module. · Fine-tuning the application on performance related issues. · Testing and assuring deliveries on time. Environment: Vantive, Arbor Billing, BEA Tuxedo-middleware, Oracle 8I, UNIX. 9. Project: Electronics Data Systems -Telco Care Project(Vantive development) Client:- Electronics Data Systems Spa -ACEA (Telefonica), Rome, Italy. Duration :- 04/2000 -- 06/2000 As a Team member I was responsible for following: · Requirement sessions with the client, which involved fully understanding module functionality and coming up with technical solutions. · Architectural design of the application. · Developed a common S&G (Standards and Guidelines) for Order Management Process in Vantive, Billing System and the Middleware using Tuxedo. · To map prepare the workflow in EAI BPD(Business Process Designer) of ConnectEx and TPV(Third Party Verification(Like Equifax)). · Preparation of High Level Design and Low level Design. · Development of the application using Van Tools, VanDesign, Vantive Client In Unix Environment. · Designing the database using Oracle 8i. · Designing database queries for updating, insertion and retrieval of data. · Normalisation of the database. · Source code management using SCCS. · Session bean for client interaction with the application. · Normalising the tables and developing database. · Testing and code review strategies. · Responsible for Pre-UAT testing and Implementation of the module. · Fine-tuning the application on performance related issues. · Testing and assuring deliveries on time. Environment: Vantive, BEA Tuxedo-middleware, Kenen Arbor Billing, Oracle 8I, UNIX. 10. Projects: Reseller Project(Vantive Configuration)for American Communication Networks, Michigan Duration :- 01/2001 to 04 2001 The ACN is a Telecom Service provider providing 1+long distance service and calling card service using TELCOCARE(which is a vantive customisation) for Capturing client information and order processing through it’s Seville billing system. Through Telco care front-end it creates an account for the customer by using connectex(EAI). As a Software Engineer I was responsible for following: · Preparation of Design Document. · Development of the application Van Tools, Van Design and Vantive Client. · Database designing using SQL Server 7. · Implemented a prototype of the UI. · Development of GUI using Van Design for user interaction. · Normalisation of the database. · Testing of Application. · Using Visual Source Safe as Source Code Control. · Bug Fixing and solving transaction . Environment: Vantive8.2, SQL Server 7.0, Unix, Visual Source Safe. 11. Projects: Reseller Project(Actuate Reports)for American Communication Networks, Michigan Duration :- 09-1999 to 12-1999 The ACN is a Telecom Service provider providing 1+long distance service and calling card service using TELCOCARE(which is a vantive customisation) for Capturing client information and order processing through it’s Seville billing system. The Reports of the Existing clients should be seen through vantive front-End using Actuate Report Writer. As a Software Engineer I was responsible for the following: · Architectural design of the application using Actuate Report Writer. · Writing of .bas file and added to Actuate Projects. · Performance analysis and optimising for better performance. · Interacting with different groups for the team requirements. · Developing different types of report such as parallel, Sequential and Cross-tab Reports. Environment: Actuate Server, Actuate Developer Workbench, Vantive, VB, Oracle, SCCS. 12. Project: Telco Care(Vantive Customisation) Project for Asia on Line(AOL) ,Singapore(Offsore Dev) Duration :- 06- 1999 to 09-1999 Brief about the Project: it basically Training in Vantive(Telco care ) and Testing. As a Software Engineer I was responsible for the following: · Involved in the Testing of Telco Care Test plans. · Bug fixing and related issues. · Attended Training session for Telco Care, Portal Billing, · Administering the IIS server and VanWeb. · Done Gap Analysis and Creating USERs, Objects, Tables in Vantive Environment. Environment: Oracle , WinNT, Vantive7.0. Organisation: Information Technlogies India Limited, India 03-1996 to 06-1999 13. Project: CTI Application for SAMSUNG, KOREA Duration :- 04-1998 to 06-1999 The CTI application based on client-server architecture and uses TSAPI (Telephony Services Application programming interface) specification’s to incorporate telephony features. The clients are MS-Windows based application running on a Novell Netware LAN. The clients provide the user with an interface for conventional telephony services like dialing, holding, conferencing, consultation etc. In addition to these services extended services like Boss Secretary, wake up services, neighbor monitoring, call routing, Personal and Shared directory assistance and central call logging are also provided by the application. The server part of the application resides on the Novell telephony server and coordinates the clients in the system. It also provides them with call logging facility and operator services. The application has been designed using Object oriented Analyses and Design and implemented in MS-Visual C++ 4.0(MFC 4.0). As a Team Member I was responsible for the following: · Development of the client module using Visual C++,MFC. · Database design in MS-SQL 5.0. · Database tuning. Environment: Visual C++, Novell Netware, SQL server6.0. 14. Project: Web Page Development for USHA INDIA LiMITED. Duration :- 08-1997 to 04-1998 The Home page gives a detailed description about the company, its associates, the products which it manufactures, market. It not only contains the text message but also contains the graphics. Responsibilities include the involvement in study, analysis, design, coding of the project. It also includes coordination with the client to understand their presentation requirement. As a Team Member I was responsible for the following: · Development of the Home page. · WEB Hosting and Pulishing using FTP. Environment: HTML. 15. Project: A TSAPI compliant Telephony services PBX Driver for Inforex PBX for SAMSUNG, KOREA. Duration :- 03-1996 to 08-1997 The TSAPI Driver is a NetWare NLM to provide a logical connection between the Inforex PBX and the TSAPI (Telephony Services Application Programming Interface) services TSAPI is a call level interface to provide a platform to build CTI (Computer Telephony Integration) applications in a Novell NetWare based LAN environment. The telephony requests originated by a client application running on a Novell workstation are redirected to the Tserver (Telephony server) NLM running on the Novell Server. This T-server NLM redirects these requests to the Inforex TSAPI PBX Device Drive which in-turn requests the Inforex PBX using its predefined software interface (known as infolink) over a RS-232C serial communication interface to get them executed in the actual switching domain of telephony devices. The inforex TSAPI device driver consists of multiple threads each of which performs independent tasks like handling of Tserver interface, OA&M settings, processing of TSAPI request/events which includes the TSAPI request identification to provide the appropriate message translation to the corresponding Infolink request and handling RS-232C interface between the Inforex PBX and Novell Serve. As a Team Member I was responsible for the following: · Development of the client module using Visual C++ , MFC. · Database design in MS-SQL 5.0. · Database tuning. Environment: Visual C++, MFC, Novell Netware, SQL server6.0. Organisation: Enkay Telecommunications, New Delhi 06/91 to 03/1996 16. Job Responsibility : Customer Support Duration :- 06-1991 to 03-1996 As a Sr Customer Support Engineer I was responsible for the following: Job involves Installation, testing, commissioning of Key Telephony Systems CTI software. and also SMDR (Station Message Detailed Recorder - Hardware) & its pre-defined software interface (known as Call Monitoring System).The KTS will be connected to the Computer over a RS-232 serial communication interface. My job is to get them executed in actual switching domain of KTS, The SMDR Card captures detail information about the exchange and sends those to the computer about the exchange (i.e. KTS). The CMS Software, which resides as a TSR in computer, maintains a database (FoxPlus), which not only keeps the track of records but also updates the records online. All this operation takes place on a online system. The format of call tracking is incoming or outgoing call, date, time, duration and finally the charge of the call. The user can get their records extension wise, line wise, data wise, city wise as per their requirement.

Highlights:

Companies I like:

All