×
Alexandra K Screven

Alex Screven

Analyst · Barre · Animal Lover
Washington, DC, USA
520-400-5952
akscreven@gmail.com
Who are you?

Who are you? Summary

I'm an analyst who enjoys:
  • Learning how to code
    • Python
    • R
    • HTML
  • Practicing barre
  • Discovering new music
  • Playing with my dog
  • Enjoying nature
  • Having an ice-cold beer with good friends
What have you done?

What have you done? Experience

  • Economic Analyst,  L. E. Peabody and Associates

    Apr 2013 - 2015 2 years 3 months

    I used a combination of research and data cleaning/warehousing to prepare business reports and expert testimony to prevent the railroads from abusing their oligopoly.

    • Lead business intelligence project to estimate the cost of coal using a variety of environmental and market factors for an energy corporation that uses 39 million tons of coal annually
    • Recommended business strategies for clients considering entrance into the natural gas market that led to a $350 million partnership
    • Forecast railroad expenses by designing and building a data warehouse using data from various government departments and confidential railroad contracts
    • Budgeted the cost of acquiring new railroad locomotives to comply with upcoming regulation and ensure the highest cost savings
    • Compared formulas in over 500,000 lines of data to budgeting procedures and identified $10,000,000 of unclaimed revenue
    • Identify railroad inefficiencies by modeling hypothetical rail systems in enterprise architect team
    • Write instructions that explain how to use VLOOKUP, HLOOKUP, and Pivot Tables functions in Microsoft Excel to update data management systems and ensure in-house efficiency and data standardization

  • Intern,  L. E. Peabody and Associates

    May 2012 - May 2013 1 year

    I worked primarily on researching and cataloging changes in the energy and transportation industries.

    • Wrote expert rebuttal testimony in rail rate case that analyzed the relevance of various land inflation indices leading to tens of millions of dollars of cost savings for client system
    • Data mined public energy contracts for coal and natural gas prices

  • Sales Associate,  Sunglass Hut

    Jan 2011 - Aug 2012 1 year 8 months

    I assisted customers in sunglass purchases and repairs.

    • Exceeded 2011 sales goal of $72,070.50 by $14,750 by helping customers find sunglasses that fit their individual needs
    • Mentored coworkers throughout training process

  • Graduation Night Volunteer,  Ironwood Ridge High School

    Aug 2013 - May 2014 1 year 10 months

    I helped organize vendor contracts, volunteers, and budget before event and managed stations during events

    • Organized and secured vendor contracts and donations
    • Developed an invoice reporting system to ensure payment deadlines were met

  • Classroom Volunteer,  Copper Creek Elementary School

    Sept 2009 - May 2012 2 years 9 months

    Helped teachers at public elementary school

    • Helped teachers adopt new grade book technology
    • Tutored students by addressing individual areas of concern

  • Member,  Data Wranglers DC

    Mar 2015 - Present 5 months

    Discuss innovative data managing systems with local professionals

What can you do?

What can you do? Skills

  • Business Analytics
    Microsoft Excel Python Microsoft PowerPoint Microsoft Visio Regulation Strategic Planning Contract Management Data Warehousing Research Planning, Budgeting, and Forecasting Intelligence Process Improvement Financial Planning Statistical Analysis Business Reports Presentations
  • Client Relations
    Web Design HTML CSS Sales Event Planning Networking
  • Miscellaneous
    Training Prioritizing Tutoring Problem Solving Organization
What have you learned?

What have you learned? Education

  • Bachelor of Science

    Business Administration

    University of Arizona

    Aug 2009 - Jun 2013

    Computers and the Internetworked Society Using and Managing Information Systems Macroeconomic and Global Institutions and Policy Quantitative Financial Management Intermediate Microeconomics Statistical Inference in Management Business Mathematics I Business Mathematics II Elements of Calculus Basic Operations Management Integrating Business Fundamentals with Ethics and Law in Management Business Law Management Policies Decision Analysis Business Communication Human Resource Management International Relations

    • Certificate with Distinction

      Data Scientist's Toolbox

      Coursera

      April 2015

      Certification ID: 4RYPXE2KD6