We provide IT Staff Augmentation Services!

Sr. Power Bi Developer Resume

5.00/5 (Submit Your Rating)

Irving, TX

SUMMARY

  • Around 9+ years of experience as a BI Developer.
  • Strong Knowledge in working with BI Tools.
  • Strong knowledge in Power BI using SQL Server.
  • Involved in Requirement Analysis, Functional Analysis, Design, Development, Implementation, Testing, Debugging and Maintenance of Power BI Applications.
  • Strong experience in synthesizing the Business Requirements, Data Models and determining Key performance indicators to evaluate key factors crucial to the success of the organization.
  • Strong Knowledge in designing and creating dimension and cubes with Snowflake and STAR schema using SSAS
  • Implemented complex query techniques of passing Multi - Valued parameters and cascading parameters in MDX.
  • Skilled in creating measures, calculated columns and performing time series analysis using DAX in Power BI.
  • Created reports like parameter-based reports, graphical reports, excel reports, drill-down chart using SSRS and tabular report and generated on-demand and scheduled reports for business analysis using SSRS.
  • Responsible for creating Power BI reports and deploying it to Power BI Services.
  • Created the Dashboards and Shared it to user groups using Power BI Apps.
  • Performed time series analysis using DAX expressions in Power BI.
  • Used Power BI to create self-service BI capabilities and use tabular models.
  • Responsible for building reports in Power BI from the Scratch.
  • Responsible for creating and changing the visualizations in Power BI reports and Dashboards on client requests.
  • Experience on publishing Power BI reports on dashboards in Power BI server.
  • Created hierarchies in Power BI reports using visualizations like Bar chart, Line chart, etc.
  • Worked with both live and import data into Power BI for creating reports.
  • Managed relationship between tables in Power BI using star schema.
  • Used different type of slicers available in Power BI for creating reports.
  • Performed transformations like Pivoting, Un pivoting and Splitting of the columns using Power Query.
  • Performed configuration of on-premises Power BI gateway to refresh datasets of Power BI reports and dashboards .
  • Involved in extracting the data using SSIS from OLTP to OLAP.
  • Experience in developing and maintaining SSIS Packages to integrate with different resources like MySQL, Oracle, SQL Server, Teradata, Flat files.
  • Hands on experience using the version controls like GIT, project management tools like JIRA, Team Forge.
  • Knowledge of full software development cycle, including code reviews, source control management and working knowledge of Agile.
  • Expert knowledge in creating Test Plans, Test Cases, Test Scenarios and Test Strategies, Defect Management to ensure Quality Assurance and to test all the business requirements.

TECHNICAL SKILLS

Power BI Tools: Power BI Desktop, Power BI Gateway, Power Query, DAX, Power BI App, SSIS, SSRS, SSAS

Database Technologies: Microsoft Access, My SQL, SQL Server

Programming Languages: SQL, PL/SQL

MS Outlook, MS Project, MS: Excel, Power Pivot 2010, MS - Access

Configuration Tools: Team Foundation Server (TFS), GitHub

PROFESSIONAL EXPERIENCE

Confidential, Irving, TX

SR. Power BI Developer

Responsibilities:

  • Used various sources to pull data intoPower BIsuch as SQL Server, oracle.
  • Involved in installation ofPower BI Report Server.
  • Developed reports to visually explore data and create an interactive reportExcel and Power BI.
  • Using a query editor inPower BIperformed certain operations like fetching data from different file.
  • Createdgroups, content packs.
  • Created the KPI to show the difference between actual and forecast data.
  • Working with import and direct query, creating custom table in thePower BI.
  • Merge queries and append queries, remove columns and split columns, choosing required columns in the data.
  • By usingPower BI desktopconnected to various data sources, working with different visualizations.
  • Developed and published reports and dashboards usingPower BIand written effectiveDAXformulas and expressions.
  • UtilizedPower QueryinPower BItoPivot and Un pivotthe data model for data cleansing and data massaging
  • Created severaluser rolesandgroupsto the end user and providedrow level securityto them.
  • CreatedPower BI Reportsusing the Tabular SSAS models as source data in Power BI desktop and publish reports to service.
  • Worked on importing custom visualizations.
  • Worked withtable and matrix visuals, worked with different level of filters likereport level, visual level filters, page level filters.
  • Used various data visualizations withPower BI.
  • Created reports utilizingSSRS, Excel services, Power BIand deployed them onSharePoint Serveras per business requirements.
  • Designed different types of KPIS for percentage growth in different fields and compared over the period of time and designed aggregations and pre calculations in SSAS.
  • Involved in designing partitions in cubes to improve performance using SSAS.
  • CreatedTabular modelreports to slice and dice huge volumes of data.
  • UsingTabular modelprovided more security to data atRow level.
  • MDXprogramming,DAXexpressions, analysis and business forecasts.
  • Implemented OLAP cubes, facts, and dimensions for providing summarized and aggregate views of large database sets.
  • Superior involvement in developing reports and dashboards from multiple data sources such as on-premises and cloud usingPower BI desktop.
  • Creating reports from importing, direct query and live data from several data sources.
  • Expertise in data transformations such as adding calculated columns, manage relationships, create different measures, remove rows, replace values, split column, date & time column.
  • Experience in combining data from different sources by using ofpower query.
  • Experience with, power pivot and dashboard designer.
  • Troubleshoot and support reports inPower BI workspaceswhenever there are issues in production.

