SUMMARY

• 10 years of extensive experience in IT. 7+ years of extensiveCRM(Siebel,Salesforce)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
• Implement, and manage multi - channel CRM technical solutions designed to meet business and customer requirements
• Enhance and maintain implementation of Salesforce Service and Sales cloud, Dashboard and any custom objects etc.
• Implement new enhancements including creation of custom objects, workflows, Visual Flow, Page layouts, email alerts and templates, and datavalidation,triggersand test classes;
• Data management through data loader
• Demonstrated ability to effectively communicate technical issues and resolve problems at all levels of the organization both internally and externally
• Train new and existing users on how to use Salesforcesystem features and processes;
• Logging and tracking identified system problems through resolution
• Participate in cross-functional teams that address strategic business issues involving CRM and sales operations
• Experienced in implementing Siebel Open UI and UI customization
• Knowledge of Siebel Open UI architecture
• 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
• Porting the Siebel servers with TNT drive and Amazon S3 drive for Siebel attachments
• Functional Knowledge ofSiebel 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 toolOWB10.2 fromOracle University.
• Salesforce.com Certified Force.com Administrator (WI16)License 4729006
• 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,CallCentre

Operating Sys: 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, 9.6.1 OWB 10.2

BI: QlikView 9.1

Languages: C++, JAVA, SQL, VB, Siebel eSCRIPT, PLC programming

Version Control: WinCVS 2.0,VSS

PROFESSIONAL EXPERIENCE

Confidential, San Jose, CA

Sr.Data Integration and CRM consultant

Responsibilities:

• Data Migration - Data extraction from Siebel CRM to Salesforce CRM.
• Involved in requirement gathering, data analysis, data cleansing and feasibility study
• Developed SQL and PL-SQL code to extract data from Siebel as per the business requirement
• Migrated data from Siebel to Salesforce using Informatica power center
• Worked on Informatica to develop ETL mapping and transformations
• Worked on Salesforce Apex data loader to load data into SFDC
• Preparation of project documents, Summary and status reports
• Worked on data mapping sheets to map Siebel fields to SFDC fields
• Designed Data insert /update and upsert logic while moving data to salesforce
• Worked on Siebel EIM to update existing data in Siebel
• Defect tracking and bug fixing
• Data cleansing on Account, Contacts and address
• Developed scripts to adjust data model changes between source and target system
• Troubleshooting issues related to Siebel and Sales force migration and database issues.
• Estimated Time Efforts for completion of implementing
• Porting the Siebel servers with TNT drive and Amazon S3 drive for Siebel attachments.

Environment: Siebel 8.1.1.11Call center, Oracle11, Salesforce.com,SQL tools1.5, TNT drive 3.5.3Amazon S3,Informatica 9.6.1

Confidential, Nashville, TN

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
• Creating and maintaining documentation on processes, policies,application configuration and help related materials for users asSalesforce applications are developed.
• Lead / Assist with user requirement sessions and document user requirements to address changing business needs
• Contribute on the technical side of business projects and create solutions to meet challenges (including performing detailed analysis of technical and business requirements)
• Ability to work independently and engage supervisor as needed.Ability to handle full workload and meet proposed deadlines.
• Regularly assess CRM applications and tools to identify and implement efficiencies and potential opportunities for improvement.
• 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 PlansPick 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.12eFinance, Oracle 11, Salesforce.com, Rapid SQL, Unix

Confidential, Irvine, CA

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 Informaticamapplets/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, Irvine, CA

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, Sunnyvale,CA

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, Houston, TX

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

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 

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