A software consultant specializing in Oracle's Siebel CRM software and has worked on projects involving Design, Development, Project Delivery and Production Support life cycles of a project with skills like providing technical solutions, troubleshooting issues, creating design documentation and requirement gathering.

SUMMARY OF QUALIFICATIONS

Siebel 8 Certified Consultant.

• Obtained 96 in Siebel 8 Certification exam.
• 10 years of IT experience mostly in CRM.
• Experience in Production Support.
• Possess experience in Siebel verticals like Siebel Financials, Siebel eCommunications, Siebel Public Sector and Siebel PRM modules.
• Experience in Siebel Horizontals like Call Center, Sales and eService Modules.
• Possess SQL skills and have worked on Oracle, IBM DB2 and SQL Server databases and also have PL/SQL experience.
• Proficient in UNIX and shell scripting, Batch Jobs in Unix OS.
• Strong analytical, diagnostic and troubleshooting skills and ability to work in a fastpaced environment.
• Has expertise in Siebel Configuration, Rules Engine, Workflows, Siebel Scripting, EAI, EIM, Java Scripts, Server Administration, Delivering CRM projects.
• Excellent Leadership skills and team player with strong consulting, Interpersonal, Writing, Communication and TechnoFunctional Skills.

TECHNICAL SKILLS

• CRM: Siebel 7.x, Siebel 8.x, Siebel Tools, Siebel VB/COM, Siebel eScript, EIM Enterprise Integration Manager , Workflows, Siebel EAI eBusiness Application Integration ,
• Smart Scripts, Assignment Manager and Server Administration
• Siebel Modules: Financials, eAutomotive, eCommunications, eCustomer, Public Sector, eService,
• eChannel, Call Center, Sales
• Languages: Shell Script, VB, SQL, HTML, VB Script, Java Script, XML, C, C , SQL,
• PL/SQL, VB.Net
• Operating Systems: Windows 95,98,2000, XP NT, Solaris 8 9 UNIX
• Database: Oracle, IBM DB2, MS SQL Server, MS Access,
• Web Applications: Microsoft FrontPage, Dreamweaver 4 and Visual Inter Dev

PROFESSIONAL EXPERIENCE

Confidenital

Sr. Siebel Developer

• This project is a design, development, delivery and maintenance effort in Siebel Financials application.
• Extensive scripting and configuration work around Accounts, Contacts, Quotes and Opportunity modules.
• Configuration work includes creating new screens, views, MVG, pick applets etc.
• Created batch jobs for data cleansing and post processing work after data load through Integration.
• Created EIM jobs for loading campaigns.
• Extensive Web Services development Inbound/Outbound Web Services.
• Integration work includes Integration Objects, Business Services, VBC Virtual Business Component .
• Receiving data from Benefit Focus to load Accounts, Quotes, Quote Items, Opportunities, Census and Contacts data.
• Send Group Benefits Administration data to legacy systems from Siebel.
• Extensive Work on BI Publisher reports.

Environment: Siebel Financials 7.8 , Siebel Tools, eScripts, Web Services, VB Scripts, Workflows, SQL Server 2007 and Windows 7,BI Publisher.

Confidenital

Sr. Siebel Developer

