PROFESSIONAL SUMMARY:

• More than 8 years of experience in Siebel CRM/Siebel Open UI/Siebel Upgrades/EIM/EAI/ETL and Business Analysis skills. The areas of expertise include analysis, design, software development/configuration, testing and deployment.
• Over 8 years of technical expertise in IT industry with emphasis on Siebel CRM, Data Warehousing and Business Intelligence applications.
• Working at Confidential for the past 8 years in various implementations.
• Experience in implementation of the Software Development Life Cycle (SDLC) processes and Agile/Scrummethodologies.
• Extensive knowledge in Siebel CRM applications andverticals including Loyalty, Call Center and Marketing.
• In - depth knowledge and experience in Siebel Open UI. Built custom dashboards using PM/PR.
• Extensive knowledge in upgrading Siebel application software from old versions to the latest IP20.
• Experience in Siebel CRM Application, especially onto the Siebel Configuration & scripting, Siebel Enterprise Application Integration (EAI), Siebel Admin and Maintenance tasks, Oracle PL/SQL development, Siebel Application Development and Support, and SiebelEIM.
• Extensive knowledge of Siebel EAI - Integration Workflows, Integration Objects, EAI Transport Adapters, SOAP, WSDL, VBCs, EBCs.
• Very Strong in design and developing batch jobs using Shell scripting.
• Extensive experience in Siebel EAI - Integration Workflows, Web Services, Integration Objects, Siebel Adapters, EAI Adapters.
• Expertise in SIEBEL applications (Siebel Call Center, Loyalty, Marketing).
• Strong Knowledge in Siebel Implementation Methodology involving modification of Data Object Layer, Business Object Layer, and User Interface Layer using Siebel Tools.
• Proficient in Siebel EIM developing Configuration (ifb) files and EIM jobs with working knowledge in SQL, PL/SQL and UNIX.
• Experienced on both Siebel HIClient and Siebel Open UI.
• Strong knowledge in Siebel Architecture and Data Model and proficient with Siebel Tools and Client in configuration and customization of Siebel Objects like Applets, Business Components, Screens, Views, Joins, Links, MVGs, Pick Lists, Associate & Shuttle Applets, Toggle Applets and Drilldowns.
• In depth knowledge and experience of Siebel architecture, installation methodology and administration of Siebel Enterprise, Servers, Gateway, Database and Clients.
• Proficient with writing PL/SQL procedures.
• Extensive experience in scripting using Siebel VB, eScript, HTML, JavaScript, jQuery and CSS.
• In-depth knowledge on REST API and SOAP client.
• Strong understanding of Siebel Data Model, Configuration, EAI and EIM processes.
• Experience in working with various databases like Oracle 12g/11g/10g/9i, SQL Server, MS Access, Amazon Redshift and Mongo DB.
• Experience with Tivoli workload scheduler.
• Extensive experience in UNIX shell scripting, Job scheduling using Crontab.
• Proficient with various testing methodologies and bug tracking tools.
• Organized, result oriented, quality conscious, Adaptive to new technology environments, self-starter with accomplished communication skills.

TECHNICAL SKILLS:

ETL Tools: Abinitio 3.2.x/3.1.x, Informatica power center 9.x/8.x/7.x

Business Intelligence Tool: OBIEE 11g/10g

CRM: Siebel 8.1, Siebel IP16, Siebel IP20, Siebel Open UI, EAI, EIM, Loyalty, Marketing, Call Center

Databases: Teradata 15/14, Oracle 12g/11g/10g/9i, MS SQL server, MS-Access, DB2, Mongo DB, Amazon Redshift

Scheduling Tools: Tivoli Workload Scheduler, DAC 11.x/10.x

Languages: SQL, PL/SQL, VB, C, C++, UNIX Scripts

Applications: MS Word, Excel, PowerPoint, Visio

Query tools: Teradata SQL Assistance, Oracle SQL Developer, SQL Workbench, TOAD and SQL PLUS

Operating systems: Windows 8/7/XP/NT/95, Linux, Unix

Domain: Airline, Retail, Call Center, Loyalty

Web Technologies: HTML, JavaScript, jQuery, CSS, XML

PROFESSIONAL EXPERIENCE:

Confidential, Dallas, TX

Sr Siebel CRM Consultant

Responsibilities:

• Involved in the project including Requirements Gathering, Requirement Analysis, Design, Build/Development, Configuration, Testing, and Production Support
• Interact with other applications support team with interact with Siebel to build new integration or resolve issue with existing integration.
• Involve in joint application design (JAD) sessions to baseline the requirements and use cases.
• Lead design and development of member dashboard on Siebel Open UI using JavaScript, CSS and jQuery plugins. This is for 360-degree view of member and helps customer representative to save time while serving the member.
• Upgraded Siebel from IP16.15 to IP16.19 to follow enterprise standards on security to be on TLS1.2.
• Owned the initiative of migrating traditional browser scripts to Presentation Model/Physical Renderer layer. This serves as the foundation for IP17 as IP17 doesn’t support browser scripts.
• SME for installing setting up Siebel Tools in IP17, LOCAL XE setup, enabling/flattening Workspaces, set upand configure SMC (Siebel Management Console).
• Designed and developed Integration Objects, Workflows, Workflow Policies, DVM, Business Services, Data Maps, and webservices.
• Worked extensively on Siebel Open UI concepts of Presentation Model, Physical Renderer, JavaScript, Cascading Style Sheets CSS, jQuery and themes.
• Created Integration Objects to send the information from Siebel to external systems with the help of Siebel Workflow, Siebel EAI adapters and Data Maps
• Customized interface and business logic using EAI, Business services and eScript.
• In-depth knowledge on IP17 to the latest IP20.
• Involve in the upgrade of Siebel Open UI.
• Configured EIM scripts and PL/SQL stored procedures for automating data loads and report mailing
• Identified many issues in IP17 and escalated to Oracle. Some of the key bugs reported by me are Web service performance, batch engine crash, users can’t edit LOVs in RR (Run-time Repository) environment etc.
• SME for work related to Siebel - JAWS integration, compatibility and accessibility. Also, visited Southwest’s customer support center in Atlanta to address their issues related to Siebel accessibility for VIP (Visually Impaired Users) users.
• SME for designing and configuring loyalty program, promotions, configuration and EAI.
• In-depth knowledge on RESP APIs and SOAP client.
• In-depth knowledge and experience in reducing the application downtime during deployments.
• Responsible for migrating all the releases into QA and Production environments.

Environment: SDLC-Agile/Scrum, Windows, Siebel CRM, Siebel Open UI, JavaScript, CSS, jQuery, TLS, SMC, Workflow, eScript, EIM, PL/SQL, EAI.

Confidential, Dallas, TX

Siebel CRM Consultant

Responsibilities:

• Played key role in one of the biggest projects in Southwest’s history. With Lone Star, Southwest went fully international and its reservation system is completely migrated to Amadeus platform.
• Designed and developed complex web services which needed Orchestration within Siebel. Implemented multi-pax exchanges and multi-pax redemptions functionality. This feature provided Southwest the ability to book or exchange flights for 8 passengers at a time.
• Extensively worked on Siebel tools configuration including UI Layer, Bus Object layer, Schema changes, Siebel eScript and Workflows.
• Enhanced the performance of points redemption which is the key functionality in Southwest’s business. Improved the point redemption timings from few seconds to milli seconds.
• Designed and developed PURGE process in Siebel.
• Worked on eScripts, to configure Siebel Application to meet business rules and for Data Validation & Error handling.
• Played major role in Siebel application upgrade from IP15 to IP16.15.
• Identified many critical bugs like Over Redemption, batch engine crashes in the Siebel Loyalty application and escalated to Oracle for quick fixes.
• Worked on JavaScript API with Siebel Open UI framework and customized SiebelOpenUI using JavaScript.
• Designed and developed corporate accruals for SWABIZ project. This project is aimed at accruing points for business travelers. Build a custom view for Marketing team to define corporate bonus rules and implemented complex logic using eScript to accrue bonus points based on the rules.
• Lead design and development partner processing dashboard using JavaScript and CSS.
• Enhanced email and postal notification batch jobs by developing shell scripts.
• Lead code deployments into QA environments and played major role in reducing the application downtime during deployments.

Environment: Windows, SDLC, Agile/Scrum, eScript, Siebel, CRM, Open UI, Workflows, Oracle, Shell Script, JavaScript, CSS, QA.

Confidential, Dallas, TX

Siebel CRM Consultant

Responsibilities:

• Involve in joint application design (JAD) sessions to baseline the requirements and use cases.
• Worked on Southwest CODA project which is initiated to upgrade southwest reservation system from Sabre owned to Amadeus.
• Developed batch scripts (shell scripts) to generate files containing member information and FTP the files to Amadeus as one-time load into their system.
• Designed and developed real time profile data sync from Siebel to Amadeus. Made use of Workflow Policies (triggers) to identify the change and synced the profile asynchronously using JMS queues.
• Played major role in Siebel application upgrade from 8.1.1.10 to Siebel IP15.
• Implemented DISA (Desktop Integration Siebel Agent) for our call center application which helped to identify calls from members enrolled into Rapid Rewards program and automatically query for the member and show the member information on Siebel UI.
• Design and configure tier promotions, marketing promotions, bucket promotions and admin promotions which are the fundamentals of the Rapid Rewards program.
• Enhanced complex member merge functionality to accommodate the client requirement.
• Configured many complex views involving roll up values using multiple levels of MVLs.
• Develop complex PL/SQL scripts for data fixes.
• In-depth experience on Siebel EAI. Developed complex workflows to handle synchronous and asynchronous transactions and member activity.
• Designed and developed EIM process to load marketing files like customer value score, partner files, subscriptions etc. into Siebel.
• Responsible to make sure all the technical details for all the work in documented and uploaded to confluence.
• Support Performance testing and UAT (User Acceptance Testing) team before deploying to production environment.
• Played key role in supporting Siebel deployments to make sure all the admin changes are migrated successfully.

Environment: SDLC, JAD, Shell Script, eScript, Siebel, Triggers, Workflow, PL/SQL, Siebel EAI, UAT, JMS.