Professional Summary

• 9+ years of experience on Siebel version 7.x & 8.x. (8.0, 8.0.0.9, 8.1, 8.1.14, 8.1.1.9 and 8.1.1.11, 8.2.2.3)
• In-depth knowledge in Siebel deployment and development right from requirement analysis to implementation.
• Worked on Siebel Call Center, Siebel eChannel, Siebel Loyalty , Siebel ePublic Sector and Siebel Marketing.
• 6+ Years of Experience in Siebel Admin (Installation, Maintenance, health check Monitoring, Administration, Migration, Production support, Upgrade and Db Migration)
• 3 Years of Experience in Siebel EAI, WFs, BS, eScripting, RCR, Runtime Events, Siebel UCM.
• 2 Years of Experience in Siebel EIM (Import, merge and delete), UNIX Shell Scripting, PL/SQL.
• One Year of Experience in Siebel Open UI, Haley and BIP.
• Extensive experience in installing and maintaining Siebel from DEV to PROD.
• Excellent Coordination with multiple vendors and customer-facing skills.
• Proficient in UNIX shell scripting.
• Strong knowledge in setting up new Siebel environments.
• Sound command over End to End Siebel upgrades and database migration.
• Extensive Oracle 9i/10g, PL/SQL development experience.
• Experience in SDLC and Agile Methodologies.
• Knowledge in Integrating Siebel and Avaya CTI 7.0.
• Knowledge in Load Balancing Siebel Servers using BigIP.
• Extensive development experience with Siebel tools and Configuration, Siebel Administration, Siebel upgrade and migration, EAI –XML, SOA-WSDL/Web Service, EAI-JMS Integration, WFs, EIM, eScripting and UCM.
• Expertise in Siebel Tools, EAI troubleshooting, debugging, performance tuning, Runtime Analysis, SQL trace, extended Syntax Check and locating bugs within the stipulated time.
• Extensively worked in requirement analysis, high level and low level designs, implementation and documentation.
• Proficiency in Customization of objects in Business Object Layer and User Interface.
• Skilled in handling Huge Data deletion from Siebel database.
• Extensively worked in moving the environments in and out of segmented environments.
• Involved in Integration between Sales Force and Siebel.
• Exposure to Sales Force Cloud Technology.
• Exposure to Siebel Marketing.
• Experience in Siebel Open UI and exposure to OPA.
• Possess excellent time management skills in tackling various issues.
• Strong analytical ability coupled with a high degree of motivation.
• Experience in interacting directly with customers and end users at client site for development, enhancement, and management activities.
• Project execution responsibilities include Preparing Technical design documents, Unit Test Scripts, code review sessions, System Integration testing and deployment plan.
• Good at understanding business requirements, having an analytical approach in problem solving and working towards improved customer experience.
• Played a good team lead role to share and take initiative to prepare my team members to live up to the business expectations and standards.

Technical Skills

CRM

SIEBEL 8.1/8.0/7.8/7.7/ Siebel 7.5.2, Sales Force CRM

Horizontal/Vertical

Siebel Call Center, Siebel Marketing, Siebel Sales, Siebel eChannel, Siebel eLoyalty, Siebel Loyalty

Operating Systems

UNIX, Windows 2000/XP, Linux Red Hat 5.10

Languages

C, C++, JAVA

Script / Markup

HTML, eScript, SOAP, UNIX shell scripting

RDBMS

Oracle 10g, Oracle 11g, DB2 UDB

Tools

BI Publisher, JIRA, Rally, Control-M, HP Quality Center, HPSD, Haley,

PROFESSIONAL EXPERIENCE

Confidential

Salem, OR

Senior Siebel Administrator

Responsibilities:

• SIEBEL 8.2 server installation & configuration in High Availability Data Centers.
• BI Publisher Installation and configuration (OC4J Application Server)
• UCM (Content Management) installation on Web Logic Server
• Siebel MDM, IIR and Address Doctor Installation and Configuration.
• OPA Installation on Web Logic Server and Integration with Siebel.
• Setting up Siebel tools, Mobile/dedicated client.
• Web Logic Administration.
• SRF, Repository migration and DDL synch.
• BIP Reports Migration.
• OPA Rule Base Migration.
• Oracle SOA Composite Migration and Administration.
• Setting up SSO/LDAP authentication for Siebel.
• Performance tuning of Siebel ePublicSector and OPA.
• Daily health checks which includes regularly checking status of servers & components. Checking status of JOBs/RCRs/ Tasks. Server resource monitoring(CPU/Memory/Disk space)
• Used Siebel ADM to migrate LOV, Responsibilities to higher environments.
• Automating Full Compile and SRF migration.
• Supporting Test and Development environments which includes
• Setting up tools/mobile client for developers
• Extracting local databases for developers
• Migrating SRF/Repository from Development to Test environment
• Deploying non repository items
• Supporting performance testing in Test(QA) environment
• Automation of daily migration/monitoring activities by writing shell scripts or batch jobs
• Resolving all adhoc issues, if issue is not related to Siebel then assign it to correct work-group.

Environment: Siebel Call Center, Siebel ePublic Sector, Siebel 8.2, Oracle 11g, JMS, MQ, Siebel Web Service, BIP, SOA, IDM, UCM ,MDM, IIR, Address Doctor, CI, Siebel Tools, PL/SQL, eScript, Workflow, Linux RedHat 5.10
Confidential

Fort Worth, TX

Senior Siebel Admin

Responsibilities:

• Involved in Siebel Upgrade (IRM Process) from 8.1.1.9 to 8.1.1.11
• Fixed upgrade issues and stabilized the environment.
• Enabled OpenUI after the upgrade.
• Installing and maintaining Siebel Enterprise, Application and Web Servers in Dev1, Test1, and Dev2, Test2, UAT and Prod environments.
• Clustered Siebel gateway in UAT and Prod environments.
• Worked with BigIP team to configure load balancing in Siebel application servers.
• Managing Parallel development for multiple Siebel applications.
• Maintained Dev1/Dev2 and Test1/Test2 environments to support parallel development.
• Daily code migration from Dev1 to Test1 and Dev2 to Test2.
• Bi-weekly code migration from Test to UAT.
• Production migration for every 4 weeks.
• Configuring DEV users, grant permissions, login issues and overall data management
• Extracting local databases for developers and adding multiple users.
• Setting up tools/mobile client for developers
• Migrating Repository from Development to Test environment, UAT and Production environments.
• Deploying non repository items like LOV, Responsibilities, XSLT, data Maps, PDQ, EAI Value Maps, views.
• Packaging and deploying using Application Deployment Manager (ADM)
• Data map import and validate
• Server configuration, Components Creation, and enterprise profile Configuration.
• QF Installs and Rollbacks.
• Creating Indexes and Tables based on the errors faced by the testers or developers.
• Supporting performance testing in UAT environment
• Supporting all planned & unplanned outages in production.
• Set up and support Siebel remote. This includes registering user as mobile client, extracting local database.
• Troubleshooting the application problems like environmental issues, configuration, and performance issues.
• Stop/Start Siebel servers, Troubleshoot functional issues and performance issues and also Analyze performance results.
• Resolving the MQ related issues.( Messages are struck in queues, Messages are in validation state)
• Set up email profiles. Configuring and managing communication management component group.
• Configuring & managing Workflow Management component group. Create WF monitor agents as per requirement.
• Automated the daily health check of application using UNIX shell scripts.
• Running generate triggers to support WF policy.
• Opening SR with oracle in case of critical issues
• Co-coordinating with different teams.
• Migration of BIP reports.
• Supporting dev teams in increasing log levels and providing log files from QA and Stage environments.
• Generating .csv files from the .fdr files using sarmanalyzer utility
• Running DDLSync in all the environments.
• Supporting database refresh activity from prod to UAT (Stage).
• Encrypting email and phone numbers after the refresh from prod to stage
• Changing communication profile.
• Automated Component, RCR, memory utilization, CPU utilization and s escl req table monitoring

