Data Analyst

Shivpriya Sharma

*** ***** ****’s Avenue, Apt-**v, Jersey City, NJ-07306 646-***-**** *********.******@*******.*** EDUCATION

Rutgers Business School, Newark, NJ May 2018

Master of Information Technology & Analytics, GPA: 3.76 Management Institute For Leadership and Excellence (MILE), Pune, India May 2012 Post Graduate Program in Management

Chitkara College of Pharmacy, Rajpura, India June 2009 Bachelor of Pharmacy

TECHNICAL SKILLS

Programming Languages: SQL, MySQL, Python, R, Python Pandas, Java, SQL, Matplotlib, Databases Tools: MS Excel, MS PowerPoint, SAP, Jupyter, R Studio, Google BigQuery, Google Analytics Operating System: Windows, Mac OS, Linux

WORK EXPERIENCE

Labelium, New York, USA Data Analyst (Internship) January 2018 – Present

• Data Analytics by performing statistical models on millions of keywords data from Ad Words/Google Analytics using Google Big queries Python API for finding repeats, gaps and issues for optimization of SEM, SEO.

• Generate, maintain SEM data with SQL Queries for implementing digital and market data in dashboards.

• Perform periodic check on content performance, Quantitative analysis for validating data in Jupyter notebooks, reporting, data visualization using BI reporting tool Tableau.

• Integrate a variety of large data resources into day-to-day decisions of account managers by performing root cause analysis and develop insights and recommend business strategy based on client queries.

• Design, execution and analysis of A/B tests, On-off bucket test to drive improvement in traffic through rigorous experimentation using Google sheets, python pandas and its analytical packages.

• Auditing websites and preparing Audit reports for clients using crawlers, Google search console and excel models.

• Automation of reports using API’s in python scripts, which reduced manual intervention by 95%. SECUIRA, Mohali, India Business Analyst May 2015 - October 2016

• Developed data models for cost focused business forecasting by extraction, cleaning, processing, statistical analysis and storage of data using Advanced Excel and R with high customer satisfaction.

• Successfully ideated and implemented actionable metrics to understand the performance of products, developed dashboards and reports to track performance, and ingrain these metrics into teams day-to-day decision-making.

• Effectively performed ad-hoc business analysis/data mining and managed client requirements through co-ordination with the team, while managing the project budget and resource constraints.

• Partnered with senior leaders to identify opportunities for improvement and for driving decision-making. Apollo Fiege Logistics Pvt.Ltd, Gurgaon, India Sr.Executive Business Analyst December 2012 - March 2015

• Successfully prepared executive summary, presentations, writing functional requirements and impressive graphical representations of results.

• Used SQL to extract data from a variety of different sources and load it into analytics database and constructed complex SQL Queries as per business requirement effectively.

• Effectively designed new KPI’s solved complex business problems with data and transformed analyses into concise insights and recommendations, which saved 35% costs of resources.

• Globally Managed HR operations with 10M + INR budget single-handedly to scale resources across all departments and completing performance management cycle with 100%accuracy and endured two promotions in one year. ACADEMIC PROJECTS

• Analysis of restaurant ratings and identifying most common violations of restaurants of NYC using Python Pandas and its analytics packages for performing exploratory data analysis, statistical testing, regression.

• Developed a dynamic Web Project for a small boutique hotel business using Java, Java Servlets integrated with SQL servers and HTML, JSP as front end.

• Classification of websites into genuine and malicious types by data mining process using WEKA and Tableau.

• Analyzed genes of diseased and control group using classification, correlation, chi-square and p-value in R.

• Analyzed real-time traffic on website for an organization using Google analytics.

Contact this candidate