Summary
Overview
Work History
Education
Skills
Certification
Affiliations
References
Timeline
Generic

Ross Pallotta

Morgantown,WV

Summary

Experienced technical consultant with 3 years of experience in the tech field and 6 years of experience in the engineering field. Result-driven professional with a proven track record in data transformation, ETL, reporting, and data modeling across multiple projects using technologies such as DigitalRoute, Salesforce, Splunk, and Workato. Adept at conducting Splunk administration and excelling as a consultant in key areas including data transformation, modeling, automation, and project management.

Overview

4
4
years of professional experience
4
4

Certifications

4
4
years of post-secondary education

Work History

CEO

Appalassians
Morgantown, WV
03.2025 - Current
  • Managed partnerships and strategic business relationships by negotiating contract terms and handling conflicts.
  • Utilized Atlassian Forge to develop multiple project management-related apps for
    the Atlassian Marketplace.
  • Successfully raised $3 million in funding over the next 24 months for my
    early-stage startup, Appalassians.
  • Performed custom full-stack development of apps using JavaScript, React, JSX,
    HTML, and APIs.
  • Conducted UAT to ensure that the apps meet the users' needs effectively.
  • I personally brought apps to market by creating a TOS and EULA, and working
    with Atlassian to ensure user safety and app support.

DigitalRoute Consultant

M&S Consulting
Morgantown, WV
04.2022 - Current
  • Client: Microsoft Federal.
  • Established a collaborative development environment by setting up a Git repository, enhancing team collaboration, and version control.
  • Refactored data transformation workflow using tools within MediationZone.
  • Designed and implemented Extract, Transform, Load (ETL) workflows on the DigitalRoute MediationZone platform.
  • Enriched, aggregated, and validated incoming transaction records through seamless interaction with REST APIs and custom validation rules.

Project Manager/Salesforce Developer

M&S Consulting
Morgantown, WV
04.2022 - Current
  • Client: Iridium Group
  • Engineered a custom data model within Salesforce, using custom objects and fields to optimize data representation and relationships.
  • Designed and developed a user-friendly digital experience website, featuring custom-built components for seamless customer access and interaction.
  • Implemented custom user and permission sets, ensuring precise access control for site users, subscribed users, and administrators.
  • Streamlined user registration processes through the creation and automation of user registration flows.

Splunk Administrator

M&S Consulting
Morgnatown, WV
04.2022 - Current
  • Client: Charter Communications
  • Successfully managed and administered Splunk infrastructure to ensure optimal performance and reliability
  • Implemented and utilized Splunk HTTP Event Collector (HEC) for efficient data ingestion and real-time monitoring
  • Developed and maintained custom Splunk queries, dashboards, and alerts to meet organizational requirements
  • Engineered and implemented a seamless integration between AWS CloudWatch and Splunk for centralized log analysis
  • Conducted regular tuning and troubleshooting to optimize Splunk search and indexing processes
  • Collaborated with cross-functional teams to gather requirements and deliver tailored Splunk solutions

Bike Shop Mechanic

Pathfinder of WV
Morgantown, WV
08.2021 - 04.2022

Mechanical Pre-Commissioning Technician

DEMATIC
Riverside, CA
01.2021 - 08.2021
  • Responsible for learning and understanding specifications and installation manuals for many conveyor belt and package-sorting systems.
  • Worked closely with Controls Engineers and Installation Technicians to ensure that the client's package handling facility works to their desired specifications.
  • Required skills include understanding a bill of materials, reading layout drawings, memorizing installation manuals, troubleshooting, and close attention to detail.

Education

B.S. - Mechanical Engineering

West Virginia University
08.2016 - 05.2020

Skills

  • DigitalRoute Expertise
  • Workato Automation Pro I
  • Workato Automation Pro II
  • Workato Automation Pro III
  • DBT
  • Splunk
  • Salesforce Administration Skills
  • SQL
  • SnowSQL
  • JavaScript Development
  • Java Development
  • React JSX Expertise
  • Python
  • Microsoft Office
  • MATLAB
  • Simulink
  • Solidworks
  • Autodesk Fusion 360
  • Siemens NX
  • Ansys
  • AI

Certification

  • Splunk Admin Certification
  • Workato Automation Pro III
  • DigitalRoute Certified Consultant
  • DBT Fundamentals
  • Salesforce AI Associate

Affiliations

  • I participate in the trail building and community outreach within the local mountain biking community. I have organized many group rides, trail building service days, and local DIY races.

References

References available upon request.

Timeline

CEO

Appalassians
03.2025 - Current

DigitalRoute Consultant

M&S Consulting
04.2022 - Current

Project Manager/Salesforce Developer

M&S Consulting
04.2022 - Current

Splunk Administrator

M&S Consulting
04.2022 - Current

Bike Shop Mechanic

Pathfinder of WV
08.2021 - 04.2022

Mechanical Pre-Commissioning Technician

DEMATIC
01.2021 - 08.2021

B.S. - Mechanical Engineering

West Virginia University
08.2016 - 05.2020
Ross Pallotta