Name: Vivek Kumar Patel E-Mail: vivekpatel293@gmail.

com
Mobile: +91-9437361864
Microsoft Certified: Power BI Data Analyst Associate (PL-300)

PROFESSIONAL SUMMARY

 Around 3+ years of IT experience in Business Intelligence tools Excel, SQL and Power BI (Desktop
and Service) on premises servers.
 Good Experience on Modeling in POWER BI.
 Designed simple, complex, and dynamic Reports/Dashboards with SQL Server, Power BI Datasets, and
Flat Files (Excel, Text/CSV).
 Worked on different Native and Custom Visualizations like Slicer, Card, Matrix, Bar/Line charts,
Doughnut, Tree Map, Waterfall, Bubble Chart, Synoptic Panel etc. to improve the usability of reports.
 Created different types of reports like Parameterized reports, Drill-through, drilldown at various
levels, and implemented Bookmarks for page-to-page navigation.
 Performed ETL transformations on Tables and Columns like Text Column, Numeric Column, Date and
Time Column, and Merge & Append Queries etc. extensively in Power Query Editor.
 Experience in designing of Data Model Relationships for appropriate modelling.
 Implemented business functionality using different kinds of DAX functions like Aggregate, Filter, Date
and Time, Logical, Time Intelligence Functions etc.
 Worked on Calculated Columns and Measures using DAX Expressions in Power BI Desktop.
 Published or shared the reports by creating Apps or Sharing the PDF, PPT, PBIX or PBIT files.
 Worked with On-Premises Gateway to refresh & schedule the data sources/creating a live connection
with SQL Server, Flat Files (Excel and CSV) to Power BI Cloud.
 Experienced in providing the Row Level Security for reports/dashboards by assigning the roles using
DAX Expressions in Power BI Desktop.
 Experience in importing/exporting data between different sources like Oracle/Excel etc.
 Experience in using multiple Join Statements to retrieve data from multiple tables.
 Experience in creating Power BI Embedded reports and dashboards for users.
 Experience in publishing reports to Power BI Service and setting up the necessary Connections.
 Diverse background with fast learning skills and creative analytical abilities with good technical skills
and problem-solving skills.

WORK EXPERIENCE

 Working as a Software Engineer with Optus Infotech Private Limited, since Apr 1 2019 to till date.

TECHNICAL SUMMARY

Reporting Tools : POWER BI

Languages : DAX
Databases : Oracle, MS SQL Server.

EDUCATION

 completed BTECH from BPUT university, Odisha in 2015 with 63.9%.

 PROJECTS SUMMARY

Project #1:
Client: Zebronics India Pvt Ltd, India

Role: Power BI Developer

 Understanding the business decisions and data source given in SQL Server.
 Performed ETL operations like Detect data type, Rename, append queries, Custom Columns, Data
Filtering, Date & Time etc., using Power Query Editor and then loaded to Power View.
 Involved in Data Modelling by identifying and establishing Cardinality is between multiple source
tables before report development.
 Created and worked with Fiscal Calendar by using custom table as per the business requirements.
 Experienced in working with DAX Functions like Aggregation, Date and Time, Filter & Logical
Functions.
 Calculated Measures such as COUNT, SUM, AVG, MED, Value splitting to each record, Current &
Previous Record fetching etc., in DAX for analytical comparisons.
 Created Reports and Dashboard with various visualizations like Card, Stacked /Clustered Bar charts,
Bubble Chart, Matrix, Line Chart, Slicers etc.
 Implemented tooltips and book-marking options and parameters wherever required.
 Implemented RLS to each Business Unit wise.
 Worked on On-Premises Gateway to refresh the data sources using Power BI Gateway and frequency of
refresh are monthly.
 Publishing the report in format of Web Link with email authentication and PPT’s to end-user in Power
BI Service.

Project #2:
Client: Zomoz Momo

Role: Power BI Developer

 Understanding the business decisions and data source given in Excel files.
 Analyzing the requirements and discussed with managers and leads on the functionality.
 Extract data from source systems into Power query and then cleansing the data by applying business
rules and loading it into Power Pivot.
 Creating new measures and columns with DAX in MS Power BI Desktop.
 Creating visualizations like Pie Charts, Tree Map, Tabular and Matrix by using Power BI View
 Designing different types of reports like drill down and drill through reports in Power BI.
 Implementing Power BI reports effective dashboards after gathering and translating end user
requirement.
 Knowledge in creating Groups in the power BI services.
 Worked on On-Premises Gateway to refresh the data sources/creating a live connection.
 Implemented Role Based and Row Level Security as part of security in Power BI.
Sharing the dashboards to end users

PERSONAL DETAILS
  Father Name : SAROJ KUMAR PATEL
 Gender : Male
 Date of Birth : 12/04/1994
 Languages : English, Hindi and Oriya
 Address : At/Po-Jamumal, Jamankira, Dist.-Sambalpur, Odisha, Pin-768107

Declaration:

I hereby declare that the above-mentioned information is correct up to my knowledge and I bear the
responsibility for the correctness of the above-mentioned particulars.

Your faithfully,
Place: Hyderabad
Date: Vivek Kumar Patel