Project Manager Management

Bhaskar Mylavarapu email: ab9w9p@r.postjobfree.com

***** ******** ******* ***** ** 20105

Cell: 571-***-****

Summary of Experience:

Sr. Oracle Database Administrator/Analyst having over 18 years of

professional experience in RDBMS, Database Architecture, Modeling,

Application Development, Infrastructure, Data ware housing and Project

management.

Experience in architecture IT solutions for enterprise applications, with

focus on Data and Database Architecture.

Project Manager for large IT infrastructure and application management

engagements for global clients and offshore delivery roles.

10 years of Oracle DBA experience as Senior and Lead positions on LINUX

Redhat,AIX, Solaris and Windows using Oracle 11g,10g and lower versions

managing DBA teams, large databases & Data warehouse Projects.

5 years of experience as Technical Project Manager and Sr.Project Manager

for major Industrial Applications.

5 years of experience in Software Development & Business Analyst,

Requirement study,High level & detailed design,System & Unit Testing.

Database :

24x7 Production Database support to prestigious International clients in

USA,FRANCE and India.

Successfully undertaken Oracle Database Up gradation and Migration Projects

from (10g to 11g,9i to 10g, 6 to 7 & 8i).

8 years of RMAN experience on Oracle production Databases.

Implemented Automatic backup techniques using Legato - EMC's backup

solution software.

Expertise on backup techniques Data pump & export/Import.

Installed more than 150 Oracle Installations on LINUX RHEL 6,5 Sun Solaris,

SCO Unix, Unix ware, NT servers.

Expertise in oracle 9i & 10g Real Application Cluster(RAC).Installation

and configuration of a 2 node RAC.

Expertise in Unix shell scripting for backup and handling of AUTOSYS jobs.

Worked on major databases like Postgres, Sql Server,DB2 and IBM UDB.

Performed Database Refresh from Production to QA and Development databases.

Managed Databases of large sizes of 1.6 TB.

Expertise in Oracle DBA tools OEM, DBA studio, TOAD, SQL Navigator.

Performed Transportation of tablespaces for Major Data warehousing

Databases.

knowledge of Database performance tuning and used STASPACK & AWR reports.

involved in Database Designs and Optimization techniques.

Expert knowledge on Oracle Data guard & ASM.

Production support to Oracle Financial Applications(OFSA).

Data warehouse:

Data Modeling, Relational Mappings, Conceptual Models,DFDs and ERDs using

Oracle Designer.

Worked in Enterprise Data warehousing projects for major clients like DBS

Bank Singapore & GE Medical Systems at Paris, France.

Expertise in the area of Enterprise Data Integration, Data Warehouse, Data

Quality, Data Migration.

Expertise in Informatica Data Integration product suite (ETL, Real-time &

Data Quality). Specialist in Informatica PowerCenter, Installation and

Upgrade.

Knowledge in Data mover scripts in People soft.

Project Management:

Managed experience in highly scalable integrated applications spanning

various Project life cycle right from inception till closure.

Managed turnkey and T&M Projects.

Extensively used Microsoft products like MS Project, Microsoft Visio.

Experience in managing and mentoring software professionals in a

challenging project environment.

Software Development

Design, Development, Implementation and Support of Highly Critical

Applications in the Banking sector customer, product, service and

industrial applications.

Domain exposure to Banking, Financial Services, Payroll, Inventory,

Purchase and Sales and Hospital management systems.

Programming expertise in Oracle PL/SQL, Pro*C, C and Oracle triggers,

stored procedures and functions & shell scripting.

worked on Oracle Forms, Reports and Menus.

Exposure to Service Oriented Architecture, design, development,

implementation and integration of enterprise applications.

Handled most prestigious international Clients & US Federal Projects.

Technical Skills

Analysis & Design Business Process Analysis, Requirements

Analysis, Requirements Management, System

design, Data Modeling,and Database design.

Database Oracle 11g,10g, 9i/8i 7i,&6i on Unix & Windows.

Exposure to UDB, DB2 Databases and SQL Server.

Project Project Initiation, Planning, Team Management,

Management Client Management, Risk Management, Quality

Management, T&M and Turn key Management, CMM 5

Quality practices & Requirement Study.

Programming Pro*C,PL/SQL, SQL, C,COBOL, Unix Shell

