SUMMARY:

• Having over 6 years of total IT experience in Siebel CRM Applications especially onto the Data side.
• Strong experience in Siebel EIM Techno Functional roles.
• Experience in design the Data Acquisition, Transformation, and Data Cleansing approach.
• Extensively worked on Siebel EIM and creating procedures, End to End data migration implementation in Siebel.
• Excellent knowledge and experience in creating source to target mapping, validation, transformations, and business rules.
• Expertise in Database Integration and Management among Oracle, MS SQL Server
• Strong experience in PL/SQL, SQL, Oracle9i, 10g, 11gS & 12c
• Excellent knowledge and experience in Siebel EAI.
• Strong experience in Siebel Out bound/ Inbound web services
• Experience in MQ middle layer for Siebel Outbound communication.
• Strong experience in Siebel configuration.
• Strong experience in Siebel workflows and eScripts.
• Strong logical skills to derive concrete software solution
• Experience in analysis, coding and testing of the deliverables.
• Analytical thinker that consistently resolves ongoing issues or defects.

TECHNICAL SKILLS:

CRM Tools: Siebel 8.1, 7.8 - EIM/EAI/Config

Domains: Siebel call center, financial service, Public Sector

Data Base: Oracle 9i, Oracle 11g, MS SQL Server 2005

Languages: SQL, PL/SQL

E.T.L Tools: Informatica

Tools: Eclipse, Toad 9.5, Edit Plus, Winscp

Operating Systems: Windows (2003, XP, NT), UNIX

PROFESSIONAL EXPERIENCE:

Confidential

Configuration/EIM Lead

Environment: Siebel public sector, Oracle 12C, Siebel Tools, Siebel e Script, Siebel Workflows, Siebel EIM.

Responsibilities:-

• Gap analysis across Siebel SEA to Siebel SIA.
• Migrate the data into new table as part of the upgrade.
• Identified the issues which got in the upgrade and fixed.
• Performance tuning has been done in new data base.
• Table fragmentaion has been done for the large volume tables.
• Worked on the configuration issues during the upgrade process.
• Application level performance tuning has been done in new Siebel version.
• Trouble shooting the defects.

Confidential

Siebel to SAP Integration Lead

Environment: Siebel financial services 8.1.1, MS SQL Server 2008, Siebel Tools, Siebel e Script, Siebel Workflows, Siebel EIM, and Siebel Web Services

Responsibilities:-

• Gap analysis across Siebel touches points and resolution.
• Identified the source systems involved in integration.
• Identified the approach, methodology for Integration.
• Configured new entity in Siebel for the SAP integration.
• Preparation of data mapping with the target system.
• Created the IO for the SAP integration.
• Created the data map for the integration flow.
• Trouble shooting the defects
• Performance Tuning

Confidential

Siebel Data Lead

Environment: Siebel v8.1, Siebel Tools 8.1, Oracle11g

Responsibilities:

• Main Role in this project is data migration (EIM).
• Gap analysis across Siebel touches points and resolution.
• Identified the source systems involved in data conversion.
• Identified the approach, methodology for data conversion.
• Preparation of staging area to hold the data before moving to EIM table.
• Transforming data using PL/SQL Procs.
• Preparation of data mapping with the target system.
• Preparing the EIM Mapping.
• Creating the control file for loading the LOV values.
• Preparing the Script to load the data from staging area to EIM table.
• Creation of IFB File.
• Preparing the Shell script for automating the EIM process.
• Running the EIM Job.
• Trouble shooting the defects
• Performance Tuning

Confidential, Rochester, NY

Siebel EIM Consultant

Environment: Siebel 8.1, Oracle 11g, SQL, PL/SQL, Informatica 8.6.1.

Responsibilities:

• Loading Data from legacy system to staging tables through ETL (Informatica) tool and transfer of data to Interface tables through SQL.
• Designed and developed Informatica Mappings to load data from Source systems
• Extensively used Power Center/Mart to design multiple mappings with embedded business logic.
• Creation of Transformations like flat file, Lookup, filter and Source Qualifier Transformations in the Informatica Designer.
• Performed Data Mapping, Bulk imports of data in the Siebel database using EIM
• Creating and modifying configuration (ifb) files to run the EIM import process to populate the base tables in optimal manner
• Involved in extending columns in the Siebel base tables.
• Involved in data cleansing at the Staging table level while loading the data into EIM tables.
• Reviewed and analyzed the application requirements & legacy system
• Involved in the analyzing, planning and execution of data transfer from legacy systems.
• Created End to End mapping sheets.
• Involved in loading different entities into Siebel base tables (Group, Member Firm, Package, Product and Address)
• Worked on improving the performance of Complex SQL's and PL/SQL scripts by applying various performance techniques using hints, indexes and also looking query's explain plan.

Confidential, PA

Sr. Siebel EIM Consultant

Environment: Siebel Call Center 8.1.1, Siebel ePharma 8.1.1, Oracle 10g, Siebel Tools, Siebel eScript, Siebel Workflows, Siebel EIM, Siebel Assignment Manager, Siebel Web Services, Apropos CTI Integration, Siebel Task Flows

Responsibilities:

• Main Role in this project is data migration (EIM).
• Migrating the data from old version (7.8) to 8.1 due changes in data model.
• Identified the source systems involved in data conversion.
• Identified the approach, methodology for data conversion.
• Preparation of staging area to hold the data before moving to EIM table.
• Preparation of data mapping with the target system.
• Preparing the EIM Mapping.
• Creating the control file for loading the LOV values.
• Preparing the Script to load the data from staging area to EIM table.
• Creation of IFB File.
• Preparing the Shell script for automating the EIM process.
• Running the EIM Job.
• Trouble shooting the defects
• Performance Tuning

Confidential, Tucson

Siebel Data Consultant

Environment: Siebel 8.1, PL/SQL, SQL Server 2005

Responsibilities:

• Performed Data Mapping, Bulk imports of data in the Siebel database using EIM
• Creating and modifying configuration (ifb) files to run the EIM import process to populate the base tables in optimal manner
• Involved in extending columns in the Siebel base tables.
• Involved in data cleansing at the Staging table level while loading the data into EIM tables.
• Reviewed and analyzed the application requirements & legacy system
• Involved in the analyzing, planning and execution of data transfer from legacy systems
• Created End to End mapping sheets
• Involved in loading different entities into Siebel base tables (Member,Vendor,Claim and Address)
• Involved in automation of EIM loads using .bat files.
• Worked on improving the performance of Complex SQL's and PL/SQL scripts by applying various performance techniques using hints, indexes and also looking query's explain plan.
• Configured Business Component, Business Objects, Applets, and Views, Screen, join, link, pick list and MVG.

Confidential

Siebel Data Consultant

Environment: Siebel 8.0 Public Sector, Siebel Tools 8.0, Oracle10g

Responsibilities:

• Main Role in this project is data migration (EIM).
• Gap analysis across Siebel touches points and resolution.
• Identified the source systems involved in data conversion.
• Identified the approach, methodology for data conversion.
• Preparation of staging area to hold the data before moving to EIM table.
• Preparation of data mapping with the target system.
• Preparing the EIM Mapping.
• Creation of control files for loading the LOV values.
• Preparing the Script to load the data from staging area to EIM table.
• Creation of IFB File.
• Preparing the Shell script for automating the EIM process.
• Running the EIM Job.
• Trouble shooting the defects
• Performance Tuning
• BI Publisher Report using PL/Sql Scripts