Ian Cleary

Experience

• 

  Thurber Engineering Ltd.

  Apr 2007 - Aug 2007

  Co-op Summer Student

  • Monitored contractors to ensure quality of driven steel H-beam piles.• Prepared official logs and hazard reports.• Worked long hours on a heavy industrial construction site.

• 

  PCL Construction

  Jan 2008 - Aug 2008

  Engineering Co-op Industrial Constructors

  • Took initiative and ran a small welding project from start to finish.• Scheduled welding, heat treatment, and non-destructive testing procedures for exotic down-hole directional drilling tool.• Relayed schedules to crew, monitored progress, and prepared documentation, resulting in project completion on time and on budget.• Calculated whether the first pass of a weld would hold the weight of a custom-made pressure vessel. Confirmed that the specimen could be mounted on a rotary submerged arc welder, saving significant time and money on the project.• Developed simple software tools for document tracking, resulting in increased efficiency.• Monitored inter-pass weld temperatures to assist the in-house materials engineer with development of welding procedures.• Conducted preliminary research for the acquisition of a 5-axis Computer Numeric Controlled Plasma Cutter, acquiring pricing information that was later used in business decisions. Show less

• 

  Arctic Energy Alliance

  Apr 2009 - Aug 2009

  Junior Technical Advisor

  • Designed and built a custom layout for an Apricus solar water heater, using teamwork and collaboration to produce an operational, portable unit for demonstrations at trade shows.• Redesigned a MS Access Database to upgrade functionality and ease of use. Learned SQL and VBA scripting on-the-fly.• Wrote users’ manuals and documentation for the above products.

• 

  Arctic Energy Alliance

  Aug 2010 - Aug 2011

  Energy Management Specialist (in Training)

  • Evaluated heat loss of private residences. Measured and calculated dimensions and internal volume of buildings with complex architectures and foundations. Used knowledge of building practices to estimate insulation values.• Prepared and presented plain-language energy audit reports to residential homeowners, advised energy-saving retrofits, and estimated cost savings.• Represented Arctic Energy Alliance at the 2010 Prospects North business conference. Promoted profitable and sustainable energy opportunities.• Investigated the cause of a major roof leak using thermal imaging. Compared building measurements to original blueprints and identified a major deviation from the original design, leading to corrective action, saving the roof from eventual collapse.• Troubleshooting residential heat loss problems, while identifying potential problems and health concerns.• Worked outdoors in extreme cold weather conditions in excess of -40 degrees Celsius. Traveled within the Northwest Territories as far north as Inuvik and Tuktoyaktuk. Show less

• 

  Acuren

  Mar 2012 - Dec 2014

  EIT - Pipeline Integrity

  -Was the Local Subject Matter Expert (SME) for Spark Optical Emission Spectrometry (OES)-Calibrated and programed portable Spark Spectrometers-Assisting in the mobilization of new Non-Destructive Examination (NDE) technologies such as Spark OES-Performed corrosion investigations using handheld laser scanner-Wrote technical papers for presentation at pipeline integrity conferences-Programed routines for analysis of Automated Ultrasonic Testing data for corrosion investigation-Designed, updated, and maintained VBA macros for graphical mapping of pipeline corrosion features-Reviewed pipeline inspection reports-Assisted pipeline integrity technicians with reporting-Assisted with technician training-Resolved technical issues in the field-Planned, organized and conducted failure investigations-Wrote detailed reports of the results obtained from investigations-Component certification testing-Performed a variety of materials test procedures both in laboratory and field locations-Testing procedures included: metallography, tensile and Charpy testing, hardness testing, spark OES, corrosion assessment by manual and laser methods, visual examination of fracture surfaces, scanning electron microscopy, spot testing, microbe testing, strain gauge analysis Show less

