Jayagobi

eMail: ac5eog@r.postjobfree.com Ph: 832-***-****

Summary

Sr. Siebel Consultant over 17 years of experience in system analysis, design, development and Integration of enterprise applications with special emphasis on CRM and has worked on various industries such as Aerospace, eClinical, Communications, Call Center, SFA and Pharmaceutical etc. Excellent background in CRM, Integration, Web Service, Scripting and Data Analysis. Has wide experience in Siebel, Java, Oracle, T-SQL, PL /SQL. Proficient in ETL (Extract Transform Load) using SQL Server Integration Services 2005 (SSIS). Good technical knowledge of Big Data technology with Hadoop (HDFS) and YARN Architecture, Map-reduce, Hive, HBase, Sqoop, Python, NoSql. Has a good communication, strong analytical and problem solving skills. Education

B.Tech, AVADH University, India.

PGDBA - Business Administration, Annamalai University, India. Certifications and Exams

Siebel eBusiness 8 Exam / 7 Delta Exam / 2000 Comprehensive Exam

Sun Certified Java programmer

MCSD - Microsoft Certified Solution Developer

Microsoft SQL Server Reporting Services

Certificates from Lyda.com

o Architecting Big Data Applications Batch mode application engineering o Hadoop

o Python

o Learning NoSQL

o Data Science Foundation: Fundamentals and Data Mining Technical Skills

CRM : Siebel 8.x/ 7.x/ 2000

Integration : EAI, EIM, Web Service, SQL Server Integration Service (SSIS) RDBMS : Oracle 11.1/9i/8.1, SQL Server 2008/2005

NoSQL : Apache CouchBase, HBase,

Language : JAVA, JavaScript, C++, VB 5.0/6.0, T-SQL, PL-SQL, Python, R Web Technology : WebSphere, Web Services, SOAP, WSDL, XSLT, XSD, XML, HTML, Servlet, JDBC 2.0, JSP 1.1

Middleware : BizTalk

Tools and Technology : IBM RAD (Rational Application Development), SQL Developer, TOAD, SSIS,2005(ETL), XMLSpy, SoapUI, Clear Case, Clear, Clear Quest, Putty, Visio, Visual Studio 2008, Team Foundation Server (TFS). Reporting Services : SQL Server Reporting Service, Crystal Reports. Big Data/ Data Science: Hadoop HDFS, Map-reduce, Hive, HBase, Sqoop, Pig, Flume, Oozie Work Experience and Training

Jaxmi IT Solutions Inc, WA Oct’11 – Current

Position: Sr. Consultant/Architect (Siebel / Big Data) Dezyre, CA Jan'18 – current

BigData/ Hadoop (HDFS 1 and YARN)/ MapReduce/ Hbase/ Pig/ Hive/ Sqoop/ Flume / Oozie

Hadoop installation and setup in Psuedo-distrubuted and fully Distributed modes.

Manage Hadoop services

Development of MapReduce using Java and Pig.

Install and setup Hadoop eco systems, Pig, Hive, Flume and Sqoop etc

Import data from mySql into HDFS using Sqoop

Jayagobi

eMail: ac5eog@r.postjobfree.com Ph: 832-***-****

Analysis using Hive on the Weather dataset (monthly datafile) shared by US Govt Department of Defence:

Date and time during the first quarter of a given year for the clear sky

Date and time between a given period, when the windspeads were above 50mph

Built a flume agent to capture real time tweets from Twitter and inject into HDFS using Flume.

