Jahnabi Barman

Background

About Jahnabi Barman

Microsoft Certified Specialist with experience in design and development of database, data integration and reporting applications across multiple domains. • Proven qualifications in data modeling, analyzing requirements, planning, designing and implementing innovative database solutions that meet or exceed challenging business needs. • Expertise in Power BI, Power BI Pro, Power BI Mobile, Power BI Premium and Power BI Embedded. • Expertise in SQL Server Integration Services (SSIS) and SQL Server Reporting Services (SSRS) with good knowledge on SQL Server Analysis Services (SSAS). • Experience in MS SQL Server, Microsoft Azure SQL and SSIS (Integration Service) package design, constructing, and deployment. • Designed, developed and implemented Power BI Dashboards, Scorecards & performance Reports. • Used SSIS Control flow tasks such as Execute SQL Task, For Each loop task, FTP Task, File system task. Used Data flow task, OLE Db connection, Derived Column task, Conditional split and Row count Transformation. • In-depth knowledge of T-SQL, PostgreSQL Databases, Tables, Stored Procedures, DDL/DML Triggers, Views, User defined data types, Cursors and Indexes. • Extensive experience in report writing using SQL Server Reporting Services like Tabular report, Matrix report, Chart report, Pie Charts and Column report. • Built effective reports/dashboards using visualizations such as Power KPI matrix, Stacked bar, Clustered bar, Donut, Waterfall, Gauge, Tree-map, Pie charts, Heat-maps, Histograms etc. along with many custom visuals. • Good experience in DAX formulas such as summarize group by, Intersect, calculate, filters and SUMX, MAXX, Hasonevalue, Hasonefilter and switch etc. • Experience in developing Dashboard Report, Parameterized Reports, Linked reports, Sub reports by Region, Year, Quarter, Month and Week. • Extensive knowledge of DAX code to support the business requirements in column and measure variables. • Worked as a Premium Capacity admin of Power BI and set up incremental refresh of reports containing large volume of data. • Have extensive experience in Power BI Embedded capacity. • Set up Power BI Gateway Services for refreshing report from on premise databases. • Added Row Level Security in Power BI reports. • Experience with Azure SQL Server, Azure Data Factory, Azure ML, BLOB storage. • Proficient knowledge of Data Warehousing methodologies and concepts, including star schemas, snowflakes schemas, ETL processes, dimensional modeling and reporting tools.