Manager Management

Ramesh Kalyandrug

**********@*****.***

Professional Profile

A technologist with over 25 years of experience in Software Industry. Nearly 15 years’ experience

is gained in North America and One year in UK

10+ years of experience in Involved in understanding of the SDLC with proficiency in mapping

requirements resource ramp up, resource management, scope management, stake holder

management, cost control, schedule development, managing on time and quality deliverables,

technical documentation and leading offshore / onsite model projects.

An effective communicator, inclusive leader and a clear thinker

Exceptional and proven analytical skills. Solid problem solving, technical, inclusive team leading,

training, coaching and guiding skills.

TECHNICAL SKILLS

RDBMS Oracle 7.3.4/8/8i/9i/10g/11g/12c Oracle RAC

9i/10g/11g/12c.

Operating Systems Redhat LINUX, HP-UNIX, Sun Solaris, Windows.

Oracle DB Tools Toad, Export, Import, Data pump, SQL developer,

Datagurad,AWR,ADDM,RMAN

Other Tools MS project, VISIO, TFS,VSS, Power point

EDUCATION

B.Sc. in Mathematics, Physics and Statistics Govt College AP

Post Graduate Diploma in Computer Applications Brilliant Tutorial Bangalore KA.

Management and Technical Details

Management Expertise

• Managing entire software development lifecycle, Risk Analysis, Write proposals in response to

RFP, Schedule, Deliverables, Performance Metrics.

• Increase communication among management and staff regarding issues that affect the efficiency

of the organization

• Establish time lines and target completion dates.

• Mentored and reviewed development plan for new and the junior DBAs. Recommended Training

needed as per the planning.

• Knowledge of industry trends and developments to improve service to our clients.

• Identified system deficiencies and implements effective solutions.

• Creates and executes development plans and revises as appropriate to meet changing needs

and requirements.

• Keeps manager well informed of status of development effort and serves as liaison between

development staff and project managers.

• Communicates and enforces coding standards

• Manages technical resources within budget and project schedule.

• Consistently delivers high-quality services to our clients.

• Facilitates team and client meetings effectively.

• Delivers engaging, informative, well-organized presentations.

• Resolves and/or escalates issues in a timely fashion.

• Inspires coworkers to attain goals and pursue excellence.

• Identifies opportunities for improvement and makes constructive suggestions for change.

• Conducts effective performance evaluations and mentors developers and senior developers

through formal and informal channels.

• Seeks and participates in personal development opportunities

• Produced Weekly/ and Monthly reports various implementation to the higher management

• Member in decision making team for developing the new products in the DIALPAD

• Technical risk assessments: Implemented disaster recovery for the production servers

• Worked closely with across project manages in preparing RFP.

• Manage, prioritize, and direct database and system administrators in line with established

priorities

• Develop database architecture, strategy and priorities, in line with IT strategic plan

• Perform administrative duties including weekly meetings, status reports, support coverage

schedules, contributing to operational and provide status reports

• Process definition/optimization: define, test, tune, code review, standards, operations/release

management

• Maintained scheduled tasks. Monitored individual tasks and to completer TASKS in time.

• Buildup communication between onsite and offshore teams.

• Communicates effectively with clients to identify needs and evaluate alternative technical

solutions

• Continually seeks opportunities to increase customer satisfaction and deepen client relationships.

• Builds a knowledge base of each client's business, systems and objectives

• According to SLA, we are following data retention policies for each client.

• Co-ordinate with business leaders and project manager to ensure that the solutions are

complying with business strategy and are in accordance with the IT strategic plans.

• Managing various projects by preparing detail specification documentation. Defined processes

and team with end-users to determine requirements.

• Improve team efficiency with the definition of a business and data analysis practice including

standardize processes, reusable templates

• Drive Oracle 12c Migration project.

Business Expertise

• Accomplished project plan for moving data-center from one location to another location for

reducing the data-center cost.

• Compressed data-center: Was instrumental in reduced rental costs for the data-center.

• Comparative analysis of quotes for purchasing the new systems from different vendors done

