Ruchi Rao Email & Phone Number

Houston, Texas, United States

Champaign, Illinois, United States

● Analyzed multiple data sets using SPSS including the Student Experience Survey and National College Health Assessment and created reports and data visualizations on the department usage/survey data● Performed statistical tests and analysis (t-test, ANOVA) to find correlations in NCHA student survey data to be presented to the UIUC Student Affairs department.

Champaign, Illinois, United States

● Created documents on Knowledge Base Tool for internal database of ACES containing data for resources and facilities● Developed Javascript methods to reduce the time for creation of articles by 50% through process automation

Bhopal, Madhya Pradesh, India

● Enhanced the UI/UX of retail Shopify website by adding interactivity and widgets using HTML and Liquid● Learned the concepts of Search Engine Optimization and worked on Google Ads to improve keyword search and search rank for the website

Pune, Maharashtra

Specialized in Big Data solutions for a US National Bank – Performed Data management, transformation and ETL activities in Agile environment for reporting through Tableau dashboards. Worked with the automated UCC-7 tool to orchestrate DAG-based scheduling for 105+ jobs. Primary owner of all ingestion related activities in the team.US National Bank - Portfolio Command Module• Aim was to assemble and monthly update an entire customer and merchant data set for commercial credit card… Show more Specialized in Big Data solutions for a US National Bank – Performed Data management, transformation and ETL activities in Agile environment for reporting through Tableau dashboards. Worked with the automated UCC-7 tool to orchestrate DAG-based scheduling for 105+ jobs. Primary owner of all ingestion related activities in the team.US National Bank - Portfolio Command Module• Aim was to assemble and monthly update an entire customer and merchant data set for commercial credit card universe of client which acted as input for Tableau dashboards.• Built data pipelines using PySpark and optimized storage by storing datasets in ORC and Parquet file formats• Performed data discovery, requirement analysis, design, development, unit testing and deployment for this project.• Managed end-to-end delivery to reduce the runtime of ETL pipelines by ~50% leading to seamless reporting• Received appreciation from leads, clients and product owners.US National Bank – Swift Account Tracking• Automated transactional reports in Hadoop for tracking activity of Swift accounts classified into different risk categories• Developed a Python script with Fuzzy Matching and Soundex function to extract data for similar customer names• Implemented a shell script to create multi-tab Excel report from custom created HTML-embedded Hive Query Language code• The automated reports were leveraged by FINCEN to reduce the search time and manual effort by 80%US National Bank – AML Sanctions Reporting• Automated real-time migration of huge volume tables of real-time oracle databases onto Hadoop through Sqoop incremental ingestion• Led a team for end-to-end delivery of the project and played key role in liaising with the client stakeholders across different stages of the engagement Show less

Bhopal, Madhya Pradesh, India

Master Of Science - Ms, Information Science/Studies, 3.7/4.0

Master Of Technology - Mtech, Computer Science, 8.0/10

Bachelor Of Engineering - Be, Computer Science

Activities and Societies: Environmental Club, Editorial Team