scripting, Perl

Oracle DBA Tools DBA Studio, OEM, SQL Navigator, TOAD

OS Redhat Enterprise Linux 6,

AIX4.3,Windows,Solaris, SVR 4.2 Unix,

ScoUnix,Unixware.

Data Modeling Oracle Designer 6i, Forms, Reports and

&Design Menus,ERWIN

Microsoft MS Project, Visio,SQL Server

Technologies

ERP Oracle Applications 11i

Migration Database Up-gradation from 9i,10g to 11g and

Projects from lower version to higher versions

Backup Software EMC Legato Networker & AutoSys jobs

Open Source PostgreSql & MongoDB

Databases

Source code Visual Source System

Control

Work History

US-Dept of Commerce NOAA-NESDES-NODC Data Center - Silverspring Maryland

Sr. Oracle Database Administrator (Sep

2005 to present )- 8 years

Manage and monitor Production & Development databases of

all NODC Applications.

Assist development team in database design and implementation.

Migration & upgrade

from 10g to 11g on LINUX of all applications. Configuring RMAN

and backup to EMC

Legato Software on backup server. Implementation of Database

Security features,tuning

and implementation of advanced technologies on these

databases.

Install critical security patches.

Roles & Responsibilities

Installation and periodic upgrades to the Oracle database software,Oracle

tools,Oracle Enterprise Manager,Oracle Management Server and network.

Up-gradation of Oracle 10g to 11i.

Configuring listeners and Oracle network files.

Control all migrations of Oracle schema objects

Writing backup scripts and the restoration scripts.

Implementation of RMAN backup mechanism.

Using of Data pump as well as export/Import.

Restoration and recovery of the database.

Designing of the disaster recovery,backup and recovery services.

Periodic performance analysis and instance tuning and database.

Analyze database objects.

Coalesce all the tablespaces to manage the fragmentation.

Installing STATSPACK and monitoring and tuning using STASPACK reports.

Collection of mechanisms and quarterly database growth summaries.

Fast response to production outages.

Managing trace files dump files.

Periodic application of security patches supplied by oracle Corporation.

Assessment of database security, roles, and privileges.

Enrolling users and maintaining system security.

Managing data security.

Managing and purging of archived files in the flash_recovery_area.

Installing and managing Oracle Enterprise Manager software.

Business Analyst - Data Modeler

(July 05 - SEP 05)

National City Mortgage(NCMC) - Dayton OHIO

National City Mortgage was updating the existing application. As a

result huge functional and design changes were required to incorporate. To

match and fit into New Mortgage software, the analysis,design,mapping of

data was required.

Roles & Responsibilities

Analyze and design the database design.

Meeting with Developmental teams and discuss the design changes.

High Level and detailed design documents to prepare.

Analyze the old database fields to the new.

Status update to Managers, developers and Project Managers.

Data Modeler American Girl Inc., Madison, WI

( April 05 to JUL 2005 )

Marketing Forecast Project

--

This project is to standardize and strengthen the forecasting methods

and Procedures used at American Girl. Requirement study, Analysis & Design

with all levels of client Managers and users to implement this forecast

method. Data modeling,Designer 6i, Oracle Applications 11i, Toad, SQL,

PL/SQL and strengthen the forecasting methods Software were used.

Roles & Responsibilities

Project Requirement study, High Level & Detailed design & Unit Test Cases.

Designing of Entity Diagrams, Data flow Diagrams.

Data Modeling and Database Design.

Understanding Oracle Application Order Management Module.

Prepare Test cases, Test Scenarios, Plans for all interface modules of the

entire forecasting Model.

Data Modeler - Warehouse & Business Intelligence

(Sep 04 - March 2005)

Client : DBS BANK - SINGAPORE

Project: Weekly Data Mart and DSS Dashboard

Weekly Data mart project is part of Financial Re-engineering program.

This project is to implement dashboard solution for Enterprise

Banking (EB) to provide a proof of concept of proposed solution, and

enable validation of metrics and how they are used in business. This

dashboard solution provides metrics as a summary of management

information on a weekly basis to Business Unit Controllers, Business

Unit Executives and Relationship Managers for business monitoring and

tracking purposes.

UNIX Scripts and Informatica 5.1 were extensively used to extract

the data.