• Budget plan for my group like training and incentives

• Did comparative study for developing billing system in-house that saved cost on out sourcing

• Purged old data and free up space at file system level, was instrumental in reducing costs by

avoiding purchase of new disks for the production systems

• Instrumental in reducing downtime and data loss was responsible for Implementation of standby

database for production. This resulted in direct financial impact at the time of disaster.

• Instrumental in reducing downtime and data loss was responsible for Implementation of standby

database for production. This resulted in direct financial impact at the time of disaster.

Technical Experience

• Oracle Database Administration, HP UNIX Administration, Oracle apps DBA experience

with specialization in ERP, Clinical Data Management System, Management Information

System, telecom inventory system (Cramer), Fare Collection

• Designed and developed a clinical database management system

• Expertise in Layout, installation and tuning of databases according to the application

requirements

• Supported 24/7 to Production databases

• Experience with Oracle 7.3.4,8,8i,9i,10g,11g and 12C on Unix, Linux operating systems

• Implemented ASM

• Experience in installation, configuration, tuning and troubleshooting.

• Experience with RMAN, Oracle Enterprise Manager (OEM), OEM Grid control,

Installation and Configuration of Oracle 10G, 11g and 12c Real Application Clusters

(RAC) and Oracle Data Guard.

• Implementation of High Availability solutions with Oracle 10g/11g /12C RAC, Physical

(Data Guard).

• Experience in Installation, configuration of Oracle RAC 9i/10g/11g on Linux

• Extensive DBA experience in supporting multiple production instances of ORACLE

database.

• Well versed with Database Administration, Cloning of Database, Backup and Recovery

strategy using RMAN and User Managed.

• Experience in using data pump import/export utility of ORACLE.

• Experience in database migration by designing and implementing database logical and

physical storage structures.

• Experience in optimizing database access and allocates/re-allocates database

resources for optimum configuration, database performance and cost.

• Experience in database security strategies by creating database Implemented &

monitored daily, weekly and monthly batch jobs in database.

• Experience in backup/restore, disaster recovery.

• Implemented BCV

• Upgrading and Migrating Databases from lower versions to higher versions.

• Experienced in Planning, Installation, Physical and Logical Database Design, Backup and

Recovery, Cloning, Refreshing test and development databases, Monitoring,

Troubleshooting & Tuning

• Experience in analyzing database & rebuilding indexes to improve database

performance.

• Performance Monitoring and Tuning of Database, Application, System Global Area, I/O,

Rollback segments using self-developed scripts, Toad, Explain Plan, TkprofUtilities,

statspack, AWR

• Extensive working experience of AD Utilities / AD Administration and Possess Knowledge

of Oracle HTTP Server, OC4J and Web cache. Generate Applications Files Tasks and

Compile/Reload Database Entities Tasks (Compile/Reload Database Entities, Compile

APPS Schema etc.)

• Worked extensively on Patching/Cloning/Refreshes (11i/R12) of Oracle Applications and

troubleshooting the issues with forms, Concurrent Manager

• Worked for the companies like SmithKline Beecham, Lucent Technologies,

Schlage(Division of Ingersoll-Rand), Yahoo.com, LogicaCMG, GAP and ACS Xerox,

ACTIVITIES AT CLIENTS LOCATION

CIG, CA Jul 2013 Present

CIG Capital Insurance Group is 115 years old Insurance company serving 7 states in the West

Coast. Insurance Business includes Auto, Home & Condo, Renter, Building, Commercial and

Agriculture.

Projects:

Major Achievements:

• Managing multiple DBAs with hands on involvement.

• Worked as the Lead DBA mentoring other DBAs.

• Leading/architecting the migration of multiple Large scale database to Oracle 12c RAC

Responsibilities:

• Manage multiple projects with diverse scope and medium size.

• Track project Milestones and deliverables.

• Effectively communicate project expectations to team members and stake holders in a timely

manner.

• Identify and resolve issues and conflicts with in project team.

• Identify change in project scope and manage using project change control process.

