Resume

Sign in

Data Analyst

Location:
Aldie, VA
Posted:
May 14, 2020

Contact this candidate

Resume:

VYSHNAVI

Email: adc7li@r.postjobfree.com • Phone: +1-571-***-****

SUMMARY

•4 years of experience in Analysis, Design, Development, Management and Implementation of various stand-alone, client-server enterprise applications in Python.

•Highly motivated, quality minded developer, with proven ability to deliver applications against tight deadlines.

•Possess good interpersonal, analytical presentation Skills, ability to work in Self-managed and Team environments.

•Proficient using Tableau to develop and deliver executive-level dashboards.

•Experience on building dashboards in Tableau and involved in Performance tuning of reports and resolving issues within Tableau Server and Reports.

•Expertise in working with different databases like Oracle, MySQL. Also, proficient in developing complex SQL queries, Stored Procedures, Functions, Packages along with performing DDL and DML operations on the database.

•Experience in SQL Server DTS and SSIS (Integration Service) package design, constructing and deployment.

EDUCATION

Master of Science, George Mason University, Virginia- Data Analytics and Engineering GPA: 3.78/4

Relevant course work: Big data, Statistics and analytics, operations, Database systems, competitive strategy, Finance

Bachelor of Science, Jawaharlal Nehru Technological University, India – Computer Science Engineering GPA: 3.7/4

SKILLS

Languages: R, Python, C Databases: MySQL, MongoDB, NoSQL

Tools: Tableau, Weka, Sipinia Learning: Data science stack- Pandas, NumPy, scikit-learn

Operating Systems: Windows, OS X Data Management: Six sigma, Lean

WORK EXPERIENCE

Graduate Teaching Assistant – School of Business, George mason university, Fairfax, VA Aug2019-Jan2020

Interaction with over 200 students, helping them by instructing, advising and evaluation of undergraduates under faculty supervision- Modeling relationships contained in data and linear models to make predictions in business.

Topics include estimation, hypotheses testing, statistical inference, analysis of variance and linear regression techniques. Fundamentals of linear programming to solve optimization problems in business.

Apply analytical tools to gain insights from real-life datasets.

Data Analyst, Infinics INC, Concord, NC Mar2018- Jan2020

Performed Data Collection, Data Cleaning, Data Visualization and Developing Machine Learning Algorithms by using NumPy, Pandas and Matplotlib.

Created SQL tables with referential integrity and developed queries using SQLPLUS and PL/SQL. Developed and updated SQL queries, stored procedures, clustered index and non-clustered index, and functions that meet business requirements

Developing reports using SSRS (reporting services) and SSDT (development tools)

Used R and SQL to manipulate data, and develop and validate quantitative models

Responsible for data identification, collection, exploration, cleaning for modeling.

Responsible for creating dashboards and overall creation of data visualizations.

Developed Tableau data visualization using Cross Map, Scatter Plots, Pie charts and bar charts, Page trial and Density chart.

Prepared Dashboards using calculations, parameters in Tableau and created calculated fields, group, sets and hierarchies etc.

Used Oracle SQL server as data sources for designing Tableau Reports and Dashboards.

Environment: Tableau, SQL Server Reporting Services(SSRS), Python 3

Data Visualization Analyst, iGuru Portal Service LLP, Hyderabad, India Apr2016–Mar2017

Analyze student, financial management and administration databases of various academic institution (Schools and Colleges) to

generate reports for implementing marketing and business strategy decisions for clients.

Used Python (NumPy, SciPy, Pandas, SciKit-Learn) to develop variety of models and algorithms for analyst.

Performed visualizations using R and Tableau - conceptualized the necessity of adequate staffing and resources for administration

Create custom dashboards for teaching staff to visualize and analyze student profiles based on existing academic records

Drive the design and build visualizations and analytics, understand the data management process across various academic institution management.

Meet the client expectations of the visualization request provided in the reports by using data visualizations tool like Tableau to make clear and concise visual representation of data. This helped in supporting the business operations and presents findings to management.

Environment: Tableau, python 3

Data Analyst, Cigniti Technologies Ltd, Hyderabad, India Aug2015- Mar2016

Analyzed hospital patients and employee data department wise and analyzed and improved the existing algorithm the percentage of emergency responses and patterns of the patient admit according to the cases.

Created database in MySQL, wrote several SQL queries to retrieve the required data for analysis.

Using SSRS, generated periodic reports based in the statistical analysis of the data.

Experience in dealing with RDBMS, including normalization, stored procedures, constraints, querying, joins, keys, indexes, data import/export, triggers and cursors.

Performed visualizations using R and Tableau and conceptualized the necessity of adequate staffing and resources

Ability to use custom SQL for complex data pulls Extracted data from the database using SQL procedures and create data sets for Analysis, Validation and Documentation

Published dashboards on Tableau public.

Environment: MS-SQL Server, SSRS, MS-SQL Analysis Server, Tableau, MS-SQL Server Integration Services

PROJECTS

Ship Detection in Satellite Imagery

Objective: Utilize the machine learning and computer vision algorithms and automate the process of image analysis for classifying ships in San Francisco Bay using Planet Satellite Imagery

This approach can be set forward with the help of Convolutional Neural Networks (CNN) which is a sub-category of Neural Networks.

The algorithm is implemented using python (Tensor Flow, Keras, Pytorch Libraries) and visualizations could be done using Tableau, PowerBI, python (matplotlib, seaborn)

Fitted and tuned deep neural networks to detect ships in satellite imagery using Convolutional Neural Network with an accuracy of 93%.

Real Estate Crime Analysis

Objective: To collect real estate datasets from Zillow, their respective transit scores and neighborhood crime rates to analyze interdependency and gain insights – to improve marketing strategies and funding for real estate markets

Collect and clean datasets to identify correlation points in datasets and map them using R studio.

Run Neural Network, Binomial Regression, and Random Forest (different complexities) models on filtered datasets using R, Python and Weka for analysis.

Airline Ticket Cancelation Analysis Dataset

Objective: To analyze factors resulting in flight cancellation based on passenger attributes and implement predictive models

Collect and clean datasets to identify correlation points in datasets and map them using R studio.

Implemented predictive models- Simple cart tree, J48 and Random Forest for analysis using Python.

Evaluation of Turkey students survey using Unsupervised Machine Learning Algorithms

Objective: To explore different category of Machine learning, the unsupervised learning algorithms. Goal- To group students on the similarity of their answers on the survey

Used PCA to do dimensionality reduction since we had 28 different dimensional space to visualize the clustering result.

Define the number of clusters using Elbow method and Dendogram, compare the results of k-Means vs Agglomerative clustering methods.

Tools used for study- R Studio, Python, Weka and Tableau.

CERTIFICATIONS

DATA SCIENCE FOUNDATION (Lynda) PYTHON FOR DATA SCIENCE (Lynda)

DATA VISUALIZATION (Lynda)

POWER BIPRO (Lynda)



Contact this candidate