SUMMARY

• Twelve years of experience in analyzing, designing, developing, implementing and testing of various client/server and web - based applications which includes Siebel eBusiness Enterprise Applications in Siebel ePharma, Siebel Public Sector, Siebel SFA, Siebel eSales, Siebel eService, Siebel eCommunications, Siebel Call Center, Siebel eMarketing, Siebel Finance, Siebel Sales.
• Extensively used Territory Management, Siebel Work Flow, Assignment Manager, Business Service, VBC, Siebel Application Configuration, EIM and EAI.
• Experience in developing reports using Actuate eReport Designer Professional/ Actuate Developer Workbench and Salesforce/Veeva
• Testing Siebel Applications. Siebel 8 Certified. Salesforce Veeva Certified.

TECHNICAL SKILLS

CRM: Veeva/Salesforce, Siebel 8.2.2.2(Open UI)/ 8.1/7.8/7.7/7.5 / 7.0 - Tools, EIM, eScript, Work Flow, Assignment Manager, EAI (XML, VBC, Business Services)

Operating Systems: Windows 7/XP/00, UNIX.

Programming: Java, JavaScript, C/C++, CGI/PERL, HTML.

Databases: Oracle 9i/10g/11g/12c, SQL Plus, PL/SQL, MS-SQL Server, MS Access

GUI: Visual Basic, Forms/Reports, Actuate, Veeva/Salesforce

Tools: Informatica 7.1/8.6/9.1, Toad, SQL Loader, MS Office, Corel Draw, Adobe Photoshop.

Testing Tools: Win Runner, Load Runner, Test Director

PROFESSIONAL EXPERIENCE

Confidential, Indianapolis, IN

Siebel Administrator/ Lead Siebel Developer

Responsibilities:

• Gathered business requirements and designed teh Functional and Technical design documents.
• Extensive use of Workflow Policies (database triggers).
• Use of External BCs & Web Service for lookups from wifin Siebel
• Configured UI elements like Screens, Views, Applets and objects like Business Components, Links, MVG, Pick List, Pick Applet.
• Configured Accounts, Contacts, Assets, Agreements, Activities, Marketing Campaigns, Invoices, Revenue Screens and Views based on Client Requirement.
• Created teh Static, Dynamic Pick list, Constarin Pick List, Heirarchical picklists.
• Used User Properties and wrote Siebel eScript behind applet and business component events to execute specific business logic.
• Worked on Data Validation Administration as an alternative to escripts.
• Developed an EIM process to Migrate from legacy system to Siebel system, populated teh interface tables and performed data mapping.
• Involved in performing teh EIM tasks and preparing teh required mapping templates to migrate teh Accounts, Contacts, Activities, Agreements, Invoices, Revenue, Products using Informatica /SQL Loader to populate teh Siebel base tables through EIM Interface Tables.
• Worked on Performance and error analysis by analyzing task info log, errors files and by tracing files in order to achieve targeted results.
• Configured teh ifb file.
• Created custom Extension Columns to teh database and interface tables and created new custom extension tables.
• Troubleshooted teh EIM Process by populating teh Error Flags, Trace Flags and SQL Trace Flags.
• Worked on Territory Management to assign Sales Rep to Territories to any given Account or Contact based on Global and Local Conditions.
• Wrote eScripts to validate teh fields based on teh business requirements.
• Created a script to dynamically constrain teh values displayed in a dynamic picklist based on whether flag is set to true or false.
• Used Business Component and Field User Properties to do validation work.
• Installing Siebel servers and setting up Development/QA/Production Environments for 7.8 and 8.2.2.2.
• Siebel Upgrade from 7.8.2.9 to 8.1/8.2.2.2.
• Data loads from Siebel to Sales force/Veeva.
• Created Inbound/Outbound integration (Web services) from Siebel to SAP and Vice Versa for Order Management(O2C).
• Created VBC for data visibility.
• Siebel releases via Siebel anywhere kits for Siebel remote users.
• Worked on Siebel remote user setup and offline initialization and Sync issues.
• Worked on Siebel server components for issue resolutions and load balancing.
• Used ADM for Siebel data.
• Developed Smart, Forecast and Parameterized Reports.
• Developed Master Detail, Group, Composite DataStream and incorporating graphics such as bar charts and pie charts in reports.
• Created specific Reports according to Business requirements and set teh Reports visibility to Manager, Financial Professional.

