PRAKASH N. - 17746 Data Analyst - Informatics And Systems from Canada
User ID
PRAKASH N. - 17746
Windsor, Canada
8:10 AM, GMT -05:00

PRAKASH N. - 17746 Data Analyst - Informatics And Systems from Windsor


• About 2+ years of experience as Azure Data Engineer in Developing, Analyzing, Designing, and Implementing Data Engineering and Analysis solutions in Microsoft Azure, ADF, ADL, Azure SQL, Azure Synapse, ADB and PowerBI • Experienced in retrieving various data from different Data servers and validating it, cleaning it, and manipulating and transforming the data using, Python scripts, SQL, Excel Macros and Advanced Excel • Worked on creating Data engineering pipelines in Azure to ingest, clean, transform and migrate the data from various data sources to Azure data lake • Experienced in migrating data and databases from on-prem infrastructure to the Azure data lake. Raw data transferred to Azure Storage containers and processed by Azure functions and then stored in Cosmos DB • Excellent in Ingestion of Large Datasets using Python, writing Python codes to automate the interaction, and downloading of data as per the data frequency from REST API, Azure Storage, FTP servers or any client-side application which act as a data source • A creative and results-driven data analyst with expertise in tackling complex business problems using Data Analytics and Business Intelligence tools, analyzing business problems, and finding creative solutions using a data-driven approach • Developed and implemented data analysis, data collection systems and other strategies that optimize statistical efficiency and quality. Acquired data from primary or secondary data sources by own software developed in Python. Identified, analyzed, and interpreted trends or patterns in data sets • Built classification models based on Logistic Regression, Decision Trees, Random Forest, Support Vector Machine, and Ensemble algorithms to predict the probability of data • Experienced in developing, maintaining, and processing large databases with complex relationships between tables. Written several advanced SQL queries for extracting relevant data for predictive analytics • Motivated and results-driven Data Analyst with proven track record in data analytics and process mapping using Excel, Tableau, and Power BI • Good at key metrics and charts, building sophisticated business intelligence solutions, and applying data visualization techniques to provide better insights to assist in business decision making • Proficient in SQL, Python, Azure cloud technologies and very comfortable with working with large data sets and can perform a variety of data analyses, cleaning and ingestion and curation using Python and visualize them using Tableau and Power BI for analysis • Superior skill in Advanced Excel on conditional formatting, count, data validation, index, match, sum, pivot table, VLOOKUP, and data table • Proficient knowledge in statistics, mathematics, and analytics with excellent understanding of business operations for effective analysis of data • Experience building ETL data pipelines, Data modeling & design, and writing complex SQL queries involving multiple CTEs and numerous table relationships • Well-versed in using analytical techniques on large data sets for delivering ad hoc analysis and development of business intelligence. Advanced Tableau user to analyze the data, develop Dashboards and to generate sophisticated reports to exhibit data visualization results • Proven ability to identify business needs and develop valuable solutions to drive accuracy and process optimization. Drives business success with recommendation based on data findings • Worked in Agile environment and exhibited strong communication skills and a keen understanding of project timelines and dependencies. Team player with excellent interpersonal skills, self-motivated, dedicated and understanding

Data Analyst - Informatics And Systems

Work experience
2022 - Present
Data Analyst
Manulife Financial
2021 - 2022
Data Engineer
University of Toronto
2019 - 2020
Data Analyst
2020 - 2021
University of Windsor
Master of Engineering - Industrial Engineering
2015 - 2019
Bachelor of Technology - Mechanical Engineering
March 2024


2 Y
Business Metrics
2 Y
Data Acquisition
2 Y
Data Lake
2 Y
Data Migration
2 Y
Data Sets
2 Y
2 Y
2 Y
2 Y
2 Y
Power BI
2 Y
2 Y
Python Programming
2 Y
R Programming Language
2 Y
2 Y
SQL Server Integration Services
2 Y
SQL Server Reporting Services
2 Y
2 Y
Visual Basic for Applications
2 Y
Windows Azure Platform
2 Y

Geolance is a search engine that combines the power of machine learning with human input to make finding information easier.

© Copyright 2024 Geolance. All rights reserved.