MOHAN RAJ

E-mail: acvcd0@r.postjobfree.com Phone: +1-301-***-****

PROFILE

Professionally & academically qualified with a B.E (Electronics & Communication Engineering) & having acquired vast experience from various reputed organizations in different capacities. Over 15 years of work experience in the field of Delivery Management & Service Delivery (IT Infrastructure, Database), Data Center Migration, Database Architect, Design and implementation of Application Software & Application life cycle management. Experience in Leading Oracle Center of Excellence in Data Center to manage 24X7 production system and Database Implementation consultancies

PROFESSIONAL EXPERIENCE

Organization: Cognizant Since Jun’11

Project Title

Western Union - IT Infrastructure Services – Data Centre Technologies

Period

Sep 2015 to Till date

Roles & responsibilities

Sr. Manager – Transition & Delivery

Service Delivery for IT Infrastructure and Data Centre Applications includes Build, Run and Mitigation, Englewood, Colorado, USA

Key Accountabilities:

oResponsible for Service Transition from existing Model to new BRM model

oAccountable for complete Transition framework to meet all the customer expectations

oDefining Resources, Roles & Responsibilities and Org structure for Transition and Delivery include Technical execution in both Onsite & Offshore.

oResponsible for DC Transition Risk assessment, planning, scheduling and cost estimations

oAlign with ITSMO for all the process flow and DC application service managements

oUnderstanding DC technology operations, Project Implementation and challenges & solutions

oResponsible for meeting Service Level Agreement as agreed in the contract.

oHandling and assessment of apps new builds and migration coordination with vendors

oResponsible and coordination with process groups like Quality, Security and change management for successful completion & avoid any process issues.

oHandling escalations for both internal and customer for various BU’s and vendors & coordination.

oGovernance with stakeholders, customer and Higher Management for both Onsite and Offshore Mangers and Leads

oWorking with team for standard Technical executions for various Infrastructure and DC technologies

oCoordinating and aligning with Application Support groups for smooth program executions

Project Title

Medimmune Life cycle Management(LCM) Program & CTMM Application upgrade Project

Period

Aug 2013 to Aug 2015

Roles & responsibilities

Sr.Manager - Delivery

CTMM project solution & Infrastructure Architect for Medimmune &

Manager for Application Life cycle Management (LCM) program in Gaithersburg, Maryland, USA

Key Accountabilities:

oProject requirement analysis, planning and execution of application retirements, upgrades and Migrations for Legacy & unsupported platforms.

oDefining Resources, Roles & Responsibilities and Org structure for LCM Program/Project Delivery include Technical execution in both Onsite & Offshore.

oResponsible for LCM Application Risk assessment, planning, scheduling and cost estimations

oDefined the process flow charts and process for LCM Apps retirement, upgrades, migrations & Discovery

oManaged team of Offshore - Onsite support and deliverables for LCM & Middleware AHS & DB

oHandled procurement & implementation part for the projects

oManaged multiple small projects & delivery by working with multivendor & teams

oSLA Service delivery for End customer

oResponsible for Program Change Management (CR’s) and IA’s

oHandling and assessment of apps retirement, upgrades and migrations for R&D, Commercial, G&A and Operations BU’s

oResponsible and coordination with process groups like Quality, Security and change management for successful completion & avoid any process issues.

oHandling escalations for both Middleware, Build & LCM program for various BU’s and vendors & coordination.

oGovernance with stakeholders, customer and Higher Management for both Onsite and Offshore Mangers and Leads

oWorking with team for standard Technical execution document for various Middle Ware technologies and Apps Retirement & process group approvals.

oCoordinating and aligning with Application Support groups for smooth program executions

Project Title

AstraZeneca - Emerald Program

Migration -Middle Ware and Database Services

Period

Mar 2012 to Jul 2013

Roles & responsibilities

Manager - Delivery, UK

Data Centre Migration for Middleware and Database & Delivery for UK, Sweden & NA Region’s

& Delivery Manager for Singapore MW Wave migration.

Key Accountabilities:

oDatabase and Middlware Migration Requirement analysis, planning, execution, scope & changes of the projects (Singapore Region) and Complex Migrations (UK, Sweden & NA)

oResponsible for Program level Scope Changes, cost estimation and Impact assessments (IA)

oTeam Management both onsite - offshore in multiple geography support and deliverables for Emerald includes delivery Leads, Architects, technical leads

oHandling & Defining of Cut over’s and Meetings with multiple vendors and Customer

oResponsible for Milestone completion and risk management for complex application AHS-DB services

oDefined the communication planning and hand over process for cutovers in Singapore Wave migration

