Sign in

Data Analyst

Jersey City, New Jersey, United States
February 21, 2018

Contact this candidate



New York City, NY +1-201-***-**** EDUCATION

Pace University, Seidenberg School of Computer Science and Information Systems New York, NY Master of Science in Information Systems GPA: 3.58 Dec, 2017 Rajiv Gandhi Proudyogiki Vishwavidyalaya Indore, India Bachelor of Engineering in Computer Science GPA: 3.67 TECHNICAL SKILLS


Database: MS SQL Server, MS Access, MySQL, Oracle 11g Programming: R, Python, HTML, PHP, CSS

SDLC Methodologies: Agile-Scrum and Waterfall

Tools & Technologies: Tableau, Google Analytics, RapidMiner, MS Excel, Hadoop File System WORK EXPERIENCE

Data Analyst Intern Meaningful World, New York City February 2017 – Present

• Analyzed AP/AR datasets to identify potential clients for the unique B2B payments solution developed by the firm

• Created ad-hoc SQL based reports based on transaction volume, count and merchant type for the sales team

• Enhanced the existing reconciliation operations by developing macros and utilizing advance Excel functions

• Implemented vlookup to automate the billing reports for payment merchants – VISA, MasterCard and Amex Data Analyst Abhyudaya Multimedia, Indore, India Jan 2014 - Dec 2015

• Independently developed strategies to analyze historical data and forecast sales

• Coordinated with relevant stakeholders to identify, analyze and solve data problems like missing values and duplicity

• Monitored data quality issues and validated data mapping by writing complex SQL queries

• Scrapped the web to extract detailed information of products and performed data modeling and database normalization

• Performed data-driven decisions using Google Analytics for marketing campaigns via Facebook and Instagram

• Created weekly data quality reports extracting data, applying business rules and building dashboards using Tableau PROJECTS

Twitter Sentiment Analysis Python Sep 2016 – Dec 2016

• Analyzed scrapped user tweets from Twitter in order to understand sentiments of individuals

• Processed raw data to mine tweet feeds using Natural Language Processing (NLP) in Python

• Evaluated users’ perspectives in terms of likes/replies guided to more pro-active and predictive Ad-marketing NYPD Motor Vehicle Collisions Analysis R, MS Excel, Tableau Jan 2016 - May 2016

• Developed predictive models using R for predicting collisions based on date, time and location

• Utilized R packages like ggplot2, lattice, plotly, etc. to generate various visual reports of the analytical findings

• Performed text mining on the collision data using tm package in R

• Improved the process of data cleansing using MS Excel, resulting in 80% reduction of erroneous records Visualization of Bank Dataset Python, Tableau, MS Excel Jan 2016 - May 2016

• Analyzed and converted raw Excel data into readable information for clients

• Created complex data views using multiple measures, also used sort, filter, group, create set functionality

• Found correlation between rate of interests of different banks by analyzing 40000+ data

• Published various kinds of live, interactive data visualizations, dashboards, reports and workbooks using Tableau Company Website PHP, HTML, CSS, MySQL, R Programming Jan 2017 – May 2017

• Developed a web-based application that allows employee to create, display, update and delete records

• Implemented the functionality where the employee can ask to reserve resources available to them

• Created trigger for the log table creation whenever the new employee logs in

• Created complex Stored Procedures, Cursors, and SQL Joins to maintain transactions and user data CERTIFICATIONS

Google Analytics by Google, Tableau, Python, Data Structures

Contact this candidate