John J. Cassidy IV

Landenberg, PA ***** 302-***-**** ad2rzj@r.postjobfree.com

https://www.linkedin.com/in/johnJcassidyiv/

BUSINESS EXPERIENCE

In-depth experience in the financial services industry, and working in technology teams designing, developing and deploying systems in customer service, disputes, collections, settlement, payments, marketing and risk decision management operations.

8 years experience in Risk Management and Cyber roles. Risk & Controls Experience

8 years experience with application and infrastructure security programs and controls framework to assess risk in technology solutions.

Working knowledge of regulatory policies impacting financial institutions doing business in the in the US, UK, Singapore and Japan

Frequent engagement with internal audit teams validating Cyber and Risk functions Technology Experience

10 years experience developing and automating Data Warehouse and Data Mart applications with Ab Initio ETL tools, AIX Unix and Oracle RDBMS platforms.

4 years experience developing customer service, disputes and collections front-end systems with the Pegasystem workflow tool, SQL and C languages running on HP-UX Unix.

EMPLOYMENT HISTORY

Aslan Properties, LLC Wilmington, DE 2020 - present Accountant March 2020 – present

• Install and configure accounting and payroll software.

• Capture and categorize all business related transactions.

• Prepare quarterly P&L & expense reporting for tax filing. Recording Studio Owner Wilmington, DE 2019 - 2020

Digital Audio Engineer May 2019 – Feb 2020

• Install, configure and operate Windows based digital audio platform.

• Produce music and voice-over audio projects for clients. JPMorgan Chase, Wilmington, DE 2000 - 2019

Cybersecurity Analyst April 2018 – April 2019

• Review network and end-point exception requests from Symantec DLP console, use cases include watermarks, source code, external personal and education email domains and enhanced off-boarding controls.

• Work with manager and team to centralize database Security Event Monitoring procedures using Guardium solution.

• Lead risk-review of controls for applications deployed on the Greenplum / Hadoop platform to identify and remediate excessive privilege as evidenced by inappropriate activity reported by Guardium, engage Technology and Business Controls leads to formally track risk acceptances and define compensating controls where necessary.

• Provide local coaching / oversight for team members in Cyber Operations based in Delaware. Information Risk Analyst (January 2011 – March 2018)

• Guardium SME for Eyes on Glass Monitoring designing and documenting triage procedures for SEM team monitoring privileged user activity on Oracle, SQL Server, Sybase, DB2, Greenplum platforms -risk discovered were referred to application assessments team to open risk breaks to track remediation.

• Primary contact for business on Database Activity Monitoring working group providing tuning and other enhancement suggestions and providing program updates to consumer business BISO contact.

• Lead LoB Contact for Audit Engagement for Security Event Monitoring with Satisfactory rating and an OCC Review of Database Governance program relating to Database layer privileged user monitoring routines. John J. Czssidy IV ad2rzj@r.postjobfree.com Page 2

• Privacy Regulations –led program to comply with tracking cookie regulations engaging business and technology teams to update web sites to obtain informed consent prior to analytic tracking of client behaviour.

• Threat & Vulnerability Management (DB & OS infrastructure) –interface with infrastructure engineers and application owners to remediate configuration vulnerabilities reported by Symantec ESM scans.

• Data Loss Prevention – monitor queue of potential exfiltration of sensitive information incidents referring suspicious activity to investigators.

• Validate firewall rule exception requests with application owners to ensure network zone hops are necessary and secure.

• Access Uplift +1 Monitoring & Remediation –led program to remediate hybrid use of privileged functional user accounts to comply with SOX regulations.

• Cyberark EPV Operations -interfaced with technology teams to integrate with password vault APIs to comply with PCI/ DSS standards.

Application Developer Lead (February 2005 – December 2010)

• Designed, developed and deployed new Data Management services that include 1) implementing Ab Initio’s Business Rules Enviroment for data stewards to code logic that would run in a daily ETL application to identify quality problems on data elements the stewards manage, which are then grouped and loaded into a Data Mart for trending analysis 2) a centralized

(Application Developer Lead Continued)

• Metadata repository and web-based user interface that imports and publishes metadata from a Business Data Definition Matrix

(valid values), database catalogue, database roles / privs, ERwin models, and ETL application lineage from the EME repository to 800+ users.

