Post Job Free

Resume

Sign in

SQL, Alteryx, Tableau, Minitab, Advanced Excel, Simio, Qlikview, SPSS

Location:
Dearborn, MI
Posted:
March 01, 2017

Contact this candidate

Resume:

SUJATHA SUNILKUMAR

****, *** ***, ********** *****, Dearborn, MI, 48126, Contact: 313-***-**** / acy2gw@r.postjobfree.com

PROFFESSIONAL PROFILE

Solid exposure and qualifications in data mining, business intelligence, information management, statistics, forecasting, management science, system simulation and decision analysis.

Proficient with data mining techniques, business analysis, requirements gathering, workflow analysis identifying key performance indicators adding value and opportunity to the customers.

Experienced working with unstructured data creating workflows in Alteryx software with documentation and implementation of the processed data.

Worked with Linear, Non-linear optimization models and discrete simulation modelling.

Decision analysis using decision tools for strategic planning and decision making.

Accomplished skills in data visualization that support business objectives with an innate ability to optimize resource allocation and understand client requirements to provide them solutions as per business needs.

Strong innovative, analytical, and communication skills with effective skills in event & team management.

Areas of interest: Business analytics, Data Mining, Business Intelligence, Big Data Analytics.

TECHNICAL SKILLS

Alteryx

Spark

Tableau

Hadoop

Minitab

Visual Basics

Qlikview

MS Excel & Pivot tables

Microsoft Access - SQL Programming

HTML & CSS

SPSS

PROFESSIONAL EXPERIENCE

Business Analyst Intern Oct’16 - Present

Marvel technologies Inc. Novi, Michigan

Business Analysis: To work with our clients industry, customers, organization and fulfil business objectives in order to help the client in a problem-solving role.

Assessing user requirements, procedures and problems to create or improve a system.

User Support Analysis: To provide quality client support by answering client questions, researching possible solutions to problems, and fostering open communication between the client and the CGI project team.

Tracking software and documentation defects, performing application maintenance, and providing onsite consulting and training as required.

System Testing: Worked with system developers and designers to identify, diagnose, and document problems and errors in specific components of a system.

Assessing how well a product adheres to its design, standards, as well as its usability and ability to meet business needs.

Decision Analysis: Applied quantitative methods to study and make recommendations regarding various business issues, including credit risk management, customer profitability, and resource allocation for optimization, and customer segmentation.

Analytical and Visualization Tool: Excel, VB, Minitab, Tableau

Data Manipulation: Excel

Statistical Methods: Descriptive, predictive and prescriptive analysis

Capstone Project Intern: Data Mining Jan’16 – April’16

Ford Motor Company, Dearborn, Michigan

Used historical sales data of vehicles to detect the buying patterns of customer preferences through identifying the factors affecting sales rate of vehicles.

Created dashboard in Tableau to show the top 10 configurations affecting sales rate.

Analyzed dealer sales and holding inventory in US to provide customer with better value added products.

Alteryx was used to cluster dealers based on their distance between each other so that customers can have access to various vehicles from dealers closest to them.

Analysis: Vehicle Data Analysis, Buying pattern Analysis

Programming: SQL

Analytical and Visualization Tool: Tableau, Excel, VB, Alteryx, and Qlikview

Data Manipulation: Excel, Alteryx

Statistical Methods: K-means clustering on Geographic Dealer Sales

Business Process Analyst Jan’15 – April’15

Prumatech, Maintenance and Materials Management Solutions, Chennai

Extracted data from the company sources about the PDO project, Analyzed data using statistical methods

Redefined the process and set up standards for achieving target, Proposed a productivity based incentive scheme

Analytical and Visualization Tool: Excel, VB Statistical Methods: Weighted Average Method

Analytics Intern Oct’13 –June’14

Vedvistara Technologies Pvt. Ltd, Calicut, Kerala

Extracted data and did data standardization for Analyzing Quantitative data of 'My studypark' product

Created a dashboard of traffic signals along with charts & graphs representing visualization tools of user views for clients

Analyzed the factors affecting the products market reach through web analytics, Provided solution using Excel software packages and proposed recommendations to the management

Analysis: Survey Research

Analytical and Visualization Tool: Excel, VB, Minitab

Data Manipulation: Excel

Statistical Methods: Descriptive, predictive and prescriptive analysis

ACADEMIC PROJECTS

Analysis of Tayko software cataloger

03/2016

Developed a classification model to classify customer into purchaser and non-purchaser for Tayko software cataloguer company, Various models were assessed and the best model was chosen based on accuracy

Created a prediction model to predict customer spending using multiple linear regression

Analytical and Visualization Tool: XLMiner, VB, Tableau

Data visualization of domestic airline flights in US

1/2016

Interpreted results for the data on insights about domestic airline flights using Tableau software.

Analytical and Visualization Tool: Tableau, VB

Data Manipulation: Excel

Analysis of Future Sales

1/2016

Forecasted future sales using ARIMA Model in Minitab as part of the applied forecasting course.

Analysis: Statistical tools, Analytical and Visualization Tool: Minitab

Analysis of Texaco Vs Pennzoil legal case:

11/2015

Decision analysis was done for the legal case of Texaco and Pennzoil using precision tree, assessed risk and cost benefits of litigation versus settlement. It was concluded that litigation is better than settlement.

Analysis: Decision Analysis, Analytical and Visualization Tool: Precision tree

Analysis of DBMS in Wayne county community hospital

11/2015

Created data warehouse for Wayne county community hospital using Access database to address issues with electronic monitoring system.

Used logical modelling and normalized the fields then finally created the physical model and implemented using Microsoft access.

Analysis: Predictive analysis, Programming: SQL, Analytical and Visualization Tool: Microsoft access, Excel

LEADERSHIP SKILLS

Coordinated an event called Invictus at Vellore institute of technology for the academic year 2015, recruited volunteers and marketed the event. Lead my team in a National Level Management Fest organized in Christ University Bangalore.

EDUCATION

Master of Science in Business Analytics & Information Technology (MS-BA/IT) 3.25 GPA

UM Dearborn, MI Dec’16

Management science

Applied forecasting

Information management

System Simulation

Data mining for business application

Decision Analysis

Master’s in Business Administration (MBA) 3.7GPA

VIT, Vellore, June’14 Aug’15

Bachelor’s in Business Administration (BBA) 3.5GPA

Academic City, Dubai April’10- Aug’13



Contact this candidate