Andrew Whelan Email & Phone Number

Waltham, Massachusetts, United States

Remote

- Built an end-to-end Data Warehouse and ETL solution in an Azure environment (using SQL Server and a Linux VM) leveraging Salesforce APIs to keep track of business-critical information and assist in client reporting, leveraging GitHub to track changes and push updates.- Automated daily data loading operations, moving from excel-based processes a python-based system in which users drop files in Sharepoint folders and an automated system processes the data, allowing for approval steps, before loading the data via API into our Salesforce environment- Developed Reporting through PowerBI Dashboards for internal and client uses- Developed and implemented a method to rank requisitions, and fed that data into dashboard visualizations

Walpole, Massachusetts, United States

- Coordinate weekly patch development processes to ensure that bug fixes and scheduled customer configurations are released on-time- Documented internal KPI datapoints captured by our sites, and built business intelligence dashboards in Metabase. Presented progress and improvement reports to leadership.- Lead the creation of a Knowledge Base utilizing existing training materials and writing new articles. Coordinated with team to set up new processes to ensure content stays up-to-date with system changes.- Integral part of the group administering the Company's Jira instance- Manage large-scale enterprise software implementations from project initiation to project close, including data import, customer training, and post-implementation customer relationship management- Develop and maintain updated project plans and weekly status reports to continue momentum and meet deliverables throughout project lifecycle- Work with customer and internal IT teams to integrate Single Sign On (SSO) and Directory Services (LDAP) integrations ahead of implementation work

Haverhill Ma

- Assisted Project Managers in various miscellaneous tasks, like updating and sending schedules or requisitions.-Managing and tracking Submittal and RFI logs and pushing reviews and returns as to avoid delays.-Working from plans to create take-offs for buyout purposes.-Contacting and negotiating with local and national contractors and vendors to obtain quotes and labor for multiple simultaneous projects.-Working closely with the project management and field teams to find out what was needed for each project and prioritizing buyouts for each job.

Arlington Ma

-Site Acquisition and licensing for over 120 concurrent Utility Pole based Telecom facilities-Responsible for tracking, licensing, and keeping in compliance over 700 utility pole projects throughout New England and consolidating team-wide data into a single document for management and client reviews.-Innovated on existing data-structures to drive, maintain, and efficiently deliver knowledge-based reports and forecasts quickly to our Client-Commenced work on designing a cloud-based database system for eventual company-wide deployment, and directly participated in the design and implementation of the database system for our team.-Directly interacted with our Client with regards to ad-hoc and scheduled reports and questions-Responsible for data support and integration for the Real Estate Team

Structure Consulting Group

-Supported the Real Estate team's operations in data entry and data management roles.-Started development on a cloud-based Database system for eventual company-wide deployment.

Waltham, Ma

-Mixture of lab work and research with the intent to develop and market nanoparticle-based inks for optoelectronic purposes.-Workdays were a mixture of experimentation, analysis, presentation, and research. Within several days in this fast paced environment, new avenues of research could be fully explored and analyzed. -Experimentation focused on Inorganic syntheses for nanoparticle compounds. Most syntheses involved experimenting in both vacuum and high pressure / temperature environments.-Nanofabrication of our devices involved vacuum spray techniques or high-temperature rolling onto substrates. Our fabrication methods were aimed at delivering quality devices to test. -Analysis and presentation of the data was done in excel and Powerpoint, respectively. The results of our experiments and syntheses were presented on a near daily basis to my supervisor.-Occasional use of Harvard’s CNS facilities for additional characterization using their SEM/EDS instruments.

-Supervised and assisted the Organic I and II required laboratory time for Sophomore and Junior-year students.-Supervised, managed, and trained students to use the Bomb Calorimeter during it's Physical Chemistry I Laboratory time. -Cleaned glassware from all Laboratories on campus.-Prepared Buffer solutions for use in Biochem and Organic Chemistry courses

Duties included: Opening and closing the cafe, taking orders and preparing short-order meals.

Various data entry and quality assurance tasks were given to me throughout many different projects.

Master'S Degree, Data Science, 4.0

My specialization was in Data Engineering, and during my degree program I built many apps and microservices, running on AWS and GCP.

Data Science

A 10-week intensive course that covered data science from the perspectives of different modeling methods, this course culminated in a solo.

Full Stack Web Development Certification

Challenge-based Front and Back end Web Development courses

Bachelor'S Degree, Chemistry