Project Sales

S U B H AYA N S U R

Cell No: +1-302-***-****

Email: *******.****@*****.***

SUMMARY:

Subhayan Sur is currently working as a DRM team lead in a major US bank project, for Cognizant

Technology Solutions. His experience in nut shell is depicted below:

• 7 years of IT experience of working in SEI-CMMI 5 Company in various stages of the Software

Development Life Cycle (SDLC), including Requirement gathering, System Analysis, Design,

Development, Testing, Implementation and Production Support.

• In depth knowledge of Hyperion DRM application requirement gathering, design, integration,

implementation and testing of DRM solutions (11.x), in various projects.

• Played lead roles in Requirement Gathering, Analysis, Design, Development, Testing and

assisting UATs/Production support in multiple multi-vendor assignments

• Successful Hyperion DRM integration implementations with PeopleSoft Finance and Siebel

CRM,UCM and Finance applications

• Developed complex DRM Configurations to generate hierarchy codes that uniquely represent

position of nodes in various hierarchies in a major US bank. A number of downstream

applications depend on this code to consume hierarchies from source DRM system.

• Played a key role in implementing DRM integration with a Siebel Finance application for a large

European bank.

• Deep understanding of Siebel CRM and UCM Architectures, Data Quality Tools – Oracle

Enterprise Data Quality & Informatica Data Quality, Implementation of the Siebel Products:

Siebel 8.x, Siebel 7.x.

• Worked as a DBA for Oracle 9i and 10g databases in Solaris and windows environments.

• Comprehensive background with Siebel Finance, Pharmaceuticals and Sales Applications.

• Played the role of an architect and production support lead in one of the largest Pharmaceutical

companies from their headquarters in Delaware, USA.

CAREER OBJECTIVE

I would like to work for an organization that offers a professional work culture with a challenging &

progressive environment with increasing responsibility & learning opportunities which will boost up

my capabilities and add values to the organization.

E D U C AT I O N

Degree/Course College/University Year of Passing

B.TECH (Electronics and

West Bengal University of Technology 2007

Communication Engineering)

TECHNICAL SKILLS

Operating System Windows, UNIX (Sun Solaris / Linux / HP-Unix)

Programming Languages C,C++, Unix Shell Scripting

Databases & Tools Oracle 9i,10G,11G, MS SQL Server 2000/2005

MDM Applications Hyperion DRM, OEDQ, IQD, Siebel UCM

Siebel CRM (Finance, Life Sciences, Sales)

CRM Packages

Other Utilities Remedy(BMC),MS Visio, Toad, Siebel Tools

Page 1 of 9

S U B H AYA N S U R

Phone No: +1-302*******

*******.****@*****.***

E M P L O Y M E N T H I S T O RY:

Location of the

Name of the Company Designation From To

employee

Cognizant Technology Consultant Kolkata (India), 2007 Till Date

Solutions US Corporation Delaware &

California (USA)

E X P E R I E N C E S U M M A RY:

P R O J E C T D E TA I L S

Project Title UB Finance Transformation Project

Role DRM Solution Architect & team lead

Client Union Bank N.A.

Duration and Location 07/01/2013 – Till Date(Monterey Park, CA )

Operating Systems Windows server 2008 R2 & Windows 7

Database Oracle 11i

MDM Tool Hyperion DRM 11x

CLIENT DESCRIPTION

Union Bank, N.A., formerly known as Union Bank of California, N.A., is a full-service commercial

bank with 398 retail branches in California, Washington and Oregon in USA. Headquartered in San

Francisco, Union Bank is a subsidiary of UnionBanCal Corporation, a financial holding company

which has $105.9 billion in assets. Its foundation is built on five lineages; three originate in California

and two in Japan.

DESCRIPTION OF THE PROJECT

Through the Finance Transformation (FT) project UB wants to modernize core accounting systems for

General Ledger, Accounts Payable and Fixed Assets by July 1, 2014. A new integrated application,

PeopleSoft Financials, is accompanied by necessary changes to the chart of accounts and changes to

workflows and access controls. DRM will maintain and enrich all the PeopleSoft hierarchies and send

them out to all downstream applications in various formats, after making periodic updates.

FT will empower employees to achieve UB’s strategic goals by better serving internal and external

customers. It will provide better financial control with faster and more accurate real-time reporting,

while also improving the operational efficiency, cost effectiveness and technological flexibility to

grow the business.

In order to do that, they are presently replacing old mainframe applications and replacing

them with PeopleSoft Finance and Hyperion DRM applications. Project will make sure that

