Amanda H. Email & Phone Number

Glen Allen, Virginia, Us

Richmond, Va, Us

• Analyze and interpret large datasets using SQL on a Greenplum database to identify defects and perform root cause analysis for new tables to be used by long term care actuarial models• Validate compounded interest rate calculations ensuring metrics are calculated the same across business areas; replicate ETL calculations in SQL for testing purposes• Document Business Development Plan for creation of rate increase tables both at the seriatim and aggregate levels; document testing cases and results

Richmond, Va, Us

• Create analytical and projection/forecasting reports to review current investor fund and property statuses to be proactive about fund management resources and tax credit compliance• Maintain tables and data on the SQL Server database which is used for all reporting and audit purposes• Create detail level reports for teams in SSRS allowing them to retrieve data in a timely manner. Maintain Excel VBA reports to load property data to SQL database. Prepare PowerPoint presentations for the Board • Led effort and main tester to determine whether Tableau would meet our reporting needs including creation of dashboards and reports• Lead the Innovation and Risk Team to help ensure that our business continuity and disaster recovery procedures are followed. Work with IT Manager to reduce technology gaps• Panel member at the 2016 NASLEF conference discussing “Portfolio Data Mining”

• Project lead on the conversion of health care related reports from Jasper to SSRS using MS Visual Studio• Work with report owners to determine report practicality and modify as necessary before conversion• Manage all QA testing including updating reports, receiving final sign off and promotion to PROD• Prepare documentation for each report detailing data sources, business owners, final output and scheduling• Completed development and initial QA stages of the project one month ahead of schedule

Charlotte, Nc, Us

• Project lead on the conversion of health care related reports from Jasper to SSRS using MS Visual Studio• Work with report owners to determine report practicality and modify as necessary before conversion• Manage all QA testing including updating reports, receiving final sign off and promotion to PROD• Prepare documentation for each report detailing data sources, business owners, final output and scheduling• Completed development and initial QA stages of the project one month ahead of schedule

Charlotte, Nc, Us

• Manage the Mortgage and Consumer Default reporting teams• Establish expectations with default customers regarding ETAs and report development feasibility• Institute monthly team meetings to help the team provide excellent customer service through clear and appropriate communication informing customers of progress, barriers and solutions to all issues and concerns until successful completion of requests• Develop UNIX SAS reports for mortgage and consumer lines of business: PROC REPORT; Macros; ODS Output

Charlotte, Nc, Us

• Create UNIX SAS reports for consumer default lines of business including recovery and credit card

New York, Ny, Us

• Manage approximately $300MM worth of potential advertising revenue from 2,400 requests annually. Improved the management of forecasting requests while increasing the on time delivery from 91% to 97%• Create forecasts of special promotions for various channels including analyzing previous campaigns for traffic, demographics behavior and ad size and placement• Improve the forecast the DL of Aol.com from 14% variance to within 2% of actual numbers • Created a forecasting tracking process to communicate accountability and to increase transparency across the organization; improved efficiency from 10-15 requests completed per week with a backlog of over 100 requests to 45-60 requests completed per week with a backlog of 35-40 requests• Manage the daily work and career development of three team members through: weekly one-on-one meetings, mentoring plans, and participating in 360 reviews. • Co-managed a team of statistical analysts in India to create reports to analyze the inventory supply across AOL properties by identifying usage trends and key traffic drivers

Reston, Va, Us

• Lead analyst on project to improve international data methodology in order to meet higher standards of quality panelist results for our clients.

Gb

• Lead effort to gather Multi-Family mortgage data for the client’s re-audit project. Coordinate efforts with technical staff to extract the data and discuss with management how best to use it for re-audit purposes and running SAS and SQL queries to ensure Multi-Family and Single Family data transfer integrity.

• Work with business analysts to define reporting requirements for on the Member Services Reporting Team. Work with DBAs on documentation for the creation of new data marts focused on Telephony and Retention Marketing business areas.

Mclean, Va, Us

• Lead analyst on the effort to create Corporate Data Warehouse Data Quality Metrics to audit critical data elements used for disclosure

New York, Ny, Us

• Work with senior economists to forecast econometric models for government and private client projects. Maintain core relational databases providing detailed historical and forecast trade coverage for the OECD trading nations and 25 individual US ports using Oracle Personal Express.