TRACY AINLEY, CPA

615-***-**** adihin@r.postjobfree.com www.linkedin.com/in/tracyainley

BUSINESS ANALYST

Certified Public Accountant, Finance, and Technology Professional experienced in analyzing data and assessing user needs to reengineer daily systems and processes, improving function and meeting strategic goals. Highly skilled in:

Data Mining & Manipulation

Data Migration & Reconciliation

Training & Development

Adhoc Reporting

Data Visualization

CloudSuite Financials

Infor Spreadsheet Designer

MS Access & Excel

Lawson

AS400

Teradata

Oracle & SQL

Toad

SharePoint

Visio

SAS

JD Edwards

Visual Studio

Jira & Confluence

CMOD

QuickBooks

PeopleSoft

Business Objects

Spotfire

Qlik

Birst

PROFESSIONAL EXPERIENCE

Business System Analyst, Hospital Corporation of America, Nashville, TN (July 2015 to Present)

Host Business Owner meetings outlining ERP updates and program changes for a $51B healthcare leader

Deliver technological support with interfaces and system configuration for ERP upgrade

Coordinate conversion to new ERP system by performing numerous adhoc analyses of large datasets

Execute and administer an auditable change function system for a variety of attributes averaging 30K new associations, 16K disassociations and 226 new accounts per month since Go Live in 2016

Create and update requirements/user stories, test scenarios, scripts and datasets for application developers and QA testers to utilize during version upgrade using an Agile methodology for over 40 projects simultaneously

Create and facilitate Lawson software training and user acceptance testing for 30+ staff

Develop needs assessments in collaboration with new business units in preparation for onboarding the new ERP system

Financial Technology Analyst, Ainley & Associates Consulting, Leitchfield, KY (July 2009 to July 2015)

Consulted with organizations and Fortune 500 companies in diverse industries including Financial Services, Healthcare, Government, Mortgage, and Education, to develop and implement customized database solutions to optimize the use of large scale structured and unstructured data

Designed and implemented a custom database marketing message system which integrated domestic and global business segments for the consumer division of an international financial company

Created custom databases for mortgage loan reviewers to manage borrower financial injury data and created management reporting packages measuring performance of reviewers and forecasting timelines for 40 users on multiple workstreams

Managed marketing pipeline; maintaining accurate data in MS Access-based tool to coordinate marketing activities and manage regulatory status of an ever-changing number of financial institutions through resolution process

OTHER RELEVANT EXPERIENCE

Business Analyst, Fannie Mae, Dallas, TX (April 2011 to September 2012)

Collaborated with SAS and VBA Developers to create and implement custom reporting for REO Outsource Sales for company with $1.2T in annual revenue

Involved in redesign, deployment and QA metrics to measure vendor performance to increase efficiency and reduce cost

Award recognition for building new approval process mitigating risk by use of multilevel approvals

EDUCATION & CERTIFICATIONS

Bachelor of Arts in Business Administration, Cum Laude, Murray State University, Murray, KY

Certified Public Accountant; TN License #21258

SAS Certified Base Programmer for SAS 9

Contact this candidate