Summary
Overview
Work History
Education
Skills
Timeline
Generic
Krishan Gopal

Krishan Gopal

Sr. Data Analyst
Gurgaon

Summary

A challenging position in a professional organization where I can enhance my skill & strength in a conjunction with the company’s goals & objectives to display versatility & emerge with Excellence by devoting the multifunctional skills.

As a Data Analyst wIth extensIve experIence In SQL Server, Power BI, and Advanced Excel, I wIll leverage My technical skills to transform raw data into actionable insights and drive data-driven decision-making. i will be responsible for designing and implementing robust data solutions, creating dynamic reports and dashboards, and performing in-depth analyses to support business objectives. My role involves extracting and manipulating data from SQL Server, utilizing Power BI for interactive visualization and reporting, and applying advanced Excel functions for detailed analysis and reporting.

Overview

10
10
years of professional experience
2
2
Languages

Work History

Sr. Associate – Data Analyst

UnitedLex India Pvt Ltd
11.2020 - Current
  • Proficient in writing complex SQL queries for data extraction, manipulation, and analysis.
  • Expertise in crafting complex queries, including joins, subqueries, and aggregations to extract and analyze data.
  • Proficient in using SQL Server and Power BI to create insightful reports and interactive dashboards.
  • Develop and manage ETL (Extract, Transform, Load) processes to integrate data from various sources.
  • Developed and optimized complex SQL queries to extract, manipulate, and analyze large datasets for business intelligence and decision-making.
  • Expert in DAX (Data Analysis Expressions) for creating custom calculations and measures to enhance data analysis.
  • Utilized Power Query to clean, transform, and prepare data for analysis and reporting in Power BI.
  • Expert in designing interactive and visually appealing dashboards and reports using Power BI.
  • Proficient in using Excel functions such as VLOOKUP, HLOOKUP, INDEX-MATCH, and advanced array formulas.
  • Ability to perform data cleansing, transformation, and modeling using Excel tools and features.

Associate - MIS Executive

Onkar InfoTech Pvt.Ltd
04.2017 - 11.2020
  • Very Good knowledge of reviewing and extraction of all type of Documents.
  • I Have Strong Experience as data Analyst with an Emphasis on cleansing Data from Multiple Sources.
  • Strong Background knowledge with advanced MS excels data analysis / manipulation capabilities such as Data capture, Data cleaning and Data Transformation.
  • Utilized MS Office tools for extraction Large volumes of Data (e.g., Power Query ,Macro) Manipulate Large Volumes of data Using Excel or Ms Office Product.
  • Proficient in using advanced formulas such as VLOOKUP, HLOOKUP, INDEX, MATCH, and OFFSET to analyze and manipulate data.
  • Organise Structure/Unstructured Raw data of many type From Multiple data Source with the Ability to Combine into useable data.
  • Experienced with PivotTables and PivotCharts for summarizing, analyzing, and visualizing large datasets.

Associate-Data Management

Events4Sure Pvt. Ltd. (KPO Consultants Pvt.Ltd.)
11.2016 - 03.2017
  • Research the worldwide market to identify potential prospects for global corporate events like Conference, Exhibition, expo and summit
  • Maintain the database of the companies on CRM like Bitrix
  • List down the decision makers of Those Organisation along with their contact details
  • Client follow up and co-ordination closure of sales for revenue generation payments Follow-ups
  • Contact the prospects via E-mail, LinkedIn and support the sales lifecycle including lead Qualification, pre-sales support and successful transition to direct sales.

Data Entry Operator in Market Research

Eli Research India Pvt. Ltd.
03.2014 - 09.2016
  • Capable of handling Back-Office Operations & with key focus on Secondary Research
  • Sound knowledge of preparing of MIS Reports
  • Handling& Maintaining the Team of 22 Executives
  • To coordinate with Market Researcher
  • Extracted, complied, tracked and analysed data to generate reports.

Education

B.Tech (Computer Science) -

MDU University Rohtak (MVN UNIVERSITY)

Senior Secondary Examination -

Secondary Examination -

Skills

Data Analytics

Timeline

Sr. Associate – Data Analyst

UnitedLex India Pvt Ltd
11.2020 - Current

Associate - MIS Executive

Onkar InfoTech Pvt.Ltd
04.2017 - 11.2020

Associate-Data Management

Events4Sure Pvt. Ltd. (KPO Consultants Pvt.Ltd.)
11.2016 - 03.2017

Data Entry Operator in Market Research

Eli Research India Pvt. Ltd.
03.2014 - 09.2016

B.Tech (Computer Science) -

MDU University Rohtak (MVN UNIVERSITY)

Senior Secondary Examination -

Secondary Examination -

Similar Profiles

CREATE PROFILE
Krishan GopalSr. Data Analyst