Summary
Overview
Work History
Education
Skills
Timeline
Generic

Adriana McCauslin

Rapid City

Summary

  • Proficient in Python scripting and SQL for automation, transformation, and data integration tasks. Experienced in developing and documenting API integrations
  • Supported production data workflows and collaborated across technical and business teams

Overview

11
11
years of professional experience

Work History

Data Analyst/Scientist

C-Lock Inc
03.2023 - Current
  • Designed and implemented data pipelines integrating Salesforce APIs with internal databases to streamline reporting and analytics workflows.
  • Developed RESTful APIs and OpenAPI documentation, enabling browser-based requests and simplifying developer onboarding.
  • Built custom dashboard tools that query both Salesforce API and internal databases, improving operational visibility for business teams.
  • Created and maintained SQL tables and optimized queries for downstream data analysis and reporting.
  • Wrote robust Python scripts to automate anomaly detection in machine calibration and environmental emissions datasets.
  • Led client training on API usage via Python and R, fostering external adoption of internal data services.
  • Developed an OpenAI API-based chatbot (RAG tool) project, parsing unstructured documents like emails and product manuals.

Student Analyst

Impact Learning and Behavior
06.2022 - 03.2023
  • Strengthened skills in data-driven decision-making, behavior tracking, and effective communication with interdisciplinary teams.

Research Intern

University of Wyoming - Laramie
04.2022 - 12.2022
  • Conducted a comprehensive literature review and applied systematic research methods to complete a meta-analysis as the final project.

Accounting Specialist

Davison County Title Co
01.2014 - 04.2022
  • Cooperated with senior leaders to create operating budgets and initiate financial planning.
  • Created various Excel documents to assist with pulling metrics data and presenting information to stakeholders for concise explanations of best placement for needed resources.

Education

Bachelor of Science - Psychology

University of Wyoming
Laramie, WY
08-2022

Skills

  • Data Pipelines SQL and databases API Integration (REST, OpenAPI, Salesforce) Database management
  • Python (Data Processing & Automation) Git/GitLab Big Data Technologies Dashboard Tools
  • OpenAI & Langchain (RAG Projects) File-based Data Transfers
  • Strong Documentation Client API Support Data Analysis Data mining

Timeline

Data Analyst/Scientist

C-Lock Inc
03.2023 - Current

Student Analyst

Impact Learning and Behavior
06.2022 - 03.2023

Research Intern

University of Wyoming - Laramie
04.2022 - 12.2022

Accounting Specialist

Davison County Title Co
01.2014 - 04.2022

Bachelor of Science - Psychology

University of Wyoming
Adriana McCauslin