Jeff Linn Email & Phone Number

Chapel Hill, Nc, Us

Chapel Hill, Nc, Us

Bloomington, Illinois, Us

Work closely with data scientists and business experts to develop modeling solutions for various internal business partners.Build and maintain data pipelines for the development, implementation, execution, validation, monitoring, and improvement of data science solutions.Enable data driven decision making by applying data analytic techniques, and exploratory research and analysis.Understand data infrastructure needed to support data services and automation.Establish business domain knowledge for State Farm data sources.Investigate, recommend, and initiate acquisition of new data resources from internal and external data sources.Identify critical and emerging technologies, techniques, tools, data sources, and platforms in the data engineering field, including cloud-based solutions, that support and extend quantitative analytical solutions.

Architected an event-driven ETL cloud pipeline using AWS services to standardize and aggregate historical and real-time medical record data from multiple sources, improving value-based care decisions, unlocking newly identified physician cash savings.Engineered advanced data transformations using PySpark and SQL in AWS Glue, leveraging EC2, Postgres, Snowflake, Glue Catalog, EventBridge, Lambda, SNS, SQS, Slack, and developed CLI commands for deployment of all services to the cloud.Implemented event-based monitoring and real-time error observability to identify and resolve data divergence across environments, enhancing pipeline reliability. Reduced costs by 32% directly related to improved optimizations and maintenance.Eliminated 500 annual hours of manual work by automating repetitive Analytics tasks.Streamlined data ownership among the teams with Slack alerts via SNS for real-time observability of anomaly events in the pipeline.Collaborated in CI/CD code development in Agile team environment using VS Code, Git, Jira, Confluence, Docker, Jupyter Notebooks, Datadog, BitBucket.Ensured HIPAA-compliant data governance in storage and pipeline environments.Worked closely with DevOps to design secure RBAC (Role-Based Access Control) IAM policies around Data Lake and AWS pipeline services.Supplemented cross-functional UI application development team in creating javascript, TypeORM backend API’s to push new features into production 20% faster.Created Snowflake databases, schemas and tables, and migrated data from Postgres to Snowflake using aws_s3 extension, S3, Snowflake external stages, SQL and Python.

Owner of 16 Apartment Units in Ohio. Realized the full lifecycle and ~30% ROI. Utilized previous years of real estate experience and knowledge to research housing markets and identify target properties. Successfully engaged capital investors, brokers, and onsite managers. Oversight of transaction coordination to complete purchasing and ongoing management.

Jacksonville, Florida, Us

Engineered a data ETL solution for analyzing global air quality from public API, integrating AWS Lambda, Kinesis, Glue, Databricks, Redshift, and QuickSight for comprehensive data processing and visualization.Cleaned and pre-processed data with SQL, Python and Pandas in Databricks, improving data accuracy and quality with medallion storage architecture and into snowflake schema.Developed an ETL pipeline for migrating on-premises data to AWS, optimizing Spark clusters, and implementing a star schema for improved OLAP performance.Designed a Data Lake and Warehouse for processing U.S. Customs data, optimizing Postgres with partitioning and indexing, and leveraging AWS services for scalability. Provided cost breakdown report as a proof of concept proposal for AWS cloud services.Implemented network security for Azure resources, including firewalls, security groups, bastion hosts, and public/private subnets. Designed and implemented a zone-redundant web server for static website in company intranet, incorporating load balancing and auto-scaling to ensure reliability.Configured user permissions for website administrators to manage Azure resources securely. Using Azure Active Directory, created users and groups with least privileged access for administrators and developers maintaining the intranet.Optimized traffic flow with a load balancer to distribute incoming traffic across replicated servers within a scale set. Designed a hub-and-spoke network architecture using Microsoft Azure and Palo Alto Next-Generation Firewalls with application filters, groups, and tags to ensure proper traffic routing across the network.

Compliance Scoring System: Developed a unique Google-Sheets system for legal State compliance, achieving record quality improvements in risk reduction.Predictive Model: Created an advanced Excel dashboard adopted by senior management in decision-making on expenditures, compliance risk, tenancy risks, and asset performance.Personnel Management: Successfully led diverse groups of over 15 personnel and apartment buildings towards common objectives, maximizing property performance and tax-credit compliance.Asset Management: Responsible for financial growth, filing compliance with the State, and physical property integrity to reach client goals.

Madison, Nj, Us

Mclean, Virginia, Us

Bachelor Of Science - Bs, Computer Software Engineering

Bachelor Of Arts - Ba, Psychology