Sr. Data Analyst

SHASHANK SHASTRI

**** ******** ****, # ***, ***********, MD 20782 301-***-**** ***************@*****.*** Education

Robert H. Smith School of Business, University of Maryland College Park, USA Dec 2015 Masters of Science, Focus Area: Information Systems Karnataka State Open University Mysore, India 2014 Master of Technology, Computer Science

Mumbai University Mumbai, India 2011

Bachelor of Engineering, Computer Engineering

Professional Experience

American Institutes for Research, Washington DC, USA Senior Data Analyst Test Information and Distribution Engine Jan 2016– Current

Optimized existing stored procedure calls to cut down processing time for setting student eligibilities by 97.2%

Partnered with developers to achieve backend ETL, hence bringing down application response time of TIDE Admin site by 10%

Authored product specifications documents regarding schooling semester for all top clients Data Analyst Intern Assessment May 2015– Aug 2015

Developed frequency distribution reports to bring down evaluation and grade calculation time by 20% using MS SQL

Initiated excel pre-processed data cleansing to reduce MS SQL Server import time Atos India Pvt Limited, Mumbai, India Jul 2011– Jun 2014 Senior Application Developer/Team Lead Global System Integration– Microsoft Practice Group

Collaborated with 5 Project Managers as primary point of contact for all client communications hence bringing down resource cost by 3 Lac INR

Spearheaded a team of 7 members in developing Imports, Exports and Onboarding portal for Siemens India

Played a major role as interviewer in hiring and developing the best – conducted over 20 interviews and helped resourcing candidates over 5 projects across 3 teams

Worked as a database administrator accountable for disaster recovery, Production/UAT/Replication servers and trigger management for stored procedures and SQL jobs Academic Projects

Upcoming Movie Profitability, Sunshine Studios – Data Mining/ Big Data Aug 2015 – Dec 2015

Worked as a Data Analyst - predicting profitability of movies by using multiple predictor variables like genre, track record of actors/directors, total box office revenue, month of release and movie rating Asthma Risk Mapping, Propeller Health – Healthcare Analytics Aug 2015 – Dec 2015

Worked as a business analyst to create visualizations and identify distributions of asthma patients and asthma inducing allergens

Technologies and Extras

RDBMS and Reporting Tools: TSQL, SQL Server 2005/2008/2012, SQL Server Reporting Services ETL Tools: SQL Server Integration Services, R Studio Programming Languages: C#, Visual Basic 6, Classic ASP UML Tools: MS Visio, Star UML, IBM Rational Rose

Webinars and Certifications: Amazon Redshift, Microsoft Certified Solutions Expert Spreadsheet: Solver Table, Sensitivity Analysis, @Risk Additional Tools: MS Office Suite

Extra-Curricular: YouTube performer, physics enthusiast

Contact this candidate