all the other downstream applications are not impacted at all by these changes.

ROLES AND RESPONSIBILITIES IN THE PROJECT:

Communicating with various functional and technical teams to understand their requirements.

Page 2 of 9

S U B H AYA N S U R

Phone No: +1-302*******

*******.****@*****.***

Document the requirements from different teams and do the impact analysis and feasibility study

from DRM perspective.

Formulate a robust strategy for DRM and overall enterprise architecture which serves the project

requirement in the most efficient way.

Design, development and testing different proof of concepts with relation to DRM Hierarchy

enrichment process, extracts & performance issues.

Writing Functional and Technical Design documents of the development activities.

Receive hierarchies from the source - PeopleSoft application and enrich them with complex 10

digit alphanumeric codes. The automation of this code generation system replaced the age old

manual system retaining the same logic, so that the downstream applications will have no impact

while consuming hierarchies from DRM.

Creating export reports in specified formats as required by various consuming applications

including mainframes.

Creation of the test scripts, simulating different test case scenarios and review & test results.

Working on performance issues in DRM, raise SRs and follow up with Oracle to get solutions.

Planning the migration process from one environment to the other.

P R O J E C T D E TA I L S

Project Title Bedrock MDM implementation project

Role DRM Architect and Siebel UCM lead

Client Travel port Inc.

Duration and Location Mar 2012 – June 2013

Operating Systems Windows 2003/2000/XP, Linux

Database Oracle 11i

MDM Tools Hyperion DRM,Oracle UCM

DQ Tools OEDQ

CLIENT DESCRIPTION

Travel port is a broad-based business services company and a leading provider of critical

transaction processing solutions to companies operating in the global travel industry

The company is composed of the global distribution system (GDS) business, that further includes the

following brands:

• Apollo

• Worldspan

• Galileo brands

• Airline IT Solutions

All these brands host mission critical applications and provide business and data analysis solutions for

major airlines. This company has its presence in 170 countries across the globe.

DESCRIPTION OF THE PROJECT

Travelport wanted to have a global customer management capability to provide a holistic, dynamic,

accurate and timely view of all customers to create the foundation that enables Travelport to

optionally achieve short to long term revenue gains and market share opportunities. In order to do

Page 3 of 9

S U B H AYA N S U R

Phone No: +1-302*******

*******.****@*****.***

that, this project was started to create Enterprise wide Customer Master Information across the

organization. Project supported other critical strategic initiatives like BRM, CDR etc.

ROLES AND RESPONSIBILITIES IN THE PROJECT:

Leading various design teams to formulate a robust solution for MDM and overall enterprise

architecture

Bringing in expertise on Hyperion DRM and Siebel UCM technologies with valuable experience

in various business domains - CRM, MDM and Finance.

Configure DRM export, import, compare and difference report generation as per the design

standards.

User creation inside DRM and assign then right so that they can run DRM hierarchy reports

whenever needed.

Designing enterprise wide solutions across multiple platforms and technologies.

Gathering the requirements from different subject matter experts (Client Side) and do the impact

analysis and feasibility study from Oracle MDM perspective.

Design, development and testing different proof of concepts with relation to Oracle UCM-

Hyperion DRM performance & synchronization issues as well as on various sustainability

principles.

Technical Design review of the Migration & Interface process and Technical & functional design

documentation of the development work.

Design the automation architecture framework for batch and real time Interfaces.

Defining the migration strategy and scope for the DRM application.

Review of the configuration files for running Siebel Enterprise Integration Manager Batch

process. Data loading using Enterprise Integration Manager of Siebel.

Train the team about Quality related work (Error Cause Analysis, Delivery Schedule etc.)

Creation of the test data. Simulate different test case scenarios and review & integrate test

results

Work Distribution. Coordinating among teams to effectively design, develop test cases and

perform end to end testing across different locations.

P R O J E C T D E TA I L S

Project Title Credit Suisse MDM Implementation

Role Hyperion DRM and Siebel Finance developer

Client Credit Suisse

Duration and Location Jan 2011- Feb 2012, India

Operating Systems Windows 2003/2000/XP,AIX

Database Oracle 9i

MDM Oracle UCM

DESCRIPTION OF THE PROJECT

Customer was a leading share trading and financial investment company, based out of

Switzerland. The company intends to automate its existing process to build a solution which

would combine all activities from Customer Tracking to Trading with the help of Siebel UCM.

• Data Stewardship application to support operational activities

Page 4 of 9

S U B H AYA N S U R

Phone No: +1-302*******

*******.****@*****.***