• This project is a design, development, delivery and maintenance effort in Siebel Financials and Claims application.
• Extensive scripting and configuration work around Claims and campaign modules.
• Extensive Web Services development Inbound/Outbound Web Services.
• Provided data from Siebel to the IPhone Claims Application and also to the Web Application using Web Services.
• Automated the claims creation process from vendors for Road Service and Glass related claims. Used Web Services for integrating Road Service vendor Agero and Glass Service Vendor Lynx.
• Created a Task Based UI in Siebel for a step by step navigation process for creating claims by call center reps.
• Automated the process of creating reserves so claims adjustors do not have to manually open the reserves.
• Involved in Production Support to troubleshoot any Siebel related issues.
• Timely resolution to Production tickets and getting approval from Business.
• Created Business Services that was invoked from server as well as browser scripts for validating data and providing warnings when changing data.
• Used Outbound Communication Manager to send emails to groups when certain production sensitive data was changed.
• Involved in configuration tasks like creating joins, links, MVG's, Pick Lists, applets, views.
• Involved in Performance tuning by modifying the Siebel configuration sometimes or by creating indexes and also worked with DBA's to resolve performance issues.
• Worked on VB application to sort incoming USPS files to remove duplicate address entries and upload them into Siebel.
• Worked with external vendors to integrate Siebel with external systems. Some of the I ntegration work web services with third party includes Rising Medical Solutions and Thunder head.
• Created a Big Siebel View to convert a manual excel sheet process used by Adjusters for negotiating Claims settlements with claimants into Siebel. Used VBC concept for scratchpad applet in Siebel.
• Used Assignment manager to automatically assign activities to the correct adjuster.
• Responsible for delivery of Projects which includes coordination with external vendors, teams within the organization and time coordination with all stakeholders.
• Responsible for estimating time effort required on the projects worked.

Environment: Siebel Financials 8.0.0.9 , Siebel Tools, eScripts, Web Services, Assignment Manager, VB Scripts, Workflows, IBM DB2 and IBM AIX

Confidenital

Siebel Lead

• This project is a design, development, delivering and maintenance effort in Siebel eAutomotive application.
• Single point of contact for everything related to CRM. Responsible for estimating, designing, developing, delivering and maintaining Siebel CRM application.
• System Administration duties as below
• Regular Siebel Maintenance like testing and applying Siebel patches. Recently upgraded 7.8.2.11 eAutomotive to 7.8.2.14 and 7.8.2.16 eAutomotive
• Created Cleanup scripts in Solaris environment to archive log files and delete the old log files to keep a healthy server free space.
• Created scripts to monitor Siebel Server components. Send an email to the concerned persons if a server component is down or offline.
• Monitor fdr files generated in the server and make changes to Siebel Application to prevent recurrence.
• Siebel Release activities like compiling srf, generating browser scripts, stopping and starting of Siebel App Server, Gateway Server and web Server.
• Improve the performance of the Application by monitoring long running sql and make the appropriate configuration changes.
• Automated the batch loading of Accounts and Account Addresses from SAP into Siebel using EIM and shell scripts.
• Handled EIM Insert, Update and delete tasks. Created Ifb files and used Pl/SQL for cleansing the data and updating EIM tables.
• Users for UAT testing before deployment.
• Lead sessions for Business requirement gathering for Accounts, Contacts and Opportunity modules.
• Used Java Beans to interact Siebel with DB link to retrieve VIN Number, Service Date for a transmission serial number.
• Used Siebel provided SARM utility for gathering diagnostic information during system crashes.
• Worked with LDAP authentication for Siebel Login.
• Experience with Actuate Administration Experience.
• Created custom charts in Siebel for reporting purposes. Interacted with business and provided an alternate feature involving charts after facing technical constraints.
• Helped migrate from Siebel to Microsoft Dynamics CRM application.

Environment: Siebel eAutomotive 7.8.x , Siebel Remote, Siebel Anywhere, Siebel Tools, eScripts, Siebel Server Administration, Shell Scripts, Workflows, Project Delivery, Oracle 11g and Solaris 10

Confidenital

Siebel Design/Dev Lead

WirelessWireline Integration WWI :

