Delivery Manager
Cognizant Technology solutions
Total years of experience :27 years, 8 Months
Lead the Astrazeneca Middleware Build Services team from Offshore as the Project Manager.Tailored the team for building and deploying the Middleware components under various towers led by Team Leads & Tech Leads. .Responsible for taking effective actions in people management and negotiating while leading the team to pioneer. Provided technical guidance to the team in order to get the output in time.
Initiated customer discussions and gathered new requirements, system analysis and proposed solutions for the build.
Prepared 300+ “Statement Of Work” and cost estimates for the proposed solutions for the customer.
Checking, validating, assigning, recording, following up till completion and reporting on Change Requests
Validating and following up of RFS changes till completion.
In-charge of the ESA Project Management, Invoicing and Forecasting.Taken care of Capacity Planning, documented it and trained the team for its execution.Addressing and solving various issues in the team, structured the team efficiently for better outcomes.Coordinated the team’s activities according to planned schedules.Identified, tracked and coordinated the team’s assessment activities.Disaster Recovery was planned, scheduled, coordinated and executed.Maintained Project tracker, project plans, status updates.
Always kept a future plan focused for the next one year across Middleware towers. Developed recurring approach for execution.
Received formal & informal appreciation from the client and on-site project managers for timely delivery and efficiency many times during the tenure of the project .
Amgen Inc..
Offshore Shared Service Support for the Clinical Data Management (CDM) System of Amgen.As an Oracle Clinical System Administrator, am responsible forMonitoring of Batch Validation, OC Sessions, licensed users, SAS view transfer to reporting instance, Rollsnap table creation, Application server sessions, and Oracle Clinical L2 & L3 tickets. Monitoring Interim Lock Activities. Troubleshooting OC /iReview/jReview/PSUB/Report Server issues
Upgrading of WhoDrug & MedDRA Dictionaries
Maintenance of scheduled jobs, automated scripts, Users, Studies, Patient Discrepancies, Projects, Trusted OC users etc.
Documentation of Business Practices
Monthly Reports for applications like OC /TMS, RAVE, DMP, GMAT, eTrack
Wyndham Vacation Ownership as an Oracle DBA, am responsible for installation and Applying Oracle patches, Creation, configuration of Oracle databases Monitoring High Availability of Servers and Notified by email from Grid.
Setting Metrics Thresholds and Policies in Grid Console.
Performing Query tuning and Database Tuning with Automatic Workload Repository reports, ADDM etc.
Promoting DDL/DML changes to the database, Generating Metadata Scripts.Trouble shooting the daily development/production problems.
Database cloning using RMAN scripts.
Schema Migration and Tables Migration from QA to Production and Database refresh from Production to QA / Development environments.Maintenance of Production / Staging/ development Databases.Database upgrade and migrations from different version to 10g.Analyzing the objects and rebuilding Indexes.
Writing Linux/Unix Shell scripts, RMAN scripts etc for backups
Automating scripts and exports / imports.Online Reorganization.
Maintenance of Real Application Cluster environment
Maintenance of Automatic Storage Management environment
Maintenance of Logical Standby environment
database Migration from 9i to 10g (Language /Territory customization, Character set & Linguistic sort). Diagnosis using Character set Scanner etc.
IMS America
Offshore DBA support to IMS America. We support more than 150 SQL Servers those belong to IMS US & Latin America of various applications which include Production, UACC, Integration and Development Databases.
As a DBA, was responsible for
Requirement analysis and Design of ER Diagrams.
·Normalizing the Database design and relationships with entities.
·Installing and Configuring Oracle Data Base.
·Establishing Security Policies.
·Deliverables were ER Diagram & Database Document & Database Script.
·Scheduling Backups and Recovery methodologies and scripts for Development Environment.
·Used Change Data Capture for Data warehousing, Oracle Streams for replication etc.
·Creating and administering user accounts, roles, granting and revoking privileges .
·Using Net Manager, Configuration Assistance. Start and stop the agent, Enterprise Manager, Listener.
·Defining, Managing Storage Structures, Schema Objects like Tables, Attributes, Constraints, Indexes, Views, Triggers, Procedures, Functions, Database Links.
·Using Import, Export SQL Loader .
·Audit database activity.
·Monitoring and Resolving Lock Conflicts, Manage deadlocks .
·Distributed and Remote Queries and Remote Transactions .
·Configuring and Monitoring Flashback Database and Backing Up the Flash Recovery Area .
·Implementing Materialized Views, Materialized View Logs and Monitoring materialized view refresh .
·Performance tuning using Hints.
The package consists of staff management in terms of allocating work in different places and payroll will be taken care by Ministry of Civil Service. Small Purchases like stationary and office equipments, Managing subcontractors like cleaning and maintenance contractors, and Asset Management also.
As a DataBase Designer, was responsible for
·Creating an Oracle DataBase
·Configuring Oracle Server by :-Installing Oracle Server, Planning & Creating DataBase, Implementing DataBase Design, Enrolling System Users, Tuning DataBase Performance.
·DataBase Storage:-Managing Tablespaces, DataFiles, Schema Objects, Partitioned Tables & Indexes, Tables, Views, Indexes, Sequences, Synonyms, Clusters.
·Detecting & Repairing Data Block Corruption
·Establishing Security Policies, Managing Users & Resources, User Privileges & Roles.
TVS is an enterprise deals with different vehicle manufacturers to provide sales and service operations across many locations in India and Colombo. TVS-Next is a web based ERP, which automates the TVS business processes across all locations and maintain centralized information, which improves business policies and customer services. It is developed using MVC architecture with STRUTS Framework.
As a PL/SQL Developer, Database Designer, was responsible for
·Extensively worked in Finance, HR & Payroll Modules.
·Involved in requirements gathering, designing and development.
·Prepared Data Modeling using ER Studio.
·Analysis of the specifications provided by the clients and identified the ambiguities with respect to the real time requirement.
·Have done documentation like use case traceability matrix, change requirement etc.
·Responsible for Database backup and Database management.
·Responsible for overseeing the Quality procedures related to the project
The HRMS package consists of details of different armies in defense like Army, Royal Guard, Oman Navy, Royal Air force, and their skill sets, promotion rules, people history, salary, leave, benefits, pensions, transfers, budget for salary etc.
The Defense Inventory package lists from Weapons to civil Purchases. Requirement Planning from different divisions, send quotes to international and local markets, compare quotes and send for approval to superiors, prepare purchase order for International and Local companies, material receipts, inspection, acceptance and stock update, rejection and send back to supplier. Issue of materials to user departments, Stock in stores, physical verification of stock. Different types of stock and consumption reports, including purchases like fighter flights, ships and tanks.
As a Software Developer, was responsible for
·Requirement analysis
·Development of Application
The Health Care System for the Clinic was a Client /Server solution, which included just the Out Patient dealings, the Pharmacy and Accounting solutions.
As a Quality Engineer, was responsible for
·Planning & creating the Database and Application for Health Care Systems.
·Leading & motivating high potential project teams.
·Preparation of Test Plan -(Unit, Integration, System)
·Preparation of Test Cases
The Hospital Management System for Apollo group of Hospitals was implemented in VB6 and SQL Server 2000.It included In patient, Out patient, Pharmacy, House keeping,
Specialization on all Departments, Accounting, Billing, Operation theater, Stores, Emergency modules etc.
Contribution
As a DBA, was responsible for
· Planning the Database
· Configuring the System
· Creating the Database
· Space Management
· Application Planning & Installation
· Distribution of Database (Replication)
· Security Administration
· Database Backup & Recovery
· Monitoring & Tuning Database performance
As a Programmer, was responsible for
· Requirement gathering
· Database creation
· Application Development
· Testing
· Delivering and Installing the product
Computer Programming
Came first in college.