Jacob Leonard

• Tech, Finance and Art company created to facilitate contracting for analytics and data consulting needs
• Developed strong partnerships with other businesses to allow for collaboration and more significant opportunities for growth.
• Clients include businesses needing support with dbt, snowflake and looker, or other analytics stacks, with specialties in data modeling and report construction
• Most recent client was glossier filling in for the director of business intelligence while he was on sabbatical, and helped improve business reporting

• Re-birth of Ackward Roots Inc
• Building infrastructure for Wordl Turtle Farm and other projects under the Ackward Roots Inc holding company structure

Promoted for Senority

• Worked with the Head of Data to help migrate data from Snowflake to Databricks which involved converting DBT SQL syntax to Databricks
• Helped design the future of the data infrastructure at the company, and surfaced technologies to use for the development of SaaS and data offerings
• Orchestrated databricks jobs and developed pyspark notebooks for extensive QA processes, and advocated for enhanced data modeling procedures for data education
• Collaborated with stakeholders and other engineers to develop the core infrastructure that would be used for the future of the vanna health ecosystem

• Built the foundation for the analytics data platform using Redshift, DBT Cloud, Sigma BI Tool, AWS Glue, and Fivetran
• Company data is generated by the in-house API and pushed into DynamoDB, then replicated to Redshift & DBT for downstream reporting
• Platform process was built entirely from scratch, base tables replicated at a specified latency, and DBT SQL used to clean and transform the data into star schema

• Worked within the Business Intelligence department to help improve data quality and reporting pipelines from legacy systems across all departments, and gather data warehousing and report generation requirements
• Reverse Engineer LookML generated SQL code from Looker into DBT dry code for report reproducibility and warehousing, using CI/CD pipelines to auto-generate converted codebases
• Technologies used included DBT, Snowflake, Fivetran, Looker, Terraform, Docker and AWS cloud services
• Built a terraform DBT module for self hosted DBT/SQL deployments through GitHub Actions on AWS using Docker.
• Reports ingested from, and reproduced for ingestion by Looker

• Founder and CEO of Ackward Roots Inc

• Hired to help improve & redesign the technology used to aggregate state and federal UI claims for the government
• Primary technologies were written in python for data ingestion and manipulation, AWS S3 for storage, and DVC for data change logging. External clients were given access to shared server through RDP logins for increased data security
• Main tasks included fixing existing ETL systems, standardizing incoming data, adapting data structures to SQL formatting, and improving system design
• Staffed through NextSource

• First member of the Machine Learning Team at Wag after working extensively with the Data Engineering team, being promoted after advocating for stronger data utilization in various environments and analytic frameworks
• Projects include: Aggregate Demand Prediction in Sagemaker(helper), NLP Analysis in Databricks for Label Generation, Graph Network Analysis for CS User Patterns, Distributed Reverse Geo-Geocoding for Address Verification
• Continued refinement and additions of SQL data sets optimized and used directly for ML projects

• Worked as a member of the DataOps team, contributing to all elements of data at Wag such as infrastructure, security, resourcing, pipelining, modeling, reporting and dashboarding
• DataOps Projects: SQL report modeling using DBT and Snowflake for dashboarding in Tableau, Databricks VPC, whitelisting, provisioning and ETL for Hive migrations, reverse-geocoding, and data science workflows, custom ETL pipelines using AWS lambda functions, incremental pipeline for Trust & Safety Department
• NRT reporting using Snowflake, DBT and Tableau deployed in Gitlab

• Worked in conjunction with Winter Genomics and John Hopkins University teams to consult and re-write RNA-Seq bash scripting pipeline, utilizing newer technologies such as Nextflow and Docker
• Pipeline was built to be deployable and extensible in multiple cluster environments while retaining consistent dependencies for versioning and reproducibility, and deploying the genomics scripts written in shell, python and R scripting

• Member of the Analytics department, responsible for building infrastructure, development, analytics, deployment, automation
• Built distributed analytics computation engines in Apache Spark for on demand data delivery
• Developed and maintained cloud analytics container system for ETL ingestion using Docker-Luigi-Spark-AWS-S3 framework
• Consulted with internal departments and key partners about user base, new products, features, and services to better leverage data sources to guide business intelligence decisions and improve customer engagement
• Developed automated reports and dashboards for internal departments, reading from AWS S3 into R Products such as modular RShiny dashboards

• Continuing the work from my internship, working on creating an automated dockerized somatic load plotting system for the production of report quality charts and figures, operating within the luigi distributed system
• Developed two additional pipelines to access firebrowse significantly mutated gene data and copy number variation data for ingestion into the HLI datalake Ongoing R&D: algorithm development of a mutation signature extractor that uses COSMIC standardized signatures as reference to determine active signature representation
• Specialized in Oncology, Breast Cancer using tools such as Luigi, Apache Spark, Apache Hive, Python, Docker

• Worked in conjunction with the Bioinformatics Oncology team, led by Wayne Delport, to develop a new annotation pipeline, designed within the existing framework, to connect clinical data with cancer sequencing data from the GDC, in accordance with Human Longevity Inc. development and coding practices
• Within the existing architecture, external data is fed in, annotated, standardized and stored using various technologies such as AWS ec2 and s3
• Following this data pull, information is connected to develop high confidence cancer signatures and tumor profiles.

• Schedule weekly lessons with students who need help with levels of math from algebra to calculus, as well as some physics
• Coordinate sessions with about 5 students a week for 1 hour each, with personally designed lesson plans according to class and course content. Travel to and from student homes independently.

• Working in congruence with Dr. Giridharan Ramsingh and bioinformatician Tim Triche to analyze and understand the changes in DNA methylated regions in relation to aging and the development of cancer
• Developing BaseSpace applications intended to expedite genome alignment, sequencing, analysis, and visualization for the benefit of the academic and research community
• Utilizing the bioinformatics online community such as BioConductor and Github, and shell scripting, R scripting and analysis, python and Linux environment development

• Under the guidance of PI Sheree Schrager, assisted doctors and other investigators to formulate and execute the mathematical and statistical analyses necessary for the progress and publishing of scientific research papers
• Under own independent study, learned a great deal about statistical analysis techniques and the work-flow involved in grant funded research in a clinical setting
• Research focus was on the relationship between the endocrine system in young children with middlesex or intersex diagnosis, gender dysphoria, and developmental differences related to gendered sexual characteristics
• Main project was to use facial mapping software to better understand and diagnose hormonal imbalances in young children through facial markers