Manager Data

Siebel principal consultant with **+ years of IT experience in different phases of design, development, and implementation, functional, production support and testing of Siebel applications. The primary expertise in Siebel is in the area of Siebel Banking sector,Siebel e communication,Siebel for public sector, Siebel Marketing v8.0,Siebel/Oracle UCM v8.2,Siebel Call Center v8.1,IP15 and experience includes Technical area of Siebel Configuration, Scripting, WF, Siebel Enterprise Integration Manager (EIM), Siebel eBusiness Application Integration (EAI),Siebel - BIP Report Integration,PL/SQL,Siebel/Oracle UCM,Siebel Admin,Admin Inbox items,Assignment Manager,Campaign Management,Forcasting,Oracle knowledge – Oracle Inquira v8.6 and NexJ CRM (Production support).

Have being involved in doing the Siebel Repository Analysis, Analysis of Integration point of Siebel Application with Third Party Applications like TIBCO,Finacle,T24,Finnone,Memobile,ATM and EDW system and understaing the complexity and customization involved and also provide the estimates and benefits to customer for upgradion of siebel application latest version.

Functional Strengths

Technical Strengths

In-depth knowledge on campaign Management, captureresponse and convert response to lead.

Convert the lead to opty by using the Siebel dialer with auto call set up.

Set up an approval level and auto closure for SR, customer’s complaints and Activities.

Analysis the Siebel Avaya issue for production supports.

Depth knowledge on Data flow from multiple system.

Managing Finacial Account and contact.

Worked on Siebel and Oracle report integration.

Worked on Siebel bank application with Oracle knowedge management integration.

Depth knowledge on Master data management for Siebel banking sector.

End to End knowledge of Banking application.

Siebel Configuration

Siebel Scripting

EIM

COM Jobs

Workflows

Siebel/Oracle UCM

Production support – 3rd level

Siebel EAI, EBC and VBC

Siebel Admin

Siebel Campaign

BIP Reports

Siebel UpgradeSiebel with Inquira tools Intergeration

PL/SQL

ODI

Siebel Applications:

Siebel CRM – Siebel Financical Services v8 and IP 15

Siebel/Oracle CRM – Siebel Communications v8

Siebel/Oracle UCM Siebel UCM Application v8.1

Siebel CRM – Siebel Public Sector v8.2

Siebel CRM – Siebel Marketing v8.0

Siebel CRM – Siebel Call Center v8.1

Education:

B.E in Electronics & Comm Engg., (Madurai Kamaraj University, 1st class, Madurai.)

Diploma in Electronics & Comm Engg (Arulmigu Kalasalingam polytechnic, 1st class with dist., Srivilliputhur)

Organazition details:

May 2019 to till date, Polaris/Virtusa – Dubai.-First Abu Dhabi Bank (FAB)

Jun 2016 to May 2019, DiceTek – Dubai –Emirates National Bank of Dubai (ENBD)

Nov 2010 – 18-Jun-2016, Principal consultant, Oracle Ind Pvt Ltd

Sep 2008 – Sep2010, Siebel Application consultant, IBM Ind Pvt Ltd

April 2006 – August2008, Senior software Engineer, Hexaware Technologies Ltd

Achivements and Extra Activities in Oracle:

Oracle Consultant of the Year 2013 for outstanding performance.

Oracle Bravo Award Winner for outstanding performance and client appreciation.

Nominated for “Consultant of the Year” Award for 2012.

Evaluate the new Siebel Candidates for Oracle.

Siebel Essential trainner for fresher.

Experience:

Core Consultant in Siebel.

Siebel/Oracle UCM

Siebel Campaign Mangement.

Siebel – BIP report

Oracle Data Integration (ODI).

PL/SQL.

Oracle.

Visual Basic.

OEDQ 9.0.8

Inquira Knowledge Management.

PRESENT EMPLOYMENT:

Employer

Virtusa/Polaris

Period

June 2019 – Till date.

Role

Senior Siebel UCM Developer

Designation

Principal Consultant

PROFESSIONAL EXPERIENCE

Siebel Banking

First Abu Dhabi Bank

Location -Abu Dhabi

FAB, the UAE’s largest bank and one of the world’s largest and safest institutions, offers an extensive range of tailor-made solutions, and products and services, to provide a customised experience. Through its strategic offerings, it looks to meet the banking needs of customers across the world via its market-leading Corporate and Investment Banking and Personal Banking franchises.

Environment: Siebel 8.2, UCM, and Oracle DB

Role: Senior Siebel UCM Developer