• Real time integration with several downstream applications

• Data migration from 7 legacy systems

ROLES AND RESPONSIBILITIES IN THE PROJECT:

• Defining the migration strategy and scope for the Finance and DRM applications.

• Create and execute the configuration files for running Siebel Enterprise Integration Manager

Batch process. Data loading using Enterprise Integration Manager of Siebel.

• Integrate DRM with Siebel Finance application, store and maintain all Siebel hierarchies in

DRM.

• Configure DRM properties to generate exports of hierarchies in formats that are directly

consumable by various legacy systems.

• Create and manage users in DRM and manage administrative tasks.

• Configure and generate various export reports based on user requirements

• Leading the migration of DRM and Siebel applications from development to test and then to

Production environments.

• Creation of the test data. Simulate different test case scenarios and review & integrate test

results

• Work Distribution. Coordinating among teams to effectively design, develop test cases and

perform end to end testing across different locations.

P R O J E C T D E TA I L S

Project Title AZ US Field Sales and AZ Visage Support

Role Onsite team lead

Client Astra Zeneca

Duration and Location November 2009-January 2011, India/US

Operating Systems Windows XP

Database Oracle 10g

CRM Siebel 7.7x

Page 5 of 9

S U B H AYA N S U R

Phone No: +1-302*******

*******.****@*****.***

CLIENT DESCRIPTION

ASTRAZENECA IS A GLOBAL, INNOVATION-DRIVEN, INTEGRATED

BIOPHARMACEUTICAL COMPANY WITH AN ACTIVE PRESENCE IN OVER 100

COUNTRIES AND WITH A GROWING PRESENCE IN EMERGING MARKETS

INCLUDING CHINA, BRAZIL, INDIA AND RUSSIA. ASTRAZENECA DISCOVERS

& DEVELOPS, MANUFACTURE AND MARKET, PRESCRIPTION MEDICINES

FOR SIX IMPORTANT AREAS OF HEALTHCARE, WHICH INCLUDE SOME OF

THE WORLD’S MOST SERIOUS ILLNESSES: CANCER, CARDIOVASCULAR,

GASTROINTESTINAL, INFECTION, NEUROSCIENCE, AND RESPIRATORY AND

INFLAMMATION

DESCRIPTION OF THE PROJECT

Global support engagement christened “Momentum” comprising of successful knowledge transition

(Technical and Functional Modules) from the Incumbent Vendor and steady state support handling

~1500 Incidents/Month for Quattro Application (Siebel Configuration, Siebel Data and Siebel

Analytics ). This Field-Sales application is a Siebel application rolled out across USA and Canada,

Offline and Online Users, having achieved 4 CRM maturity levels namely Sales Force Automation,

Enterprise-wide single view of Customer, Customer insights Driven Sales & Marketing and Tailored

Customer Management. High level scope of this program includes -

24*7 Level 3 Support including Capacity Management, Availability Management, Incident

Management, Change Management, Problem Management & Operational activities

24*7 Support of Data Interfaces across all the Markets comprising of ~ 80 Medium and High

complexity Interfaces

Maintenance releases as a part of the Support engagement as agreed contractually

Quarterly/Monthly Sales Cycle engagement comprising of Data Interfaces to handle

communication/Validation/Loads for medium to high Alignment changes/Territory Changes

& Targeting and segmentation information for all the Markets

Engagement comprises ~100 resources currently working on different aspects

ROLES AND RESPONSIBILITIES IN THE PROJECT:

Leading the data team comprising of 9 members to do regular support activities which includes

sales cycle, interface automation and demographic data load for 64 countries across the globe.

Guiding the team to do root cause analysis of the critical issues and communicate them

Engaged in designing, development and testing different proof of concepts with relation to Siebel

performance & synchronization issues as well as on various sustainability principles.

Guiding the team from the front to take knowledge transition from the development team (Other

Vendor).

Working closely with proposal team to produce different enhancement proposal for the Quattro

system, also leading the team to prepare proof of concepts for those proposal.

Design the automation architecture framework for batch Interfaces as part of enhancement

service scope.

Page 6 of 9

S U B H AYA N S U R

Phone No: +1-302*******

*******.****@*****.***

Gathering the requirements from different subject matter experts (Client Side) and do the impact

analysis from data perspective for enhancement work.

Preparing Quality Documents (Error Cause Analysis, Delivery Schedule etc.)

P R O J E C T D E TA I L S

Project Title Pfizer Animal health US and Europe

Role Siebel team member

Client Pfizer

Duration and Location July 2008 –October 2009 Kolkata – India

