Manager Service

Rajavardhan B

Contact#: 972-***-****

Email: *************@*****.***

Summary

Having around 10 Years of experience in Siebel CRM. My technological forte is Siebel. Have diversified experience across siebel applications like Siebel loyalty, Siebel Communications, Siebel Financial Services, and Siebel Call Center, Sales and Marketing.

Having 3 Years of design and development experience in Siebel Universal Customer Master (UCM) and Oracle EDQ applications.

Extensive hands-on experience on Siebel EAI, Web Services, HTTP, VBC, EBC, Data Mappings, File Transports, Siebel XML Converters, WSDL, Integration Objects, JMS, Business Services, EAI Performance Tuning.

Worked on Siebel EAI Value maps and XML parsing using Siebel vanilla Business Services and Scripts.

Developed Inbound & Outbound Web Services for Service Request, User profile, Account, Address and Product.

Efficient in integrating Siebel application with External applications using JMS and MSMQ Middle wares.

Expertise in configuring Siebel email Inbound & Outbound Integrations both Structured and Unstructured.

Knowledge in Integration of eMail server with Siebel Server by configuring Communication Drivers and Response Groups.

Experience in development and deployment of email Response module, custom Automation solutions for variety of Inbound/Outbound email requirements.

Good experience in setting up business rules for automation using Task based UI and Siebel workflows

Expert with Siebel Universal Customer Master (UCM) v8.x.x including extensive experience with setting up and configuring Survivorship rules and Source confidence.

Experience in integrating MDM with external applications using Siebel Web Services, Siebel "UCM Publish & Subscribe", and SOA related technologies

Deep understanding of Siebel UCM/MDM capabilities, Methodologies and approach to UCM implementations

Having experience in configuring UCM survivorship, best version records, source confidence, & Siebel connector, Data Cleansing and Matching.

Strong knowledge of working with the Siebel Universal Connector, and integrating with Third Party Data Quality Tools for Data Cleansing and Matching.

Good understanding in Siebel UCM/MDM and IIR tables. Having expertise in configuring Fuzzy queries.

Functional experience and comprehensive understanding of Master Data Management software applications specifically Siebel UCM/MDM.

Experience executing data profiling using data quality tools like Oracle Data Quality, Informatica Identity Resolution

Experienced in configuring and integrating UCM/MDM with Siebel CRM.

Excellent hands on experience on integrating Oracle BI Publisher with Siebel.

Good experience in setting up business rules for automation using Haley rule engine, task based UI and Siebel workflows

Having conceptual knowledge on Siebel Open UI, HTML, CSS, JQuery and Shell scripts.

Good understanding of Software Development Life Cycle (SDLC) and Agile methodologies.

Solid experience in onsite--offshore model. Successfully led onsite-offshore team for 3 implementations from onsite.

Closely worked with business users/BAs to analyze, gather, and map requirements, solution recommendation, scope, costing, prototype, and implementation.

Diverse experience in Siebel CRM product performing various roles such as analyst, configurator, technical lead, integration specialist.

Certifications

Oracle Siebel CRM 8 Business Analyst Expert

Salesforce.com Certified Force.com Developer (DEV401)

Skill Summary

CRM:

Functional Siebel loyalty, Siebel Communications, Siebel Financial Services, and Siebel Call Center, Sales and Marketing.

Technical: Siebel Tools 8.1.1/8.0/7.8.x/7.5.x, include Siebel Configuration, Siebel Server Components: Siebel UCM/MDM, EAI, Assignment Manager, Repeating Component and Workflow Manager, Siebel EAI: eScript, VBC, Integration Objects, Business Service, HTTP, EIM, Haley, Task Based UI

Additional Skills

Operating System: Windows NT 4.0/98/2000/XP, UNIX, Sun Solaris

Programming Languages: C, JavaScript, XML, HTML, Siebel eScript / VB script, SQL, PL/SQL, Shell script

SAAS: Sales force, Apex, Visual force

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

Others: TOAD, SQL Plus, XML SPY, SoapUI 1.6

Education

Bachelor of Computers Science, Master of Business Administration

Employment Summary:

Working as a Sr. Siebel Lead Consultant with Tata Consultancy Services Ltd since 2008, Worked as a

Programmer in “Hexaware Technologies Ltd” during 06-08.

Professional Experience:

American Airlines, Fortworth, TX

Project#1: Barcelona Jun’14 – Present.

Role: Siebel Lead Consultant

