Data Analyst

Education

Aug **** – May **** California State University, Fullerton CGPA 4.0

• MS in Information Systems (Business Analytics) Coursework - Data Mining, Adv. Deterministic Models, Database Design, Marketing Analytics, Analytical Forecasting, Supply Chain Analytics and GIS. Big Data Analytics – including the concepts and the functions of big data tools like Hadoop (HDFS) and Spark. Jul 2008 – Apr 2012 Anna University, Chennai CGPA 3.2

• Bachelor of Engineering in Mechanical Engineering. Experience

Mihaylo College of Business & Economics, California State University, Fullerton. Aug 2017 – Dec 2017 Data Science Analyst (Graduate Research)

• Implemented NLP techniques, built neural network models using Keras & TensorFlow in Python.

• Performed data cleaning and data pre-processing on unstructured datasets with both quantitative and qualitative information in Python and R. And stored the data by creating RDBMS using advanced SQL.

• Designed data models using statistical modeling techniques in R and Excel. Data visualization using ggplot2 & Tableau. Created and presented the analysis reports in an interactive dashboard using Tableau. Tata Consultancy Services, Chennai, India.

May 2013 – Jul 2016 SC Data Analyst

• Designed data models for prediction of demand and scheduled optimized shipments in Python and Excel.

• Built and maintained a relational database management system (RDBMS) using advanced SQL.

• Performed data cleaning & pre-processing on multiple external raw datasets in Python integrated with MS SQL Server and stored them in the RDBMS. Performed data mining after extracting the processed data. Technologies Used: Python, Advanced SQL, Java, VBA Excel, Vlookups & Enterprise Data Warehouse. Nov 2012 – May 2013 Business Analyst

• Designed business process framework for CITI mobile banking application, from page level design to the overall process schema embracing the whole application. Performed feasibility, gap & competition analyses

• Customized the application with the user requirements across the continents including North America, Australia, and Poland during their regional deployment and have conducted agile scrum meetings.

• Written Business Requirement, Functional Requirement documents, User Stories and Market Research. Technologies Used: HP QC, ALM, RTC, Blueprint, JIRA, Rally and Agile & SCRUM methodologies. Projects

Determining Bias in US News Media (Politics) Using Neural Networks in Python: Built a backpropagation neural network model in python with Keras’ framework & TensorFlow’s backend to classify the bias of the articles. Recruit Restaurant Visitors Forecasting (Kaggle Problem): Built an automated data modeling & selection module in R which gives the best forecasting model for predicting the no. of visitors for each restaurant in database. Prediction of Airbnb Pricing using R and Excel Minor: To predict the Airbnb pricing in Boston, built different data models using data mining techniques (MLR/KNN/CART/Cluster Analysis) in R and excel minor. Protection of Endangered Florida Panthers from Roadkill Using GIS: Designed a GIS map tracking the movements of Florida Panthers to avoid future road kills using ARCGIS software. Areas of Expertise

• Data Mining

• DW - ETL & OLAP cubes

• Forecasting Techniques

• VBA MS Excel & Macros

• Python & R (RStudio)

• MS SQL & MySQL

• ML – NLP, Random Forest

• Optimization & Logistics

• Cloud Comp. (AWS/GCP)

• Neural Networks

• Statistical Data Modeling

• Tableau & Power BI

Awards: Received “Certificate of Excellence” from Mihaylo College of Business and Economics, CSUF. Sriram Ramanujam

******.*********@***.*********.*** +1-479-***-**** LinkedIn: sriram-ramanujam GitHub: https://github.com/gokusri08

Contact this candidate