Andrew Schneider Email & Phone Number

East Amherst, Ny, Us

UNIVERSITY LEARNING SYSTEMS provides accredited continuing medical, pharmacy and nursing education with a focus on pharmacology training in live, live streamed remote and recorded online formats.

Chicago, Il, Us

Architecting and deploying a lake house. Mentoring development Conducting proof of concepts. Tech stack Databricks, FiveTran, Glue, Spark, Python, etc. Bronze, Silver, Gold ACID architecture. Support AI/ML team, as well as BI team. Self service establishment. Extensive use of Delta Live Tables to build pipelines. Integration with Collibra for meta data. Worked closely with CTO/CXO to establish strategic architecture and bring in vendors. Currently guiding application with hands on development. Ready to go back to architectural role now that project is successfully established.

Rochester, Ny, Us

Mentored junior AWS team converting custom “expert system” built in .Net and SQL Server to AWS Spark, Lambda, Redshift, Snowflake, etc.• Worked on multiple teams as a consultant prototyping new capabilities, documenting work, and handing off work others.• Examples: simulation of queuing delays using SymPy, introduction of AWS Deequ unit test framework for data quality, construction of rule engine using Python for analyzing AWS configuration, replacing problematic data indexing mechanism using S3 with Dynamo, advice on SCRUM practice.• Finished engagement after handing off rules engine.

Buffalo, Ny, Us

Helping OLTP shop to create a modern enterprise data capability. AWS, lambda, Glue, Athena, Docker, Kubernetes, Python, Mongo, Athena, Snowflake, Informatica, Datalake, Airflow. Supporting Data science team. Mentoring others on big data philosophy and approaches. Employment gap due to recovery from broken hip from accident.

Buffalo, Ny, Us

Responsible for ingestion of SCADA data from windfarms into a cleansed form ready for machine learning and physics based models. Transformed manual process that took weeks to perform to one that executes in near real time through the used of AWS lambda functions. Optimized current usage of Redshift for queries of large time series data sets though partioning. Formulated approach for dramatic reduction of query times by replacing time consuming load and query of a Redshift database with file based operations using S3 as the data lake and Athena SQL data consumers. Formulated reusable architecture while meeting tight delivery time frames. Mentoring technical team on big data concepts, and assisting them with the conversion of proof of concept code into a platform for internal and external customers. Mentoring the team about agile development with SCRUM. Defining vision for the platform product.

Reston, Va, Us

Senior position in guiding the conversion of an on premise Oracle based data warehouse product line to run in the cloud. Using Amazon Web Service, Pentaho, Vertica, Tableau. Processing JSON events from a message bus and translating the data for operational and analytical reporting. Predictive Analytics with R. MEAN Web Technology (Mongo, Express, Angular, NodeJS).

Mount Laurel, Nj, Us

Worked at firm that processed TBs of data daily from major wireless carriers such as ATT, Verizon, Sprint, TMobile etc. Learned issues involved with extremely high velocity and volume big data processing on MPP database systems. Accomplishments while at Ventraq:• Came up to speed on Netezza MPP database technology• Introduced Kimball Dimensional Data Mart with positive review from Kimball expert.• Converted Netezza application to Cloudera Hadoop.• Successful implementation of IBM Streams application for CDR processing• Introduced SCRUM development methodology• Formulated relationship with SUNY/Buffalo for predictive analytics for customer churn.

Reston, Virginia, Us

• Refactored a mission critical Ruby on Rails application that was implemented by an inexperienced team. Applying standard RoR doctrine, along with Behavior Driven Development. • Developed decision support applications for intelligence analysts that integrated information from enterprise data warehouses.• Mentored an world-wide team of developers in the use of Ruby on Rails Technology. .

Formerly the Chief Architect at EMSoftware Solutions. Responsible for setting overall technical direction for the SNAP product, managing and mentoring the R&D organization, leading technical sales efforts, and strategic planning. SNAP is a specialized application server aimed at the requirements of distributed command and control systems, and features facilities for creating common operating pictures. The SNAP tool implements a “Model Driven Architecture” recommended by the Object Management Group, resulting in the ability to create solutions with extraordinary productivity and reliability. Materially contributed to a major win with a Detroit automobile manufacturer with multi-million impact. Developed and executed a business plan for the application of the SNAP product to the Extensible Business Reporting Language (XBRL).

As technical lead was responsible a collaborative decision-making for the White House, NSC, using an agent based architecture implemented in Lisp. Lead in the commercialization of the R&D into a successful product based on C and Unix.Architected solutions complex distributed mission critical applications for over a dozen European customers primarily in the area of telecommunications and transportation management systems.As a product manager defined the requirements for the System Management Template.