PERSONAL PROFILE:

• An extremely capable individual who adopts a 'can do' approach to work solutions.
• Has developed a key ability in negotiating and understanding user requirements of an IT solution, together with developing processes (both system and business) to deliver the requirements.
• Have been involved in the IT sector for over 12 years and worked as a CRM Siebel Consultant at a large Indian software company for the past 5 years in which have mainly worked within system study, design and development teams.
• During my career I have gained dynamic experience in the full project lifecycle especially in Siebel Configuration, Data migration and Data Analysis. I have dynamic operational experience in Siebel Project Management, Siebel Configuration, Siebel Data Migration Expert, Data Analysts and Database Designer.
• 12+ Years of IT experience with dynamic knowledge and fundamentals of RDBMS, Client Server Concepts, Data Modeling, Operating System and CRM packages.
• 6+ Year of elegant experience as a Siebel Consultant using Siebel 8 / Siebel 7.5.3 Industry Applications.
• Experience in Siebel Call Center, Siebel ePharma, Siebel eCommunication, Siebel ePublic Sector and Siebel eFinance.
• Elegant work experience as a Siebel Project Manager / Siebel Configuration / EIM Configuration Analyst / Data Analysts in various Siebel Industry Applications implementation.
• Onsite experience in different projects in Germany, Australia, UK and USA.
• Having dynamic onsite work experience in Siebel 8 ePublic Sector, Siebel 7.5.3 Call Center and Siebel 7.5.3 eCommunication application implementation.
• Having experience in Siebel 7.5.3 ePharma and Siebel 7.5.3 eFinance Applications implementation
• Having experience of creating the High level design and low level design documents for the functionality related to Siebel Configuration.
• Leading Siebel Project team in designing and delivering a Siebel solution & responsible for all aspects of managing the Siebel project including scope, cost, schedule and deliverables and has regular interaction with client leadership.
• Having experience of Design and implementation of joins, Links and MVG’s, Pick Lists, Drilldown Applets for business objects and business components.
• Dynamic experience in Analysis and preparing data migration design document for UI Mapping, Database Mapping and Business Requirement Mapping.
• Wide range of experience in database development, Stored Procedures and Functions in both Oracle 9i / 8i and MS SQL Server 7 / 2000 using PL/SQL and TSQL respectively.
• Simultaneously 3 years of experience in Data Modeling / Database Design using SML tool ‘Erwin’.

TECHNICAL SKILLS PROFILE:

Operating System: Windows NT, Windows 2000, Linux and SUN Solaris

Languages: SQL, PL/SQL and T - SQL

Database: Oracle 9i / 8i, MS SQL Server 2000 / 7.0, MS Access and MySQL

CRM Application & Tools: Siebel 8 ePublic Sector, Siebel 7.5.3 eCommunicationSiebel 7.5.3 ePharma, Siebel 7.5.3 eFinance, Siebel eAutomotiveSiebel Call Center, Siebel Assignment manager, Siebel EIM and

Siebel Tool and Siebel Client:

Database Design/Case Tool: Erwin 4.1, Case Studio 2.0

Data Warehouse: Informatica, Business Objects

Tools: MS Office, MS Project, MS Visio

PROFESSIONAL EXPERIENCE:

Confidential, New Jersey

CRM Project Manager

Responsibilities:

• Leading the project team in designing and delivering a Siebel solution.
• Responsible for all aspects of managing the Siebel project including scope, cost, schedule and deliverables and has regular interaction with client leadership.
• Manages all onsite and offshore project resources
• Include full lifecycle participation in Siebel engagements as a project manager, methodologies, familiarity with Siebel architecture and depth of knowledge of Siebel functionality.

Environment: Oracle 9i / Sun Solaris - SQL & PL/SQL, Siebel 7.8 ePharm, Siebel Analytics

Confidential, New York

Siebel Developer & Data Migration Consultant

Responsibilities:

• Configuration of Siebel ePublic Sector 8.0 Application using Siebel tools 8.0
• Responsible for creating the High level design and low level design documents for the functionality related to configuration.
• Design and implementation of joins, Links and MVG’s, Pick Lists, Drilldown Applets for business objects and business components.
• Analysis and approve data migration design document for UI Mapping, Database Mapping and Business Requirement Mapping.
• Involved in development of SQL, PL/SQL Procedures to extract the data from Legacy database to staging database and staging database to Siebel EIM tables to populate the Siebel Base tables.
• Supporting Interface related issues which involves EIM, Data Load-Import & Export to Siebel Database.
• Mapping legacy data to Siebel EIM Interface table for import into the Siebel database, EIM Server Task to import data from an EIM interface table.
• Analyzing and problem solving the issue tickets raised by the client, identify the issue and provide the solution with the SLA