Roles & Responsibilities

Unix Shell Scripts to extract data from Mainframe to Staging Area.

Shell Scripts Automate the Entire Informatica Loading.

Implementation of automation Scripts in TWS Automation Software.

Production Support for weekly Datamarts.

Meeting The Project Dead lines.

Data Mover Scripts for People Soft Applications

Data Loading Using Informatica 5.1 to extract from Staging area.

Installation and up-gradation of Informatica.

SQL queries.

Senior Oracle DBA - Oracle Financial Services Application

(Oct 03 - Aug 04)

Client : National City Corporation Bank, Columbus Ohio, US

Project : Oracle Production DBA & Oracle Financial Application - Data

warehouse

The company operates through an extensive banking network primarily in

Ohio, Indiana, Illinois, Kentucky, Michigan and Pennsylvania, and also

serves customers in selected markets nationally. Its core businesses

include commercial and retail banking, consumer finance,asset

Management, mortgage financing and servicing, and payment processing.

National City Corporation has several Applications and all most all the

latest technologies are in Use. It has over 100 Databases comprising of 46

Production and 63 Test databases.

Oracle Financial Services Application software is a Corporate accounting

Oracle Package. It has 6 Databases including Warehouse databases. Daily

refresh of the databases, transportation of tablespaces and Month end

Roll are the primary activities on the Databases.

Roles & Responsibilities

24x7 Production support to 46 Production Databases.

Database Health Check

Database Design & Creation

Managing Backups & Recovery,Security,Users, space Management

Database Performance Tuning

Data Loading from External Sources using Sql Loader

Transportation of Tablespaces & Table Partition

Creation Database Links

Suggestions to senior Management about Database Health

Capacity Planning

Month end Roll of Data warehousing Data of OFSA.

Installation of patches.

Tnsnames.ora Rollout.

Security using user profile limitations.

Senior Oracle DBA & Project Manager

(Dec 02 - Oct03)

Project : Export & Credit Guarantee Corporation(ECGC) - India

Client: Support and Development of Credit Guarantee Applications.

ECGC is insurer to the Exporter's Goods. The Web based System is

integrated with 12 applications has a 3 tier Architecture. Developed in ASP

for the front end and Crystal Reports were used as reporting tools. The web

Application developed in .net where the Exporters can query about the

status of their declarations, Policies etc. The System was working on

Oracle 9i RAC on Windows environment integrates with Microsoft Cluster

services .The total database size is 120 GB.Sql Server,Oracle 9i,PL/SQL &

Toad were extensively used.

Roles & Responsibilities

Project Management & Production DBA.

Implementation of 9i RAC.

Maintain the 70GB of Database for 300 users.

Scheduling & Monitoring Backups

System performance Tuning

Installation of patches.

Monitor Backup, recovery, up gradation.

The Standby Backup server is also configured.

Implementation of Standby Sever was also done using Data Guard

Understand Customer requirements.

Team Management.

Client Interaction.

Lead Oracle DBA & Architect - Data warehousing Project

(Sep 02 -Dec02)

Client: GE Medical Systems - PARIS, FRANCE

GE Medical System, BUC FRANCE has 8 servers located in UK. One

server was in Europe. To ensure the continuous availability of Database to

Users.

Roles & Responsibilities

Monitor Nightly & weekend Loads, Transfer Jobs from Mainframes and has to

ensure the proper data loading into the Data Warehousing Databases.

24/7 production support.

Data Modeling for GE's Data warehousing Database.

Batch Loading of Data from databases to Warehouse databases.

Monitor and maintain 93 Databases.(45 Production and 48 Develop DB)

Make sure the continuous availability of Database to huge number of users

Daily monitoring of Databases using Oracle Enterprise Manager(OEM).

Production moves, Production updates and assisting the development team are

also the major responsibilities of the DBA.

Regular refresh.

Scheduling & Monitoring Backups.

Manage Teams.

Senior Oracle Database Administrator - Interactive Trading System - Web

Application

Client: Bombay Stock Exchange - Online Trading

(May 02 - AUG 02)

Web based Interactive Trading application system running on Oracle

8i.

Roles & Responsibilities

Critical support & Monitor the availability of Database to users during the

trading hours.

Daily monitoring of Databases

