Connect With Me |
Github Repos |
Education
- Master of Business Administration – University of Massachusetts Amherst
- Advanced Certificate in Data Analytics and Computational Social Science – University of Massachusetts Amherst
- Master of Engineering Management – University of Massachusetts Amherst
- Bachelor of Science Mechanical Engineering – University of Massachusetts Amherst
Professional Experience
City of San Diego
Data Engineer Program Coordinator
January 2023 – Present, San Diego
- Utilize Python, Apache Airflow, Snowflake, Pandas, AWS, Docker, and Git to design and automate ETL processes, facilitating smooth data integration and transformation for Development Services Department projects.
- Develop tailored pipelines for visualizing project insights in Power BI and ArcGIS, leveraging Apache Airflow, Python, Pandas, and SQL for data preprocessing and analysis.
- Spearhead comprehensive data analysis and visualization efforts, collaborating with city planners and stakeholders to drive evidence-based decision-making and optimize resource allocation.
- Implement proactive data quality measures and monitoring frameworks to ensure the accuracy and reliability of city datasets, supporting informed policy formulation and infrastructure planning.
National Grid
Data Engineer, Technical Delivery
November 2022 – January 2024, Waltham, MA
- Proficiently employ Python, SQL, PySpark, Databricks, Azure, and Snowflake to design and automate ETL processes, enabling seamless data integration and transformation.
- Develop robust pipelines for Power BI reports, utilizing DAX, Python, PySpark, and SQL within Databricks notebooks. Adapt and optimize functions and code to enhance performance and reliability.
- Successfully execute complex analysis, design, development, testing, and debugging of computer system application software for a prominent utility company undergoing digital transformation, ensuring efficient and reliable operation.
- Proactively manage and support end-to-end Power BI initiatives, including dashboard development, data engineering, and ad hoc requests, ensuring seamless data visualization and analysis for efficient decision-making.
Senior Engineer, Gas Asset Engineering
July 2022 – October 2022
- Collate and analyze data using R, SQL, Oracle SQL Developer, Alteryx, and Power BI to support the department’s decision-making process.
- Lead monthly meetings with internal and external stakeholders to monitor current projects.
- Lead engineering analysis to manage and organize resources to ensure that work is carried out efficiently and in line with relevant policies and processes. Test and challenge existing procedures and highlight areas for improvement to ensure they are robust.
Engineer, Gas Asset Engineering
August 2020 – May 2022
- Collate and analyze data using R, SQL, Oracle SQL Developer, Alteryx, and Power BI to support the department’s decision-making process.
- Lead monthly meetings with internal and external stakeholders to monitor current projects.
- Lead engineering analysis to manage and organize resources to ensure that work is carried out efficiently and in line with relevant policies and processes. Test and challenge existing procedures and highlight areas for improvement to ensure they are robust.
TRC Companies (formerly Lockheed Martin Distributed Energy Solutions)
Energy Efficiency Field Representative
September 2016 – July 2020
- Utilized VBA and Excel to create a new and more efficient process to analyze, prep, and visualize sales data.
- Built relationships with retailers and their staff about the Northeast Regional ENERGY STAR Consumer Products Initiative and energy-efficient lighting and products.
Technical Skills
- ETL Processing: Airflow, Python, Pandas, PySpark, Databricks, SQL, Docker, Snowflake
- Data Analysis & Visualization: Python, R, Power BI, Oracle SQL Developer, Alteryx, Advanced MS Excel, Power Query, ArcGIS, Tableau
- Other: Data Quality & Data Normalization