Amy Mcwilliams Email & Phone Number

Grand Prairie, Tx, Us

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.

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.

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.

• 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.

• 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.

• 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.

• 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.

• 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.

• 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.

One Year, Accounting

2 Years, Music

1974-1976, Music