Andy Stuart Email & Phone Number

Denver, Co, Us

Served as Senior Data Analyst to support data management and data reporting needs for CFC.Develop schema, workflows, queries and a standard Tableau workbook for uploading/accessing consulting datasets to/from the cloud (AWS S3 & Snowflake); and use that data for client projects. Successfully developed data tracking mechanism to understand upstream and downstream effects. Recruited, onboarded and trained Data Analyst and successfully standardized and documented Tableau workbook policies and processes.Collaborate with 8 rate analysts and 15-20 member organizations per year to organize, join, and cleanse data sets received to produce accurate, actionable, and valuable results for electric rate studies and other value-added consulting services. Create 8 Tableau dashboards reporting on consulting engagement status and progress for the 50 clients our team services annually.Use Alteryx, Snowflake, Salesforce, R and Python to prepare data for these studies and dashboards.

Dulles, Virginia, United States

Alexandria, Virginia

Worked on a project team assessing data from new sensors and cameras on I-95, 395 and 495 Express Lanes for new initiatives.Created analyses and dashboards using Python, SQL and Tableau to assess and execute the new initiatives, and track revenue from them.Developed SQL queries to track customer responses to these initiatives, and to quantify revenue and traffic volume decreases due to covid-19.Wrote Python codes to automate the cleansing and warehousing of new data streams into SQL database.Created Python and R scripts to back up tables for database migration, ensuring data completeness and integrity.Collaborated with marketing, law enforcement, customer service, IT and other operations teams on the rollout and progress of these initiatives.

Communicated findings on risk exposure to brokerage department and insurance company clients.Prepared data for modeling from tables of insurance policies received from clients using Excel, Access, R and SQL.Wrote SQL queries to report client exposure on state-by-state, distance-from-coast and other custom bases. Created 20-page reports in Word including text, graphs and tables to communicate pre-modeling assumptions, and modeling results to clients and brokers.Ran RMS and AIR catastrophe models and used statistics knowledge to analyze and present insurance clients’ exposures. to natural and man-made hazards, recommending reinsurance coverage levels to clients and brokers.

Washington, District Of Columbia, United States

Utilized my weather, statistics and programming skills to analyze energy markets.

Master Of Science - Ms, Weather Intelligence And Risk Management

Applying weather knowledge and forecasts to improved business operations and profitability with an emphasis on applications.

Certificate, Data Analytics

R and PowerBI-based courses in data vizualization, data mining and predictive modeling.

Bachelor Of Science - Bs, Meteorology With Weather Risk Option

Activities and Societies: Campus Weather Service, Weather Risk Management Club, Penn State Bureau of the American Meteorological Society.

Bachelor Of Science - Bs, Accountancy, Mathematics Minor