Project Description: Barcelona Project is responsible for feeding the Agency and Corporate data to all downline systems like Mosaic and Mainframe. Barcelona project is replaced existing VISION application which was originally developed in Mainframe and it used to feed the data to all its downstream systems. As part of an enhancements, we are integrating Barcelona application with Salesforce to bring Account owner and Account profile information to Siebel. Barcelona Project is also integrated with SHARP system which provides American Airlines employee information on a daily basis. The implementation also includes migration of data from the legacy application (ARC/IATA/PRAS) and leveraging the functionalities of other Siebel modules such as Loyalty, eChannel, eService etc.

Responsibilities:

Daily interaction with the client for requirement gathering and seeking the clarifications upon ongoing implementations.

Design and develop Siebel user interface and EAI (Enterprise Application Integration) for integration with other software applications like SFDC, including set-up activities.

Involved in integrating Siebel with Salesforce cloud application using JMS.

Developed interfaces with external systems SHARP, QIK using Siebel Workflows, Siebel EAI Adapter, EAI XML Converter, EAI HTTP transport (Design and Develop EAI XML Interface connecting Siebel EAI).

Worked on EAI Data Transformation engine to map the Inbound and Outbound Integration Objects.

Developed Task Based UI to speed up the QIK certification generation process as part of issuing TAC requisition certification

Working closely with Database team, infrastructure team and others to integrate their applications with Siebel applications.

Troubleshoots Siebel issues across multiple environments. Duties include gathering business requirements, preparing specifications, coding, testing, debugging and documentation including

Designed and developed Siebel Virtual Business Components for real-time legacy integration.

Configured the BI Publisher Scheduler and uploaded pre-configured reports.

Created workflows/WF Policies/Batch Process as per business requirements.

Developed Custom business services to roll down team members to Regions and Sites.

Involved in the Open UI upgrade project planning, completely and came up with all the tasks needs to be executed.

Implemented User Inbox Notifications using Siebel Workflow policies.

Always adhered to follow Siebel Best Practices where ever it is required.

Modules Implemented:

Using MSMQ, Integrated SIEBEL application with SFDC application for creating Accounts in Siebel.

Using Web service, Integrated SIEBEL application with SFDC application for associating sales reps to

Accounts created in Siebel.

Designed Siebel application to handled Sales territory hierarchy.

Siebel Task Based UI

Siebel BIP Reports

Environment: SIEBEL Application v8.1/8.1.4, Windows XP, 7, Oracle 9g, 10g2

American Airlines, Fortworth, TX

Project# 2: Soliel Jan’13 – Jun’14

Role: Siebel EAI Sr. Developer/Lead

Project Description: Soleil involves in creating various facilities and benefits for the customers of American Airlines as an individual or along with their spouse. These facilities will be enabled for the users when they purchase a One Day Pass (ODP) or enroll Advantage members as Admirals Club members to enable them to use any of the American Airlines lounges for a given period of time.

Responsibilities:

Involved in integrating Siebel with external system SABER using web services.

Developed new workflow to generate reject letters using EAI Siebel Adapter, EAI Data Transformation Engine, and Integration Object.

Performed administrative tasks like creating users and assigning them privileges to groups

Developed custom business service for transition of Campaign Members from one campaign to another campaign

Developed new custom business service to create response, service request, Order and activity.

Developed new interfaces to support Account management on (.net application), which involves creating web services, workflows, workflow policies, Integration Objects, and business Services.

Developed and created Inbound Web Service ‘MM_CAMP_CON, which consists of Create Contact, Assign to Campaign, Update Contact, and Update State License Info.

Developed New Inbound, Outbound and Data Entry Smart Scripts for Campaigns to create Response, Service Request and orders.

Developed Siebel Workflows, Workflow policies and RCR’s to meet the customer requirements.

Altered Web services as per the change requests for fine tuning the performance issues.

Created workflows/WF Policies/Batch Process as per business requirements.

Helped other team members to understand requirements and develop required functionality.

Worked with Workflows, XML, DTDs, Integration Objects, HTTP and MQ Series as the transporting agents

Designed and developed the Outbound Web Service to send Accounts, Address, Orders, and Adjustments to SAP.

Designed and developed TASK FLOWs to enhance the process of issuing ODP passes to Advantage members

Developed Integration Workflows to handle the integration task from receiving the external message, parsing the message, converting into XML and Updating Siebel database and vice versa.

Modules Implemented:

Using Web service, Integrated SIEBEL application with SABER for retrieving the PNR details and Customer information’s.

Siebel Loyalty Management

Environment: SIEBEL Application v8.1/8.1.4, Windows XP, 7, Oracle 9g, 10g2

Petco, San Diego, CA, USA

Project #3: embark – Petco Nov’11 – Jan’13

