We provide IT Staff Augmentation Services!

Bi Developer /power Bi Developer Resume

Boise, ID

SUMMARY

  • Solid understanding of the entire Microsoft BI Stack including SQL Server, SSIS, Data Warehouse, SSRS, Power BI with at least 7 years of experience with Microsoft BI tools
  • Created databases, tables and provide constraints and user defined rules and defaults.
  • Developed SSIS Packages to Extract, Transform and Load (ETL) data into the Data warehouse from SQL Server.
  • Involved in building a data - warehouse and Datamart with Dimensions and Fact Tables based on the Business requirements.
  • Write Stored Procedures to populate various dimensional tables and the fact tables for the Data Warehouse.
  • Designed data structure with multiple facts and dimension tables to hold the source data to be used for building new reports with SSRS and power BI.
  • Worked on T-SQL programming, stored procedures and views in the process of developing Power BI and SSRS reports.
  • Strong data visualization skills, and ability to apply them to provide actionable business insights.
  • Hand on experience using Azure DevOps and GitHub for managing source code changes.
  • Developed compelling and interactive analysis reports and dashboards using advanced DAX.
  • Expertise in Power BI, Power BI Pro and Power BI Primum
  • Worked in Development, Testing and Production environment.
  • Published Power BI Reports and made available in Web clients and mobile apps.
  • Organized, self-starter and effective team member with excellent problem-solving skills.
  • Excellent in writing various DB objects like user defined functions, views, indexes, Procedures, Functions, Packages, and Triggers.
  • In-depth knowledge and skills in SQL query building.
  • Maintained data integrity by Creating checks and constraints.
  • Optimized the performance of queries with modification in T-SQL queries, normalized tables, established joins, created indexes etc.
  • Handled performance tuning and optimization, with strong analytical and troubleshooting skills for quick issue resolution.
  • Troubleshoot slow performing queries by using SQL Profiler.
  • Performed some DBA Tasks like checking the jobs that fail and troubleshooting the issues.
  • Developed, tested and implemented Referential Integrity rules and regulations through constraints, triggers and views in the centralized SQL database.
  • Designed and developed data warehouse, data marts and business intelligence using multi-dimensional models
  • Implemented different Slowly Changing Dimension methodologies to maintain and update historical data corresponding to Dimension tables in the Data warehouse.
  • Implement Star and/or Snowflake schemas while designing relational database and data warehouse as per business and report requirements.
  • Write Stored Procedures to populate various dimensional tables and the fact tables for the Data Warehouse.
  • Used ETL to implement the Slowly Changing Transformation, to maintain Historical Data in Data warehouse.
  • Practical understanding of the Data modeling (Dimensional & Relational) concepts like Star-Schema Modeling, Snowflake Schema Modeling, Fact and Dimension tables.
  • Imported data from different source to Power BI to generate different type reports.
  • Worked on all types of transformations that are available in Power BI query editor.
  • Developed custom calculated Measures using DAX in power BI to satisfy business need.
  • Worked on all kind of reports such as Yearly, Quarterly, Monthly, and Daily.
  • Expert in creating and developing Power BI Dashboards into rich look.
  • Created Workspace and content packs for business users to view the developed reports.
  • Installed and Configured Enterprise Gateway and Personal Gateway in Power Bi Services.
  • Scheduled Automatic refresh and scheduling refresh in power bi service.
  • Weekly presentation to the business users about the reports and their changes as required.
  • Expertise in Power BI pro and Power BI Primum.
  • Participated in project planning sessions with project managers, business analysts and team members to analyze business requirements and outline the proposed solution.
  • Wrote SQL queries and stored procedures to generate data for reports.
  • Defined the report layout and identified datasets for the report generation.
  • Created, formatted, and maintained various report in SSRS like drill-down, drill through, sub reports, Ad hoc reports, parameterized reports, interactive reports & custom reports.
  • Configured the report viewing security for various users at various levels using Report Manager.
  • Deploying and scheduling Reports using SSRS to generate all daily, weekly, monthly and quarterly Reports including current status.

