Data Analyst

*********.*********@*****.*** MANASWINI VINNAKOTA +1-704-***-****

A highly motivated and entry level analyst with experience in interpreting, analyzing and reconciliation of data obtained from a variety of sources; proficient with the prevailing analytical tools, various presentation software.

O R G A N I S A T I O N A L E X P E R I E N C E

Analyst Bank of America June 2017- Aug 2017

Translate business and technology requirements into database design models

Design and implement next generation of data warehouse systems

Work closely with development, support, DBA and business teams

Responsible for team level contributions to overall application development efforts within portfolio application(s)

Experience with the processing, manipulation and analysis of large datasets.

Experience with various supervised and unsupervised machine learning techniques, as well as peer grouping, clustering and classification using R.

Experience with advanced concepts of MS Excel such as pivot tables, graphs and advanced functions VLOOKUP, IFELSE, etc. and Macros.

Experience with data modeling, database design, complex SQL queries and query optimization

Develops, enhances, tests, supports, maintains, and debugs implementations within business intelligence (BI) applications that support business continuity and problem incidence functions; competent to work under supervision on simpler visualization coding from documented logic.

Experience with descriptive statistics and how to effectively represent them graphically using Tableau and Microstrategy.

Worked under general direction on complex projects usually on specific assigned problems, receiving guidance and direction from more senior associates or manager, as needed.

Awareness on business continuity and problem incident functions for which application is designed.

Working knowledge of Waterfall and Agile development methodologies, Rally / CA Agile Central experience a plus

Exercised good communication skills to work with service delivery and engagement partners.

Skills Exercised: SQL – R – Microstrategy- Tableau- Communication Skills- Leadership

Database-Graduate Assistant University of North Carolina, Charlotte Aug 2015 – Dec 2016

Provide assistance to the professor for the course Database Design and Implementation

Assisted professor with classroom instructions, exams, record keeping and projects

Tutor and assist Under-grad and Grad students individually or in small groups to help them master assignments and to reinforce learning concepts presented by Professor for course – Database Design and Implementation- MySQL

Perform weekly and monthly analysis using SSRS, Tableau to generate reports on merit level of students in different concepts of Database design, Normalization

Maintain course Learning Management System(LMS) site, including but not limited to posting assignments, editing and posting notes and/or slide shows for student access, and entering grades as assigned

Evaluate student performance, including grading exams, quizzes, assignments, and papers

Meet with course instructor and assists in designing term project

Maintain weekly office hours to communicate in person with students as needed

Receive and promptly respond to student inquiries regarding grades, assignments, attendance, and course material

Skills Exercised: SQL – EXCEL – SSRS- Tableau- Communication Skills- Leadership

Junior Data Analyst Data Epsilon Sept 2014- Jul 2015

In the role of Data Analyst performed analysis and design of extensions to an existing data warehouse/mart business intelligence platform

Analyzed large data sets using statistical software, such as SAS, R, Python, and SPSS, to discover new business insights

Analyzed data in both application and reporting databases and solving the discrepancies

Data cleaning, data visualization, detection of missing data and skewness, correlation analysis using heat maps, principal component analysis and model development were performed on the data

Designed and built machine learning & statistical models and conducted analyses at the appropriate level of complexity to produce relevant results for the business

Created complex SQL queries for validating target data against source data

Modified the existing SQL queries according to the requests and executed them to check the performance

Extensively used SQL programming in backend and front end Functions, Procedures, and Packages to implement business logics/rules

Written Procedures and Functions using Dynamic SQL and written complex SQL queries using joins, sub queries and correlated sub queries

Modelling using Logistic Regression for the binary response variable

Random forest modelling was explored for better predictability

Built model to predict binary response on dataset with 28variables. Achieved model accuracy of 75% and sensitivity of 54% with Random forest

Developed Tableau visualizations and dashboards using Tableau Desktop

Skills Exercised: SQL – R – EXCEL - SAS – Tableau- Machine Learning

Data Analyst Config Technologies May 2013-Aug 2014

Worked directly with the Business Data Architect into identifying customer’s interactions across systems and their correspondent data repository

Provided customized and complex reports to client institutions and provide them with the analysis that informs their financial aid policies

Analyze the data set and find the problem statement. Extracted, compiled and tracked data and analyzed data to generate reports

Developed optimized data collection and qualifying procedure. Ensuring data integrity, updating and entering definitions

Interpret data from primary and secondary sources using statistical technique and provide ongoing reports

Translate data into understandable document by cleaning, transforming and visualizing

Integrating data from multiples sources to build reporting spreadsheets and user interface which meet business information requirements

Ensemble learning method applied for better predictive performance

Worked with other team members to complete special project and achieve project deadlines

Developing tidy dataset, Data visualization in R using dplyr, tidyr& ggplot2 packages.

Develop prediction model using Linear/Logistic/Decision Tree/Random Forest models.

Building Dashboard/Stories over data using SSRS, Tableau and Excel.

Run reports based on team needs by writing SQL quires to extract data

Skills Exercised: SQL – R - Tableau – EXCEL- SPSS- Python

E D U C A T I O N

M.S. Computer Science

University of North Carolina, Charlotte

