Balaji

acsvtg@r.postjobfree.com 248-***-****

Summary

A progressive and goal oriented project management professional with track record of building and leading high performing teams. Focus on continuous improvements to drive down costs and improve service delivery. Having over 20 years of in-depth enterprise level expertise with clustered and high availability systems architectures, relational database systems design and implementation, full life cycle applications development (SDLC) and testing support, mission critical production support, networking, operating systems, design, development, and relational database support. I was in various roles as Database Architect, Senior Oracle DBA, System Architect, System Analyst, Data Architect, Data Modeler, Project Lead and Project Management.

Education

Master’s in Business Administration

Bachelors in Computer Engineering

Bachelors in Mathematics, Physics and Chemistry

Certifications

Project Management Institute’s PMP Certified (April 2011 to April 2017)

Oracle Certified professional (OCP) DBA

Professional Experience

Allied World Assurance Company, Farmington, CT April, 2011 – Till Date

Consultant / IT Project Manager

Project: Dragon platform Revitalization Project:

Define the scope of the project in collaboration with senior management

Identify project stakeholders and engage project team to get effort estimation from various teams and determine project cost and timeline.

Built detailed work break down structure (WBS) for effective resource allocation to perform project activities in parallel.

Prepare financial forecasts and manage budgets for the execution of the project.

Created a list of prioritized risks and reviewed with sponsor and team.

Manage project dependencies, risks and issues by setting up risk log with review dates and mitigation plan.Compiled cost estimates for hardware, software, training and support.

Plan, schedule, and track project deliverables and milestones.

Manage changes recognizing time & budget impact.

Provide project updates to project steering committee and other stakeholders and seek necessary approvals for project execution.

Communicated daily by scheduling meetings with Application Owners and Infrastructure team and other stakeholders to schedule the retirement and migration of all Oracle databases to the new ODA environment.

Worked with the systems and database group to develop a recovery process that identified all applications and database in the critical path that required application and server upgrading.

Worked with Storage team to backup and deploy EMC storage devices to DR sites.

Migrated databases to new Oracle Database Appliance (ODA) environment to accommodate new version of Dragon application and more databases.

Utilized Microsoft Project to drive multiple projects, also leveraged SharePoint sites as a repository for Project artifacts such as Project Plans and other project documentation

Significant interaction with functional business users in planning and conducting analysis of business processes and problems.

Close project with appropriate review and lessons learned process.

Projects: iVos Claims Processing System Upgrade and Farmington Datacenter Move

Work with project sponsors, end users, customers, and vendors as needed, to define project scope, cost, and schedule.

Create Project Charter, Scope Statements, Stakeholder Analysis, Communication Plan, Control Plan, Risk Logs and Lessons Learned.

Lead daily status meetings with the team to monitor progress and manage changes.

Identify and mitigate project risks, prioritize deliverables, and recommend alternative solutions.

Prepare financial forecasts and manage budgets for the execution of the project.

Provide project updates to project steering committee and other stakeholders and seek necessary approvals for project execution.

Built detailed work break down structure (WBS) for effective resource allocation to perform project activities in parallel.

Executed project from initiation to Release utilized ServiceNow ver.1.0 to request resources, Open and Close Demand Task, Project Planning/Tracking, issuing change request approvals, including milestone updates and project health reporting.

Participated in Business Continuity/Disaster Recovery planning and testing of application/Data functionality.

Scheduled meetings with vendor AON and senior management on draft proposals verifying Implementation plan, risk, resource plan, time-lines and milestones.

Manage the Datacenter move of all the oracle applications along with infrastructure team.

Close project with appropriate review and lessons learned process.

The Hartford Insurance Group (HIG), Hartford, CT March, 2003 – Feb2011

As an employee, I was involved in various projects in different teams as follows.

Senior Database Administrator

Period: Since Dec 2008

Team : ATS DBA Personal Insurance

Primary DBA for:

Claim Enterprise Document Management (EDM) Project.

Adaptive / DMO metadata project

MSO web portal application

UCX common login application

Secondary DBA for:

Pega BISF

Web portal applications

PL NQ database

Pega Just in time (JIT)

QTI application

Product Registry

Senior Database Administrator

Period: June 2008 to Nov 2008

Team : ATS DBA Business Insurance

Primary DBA for:

Oracle Web Service Manager (OWSM),

Business Process Enterprise Level (BPEL),

Electronic Business (EBC) portal and registry management.

Blade logic project

Universal Description, Discovery and Integration (UDDI)

Responsibilities included:

Production DBA functions such as high availability, 24/7, replication, standby, dataguard, clusters, data warehouses, ETL, RMAN, Veritas NetBackup, tuning, application support, auditing

