Summary
Overview
Work History
Education
Skills
Websites
Hobbies and Interests
Personal Information
Software
Timeline
Generic
Jared Jose Mercado

Jared Jose Mercado

Waterbury,CT

Summary

Knowledgeable Data Engineer with a robust background in data architecture and pipeline development. Proven ability to streamline data processes and enhance data integrity through innovative solutions. Demonstrates advanced proficiency in SQL and Python, leveraging these skills to support cross-functional teams and drive data-driven decision-making often through the use of visualizations.

Overview

5
5
years of professional experience

Work History

Data Analyst

The Children's Community Programs of CT, Inc.
05.2023 - Current
  • Produced monthly reports using advanced Excel spreadsheet functions.
  • Utilized data visualization tools to effectively communicate business insights.
  • Created various Excel documents to assist with pulling metrics data and presenting information to stakeholders for concise explanations of best placement for needed resources.
  • Improved decision-making processes with accurate data analysis and visualization techniques.
  • Enhanced business efficiency by identifying trends and patterns in complex datasets.
  • Provided actionable insights through comprehensive reports and dashboards, supporting strategic initiatives.
  • Conducted comprehensive data analysis to support strategic planning, leading to more informed decision-making.
  • Analyzed data to identify root causes of problems and recommend corrective actions.
  • Developed and maintained data pipelines for seamless flow of information, ensuring timely availability for decision-making.
  • Conducted ad-hoc analysis to address urgent business questions, facilitating rapid response to market changes.
  • Automated routine data analysis tasks, freeing up time for more complex analysis.
  • Provided technical support for troubleshooting analytics and reporting issues.
  • Developed complex dashboard and reporting tools to track business performance metrics.
  • Developed customized reports, summarizing and presenting data in visually appealing format.
  • Optimized data collection methods to enhance quality and volume of data captured for analysis.
  • Facilitated knowledge sharing by creating centralized data repository accessible to all relevant parties.

Big Data Engineer

Revature
10.2021 - 02.2023
  • Worked with several end clients performing tasks under database management, SQL query performance optimization, rule-set software development, and ETL pipeline verification
  • Many technologies I have learned or worked with in this position: Hadoop, Spark, AWS, MongoDB, Linux terminal, GCP, Splunk, Hue, Ab Initio, Jira/GitHub boards
  • Evaluated emerging big data technologies to ensure relevance with evolving industry trends, maintaining competitive advantage over peers.
  • Migrated legacy systems to modern cloud-based platforms for increased efficiency and scalability.
  • Conducted thorough performance testing to optimize system configurations and maximize resource utilization.
  • Enhanced data quality by developing robust validation strategies to identify and correct inconsistencies.
  • Designed scalable ETL pipelines for improved data ingestion, processing, and storage.
  • Collaborated on ETL (Extract, Transform, Load) tasks, maintaining data integrity and verifying pipeline stability.
  • Compiled, cleaned and manipulated data for proper handling.
  • Developed polished visualizations to share results of data analyses.

SCADA Distribution Automation Technician

Eversource
06.2019 - 09.2021
  • Troubleshooted several distribution technologies throughout CT fixing mainly the communication systems within and occasionally installing new devices on the SCADA system
  • Several additional work tasks were needed when applicable: fleet vehicle management, acquiring supplies, storm-duty, costumer support, training sessions
  • Trained operators on the use of newly installed automation equipment, contributing to a seamless transition during implementation phases.
  • Responded to emergency system repairs and maintained regular service schedules for all job-related machines to optimize performance.
  • Used hand and power tools to mount components to panels by following dimensional layout drawings.
  • Counted, organized and restocked inventories to maintain optimal productivity and meet expected demands.

Education

Bachelor of Science - Computer Science

Colorado State University - Global Campus
08.2024

Associate of Science - Electrical Engineering

Naugatuck Valley Community College
Waterbury, CT
05.2019

Skills

  • Data Analysis

  • Data Storytelling

  • Database Management

  • Clear and Concise Communication

    • Data Collection Management

  • Attention to Detail

  • Web Scraping

    • ETL Processes

  • Data Validation

  • Data Modeling

  • Report Writing

  • Flexible Schedule

Hobbies and Interests

  • 3D Printing
  • YouTube Videos
  • Puzzles
  • Microcontrollers

Personal Information

Pronouns: He / Him

Date of Birth: 06/26/98

Marital Status: Eloped

Pet: Yellow-Chevroned Parakeet

Software

SQL

Python

R

DAX / Power M

VBA

Power BI (Desktop & Service)

Excel

Tableau

Zoho Analytics

Jenkins

Docker

Timeline

Data Analyst

The Children's Community Programs of CT, Inc.
05.2023 - Current

Big Data Engineer

Revature
10.2021 - 02.2023

SCADA Distribution Automation Technician

Eversource
06.2019 - 09.2021

Bachelor of Science - Computer Science

Colorado State University - Global Campus

Associate of Science - Electrical Engineering

Naugatuck Valley Community College

Similar Profiles

CREATE PROFILE
Jared Jose Mercado