SUMMARY

• Over 15 + years of IT experience in Siebel implementation, administration, support and design of enterprise applications in covering all the stages of the SDLC. Past 13 years concentrated exclusively on the Siebel CRM applications.
• Skilled with the Administration of Siebel Components and Siebel Servers in various environments and SRF change, bounce server\SRF Migration (Dev2Prod) from one environment to another.
• Experience in Healthcare, Communications, Sales, Call Center, Finance, Public Sector, Marketing and Consumer Goods Industries.
• Worked on Remote Administration and trouble shooting Siebel Remote, trickle Sync issues and Server components Siebel Transaction Processor, Merger and Routers.
• Hands - on experience with Siebel Server administration on Application deployment manager (ADM), managing server tasks, setting up new user’s access for developers, code migration, automated import /export, DDL Sync processes.
• Siebel Server Setup -Configuration & Installation of SSO/LDAP for OBIEE, Informatica, DAC for development & QA Environments
• Daily health checks which includes regularly checking status of servers & components. Checking status of JOBs/RCRs/ Tasks. Server resource monitoring (CPU/Memory/Disk space)
• Experience in project and quality management activities such as preparing Project Metrics (Schedule Metrics, Effort Metrics, and Defect Metrics), Effort Estimation, Root Cause Analysis and Risk Management Plan.
• Comprehensive knowledge on Siebel Data Conversion, Siebel Configuration, data loading techniques and using EIM, SQL Loader, DTS, ETL experience in setting Siebel environments and creating a customized packagers for end users.
• Worked extensively in design, Configuration, E-Script, State models and Siebel Data model.
• Skilled with integration and EIM technologies, involved in all stages of Project Lifecycle including Project Design, Project Development, Testing, Implementation, Modifications, Enhancements, Production Support, Configuration and Installation, Planning and Management.
• Good UNIX\ Linux skills and possess working knowledge of shell scripting and windows batch programming.
• Experience in Siebel Tools Configured Screens, Views, Applets, Business Objects, Business Components, Business Services, Drill Downs, Pick lists, Multi value Groups, Workflows, scripting as per the Client needs.
• Team management skills\ good communication skills and a very good team player.
• Highly motivated and a quick learner, with excellent communication skills with multiple levels of the organizations.

PROFESSIONAL EXPERIENCE

Senior Siebel Admin/OBIEE

Confidential, Fallon, MO

Responsibilities:

• Responsible for repository migration between the environments including the OBIEE RPD deployments and informatica repository migration \mappings\workflows along with DAC import and export tasks.
• Successfully upgraded Siebel 8.x to Siebel IP 2014 and resolved the issues encountered during the upgrade.
• Installed and maintained MDM Projects Informatica ODI, DIH and ALM was configured.
• Worked closely with development/interface team to assist them on the production implementation activities and troubleshooting.
• Planned and established after go-live activities including ongoing support with DBA’s which includes the list of tables and columns to be synced and conflicts.
• Maintained\Approved the Issue Tracking Log and change management tasks in order to resolve the issues with different teams.
• Configured OEM for existing servers for monitoring/troubleshooting the server side agents.
• Worked on ODI/DIH and ILM installations and troubleshooting.

Environment: Siebel Call Center/Siebel Marketing /7.x/8.x/IP2014, Oracle 11g, Windows 7 Enterprise, CTI Avaya, OBIEE 11G, ETL, Oracle Enterprise Manager 11G, Apache2.2x, DAC 11.1x, ESD/BHD, PVCS(version control), Apache WebSphere, Weblogic 11G, Golden Gate 12c, Informatica Data Quality (IDQ), Informatica Master Data Management (MDM), Linux 6.8, AIX Unix 7.1

Siebel Admin ( Consultant)

Confidential, Sacramento, CA

Responsibilities:

