Divya Pawar
Fort Collins,Colorado
Summary
Seeking a Data Analyst position, aiming to leverage my background in Environmental Engineering and Computer Information Systems, along with my proficiency in Data Analysis, SQL, Python, and Visualization Tools.
Overview
6
6
years of professional experience
Work History
Distribution Analyst Intern
EDM International INC.
Fort Collins , CO
06.2023 - Current
- Utilized specialized Ocalc Software to model, design, and analyze utility poles, ensuring optimal placement, configuration, and functionality.
- Utilized Data analysis skills to analyze and manipulate large datasets related to distribution lines, including Inspection Data, GIS data, Performance, and Utilization Data.
- Leveraged Microsoft Excel macros and functions to manage data from inspections, GIS, etc.
- Automated tasks in Excel using VBA. Developed visualizations and reports to support project timelines and coordinate activities.
Graduate Research Assistant
CSU
Fort Collins , CO
08.2022 - 05.2023
- Managed SQL Server databases and created PowerBI dashboards.
- Offered tutoring support for under-graduate students.
Environmental Engineer
Kalpataru Consultants
Kolhapur , Maharashtra
06.2018 - 07.2021
- Designed Wastewater Treatment Plants.
- Implemented SQL databases to store and manage geospatial data and compliance-related data.
- Wrote SQL queries to retrieve the required data for preparing compliance reports and Environmental Impact Assessment (EIA) reports.
- Created Power BI visualizations and advised on environmental compliance policies.
Education
Master of Science - Computer Information System
Colorado State University (CSU)
Fort Collins, CO05.2024
Bachelor of Engineering - Environmental Engineering
Shivaji University
Kolhapur, Maharashtra05.2018
Skills
- Databases: PostgreSQL,Microsoft SQL Server, MS Access,Google BigQuery
- Programming Languages: SQL,Python
- Visualization Tool: Power BI, Tableau
- Data Analysis Tool: Visual Studio
Projects
Database Design and Implementation - ColoCraft Trading Company
- Developed a Conceptual Design using LucidChart and Logical Design.
- Created Database using Data Definition Language (DDL) based on logical design and data dictionary in SQL Server.
Data Visualization and Reporting - Sales Information Data
- Imported data into Power BI and cleaned it and added Hierarchies.
- Created Visualizations to get insights of the Sales Information Data.
Timeline
Distribution Analyst Intern
EDM International INC.
06.2023 - Current
Graduate Research Assistant
CSU
08.2022 - 05.2023
Environmental Engineer
Kalpataru Consultants
06.2018 - 07.2021
Master of Science - Computer Information System
Colorado State University (CSU)
Bachelor of Engineering - Environmental Engineering
Shivaji University
Similar Profiles
Pati YeadonPati Yeadon
Administrative Assistant at EDM International, IncAdministrative Assistant at EDM International, Inc
JEFF ISAAKJEFF ISAAK
Digital Content Director at Evolution Digital Media (EDM)Digital Content Director at Evolution Digital Media (EDM)
Janice LiJanice Li
Warehouse Worker at EDM RECYCLYING INCWarehouse Worker at EDM RECYCLYING INC