PROFESSIONAL SUMMARY:

• Senior Siebel CRM Consultant with 14 years of IT experience in system study, analysis, design and development of enterprise applications exclusively in Siebel CRM.
• Working experience in Sibel IP 2018, Siebel 8.2, Siebel 8.1 etc. worked across multiple domains and client locations.
• 9 years of experience leading a team of 3 - 5 developers and successfully implementing projects.
• 10 years of experience working at the client locations in USA, have good professional rapport with the all the clients that I have worked.
• Strong communication skills, good leadership and inter personal skills, strong client facing skills.
• Worked extensively on Requirements gathering, Fit Gap analysis, Design & Configuration.
• Full life cycle implementation experience including scoping, process design, system configuration, testing, deployment and post go-live production support.
• Good understanding of Siebel data model and architecture.
• Strong in Siebel Tools EIM (Enterprise Integration Management), Configuration, Siebel EAI Integration, Scripting, Workflows, Product Configuration, Web Services (SOAP UI), business services, Siebel Application Administration, EBCs, and VBCs.
• Worked in Confidential from 7.8 to 8.1.1.5 for Call Center, Sales and Loyalty applications as well as Siebel 8.2 to Innovation Pack 2018.
• Strong in Data Migration, Oracle SQL and have good understating of PL/SQLs, developed interfaces that interact with Siebel and external system.
• Expertise in Design & Development of integration systems interfacing Siebel with external legacy systems.
• Experience in performance tuning of Siebel application.
• Experience working in Siebel Open UI, JavaScript, JQuery.
• Good understanding of middleware technologies like SOA (Service Oriented Architecture) technology.
• Received recognition from client on several occasions.
• Completed 3 levels of internal in Siebel at Confidential and another internal at Confidential .
• Experience in teaching Siebel for a batch of fresh recruits in Confidential .
• Good understanding and experience working in Financial, HealthCare, hospitality domain.
• Good knowledge of Order Management, Quotes, Case Management, Siebel Sales, Call Center, Automotive, Service modules.
• Knowledge of Cloud based CRM application Salesforce.

TECHNICAL PROFICIENCY:

Siebel Skills: Siebel Enterprise Integration Manager (EIM), Oracle PL/SQL, Siebel Configuration, Siebel Tools, Siebel EAI, Siebel Administration, Integration, Scripting, Business Services, Workflows.

Siebel Modules: Public Sector, Automotive, Finance, Sales, Service, Call Center, Order Management, Loyalty, Marketing

Siebel Version: Siebel IP 2018, Siebel 8.2/8.1, Siebel 7.8/7.7

Languages: PL/SQL, eScripts, HTML, XML, Java Scripts, Shell Scripts, batch scripts, control files

Databases: Oracle 11g/12c, DB2, MS Access, SQL Server

Operating Systems: Windows, Unix, Linux

Others: Informatica, OBIEE, Batch / Shell scripts

Domain Expertise: Health Care, Financials, Sales, Logistics, Hospitality

PROFESSIONAL EXPERIENCE:

Confidential

Senior Siebel Consultant

Modules: Public Sector / Case and SR management.

Technology : Siebel 8.2 & Siebel IP 2018 / Oracle PL/SQL

Responsibilities:

• Siebel onshore lead responsible for converting requirements into a Technical design document and conducting sessions with the team to understand and code development.
• Solution Design, DLD (Detailed Level Design Document) for Configuring new changes.
• Siebel Development involving configuring applets, views, screens, BCs, BOs, user properties, joins, links, MVLs, MVGs, tables, Business services, Workflows, batch processes etc.
• Played key role in Confidential to IP 2018, fixing exiting batch and real time / EAI interfaces, EIM jobs.
• Configuring External business components (EBC) and Virtual business components (VBC).
• Created EAU interfaces for our payment processor partner (WEX Health) to show all the user payment transactions and outstanding balance in Siebel.
• Develop and Monitor Siebel EIM and other batch process related to the application, looking ways to improve performance and the design based on requirement changes or enhancements.
• Develop batch process for pending enrollment verification functionality using Siebel EIM and Oracle PL/SQL which will enable automatic sending of notices and assigning SRs to the agents.
• Create Oracle Stored Procedures, Packages, Functions, Tables, Views, DB Links and other objects as needed for batch interface.
• SQL and/or control files to load data into staging tables, creating process for data massaging / validation, loading other required columns and intersection tables etc.
• Created many complex reports needed for the business by writing SQL queries that interact with systems.
• Load and configure products (Insurance Plans), price list every year and as they change for various insurance carriers and plans that are available for selection in the Exchange platform.
• Siebel Open UI configuration using Java scripts for Presentation Model (PM), Physical Renderer (PR) and CSS files.
• Meet with State of Vermont’s various business segment leads at the client location, provide technical and functional guidance whenever needed, propose updates to the current process or new functional / technical changes that can be implemented.
• Manage Siebel system integration with middleware, Java Portal and external partners.
• Support open enrollment activities related to Siebel - identification of the renewal population using various SQL reports, loading new products, running batch jobs (shell scrips and EIM) and providing report to the State for validation.
• Collaborate with offshore and other technology teams (like SOA, Portal, OPA) to provide exhaustive solution for any new requirement or an enhancement.
• Identify the root cause for performance issues and develop solution for improving Siebel application performance by means of configuration changes, Database statistics, Indexes etc.
• Monitor the application continuously for any issues - memory usage, CPU utilization, Communication server, performance, Siebel component availability, server availability.
• Providing a roadmap / estimate for the requirements and the release.
• Development of interfaces that manages the flow of data into the system using EIM and PL/SQLs
• Siebel Application administration tasks like making sure the application and Siebel servers are up and running, required components are online etc.
• Also responsible for managing views, responsibilities, adding / removing access to the application.
• Coordination with different business and application stakeholders at client location on daily basis.
• Identified some functional development changes needed in Siebel working with State on other issues which led to the approval of Change Request (CR) for additional budget.
• Create Siebel Assignment manager process to assign Service Request to the agents based on the division and skills.