Duration:- May 2019 to till date.

Responsibilities:

·Create the mapping sheet between ODI and UCM tables for the new system’s data migration (from Intellect to T24).

·Create the EIM_UCM_CON and EIM_UCM_ORG table mapping to load the custome column data in to S_UCM_CONTACT and S_UCM_ORG_EXT table.

·Create new IO field mapping for UCM Batch jobs to Insert /Update the records.

·Create PL/SQL procedure and IFB file to load the cross ref records for the two bank merge task.

·Create/Modify the Person search/Match web servie workflow to Onboard the customer via Mobile app/CRM/NTC and Loan system.

·Create MDM outbound file to do the Fircosoft screen, SAS AML,EFMS and CRM.

·Monitoring and take action the MDM data flow by using Control M application.

·Monitor and take action Siebel UCM Production server and server component.

·Bounce/SRF depoyement in Production server.

·Schedule the report based on the business requirement.Example newly open CIF

·Monitoring the Sql Active session by using OEM tool.

·Investgating the long running sql in Production and kill the session.

·Creating Shell script to automate the Data load to the EIM Tables and Execution of EIM task to move the data from EIM tables to UCM tables and Base table.

·Create Index to optimize the BAU Data load.

Siebel Banking

Emirates NBD Bank: Dubai.

Emirates NBD, the leading banking group in the region, were formed on 16th of October 2007 when the shares of Emirates NBD were officially listed on the Dubai Financial Market (DFM). The Emirates NBD 2007 merger between Emirates Bank International (EBI) and the National Bank of Dubai (NBD), became a regional consolidation blueprint for the banking and finance sector as it combined the second and fourth largest banks in the United Arab Emirates (UAE) to form a banking champion capable of delivering enhanced value across corporate, retail, private, Islamic and investment banking throughout the region.

Environment: Siebel 8, and Oracle DB

Role: Principal Consultant

Duration:- June 2016 to May 2019.

Responsibilities:

·Monitoring the siebel CRM Production server and server component.

·Bounce/SRF depoyement in Production server.

·Schedule/Monitor the dialy data load.Which has newly open account, Credit card,Debit card,Loan Account and CIF.

·Monitoring the Sql Active session by using OEM tool.

·Investgating the long running sql in Production and kill the session.

·Schedule/Monitor the OBIEE report.

·Supporting the Service Request Module for Call center. Which has integrated with Multiple system.

·Suporting the Campaing Load and Wave launch marking team.

·Worked on SMS, Email, Banknet campaing.

·Working on the remedy incident ticket to support the Siebel CRM Call center Application.

·Loaded data by using COM jobs

·Involved in customization of Audit trail modules, State model, and Assignment Manager and DVM validation.

·Creating Shell script to automate the Data load to the EIM Tables and Execution of EIM task to move the data from EIM tables to Base tables

·Worked on the intergartion between Siebel system and Oracle knowledgement system.

·Completed implementation following Siebel recommended business practices.

·Used Siebel Tools for enhancement of Siebel Business Components, Business Objects, Screens, Applets, and Views.

·Involved in customization of MVG Applets, Dynamic pick Applets, Static pick lists and List of values.

·Established joins between tables and created links between business components.

·Configured Drilldown navigation and Applet Toggle.

·Used Applet level and Business Level scripting to meet the requirements where standard configuration is not possible.

Siebel Banking

Post Upgrade and Production support

Assignment Location: India

ING Vysya Bank Ltd is a premier private sector bank with retail, private and wholesale banking platforms that serve over two million customers. With over 80 years of history in India and leveraging ING’s global financial expertise, the bank offers a broad range of innovative and established products and services, across its 547 branches. Your search for a Ideal Home ends at ING, you can avail Home Loans from ING for constructing a home, purchasing a ready built house/flat, or even for refinancing existing loans. ING offer you a bundle of benefits on Home loans to ensure that you realise your long cherished dream of owning a Home along with attractive Interest Rates.Continue reading to view more details about this loan.

Role: Senior Siebel developer

Duration:- 7 months

Responsibilities:

Successfully upgrading the application from 7.8 to 8.1.

Managing the offshore team with team size 10 and triaging the defects in the Testing phase

Fixing complex defect in the Commercial loans Module.

Monitoring service Request from oracle support regarding product defects.

Streamline the process of creating the customer using different approaches.

Production support:-

·Maintain new users including providing Data base access, login issues & all access concerns. Extracted local database for team members.

·Creation and maintenance of Batch jobs to perform repetitive jobs without manual intervention.

