SUMMARY:

• 13 Plus years of IT experience and Siebel Certified Consultant involved in Requirement Analysis, Design, Development, Migration, Support and Maintenance.
• Technical experience involved in Configuration, Upgrade, EIM/EAI, Scripting, Workflow, Business Service, Web Services, Administration, OBIEE and OBI Publisher, Informatica.

TECHNICAL SKILLS:

CRM Applications: Siebel eBusiness Applications (SEA) (IP2016, 8.1.1.8v, 8.1.1.5v, 8.1.1.3v, 7.8.2.3v, 7.7.2.9v, 7.0.2v, 6.8v) Siebel Industry Applications (SIA) (Marketing, Financial, TNT, Public Sector), Localization.

BI Tool: OBIEE 11.1.1.5/10.1.3.4/3/2/1 , Oracle BI Publisher, OBIA 7.9.x

Database Management Systems: DB2, SQLServer 2008, Oracle Database 10g SQL, PL/SQL, 9i, 8i.

Operating System: UNIX, Red Hat - Linux, Sun-Solaris 10.5v and Windows 2008, 2012 Server

Microsoft office Suite: (MS Projects 2003, Power Point, Excel and MS-Word)

Configuration MGMT: PVCS, Rational Clear Quest.

Platforms & Tools used: Toad, Sql, PL/Sql, Sql*Loader, VISIO, and XML.

Middleware: Oracle SOA 10g R1, IBM MQ Series, MS BizTalk 2006 R2.

ETL: ODI 12c, Informatica 9.6V, DAC, Abinitio 10.0.1.3 v GDE, 3.1v Co-Op, SSIS-2008/2012

Framework: JavaScript Framework (JSON), XML SPY, Oracle SOA Suite ESB (Enterprise Service Bus)

PROFESSIONAL EXPERIENCE:

Confidential, Elkridge, MD

Siebel Administrator

Responsibilities:

• Siebel repository migrations, patchset installations and schema synchronizations (Siebel Admin) for Maryland state and county systems and integrated batch interfaces, OracleBI and DQ environments with Siebel systems.
• Extensive experience in Debugging, Optimizing, load balancing and Performance Tuning of OBIEE Dashboards/Reports by implementing Aggregate navigation, cache management.
• Implemented automation script using ADM packages and projects (Siebel Admin) for Repository and Non-Repository object customizations in release migrations
• Troubleshooting production (Siebel Admin) support issues on Avaya Siebel CTI server and Open UI issues on CTI toolbar web template customizations.
• Implemented style sheet (CSS) issues in (OpenUI) on message notification, list column UI alignments, and smartscript wrap-up issues in Siebel toolbar and corrected less section in style sheet.
• Upgraded Siebel from 8.2.2.2v to Siebel 16v (IP2016) (Siebel Admin) and fixed browser script and server script issues in browser compatibility for chrome, IE and firefox.
• Configured custom Virtual Directories in OHS for .net based 3rd party application integrations with Siebel and configured Big IP load balancer.
• Provisioning (Siebel Admin) Siebel Avaya user’s CTI toolbar issues, browser issues and desktop issues and update the DEF file for bug fixing and performance tuning on AMC and Avaya servers.
• Design (Siebel EIM) interface for client, programs, service area, household and address entities and created custom .IFB files to automate batch load jobs.
• Implemented custom PM and (OpenUI) PR JS file for VBC based form applet to resolve the radio button issue for Siebel users to search appropriate customers.
• Implemented configurations for system monitoring and fault detection processes, back up and recovery processes, and appropriate service affecting notification mechanisms using performance tool.
• Installed SSEP to encrypt/decrypt sensitive column’s data from Siebel database to client and masking business data from un-authorized users.
• Fixed issues on 611 language (Siebel Admin) selection causing the timeout in call wrap up popup window in Siebel have provided workaround for while and fixed the issues with CCT team later.
• Installed EDQ and Customized business rules based on profiling (EDQ) and implemented matching and merging based on survivorship rules between county and state systems environments.
• Fixed DOB issue in (OpenUI) calendar applet and provided solutions using (Siebel Admin) locale code from server and runtime table seed data such as short and long date format.
• Provided Siebel deployment strategy for UAT/SIT team testing estimation, (Siebel Admin) and derived deployment plan for HI and (Open UI) repositories.
• Configured EAI component group (Siebel Admin) and profile queuing subsystems based on IBM MQ Series for inbound/outbound message communications between state systems and Siebel system.
• Customized error popup JS (Open UI) file to handle custom popup window to behave similar way as IE popup window for browser script alert and server error handling script alert.
• Maintained and administrating (Siebel Admin) Siebel environment (Dev/UAT/SIT/RGT/PROD) for monthly releases and troubleshooting (Open UI) performance issues in production and non-prod environment.