• This project is a design and development effort in Siebel eCommunucations application. This project is focused on integrating ATT and Cingular's CRM systems under one umbrella. The project is undertaken to bring the Business Customers of ATT and Cingular under one platform to help the Sales representatives of both businesses to better understand the customer's needs and to increase productivity and profitability of the enterprise.
• Responsible for the technical delivery of the projects.
• As the Design Lead for Account Hierarchy module of the project, is completely responsible in designing the new features across this module from System Requirements.
• Design Areas in Siebel include Configuration, Scripting, Workflows, Batch Jobs and Web Services.
• Some of the salient features in the new Account Hierarchy Module are as below
• Accounts will be having 5 levels of hierarchy. Level 5 through Level 2 will be stored in Siebel Application ROME . Level 1 will be stored in an external application called SAART which is the system of record for Accounts. This scenario was configured using Siebel inbuilt Master Account Id and Parent Account Id fields. Master Account Id for Level 4 through Level 2 will be the Siebel Row Id of Level 5 and Parent Account Id will be the first parent of a record.
• All the Account Assignments will happen only for Level 4 and Level 3 records. In other words only Level 4 and Level 3 records will be assigned to Sales Representatives and only they need to be displayed Across all applets with a few exceptions and if a L4 Account belonging to a Sales Rep has an L3 as well, only L4 need be displayed in the screen. This scenario was achieved using complex configuration to display the records.
• Only Level 4 and Level 3 can be assigned to child. i.e Opportunity, Contacts, Credit Check etc . objects and the visibility rules for L4/L3 applies here also.Achieved this scenario with configuration tasks.
• Whenever an assigned Account on an object like Opportunity or Credit Check is changed audit trail needs to be invoked and should be displayed under Old Accounts. This was configured using a combination of BC level joins, Links from Account to Audit Trail and Links from Child Objects i.e Opportunity, Credit Check to Audit Trail.

Involved in designing the EIM load of Accounts, Contacts, Address and Position into Siebel from SAART into Siebel.

• Created Web Services to create Accounts, Contacts, Address and Position information real time.
• Account Explorer screen was completely changed from Vanilla to meet the new System reqirements.
• This was achieved with a combination of configuration and complex scripting across events of the
• Business Component.
• An email need to be sent to Sales Reps who own the Account as soon as they are assigned an Account
• through EIM. This scenario was achieved using a combination of Batch Script written in Shell scripts
• and Siebel Workflow using Outbound Communication Manager to send the email.
• Account Hierarchy Data will be received real time from SAART. An inbound web service with workflow was used to achieve this scenario.
• Configured various other views,Screens and applets and Toggle Applets as a part of Account Hierarchy.
• Configured VBC Virtual Business Component using web service to get L1 account details for an L2 account and display it in Siebel Applet.
• Involved in developing Siebel functionality across other modules of the project like Sales Hierarchy
• and Common Funnel as well.
• Created Batch Workflow Process to automatically update Segment values for Opportunities and used RCR.
• As the Design Lead for Common Product catalog CPC module of the project, is completely responsible for designing the product data load and configuring the Product Screens and applets across the application.
• CPC External System sends us full XML having about 100000 products on nightly basis. Loading of products was designed and implemented as below.
• Used XSLT transformation in shell scripts to break down the Products and its attributes in the XML file into 12 data files containing Products, Portfilios and the different attributes of Products.
• Once the data files are ready, used SQL and EIM to upload the products into Siebel.
• Created COM scripts to map existing Products with new CPC Products and map Offers with Products.
• MVG's were correctly displayed with Product Hierarchy using a Calculated Source Field in the Link.
• Involved in resolving ST/UAT/Production tickets in a timely manner.
• Configured Siebel iHelp functionality.
• Involved in Performance Tuning the Siebel Application especially around Address and Account entities. Used tools like SiebelSpy for Performance Tuning.
• Worked on Smartscripts to create Products and link Products to Opportunity.
• Environment: Siebel Sales, eCommunication 7.8.x , Siebel PRM, Siebel Tools, eScripts, Shell Scripts, Siebel Server Administration, Web Services, Workflows, Oracle 11g and Solaris 10
• Confidenital
• Siebel Consultant
• This project is a development effort in Siebel Sales and eComm application. The development effort is mainly focused on automating existing promotions assigning operations.
• Created new Assignment Promotions View to facilitate assigning promotions to new and existing Accounts.
• Created Business Services to assign one or more Promotions to an Account on the click of a button.
• Also created Business Service to do validations on Promotions.
• Made use of calculated fields, user properties and Siebel out of the box configurations to avoid scripting in implementing business requirements.
• Regularly interacted with Business users to fine tune the requirements and implement them in Siebel.
• Created Batch Workflows to set the status of unused Assigned Promotions to Cancelled on the second day of every month.
• Also involved in Administrative tasks like adding/editing LOV's and creating test data.
• Involved in creating the Technical Design documentation.
• Used Web Services to receive Campaigns and Promotions entered in web portal into Siebel.