Operating Systems Windows 2003/2000/XP,

Database Oracle 10G

CRM Siebel 8.0

CLIENT DESCRIPTION

Pfizer is a dynamic and a fast growing Animal Health company, operating in a fluid and highly

competitive market in US and Europe.

In order to support their growth plans Customer had undertaken a large IT transformation Program

underpinned by the replacement of its existing legacy systems with the latest Oracle and Siebel

applications.

This project was aimed at providing a fully scalable CRM solution to all of Pfizer’s sales

representatives working for its Animal Health division across US and Europe. With this solution sales

representatives could easily download latest drug information, related presentation, target sales area,

target account and contact information and also review of the progress made on target sales as various

charts. Synchronization of user’s data with the server could easily be done using sync service.

ROLES AND RESPONSIBILITIES IN THE PROJECT:

• Installation of Siebel ePharma Application version 7.8.2.5 and 8 on Window operating system.

• Configuration of Siebel Server Siebel Server according to the needs specified by the

developers.

• Configuration of object managers for different countries.

• Monitoring the Batch Assignment jobs, DB Extracts.

• Installation & configuration of Oracle BI 10.1.3.3.2, Informatica 7.1.4 along with DAC 7.9

• Successfully handled some DBA roles (Installation, bit of database performance & tuning

exercises, backup / recovery strategy, table space, creation and management and changing db

parameters

P R O J E C T D E TA I L S

Project Title Pfizer China

Page 7 of 9

S U B H AYA N S U R

Phone No: +1-302*******

*******.****@*****.***

Client Pfizer Inc.

Role Team member

January 2009 to May 2009

Duration and Location

Environment Windows NT, Siebel Servers, Solaris, HP UX,Oracle Server

Database Oracle 9i

Siebel 7 ePharma Life Science, Datastage Client, Oracle 8i, PL/SQL,

TOOLs

EIM Concepts

CRM Siebel 7 ePharma Life Science

CLIENT DESCRIPTION

Pfizer Incorporated is a pharmaceutical company, ranking number one in sales in the world. The

company is based in New York City, with its research headquarters in Groton, Connecticut. It

produces the Lipitor (atorvastatin, used to lower blood cholesterol); the neuropathic pain/fibromyalgia

drug Lyrica (pregabalin); the oral antifungal medication Diflucan (fluconazole), antibiotic Zithromax

(azithromycin), Viagra (sildenafil citrate), and the anti inflammatory Celebrex ( celecoxib) (also

known as Celebra in some countries outside USA and Canada, mainly in South America).

DESCRIPTION OF THE PROJECT

ECMS China Implementation was a Siebel application developed for China. All the country users

would be using the ECMS/SFA Application.

This application was being designed to support common selling activities, and processes that sales

force engages in while interacting with the customers. This project was executed in two phases phase

1 and phase2. ECMS China Implementation was quite important from customer business strategic

point of view as the ECMS application for the first time was rolled out for any APAC country .

ROLES AND RESPONSIBILITIES IN THE PROJECT:

• Offshore team member

• Gathering and Analyzing requirements and technical design

• Setting up Production environments

• Data Migration

• Install and configure the Siebel environments required for this project.

P R O J E C T D E TA I L S

Project Title Pfizer ECMS

Client Pfizer Inc

Role Team member

Duration December 2007 to August 2008,India

Environment Solaris, Oracle Server

Page 8 of 9

S U B H AYA N S U R

Phone No: +1-302*******

*******.****@*****.***

Database Oracle 9i

CLIENT DESCRIPTION

Given above

DESCRIPTION OF THE PROJECT

• World’s largest pharmaceutical major had a mobile user base of 3000 (which was likely to go

up to 13000) and this engagement was typically aimed at providing optimal assessment for their

ECMS Lucan, ECMS UK and Promote application performance, infrastructure requirement, finding

out the sustainability principles and identifying failure points and recovery scenarios to enable the

applications to be robust, scalable, recoverable with minimal impact to business

•

• The project is centered around establishing and running a Program Management Office

(PMO) for providing strategic direction, in turn assisted by a Center of Excellence (Coe) providing

technical expertise on Siebel and its integration with other ECMS components such as Data

warehouse and iAnywhere.

ROLES AND RESPONSIBILITIES IN THE PROJECT:

• Worked as Siebel Administrator

• Monitoring Server Jobs and Mitigating/ Rectifying unusual component behavior

• Coordinating with the development team to deploy new server jobs

• Setting up development environment

Page 9 of 9

Contact this candidate