Robert Matts Email & Phone Number

Boston, Massachusetts, Us

London, Gb

London, Gb

-Worked with large financial service provider to conduct impact analysis of self-identified regulatory reporting matter. Worked closely with data vendor throughout life cycle of project to scope issue, develop and test logic using Python and SQL for issue quantification. Leveraged multiple client data steams to associate billions of records and delivered final impact findings to Outside Counsel and regulatory authority. -Worked with financial service client to perform lookback of one-year period to screen for potential transactions of restricted entities. Leveraged SSIS packages to manipulate and perform fuzzy matching on large quantity of SWIFT, ACH, and Fedwire transactions against OFAC sanctions lists.-Derived logic for joining data across large pharmaceutical provider’s disjointed data systems. Actively lead meetings to derive business and technical requirements in creating anti-kickback related database and platform. Designed anti-kickback Tableau dashboard to visualize back end SQL tests.-Analyzed medical administration data to identify anomalies between drug withdrawal and patient administration. Performed analytics to identify users withdrawing high number of drugs compared to peers. Created risk ranking dashboard to highlight outliers based on an aggregated risk score.

London, Gb

-Imported, validated, cleansed, and analyzed client labor and expense data to identify potential instances of fraud-Presented independent research project to senior management, regarding potential future client engagements stemming from analysis of publically available data-Reviewed and sanitized Information Governance Services documents for retention, in order to mitigate risk associated with handling privileged information-Developed client deliverable, data visualizations in Tableau-Researched company background and recent market developments in order to facilitate client proposal meetings

New York, New York, Us

-Developed VBa based custom Compound Management and Distribution tools to track subset provision and inventory plate production-Manage subset order database and quarterly production metrics-Enhance existing web based tools and user request interface

Bachelor'S Degree, Systems And Information Engineering

Education record