Summary
Overview
Work History
Education
Areas Of Expertise
References
Timeline
Generic

Vandana J

Melbourne,VIC

Summary

Having around 5+ years of total experience as a Power Bi Developer expertise in creating compelling reports and dashboards using DAX. Looking to work with an esteemed organization that gives me an opportunity to utilize my existing analytical skills and help make better business decisions.

Experience in all Phases of Project Lifecycle Including Requirement gathering, analysis, design, development, implementation, testing and deployment of projects using Microsoft Power BI. Good working knowledge on Application development and maintenance of life cycle process. Worked both on import and direct query modes. Good experience on power BI desktop including getting data, identifying the relationships, create calculated columns and measures using Dax. Extensive Knowledge in writing DAX and Worked both on imported and Direct Query. Experience in creating table, matrix, slicers, gauge, bar and custom visualizations. Good in Writing and Implementing DAX Functions in PowerBI Implemented RLS as part of security. Hands on Experience in developing Dashboards using Power BI Desktop and Power BI service. Created relationship between two different Data Sources by using Data Modeling and manage relationships in Power BI Desktop. Proficient in creating Bookmarks, Hierarchies, Edit Interactions behavior in Power BI Desktop. Knowledge on Star Schema & Snowflake Schema, Fact & Dimension Tables. Experience in creating Filters, quick filters, table calculations and parameters. Merge and Append Queries in PowerBI. Experience in creating different visualizations using Bars, Lines and Pies, Maps, Bubbles, Tree maps and Highlight tables, crosstabs etc. Applying row-level (data level) security to support the same dashboards. Strong in writing SQL queries using Joins, Co-Related Queries and Sub-Queries. Experience in designing, developing and execution of Test Cases. Prepared and participated in Reviews and Walkthroughs of test plans, test cases, test reports, functional requirements, and technical specifications. Exposure in Deployment and Release activities. Client interaction for getting requirements and support activities. Expert in El Text functions (case, trim, substitute, concatenate, Len, substitute). Good knowledge in Developing and delivering Monthly, Weekly & Daily reports to Management by using Power Bi. Good knowledge in preparing Report and Dashboard visuals for business overview.

Overview

9
9
years of professional experience

Work History

Power BI Developer

Impel Infotech Private Limited
03.2021 - Current
  • Developed user interactive dashboards starting from data analysis, prototype development until deployment
  • Part of team performing data clean-up and data validation during requirement phase
  • Designed a user accepted visualization donut dashboard with hide and show mechanism with slicer selection
  • Implemented dynamic tooltip and dynamic titles based on slicer selections
  • Created personalized visuals in power bi desktop, in order to allow end user to make their personalized visuals
  • Worked on all groups of most of the DAX functions (Date and Time Intelligence, Text, Logical, In-formation, Filter, and Joins etc.)
  • Implemented RLS (Row level security) and provided RLS security for reports in PBI services level
  • Created content packs to share dashboard and reports to the end users.

Power BI Developer

Impel Infotech Private Limited
04.2020 - 03.2021
  • Involved in extracting data from different data sources like Excel and Flat files etc
  • Performed various transformations for cleaning the data
  • Created new columns, new measures and conditional columns using DAX functions
  • Designed diverse types of reports like drill down, drill through, And Bookmarks
  • Developed various visualizations like donut chart, Pie chart and Bar graph, Tree map, Waterfall charts and Card Visualizations
  • Created the required workspace for publishing the reports
  • Created different types of dashboards and reports for various scenarios.

Power BI Developer

V A Solutions Private Limited
08.2015 - 11.2016
  • Loading the data from development system to staging environment
  • Extracting data from multiple sources like flat files, Excel, and SQL server and validating data and loading into Final Destination
  • Design and develop of reporting data module for Customer Experience Beacon
  • Developed Score Card Reports using DAX functions
  • Created Drill Down Reports, Drill Through Reports
  • Developed analysis for reports and visualization using DAX functions like logical functions, Filter functions, Text functions, Statistical functions, Information functions and Date and Time functions
  • Explored data in a variety of ways and across multiple visualizations like Matrix, Gauge, Card, Multi- row card, Stacked Bar Chart, Donut Chart, Line Chart, Stacked Column Chart, Line and Clustered column chart, Tree map, Table and Sync slicers using Power BI
  • Uploaded Power BI Reports into Power BI Report Server and made Power BI Dashboards available to users
  • Responsible for the design of the Mapping document for the different reports.

Education

PROFESSIONAL YEAR PROGRAM -

Performance Education
01.2020

Master of Information Technology -

Charles Sturt University
01.2018

Bachelor of Information Technology -

VNRJIET college
01.2015

Areas Of Expertise

Power BI, JAVA, C, HTML, Java Script, Eclipse, IntelliJ, Visual Code Studio, SQL, Oracle, Windows, JIRA, Firefox, Explorer, Safari, Chrome, SDLC, Waterfall, Agile (Scrum Approach), Github

References

References available upon request.

Timeline

Power BI Developer

Impel Infotech Private Limited
03.2021 - Current

Power BI Developer

Impel Infotech Private Limited
04.2020 - 03.2021

Power BI Developer

V A Solutions Private Limited
08.2015 - 11.2016

PROFESSIONAL YEAR PROGRAM -

Performance Education

Master of Information Technology -

Charles Sturt University

Bachelor of Information Technology -

VNRJIET college
Vandana J