Using Hive/Pig, Analysis on Airline Dataset (collected by US Dept of Transportation's Bureau of Transportation Statistics ) to track the on-time performance of domestic flights operated by large air carriers for the years 1987 to 2008

o Unique carriers,

o Number of cancelled flights of carrier "9E",

o Average delay caused due to weather for each year Client: Boeing Inc, WA Oct’11 – Dec’17

Siebel 8.x/ Oracle11g/ Field Service/Contact and Account Management/ Assignment Manager/ StateModel/ EAI/ EIM/ Web Service/ Email Response/ EBC/VBC/ Configuration/ e-Script/ Workflow/ WSDL/ XSD/Clear Case/ PL SQL / Java / Web Sphere / RAD 7.5

Development, Deployment, Server Administration and Production Support for Material Management Request Tracking (MMRTS) and Material Management Operational Data Store (MMODS) systems in MMIT Organization.

MMRTS: Development (Design, configure and customize) of various enhancements (Projects: Regionalization, Contact Administration, State Model, Email Communication) and upgrade Siebel and Oracle. Some of the key responsibilities are:

o Contact and Account module as part of Regionalization project (BC, BO, Integration Objects, Business Service browser Scripts and Server scripts, Applets, Views, Links, and Joins etc). o Design and develop state model for contact status accommodating the challenged requirements by choosing the LOV Based State Model instead over the out-of-the box State Model functionality. o Account Assignments and Contact Assignments based on Territory and Regions (Assignment Manager, Position Skill Items and Territory Rule Criterion). o Email Response process for Cost & Availability cell users (Communication Outbound and Communication Inbound, Communication Driver and Profiles, Response Group, Email templates and Communication views, Biztalk Integration).

o Email communication process to auto-create email contacts and association to Service Request and Communications using Workflow process, Business Service and eScript. o A process to extract the rejected email address from body of the rejected email communication and to update the status of the email contact (Workflow, BS and eScript). o A Dashboard application that runs on java application to display the matric information

(StationOnDeck, InWork, Completed, Oldest OnDeck, Color code for cycleTime etc) of Siebel Service Request data. k

o Integrated the MMODS applications with WSSO (Web Single SignOn) which does Authenticate, User session management and Authorization prior to application access. WSSO proxy method is used as WSSO standard is not supported for the applications that uses unsupported servers. o Develop monitor to alert in email / text for job failures/hung status.

PRODUCTION Support: Tier3 technical support in regards to production issues, investigation and debugging for both applications. Some of the Major Production Supports: o Key role in setting up DR application server for java applications; deploying EAR files and configuring necessary settings on Web sphere server. o Source (SONIC) ID max char limit exceeded (9 to 10 digit) due to limitation in Source System (IMB mainframe DB2). Identified the issue and provided work around solution which required code change on both system to handle 10 digit ID with reduced fetch size. o Performed Disaster Recovery activities to fail over the applications from Production site to Standby site due to failure in the Oracle DB Disk group. o Deployment planning and execution activities.

ADMIN Support: Web sphere Application Server (WAS) admin to control (stop, start application and servers) the application servers as and when required. Deploying EAR files using WAS Console for MMODS applications and on EHS server through PuTTY console for MMRTS Dashboard application.

Supporting tasks for Oracle migration and upgrade from 11.1 to 11.2 regards to MMODS. Jayagobi

eMail: ac5eog@r.postjobfree.com Ph: 832-***-****

Supporting Retirement of MMRTS and MMODS systems (to make ReadOnly mode) in regards to new OneSAP system implementation.

Quorum Review IRB, WA Sept'10 – Oct’11

Position: Application Engineer

Siebel 7.8 / SQL 2008 / CTMS / eClinical Application / Integration Services / EIM / Configuration / e- Script / vbScript / Workflow / Actuate Report/Business Intelligence (BI)/ SSIS / SSRS.

Projects participated: 2011 Pricing, Sponsor Control, Siebel Reports and Paperless Project.

Technical design, documentation and review for the system development.

Development:

o Develop the process / functionalities as per the business and functional requirements in Siebel Tools (BC, MVL, MVG, Applets, View, Business Service, Workflow, VBScript/eScript etc.)

Integration and Data Load:

o Interface between Siebel application and Data Warehouse to synchronize the Protocol, Site and related Activity data using Integration Services (SSIS). o Perform EIM jobs on request basis to import bulk data into Siebel. (EIM Column Mapping, ifb config and SQL loader).

o Develop and Modify the SSIS Job tasks/process flow to effectively pull the Siebel data using T-SQL and Stored Procedures.

Admin and Production Support:

o Planning for Migration and Implementation into various environments and conducting mock deployment prior to go-live.

o Deploy SRF / Repository Migration and Admin Data Setup into Production environment. o Effectively monitor server and take action to ensure coordination and effectiveness of all components and activities and decide on issues requiring escalation. Conduct root cause analysis and work-around solution to resolve the issues on timely manner. o Created Jobs and scheduled Packages using SQL Server Management Studio for the Daily Load.

Reports:

o Design and Develop various Reports (Safety Report, Site Change Request, Site Startup Report and Continuing Review & Closing Report), Fax Cover Sheet etc using Reporting Services (SSRS) and Actuate Report.

Data conversion:

o As part of paperless project data conversion team, migrated the Clinical Trial data from Siebel to new system called eResearch Portal(using ETL, SSIS, Web Service, jscript, XML construction using SQL, ERD and data mapping ).

o Designed and developed the Staging Database and loaded from source to staging and from staging to the Destination tables applying different transformations. o Design and develop SSIS packages, store procedures, configuration files and tables; Perform Data Cleansing and Data Profiling using several transformations like Data Conversion and Derived Column; mappings /transformations based on source-to-target specifications o Worked on XML Web Services Control Flow task to read from XML Source; Construct XML using complex T-SQL Queries.

American Solutions Inc, USA Jun'03 - Aug'10

Position: Sr. Siebel Developer

Client: Quintiles, NC May’10 – Aug'10

Siebel 8.1/ Oracle 11g/ CTMS/ eClinicalApplication/ EAI/ EBC/ Configuration/ e-Script/ Workflow.

Develop the interface to send the updated Protocol and its children information to CTMS ODS staging tables through the EBC Integration Objects utilizing the Siebel EAI adapter. The underlying staging tables for these EBC’s makes data available to other systems like TMODS, OBIEE etc.

Develop the EBC’s, IO’s, workflow process and error handling for the integration process.

Analyze the data for data mapping and set up the EAI Data Mapper.

Develop triggers using Run-time events and escript. Jayagobi

eMail: ac5eog@r.postjobfree.com Ph: 832-***-****

Client: ACS (Xerox Company), NJ Feb’10 – May’10

Siebel 8.1/ Oracle 10g/ Financial Application/Call Center/ CTI /Avaya 7.2/ Web Service/ VBC/ Configuration/ e-Script/ Workflow/ WSDL/ XSD.

Develop the interface to get the PASS History data from Sybase system (using existing generic stored procedures calls) and display in Siebel application using Webservice, VBC, Business Service and eScript).

