Project Sales
Resume:
S U B H AYA N S U R
Cell No: +1-302-***-****
Email: acdgth@r.postjobfree.com
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*******
acdgth@r.postjobfree.com
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*******
acdgth@r.postjobfree.com
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*******
acdgth@r.postjobfree.com
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*******
acdgth@r.postjobfree.com
• 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*******
acdgth@r.postjobfree.com
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*******
acdgth@r.postjobfree.com
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*******
acdgth@r.postjobfree.com
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*******
acdgth@r.postjobfree.com
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