• Repository migration between the environments and troubleshoot issues pertaining to the migration and performance tuning including go-live activities for ongoing support
• Troubleshoot issues related with various server components/component groups. Created custom Siebel components for AOM for various requirements for better performance.
• Configured LDAP/Active Directory for user authentication. Built the Siebel Environments with Gateway, Application Server and SWSE for upgrade activities.
• Assisted developers in adding new columns to existing tables or adding new tables in order to meet the needs.
• Responsible for repository migration between the environments including the OBIEE RPD deployments and informatica repository migration along with DAC Repository import and export tasks.

Environment: Siebel Public Sector 8.2.2.2 SIA, Oracle 11g, BI Publisher, Oracle Enterprise Manager, OHS 11g, OBIEE 11g, Informatica 9.1.0, DAC 11.1x, Tortoise SVN, XL Deploy 4.5.1

Siebel Admin ( Consultant)

Confidential

St Louis, MO

Responsibilities:

• Repository migration between the environments and troubleshoot issues pertaining to the migration and performance tuning including go-live activities for ongoing support
• Troubleshoot issues related with various server components/component groups. Created custom Siebel components for AOM for various requirements for better performance.
• Configured LDAP/Active Directory for user authentication. Configured Load balanced URL Siebel application with F5 and OHS
• Built the Siebel Environments with Gateway, Application Server and SWSE for upgrade activities.
• Worked on Oracle Query Optimization and performance tuning and best practices.
• Assisted developers in adding new columns to existing tables or adding new tables in order to meet the needs. Involved in the upgrade activities from Siebel 8.0. to 8.1
• Installed Web Logic Server. Involved on Proof of concept for Oracle EDQ for future requirement.

Environment: Siebel Fins\UCM 8.1.1.11, Siebel Tools, Oracle 11g, RHEL 6.5, CTI Avaya, BI Publisher, Oracle Enterprise Manager, OHS 11g, Trillium 12.0, Oracle EDQ 12.1

Senior Siebel Admin ( Consultant)

Confidential, O Fallon, MO

Responsibilities:

• Responsible for repository migration between the environments including the OBIEE RPD deployments and informatica repository migration\mappings\workflows along with DAC import and export tasks.
• Troubleshoot issues pertaining to the migration and performance tuning. Maintained details about the code base information for environments and giving the support.
• Worked closely with development/interface team to assist them on the production implementation activities and troubleshooting.
• Troubleshoot issues related with various server components/component groups. Created new custom components for JMS Receiver to have better performance.
• Worked extensively on Oracle Query Optimization and performance tuning and PCI Re-Certification Activities.
• Planned and established after go-live activities including ongoing support with DBA’s on implementing the Golden Gate on Siebel Database, which includes the list of tables and columns to be synced and conflicts.
• Worked closely with Oracle TAM on severity 1 SR’s for production fix.
• Maintained\Approved the Issue Tracking Log and change management tasks in order to resolve the issues with different teams. Configured OEM for existing servers for monitoring.

Environment: Siebel Call Center 8.1.1.9,Siebel Marketing 8.1.1.9, Siebel Tools, Oracle 11g, Windows XP Professional, RTD, CTI Avaya, OBIEE, ETL, Oracle Enterprise Manager,Apache2.2x, DAC,ESD/BHD, AIX Unix 7.1, ksh scripting, PVCS(version control), Apache WebSphere, Golden Gate 12c

Confidential, Westchester, PA

Responsibilities:

• Responsible for repository migration between the environments.
• Troubleshoot issues pertaining to the migration and performance tuning.
• Maintained details about the code base information for environments and giving the support.
• Worked closely with development/interface team to assist them on the implementation activities.
• Troubleshoot issues related with various server components/component groups.
• Worked with Siebel support for the issues opened for the server components.
• Involved in the upgrade activities for Siebel Objects.
• Built the Siebel Environments with Gateway, Application Server and upgrade activities.
• Planned and established after go-live activities including ongoing support.
• Documented technical, configuration changes and architectural changes regularly.
• Worked as Administrator in adding new columns to existing tables or adding new tables in order to meet the needs.
• Have used .bat script files for automating server related jobs.
• Maintained the Issue Tracking Log and manage the resolution of those issues with the developers.