Customize and develop the Views for PASS History Data (Applets, Views, Screen, Business Objects, Business Components)

CTI Integration:

o Configure Call Center application to support call center agent experience. Set up configuration profile, Agent, Event Handlers; Event Responses and Event Logs as per the requirement and conditions.

o Auto-create Activity record for the inbound and outbound calls for the participant’s Siebel contact record.

o Auto-populate the available data retrieved from the inbound call while creating a new Service Request.

o Customize the customer dashboard to include additional data about the participant and company.

o Configure and customize the Siebel application to support both migrated and not- migrated participant’s calls.

o Research and Proof of concept for the additional functionality to invoke existing non- siebel call center application from Siebel if the incoming call is from non-migrated participant.

Managing the delivery of the target integration points and resolving issues in regards to the blocking issues for any development and thus delivery of the work on time.

Liaise with the business analysts and system integration SMEs to promote effective design relative to requirements.

Responsible for the delivery of design, build and test components for integration points.

Support the system testing and user acceptance of the integration points. Client: Boeing, WA Oct’09 – Dec'09

Siebel 7.8.x/ Oracle 10g/ Field Service/ EAI/ Web Service/ VBC/ Configuration/ e-Script/ Workflow/ WSDL/ XSD, Clear Case.

Develop the interface to get the Release Comments info from external application (CWT) to display in MMRTS (Siebel) application view using VBC, eScript and Web Service.

