Project Manager Management

RAMA R. GUDHE

**** ******* ***** **** 614-***-**** (Cell)

Dublin OH 43016 email: *****@*********.***

SUMMARY

• Around twenty three plus years of experience in Information Technology and other industries.

Out of which 6 months of experience as an Assistant CIO/VP of Infrastructure & Operations, two plus years

of experience as an Technology Director of Data Center Operations, two years of experience as a Director of

Database Services, five plus years of experience as IT Manager/Production DBA Manager, eight plus years

of experience as a Project Manager, fifteen years of experience in leading/coordinating enterprise projects,

seven years of experience as a Database Administrator (Prod and Application) and UNIX administration, ten

plus years of experience as Instructor/Adjunct Faculty for Oracle database programming, administration,

data modeling, project management, systems analysis and design, and other products and Nine and half

years of experience in analysis, design and development of GUI based client/server and web based

applications and programming.

• Project Management Professional (PMP) Certification.

• Extensive project management experience including managing large, complex, high risk projects and with

providing technology direction and architecture guidance for enterprise-wide solutions.

• Solid understanding of SDLC, change control & problem management processes and systems and

applications management including systems/application design in java/J2EE.

• Managed and deployed several Oracle based applications for the organization.

• Experience in Business Intelligence tools and supported Business Intelligence applications for the enterprise

and specialized in various database and data warehousing technologies.

• Experience with budgetary forecasting, risk and vulnerability management, disaster recovery planning.

• Experience in analyzing emerging technologies and translate implications of the new technology into an

effective IT vision and strategy.

• Experience in applications development, infrastructure, end user support, and project management,

managing vendor resources and vendor relationships and developing internal and external applications.

• Familiar with various object-oriented technologies frameworks (such as STRUTS, SPRING, Hibernate etc.).

• Ability to multi-task, currently working on/supporting various projects and possess good communication skills,

excellent rapport with employees.

• Has in-depth understanding of operating problems and their acceptable solutions from a business perspective

and is capable of implementing them and multiple types of systems and applications architecture, running on

multiple hardware and software platforms including mainframe technologies.

• Resourceful team player highly organized, professional, motivated and loyal.

SKILLS

Hardware HP1000, HP9000, HP K Series, Sun Solaris, ND 500, DEC VAX, CRAY/YMP, DEC ALPHA,

TANDEM R2, R4 and PUMA, IBM-PC, MACINTOSH, Sun and Appollo workstations, IBM

AIX and IBM Mainframe

Operating Unix, VMS, Sintran, Sun OS, MS-Windows 3.1, MS-Dos, Windows 95/98, Windows

Systems NT/2000/XP/7, Novell and Linux

Languages C/C++, PASCAL, FORTRAN, SQL, Basic, PL/SQL, JAVA and .Net

Reporting tools Crystal reports, Discoverer and Cognos

Databases Oracle 6.x, 7.x, 8.x, 8.x, 10.x, 11.x, dBASE III, SyBase, SQL Server, Mainframe DB2, IMS

and DB2 LUV

DB Tuning tools SQLAB, Precise SQL, TOAD, GRID Control

Database tools Platinum Technologies DB Vision, Platinum DBA products, Oracle Enterprise Manager,

Procedure Builder, Platinum SQL Station, Data Shark and EDA*SQL (Gateway product for

VSAM Files on Mainframe and Oracle database)

Version control PCMS Dimensions and PVCS

Testing tools Win runner and Load Runner

Middleware Web Sphere, Oracle Application Server, Control-M, MQ-Series, Adobe, EMC Expressions

ECM File Net

ETL INFORMATICA

ESB TIBCO, IBM BPM

Virtualization VM Ware, IBM Power 7 Series

Storage IBM XIV, Net APP, VNX/SVC

Modeling tools ERWIN, Power Designer, Designer 2000, ER Studio, Model Mart (Platinum Repository)

Software MS-Word, MS-Excel, MS-PowerPoint, MS-Project, Word Perfect, Corel Suite, Rational

Rose, IBM Portal and TIM/TAM/WEB SEAL

EDUCATION

Ph.D. in Computational Fluid and Solid Mechanics – University of Pittsburgh, Pittsburgh, PA, USA (March

1993)

Diploma in Super Computing – University of Pittsburgh, Pittsburgh, PA, USA (March 1993).

M.S. Applied Mathematics and Computer Science– University of Pittsburgh, Pittsburgh, PA, USA (March

1993).