Role: Sr. Siebel UCM Consultant

Project Description: As part of the embark Business transformation program, Customer Management project is in initiated in Petco. The objective is to provide single version of truth about the customer information across various customer touch points. Oracle technology, Siebel Universal Customer Master Application is leveraged for this purpose.

Responsibilities:

Worked on implementing the Siebel UCM data base extensions, Creation of IO/IC's, creating the integration Workflows, BDM workflows for routing the data from source systems into Siebel UCM(Inbound data Flow) and from UCM data to external systems(Out Bound Data Flow)

Extensively worked on SDH tables and Siebel connectors to integrate Siebel UCM with third party data quality tool i.e. IIR

Installed Informatica Identity Resolution 2807 in AIX 6.1 and integrated with Siebel UCM 8.1.1.5

Participated in loading the customer address data using Batch Interfaces for initial source data loads and incremental data loads

Exclusively worked and customized Siebel vanilla UCM WF’s and Business services like UCM Transaction Manager, UCM Data quality manager, UCM Dispatcher etc.

Configured UCM inbound server communication using EAI JMS Transport.

Integrated Siebel UCM application with IIR by configuring Data quality server components in Siebel.

Configured threshold limits for Data cleansing and data matching as per the customer requirements.

Explored and widely used existing UCM Business service user properties which helps in configuring threshold limits for data cleansing and data matching for customer data.

Solid business acumen related to customer master / customer hub business processes and best practices.

Modified vanilla survivorship engine business rules as per the customer requirements

Developed Fuzzy queries which helps customer enormously in matching the exact data.

Explored, customized, and developed UCM integration Objections while integrating Siebel UCM application with IIR.

Hands on UCM development for Survivorship, real-time integration using UCM web services and Data Quality

Adjusted the Match field weights and various other functionalities of IIR to fine tune the matching and data standardization

Proposed the search criteria for exact match and Fuzzy match and weightage for each fields in match criteria

Developed and customized data governance rules as per the Data steward

Solid knowledge related customer data quality and rules around customer master attributes

Environment: Siebel 8.1.1.7, Oracle 11g, Linux 10.0 application server, Siebel UCM application and Shell Scripting and Oracle On Demand(OOD).

US Bank, Richfield, MN, USA

Project #4: US Bank CRM Service Support Apr’10 – Nov’11

Role: Siebel UCM Consultant

Responsibilities:

Understood the existing business process and functional requirements of the project by interacting with client and end users. Involved in analysis of project requirements and design Responsible for Root-Cause-Analysis (RCAs) for any issue.

Gathering the requirements from different subject matter experts (Client Side) and do the impact analysis and feasibility study from Siebel UCM/MDM perspective.

Involved in data profiling and data quality assessment of financial accounts and address data

Modified and customized Survivorship rules for customer address cleansing and matching

Configured Attribute groups and external systems privileges which are integrated to Siebel UCM

Customized Siebel Vanilla UCM BS user properties such as SIEBEL UCM Transaction Manager, UCM Dispatcher, and UCM Publish/Service BS etc. as per the client requirement.

Altered Siebel UCM data quality Manager user properties and UCM Account Source Data History service which was configured to get the Account data from SAP system

Configured Deduplication mechanism for UCM contact records by creating under Admin screen

Deployment of the new changes or enhancement in application from development environment to UAT environment and finally in production.

Worked on setting Data Quality parameters and for matching and cleansing in UCM

Environment: Oracle 11g, IIR, IDQ, Siebel UCM application and Shell Scripting and Oracle on Demand (OOD).

Bharat Sanchar Nigam Limited, HYD, INDIA

Project #5: BSNL Call Detail Record Jul’09 – Apr’10

Role: Siebel Technical Consultant

Responsibilities:

Responsible for doing the impact analysis and preparing the technical design documents.

Responsible for Root-Cause-Analysis (RCAs) for any issue.

Developed integration scenarios by using Web services both Inbound and Outbound with external systems like billing and provisioning systems.

Designed workflow architecture, configured workflow policies, actions and business services for activities such as EAI, Assignment Manager and others.

Configured the Workflow Manager by creating Workflow Objects, Workflow Components and Workflow Component Columns for database operation.

Used Workflows on the Business Components to invoke Business Services

Developed custom workflows, Web Services, Business Services and Integration Objects.

Created Integration object for Siebel and External System, and developed business service in Workflow for conversion of data. Used EAI HTTP transport, EAI xml converter and EAI Siebel adaptors.

Created Inbound and Outbound Web Services for Integrations between Siebel and External System.

Worked EAI HTTP Transport services to retrieve data from External System.