·Involved the Siebel server set up including the Gateway server, Siebel server and web server.

·Created the sub system and repository migtration.

·Run the eHealth check report.

·eHealth email alerts – turning off and on

·Involved the Environment Verification

·Verify the server Component connection to the database been ative or lost

·Environment Verification for SIEBP

·Involved the cleanup the old Repositories

·Involved the Refresh siebt file system

·Worked on the Workflow Troubleshooting.

·Involved the to check the Siebns.dat file

·Involved the Delete old repositories

·Worked on the RepeatingComponents set up.

·Repository table cleanup process.

·Generated the Account\Contact mismatch errors report

·Repository Migration across various environments and deploying into UAT

·Monitor the Application ensuring components are running as per the requirement

·Maintanting the 24x7 production support team schedule and ESCALATION process.

Siebel Communication

AT&T Project designed to support the customers and application used by the Customer Service Representative (CSR)will do the action like to enter the customers details in the UI and based on the data he/she has to perform the service availability check of that address and Capture contact details to create an account and based on those values perform credit check validation and validation on contracts based on the specific product either PMO (Present Mode Operation) or FMO (Future Mode Operation) Product and Capture delivery address and billing details and the confirm order for that product.

Environment: Siebel 7.7, Oracle, Windows XP

Role: Senior Consultant

Responsibilities:

·Installed Siebel on a POC machine along with complete Order Management setup to integrate Siebel with BRM via AIA

·Configuration changes to the Literature and Correspondence screen; extend the table S_LIT_X, S_DOC_CORR and S_DOC_PPSL.

·Customized out-of-the-box solution using Siebel Tools created and modified applets, BC User Properties, LOV, Static Pick lists

·Leveraged Applet level and Business Level scripting to meet the requirements where standard configuration is not possible.

·Analyzed the Siebel data model and loaded the bulk data into Siebel Custom table.

·Loaded data by using COM jobs

·Involved in customization of Audit trail modules, State model, and Assignment Manager and DVM validation.

·Creating Shell script to automate the Data load to the EIM Tables and Execution of EIM task to move the data from EIM tables to Base tables

Created new process to match the existing customer information based on Name and address fields for the new system.

Siebel Communication

Assignment Location: USA

T-Mobile USA, a subsidiary of Germany-based Deutsche Telekom, is one of the largest providers of wireless voice and data communications services in the US. The company's 43 million+ T-Mobile contract and prepaid consumer customers use its networks domestically and are able to connect to the compatible network of its parent company when in Europe. It also provides wireless Internet access and other data services in airports and retail businesses, among other locations, through its T-Mobile HotSpot brand. T-Mobile resells phones, PDAs, and accessories from such vendors as Nokia and Samsung. In 2013 Deutsche Telekom acquired smaller rival via a reverse merger and combined it with T-Mobile.

Environment: Siebel/Oracle UCM 8.1, Oracle DB

Role: Siebel UCM developer

Duration:- 3 months

Responsibilities:

·Involved in designing the Functional, Technical Document, and Configuration

·Added value to the current system by adding various Functional capabilities

·Validation and modification of BDM Workflows

·Applied the Open UI Batches and activated the Open UI functionality.

·Created the synonymous user for CHUB Real time transaction

·Sync the BAN information data between Billing system and CHUB.

·Implemented the ADM (Active Duty Military) functionality for T-mobile.

·Modified the Person service based on T – mobile functionality.

·Customized the Transaction log for each real time transaction.

·Worked/Managed the customer (on-site) to impletemented the UCM Application.

Siebel Hospitality

Production support & troubleshooting

BIP Reports

Assignment Location: India

Marriott International signs in at the top of the lodging industry. The company is one of the world's leading hoteliers with some 3,500 operated or franchised properties in 70 countries. Its hotels include such full-service brands as Renaissance Hotels and its flagship Marriott Hotels & Resorts, as well as select-service and extended-stay brands Courtyard and Fairfield Inn. It also owns the Ritz-Carlton luxury chain and resort and provides more than 2,000 rental units for corporate housing and manages 40 golf courses. The firm is spinning off its time-share business, Marriott Vacation Club International.

Environment: Siebel 8.1, IBM DB2

Role: Senior Siebel Technical Consultant

Duration:- 3 Years

Responsibilities:

·Integrated the Custom HTML code with Siebel Application for custom dialog pop up message.

·Conceptualized and Rebuilt the Siebel Doc server functionality for Linux by using the BIP server with rtf files.

·Created the New Siebel “Import objects” for importing data from CVS files.

