We provide IT Staff Augmentation Services!

Power Bi Developer Resume

Richmond, VA

PROFILE SUMMARY:

  • MSBI Consultant with an experience of nearly 7 years and currently working as a Power BI Reports Developer.
  • Experience in creating tabular reports, matrix reports, parameterized reports, sub reports, and global map reports in both Power BI Desktop and Power BI Cloud Service.
  • Expertise in creating Dashboard Reports to support end users using SSRS.

TECHNICAL SKILLS:

Database: SQL Server 2016, 2014, 2012, 2008/R2

SDLC: Agile, Scrum, Waterfall, and Spiral

Data Modeling: ER - win, MS Visio

Database Programming: T-SQL, Dynamic SQL, MDX, DAX

Development Tools: BIDS, SSDT, SSMS

Integration Tool: SSIS

Analysis Services: SSAS, OLAP Cubes, Tabular Model

Reporting Tools: SSRS, Tableau Desktop, Power BI, Excel Power BI

Source Control & Collaboration Tool: Team Foundation Server (TFS), SharePoint

Cloud Technologies: MS Azure (IaaS, PaaS, SaaS), Azure SQL, Azure Data Warehouses, Data Factory, PowerShell, Azure Storage (BLOB, Tables, Queues, and File Share)

WORK EXPERIENCE:

Confidential, Richmond, VA

Power BI Developer

Tools & Environment: SQL Server 2016, SSAS, SSRS, SSMS, SSDT, T-SQL, Erwin, TFS, Power BI, SQL Profiler, DTA, MS Azure

Responsibilities:

  • Created system requirement gathering documents based on extensive JRD and JAD sessions.
  • Designed the logical model with Erwin based on business requirements.
  • Maintained referential, domain, and column integrity utilizing available options.
  • Created complex SQL queries, derived tables, common table expressions (CTEs), stored procedures, views and user defined functions (UDF).
  • Extensively used dynamic SQL, procedures and database triggers.
  • Recommend SQL tuning for report queries in order for them to work efficiently on high volume scenarios
  • Configured partition for SSAS cubes to use different storage modes in order to improve performance.
  • Incorporated the latest features in Power BI such as sync slicers, bookmarks, drill down effect to make reports more interactive and user friendly.
  • Developed App and deployed those to App Workspace for various user groups using Power BI Services.
  • Performed troubleshooting of performance issues which were associated with Power BI reports.
  • Published the Power BI reports to Power BI Services per business requirements.
  • Installed and managed gateways to do automatic data refresh of Power BI datasets.
  • Created drill down/drill through, sub-reports with SSRS to present a more detailed information about the summary.
  • Delivered SSRS reports to multiple file formats such as PDF, Word, and Excel format based on business demand.
  • Utilized SSRS to create business interactive reports such as parameterized and cascading parameterized as demanded by the business users.
  • Designed and developed data migration applications to retrieve and populate data from Azure Table / BLOB storage to on premise SQL Server instances.
  • Maintained different versions of SQL scripts and reports on TFS.

Confidential, Dallas, TX

BI Developer

Tools: & Environment: SQL Server 2012, Erwin, SSDT, SSAS, SSRS, Power BI, DAX, T-SQL, Erwin, MS Excel, TFS, DTA

Responsibilities:

  • Collaborated with the project team and business users to gather business requirements.
  • Designed and developed data marts by following star schema methodology, using industry leading data modeling tools such as Erwin.
  • Validated the appropriate LDMs to process mappings, use cases, business object model, and system object model.
  • Scripted T-SQL queries, ranking functions, derived tables, common table expressions (CTEs), stored procedures, views, user defined functions (UDF), constraints & database triggers.
  • Maintained SQL Server Security, created logins and users, configured permissions and assigned roles to users.
  • Monitored, determined and solved issues at SQL/database/server levels.
  • Created a cube using multiple dimensions and modified the relationship between a measure group and a dimension and created calculated members and KPIs using SSAS.
  • Customized new columns, quick measures and measures in Power BI desktop utilizing DAX.
  • Implemented common data scrubbing such as changing data type, grouping rows, and filtering data using Power query and M code in Power BI.
  • Developed dashboards using donut charts and implemented with customized tooltip with in Power BI.
  • Implemented data alerts, subscriptions to receive notification based on data changes on Power BI services.
  • Configured parameters and functions to extract data from Web APIs within Power BI reports.
  • Checked in/checked out SQL code and other DB objects in TFS.