Dec 2016

. Cumulative GPA: 3.8

B.E. E.C.E

Osmania University, India

May 2015

. Cumulative GPA: 4.0

Relevant Courses:

. Business Intelligence

. Visual Analytics

. Knowledge Data Discovery

. Algorithms and Data Structures

. Network Based Application Development

. Database Systems

. Information Security and Privacy

. Machine Learning . Knowledge based systems

T E C H N I C A L S K I L L S

Programming Languages : R, SAS(Base) D3, Python, C, C++, Java, J2EE (Servlets, JSP), XML, PHP, jQuery

Database skills : My-SQL, Microsoft SQL Server, Teradata, NoSQL, PL/SQL, T-SQL, Redshift

Analytics : SAS, SPSS, EXCEL, WEKA, SSIS(ETL), SSRS,SSAS,Hadoop,Hive

Scripting Languages : JavaScript, HTML, CSS and Python

Operating Systems : Windows, LINUX

Machine Learning Algorithm : Linear & Logistic Regression, Market Basket Analysis, Time Series, Apriori

Algorithm, Naïve Bayes, Clustering, Principle Component Analysis, Factor Analysis, Decision Trees, Random Forests, Support vector Machines, Exploratory Data Analysis, ANOVA

Other tools : Tableau, Informatica, Microstrategy, SAS E-Miner, SAS Enterprise guide, R studio, Eclipse, MATLAB, Xilinx ISE simulator, MASM- Microsoft Macro Assembler, MS Office

A C H I E V E M E N T S

Successfully completed Advanced R programming offered online by Johns Hopkins University at Coursera - Certificate Link

Successfully completed R programming offered online by Johns Hopkins University at Coursera - Certificate Link

Successfully cleared test and now a SAS Certified Base Programmer for SAS 9

SAS Certified Statistical Business Analyst Using SAS 9: Regression and Modeling

Successfully achieved certification in Intro to Python for Data Science from Data camp

Awarded Certificate of achievement for the successful completion of the Google Analytics Certification

Successfully completed MICROSOFT AX DYNAMICS R2 2012-FUNCTIONAL MODULE

University topper in Undergraduate studies

Design Head and Active Member of MCC-MVSR Campus Connect

Achieved Merit Certificate and Award for achieving Academic Excellence in SSC

P R O J E C T E X P E R I E N C E

Mail Order Catalog Retailer Analysis Nov 2016

The goal is to increase revenue per mailed catalog and to select customers to mail the 2010 catalog to, based on their past purchasing behaviors. The catalog example serves a dual purpose; to illustrate predictive modeling and also to highlight the importance of customer relationship management for this type of application.

i) Developed a Predictive model with many deciding variables, historical purchase patterns and behaviors.

ii)Performed a data mining methodology called RFM analysis on CATALOG2010 data set to identify profitable customers for a mail-order catalog retailer.

iii) Implemented Predictive Modeling using Decision Trees and Logistic Regression and Model comparison was used to identify better predictive accuracy.

iv) Performed Market Basket Analysis on various data sets to determine and suggest best possible solutions to close the gaps.

Skills exercised: SAS E-Miner

Visualization of Factors Influencing Global Warming April 2016

The objective of the project is to create different visualizations of multiple attributes causing global warming using Tableau and also implement the system using D3 coding. The data for this project is collected over the years 2000 to 2011. Dashboard thus created from visualizations aid to conduct study on Global warming.

Skills exercised: Tableau, D3

Researchers’ Interaction Model March 2016

Responsive Java based web application using MVC pattern that integrates researchers and students; allows users to exchange their participation. User friendly and aesthetically pleasing application with multiple features like Refer a Friend, Follow Study etc

Skills exercised: My-SQL, Java, HTML, CSS, JavaScript, Servlets, JSTL, JSP and JDBC

High Precision Attribute Discretizer March 2016

The intention of project is to discretize an attribute of data into categories with resultant classifiers to have highest precision. Designed a database of paintings from a website; used one feature of paintings as the decision feature and discretized using interactive binning node.

Skills exercised: WEKA and SAS.

Descriptive Statistics for New York City Vehicle Collisions Nov 2015

In RStudio, we tried to analyze and visualize the data set of New York City vehicle collisions (2012-2015). Cleaned the data by using RDSTK library to get the address based on the latitude and longitude coordinates. Data analysis and visualization has been done based on the contributing factors for accidents like number of accidents across boroughs yearly, annual trends in accidents in each boroughs, number of accidents at a particular time, number of injuries and deaths over the years, most common reasons for the accidents, areas in a particular borough having most accidents.

Platform: R Programming

Online Ticket Reservation System October 2015

A web based application that enables users to check, reserve, update and cancel tickets. Application also allows user to create his profile, log- in and track the booking history.

Skills exercised: My-SQL, HTML, CSS, JavaScript and PHP

Patient HealthCare Management System October 2015

A web based application - unified platform for doctors and patients. User can register himself either as patient or doctor; Patient can browse through registered doctors’ profiles to get acquainted with available local healthcare facilities.

Skills exercised: Java, Spring, Hiberanate, PostgreSQL, Apache Tomcat, Maven and Eclipse

Contact this candidate