Environment: Siebel 16v Public Sector, e-Script, OHS 11g, Avaya Interaction Center 9.3.2v, AMC Integration, CTI, HTML, JQuery, AJAX, JSON, Red Hat Linux, IBM MQ Series, SOAPUI, IIS server 7.5v, OBIEE 11g, DAC, Knoa, Weblogic, Oracle11g, Compuware Vantage, F5 BIG-IP.

Confidential, Albuquerque, NM

Siebel Administrator

Responsibilities:

• Implemented new custom Inbound interface (Siebel Admin) for provider to add attachment for their claims using NPI and TaxID through JCAPS (EAI JMS Transport) Queue.
• Configure the ADSI directories for EWCM and PCSC dept to enable users to use (Siebel Admin) web SSO for Siebel and medipac (Java) environments.
• Created OBIEE Catalog Groups and set permissions for items in the presentation catalog and privileges and rights to EWCM users and PCSC groups.
• Enhanced Query performance, by analyzing & modifying SQL Query and Filters, for all OBIEE reports and dashboard prompts, to minimize the delay in Physical Query Execution.
• Troubleshooting ETL, metadata management using DAC, Creating Oracle provided data warehouse BAW,OBIEE RPD development, OBIEE reports and dashboards for providers and Patients by EWCM and PCSC
• Fixed data quality issues in members UCI batch interface using PL/SQL automation framework and (Siebel EIM) jobs for contact and asset entity.
• Prepared batch interface automations between (Siebel EIM) FACETS and Siebel to load providers entity in weekly interval.
• Provided support on agents and (Siebel Admin) VDN# maintenance for PCSC team using Genesys GUD Bridge and Genesys CTI toolbar in Siebel and fixed performance issues in Blind transfer and consultative transfer.
• Fixed certificates issue in IFrame and symbolic URL embedded WebMD application in to Siebel applets for PCSC users want to drilldown the medicine details in SR.
• Prepared custom functions (PLSQL) for cactus PMG provider data load from cactus systems in to Siebel base table.
• Implemented batch assignment (Assignment Mgr) on Service Request for all closed SRs for more than 30 days or 60 days to EWCM Report administrator position.
• Implemented Siebel Inbound (Siebel Admin) Web services to (Siebel EAI) send Siebel notes to FACETS while PCSC agents using Genesys CTI inbound calls.
• Prepared Siebel custom ASI services to create SR in to (Siebel Admin) Siebel for every complaint created using EWCM web (Advocate) portal application by members/patients.
• Troubleshooting Siebel browser related issues in PCSC and EWCM agents and siebel production server’s performance related issues.
• Performed Cross Platform Upgrade (UPGREP), Merge and Post Upgrade operations in red Hat Linux environment from Siebel 7.7 to 8.1 Siebel (SIA) Financial Services application.
• Identify the issues related to Siebel performance tuning and interact with network and database teams for the performance related issues.
• Modified existing batch automation (PLSQL) framework to avoid scheduled batch instance failure because of duplicate records exists in base table.
• Implemented Siebel outbound web services (Siebel Admin) for documentum to store all EWCM documents for the providers and members in to documentum external server using XSLT transformation and DTE BS.
• Move SRF, Repository migration, DDL synch and runtime (Siebel Admin) change migration sheet preparations for every release between non-prods to production environments.
• Updated Siebel CTI to use KVP data from (Siebel Admin) genesys to determine if the outbound call is Virtual Hold call or Campaign Call.
• Migrated from Instance to Instances the Web Catalog using Catalog Manager and Imported and Exported Execution Plan in DAC.
• Prepared admin testing for custom assignment attribute, (Siebel Admin) assignment Object and assignment criteria for assign the inbound SR (PHS/PHP) to appropriate EWCM coordinators.