• Ensures project meets requirements and objectives.

• Played key role in client meetings by determining requirements and specifications.

• Directly work with SMEs, Solution Architects, Designers

• Regularly reviewed project execution status with Program Manager &PMO.

• Extensively used MS Project, Excel and Visio

• Attending Pre-Sales Meeting with prospective customers

• Acting as the liaison between Solutions delivery and DBA team

• Designing Solutions for Customer specific requirements

• Project Management of big migration projects.

• Defining Standards for the managed databases and enforcing the standards.

• Database cloning using RMAN Duplicate

• Applying CPU and one-off Patches

• Physical standby database creation using RMAN

• Logical standby database created using RMAN

• Analyzed AWR reports and tuned databases.

• DR site designed and tested using oracle 12c.

• Knowledge in GuideWare products .

BigMachines, IL Jan 2013 – Jun 2013

Sr. Consultant

BigMachines is hosting company . My role is to architect and designing the 11gr2 RAC. Created proposals

for the new requirements Get business approval, prepare SOW and work with vendor management .

Working with my technical team to deliver the CR’s in given time. Maintained schedules. At present I am

supporting Oracle database, oracle apps and Linux team.

July 13th2009 –Dec2012 ACS Xerox Corporation

Role: Technical Manager

ACS Xerox Developed product for USA TOLLS. We implemented the product for NJ turnpike,

PA,BATA,ORT,FLT,SC. The product is developed in C++ and JAVA.

.

• Identified gaps and areas of improvement in current applications and come with a roadmap to

address them.

• Get business approval, prepare SOW and work with vendor management. Plan and execute end

to end activities from knowledge transition to moving into steady state.

• Work with the technical team to review design/architecture, track scope, resolve conflicts manage

change requests and schedule user meetings.

• Guide and groom team members to incorporate best practices in design/architect and

configuration management. Also work with them to resolve design/architect and production

issues

• Work closely with business to priorities work activities and ensure optimal resource utilization.

• Worked closely with across project manages in preparing RFP projects.

• Supporting major clients databases and their OS like NJ Transit, Metrolink LA, Houston Metro,

GCR (Cleveland ), CATS from North Carolina and also supporting major Toll Plaza’s in USA like

NY,PA,BATA ORT,FLT,SC

• Maintained schedule tasks

• Delivered deliveries within given time.

• Responsible for all databases architecture and program design, backups and restores, monitoring

SQL up time, designing and maintaining DTS packages.

• Design ETL process involving data quality, testing and information delivery and access to the data

warehouse.

• Lead the development of the company’s data warehouse and define Meta data standards for the

data warehouse.

• Meet with technical and business staff to document requirements and current processes for the

data warehouse solution

My team accomplished following activities

• Implemented 10g on Sun Solaris.

• Implemented 11g on Linux servers.

• RAC implemented on 4 node LINUX.

• Migrated 9i database to 10g.

• Cross platform migration done (sun Solaris to Linux).

• Re-organized tables and indexes for better performance.

• Analyzed and changed storage parameters for tables and indexes to get better performance.

• Tuned database and UNIX for better performance.

• Tuned Application SQLs whenever if it requires.

• Accomplished capacity planning for new production systems.

• DB maintenance scripts are automated.

• Every day replicated data from production to DW.

• Generated business related reports using DW.

• Implemented DR site for the production servers.

• Daily monitoring the Oracle ERP applications.

• Created application users

• Configured printers in oracle application

• Applied APPS patches using AD utility

• Clone apps

• Upgrade apps from 11.5.10 to R12

• Architecture, developed, and enhanced custom DW systems

Aug2005 –July 09th ACS fare collection Atlanta, US

Role: Technical Manager

• Identified gaps and areas of improvement in current applications and come with a roadmap to

address them. Get business approval, prepare SOW and work with vendor management. Plan

and execute end to end activities from knowledge transition to moving into steady state.

• Work with the technical team to review design/architecture, track scope, resolve conflicts

manage change requests and schedule user meetings .

• Guide and groom team members to incorporate best practices in design/architect and