Environment: Siebel Sales, eCommunication 7.8.x , Siebel PRM, Siebel Tools, eScripts, Web Services, Workflows, Oracle 11g and Solaris 10

Confidenital

Siebel Consultant

• This project is a development effort in Siebel PRM application. MTS Allstream needed a new PRM application for the use of all their dealers across Canada.
• Created Task based UI process to handle the step by step flow to be followed by the dealers while
• creating or modifying existing customer information.
• Created new Business Services to dynamically generate URL to open 'Freeway' pplication where orders need to be created. This business service was developed to get all the values dynamically with no hard coding. Also created Business Service for getting field values from the browser scripts.
• Involved in the UI configuration like creating new views, screens, applets, links and joins.
• Involved in data mapping work like appropriate selection of tables and columns for BC's and BC fields.

Environment: Siebel eChannel 8.0.0.5 , Task based UI, Siebel Tools, eScripts, Workflows, Oracle 11g and Windows XP

Confidenital

Siebel Consultant

• This project was for the Unemployment Insurance modernization program implemented for KDOL by IBM. As a part of Business Rules team, I was involved in creating new rules and modifying existing Rules in Haley rules engine, troubleshoot the defects in HaleySiebel integration and acted as an administrator for the Haley Knowledge Base on Dev Server.
• Integration of Haley Rules Engine with Siebel Public Sector Application using Siebel's inbuilt integration Mechanism.
• Extensively worked on Haley Rules engine to create business logic for our client's unemployment insurance program.
• Created Business Services to send inputs to Haley and handle outputs from Haley and process them to Haley/Siebel understandable formats.
• Worked with Oracle Expert Services and Haley Experts to resolve a lot of issues with the Siebel Haley Integration. Detected flaws in the integration and reported it to Oracle Expert Services which they agreed upon and worked on it for a fix.
• Created patches to fix data in the Siebel runtime tables to overcome the deficit in the Integration.
• Created Workflows for the seamless flow of the process. Most of the work done here are huge processes like Filing New Claim and Filing Continued Claim . The workflow had lots of Siebel and Haley steps that were processed and branched appropriately.
• Also involved in configuration works like creating Business Components, Applets, Joins, links, calculated fields and User Properties.
• Made all efforts to minimize the usage of scripting by handling it with user properties and calculated fields.
• Acted as an administrator of Haley knowledgebase in Dev Server. In charge of importing Siebel objects
• into Haley knowledge base, creating and modifying rules and testing the rules.
• Analyzed Haley and Siebel log files to determine the causes of the errors arising out of Haley and Siebel
• and fix them accordingly.

Environment: Siebel Public Sector 8.0.0.5 , Siebel eService 8.0.0.5 , .Haley Rules Engine 4.12 ,Siebel Tools, eScripts, Workflows, SQL Server 2005 and Windows XP

Confidenital

Siebel Consultant

• This project was to create a new excel application integrated with Siebel CRM for the sales representatives of Solid works Corp. Sales Reps were able to create, modify, delete opportunities in Excel and synchronize their excel sheet with Siebel to post and retrieve data.
• Integrated Excel Sheet Application with Siebel Application. Extensively used VBA Coding for this purpose. The functionalities achieved in excel sheet were the following.
• Create new Revenue records, Edit Revenue Records and delete Revenue records .This was achieved by the click of button in excel sheet.
• There is a Synchronize button which will fetch Revenue Records from Siebel and from excel to Siebel. If records were deleted or edited in either application, it would do the synchronize operation for this as well.
• This spreadsheet is used by VAR's Value Added Representative's who essentially sell Solidworks software.
• Created custom Business Components, Business Objects, Links, Views, Applets and Tables.
• Extensively used scripting to achieve some of the following scenarios
• Get the row id of the revenue record being deleted and store it in a custom table.
• Set Profile attributes when a revenue record is edited or a new record is created. Use these profile attributes to get updated records and new records when synchronize button is hit in excel.
• Created Applet level and BC level scripts to achieve all the above scenarios.

