Gregory Power Email & Phone Number

Cary, Nc, Us

• Managed Cary’s Open Data Portal which supports datasets for internal/external users• Worked across departments' with data professionals to improve Cary, NC's eligibility for What Works Cities Certification• Created dashboards using PowerBI and Opendatasoft Platform• Created public inter-departmental dashboards using Opendatasoft's Bootstrap and AngularJS component library• Managed access for PowerBI and troubleshoot dataflows and workspacesManaged PowerBI Dataflows, PowerBI workspaces, SAS 9.4 on Windows & RHEL, and SAS Viya 4Accomplishments• Created inventory of Cary’s Eco-Counter sites/sensors, saving $14,000 to upgrade people-countinginfrastructure• Deployed QGIS software for GIS users, saving $8,300/year in licensing• Led a team to complete the SAS 2023 Hackathon, where we built a forecasting model for inventory to better predict demand and cost of products.• Began the Python Inter-Department User Group and train users on conda and git

Raleigh, North Carolina, Us

• Created integrations between Salesforce, BundleB2B, and BigCommerce REST APIs using Celigo’s integrator.io platform.• Handled the launch of four ecommerce websites on BigCommerce and managed international development teams.• Responsible for application integration for payment services and Avalara's tax calculation tools on Accumatica, Salesforce and BigCommerce.• Troubleshooting UI problems within BigCommerce themes by tweaking HTML, CSS, and logic for Handlebars functions.

Raleigh, North Carolina, Us

Responsibilities:• Developed Microsoft Powershell, Linux Bash, and Python 3 scripts, managing source control through Git and Github• Input and analyse data from multiple pipelines into online platform.• Used Python, Excel, Google Sheets, and MySQL Server/Workbench to create certificates for Non-Energy Star programs.• Manage maintenance of code infrastructure for built scripts and creating consistent computer environments for data team.Accomplishments:• Transitioned company's reporting code [Python] infrastructure to a new web platform, saving $40000 per year through increased productivity and opened new lines of business through reporting trends found in our data to builders.• Created scripts for QA of Invoicing, using Python modules Selenium and pandas, that eliminated issue of duplicates being added to system, saving company $10000 per year through increased productivity.• Created scripts to collate and analyze service data for QA purposes, saved $95000 per year of labor, while increasing coverage/visibility of quality assurance from 20% to 100% of data.• Developed automated framework to ensure data accuracy between MySQL database and online platform.• Created integration between MySQL database, Google Sheets, Hubspot, and Sakari that sends SMS messages to site supervisors to see if jobs are ready prior to field tech arrival to prevent wasted time and missed rough inspections.• Introduced Git/Github as a form of source control for company• Fixed HTML & CSS bugs in company's Wordpress website.

Raleigh, North Carolina, Us

• Developed a thorough understanding of AC and DC electrical assemblies in grid-direct, grid-interactive, and off-grid photovoltaic systems.• Programmed inverters and site monitoring equipment for data collection via cloud-based storage, monitoring data for up to a year for multiple homes.• Provided field maintenance and troubleshooting repairs to ensure sites were back online with less than single day downtime.

Raleigh, North Carolina, Us

• Handle installation of solar panels and inverters for grid-tied solar-powered systems.• Set up anchors and safety plan for job site.• Responsible for refactoring panel layout to fit roof.• Draw string map for panel layout.• Install the racking system according to plans.• Set up metal flexible conduit in attic spaces.• Wire the conductors SolaDeck(s) and Inverter(s).

New York, Ny, Us

• Collaberated with client to create design for Front-End website• Ensured that client was notified when we hit project milestones• Worked as a part of a team with UI/UX and Back-End members• Created designs using Adobe XD• Front-end: HTML, CSS, SASS, JavaScript• Deployed websites to Github Pages & Netlify

• Built calculator in Python that calculated herbicide/algaecide mixtures for application to ponds.• Updated company's herbicide/algaecide manual with effective treatments for invasive vegetation.• Develop management plans and reports for private landowners and commercial properties. • Licensed to analyze stormwater devices in the field.• Independently enacted algae and aquatic vegetation best management practices.

Raleigh, North Carolina, Us

• Leading class discussions on Environmental Justice.• Through my contributions, the class achieved permanent status.• Created system for managing student feedback through online portal.• Working with faculty to create course materials.

• Processed, shipped, transported and sold: marine/freshwater seafood as part of a small company.• Responsible for maintaining and ensuring the quality of inventory.

• Represented the organization at the local, state, and regional level.• Ran committees organizing volunteering events for nonprofits in Raleigh.• Trained delegates to represent NRHH to local conferences.

• Oversaw quarterly budget, event planning, and restructuring of the organization.• Responsible for 20 Residence Hall Presidents, along with their supporting board members.• Trained Residence Advisors and volunteers on presenting programming.• Represented NCSU on a state, regional, and national level through attending conferences.

Raleigh, North Carolina, Us

• Responsible for measuring and recording samples (scales, otoliths and spines) of various fishes.• Data entry and analysis of the age and growth data for data sets.• Conducted cleaning and analysis of data sets using Microsoft Excel, R, Python, and JMP Pro 12.• Worked in the field with Old Dominion & utility companies to determine abundance of species.