Customize the List Import functionality to validate the data depending upon the source and format of the file (CSV) and to create activity and SRs.

Design and develop the GUI (Applet, View) to get the parts information from external systems

(SONIC through ODS) on request basis as well as on List Load Import.

Prototype and demonstrate the Realtime interface to update the SIS information in MMRTS

(Siebel) Application from external application (ODS).

Design and configure 787 Process Cell structure and create positions for each Stations and Sub- Stations in Siebel application.

Design and configure the List Applet and Form Applet, Pre-On Deck View for the 787 Process Cell users.

Extend Tables to support new data elements for 787 Process. Client: at&t Mobility Inc, WA Sept’07 – Sept'09

Siebel 7.8 and 7.7/ Oracle 10g/ eCommunication for Wireless and Wireline / EAI/ Configuration/ e- Script/ Workflow/ WSDL/XSD/XSLT.

Design and develop Data Model; Configure and customization for ECPM Project (Enterprise Contract and Profile Management System) and its various releases. Jayagobi

eMail: ac5eog@r.postjobfree.com Ph: 832-***-****

Enterprise Application Integration (EAI) to develop various interfaces and creation of web service architectures for data transformation between Siebel Application and external systems like BEST Integration [Laser Sunset], Premier Integration, NBI/TLG/CARE real-time feed (WSDL, XSD and XSLT for various APIs for integration, escript).

Siebel upgrade from version 7.7.x to 7.8.x. Resolve the object difference in conflicts and fix them. Resolve the issues in Ref data (LOV, Sales Stage and Sales Method) after the upgrade.

Work with Production Support team to investigate the issues and provide work around for the fix.

Prepare detailed documentation and review for the system development. Client: Yahoo Inc, CA Jun’07 – Sept’07

Siebel 7.8.2/ Oracle 9.204/ Configuration/ e-Script/ GUI/ Workflow/ FirstLogic/ Contact Management

Worked on YCRM project and involved in Account and Contact module of the application design and development (BC, BO, Pick list, Pick Map, MVL, Applets, MVG Applet, Views, Screen, and workflow process, eScript)

Worked on the First Logic module to customize the real-time de-duplication process for Company, Contact and Address as per the business request such as: o Configuring matching fields for contact deduplication (ex: Email Address and Last Name).

o Configuring matching %age for matching fields (ex: Email address and Last Name would be 100% and 50% respectively)

o Configuring the capitalization fields (ex: First Name and Last Name fields on Contact) o Make necessary changes to run the first logic batch workflow process asynchronously o Real time First Logic de-duplication process should avoid checking Company/Contacts/Address records created through promotion process Client: T-Mobile USA Inc, WA Jan’07 – April’07

Siebel 7.7.x/ eCommunication for Wireless/EAI/ TIBCO/ Configuration/ e-Script/Business Process Administration

Worked on CRM2( Bundle2) project to deliver the online payments (CCP - Credit Card Payment and ECP - Electronic Check Payment forms) via the Siebel User Interface for use initially by Customer Care. This is to replace the old process of online payments coming jPayment directly from Streamline to take payments from customers by CSRs.)

Support the Siebel to Samson (through TIBCO) integration systems and maintain the data integrity between the systems. (Account/Contact and Assets flowing from Siebel to Samson) Client: Cingular Wireless, WA July’05 – Dec’06

Siebel 7.7.x/ eCommunication for Wireless/EAI/ Configuration/ Web Service/ e-Script/Business Process Administration

