We provide IT Staff Augmentation Services!

Power Bi Developer Resume

Green Bay, WisconsiN

PROFESSIONAL SUMMARY:

  • Over 6 Years of experience in Business Intelligence lifecycle projects from requirement gathering, documentation, data analysis, modeling, development, testing, production, deployment and support.
  • Excellent knowledge of entire Software Development Life Cycle (SDLC) methodologies like Agile, Scrum, UML, Waterfall and Project Management Methodologies.
  • Experienced in TSQL (DDL, DML), documenting, modifying and implementing Business Intelligence solutions.
  • Experienced in relational database design, SQL queries, stored procedures, clustered and non - clustered indexes, views, joins and Nested queries.
  • Experience in using, temp tables, Views, Table Variables to facilitate efficient data manipulation and data consistency as well as to support the existing application
  • Involved in Normalization and De - Normalization of existing tables for faster query retrieval / query optimization.
  • Well versed in Using MDX/DAX Queries to retrieve data from Analysis Services Cubes.
  • Experience in designing Star, Snowflakes schemas and database modeling using Erwin tool.
  • Extensive­­ experience in designing, developing, and delivering business intelligence solutions using Power BI.
  • Experience in the Analysis, design, development, testing and Implementation of ETL & Business Intelligence solutions using Data Warehouse/Data Mart Design, ETL, SQL SERVER, MSBI and Power BI.
  • Responsible for creating SQL datasets for Power BI and Ad-hoc Reports.
  • Created, Maintained & scheduled various reports in Power BI like Tabular Reports .
  • Experienced on creating multiple kind of Report in Power BI and present it using Story Points
  • Extract and analyze data using Power Query, PivotTables, MS Excel, Power BI and SSAS
  • Migrate existing data into the Power BI.
  • Used DAX ( Data Analysis Expressions ) functions for the creation of calculations and measures in the Tabular Models
  • Expert in Data Extraction, Transforming and Loading (ETL) using various tools such as SQL Server Integration Services (SSIS), DTS, Bulk Insert and BCP.
  • Expertise in developing Parameterized, Chart, Graph, Linked, Dashboard, Scorecards, Report on SSAS Cube using MDX, Drill-down, Drill-through and Cascading reports using SSRS.
  • Created SSRS packages with different data sources (Flat Files, Excel source files, XML files etc.) and then loaded the data into destination tables.
  • Excellent knowledge and experience of creating Jobs, Alerts, SQL Mail Agent , using various Control flow items ( such as Execute package task, Execute Process Task)
  • Experienced in creating highly interactive Data Visualization Reports and Dashboards using features such as Data Blending, Calculations, Filters, Actions, Parameters, Context Filters, Sets, groups etc.
  • Proficient in creating Ad-hoc reports, Scheduled reports, defining query for generating drilldown, drill through reports, MATRIX, tabular reports for different business domains depending on the specifications and requests.
  • Having knowledge on maintaining and managing Power BI and Tableau driven reports and dashboards.
  • Used Visual Team Foundation server for version control, source control and reporting.
  • Scheduled reports for Daily, Weekly, Monthly reports on sales and marketing information for various categories and regions based on business needs using Reporting services (SSRS).
  • Strong debugging skills and the ability to solve complex problems.
  • Good team player with strong analytical skills.
  • Excellent communication, interpersonal, analytical skills and strong ability to perform as part of a team

TECHNICAL SKILLS:

Databases: MS Access, SQL Server 2008 R2,2012,2014,2016, Oracle 9i, 10g, T-SQL

Reporting Tools: Power BI, SQL Server Reporting Services, Tableau, Excel.

Database Tools: SQL Query Analyzer, SQL Enterprise Manager, Visual Studio, Analysis Manager, Reporting Server, JIRA, Agile Central

Office Tools: MS Word, Power Point, Visio and MS Excel

Operating Systems: Windows XP, 2000, NT, 98, 95, Windows 2003, Windows Vista, Windows 7

T: SQL, HTML, C#.Net, VB.Net, C++, Java, Java script, CSS, Windows Scripts

