Sr. Business Systems Analyst

Thomas C. Randle

***** ******* ** ** ******, MN 55434 763-***-**** (Mobile) adb6fu@r.postjobfree.com

Objective

Seeking a Senior Business Systems Analyst or similar position that leverages my ability to provide complex business system solutions.

Summary

Experienced professional with over 30 years of business analysis and testing experience focusing on Anti-Money Laundering, Fraud, Compliance and Accounting Systems. Relevant experience identifying and solving complex business problems, innovating technical solutions in compressed time frames and successfully developing requirements and test designs for proprietary and off-the-shelf applications.

Education

Carlson School of Business, University of Minnesota, MN - B.S. Accounting

Normandale College, Bloomington, MN - Assoc. Science Engineering Studies

Technical and Professional Skills and Certifications

Certified Business Analysis Professional Program v2

Microsoft Office Suite (Access, Excel, PowerPoint, Word)

SQL Server, Oracle SQL

Project Management Training – St. Thomas, Mpls. Mn 2005

Python – Udemy online course

Power BI – Udemy online course

EDS Boot Camp – Integrated Engineering Facility

CPA Certification

Ad-Hoc reporting using various tools (SAS, IE, DB Visualizer)

Professional Experience

Ameriprise Financial Services, Inc. Minneapolis, MN August 2004 – Present

Sr. Mgr. Business Systems Analyst ~ Chairman’s Award Nominee

Gathered User Requirements for the Big Data project on the Suspicious Activity Monitoring (SAM - Actimize) providing anti-money laundering (AML) oversight of client transactions by employing risk-based evaluations to reduce false positive alerts, participated in model design reviews and performed User Acceptance Testing (UAT). Worked with the Ameriprise Information Management (AIM) team on model variable data mapping.

Gathered User Requirements for Fuzzy Logic project to reduce false positive alerts from the Centralized Hotlist Database (CHL) to SQL Server Reporting System and Money Movement System (MMS). Analyzed alert data from MMS and CHL to identify false positive alert characteristics. Performed UAT and provided statistics of matched record reductions.

Gathered GCO User Requirements for a new document repository to automate communication with the company’s Subadvisors (firms providing Investment Services).

Performed System Testing on the Global Trade Surveillance project. Completed testing Securities file and first round of testing on End of Day (EOD) Valuation files for Aladdin, Long View Trading System (LVTS) and EOD Position files for Aladdin and LVTS.

Wrote User Requirements for the Centralized Hot List (CHL) Database Enhancement project used for recording corporate employee Outside Business Activity (OBA) information. Participated in the design review of graphical User interface and database. Received additional requests to include Private Placement Securities (PPS) and Manual Batch Anti-Fraud Hotlist Inserts (MBI) to the CHL database requiring additional table mapping.

Constructed Data Dictionary of new feeds and converted the historical OBA and PPS data into database.

Participated in validation of Client, Account, Party-to-Party Relationship data for the SAM CDS database from AML Office, SalesForce, Customer Online Application (COLA), Vantage Financial Direct, and Outside Distributor’s daily and weekly sources.

Reviewed SIT Test Results for True-Up activities bringing in historical client data for successful implementation of SAM Customer Due Diligence (CDD) module and updated process documentation impacted by project.

Worked from the RPF process and compiled User Requirements through UAT for Contract Management System (CMS) supporting Ameriprise's and RiverSource's Complex Securities (derivative) trading.

Gathered User Requirements and UAT of implementation of Actimize’s Customer Due Diligence (CDD) Module to the Entity Risk Control Management/SAM application.

Gathered User Requirements, created test cases, and performed UAT of upgrade to the Unified Data Model database supporting CDD module importing new data requirements from COLA, SalesForce, Outside Distribution (OD) Daily, OD Weekly, Vantage Financial Direct and AML Office source systems.

Transformed Enhanced Due Diligence (EDD) data structure to a normalized database for our Client Identification Program (CIP).

Gathered User Requirements for AML Enhanced Due Diligence Enhancements, One Account Challenge Question and ACH and Check Payee Controls projects to develop Supervision Reports of ACH and Check Payee Controls.

Worked with MIS and SSRS developers to mock-up and test the new Interface Balancing Control Report, Transaction Payee Report and Suppressed Transaction Report. Provided User training on functionality of HERT database. Develop Training materials for User community. Developed all the Test Cases and provided testing support to the AML, Anti-Fraud, Centralized Supervision Unit and Service and Operation teams.

Wrote User Requirements for the source data feeds, infrastructure, ad-hoc processes and Watch List Filtering (WLF) Migration/upgrade project from Actimize’s (AML) to their Suspicious Activity Monitoring (SAM) application. Provided UAT testing of normalized data feeds and conversion data. Team nominated for Chairman’s Award.

Performed analysis and participated in User Acceptance test case creation and execution of alternative ingestion sources for Unusual Activity Reports, Manual, Counterparty Profile and Customer Due Diligence alerts for the Enterprise Risk Case Management (ERCM) system.

Served as Project Manager from RFP to implementation for the A-PASS (Ameriprise Prospectus Automation Strategy and System) project combining the manual RiverSource prospectus process with the automated ColumbiaThreadneedle process into a new document management tool, ArcPro, from RR Donnelley. Team nominated for Chairman’s Award.

Coordinated GCO (General Counsel’s Organization) system support for the BETA (Thompson Reuters) brokerage system installation and created User Requirements for the installation’s interface to GCO systems. Reviewed requirements from 35 different work streams within five GCO business functions. Acted as the Subject Matter Expert for these GCO business functions. Received the GCO Leadership Award 3rd Quarter 2010.

Gathered User/System Requirements for integration of H&R Block Financial Advisors into Ameriprise Financial Services Inc. through the AASI, BETA/AnnuityNet, GENE and Big Top projects. Participated in design and data mapping sessions, executed testing and supported the Testing COE.

Previous Employers Job Title Years Employed

Ciber, Inc. Minneapolis, MN Senior Consultant 3

Kinetic Solutions, Inc. Minneapolis, MN Senior Consultant 1

Keene Consulting, Inc. Minneapolis, MN Senior Consultant 2

EDS Inc. Minneapolis, MN System Information Engineer 6.5 Office Automation Analyst

Financial Analyst

National Car Rental. Minneapolis, MN Accounting Systems Analyst 6.5

Accounting Systems Specialist

Accounting Procedure Coordinator

Contact this candidate