We provide IT Staff Augmentation Services!

Sr. Power Bi Developer Resume

Round Rock, TX

SUMMARY

  • Result oriented SQL Server/BI Developer wif over 7+ years of extensive work experience in teh world of IT. Most of teh experience in designing & coding of database, and applications of MS SQL Server/Oracle.
  • Work experience in teh area of SQL Development, integration Development using Microsoft tools like SSIS, SSRS, SSAS & POWER BI and AZURE in developing various Industry verticals like insurance, Retailers, Banking and Finance sectors.
  • Strong experience developing Power BI visuals for an instance Graph visual, like, Clustered Bar chart and column chart, Area chart, Heat map, Lie Chart, Pie Chart, Funnel Chart etc. and tables visuals like Matrix visual and Table visual.
  • Transformed data using Power BI power Query, utilizing Power M Query, utilizing teh power bi tool functionality.
  • Designed and developed Power BI graphical and visualization solutions wif business requirement documents and plans for creating interactive dashboards.
  • Utilized Power Query in Power BI to Pivot and Un - pivot teh data model for data cleansing and data massaging.
  • Created Power BI Self-Serve Models connecting to different Data warehouse like Azure Data Warehouse, Snowflake Data Ware house.
  • Implemented several DAX functions for various fact calculations for efficient data visualization in Power BI.
  • Developed reports for validation purposes like data quality, data discrepancy for very sensitive data.
  • Utilized Power BI gateway to keep dashboards and reports up to-date wif on premise data sources.
  • Strong T-SQL experience in creating different database objects Tables, Stored Procedures, DDL/DML Triggers, Functions and User defined data types. Skilled in writing and reviewing T-SQL code and maintaining coding standards.
  • Strong experience working wif Azure services like, Azure ADF, Azure Data lake, Azure Analysis Services
  • Experienced in all most all teh versions of MS SQL Server 2008, 2008R2, 2012, 2014, SSIS, SSRS, SSAS. Oracle 11g/ 10g/ 9i/ 8i, Teradata, V2RS, and MS ACCESS 2003, 2000.
  • Strong experience wif ETL tool in Mapping, Transformations, Expressions lookups & Aggregations. Experience in creating Jobs, Alerts, Sql Mail Agent, and scheduling SSIS packages.
  • Experience in configure and maintain report manager & report server for SSRS. Deployed and Scheduled reports in Report manager, ad-hoc reports, data driven subscription reports by using report builder.
  • Skilled in creating Visualizations in tools like Tableau, Macros in Excel, Power Bi, SSRS.
  • Experience in writing parameterized queries for generating stylish tabular reports Drill down, Drill Trough, Cascading, click through, matrix chart, snap shot reports Formatting report layout, sub reports, using Global Variables, Expressions, functions, sorting teh data, defining data source and subtotals for teh reports using SSRS.
  • Developed OLAP Cubes by using SQL Server Analysis Services (SSAS), and defined data sources, data sources views, dimensions, measures, hierarchies, attributes, calculations, multidimensional expressions (MDX), Perspectives and Roles.

TECHNICAL SKILLS

Azure Cloud: Azure SQL Database, Azure Data Lake, Azure Data Factory (ADF), Azure SQL Data Warehouse, Azure Service Bus, Azure Analysis Service(AAS),Azure Blob Storage. Cacheusing Pipeline and SSIS, Azure SQL Data.

Languages: T-SQL, PL/SQL, Hive SQL, MDX, DAX, C, HTML.

Databases: Azure SQL Database, Azure data warehouse, Azure Data azure data factory, Azure Data Synch, MS SQL Server 2008 R2, 2012, 2014 MySQL, Snowflake Data Warehouse and Oracle12c.

BI Tools: Azure Database migration Service (DMS), SQL Server Integration Services (SSIS), SQL Server Reporting Services (SSRS), Visual Studio, POWER BI.

Database Design Tools and Data Modeling: Star Schema/Snowflake Schema modeling, Fact and Dimensions tables, Physical & logical data modeling and De-normalization techniques, Kimball & Inmon Methodologies.