Data Warehouse / Business Intelligence Tools: SQL Server Reporting Services (SSRS), SQL Server Integration Services (SSIS), Visual Studio 2013/2010/2008 , SSAS, Business Intelligence Development Studio (BIDS) 2008, MS Data Tools 2012

PROFESSIONAL EXPERIENCE:

Confidential, Green bay, Wisconsin

Power BI Developer

Responsibilities:

  • Analyzed the Business Requirement Document (BRD) to design a conceptual model, participate in all phases of SDLC process to implement T-SQL, SSIS, SSAS and SSRS to develop a solution.
  • Writing complex SQL Queries, Stored Procedures, Views, Cursors and User Defined Functions to implement the business logic.
  • Established the relationships among the tables in the database by assigning primary keys, foreign keys and established the referential integrity.
  • Created Tables, Views, SQL joins and defined roles and privileges to implement business rules and control access to database.
  • Created Database Maintenance Plans for the Performance of SQL Server, which covers Database Integrity.
  • Wrote standard & complex T-SQL Queries to perform data validation and graph validation to make sure test results matched back to expected results based on business requirements.
  • Wrote complex SQL queries in database Access and created various joins (inner, outer joins) to fetch the desired output for Data Analysis.
  • Have worked extensively on MS Access to create various tables and queries and implement business logic in VB.NET.
  • Created Forms and reports using Dashboard in MS Access.
  • Expertise in loading data warehouse from heterogeneous databases such as Oracle, DB2, Sybase and MS Access using SSIS packages.
  • Developed high Level Design of ETL Package in VS 2015/13/12 for integrating data from heterogeneous sources (Excel, CSV, Oracle, flat file, Text Format Data) using SSIS.
  • Gathered report requirements and determined the best solution to provide the results in either a Reporting Services report or Power BI.
  • Created Power BI Visualizations and Dashboards as per the requirements
  • Used DAX (Data Analysis Expressions) functions for the creation of calculations and measures in the Tabular Models.
  • Created effective reports using visualizations such as Bar chart, Clustered Column Chart, Waterfall Chart, Gauge, Pie Chart, Tree map etc. in Power BI.
  • Designed and developed various complex reports such as Drill down, Drill Through, Cross Tabbed using MS Reporting Services.
  • Strong experience on connecting various Data Sources in Power BI.
  • Created various data modelling in Power BI and linking the tables using various dimensions.
  • Created Tabular Models using DAX queries in Power BI deployed it.
  • Developed and maintained multiple Power BI dashboards/reports and content packs.
  • Responsible for building Power BI Dashboards using Tabular and Multi-Dimensional Models.
  • Design and model data sets with Power BI desktop based on measure and dimension requested by customer and dashboard needs.

Environment: T-SQL, MS SQL Server 2016, SQL Server Integration Services (SSIS), SQL Server Reporting Services (SSRS),, Power BI Desktop, Power BI Service, Data Gateway, DAX, T SQL, SQL Profiler, XMLA, MS Excel, Excess, Windows 8.

Confidential, Detroit, Michigan

Power BI Developer

