Sign in

Data Analyst Digital Marketing Business Analyst Business Intelligence

Harrison, NJ
January 15, 2020

Contact this candidate



+1-574-***-**** Harrison, NJ 07029


Rutgers University, Newark, NJ, US Dec 2019

Master of Science in Information Technology and Analytics GPA: 3.73

University of Mumbai, Mumbai, India May 2017

Bachelor of Engineering in Computer Science GPA: 3.62

Technical Skills

Skills: Data Science, Data Visualization and Reporting, NLP, Machine Learning, Project Management, Digital Marketing.

Languages and Databases: Python, R, Oracle SQL, MS-SQL, MySQL, PL/SQL, MongoDB, Cassandra, Neo4j, MS-Access.

Tools and Software: Tableau, Power BI, Google Analytics, Hadoop, Excel (Macros, DAX, Pivot Table, Vlookup), Salesforce, MySQL Query Browser, R Studio, Jupyter, Spyder, MS Project, JIRA, MS Office, Outlook.


Python & R for Data Science Google Analytics Tableau SQL NoSQL Excel Big Data and Hadoop

Professional Experience

Rutgers University, Newark, NJ, US Research Assistant - Data Analyst Oct 2019 – Dec 2019

Imported and exported health industry data from text files, databases; created advanced filters, and used Python to clean old data and upload the required data into new systems.

Compared data with source documents and re-entered data in verification format to detect errors.

Created pivot tables and charts in MS Excel using worksheet data and sorted items to achieve analytical goals.

Designed, recorded, and executed macros to automate data entry inputs.

Created a dashboard in Power BI for Data Visualization.

Janique, New York, NY, US Digital Marketing Analyst Intern Jul 2019 - Sep 2019

Created company website using WordPress and specialized plugins for SEO.

Conducted keyword research and implemented a range of techniques including SEO and Google Analytics.

Devised strategies to drive online traffic to the company’s website and improve conversion and ranking.

Evaluated customer research, market conditions, and competitor data and organize it into reports for company use.

Worked with reporting Supervisor to analyze statistics, develop, manage, monitor, and assess the effectiveness of digital marketing campaigns including social media ads, website banner ads, and online branding.

Improved rankings from page 12 to page 1 and increased the organic traffic by 18%.

HUDL, Mumbai, India Data Analyst/ Project Coordinator Sep 2017 - Jan 2018

Collected and analyzed data to evaluate existing potential product in MS Excel.

Solved business problems by deploying Macros and Vlookups for data transformation and manipulation.

Developed visually impactful dashboards in MS Excel for data reporting increasing the team’s performance by 20%.

Managed work efforts under the direction of a Senior Project Manager and assisted Senior Project Manager in maintaining and tracking project budget and managed pieces of larger projects.

Assisted the project Manager by creating and maintaining PM artifacts such as RACI, communication plan, meeting minutes.

Facilitated meetings, both onsite and online using tools (e.g. WebEx) for global team.

Banyan, Mumbai, India Data Analyst Intern Jun 2017 - Aug 2017

Performed exploratory data analysis, data cleaning, and transformation using Python libraries NumPy, Pandas and SciPy.

Devised complex MySQL queries accessing several rows across multiple database schemas.

Worked with ETL consisting of data transformation, data source, mapping, conversion and loading.

Created analysis reports with Tableau increasing revenue by 15%.

Assisted in gathering project requirements, managed and documented meeting minutes, and facilitated coordination between different technology and business teams for on-time completion of work using AGILE and Waterfall methodologies.

Maintained the project timelines, tracked issues and using JIRA and SharePoint.

Academic Projects

Forecasting of Future Stock Prices [R]

Performed Time-Series analysis on stock prices of Microsoft Stock Index data of 6 years.

Implemented model evaluations and predicted future stock prices for 1 year using ARIMA model.

Data Analysis for Airbnb [Python, Tableau]

Performed Exploratory Data Analysis and applied Random Forest, Logistic Regression, SVM Machine Learning Algorithms to predict new user’s first destination choice based on the personalized content.

Achieved 65% accuracy by applying Logistic Regression proving to be the optimal model.

Created a dashboard in Tableau for Data Visualization.

Orchid Hotel Web Development [HTML, Apache Server, Python CGI, MySQL]

Developed a Web interface for Orchid Hotel and established a database connection to it using Apache Server.

Executed various MySQL constraints and fired various queries against different databases to generate the output.

Contact this candidate