SHANKARI SEETHALAKSHMI MOHANAKRISHNAN

www.linkedin.com/in/shankari-sm Chicago ac49vc@r.postjobfree.com +1-646-***-**** OBJECTIVE: I seek an opportunity to augment my knowledge on predictive analytics & MSBI gained from my work experience, by learning in an environment that is conducive to collaboration with experienced professionals who share my passion. EDUCATION

Illinois Institute of Technology Masters in Information Technology Management (GPA-3.8/4.0) 2016 – 2018 College of Engineering Guindy Bachelor’s Information Technology (GPA-3.67/4.0) 2011 – 2015 EXPERIENCE

ITM Department, IIT, Chicago – Graduate Teaching Assistant Sep 2017 – Present

• Guided students by teaching them T-SQL and relational models.

• Assisted professor by tutoring for the topics in Business Intelligence and Data analytics. IIT, Chicago - Technology Assistant to Associate VP of International Affairs Apr 2017 – Sep 2017

• Created and documented flow for agreement and admission process for research students at IIT using Visio.

• Generated reports and dashboard using salesforce & Excel for comparing admission of international check-in students. Temenos India Private Limited, Chennai, India – Data Analyst Jul 2015 - Aug 2016 Pricing strategic modelling for a Retail Shopping Center

• Designed ETL for a local retail store using SSIS by efficiently moving data from extracts and database into a common staging.

• Generated cubes for determining the bestselling products based on time dimension at a granularity of month level.

• Designed dashboards in excel using pivot tables and forecasted sales of products by obtaining insights from SSRS reports. National Informatic Center – Data science Intern Jul 2014 - Jun 2015 Customer and Market Research team of a large software company

• Predicted market shares of software products using time series forecasting. Research team of a healthcare Organization

• Built a risk model to predict the existence of cardiac disease on a thalassemia major patient by using logistic regression model.

• Performed hypothesis testing on claims data to understand the factors influencing cardiac disease. Marketing Operations team of a Global Retail Business

• Designed a strategy to provide targeted customer service by segmenting customers using clustering algorithm.

• Developed an interactive dashboard using Tableau to analyses product performance and identify underperforming market. SKILLS

• Analytic Tools: Python, R, T-SQL, PL/SQL, Excel (PowerPivot, Pivot tables, lookup function) & VBA.

• Big Data Tools: Hadoop (Map Reduce), Sqoop, Hive, Spark.

• Business Intelligence Tools: SSIS, SSAS, SSRS.

• Visualization: Tableau, Power BI, Visio.

• Database – Oracle, MS Access, SQL Server, MySQL

• Programming Language: C, C++, Java.

• Methodologies: Waterfall, Agile.

• Machine Learning Techniques: Hypothesis Testing, Statistics, Predictive modelling, Forecasting, Association Rules, Clustering, classification, Regression, Decision tree, Time Series.

• MSBI Concepts: Data & control flow, Matrix & Tablix crystal reports, star & snowflake schema, ETL, data modelling. ACADEMIC PROJECTS

Titanic Survivors – Data Mining in R (Kaggle Statement)

• Handling missing data and cleaning the TITANIC dataset using predictive modelling techniques.

• Implemented random forest algorithm to predict what sort of people likely to survive on the TITANIC. Black Friday Sales Dataset– Big Data Analytics

• Dumped data from RDBMS into Hadoop by using Sqoop for performing analytics on HDFS files

• Created complex HIVE queries to predict total sale and sales amount based on category. CERTIFICATIONS

• Information Technology Infrastructure Library December 2016

• Implementation a Data warehouse with Microsoft SQL Server January 2018

Contact this candidate