Simon Ioffe

Solution Architect | Product Manager | Data Scientist | Tech Manager

About Me

Creative Technical Problem Solver with a Passion for Cloud, Data Science, and his Customers

An experienced professional with extensive expertise in cloud, SaaS, databases, integrations, data science, and machine learning, I am passionate about solving the intersection of technical and business problems. With years of experience working across multiple industries, from healthcare to MarTech, I am skilled at Python, JavaScript, and SQL, with the ability to creatively solve both business and technical problems.

Personal Info

  • Email : smnioffe@gmail.com
  • Phone : (781) 572-7467
  • Location : Boston, Massachusetts

My Expertise

Technical Pre-Sales

I am passionate about empathetically learning about customer's challenges and partnering with them to present the right solution. I excel at presenting and building out demos and integrations across a variety of industries to diverse audiences, both technical and non-technical audiences, including C-Suite executives and Fortune 500 companies.

Product Management

As a technical product manager, I bring an agile and process-oriented approach to managing platform, web, and internal tooling. My expertise in leading cross-functional teams has helped me drive both successful new product launches as well as evolving complicated existing products.

Data Science

My passion for data and technical skills enable me to create and integrate complex data sets and build modern cloud ML stacks. I have experience creating machine learning models and developing architecture plans to help organizations make data-driven decisions.

Technical Team Management

In addition to being a strong individual contributor, I have experience managing teams and unlocking their full potential. I help individuals develop their careers by encouraging their passions and motivating them to achieve their goals.

My Resume

Experience

Pre-Sales Solutions Architect

April 2022 - February 2023

  • Utilized SQL/Presto/Hive, ML solutions, Kafka, Snowflake, JavaScript, Python, API’s/Integrations, and workflow automation to deliver technical demonstrations.
  • Lead presentations, product demos and provided technical consultations to prospects, helping to understand their needs and the capabilities and benefits of the software.
  • Answered RFPs and conducted product development discussions, providing feedback and insights on customer needs and trends.
Machine Learning Solution Architect

2020 - 2022

  • Established the architecture, technical specifications and oversaw the implementation of complex, custom, cloud-based (GCP) machine learning solutions.
  • Counseled customers as the lead technical product and machine learning expert to meet and exceed client business needs.
  • Set priorities based on project requirements and serve as a technical escalation point to developer, ML, QA, DevOps, and support teams.
Arcadia.io
Product Manager

2019 - 2020

  • Owned and oversaw the execution of a platform to automate, scale and provide monitoring to support and aid implementation of Arcadia’s software and the integration & ETL of 1000s of data sources.
  • Managed the backlog and work queue & sprints for the platform back-end team and web team.

Technical Implementation Team Manager

2017- 2019

  • Managed twelve employees across two technical product implementation teams.
  • Developed a full-stack set of applications to monitor real time operational metrics across the organization using D3, Python, SQL, Node.js and multiple APIs.
  • Chosen to be on an executive SWAT team to fully revamp and redevelop the implementation process within AWS, leveraging Spark, machine learning algorithms and a redesigned lean process workflow.

Solutions Architect

2015 - 2017

  • Led client engagements to capture requirements, articulate Arcadia's technology capabilities, and devise customized architectural plans, ensuring alignment with clients' strategic objectives and successful product implementation.
  • Established technical requirements and oversaw their completion across multiple teams.
  • Created a predictive model to predict the likelihood of a patient being a no-show to a scheduled doctors appointment based on dozens of data points.

Senior Consultant

2013 - 2015

  • Served as the tech lead onsite for a major insurance client at the onset of the HealthCare.gov integration and enrollment reconciliation.

Consultant

2012 - 2013

  • Worked to integrate and analyze data from multiple clients connecting to an array of EHR (Electronic Health Record System) and Health Plan data sources.
  • Lead the UX/UI effort for the creation of a large custom enterprise application.

Education

Northeastern University

B.S. Industrial Engineering

