Data Analyst Business

Ezhilan Natarajan Kannudurai

**** ******** ****** ****, *******, ON, M1E 2R4 705-***-**** *******.**@*****.***

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

TOP CLIENTS

Handled top clients like Renasant bank, Berkshire bank, Credit Union of Colorado, Royal Bank of Scotland, American International Group and Stearns Lending.

PROFESSIONAL PROFILE

Data & BI Analyst, with over six 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 pays strong attention to detail.

HIGHLIGHT OF SKILLS AND QUALIFICATIONS

SQL (SQL Server & Oracle)

Snowflake & Google Cloud (BigQuery)

Power BI

Data Mapping, Data Profiling & Data Warehousing

Python

Excel (VBA)

Data Modeling and Data Storytelling

Statistics & Probability

ETL (Talend, SSIS)

Product development & implementation

MS Power Apps

Agile, Scrum, Jira, Confluence and BitBucket

Data Build Tool DBT

Strong written and verbal communication

MS Excel, Power Point and Visio

Gap analysis

WORK EXPERIENCE

Data and BI Engineer

Passerelle Data, Toronto, ON

JUL 2021 - NOV 2023

Previous company website: https://passerelledata.com/

Created data pipelines using Talend Studio and maintained the artifacts in Talend Cloud, by creating jobs and plans.

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

Proposed new data architecture/ frame work for the software product.

Installed and maintained product’s data architecture in the client environment.

Assessing the needs of the clients and prescribing suitable solutions.

Handled customized product development and product implementation.

Creating data warehouses, database schemas, tables, store procedures using SQL.

Skilled in setting up the data warehouses in Snowflake (Azure and AWS instances).

Experienced in cleansing data (using SQL, python or ETL tools like Talend) and preparing the cleansed data for transformation and analysis.

Created the third stream of the product specifically targeting the Snowflake Share between vendors’ and clients’ environment.

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

Migrating raw data from multiple sources to Snowflake using Talend artifacts.

Creating Data Models for clients to facilitate reporting using data visualization and analytics to provide strategic insights.

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

Created Power BI dashboard for Commercial Real Estate (CRE) for Berkshire bank that facilitates the organization in deciding the rates without affecting the sales pipeline.

Handled Data Mapping and Data profiling in Snowflake Staging (before transformation) and Analytics (after transformation) databases.

Data transformation in Snowflake using DBT core to enhance and organize the data in the data warehouse.

Experienced in creating data models using DBT core that facilitates data lineage.

Created and maintained Jira board tasks for measuring the timeliness of the project.

Created and maintained client-facing confluence pages for the software product.

Handled multiple projects for clients in Banking, Retail and Logistics and provided customer-centric solutions.

Custom product development, product installation and BI development (as professional services) was carried for Berkshire bank, Renasant bank and Credit Union of Colorado.

BI Developer

Toyota Motor Manufacturing Inc., Cambridge, ON

FEB 2021 - APR 2021

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

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

Handled stakeholder engagement throughout the project.

Developed financial management dashboard and heatmaps using Power BI for reporting the current financial standing to the higher management.

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

Proposed enhanced data model to avoid undesired results and created customized visuals for the finance department that could cut costs by at least 5% from the current budgeting data model.

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, Sudbury, ON

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.

Adept in data analysis using SQL and python (pandas, scipy, sklearn, numpy, seaborn and matplotlib) for hypothesis testing and predictive models (using linear regression or ANOVA).

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

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

Reported from multiple data sources to recommend data driven decisions to the problem statement.

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

Created an automated tool using Python for targeted marketing that improves marketing leads on an average by 30% and reduced cost by 40%.

CRM Assistant

Cambrian College, Sudbury, ON

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 multiple data sources are brought into CRM, thereby avoiding silos.

Prepared an automated Excel (VBA) that identifies and reports the data duplicates, improving data quality and saving manual labor (estimated at about 10 hours a week), 25% of a workweek.

Prepared reports, presentations and suggested actionable recommendations to the higher management to boost efficiency.

Business Analyst (Intern)

Cambrian College, Sudbury, ON

MAY 2019 - JUN 2019

Created forms using Power Apps that collects information from users and injects them to Microsoft Dynamics CRM.

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

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

Prepared documents on industry trends, their use cases and user stories using Jira.

Documented '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 for every event, estimated around 15 hours per event (thereby improving efficiency by 37.5% in a work week).

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

Delivery Associate Software Engineer

Mphasis Ltd., India

OCT 2015 - FEB 2018

Highly skilled in writing complex queries, cursors, functions, stored procedures, triggers, packages ad their performance tuning techniques in T-SQL (Transact SQL) and PL/SQL.

Proficient with Relational databases (SQL Server, Oracle, MySQL, PostgreSQL) and possess working knowledge in NoSQL database (MongoDB).

Generated Business reports (general and paginated reports) using Business Intelligence tool (Power BI) and SSRS.

Handled data analysis and automation scripts in T-SQL for Royal Bank of Scotland (RBS) as part of ODC (off-shore development center) project.

Created data pipelines using IBM DataStage for client AIG (American International Group).

Created financial reporting dashboard in Power BI for Stearns Lending.

Performed Online Transaction Processing (OLTP) and Online Analytical Processing (OLAP).

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

Skilled in database backups, recovery and administration.

EDUCATION

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

Cambrian College, Sudbury, ON

Post-Graduate Diploma in I.T. Business Analysis SEP 2018 - JUN 2019 Cambrian College, Sudbury, ON

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

CERTIFICATIONS

Microsoft Certified: Power BI Data Analyst Associate

Talend Data Integration - Advanced, Talend Academy

Talend Cloud Administration - Basics, Talend Academy

Talend Data Catalog - Basics, Talend Academy

ADDITIONAL INFORMATION

Working status - PR of Canada.

Contact this candidate