Environment: UNIX Solaris10, Siebel Call Center, Siebel eChannle, Siebel Loyalty, Siebel eLoyalty, Siebel Marketing,Siebel 8.1, Oracle 10g, JMS, MQ, Siebel Web Service, BIP, UCM ,Siebel Tools, PL/SQL, eScript, Workflow.
Confidential

Minneapolis, MN

Responsibilities:

• SIEBEL server installation & configuration, Patch management
• Siebel version upgrade.
• Setting up Siebel tools, Mobile/dedicated client
• SRF, Repository migration. DDL synch.
• Performance tuning
• Supporting Production environment which includes
• Maintaining high application availability
• Planning and co-coordination of production release.
• Daily health checks which includes regularly checking status of servers & components. Checking status of JOBs/RCRs/ Tasks. Server resource monitoring(CPU/Memory/Disk space)
• Supporting all planned & unplanned outages
• Supporting Test and Development environments which includes
• Setting up tools/mobile client for developers
• Extracting local databases for developers
• Migrating SRF/Repository from Development to Test environment
• Deploying non repository items
• Supporting performance testing in Test(QA) environment
• Supporting all planned & unplanned outages
• Set up and support Siebel remote. This includes registering user as mobile client, extracting local database, creation of packager, upgrade kits etc
• Set up email profiles. Configuring and managing communication management component group
• Configuring & managing Workflow Management component group. Create WF monitor agents as per requirement.
• Integrating other applications with Siebel. Mainly OBIEE/BIP/Web Methods. This includes configuring symbolic urls, WSDL imports/exports etc.
• Installing and configuring document server
• Database refresh activity
• Setting up SSO/LDAP authentication
• Automation of daily migration/monitoring activities by writing shell scripts or batch jobs
• Resolving all adhoc issues, if issue is not related to Siebel then assign it to correct work-group.
• In case of issues preparing RCA & RCCA documents
• Keep all stake holders updated with progress in case of issues as per SOP.
• Opening SR with oracle in case of critical issues
• Co-coordinating with different teams
• Provided the solution to move data from DB2 to Oracle, which can be implemented in less down time as it is important to the Client
• Worked with database team to analyze the impact at database level.
• Prepared HLD and LLD
• Prepared design plans and user manuals for future reference and guidance
• Installed Siebel Schema in Oracle 10g database.
• Re-pointed enterprise to Oracle 10g from DB2 without reinstalling.
• Export the data from the DB2 UDB tables into flat files.
• Developed UNIX shell script to invoke SQL Loader import process for multiple tables in parallel to reduce the downtime.
• Tuning batch jobs (EIM) as per Oracle 10g.
• Modified UNIX shell scripts for EIM process as per Oracle 10g

Environment: Siebel 8.0, PL/SQL Developer, Microsoft Office 2003/2007, ControlM 6.4, HPSD and Quality Center, Siebel Tools, eScript, Workflow, UCM, UDB DB2, Oracle 10g, Siebel Callcenter, Sun Solaris 10
Confidential

Minneapolis, MN

Siebel Admin

Responsibilities:

• Impact analysis of the application and database due to upgrade.
• Helped client to define requirements and prepare requirement specifications
• Prepared HLD and LLD
• Prepared design plans and user manuals for future reference and guidance.
• Siebel 8.0 Upgrade POC in a separate environment.
• Siebel Installations on new Solaris 10 and windows 2003 servers
• Installed and administered multiple Siebel environments DEV/ TEST/ UAT in Siebel 8.0. Completed a full upgrade of Siebel from 7.5.2 to 8.0. Included upgrade of Siebel Servers, Databases, and Siebel Repository and Web clients.
• Setup of environments (stage, training and prod) in segmented environment to comply under the GLBA act.
• Worked closely with BigIP team to setup load balancing at Siebel server level from Dev to Prod.
• Generated load balancing configuration file on Siebel server
• Download perl script from BigIP site
• Ran perl script on Siebel server by passing lbconfig file and generated BigIP config files.
• Performed upgrade activities Pre Upgrade tasks, Upgrep, Merge Repository, Post Merge and Upgphys.
• Perform dry run in sandbox environments to fine tune the upgrade scripts.
• Worked on configuration and WF changes as part of upgrade
• Helped offshore in modifying EIM batch jobs as per Siebel 8.0.
• Provided solution for extracting Audit Trail information into flat files.
• Had setup and administered complete Siebel 8.0 PROD and UAT environment with clustered gateway configuration and load balanced web and Siebel application servers..
• Designed and created a EIM Conversion program for importing million plus records to Siebel DB. Created Workflows and business services for post import processing to set up primary Ids on imported data.
• Set up eDocument server for eDoc processing. Added new iebel server to an existing enterprise. Designed new templates and customized eDoc processing for member correspondences.
• Customization of Rules for data survivor ship and Matching
• Review configuration of Siebel User Interface for master entities data capturing.

Environment: Siebel 8.0 , Call Center, DB2,Oracle 10g, Siebel Tools, eScript, Workflow, VBC, UCM, Sun-Solaris, , PL/SQL Developer, Microsoft Office 2003/2007, ControlM 6.4, HPSD and Quality Center
Confidential

Minneapolis, MN

Siebel Developer

Responsibilities:

• Impact analysis of the application and database
• Helped client to define requirements and prepare requirement specifications
• Prepared HLD and LLD
• Prepared design plans and user manuals for future reference and guidance
• Configuration, creating/modifying applets, Views, Screens, BCs, BOs, WF and Business Services based one new requirements and enhancements.
• Create VBC based integration (EAI) with TSYS system to show the Credit Card customer information in Siebel UI.
• Developed EAI HTTP Transport service to pull the TGR Account information from ADW in real time.
• Created EAI Inbound Web Services to publish a service to external system to access the TGR Guest Information.
• Created EAI Outbound Web Service to send and update the Service request information as when created to other internal system in realtime.
• Worked on different BS like EAI Siebel Adapter, EAI XML Converters, XML gateway as part of VBC and Inbound Web service integration.
• Developed/Modified complex WFs like eMail response WFs.
• Developed eScripting for various complex solutions like loading Users through excel, parsing Siebel message/ XML message, getting latest email from assigned queues for a user etc.,
• Setting up the document server on windows machine to generate and merge the correspondence.
• Modifying eMail Response WF based on requirements.
• Integrating Siebel with Avaya CTI 7.0.
• Creating Communication templates for CTI Integration.
• Setting Communication profiles and Response groups to receive and send emails.
• Used Communication outbound manager to send emails.
• Working on Siebel UCM application which includes
• data survivor ship Customization and Matching
• Review configuration of Siebel User Interface for master entities data capturing.
• Integration with new source systems
• Preparing shell scripts in UNIX and Pl/SQL to load the flat files into Temporary tables perform data cleansing and load into EIM tables.
• Developing EIM import IFB files to load account contact and address information coming from mainframe source systems.
• Prepare EIM Merge IFB files to merge duplicate contact records which were loaded from multiple systems.
• Prepare EIM delete IFB files to delete historical account, contact, service request and Activities based on the defined criteria.
• Debugging EIM Import related issues by analyzing EIM component logs.
• Performed Admin tasks like SRF migration, bouncing components etc., in development server for UNIT testing.
• Created RCR to invoke WF which updates the SR and activity information.
• Created Run Time events to trigger BS and WF based on events.
• Setting up Siebel Tools/Clients for new team members.
• Support QA and UAT phases.

Environment: Siebel 7.5.. Siebel Call Center, DB2, Siebel Tools, eScript, Workflow, VBC, Siebel UCM, Windows, Sun-Solaris, PL/SQL, Microsoft Office 2003/2007, Control-M 6.4, HPSD and Quality Canter.