Alexis K. Email and Phone Number

Revealed inequities in lung cancer screening and potentially preventable deaths across 1000s of participants using analysis and decision tree modeling in RAnalyzed networks generated from over 100 survey questions of 45 community organizations for the effects of city wide public health programAnalyzed health and poverty data samples across dozens of subgroups and intersections to verify analysis and resultsIndependently created Python pipeline utilizing Beautiful Soup, Pandas for web scraping and transforming and cleaning commodity, insurance and other data from over 68 files with differing formats into agricultural public policy data visualization Visualized in R the prevalence and geospatial attributes of homelessness across Illinois utilizing American Community Survey and other public data sets

Led design, development and parallelization of real time streaming data serviceAutomated end-to-end data and dashboard pipelines for 15-minute update Service Level Agreement requirement, handling over 200 million dollars of real time donations and transactionsModeled and mastered semi-structured streaming data from multiple APIs and sources Analyzed election and non-profit fundraising ad campaign A-B testing resultsVisualized and summarized survey results, revenue and spending in dashboards using Pandas, SQL

Advised on outreach and digital strategy combining previous experiences volunteering with themCoordinated over 20 volunteers across different assignmentsDetected and resolved voter file data segmentation and quality issues in a dataset of over 10,000Redesigned website for multilingual COVID-19 relevant resources based on community feedback

Developed Hadoop/Spark enterprise framework built to automate deployment, configuration and integration of Hadoop technologies in AWS ecosystem.Constructed data mastering ELT multi-stage Java/Scala pipelines with Hive, Spark, SparkSQL, Talend on AWS EC2 cloud.Integrated and parallelized pipelines for 8 TB of data sources across 12 heterogeneous data sources, including flat files, into a new data lake. Created and executed cleansing and business logic test cases for data pipelines.Lead efforts to automate and integrate Junit tests for Hive, Spark.Enhanced user experience and backend for client facing Spring MVC JQuery based application.

Improved data quality and resolved data integration problems across over 20 domain tablesCoordinated code deployments and testing affecting over 6 departments directly Developed REST API on Java Spring framework for enterprise data serviceExpanded data services API in Java and assimilated them into enterprise SOAContributed to data model for new data sourcesImplemented features to match new business requirements on IBM data management platformUnit tested and integration tested SOAP and REST web services using mocksUtilized and extended upon Informatica functionality to accommodate integration of both traditional relational database sources and heterogeneous semi-structured sources like JSON flat files

Coordinated with other students and faculty to code different components of a program that handles agricultural map data in an Energy Resource Center projectWrote an asynchronous FTP crawler and automation scripts in Qt C++Automated satellite image data conversion with ArcGIS and image processing scripts

Collaborated with other students on an extensive chaotic systems research projectDeveloped methods of experimentation and analysis in nonlinear physically intelligent type systemsApproximated nonlinear systems and optimized parameters using numerical methods for differential equations like Runge-Kutta