We provide IT Staff Augmentation Services!

Power Bi Developer Resume

5.00/5 (Submit Your Rating)

Orange, CA

SUMMARY

  • Strong noledge in Power BI using SQL Server.
  • Expertise in using Microsoft BI suite: SQL Server Integration Services (SSIS), SQL Server Analysis Service (SSAS), SQL Server Reporting service (SSRS).
  • Good Programming noledge on SQL.
  • Involved in Requirement Analysis, Functional Analysis, Design, Development, Implementation Testing, Debugging and Maintenance of Power BI Applications.
  • Strong Knowledge in designing and creating dimension and cubes wif Snowflake and STAR schema using SSIS.
  • Experience in Power BI report development and Proficient in writing complex calculated measures using data analysis expressions language (DAX).
  • Expertise in using DAX and generated dashboards & reports and integrating wif Power Apps.
  • 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 wif 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, Unpivoting 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
  • Experience in developing and maintaining SSIS Packages to integrate wif different resources like MySQL, Oracle, SQL Server.
  • Worked on configuring various data adapters for MySQL, Oracle, SQL Server.

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.

Specialist: Designer, Developer, Server and Administration skills.

Auxiliary Skills: MS Office Suite, Microsoft Visio, Erwin.

PROFESSIONAL EXPERIENCE

Power BI Developer

Confidential, Orange, CA

Responsibilities:

  • Worked closely wif various teams across the company to identify and solve business challenges.
  • Gathering and Analyzing requirements of clients, understand and convert them into database solutions wif solid exposure to architecture, analysis, design, testing, development, deployment, documentation & implementation.
  • Import data from different data sources to create Power BI reports and Dashboards.
  • Experience in developing Reports, Charts, Dashboards using Power BI Desktop and manage security based on requirements.
  • Transform, define, navigate the data from data source and performed merge and append queries using Power Query.
  • Implemented complex query techniques of passing Multi-Valued parameters and cascading parameters in MDX.
  • Performed different types of context like Row context, filter context and query context using Power BI Desktop
  • Performed transformations like Pivoting, Unpivoting and Splitting of the columns using Power Query.
  • Performed Query Folding using Power Query to filter data in the data source server.
  • Created different chart types and drill down reports using Power Bi Desktop (SSRS).
  • Involved in defining report layout in SSRS.
  • Created complex SSAS cubes wif multiple fact measure groups and multiple dimensions hierarchies in SQL server.
  • Created measures, calculated columns, relationships and performed time series analysis using DAX in Power BI.
  • Created hierarchies in Power BI reports using visualizations like Bar chart, Line chart, etc.
  • Worked wif both live and import data into Power BI for creating reports.
  • Managed huge volume of data by creating weekly partitions in SSAS models.
  • Used different type of slicers available in Power BI for creating reports.
  • Experienced in creating many dashboards by pinning many visualizations in the workspace as per the insights provided.
  • Experienced in Data Modeling used to define and analyze data requirements needed to support the business processes wifin the scope of corresponding information systems in organizations.
  • Used Power BI Gateways to keep the dashboards and reports up to date.
  • Used recently introduced Power BI to create self-service BI capabilities and use tabular models.
  • Responsible for creating and changing the visualizations in Power BI reports and Dashboards on client requests.
  • Shared the created workspace across the organization using Power BI Apps.
  • Created complex stored procedures and scripts in SQL Server.

Power BI Developer

Confidential, Cincinnati, OH

Responsibilities:

  • Developed various dashboards and performed data analysis to handle unsolicited user access.
  • Implementing time-based subscription schedule which is a latest feature in Power BI service for scheduling reports and dashboards.
  • Data modeling using Composite models in Power BI, retrieved data from REST Elastic search and SQL server.
  • Implemented Row level security to restrict data access for required users.
  • Co-ordinate wif Admin team to install Power BI gateway to allow multiple users to access data sources.
  • Connect to files stored in One Drive for you're Power BI app workspace.
  • Implemented various DAX functions for various fact calculations and calculated columns for efficient data visualization.
  • Interact wif Office 365 Admin team to has Power BI app workspace groups created wif legit members assigned.
  • Identified Data quality issues using the latest data prep features, fuzzy matching capabilities and data profiling.
  • Scheduled Automatic refresh and scheduling refresh in Power BI Service.
  • Created Workspace and content packs for business users to view the developed reports.

Power BI Developer

Confidential, Boston, MA

Responsibilities:

  • Worked wif Project team to outline Project requirements.
  • 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 wif the jobs
  • Developed and maintained SSIS Packages to integrate wif different resources like MySQL, Oracle, SQL Server.
  • Performed several performance tunings using execution plan and SQL Profiler to improve the performance.

SQL/MSBI Developer

Confidential

Responsibilities:

  • Involved in understanding Business requirement document and developing Technical Design specification documents for multiple interfaces.
  • Identified various source systems for data feeds.
  • Used SSIS to develop jobs for extracting, cleaning, transforming and loading data into Data warehouse.
  • Designed and developed jobs for loading data to star schema.
  • Extracted Data using SSIS from DB2, and flat files, Excel transformations.
  • Populate the data warehouse. Worked on SSIS to remove duplicate records wif data standardization.
  • Created SSIS Package to transfer data from various locations using the FTP task. Tan loaded the flat file data into the database.
  • Created various Jobs, Alerts and Events, Created Backups for databases and automated the process. Assisted in building dimensional cubes wif SQL Server Analysis Services (SSAS) and building multiple calculated members, KPI’s for user perspectives.
  • Worked as a developer in creating complex Stored Procedures, tables, and views and other SQL joins and statements using TSQL for different applications.
  • Managed index and optimized queries using execution plan.
  • Created and integrated user defined functions and stored procedures for reporting purposes.
  • Involved in the Analysis of the Report Data, Developed and Deployed Reports on to the Reporting Server. Wrote and integrated stored procedures to generate the reports.
  • Created Cross-Tab, Drill-down and Sub-Reports using RDL and promoting RDLS to Reporting Services Server.

Business Data Analys

Confidential

Responsibilities:

  • Gathering requirements from clients and convert to user stories for the internal teams.
  • Highly analytical and process-oriented data analyst wif in-depth noledge of database.
  • Furnish insights, analytics and business intelligence used to advance opportunity identification, process reengineering and corporate growth.
  • Developed Key Performance Indicators to monitor sales and decreased costs
  • Spearheaded data flow improvement.
  • Successfully interpreted data in order to draw conclusions for managerial action and strategy.
  • Used statistical techniques for hypothesis testing to validate data and interpretations
  • Presented data and conclusions to team in order to improve strategies and operations.
  • Proposed solutions to improve system efficiencies and reduce total expenses.
  • Manage the planning and development of design and procedures for metrics reports
  • Develop new reports and delegate tasks to team members
  • Perform market analysis to efficiently achieve objectives, increasing sales
  • Investigate and conduct studies on the forecasts, demand, and capital of products
  • Optimized data collection procedures and generated reports on a weekly, monthly, and quarterly basis
  • Used advanced Microsoft Excel to create pivot tables and pivot reporting, as well as use VLOOKUP function.

We'd love your feedback!