We provide IT Staff Augmentation Services!

Configuration/eim Lead Resume

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

Hire Now