Pradip S. Patil
******.*****@*****.*** 978-***-****
Introduction:
Experienced IT professional with expertise in all phases of application software management and operations in a wide range of industries. Unique and varied skills acquired in a variety of roles played, from technical expert to Management, in leading global organizations such as Fidelity Investments, UBS, Pepsi and governance organization like Securities Commission of Malaysia. Mastery in infrastructure modernization of large scale/many-moving-parts system upgrades and disaster recovery planning in critical/high impact applications. Has gained insights in securing commercial off shelf application software products from small and large vendors by implementing various controls to cover weakness identified. Has extensive experience of working with stakeholders and Decision makers.
Certifications:
CISA (# 17141211) June 2017.
CISM (# 1839663) February 2018.
Work Experience Summary:
Sr. Systems Administrator - BJ’s Wholesale Club Home Office 10/2010 -02/18
(Westborough, MA)
Operational data store management including data life cycle management
Access control, account/User management including permissions review
Scan of Applications, servers and databases for vulnerabilities and configuration auditing.
Ensuring strategic mitigation of vulnerabilities identified
General controls evaluation and assessment.
Resolution of audit items from audits.
compliance reporting for SOX and PCI on servers & databases
Carried Disaster Recovery exercises with Sun Guard twice a year
Implemented comprehensive monitoring system for all Production servers, websites and critical applications using OEM Grid control, SCOM OPS-Manager and HP Site scope
Migration Management of Servers, Applications, databases for data center migration.
Principal Database Architect/Administrator - Fidelity Investments 02/2002 – 09/2010
(Marlborough, MA)
Responsible for Production support of OLTP databases for Defined Benefits and Defined Contribution Businesses, (401K.com).
Database Architect for Defined Benefits & Defined Contribution schema structure.
Designed and implemented data masking process for all PII data in Non production environment.
Implementation of access controls for sensitive data like salary in defined benefits data stores.
Management of authorization and authentication module data for 401k.com.
Approved quality checks for new DB changes in a multisite environment, and ensured maintenance and implementation of standards and best practices.
Resolution of audit items for compliance for internal and external audits.
Lead role responsibilities included ensuring uptime in high value services
Received 2 organization wide Outstanding Service Awards during tenure.
Capital Market DBA Consultant – UBS Paine-Webber 01/2001 – 11/2001
(New York, NY)
Supported all trading servers for Over the Counter (OTC), Fixed Income Research (FIR), Mortgage Trading (MTS), Electronic Trade (PET) & Municipal Bonds Desk in Sybase.
Performed server tuning & stored procedure tweaking for improved performance & speed
Introduced Proactive Maintenance planning & implementation for better uptime.
Performed Sybase replication server installation & implementation as part of a system used to replicate Key tables across four servers.
Implemented Shell scripting for Oracle DBA activities and DBA Support.
Managed installation & instance creation of Oracle 8.15 & guided database and data migration for QA tests.
DBA Consultant Mercedes Benz Credit, Sony,Pepsi 01/1997 - 03/2001
(NY/NJ/CT)
Production Support DBA for Sybase and Oracle databases.
Project Manager – Malaysian Securities & Exchange Commission 01/1996 – 12/1996
Kuala Lumpur.
Project budgeted for 4 Million RM ( First phase)
Management of 20+ resources on team
RDBMS
Sybase 4.2 – 15.00, Oracle 9i – 12c, SQL Server 2005– 2014, Teradata 13
Operating Systems
Linux, Solaris, HP-UX, AIX, Windows
Security Tools
Qualys, Tenable, Malwarebytes, wire shark, lsof, sysinternals suite, Symantec
Languages
COBOL, SQL, TSQL, PL/SQL, Dbase, Focus, shell scripts
Case Tools
S-Designer, Erwin
Monitoring Tools
HP Site Scope, OEM Grid Control (11g,12c) HP-OpenView, Scom/Ops Manager
Backup Software
Teradata ABU, HP Omni Backup, EMC Data Domain, Veritas NetBackup
job scheduler
Control-M, Autosys
ITIL
Service Now, Remedy
ERP
PeopleSoft ( Oracle DBA/PeopleSoft admin ) SAP R-3
HA set up
Sybase Replication server, Veritas cluster, Microsoft SQL cluster
Load Balancer
F5 ( Big IP ), Citrix Netscaler
Academic Qualifications:
BS (1981) University of Poona, India
MBA Information Systems (1984) University of Poona, India.