M.S. Computer Aided Design Engineering – Indian Institute of Technology, Kharagpur, India (December,

1986).

B.S. Mechanical Engineering – Andhra University College of Engineering, Visakhapatnam, India (June,

1985).

CERTIFICATION

Project Management Professional (PMP)

ITIL V3 Foundation

EXPERIENCE

Assistant Deputy Director (Asst. CIO/VP) April, 13 – Present

Infrastructure & Operations

Ohio Department of Job & Family Services (ODJFS)

State of Ohio, Columbus, Ohio

Works closely with peers in other departments (Enterprise Architecture, Development) and create road

maps and implementing upcoming technologies and ensure to meet organization goals and also set up standards

and guidelines using Technology Investment Board (TIB). Performs infrastructure capacity analysis and plan

infrastructure to support for future projects/initiatives and also invest to new technologies. Implemented

virtualization and consolidated lots of older physical hardware and reduced operational costs significantly for

hardware as well as software maintenance costs and experience in negotiating contracts with hardware and

software vendors. Have around 200 plus resources that support Infrastructure & Operations.

Responsible for managing:

• Core Infrastructure Services (enterprise network, Telephony, VOIP, enterprise monitoring).

• Application Operations (Mainframe, Custom of the Shelf products, Configuration and Change

Management and Trouble ticket applications).

• End User Support (enterprise desk top support, desk top engineering).

• Production Control (help desk, production scheduling and control, information security) and

• Data Center Operations (enterprise storage, data base administration, Middle ware support and Sun, AIX,

Linux support), Windows and VMware administration). Have around 200 resources that support

Infrastructure & Operations.

• Enterprise IBM Business Process Management (Process Center, Process Server, ODAM, BAM),

Enterprise Content Management and enterprise Service Oriented Architecture.

• Infrastructure & operations budget which includes hardware, software procurement and

maintenance and other operational costs.

Director/Section Chief, Data Center Operations May 2011 – Apr 2013

Ohio Department of Job & Family Services (ODJFS)

State of Ohio, Columbus, Ohio

Works closely with business units, development teams, project management office and release

management to deploy and support internally developed applications. Provide 24X7 production support and lead

team in the diagnosis and resolution of systems and software related operational problems. Develop, maintain,

and publish metrics of problem source, resolution, frequency, and closure rates. Identify root cause, and utilize

problem management processes to eliminate further occurrences and eliminate single points of failure. Participate

in IT strategy and planning activities, bringing current knowledge and future vision of infrastructure technology,

systems and best practices as related to business requirements. Provide leadership in IT strategy, operations,

cost-optimization, innovation, and efficiency improvement, driving new technologies, processes and procedures.

Works with CIO’s office and enterprise architecture team to create vision and technology road map for

organization. Have extensive knowledge in data analysis and familiar with ETL tools such as INFORMATICA and

ensuring adherence to enterprise information technology standards and guidelines. Managed: State employees

and several contractors (50 Resources).

Responsible for managing:

• Mainframe DB2, IMS database on Mainframe, UDB (enterprise data warehouse and data marts),

ORACLE, SQL Server databases at an enterprise level, which includes all environments

(development, test, prod etc.).

• Storage, backup and recovery, (IBM P5, P7 and blade servers), SOLARIS, Linux administration, middle

ware such as Web sphere, Oracle application server, and other software such as INFOMATICA,

COGNOS server administration, Remedy Administration, Adobe, EMC expressions, Control-M, File net,

IBM MQ series, TIBCO ESB, Enterprise web Enterprise services and Windows environment physical as

well as VMware virtual environments (production and non-production).

• Enterprise infrastructure architecture, enterprise storage architecture and database/data architecture.

Works with project management office, development and testing team to support several internal and

COTS based applications. Works with several program (departments) areas to support several

information technology projects.

• Consolidation of IBM hardware from physical (500 plus servers) to power 7 series (virtual), database

consolidation and windows consolidation to VM ware (800 plus physical servers to Virtual).

• Infrastructure and application software upgrades and maintain software currency.

• Enterprise business intelligence applications which uses Oracle, DB2 as database and COGNOS as BI

tool.

Data & Information Architecture Manager/Production DBA Manager Jan 2008 – Apr 2011

Ohio Department of Job & Family Services (ODJFS)

State of Ohio, Columbus, Ohio

Responsible for managing:

• Mainframe DB2, UDB, ORACLE and SQL Server databases at an enterprise level, which includes all

environments (dev, test, prod etc.) and IMS database on Mainframe.

