Aaron R Email & Phone Number

agile development, alation, ansible, apache nifi, apache web server, apache activemq, apache spark, ataccama, aws cloud, aws ec2 linux, aws s3, aws lambda, bash scripting, big data, confluence, dataiku, deployments, disaster recovery, dev ops, docker, encryption, enterprise directory ldap, elt, enterprise-level network systems administration, etl, hadoop, high availability, ibm aix unix, ibm datastage, ibm db2, ibm gpfs, ibm igc, ibm watson, identity access management, information security, ingestion, java, javascript, jenkins, json, kubernetes, lenses, mettleci, ms office 365, ms sharepoint, ms teams, oracle, platform architecture, production, productionalization, python automation, red hat linux, resilient distributed dataset (rdd), sailpoint identityiq, sap business objects, sap sas, sap sas grid, scrum development, service now, shell scripting, snowflake, sql, tableau, windows active directory, windows server, xml, yaml

- Partnered with a Cincinnati and Northern Kentucky regional ODOT urban planning contracting company.- Analyzed relational-based traffic data from cellular traffic monitors to identify problematic traffic devices, and predicted future traffic device faults.- Leveraged: - python: machine learning , Convolutional Neural Network (CNN) - sql: time-series relational data, advanced query writing - linux networking

Consult-to-Hire 6-month,​ (Layoff due to Coronavirus).- Project: Modernizing legacy data lakes and data warehouses into new AWS cloud platforms.- Solution to replace the legacy data lake and warehouse is expected to grow +$30B annual business by increasing data refresh frequency to streaming in real-time to provide real-time tracking of aviation component repair status.- Reverse engineer data workflows back to source databases, ERPs and numerous ingestion and ETL processes supporting legacy data warehouses which provide internal reporting and analytics to an external facing customer web portal while providing legacy data lineage and business logic.- Develop a system for documentation and maintenance of business logic underlying the legacy data warehouses that integrated the databases.- Pass Risk & Compliance scope approvals for a lift and shift of solutions to a newly designed AWS cloud-based platform.Processes used: Automation, Big Data, Business Intelligence, Cron Jobs, CRUD operations, Dashboards, Data Auditing/Mapping/Validating, Data Engineering, Data Extraction, Data Ingestion, Data Migration, Data Redundancy, Data Warehousing, ETL Operations, Infrastructure and Platform Design, Normalization/Denormalization, CI/CD Project Management (Agile, Kanban, Scrum), Reporting, Stored Procedure Engineering, System IntegrationTools used: Linux/UNIX Bash Scripts, Git, HVR, Hadoop, Informatica, Java, JavaScript, PySpark, Python, Spark, Talend, Alation, DBeaver, SAP S4HANA/ABAP, Oracle SQL DeveloperAWS Tools​ used: API Gateway, Aurora, Cloud9, CloudSearch, CloudWatch, CodeCommit, Command Line Interface, Database Migration Service, DynamoDB, EC2 Linux, Elastic Container Service, Elastic Beanstalk, Glue, Kafka, Kinesis, Lambda, Redshift, S3 Buckets, SNS & SQS for messaging integration for Streaming Data, VPC, X-Ray.Databases used: SQL (AWS Aurora, AWS RDS, AWS RedShift, Microsoft SQL (T-SQL) MySQL, Oracle (PL/SQL), PostgreSQL), NoSQL (AWS Dynamo DB, MongoDB).

- Supported the development of business strategy and plan, articles of incorporation, and team structure.- Development of mobile application, platform, and data infrastructure for upcoming product launch, all within AWS cloud. - Research and test machine learning models to apply regression analysis of longevity and profitability, on more than 80k Ohio oil wells. - Develop API and other processes on AWS new server-less platforms (Lambda) and docker images for improved application functionality.

Continued Data Science classroom instruction with supplemental internship at newly founded startup company founded by Case Western Reserve University Professor. - Researched and tested advanced statistical analysis methods. - Designed, deployed, and maintained data processing environment and data scraper on AWS (EC2 Linux, RDS: MySQL, and MongoDB) for application development.

- Provided flexible and cost-effective IT services and 24/7 support for several small and medium sized businesses. - Custom-tailored IT network infrastructures within clients' budgets and needs. - Continuously monitored, fixed, and proactively maintained file servers, databases, workstations, network hardware, and telephony hardware and services. - Extracted CRM data and developed a customized google map for a certain client. - Developed an automated process using Python for a certain client with an Outlook email problem, saving dozens of hours every week for e-mail management.- Performed Microsoft SQL database migration and upgrade for an ERP system.

Cleveland, Ohio, Us

- Developed and implemented remote technologies for entire UH Radiology Scheduling Department and network (45 sites). - Designed a paperless digital fax management system for UH Central Radiology Scheduling Department. - Created end-user and administration documentation for the new systems and processes, and instructed training classes for employees.

- Organized and managed digital and paper marketing promotional advertising campaigns for music venue events.- Increased revenue and attendance numbers for venue by increasing advertising reach.- Tracked and evaluated marketing approaches for continual refinement and implementation.- Organized teams and coached members to fulfill marketing and promotional goals.

Tutored students in:- Algebra- Biology- Calculus- Chemistry- Economics- Physics- Statistics

Columbus, Ohio, Us

- Assisted students by creating and distributing study materials.- Created digital microscope slides for PowerPoint presentations and study guides.- Hosted group study sessions and collaborated with students to achieve better understanding of subject.

Columbus, Ohio, Us

- Investigated the synthesis and efficacy of Sodium Borohydride reducing agents for principal investigator. - Explored the cost-benefit analysis of synthesis for large scale commercial production.- Maintained lab experiment procedures and standards for principal investigators. - Collected data and recorded observations for data analysis and publication.

Data Analytics And Data Science

Bachelor Of Science (B.S.), Biology, Pre-Medicine, Biochemistry