configuration management. Also work with them to resolve design/architect and production

issues

• Work closely with business to priorities work activities and ensure optimal resource utilization.

• Worked closely with across project manages in preparing RFP projects.

• Supported major clients databases and their OS like NJ Transit, Metrolink LA, Houston Metro,

GCR (Cleveland ),CATS from North Carolina, supporting tolls databases for NY, MD,PA and FL

. My team accomplished following activities

• Implemented 10g on Sun Solaris.

• RAC implemented on 4 node LINUX

• Migrated 9i database to 10g.

• Cross platform migration done (sun Solaris to Linux)

• Re-organized tables and indexes for better performance.

• Analyzed and changed storage parameters for tables and indexes to get better performance

• Tuned database and UNIX for better performance

• Tuned Application SQLs whenever if it requires.

• Accomplished capacity planning for new production systems

• Implemented physical standby database

• Archive process implemented (the process will generate flat files and DDls for the external

tables )

• Implemented purge process

• Automated RMAN backup process

• Regularly monitoring databases and OS.

• Involved in client meetings.

• Convinced client to implement some of the database monitor processes.

• Accomplished major tuning done and improved critical process for the NJT client database.

• Automated process to monitor database as well as OS

• Automated cleanup process at OS level

• Automated some of the DB maintenance scripts.

• Implemented kick start scripts to build new Linux servers

Contractor

May2005 –Aug2005 GAP SFO/CA US

Role: Senior consultant and Technical Manager

• Setup replication.

• Setup disaster recovery plan.

• Installed and configured new databases for production

• Implemented 9i RAC on four nodes on Linux .

• Involved in performance test on RAC.

• Tuned database for better performance

• Tuned Application SQLs whenever if it requires.

• Accomplished capacity planning for new production systems

• Accomplished cross platform data migration

Oct2003 – March 2005 LogicaCMG India/UK

Role : Senior technical consultant and Staff Manager

• Guide and groom team members to incorporate best practices in design/architect and

configuration management . Also work with them to resolve design/architect and production

issues

• Stays current with database trends and applications that may affect infrastructure decisions and

planning.

• Mentors the DBA staff and maintains proper training and education levels.

• Coordinates with system administrators regarding scheduled downtime and maintenance.

• Reviews project requests that involve database access to verify appropriate application design.

• Creates and enforces policies and procedures for:

• Governing database access, security and auditing

• Developed Monitoring database tools proactively fixed issues

• Disaster recovery preparation and testing

• Scheduled for the knowledge transfer from onsite to offsite

• Work closely with business to priorities work activities and ensure optimal resource utilization.

• Identify gaps and areas of improvement in current applications and come with a roadmap to

address them. Get business approval, and work with vendor management. Plan and execute end

to end activities from knowledge transition to moving into steady state.

• Maintained schedules at project level .

As a Staff manager

• Monitored team members activities.

• Co-ordinate with the project managers about my team members activities .

• Motivated team members

My team accomplished following activities

• Upgraded databases from 8i to 9i.

• Setup replication

• Setup disaster recovery plan.

• Weekly/ Monthly reports to management on database health, resource utilization, and

resource plan for the new implementations.

• Set up standby database

• Installed and configured new databases for production

• Accomplished database architect

• Accomplished system design

• Implemented RAC on two nodes on Linux.

• Automated the process for updating standby databases.

• Replicated production databases to development databases by using RMAN.

Sep2002 – Sep 2003 Yahoo.com India/USA

Role: Senior DBA

Accomplished following activities

• Supported oracle application

• Applied apps patches

• Re-0rg tables and indexes to get better performance

• Setup standby databases

• Upgraded databases from 8i to 9i.

• Accomplished the Database Resource Management

• Co-ordinate with the users and developers for resolving issues.

• Setup replications between production,development and report servers

Oct-2000 - Sep2002 Dialpad.com San Jose, CA, US

Role: Technical Manager

• Responsible for logical and physical design with a significant effort towards application and

database tuning of the company’s VOIP product, and Telecom Billing. Major activities include

