Summary
Overview
Work History
Education
Skills
Accomplishments
Timeline
Generic

Alan Monaghan

Lackawanna,New York

Summary

Committed job seeker with a history of meeting company needs with consistent and organized practices. Skilled in working under pressure and adapting to new situations and challenges to best enhance the organizational brand.

Overview

3
3
years of professional experience

Work History

Operations Data Analyst

Conax Technologies
Buffalo, NY
01.2023 - 07.2023
  • Developed complex SQL queries to aid multiple departments
  • Helped implement a new ERP system, which involved cleaning and loading data, training personnel in various departments, and designing new workflows
  • Aided in recreating the entire reporting structure after the implementation
  • Provided monthly and weekly reports to members of the leadership team
  • Participated in Sales and Operations monthly planning meetings.

SDTM Specialist I

Frontier Science & Technology Research Foundation
Buffalo, NY
06.2022 - 12.2022
  • Developed complex queries for large data sets using SQL
  • Abided by CDISC and FDA standards for cleaning and managing data on Clinical Trials
  • Created and managed large workbooks using Excel
  • Mapped documents to standard variables in a database
  • Participated in weekly team meetings to share progress and answer questions.

Programmer/Data Analyst

Strong Staffing/University of Rochester
Rochester, NY
12.2020 - 09.2021
  • Worked with the Level 1 Help Desk to triage tickets and aid end users
  • Produced monthly reports using Excel
  • Compiled, evaluated, and reviewed data for internal systems
  • Identified and documented business rules and use cases based on requirements analysis
  • Developed database queries using SQL
  • Participated in requirements meetings and data mapping sessions to understand business needs.

IT Internship

University of Rochester
Rochester, NY
01.2020 - 05.2020
  • Internship with the Information Security - Identity and Access Management team
  • Learning a broad overview of the Identity Management processes and was responsible for various daily tasks that compiled databases and lists used by the team
  • Responsible for creation and maintenance of Active Directory accounts for employees, students and contractors.

Education

Bachelor of Science - Management Information Systems

Rochester Institute of Technology
05.2020

Skills

  • Data analysis and validation
  • Data Validation
  • Report Writing
  • Database Programming and SQL
  • Business Needs Analysis
  • Requirements Definition
  • Technical Analysis
  • Business Intelligence
  • MS Office
  • Time Management

Accomplishments

Eagle Scout

Timeline

Operations Data Analyst

Conax Technologies
01.2023 - 07.2023

SDTM Specialist I

Frontier Science & Technology Research Foundation
06.2022 - 12.2022

Programmer/Data Analyst

Strong Staffing/University of Rochester
12.2020 - 09.2021

IT Internship

University of Rochester
01.2020 - 05.2020

Bachelor of Science - Management Information Systems

Rochester Institute of Technology
Alan Monaghan