Summary
Overview
Work History
Education
Skills
Languages
Personal Information
Timeline
Generic
Krishan Gopal

Krishan Gopal

Gurugram

Summary

Dynamic data analyst with a proven track record at UnitedLex India Pvt Ltd, excelling in data visualization and analytics. Expert in Power BI and SQL, I transformed complex datasets into actionable insights, enhancing decision-making. My strong analytical skills and attention to detail drive impactful reporting and data management solutions.

Overview

8
8
years of professional experience

Work History

Sr. Associate – Data Analyst

UnitedLex India Pvt Ltd
11.2020 - Current
  • Developed interactive Power BI reports and dashboards, delivering actionable insights.
  • Executed ETL processes for seamless integration of data from various platforms.
  • Crafted sophisticated SQL queries for thorough data extraction and manipulation.
  • Employed DAX to create tailored calculations, improving analytical capabilities.
  • Utilized Power Query for detailed data preparation prior to analysis.
  • Applied advanced Excel functions like VLOOKUP and INDEX-MATCH to ensure data accuracy.
  • Conducted extensive data cleansing and transformation using advanced Excel features.
  • Organized structured and unstructured raw data from diverse sources into usable formats.
  • Developed Pivot Tables and Pivot Charts to summarize, analyze, and visualize large datasets.

Associate - MIS Executive

Onkar InfoTech Pvt.Ltd
04.2017 - 11.2020
  • Reviewed and extracted various document types for data analysis purposes.
  • Cleansed data from multiple sources, enhancing overall accuracy and reliability.
  • Utilized advanced MS Excel techniques for data capture, cleaning, and transformation.
  • Leveraged MS Office tools to extract and manipulate large data volumes efficiently.
  • Applied advanced formulas including VLOOKUP, HLOOKUP, INDEX, MATCH, and OFFSET for data manipulation.
  • Organized structured and unstructured raw data from diverse sources into usable formats.
  • Developed PivotTables and Pivot Charts to summarize, analyze, and visualize large datasets.

Education

B.Tech (Computer Science) -

MDU University Rohtak (MVN College Of Education)
Palwal(HR)
05-2014

Senior Secondary Examination -

Anupam Public School
Hodal(HR)
05-2010

Skills

  • Data visualization and analytics
  • Power BI and dashboards
  • SQL querying and extraction
  • ETL processes and management
  • DAX calculations and measures
  • Data modeling and mining
  • Report generation and cleansing
  • Advanced Excel and Power Query

Languages

English
First Language
Hindi
Advanced (C1)
C1

Personal Information

Timeline

Sr. Associate – Data Analyst

UnitedLex India Pvt Ltd
11.2020 - Current

Associate - MIS Executive

Onkar InfoTech Pvt.Ltd
04.2017 - 11.2020

B.Tech (Computer Science) -

MDU University Rohtak (MVN College Of Education)

Senior Secondary Examination -

Anupam Public School

Similar Profiles

CREATE PROFILE
Krishan Gopal