Confidential, New York, NY

BI Reports Developer

Tools: & Environment: SQL Server 2012, T-SQL, SSAS, SSRS, SSMS, SSDT, SQL Profiler, Erwin, DTA, Power BI

Responsibilities:

  • Participated in JAD meetings and outlined functional requirements to design the data migration process.
  • Evaluated and created different documents to support data migration process and troubleshooting during data migration process.
  • Examined and evaluated data structures of the source/legacy systems, analyzed data quality and performed data cleanups.
  • Analyzed requirements and optimized stored procedures to enhance performance.
  • Developed data reconciliation SQL queries to validate the overall data migration.
  • Utilized T-SQL constructs such as joins, subqueries, derived tables and views for querying data.
  • Optimized cubes by assigning appropriate storage modes to partitions, thereby improving query performance.
  • Managed the data models in Power BI by converting the indirect relationships to direct relationships.
  • Designed complex data intensive reports in Power BI utilizing various graph features such as gauge, funnel, and line better business analysis.
  • Filtered bad data from the source system with the help of Power BI transformations.
  • Created reports such as ad-hoc, drill-down, drill-through, cross-tab, sub-reports, pivot, tabular, parameterized reports and cascade parameterized reports using SSRS.
  • Formulated design specification documents for the new reports developed through SSRS.
  • Gained excellent understanding of SSRS with report authoring, report management, report delivery and report security and created reports with analysis services cube as the data source using SSRS.

Confidential, Cincinnati, OH

SSRS Developer

Tools: & Environment: SQL Server 2008 R2, T-SQL, SSMS, BIDS, SSAS, SSRS, SQL Profiler, DTA, Excel Power BI, Power View, Power Pivot, TFS

Responsibilities:

  • Analyzed multiple user requirements and development specifications for OLAP applications in JAD meetings.
  • Developed complex stored procedures to perform index maintenance and data profiling.
  • Performed data profiling of OLTP database systems and defined data mappings.
  • Wrote SQL queries and stored procedures to generate data for reports.
  • Formulated ad-hoc SQL queries for testing end-to-end process.
  • Created and maintained various databases for production, development and testing environments using SQL Server.
  • Utilized Excel Power BI (Power View and Power Pivot) to create various analytical reports and dashboards to analyze KPIs and facilitate strategic planning.
  • Created a variety of reports using SSRS including matrix report, parameter report, dashboard, charts, drill-down, drill- through and cascade parameterized report.
  • Implemented role-based security for reports with the report manager.

Confidential, Fresno, CA

Database Developer

Tools: & Environment: SQL Server 2008, T-SQL, SSMS, BIDS, SSAS, SSRS, SQL Profiler, DTA, TFS

Responsibilities:

  • Analyzed the business requirements in JAD sessions.
  • Performed normalization and de-normalization of existing tables improving query processing.
  • Enhanced and implemented pre-existing logical and physical database.
  • Created complex stored procedures and functions to support efficient data storage and manipulation.
  • Optimized existing queries with stored procedures, parameter sniffing, execution plans and statistics.
  • Modified queries to improve database performance utilizing execution plans, indexes, batch processes, and hints.
  • Developed SSRS reports using complex formulas and queried the database to generate ad-hoc reports.
  • Deployed and uploaded the SSRS reports to SharePoint server for the end users to look at them.

Confidential, San Francisco, CA

SQL Developer

Tools: & Environment: SQL Server 2008, T-SQL, SSMS, BIDS, SSAS, SSRS, SQL Profiler, DTA, TFS

Responsibilities:

  • Collaborated with the development team in planning, defining, and designing functional requirements.
  • Worked closely with the developers to understand their requirements and to meet project scope within the time line.
  • Developed ER diagrams for the proposed data mart using Erwin.
  • Maintained Data Model and synchronized it with the changes to the database.
  • Identified and mapped various data sources and their targets successfully to create a fully functioning data repository.
  • Created critical staging procedures to load data marts and report databases with multiple features.
  • Delivered on-demand and scheduled reports for business analyses in SSRS.

Hire Now