Prepared interface data mapping documents for Integration of portal with Siebel

New workflows created to automate the integration process.

Worked on development of custom integration objects for real-time interface development.

Worked on development of EAI data maps named subsystems for real-time inbound integration.

Successfully resolved critical issues in the areas of efficient workflow design product configuration and process integration.

Worked extensively on designing Integration Objects.

Involved for writing Custom Business Services using eScript, which will implement XML/HTTP framework to interact with external application.

Created Workflows for Inbound communications and deployed as Web Services.

Created Custom Business services to Parse and modify the Siebel Hierarchal Message structure and Property sets.

Involved in customization of signals, variable maps and Data maps.

Environment: SIEBEL Application v8.1/8.1.4, Windows XP, 7, Oracle 9g, 10g2

Kotak Mahindra Bank, Mumbai, INDIA

Project #6: Kotak Mahindra Siebel 8.0 Implementation Phase II (Service) Sep’08 – Jul’09

Role: Siebel Developer

Project Description: Kotak Group has implemented Siebel 8.0 for Service Request, sales and Marketing. This implementation has consolidated the customer base of all the child organizations of Kotak Group (Kotak Mahindra Bank, Kotak Mahindra Prime, Kotak Life Insurance, and Kotak Securities). In effect it is a multi-org implementation.

Responsibilities:

Team member responsible for configuring the Siebel Application using Tools.

Customization of Business Services, Integration Objects, Business Objects, Business Components, Applets, Views and Screens to match the requirements.

Customization of Joins, Links, MVG, Pick lists and Drilldowns.

Configured eMail Response Groups for integrating Inbound communication server with eMail server

Customized MVG using MVLs, MVFs, MVGs and Associate Applets

Extended the base behavior by using different type of user properties

Involved in adding business logic into applications using user properties

Written scripts at business component and applet object level to fulfill the requirements

Created business services to implement complex business logics

Customized the user interface object definitions to map data from BO definitions

Involved in creating unit test cases and coordinate for testing with testing team

Performing Server side scripting in Applet, BC and Business Service level.

Involved in gathering of user requirements and developed high-level and detail design documents.

Designed and Configured the Siebel Financial Services & Call Center applications i.e. Configured UI/BO/DO layers as per the requirements.

Designed applets, views and screens, enabled the applets to display on web in different modes. Used the built-in web templates. Created pick lists, drill downs.

Customizing Business Objects, Business Components, Applets, Views and Screens to -match the requirements using Siebel Tools.

Configured the Views, Drilldown with Customer Name, which resulted to, desired "Customer Info" View.

Created Integration Object, Business Services for integration using eScript. Created Business services to generate XML files of Product, Account and transaction list using eScript.

Designed Integration Process between Siebel and Web application to create/Update an opportunity and create an activity at Siebel for every transaction done from the application.

Environment: SIEBEL Application v8.0 Windows XP, Oracle 9g

Affiliated Computer Science, MD, USA

Project #5: ACS Vector May’06 – Sep’08

Role: Siebel Developer

Project Description: VECTOR is a client-server application implemented in a distributed processing environment. VECTOR is broken down into eight subsystems that provide for a flexible set of business rules. VECTOR is a complex system which involves the electronic collection of tolls including identification of vehicle types, processing of payments, capturing violations, managing toll lanes and plaza etc. The objectives of the VECTOR systems are to help the agencies increase their efficiency and effectiveness and provide the agency’s customers with an improved experience in using the toll system.

Responsibilities:

Team member responsible for configuring the Siebel Application using Tools.

Customization of Business Services, Integration Objects, Business Objects, Business Components, Applets, Views and Screens to match the requirements.

Customization of Joins, Links, MVG, Pick lists and Drilldowns.

Involved in customization of Static and Dynamic pick lists, created customized links and joins

Customized MVG using MVLs, MVFs, MVGs and Associate Applets

Extended the base behavior by using different type of user properties

Involved in adding business logic into applications using user properties

Written scripts at business component and applet object level to fulfill the requirements

Created business services to implement complex business logics

Customized the user interface object definitions to map data from BO definitions

Involved in creating unit test cases and coordinate for testing with testing team

Performing Server side scripting in Applet, BC and Business Service level.

Configured the UI for TPMS (Transaction Processing Management Subsystem) which consists of validating transactions received from all sources, matching entry and exit transactions for closed-loop systems (such as toll roads) etc.

Configured the Rule sets using Data Validation Manager to perform the validations on the data, entered by the CSR.

Environment: SIEBEL Application v7.8/8.0 Windows XP, Oracle 9g

Contact this candidate