Aashutosh Acharya

Power BI Developer

Email: admeod@r.postjobfree.com Phone: +91-973*******

Career Objective :

looking for an opportunity to work as a Power BI developer with an organization that provides ample opportunities to learn and to contribute to the growth of an organization.

Professional Summary :

9 Years of IT Experience in Development and Support of Power BI (Desktop and Service) along with SSAS Tabular Model and DAX, Microsoft SharePoint, SQL Server in Development, Data warehouse, Test and Production Environments on various business domains like Financial, Insurance, Oil & Gas and Health Care.

Certified Power BI developer from Microsoft Power BI Partner.

Worked on the Power Bi reports & dashboards with SharePoint lists, OData, web, SQL Server/Tabular SSAS sources.

Used Table, Matrix, Bar, Card, Gauge, Slicers visualizations

Worked on Custom Visualizations like multi slicer and Hierarchy slicer.

Worked on DAX expressions like filters, Aggregate, Mathematical Functions etc.

Created New Calculated Column and Measure using DAX Expression.

Comfortable in working with filters/calculated columns/measures/relationships and transformations of Edit Query section.

Published/shared the reports by creating Content Pack/Sharing the pbix file.

Worked on On-Premises Gateway to refresh the data sources/creating a live connection with Tabular SSAS.

Implemented Role Based Security as part of security in Power BI.

Experience with SQL in constructing Tables, Triggers, User Function, Views, User Profiles, Relational Database Models, Data Dictionaries and Data Integrity.

Experience in Using multiple join statements to retrieve data from multiple tables

Experience in Creating Backend validations using Insert/Update and Delete triggers and Created views for generating reports.

Experience in writing Programs for implementing Stored Procedures for different tasks. Worked with Development teams in relation to application tuning.

Experience in MS Business Intelligence tools like SQL Server Integration Services, Reporting Services.

Created ETL packages using SSIS to move data from various heterogeneous data sources..

Worked with Financial companies for application related pricing and security applications

Developed Reports using efficient data retrieval techniques

Designed different types of reports like drill down, drill through, sub reports, parameterized reports and cascading reports in SSRS 2008R2/2012.

Design and develop tabular, Matrix, Drill down and Parameterized reports in SSRS using stored proc. Use of custom code, Expressions in SSRS.

Developed Custom Reports and different types of Tabular Reports, Matrix Reports, Ad hoc Reports and distributed Reports in multiple formats using SQL Server Reporting Services (SSRS)

Excellent Report creation skills using Microsoft Power Bi & Microsoft Reporting Services (SSRS) 2008R2/2012.

Excellent communication, presentation, interpersonal skills, strong troubleshooting and organizational skills.

Technical Skills :

Main Skill

Power BI, Microsoft SharePoint (2013, 2010, Online)

(Functional, OOB Features, Migration and partial Administration, SSRS, InfoPath), RPA (Blue prism), Project Server

Power BI

Data Extraction, Power query editor for Data Transformation, Power Pivot for Data Modeling, Data Analysis Expression - DAX Queries, Data Visualization with Analytics, Power Q & A, Power BI Desktop & Administration

SQL Server Tools

SQL Server Enterprise Manager, Data Transformation

Services (DTS), SQL Server Query Analyzer, SQL Server Management

Studio, SQL Server Integration Services (SSIS), SQL Server 2008R2

Reporting Services (SSRS)

Reporting Tool

Power BI & SSRS

Programming Languages

DAX, HTML, JavaScript, jQuery

Database

Microsoft SQL Server (2008, 2012)

Development/Productivity Tools

Power BI Desktop, Power BI Service, Power BI Gateway, Power BI On premises, Power Automate. Power Apps, SharePoint Designer, SSRS, InfoPath forms

Domain

Retail, Financial, Consumer Goods, Oil & Gas

Process

Task Management, Incident Management, Change Management, Service Introduction

Organizational Experience :

HCL Technologies

Presently working from March 2016

Altisource Business Solution Pvt. Ltd.

March 2014 to March 2016

E2e Projects Pvt. Ltd.

August 2012 to January 2014

Academics :

MBA in IT Project Management from Welingkar Institute of Management Development & Research, Mumbai.

B. Tech in Information Technology from Modi Institute of Technology, Affiliated by Rajasthan Technical University, Kota

Professional Experience :

Project : In the United States, there are many stores in which a survey was conducted based on students i.e. How much they are spending on different kinds of purchases like Video games, Indoor games, Toys, Books, Gadgets etc.

Description: In this project, I have created a Power BI Report. Hands-on experience on Tabular Visualization, Matrix Visualization, Funnel chart, Pie chart, Scatter plot, and Sand dance plot.

Topics: Basic Calculation using DAX, Data Transformations, Advanced Visualizations, Advanced features of Power BI Cloud Service, Context, Gateway and Schedule Refresh, Creation of Report, Sand-Dance and Percentile, Row Level Security

Roles and Responsibilities:

Tabular Visualization

Matrix Visualization

Funnel chart

Pie chart

Scatter plot

Sand dance plot

Advanced features of Power BI Cloud Service

Row Level Security

Cigna Health Insurance : it’s a leading provider of healthcare industry. Cigna Health Insurance has created a set of web based supply chain management solutions that directly address the particular needs of hospital materials management departments and Supply manufacturers and distributors. The important mission of the data visualization project is Increase the frequency and quality of information by providing increased levels of beneficial data to stakeholders in a more responsive way at a predictable cost. Support and align with the corporate business strategy and differentiate Cigna Health Insurance data offering from its competitors.

Worked on the Power Bi reports & dashboards with SQL Server/Tabular SSAS sources

Used Table, Matrix, Bar, Card, Gauge, Slicers visualizations

Worked on DAX expressions like filters, Aggregate, Mathematical Functions etc.

Created New Calculated Column and Measure using DAX Expression.

Stored Procedures, User Defined Functions, Views, SQL scripting for complex business logic. Extensively used Joins and sub-queries for complex queries involving multiple tables from different databases.

Performed maintenance duties like performance tuning and optimization of queries, functions and stored procedures.

Used SQL Profiler for troubleshooting, monitoring, optimization of SQL server 2012 and SQL code.

Cadent Gas : Cadent Gas is the second largest Gas supplier brand in UK. And having max use of SharePoint online, BI dashboards, reporting, Power platform, Power Apps, Designer workflows, Metadata and other OOB functionality of SharePoint. I am involved in end to end interaction with client starting from collecting the requirements till UAT signoff. My main responsibility was to create the BRD document, PRD document, Technical specs and Functional specs document. Providing L1/L2/L3 support for SharePoint Online & Power BI reporting. After the development part I was actively involved in creation of test cases creation and end to end testing of the application at my end.

Role and Contribution: Analysis, design, development and support

SharePoint Online Feature in Project: Designer, InfoPath, OOB features, SSRS, Power automate & Power Apps

Power BI : Reporting & Dashboard creation

Working with Power BI dashboard

Creating Reports & visualization

Used Pie chart, Scatter chart, Bar chart, Map, Gauge, Slicers visualizations

Worked on Custom Visualizations like multi slicer and Hierarchy slicer.

Worked on DAX expressions like filters, Aggregate, Mathematical Functions etc.

Hobbies :

1.Yoga and Meditation

2.New learning everyday

3.Swimming

4.Bike Riding

5.Trekking

6.Exploring the new places

Contact this candidate