Resume

Robert L. Underwood

Email: robertlunderwood@protonmail.com

Experienced data analyst with proven ability to optimize processes and deliver solutions using analytical and technical skills. Capable of learning new skills quickly to solve problems.

Skills

Analytics: Data Analysis, Data Mining, Data Modeling, Data Visualization, Database Design
Software and Languages: R, Python, Tableau, SQL, Access, Excel (including Pivot Tables and VLookup), Power BI

Work Experience

Capgemini Government Solutions, Washington, DC
Data Analyst Team Lead, January 2024 — Present
Data Analyst, March 2020 — December 2023

  • Develops and monitors dashboards in ServiceNow, reducing report completion time by 50%.
  • Delivers weekly and monthly overdue reports and ad-hoc data requests via ServiceNow and Excel.
  • Oversees a team of five in the entry, tracking, and reporting of cases for nine group mailboxes into ServiceNow.
  • Highlights significant or life-threatening issues for immediate action.
  • Maintains over 10 standard operating procedures to align with department changes and new tools.

XLA, Washington, DC
Data Analyst, August 2019 — March 2020

  • Analyzed up to 50 complaints per day submitted through multiple sources, logged summaries in Access, and forwarded complaints for follow-up action.
  • Assisted DBA in developing and testing new functions which reduced entry time by 25% and turnaround time from three months to two weeks.
  • Optimized overdue case reports for clarity and brevity leading to closure of 97% of overdue cases.

Fannie Mae (via FDM Group), Herndon, VA
Junior Peoplesoft Developer, June 2018 — February 2019

  • Updated over 700 test scripts using Peoplesoft Test Framework.
  • Reviewed team interfaces and updated internal database with new interface control documents.

FDM Group, New York, NY
Data Analyst Trainee, March 2018 — May 2018

  • Received additional training and completed projects requiring the use of SQL including Oracle SQL and Microsoft SQL Server, SQL Server Integration Services and SQL Server Analysis Services.
  • Completed a data visualization project using Power BI to create a sales dashboard.

Dollar Bank, Pittsburgh, PA
Video Banking Teller, September 2015 — March 2018

  • Serviced banking needs remotely from customers at 11 locations in three states.
  • Promoted machine functions via branch visits leading to a 75% increase in customer usage.
  • Built and maintained a new schedule template in Excel which reduced the time spent completing schedules by 50%.

Education

American University, Washington DC
Master of Science in Analytics, June 2017

  • Relevant Coursework: Database and Big Data, Applied Managerial Statistics, Business Intelligence, Business Insights Through Analytics, Predictive Analytics

Academic Projects

Email Marketing Data Group Project

  • Analyzed email marketing data – both company and third-party data to build a model that could predict email responses while reducing the total emails sent by over 50% and presented to company representatives.
  • Identified 15 variables out of 300 in the third-party dataset that resulted in a response rate outside of the average response rate and cleaned the data to create a new dataset for modeling.
  • Built, trained, and compared various models which were used to identify how many emails would need to be sent to retain 80% of responses

AU Personal Care Group Project

  • Created a visual analytics tool in Tableau to identify key salespersons, customers, and products that were useful maximizing revenue and recommended the discontinuation of low-performing products
  • Summarized sales patterns and reported outlying high-performance month

Carnegie Mellon University, Pittsburgh, PA
Bachelor of Science in Mathematical Sciences, May 2009