Environment: Windows7/XP,Veeva/Salesforce,SiebelePharma,SiebelClient8.2.2.2(Open UI)/ 8.1/7.8/7.7/7.5 , Siebel Tools 8.1/7.8/7.7/7.5 , EIM, EAI, PL/SQL, eScripts, Informatica, Oracle, Toad, UNIX, SAP,XML,SQL-Loader.

Confidential - Seattle, WA

Siebel Consultant

Responsibilities:

• Configured UI elements like Screens, Views, Applets and objects like Business Components, Links, MVG, Pick Applet.
• Created teh static and dynamic picklists
• Configured Accounts, Contacts, Agreements, Profiles, Addresses, Offers Screens and Views based on Client Requirement.
• Involved in performing teh EIM tasks and preparing teh required mapping to migrate teh Accounts, Contacts, Agreements, Profiles, Addresses, Offer, and Offer Elements data using Informatica to populate teh Siebel base tables through EIM Interface Tables.
• Managed teh Inbound and Outbound Interface by using EIM process.
• Created custom Extension Columns to teh database and interface tables
• Configured teh ifb file.
• Worked on error analysis by analyzing task info log, errors files and by tracing files in order to achieve targeted results.
• Wrote eScripts to validate teh fields based on teh business requirements.
• Involved in teh requirements gathering, data mapping and UTP.

Environment: Windows 2000, Siebel Communications, Siebel Sales Force Automation, Siebel Client 7.7.x, Siebel Tools 7.7.x, EAI, EIM, PL-SQL, eScripts, Informatica7.x, Oracle9.x, Toad, UNIX.

Confidential - Lansing, MI

Siebel Consultant

Responsibilities:

• Worked wif Siebel tools to define/modify objects-Applets, Views, Pick Lists and Screens to suite teh customer requirements.
• Configured Accounts, Contacts, Assets and Activities and Views based on Client Requirement.
• Created teh static and dynamic picklists and MVG applets.
• Developed an EIM process to Migrate from legacy system to Siebel system, populated teh interface tables and performed data mapping.
• Data-mapped fields from Legacy system to teh fields in teh Interface tables of Accounts, Contacts, Assets and Activities then imported into Siebel Database.
• Involved in performing teh EIM tasks and preparing teh required mapping templates to migrate teh Accounts, Contacts, Assets and Activities using SQL* Loader to populate teh tables from teh Siebel base tables through EIM Interface Tables.
• Used SQL Loader Utility and Control Files to stage teh data from Flat file, which is coming from teh legacy System.
• Troubleshooted teh EIM Process by populating teh Error Flags, Trace Flags and SQL Trace Flags.
• Configured teh ifb file.
• Managed teh Inbound and Outbound Interface by using EIM process.

Environment: Windows 2000, Siebel Public Sector, Siebel Call Center, Siebel Client 7.7, Siebel Tools 7.7, EIM, PL-SQL, Oracle 9.x, SQL- Loader, Toad, UNIX.

Confidential - Boston, MA

Siebel Configurator/Developer

Responsibilities:

• Configured UI elements like Screens, Views, Applets, View Web Templates, Applet web Templates and objects like Business Components, Links, MVG, Pick List, Pick Applet.
• Created Joins, Links to display teh customized filed in customized tables to display data.
• Configured Accounts, Contacts, Opportunities screens and Views based on Client Requirement.
• Created teh static and dynamic picklists and MVG applets.
• Wrote Siebel eScript behind applet controls and business component events to execute specific business logic.
• Data-mapped fields from Legacy system to teh fields in teh Interface tables of Contacts, Accounts and Activities, then imported into Siebel Database
• Used SQL* Loader in EIM process to migrate teh Account, Contacts and teh Opportunities data from DB2 into Siebel system.
• Worked on error analysis by analyzing task info log, errors files and by tracing files in order to achieve targeted results.

Environment: Windows 2000, Siebel Finance, Siebel Call Center, Siebel Client 7.7, Siebel Tools 7.7, eScripts, EIM, PL-SQL, Oracle9.2, SQL-Loader,Toad,UNIX.

Confidential - Cincinnati, OH

Siebel Developer

Responsibilities:

