TECHNICAL SKILLS:

Storage: EMC (DMX, VNX, Centera and Clarion), Netapp NAS, HP EVA, Data Domain

OS: Linux, Windows, Solaris, AIX, Azure, VMWare, MVS, JCL

OLTP Database: DB2/UDB/LUW. Sybase ASE, MS SQL Server, Oracle, DB2/MVS, IMS, VSAM

Big Data DWs: Sybase IQ, Vertica, Greenplum, Matrix/ParAccel, Netezza, Hadoop, Teradata, NoSQL

Replication/DR: SRDF, IBM CDC, Oracle GoldenGate, Sybase Rep Server, F5, Snapshots, NetbackupRHCS, VCS, Sybase MA, MS Clustering, ESM

Other Software: Foglight, Guardium, BMC Clarity, PowerDesigner, ERwin, JIRAOptim, Informatica, Tableau, Splunk, SAP Business Objects, Cognos

Languages: SQL, Ksh, Bash, Expect, Visual Basic, COBOL II

Methodologies/SDLC: Agile/Scrum, Waterfall, RAD/JAD, UML, ITIL, TOGAF, DLP, Data Lifecycle Management

PROFESSIONAL EXPERIENCE:

Confidential

Senior Solutions Architect

Responsibilities:

• Building a data protection practice around Confidential ’s Guardium tool for Confidential ’s largest reseller. Working directly with clients nationwide to architect, implement and integrate security monitoring solutions for structured and unstructured data including vulnerability assessment, encryption, PIM and IAM. Primary products supported are Guardium GDP, GDE, Stealthbits, and Thales/Vormetric.
• Performed complete implementation of Guardium Data Activity Monitoring (DAM) for about 10 clients, supporting their GDPR, PII, PCI, SOX, HIPAA, FISMA, NIST and other compliance requirements. Activities include planning, hands - on installation and configuration, developing policies and reports, and all other activities necessary for a robust, complete data monitoring environment. Supported platforms include all standard OLTP DBMS’ and operating systems as well as DB2/Z, IMS, MPP and Big Data platforms.

Confidential

Risk Management Architect

Responsibilities:

• Designed and built data warehouse architecture for managing and controlling risk (Market Risk, Credit, Liquidity, Operational) and monitoring compliance to international standards such as Basel 3 and Dodd Frank) across all the client bank’s product lines.
• Embedded data governance and access management techniques into the warehouse design phase.

Confidential

Data Architect

Responsibilities:

• Built self-service analytic warehouse to provide significantly enhanced capabilities for the marketing VP. This includes physical system design (Vertica, Hadoop), code review, logical and physical data modeling (segments, partitions, sort sequences, projections), governance, query tuning, designing dashboards with Tableau and a common IAM paradigm.

Confidential

Security Architect

Responsibilities:

• Led Implementation of Guardium Database Access Management, VA, audit and governance solution for all databases and warehouses on all platforms (Linux, AIX, Solaris, MVS, Windows) in the firm. Developed policies, workflows, issue resolution methodologies, reporting, DLP integration and provided extensive training for internal personnel

Confidential

Database Security Architect / Engineer

Responsibilities:

• Built the firm’s OLTP and warehouse infrastructure from the ground up including physical and logical architecture, modeling and data governance standards; IAM, hardware and storage; backup and disaster recovery solutions; access and security policies, SOX and other regulatory compliance; development and turnover procedures..
• Developed processes for SOX, PII, Dodd-Frank and other regulatory compliance, Instituted Master Data, data governance, protection and stewardship procedures

Confidential

Vice President

Responsibilities:

As a member of Confidential DB2/ Confidential CAC, served as primary interface between the firm and Confidential for all database tools in the Confidential ecosystems. Worked directly with Confidential lab engineers on several enhancements to database and data movement products to support bank requirements.

• Managed entire life cycle for deploying Guardium for real-time Database Activity Monitoring, auditing and vulnerability assessment for all corporate databases hosting PII and PCI data. Instituted DAM and VA monitoring policies, workflows and issue resolution methodologies. Created extensive reporting framework including ESM and DLP integration. Assured compliance with PII, PCI, SOX and other regulatory bodies. Supported platforms were Sybase, DB2, Oracle, SQL Server, PostgreSQL, Linux, Windows, AIX, Solaris.
• Developed, tested, published documentation and implemented authentication, entitlements, security and auditing standards for multiple DBMS’s using native audit tools and Guardium, integrating with SIEMs such as Splunk using ITIL-based processes.
• Led global teams to manage full engineering life-cycle support for all SAP and Confidential database - related products in the firm. Responsibilities included version certification, level-three support, upgrades, hardware and environments (including cloud) vetting, monitoring and tuning, security and audit processes, scripting, automation, command-line (RHEL) tools, DBaaS and SaaS solutions, defining architectural guidelines and standards, documentation, managing global rollouts, implementing support policies and negotiating SLAs. Designed logical and physical architecture and collaborated with external vendors to define data requirements, design system architecture and deploy the global Reference Data Project. This master data system replaced over two dozen separate reference databases with a single global system of record replicated out to local repositories with built-in hooks for compliance with international regulatory bodies.
• Engineered full-stack solutions for data warehouse MPP platforms including HP Vertica, SAP/Sybase IQ Multiplex, Hadoop, MongoDB, Teradata, MS PDW, Netezza, Greenplum and DB2 DPF/BLU. Worked with business users across the entire enterprise to provide full production life-cycle support for these platforms, including multi-tenancy, data protection, capacity management, storage layouts and BCP for the entire big data stack. Published installation guides, runbooks, support escalation guides, security guidelines and best practices documents..

Confidential, NA

Vice President

Responsibilities:

• Managed enterprise-wide deployment of Quest Foglight for global monitoring and auditing of the Bank’s entire database environment enabling establishment of a follow-the-sun support model. Produced schedules for production roll-outs and progress reports for management
• Evaluated ILM products (Princeton Softech/ Confidential Optim and Outer Bay/HP), defined corporate archive policies and procedures and implemented a number of migrations and
• Matrix-managed multiple projects using dedicated staff with support DBAs, UNIX and Windows SAs, particularly Market Risk, HR, and internal infrastructure apps
• Developed system and data architecture for managing the Bank’s data-management infrastructure.
• Created deployment standards for software builds, operational procedures, file system and directory layouts, security and auditing policies, monitoring, backups, workflows, and defined roles and responsibilities
• Developed, tested and implemented disaster recovery plans using various hardware and software replication solutions such as EMC SRDF/A, Veritas and database replication

Confidential

Senior System/Data Architect

Responsibilities:

• Managed team of outsourced consultants building SOA-based development architecture for entire division
• Instituted processes for internal development projects and for all database support and instituted policies and procedures for data and application security

Confidential

Data Warehouse Architect

Responsibilities:

• Designed and developed Oracle Data Warehouse. Developed data feeds from a MVS/DB2 ODS and Sybase OLTP; built ETL models with Informatica