Environment: Siebel Financial 8.1.1.8v, e-Script, Red Hat Linux, Informatica 8.6v, OBIEE 11g, DAC, Genesys7.5v, 8.0v (T-Server), genesys G-Plus, GUD bridge, SOAPUI, Agile Scrum, FACETS 5.0.1v, OHS 11g,Oracle11g, BMC Patrol,F5 BIG-IP.

Confidential, Costa Mesa, CA

Senior Siebel Administrator

Responsibilities:

• Prepared inbound web services (Siebel Admin) for SRNUM creation in to Siebel for SRNUM created in SAP and eBIZ systems.
• Prepared Upgrade plan and performed (Siebel Admin) UPGREP, merging, post merge and UPGPHYS from 7.8 to 8.1 Siebel (SIA) automotive applications.
• Troubleshooting and testing performance tuning of OBIEE Dashboards / Data Warehouse Informatica jobs for KCI, HMA on sales and service entities.
• Prepared fixes and configuration solutions for dev-post upgrade phases (Siebel Upgrade) and tested case management entity after post upgrade in 8.1 dev environments.
• Installations and configurations of Siebel gateway (Siebel Upgrade) and enterprise server in red hat Linux and windows and database configurations for Siebel repository.
• Prepared automated and scheduled (Siebel EIM) batch interfaces for Dealer master and Dealer contact from AS-400 mainframe systems in to Siebel base table.
• Prepared Siebel EIM batch interface for (Siebel EIM) RDR and WRTCLM data from EDW and warranty application in to Siebel application.
• Provided Siebel application support for Product configuration and Sub-Products attribute maintenance, Rule creations in e-Product configurator.
• Implemented Siebel Marketing infrastructure (Strong Mail/ESD/CTD) for Email and Direct mail campaign in HMA/HACC.
• Siebel integration with external systems with different codepages and Localization of the Siebel user interface in multiple languages.
• Converted MSSQL server from Non-Unicode to Unicode database to support (Siebel Upgrade) internationalization for 16 bit codepage support for multiple languages.
• Integrated Order management by the Sales (Siebel Admin) Order flows from Siebel Consumer Application to SAP through (BizTalk).
• Managed workflow processes, (Siebel Admin) Workflow Policies, Workflow Policy Actions and Business Services for the Siebel and eBIz real time/batch integration.
• Prepared custom Business Services in lead Aging and Dealer allocation process for offline leads coming from Auto Show Event.
• Prepared segmentations (Siebel Marketing) using BI Publisher screen in 8.1.1.5v for HMA/KCI and used the segment for “new vehicle sales marketing” in marketing applications.
• Involved in improving Siebel performance related issues (Siebel and Database Tuning) in contacts and case entities and provided configuration solutions using Siebel Tools.
• Prepared detailed design document and implemented Marketing process (Marketing Campaign) in siebel 8.1 marketing application for HMA/HACC/KCI divisions for Hyundai sales, Parts and services.
• Implemented OBIEE sales and service dashboards (Siebel Admin) and reports for HMA and KCI divisions using Informatica job and DAC on complaints, sales lead and Service Request by monthly and weekly based.