• Involved in teh design and configuration of ePharma Industrial application of Siebel Life Science.
• Created links between teh parent business components and child business components when designing master-child views based on this link.
• Created teh static and dynamic picklists and MVG applets.
• Wrote eScripts to validate teh fields based on teh business requirements.
• Created applets and assigned them to teh Meetings view, Sample Usage view, Samples Orders view, Order Management, Contact, Opportunities, Accounts, Medical Event view, Product Information view and Product Complaint views.
• Created teh Meetings view, Sample Usage view and Samples Orders view and added them to teh required screen and displayed them in teh applets.
• Created Campaigns, sub-campaigns, assigned individuals to be contacted and scheduled activities for campaigns.
• Involved in performing teh EIM tasks and preparing teh required mapping templates to migrate teh Product data, Orders data and teh Samples data using Informatica to populate teh tables from teh Siebel base tables through EIM Interface Tables.
• Created new Static bounded and unbounded pick lists and customized dynamic pick lists.
• Created Joins, Links to display teh customized filed in customized tables to display data in Account and Contact screens on different Account and Contact Form and List applets.
• Modified teh user interfaces for Accounts, Contacts, Products, Orders Screens.
• Configured UI elements like Screens, Views, Applets, View Web Templates, Applet web Templates and objects like Business Components, Links, MVG, Pick List, Pick Applet.
• Customized Account Entry, Account Form applet to accommodate new fields created on Account Business Component, corresponding to new columns on S ORG EXT table.
• Created custom Extension Columns to teh database and interface tables.
• Used SQL Loader Utility and Control Files to stage teh data from Flat file, which is coming from teh legacy System.
• Migrated data from legacy system to Siebel system using EIM populated teh interface tables and performed data mapping.
• Troubleshooted teh EIM Process by populating teh Error Flags, Trace Flags and SQL Trace Flags.
• Configured teh ifb file.
• Wrote Siebel eScript behind applet controls and business component events to execute specific business logic.

Environment: Windows 2000, Siebel ePharma, Siebel Call Center, Siebel Client 7.5.3, Siebel Tools 7.5.3, EIM, Actuate6.x, Siebel Application Administration, PL-SQL, Oracle8.1.x, Informatica 6.x, Toad,eScripts, iPlanet-WebServer-Enterprise/4.1,UNIX and IIS.

Confidential - Minneapolis, MN

Siebel Developer

Responsibilities:

• Involved in implementing Access Control Mechanism according to BusCompViewMode and Visibility Applets.
• Used VBC to show data from Legacy Systems on Siebel screens.
• Worked extensively on Siebel eConfigurator for preparing Catalogues, Models, and defining relationship between line items.
• Used eConfigurator to allow customers to order products via Confidential Online so as to identify selling opportunities based on customer profile information and their previous product selections. It then delivers targeted messages and recommendations to ensure dat all relevant product options are presented
• Used teh Model Manager to define teh new models and added properties, products, virtual products, and categories to teh model in Catalog Designer View.
• Implemented rules and conditions associated wif each model in Basic View Designer.
• Implemented logical expressions for teh product selection in Logic Designer View.
• Wrote eScripts for cross selling and up selling, for calling external program and for pricing configuration.
• Configured Accounts, Opportunities, Campaigns, Quotes, Product screens and Views based on Client Requirement.
• Used Catalog Administration to organize master data into catalog and categories and controlled access to master data by associating access groups to categories.
• Using Personalization Administration provided access to teh applets and views based on user responsibilities.
• Used SQL- Loader in EIM process to migrate teh data from DB2 into Siebel system.
• Integrated Siebel application using EAI (eBusiness Application Integration) to provide more robust interface wif IBM legacy system using MQSeries.
• Used Workflow Manager to define policies, to configure workflow policy, program and business services, and generated triggers for teh Sales applications.
• Installed Mobile clients and tools, generated database Templates, initialized Database and did database extract to enable remote access for Mobile Clients.

Environment: Siebel Client 7.x, Siebel Tools 7.x, eSales, Siebel eMarketing, Siebel Call Center, eConfigurator, eCommunications, Siebel Tools, eScripts, EIM, EAI, Assignment Manager,WorkflowManager,PersonalizationAdministration, Catalog Administration. PL-SQL, Oracle 8.x, Product Configuration, Windows 2000, SQL- Loader, Toad.