SUMMARY

• Over 7+ years of IT experience in Siebel CRM solutions across multiple domains and verticals including Retail, Healthcare, Telecom, Financials ,Judicial and Sales.
• Experience with Siebel Call center, Sales, Marketing, Financial Services, Life Sciences, Automotive, Public sector and eCommunication.
• Worked extensively on Siebel version 8.0/7.8/7.7/7.5 and Siebel 2000
• Executed full life cycle Siebel Implementations and Upgrade projects
• Worked extensively in EIM to Import and Export Data from External Database to Siebel Database, Base Mapping, Document Mappings, Running & Monitoring EIM Tasks and Adding & Mapping EIM Extension Columns.
• Performing EIM tasks for Upgrade. Data model comparison.
• Configure and optimized the .IFB Files, set the Configuration parameters, run the EIM Server Components through Batch files, Data Migration/Data Integration, Data Mapping/Data Stage, Data Fix and Trouble shooting.
• Expert knowledge in Data Modeling and data Normalization techniques.
• Excellent Communication skills, organizational skills, & analytical skills

Working experience in
Data migration from Legacy to Oracle DB.
Data migration from Legacy to Siebel. Siebel EIM, Data model and mapping.
Siebel Application Support: Call Centre Application, Siebel e-communications Application, Siebel e-consume
Application and Siebel supplier centre Application.
High and Low level Design. Preparation of solution design document and Technical design documents.
Automation of EIM process and performance tuning.
Architecture redesign of ORACLE DB.
Development of PL/SQL scripts, procedures and other DB objects.
Batch jobs and reports generation.
Tuning DB objects. Indexes using explain plan.

EDUCATION:

Bachelor's degree in Electrical and Electronics.

TECHNICAL SKILLS:
CRM Tools: Siebel 8.1, 7.5 - EIM
J2EE Technologies: Java 1.4, JSP, JDBC
Data Base: Oracle 9i, Oracle 11g, MS SQL Server 2005
Languages: SQL, PL/SQL, C and Java
E.T.L Tools: Informatica
Tools: Eclipse, Toad 9.5, Edit Plus, Winscp
Operating Systems: Windows (2003, XP, NT), UNIX

Project Profile:
Project: Confidential - Seattle, Washington
Role: Siebel Data Specialist
Period: July 2012 to till date

Environment: Siebel v7.5 Siebel Partner Manager Application, Siebel Tools 7.5, Oracle10g.

Confidential USA was the fourth-largest wireless carrier in the US with 33.73 million customers and traces its roots to the 1994 establishment of Voice Stream Wireless PCS as a subsidiary of Confidential. In order to improve the relations with partner T-Mobile implemented Siebel PRM applications.

Responsibilities:

• FSD Review, Requirement Gathering and System analysis.
• Creating Technical design document preparation for Data migration.
• Responsible for handling data migration for implementing Multi Org model.
• Designed Bulk data load strategy.
• Created End to End mapping sheets.
• Designing data migration Optimization Techniques.
• Performed Data Mapping, Bulk imports of data in the Siebel database using EIM.
• Designing the staging area structure for the data migration.
• Designing the data cleansing logic.
• Creating and modifying configuration (ifb) files to run the EIM import process to populate the base tables in optimal manner.
• Involved in Data quality activities.
• Involved in the analyzing, planning and execution of data transfer from legacy systems.
• Involved in loading different entities into Siebel base tables.
• 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.
• Performed creation of Windows batch file for running the EIM job and for automation purpose.

Project: Confidential - San Diego California
Role: Siebel Data Lead
Period: Jan 2012 to July 2012

Environment: Siebel v8.1 Call Center application, Siebel Tools 8.1, Oracle11g

Confidential is the largest solution for all type of business organization. Confidential the personal finance programs Quicken and TurboTax (and its Canadian counterpart, Quick Tax), as well as the small business accounting program QuickBooks. In addition, they produce QuickBooks Point of Sale solution for small retailers, professional tax solutions ProSeries and Lacerte, and the Web-based corporate workgroup productivity solution QuickBase.
The new siebel application is to simplify the business and to enhance the customer experience.

Responsibilities:

• Leading the team of 5 EIM Developer and coordinating with offshore team.
• Interacting with business for getting the requirement for data migration activity.
• Involved in gap analysis between new siebel system and legacy system for data migration activity.
• Reviewed and analyzed the application requirements & legacy system.
• Responsible for handling data migration for implementing Multi Org model.
• Created End to End mapping sheets.
• Performed Data Mapping, Bulk imports of data in the Siebel database using EIM.
• Designed Bulk data import strategy.
• Creating and modifying configuration (ifb) files to run the EIM import process to populate the base tables in optimal manner.
• Involved in Data quality activities.
• Involved in data migration script optimization techniques.
• Involved in the analyzing, planning and execution of data transfer from legacy systems.
• Designing the data cleansing logic at the Staging table level while loading the data into EIM tables.
• Involved in loading different entities into Siebel base tables.
• 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.
• Involved in automation of EIM loads using UNIX shell scripts.

Project: Confidential - Public Prosecution System - A
Role: Siebel EIM Lead
Period: July 2011 - Jan 2012

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

Confidential is embarking on an era of modernization to ensure justice that fosters citizens\' and residents\' rights, promotes equality and ensures security as well as socio-economic development. Confidential supervises and coordinates the primary legal and judicial mechanisms and processes that protect individual rights and safeguard the rule of law through a tri-tiered court system, Court of Cassation, Court of Appeals, Courts of First Instance.
In addition, the Department's service divisions such as Fatwa, Attestations, Notary Public, Family Guidance, Reconciliation and Settlement Committees, as well as specialized courts work concurrently to ensure the administration of justice in the Emirate. Each court is managed by a Court President and supported by dedicated judges and administrative staff. An efficient and independent judicial system based on excellence that provides world class judicial services.

Responsibilities:

• Understanding the legacy system based on requirements and structuring the siebel Data model.
• Involved In analyzing the legacy system and mapping the entities between legacy system and siebel system.
• Involved In identifying strategy for loading the data from legacy system to siebel system.
• Designing the staging area structure for capturing the extracted business data from the legacy system.
• Loading the data from legacy system to staging table using the extraction logic and transfer of data to siebel interface table through SQL.
• 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.
• Designing the data cleansing logic at the Staging table level while loading the data into EIM tables.
• Reviewed and analyzed the application requirements & legacy system.
• Involved in loading different entities into Siebel base tables (Case, Incident, Interrogation, Order, Contact, Address, Hearing Session, Account)
• Designed Bulk data import strategy.
• 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.
• Involved in shell script creation for automating the Bulk data import process.

Project: Confidential, Rochester (NY), USA
Role: Sr. Siebel EIM Consultant.
Duration: Dec 2010 to June2011

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

Confidential, headquartered in Rochester, NY, is part of a $4 billion family of companies that finances and delivers health care services across upstate New York and long-term care insurance nationwide. Confidential maintains a strong local presence through four regional headquarters. Excellus EHP is undergoing a business transformation that will include changes in people, process and technology. This transformation includes 1) simplifying the business and 2) enhancing the customer experience. This Application replaced customer's housekeeping application with Siebel Financial Services. This application primarily used for maintaining the details of Groups, Brokers, Contacts, Activities, Opportunities and Products & Packages

Responsibilities

• Loading Data from legacy system to staging tables through ETL (Informatica) tool and transfer of data to Interface tables through SQL.
• 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.

Project: Confidential (Tucson, USA)
Role: Siebel Data Consultant
Duration: Feb 2009 to Dec 2010.

Environmental Tool: Siebel 8.1, PL/SQL, SQL Server 2005

Confidential is currently in the process of implementing enterprise Customer Relationship Management (CRM) system in multiple phases to support their Insurance Health Plan Business units such as Sales & Marketing, Member & Provider Services, Medical Management, Grievances & Appeals, Quality Management, IT Service Management, and Compliance & Finance.

Confidential is undergoing a business transformation that will include changes in people, process and technology. In order for Confidential to enhance the customer experience and be able to track processed requests, UPH has selected Siebel as the application platform that can quickly and efficiently create and build a system to meet their business objectives of simplification and enhanced customer experience.

They key objectives of the Siebel CRM Installation project are

• To move the business transformation faster and better
• To simplify UPH business and enhance UPH performance
• To assist UPH in retaining and servicing their valued customers

The implemented solution includes the Members, Claims, Compliance, Grievance and Appeals departments. Enhanced function to support the future state end to end processes of Siebel CRM include UPH Sales and Medical Management. The integrations include IDX, Oracle Data Warehouse and Avidity.

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.

Project: Confidential, Atlanta GA
Role: Data Consultant
Duration: June. 2008 - Jan 2009

Environmental Tool: Siebel 7.5.2, Siebel Call Center, DB2, IBM Mainframe, Siebel EIM, Siebel Tools

Responsibilities:

• Worked on a Pilot Implementation of Siebel covering the Flooring Department
• Worked on the Data Conversion of Organization, Associates, Service Provider, Product Supplier and Products
• Developed Mapping Document from Legacy to Siebel
• Developed IFBs to load Organization, Associates, Products data
• Ran the EIM process to move data from Interface tables into Siebel base tables
• Performance monitored the data load in order to handle huge data loads
• Heavily involved in Schema changes to Siebel using Siebel Tools
• Created Custom tables and Custom columns in order to support additional functionality

Project: Confidential - CA
Role: Offshore Siebel Consultant
Duration: July '07 to May'08

Environmental Tools: Siebel 7.8.2 PRM, Oracle 10g, TOAD and Windows XP, SQL Loader, Toad, SQL, PL/SQL

Responsibilities:

• Involved in preparation of technical design documents for data migration.
• Created IFB's for executing various EIM Processes.
• Responsible for Importing from the legacy system using EIM in the Development Server.
• Worked with Enterprise Integration Manager (EIM) to import external data to Siebel database - Loading data into interface tables and importing from Interface Tables into Siebel.
• Worked with Tools to customize Siebel Objects and UI to meet requirements.
• Have experience in extending columns on the Siebel Database layer.
• Analyzing and mapping legacy system fields with Siebel Interface tables for running EIM.
• Loaded data into EIM tables using SQL Loader and ran EIM tasks to load data into Siebel base tables.
• Created PL/SQL Stored Procedures, Packages to implement requirements.
• Loaded 2 digit and 4 digit Industry type code.
• Imported Products, Subscription lists, MRA Prospects, Accounts, Contacts & Opt out email.
• Created Workflow to export Contacts & Partners to the docent system.
• Responsible for writing queries in SQL and performance tuning SQL statements while extracting the data from Oracle.

Project: Confidential
Role: Offshore Siebel Configurator
Duration: May 06' - June 07'

Environmental Tools: Siebel eCommunications 7.5.2, Microsoft SQL Server, Win 2K.

Responsibilities:

• Designed and Developed the UI layer using Applets, Controls, Assignment of Applets to view and views to screen.
• Created and configured the applets, views as application required.
• Created and customized the Pick lists needed for the application.
• Created and customized the Joins and links.
• Data Layer changes like extending database table columns and applying the changes.
• Customized the drilldowns on the fields as business needed.
• Created Predefined SQL Queries.
• Created and configured the Multi Value Links, Multi Value Groups, and Multi Value Fields.
• Customized the UI layer, applets, views, and screen.

Project: Confidential
Product: Real Time Liquidity Manager
Role: Developer
Duration: Sep 2005 to April 2006.

Environmental Tool: PL/SQL, SQL, Oracle9i & 10g, JDK1.4, JSP, JDBC, Java Script, Tomcat4, Eclipse 3.2.

An Confidential payment system is one in which payment instructions between banks are processed and settled individually and continuously throughout the day. With the introduction of Confidential in India for local currency, intra-day liquidity management has become an operational imperative for banks that participate in Confidential. The job of the Liquidity Manager is to ensure sufficient intra-day funding of the Confidential Settlement Account and the RBI Current Accounts. For this, he would need to be aware of the real time balances in these accounts. RLM is a tool for the Liquidity Manager

Client: Confidential, India.

Responsibilities

• Involved in database PL/SQL programming
• Simulation of Issues Reported by client
• Bug fixing, development and testing.
• Coordinating with Client for reviewing and closing of the issues raised by them.

Project: Confidential
Product: MIRROR
Role: Developer
Duration: July 2005 to August 2005.

Environmental Tool: PL/SQL, SQL, Oracle 9i , JDK 1.4, JSP, JDBC, JavaScript, Jakarta Tomcat4.0.3

Mirror is a product that automates the reconciliation functions of a financial organization or a bank and is intended primarily for Nostro Reconciliation, Mirror caters to the overall functions, Maintenance of Internal and External Data Transactions, Matching Logic, External Data Interface, Reporting functions and Reconciliation Management tasks. Reconciliation System is based on future-oriented Web technology, modern n-tier architecture, and extremely flexible JSP middleware. The application can be accessed via conventional Web browsers (IE 5 and above).

Clients Indian Clients: Confidential
Over sea's Clients: Confidential

Responsibilities

• Involved in database PL/SQL programming
• Involved in Performance Tuning of complex SQL queries for customer reports.
• Development of new enhancements.
• Resolving issues/customizations raised by them on priority basis.
• Training the clients for the new enhancements customized
• Support day to day issues raised by the clients
• Coordination with clients for weekly status meeting and keep them up to date about the progress of the deliverables.