Enhancing the existing Trading system by writing PL/SQL procedures.

Backups and restoration.

Team Lead - Post Denmark, Copenhagen Denmark

(AUG 01 - April 02)

Project : Bar-code Software enhancements & Implementation

Post Denmark is a Central control of the Post office at Denmark,

headquarters at Copenhagen, Denmark.The Software Systems at Post Denmark

have 28 Modules. The have intended to introduce a new bar-code of 35

Alphanumeric field which required to change the entire software at

different levels. The requirement in the project is to enhance and change

the existing system to work with new bar code. After all the

enhancements were done, the total software has to be converted to new

versions of Oracle.

Roles & Responsibilities

Project planning & Scheduling

Requirement gathering

Design the changes using Oracle Forms.

Generation and development of the Reports.

Development of Forms to reflect the functionality.

Testing and implementing in production

Incorporate the new changes in the existing System

Lead Oracle Database Administrator & Technical Adviser

(Jan 01 - July 01)

Project : Central Hotel Reservation System

Client : TAJ Mahal Hotel (5 Star) Bombay, India

Team : 3

Manage the 50 GB of Taj Hotel online Production reservation System

Oracle Database has a network of world databases.

Roles & Responsibilities

24x7 Maintenance of database.

Manage all DBA's.

Database Tuning, Backup Strategy, Recovery, Network Management.

Technical Adviser to Taj Hotel Vice President & Senior Management.

Taj Hotel Job Interview Technical Board Panel member.

Developed Call Management System using D2k

Oracle Databases on IBM AIX RS 6000

Sr.Project Manager - General Motors, Thailand

(AUG 00 - JAN 01)

Project : Payroll Outsourcing

Team : 8

Monthly payroll generation of raw data sent in excel files by

organizing,cleaning and error reporting as per the functional requirements

of the Client. The organized data, then loaded into temporary Oracle table

using SQL Loader by applying required Control checks. The processed data

is loaded into the actual Oracle Database. Payroll report generation will

take place with this data. All the payroll related reports were sent to the

client. Pl/Sql,pro*C and Oracle forms & reports were extensively used.

Enhancements were also incorporated.

Roles & Responsibilities

Requirement Gathering & SDLC process.

Collecting Functional Requirement of Payroll System

Customer Communication

Manage the Payroll process successfully.

Work with team members to validate the sent data.

Confirm the raw data sent was cleaned.

Check whether all the functionalities specified were incorporated.

Confirm the generation of Payroll to GM.

Deliver the printed pay slips to GM.

Configuration Management,Team Management,Project Estimation,Delivery

Management.

Technical Project Manager

(Jan 1999 - July 2000)

Project : Out Sourcing of IT requirements

Client : Tata Special Steel Limited, Bombay, India

Team : 36

Tata Special Steel, a quality wire company outsourced all of it's IT

requirements. The activities include,Software Development,support&

maintenance of enterprise Industrial applications. The goal is to

understand the needs of the customer and suggesting them as per the needs.

To provide the GAP Analysis. The deliverable items include Requirement

study, Design,System Study,Technical,functional & User Documentation.

Roles & Responsibilities

Project Management Methodologies & SDLC life cycle.

Online Production Support Management

Requirement Gathering

Client Management

Team Building

Risk Management

Time Management

Quality Planning

Delivery Management

Manage Development Team of 36 engineers

Project Scheduling.

Other Major Projects Handled from Nov 1992 to Aug 1997)

Conversion & Migration Projects from Oracle 7 to 8i.

Banking application Development & support Projects

Integrated Financial Accounting Systems

Payroll System.

Hospital& Health Management Systems.

Sales,Inventory,Financial Systems.

Education

Masters Degree in Mathematics with Computer Science, University of Delhi,

India, 1990

Honours Degree in Mathematics from University of Delhi, Delhi, 1988.

Post Graduate Diploma in Computer Applications from Regional Computer

Center, Calcutta, India - 1992.

Employment History

1992 - 1997 - Systems Engineer at DDE ORG systems.

1997 - 2005 - Systems Engineering Specialist at Tata Infotech

Limited.

2005 - 2012 - Sr.Project Manager at Megasoft,Trianz &

Blueally.

2012 - Present - Database Administrator III at Ace Info Solutions.

References - Available Upon Request

Contact this candidate