PRASANNAKUMAR “Kumar” SETHUMADHAVAN

508-***-**** adx6v2@r.postjobfree.com linkedin.com/in/kumar-1518b714 SUMMARY

DATABASE PROFESSIONAL with vast IT experience managing, administrating, and developing databases and operating systems for business application software using Relational Databases (RDBMS) such as MS SQL Server, Oracle, DB2, Sybase, and other RDBMS in OLTP and OLAP environments.

● 7+ years of experience leading a team of DBAs in global organizations in various positions.

● As an Individual contributor, has extensive experience in Database Performance Tuning, Query Optimization, Capacity Planning, Database Storage Planning, Database Security and Auditing, Backup, and Recovery of the database using in-built utilities and third-party applications.

● Solid experience in designing data models, data mining, and data warehousing technologies using databases such as SAP HANA, Netezza, Teradata, and Other NoSQL databases in various flavors of Unix, Linux, and Windows Server technologies.

Business skills include:

DR planning and implementation for databases, budgeting, on-call resource planning, onsite and offshore resource management, goal setting, strategic and tactical planning on database licensing, and hardware for new projects. Sarbanes- Oxley compliance reporting, project management, 2 /3 TIER architecture planning, and ITIL implementation in database environments. ServiceNow SLA assignment for the ticket, support service model implementation, DB software, tools and license management, technical architecture, data modeling, and migration Architecture. Database Technologies:

MS SQL server 6.5, 7, 2000, 2005,2008, 2008R2, 2012,2014 and 2016, 2017,2019, Oracle 7,8i, 9i, 10g,11g, 12c,19c, DB2, SAP HANA SPS 9, Sybase 10.x, 11.x, 12.x, DB2/AS 400/ HPUNIX 11.0, DB2 on AIX/HP Unix/AS400, Netezza and Teradata. Operating Systems:

MS-DOS, Windows 95, Windows 98, Windows XP/2000, windows server 2003 2008, 2012,2016,2019, AIX, HP UNIX10.2/11.0. /11i, Red hat Linux 4.0, 5.0.,7.0, VMware ESXi 5.5 Languages: COBOL, Power Builder, Visual Basic, ASP.Net, Visual Studio 2005 and 2008. Tools: SQL Sentry, SolarWinds DPA, DB Artisan, Quest Central, Erwin 4.0, DATA Junction, Rose, Platinum Repository, Fog light and Toad, Data stage, Crystal reports. TFS, BizTalk 2006, Lite Speed, Red Gate Toolset, Informatica 9.1 and Business Objects 3.1 and 4.0, Net backup, Omni backup, TSM. PowerShell. EXPERIENCE

ACUSHNET COMPANY, Fairhaven, MA December 2016 – June 2023 Senior Manager – Global Database Development & Administration (June 2022 – June 2023) Senior Manager – Global Database Services (March 2019 – June 2022) Senior Manager – Database Administration (December 2016 – March 2019) Team Size – 5 onsite (2 direct + 3 contract) / 6 offshore (contract) + Managed Services Database Size - 2GB to 20 TB

Production database server’s 300+ Windows/Linux/UNIX Servers+ 1 AS400 Environment: SQL Server on Perm/AWS Cloud, Oracle Cloud, SAP, Oracle PaaS, M3/ERP on DB2/As400. Company Profile: No1. Golf Ball/Accessories manufacturing company. Key Accomplishments:

● Implemented performance monitoring tools for tier 1 applications using SQL Sentry and DPA from SolarWinds. M3/ DB2 ERP project global roll-out coordination.

● Supported Manhattan’s WM/Oracle application and migrated flagship application databases from SQL Server to MySQL for warehouse management systems.

● Coached and mentored data management resources including DBAs, database developers, data architects, and production support resources. Database/Data flow Architecture and Migration Planning for 150+ Servers/applications to Cloud.

● Migrated PeopleSoft HR application in SQL Server to Oracle HCM Cloud migration by working with Oracle consulting group.

Kumar Sethumadhavan Page 2 of 3

● Managed vendors for various Cloud projects.

● Ensured project and department milestones and goals were met on time and within budget.

● Conducted impact analysis of keeping legacy application and database servers to reduce the IT cost, performed skill assessment, planning, and budgeting (Managing around 3M+) on software license and hardware planning, working with senior technology services leaders.

● Increased from 70% to 99% database backup availability and reduced costs by conducting skill assessment, goal setting for direct reports/indirect reports, project task monitoring and resource allocation, and skill development.

● Created SOP documents for database administrative functionalities, retired legacy database servers, performed Sox auditing, and supported SAP SQL Anywhere application. HASBRO INC., East Providence, RI September 2010 – December 2016 Technical Consultant

Team Size – 4 onsite / 8 offshore

Database Size - Sizing 1GB to 30TB

Production Database servers in 500 Windows/Linux/UNIX Servers Environment: SAP/ERP on DB2/HP-UNIX, SQL Server, and SAP HANA Company Profile: No2. Toy Maker/ Branded play company. Key Accomplishments:

● Worked with Migration partner from SAP/DB2 AS400 to SAP/DB2 HP-Unix for project planning/management.

● Implemented data warehousing on SAP Hana, performance tuning, infrastructure planning, and 3-Node Active/Active/Active Clustering implementation in SQL Server 2012 (Always on & Failover Cluster).