Worked in BASE team and Involved in SIA, HLD, TDD, Development and Unit Testing stages of various projects (ECPM - Laser Integration, Discount Tracker Interface, Biller Feed Interface and Small Business Discounting) of eCommunication Application.

Developed the real-time Integration process for integration the Agreements/Contracts and Profiles flowing from ECPM system to LASER system using the Web Service technology in Siebel.

(EAI, IO, XSL Transformation, Workflow Process, Workflow Policies and Business Services, escript).

Designed batch process to automate the data extract from ECPM system and to deliver the data to multiple external systems.

Designed the batch process to upload the data file from external system into ECPM system. And to auto update the discounting information (Service Discount and Equipment Discount) based on the updated data and its Offer Elements Discount Schedule information.

Involve in Production support in case of any issues and to work towards the fix deployment activities.

Jayagobi

eMail: ac5eog@r.postjobfree.com Ph: 832-***-****

Configurations on the objects in Tools as per the business requirements such as Joins, Links, BC fields and BC user Properties.

Client: Teva Neuroscience, MO July’03 – June’05

Siebel 7.5.3/ ePharma/ Call Center Application / SFA/ Marketing /Configuration / EAI/ WebService

/ COM / e-Script / VBScript / Workflow Manager/ Smart Script /Order and Product Module/ Marketing and Campaign Management/ BizTalk Server

Completed three major projects (MMS, eEntrollment and Mail Stream Automation) in Call Center Application and one in Siebel Marketing (msDialogue Response).

Requirement gathering, Design, Development and Supporting Testing and Roll out phases of all the projects.

Customized Product, Catalog management (enabling company to product configure for customizable and bundle items, and analyze product information from all customer channels) and Order module.

Constructed inbound integration to synchronize the products and Inventories from an external application and Outbound Integration for sending order to External fulfillment shop with status back to Siebel (using HTTP transport adapter, XML converters, Siebel EAI Adapters).

Marketing Management:

o Campaign Management module to set up Marketing Campaign Programs (Clay Walker Patient Programs).

o Set up offer Templates with invitation letters/email templates and set up Direct Mail/Email Offers

o Creating Measures using Radius around ZIP and creating Segments using Buckets and Numeric Measures.

o Creating Campaign Plan for Direct Mail and Email. o Editing Program Plan using Stages, Segments for DM/Email. o Adding Seed Data in List Distribution and Generating Snapshot files from the server. o Loading Direct Mail/ Email Campaign to load Campaign Contact List and launching the campaigns.

o Used List Management to upload the external file into Siebel to create Prospects and Contacts.

o Developed an EAI process to create Prospects and Responses in Siebel for each Patient enrollment for the Marketing Programs through Registration page on Web and to associate the existing patient / prospect into the appropriate campaign-contact list and to create SmartScript session for each registration. o Promoting Prospects into Contacts.

Successfully done the Proof of concept for the real time integration for the Orders using BizTalk server as Middleware and using Web Services in Siebel.

Set up Care-Set Template (Applets, Views and Screen) and set up automation processes for Care- Sets and High Risk Mailers to generate Siebel Orders from the Templates (eScript).

Modified the SmartScipt to automatically generate Careset Orders in Siebel when ever patient starts a particular program.

PSS, FL July’02 – Jun’03

Position: Siebel Technical Architect

Siebel 7.0.4/ Sales and Service/ EAI/ EIM/ e-Script / Workflow Manager/ Assignment Manager/ Server Administration/ Configuration/Oracle/PLSQL / JDE Customer Information, Siebel Installation and Repository migration / Upgreade from 7.0.3 to 7.0.4 / Repository cleanup. BACC Inc, USA Sept'00 - Jun'02

Position: Application Engineer and Consultant

Client: COMPAQ, TX Nov’ 00 – Jun’02

Siebel 2000/ Call Center Application / eChannel/ EAI /Tools/ e-Script / VBScript/ Workflow Manager/ Integration / Orderand Quote processing, Account and Contact/ Module customization.

Contact this candidate