Good communication skills, Having hands-on experience in DAX OPERATIONS, Good knowledge in creating interactive dashboards and reports.
Professional Summary:
3+ years of IT experience in the Analysis, Design, Development, Administering, Implementing using Microsoft Power BI suite (Development, UAT and Production Environment). • Extensive experience with different phases of project life cycle (Analysis, Design, Implementation). • Experience in writing complex SQL queries involving multiple tables with inner and outer joins, stored procedures, Experience in creating indexed views. • Hands-on Experience in DAX Expressions, Power BI, Power Pivot, Power integrated with Share Point and in creating dashboards in Power BI. • Creating powerful calculations, key metrics, and key performance indicators (KPIs). • Expertise in adding Calculated Fields with Data Analysis Expressions (DAX). • Worked on Calculated Columns vs. Measures, Row Context vs. Filter Context, DAX Syntax and Operators, Date and Time Formulas, Text, Math and Stats Functions. • Worked on DAX Iterators and Time Intelligence Formulas. • Worked on Designing Interactive Power BI Reports. • Worked on Formatting and Filtering Options, adding Matrix Visuals, Slicers & Timelines, Cards & KPIs • Worked on Power BI Map Visuals, Tree maps, Lines, Areas & Gauges. • Worked on Edit interactions, Adding Drill through Filters, Linking to Report Bookmarks, using “What-If” Parameters, Managing and Viewing Roles • 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 SQL SERVER, Gateway migration • Having very good experience on building dash boards, reports.
Project #2 Company:
Pactera edge technologies
Project Title: Amanda Collections Client: Zalando, Berlin, Germany
Role: Power BI Developer Environment: Power BI, SQL Server
Project Description
Zalando SE is a European electronic commerce company based in Berlin. The company maintains a cross-platform online store that sells shoes, clothing and other fashion items. The company was founded in Germany in 2008, and since has begun operating in fourteen European countries and worldwide with spin-offs and subsidiary companies. They gain their competitive advantage through their generous shipping and return policies, which come at no additional costs while promising a speedy delivery of the ordered items. Additionally, they offer 'payment after delivery', which involves a certain risk for the company. The scope of this project is to build the warehouse and maintain client's historic and current data Responsibilities Responsible for getting, understanding the Business and its requirements Worked with SQL objects to create Tables, Views, Indexes, Functions. Worked on the Power Bi reports and dashboards with SQL Server. Used Table/ Matrix/ Trend Lines/ Bar/ Card/ Gauge/ Slicers etc. and Custom Visualizations. Comfortable in working with filters/calculated columns/measures/relationships and transformations of the 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 Confidential Worked with various transformations like lookup, derived columns, multicast, conditional split, Union All. Implemented performance tuning in various levels in the packages.
