Data Analyst Tableau

Ryan Seideman

** ***** ***

East Northport, New York 11731

Phone: 631-***-**** Email: ****.********@*****.***

SUMMARY

Curious and insightful Compliance Officer and Data Analyst with autism transforming large transaction datasets into interactive KPIs, business processes and model enhancement solutions through subject matter expertise and technical knowledge. Creative and resourceful by nature with a unique skillset blending compliance regulations, data analysis and operations to enhance program capabilities.

SKILLS

Skills: Exploratory data analysis, statistics, data visualization, relational databases, data analysis of large datasets (>5million records), technical writing, business requirement documentation, market manipulation strategies, market infrastructure, intermarket communication and risks, fixed income, equities and futures.

Software Proficiency: Tableau (expert), R (proficient), Word (expert), Excel (expert), PowerPoint (expert), SQL (proficient), VBA (proficient), Alteryx (proficient), Actimize and SMARTS.

EXPERIENCE

Iconac “AI-Assisted Water Main Inspection”, Milwaukee, WI 10/2013-Present

Independent Contractor, Management Consulting, Co-Founder and Investor

ICONAC is an alumnus of the WERCBench Labs Accelerator at the Midwest Energy Research Consortium, the YEDI Accelerator at York University, the Water Council’s BREW incubator, and the 2016 Wisconsin Governor’s Business Plan Contest.

Iconac's Tonal Pipe Assessment (TPA) technology simplifies watermain inspection. TPA uses low-frequency sound to assess wall thickness, stiffness, leak location, tuberculation, and remaining service life without any service disruption or excavation.

TPA’s AI driven analysis engine properly implements higher order physical effects not captured by commonly used water-hammer, inverse transient and time-of-flight techniques. This enables inspection of a variety of different pipe materials and customized solutions.

Credit Suisse, New York, New York 10/2016-11/2019

Technical Surveillance Officer, Global Trade Surveillance, AVP

Built fully interactive data visualization using Tableau (pre-processed in R) to explore model effectiveness by theme using descriptive statistics to identify and prioritize models based on resource inefficiency and escalation efficacy. This data visualization was shown to the executive management of compliance and regulators. It led to a decrease in false positives of 25% over six months and was replicated by data science for real-time viewing.

Integrated threshold change implementations across scenarios into the Model Effectiveness dashboard to track long-term results of scenario tuning.

Assist in implementing and UAT testing of SMARTS scenario thresholds for equities and listed derivatives globally with IT, regional heads, managers and other relevant stakeholders.

Authored BRDs for the global implementation of “Dark Pools Surveillance”, “OTC Markets” and “Benchmark Manipulation”. Extensively researched and documented the market impact across all market structures on each topic, set up risk themes, described the product scope and the data sources necessary for effective surveillance using an outlier approach.

Analyzed 100million transaction records to identify possible spoofing by using R and PowerShell to remediate, combine, merge and summarize 3,000 transaction files.

Sourced all scenarios from SMARTS, Actimize and eComm surveillance globally and combined all sources to accurately produce multiple Tableau dashboards to monitor trade surveillance risks and controls.

Led global remediation of manual alerts working with dozens of stakeholders to classify and procedures for each manual alert and developed the logic to automate leading to reduction of 33% of alerts in the US.

Technical Trade Surveillance, Global Trade Surveillance, Consultant 6/2017-10/2017

Created KPIs around transactions and alerts to produce a 360 degree view of alert dispositions by risk, asset class, analyst, trader and business. This KPI Dashboard led to the regional alignment of disposition procedures to further MI collection.

Americas’ representative for EMEA SMARTs implementation, calibration and Global Metrics Dashboard working group.

Authored BRDs “Abusive Squeezes (cornering the market)” to articulate risks and develop a holistic approach to surveillance reliant on outlier driven data rather than threshold based models.

Developed custom R script to analyze, clean and standardize Trade Surveillance global metrics for Trade Surveillance’s first ever globally unified data analysis and reporting.

Monitoring and Trade Surveillance, Fixed Income, Consultant 11/2016-5/2017

Created fixed income trade surveillance procedures for training and product specific documents with specific emphasis on Mortgage Backed Securities, agency and non-agency.

Trained existing fixed income trade surveillance staff in Mortgage Backed Security products with emphasis on institutional pass-through trading, and To-Be-Announced trading patterns and settlement. Employees were flown to NYC location to participate.

Performed analysis on MBS trade booking system to identify non-material trade management and support entries through specific institutional trading books and counterparty identifiers. This resulted in a reduction of false positives by 95%, 90% and 50% across three models respectively.

Citibank, Jersey City, NJ 7/2015-8/2016

TTS, AML ICG Advisory Metrics and Risk Assessment, Senior Compliance Analyst AVP

Created, maintained, enhanced and fully automated AML MI reporting and analysis, tracking alert lifecycles, presenting trends and analysis to management.

Worked with the AML Advisory team to define meaningful metrics and create standardized templates.

Standardized Global SAR database in two months allowing metrics reporting to commence for the first time in 2 years.

Responsible for reporting AML metrics to the RDC Governance Committee and answering questions from senior management on SAR workflow in Mantas alerts and key KRI/KPIs regarding time analysis.

Partnered with AML Monitoring and US Bancorp Operations to create the data transfer and automation for interbank communication to monitor Syncada wires (a joint venture between Visa, US Bancorp and Citibank) for AML surveillance, allowing new product launch.

JPMorgan Chase, New York, NY 1/2015-6/2015

Global Financial Crime Compliance, AML Risk Assessment Team, Consultant

Support the execution of AML Risk Assessment process across all lines of business.

Analyzed qualitative data from past AML risk assessments controls to identify key drivers of risk and controls in mitigating inherent risks.

Automated QC and QA reports using data analysis, survey responses, and risk assessment datasets.

Analysis of datasets to wrangle data for preprocessing to prepare decks for senior management.

DPC Data, Inc., Roseland, NJ 10/2012-10/2013

Associate, Research & Compliance

Developed a Primary Market compliance product for issuance of new municipal bonds for ‘material event’ look back requirement SEC 15c2-12 by linking material news to obligors and issuers to allows clients a full 360 degree view of a Municipality’s debt and historical issuances.

Monitored new issuances and regional news to ensure product integrity for compliance regulation services.

Analyzed SEC muni regs from inception to present, MSRB regulations for defeasance of Refundings.

DEALOGIC, New York, NY 9/2011-10/2012

Research Analyst, Compliance

KYC compliance of Qualified Institutional Buyer, FINRA 5131, 2111 Suitability and Regulation S investor certificates for the SEC Securities Act of 1933. Extensive interaction with Broker Dealer senior management.

Mapped extensive database of investor accounts to support integration within the firm’s technology platform.

Implemented an augmented workflow procedure to increase overtime efficiencies and training through automation.

EDUCATION

LEICESTER LAW SCHOOL, Leicester, United Kingdom 2011

Legum Baccalaureus (LLB): Bachelors of Law, Awarded Honours distinction; Upper Second Class (2:1)

STONY BROOK UNIVERSITY, Stony Brook, NY 2007

Bachelor of Arts, Dean’s list

Contact this candidate