Summary
Overview
Work History
Education
Skills
Timeline
Generic

CHETHAN H O

Summary

Seeking an opportunity in a challenging environment where I can learn the latest technologies as well as add my knowledge and skills for the better productivity of the organization.

Having 10 years of experience in Financial Domain and Real Estate and 4.5 years of Professional experience in IT industry, working on Power BI Desktop, Power BI Service and , SQL, Azure data factory. Snowflake, Databricks,Currently working as BI Lead. Having Good Experience on Power BI Desktop and Service end to end Development and worked on the Power BI Reports & Dashboards and creating ADF pipeline. Hands on experience in writing SQL Queries , python data analysis library and Experience on Advanced Excel. Good exposure to windows OS. Extensively used Power bi,ADF ,SQL Develop Power BI reports and effective dashboards after gathering and translating end user requirements.

Overview

11
11
years of professional experience

Work History

Lead BI (Power Bi,Azure(ADF, Snowflake, Sql)

JLL Technologies
08.2022 - Current
  • Collaborated with a real estate company specializing in acquiring, furnishing, and leasing property assets
  • The project focused on managing and analyzing assets at various stages of development, including IT parks and hotels
  • Responsibilities included designing and implementing a Snowflake database schema, utilizing Python for data cleaning and transformation, creating interactive dashboards in Power BI, conducting risk analysis using Python-based statistical models, and providing actionable insights on project timelines and potential risks.
  • Design and develop data pipelines using Azure Data Factory (ADF) to extract, transform, and load (ETL) data from various sources into the data warehouse or lake.
  • Implement data ingestion strategies to ensure efficient and reliable data movement across different systems and environments. 
  • Utilize Data bricks for data processing tasks, including data cleaning, transformation, and enrichment, leveraging Apache Spark for scalable and parallel processing.
  • Design and develop interactive dashboards, reports, and visualizations using Power BI to meet business requirements and objectives.
  • Create compelling data visualizations that effectively communicate insights and trends from complex datasets, using a combination of charts, graphs, maps, and custom visuals.

Lead BI (Power Bi)

JLL Technologies
- 01.2023
  • Collaborated with higher management and cross-functional teams to design and implement a comprehensive pre-BAE and EBITDA dashboard, aimed at monitoring and enhancing the company's business performance
  • Responsibilities included gathering requirements, conducting data cleansing and modeling, implementing business logic layers in Power BI, and working closely with operations and finance teams.

Bi Developer (Power Bi)

NORTHERN TRUST
12.2018
  • Worked with Allstate, one of the top insurance companies in the USA, to monitor and improve business performance
  • Responsibilities included monitoring and analyzing policies and customer details, creating data monitoring reports using Power BI, and providing satisfactory services to customers.

Senior Analyst Account opening and operation research analysts

NORTHERN TRUST
10.2013 - 11.2018
  • Reviewed and investigated price at security level, provided clean reporting statements to clients, and worked with external vendors to obtain accurate prices of securities
  • Also worked on Power BI projects, gathering requirements, importing data from multiple sources, creating reports and dashboards, and publishing them to Power BI server.

Education

MFM -

MYSORE UNIVERSITY

B.Com. - undefined

MYSORE UNIVERSITY

12th Std. - undefined

SSPCB, Tumkur

Skills

Python(extensive use of pandas, databricks), T-SQL

Timeline

Lead BI (Power Bi,Azure(ADF, Snowflake, Sql)

JLL Technologies
08.2022 - Current

Bi Developer (Power Bi)

NORTHERN TRUST
12.2018

Senior Analyst Account opening and operation research analysts

NORTHERN TRUST
10.2013 - 11.2018

Lead BI (Power Bi)

JLL Technologies
- 01.2023

MFM -

MYSORE UNIVERSITY

B.Com. - undefined

MYSORE UNIVERSITY

12th Std. - undefined

SSPCB, Tumkur

Similar Profiles

CREATE PROFILE
CHETHAN H O