Responsible for the daily operation and analysis of machine learning models to forecast short-term and long-term electricity loads for Community Choice Aggregators. Also directly oversees the data management services of over 230,000 electric meters to ensure data quality for load forecasts.• Improved the data cleaning and validation processes of electricity data by coding scripts in Python using Numpy and Pandas, leading to a 97.22% decrease in daily time spent curating files from 3 hours to 5 minutes.• Documented and implemented technical Standard Operating Procedures for the CCA Data and Load Forecasting Teams including Extract, Transform, Load (ETL) processes, statistical programming, and data validation.• Improved the daily forecasting performance of machine learning models for clients by executing SQL queries to export up-today interval electricity data from the utilities’ Advanced Metering Infrastructure platform.• Reduced the number of data exception reports from 31 to 15 by reevaluating business needs which led to improved data accuracy and timely billing of electricity charges for over 230,000 accounts. This reduced the Data Analyst’s billing time procedures by 71.43% from 7 to 2 hours.

Public finance, urban economics, and Clean-Energy Bond consulting firm specializing in financing public infrastructure, facilities and services to over 2,500 public and private sector clients.• Prepared financial reports for clients modeling fiscal impacts, 5-year plan budget projections, revenue sources, delinquency rates, trending build out expenses, and community mapping by integrating macros, database management, and business intelligence applications.• Constructed, updated, and managed financial models to determine and record annual debt service payments on Municipal Bonds issued by public sector clients to finance improvement projects in local jurisdictions in Texas.

Composed month-end and semi-annual property tax collections variance analysis packages to clients and trustees in accordance with fiduciary and statutory requirements in order to reconcile Budget vs Actual reports to ensure that forecasts were on target.• Created databases in Visual FoxPro to pull tax data relevant to billing property owners in Public Improvement Districts in Texas covering over 800 parcels of land.• Reviewed over 200 Bond debt and payment schedules amortizing special assessments throughout their term and ensured that the data accurately uploads into the company’s ERP primary system.

Conducted consulting services on parcel research, assessor’s maps, recorded County documents, and building permits for Communities Facilities Districts in California and Public Improvement Districts in Texas.• Updated accounting databases using SQL in Visual FoxPro for clients in over 20 districts in California, New Mexico, Illinois, and Texas with information including monthly bank transactions, data on assessed values, payments, and delinquencies.

Authorized electronic components distributor specialized in sourcing obsolete and Hard-to-Find products supplying the consumer, defense, energy, and manufacturing industries on a global scale.Oversaw the procurement and sustainability of the company’s inventory levels through efficient and cost-effective supply chain management.

Coordinated the logistical operations in the Shipping and Receiving department and managed the inventory data entry at a growing electronic components distributor.