Environment: Oracle 9i / Sun Solaris - SQL & PL/SQL, Siebel 8 ePublic Sector

Confidential

Data Migration Release Manager

Responsibilities:

• Analysis and approve data migration design document for UI Mapping, Database Mapping and Business Requirement Mapping.
• Developed of SQL, PL/SQL Procedures to extract the data from Legacy database to staging database and staging database to Siebel EIM tables to populate the Siebel Base tables.
• Involved in business meeting and coordinate with development team.

Environment: Oracle 9i / Sun Solaris - SQL&PL/SQL, MS Access - Siebel eMedia

Confidential

Siebel Developer & EIM Analyst

Responsibilities:

• Responsible for creating the High level design and low level design documents for the functionality related to configuration.
• Configuration of Siebel Call Center 7.5.3 Application using Siebel tools 7.5.3 in multi lingual support.
• Design and implementation of joins, Links and MVG’s, Pick Lists, Drilldown Applets for business objects and business components.
• Maintaining LOVs and Running the Admin task like creating Siebel users, responsibility and role in multilingual organization structure for multi European language.
• Developed document for UI Mapping, Database Mapping and Business Requirement Mapping for Data Migration through EIM.
• Developed PL/SQL Procedures to extract the data from Legacy database to staging database and staging database to Siebel EIM tables to populate the Siebel Base tables.
• Imported 11 European Call Center data and attachments into Siebel application Database.
• Lead Offshore Siebel development team from Ford Development center, India.
• Analyzing and problem solving the issue tickets raised by the client, identify the issue and provide the solution with the SLA

Environment: Oracle 9i / Sun Solaris - SQL&PL/SQL, SQL*Loader - Siebel eAutomotive Call Center

Confidential

Siebel EIM Configuration Analyst

Responsibilities:

• Involved in preparing document for UI Mapping, Database Mapping and Business Requirement Mapping.
• Mapping legacy data to Siebel EIM Interface table for import into the Siebel database, EIM Server Task to import data from an EIM interface table.
• Developed Oracle Control file to extract data from input DAT file and XML files using custom XML Parser.
• Developed PL/SQL Procedures to extract the data from Legacy database to staging database and staging database to Siebel EIM tables to populate the Siebel Base tables.
• Developed IFB files and execute EIM admin schedule tasks.

Environment: Oracle 9i / Sun Solaris - SQL&PL/SQL, SQL*Loader - Siebel eFinance 7.52

Confidential, Philadelphia, PA

Siebel EIM Configuration Analyst

Responsibilities:

• Involved in preparing document for UI Mapping, Database Mapping and Business Requirement Mapping.
• Involved in data migration from flat files to EIM tables using MS SQL Server DTS process.
• Involved in developing T-SQL scripts and DTS Packages, which populate the data in a specific format and send them to report generation applications.
• Involved in creating Database users and assign role to them in ODC environment.
• Involved in backup and restoration of Siebel database in ODC environment.
• Involved in EIM process by using custom IFB files for importing data
• Preparing ‘EIM Run Book’

Environment: MS SQL Server 2000/Windows 2000 Server - SQL&TSQL - Siebel eFinance 7.52

Confidential

Siebel EIM / Data Migration Consultant

Responsibilities:

• Involved in Data Mapping between Legacy and Siebel Tables.
• Involved in development of Oracle Control file to extract data from flat files.
• Involved in development of PL/SQL Procedures to extract the data from Legacy database to staging database and staging database to Siebel EIM tables to populate the Siebel Base tables.
• Involved in developing PL/SQL scripts and Oracle UTL Packages, which populate the data in a specific format and send them to report generation applications.
• Involved in EIM process by using custom IFB files for importing data.
• Involved in creating Database users and assign role to them in development and testing environments.
• Involved in backup and restoration of Siebel database in development and testing environments.
• Involved in database activities in development and testing environments.

Environment: Oracle 9i / Sun Solaris - SQL&PL/SQL, SQL*Loader - Siebel 7.5.3 eCommunication

Confidential

Siebel EIM / Data Migration Consultant

Responsibilities:

• Involved in data Migration from MS Access to MS SQL Server 2000 through DTS.
• Involved in developing T-SQL scripts and DTS Packages, which populate the data to staging tables and staging tables to Siebel EIM tables to populate the Siebel Base tables.
• Involved in creating Database users and assign role to them in development and testing environments.
• Involved in backup and restoration of Siebel database in development and testing environments.
• Involved in database activities in development and testing environments.

Environment: Oracle 9i / Sun Solaris - SQL&PL/SQL, SQL*Loader - Siebel 7.5.3 ePharma Application