SUMMARY

• 10 Years of overall software experience with around 6 years in Siebel involving implementation of Siebel 7x/Call Center/ Sales/ ePharma/ Financial Services/eservices/MDM
• Expertise in solution design and implementation on Siebel UCM/Tools/ Configuration/ eScript/ Workflow/ EIM/EAI/Assignment Manager.
• Experience in testing integration solutions for Data import, Export and Migration using EIM and EAI, Business Services, Workflow processes, Workflow policies.
• Experience in application development in CRM domain with Health Care, Banking and Financial Services industries.
• Proficient in Data mapping and Gap Analysis for the client requirement.
• Strong knowledge on Siebel Data Model and Performed Data Mapping between Siebel and External Systems.
• Experience in Business Intelligence tool and Data warehousing experience using Siebel Analytics and Informatica.
• Experience in UNIX shell scripts and Administration of Linux based Siebel Enterprise Servers.
• Knowledge in various Informatica Transformations and Mappings.
• Knowledge of Java, Oracle WebLogic Server, SOA and Web Services XML Technologies.
• Coordinate with offshore by scheduling weekly calls.
• Looking for challenging Siebel Implementation/support position.

TECHNICAL SKILLS

• Siebel Applications Siebel Financial Services, Siebel Call Center, Siebel EPharma
• Siebel Development Tools Siebel Tools 6.3/7.0/7.7/7.8/8.0
• Siebel Modules Order Management, Asset Management, Opportunity Management, Siebel UCM MDM
• Siebel Technologies Siebel VB, Siebel eScript, Siebel Work Flows, Siebel EAI
• Programming Languages Java, Java Script, Visual Basic 6.0, VB .NET
• Databases Tools Oracle 8i/9i/10g, MS SQL Server 2000, TOAD
• Operating Systems Windows 95/98/NT/2000/XP,Solaris9
• Testing Tools Mercury Test Director 7.x, Mercury Load Runner 8.1
• Reporting Tools Cognos
• ETL Tools Informatica, Data Stage
• Web Technologies HTML, JSP, Servlet, EJB and XML
• Other Tools Visual InterDev 6.0, Remedy, Clarify, MS Office 2000, IBM MQ Series, Altova XMLSpy, .Net Web Services

EXPERIENCE SUMMARY

Confidential

Responsibilities:

• Prepare Functional Design Document Technical Design Document to meet the Business requirements
• Configured Siebel UCM application to tailor it according to the Business requirements.
• Create and modify business objects, applets, views, screens, and adapt business components, fields, joins, links, business component user properties, drilldowns, and visibility configuration using Siebel Tools.
• Design EIM configuration files to load data from staging to SDH tables.
• Prepare Batch scripts using PL/SQL procedures for transferring data from Siebel tables to external legacy systems.
• Implement matching and survivorship rules and configure universal connector for data quality, merge/unmerge
• Load Contacts and Account from Open Lane, COSMOS into Siebel UCM application.
• Configured EAI web services for external application to view and updating Resyncing BAN from SAMSON source to Siebel.
• Created pl/sql procedure for initial loads and load data from external table to Siebel.
• Configure JMS queues for sending data from siebel external SAMSON system.

Environment: Siebel UCM 8.1, Oracle 10g/11g, JMS, Informatica 9.5.1, Oracle Enterprise Data Quality, UNIX

Confidential

Responsibilities:

• Prepare Functional Design Document Technical Design Document to meet the Business requirements
• Configured Siebel UCM application to tailor it according to the Business requirements.
• Create and modify business objects, applets, views, screens, and adapt business components, fields, joins, links, business component user properties, drilldowns, and visibility configuration using Siebel Tools.
• Configure UCM survivorship rules according to client requirement to eliminate duplicates.
• Design EIM configuration files to load data from staging to SDH tables.
• Prepare Batch scripts using PL/SQL procedures for transferring data from Siebel tables to external legacy systems.
• Implement matching and survivorship rules and configure universal connector for data quality, merge/unmerge
• Load Contacts and Account from Open Lane, COSMOS into Siebel UCM application.
• Configured EAI web services for external application to view and updating the policy in Siebel UCM application.

Environment: Siebel UCM 8.1, Oracle 10g/11g, Informatica 9.5.1, Oracle Enterprise Data Quality, UNIX

Confidential

Responsibilities:

• Prepare Functional Design Document Technical Design Document to meet the Business requirements
• Create and modify business objects, applets, views, screens, and adapt business components, fields, joins, links, business component user properties, drilldowns, and visibility configuration using Siebel Tools.
• Load Contacts, Accounts and from different sources into Siebel UCM application.
• Configured Siebel UCM application to tailor it according to the Business requirements.
• Configured the inbound EAI web services for external application to view and update the data in Siebel UCM application.
• Prepare Batch scripts using PL/SQL procedures for transferring data from Siebel tables to external legacy systems.
• Created PL/SQL Procedures to Validate and Massage data before loading them into Siebel EIM Tables
• Experience in Creating OBIEE Metadata Repository in three layers like physical, BMM and Presentation Layers.
• Worked on MDM principles provided by Siebel UCM to maintain the master data from different sources.
• Used the MDM principles like survivorship rules to maintain the golden record.

Environment: Siebel UCM, Siebel Tools 8.1, Oracle 10g, 11g, Informatica 8, Oracle Data Quality, IIR, UNIX

Confidential

Responsibilities:

• Prepare Functional Design Document Technical Design Document to meet the Business requirements
• Configured Siebel UCM application to tailor it according to the Business requirements.
• Create and modify business objects, applets, views, screens, and adapt business components, fields, joins, links, business component user properties, drilldowns, and visibility configuration using Siebel Tools.
• Configure UCM survivorship rules according to client requirement to eliminate duplicates.
• Design EIM configuration files to load data from staging to SDH tables.
• Prepare Batch scripts using PL/SQL procedures for transferring data from Siebel tables to external legacy systems.
• Created PL/SQL Procedures to Validate and Massage data before loading them into Siebel EIM Tables
• Implement matching and survivorship rules and configure universal connector for data quality, merge/unmerge
• Load Contacts and Policies and from Customer-SQL into Siebel UCM application.
• Configured EAI web services for external application to view and updating the policy in Siebel UCM application.

Environment: Siebel UCM 8.1, Oracle 10g/11g, Informatica 8, Oracle Data Quality, IIR, UNIX

Confidential

Responsibilities:

• Prepare Functional Design Document Technical Design Document to meet the Business requirements
• Create and modify business objects, applets, views, screens, and adapt business components, fields, joins, links, business component user properties, drilldowns, and visibility configuration using Siebel Tools.
• Configured Clinical Trip Report, Site Management, and Monitoring Reports functionality.
• Configure Siebel Application by Creating Business Component User Properties and Field User Properties.
• Created PL/SQL Procedures to Validate and Massage data before loading them into Siebel EIM Tables.
• Load users, Studies, Monitoring Data in Excel sheet using Siebel VB.
• Configured Pre default and post default values in proposal Templates.
• Configured State Model to hide LOV's based on responsibility.
• Configure SAP Customer and Vendor Integration to enable CTMS application to display customer and Vendor information.
• Configure Runtime events to restrict delete of Study and region based on the Responsibilities.
• Assign delete Privilege for Super users based on Responsibilities.

Environment: Siebel eClinical, Siebel Tools 7.8, Oracle 9i, MQ Series, HP UNIX

Confidential

Responsibilities:

• Prepare Functional Design Document Technical Design Document to meet the Business requirements
• Create Workflow Process and Polices for creating Activities and automatically inform Service Request Owner that Change Request has been updated.
• Experience working in Call Center application handling Service Request, Activities and Billing Invoice.
• Prepare Batch scripts using PL/SQL procedures for transferring data from Siebel tables to external legacy systems.
• Coordinate with offshore team by scheduling calls and getting updates.
• Account Management is done based on user request to add, modify and inactivate their profile.
• Load Activity, Assets based on user request using EIM.
• Support the existing application for remote user who works remotely.
• Managing servers for sales and service applications and running Batch jobs.
• Application Services Interfaces as web services was implemented for synchronizing the accounts from external application with Siebel EAI.
• Write System test scripts that are run in Quality center for unit testing to move changes to production.

Environment: Siebel eServices, Siebel Marketing, Siebel Call Center 8.1, Siebel eMedical , Siebel Sales, Siebel Tools 7.8.2.3,8.0 Oracle 8i, 9i, 10g, Solaris 9,Informatica,OBIEE,SOA,WSDL.

Confidential

Responsibilities:

• Prepare Siebel upgrade driver and master ucf file and preparing the Schema files.
• Tune the upgrade scripts. Run the upgrade scripts for the PTE and QA environment.
• Analyze and tune the scripts and run in parallel degree avoiding dependencies.
• Perform the pre upgrade and post upgrade task for the production upgrade.
• Perform EIM table mapping and prepare EIM configuration files for data loading.
• Prepare the control files and loading data to the EIM tables and populate the respective base tables in the QA environment using the sql loader.
• Work on data conversion for loading legacy data in to Siebel.
• Load data for Account and Contact entity for development and production environment.
• Create EIM configuration files to load data from staging table to Siebel base tables.
• Customization of various Object definition using Tools.
• Create Internal and External IO for data mapping and getting data as the XML into the Siebel system.
• Create inbound web services for exposing the business services.
• Create data mapping using Data Mapper to map Siebel schema and external schema.
• Create VBC for exposing the external system data into the Siebel system.

Environment: Siebel Financial Services, Siebel Tools 7.8, C , Oracle 8i, 9i,10g, 11g,Informatica,UNIX

Confidential

Responsibilities:

• Administer and solve issues related to Siebel Communication session manager.
• Administer Siebel CTI Contact Center Application CCA .
• Deploying the Release in all the Environments which includes copying and installing the build, running DTT Data Transfer Tool for copying LOV's and PDQ's to the database, Workflow Deployment and activation. Product Model etc.
• Communicating with Developers/Testers to resolve issues and perform day-to-day operational support functions.
• Manages Siebel servers monitoring the logs and statistics reports, Maintaining Servers and Application stability in order to provide a reliable Siebel environment for Developers/Testers.
• Executing EIM Jobs like auto alert load files and number loading files
• Starting and shutting down the components.
• Installed Siebel Gateway Server, Siebel Enterprise Server, Siebel Database Server, Siebel, Server Siebel Tools Siebel Thin Client Siebel Dedicated Client.
• Installed and configured Microsoft IIS Web Server LDAP and configured the Siebel web extensions.
• Administration of Siebel Servers Report server LDAP and .COM application. Maintenance of the Siebel application by performing daily and weekly application maintenance tasks.
• Worked on the configuration of the communication adapters to interface with external communication profiles/servers.
• Resolve synchronization issues with remote users. Identify and resolve the issue of transaction task failure. Decode .dx files to identify the issue.

Environment: Siebel Sales, Siebel eservices, Siebel Call Center 7.8, Web Methods, Siebel Tools 7.8

Confidential

Responsibilities:

• Extensive involvement in the Assignment Manager part for creating the Assignment rules and tools configuration for the criteria's.
• Configure the Assignment rules based on the requirement of the client to assign the position candidates to the Opportunities.
• Define Assignment Rule, Criteria, and Positions for Assignment of Object to Positions.
• Create Customized Assignment Criteria, Attribute and Workflow Process Component using Siebel Tools.
• Run Assignment Manager in Batch and Dynamic mode.
• Design Business objects and modified Page Tabs, Screen Menus.
• Implement the Search Specification on Applet and Business Components for faster loading of Applet.
• Load Accounts, Contacts as initial data load after doing interface mapping.
• Perform Unit testing in Mercury test director to test the Siebel application.
• Design and develop workflow for the business logic according to client requirement.
• Custom Scripting at Business Comp level to achieve the specified functionalities.
• Create interface with MQ Series to receive data from the external system to Siebel system.
• Design and develop Siebel subsystem to invoke the Siebel workflow.

Environment: Siebel Financial Services, Siebel Tools 7.7, Siebel Partner portal, HTTP.

Confidential

Responsibilities:

• Design the Business Object Layer and User Interface Layer Establishing Joins, Links, Pick Applets and MVGs.
• Added the specifications for Joins and Pick maps that will participate in the activation of Pick Applet.
• Create Assignment rules for Assigning the Accounts and contacts to the sales rep.
• Create Server script for creating new orders in the application.
• Test each change requests before delivering it to the client.
• Modify and Configure of Vanilla Siebel Application using Siebel Tools.
• Develop User Interface by mapping and designing the Applets into Views, Views into screens by using Applet and View Designer.
• Design workflows and running it in Runtime event and also using policies
• Customize and modify of various Object definition using Tools.

• Extracted data from multiple databases and presented to the management in the form of Excel Sheets.
• Developing SQL Scripts, Stored Procedures.
• Spooling Uploading the generated reports to Excel files.

Environment: Siebel 7.5.3, Oracle 9i, UNIX, Siebel Epharma, Actuate Reports