Anishka Tahiliani

adkfwm@r.postjobfree.com www.linkedin.com/in/anishka-tahiliani/ 315-***-****

Education

Master of Science, Information Management, Syracuse University, NY, USA May 2021

Coursework: Project Management, Information Design and Analysis, Information Management, System Analysis

Certificate of Advanced Studies in Data Science, Syracuse University, NY, USA May 2021

Coursework: Scripting in Python, Data Warehousing, Big Data Analytics, Data Science, Data Analysis Decision Making

Bachelor of Engineering, Computer Science, Mumbai University, Mumbai, India May 2017

Coursework: Object Oriented Programming, Database Management, Artificial Intelligence, Risk Management

Work Experience

BI Developer Intern, Guidewire Software, California, USA Jun 2020 - Aug 2020

•Developed CIO Dashboard in QlikSense, established KPIs to analyze attrition rate, presented to C-Suite, senior management

•Collaborated with Mentor to perform cohort analysis and identified 15% potential customers with same insurance claims

•Assisted the Director performed competitive analysis of devised metrics to migrate Enterprise Architecture system to LeanIX

•Executed trend analysis, performance measurement, forecasted customer data using Python improving time taken by 10%

Analyst, Freight Tiger, Mumbai, India Feb 2019 - Aug 2019

•Automated invoice reports and reduced execution time by 99% through ETL and leveraging VBA script

•Lead a team of 10 to generate Ad Hoc SQL scripts to team, reduced curation time and resource requirement by 52%

•Reduced freight cost by 13% for JSW Steel Ltd optimizing supply chain pipeline leveraging Python, Tableau

•Developed sales forecasting tool using Python Arima and Excel, enabled 70% accuracy rate to achieve the sales target

•Identified procedural areas of improvements in logistics using clustering techniques saving $10000 each year for milk company

Analyst, Trafigura Global Private Limited, Mumbai, India Sep 2017 - Jan 2019

•Developed a model by analyzing data, understanding requirements from traders using clustering models in Python and R

•Extracted Bloomberg, Reuters market data, created dashboard in Tableau, analyzed, forecasted market behavior for clients

•Optimized process turnaround time by 97%, developed an automation tool for manual data entry by leveraging VBA Script

•Created Excel dashboard to monitor daily price volatility of commodity market which enabled risk management for clients

Technical Skills

•Information Management / Visualization: Tableau, QlikSense, MS(Visio, Excel, Word, Power Point, Power BI, V-Lookup, H-Lookup, Pivot table),Google Analytics, JIRA, Confluence, Adobe

•Database Management: MySQL, Oracle, MS Access, Informatica, MS SQL Server Integration Service

•Programming Languages: Python, R, SQL, Ethereum, JSON, JavaScript

Academic Projects

Scripting in Python, COVID-19 Predictive Modeling for NYC Boroughs, NY, USA Aug 2020 - Present

•Utilizing regression, predictive analytics in Python to forecast the COVID-19 with NYC boroughs cases with a 91% accuracy rate

•Developing ETL using Informatica for data sources for reporting the cases using different metrics in NYC boroughs

•Constructing baseline representations for datasets using lightSIDE, evaluating machine learning CART for text representation

Data Warehouse, University Student Enrollment, Syracuse University, NY, USA Jul 2020 - Aug 2020

•Staged, loaded data using SSIS, created data flow maps, optimized Query performance by 17% to solve enrollment problems

•Implemented ETL using SSIS and SSAS, build Cubes on the dataset to analyze pivotal information of Student enrollment

•Sliced and diced OLAP cubes developed dashboard using Tableau performed analysis improving execution time by 10%

Big Data Analytics, Ride Share Commute Prediction, Syracuse University, NY, USA Jan 2020 - May 2020

•Utilized PySPark to do feature extraction and understand feature importance of a dataset of 12000 rows and 21 columns

•Leveraged Gradient Boost algorithm to predict commute time of passengers and obtained an initial accuracy of 71%

•Generated insights to enable reduction of commute time and created a dashboard to the responses on Google Analytics

Leadership

•iSchool Employer Relations Student Assistant: Establishing relations between companies and students Jan 2020 - Present

•President WiTec: Leading women in technology & race, overseeing daily operations of cloud-based projects Jan 2020 - Present

•Research Assistant: Jan 2020 - Jun 2020

Analyzed behaviors, activities of 15000 users to indicate short term forecast in learning patterns using SAX in Python

•Faculty Assistant, Blockchain Management: Aug 2019 - May 2019

Improved student engagement and inclusion by leveraging discussion and collaboration tools

Contact this candidate