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.

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.

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