Vasudha Sood
+1-519-***-**** *******@********.**
www.linkedin.com/in/vasudha-sood https://github.com/Vasudha1402 SUMMARY OF QUALIFICATIONS
● Over 4.5 years of work experience in data analytics, database management and software development
● Good knowledge of cloud-based technology Google Cloud Platform services
● Proficiency in database systems SQL server, Google Big Query, MySQL, Oracle
● Adept with data manipulation and data visualizations using SQL, Python, Tableau, Google Redash
● Experienced in detecting data quality issues using data mining and statistical methods like regression
● Exposure in creating ETL pipelines to transform raw data into meaningful insights and query optimization
● Strong technical expertise in UNIX, Java, JavaScript programming languages
● Exposure in designing dynamic dashboards using Tableau, Google Analytics, Plotly
● Well versed with version control tool GitLab, software development life cycle and Agile methodologies TECHNOLOGY
● Cloud Computing: Google Cloud Platform (GCP)
● Database Systems: Google Big Query, SQL, MySQL, PL/SQL,, Oracle
● Data Processing & Visualization: Google Analytics, Tableau, PowerBI (Basic), Google Redash, MS Excel
● Programming Languages: Python, Java, JavaScript
● Python Libraries: Matplotlib, Seaborn, Plolty, Numpy, Pandas -GBQ
● Notebook: JupyterLab, Google Colab
● Tools & Frameworks, GitLab, Putty, Eclipse, PyCharm, WinSCP, Toad
● Operating Systems: Windows, Linux, Unix
● Web Development: HTML, CSS
● Project Management Tool: JIRA, Agile, Scrum, Waterfall EDUCATION
Master of Applied Computing September 2019 – April 2020 University of Windsor, Windsor, Ontario
Relevant Coursework: Data warehouse and Data Mining, Advanced Database Systems Bachelor of Technology-Computer Science July 2010 - May 2014 Amity University, India
RELATED WORK EXPERIENCE
Embedded Systems Big Data Intern
Geotab, Oakville, Ontario September 2019 – June 2020 Technology: Python, BigQuery, SQL, GCP, Tableau, GitLab, JIRA, Google Analytics, MS Excel
● Develop pipelines to run data ETL jobs on daily/hourly basis to extract, clean and analyze petabytes of data
● Altered and cleaned existing SQL queries reducing the overall cost of project in BigQuery
● Monitored performance, failures, data quality issues related to loading the data in Google Cloud Datawarehouse
● Performed data testing using ETL unit testing scripts for ensuring data integrity and data validity
● Designed dashboards, metrics to monitor data quality, performance & provide understanding of Geotab vehicles
● Performed data mining to interact with terabytes of data and provide meaningful insights for Geotab product suite
● Used GIT as configuration Management tool to have version control and performing code reviews
● Used JIRA for issue tracking, ticket resolution, project mapping, task distribution and management Web Developer (Volunteer-Internship) October 2018 - December 2018 SiliconBrane Inc., Windsor, Ontario
Technology: Tableau, Java, JavaScript, HTML, CSS, MySQL
● Created Tableau Dashboards with interactive views, trends and drill downs with different KPI measures Vasudha Sood Page 2
● Developed data model and database system based on business requirements
● Deployed two websites using JavaScript, HTML and CSS from scratch to the end Project Analyst September 2014 – February 2018
Wipro Technologies, India
Technology: Python, MySQL, PL/SQL, Tableau, UNIX, Oracle11g, Java, JavaScript
● Developed dashboards for analyzing Business KPIs in order achieve SLA using Python, SQL and MS Excel
● Automated business daily, monthly, and quarterly reports using complex queries and PL/SQL procedures
● Utilized SQL for root cause analysis and trend analysis on recurrent incidents, reducing the count by 25%
● Performed data migration and data extraction from different sources of data
● Developed Tableau data visualization using Cross tabs, Heat maps, Scatter Plots, Geographic Map and bar charts
● Development & maintenance of application by contributing to issue fixing for frontend and backend modules
● Received the award “Best Achiever” and “Round of Applause Award” Software Developer Intern May 2013 – July 2013
HCL Technologies
Technology: Java, JavaScript, HTML, CSS, MySQL
● Worked for 3 months as a trainee on development of Complaint Management System application
● Gathered and defined customer requirements to develop well-organized project plans based on clear specifications
● Designed the relation database model and connected the database using JDBC with the application ACADEMIC PROJECTS
DataSaur (Sentiment Analysis) September 2018- December 2018 University of Windsor
Technology: Python, Django, SQLite3, HTML, CSS
● Analyzed the twitter data using natural language processing algorithm TextBlob
● Visualized the data retrieved from Twitter geographically and performed emotion recognition using Python
● Awarded the second position among 50+ project during Demo Day GitHub Link : https://github.com/Vasudha1402/Sentiment-Analysis PERSONAL PROJECTS
Titanic Survival Analysis April 2019
Technology: Python, NumPy, Pandas, Seaborn
● Performed data processing and analyzed data from Kaggle dataset using NumPy and Pandas.
● Demonstrated and visualized different survival scenarios using statistical visualization. GitHub Link : https://github.com/Vasudha1402/Data-Analysis-Titanic-Dataset ADDITIONAL TECHNICAL TRAINING
● Power Bi (www.udemy.com) Dec 2019 -Present
● Tableau (www.udemy.com) April 2019 -Present
● Python for Data analysis and Visualization (www.udemy.com) December 2018 - April 2019
● JIRA Software: Basic Administrator (www.lynda.com) April 2019