AMANDA NORWOOD

***** ********* ****

ASHBURN, VA 20148

ad2fwt@r.postjobfree.com

703-***-****

EXPERIENCE SUMMARY

Innovative and determined business analyst with seven years of data analytics and project management experience. My goal is to apply personal experience and to expand my business analytics background to strengthen my data analytics techniques to produce presentable data for clients to make informed decisions based on their business needs.

COMPETENCIES

Project Management

Personnel Management

Statistical Analysis & Techniques

Data modelling

Oracle SQL/Microsoft SQL Server

Linear and logistic analysis

Regression, Correlation, Forecasting Analysis

Python & R

Gather Requirements

Manage Stakeholder Expectations

Machine learning/cluster analysis

Business Program Analysis

Oracle Database

Structured Query Language

Business Analytics

PowerPivot

Power BI

Power Query

Data Visualization

Data optimization and sensitivity analysis

Process Improvement

Dashboard Creation

Credit default analysis

EXPERIENCE DETAILS

MEDALLION BANK (PART TIME) 9/2022 – PRESENT

Business Intelligence Analyst

Create and model machine learning techniques to predict loan default

Design experiments, reports, and dashboards using a combination of SQL, Python, Power BI, and other appropriate tools.

Assist in monitoring credit portfolios within the Bank, including both Recreation and Home Improvement loan portfolios, for optimal performance

Develop credit score models and implement forecasting techniques to predict charge offs

Review monthly reports outlining contractor/dealer performance and present concerns or suggestions for improvement to department.

Monitor the Credit loan portfolio, analyzing changes in risk and profitability.

Analyze credit and risk-related reports and identify concerning trends or red flags in any of the Bank's portfolios. Modify or create such reports for optimal use and provide a summary for management review of any findings.

Assist in the credit activities associated with the Strategic Partnership program, analyzing application and loan volumes to provide insights on unexpected trends and patterns.

Collect data from multiple sources including credit applications, loan origination, servicing, CRM, and accounting systems; analyze the collected data and report the results in intuitive form.

Thoroughly understand and recommend appropriate changes to policies and procedures based on portfolio trends, economic or regulatory changes, strategic direction, etc.

Perform other duties as necessary to support the goals and credit objectives of the Bank and its credit departments.

BOOZ ALLEN HAMILTON 04/2019 – PRESENT

Business Analyst

Provide data analysis reports via SQL for clients and steps to resolve accounting issues

First purchase card SME to export SQL data to present in Power BI as the new standard. Various reports include spending by regions and departments.

oLed to quarter forecasting expenditures for each region and department to improve on time budget execution

Develop and build dashboards for various modules in Oracle via SQL and Power BI

oAllowed users to see their spending within seconds, rather than pulling Enterprise reports which take 10-15 minutes

Project manager for yearly accounting line rollover projects and currently lead a team of 7. Manage schedule, risk, client deliverables, communication, and stakeholder management

Project manager for yearly 1099 project and currently lead a team of 3 for duration of project. Validate and maintain data integrity for DOL to report to IRS and print the forms

Manage support for purchase card module; run daily purchase card transaction processing and payment reports; prepare and review daily control reports sent out to the client

Manage and resolve help desk ticket escalations by identifying software issues, data management issues, and system bugs

Develop training programs for help desk staff and purchase card users to reduce help desk tickets

Provide financial management support, including analysing the development of financial management reports

Utilize SQL & and Power BI to generate reports and clean data to present to the client

Utilize optimization tool to improve help desk staffing days and hours during high and low seasons

Serve as a liaison between business and IT organizations on day-to-day operational support activities

Work on monthly Working Capital Fund processing for all DOL agencies and complete it before the GL monthly close

Update Working Capital Fund, Project setup, Accounts Receivable, Rent/Mail/Security and Refund and Reclass procedure documentation to reflect current client processing requirements and document resolutions for error scenarios

Actively involved in year-end rollover activities for Working Capital Fund, Accounts Receivable, Travel, Mail/Rent and Security and ensuring deliverables are met in required timeline

Major Accomplishments:

Forecasted annual spending for 13 government agencies and reduced erroneous spending by 17% in 2021. On time budget execution improved from 83% to 94% in 2021. This allowed DOL to readily have funds available when needed. Data optimization and forecasted in Excel and R, then presented with Power BI.

UNITED STATES ARMY NATIONAL GUARD 10/2013 – 10/2019

Human Resources

Gathered requirements and managed the manifests for mobilization and demobilization for over 600 soldiers

Prepare policies and correspondences for battalion commander and commanding general for post-wide distribution

Developed an elaborate awards tracking tool to allow proper reporting to commanders

Developed a SharePoint site to track travel for 600 personnel

Appointed as emergency leave and Red Cross Emergency Message representative for the battalion

Prepare and process recommendations for awards and decorations; arranged over four awards ceremonies for 600 personnel within the battalion and over 200 personnel for down trace units

Directly manage three other team members

Awarded as Soldier of the Month and United States Army Central Command Soldier of the Week for contributions

Major Accomplishments:

Scored perfect physical training score of 300. Awarded as 29th Infantry Division Soldier of the Month and United States Army Central Command Soldier of the Week for contributions. Distinguished Honor Graduate or Honor Graduate at each military school attended.

SOC LLC 03/2016 – 04/2019

Training Specialist

Gathered requirements for client training standards to develop internal training programs for 17 courses

Gathered requirements to adhere to ATF range standards

Maintained database integrity and ensured correct updates were made through SQL

Forecasted amount of training needed for each following year in order to meet minimum boots on ground numbers

Managed the coordination travel for all training activities within Special Programs; handled flights, lodging, and transportation arrangements

Managed a team of four with direct management and oversight of over $7 million worth of weapons, training gear, and a weapons range

Tracked and reconciled all travel expenditures monthly and adhere to corporate deadlines for invoicing and FAR Compliance; managed an $8 million budget for all training needs

Managed assessment of operators training needs, including meeting the client’s contractual course requirements for over 17 courses throughout the year

Built and managed training pipeline to ensure fully trained and deployable operators are ready for boots on ground status

Maintained proper and timely maintenance of all training records and status updates

Maintained direct contact with client trainers to ensure effective communication to meet training standards

Major Accomplishments:

Awarded 13 extra courses for operators that were not previously available due to poor training plans. Streamlined requalification courses for returning operators, saving over half a million dollars in 2018. Partook in the rebidding process. Promoted to manage a team of four.

QA/QC Document Control Specialist 03/2016 – 01/2018

Filed items for personnel records generated in Project Management Office and remote countries

Served as a liaison with the PMO and project to ensure proper document collection and retention in project management database system

Ensured all personnel records are properly accounted for in database for auditing purposes

Cross-trained in other support services and provided assistance when needed

Prepared correspondences for Program Directors for distribution to clients and operators

EDUCATION

GEORGE MASON UNIVERSITY

Bachelor of Science, Criminology: Law & Society, 2015

SYRACUSE UNIVERSITY

Master of Science, Applied Data Science, In Progress, Anticipated Graduation May 2024

PROJECT MANAGEMENT INSTITUTE

Project Management Professional (PMP), 2021

Contact this candidate