• Designed, developed and deployed the automation of several marketing and risk predictive models via ETL applications that extract and combine account, customer, transaction, credit bureau, authorization, applicant information which is staged and fed into a SAS model coded by the business and run in the ETL scoring engine. The score results were then published to analytical and operational databases for use in decisioning in batch mode as well as the central card processing mainframe for use in real- time line increase or authorization decisioning.

• Improved quality of information services in Chase DWH by defining, socializing and implementing defensive programming best practices in ETL applications to proactively identify problems in data quality before analysts or other applications can consume inaccurate or incomplete information.

• Worked across business lines at Chase to design, develop and deploy data exchange applications to enable customer matching and information sharing across retail and card businesses; these services were key to compliance with customer privacy regulations, improving risk and marketing decision strategies by providing customer and household information across products in multiple business lines (mortgage, checking account, credit cards, HELOC, etc.).

• Led team of developers to work across business lines on merger and acquisition efforts impacting the warehouse by building

"bridge" applications that fed legacy retail systems until customers and accounts were consolidated onto permanent servicing platforms.

• Reduced customer impacts via phone and web channels as well as operating expenses by working across lines of business to create an inventory of recurring conditions that denegrate information quality and cause customer information maintenance transactions to fail, and working with technology teams in the chase retail business to implement code changes to reduce thousands of rejects per day to less than 10 per month. Application Developer Sr. (March 2001 – January 2005)

• Developed, tested and implemented ETL application to validate and process account, authorization, transaction information from TSYS IP platform and populate Stored Value Card Data Mart

• Developed, tested and implemented a bi-directional exchange of information between the Enterprise DWH and the Card DWH in order to enable integration of card’s account and customer information to the Retail Data Mart in the EDW. Once this integration was complete, the second main component of this ETL application received interface files from the EDW and populated a dimensional model in the Card DWH to enable cross-selling with other business lines in the firm as well as allowing operational areas that interact with customers to evaluate decisions based on behaviours demonstrated with other product relationships a customer might have as well as customer and household level marketing and risk factors which were previously not available. John J. Czssidy IV ad2rzj@r.postjobfree.com Page 3

• Enhanced a daily interface feed to retail systems mainframe that enabled a customer to link their checking account to one of their Chase credit cards for overdraft protection.

• Provide after-hours pager support to resolve application failures in the production environment engaging other groups as needed Aetea Information Technology, Blue Bell, PA October 2000 – February 2001 ETL Developer In First USA (now Chase Card Services) DWH

• Code and test an ETL application which generates a monthly extract file of account and customer information which was delivered to a central customer matching system that applied customer-level privacy choices to the accounts sent in the extract. This information exchange enabled the card business to comply with privacy choices made through the various customer channels to any of the firm’s business lines.

Skill Sets

Languages

Ab Initio XFR & DML, C, Korn Shell, Perl, SQL, PL/SQL, COBOL Server Platforms

• Unix, Wintel

• Oracle, SQL Server, IBM DB2 (distributed), Sybase Security Tools

• Symantec Endpoint Security (infrastructure scans)

• Cyberark Password Vaults

• IBM Guardium Data Protect

• Splunk

Client Products

• Abintio GDE, BRE, Profiler

• SQL*Plus, SQL*Loader, SQL Navigator

• HP Quality Center, PuTTY, WinSCP,

• MS Word, Excel, Power Point, Access, Project, Visio

• ERWin, Peregrine Incident Mgmt System

• Harvest Code Promotion Manager

Web

• Ab Initio Metadata Explorer

Protocols

ftp, scp, ssh, PGP encryption

Working knowledge of SAS language, mainframe systems, Tomcat / Apache web application server and Business Objects technologies

EDUCATION

Delaware Technical & Community College, Wilmington, DE A.A.S. Computer Information Systems Relevant courses completed: • System Analysis & Design (Relational Database Theory Class/MS Access)

• C Programming Language I & II

• Visual Basic 6.0

• Operating Systems I & II (Windows NT/UNIX)

• Computer Organization (Assembly Language/PC Maintenance)

• COBOL I & II

John J. Czssidy IV ad2rzj@r.postjobfree.com Page 4 Chase Employee Development, Wilmington, DE

Training Classes

Courses completed: • CISSP Boot Camp 2013

• Visa Bank Card Training

• Fast Start In Project Management

• Coaching For Performance Reviews

Contact this candidate