Environment: Siebel Call Center 8.1.1.3, Siebel Tools, Oracle 10g, Windows XP Professional, RTD, CTI Avaya, OBIEE, ETL, TIBCO

Siebel Admin\ EIM Consultant

Confidential, Indianapolis, IN

Responsibilities:

• RResponsible for deploying code in QA and production environment. Responsible for post-production support and assistance for post go-live activities.
• Worked EIM process through UI, reviewed EIM logs to configure the IFB files for optimization.
• Used SQL statements using TOAD to validate the Data. Configured IFB file to populate the corresponding table to EIM table. Worked extensively on Oracle Query Optimization and performance tuning.
• Involved in document technical changes, configuration changes and architectural changes regularly.
• Responsible for installation and administration of Siebel CRM - Gateway, Application Servers, SWSE and OBIEE Servers for development and testing environments.
• Worked in Remote Administration and trouble shooting Siebel Remote components, trickle sync issues and server components Siebel Transaction Processor, Merger and Routers.
• Updated Functional Specification documents to reflect changes made in the application. Participated in requirement analysis, use case analysis and identified gaps in the application.
• Served as Administrator in adding new columns to existing tables or adding new tables in order to meet the needs.
• Maintained the Issue Tracking Log and managed the resolution of those issues with the developers.
• Assisted technical programmer analysts in the design, development and testing of application system corrections or enhancements by analyzing modifications recommended, determining system impact and estimating effort for trouble shooting and resources required to perform modification; oversaw implementation and troubleshooting complex tasks and issues on new enhancements/projects. Understood overall business operations and develops innovative solutions to help improve productivity.
• Monitored migration of new and revised applications through user acceptance and production regions to ensure adequate pre-production test planning and execution in coordination with established quality assurance policies and procedures.
• Created reviews and updates application documentation and training material to ensure that information is accurate, relevant, and current and user friendly.
• Reviewed testing progress; managed issues/risks relating to System Test Team. Have executed/created ksh scripting for automating jobs

Environment: Siebel Life Sciences 7.8, 8.0, Siebel Tools, Oracle 10g, Windows XP Professional, Sun Solaris 7.0, ESB, Biz Talk, Citrix, ksh scripts, Siebel Remote Administration, Siebel Anywhere

Siebel EIM Consultant

Confidential, NJ

Responsibilities:

• Developed external interfaces, including EIM (Enterprise Integration Manager) and EAI (External Application Integration).
• Imported data using SQL LOADER, MS-ACCESS and DTS for EIM CONTACT, EIM OPTY, EIM POSITION and EIM ACTIVITY. Configured IFB file to populate the corresponding table to EIM table. Extracted data from legacy systems of Medco and importing to Siebel.
• Worked EIM process through UI and Command prompt, reviewed EIM logs to configure the IFB files for optimization.
• Assisted technical programmer analysts in the design, development and testing of application system corrections or enhancements by analyzing modifications recommended, determining system impact and estimating effort for trouble shooting and resources required to perform modification; oversaw implementation and troubleshooting complex tasks and issues on new enhancements/projects. Understood overall business operations and develops innovative solutions to help improve productivity.
• Ensured that new functionalities/projects are architected leveraging best practices and the latest technology - platform.
• Monitored migration of new and revised applications through user acceptance and production regions to ensure adequate pre-production test planning and execution in coordination with established quality assurance policies and procedures.
• Created reviews and updates application documentation and training material to ensure that information is accurate, relevant and user friendly.
• Configured Workflows, Runtime events and Triggers for various business requirements.
• Responsible for releasing the products so that the user can use it for quotes.
• Troubleshot EAI issues either by increasing log levels in the Object Manager or trapping Siebel error by building custom function which in turn writes the Siebel errors in a file/System.
• Used Symbolic URL to show remedy application screen from Siebel application.
• Worked on workflow and state model to restrict the users from updating certain fields based on state model in opportunity.
• Created Integration Object and Workflow to import updated contact/user information daily from external system to Siebel. Once the Profile has been modified in Siebel another business process triggers which in turn generates a flat file with the following information (First Name, Last Name, PHI Address of any or Correspondence address and standard letter template information about their change in user profile).
• Configured Workflow Policy, Policy Actions, Runtime events and Triggers for various business requirements.
• Extracted local database from the server database so that developers can work in their area/module.
• Created and modified applets, views, and screens and attaching all these Objects to the corresponding application. Extended the Siebel database using the data object layer.
• Responsible for creation and maintenance of Migration Checklist, Technical Design Documents as per functional requirement document and Data mapping documents for interface external systems.
• Involved in document technical changes, configuration changes and architectural changes regularly.
• Updated Functional Specification documents to reflect changes made in the application.
• Coordinated with the team members to implement the Siebel code review changes and to improve the overall performance of the system.