● Created Upgradation plan and implementation steps for Business Objects 3.1 sp2.10 to 3.1 sp4.0 and 4.0. SQL Server & HANA On-site/Off-shore DBA work/Resource Management and Planning.

● Used DR software such as Recover Point, and SRDF.

● Gained experience with high availability with globally distributed data persistence and disaster recovery techniques.

● Designed and implemented effective database solutions and models to store and retrieve device and patient data.

● Maintained exceptional skills in installing, upgrading, and patching in a Clustering and Mirroring environment in SQL SERVER 2005,2008,2008 R2, 2012,2014 and Oracle databases and implementing new product features in Oracle 9i 10g and 11g versions such as Oracle data guard 10G, Oracle 10g RAC, Oracle Streams along with 3rd party replication tools such as Quest’s Share plex. WINTER WYMAN TECHNOLOGY CONSULTING May 2009 – August 2010 Senior Database Management Consultant for two clients:

– Millennium Partners Sports Club, Boston, MA, Millennium Partners formerly Sports Club LA

– LoJack Corporation, Westwood, MA, LoJack wireless tracking and recovery systems for automobiles Environments: Microsoft CRM on MS-SQL server

Key Accomplishments:

● Implemented SQL Server 2008 R2 for Microsoft CRM application along with SQL Clustering and Replication for DR

(low-cost high availability solution).

● Worked on virtualization, planning, and implementation for Database Servers.

● Performed database-related budget planning, vendor and license management for CIO. PEROT SYSTEMS AS (Presently NTT DATA) September 2000 – May 2009 Sr. Database Management / Configuration Manager – Clients:

– Blue Cross Blue Shield of RI, Providence, RI

– Harvard Pilgrim Health Care, Wellesley, MA

Environments: Oracle in AIX, MS-SQL server, Netezza, Oracle in HP-UX Linux, SQL Server, Sybase 11.5, 11.9, 12.0 on HP Unix 10.2 and 11.x

Key Accomplishments:

● Played a key role in implementing Netezza Data Warehouse, DR planning, and implementation.

● Conducted Teradata implementation for EDW from Oracle data warehouse database.

● Created offshore/on-site model to improve the efficiency of the DBA team and reduced team cost by 40%. Kumar Sethumadhavan Page 3 of 3

Implementation/Conversion Activity:

● Worked on Windows Authentication in SQL server databases, cost accounting, identity management, Mercury Quality Center, configuration management upgradation/implementation, and Oracle Grid Control from 9i OEM to 11g.

● Implemented Oracle RAC 10g. Upgradation planning for Oracle 8i to 9i and then later 9i to 10g using SDLC Life cycle model. Sybase installation 11.9.2 and 12.5 on AIX/ HP-Unix 11.0 Version. Regular Maintenance Activity:

● Created Database partitions in Oracle and SQL servers, query tuning, database tuning, index tuning, capacity planning, SQL query tuning, and TSM backup for Oracle databases in a centralized NAS backup storage System.

● Implemented new features in Oracle and SQL servers. SAN migrations for database servers. Process Improvements:

● Created SOP for repeatable tasks in ORACLE, SQL SERVER, and SYBASE database environments.

● Standardized user account management by automation scripts.

● Implemented level 1, 2, and 3 support models. Implemented the ITIL process in the database area. HUNT WESSON INC., Fullerton/Irvine, CA March 2000 – September 2000 Database Consultant

Environment: SQL server Replication in 6.5/ 7.0. Replication tuning and administration EDUCATION

B.Sc., (Mathematics, chemistry, and physics), BHARATHIYAR UNIVERSITY, Coimbatore M.B.A (System Analysis and Design), UNIVERSITY OF MADRAS, Chennai. Post Graduate Diploma in Systems Management, NIIT, Chennai, Post Graduate Diploma in Relational Database Management, SSI, Chennai. Post Graduate Program in Cloud Computing, UT Austin - (Jul 2023-Dec 2023) Post Graduate Program in Project Management, UMASS Amherst – (Jun 2023-Dec 2023)

• PMP

• Agile Scrum master

• Microsoft Project 2019

• Implementing a PMO

CERTIFICATION

IT Project Management – University of Washington – Apr 2020 Microsoft Certified Technology Specialist (MCTS) – SQL Server 2008 – June 2011 Microsoft Certified IT Professional (MCITP) – SQL Server 2008 – June 2011 TRAINING & WORKSHOPS

Project Management & Communicating with Global Team October 2018 SQL Sentry tool implementation/training May 2017

Oracle 12c & DB2/AS400 refresh course at Manhattan/Infor consulting August 2016 SAP HANA SPS 9 Introduction, Implementation, and Modeling December 2015 Microsoft SQL Server 2012 Performance Tuning – Design, Internals, and Architecture November 2014 SAP HANA SPS 1.0 Database and System Administration March 2013 Business Objects Architecture and implementation – SAP BO 4.0. November 2012 Windows 2008/2012 R2 Performance Monitor: Monitoring Vital Signs April 2011 Project Management for Information Systems November 2009 / October 2012 Oracle RAC implementation January 2006

Netezza Advanced Database and System Administration September 2006

Contact this candidate