Database administration activities such as managing space, roles, users, space monitoring, parameter monitoring.

Performance tuning at database level, memory tuning, server level, SQL optimization tuning.

Performance monitoring using tools such as Precise i3, stats pack, grid control, AWR reports.

Archive log management.

Monitor the high availability and fail over of enterprise level databases

Disaster Recovery planning and testing

Implement backup and recovery using RMAN

Capacity planning and management

Database design

ASM Configuration

Exploring new technologies and features and applying appropriately on running databases.

Lead team in upgrading Oracle instances from version 10g/9i to 11gR2.

Manage backup jobs (hot backups, bcvs, cold backup, export/import, Datapump).

Meet with developers and business consultants in database architect & issue management.

Train team in performance monitoring and resolving issues.

Manage team of 4 Offshore DBA’s

Perform Reorg of bigger tables with BLOB’s using Data Pump

Maintained more than 100 oracle db’s of size ranging from various GB to TB that includes Production, Development, QA and Training environments

Implement in house database monitoring tools for db health check such as storage, parameters, sessions, alert log, archive log.

Maintain the Oracle 10g RAC environment and troubleshoot performance problems.

Grid Control Set up for BI and PI databases & Precise i3 tool monitoring.

Setting up alert notifications

Monitoring database performance, events

Identifying long running queries.

Identifying heavy IO objects & applications.

Identifying sql consuming high cpus/memories.

New database creation activities.

Storage planning

Setting up appropriate init parameter

SGA sizing

Applying new features of 11G / 10G

Setting up backup jobs

Setting batch jobs for stats collection.

In house monitoring tool development using unix shell

Space/storage monitoring

Alert log monitoring

Batch & Backup jobs monitoring.

Long running queries monitoring.

Technical Project Lead Mar 2003 – Jun 2008

Team: CCTS

Autosys Project: This project was a strategic initiative of CCTS to move production jobs into Autosys scheduler. I was responsible for driving this initiative. It involves concurrency of assignments; the environment was diverse as the teams under CCTS have different tools and applications. The team consists of CCA, CTI, IVR and TAS. The Autosys project needs a degree of integration among the systems in CCTS and required collaboration of team members in various degrees to accomplish tasks

Developed project requirements in collaboration with other teams that resulted in clearly defined project scopes agreed by all stakeholders.

Prepare the estimates and project cost

Created a web inventory of the production and other jobs from all the teams under CCTS

Collaborated in the installation of demo version of Autosys client on one of our windows server.

Prepared weekly status reports to keep management informed as to issues tracking and work progress resulting in significant improvements

Involved in risk assessment and estimates

Delegated the creation of proof of concept of some existing DTS jobs with Autosys.

Gave presentation of findings to upper management (incl. Assistant VP) highlighting the cost savings, total servers and work effort involved

Environment: Sun Solaris, Windows XP, SQL Server 2005/2000, DTS, SSRS and IIS

Technical Project Lead / Database Architect

Oracle Farm Project: The production and test databases were on standalone UNIX servers. In order to save the cost on server leases and sun’s HA Cluster (high availability solution), this project was initiated to move the standalone servers to Oracle Farm (Oracle Shared Environment).

Facilitated several meetings with ISD Performance and Capacity Planning team.

Gathered the performance data from ISD performance team to isolate intensive jobs that may prevent us from moving to Oracle Farm

Communicated with business customers to categorize the applications on the servers as business essential

Prepared weekly status reports to keep management informed as to issues tracking and work progress resulting in significant improvements

Lead the move of our production and test databases to Oracle Shared Environment (Oracle Farm).

Facilitated meetings with developers to determine the important batch jobs that can move to Autosys.

Documented the complete process of moving production and test databases to Oracle Shared Environment.

Technical Project Lead

Farmowners (AIS-Advanced Insurance System)

Farmowners Application is a vendor (Garvin-Allen) quoting and policy administration system, completed with rates and forms used in the HBB (Home Based Business / Specialty) business segment. This application allows the HBB agents and underwriters to accurately quote the Farmowners package policy.

Lead the overall implementation of Farmowner’s system with Interbase database.

Involved in the meetings with Business analysts and DBA’s

Lead the batch process to send the NPPS data to the teams in Hartford.

Created and automated the backup process of the Interbase database

Evaluated the whole suite of newer version applications for upgrade

Lead the upgrade process of the whole suite.

Environment: Windows XP, Delphi, Interbase db, SQL*Plus and NPPS

Senior Database Administrator / Data Architect

E Reference:

The E Reference application was developed to display EREF Fan forms on the web using .Net and Oracle db. The fan form documents were stored in Oracle database. The E Reference web application had many performance problems due to the large number of joins.

Responsible for the overall tuning of the E Reference application.

