Data Analyst, Industrial Engineering, Excel, SQL, Tableau

M SURIYA RAM

+91-944******* ***********@*****.*** https://www.linkedin.com/in/suriya-ram-mohan/

SUMMARY

Mechanical Engineering graduate from SRMIST, Kattankulathur seeking full time job opportunities/internships.

EDUCATION

Bachelor of Technology, SRMIST, Kattankulathur June 2020 Mechanical Engineering 88.27%

Class XII, PSBB, KK Nagar 92.2%- May 2016

Class X, PSBB, KK Nagar CGPA: 10/10- May 2014

SKILLSET AND TOOLS

SQL, Tableau, Microsoft Excel, Mode Analytics, Mixpanel Analytics,AutoCAD, SOLIDWORKS

ONLINE COURSES & CERTIFICATIONS

Learn SQL Basics for Data Science Specialization UC Davis, Coursera Platform

(Courses included: SQL for Data Science, Data Wrangling, Analysis and AB Testing with SQL, Distributed Computing with Spark SQL, SQL for Data Science Capstone Project)

Tableau 2020 A-Z: Hands-On Tableau Training for Data Science Udemy Platform

Introduction to Data Analysis using Excel Rice University, Coursera Platform

Lean Six Sigma Yellow Belt Certification Binghamton University Certified SOLIDWORKS Associate (CSWA) Dassault Systemes

WORK EXPERIENCE

Data Analyst Intern – FreightBro July 2020- Present

• Conducted analyses on the data obtained pertaining to the portal usage (captured via Mixpanel Analytics platform) and derived insights as to how customer activity in the platform can be retained throughout the entire shipment booking process.

• Worked in the rate card management team and was responsible for ensuring that the rates obtained from numerous freight forwarders are properly entered and uploaded in the portal using Excel.

• Worked on the SOPs (Standard Operating Procedures) of various documents and streamlined the content in such a way that a newcomer can understand how to process each of the different rate cards.

ACADEMIC PROJECTS AND PUBLICATIONS

Investigation of toolpath parameters during slot milling on AISI D3 Steel Dec 2019- May 2020

• The slot milling operations on AISI D3 Steel were carried out on 4 different toolpaths- namely trochoidal, quasi- trochoidal, zig and zig-zag type toolpaths.

• The values of surface roughnesses (Ra, Rz, Rq), skewness, kurtosis, cutting forces (Fx, Fy, Fz), specific cutting energy, cycle time, tool nose radius deviation, chip morphology were all obtained.

• Data Analysis and scientific study were done with these values. Histograms and bar graphs were plotted to determine the most effective toolpath (Zig-Zag) out of the 4 depending on the industry requirements.

Optimization of Process Parameters during Slot Milling on Magnesium Alloy- AZ31 using Artificial Neural Networks July 2019- Nov 2019

• Face Milling of AZ31 Magnesium alloy was carried out and successfully optimized for surface roughness and tool nose radius deviation.

• ANN was used to develop a predictive model and genetic algorithm was used to optimize the input parameters, which were namely cutting speed, feed rate and depth of cut. Most influencing input parameter was also found via ANN.

Physical and Metallurgical Behaviour of Aluminium Hybrid Composites Jan 2019- May 2019

• Prepared 4 samples of aluminium hybrid composites consisting of aluminium, flyash and, graphene with varying compositions of aluminium and graphene in each sample using the powder metallurgy technique.

• Microstructure analysis, SEM analysis, XRD analysis and hardness tests were carried out on samples. The sample with the highest strength was identified.

The effect of Magnesium Addition in microhardness and thermal conductivity of Aluminium Alloy

– Journal of Advanced Research in Dynamical and Control Systems, issue 18, PP 1937-1944, 2017 Sept 2017

• 4 different samples of aluminium and magnesium of varying compositions were created by casting technique.

• Microhardness test was done to determine the hardness of the specimen. Microstructure analysis was performed on the 4 specimens. Temperature distribution test was carried to find out the thermal conductivity of each sample.

• Al+ 10 percent Mg was found to have the maximum hardness and thermal conductivity.

INDUSTRIAL TRAININGS

NTPC Tamilnadu Energy Company Limited, Vallur - Internship June 2018

• On-site internship. Learned about the various cycles involved in a thermal power plant like the Rankine Cycle.

• Visited and studied all the sections of a coal based thermal power plant including the boiler, coal-handling facility, ash-handling plant, cooling towers and turbines.

Avant Garde Engineers and Consultants, Chennai – Internship December 2018

• On-site internship. Learned about coal based and bagasse based thermal power plants.

• Gained in-depth knowledge about designing a boiler according to various customer requirements like output power generation, costs and type of fuel used.

Diamond Engineering Chennai Private Limited – Internship June 2019

• On-site internship. Learned about multiple manufacturing processes like milling, boring and welding that are involved in the fabrication of steel.

Contact this candidate