top of page
UNAIS MK
Experienced Business Intelligence analyst with expertise in multiple BI tools and languages. Has nearly 4 years of experience in analyzing data, automating reports, building dashboards, data modeling, Querying, stakeholder management and delivering the projects, working with a Passion to turn scratch data into insightful dashboards using Tableau, SQL, Power BI, ETL, and Excel.
Intro: About
Skills & Tools
Business Intelligence, Data - Analysis, Transformation, Integration, Preparation, Cleaning, Collection, Modelling, Visualization, Presentation, Documentation, Database management & Tableau Server Management.
Tableau
Strong expertise in the Tableau ecosystem including Tableau Desktop, Tableau prep, and Tableau server management. Experienced in advanced functions like Custom Visualization, Table Calculations, Custom SQL queries, Figma integrations, etc
Power BI
Prepared various dashboards using calculations and visualizations including custom visualizations. Expertise in Dashboarding, Visualizing, Data Reporting, DAX, and Using Power Query for Data Modelling, Cleaning, and Transformation in Power BI.
SQL
SQL specialist with a Hackerrank gold badge and Maven analytics MySQL Specialist badge, Well versed in numerous functions like CTE, Ranking functions, Group by extensions, Windows functions, Joining, Union, Aggregation functions, Analytical functions, Sub queries, Database management, Triggers, Data
normalization, Stored procedure, etc
Data Studio & Looker
Developed real-time dashboards in Google data studio as per the requirements. Explored the various features of the tool including dashboarding, reporting, calculations, parameters, spatial data analysis, scheduling delivery, filters including page level and date filters, Pivoting, exploring the charts etc
ETL Tools
Explored various ETL tools based on requirements for transforming and cleaning the data including AlteryxTableau prep & Power Query,
Advanced Excel
Familiar with various advanced excel features and functions including Vlookup, Hlookup, Index, Match, Pivoting, Macro, VBA, Data Modeling, etc
Intro: List
Career Steps
Data Science Associate
UL Technology Solutions
14/10/2019 to 14/10/2020
Comprehensive understanding of BI tools like Power BI, Tableau, SQL, Excel, Python, Database management, and ETL. Also done various learning projects in Data analysis including dashboarding, Reporting, Data cleaning, Data manipulation, Data transformation and Presentation.
Data Science Analyst
UL Technology Solutions
14/10/2020 to 02/09/2022
Managing end-to-end business intelligence solutions by handling projects straight from requirements gathering to building a strategic plan product to meet customer needs and timelines. Also handling the server environment and providing support in the deployment of BI solutions. Working on various business intelligence projects includes requirements gathering, data preparation and transformation, reporting and dashboard preparation, and delivering the same to clients.
Senior Analyst
Factspan Analytics - Data Visualization
08/09/2022 to Present
Expertise in Tableau dashboard development, admin portal and point of contact for all the tableau related issues. Developed and enhanced 100+ dashboards and saved approximately $0.5M/month. Developed a self-serve power bi dashboard (Canned report dashboard)) to the top officials for helping them to customize the crosstabs by choosing dimensions and measures and there by proper further analysis o Well versed in complex SQL queries in Tableau for custom SQL, validation of data in GCP and data modeling.
Intro: List
Weekly Business Review Report
As a part of Factspan
Developed a Weekly Business Review – WBR Report for Macy's, which including the Financial, Sales, Advertising, Promotional Campaigns etc. This report acts as the one stop solution for all the analysis and insights of the marketing team of the client.
Self-Serve Canned Report
As a part of Factspan
Created a self-serve report using the latest features of Power BI including field parameter. The report helps the clients to play with dimensions and measures as ensure the user defined matrice output for deep analysis
Intelligent Property Management System (IPMS)
As a part of ULTS
Developed the Dashboards for Local Self Governments (LSGDs) in Kerala for Proper Asset and Citizen management. It includes property tax estimation of each and every property and also various socio - economic analysis including Disaster management, Beneficiary Identification, Health facility analysis, Education and Employee matrix and other use cases to enhance the Policy making and Fund utilization of LSGD's. Also developed ETL pipeline to automate the QA/QC tasks of the first level data.
Talent Capacity Management (TCM)
As a part of ULTS
Automated the Skill, Resource and Department utilization along with the Demand - Availability skill gap mapping through proper data transformation and calculations with proper dashboarding. The same helps the HR teams to get a real-time view of the requirements which were a manual tasks previously
Vehicle Tracking System (VTS)
As a part of ULTS
Implemented Vehicle Tracking System for ULCCS for tracking the position, maintenance, mileage, and other aspects of all the running vehicles of the firm. It also includes employee view and analysis on the expenses to find out the pain points. Enhanced the dashboards with Figma integration
Analysis Report on Sri Lankan economic crisis 2022
Developed a detailed dashboard to share the insights on the causes on Sri Lankan economic crisis 2022. It includes the data collection from various sources including web scrapping, data cleaning, preparation and economic model developments to the dashboard preparation
Personal Project
Kerala Floods overview
Personal Project
Developed an Interactive dashboard on Kerala floods 2018 -19 . It includes the main causes, how do people & government of Kerala responded to a 'fist-in-lifetime' disaster, post flood assessment survey key insights and an overview of the donations received from various resources to the official relief fund and its expenses. Collected authentic data from various sources including National water commission and Kerala State Disaster Management Authority.
Members overview of The Great Indian Parliament
Prepared a dashboard using the official data from Lower house and Upper house websites of Indian Parliament. It includes diversity among the members of the parliaments, It includes state level, party level, profession level, gender level, age level diversities.
Personal Project
Door to FIFA World Cup - Qatar 2022
Personal Project
Developed a dashboard to find out the end-to-end details of the Upcoming FIFA World Cup Qatar 2022. It includes the map view of the stadiums and fixtures with in depth details of the stadiums. I have used the background image in map feature for the same.
Dashboard on Employee Data
Developed the dashboard using employee data from Kaggle data sets and it includes various analyses including a salary tree, performance report, age to salary view, various KPIs etc
Personal Project
Procurement Data Dashboard
Personal Project
Detailed report on the procurement data
Intro: List
Intro: Blog2 Custom Feed
Certifications
Intro: Projects
Intro: Contact
bottom of page