Confidential, NC

Senior Siebel Developer

Modules Used: Siebel 8.1 Finance

Technology: Siebel Tools, Application Administration, Siebel Communication Server, Siebel Configuration, e-scripting, Workflows, Assignments Manager.

Responsibilities:

• Creating EIM jobs for data loads - Account, Client, Contact loads.
• Monitor the Autosys batch jobs and fix data issues when the job is abended.
• Create tool for bulk LOV load using spreadsheet as well as EIM.
• Create various batch processes for data flow from external systems into Siebel (GSS system).
• Siebel Open UI upgrade activity, enhancing Siebel Workflow to support Siebel Open UI.
• Identified and fixed Siebel OpenUI browser issues, applet layout issues.
• Implemented JavaScript Open UI JQuery file to fix form applet controls overlapping in certain browsers.
• Configure business service, web services for GSS application.
• As a Team lead for performance improvement project, work with business analysts to identify the performance intensive areas in the application.
• Identify the root cause for performance and develop solution for improving Siebel application performance by means of configuration changes, Database statistics, Indexes etc.
• Monitor the application continuously for any issues - memory usage, CPU utilization, Communication server, performance, Siebel component availability, server availability.
• Work and resolve various issues reported by GSS users by means of ticket. Follow up with the users to close these tickets.
• Develop batch jobs to monitor the mailboxes, create Assignment manager jobs for various assignment rules.
• Solution Design, DLD (Detailed Level Design Document) for Configuration.
• Siebel Development involving configuring applets, views, screens, BCs, BOs, user properties, joins, links, MVLs, MVGs, tables, Business services, Workflows, batch processes etc
• Responsible for implementing changes in production by creating RFC (Request for Change) ticket.
• First point of contact for GSS application related issues in production.

Confidential, OR

Senior Consultant

Modules Used: Siebel 7.7 Order Management

Technology: Siebel Tools, Siebel Configuration, Workflows, Scripting, Siebel EIM, Oracle PL/SQLs

Responsibilities:

• As part of production support responsible for maintaining the health of the system and servers, make sure the services are up and running.
• Monitor the EIM batch jobs, identify and fix data issues.
• Constantly check the availability of the server components for synchronization, transaction routing, BAPI receiver, EIM.
• Day to day activities include handle requests from geo leads for issues such as new rep creation, product availability, local db extractions, db synchronization etc.
• Coordinate with offshore on daily issues, collate reports and present to the business weekly,
• Handle the batch jobs for employee creation, order updates, product creation and updates from SAP and CDP systems.
• As part of transitioning the application from Siebel to salesforce, generate reports for ad-hoc data requests from business analysts.
• Test the application functionality when there are any changes in SAP.
• Minor enhancements in application and EIM scripts for performance.

Confidential, OR

Senior Consultant

Modules Used: Siebel ICM

Technology: Siebel ICM ver 7.8, Oracle PL/SQLs, Informatica, Actuate

Responsibilities:

• Responsible for monitoring the daily jobs for invoice and commission processing and also running actuate reports.
• Make sure all the services are up and running for the jobs, kill any long running job and execute the process manually.
• ICM relies on current period and absolute period values, refresh the database tables yearly for fiscal year change.
• Check if all the invoices are loaded in ICM and retrigger any missing invoices for accurate commission processing.
• Coordinate with offshore for daily monitoring of the jobs.

Confidential, FL

Senior Consultant

Modules Used: Siebel 8.1 Call Center, Siebel 8.1 Sales, Loyalty, Siebel 7.8

Technology: Siebel Tools, Siebel Configuration, Workflows, Scripting, Siebel EIM, Oracle PL/SQLs, Shell scripts, Informatica.

Responsibilities:

• Involved in preparation of functional document which has a detail description of key application functionality that would serve as a basis for our unit testing and SIT testing scripts.
• Involved in post upgrade cleanup of Siebel applications.
• Leading offshore team in performing various activities of Confidential .
• Fixing workflows, business services and scripts to make it compatible with Siebel 8 STE.
• Building new enhancements to the existing application which involved tweaking workflows and writing scripts.
• Understanding various interfaces in Siebel applications and testing each interface after the upgrade.
• Responsible for fixing PL/SQLs, EIM jobs related to interfaces to make it compatible with Siebel 8 data model.
• Identify and fix performance intensive areas in the application.
• Fixing various unit test and SIT test defects.
• Testing inbound and outbound web services.
• Presenting the upgraded Siebel 8 application to the business analyst to make them familiarize with the application and identify the differences.
• Fixing PL/SQL procedures related to different interfaces.
• Updating EIM configuration files (ifb) to make it compatible with Siebel 8 data model.

Confidential

Siebel Technical Lead

Responsibilities:

• Solution Design, DLD (Detailed Level Design Document) for Configuration.
• Siebel Development involving configuring applets, views, screens, BCs, BOs, user properties, joins, links, MVLs, MVGs, tables, Business services, Workflows, batch processes etc.
• Configuring External business components (EBC) and Virtual business components (VBC).
• Providing a roadmap / estimate for the requirements and the release.
• Development of interfaces that manages the flow of data into the system using EIM and PL/SQLs
• Siebel Application administration tasks like making sure the application and Siebel servers are up and running, required components are online etc.
• Also responsible for managing views, responsibilities, adding / removing access to the application.
• Coordination with different business and application stakeholders at client location on daily basis.
• Demonstrate capabilities built to client and take feedback at different phases of implementation.
• Code migration from dev to test and from test to prod during release.
• Manage, coordinate and review technical work deliverables from offshore team.
• Post Production support to resolve critical issues.
• Mentor developers by conducting s on different Siebel technical areas.
• Involved in implementation of CTI in Confidential, this project required capturing calls coming to agent telesets and creating activities in the system.
• Implemented single sign on in Confidential by developing a custom security adapter and using the single sign on provided by siteminder.

Modules Used: Siebel 7.8 Finance, Siebel EIM, Siebel Configuration, Siebel Tools, Siebel Admin, Oracle PL/SQLs

Confidential

Siebel Technical Lead

Responsibilities:

• Identifying the critical business components that form the application.
• Switching the application from single sign on (SSO) to database authentication mode so that developers/ managers only have access to the application after it has frozen.
• Studying all the interfaces to identify the data flow in / out of the application.
• Create Siebel EIM jobs for data extracts on various objects.
• Siebel File attachment export jobs using Siebel EIM as well as using custom business service.
• Performance tuning of the EIM process by updating IFB files with right parameters.
• Creating complex SQL scripts to extract the data according to the agreed upon conditions and criteria.
• Massaging the data to fit the surviving systems data format.
• Sending the extracted data in different formats .csv, .mdb etc.
• Matching the extracted data with the application UI, and then debugging any mismatch in the record count.
• Providing weekly status updates and extracts.

Modules Used: Siebel Configuration, Siebel Business Services and Workflows, Oracle PL/SQL, DB2, Siebel EIM, Siebel Administration.

Confidential

Onsite Siebel Technical Lead

Responsibilities:

• Fit gap analysis, HLD (High Level Document), DLD (Detailed Level Design Document) for configuration and interfaces.
• Siebel estimation and sizing for releases.
• Discussing the feasibility of the requirements with the BA and helping with the BRD preparation.
• Development involving configuring applets, views, screens, BCs, BOs, tables, Business services, application administration etc
• Design, develop & test stored procedures to be used for updating data during release outage.
• Performance tuning of Siebel application UI as well as interfaces involving multiple organization and sub-organization visibilities.
• Draft rollback/failover strategy for deployment.
• Providing status updates of the deliverables to the stake holders.
• Manage, coordinate and review technical work deliverables from offshore team.

Modules Used: Siebel 7.8 Finance, Oracle PL/SQLs, Siebel Configuration, Siebel EIM

Confidential

Offshore Siebel Technical Lead

Responsibilities:

• Taking the bottom line responsibility of the deliverables from offshore team.
• Fit gap analysis, HLD (High Level Document), DLD (Detailed Level Design Document) for configuration and interfaces.
• Development involving configuring applets, views, screens, BCs, BOs, tables, Business services, application administration etc.
• Design, develop & test stored procedures to be used for updating data during release.
• Performance tuning of Siebel application UI as well as interfaces involving multiple organization and sub-organization visibilities.
• Draft rollback/failover strategy for deployment.
• Providing status updates of the deliverables to the stake holders.
• Manage, coordinate and review technical work deliverables of the offshore team and co-ordinate with the onsite lead.

Modules Used: Siebel Configuration, Oracle PL/SQLs, Siebel EIM