Siebel Consultant, Project manager

PERSONAL DATA Sagar Shawrikar

Siebel Consultant

Location: Pune, India

Languages: English

Visa / Work Permit: H1B (Petition)

IT Experience Since: 2001

Cell: +919*********

E-mail: **************@**********.***

SUMMARY OF EXPERIENCE

• I have 9+ yrs of IT industry experience worked on Siebel eBusiness Solutions (Siebel 8.1.1/7.8/ 7.7/

7.5.x and Siebel 2000), PL/SQL,C , EximBills, Bank@24

• Designed, Developed, and Implemented Custom EAI Solutions

• I have fulfilled the role of CRM Stream/Technical Lead, Business Analyst, Configuration Expert & EAI Expert

• Data Validation Manager, Business Rules Processor, Runtime Events Solution

• Siebel Business Process Workflows and Email Response Development

• Experience in Siebel Inbound and Outbound Web Services

• Expertise in Design/Development of integration systems interfacing Siebel with external systems using Siebel EAI and External Business Components.

• I have involved in end-to-end implementations of enterprise wide applications. This involved project management, analysing business requirements, developing business requirements documentation, developing system design and documentation based on the requirements, developing and customizing the system to meet the requirements, testing and rollout of the system, supporting the production system during the initial go-live for various projects.

• Versatile team player with excellent Analytical, Communication and Interpersonal skills

• I have domain knowledge of Banking, Manufacturing and Telecommunication

PRIMARY SKILLS

Siebel Applications Siebel Call Center, Siebel Sales, Siebel Marketing (Siebel 7.5.x/ 7.7/ 7.8/ 8.1)

Siebel Tools - Siebel 7.5.x/ 7.7/ 7.8/ 8.1

Industry Practices Telecommunication, Banking & Finance, Manufacturing

Siebel Modules Siebel EAI - Web Services, ASI, Workflow Manager, Integration Objects, Integration with MS Outlook, Assignment Manager, Siebel Anywhere, Smart Scripts, System Admin, PRM

Programming languages C, HTML, VBScript, JavaScript, Siebel VB Script, Siebel eScript

Database Oracle 8i/9i/10g, IBM DB2/400, MS SQL Server 2003/2000/7.0

Operating systems Windows NT 4.0, Windows 95/98/2000/2003 Advanced Server/XP

Software packages Siebel, ALTOVA-MAPForce, Visual Basic 6.0, Visual Interdev 6.0, Dream Weaver, XML Spy, Informatica PowerCenter 5.1, Toad, Oracle Express Objects, See-beyond

Tools and Methods Microsoft Visio, Microsoft Project Plan

SIEBEL PROJECTS

Siebel – CRM Consultant

E2E Architect for telecom solutions.

Lead team of Siebel Consultants in Siebel CoE managing preparation of Training material, Estimation templates, challenges faced & proposed solutions, Best Practices

Performed Technical Assessment of Siebel Upgrade for GE-Railcar, Merrill Lynch and Honeywell, wrote proposal for the same and won projects for TCS

Created Siebel training kit and Imparted training in Siebel Configuration and EAI for associates working in Washington Mutual and TCS-CRM Practice

Interviewed Siebel associates across USA, India

Created training material for Web Services, SOA for TCS internal training

Organization: Tech Mahindra (IT Consulting company and Oracle Partner) – May 2009 to till date

