About

Aravindkumar Mohan is a seasoned data engineer with over 10 years of experience in data warehousing and business intelligence. He has hands-on experience in large-scale, massively parallel processing, distributed, and highly available database systems. Aravindkumar has an in-depth understanding of data mining and machine learning algorithms, including decision trees, clustering, association, and classification rules. He has a strong understanding of statistical concepts and hands-on programming experience in SAS, R, and SQL. Aravindkumar has built numerous data solutions for some of the top-tier internet companies, including eBay Inc, PayPal, Amazon, and HomeAway.com. His specialties include SQL, PL/SQL, Hadoop, HBase, Hive, Informatica, Amazon Redshift, Teradata, Oracle, MS SQL Server, Vertica, Kinesis Firehose, Unix shell scripting, PERL, Microstrategy, database tuning and optimization, and dimensional modeling. Currently, Aravindkumar is working as a Data Engineer at Amazon. He works with cross-functional teams in bringing data from IIOT devices, such as sensors, conveyors, material handling equipment, robots, and work cells, into Redshift in near-real-time using Kinesis Firehose. He creates tables and schemas in Redshift for easy querying that scales at Amazon level. Aravindkumar generates daily and near-real-time reports on the performance of Amazon fulfillment center as a whole and at individual workstation levels. He sets up monitoring and alerting for Redshift clusters and data quality. Aravindkumar communicates and works with technical product managers, fulfillment center operations managers in gathering requirements for additional performance improvement metrics. He also assists end-users with ad-hoc data requests. Aravindkumar's past experience includes working as a Senior Data Warehouse Developer at HomeAway.com and a Senior Software Engineer and Subject Matter Expert (SME) - Enterprise Data Warehouse at PayPal. He has a Master of Science (MS) degree in Applied Statistics from Penn State University, an M.Sc degree in Materials Science from the College of Engineering, Guindy, and a B.Sc degree in Physics from the University of Madras. Aravindkumar's tech stack includes Data Engineering, SQL, Hadoop, Snowflake, Search, Data Warehouse, Machine Learning, ETL, Apache Hive, Data Scientist, Research Scientist, Kafka, Software Engineer, Neural Networks, and more. Aravindkumar has 15.79