PROFILE

• 9 years of extensive experience in IT. 6 years of extensive Siebel CRM full cycle application implementation.
• Expert in Configuration of user Interface layer, Business Object layer and Data Layer
• Extensive experience in Siebel eAutomative eConsumer, eCommunications, eFinance, and Telecommunications industry knowledge experience.
• Data Migration complete end to end process from Siebel to Salesforce.com
• Proficient in Siebel Tools configuration, eScript, ,Enterprise Integration Manager EIM .
• Experienced in handling data migration/batch process integration using EIM and debugging EIM errors
• Ability to translate business requirements in to functional/technical specifications
• Ability to understand business requirements and create data mapping documents for reviews and approvals
• Ability to understand business requirements and create Non functional integration requirement document.
• Provide contribution knowledge and effort on creating Functional Specifications documents, based on requirements
• Extensive Knowledge of Siebel Order Management with Product Configuration, Attribute Adjustment as part of customization
• Functional Knowledge of Siebel Product ,Order Management and Sales Process
• Handled the team of L2/L3 in production support.
• Application support for L2/L3 incidents related to concerned applications as per the defined SLAs
• Extensive training in ETL tool OWB 10.2 from Oracle University.
• Salesforce.com Certified Force.com Developer SP12
• Trained in Interpersonal Skills, Personal Presentation, Problem Solving Decision Making, Effective Time Management and Expressing Assertively.
• Effective communication, presentation skills and ability to interact with users and technical team.

TECHNICAL SKILLS

• Applications Siebel 8.1/7.8/7.7.2.8//7.5 Tools, Configuration, Product Administration,EAI,EIM
• CRM Siebel Automotive, eConsumer, eCommunication, eConfiguration, eFinance, Sales, Call Centre
• Operating Systems WIN 2000, WIN NT SERVER , Windows 2003 Server, WIN XP
• Data Base Oracle 11,10G, 9I, SQL Server 2000
• Domain Telecom, Oil Gas, Health Care, Finance
• ETL Informatica 8.6, OWB 10.2
• BI QlikView 9.1
• Languages C , JAVA, SQL, VB, Siebel eSCRIPT, PLC programming
• Version Control WinCVS 2.0,VSS

PROJECT EXPERIENCE

Confidential

Application: Siebel eFinance 7.7.2.12, Sales Force.com

Role: Sr.Data Integration and CRM consultant

Responsibilities

• End-to-end expertise in Siebel-to-SFDC Data-Migration
• Siebel-to-SFDC System Field Mapping
• Siebel View creation and optimization
• SFDC Load file creation
• Data migration SIT/ UAT conduction and issue resolution
• Involved in analysis, gathering requirements for the High Level design.
• Performed gap analysis and drafting the Technical Design documents from the Functional Requirements provided by the Business Team.
• Data Migration complete end to end process from Siebel to Salesforce.com
• Implementation of LOV's, Activity Plans Pick Lists and Business Component User properties to achieve the client business functionality
• Estimated Time Efforts for completion of implementing
• Created .ifb files for the Used the shell Process for creating the ifb files .
• Extract the data to EIM Tables and run the EIM Task to load the data into Siebel Base tables.
• Developed new functionality scripts or modified existing scripts for data conversion and loaded bulk data into Siebel applications using EIM.
• Modified the Batch Execution processes for executing the steps for importing data from the External database to EIM tables and then kick-off EIM tasks to load Siebel DB based on the business request.
• Debugged the Log file for fixing the Errors and Post import analysis for errors and rejects and re-importing.

Environment: Siebel 7.7.2.12 eFinance, Oracle 11.Siebel EIM, Assigment Manager,Sales force.com, Rapid SQL, Unix

Confidential

Application: Siebel eFinance 7.7.2.8, Sales Force.com

Role: Sr.Siebel Integration ETL

Responsibilities

• Oracle upgrade 10g to 11 repository migration in Informatica.
• Modified the existing XML definition source in the power centre based of the business requirements
• Developed ETL mapping by using different transformation to populate the data into Siebel application.
• Converting legacy data from multiple sites into the Oracle Interface or custom staging tables as per the Functional Design Documents
• Validating and test the Informatica mapplets/mappings for desired functionality.
• Debugging and fixing existing Informatica jobs
• Created Test cases for unit, integration and unit and functional testing and finding out whether the output of the mappings and stored procedures matches the expected results
• Consulting and resolving data issues with business teams and leaders across North America.
• Designed and developed the complete flow of the data transformation based on the requirements.
• Data Masking specialist provided the enterprise security fields.
• Developed ETL mapping by using different transformation to populate the data into Siebel application.
• Dedicated to Implementing Oracle's Data Masking product with specific experience in an Oracle environment.
• Supporting current security and compliance activities for Oracle databases in a PeopleSoft HRMS and Financials application environment.
• Participating in periodic evaluations of database security with established baselines that are in-scope for masking the fields. Supporting and developing Data Discovery techniques to detect sensitive data.
• Identifying sensitive/regulated data Selecting delivered Data Masking format libraries Creating custom data masking format libraries Establishing column to mask relationships Generating and executing data masking scripts Testing and Validation Implementation and verification
• Masking product in Seibel CRM environment, Oracle 11gR2.
• Lead the complete project of data masking by using Siebel EIM, which includes the complete process of export, import
• Primary resource for EIM mapping key entities.
• Unix Shell scripting to integrate batch load jobs
• Prepared IFB scripts for the EIM Process.
• Exporting and importing the data from base tables to interface table,transferring the data back to base tables through EIM jobs
• Developed custom objects, triggers and workflows.
• Interacted with customer operations managers to identify issues and potential areas for improvements to existing applications.
• Translated business requirements to smart solutions in Salesforce.com.
• Prepared technical approach and design documentation supporting business needs.