Environment: Siebel Life Sciences 7.8/Siebel Sales 7.5.3, Siebel Tools, Oracle 9i, Windows 2000, Citrix

Senior Siebel Consultant

Confidential

Responsibilities:

• Coordinated with the onsite team and meeting the deliverables of the client.
• Created and modified Business Components and Business Objects-definitions in the Business Object Layer.
• Created and modified applets, views and screens and attaching all these Objects to the corresponding application. Extended the Siebel database using the data object layer.
• Gathered Client Requirements to upgrade the Siebel System from 7.5 to 7.8.
• Worked EIM process through UI, reviewed EIM logs to configure the IFB files for optimization.
• Used SQL statements using TOAD to validate the Data. Configured IFB file to populate the corresponding table to EIM table.
• Involved in testing the Application and also involved in Bug fixing.
• Served as key player in handling daily client calls to interact with business users for Siebel, Siebel data model and Development related issues & critical problems.
• Participated in requirement analysis, use case analysis and identified gaps in the application.
• Worked with administrator in adding new columns to existing tables or adding new tables in order to meet the needs.

Environment: Siebel Sales 7.7, Siebel Tools, Oracle 9i, Windows 2000, Citrix

Siebel Consultant

Confidential

Responsibilities:

• Created and modified Business Components and Business Objects-definitions in the Business Object Layer.
• Worked on workflow and state model to restrict the users from updating certain fields based on state model.
• Created Business service and Integration Objects to load data into Siebel for Inbound data using HTTP.
• Created Integration Objects for integrating Java application, to get the Account details which in terms created in Siebel Account.
• Responsible for reviewing technical design documents, functional requirement documents and data mapping documents for external interface systems
• Created and modified applets, views, and screens and attaching all these Objects to the corresponding application. Extended the Siebel database using the data object layer.
• Worked EIM process through UI, reviewed EIM logs to configure the IFB files for optimization.
• Used SQL statements using TOAD to validate the Data. Configured IFB file to populate the corresponding table to EIM table.
• Participated in requirement analysis, use case analysis and identified gaps in the application.
• Worked with administrator in adding new columns to existing tables or adding new tables in order to meet the needs.
• Served as key player in handling daily client calls to interact with business users for Siebel, Siebel data model and development related issues & critical problems.
• Provided production support for users, and fixing the issue tickets.
• Involved in Integration testing of the application and also involved in bug fixing.
• Coordinated with the onsite team and meeting the deliverables of the client.

Environment: Siebel Sales 7.8, Siebel Tools, Oracle 9i, Windows 2000, Citrix, Sales force

Siebel Consultant

Confidential

Responsibilities:

• Modified Siebel Business Components, Business Objects, Applets, Views and Screens.
• Modified/Created the user interfaces for Accounts, Contacts, Products, Activities and Orders Screens.
• Created Static, Dynamic Pick Lists, Joins, Multi value Links and MVG Applets.
• Implemented Validation, Calculated Fields and Business Component User Props for various Business Component Fields.
• Used Siebel e-scripts to write a script to extend data validation beyond the validation already provided in the Siebel standard applications.
• Involved in EIM data loading and configuration of various modules, extensively used SQL statements using TOAD to validate the Data.
• Used Data Mapping from Legacy system to Siebel 7.5.3 using EIM Data Mapping. Performed Data Extraction from the legacy systems and imported to Staging Tables using SQL Loader.
• Played a successful role in coordinating with Off Shore Team to develop the integration piece.