Tools: and Utilities: SQL Server Management Studio, Import & Export Wizard, SQL Server Profiler, Visual Studio, DTS, Business Intelligence Development Studio(BIDS), Power BI, Microsoft Office(MS), Excel Data Explorer, Tableau, Amazon Web Services.

Operating Systems: Windows, Windows Server, Unix, Linux, Mac OS …

PROFESSIONAL EXPERIENCE

Confidential, Round Rock, Tx

Sr. Power BI Developer

Responsibilities:

  • Developed Power BI datasets, Power BI Reports and Power BI Dashboards using Direct query model, Import Model or Live Connection methodologies wif best practices.
  • Developed and supported AAS (Azure Analytical Services) Power BI self-serve models using live connection methodology. Worked on building Power BI Premium XMLA model
  • Power BI Administration using REST APIs using Python and PowerShell.
  • Designed and implemented Row Level Security & Roles forSSASTabular Model and deployed on teh On-Premises Analysis Services.
  • Created KPI's, Partitions, Perspectives, and Calculated Measures, used DAX queries, roles.
  • Used DAX (Data Analysis Expressions) functions for teh creation of calculations and measures in teh Tabular Models
  • Setting up Power BI Environment, creating app workspaces, publishing apps and setting up Power BI Gateway.
  • Created Page Level Filters, Report Level Filters, Visual Level Filters in Power BI according to teh requirements.
  • Created different visualizations like, Clustered Bar chart and column chart, Area chart, Heat map, Lie Chart, Pie Chart, Funnel Chart etc. and tables visuals like Matrix visual and Table visual.
  • Transformed data using Power BI power Query, utilizing Power M Query, utilizing teh power bi tool functionality.
  • Published Power BI Reports in teh required origination and Made Power BI Dashboards available in Web clients and mobile apps.
  • Developed Azure Analysis Self-Serve model through different source like Azure Data Warehouse, Snowflake Datawarehouse. Also Built reports and dashboard.
  • Designed and developed Power BI graphical and visualization solutions wif business requirement documents and plans for creating interactive dashboards.
  • Created Dashboard and teh App Workspace for teh originations to get teh updated Power BI Reports. And added teh refresh time for each tile in teh dashboard.
  • Generated ad-hoc reports in Excel Power Pivot and shared them using Power BI to teh decision makers for strategic planning.
  • Developed Tabular Data Models both teh Star Schema and teh Snow Flake Schema using teh right filter directions both in Power BI and SQL Server Analysis Model (SSAS).
  • Utilized Power Query in Power BI to Pivot and Un-pivot teh data model for data cleansing and data massaging.
  • Utilized Power BI gateway to keep dashboards and reports up to-date wif on premise data sources.
  • Good experience developing teh Power BI reports, and formatting according to Business requirement and suggesting teh best practices to teh Business. Created and automated Power BI Audit log report by using PowerShell and REST API’s.
  • Created Power BI administrative scripts using Power BI REST API’s and Cmdlets.
  • Worked on Power BI Embedded to embed custom report visual, dashboard tiles, reports and dashboard in teh Intranet Portal.
  • Created Dashboard and teh App Workspace for teh originations to get teh updated Power BI Reports. And added teh refresh time for each tile in teh dashboard.

Environment: Power BI, MS Sql Server 2008r2 and 2012 MS Excel, Power pivot, SSIS, SSAS, SSRS, Performance point, Dashboard Designer, MS SharePoint Designer 2010, TSQL, SQL, Windows. Azure, Unix, Azure Data Warehouse, Snowflake Datawarehouse, Azure Data Factory.

Confidential, Detroit, MI

Power BI Developer/ SQL Developer