oDefinition of Roles & Responsibilities, Org structure for Program/Project Delivery include Technical Architectural team and Delivery Leads

oActively Participated in the discussion of Migration method decisions and POC’s planned for PDC and RDC’s

oGovernance with customer, higher program managements and delivery teams in both Onsite and Offshore

oProject Status reporting biweekly, monthly to Program management team & customers

oHandling of escalations for various complex Applications suits for various Regions & coordination

oTechnical effort estimation and assistances for successful completions

oDelivery and Process management of Emerald Program to BAU handover

oWorked in Automation and Transformation activities for the migration which reduce cost and time

oEnsuring Execution of smooth Data center MW migrations from one DC to others by coordinating and aligning with Application Migrations

oFinding new business opportunities within the customer for any solutioning & enhancement

Project Title

AstraZeneca - MW DB Run Services (BAU)

Period

Jun 2011 till Feb 2012

Roles & responsibilities

Manager – Service Delivery Lead - Database, Chennai

Complete End to End delivery of Middle Ware services for Database BAU delivery from Offshore (Chennai, India) covers UK, US and Asia Regions.

Key Accountabilities:

oEnsuring Delivery for Middleware Database engagement for BAU’s

oHandshake and governance between Horizontals and Verticals

oOnsite and offshore deliveries (India, UK, US and China)

oPeople management for the team of 30+ and ELT’s

oService Improvement Plans (SIP’s) and Roadmaps for Middleware and Database

oEnsuring availability for more than 1500 database for the environment of 24x7

oImplementation and Upgrades of Oracle databases, Patching, Oracle Data Guards, RAC

oMultiple geography support for the customer (NA, UK, Shanghai & India)

oFinding new business opportunities within the customer for additional scopes

oSLA Service delivery for End customer

Organization: D&B TransUnion ADSL Sep’08 - May’11

Architect – Database

Key Accountabilities:

oDatabase management and interface with application support team

oHandled team for Database Support delivery for Credit Bureau information system India, Omen & Libya

oHandling client escalation, Database performance issues and taking proactive measures

oDatabase Implementation and consultation for all Bureau’s

oDone the Transition for database offshore support delivery for TransUnion, Chicago, USA

oLeading the “Center of Excellence” for Database Team and Management

oSuccessfully implemented Oracle RAC in Libya, Nigeria, Bhutan and Sri Lanka

oDatabase capacity planning and Recommendation

oResponsible for installation, application setup and configuration of Oracle Database & Data Guard

oForming backup and recovery strategy for RMAN, Hot and Cold backups

oPerforming database tuning using Explain Plan, Hints, TKPROF, Stats pack, AWR, Enterprise Manager & Grid controls

oProviding on-call production database support

Assignment

Project Title

FICB

Period

Sep 2008 till Jun 2009 & Jan 2010 to May 2011

Roles & responsibilities

Handling the Application project support delivery for CIBIL-India, Omen & Libya

Lead – Leading “Centre of Excellence” for database and providing solution to all the customers in FICB vertical. Managing Team members and handling escalations from the clients.

Solution Environment

Oracle 9i, 10g, 11g R2

High Availability (Data Guard)

ASM & RAC

Tools

Grid Control, OEM, SQL Developer & SQL Plus

Organization: 3i-Infotech Ltd. Sep’04 – Aug’08

Lead – Database “Centre of Excellence”

Key Accountabilities:

oProject management and interface with application support team

oResponsible for installation, setting up, and configuration of Oracle Database on SUN servers SPARC 9 & 10

oProactive monitoring and Administrating 24X7 Production system for 3 Terabyte database and more than 5000 concurrent users

oSetup and maintaining Data Guard (Physical) /Stand by database and Log application Process

oAnalyzing the root cause for various alerts raised and providing solution within the SLA period.

oFormed backup and recovery strategy for RMAN, Hot and Cold backups

oInstallation and configuration of Oracle Application Server 10g R2 (Forms and Reports)

oApproving data structure change requests (DSCR)

oPerformed database tuning using Explain Plan, hints, TKPROF, Stats pack, AWR, Toad and Enterprise Manager.

oInteracting with Oracle Support team for Service Request (SR) and other Issues and provided on-call production database support to the customer’s

oDatabase sizing, Recommendation, Planning and resolved design issues during development

oDeveloped Unix Shell scripts to automate database operation and database monitoring

oPeriodic Database Statistics gathering, Rebuilding of indexes and moving of objects based on IO statistics

oOracle Business Intelligence (BI) Tool setup, configuration and Implementation

oHandled Data migration activity to migrate data from SQL Server to Oracle database using ODBC and Heterogeneous Services