·Created complex IOs by using VBC for the BIP implementation.

·Provided zero down time solution for critical production issue.

·Created custom WF which streamlines XML Generation for BIP reports development.

·Worked on enhancing the end user experience.

·Automated the Quote Status Update Process by using Siebel WF.

·Involved in the gap analysis between version 8.0 and 8.1 upgrade assessment

·Consistently working on analyzing the root cause and fixing bugs as a part of the incident management and problem management team.

Analyzed the log files and back end data for various activities performed in the Siebel applications.

Siebel production support & troubleshooting

Assignment Location: India

Unisys Siebel Sales Force Automation 7.7 (SFA 7.7) Application was assigned to the team to cater the requirements for Enhancements or Modifications.

The Sales Force Application assists sales professionals throughout the entire sales cycle with tools and information that help the sales team manage opportunities, the sales pipeline, customer profiles, accounts, products, pricing, competitors, decision issues, and sales brochures, data sheets, and presentations. Sales Task like Contacts and Account Management, Opportunities, Quotes, Activities, Support for Target Account Selling are supported.

Environment: Siebel 7.7.2.3, Oracle 9i

Role: Technical Consultant

Duration:- 2.10 Years

Responsibilities:

·Understand the Siebel Sales and Market Business requirements and worked with the user.

·Completed implementation following Siebel recommended business practices.

·Used Siebel Tools for enhancement of Siebel Business Components, Business Objects, Screens, Applets, and Views.

·Involved in customization of MVG Applets, Dynamic pick Applets, Static pick lists and List of values.

·Established joins between tables and created links between business components.

·Configured Drilldown navigation and Applet Toggle.

·Used Applet level and Business Level scripting to meet the requirements where standard configuration is not possible.

Siebel Admin Tasks:

·Maintain new users including providing Data base access, login issues & all access concerns. Extracted local database for team members.

·Creation and maintenance of Batch jobs to perform repetitive jobs without manual intervention.

·Involved the Siebel server set up including the Gateway server, Siebel server and web server.

·Created the sub system and repository migtration.

·Environment Verification for SIEBO

·Involved the cleanup the old Repositories

·Involved the Refresh siebt file system

·Troubleshooting_Workflow_UniWorkMonUtility

·Involved the to check the Siebns.dat file

·Involved the Delete old repositories

·Worked on the RepeatingComponents set up.

·Repository table cleanup process

·Repository Migration across various environments and deploying into UAT

·Monitor the Application ensuring components are running as per the requirement

Siebel Insurance

Assignment Location: India

Stewart (NYSE: STC) is a leading provider of title insurance and related services to the real estate and mortgage industries. Throughout our 117-year history, our conservative management philosophy has allowed us to grow and remain strong through the ups and downs of the market. Stewart Title Guaranty Company's policyholders' surplus is one of the largest in the industry and our financial strength provides the confidence our customers need from their title insurer in these tough economic times.

Environment: Siebel 8.1, Oracle

Role: Technical Consultant

Duration:- 4 Months

Responsibilities:

·Implemented Franchise visibility

·Implemented Siebel-Partner system User credentials authentication Interface.

·Created Siebel Admin inbox item notification process.

·Developed composite Siebel forecast, contract and correspondence functionality.

·Created complex Workflow and BS for the inbound web services.

·Consume the WSDL provided by the TAM team to communicate with the web service for Policy status update

·Implemented the Siebel SSO setup

·Repository Migration across various environments and deploying into UAT

Proactively provided production support with server checks on a daily basis.

Technical & functional consultant

Public Sector

Assignment Location: India

Michigan’s Human Resource (HR) Optimization Project was an interdepartmental initiative intended to augment the efficiency and effectiveness with which HR services are delivered by building upon the state’s centralized HR system. This initiative resulted in the implementation of an enhanced self-service internet application, centralized data store, multi-tiered service center, and redesign and realignment of Human Resource processes that produced documented savings of $2 million in the first year. The project remains on schedule to save a projected $25 million savings over the first five years—while delivering best-in-class service

Environment: Siebel 8.2.2.14, Oracle DB

Role: Techincal Consultant.

Duration:- 3 months

Responsibilities:

·Involved the Siebel server set up including the Gateway server, Siebel server and web server.

·Created the sub system and repository migtration.

·Design the Account, Policy and Case entities.

·Planing to do the Case, Activity and attachment data load for every night.

·Setting Up a Siebel Audit Trail for Submitted Application.

·Approval Templates and Routing.

·Added Images to the Siebel Public Sector Home Page.