Designed and developed the EREF update job on the Unix server to constantly refresh the EREF Fan forms.

The EREF web page got faster getting Fan Forms and other documents quicker. The EREF job that I created solved the performance problems and the web site is much faster now.

Clone development and QA databases from production db

Created Standby database from production db and also used Dataguard.

Environment: Sun Solaris, Windows XP, Visual Basic, IIS, TOAD, Erwin, SQL*Plus, PL/SQL, and SQL*Loader

Contact Center Employee System (CCES):

The CCES application is the enhanced and upgraded version of Employee Information System. This application was written in C# with newly designed database.

I was the secondary DBA and was actively involved in the implementation of CCES application.

Created security roles and profiles

Tuned the performance of various stored procedures and reports.

Involved in system testing, tracked and fixed the bugs

Involved in the database conversion and migration of old EIS system to CCES Performed included comparison, movement of new objects to production. Also ran scripts to set up security, index and table moves and did validation of objects and correcting error conditions where necessary.

Environment: Sun Solaris, Windows XP, C#, Web Logic, TOAD, Erwin, SQL*Plus, PL/SQL, and SQL*Loader

Computer Telephony Integration (CTI)

I was the secondary DBA for CTI databases in various sites.

Recommended various options to minimize the maintenance of production jobs on CTI db’s.

Tune the SQL*Loader jobs that were used by CTI system

Responsible for fixing and running the failed jobs

Environment: Sun Solaris, Windows XP, TOAD, Erwin, SQL*Plus, PL/SQL, and SQL*Loader

Technical Lead DBA / Data Architect

Customer Service File (CSF)

I was responsible for the whole database setup starting from database design, data modeling (physical and logical), creation of databases, architect the conversion process, performance tuning of the queries and web application.

Lead two DBA’s and guided them in whole process of production rollout

Designed complete conversion process from Btrieve database to Oracle Database in short outage window

Gathered the Reporting requirement

Source data analysis

Designed and created the oracle database using Erwin tool

Architected the Data extraction process from Btrieve to Oracle Database

Lead the Oracle developers in writing stored procedures and triggers

Performance tuning at database level, memory tuning, server level, SQL optimization tuning.

Transform the design in terms of staging, EDW and datamart layers.

Prepare detail level report design based on crystal reports tool.

Prepare the project plan and monitor the project plan by assigning activities to DBA’s.

Review the code, mappings and reports prepared by the developers.

Review the unit testing and track the defects

Review System Integration testing and track the defects

Prepare the deployment plan and followed by production support lay out.

Used Transportable tablespaces to rapidly copy the whole database for testing

Environment: Sun Solaris, Windows 95/NT, Visual Basic, Web Logic, TOAD, Erwin, SQL*Plus, PL/SQL, Pro*C, and SQL*Loader

Technical Project Lead / Data Architect

Web-enabled Oracle Forms applications

Many of the CCTS applications were developed in Oracle Forms 4.5 and Reports 2.5.

It was migrated to Oracle forms 6.0 and Reports 6.0. The release of Oracle 9i Forms and Reports enabled us to try web enable the client server forms. I was responsible to take two applications and web enable as a proof of concept to present it to management.

Installed and configured the Oracle 9iApplication Server (9iAS) software on Solaris.

Configured Enterprise manager to work as part of the installation.

Installed Oracle Forms 9i and Reports 9i software

Web enabled two CCA applications to demonstrate the working of web enabled Oracle Forms and Reports 9i.

Environment: Sun Solaris, Windows 95/NT, Developer 9i/6.0/2000, TOAD, Erwin, SQL*Plus, PL/SQL, Pro*C, and SQL*LOADER

Project Team Lead / Database Architect / System Analyst Aug, 97 to Mar, 03 The Hartford Insurance Group (HIG), Hartford, CT

As a Consultant, involved in the following projects for Distributed Application Support (DAS) team:

Technical Project Lead for Re-engineering Champs (Auto letter creation) system into client

/server environment from character based.

Analysis, Database Design & Modeling and Development of Employee Information System.

Analysis, Database Design & Modeling and Customization of Agency Quality Management system

Customization of Employee Information System (EIS) for LVO

Development, Unit & System Testing of Cancellations system.

Attendance Recording System (ARS)

Assigned Risk System

Agent Tracking and Licensing Information System (ATLIS)

Cancellations System

Database development,Unit & system testing of Central Answering Point application (CAP)

CEMS EIS (Employee Information System)

Consumer affairs

Dialer

EFT/Credit card

Learning exchange (LNEX)

License audit

New user password reset application for Help Desk

Problem study

Property inspection

QMS (Quality Management System) for Quality Control Unit

Service tracking

Underwriter deskwork

Was responsible for the following activities:

Requirement study & analysis (interacting with users to understand system requirements),

System Design,

Lead Developers in Oracle Forms and Reports development and testing

Upgraded the above applications from Developer 2000 to Developer 6i

DBA activities

Data modeling

Creation of databases

Creation and maintenance of Oracle schema objects like tablespaces, tables, indexes, sequences and synonyms

Creation and maintenance of stored procedures and database triggers

Fine tuning of the stored procedures and queries using explain plan and Tkprof

Creation and maintenance of Oracle users, roles and profiles

Environment: Digital Alpha, VAX, Sun Solaris, Windows 95/NT, Developer 6i/2000, Erwin, SQL*Plus, PL/SQL, Pro*C, and SQL*LOADER

Senior System Analyst Aug, 95 to May, 97

P&O Containers, London, UK

As a BirlaSoft consultant and Senior Systems Analyst, I was involved in the enhancement analysis, design, specs writing, development and system testing of Finance module of Documentation and Revenue System (DRS) for P&O containers Ltd.

Was responsible for the following activities:

Enhancement analysis and design,

Development,

System testing,

Implementation,

Bug fixing and enhancements

Environment: IBM SP2, AIX, OS/400, Windows 3.1, Oracle 7.0, Forms 4.0, PL/SQL, SQL*Plus and Pro*C

System Analyst / Database Architect

BirlaSoft Ltd., Noida, New Delhi, India

I was involved in requirement analysis, database design, data modeling, specs writing, system testing and implementation of Individual Running Ledger Account (IRLA) System for Income Tax Dept of India, as a module leader (System Analyst).

Was responsible for the following activities:

System design,

System testing,

Implementation,

DBA activities

Data modeling

Creation of databases

Creation and maintenance of Oracle schema objects like tablespaces, tables, indexes, sequences and synonyms

Creation and maintenance of stored procedures and database triggers

Fine tuning of the database using explain plan

Environment: RS6000, AIX, Windows 95, Oracle 7.1, Forms 4.5, Reports 2.5, PL/SQL, SQL*Plus, and SQL*Loader

System Analyst Jan, 94 to Jul, 95

Jaya Food Industries Ltd, Hyderabad, India

As a System Analyst, I was involved in the System Study, Analysis and Design of Financial Raw Material Inventory, Production Planning & Control and Finished Goods Warehouse module.

Was responsible for the following activities:

Requirement study & analysis (interacting with users to understand system requirements),

System design,

Creation and maintenance of Oracle schema objects like tables, indexes, sequences and synonyms

Creation and maintenance of stored procedures and database triggers

Development of several complex master-detail forms

System testing and implementation

Environment: HP, HP-UX, Oracle 6.0, Forms 3.0, Pl/SQL, Pro*C, Shell Programming

System Analyst Aug, 93 to Dec, 93

Asia Pacific Investment Trust Ltd, Hyderabad, Ltd.

I was involved in reengineering of Financial Accounting Module for APITL, India as a System analyst.

Was responsible for the following activities:

Requirement study & analysis (interacting with users to understand the system),

Development of tools for conversion,

System design,

System conversion,

System testing,

Implementation,

Environment: Fujitsu Server, SCO Unix OS, Oracle 7, Oracle Forms 3.0, SQL, Pl/SQL, C-Shell Programming, Awk and Sed.

Technology and tools

Oracle 12c/11g/10g/9i/8i/7/6, Sql Server 2005/2000, ERwin, Golden Gate, Sybase, Interbase, Btrieve

Weblogic Portal, Portlets, E-Business / EAI, Service-Oriented Architecture (SOA), Web Services, Java/J2EE, MQ Series, Transaction Processing

EJB, OOD, Servlet, JSP, Weblogic, Oracle 10g iAS, WSAD, Hibernate, XML, Web Services, Parsers

ETL, SSIS, SSAS, Data Warehouse, Star/Snow Flake Schema, Data Cleansing

Unix (Sun-Solaris, HP-UX, AIX Linux (Redhat, Suse), Windows, VAX-VMS, AS/400

C, C++, .Net framework and architecture, ASP.Net, VB.Net, IIS, C#, Java Script

Rational Rose, UML, RUP, Clearcase, PVCS

User Requirement Analysis, Project Estimation, System Design and Development (using SSAD and OOAD), System Re-engineering, Configuration & Change Management and ITIL

Software methodology Waterfall, RUP, Agile, Scrum

MS Project 2003/2010, Microsoft Visio, Outlook 2010, Word, PowerPoint, Excel, Planview

Product Evaluations

Quest Central

Quest Foglight

Quest Spotlight

Compuware’s SQL Expeditor and DB Partner

BMC Patrol

Garvin-Allen Farmowner and NPPS application

Contact this candidate