Sign in

Data Analyst

Dearborn, MI
October 05, 2020

Contact this candidate



Data Analyst, Business Analyst, Business Intelligence Analyst

P: +1-313-***-**** E: Review-Analyze & Evaluate Data requirements (Attention to Details), Data Manipulation & Preparing, Sending Reports on timely manner, Data Visualization & Interpretation with Presentation and Dashboard Creation. If these are some of the qualities that you look upto in a prospective candidate, then you are screening the right resume. I am proficient in delivering SQL Queries, Tableau reports. I am sure that with my excellent Verbal & Written Communication skills and interpersonal skills with self-driven efforts can help & support the Analytics Team and senior leaders. SKILLS/TOOLS

• Databases/ETL/Integration: SQL, SAP, Alteryx Programming skills- Python, SQL, SAS MS Visio, MS Office Suite, Access, Advanced Excel (Pivot Tables, Fuzzy Lookup, Vlookup, Solver)

• Data Visualization Tools/ Business Intelligence Tools – Tableau, MicroStrategy & PowerBI

• Area of expertise - Exploratory Analysis, Data Classification, Clustering, Time-Series forecasting, Regression & Data Analysis Reporting.


Valeo India Pvt Ltd Chennai, Tamil Nadu, India

Data Analyst, (Intern) Tools: SAP, Excel 3 mos. May 2019 – July 2019

• Data CollectionData Modelling is done by finding the trend in International travel expenses data and worked with senior management to assist and review the change in trend.

• Summarized and analyzed data sets, reports from databases using Microsoft Excel, SAP software and Microsoft Office. Performed extraction & standardization processes of data from SAP and used Pivot Tables to calculate and summarize data. Information Technology & Services Ann Arbor (University of Michigan Ann Arbor) Ann Arbor, Michigan Capstone Experience 4 mos. Jan 2020 – April 2020 Tools: Alteryx, Google Analytics, Firebase, Natural Language Processing

• Developed a chatbot with the use of conversational analytics which will include leveraging platforms such as Google Assistant and Google Dialog-flow capabilities in answering complex questions.

• It is done using a machine-friendly query, then going through relevant data architecture to find the necessary information (data mapping), and finally returning the answer efficiently in a natural language sentence. Optimization of Inventory Level and Revenue for an E-Tailer Dearborn, Michigan Supply Chain Analytics (CE) Tools: Excel, Alteryx, Tableau 4 mos. Sept 2019 – Dec 2019

• Optimized inventory levels during the busy and regular seasons through which inventory stock-outs were prevented.

• Built a linear programming-model that will help the business increase the revenue and will optimize the quantity of each game that should be in inventory.


Analyzed Customer Service Center Data of Mills Financial Company

• Successfully developed and forecasted average percentage increase per month to be 14%.

• Predicted that the number of calls in 2019 to increase by 14% per month, on average, compared to 2018. Sentimental Analysis – Predicted US Presidential election using Twitter

• Extracted raw data from Twitter using Twitter API which was not retweeted.

• Performed Text classifier to determine a tweet expressing a positive or negative sentiment.

• Data was pre-processed in different ways thus creating different features and then compare across the text Flint Water Crisis (Flint Lead Prediction)

• Effectively predicted a given house in Flint is likely to have used lead/ galvanized pipe.

• Analyzed and extracted data of 4000 water tests from around 6000 homes in Flint, Michigan.

• Developed predicted models to choose which model is best for prediction accuracy. EDUCATION

University of Michigan, Dearborn, USA Dearborn, Michigan 2019 – Dec 2020 (expected) Degree: Master of Science in Business Analytics, Supply Chain Analytics GPA: 3.61/4.0. Top of the Dean’s List in College of Business VIT University Chennai, Tamil Nadu 2018 - 2020

Degree: Master of Business Administration, Finance & Operation. GPA: 9.08/10.0. SRM University Chennai, Tamil Nadu 2014 - 2018

Degree: Bachelor of Engineering, Electronics & Communication Engineering.

Contact this candidate