Akash Gangrade

Email: ac7c5g@r.postjobfree.com Cell Phone: 347-***-**** LinkedIn

CAREER OVERVIEW

● 5 years of experience as a Data Analyst, Business Analyst and Digital Marketing Analyst in IT Industry with proficiency in Data analysis, Data Visualization, Business requirement gathering, Process modeling, Reporting

● Advanced Excel abilities including Pivot tables, Power Pivot, Macros, Reporting, V-lookups

● Excellent knowledge of SQL using Google BigQuery and Oracle, stories and dashboards in Tableau

● Knowledge of data analysis and data mining algorithms using SQL, Python, R EDUCATION

Rutgers University, USA Master of Science Information Technology and Analytics GPA 3.9(Current) Jan 2018 -May 2019 RGPV, India Bachelor of Engineering Computer Science and Engineering GPA 3.8 Jul 2008 -May 2012 CERTIFICATIONS

Google Analytics, Google AdWords, SQL

TECHNICAL SKILLS

Analysis Tools: Tableau, Google Analytics, Google Data Studio, BigQuery Programming: Python, R, SQL, HTML, CSS, JavaScript, JAVA Software: MS Office (MS Word, PowerPoint, Excel), JIRA, Databases: SQL Server, Oracle, MS Access

PROFESSIONAL EXPERIENCE

(2016-Dec 2017) COGNIZANT TECHNOLOGY SOLUTIONS Senior Business Analyst Pune, India Professional services major with FY’16 revenues of $13.4B and 266,000 employees serving 70,000 clients in more than 200 countries;

• Spearheaded the 7-member team from offshore, analyzed customer-centric requirements, and built a flexible digital marketing strategy for a UK based banking firm to create and maintain the content on its websites; Recognized with ‘Best Project Award’

• Performed data analysis and successfully modified the websites to improve the response time by 30% which helped in extending the business contract worth $3M for 5 years; Recognized with ‘Performance Award’ for maximizing team performance

• Formulated functional trainings (50+ hours) for content management and website development cohort, coordinating among 4 trainers from across the organization; the program has been well appreciated by senior management and replicated for other content management clients

(Mar 2014-16) COGNIZANT TECHNOLOGY SOLUTIONS Analyst Pune, India

• Collaborated closely daily with Business Analysts and Digital Marketing teams from multiple countries to gather and analyz the requirements, to create and manage the content and marketing strategies that will suit the websites of multiple nations and increase the productivity by reducing the response time of the websites.

• Created SQL tables and stored procedures to extract and manipulate data, updated stored procedures and queries to accommodate change requests from the users in SQL Server Management Studio (SSMS)

• Responsible for creating reports using MS Excel and visualizations using Tableau for daily status meetings and townhalls

(2012- Jan 14) MICIPL (System house of SIEMENS) Project Engineer Nashik, India An industrial automation firm; Automated more than 5 firms in the tenure of a year

• Designed and implemented an effective programming strategy which increased the production by 20%

• Prepared reusable modules to put analytical strategy into a structured program by using ladder logic technology ACADEMIC PROJECT

Predictive Analysis using Python and Machine learning

• Explored Lending Club data in Python, identified patterns in data and insights to analyze the impact of variables on loan returns, performed data cleaning, clustering to find target market and visualized the data using Matplotlib.

• Performed statistical analysis on Loan data using regression, decision tree and neural network to predict bad loans. Data Mining and Visualization

• Performed opinion mining on customer reviews and ratings for hotels across USA by using text mining algorithm (NLTK)

• Sentiment and Emotion mining on data of customer reviews using Tableau.

• Plotted trends over time and an interactive map of hotels and average ratings as reviews using Tableau. Online Marketing Campaign (Google online marketing challenge)

• Executed18 day online marketing campaign using Google AdWords, achieved 17,337 impressions, 2.24% average CTR