ETISALAT DB: Siebel eCommunication 8.1.1 ( Telecom Service Provider (May 2009 – till date)

• Stream / Technical Lead (Siebel CRM, PRM and SelfCare)

Discussion with Business User, Solution & Stream Architect for

requirement and design approach

Responsible for Task / Activity & resource Management for

Onsite-Offshore Team Members

Interaction with Client and vendors

Interface Identification and development of Interface design Specification

Organization: hiSoft (IT Consulting company and Oracle Partner) – Oct 2008 to Mar 2009

National Grid: Siebel Energy 7.8.2.6 ( Major Power company (Nov 08 – Mar09)

• EAI Expert/ Siebel Consultant

Data mapping between custom Application to Siebel entities like Opportunity, Contact, Account, Activities etc.

Data Extraction logic for updating Siebel application as a daily batch job

Developed code to generate XML file in Siebel required format using Altova MapForce

Created batch file to be schedule to run as a daily batch job

Organization: TATA CONSULTANCY SERVICES LTD (TCS) – 12th Apr 2001 to Oct 2008

Ingersoll-Rand: Siebel Application hmmt 7.8.2 (Mar 07 – Oct 08) – Davidson,NC

• EAI Expert/ Siebel Consultant

As EAI Expert, I designed, developed EAI framework for integration between Siebel and Oracle apps thru Web Method as middleware.

Managed team of configurators who used the design documents in doing Siebel configuration, Mentored developers to use best practices and less scripting wherever possible to keep optimal UI performance

Generated and validated DTD files.

Validated HLD, LLD for interface with different systems

Designed & developed Error handling framework for interfaces

Designed & developed 35 interfaces

Automation of EIM Process.

Done post implementation production support.

Pilot Handheld rollout.

Currently working on change requests and new interfaces introduced.

CRM Practice (Jan 07 – Mar 07) – Charlotte, NC

• Technical Lead

Designed and developed POC on Inbound / Outbound Web Services. This involves - Creation Of Web service.

- Hosting Web service

- Created WSDL for external application to be consume for invoking web service

Led team of 2 TCS consultants doing this POC.

Prepared training material and labs on Inbound / Outbound web services management

Washington Mutual: Siebel Implementation 7.8.2 (Dec 05- Jan 07) – Seattle, WA

• EAI Expert / Siebel Consultant

Designed and Developed EAI framework to communicate between Siebel and Mainframe application (Hogan)

Created VBCs, Integration Objects and custom Business services to integrate Siebel with Mainframe systems.

Generated and validated DTD files.

Implement basic and advanced Data Mapper functionality for translation of data coming from Mainframes

Prepare workflows for debugging EAI transactions for all modules

Guided configuration and integration team in managing mix of customizations and 78 features

Done configuration for modules like Offers /Leads and customer maintenance.

Done work allocation, tracking of resource performance, Status Reporting

Facilitate in setting up Offshore in Banglore India

GE Commercial Finance: Siebel Center of Excellence (Siebel Call Center 7.8.2) – (Mar 05 – Dec 05) – Mumbai, India

• Siebel Configurator

Participated in requirements gathering and requirement validation

Design for change requests and enhancements.

Done UI, Business Object and Data layer configuration

Mapped & Implemented Smart Scripts functionality with Business requirements of uniformity in calls handling

OTHER PROJECTS

Enterprise Application Integration-National Health Care System (Jan 05 – Feb 05) –Delhi, India

Part of the Enterprise application integration team for NHS and worked on the proof of concept for See Beyond as an integration engine for integrating disparate applications for a health care system. Case studies pertinent to the health care scenarios were attempted. The nature of the case studies was to assess the ability of the integration engine to deal with disparate file format and file types as prevalent in the health care systems.

The various See Beyond components used for integration activity were:

• E*gate Manager

• E*gate Client

• Eways

• ETD

• IQ Manager

• Collaboration Rules

State Bank of India: Application Development and Customization (Trade Finance Project) (Oct 02 – Dec 2004) – Mumbai, India

The Project Involved:

• Supply, Customisation and implementation of CS EximBills Trade Finance System for International and Inland Trade Finance requirement of the bank.

• The centralized architecture of the system supports Centralized Forex rate, maintenance, Centralized MIS reporting, Centralized Exposure monitoring, any branch banking and the concept of Shared Operations Centre.

• This Trade Finance system was customized for the Banks trade in the areas of Imports, Exports and Inland according to the Indian statutory and Regulatory Requirements.

It also involved generation of complex reports for statutory purposes regarding exposure in foreign exchange etc

• Team Lead

Responsibilities

Requirement Analysis and Gap Study for Complete Import trade of the Bank

Functional Specifications

Technical Specifications

Coding

Testing

Implementation (In Twelve branches Of SBI including Corporate Accounts Group Branch, the Largest branch Of SBI for Trade finance services accounting for 30% of total revenue generated from trade finance operations for SBI)

Training for SBI users at different locations in India

State Bank of India: Application Development and Customization (Core banking Project) (Feb 02 – Sep 2002) – Mumbai, India

The Project Involved:

Supply, customize and implement a solution for the Core Banking Application System to SBI, on a turnkey basis, which includes Application Software and Hardware.

This comprehensive solution will ensure the realization of a fully functional Centralized Core banking solution for SBI.

The project involved the customisation of FNS B@ncs-24 software according to the banks

needs in the areas of retail banking

• Team Member

Responsibilities

Requirement engineering for Safe Deposit Vault

Functional Design Documentation

HLD, LLD

TCS Product Development: ALMITYTM (Jun 01 – Jan 2002) – Mumbai, India

The Project Involved:

ALMITY is a risk management tool designed and developed by Tata Consultancy Services (TCS), based on Client/Server architecture, Graphical User Interface and using Data Warehousing Technology

Asset Liability Management (ALM) involves strategic balance sheet management encompassing all market risks

• Team Member

Responsibilities

Developer

CERTIFICATIONS AND AWARDS

Siebel 7.7 Siebel 7.7 Core Consultant Certification

PMW Project Management Workshop needed for PMP

B@ncs24

Retail Banking Program Certification for B@ncs24

Siebel 8 Undergone PRM & Loyalty training by Oracle

EDUCATION AND TRAINING

Jun 2000 Bachelor Degree in Mechanical Engineering, Jiwaji University, Gwalior.

4

Contact this candidate