Sql Server Sales

Juhi Sharma

MASTER OF INFORMATION SYSTEMS, NEW JERSEY INSTITUTE OF TECHNOLOGY

****, ******** ****., *** # ***, Orlando, FL 32839

+1-201-***-**** ac0z6n@r.postjobfree.com github.com/juuhi LinkedIn

Education

Master of Information Systems, NEW JERSEY INSTITUTE OF TECHNOLOGY Aug. 2015 - Dec. 2016

GPA- 3.85/4.0. Courses - Enterprise Management Systems, Marketing Data Analysis, Integration of Database System, System Architecture & design, Business Process Innovation.

Bachelor of Technology (ECE), UTTAR PRADESH TECHNICAL UNIVERSITY, INDIA Aug. 2009 - Jul. 2013

Experience

Research Analyst

NEW JERSEY INSTITUTE OF TECHNOLOGY (Newark, NJ) Oct 2016 - May 2017

•Worked on the web portal of Novartis to generate trends for the web metrics KPIs (Bounce rate, page views, time on site etc.)

•Created custom reports using Tableau 10.0 for segmenting user traffic, running demo marketing-campaigns to analyze customer behavior.

•Advanced SQL (Creating Views, stored procedures, Functions, Triggers Percent Select Sub queries).

Tableau Developer - Internship

DEVTECHNOCHEM (New Delhi, India) May 2016 - August 2016

•SQL Development and Tableau 9.0 experience working on design, analysis & implementation of marketing solution environment.

•Identified new data sources & remedied data quality issues that boosted campaign effectiveness by 10 percent.

•Converted existing BO reports to Tableau dashboards. Build real-time dashboard/scorecard.

•Experienced in writing scripts in SQL (Expert) and creating reports using Excel.

Data Analyst – (SQL/BI),

AON (Noida, India) Jul 2013 - Jun. 2015

•Developed a web portal for HSBC (AON client) employees to lookup for their retirement benefits.

•Solid programming skills in Python 3.4 to clean manipulate & present data, particularly using Pandas & NumPy.

•Implemented BI solutions for sales KPI using Tableau server version 8.2 connecting with backend Microsoft SQL Server 2012 data warehouse.

•Tracking Goal Conversion (Sign-ups in this case) path & improving Pages in Funnel Step Managing Campaign Tags.

•Performed Year to Date Analysis, Monthly & Yearly Comparisons, percent change Analysis & Visualize trends.

•Proficient in Excel (VlookUP, SumIf, NestedIf, Pivot Tables and Macros) with Advanced Skills.

Projects @ New Jersey Institute of Technology

Public Water Contamination Database, DATA ANALYSIS Aug. 2016 - Dec. 2016

Designed and implemented relational database with ER diagram for National Drinking Water Contamination using MS SQL Server Management Studio. Developed indexes and analyzed SQL queries for optimizing performance of execution on large data.

Technologies used - MS SQL Server, ER Studio, Excel(Power-Pivot).

Pizza Ordering Website, WEB DEVELOPMENT May. 2016 - Aug. 2016

Designed and built a 3 -Tier web application of pizza ordering. User selects the pizza and toppings, app calculates order price, stores order details in database. Technologies used- VB.Net, Asp.NET, MySQL.

Stock Technical Analysis, DATA ANALYSIS Jan. 2016 - May. 2016

Developed an application which analyze stock technical data based on Apple Inc’s daily stock prices(ticker:AAPL) for one business calendar year(252 observations).Technologies used - Python

Car Sales System, DATABASE SYSTEMS Aug. 2015 - Dec. 2015

Designed and built an application that implements car sales management software provides searching facilities based on search factors. Technologies used- Java, MySQL.

Certification

Microsoft Technology Associate: Database Fundamentals, MICROSOFT

Skills

Technologies - Quality Management, Software Architecture, Agile Development, Cloud Development.

SQL, T-SQL, Java, Python, C#, .Net, Microsoft SQL Server, Oracle, SSRS, SSIS, Tableau, Excel, MS-Visio, Visual Studio

Contact this candidate