Confidential, Arbour, MI

Power BI Developer

Responsibilities:

  • Worked with Project team to outline Project requirements.
  • Gathering and Analyzing requirements of clients, understand and convert them into database solutions with solid exposure to architecture, analysis, design, testing, development, deployment, documentation & implementation.
  • Profiled the legacy database tables to provide data cleansing issue reports to the client.
  • Developed data reconciliation SQL queries to validate the overall data migration
  • Formulated DAX Expressions create Date to yearly columns and implemented partitions in Tabular Models for Power BI.
  • Created measures, calculated columns and performed time series analysis using DAX in Power BI.
  • Effectively used data blending, filters, actions, and hierarchies feature in Power BI.
  • Analyzed the data using Statistical features in Power BI to develop trend analysis and published the reports on the Power BI Services.
  • Created different chart types and drill down reports (SSRS).
  • Participated in the configuration of on-premises Power BI gateway to refresh datasets of Power BI reports and dashboards .
  • Implemented complex query techniques of passing Multi-Valued parameters and cascading parameters in MDX.
  • Involved in defining report layout in SSRS. Created complex stored procedures for reporting services and Analyzed reports
  • Generated several daily and monthly critical reports
  • Created and maintained several ETL jobs and resolved any issues associated with the jobs
  • Developed and maintained SSIS Packages to integrate with different resources like MySQL, Oracle, SQL Server, Teradata, Flat files.
  • Performed several performance tunings using execution plan and SQL profiler to improve the performance.

Confidential

Power BI Analyst

Responsibilities:

  • Created DAX Queries to generated computed columns in Power BI.
  • Created power BI dashboards and reports for sales group by connecting Oracle database.
  • Involved in defining referenced relationships with the measure groups and fact tables.
  • Creating Database objects - tables, views and functions and developing procedures for implementing application functionality at the database side for performance improvement.
  • Responsible for creating datasets using TSQL Stored Procedures and involved in Data visualization.
  • Involved in extracting the data using SSIS from OLTP to OLAP.
  • Understanding the business requirement and functional specification of the client module with Business Executives & Analysts.
  • Scheduled jobs and alerts using ADF Triggers.
  • Implemented Star and/or Snowflake schema while designing relational database and data warehouse as per business and report requirements..
  • Explore data in a Variety of ways and across multiple visualizations using Power BI.
  • Created and schedules tasks for reloading and distribution of Data in Tableau.
  • Involved in creating new stored procedures and optimizing existing queries and stored procedures.
  • Created Azure Blob Storage for Import/Export data to/from .CSV File.
  • Followed the AGILE methodology for the entire “SDLC”.
  • Worked with DBA, data modeling team, Application management team to understand the database structure, tables and their relations and to apply security
  • Validated data against database by creating and running SQL queries.

Confidential

Business Analyst

Responsibilities:

  • Responsible for gathering requirements from stakeholders and operational analysts and identifying the required data sources for the requests.
  • Developing reports, maintaining report definitions, maintaining report manager portal using SQL Server Reporting Services (SSRS).
  • Developing and maintaining OLAP cubes using SQL Server Analysis Services (SSAS).
  • Developing ETL packages using SQL Server Integration Services (SSIS) and bulk-loading utilities.
  • Extracted, analyzed and presented in graphical format using Excel, such a way that stakeholders can make key decisions.
  • Identified critical data collection points and made sure that the data is accurate and created SOP (Standard Operating Procedures for data collection).

We'd love your feedback!