Amy Mcwilliams

Amy Mcwilliams Email and Phone Number

Sr Business Analyst @ Mr. Cooper
Grand Prairie, TX, US
Amy Mcwilliams's Location
Grand Prairie, Texas, United States, United States
Amy Mcwilliams's Contact Details

Amy Mcwilliams work email

Amy Mcwilliams personal email

About Amy Mcwilliams

Twenty years of executive level experience in application of finance and accounting computer systems to manufacturing, distribution, real estate/mortgage, health services and human resources areas in both large and small companies.Specialties: Financial analyses, accounting solutions, reporting, etc. Integration of multiple data sources for accurate output.Complete system development cycle service from business process concept to production rollout, user training, documentation, etc.

Amy Mcwilliams's Current Company Details
Mr. Cooper

Mr. Cooper

View
Sr Business Analyst
Grand Prairie, TX, US
Amy Mcwilliams Work Experience Details
  • Mr. Cooper
    Sr Business Analyst
    Mr. Cooper
    Grand Prairie, Tx, Us
  • Mr. Cooper
    Sr Business Analyst
    Mr. Cooper Oct 2017 - Present
    Irving Tx
    Working with Post-Closing team on various databases tracking audit activity, document completion and shipping, and associated recording fees in compliance with federal regulations.
  • Citi
    Business Analyst Sr
    Citi Jul 2013 - Jun 2017
    Las Colinas Irving Tx
    Princeton Information consultant with Marketing data specialization working with corp specific systems, applications and vendors; liaison with research and interpretation responsibilities. Monitoring production and troubleshooting with vendor communication. Developing documentation and tools for ongoing management of historical and current data. Working with users to locate and interpret general to specific data and/or metadata for business use.
  • Think Finance
    Sr. Mis Analyst
    Think Finance Mar 2012 - Jun 2013
  • Ahmsi, Coppell, Tx
    Sr. Business Analyst
    Ahmsi, Coppell, Tx Nov 2011 - Feb 2012
  • Saxon Mortgage
    Sr. Business Analyst
    Saxon Mortgage Jul 2010 - Nov 2011
    Providing reporting for the Financial Transactions Management Dept at this Morgan Stanley owned corporation. Working with FISERV, LPS/MSP, MS Access and Excel to provide timely cash and status information as well as analysis, ad hoc, etc.
  • Modis, Contracted To Radiology Associates Of Tarrant County
    Business Analyst
    Modis, Contracted To Radiology Associates Of Tarrant County Jul 2007 - Aug 2008
    • Developed integrated tools for business assessment utilizing existing system modules from different vendors including billing data from Sentinel VitalWorks, IDX Healthcare clinic scheduling data and Dictaphone timestamp data, as well as internal scheduling data for this large provider of radiological healthcare in the Dallas Fort Worth metroplex at 40+ hospitals and clinics. • Working with GE IDX developers and client IT Dept to facilitate access to scheduling and procedural data, and transmission to the client’s billing data company and system of record. Interpreted HL7 code and communicated needs to IDX developer and billing data company representative. Reported on progress of development to management.• Worked with IDX user SQL table exports and built QA assessment and analysis MS Access database, with reports to analyze scheduling and patient activity for 12 clinic locations.• Creating MS Access tools for reporting and analysis of radiology business as well as user friendly interface tools for employees. Providing project management and documentation of all development and systems involved, as well as ongoing status reporting to executives and other parties involved. Speeding up repetitive tasks with automated solutions at reduced cost to the client.
  • Rhmr, Contracted To Emc Mortgage, Inc.
    Business Analyst
    Rhmr, Contracted To Emc Mortgage, Inc. Feb 2006 - Feb 2007
    • Contracted by this Bear Stearns-owned corporation to maintain and enhance in-house MS Access database designed to track, report status and retain detail of bank account reconciliations related to 500+ investor accounts. These accounts provide funding for 500,000 loans nationwide. Completed enhancements; created new reports, set up a monthly reporting schedule. Created input screens and other tools for users. Provided liaison services for Bank Recon and Investor Accounting Depts with IT to facilitate storage and speed improvements to shared drive. Developed automation for reconciliation of +/-1,000 bank accounts previously reconciled in Excel. Developed automated download of Fidelity data and “FORT” data – a SYBASE in-house system – to provide automation of primary reconciliation steps.
  • Robert Half Technologies, Contracted To Orthorx, Inc.
    Business Analyst
    Robert Half Technologies, Contracted To Orthorx, Inc. Jan 2005 - Jan 2006
    • Contracted to develop and implement corporate financial reporting for this year-old Plano based distributor of orthopedic devices and equipment. Working with a UNIX based mid-sized financial information system called TIMS, and its companion query/reporting software Diver to build corporate monthly, quarterly and annual reporting for analysis and information, as well as daily snapshot/ scoreboard statistics. Additionally building reports and analyses in MS Access and Excel for 22 branches, 6 regions, etc. Recommendations on best tools to use for different types of reporting for accounts receivable, collections, claims tracking, etc.
  • Resulte, Contracted To Blockbuster, Inc.
    Business Analyst
    Resulte, Contracted To Blockbuster, Inc. Sep 2002 - Oct 2003
    • Working for the Studio Revenue Sharing Dept. of Blockbuster Inc.’s Accounting and Finance Dept., assumed responsibility for updating and editing Access database method of downloading and calculating Revenue Share Due studios for test of new Blockbuster Inc. monthly Pass products. Transaction activity is stored in Oracle tables; in excess of ½ million records per accounting period must be downloaded and manipulated. Responsible also for the monthly production of the report.• Created Pass Program Summary Report, using MS Access and Excel to produce a multi-year trend report for analysis of the tested Pass Program activity and resulting Revenue Share Due.• Created Access database application to facilitate the monthly accounting period reconciliation of the main Revenue Sharing General Ledger account. Downloaded data from AS/400 based JD Edwards Financial Accounting System for reconciliation and analysis. Account cash flow exceeds $100 million/yr., with detailed multi-line journal entries to reconcile. • Completed detailed analysis of Columbia title activity over a 3 year period of time, combining data from multiple sources to create a database analyzing accrual vs. actual payment activity. Completing analyses for the remaining studio clients.
  • Rhimr, Contracted To Children’S Medical Center Of Dallas
    Business Analyst
    Rhimr, Contracted To Children’S Medical Center Of Dallas Jul 2001 - Sep 2002
    • Converted data files for Children's Medical Center of Dallas Payroll Dept. for their move from ADP outserviced payroll to a new in-house Lawson payroll system. Tested for integrity and accuracy. • Developed standardized reporting for the Payroll Dept. in MS Access and Crystal Reports for dept. managers; automated the monthly submission of general ledger journal entries to the Accounting Dept.• Developed automated reconciliation to verify data integrity between the major monthly reports.• Completed documentation and procedures for each of the reports and databases developed. • Developed archival of monthly data retrieved, and automated reproduction of previous months’ reports, as well as facilities to produce report department detail upon ad hoc request to the Payroll Dept.• Developed monthly employee turnover reporting for the Human Resources Dept., including analyses calculations, charts, trend reporting and automated production and archival.• Developed Paid Time Off Buy Back report database and employee statement producing system for use by benefits to collect information and pay employees “Buy Back” eligible hours of unused leave each 6 months.• Produced report database for state required Workman’s Comp annual accounting.• Produced documentation and user level procedures for all database venues developed.
  • Fdic/Rtc
    Sr. Financial Information Analyst
    Fdic/Rtc Feb 1992 - Dec 2000
    • Team Leader for the Reporting department of Div. of Finance at FDIC in Dallas for Production and for Management Reporting.• Supervisor for Production Reporting and staff, with administrative responsibilities.• Arena included approximately 1,800 production reports and 150 management reports distributed monthly for $2 billion worth of receivership assets. • Analyzed existing reporting procedures, and recommended and implemented improvements for more efficient operations. • Led professional and staff team members in work related areas and directed work flow. • Led customer service efforts for Reporting with direct customer contact, assessing customer needs and identifying critical areas for improvement, then supervising the initiation of changes needed to achieve customer satisfaction.• Customers included all DOF departments, as well as many departments in DRR, Legal and other divisions in both Dallas and Washington.• Monitored and maintained report notification email distribution lists for department, coordinating with Div. of Information Resource Mgmt (IS). • Wrote documentation and procedures for production of regular reports.• Monitored Ad Hoc reporting efforts for Reporting department; ensured any items deserving special attention received proper response. Activity included approximately 600 reports per month.• Lead designer and developer of multiple databases for internal and external DOF clients, including both mainframe data-based and stand-alone (e.g., DOF Field Finance Ctr Personnel and Tax Issues databases, Gen Acctg Office Cash Receipt Audit, etc. • Designs included numerous reports and input forms, as well as links to other working files in softwares such as Excel, and VB and macro programming.• Coordinated with DIRM (IS) regarding placement of databases on multi-user servers, and limited access with Microsoft NT permission hierarchies.

Amy Mcwilliams Skills

Visio Analysis Accounting Sdlc Financial Analysis Software Documentation Access User Training Business Analysis User Acceptance Testing Process Improvement Sql Payroll Databases Project Management Oracle Integration Business Process Testing Business Intelligence Vendor Management Quality Assurance Crystal Reports Sharepoint Requirements Gathering Requirements Analysis Unix Business Requirements

Amy Mcwilliams Education Details

Frequently Asked Questions about Amy Mcwilliams

What company does Amy Mcwilliams work for?

Amy Mcwilliams works for Mr. Cooper

What is Amy Mcwilliams's role at the current company?

Amy Mcwilliams's current role is Sr Business Analyst.

What is Amy Mcwilliams's email address?

Amy Mcwilliams's email address is am****@****hoo.com

What is Amy Mcwilliams's direct phone number?

Amy Mcwilliams's direct phone number is +121467*****

What schools did Amy Mcwilliams attend?

Amy Mcwilliams attended Northlake College, Baylor University, Baylor University.

What skills is Amy Mcwilliams known for?

Amy Mcwilliams has skills like Visio, Analysis, Accounting, Sdlc, Financial Analysis, Software Documentation, Access, User Training, Business Analysis, User Acceptance Testing, Process Improvement, Sql.

Not the Amy Mcwilliams you were looking for?

Free Chrome Extension

Find emails, phones & company data instantly

Find verified emails from LinkedIn profiles
Get direct phone numbers & mobile contacts
Access company data & employee information
Works directly on LinkedIn - no copy/paste needed
Get Chrome Extension - Free

Aero Online

Your AI prospecting assistant

Download 750 million emails and 100 million phone numbers

Access emails and phone numbers of over 750 million business users. Instantly download verified profiles using 20+ filters, including location, job title, company, function, and industry.