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