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