Ian Macgregor Email & Phone Number

North Reading, Ma, Us

North Reading, Ma, Us

Boston, Massachusetts, Us

Senior member of the Data Mapping team. Transform healthcare datasets several terabytes in size from relational tables in AWS across dozens of clients to a patient-centric format for use on a data analytics web application using Java and Spark. Support in-house ETL pipeline software, automate the processing of data, and manage its configuration using Ruby. Collaborate with the web development team and healthcare data specialists on software specification and design.• Enabled ETL pipeline software to run groups of tasks in parallel using a DAG, reducing multi-hour pipeline runtimes by 40%• Designed and implemented a method of linking a variable number of mapped datasets using Spark and displaying a subset of the result to clients based what they have licensed, allowing one pipeline run to be used for dozens of unique releases• Implemented a logging system to record ETL pipeline success rates, runtimes, and trends in MongoDB• Improved team efficiency by adding new features to in-house code generation tools to improve usability and reduce the amount of handwritten code used in ETL• Reviewed pull requests, designed test plans, and mentored junior members of the team

Arlington, Va, Us

Key member of the Sea-Based X-Band Radar (XBR) Tools Team. Develop scripts and tools to support the engineering team and automate the software release process. Enhance and monitor program infrastructure, Jenkins servers, and regression test pipelines. Prepare, test, and deliver software releases to customer.• Created a baseline release of radar-supporting Perl and SQL software. Compared code used at three sites and worked with SMEs to create, install, and test a single version• Used Jenkins to automate steps of our team's release process, saving over 100 hours a year and making the process more accessible to other members of the program• Initiated development of the program's Continuous Delivery pipeline• Managed the release of mission critical radar software to customer sites• Contributed to my team's initial Agile transformation

Us

Joined a cross-functional geoscience support team in Upstream IT, identifying and solving crippling performance issues with an in-house plugin for managing large amounts of vendor data.• Added features allowing users to reduce multi-hour load times by up to 95%• Learned and worked with C#, XAML, and the vendor’s API• Participated in training and assisted with my team’s initial Agile transformation

Us

Joined the Scientific Computing team, implementing a new version of a tensor-based math library to support a Corporate Strategic Research team working to model soft sand wells.• Increased the speed of library functions by up to 45%• Further developed my C++ skills, worked with creating and linking libraries, and gained exposure to High Performance Computing

Worked individually and in groups configuring systems and installing technology to prepare Andover public schools for the upcoming school year.

Irving, Tx, Us

Planned, designed, organized, and led a team in the installation of a 230 foot long wooden fence for the Andover Department of Community Services at their day camp location.