Responsibilities:

  • Developed and Published dynamic and complex Financial and Sales Reports in Power BI.
  • Used DAX to create complex measure and calculated columns.
  • Setting up Environment, creating app workspaces, publishing apps and setting up Power BI Gateway.
  • Used bookmarks feature which enables the ease to jump to respective report tabs with one click.
  • Imported custom themes and page backgrounds for rich visual effects.
  • Performed end to end testing on the reports and packages developed to ensure data quality is met.
  • Utilized Power BI gateway to keep dashboards and reports up to-date with on premise data sources.
  • Created drill down and drill through report to go to details and child report within power bi based on hierarchy.
  • Utilized Power Query in Power BI to Pivot & Un-pivot the data model for data cleansing and data massaging.
  • Creating and managing schema objects such as Tables, Views, Indexes and referential integrity depending on user requirements.
  • Develop and deploy SSIS packages, configuration files, and schedules job to run the packages to generate data in CSV files.
  • Design, Implement and maintain Database Schema, Entity relationship diagrams, Data modeling, Tables, Stored procedures, Indexes, Views, Rules, Defaults and complex SQL statements.
  • Maintained the database schema in source code control (MS Team Suite Database Edition preferred).
  • Involved in XML Development and XML File Parsing in SSRS.
  • Developed the SQL programs and Involved in optimize stored procedures and queries for faster retrieval and Server efficiency.
  • Used Quality center (Defect tracking tool) for Bug fixing and resolution details.
  • Generated Reports using Global Variables, Expressions and Functions for the reports.
  • Designing and implementing a variety of SSRS reports such as Parameterized, Drilldown, Ad hoc and Sub-reports using Report Designer and Report Builder based on the requirements.
  • Performance tuning of SQL queries and stored procedures using SQL Profiler and Index Tuning Wizard.
  • Used multiple transformations to meet the business requirements by extracting data from heterogeneous source systems, transform and finally load into the Staging Data base.
  • Worked in importing and cleansing of data from various sources like DB2, Oracle, flat files.
  • Worked in Enterprise Manager for job scheduling and batch queries.
  • Used Microsoft Power BI Power Query to extract data from external sources and modify data to certain format as required in Excel.
  • Wrote DAX Expressions, Power Query, Functions in power bi.
  • Used Power BI Power Pivot to develop data analysis prototype and used Power View and Power Map to visualize reports.
  • Monitored performance and optimized SQL queries for maximum efficiency.
  • Implemented fine tuning of database objects and server to ensure efficient data retrieval.
  • Planned Backup strategy based on projects requirements.
  • Involved in project planning also schedule for database module with project managers.

Environment: MS SQL 2008 R2/2012, SSIS, SSRS XML, T-SQL, DAX, MS Word, MS Excel, MS CRM,VBA (Visual Basic for Applications), Share point, DTS, C#,ASP.NET, Microsoft Visio, Crystal Reports, ER Studio, Performance point Server, Sales force, Team Foundation Server, FTP & SFTP server, Power-BI Tool.

Confidential

BI Developer

Responsibilities:

  • Generated database monitoring and data validation reports in SQL Server Reporting Service (SSRS).
  • Created partition table for very large database for good performance.
  • Transfer data crossing different platforms, validate data during transferring, and archived data files for different DBMS.
  • Created logging, custom logging and error handling packages.
  • Deployed reports to Production Servers.
  • Published Power BI Reports in the required origination's and Made Power BI Dashboards available in Web clients and mobile apps.
  • Used One Drive for storing different versions of Power BI report.
  • Worked with OBIEE Administration Tool.
  • Converting complex sql query solutions in to OBIEE model solutions.
  • Have done Security implementation of OBIEE repository level.
  • Created different visualization (Stacked bar Chart, Clustered bar Chart, Scatter Chart, Pie Chart, Donut Chart, Line & Clustered Column Chart, Map, Slicer, Time Brush etc.) in Power BI according to the requirements.
  • Maintained System Monitoring Jobs and provide high availability support.
  • Worked on Migration of packages from DTS.
  • Assisted internal and external report needs and designed solutions based on specific requirements using SQL Server Reporting Service (SSRS).
  • Created and developed the stored procedures, triggers, views, and user-defined functions to support application development.
  • Involved in Normalization and De-Normalization of existing tables for faster query retrieval
  • Deployed and configured the reports in the Report Server.
  • Created User Defined Functions to encapsulate frequently and commonly used business logic making the system more modular, secured and extensible.
  • Generated test data and tested database to meet the functionalities deliverables in the project documentation and specifications.
  • Designed and developed MS SQL Server Reporting Services (SSRS) under SQL Server 2008.
  • Worked closely with IT project managers, programmers, and testers.

Environment: SQL Server 2008 Enterprise Edition, SSRS 2008R2, VisualStudio.net, XML, MS Excel, MS Access, Visual Studio 2008R2

Hire Now