Andy W. Email & Phone Number

United States

• Perform analysis of business data using Excel, R, Power BI, and Tableau for data driven decision making.
• Determine measurable, and focused KPI targets informed by business and market data.
• Identify areas of improvement for operational efficiency as informed by business data to streamline business functions
• Analyze financial and sales data to make long term strategic decisions.

Nashville Metropolitan Area

• Develop repurposable data models within the Power BI ecosystem for the use of reporting across multiple business units.
• Advise on best practices for creating Power BI models and reports to improve performance and report usability.
• Create custom SQL queries for the benefit of data architects to develop necessary tables and views with the data warehouse.
• Collaborate with an integrated team to ensure goals are met in a timely and efficient manner.
• Educate business users and report consumers on how to utilize Power BI to gain the most relevant and impactful insights for their needs.
• Transition legacy reporting and data models into the Power BI environment.

Brentwood, Tennessee, United States

• Analyze and Manipulate data with SQL (Teradata and MSSL) in order to carry out ETL needs and extract information for report building and business insights
• Develop Power BI reports and dashboards as the team’s resident Power BI expert for internal customers to include upper management and C-Suite Leaders.
• Utilize Python and other automation tools to increase departmental efficiency and reduced time spent in manual processes.
• Project management as primary analyst ensuring collaboration and encouraging creative problem solving for company processes relating to supply chain, data management, and financial management.
• Communicate insights to stakeholders to aid in strategic business decision making through presentations and reporting.

Oak Ridge, Tennessee, United States

• Utilize Microsoft analytic suite(excel, PowerBI, Power Query (M), Power Pivot, etc.) vendor tools, and classified USIC data sources to conduct analytical research and investigations
• Present data driven reports on threat assessments, counterintelligence, and briefings on foreign intelligence tactics for decision making.
• Manage Foreign National Visits & Assignments (FNVA) by reviewing and analyzing FNVA requests for potential risk factors and counterintelligence interests.
• Liaison with members of other federal agencies (HSI, FBI, etc.), private industry, and DOE personnel to aid in the effective execution of directives and goals

Knoxville, Tennessee, United States

• Analyze vast amounts of personal background information to determine pertinent information for investigative purposes.
• Tactfully discuss and confront individuals with information regarding employment record, foreign influences, and criminal history to obtain motivation and context surrounding potential issues.
• Cultivate relationships with record keepers from local businesses, universities, as well as court and government officials in order to have access to records needed for investigations.

Greater Minneapolis-St. Paul Area

• Create goals for clients with disabilities in order to help them gain employment and improve their quality of life.
• Develop and Instruct curriculum for participants educationally through various onsite enrichment programming.

Master Of Business Administration - Mba, Data Analytics & Digital Marketing

-Completed Data Analytics Focus, receiving extensive training to use Excel, R, PowerBI, and other data analytic tools. -Completed Digital.

Bachelor Of Arts - Ba, Cultural Anthropology