• Application database design (data modeling and master data management). Created

standards/guidelines for various database technologies and also created Database Architecture Review

Process (DARP) for the enterprise to review all the database changes before going to production.

• Upgrades, backup/recovery, and support various development projects and production support.

Information Technology Manager June 2006 – Dec 2007

Ohio Department of Job & Family Services (ODJFS)

State of Ohio, Columbus, Ohio

Responsible for managing:

• State of Ohio Job Match Application, known as Sharing Career Opportunities and Training Information

(SCOTI), Business Intelligence, Ohio Means Jobs (OMJ) and several web based applications using Java

(J2EE Environment).

• Requirements management, architecture, design which includes database application design and

reporting application. Responsible for maintaining, coordinating the setup/configuration of various

environments for the application.

• Providing application systems delivery across multiple technology platforms. Responsibilities include

understanding and planning to meet the business needs of the organization, business area groups, or

divisions; and meeting those business needs with high quality, timeliness, and cost justified solutions.

Followed Waterfall and Agile development disciplines for applications development. Managed: State

employees and several contractors (45 Resources).

Information Technology Consultant 2 / Sr. Project Manager Feb 2002 – Jun 2006

Ohio Department of Job & Family Services (ODJFS)

State of Ohio, Columbus, Ohio

Acted as a client partner liaison between MIS and the customer. Worked with co-workers (Managers) to

develop the IT project portfolio and worked with the customer to prioritize the projects. Worked with Deputy

Director Office (DDO) to come up with the System Development Life Cycle (SDLC) for the MIS Projects. Mentored

co-workers in the database technology area. Managed various project for the section. Organized Project

Management training classes for the section. Involved in CMM Level 2 activities for the section and also was

project lead for Project Management and Project Tracking and Oversight KPA’s

Responsible for managing:

• Projects in the Medical System’s Section and also project manager for some of the sections projects.

Reviews all the project plans for the entire section and provided project status reports to the customer.

• The migration of all the sections Oracle 8i databases to Oracle 9i.

• DB2 database Schema for Buy in Application and Athena application. Also mentored co-workers in the

database technology area. Managed various project for the section. Organized Project Management

training classes for the section. Involved in CMM Level 2 activities for the section and also was project

lead for Project Management and Project Tracking and Oversight KPA’s

Adjunct Faculty (part-time) Mar 2000 - Present

Franklin University, Columbus, Ohio

Involved in teaching Database/Systems Analysis & Design courses at under graduate and graduate level

and also assist in developing on-line database courses, MBA MIS program and database course for Master’s

Program in Computer Science.

Commerical Network, Inc (Independent Contractor) Dec 1999 – Feb 2002

Client: ODJFS, State of Ohio

Worked as a:

• DBA/Sr. Oracle Analyst (Oracle 7.3.4 and Oracle 8.1.6 and Erwin Data Modeling tool) for the Medicaid

Systems, which includes maintaining the development and acceptance test databases and assist in the

analysis and design of the applications (Such as Encounter data, Drug Utilization Review, Long Term

Care, Utilization Review System and Children with Special Health Care Needs), which includes

requirement gathering (Data Modeling and PL/SQL Programming) and also assist in writing database

standards and model mart standards and migrating schema’s to development, testing and production

databases.

• Involved in tuning of database, SQL queries for various Medicaid applications.

• Configured EDA*SQL, Oracle transparent gateway product to access VSAM Mainframe files from Oracle

database, by creating database views through the gateway. Worked on building the Oracle 8i client and

Delphi BDE 5.1.1 NAL object for ODJFS and assisted in setting up testing environment for MSAD

Client/Server applications for Oracle 8i and BDE 5.1.1 and testing few applications. Worked on

mainframe IMS based applications.

Director (Database Services) Oct 2000 – Jan 2002

Mentorgen, Columbus, OH

Responsible for maintaining the in house databases and designing the database schema being used for

developing Operations Support System by Mentorgen (OSSM) product. Also managed and worked on various

out sourced database projects for clients in Columbus and Virginia.

Instructor (part-time) May 1999 – Dec 2004

Wilber Force University at Columbus State Community College Campus, Columbus, Ohio

Taught the following courses for under-graduate level.

Introduction to Systems Analysis and Design Course,

Database Programming Course.

Networking and Data Communications.

Sr. DBA (part-time Consultant) Jan 2001 – Aug 2001

Client: LeadScope Inc., Columbus, Ohio

• Created and supported development, testing and Production database on Sun Solaris Server (Oracle 8I)