Environment: Siebel 7.7.2.8 eFinance, Oracle 11.Siebel EIM, Informatica 8.6,Sales force.com, Rapid SQL, Unix

Confidential

Application: Siebel Automotive 8.0.0.10

Role: Siebel Integration

Responsibilities

• Performed optimization and stabilization of Financial Accounts and Service Requests
• Developed Siebel Workflows and Web Services for Integration with Day Break and Lease Pak
• Performed optimization and stabilization of Financial Accounts and Service Requests
• Performed Integration with Day Break and Lease Pak by using web services.
• Defined and designed Error Handling approach
• Developed interfaces for creating conditions in Day Break and Lease Pak
• Involved in resolving issues related to integration in Production.
• Migrated legacy data to Siebel application using EIM
• Performed EIM Automation for daily delta load

Environment: Siebel 8.1 eAutomative, Oracle 10.1.2, Siebel EIM, Siebel eScript ,Informatica 8.6

Confidential

Role: Siebel eConfigurator

Responsibilities

• Configured Siebel Product with Attribute, Class, and Constraints based rule set on business requirement
• Understood the business requirements and designed, and Siebel for entities like Opportunities, Products, and Orders etc
• Configured the product hierarchies, product models, product classes their attributes
• Written Rules based on the Product Configuration for the attributes
• Configuring building the product models and hierarchies in the Siebel application
• Building the required Quotes and Orders Quote to order process
• Validation of Quote Orders
• Configuring/customizing the Siebel application based on requirements
• Export and Import process in Siebel Business Administration for Customizing Products for different environments.

Environment: Windows XP Siebel 7.5.2, Toad, Edit plus, Oracle 9i

Confidential

Role:Siebel Developer Informatica 8.6 Control Systems Engineer

Responsibilities

• Established Responsibilities and assigned the views to various users based on visibility.
• Created Outbound and Inbound Web Services for facilitating Real-Time integration
• with these interfaces.
• Involved in defining the Error Handling based on entity business needs.
• Configured Workflows, Business Services and Business components
• Represent Users in gathering requirements and prioritize
• Migrated legacy data to Siebel application using EIM
• Perform unit testing at various levels of the ETL.
• Developed and implemented the coding of Informatica Mapping for the different stages of ETL.
• Fixed the invalid mapping's and troubleshoot the technical problems of the database.
• Debug the sessions by utilizing the logs of the sessions
• Proficient in designing and developing the various transformation logics by utilizing the expression, filter, joiner, lookup, router, aggregator, stored procedures, rank, normalization.
• Developed and implemented the coding of Informatica Mapping for the different stages of ETL.
• Fixed the invalid mapping's and troubleshoot the technical problems of the database.
• Debug the sessions by utilizing the logs of the sessions
• Proficient in designing and developing the various transformation logics by utilizing the expression, filter, joiner, lookup, router, aggregator, stored procedures, and rank
• Created Integration Objects and mapping between IO and Business Layer.

Environment: Windows XP Siebel 8.0 Informatica 8.6, Toad, Oracle 10g.

Confidential

Application: eCommunications

Role: Siebel configurator

Responsibilities

• Analyzing the huge functionality of One View as fault may come up in any stream and to provide quick fix based on the severity and priority of the faults.
• Configuring building the product models and hierarchies in the Siebel application
• Building the required Quotes and Orders Quote to order process
• Responsible for Production Bug fixes and any In Life Changes in Production environment.
• Investigating and correcting Data Issues through EIM.
• Configured the IFB file and invoked the EIM process
• Configuring Siebel Components through UI/ Server Manager Utility.
• Troubleshooting and resolving performance issues with the Siebel platform

Environment: Windows 2000, Siebel tools 7.8, Oracle 8.x, PL/SQL 2.3.4, Toad

Confidential

Application: eConusmer

Role: Siebel Configurator

Responsibilities

• Configuration of Siebel Consumer TPM Sector Application to support the client's business requirements using Siebel Tools
• Onsite Coordination with UK Clients to clarify the function requirements and technical feasibilities
• Responsible for handling the issue from development QA to production.
• Debugging the application and fixing the solution in appropriate environments.
• Understanding and modifying existing scripts as per requirements.

Environment: Windows 2000, Siebel 7.5.2, Oracle 8.x, SQL PLUS 8, Toad

Confidential

Development and Deployment of Virtual Showroom using Distributed Web Windows Application Jun 03 Aug 04

Role : Programmer

• Creation of order form includes order entry system, dynamic product selection, auto product code generation and add-on features etc.
• To create and design distributed web applications that depict a Virtual Showroom
• The project scope also includes managing plsql procedures for achieving business constraints through complete database functionality.