Sql Server Data

SAURABH NIGAM

** ******** ******, *** *, Jersey City, NJ, 07306 Ph.: 201-***-**** Email: ******@*******.*** SUMMARY

• Advanced Microsoft Excel for Data Analysis certified professional with proficiency in VLOOKUP, HLOOKUP, PivotTables and Macros.

• Google Analytics certified individual with strong analytical and problem solving skills along with hands-on experience in Google Analytics to produce actionable insights on the various Marketing Campaigns and Key Performance Indicators.

• Proficiency in Tableau to generate dynamic dashboards to analyze large data sets by cleaning the data in MySQL.

• SQL Server and MySQL certification from National Institute of Information Technology.

• Experience of working in a fast paced growing ecommerce startup as Marketing Analyst.

• Highly proficient in Wordpress, SharePoint, PowerPoint, Microsoft Project and database tools such as SQL Server Management Studio

(SSMS), MySQL Workbench and Visual Studio 2013 including the ability to analyze, summarize and manipulate large volumes of data.

PROFESSIONAL EXPERIENCE

Shredz Supplements, Jersey City, New Jersey 09/15 to Present PPC Analyst

• Created dashboard to aggregate data from all the paid Facebook Ads, Google PPC campaigns and MySQL to monitor day-over-day and weekly performance of all the campaigns.

• Analyzed the performance of the campaigns based on the historical data and live performance data such as CPC, CTR, Relevance, Revenue generated and Amount Spent on each ad.

• Provided daily/weekly reports of the PPC campaigns, of 3 companies, reporting directly to the CTO along-with actionable insights and suggestions to improve the ROI.

• Took a dive into Twitter Ads analytics and analyzed the various twitter campaigns.

• Managed Google Analytics and Google Tag Manager accounts and analyzed the post-click behavior of the user for the ad campaigns. True Facet, New York, New York. 06/15 to 09/15

Marketing Analyst.

• Provided weekly & monthly web analytics reports using Google analytics to produce actionable insights on the various Marketing Campaigns and Key Performance Indicators

• Used Mixpanel and RJ Metrics to get user level insights of the customers for Attribution Marketing and to calculate Lifetime Value and Customer Acquisition Cost.

• Effectively reduced work time by connecting Google Analytics directly with Tableau and creating dynamic dashboards to analyze web traffic data.

• Created interactive Microsoft Excel dashboards and reports on daily weekly basis using complex excel functions and pivot tables to analyze the various Organic/Paid Channels.

• Helped improve the performance of websites through Google Analytics, Crazy Egg, Optimizely and other online tools. Prime Minister Rural Road Development, Raipur, India. Sector: Government Data Analyst. 08/13 to 06/14

• Build and maintain SQL scripts, indexes, and complex queries for data analysis and extraction.

• Creating custom reports, writing stored procedures and optimizing custom reporting tools for MS SQL Server databases.

• Used complex excel functions that reduced time consumption and error due to manual work. Sankalp Realities, Raipur, Chhattisgarh.

Business Analyst Intern. 04/12 to 06/12

• Generated web analytics reports using Google Analytics to display website traffic and customer segmentation for the company website.

• Generated advanced tracking, profiles, goal conversion tracking, and custom filters in Google Analytics to measure, monitor and provide insight into user behavior.

EDUCATION

Master of Science in Information Systems. 12/2015

Stevens Institute of Technology, Hoboken, New Jersey. Relevant Coursework: Multivariate Data Analysis, Experimental Design II, Statistical Learning and Analytics, Web Analytics, Data Warehousing and Business Intelligence, Analysis and Development of Information Systems. Bachelor of Engineering in Civil Engineering.

Bhilai Institute of Technology, Durg, Chhattisgarh, India. 03/2103 SKILLS

Office Applications: Microsoft Word, Excel, PowerPoint, Access, Microsoft Project, Apple Keynote, Numbers, Visual Basic Software Suites: SAS, Wordpress, Google Analytics, AdWords, Tableau, Photoshop, Adobe Creative Suite, InDesign. Languages: SQL Server, MySQL, R, C, Java, PHP.

Operating Systems: Windows XP, Windows 7, Windows 8, Mac OSX.x CERTIFICATIONS

• Advanced Microsoft Excel for Data Analysis from Udemy Mar 2015

• R Programming Certification from John Hopkins Institute Jan 2015

• Google Analytics Certification. Nov 2014

• SQL Server and MySQL certification from National Institute of Technology, India. July 2013

Contact this candidate