About Me
My name is Robert Marston, with 18 years of professional experience, I’ve built a career that spans the legal, real estate, and data analytics sectors. My journey has seen me lead support teams of paralegals, contribute to a Top Ten producing real estate team in the Bay Area, and successfully run my own real estate business for over eight years. In my time navigating through the dynamic landscapes of law, real estate and now data analytics, I’ve developed a keen eye for detail and a demonstrated commitment to lifelong learning. As I embark on the new chapter of my career, I am equipped with certifications in SQL, Tableau, and Python from DataCamp.com, I am a Salesforce-certified Administrator, and I’m currently a student at WGU pursuing a BS in Data Analytics. —leveling up all the time.
On my path I have honed my skills in data analysis, I have done extensive financial modeling, but what truly sets me apart is my ability to bridge the gap between data and strategic decision-making. I have a knack for communicating intricate findings in a clear and compelling manner, tailoring my approach to resonate with audiences across varying technical proficiencies.
Collaboration is the driving force behind my success, and it is what I crave. I thrive in cross-functional environments, where diverse perspectives converge to ask the “whys” with the goal to achieve innovation for collective growth. I firmly believe that the fusion of different viewpoints is the catalyst for achieving groundbreaking results.
For many years, I have been captivated by the thrilling world of Formula 1 racing. The roar of engines, the precision of engineering, and the thrill of high-stakes competition have fueled a desire within me to contribute my analytical prowess to this world of motorsport. The way F1 teams move together under immense pressure is awe inspiring and I thrive for the community demonstrated in that sport, one of trust, hard work, dedication, and success.
It is this drive that propels me forward, a pursuit to unlock the secrets that separate champions from contenders. In the future, data reigns supreme, it paves the path to unprecedented innovation and success on and off the racetrack. From aerodynamic simulations to healthcare innovation, I aim to develop insights that drive advancements in technology, Specifically, I focus on generating insights that propel advancements for chronic conditions such as Type 1 diabetes—a condition I manage personally. This intimate understanding of data’s impact allows me to analyze trends from food logs and continuous glucose monitors. In doing so, I not only fine-tune my health management but also embody the very principles of precision and improvement that I advocate for in professional settings.
This personal connection to data’s transformative potential fuels my determination to make a meaningful impact, whether through groundbreaking healthcare solutions, pushing the boundaries of what’s possible for your business, or helping you understand the data your racecar produces I am excited to join forces with you as a dedicated teammate.
Skills
Python
SQL
Excel
Tableau
Salesforce
Relational Database Management
- Acquired fundamental Python skills through coursework at DataCamp and Sophia Learning, covering essential topics like syntax, data structures, and core programming concepts.
- Proficient in utilizing Python's robust libraries including pandas for data analysis, numpy for numerical computations, and beautifulsoup for web scraping, applying these tools to real-world data challenges.
- Continuously enhancing my Python proficiency through ongoing studies at WGU, demonstrating a commitment to expanding my data analytics toolkit.
- Proficient in SQL with a strong foundation in PostgreSQL, as evidenced by completing DataCamp's SQL Fundamentals and Data Analyst tracks.
- Skilled in crafting complex SQL queries, adept at using JOINs, aggregate functions, and window functions to extract and analyze data.
- Successfully applied SQL to real-world scenarios, including analyzing international debt statistics and solving intricate problems like the SQL Murder Mystery.
- Demonstrated ability to handle advanced data manipulation tasks, employing techniques such as sub-queries and statistical functions to derive meaningful insights.
- Financial modeling for the Real Estate industry, calculating key metrics such as Cap Rates, Return on Interest, Gross Rent Multipliers, 1% test, Gross Yield, and Cash Flow.
- Proficient with Excel's analytical tools, including pivot tables, formulas, and functions like XLOOKUP for data organization and interpretation.
- Advanced Excel Functions such as GETPIVOTDATA, COUNTIF/S, and IF statements for nuanced data extraction and conditional analysis.
- Statistical Calculations, including standard deviation and percentage calculations, to assess performance metrics.
- Data Cleaning Techniques to ensure data deduplication and integrity.
- Certified in Tableau Fundamentals, with practical experience in visualizing real estate financial data and market trends.
- Crafted client-facing dashboards and reports, translating complex data into actionable insights.
- Demonstrated versatility in data storytelling, from analyzing haunted house locations to reviewing film genres.
- Employed ETL processes to source data, ensuring accuracy and relevance in visual representations.
- Designed interactive dashboards with heat maps and geographic mapping to provide spatial analysis of data points.
- Utilized Tableau's dynamic features, like advanced filtering and parameter controls, to create tailored user experiences.
- Certified Salesforce Administrator with extensive experience in CRM management, successfully migrating and maintaining tens of thousands of contacts across various CRM tools.
- Authored comprehensive technical documentation to streamline new organizational structures and sales processes.
- Led training initiatives for new hires, fostering a culture of continuous learning and system proficiency.
- Ensured CRM database accuracy and functionality through systematic validations, hierarchical account management, and workflow automation.
- Oversaw Sandbox environments for user acceptance testing, facilitating smooth transitions and user adaptability across various access levels.
- Implemented key performance indicators within enterprise environments, enhancing performance tracking and strategic decision-making.
- Certified in PostgreSQL database creation and configuration.
- Applied RDBMS principles to manage user permissions and safeguard sensitive information, upholding industry-standard security practices.
- Skilled in schema design, optimizing data storage and retrieval processes for enhanced database functionality.
- Executed data extraction, transformation, and loading.
Projects
