Specialties: Technical Skills: --- Statistics: regression, dimension reduction, classification and clustering Computer Skills: --- Extensive experience in R and Python and Business Objects --- Some experience in Perl,Java,Shell Scripting and SQL --- Little experience in Tableau and Qlikview

Senior Data Analyst @ Tools used : Java , Python , Perl Project 1 : Build a JSON parser to process clickstream data 1. Built a perl script to parse clickstream data into files 2. Built a POC in python and java and compared performance with the perl parser 3. Ongoing effort to built a multi-threaded java parser to process clickstream data and feed it into a database Project 2 : Create an application to store and retrieve business requirement documents in spreadsheets 1. Design the database schema in oracle and built the data model 2. Did a POC to insert data from spreadsheets into the database 3. Create SQL reports to view relationships between project and its parameters Project 3 : Solved ad-hoc requests from different sources like sales.clickstream,customer satisfaction,orders and fullfiment and cross/omni channel 1. Handling data quality requests by verifying the SQL used in existing Business Objects reports 2. Reported discrepancies to the ETL / Tagging team for immediate handling of production issues 3. Creating reports using custom sql on specific scenarios or absence of existing reports From July 2014 to Present (1 year 6 months) Greater Seattle AreaData Analyst @ Tools - RStudio , Navicat Project 1 : Developed an application using SHINY to create a user interface for identifying teachers overcharging money for GRE/ GMAT classes.The application included the following features : 1. Upload flat files ( excel/csv ) 2. Filters to select 'date range' which dynamically queried data from an Oracle database 3. Display reports using GoogleVis package 4. Options to download reports in a csv file Project 2 : Identify feature importance and segmentation(per program) of a A/B testing email campaign 1. Data cleaning - check for missing values , deal with typos and missing values, create buckets for handling 'dates' 2. Randomly sample 70 % of the data and ran a random forest using different combinations of nodes and trees. 3. Computed the feature importance matrix to identify meaningful segments to be used in the A/B testing campaign Project 3 : Run queries in Navicat to provide reports for ad-hoc requests. From May 2014 to July 2014 (3 months) Greater New York City AreaGraduate Assistant @ - Researched journals and articles to collect relevant data needed to make power-point presentations - Use of 'Google Translate' and related tools to convert the English version of the presentations into Italian. - Uploading documents and maintenance of the website using asp.net From September 2013 to December 2013 (4 months) Business Technology Developer @ -Developed a statistical quality control scorecard in Qlikview 11.2 containing key performance indicators( KPI's) -The scorecard imported data from different sources- SQL Server, MS Access, MS Excel -Performed statistical analysis on quality metrics- Standard Error, Confidence limits (3 sigma) -Produced control charts for the quality metrics with phases and annotations -Created a drill down from the scorecard to the underlying control chart displaying the recent phase information highlighting key annotations and rule violations From June 2013 to September 2013 (4 months) Statistical Analyst @ - Provided statistical support for the prediction of English scores on linguistics data using the Excel Data Analysis toolpack - Performed data cleaning, multiple linear regression, ANOVA and VIF to determine collineraity between predictors - Identified anomalies and influential observations by plotting residuals to reduce the error rate From May 2012 to December 2012 (8 months)

Master's Degree, Operations Research, 3.583 @ Northeastern University From 2011 to 2013 Bachelor Of Engineering, Mechanical @ Fr.C.Rodrigues Institute Of Technology From 2007 to 2011 Nachiket Galande is skilled in: R, Statistics, Data Analysis, Matlab, Statistical Modeling, Data Mining, Machine Learning, SQL, Microsoft Excel, Python, Business Objects, Java, MongoDB