Sql Server Project

Arindam Dutta

Resource Highlights

Arindam Dutta's expertise on implementation, maintenance and support of

various Siebel Projects across all the industries like pharmaceuticals,

clinical, services. Arindam has a unique profile in that he has gained

extensive experience across many areas of Siebel like Server

Administration, Integration and configuration roles of CRM implementation

projects including tech lead, integration lead. As a result of this

profile, Arindam has a thorough understanding of the interrelated

components of the Siebel CRM. He has total IT experience over 9 Yrs.

Background

Arindam has started his career in TATA Consultancy Services, Asia's largest

software company direct from his college in year 2000. He experienced there

about software development in various technologies like Microsoft, Oracle

database, Crystal Report and later he shifted to Siebel CRM. In 2007 he

joined in IBM India as a Siebel Server Admin & Configuration specialist. In

Nov. 2007 Arindam joined in C3I as Tech Lead for The Medicines Company

Project. After successful completion of that Project, he has started

implementation of Warner-Chilcott project. Later he joined in Eisai

Pharmaceutical Siebel enhancement project.

Work Experience

C3i, Inc. (Nov' 07 - Present)

Eisai Pharmaceutical as Siebel Tech Lead

. Siebel Pharma 7.7 Enhancement as Tech Lead

. Managed 1100-Mobile users of Siebel Pharma.

. Handle Transaction Merger issue due to Account merge.

. Rectify the corrupted DX files generated due to Account Merge

. Weekly monitoring Transaction backlog.

. Troubleshooting the various UI related issue logged in as SR

. Involve in the proving technical architecture and solution for every

Siebel release.

. Converting all functional requirement into Technical Design Document

. Deploy database Schema Upgrade using Siebel Anywhere after every release.

. Configure Siebel application using Tool

. Daily to daily production monitoring

. Creates MS Excel report for sales force as requested.

Environment: Siebel 7.7.2.6 ePharma, Oracle 10.2.0.2, Siebel Tool, VB

Script, Excel Programming

Warner Chilcott as Siebel Architect

. Siebel Pharma 8.0 implementation as Siebel Architect

. Install Siebel Gateway, Siebel Application Servers and SWSE for DEV, VAL

and PROD using Oracle Universal Installer

. Given the idea about 100% redundant Siebel server architecture to handle

disaster recovery recommended by Oracle.

. Load Balanced Production Environment set up.

. Actuate Server Setup

. Setup Remote Server for 500 users

. Managed 500-Mobile user Siebel Pharma.

. Project focused on specialty sales force and included SAP Integration,

syndicated data, and full expense reporting functionality.

. Build 4 new Interface using SAP eBusiness Connector. Sample Order

(Inbound / Outbound), Employee Roster (inbound / Outbound)

. Worked with EAI Siebel Adapter, DataMap Administration, Workflow, Runtime

Event

. Proposed integration solution for AMEX data with Siebel Expense Report.

. Build the automated script to configure all Siebel related setup in new

laptop.

. Deploy 500 user in Production Environment

Environment: Siebel 8.0.0.3 ePharma, Oracle 10.2.0.2, Siebel Tool,

Windows 2003 server

The Medicines Company as Onsite Tech Lead

. Work as Tech Lead with other Offshore team in India.

. Siebel Pharma 8.0 implementation

. Install Siebel Gateway, Siebel Application Servers and SWSE for DEV, TEST

and PROD using Oracle Universal Installer

. Managed 200 Mobile user Siebel Pharma.

. Implement Siebel/Outlook synchronization for Contact module

. Implemented Syndicated data, and full expense reporting functionality.

. Set up Siebel Servers for Dev, Test and Production environment.

. Setup Remote Server for 200 users

. Proposed integration solution for AMEX data with Siebel Expense Report.

. Integrate other portal with Siebel using WI Symbolic URL

. Siebel SSO implementation

. Proposed integration solution for State Spend report

Environment: Siebel 8.0.0.1 ePharma, SQL Server 2005, Siebel Tool,

Windows 2003 server

IBM India Pvt. Ltd. (Mar'07 - Oct'07)

Ricoh Integration RFGS

. Integration Lead

. Siebel 7.7 eService

. Integration Siebel eService application with Oracle Apps using WBI Siebel

Adapter

. Prepare Technical Design document after analysis of Functional Document.

. Create Siebel Business Objects, Business Components according to

Technical Document.

. Create Integration Object and integration Component.

. Create Workflow and writing Business Service as per Technical Document.

. Implemented integration of various modules - Order Management, Service

Request.

. Siebel Administration - Repository Backup, DB Extract for developers,

monitoring Workflow Component Group

Environment: Siebel 7.7 eService, WBI Siebel Adapter, Oracle 9.2.0.6,

Siebel Tool, PL/SQL, IBM Websphere, IBM Rational ClearCase, IBM Rational

ClearQuest, TOAD 8 Windows XP Prof

TATA Consultancy Services Ltd. (Sep'00 - Feb'07)

Johnson & Johnson (PR&D)

. Production support Lead

. Siebel 7.5 eClinical

. Worked as primary Siebel Server Administrator.

. Involved in dedicated and mobile client installation.

. Database extraction for the new users.

. Involved in quarterly production release.

. Administering Actuate iServer.

. Database refresh in Development & Staging environment.

. Working in daily to daily component monitoring task.

. Writing Siebel EAI Web Service.

Environment: Siebel 7.5 eClinical, Informatica 7.1, Oracle 8i, IIS,

SQL*Loader, PL/SQL, Windows XP Prof, TOAD8

Lifescan of Johnson & Johnson

. Siebel Configuration Expert

. Siebel 7.7 eMedical

. Create Siebel Business Objects, Business Components.

. Created Join, Link, & MVG.

. Create Applet and View.

. Create Workflow and debugging. Convert Change Request requirements into

Detailed System Requirements.

. Writing server side scripting.

. Write Technical Specification after analysis of Change Request.

. Modified data map object as per technical specification.

. Writing Business Service.

. Perform unit testing.

Environment: Siebel 7.7.2.2 eMedical, Sun One Web Server, Oracle 9i,

PL/SQL, Windows XP Prof, TOAD 8

Merrill Lynch GPCT Project

. Siebel Configuration Team member

. Siebel 7.8 marketing

. UI validation in Siebel 7.8 comparing existing application in 7.5 during

post upgrade activity.

. Test & Verify all the Business services and Workflows after upgrade in

7.8.

. Defect fixing in 7.8 as post upgrade activity

. Verify and deploy all the running smartscripts in 7.8 from 7.5 during

post upgrade activity.

. Overall system testing after upgrade in 7.8 from 7.5

. Perform unit testing. Prepare system test case

Environment: Siebel 7.5, 7.8 Marketing, IIS 5.1, SQL Server 2K, Windows XP

Prof, TOAD 8

GE Medical System (GEMS)

. Analysis of existing GGDD MLS Dashboard application.

. HLD, LLD and Process Flow Diagram of existing system

. Incorporation of All GCO Org in the current system

. Deal with all Production issue of the GCO part

. Writing batch job using VB Script.

. Involved in Database design, table creation in MS Access.

. Designed and developed ASP pages and interfaced ASP application

. Wrote, enhanced and managed batch jobs to load highly sensitive inventory

data from Oracle database to MS Access.

. Directly interacted with managers across GE business on a regular basis

Environment: ASP, IIS Server, MS Access, VB Script, Windows NT, VSS

Somerfield - SPC Client Server

. Analysis of existing application.

. Impact analysis of each application due to database change.

. Re-engineering of all impacted components according to the latest

database.

. Modify PB code.

. Upgrade SQL Server 6.5 to 7.0

. SQL Server Administration.

. Involved in writing PL/SQL, stored procedure, function, triggers.

. Performance tuning of newly developed database objects in SQL Server 7.0

Environment: SQL Server 6.5/7.0, PL/SQL, Power Builder 8.0, Windows NT, VSS

SBI Home Finance Ltd

. Involved in designing & developing crystal report.

. Create stored procedure, table, and index for report access.

. Writing ATL COM using VC++

. Integration of crystal reports with front end through ATL COM.

. Writing system test cases.

. Perform unit testing

Environment: ASP, Oracle 8i, IIS, VC++, Crystal Report 8.0, Windows NT,

VSS, MTS.

Education

Bachelor Of Engineering in Computer Science, 2000

Regional Engineering College, Durgapur, India

Contact Info

Phone: 862-***-****

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

Contact this candidate