Summary
Overview
Work History
Education
Skills
Project
Timeline
Generic

Priyanka Kumari

BI Analyst || Data Analyst
Bengaluru,KA

Summary

Prudent Business Intelligence Analyst with 5.2+ years providing employers with valuable and actionable data to drive customer success and customer services . Practiced at filtering information to find and highlight vital metrics and revelatory findings. Keen support business growth by leveraging intelligence assets to predict and reveal optimal business strategies.

Overview

5
5
years of professional experience
4
4
years of post-secondary education

Work History

BI Analyst

Citrix
Bengaluru , IN
09.2020 - Current
  • Work independently or as part of a team to design and develop analytics/reporting solutions using Tableau, Salesforce,SQL and Excel/Excel
  • Integrated BI assets into customer relationship management tasks, improving service personnel's available intelligence.
  • Interacts with Customers to get the requirements and also train them with developed objects
  • Design and develop extract, transform, and load (ETL) mappings, procedures, and schedules Using SSIS and SSMS
  • Provided recommendations for the optimization, automation, and standardization of business intelligence solutions, Helps to create Ops status.
  • Works on multiple modules for performance improvement of existing process and successfully implemented them and deployed to Production
  • Contributes in weekly meetings, reviews, and user group meeting while communicating status updates to stakeholders
  • Enhanced Customer Experience for consumers of Tableau reports by improving dashboards performance up to 97% by using best practices and
  • SQL query optimization


BI Developer

Technosoft Corporation
Bengaluru , IN
12.2019 - 06.2020
  • Identify and solve business challenges, utilizing largely structured, semi- structured, and unstructured data in a distributed processing environment
  • New report development, report maintenance, troubleshooting, performance tuning
  • Wrote and optimized SQL statements to assist business intelligence practices.

Data Analyst

Bizviz Technologies Pvt Ltd
Hyderabad , IN
02.2017 - 10.2019
  • Designed and developed packages for data warehouse using Integration
  • Services (SSIS) SQL Server
  • Implemented Event Handlers and Error Handling in SSIS packages and notified process results to various user communities
  • Worked in agile methodology using JIRA tool
  • Builds business dashboards that show market trend analysis of online retail metrics
  • Evaluates KPIs to identify trends and evaluate the success of business initiatives and creates models and reports to demonstrate observations and clearly communicate recommendations to senior management
  • Created an educational analytics solution for an international university to monitor their administrative performance
  • Data entry forms were created to ease the process of maintaining the data as well
  • Identified and documented detailed business rules and use cases based on requirements analysis.

Education

B.Tech - Computer Science Engineering

Lovely Professional University
08.2011 - 06.2015

Skills

    MS-SQL, MySql

undefined

Project

CX Leader Board

Created a scoreboard for customer success managers to track their performance measured by factoring their subscriptions, licenses renewals , TTC, Customer Interactions, etc

Top performers are rewarded with Cash Prize

Enablement - All Training Hr

Created a Multi-tab dashboard for Managers (L6,L7) , Agents to track their and team's performance measured by completion of the required course of enablement

Gainsight Data pipeline

Package Deployment Designed and developed packages for data warehouse gainsight database using SSIS, implemented Event

Handlers and Error Handling in SSIS packages and notified process results to various user communities

First Active Usage (FAU) - Of all the customers who have purchased the service, what percentage are using at least 2% of their entitlement (subscription purchased > 90 days)

Meaningful Active Usage (MAU) - Of all the customers who have purchased the service, what percentage are using at least 20% of their entitlement (subscription purchased > 90 days) Growth

Active Usage - Of all the customers who have purchased the service, what percentage are using at least 60% of their entitlement.


Timeline

BI Analyst

Citrix
09.2020 - Current

BI Developer

Technosoft Corporation
12.2019 - 06.2020

Data Analyst

Bizviz Technologies Pvt Ltd
02.2017 - 10.2019

B.Tech - Computer Science Engineering

Lovely Professional University
08.2011 - 06.2015
Priyanka KumariBI Analyst || Data Analyst