Peter John V. looks like a good fit?
We can organize an interview with Aldin or any of our 25,000 available candidates within 48 hours. How would you like to proceed?
Schedule Interview NowPeter John V. Data Engineering, SQL and Data Analytics
My name is Peter John V. and I have over 2 years of experience in the tech industry. I specialize in the following technologies: Data Analytics, SQL, Python, Tableau, Data Visualization, etc.. I hold a degree in Bachelor of Arts (BA). Some of the notable projects I’ve worked on include: BrightFutures, Helldivers 2: Sentiment Dashboard, FMA Marketing Executive Dashboard, YelpBoost: Enhanced Yelp Dashboard Map, BeachConsulting: Montreal Crime Dashboard. I am based in Los Angeles, United States. I've successfully completed 5 projects while developing at Softaims.
I approach every technical challenge with a mindset geared toward engineering excellence and robust solution architecture. I thrive on translating complex business requirements into elegant, efficient, and maintainable outputs. My expertise lies in diagnosing and optimizing system performance, ensuring that the deliverables are fast, reliable, and future-proof.
The core of my work involves adopting best practices and a disciplined methodology, focusing on meticulous planning and thorough verification. I believe that sustainable solution development requires discipline and a deep commitment to quality from inception to deployment. At Softaims, I leverage these skills daily to build resilient systems that stand the test of time.
I am dedicated to making a tangible difference in client success. I prioritize clear communication and transparency throughout the development lifecycle to ensure every deliverable exceeds expectations.
Main technologies
Data Engineering, SQL and Data Analytics
2 years
Data Analytics
1 Year
SQL
1 Year
Python
1 Year
Additional skills
- Data Analytics
- SQL
- Python
- Tableau
- Data Visualization
- Snowflake
- Statistics
- Microsoft Excel
- Marketing Analytics
- A/B Testing
- Database Development
- Data Warehousing & ETL Software
- Project Management
- ETL Pipeline
- dbt
- Data Engineering
- Data Science
- Data Analysis
Direct hire
Potentially possible
Previous Company
Snowflake
Experience Highlights
BrightFutures
Objective: Led the development of a sophisticated tool to simplify the school selection process in Southern California and to offer a detailed view of educational institutions for informed decision-making. Outcome: Developed an interactive web dashboard providing a data-driven overview of Southern California schools, enabling informed educational choices.
Helldivers 2: Sentiment Dashboard
Helldivers 2 has captured the attention of both indie and mainstream gamers since its release. My project centered around developing a robust analytics tool designed to assist developers in enhancing the gaming experience for PC players on Steam. Objective: The primary objective was to create a tool that helps identify gameplay issues reported by PC users on Steam and aims to boost game performance by identifying issues early.
FMA Marketing Executive Dashboard
1) The Goal In this project, my team and I aimed to analyze Instagram data to uncover valuable insights that would drive our social media strategy for the Financial Management Association (FMA) We wanted to understand our followers' preferences, engagement trends, and the effectiveness of our content strategy. 2) My Contribution ➤ Data Analysis & Visualization: Using Tableau, I addressed key questions related to popular topics, engagement trends, and optimal posting days. I also flexed my designer side, creating visually appealing dashboards.
YelpBoost: Enhanced Yelp Dashboard Map
1) The Goal In a data competition organized by the Southern California R Users Group at the University of California, Irvine, my team, Pythons 'R' Us, and I were challenged to transform raw Yelp reviews data into actionable insights. We aimed to enhance user engagement and provide a more accurate representation of users' experiences at specific locations. 2) My Contribution ➤ Data Engineering: I transformed Yelp reviews data from JSON format into a structured dataframe using Python, applying advanced data engineering techniques for cleaning and enhancing processing efficiency. ➤ Sentiment Analysis: Employing Natural Language Processing (NLP) techniques with Python libraries like spaCy, TextBlob, and NLTK, I achieved a remarkable 90% prediction accuracy rate in sentiment analysis. ➤ Algorithm Development: I engineered a sophisticated ranking algorithm that encapsulated user sentiment and experiences over time, factoring in review count, star rating, and sentiment score. ➤ Visualization: I conceived and implemented a user-focused Tableau dashboard for streamlined decision-making, enhancing user engagement by 65%. This interactive dashboard ensured relevant and readable data presentation. 3) Project's Success Our innovative approach led us to win the 'Best Visualization' award among 100+ Master of Data Science and Business Analytics students. We developed an algorithm that enhanced Yelp's current approach, using a weighted ranking system, and created an engaging, visually appealing, and informative tool for end-users.
BeachConsulting: Montreal Crime Dashboard
1) The Goal At the UCI Embark Datathon, my team and I were tasked with analyzing Montreal's Crime Data, consisting of over 240,000 rows. Our goal was to uncover criminal activity patterns, identify areas for law enforcement improvement, and provide actionable insights for city planning. 2) My Contribution ➤ Data Engineering & Preprocessing: I took charge of data preprocessing and cleaning, handling inconsistencies and missing values to ensure data quality. I used SQL and Python to manage a large dataset, focusing on reliability and accuracy. ➤ Geocoding & Analytics Engineering: I utilized a geocoding API to enrich location data, demonstrating adaptability with API rate limits and optimizing code for efficiency. ➤ Collaboration & Communication: I worked closely with data analysts to create interactive Tableau dashboards, visualizing our findings. My ability to communicate data insights to both technical and non-technical stakeholders was key to our success. ➤ Real-World Impact: My work deepened my understanding of data-driven solutions' potential impact on real-world problems, such as law enforcement and city planning. 3) Project's Success Our hard work paid off as we won the "Best Presentation" award at UC Irvine's Embark Datathon. This experience not only honed my technical skills but also showcased my ability to collaborate effectively and deliver results under pressure.
Education
California State University, Long Beach
Bachelor of Arts (BA) in Economics
Languages
- English
Github