Environment: Windows 2008 Server R2, SQL Server 2005, Agile Scrum, SOAPUI, Siebel eAutomotive 8.1.1.5v, DAC, IIS server 7.5v, SAP, Siebel Analytics 7.8v, OBIEE 10g, Informatica 8.6v, OBIA 7.9x (Sales Analytics, Order Management Analytics), eBIZ systems, SQL, PL/SQL, BMC Patrol, F5 BIG-IP.

Confidential, San Jose, CA

Senior Siebel Administrator

Responsibilities:

• Troubleshooting and managed Workflows to handle XML file to update the Defect entity for Ariba’s Product related defects.
• Created new Business Services and WF policy to automate default product Owner assignment in SR entity.
• In depth experience with Virtual Business Components (VBC) and EAI technologies including the utilization of Siebel Integration Objects and Adapters to promote seamless external data interfaces and used specialized Bus Comp User Properties for configurations.
• Implemented product configurations (Siebel Product Configurations) for all Ariba’s products (Ariba Buyer, Ariba Analysis) and setup pricing for the products using pricing engine.
• Worked on HI and SI (Standard Interactivity) mode CRs and applied patches for standard interactive support on Siebel 7.7 releases.
• Configured Hierarchical (constrained) pick lists and configured Pick list, Dynamic drilldown and Applet Toggling.
• Prepared inbound web services to facilitate AN Punchout and configured outbound web services to get Defect records for Account from Connect Systems.

Environment: Windows XP professional, SQL Server 2000, TSQL scripting, Siebel 7.7.2.11 eService, IIS server 5.1v.

Confidential, Madison, NJ

Siebel Administrator

Responsibilities:

• Developed a complete EIM mapping from Siebel 6.0 model to new Siebel 7.5.3 model including S PARTY model mappings.
• Provided data analysis, data modeling, and Siebel EIM expertise in data conversion & loading to Siebel 753 including troubleshooting data related issues.
• Involved in the configuration of the customization process and move data using EIM from one environment to the other for Application Administration, which involves Employees, Positions, Responsibilities, Views, LOV’s and all the Reference entities.
• Using Siebel tools interface, configure the application, which uses some of the vanilla components. Extended new database columns and Applied and Activated to Database layer

Environment: Windows XP Professional, Siebel Life Science (SIA) e-clinical 7.8.2.0v, Oracle 9i, SQL/PLSQL, SQL Loader, IIS server 5.0v

Confidential

Siebel Administrator

Responsibilities:

• Siebel server installation & configuration, Patch management on non-prod and production environments and created custom batch file for Checking status of JOBs/RCRs/Tasks
• Design and Develop Siebel Virtual Business Components for real-time legacy integration and design and develop EAI XML Interface connecting Siebel EAI and Java Servlets
• Used Siebel Tools and added new functionality like buttons, customized validations in Order Entry Modules using: Business Components & Business Objects, Applets, Views, and Screens & Application.
• Responsible for enhancement the current eScripts to meet new business requirement and performance tuning of the application.
• Designed Workflow Processes for Inserting and Updating fields in BC and custom workflow monitor agents.
• Developed high level Design documents for data mapping of various function points discovered during Discovery and Design stage

Environment: Windows 2000 Professional, Siebel Financial Services 7.5v, Oracle 9i, SQL/PLSQL, SQL Loader.

Confidential

Siebel Administrator

Responsibilities:

• Involved in the design and deployment of Accounts, Contacts, Opportunities, Orders, and Service Requests. Configured Hierarchical (constrained) pick lists.
• Prepared PL/SQL procedures for Data Loading from Legacy systems into siebel schema through EIM.
• Involved in gathering requirements for Adding controls, creating and configuring pick applets and multi value applets, joins and links.
• Interacting with the Business Users and Prototyping the modules Service requests, Accounts and contacts.
• Created Abinitio Graph for Extracting the customer data from Legacy systems, cleansed using Abinitio and Loaded into Siebel Schema
• Siebel server and client installation and system setup with Oracle9i as the RDBMS

Environment: Windows 2000 Professional, Siebel Call center (eVolve) SEA 6.8, 7.0.4v, Oracle 8i, SQL/PLSQL.