Environment: Siebel Call Center/Siebel VAR Portal 7.8 , Siebel PRM, Siebel Tools, eScripts, Workflows, SQL Server 2005 and Windows XP

Confidenital

Siebel Consultant

• This was a maintenance and enhancement project for Alltel Communications. I was involved in maintaining and enhancing their Siebel eCommunication Application and also automating and scheduling jobs in Production environment along with enhancing their web sites hosted on Siebel eCustomer application.
• Created new Search screen in eCommunications to retrieve ESN numbers.
• Created functions using eScripts to convert Hexadecimal numbers to Decimal and vice versa.
• Created script to get the make and model of a phone based on the ESN number.
• Created Custom applets/Business Components for the purpose of retrieving ESN numbers.
• Created a script to dynamically constrain the values displayed in a dynamic picklist based on the value set
• in another field.
• Created a script to disable the New , Copy , Query button based on position of the users.
• Created eScripts to log the MDN and Account no into a custom defined table whenever there is an error
• in the application.
• Created a new web page using Siebel eCustomer application for customers to register their cell phone numbers. Created custom webtemplates using java script for this purpose.
• Created and modified eScripts to enhance CTI application and improve performance.
• Used Oracle External Table concept and PL/SQL scripts to load date values to an extension column in
• Accounts table.
• Used sql loader to populate data into tables from data files.
• Created Smart Scripts to enable customer service agents create trouble ticket.
• Created user interact workflows to navigate users to different views.
• Also created workflow to retrieve information from billing system and update it in the Siebel database.
• Was involved in the New Mexico split project which is for splitting the area code in New Mexico State
• into two.
• Created a script to dynamically constrain the 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 a lot of validation work.
• Created batch scripts to run EIM process daily to upload accounts and contacts data obtained from billing
• Application.
• manager log files to find out errors/slow performance.
• Created batch jobs using shell script to continuously monitor Server Components and automatically restart them if found in Not Running/Online state. Generate an alert, if unable to restart. Created custom tables to store the server component data.
• Created shell scripts to monitor if any eCommunications/eCustomer server is accepting sessions. Generate an alert using scripts, if they are not accepting any sessions.
• Truncated tables that were growing really big as a result of persistence turned ON for workflows. Also rebuilt indexes for those tables and turned OFF persistence.

Environment: Siebel eCommunications/eCustomer 7.5.3 7.8.2 , Siebel Tools, Web Services, EAI, eScripts, Workflows, Siebel Server Administration, CTI, EAI, EIM, Oracle 9i, and Solaris 8 9 UNIX

Confidenital

Siebel Consultant

• Used eScripts to check Duplicate accounts from being created.
• Used eScripts to capture user information whenever a user attempts to create a duplicate account.
• Created browser scripts to achieve user interactive functionalities.
• Constrained users functionality based on their position.
• Created Business Service to truncate the length of the text.
• Created the Workflow Policy. Developed Business Services for Workflow Automation, and verified
• workflow Processes using process simulator.
• Created custom tables and business components to capture user details.
• Customized the screens of Account, Products, Contacts, etc. as per the Client Requirement.

Environment: Siebel eCommunications 7.5.3 , Tools, eScript, Workflow, Oracle 9i, Win XP

Confidenital

Siebel Consultant

• Involved in complex tools configuration to modify the Siebel UI as per the requirement.
• Performed EIM to load Canadian customer records into Siebel from external application.
• Performed data mappings from legacy to new system.
• Used Microsoft SQL Servers DTS to build a transformation package that loads the external data to
• interface tables.
• Involved in migration and data loading from Siebel tables using EIM.
• Post import analysis for errors and rejects and reimporting.
• Environment: Siebel 6.3, EIM, Siebel Tools, MSSQL Server