General Assembly

Data Science 

 Boston, MA


Visual Design

Boston, MA

Technical Skills

Coding
Python
JavaScript
SQL
D3.js
Node.js
jQuery
HTML/CSS
Cloud
AWS
GCP
Azure
Database
SQL Server
BigQuery
Presto
Snowflake
Postgres
Redis
Misc
Message Queue/Streaming
Docker
pySpark
Pandas
Jupyter
Git
Scikit-learn
Jira
API's/Integrations
Jenkins

Patent

Automated Splitting of Document Packages and Identification of Relevant Documents
Patent Pending — Filed Apr 29, 2022
Co-author — 17/733,581

Employee of Year

2016 Arcadia Analytics Award

Enterprise Clients

Experienced presenting to and working with large companies

6σ

Six Sigma

Six Sigma Yellow Belt

My Areas of Focus

SaaS Software

Over 10 years experience with selling, implementation and supporting SaaS software across multiple industries. I am specifically experienced with cloud software which focuses on data integration, transformation and analytics. Treasure Data's CDP and Arcadia's Analytics platforms are two prominent examples.

Product Management

Experience with Agile methodologies (Scrum, Kanban), grooming and planning backlogs. Experienced as a Jira Admin, creating, managing and supporting project workflows. My technical experience is a large asset in communicating with and gaining the trust of engineers. I have experience serving as product owner for platform, web, as well as internal automation and telemetry products.

Machine Learning

Have developed my own predictive models, as well as created architectural plan to support larger production machine learning stacks. At Iron Mountain, my team and I received a patent for an document splitting and identification model that we developed for our large lender clients. At Arcadia, while using clinical, claims, and demographic data I built a predictive model to predict how likely a patient would be a "No Show" to their doctor appointment.

Database Expertise

Extremely experienced with creating, managing and architecting databases. Very strong SQL skills and have created very complicated queries, stored procedures as well as integrations via APIs to external systems. Both SQL and NoSQL databases. Have conducted data model designs, database development standards, implementation and management of data warehouses and data analytics systems.

Cloud Tech

Have worked across AWS, Azure and GCP. And have years of experience using and architecting cloud services and software. Have used cloud data products like Snowflake, Databricks, Splunk and Elastic. Have experience using and coming up with architecture using streaming services like SNS, Pub/Sub, Kafka. Also have experience with both serverless services like Lambda, as well as VMs and containers in the cloud.

Business Minded

Have worked across several industries (Healthcare, Insurance, Consumer, Pharma, etc.). Presented to C-Suites. Have accrued years of client-facing experience, starting with onsite weekly consulting earlier my career. I enjoy learning about businesses and industry trends, and even outside of work I stay up to date on business, tech news and review quarterly earnings reports of public companies I follow.

Process Focused

As an Industrial Engineer by training, I have a mind for process improvement, efficiency and using data to make business decisions. I am Six Sigma certified and a strong believer in measuring outcomes to learn and make better informed business decisions from.

Full Stack

Have written full stack applications using Python, Node, JavaScript and SQL as well as integrating data from numerous external systems via APIs, message queues, ETLs and webhooks. Am familiar with a lot of common JavaScript libraries like jQuery, Bootstrap, Angular, D3.

Data Visualization

Experienced with creating custom, and sometimes interactive, javascript visualizations using D3. Additionally have created dashboards and models with Sisense, QuickSight, Tableau, PowerBI, Qlik. You can view some examples here. I am also proficient with Adobe Illustrator, Photoshop and Xd.

My Portfolio

Download free bootstrap 4 admin dashboard, free boootstrap 4 templates
Database Job Monitoring

A real time database job monitoring dashboard I created, using D3 in the front end, Node.js and SQL Server in the back-end.

Download free bootstrap 4 admin dashboard, free boootstrap 4 templates
ETL Timeline Telemetry

A real time database job monitoring dashboard I created, using D3 in the front end, Node.js, Python and SQL Server in the back-end.

