SUMMARY

• Around 10+ years of experience in the IT Industry, around 10+Years of experience in the implementing/Supporting various Siebel Applications, 6+ Years of experience in Siebel CTMS (8 Projects) and 4+ Years in Siebel CRM (2 Projects).
• 10+ years of experience in design, Admin, development and maintenance of critical and time bound software applications, which include extensive experience in customization of Siebel ebusiness applications.
• Proficient in the configuration of Data Objects Layer, Business Objects Layer, and User Interface Layer.
• Experience in Siebel Configuration, Siebel Scripting, Siebel Workflow, Siebel EAI, Siebel EIM, Siebel Business Services, Web Services, etc.
• Hands - on experience in SQL, PL/SQL and RDBMS like Oracle 9i/10g/11g/12c and SQL Server.
• Experience in Siebel Client Customization of Siebel Call Center and Siebel Clinical.
• Siebel server installation & configuration, Patch management and Siebel version upgrades.
• Siebel server installation in multiple operating system environments such as UNIX, Linux, Windows.
• Development of functional and technical specifications according to the client requirements.
• Siebel administration, application and interface development.
• Excellent troubleshooting skills and Ability to clearly understand and articulate complex problems.
• Very strong interpersonal skills able to work at all levels of the organization.
• Data analysis and operational support.
• Providing technical expertise to peers, associates and management.
• Worked in concepts like Integration Objects, Data Map, VBC, EBC, Web Services, SSO, LDAP authentication, etc.
• Extensive Knowledge with CSS (Cascading Style Sheets), web templates and Java Script.
• Good working knowledge of Siebel Enterprise Integration Management (EIM).
• Experience and knowledge of the integration of Siebel with other systems.
• Hands-on experience in Database support and Installation and upgrades.
• Experience on integrating Siebel with Business Intelligence Publisher.
• Having experience on configuring Siebel remote clients.
• Having experience on server maintenance and server Components.
• Having experience on creation BIP custom reports and OBIEE Dash boards.
• Good functional knowledge and experience in implementing Siebel CTMS.
• Functional and support management expert in Siebel Clinical 8.x CTMS area.
• Business Process Knowledge of Clinical Trails (CTMS), Sales Cycle, Customer Service, Service, Quoting, Order Management, Pricing, Opportunity Management.
• Domain expertise in Sales, Marketing, Service, Manufacturing, Life Sciences (eClinical/ CTMS).
• Expertise in implementing multilingual rollout in English, German, French and Spanish languages.
• Technical expertise in Siebel Configuration, Workflows, eScripting, BIP Reports, TM, EIM (Data Migration/Conversion), EAI (Inbound & Outbound), Informatica,Veeva valut and Conga.
• Proficient with Siebel Tools/Client and Customizing of Siebel objects at multiple levels like Applets, Business Components, Screens, Views, and Joins. Links, MVGs, Pick Applet, Pick lists, Shuttle Applets, Toggle Applets and Drilldowns, User Properties.
• Performed Data Mapping, Bulk imports of data from Flat files/Other Systems to Base tables using EIM.
• Strong knowledge in Siebel CRM Data Model. Expertise in the underlying Siebel (PARTY) data model and Good experience in SQL, PL/SQL, SQL Loader, RDBMS Concepts. Experience in end to end Siebel EIM Process.
• Strong experience in Siebel EIM Process, Developing IFB Files, and Control files, PLSQL Procedures, Validation Scripts, Troubleshooting EIM Issues, and Performance Tuning. Worked on data Loads for Custom Tables/columns, Developed eScript for Data Loads into Siebel Custom Tables and also User key Updation for Accounts & Products using EIM.
• Good Experience in Developing Siebel Workflows, Workflow Policies, Run Time Events, Scheduling Workflows Using RCR Components, Sending Emails through Workflows, Email Templates.
• Good in Siebel eScript at Applet and Business Component level and good in Developing Siebel Custom Business Service.
• Experience in Siebel EAI including inbound/Outbound Process using Web services, MQ Series, HTTP and JMS Integration and also Developing VBC, EBC and Integration Objects.
• Good in Developing Siebel Integration Objects for BIP Reports, Devolving RTF Templates as per Client requirement, Generating XML files, Developing Siebel Custom Reports.
• Performed various Siebel Runtime Setups like Siebel Responsibilities, Views, User Setup, Positions, User Lists, Access Groups, Catalog-Categories, and Run time events, State Models, MLOV/LOV and Pre Defined Queries.
• Experience in monitoring/managing implementation of end-to-end ETL system. Experience in development, maintenance, and enhancement of Informatica Mappings, Workflows, etc.
• Created theQlikviewdashboard user interfaces as per the client requirements, by using different multiple charts such as Pivot, List, Multi-box, Trends, KPI's, custom requests for excel export and fats change objects for dashboard reports.
• Designing Data Mart &Data Warehouse and Implementation of QlikView for BI (Business Intelligence) Reporting Solutions. Good in Data Modeling (Star Schema, Snow Flake Schema) & Loading data from multiple data sources.
• Experience in Incremental Loading, Partial Load & Binary Loads &QlikViewDocument Versioning.
• Experience in developing Java API’s to integrate with Siebel application
• Expertise in Visual Basic programming.

