Eswarya Pillai

+1-301-***-**** adgrg4@r.postjobfree.com https://www.linkedin.com/in/eswaryapillai/ Expertise Analyst, with almost 5 years of experience in various Data operations like data analysis, data-workflows, automation, using latest analytical programs like Python, R. Very strong in writing SQL queries and can develop various daily Data quality monitoring reports, Tableau Dashboards, for product requirements and key business decisions. EDUCATION

Master of Science, Data Analytics Engineering Aug 2021 Harrisburg University of Science and Technology, PA, USA Master of Business and Administration, Finance and Marketing May 2015 SRM University Chennai, India

Bachelor of Engineering, Electronics and communication Engineer May 2013 Anna University Chennai, India

TECHNICAL SKILLS

Languages : Python, R, Shell Scripting, HTML, CSS

Databases : MySQL, Microsoft SQL Server, NoSQL

Machine Learning : Regression, Decision tree, Support Vector Machine(SVM)Classification, Clustering, Gradient Boosting using various algorithms

Data Visualization: Tableau, Powe BI, MS Suite

Big data: Hadoop, Hive HQL, Spark, Spark SQL

Other Tools & Cloud : Jupyter, PyCharm, Git, R-Studio, Jira WORK EXPERIENCE

Data Analyst @ Aimtop Construction Singapore Apr 2018 – May 2019

• Managed strategy, optimization & growth initiatives and delivered several tracking and data analytics projects.

• Applied various statistical tests and performed business data analysis using Python, MATLAB, and Excel and built various decision-making graphs using matplotlib that helped to increase business productivity.

• Analyze the cost Index of the company by utilizing Time series in R to predict future outcome and recommended actionable insights

• Enhanced analytics dashboards using Tableau, Microsoft Power BI and Data Visualization in R studio

• Managed, updated and enhanced reporting with advanced excel functions such as Pivot table and V-Lookups. Analyst @Chaithiram Construction Singapore Jun 2016 – Feb 2018

• Design and plan BI reports, as well as debug, monitor, and troubleshoot BI solutions.

• Write relational and multidimensional database queries.

• Built email campaign using various marketing software like Get Response, sending Blue

• Designed and built custom dashboard to turn large data points into actionable information, develop strategic initiatives, and marketing strategies by conducting in-depth research and analysis of companies, marketplace and competitors

• Run SAS/SQL code to assess, clean, validate and analyze large dataset to support email campaigns

•

Marketing Analyst @ IFB Industries Pte Ltd Chennai, India Dec 2014 – Mar 2016

• Maintained customer databases and managed customer promotional marketing campaigns

• Gathered and analyzed data to measure customer satisfaction effectiveness of the campaigns

• Created, updated, and presented marketing collateral that includes technical presentation, data sheets and case study

• Managed and maintained partnerships with marketing, sales, and digital teams to increase the adoption of campaign/ media strategies, promotional priorities, insights, and best practices with regional teams to support franchise titles

ACADEMIC &PERSONAL PROJECTS

Tesla Stock price Forecasting with Time Series model – R Script

• Generated CSV files form Yahoo website and store the historical data of stock price in CSV.

• Converted data into Date time format, analyzed the trend seasonal component using Additive Decomposing, method, Augmented Dickey Fuller’s to check stationary.

• Phillips-ouliaris Cointegration test and implemented Linear Regression model, ARIMA, SARIMA for forecasting

Recommendation Engine of online retail store– Sklearn, Pandas, Numpy, Pyplot,

• Recommendation engine is used for the suggest of products based on purchased product by implementing various classification algorithms like KNN, Decision Tree, SVM, Logistic Regression,Linear Kernal after Exploratory data analysis and preprocessing the data.

• Used Model evaluation to report the results.

Analyzing the Capital bike share usage – R Script

• Analyze the data, clean the data, use exploratory data analysis, implemented Linear Regression method, correlation method, statistical analysis, performed visualization to see the trend for bike rental.

• Data Visualization in R for the trend pattern to check the high usage of bikes. Data Visualization of Landfill of US– Leaflet, R script

• Generated the data from Environmental Protection Agency for creating that analyze locations and characteristics of landfills in the United States.

• Created a Polygon layer, points with labels, map using radius, rectangle layer in R COVID -19 Real time Dashboard – Tableau

• Generated CSV files from the Worldometer website and store them in CSV .

• Formulated metrics like Mortality rate, Growth from last month and designed COVID -19 dashboard to publish in tableau server.

Contact this candidate