advanced performance tuning, database design, capacity planning and establishing standards for

Oracle installations, maintenance, tuning, and telecom billing for VOIP.

• Managing team of 20

• 24x7 on call to support for all databases

• Performed tuning for Oracle database attributes like space management, memory structure &

processes and de-fragmentation of tables and indexes at specified intervals, re-organize

databases with less down time

• Responsible for the capacity planning

• Co-ordinate with the users and developers for resolving the database issues in the production

system, with minimal or no downtime.

• Automated the process of making hot backups.

• Automated daily creating the report databases.

• Performed recovery of production databases, when required

• Set up standby database

• Automated the process for updating standby databases.

• Replicated production databases to development databases by using hot backup.

• Responsible for moving data center from one location to another

• Migrated production databases from one EMC box to another with less downtime

• Setup daily monitoring scripts.

• Installed and configured VERITAS Volume Manager

Jan 1999 – Oct 2000 SchlageSanFrancisco,CA, US

Role: Senior Database Administrator and HP UNIX sys administrator

• Monitored the Oracle MRP applications

• Monitored four different databases on HP servers on a day to day basis

• Installed Oracle products on HP UNIX Oracle 8 and 8i

• Configured the oracle databases

• Accomplished the tuning of databases

• Tuned the SQL scripts

• Automated the process of Hot Backup

• Performed recovery of production databases, when required

• Replicated production databases to development databases

• By using the RAID technology created business copy for production database by using the

breaking the mirror on daily basis.

• Migrated oracle 7.3.4 to oracle 8.0

• Major recover done on 800GB oracle apps database

As a apps Administrator

• Daily monitoring the Oracle MRP applications.

• Created application users

• Configured printers in oracle application

• Applied APPS patches using AD utility

• Clone apps

• Involved in apps upgrade from 10.7 to 11

As a HP Administrator handled 4 Major production servers

• Designed System layout

• Implemented RAID technology

• Involved in to configure HP256.

• Created volume groups

• With the help of HP people setup the new disks and removed damaged disks

• Configured printers

• Daily monitored UNIX systems

Nov 1996 – Dec 1999 Lucent Technologies Redhill,NJ, US

Role: Sr. Database Administrator

• Estimated table sizes, tuning database

• Involved in development team

• Eliminated the disk contention

• Sized the rollback segments correctly to reduce the dynamic space allocations

• Tuned the SQL statements by using Tkprof utility

• Executed the oracle tools at regular intervals of time

• Responsible for the logical and physical design

• Defined the rules by which data was accessed (optimization)

• Installed Oracle7.3 on Sun Solaris and HP

• Created instances, users and tables

• Performed backup and recovery process

• Created the database, tablespaces and rollback segments

• Performed logical backup by using oracle export utility

• Worked on several assignments with different clients in the areas of application tuning, database

tuning, installation & configuration of Oracle on UNIX, installation and configuration of Designer

2000, Data mart suites, and Discoverer 2000

Dec 1995 - Oct 1996 SmithKline Beecham India/Belgium

As a DBA and Senior Analyst involved in the database design and development of a Clinical

Database Management System, a comprehensive and integrated software covering clinical trials of

vaccines.

Role: Database Administrator

• Responsible for the logical and physical design

• Installed Oracle 7.3 on Solaris

• Created instances, databases, tablespaces, tables, users, rollback segments

• Performed backup and recovery process and also performed logical backup

• Executed Oracle utilities at regular intervals of time

• Tuned and monitored the Oracle 7.3

OCT 1991 - Nov 1995 W.S.Telesystems Bangalore, India

Started my carrier with foxpro developer and later on worked as developer and started oracle DBA

As DBA and Analyst designed, developed and implemented an order management, production

schedules system for W.S.Telesystems, India. The system covered several modules including

production planning, bill of materials and shop floor control. The system provides for effective control

and organized time phased management of products, cost analysis and planning. The system was

developed using Oracle and Forms 3.0. Created Oracle instance, tablespaces, tables, indexes

References available upon request

Contact this candidate