Ezhilan Natarajan Kannudurai

**** - **** ******** ****** ****, Toronto, ON, M1E 2R4 705-***-**** ad4hkx@r.postjobfree.com

LinkedIn: https://www.linkedin.com/in/ezhilannk/ Portfolio: https://ezhilannatarajankannudurai.weebly.com

PROFESSIONAL PROFILE

Experienced Data & BI Analyst with over five years of experience in manufacturing, banking, insurance and logistics, with proven experience in requirements gathering, stakeholder communication and business documentation. A strong business development data professional with hands-on experience in data migration, data modeling and statistical analysis. A highly motivated individual who is eager to learn and pays strong attention to detail and always look for ways to implement new data processing techniques and strategies.

HIGHLIGHTS OF SKILLS AND QUALIFICATIONS

SQL (Snowflake, SQL Server & Oracle)

Google cloud (Big query)

Power BI

Data Warehousing

Python

Advanced Excel

Data Modeling and Storytelling

Statistics & Probability

ETL (Talend, SSIS)

Product implementation & development

MS Power apps

Agile and Scrum

Data Build Tool

Strong written and verbal communication

MS Visio

Gap analysis

WORK EXPERIENCE

Data and BI Engineer

Passerelle Data, Toronto, ON

JUL 2021 - NOV 2023

Skilled in requirements elicitation, product demo session, knowledge transfer sessions with clients.

Assessing the needs of the clients and prescribing suitable solutions.

Handling customized product development and product implementation.

Creating Data warehouses in Snowflake for product installation (Data Rocket).

Migrating raw data from multiple sources to Snowflake using ETL tool (Talend Studio).

Creating Data Models for clients to facilitate data storytelling.

Identifying KPIs and developed dashboards in Power BI to bring out Business Insights.

Created Proof of Concepts (PoC) using Snowflake, SQLDBM and DBT to enhance/ organize the warehousing/ modeling process more efficiently.

Handling multiple projects where clients operate in Banking, Retail and Logistics.

BI Developer

Toyota Manufacturing Inc., Cambridge, ON

FEB 2021 - APR 2021

Gathering requirements from different teams like Finance, Labor, IS, and Management.

Identifying stakeholders within the organization, acquired the diversified knowledge within the organization.

Successfully handled stakeholder engagement throughout the project.

Proposed enhanced data modelling techniques to avoid undesired results (from structured data) and create customized visuals.

Developed financial management dashboard and heatmaps using Power BI.

Implemented cost cutting measures to help stakeholders optimize business process by identifying the underlying problems.

Successful completion of user stories and tasks using Jira board.

Produced eight project deliverables including reports, BPMN diagrams, dashboards and knowledge transfer documents.

Business Data Analyst (Intern)

Cambrian College of Applied Arts and Technology, Sudbury

MAY 2020 - JUN 2020

Involved in Market Research to identify vendors (Stakeholder Identification) whose product matches with client's requirements.

Business Proposals were requested and debriefed to management.

Price points were discussed & negotiated to ensure win-win situation is attained for both parties.

Highly proficient in technical writing, as all of the projects were documented (code, dashboard preparation, stakeholder details & first point of contact, etc.)

Created an automated data mining tool using Python to accumulate leads from social media (Instagram) for the marketing team.

Skilled in creating personal views, charts and dashboards in Microsoft Dynamics CRM.

Integrated Power BI with College's CRM to comprehend data with professional visuals.

Created advanced dashboard in Power BI that imports data from MS Dynamics CRM to identify insights.

Created a workflow that automatically responds (depending on different stages/ phases) to leads, for better Customer Service.

CRM Assistant

Cambrian College of Applied Arts and Technology, Sudbury

AUG 2019 - APR 2020

Created dashboards and personal views in Microsoft Dynamics CRM.

Handled data inserts, updates and merging of data in Microsoft Dynamics CRM.

Created an automated tool (VB.NET) to ensure data integrity is maintained and data redundancy is identified.

Ensured data collected from miscellaneous data sources are brought into CRM, thereby avoiding silos.

Prepared user manual for knowledge transfer and other educational purposes for leadership team.

Business Analyst (Intern)

Cambrian College of Applied Arts and Technology, Sudbury

MAY 2019 - JUN 2019

Created forms using MS Power Apps that connects with Microsoft Dynamics CRM.

Gathered requirements from client and prepared documents (Vision, BRD and SRD) accordingly.

Market Research was undertaken to identify applications that aligns with the client's requirements.

Prepared FRD, use cases and user stories using Jira.

Performed in-depth analysis of current business processes.

Created an 'As-Is' model in using Microsoft Visio (Business Process Mapping).

Prepared a strategic model to automate the manual process with proposed solution.

Created a 'To-Be' model that enhances performance by eliminating manual activities and decreases processing time.

Identifying potential vendors whose product profile matches with the client's requirements.

Hosted a meeting between the client (leadership teams from different departments) and the vendor (App development company) for product demonstration.

Delivery Associate Software Engineer

Mphasis Ltd. (Blackstone company), Chennai, India

OCT 2015 - FEB 2018

Extensive knowledge and experience in SQL (Oracle 11g and MS SQL Server 2012).

Highly skilled in writing complex queries, cursors, functions, stored procedures, triggers and packages.

Proficient with both Relational databases (SQL Server, Oracle, MySQL, PostgreSQL) and NoSQL databases (MongoDB and Cassandra).

Generated Business reports using Business Intelligence tool (Power BI).

Skilled in connecting different data sources to a Data Warehouse (DW).

Proficient in ETL tools like SSIS, Talend and IBM DataStage.

Experienced in creating reports using SSRS.

Performed Online Transaction Processing (OLTP) in MS SQL Server.

Skilled in performing Online Analytical Processing (OLAP).

Experienced in data modelling, data mapping and data pipelining.

Performed data cleansing activities to identify errors and detect outliers in data.

Created data marts from data warehouse for data storytelling.

Proficient in python programming and libraries related to data science (like Pandas, NumPy, Scikit, TensorFlow, Seaborn, etc.)

Skilled in performance tuning to fetch data faster from Databases/ Data Marts.

Skilled with availability groups, High-availability and Disaster Recovery (HADR).

Involved in POCs (Proof of Concepts) that integrates various technologies like NodeJS, ASP.NET, ADO.NET, SQL Server & MongoDB and APIs.

Created several windows applications (customizable) to eliminate manual tasks using C#.

Skilled in writing Shell scripting and batch processing.

Experienced in Database design and scheduled jobs to ensure enhanced quality and performance.

Skilled in databases, DB backups, DB recovery and granting/ revoking permissions.

Created and updated High-level documents for each and every project handled.

EDUCATION

Post-Graduate Diploma in Business Analytics SEP 2019 - JUL 2020

Cambrian College of Applied Arts and Technology, Sudbury, ON

Post-Graduate Diploma in I.T. Business Analysis SEP 2018 - JUL 2019 Cambrian College of Applied Arts and Technology, Sudbury, ON

B.Eng. in Electronics and Communication Engineering AUG 2011 - MAY 2015 Sree Sastha Institute of Engineering and Technology, Chennai, India

CERTIFICATIONS

Talend Data Integration – Basics, Talend Academy

Talend Data Integration – Advanced, Talend Academy

Talend Cloud Administration – Basics, Talend Academy

Talend Data Catalog – Basics, Talend Academy

Contact this candidate