Power BI Developer
Location : Jaipur, India
Experience : 11 Year
Rate: $18 / Hourly
Availability : Immediate
Work From : Any
Category : Information Technology & Services
Nirav – 10+ Years – Power BI
Summary
Microsoft Certified Developer with 10 + year of demonstrated history of working in the US
Healthcare software industry. Experience in Web development, SQL Server development, BI
development, ETL (SSIS), Data warehouse, and Report development (SSRS/ Crystal/ Power BI)
support. Currently looking for a job profile with an opportunity to work, experiment and grow in
the latest technology and development trend.
Professional Expertise
● 10+ years of IT experience in Business Intelligence, specializing in MicroStrategy and
Power BI with sound knowledge in ETL & Data warehousing concepts
● Involved in system analysis & design of the Enterprise data warehouse implementation
Created various database tables and procedures to update and clean the old data.
● Actively involved as part of a team for gathering and analyzing the needs of End User
Requirements and System Specifications Created various complex SQL Queries, Stored
Procedures, Views, Cursors and User Defined Functions to implement the business logic.
● Designed SSIS Packages in SQL Server 2012 to handle data migration (ETL Processes) from
transaction System to Dimensional Model.
● Performed activities like analyzing and improving the architecture of databases, creation
& indexing of the tables.
● Involved in designing the data warehouse and core Database for the system including
tables, Stored Procedures, Indexes, UDF and triggers.
● Performed operations such as Fine-tuning queries and stored procedures and providing
consultation to other developers.
● Reviewed and approved sign-off of developers reporting related test documentation in a
Change Management Process.
Experience
Confidential
● Work with Business Users and Managers to understand the business needs and Design
the Data Model to fulfill the needs.
● Managing Project estimations for analytics projects.
● Modeling Datawarehouse/Data mart, Data Lineage using ER studio.
● Architecting the optimal Model and ETL Solution to extract and load the data from
different source systems to EDW using AF, SSIS, Azure Databricks Establish and enforce
technical standards for deliverables of projects.
● Lead Data warehousing and ETL team Members to achieve deliverable standards.
● Development of embedded power BI dashboard and paginated reports.
● Involved in data science Operations (Data feed and EDA).
Confidential
● Work collaboratively, train and lead geographically distributed teams across India and US.
● Architecture/Modeling design of database/Warehouse/Datamart to support complex
healthcare BI Reports and dashboards.
● Performing optimization of database structure by restructuring and L2 support.
● Development and maintenance ETL/ELT pipelines using SSIS and ADF.
● Creating dashboards and reports using Power BI and SSRS.
● Writing complex queries to support one of Top 10 EMRs in US market.
● Codes, tests, debugs, implements, and documents programs or technical configuration
using C#, .NET, SQL, SSIS, SSRS, SAPBO and Precision BI.
● Involved in predictive analysis (Feature selection, Model development, training, and
deployment) in Azure SQL server
Technical Skills
Database skills
● Designing database structures and tables
● Query tuning and optimization
● Developing functions, views, and stored procedures
● Relation Database Management
● SQL Server 2014/2016/2017/2019
● NoSQL (Redis)
Data Warehousing skills
● Data Modeling (Conceptual, Logical and Physical)
● Dimension Modeling
● Data Modeling Using ER Studio
● Datawarehouse/DataMart Operations
● SnowFlake Data Warehouse
ETL/ELT Skills
● ETL/Data Lineage Architecture and Mapping
● Data Cleansing and Validation
● Audit/Meta Process
● SSIS, Azure Data Factory, Azure Data Flow
Reporting Skill
● SSRS, Crystal Report, SAP BO
● Precision BI
● Power BI Dashboard/Reports
Cloud Skills
● Microsoft Azure
● Azure Blob Storage, Azure Data Lake
● Azure Data Bricks, ADF
● Azure synapse analytics
Scripting Languages
● Net (C#, Vb.net), HL7
Experience
● The architecture of database and tuning queries, ETLs and Reports.
● Architecture design of the
{{contact.cdata.phone}}
{{contact.cdata.email}}
View Resume
