Javaun Hamilton
Douglasville,GA
Summary
Respected Data Engineer with history of creating system architectures that reduce costs and streamline operations. Ready to create design plans from whole cloth or tackle revamps of disparate networks full of outdated systems. Uses emerging and nascent technologies to create stress-free operations both on site and via remote locations and online.
Overview
5
5
years of professional experience
1
1
Certification
Work History
Data Architect
Synovus
09.2022 - Current
- Designed an SQL-based in-house customer classification system, resulting in a $500k annual cost reduction
- Initially, I executed test cases parallel with live data to ensure accuracy
- Once confident, the new system effectively replaced the older outsourced one
- Utilizing SQL, I crafted queries to identify customers based on their income or bank account balances, allowing Synovus to offer tailored perks and discounts
- I further enhanced system precision and efficiency by integrating new discount tiers using SQL stored procedures
- I instituted data governance policies, fostering enhanced data quality and facilitating seamless data access across various departments
- Additionally, I consistently undertook data cleansing, preprocessing, and transformation tasks to maintain data integrity and dependability.
- Enhanced data quality by designing and implementing efficient data models, schemas, and storage techniques.
Real Estate Agent
Vintia Realty
10.2018 - Current
- Assisted clients in the home buying journey, providing tools and insights to streamline decision-making.
Data Engineer
GenSpark
08.2022 - 10.2022
- Completed a 7-week, full-time, classroom-based skills development and training program covering fundamentals of Data Engineering
- Gained knowledge of the Hadoop ecosystem and big data concepts like HDFS, YARN and MapReduce
- Worked with prototyping, designing, and requirement analysis, as well as secondary tools such as Microsoft Azure, SQL data warehouse, PolyBase, Visual Studio, etc.
- Optimized data processing by implementing efficient ETL pipelines and streamlining database design.
- Enhanced data quality by performing thorough cleaning, validation, and transformation tasks.
Junior Data Analyst
Opendoor
06.2020 - 06.2022
- Built out the data reporting infrastructure from the ground up using Tableau and SQL to provide real-time insights on customer app usage
- Developed root cause reports to address problems with customer conversions by 26%
- Architected a robust data reporting infrastructure using Tableau and SQL, enabling immediate access to key insights on customer app interaction
- Created and maintained a series of dynamic dashboards to visualize KPIs, monitor real-time data, and assist in strategic planning
- Utilized advanced statistical techniques to identify patterns correlations, and trends within complex datasets.
Skills
- SQL
- Microsoft Excel
- Data Analysis
- Python
- Tableau
- Statistical Data Analysis
- R (Programming Language)
- Home Evaluation
- Real Estate Investment Knowledge
- Data Warehousing Expertise
- Structure Designs
- Data Analytics
projects
Covid Data Analysis
Bank Customer Tier Hierachy
Job Runtime Power Bi Reports
Timeline
Data Architect
Synovus
09.2022 - Current
Data Engineer
GenSpark
08.2022 - 10.2022
Junior Data Analyst
Opendoor
06.2020 - 06.2022
Real Estate Agent
Vintia Realty
10.2018 - Current
Certification
- GenSpark Data Engineering Certification, 10/01/22
- Google Data Analytics Professional Certificate, 08/01/23
hyperlink
https://www.linkedin.com/in/javaun-hamilton-9b2796174/