Data Analyst Sql Server

VISHALI MURUGESAN

** ******* ****, +1-416-***-****

Toronto, ON **********@*****.***

M1N 1C4

Education

University of Leeds, United Kingdom: MSc Information systems and Information Management, Sep 2016 to Sep 2017, Final Grade: Pass with Merit Key Modules: Supply Chain Management, Business Analytics and decision science, Challenges in Information Management, Information tools for organisation, Strategic Management.

Anna University - Chennai, India: Bachelor of Engineering in Electronics and Communication, Aug 2010 to May 2014, Final Grade: Pass with Distinction (CGPA: 8.79) Work Experience

Dappstreet Corporation, Toronto

Data Analyst (Current)

Analysing the cryptocurrency data and generating insights/reports, making decisions to support the business functions

Integrating and querying data from various sources feed PowerBI for insight generation

Have taken end to end responsibility from the pre-processing data to insight creation C#.net, Azure Machine Learning Studio, PowerBI, Microsoft Excel, MS SQL Server

Capillary Technologies, India

Data Analyst - Sep 2018 – Nov 2018

Worked on the analysis of bulk of CRM data received from various brands

Worked on data clean-up process with qubole after creating a DQR (Data Quality Report) using Microsoft Excel

Created insights for different brands using PowerBI based on the data shared and provided with to improve.

Qubole, phpMyAdmin, MySQL, Hive, MS SQL Server, PowerBI, Microsoft Excel

TATA Consultancy Services Ltd, India

SQL Developer - PNB MetLife, India. Oct 2015 – Aug 2016

Maintained the whole Illustration system of PNB MetLife.

Worked on the calculation part of various insurance products offered by PNB MetLife

Understood the entire business requirement shared by client, visualized the same with SQL server, and developed the business solution accordingly

Worked on front-end changes of PNB MetLife official website: https://www.pnbmetlife.com/

Microsoft Visual Studio 2013, MS SQL Server, ASP.NET, C#.NET, Crystal Reports, Microsoft Excel DBA/Developer, Prospect Mortgage, LA. Apr 2015 – Sep 2015

Worked on creating and maintaining the databases in various servers of Prospect Mortgage.

Analysed on performance improvement, established index for speed querying, introduced triggers for security purposes

Worked on Change Data Capture feature of SQL Server for capturing the schema changes.

Worked on Data Model of LOS system of prospect Mortgage using Erwin Data modelling tool.

Erwin data modelling tool, MS SQL Server, C#.NET, ASP.NET Trainee, Online Flight Reservation System Dec 2014 – Mar 2015

Created a website for booking flights – C#.Net and ASP.NET based frontend, SQL Server based Backend.

Created various webpages like flight search, manage booking, cancel booking, and view/edit profile.

C#.NET, ASP.NET, MS SQL Server, Microsoft Visual studio 2013, MS SQL Server Management Studio 2008/2012

Professional Summary

Excellent Administrating skill in SQL Server with a good exposure in RDBMS.

Broad working knowledge in performance-tuning tips and techniques of SQL Server/Hive databases.

Experienced all different stages of Software Development Life Cycle.

Flexible with changing work and work environment.

Strong experience in using complex joins for extracting data from different and multiple table sources.

Good understanding in query optimization and execution.

Excellent knowledge in Microsoft Excel and complex calculations and proficient in implementing the same in SQL/Hive.

Experienced working in a complete agile and proved an efficient team player. Course and Certifications

.NET Framework

Business English Certification – Vantage

Hadoop – Hive Query Language

Technical Skills

Programming Languages: T-SQL, C#, ASP.NET, Hive, MySQL

Software and packages: Microsoft Visual Studio 2013, Microsoft SQL Server Management Studio 2008/2012, Crystal Reports, Erwin- data modelling tool, Power BI, Microsoft Excel, Azure ML Studio, Qubole, phpMyAdmin, Cloudera (Beginner).

Contact this candidate