Assist in IT enhancement projects for Actimize's Anti-Money Laundering Compliance software solution (SAM):- Gathers business requirements- Document data mapping logic from the financial institution's source systems to Actimize- Perform data quality testing on data loaded into Actimize- Provide ad-hoc management reports to Compliance team

Lead Business Analyst on 2 of the first 4 Actimize implementations to ever upgrade to AML-SAM version 8.Write R code to generate distribution curve analysis graphs for 653 account type-transaction type combinations held by a top-5 US bank. The raw data set sent by the client bank contains 120+million records with the total value for 1 month for each record. Each account type-transaction type graph reports important data for AML alert tuning such as minimum account monthly value, maximum account monthly value, average value, 3 standard deviations above average value and monthly value event threshold.Assist and guide client financial institutions in implementing Actimize's suite of Anti-Money Laundering software solutions (Suspicious Activity Monitoring, Customer Due Diligence & Watch List Filtering). Write and execute data validation, alert tuning and ad hoc SQL queries and report results to the client for the alert threshold and scoring scale tuning. Guide clients on using the Actimize Risk Case Manager GUI and implement Change Requests.

Role Description: Business/Testing Analyst for Anti-Money Laundering software implementation Dates: February 2013 - PresentBanking client is implementing the Actimize transaction monitoring solution in compliance with federal banking regulations. Set up meetings with members of the client's IT team to understand & document 45 relational data mappings between the client's customer management software data fields & Actimize data fields. Analyze PL/SQL code written by the client's Senior VP of IT Development for an ETL process to load data from the client's transaction maintenance systems into the Actimize database. Analyze MS Excel extracts of data produced by the ETL process for quality assurance. Draft testing approach and methodology business documents for approval by senior client stakeholders.Role Description: Event Gateway Developer for major telecommunications provider Dates: July 2012 to October 2012Develop and code a data analytics web application for television and film media companies interested in analyzing viewership statistics for their content on a major telecommunications provider’s Video-On-Demand (VOD) online streaming service. Application uses JavaScript, the PHP Laravel framework, a RESTful API, JQuery and MySQL. Perform quality assurance analysis of the ETL process involving the daily aggregation and transformation of raw data logs stored on a Hadoop cluster into SQL queries for insertion into the MySQL database.