• 

  Inspection Info Systems

  Aug 2015 - Jun 2016

  Sole Proprietor

  Minor errors in field-reported data, such as transcription and typographical errors, can be a cause of major, ongoing delays for industries in which inspections are routinely part of a project's critical path. This type of error might take minutes or seconds to correct if detected during field operations, but they are not always detected. This is particularly true of inspection processes that have multiple points of data entry, which tends to happen when photographs are used alongside written reports. Inspection photos often contain information – often hand-written on specimens – which is supposed to match reported values. This introduces the possibility of discrepancies between photographs and reports. In tightly regulated, safety critical fields, that rely heavily on photographic information, the mere possibility of these simple errors may necessitate hours of engineering review poring over photographs to consolidate them with corresponding inspection reports. In some cases, engineering staff spend approximately 60 to 70% of their review time checking fortranscription errors between photographs and reports. Many entry-level engineers will spend two tothree hours per day performing this repetitive task that adds little or no value. Inspection Info Systems' PLI Data Management System can cut that time down to zero hours. By creating a single point of data entry at the field level and using QR code technology to make photographs machine-readable, discrepancies can be highlighted for reviewers. Thus any review time that would have been spent checking for the presence of discrepancies can instead be put to better use.-Business plan-Vision and scope document-Software requirements specification document-Sales proposal-Ensured that product complied with copyright laws and licensing agreements-Designed, coded, and tested a custom application -Used C#, Visual Studio, Entity Framework, WPF-Employed best practices to produce clean, readable code Show less

• 

  Convergent Manufacturing Technologies, Inc.

  Jun 2016 - May 2021

  Engineer/Developer

  Full stack development of tools for managing complex material characterization data• Implemented data transformations between XML, SQL, node-graphs, andPython objects• Designed, implemented and tested a tool for validating material files• Designed, implemented and tested a material file editor with dynamic UIelements• Deployed these tools, both as standalone applications and as featuresintegrated into larger applicationsChampioned code quality initiatives• Trained colleagues in the Model-View-Controller pattern for UI, enablinglarge projects to be split up and solved separately• Introduced colleagues to Python's unit testing tools and encouraged their use• Advocated and trialed code review procedures and toolsSet up a Python package-based development pipeline for use by the entire softwaredepartment, allowing for more flexible project management and saving loads of time• Documented its use and trained colleagues• Created deployment tools for building Windows executables frominterdependent Python packagesRewrote core 0-dimensional solver• Collaborated with original author to recreate functionality in a new code base,migrating from Python 2 to Python 3• Identified errors in the original time-stepping algorithm and implementedsolutions, nearly doubling the speed performance of thermoplasticcrystallization simulations• Clarified implementation details by better organizing the code, paving theway for future improvements• Documented the time-stepping algorithm, previously undocumentedRewrote core 1-dimensional solver• Implemented a cleaner version of the meshing code• Used original solver as a test oracle and verified that new code producedexactly identical outputsReverse engineered a complex XML schema by examining the FORTRAN code ofthe parser (approx. schema size = 1200 statements)Set up a Dask process on a Linux server for use in parallel processingMonitored and directed customer support activities Show less

• 

  InsideDesk

  Aug 2021 - Jul 2022

  Senior Developer

  Optimized PostgreSQL queries, making new software features possibleDesigned and fully implemented an extract-transform-load (ETL) pipeline to ingest Electronic Remittance Advice (ERA 835) documents into a relational databaseCollaborated with frontend and collector teams when designing interface specificationsPlanned and executed major database migrations on production systems without data lossIndependently optimized pytest test suites across multiple repositories, reducing average test times from 15 minutes down to 50 secondsUsed concepts from category theory for visually mapping data structures and program architecture, using those visuals to find structural errors andConfigured AWS Lambda functions to execute on a regular scheduleUsed AWS DynamoDB to store configuration valuesMonitored log groups in AWS Cloudwatch for debugging and performance informationMonitored and optimized application performance with NewRelicDid code reviews and advised junior developersGit, Bitbucket, Clickup (Kanban), Linux, Vim Show less