• The database size is around 100GB data with many large objects containing information to support

Pharmaceutical research. The application provides sophisticated data visualizations and tools for

interactively exploring structures by properties to find correlation between biological activity and structural

features. The front-end application is developed in Java

• Involved in space management, database tuning and managing user permissions

• Installed Oracle Server InterMedia for context based searching in tables with Large Object storage data

types, created context indexes and wrote queries for context based searching

• Automated Database startup and Context Server startup at the Operating system startup in Solaris using

shell scripts

• Automated Context Server startup in NT by making Context Server as a service which starts up

automatically at the Operating system startup

• Created data model for the application using Erwin

• Involved in Capacity Planning and Implementing Oracle database on RAID based Architecture

• Designed the Backup and Recovery strategies and documented the process for Customer

• Mentored developers in the team in understanding the database concepts

• Supported Data warehouse and data marts.

Sr. Oracle Instructor (Part-time) Sept 1996 – Mar 2001

Prosoft, Inc, Columbus, Ohio

As an Instructor at Prosoft, I taught

• Introduction to Oracle, PL/SQL Programming

• Data Modeling

• Oracle 8 for developers

• Database Administration for week end training and corporate clients.

In addition to teaching courses, I am involved in maintaining and installing the Oracle databases and other Oracle

related products on Windows NT server and Sun Solaris server for all the centers. Developed and updated

class material for the above mentioned courses.

Lead Database Administrator (MTS) Oct 1998 – Nov 1999

Lucent Technologies, Columbus OH

Responsible for all the Oracle Databases and Database Architecture in the Network Surveillance Unit for the

product Network Fault Management (NFM) 6.0 to 6.3, 7.0 and NFM 2000 releases. Some of the task performed

involves:

• Mentoring other Database administrators

• Developed database standards and Enforced database standards across the NFM.

• Upgrading the Oracle database from 6.0 to 7.3.3.5 version for the NFM product. Wrote shell scripts to

automate the upgrade process.

• Supported the NFM 4.2 to NFM 6.2 upgrade for Oracle database related issues and also wrote scripts to

perform the Oracle database migration.

• Provided customer support for Oracle related issues for Domestic and International customers.

• Supported the Oracle databases and tuning of application for the developers working in the NFM product

development.

• Worked on tuning the Oracle database as well as the application for NSPMP release 6.2

• Provided support for Oracle Replication in the NFM product.

• Wrote scripts for monitoring the Oracle database, which is used in the NFM product.

• Involved in the requirements for Oracle database architecture for the NFM 7.0 release.

• Involved in determining the sizing and Oracle parameters for Oracle database on various platforms.

• Assisted developers in modifying the Oracle database schema for the NFM product.

• Involved in customizing NFM product Oracle database for the AT&T customer.

• Working on Topology Database for the Inter Domain Management System for Data and IP networks.

• Involved in the requirements for the Database related parts for the NFM 2000 product.

• Tuned Bell South NSPMP Oracle Database for better performance.

• Supported data warehouse.

Sr. Database Administrator / Team Lead Jun 1995 – Sept 1998

QWEST Communications, Dublin, Ohio

As a member of Database Administrator Team and team Lead in the Information Systems Department, we

are responsible for maintaining the development, product assurance and production instances of Oracle

database. My responsibilities include

• Creating new instances including copying instances from one server to another server.

• Perform space management (object and tablespaces).

• Migrated applications to testing environment and production instances.

• Monitor production instances.

• Mentoring New Database administrators

• Copying production databases to development and PA.

• Assist Developers in tuning SQL queries.

• Upgrade existing or install Oralce Products.

• Involved in recovering databases as needed.

• Creating user security in production databases.

• Creating snapshots and database links.

• Export/import of schema or data from one database to other.

• Provide 7x24 support to production databases (when On-call).

• Developed scripts to go against the Oracle data dictionary, that are used by DBA’s in our team for trouble

shooting.

• Taught in-house Oracle classes for developers.

• Trained all developers in using SQLAB tuning tool.

• Assisted in designing and supporting Data Warehouse applications at QWEST as needed.

• Assisted in tuning PeopleSoft Financial application SQL queries and supported the PeopleSoft

development and product assurance databases.

• Supported Frame Relay and Remote Control Web Applications in addition to reviewing their Schema.

• Supported Peoplesoft as development and production DBA.

• Dataware housing DBA

In addition to the above responsibilities, designed, developed database programs in PL/SQL and PRO*C for