Responsibilities:

  • As a Part of BI/Database team, involved in Requirement Gathering Technical Design, Development, Testing and Implementation of BI Analytics and Reports.
  • Utilized Power BI (Power Pivot/View) to design multiple scorecards and dashboards to display information required by different departments and upper level management
  • Developed over 25 Reports/Dashboards in 3 phases.
  • Provided training on Architecture & Basics of Power BI (Report development) to stake-holders.
  • Created reports utilizing SSRS, Excel services, Power BI and deployed them on SharePoint Server as per business requirements
  • Documented and provided detailed level training on Manual Refresh of Datasets in Power BI (in case of Failed Scheduled Refresh through Gateway)
  • Followed up wif Microsoft Product team on schedule refresh issue for OData (having Organization Autantication) through Power BI Gateway, as it is not an option in Enterprise gateway.
  • Extensively involved in SSAS storage and partitions, aggregations, calculation of queries wif MDX, Data Mining Models, Tabular developing reports using MDX and SQL.
  • Supported in creating KPI, Calculation Members and Measure groups and MDX queries.
  • Worked wif preparing teh documentations for analysis, Technical Specification Documents, Functional Specification Documents, Mapping documents etc., for various migrations and upgradation process.
  • Designed SSAS cube objects such as KPIs, aggregations, perspectives, and translations.
  • Developed Dashboards wif keeping in mind end user’s compatibility/usage.
  • Successfully enacted complex Billable/Non-Billable Business Logic in Power BI Timesheet Report in very brief time span.
  • Formatted dashboards, multiple chart types, trends, and KPIs wif Power View to support analyses.
  • Worked as a developer in creating complex stored procedures, SSIS Packages, Triggers, Cursors, Tables, and Views and other SQL Joins and statements for applications. Generating Reports using Global Variables, Expressions, and Functions for teh Reports and configured Reporting Services in SQL Server 2008.
  • Involved in implementing key performance indicator (KPI) Objects in SSAS 2008and created calculate member MOLAP cube using MDX in SSAS 2008.
  • Designed and build teh dimensions, cubes wif star schema and snow fake schema in Power BI and in SSAS for analysing purpose.
  • Performed complete impact analysis on system software due to suggested modifications/ enhancements and prepared detailed documents identifying program and database design changes required for successful implementation of change module.
  • Translated teh business requirements into workable functional and non-functional requirements at detailed production level using Workflow Diagrams, Sequence Diagrams, Activity Diagrams and Use Case Modelling.

Environment: Power BI, MS Sql Server 2008r2 and 2012 MS Excel, Power pivot, SSIS, SSAS, SSRS, Performance point, Dashboard Designer, MS SharePoint Designer 2010, TSQL, SQL, Windows.

Confidential

SSRS/SSIS DEVELOPER

Responsibilities:

  • Implementation and delivery of MSBI platform solutions to develop and deploy ETL, analytical reporting and scorecard/ dashboards on SQL Server 2012/2008 R2 using SSAS, SSIS/DTS, SSRS.
  • Working wif various business groups while developing their applications, assisting in Database Design, Creating E-R Diagrams using visio and designing Local and Physical Data Model wif Erwin r4.
  • Based on business requirement, developed complex SQL queries wif Joins and T-SQL, Stored Procedure, Views, Trigger to implementing teh business rules and transformations.
  • Involved in creating teh custom objects, workflows, Visual Flow, Page layouts, Emails, alerts, Templates and data validations, triggers and test classes.
  • Involved in extracting teh data using SSIS from OLTP and OLAP.
  • Worked on teh Audit Logs that capture teh audit details before and after teh package execution using Variables and Parameters.
  • Deploying and scheduling reports using SSRS to generate all daily, weekly, monthly, quarterly reports including current status.
  • Involved in generating Matrix reports, Sub reports and complex reports wif multi value parameters for teh analysis of performance.
  • Created Drill reports which give all teh details of various transactions like closed transactions, pending approvals and summary of transactions and scheduled this report to run on quarterly basis using SSRS (Sequel Server Reporting Services).
  • Took part in creating Star Schema, Snowflake dimensional schema in MS analysis services (SSAS).

Environment: T-SQL, PL/SQL, MS Sql Server 2012/2008R2, SSAS 2012/2008, SSAS 2012/2008, SSIS 2012/2008, Power Pivot, Erwin r4, Oracle 9i, DB2, Visual Source Safe(VSS), Tableau, Windows XP, VBscript.

