Summary
Overview
Work History
Education
Skills
Personal Information
Hobbies and Interests
Timeline
Generic

ANUP SINGH

Gurgaon

Summary

Overall 8+ Year’s with 4+ Years of relevant experience in IT industry, involved in BI projects & database management. 4 Years of experience in data modelling, identifying the relationships, creating flow & measures using DAX. 4 Years of experience in data warehouse & Integrating different Power bi Connectors like CRM, SQL, Cloud DB file. 4 Years of experience in designing graphical & custom visualizations with drill down option using tabular matrix. 4 Years of experience in power BI service from dashboard design, giving access & sharing report with dynamic user RLS. Currently working on power app & power automate for automating the power bi report and sharing with the stakeholder. Creating reports as per client’s requirement in the form of bookmark, page navigation, incremental refresh, schedule refresh. Worked with different filters like slicer, visual level filter, page level filter, dax filter with power query advance editor & worked on Power BI Gateway.

Overview

8
8
years of professional experience

Work History

Data Analyst & Power BI Developer

Teleperformance
07.2022 - Current
  • Collaborate with stakeholders to refine reporting requirements, ensuring that reports meet their needs
  • Develop and maintain interactive dashboards and reports using Power Bi tools and Power Platform
  • Understand business requirements and design data models and transform into meaningful insights
  • Collaborate with cross-functional team to gather requirements, identify data sources, and ensure data accuracy and integrity
  • Conduct data modelling and perform advanced data analysis, including statistical analysis and trend
  • Identify (KPIs) & performance measurement framework to track and monitor business performance
  • Pro-actively identify opportunities for process improvement, automation, and optimization of data analysis workflow
  • Create relationships between data and develop tabular and other multidimensional data models
  • Proficiency in designing entity-relationship diagrams to represent the logical structure of a database, including entities, attributes, and relationships between them
  • Capable of implementing RLS, row-level security on data along with an understanding of application security layer models & publish with different users in Power BI Service
  • Good knowledge on Data Lake, Data warehouse and Data Mart.

Power BI Developer

Sakshath Technologies
10.2021 - 06.2022
  • Developing visual reports, KPI scorecards, and dashboards using Power BI desktop
  • Connecting data sources, importing data, and transforming data for meaningful insight
  • Created Custom visualizations in Power Bi & published reports to the Power BI service
  • Collaborate with different stakeholders to work on data sources
  • Data documentation which explains Dax, algorithms, parameters, models, and relationship
  • Good knowledge of Data modeling, data pipeline, data warehousing, data visualization
  • Create customize charts and custom calculations as per requirements
  • Work with management, for each business segments like, NBFC, FMCG & HR
  • Configured gateway services for Power Bi Desktop, working with gateways and scheduling the refresh and creating reports and dashboards
  • DAX queries & measure, to develop tabular and multidimensional models that are compatible with data warehouse standards
  • Knowledge of database management system, like SQL, Aws, Azure.

Data Analyst

Origo Commodities India Pvt ltd
07.2019 - 05.2020
  • Started Creating report on power pivot using excel to present within the management
  • Created different types of visualizations using Power Bi desktop, published reports to the Power BI service, Created Dashboard and shared with the users
  • Good Knowledge on Drill down, Drill through, Bookmark, Tooltip, Power Query, Power pivot and DAX functions Loading the data from development system to staging environment
  • Created visualization reports using Power BI, using Custom column, calculated columns and measures using DAX
  • Updating weekly status and keeping track of overall development status for the project
  • Work with management, for each business segment like, Price & Warehouse capacity
  • Prepare the operational dashboard for day-to-day activities, worked on different KPI & in term of Price & Capacity of warehouse
  • Prepare custom visual chart for different dimension on MTD, QTD, YTD basis
  • Forecast Analyzing: prepare custom visual for historical price of the commodities with the current price, so that we can pitch “loan Amount” to the client, the loan amount which got approved by bank on behalf of their commodities
  • Use to prepare report on price defining the client payment details
  • On every month which are pending and need to be completed
  • Client who are on Credit of limit (Loan), Then I need to prepare the report mentioning that their collateral money margin should not be less than 30% of the Loan Amount, if it is less than 30% then I need to inform to the management & bank
  • Warehouse factor: Prepare report on State level warehouse’s staying which warehouse is fully utilized & which are unutilized to their full capacity, ultimately unutilized warehouse is the business opportunity for the company
  • If the expenses are more than the revenue, then that warehouse are considered or given more importance in terms of sales and accruing new clients.

Senior Research Analyst

Penguin International
07.2018 - 07.2019
  • Analyzing the business cycle of the client project for data mining and performing different generic data research
  • Extract data from different sources & perform data cleaning tasks, for updating those data into the database.

Research Analyst

01.2017 - 07.2018
  • Prepare company profiles on business description, diversified segment, product & services, key facts on company, management team, financial trends, competitive analysis, and present the finding to the client
  • Preparing quarterly and annual reports on different sectors Like IT, FMCG, Oil & Gas and perform SWOT & PEST Analysis
  • Prepare short news article on sectors like FMCG, Retail, Consumer durable, E-commerce.

Education

MBA in Marketing & Finance -

Indus Business Academy
Greater Noida, Uttar Pradesh
05.2013

Bachelor of Science in Information Technology -

Genius Institute of Information Technology
Gurgaon, Haryana
06.2010

Skills

  • MS-SQL
  • SSMS
  • ELT & ETL
  • Power Bi
  • Power App & Automate
  • Microsoft Excel
  • Data Modelling
  • Joins & Relationship
  • Data Warehousing

Personal Information

  • Date of Birth: 11/15/87
  • Gender: Male
  • Nationality: Indian

Hobbies and Interests

  • Indian Economy & major world economy
  • Indian & world defence technology
  • IPAnldvadiyeainnngtIunCrtreei crsknpeaottritosnal Relation

Timeline

Data Analyst & Power BI Developer

Teleperformance
07.2022 - Current

Power BI Developer

Sakshath Technologies
10.2021 - 06.2022

Data Analyst

Origo Commodities India Pvt ltd
07.2019 - 05.2020

Senior Research Analyst

Penguin International
07.2018 - 07.2019

Research Analyst

01.2017 - 07.2018

MBA in Marketing & Finance -

Indus Business Academy

Bachelor of Science in Information Technology -

Genius Institute of Information Technology

Similar Profiles

CREATE PROFILE
ANUP SINGH