BCASPER (Business Customer Accounting Profile with Enhanced Reporting) and CCASPER (Consumer

Customer Accounting Profile with Enhanced Reporting) and also involved in gathering user/business

requirements for the above mentioned applications. Wrote Unit test plans for testing the above two applications

and participated in testing the customer service applications. For GBUS (Generic Bulk Upload System) application

I was involved in writing Common Stored Packages enforcing business rules. Developed conceptual and physical

data model for the BCASPER and CCASPER applications using Power Designer and later ERWIN data modeling

tool.

Member of database review board, which includes reviewing all schema changes that are being done to the

production/PA/development environment. Member of database standards committee, documented the

standards for PL/SQL programming and Oracle8. Reviewed developers PL/SQL programs and enforced

standards. Also developed in-house training material for Introduction to Oracle, PL/SQL and Oracle8 for

application developers.

Application Engineer Jan 1995 – Jun 1995

CDI Computer Services Inc, Detroit, MI

Involved in the maintenance and testing of PDGS, a Computer aided design package for Ford Motor

Company which was developed using C/C++ and Fortran 77.

Application Analyst / Programmer Jan 1993 – Dec 1994

Viscoustech Inc, Pittsburgh, PA

• Worked on rapid prototyping of Inventory Control System using Powerbuilder as the front end and Oracle

as the backend. Also involved in the development of the production version of the same system and wrote

stored procedures for this application. This application keeps track of the inventory and purchase orders. It

also provides early warning of the availability of the inventory. Involved in training and imparting system

knowledge to the end users.

• Involved in the design and development of a Human Resource Management utility. This utility was

developed using SQL*Forms 3.0 and Oracle as the backend. Involved in gathering user requirements,

systems analyzing and designing schema using normalization techniques. Also worked on entity relationship

diagrams. Developed technical and user manuals.

• Worked on the design of a Consultant Management System and implemented it using SQL*FORMS 3.0

and Oracle 6.0 Database as the back end. Provided utilities for matching job requirements with the available

skills along with a full set of utility reports.

• Developed a software program using C and Fortran for measuring the material properties of non-

Newtonian Fluids and Visco-elastic materials.

• Converted the hand drafted facilities drawings to AUTOCAD 12.0 for GM-Lordstown plant.

• Converted the material specifications in American Standards to corresponding British Standards for the

SR-100 Mining equipment for CSE Corporation.

• Performed Finite Element Analysis and designed a Torsional Rheometer.

Programmer / System Administrator May 1989 – Aug 1989

University Computing and Information Systems May 1990 – Aug 1990

Pittsburgh, PA May 1991 – Aug 1991

Worked on Online Registration System using C as the front end and DBASE III PLUS as the back end. This

system is used to maintain details about available courses, class rooms and teachers. Reduced schedule conflicts

by providing advance warnings and immediate feedback.

• Involved in developing Student Information utility using DBASE III PLUS. This utility maintains all student

records in the university and has the capability to input and maintain student data.

• Wrote handouts and help sheets explaining how to use the computer systems and the software which

were available in the University computing labs.

• Handled variety of questions from users related to various programming languages (Fortran, C, Basic and

Pascal), various operating systems (Vax/Vms, HP-UX, Macintosh, MS-DOS), numerous software

packages such as word perfect, macsyma, mathcad, mathematica, ansys and cricket graph

System Manager/Administrator Jan 1986 – Aug 1986

Indian Institute of Technology, Kharagpur, India

• Supervised mechanical engineering computer labs. Responsibilities included maintenance of HP 1000

and HP 9000 computer systems and personal computers.

• Trained students in Pascal, C and in-house CAD packages

Software Consultant Jan 1987 – Jul 1988

Engineers India Limited, New Delhi, India

Involved in developing the software applications such as in-house computer aided design packages and

modifying existing in-house software. I was involved in

• Gathering user requirements and writing design documents

• Writing Fortran code for Finite Element Analysis (FEA) design packages

• Training consultants to use various computer aided design packages

• Writing user documentation and training documentation

• Prepare maintenance plans for FEA packages

MEMBERSHIPS

Member of Ohio Oracle Users Group (OOUG)

International Oracle Users Group (IOUG)

Project Management Institute (PMI)

HONORS

Merit scholarship in Under graduation (1981-1985)

Awarded twice for excellence in QWEST (1997)

PUBLICATIONS

15 publications in various journals and conference proceedings

REFERENCES

Furnished upon request.

Contact this candidate