PROFESSIONAL EXPERIENCE

BI Developer /Power BI developer

Confidential, Boise , ID

Responsibilities:

  • Overall database design, such as creating normalized databases, authentication, query tuning, assigning proper indexes, creating stored procedures, functions, triggers and data types.
  • Establishing referential integrity, data consistency, and indexing procedures to maintain high quality data that can be used for reporting.
  • Using SSIS to create ETL packages to validate, extract, transform and load data to data warehouse databases.
  • Implemented Various Error handling and Event Handling Techniques in SSIS to ensure efficient package execution and to improve their performance.
  • Responsible for Configuring, Deploying, Scheduling Jobs, and Maintaining SSIS packages.
  • Converted various SQL statements into stored procedures thereby reducing the Number of database accesses.
  • Analyzing a huge number of existing reports to understand the logical and interface design changes to be applied accordingly.
  • Worked on T-SQL programming, stored procedures and views in the process of developing reports.
  • Implemented several DAX functions for various fact calculations for efficient data visualization in Power BI.
  • Utilized Power BI gateway to keep dashboards and reports up to-date with on premise data sources.
  • Utilized Power BI (Power Pivot/View) to design multiple scorecards and dashboards to display information required by different departments and upper level management.
  • Designed complex data intensive reports in Power BI utilizing various graph features.
  • Using DevOps and GitHub for managing source code changes.

Environment: SQL Server 2012/2014/2016 , T-SQL, SSMS, Excel, SSIS, SSAS, SSRS, Power BI, Power Pivot, GIT, GitHub, Visual Studio.

Confidential

ETL Specialist

Responsibilities:

  • Created Databases, tables and provide constraints and user defined rules and defaults.
  • Query tuning based on query execution plans, statistics, and profiling
  • Development and performance tuning of complex stored procedures, user defined functions and views for data migration.
  • Design SSIS packages to bring data from existing OLTP databases to the new data warehouse by performing different kinds of transformations like lookup transformations, merge joins, fuzzy look ups, derived columns, merge join, conditional split, data conversion with multiple data flow tasks.
  • Design and implementation of the Data Warehouse/DataMart life cycle.
  • Working on all phases of Data warehouse development lifecycle, from gathering requirements to testing, implementation, and support.
  • Used ETL to implement the Slowly Changing Transformation, to maintain Historical Data in Data warehouse.
  • Developed complex SSAS cubes with fact measures groups, and multiple dimension hierarchies based on the OLAP reporting needs.

Environment: SQL Server 2012/2014/2016 , T-SQL, SSMS, Excel, SSIS, SSAS, SSRS, Power BI, Power Pivot, GIT, GitHub, Visual Studio.

Database Developer

Confidential, Bellevue, WA

Responsibilities:

  • Created new database objects like Procedures, Functions, Packages, Triggers, Indexes and Views using T-SQL in Development and Production.
  • Optimized the performance of queries for improved Performance and availability with modification in T-SQL queries, normalized tables, established joins, and created indexes.
  • Worked on T-SQL programming, stored procedures and views in the process of developing reports.
  • Generating different kind of report in various formats like Table format and Matrix format using Reporting services (SSRS) to display in a customized format as per business requirements.
  • Created and implemented complex SSIS package to migrate data from multiple data sources for data analyzing, deploying and dynamic configuring of SSIS packages.
  • Used different type of SSIS transformation for data cleansing to remove unnecessary columns, eliminated redundant and inconsistent data.
  • Configured packages with checkpoints, package logging, error logging and event handling to redirect error rows and fix the errors in SSIS.
  • Involved in automating SSIS packages using SQL server agent jobs, windows scheduler.
  • Involved in creation of fact and dimension tables in the OLAP database and created cubes using MS SQL Server Analysis Services (SSAS).

Environment: SQL Server 2012/2014/2016 , T-SQL, SSMS, Excel, SSIS, SSAS, SSRS, Power BI, Power Pivot, GIT, GitHub, Visual Studio.

Hire Now