Environment: Siebel CRM 7.5.3, Siebel Tools, Siebel Workflow, Oracle 9i, Windows 2000, VSS

Siebel Consultant

Confidential

Responsibilities:

• Designed, developed and integrated Siebel with other external applications for retrieving inventory Details for sales reps in order to display available products for required customers.
• Extracted local database from the server database so that developers can work in their area/module
• Created and modified Business Components and Business Objects-definitions in the Business Object Layer, Integration Objects for integrating DBOR application, to get the inventory details of product availability from the DBOR system and populate the link to open the inventory sheet from the Siebel.
• Administered Siebel components and Siebel Servers in various environments as and when necessary.
• Created\Modified UI elements like applets, views, MVGs, added/modified views for purpose of EAI requirement, Static, Dynamic Pick Lists, Joins, Multi value Links, drilldown and MVG Applets.
• Implemented Validation, Calculated Fields and Business Component User Props for various Business Component Fields.
• Served as key player in handling daily client calls to interact with business users for Siebel, Siebel data model and Development related issues & critical problems.
• Responsible for interaction with UAT groups and documented UAT suggested enhancements, Understood Business Process Requirements; involved in Unit and System testing.
• Performed Usability testing for the entire application, was leading a team of six, provided end to end testing of Data based on business requirements from Siebel UI.

Environment: Siebel eCommunications 7.5.3 and eChannel, Siebel Tools, Oracle 9i, Windows 2000

Siebel Consultant

Confidential

Responsibilities:

• Involved in configuration management, training and knowledge/skill management.
• Modified Siebel Vanilla Business Components, Business Objects, Applets, Views and Screens.
• Created Static, Dynamic Pick Lists, Joins, Multi value Links and MVG Applets.
• Implemented Validation, Calculated Fields and Business Component User Props for various Business Component Fields.
• Used SQL statements using TOAD to validate the Data.
• Added new Joins, Links as required; created new static and dynamic pick lists and MVG.

Environment: Siebel call center 7.5, Siebel Tools, Oracle and Windows 2000

Siebel Configurator

Confidential

Responsibilities:

• Tested the data with respect to Business requirements Test Director.
• Created joins, static\ dynamic pick lists, multi value fields and MVG.
• Documented test plan\cases, test results, test procedure and reported to client.
• Provided mapping of objects like business components, creating applets, views, screens etc.
• Developed Test Cases and tested all Client side scripts, server side scripts and the User Interface.
• Implemented data layer changes like extending database table columns and applying the changes.
• Developed test cases and executed them to test secured on-line transactions through HTTPS.
• Involved in Unit and System testing; involved in bug fixing in testing phase.

Environment: Siebel sales 7.0.3, Siebel Tools, MS SQL Server, Windows 2000

Siebel QA

Redback Networks

Responsibilities:

• Designed and developed test plans according to user requirements.
• Developed test cases and executed them to test Secured on-line Transactions through HTTPS.
• Configured Applets, Views and Screens at the user interface layer.
• Provided End to End testing of Data based on Business requirements from Siebel UI.
• Suggested configuration changes based on the client requirements.
• Gathered client requirements to enhance the New System.
• Designed the Siebel application based on the business requirements.
• Created Integration Object, Business Services for integration.
• Participated in requirement analysis, use case analysis and identified gaps in the application.
• Added new Joins, Links as required; created new static and dynamic pick lists and MVG.
• Involved in client interaction and freezing of requirements.
• Involved in implementation of sales management software.
• Involved in Test Plan and Test Script; prepared the MIS Stock Reports.

Environment: Visual Basic 6.0, SQL Server 7.0, Crystal Reports