DQA Scorecard
Data Quality Scorecard

Interactive set of D3 dashboards that in real time read a set of flat files from S3, and turned them into a set of charts making the output much easier to understood. I built the full webapp using a Node Express server, Python for data integration and transformation and D3 and other JavaScript libraries for the front end.

DQA Scorecard
Data Quality Scorecard

Interactive set of D3 dashboards that in real time read a set of flat files from S3, and turned them into a set of charts making the output much easier to understood. I built the full webapp using a Node Express server, Python for data integration and transformation and D3 and other JavaScript libraries for the front end.

DQA Scorecard
Data Quality Scorecard

Interactive set of D3 dashboards that in real time read a set of flat files from S3, and turned them into a set of charts making the output much easier to understood. Built using a Node Express server, Python for data integration and transformation and D3 and other JavaScript libraries for the front end.

Work Estimator
Workflow Capacity Planner

Interactive work scheduling application I developed using a myriad of data sources including a python JIRA API integration, as well as data collected from database, and logs & files from AWS.

Stock Dashboard
Near Real Time Stock Dashboard

Using a GCP cloud function, running a python script to obtain latest stock data from yahoo finance API for a set of stocks on my stock watchlist. The output is displayed in realtime, in a custom chart made using D3.

Burgers and Fries
Infographic Using Public Data

Infographic for a poster used at a conference, made in D3 and Adobe Illustrator, using publicly available data. Read more here: https://arcadia.io/resources/burgers-and-fries

Download free bootstrap 4 admin dashboard, free boootstrap 4 templates
Appointment No Show Model

The model was made to predict “No Shows” from clinical & claims data. “No Shows” are appointments which a patient makes, but doesn’t show up for, cancel or reschedule prior

Download free bootstrap 4 admin dashboard, free boootstrap 4 templates
Benefits of Predicting No Shows

Target outreach, additional appointment reminders or other services like at home visits, transportation or assistance from social workers Target the cross section of likely “No-Shows” & High-Risk patients

Download free bootstrap 4 admin dashboard, free boootstrap 4 templates
Past Behavior

For each appointment, the status of the previous appointment (Kept, No-show, etc.) was obtained along with number of previous appointments, and the patients trailing appointment behavior (ex. 25% cancelled, 25% no show, 50% kept)

Download free bootstrap 4 admin dashboard, free boootstrap 4 templates
Getting the Data

The first step was to obtain data for each appointment for a given time and relative information like time of day, when the appointment was made, etc.

Download free bootstrap 4 admin dashboard, free boootstrap 4 templates
Demographics

The next step was to obtain patient demographics such as age, gender as well as patient chronic conditions and past diagnoses

Download free bootstrap 4 admin dashboard, free boootstrap 4 templates
Distance to Appointment

Created Python script which used the Google Maps API to retrieve coordinated for each location, based on the practice name Found a lookup table to map patients ZIP codes to coordinates and used Haversine formula to find distance between the two sets of coordinates

Download free bootstrap 4 admin dashboard, free boootstrap 4 templates
Income

Used publicly available income information to approximate income by patient zip code

Download free bootstrap 4 admin dashboard, free boootstrap 4 templates
Provider Specialty

Grouped several categories and select the top reasons and specialties as features

Download free bootstrap 4 admin dashboard, free boootstrap 4 templates
Tuning The Model

Used Python and SQL to transform nominal features (ethnicity, gender, etc.) into binary features (ex: female: 1/0; male: 1/0). The features were normalized to have the same initial weight.

Download free bootstrap 4 admin dashboard, free boootstrap 4 templates
Selecting The Model

Using different hyperparameter as well as models to choose best model and parameters. Evaluated: Decision Tree vs K Nearest Neighbor vs Random Forrest vs Ridge Classifier vs Logistic Regression

Get in touch

Phone :
(781) 572-7467
Location :
Boston, Massachusetts
Email :
smnioffe@gmail.com