Data Information Technology

SALONI AJMERA

*** ******* ******, *** ****, CA **134 ******.********@*****.*** 650-***-****

EXPERIENCE

Local Insights Feb 2017 - Present

Data Analyst

• Mapping the input data sources to a common format to perform data operations on a standard schema.

• Writing the guides for engineers to perform web scrapping from counties websites. Bank of the West November 2016 – Feb’ 2017

HR Business Analyst SQL, Visier, Excel

• Performed statistical analysis and created dashboards on turnover rate, headcounts, attrition rate and other metrics.

• Created detailed analytical reports weekly and presented to HR Business Partners and Commercial Banking Group.

• Responsible for coordination of compensation including bonus plans, merit increases, promotion and performance rating.

• Performed data mining using SQL queries.

Google June 2016 – September 2016

Data Specialist, Machine Learning Team Google Spreadsheet

• Validated, analyzed and parsed the user search queries to find the pattern.

• Labelled the event data for the supervised machine learning algorithm which increased the efficiency by 40%.

• Assessed 8000 URL’s and categorized them based on rules to verify the data extraction done by the algorithm. Pluto7 May 2016 – June 2016

Intern Tableau, SQL

• Researched on how Google cloud data flow can be used to create the pipeline for performing ETL on the data.

• Created dashboards for showcasing the predicted supply and demand to the client. NASDAQ Entrepreneurial Center November 2015 – September 2016 Volunteer Data Analyst SAS, MS-Excel

• Analyzed the collected survey data to find the insights and trends from the data set.

• Worked independently to gather information through research, surveys and interviews of 500+ pre-existing centers in US. Zensar Technologies Limited-CISCO Systems January 2013 – April 2014 Software Development Engineer JAVA, Visio, Oracle, Struts Framework

• Communicated with different stakeholders to elicit and analyze the business requirements.

• Implemented business requirement, performed unit testing and wrote SQL queries which increased performance by 40%. TECHNICAL SKILL

• Programming skills: SQL, Python, R, SAS, HTML, JAVA

• Business Intelligence Tools: Tableau, SPSS Modeler, Visier

• Databases: MySQL, PostgreSQL, Oracle, DB2, People Soft

• Operating Systems: Unix/Linux, Windows

• Other: Advanced Microsoft Excel, Word, Power Point, Taleo, ParseHub EDUCATION

Golden Gate University, Ageno School of Business San Francisco, CA Master of Science in Information Technology Management, concentration - Business Data Analytics, GPA: 3.85 August 2016

• Awarded ‘Best Presenter’ by the University’s CIO for the business plan presentation among 20 students. Rajiv Gandhi Prodyogiki Vishwavidyalaya Indore, India Bachelor of Engineering, Computer Science and Engineering, GPA: 3.5 July 2012 ACADEMIC PROJECTS

Kaggle: Predicting the bike sharing demand April 2016

• Performed exploratory data analysis on dataset containing 10,000+ rows using visualization and statistical tools. R, SAS

• Performed hypothesis testing and regression analysis to find the association between variables.

• Created predictive model to predict the count of number bikes that will be rented. Udacity Data Analysis April 2016

• Performed data wrangling: cleaning, transforming and merging of datasets to analyze the data. Python

• Used numpy, matlpotlib library for finding patterns, analysis and plotting of the data.

Contact this candidate