RANJIT SREYUS ANANDHAVALLI VETRIVEL

**** ********* ****, *** ****, Dallas, Texas 75252

Email adyufu@r.postjobfree.com Mobile 716-***-****

LinkedIn linkedin.com/in/ranjit-sreyus GitHub github.com/avrsreyus EDUCATION

Master of Science in Management Information Systems Aug 2022 – June 2023 University at Buffalo, The State University of New York GPA: 3.97/4.00 Featured Coursework: Predictive Analytics, Data Visualization for Business, Online Analytical Processing, Database Management Systems, Statistical Analysis, Experiential IT Projects, Web Analytics for E-Commerce, Digital Product Management Bachelor of Technology in Electronics and Communications Engineering Jul 2015 - May 2019 SRM Institute of Science and Technology, India GPA: 8.3/10.00 TECHNICAL SKILLS

Languages: Python, Java, Matlab, C, VBA Data Visualization: Tableau, Matplotlib, Excel, PowerBI Machine Learning: Scikit-learn, Numpy, Pandas Database Technologies: PostgreSQL, MySQL, Oracle Live SQL Deep Learning: TensorFlow, Keras Project Management: ServiceNow, JIRA, MS Office Other Skills: Verilog, VHDL, Powershell

EXPERIENCE

PROJECT ENGINEER, WIPRO LIMITED, Chennai, India Jul 2019 - Aug 2022

● Extensive experience in conducting analysis on ServiceNow ITSM reports, identifying trends and areas for improvement, resulting in a 10% reduction in unfulfilled requests and a 15% increase in customer satisfaction

● Led a team from project initiation to oversee Identity and Access Management systems for a newly acquired healthcare client account, analyzing data to improve team productivity by 30% while streamlining Standard Operating Procedures

(SOPs)

● Delivered data-driven insights on audit and SOC metrics using advanced analytical SQL queries, and created dashboards using Tableau to minimize access-related disruptions

● Automated the access provisioning and de-provisioning processes on Active Directory using Python and PowerShell scripts, resulting in a 25% reduction in processing time

● Collaborated cross-functionally with technical teams as an SME in communicating the business processes for developing a Natural Language Processing model that used data from user tickets to minimize user issues and downtime

● Analyzed audit data on user access rights and permissions, ensuring compliance with company policies for preventing unauthorized access to critical systems. This resulted in a 20% reduction in access-related incidents and a 15% improvement in the average ticket resolution time

DATA ANALYST, THIRD ESTATE ANALYTICS, Buffalo, New York Feb 2023 - May 2023

● Completed experiential IT project at Third Estate Analytics as part of university coursework, gaining hands-on experience in data profiling, modelling, data analysis, data preprocessing, and machine learning

● Conducted comprehensive data gathering and preprocessing of Buffalo's housing data, optimizing its quality for analyzing the compliance of short-term rentals

● Employed machine learning techniques, including logistic regression, K-NN, decision trees, and neural networks, to accurately classify houses into Owned, Rented, Short-term rental, and Illegal categories. Achieved an accuracy of 87% with the decision tree model

PROJECTS

ENTERPRISE DATA WAREHOUSE DESIGN (Data Management) Oct 2022 - Dec 2022

● Developed and implemented an end-to-end Online Analytical Processing (OLAP) system for a small-sized company as an analytical solution

● Deployed a data warehouse using SQL Server by building an ETL pipeline using Azure Data Factory, created analytical queries and visualizations with PowerBI to derive insights DATABASE DESIGN AND EXPLORATORY DATA ANAYSIS (Database Management) Oct 2022 - Nov 2022

● Designed a robust database schema using Oracle Live SQL, leveraging the knowledge of ER diagrams and data modeling techniques to create an efficient and scalable database solution

● Created optimized tables and utilized complex SQL queries to extract key insights, which informed data visualizations (EDA) and reporting using Tableau

ACHIEVEMENTS AND EXTRA-CURRICULARS

● Certifications: Azure DP-900, Deep Learning specialization - DeepLearning.AI, Machine Learning course - Stanford University

● Yoga Club Member - Participated in the university’s yoga club, practicing and promoting the physical and mental health benefits of yoga. Member of Directorate of Student Affairs: Actively participated in the university's discipline committee

Contact this candidate