Data Engineer

John Geoghegan 860-***-**** ******@*****.*** West Hartford CT

Senior Data engineer with wide-ranging skill set; extensive experience in design, development, and ongoing improvement of technical projects. 5 years of AWS experience: Kinesis, Lambda, Eventbridge, API Gateway etc. in addition to 5+ years with suite of big data tools. Accustomed to working effectively in Agile environments with a focus on larger strategic picture.

AWS certified Associate Architect May 2020 - May 2023 Technical Experience:

Data Engineer Travelers 2014-2024

Designed and implemented robust data ingestion pipelines utilizing a combination of cloud

(Lambda, API Gateway, Step Functions, EventBridge, Kinesis Firehose, Athena) and on-prem technologies (Python, SQL, Node, Snowflake, Glue). Developed a repeatable Terraform pattern for each category of CRM data, allowing rapid buildout of cross-channel analytics.

Applied advanced data engineering techniques with PySpark to develop and enhance actuarial data products, including leading conversion of build technology from SAS to PySpark.

Built end-to-end clickstream analytics capability using Hadoop environment to process web server logs and aggregations were persisted in SQL Server. Made use of many technologies: Linux; Bash; Hadoop; Hive; Sqoop; MS SQL Server.

Led the design, development, and optimization of critical ETL processes in Databricks.

Established and maintained a continuous deployment ecosystem (Terraform, GitHub, Jenkins) to streamline development and deployment processes.

Led initiative to migrate mainframe data into Hadoop, allowing comprehensive analytics for IT operational data.

Developed and optimized Python ETL pipelines to efficiently extract, transform, and load vendor data from external APIs.

Drove innovation by prototyping and evaluating emerging technologies to identify and implement solutions that enhance data capabilities.

Demonstrated leadership by mentoring and managing summer interns and Leadership Development Program participants.

Contributed to talent acquisition by conducting technical interviews to assess candidate skills and fit.

Developer Eversource 2000 – 2013

Quantified and reported risk metrics for a diverse energy portfolio.

Developed and implemented mark-to-model price curves for illiquid NYISO zones, enabling mark-to-market valuation of energy portfolio.

Optimized energy derivative analysis and settlement processes, resulting in.

Designed and produced comprehensive reports utilizing vendor proprietary risk reporting system.

Education:

M.S. Computer Science Rensselaer Polytechnic Institute M.A. Economics University of Connecticut

B.A. Economics University of Connecticut

B.S. Nursing University of Connecticut

Contact this candidate