TECHNICAL SKILLS

Siebel: Siebel Tools (7.7 and 8.0, 8.1.1 to 8.1.1.14), Siebel Innovation Packs (IP15,IP16), eScript, Siebel Configuration, Siebel Administration, Open UI, Siebel Upgradation, Siebel EIM, Siebel EAI, Siebel Open UI

RDBMS: Oracle 9i/10g/11g,12c SQL Server 2000,2005,2008,2012

Languages: C,C++,HTML,.Net, C##,Java

Operating Systems: Windows, Solaries,Linux

Reporting Tools: BIP 10g and 11g and 12c OBIEE11g, Tableau

PROFESSIONAL EXPERIENCE

Confidential, New York

Oracle Siebel CTMS (eClinical / Oracle Siebel CTMS)

Responsibilities:

• Integrated Siebel application with Veeva Vault application.
• Upgraded Siebel application from 8.8 to 16.11.
• Customized Siebel application as per CTMS process by using open UI methods like CSS, Java Scripts.
• Designed the Siebel BIP reports in different screens level in the application.
• Worked on Siebel EIM Import Process for Objects like Clinical Protocols, Clinical Regions, Documents, Protocol attachments and Activities etc…
• Worked on the PL/SQL stored procedures to create EIM Automation process.
• Worked on CTMS Application objects like Protocols, Regions, Protocol Sites, Subjects, Activities, Payments, Clinical Trip Reports, Products, Accounts, Contacts, and Administration of Clinical etc.

Environment: Siebel Configuration, Workflows, eScript, BIP Reports, EIM, Veeva Vault

Confidential

Oracle Siebel CTMS IP 16 (eClinical / Siebel CTMS)

Responsibilities:

• Perform requirement Analysis, Identify root causes of data issues and recommend application, process, and education changes to eliminate each data issue.
• Review and refine requirements, review functional design documents, and develop technical design document.
• Review oracle objects such as Tables, Views, and Indexes structure to ensure they are compliant with legacy systems.
• Develop Informatica Mappings, Workflows etc to migrate data from multiple systems into Siebel CTMS, as per business requirements.
• Develop Oracle Functions, Stored Procedures and Triggers etc.
• Prepare Source Legacy -Target Siebel Mapping Sheet.
• Prepare ifb files.
• Design and develop process to migrate data from one Siebel System to another Siebel System using Siebel EIM.
• Implement Audit Trail to conform to Federal Regulatory Laws.
• Consult with SME's in numerous departments to develop lists of values for all fields in the new system.
• Created Unit Test cases and involved in fixing defects, System Testing, Integration Testing.
• Debugging issues with the help of Siebel log events, Server logs, Spool files and Workflow Instance monitoring.
• Developed Business Services, Workflows and worked on complex business requirements using e-script, run time events, DVMs etc.
• Designed, developed and supported Siebel EAI, Configuration, Scripting, Workflows.
• Worked on Stored Procedures for automation of batch jobs.
• Proficient with Siebel Tools and Client in configuration and customization of Siebel Objects at multiple levels like but not limited to Screens, Views, Applets, Business Objects, Business Components, Links, Joins, Drill Downs, Pick lists, Pick Applets, MVG, Associate & Shuttle Applets and User Properties.
• Worked extensively on eScript coding, implementing customized logic in applications, applets, and business components with Browser Script or Server Script.

Environment: Siebel CTMS Configuration, Workflows, eScript, BIP Reports, EIM, EAI, Qlikview

Confidential

Oracle Siebel CTMS (eClinical / Oracle Siebel CTMS)

Responsibilities:

• Customizing of Siebel objects at multiple levels like Applets, Business Components, Screens, Views, and Joins. Links, MVGs, Pick Applet, Pick lists, Associate and shuttle Applet and Drilldowns.
• Implementing Siebel declarative Configuration Alternatives, workflows, Runtime events and Workflow Policies to meet business requirements.
• Worked on Application Setups like LOVs, Views, Responsibilities, Positions, State models, Users setup.
• Developed Business Services and eScript at applet & Business Component level as per Business Requirements.
• Developed Siebel Interfaces/Integrations with Medidata Rave Application (EDC).
• Developed Siebel Inbound Integration with Medidata Rave for getting the data. Developed Siebel IO’s, Business Services, and Workflows for Integration.
• Developed Siebel Integration Objects for BIP Reports and RTF Templates, Custom BIP Reports.
• Worked on Data loads like Protocol Sites, Site Visits, Subjects, Products, Contacts, Accounts, Activities
• Developed PLSQL Procedures for CTMS Data Loads Scheduling & developed IFB files, Control files, Validation Scripts.
• Developed Multiple Dashboards using Qlikview for Data Visualization, Developed KPI's and set analysis applications.Requirement gathering & designingQlikview applications. Developed Dashboards for financial Information, SAE, Protocols/Regions, Sites, Subjects Information.
• Writing SQL Scripts to load the relevant Data inQlikview Applications, Developed QV scripts to handle requirements and performed unit testing throughQlikview binary load.

Environment: Siebel CTMS Configuration, Workflows, eScript, BIP Reports, EIM, EAI, Qlikview

Confidential

Oracle Siebel CTMS 8.1 (eClinical / Siebel CTMS)

Responsibilities:

• Worked on CTMS Application objects like Protocols, Regions, Protocol Sites, Subjects, Activities, Payments, Clinical Trip Reports, Products, Accounts, Contacts, Administration of Clinical etc.
• Involved in end to end EIM Process Import, Export, Delete for Objects like Clinical Subjects, Clinical Site Visits, Activities, Accounts, Contacts, Administration Data like LOVS, Responsibilities, Employees, Views, etc..
• Strong in Troubleshooting Siebel EIM issues, Performed Data Mapping, Bulk imports of data from Flat files/Other Systems to Base tables using EIM. Worked on Data Extraction, Data Cleansing, and Data Load in Siebel EIM.
• Developed Control files, Validation Scripts, IFB files based on Business Requirements.
• Worked on data Loads for Custom Tables/columns, Developed eScript for Data Loads into Siebel Custom Tables.
• Developed BIP Reports for Clinical Trials Data and Clinical Trip Reports, Sites, Regions, Protocols Summary
• Customizing of Siebel objects at multiple levels like Applets, Business Components, Screens, Views, and Joins. Links, MVGs, Pick Applet, Pick lists, Associate and shuttle Applet and Drilldowns, IO’s.
• Implementing Siebel declarative Configuration Alternatives, workflows, Runtime events and Workflow Policies and Custom Business Services and eScript at applet & Business Component level as per Business Requirements.
• Developing Siebel Inbound & Outbound Web services for Integration.

Environment: Siebel CTMS Configuration, Workflows, eScript, BIP Reports EIM

Confidential

Oracle Siebel CTMS (eClinical / Oracle Siebel CTMS)

Responsibilities:

• Worked on Siebel EIM Import Process for Objects like Clinical Subjects, Sites, Site Visits, Subject Visits, and Activities etc…
• Developed Control files for SQL Loader to Load the data into Database from Flat files. Developed PLSQL Procedures for Scheduling Data Loads into Siebel from Other Applications. Developed IFB Files for Import, Export and Delete Process.
• Worked on CTMS Application objects like Protocols, Regions, Protocol Sites, Subjects, Activities, Payments, Clinical Trip Reports, Products, Accounts, Contacts, Administration of Clinical etc.
• Developed BIP Reports for Clinical Trials Data and Clinical Trip Reports, Sites, Regions, Protocols Summary
• Customizing of Siebel objects at multiple levels like Applets, Business Components, Screens, Views, and Joins. Links, MVGs, Pick Applet, Pick lists, Associate and shuttle Applet and Drilldowns, IO’s.
• Implementing Siebel declarative Configuration Alternatives, workflows, Runtime events and Workflow Policies and Custom Business Services and eScript at applet & Business Component level as per Business Requirements.

Environment: Siebel Configuration, Workflows, eScript, BIP Reports, EIM

Confidential

Oracle Siebel CTMS (eClinical / Oracle Siebel CTMS)

Responsibilities:

• Customizing of Siebel objects at multiple levels like Applets, Business Components, Screens, Views, and Joins. Links, MVGs, Pick Applet, Pick lists, Associate and shuttle Applet and Drilldowns.
• Implementing Siebel declarative Configuration Alternatives, workflows, Runtime events and Workflow Policies to meet business requirements.
• Worked on Application Setups like LOVs, Views, Responsibilities, Positions, State models, Users setup.
• Developed Business Services and eScript at applet & Business Component level as per Business Requirements.
• Developed Siebel Interfaces/Integrations with Medidata Rave Application (EDC).
• Developed Siebel Inbound Integration with Medidata Rave for getting the data. Developed Siebel IO’s, Business Services, and Workflows for Integration.
• Developed Siebel Integration Objects for BIP Reports and RTF Templates, Custom BIP Reports.
• Worked on Data loads like Protocol Sites, Site Visits, Subjects, Products, Contacts, Accounts, Activities
• Developed PLSQL Procedures for CTMS Data Loads Scheduling & developed IFB files, Control files, Validation Scripts.
• Developed Multiple Dashboards using Qlikview for Data Visualization, Developed KPI's and set analysis applications.Requirement gathering & designingQlikview applications. Developed Dashboards for financial Information, SAE, Protocols/Regions, Sites, Subjects Information.
• Writing SQL Scripts to load the relevant Data inQlikview Applications, Developed QV scripts to handle requirements and performed unit testing throughQlikview binary load.

Environment: Siebel CTMS Configuration, Workflows, eScript, BIP Reports, EIM, EAI, Qlikview

Confidential

Oracle Siebel CTMS (eClinical / Oracle Siebel CTMS)

Responsibilities:

• Customizing of Siebel objects at multiple levels like Applets, Business Components, Screens, Views, and Joins. Links, MVGs, Pick Applet, Pick lists, Associate and shuttle Applet and Drilldowns.
• Provided solutions and implemented complex and functional logics for entities in the application using workflows, e-scripting and other configuration techniques.
• Imposed the new business rules by implementing validations and restrictions in the application objects through User Properties, Scripting and visibility control using Bus comp view mode objects.
• Implementing Siebel declarative Configuration Alternatives, workflows, Runtime events and Workflow Policies to meet business requirements.
• Developed Business Services and eScript at applet & Business Component level as per Business Requirements.
• Developed Siebel Integration Objects for BIP Reports and RTF Templates, Custom BIP Reports.
• Worked on Data loads like Protocol Sites, Site Visits, Subjects, Products, Contacts, Accounts, Activities

Environment: Siebel CTMS Configuration, Workflows, eScript, BIP Reports, EIM

Confidential

Oracle Siebel CTMS (eClinical / Oracle Siebel CTMS)

Responsibilities:

• Configured and Customized the Siebel applications using Siebel Tools in accordance with the business requirements.
• Siebel Server installations and Components Maintenance.
• Creating Responsibilities and users according to the client requirement.
• Involved in issues like updating the LOV’s based on the business requirements.
• Involved in clearing the performance issues.
• Modified the calculated fields according to the business requirements.
• Involved in creating the workflows according to the business requirements.
• Involved in writing the code for calling the workflow from scripting.
• Involved in creating the new columns in a table.
• Integrating Siebel with BIP.
• Creating report Templates as per requirement.
• Extracting Siebel remote client.
• Taking Database Backups and Siebel Servers backups and repository backups.
• Enabling and disabling server components.
• Assign new parameter values at varies levels.
• Trouble shoot, work closely with client & management.
• Creating new applets and modifying existing applets.
• Configure drilldowns and creating new user properties

Environment: Siebel Configuration, Workflows, eScript, EAI, EIM, SQL/PLSQL

Confidential

Oracle Siebel CTMS (eClinical / Oracle Siebel CTMS)

Responsibilities:

• Review the existing business requirements.
• Prepare configuration plan as per the Siebel 8.0 application functionality.
• Write the unit test cases for the Siebel 8.0 application functionality.
• Involving in the peer to peer review test cases which are prepared by the team.
• Execute the unit cases on Siebel 8.0.
• Setup the 8.0 & back up the exiting repository
• Uninstall all the 8.0 version expect Tools.
• Setup the Target Environment 8.1 except DB configures.
• Stop all the services before db wizard run.
• Troubleshoot issues while running the db wizard.
• After run the upg wizard backup the repository, merge the repositories
• Run the upgphys.
• After complete the upgrade run the admin activities.
• Write Siebel script to improve existing functionalities.
• Enhanced the functionality with Business Component User Properties.
• Configuring Business Components, Business Objects.
• Configuring joins, links, MVL’s, Pick Lists.
• Extending columns on a table, created new Columns.
• Customized User Interface Objects Layer (Drill Downs, Toggles, Views, and Screens. Enhancement of Functionality of Siebel Business Components using Joins, Links and MVG)

Environment: Siebel Configuration, Workflows, eScript, EAI, EIM, SQL/PLSQL