Assignments

Project Title

PREMIA – US Geography

Period

April 2007 till Aug 2008

Roles & responsibilities

Lead – Provided Database consultancy and Implementation support for all US Premia Customers

Description

Responsible for Implementation of Premia product at our customer site placed in US. Premia is the product for Insurance end to end solution and Implemented at various places to our customers like Healthcare Providers insurance Co., Commercial America Insurance Co. ltd, Nevada Mutual Insurance co., Virginia Farm Bureau

Insurance Company, American Physician Insurance Company, Block Vision

.

Solution Environment

Oracle 10G

Oracle Discoverer

Oracle Application Server

Windows 2000

Tools

OEM, SQL Developer, Toad & SQL Plus

Highlights

Migrations from SQL Server to Oracle Database

Project Title

Oriental Insurance Co. Ltd, India

Period

Sep 2004 – Mar 2007

Roles & responsibilities

Sr. Oracle DBA

Description

Implemented Centralized Oracle Database system for one of the largest Indian Insurance customer. Provided 24/7 support and ensured database availability for more than 5000 concurrent users. Involved in process definition and escalation handing for smooth function of both production and development environment.

Solution Environment

Oracle 9i, 10G, Data Guard

Oracle Discoverer

Oracle Application server

Sun Solaris 9 & 10

Tools

OEM, SQL Developer, Toad & SQL Plus

Organization: CMC Limited (TATA ENTERPRISE) Jan’01- Aug’04

Project Assignee – System Integration

Key Accountabilities

oDBA activities like installing Oracle software, creation of database, maintaining the database with proper backups and recovering the same if necessary.

oImplemented Brains & Genisys software for Vijaya Bank and Insurances New India Assurance, United India Insurance and National Insurance Co. in India for more than 200 Branches.

oInstallation of Oracle 8,8i on UNIXWARE and Windows and created Database Instances.

oPL/SQL programs were developed for data manipulation.

oInstallation of Oracle client tools and establishing connectivity to databases

oCreating table spaces, tables, indexes, users, etc and handling free space deficit problem

oHanded multiple customers to Implement Banking & Insurance Products at client site

oDatabase object sizing was done for effective space management and optimal performance.

oMigrating old data to Oracle Database through SQL*Loader on windows and Unix system

oImplemented Database refresh using Export and Import Utility

oExplained about Modules & tools incorporated in the products Brains (Banking) and Genisys (Insurance)

oWriting shell scripts to automate routine activities

Assignments

Project Title

BRAINS

Period

Oct 2003 to Aug 2004

Description

BRAINS is the Banking application which developed for Retail Banking Operations.

This has been implemented in one of the Nationalized bank “Vijaya Bank” in India for functioning retail operations.

Roles & responsibilities

Project Assignee – Implementation of Banking software in oracle environment and Installation and maintenance of Brains software. Migration of legacy system data to new system. Ensuring smooth operation after implementation and solving day to day operation problems. Implementing Back up methods and application patches.

Solution Environment

Oracle 8i, .Net

Linux

Tools

SQL plus, telnet, ftp, Oracle Developer

Highlights

Handled one Region Branches to implement banking software

Project Title

GENISYS

Period

Jan 2001 to Sep 2003

Description

Insurance application software developed for Indian insurance companies. This is office automation software for end to end Insurance solutions. This was implemented all major Insurance companies like New India Insurance, United India Insurance and National Insurance Co. More than 1000 branches were implemented for each Insurance company.

Roles & responsibilities

Installation and Maintenance of Genisys software. Migration of legacy system data to new system. Ensuring smooth operation after implementation and solving day to day operation problems. Implementing Back up methods and applications patches.

Solution Environment

Oracle 8, 8i

Oracle Forms

Oracle Reports

Unix Ware, Sco Unix, Windows

Tools

SQL Plus, Telnet & ftp

CERTIFICATIONS

Successfully completed the following certification to have acquired expertise in this field:

OCA Oracle 9i

TRAININGS

Successfully completed the following trainings to have acquired expertise in these fields:

Program

1. Project Management Training

Coverage

Project management Program (PMP)

Year

2011

2. Oracle 10G RAC

Real application Cluster

2009

3. Oracle 11G

New Release of Oracle version

2009

TECHNICAL SKILLS

Languages: SQL, PL/SQL

Database: Oracle 8i, 9i, 10G & 11G

Application Server: Oracle Application Server (10.1.x.x)

Operating system: Linux, UNIX, Windows

Tools: Grid Control, OEM, SQL Developer, Toad, SQL Plus, Oracle Discoverer

Contact this candidate