Andrew Schell Email & Phone Number

Kirkland, WA, US

Seattle, WA, US

Develop and Implement BI Strategy, and GTM Strategy, Performance Monitoring, Market Analysis, Investment Analytics, Cross-Department Collaboration, Mentorship and Training, Reporting to Leadership, Scalability Planning, Automation of Reporting Processes

Seattle, WA, US

Supporting existing startups on our floor, mentoring new startup founders with Data Science, Data Engineering, Annual Recurring Revenue (ARR)Creating a prepared space to support over 1,000 corporate summits, offsite and networking events.

• A volunteer group of experienced data scientists, and engineers dedicated to exploring Python-based programming knowledge, conducting hackathons, code reviews, and skill growth, while embracing new and experienced.
• Increased new member re-attendance from 2 in 5 to 3 in 5 or +31% by encouraging their individual contributions
• Upskilling use of algorithms, teaching best practices, and working to flatten the learning curve as a data science mentor.

Portland, OR, US

• Engineered ETL funnel pipeline connecting offices to a central database across enterprise for multi cloud architecture.
• Migrated years of data from CRM, Marketing, Sales, Scheduling, Billing and Tax into a unified architecture with backup.
• Wrote initial AWS Glacier data backup pipeline, to support Google Analytics, GCP Big Query and ZOHO CRM.
• Weekly report to Marketing Director and CEO to provide automated agile, or waterfall dashboard updates.

• My implementation of Natural Language Processing (NLP) and Bidirectional Encoder Representations from Transforms (BERT) to problem solve inefficiencies in the $700B global recruiting market. Our Machine Learning.
• Wrote backend script to automate 24.8 hour per month or 62% of the recruiting process with 91.8% resume data accuracy with BERT NLP.
• Optimized AWS pipeline, with the potential to save $146,000, and managed a team of five with weekly virtual standups.
• Collaborated with 23 HRTech CEOs with the potential to develop $116M in new revenue channels based on interview data.

Olympia, Washington, US

• The Puget Sound Historical Archives preserves original documents from the 1850’s for viewing and research in a secure temperature-controlled vault. White gloved staff handle delicate documents for copies, and for.
• Improved archivist physical records retrieval speed, saving 3 hours week with more efficient document research and retrieval as a student intern.
• I researched computer vision and NLP architecture to digitize historical documents for online access of documents.

• Consulted with business owners in Finance, Medical and Legal practices to help big data tools for small to midsize companies who don’t have the budget or need for a full-time machine learning engineer or data scientist.
• Created data ETL pipeline to automate SQL cleaning and wrote HR analytics that reduced employee turnover by 44% by aligning sales with user demographics.
• Rewrote backend analytics system to automate Google Analytics, saving 9 hours a week of data preparation.
• Partnered with business owners to reduce layoffs by 41% and improved retention by 203% with data-driven metrics.

• LSBio provides high-quality antibodies, proteins, biochemicals, ELISA and Assay kits to researchers worldwide. More recently LSBio has released their growing collections of Assay Kits and BioChemicals intended to.
• Wrote backend Python code reducing weekly update from 9 hours to 2 hours with unittest, pytest and CI/CD version control.
• Wrote clustering algorithm to clean and identify 91% of monoclonal and polyclonal antibodies, BioChemical and DNA markers via Supervised Learning based on NCBI and LSBio 23 year old SQL server database.
• Engineered ML pipeline for ELISA, Immunoassay, Protein, BioChemical, mono, and polyclonal antibody research.

New York, NY, US

• PSS is an innovative, multi-service nonprofit 501(c)(3) agency whose mission is to strengthen the capacity of older New Yorkers, their families, and communities to thrive. PSS has 70+ staff and 250+ volunteers to run.
• Built new Salesforce org and tested migration of 10,000+ HIPPA records with AWS cloud environment with Python scripting and Salesforce API saving $63,000.
• Streamlined patient data handling 148% by automating 3 hours of manual data handling with streamlined architecture in collaborating with IT, Nursing Staff and stakeholder collaboration while ensuring HIPAA patient data.

Cambridge, Massachusetts, US

• Counterfeit medicine is a dangerous, multi-billion-dollar problem that plagues patients, regulatory bodies, and the global health care industry. Fake anti-malarial and tuberculosis drugs alone account for over +790,000.
• Increased website engagement customer time series buying patterns, leading to a 312% increase in product use.
• Wrote an automated SQL script to reduce data errors from marketing attribution by 41% for Google Analytics data.
• Rectified gender attribution errors in Google Analytics and SQL database, eliminating 71% of marketing overspend.

Bloomington, IL, US

• Country Financial is a privately held insurance and financial services conglomerate with customers in 19 states and $3.19 billion in revenue. The group of companies offers a range of insurance and financial products.
• Improved sales "call to close" ratio from 32 sales per 100 calls to 84 per 100 or +262.5% with Reinforcement learning and multivariate underwriting risk model.
• Reduced annual client churn by 38% by improving targeting marketing and 188% increase in Net Promoter Score from 3.9 to 8.1 on 482 B2B/B2C accounts.

Edx Relational, Sql Databases

Bachelor Of Applied Science - Basc, Data Analytics

Data Science - Python