Confidential, Charlotte, North Carolina

SSRS/SSIS DEVELOPER

Responsibilities:

  • Extensively used Joins and Sub-Queries to simplify complex queries involving multiple tables. Written stored procedure to populate final database tables from staging tables and clean inaccurate data. Written T-SQL stored procedures and queries for accessing Data from Teradata Database.
  • Prepared teh complete data mapping for all teh migrated jobs using SSIS. Responsible for creating and designing SSIS 2012 packages. Designed SSIS packages to load data from CSV files to teh staging area in SQL Server.
  • Wrote DDL, DML script for Schema, Table space and Cluster creation and alteration.
  • Worked wif teh program Architect and Technical Architect in design sessions to develop high-level solutions architecture for SQL Server Reporting services
  • Scheduled packages using SQL Server Agent jobs to execute at specified time on weekly and monthly basis. Participated in designing Logical and Physical data models for data mart.
  • Use package configuration to migrate SSIS package from one environment to other.
  • Involved in scheduling, creating snapshots and subscriptions for teh reports using SSRS 2012.
  • Experience in writing client-side as well as server side Multi-dimensional Expressions (MDX) for incorporating data querying capability for inventory and forecast cubes.
  • Experienced in capturing metrics/storage behaviours of cube metadata such as partition growth statistics and aggregation limitations.
  • Performed routine functions in Informatica like loading data from a flat source file into a target and apply transformations for teh data according to teh requirements.
  • Created Ad-Hoc reports using Report Builder and maintained Report Manager for SSRS.
  • Generated different types of reports (Tabular /Matrix) using MS SQL Server Reporting Services (SSRS).
  • Created Technical Documentation for reports and maintenance/enhancements of existing Reports.
  • Actively participated in User Acceptance Testing and debugging of teh system.

Environment: Microsoft SQL Server 2005, 20012, SSRS, SSAS, SSIS, T-SQL, MS Excel, MS Sql Server Management Studio, Informatica, Visual Studio 2005, Windows Enterprise Server

Confidential

SSRS/SSIS DEVELOPER

Responsibilities:

  • Created tables, views, index based on teh requirements.
  • Wrote complex SQL Queries to retrieve information from teh database depending on teh requirement
  • Worked as part of a team for gathering and Analysing Business Requirement.
  • Worked on interface process which download teh file from client FTP and process teh applications in production database on teh requirement.
  • Worked on developing and modifying Informatica mappings (ETL) from source to staging and staging to target.
  • Translated business logic to transformation logic to generate pseudo code for teh ETL process.
  • Created packages using SSIS 2012 for Data Extraction from flat files, Excel files, OLEDB to SQL Server using ETL tools.
  • Tested packages and fixed bugs using SQL 2005 Business Intelligence Development Studio.
  • Fine-tuned SQL queries using hints for maximum efficiency and performance.
  • Developed ETL packages using SQL Server 2005 integration services to populate data from different sources like from flat files/SQL/Oracle Server to teh staging database and tan into teh data warehouse. Teh packages created included a variety of transformation like slowly changing dimensions, look up, aggregate, derived column, conditional split, fuzzy lookup, and multicast and data conversion.
  • Worked on DTS packages, DTS Import/Export for transferring data from heterogeneous database.
  • Designed using Star Schema using SQL Server Analysis Services 2008/2005 (SSAS)
  • Developing OLAP cubes for migrating existing reports onto this new platform.
  • Experience in wring complex MDX Queries for calculated members and measure groups.
  • Design Stored Procedures, Views, Triggers, Function for data ware housing.

Environment: Ms SQL Server, SSAS, SSIS, SSRS 2005/2008/2012 , Crystal Reports, Oracle 9i, ETL, DTS, Data Modelling, Data Warehousing, Visual Studio 2014/2012/2008 & 2005, SQL, T-SQL, Ms Excel, XML

Hire Now