Summary
Overview
Work History
Education
Skills
Interests
Timeline
AccountManager

Smruti Ranjan Gumansingh

BI Analyst
Bhubaneswar

Summary


Motivated, Teamwork- oriented , ambitious and hardworking individual looking forward to work with team/Organization that will allow me to utilize my skills to broaden and enhance my experience in the area of Business Intelligence and Reporting


  • Having 7+ years of experience in BI and reporting Understanding the customer's business requirements.
  • Having 4+ years of experience only in HR reporting
  • Good understanding of HR Metrics & KPI’s for reporting
  • Skilled understanding of data analysis to effectively interpret findings in a way that makes sense to end users
  • Detail-oriented, thorough, and vigilant to collect all necessary data without missing critical components
  • Developed Power BI Reports and Dashboards using Guided Analytics Approach & Agile Methodology
  • Experience in data preparation using Power Query and enhancing data model using DAX
  • Experience in Managing global Stakeholders and providing support as per their request.
  • Having good understanding of Datawarehouse concepts
  • Having Good Understanding of SSAS Tabular model cube creation and deployment.
  • Familiarity with other BI tools like QlikView & Tableau
  • Hands on retrieving of external data from SQL SERVER to Power BI.
  • Used SQL concepts like Aggregate Functions, Group by, Date & time functions, joins, views in Analyzing data in SQL server .
  • Self-driver, excellent technical resource, a team player with good analytical and strong commutation skills.

Overview

8
8
years of professional experience
4
4
years of post-secondary education
3
3
Languages

Work History

BI Analyst

Capgemini Pvt . Ltd
Kolkata
07.2017 - Current
  • Gathering the requirement from business users and analyzing those requirements
  • Identifying the tables and attributes as per Business Requirement for Development of Dashboard.
  • Created Views in SQL server to extract the specific set of data attributes required for development of Reports/Dashboards
  • Fetching data from SQL server into power BI and develop data model suitable for Reporting
  • Cleansing the Massaging data received using Power Query to optimize the data Model.
  • Created Measures and calculated columns as per Business requirement using DAX
  • Responsible for Change request received and action on it as per timeline.
  • Publishing the dashboard to Power BI service (workspace) and updating the app
  • Responsible for granting users access to reports using Row level -security
  • Created alerts for KPI’s and scheduling refresh of Reports/ Dashboards in Power BI service
  • Publishing monthly validation report as requested by stakeholders
  • Investigating the anomalies from source system to Group dashboards and provide quick resolution to it
  • Stakeholder Management and support wherever required


Analyst

Tetrasoft India Pvt. Ltd
Bengaluru
11.2013 - 06.2017
  • Recommended process improvements to continually identify, analyze and fix constraints and challenges.
  • Discovered root causes of problems and identified appropriate solutions.
  • Involved in Understanding Business requirements, analysis and translate into Application and operational requirements, Involved in Database Extraction using QlikView and storing them in QVD.
  • Involved in the Requirements gathering (gathering, analyzing, and documenting business requirements and data specifications)
  • Gathering data sources like QVD files, Excel, txt files in developing the QlikView Data Models..
  • Developed QlikView Dashboards using Chart Box (Drill down & Cyclic Grouping), List box, Input box, Table box, Multi box & Calendar.
  • Implemented Ad-hoc Analysis and shared the insights with Stakeholders
  • Involved in Access management of Dashboards through QlikView Management Console

Education

B. Tech in Information & Technology - Information Technology

Bhubaneswar Engineering College
Bhubaneswar
06.2008 - 06.2012

Skills

    Microsoft Power BI

undefined

Interests

Travelling

Music

Photography

Swimming

Football

Timeline

BI Analyst

Capgemini Pvt . Ltd
07.2017 - Current

Analyst

Tetrasoft India Pvt. Ltd
11.2013 - 06.2017

B. Tech in Information & Technology - Information Technology

Bhubaneswar Engineering College
06.2008 - 06.2012
Smruti Ranjan GumansinghBI Analyst