·Added New Serialization Rules.

·Worked On location creation.

·Configuring Constraints for Time Entry.

·Configuring Contact Matching using "PUB Contact Matching Service" BS User property

·Disabling Contact Matching in PUB Application BC user property

·Did the set up for associate the cases for nonbenefit categories with master cases.

Worked/Involved the Public Sector Workflows and Assignment Manager

University – Siebel UCM

Assignment Location:India

New York University’s mission is to be a top quality international center of scholarship, teaching and research. This involves retaining and attracting outstanding faculty who are leaders in their fields, encouraging them to create programs that draw outstanding students, and providing an intellectually rich environment. NYU seeks to take academic and cultural advantage of its location and to embrace diversity among faculty, staff and students to ensure a wide range of perspectives, including international perspectives, in the educational experience.

Environment: Siebel UCM 8.1, Oracle DB and IIR .

Role: Technical Consultant

Duration:- 6 months

Responsibilities:

·Data quality configuration and validation

·EIM and Data loading scripts for Initial data Load.

·Set the Data Quality Administration options

·Create Vendor ODQ

·Enable Data Cleansing & DeDuplication

·SQL to load data into EIM_UCM_ORG & EIM_UCM_CON

·Run EIM jobs to load data into SDH tables

·Modify & Run UCM Batch WFs to process the data from SDH tables

·Clone & modify UCM Contact Batch Data Management Workflow

·Prepare sample Account & Contact XMLs

·Modify & Run UCM Real-time WFs to process the data

·Clone & modify UCM Customer Profile Integration Process

Add external systems under System Registrations

Siebel UCM

Assignment Location:USA

PC Connection, Inc.’s mission has been to offer customers the best service and broadest array of brand-name quality products in the IT industry. Over the years, that guiding principle has helped us grow into a Fortune 1000 company with more than $2 billion in annual sales. The secret to our success is simple: start with talented, driven individuals and give them the tools, support, and encouragement to realize their career goals.

Environment: Siebel UCM 8.1.10, Oracle DB,OEDQ 11 and Linux

Role: Technical Consultant.

Duration:- 3 months

Responsibilities:

·Involved in the Design and Technical development in UCM Account and Contact Data load by using SQL/EIM and BDM Jobs.

·Activated the Guided merge function and modified the Guided merge work flow.

·Implemented the Contact Dedup with in the Account.

·Implemented the custom entity for guided merge and Unmerge functionalilty.

·Involved in the Key generation methodology.

·Worked on the Address, Account and Contact Cleanse and Matching Process.

·Worked on the Survivorship rule.

·Involved on the OEDQ jobs and Process.

·Validation and modification of BDM Workflows.

·Customized the UCM screen to do the better UI navigation.

·Worked on the Incomplete Transaction data process.

·Customized the Dedup Matching Process by using UCM UI interaction business service.

Worked/Managed the customer (on-site) to impletemented the UCM Application.

Oracle CRM OD Implementation

Location: India

Boeing is the world’s leading aerospace company and the largest manufacturer of commercial jetliners and military aircraft combined, with capabilities in rotorcraft, electronic and defense systems, missiles, satellites, launch vehicles and advanced information and communication systems. Our reach extends to customers in 145 countries around the world, and we are the number one U.S. exporter in terms of sales.

Role: Web Service Developer.

Duration:- 2 months

Responsibilities:

Involved in data migration as well as data integration between CRM OnDemand and Boeing SQLServer.

Includes Custom attachment uploaded, one Outbound, one inbound, Approval process, Obligation Schedule generation, Assign Specialist, Custom Product revenue and Mail merge.

Involved in Bug fixing, enhancements for modules delivered in phase1 and also developing one new inbound interface.

Analyze and contribute to Architectural decisions and design for New Technology (Oracle Business Intelligence Publisher (BI Publisher).

Siebel 7.8

Siebel Call Center

Assignment Location: India

This Client is a Leading producer of products in nearly 50 categories — from toothpaste to bone-disease therapies — the breadth of Client’s business is connected to technologies across categories in some unexpected ways. The end-end solution was provided so that users can transact through the products, which enable them to access the information. The application covers all the activities from Quote creation through order management

Role: Product Configurator

Duration:- 2 months

Responsibilities:

Worked on the development activities through configuration of Siebel Tools and Application, and Scripting to meet the Business Requirements.

Configured the Bundled Products, Promotions, CXP’s

Modified the Pricing Procedure Logic to fulfill the Business requirements

Worked on the Order to Asset functionality. Done POC for new functionality

Contact this candidate