Power Bi Sql Server

JAHNABI BARMAN

Phone : +1-484-***-****

Mail : *******.********@*****.***

Address: ** ************ **, ****** ********, New Jersey

SUMMARY

●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 of SQL Server Analysis Services (SSAS).

●Experience in MS SQL Server, Microsoft Azure SQL and SSIS (Integration Service) package design, constructing, and deployment.

●Designed and managed SSAS OLAP cubes and tabular models for streamlined data analysis, improving reporting efficiency across departments.

●Created POCs using Microsoft Co pilot.

●Familiar with Microsoft Fabric and its integration into the modern data landscape, ensuring seamless data transformation and analytics.

●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.

●Designed, developed and implemented Power BI Dashboards using Power Query and M integrating multiple data sources like Snowflake, MS SQL, PostgreSQL, and MySql,

●Created Dashboard using Tableau to communicate complex ideas to the executive committee.

●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 Power Query and 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.

●Worked as a Premium Capacity admin of Power BI and Power BI Embedded capacity.

●Performed subscriptions and refresh extracts in Power BI as well as set up data alerts on business-critical data utilizing Power BI services.

●Set up Power BI Gateway Services for refreshing reports from on premise databases.

●Designed reports using Power Automate which enables users to send reports or parts of reports via email, to stakeholders, directly from Power BI.

●Added Row Level Security in Power BI reports and implemented incremental refresh to handle large datasets.

●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.

●Led Power BI training sessions for business units to improve self-service reporting and analytics capabilities.

TECHNICAL SUMMARY

Certifications: Six Sigma Certified

Languages: T-SQL, PL/SQL, PL/pgSQL, MySQL, Snowflake db, Hive, DAX, MDX, HTML, JAVA, C++

Database Tools: Microsoft SQL Server 2008 R2/2012/2014/2016, Oracle SQL Developer, Microsoft Access, pgadmin

Web: HTML, CSS, XML, JSON

BI Tools/ETL: Microsoft Data Tools, Power BI, Tableau, Google Data Studio, Visual Studio 2017, SSIS, SSRS, SSAS, IBM Cognos, Looker

Analytics Tools: SPSS, Minitab, Weka, Visual Paradigm

Others: Microsoft Office (Excel/ Word/ PowerPoint), Microsoft Visio, Microsoft Project.

Cloud: Power BI Service, Azure SQL Server, Azure Data Factory, BLOB storage

EXPERIENCE

Business Intelligence Dev Lead January 2022 - Present

Client: Zelis - Zelis Healthcare Corporation operates as a healthcare information technology company. The Company focuses on network analytics and access, claims integrity and electronic payments for healthcare payers, providers and consumers in the medical, dental, and workers' compensation.

●Build High level technical design both for Streaming and batch processing systems

●Design and build reusable components, frameworks and libraries at scale to support analytics data products

●Perform POCs on new technology, architecture patterns.

●Familiar with Microsoft Fabric and its role in seamless data transformation for the organization.

●Designed reports using Power Automate which enables users to send reports or parts of reports via email, to stakeholders, directly from Power BI.

●Developed over 50 interactive Power BI dashboards, resulting in a 30% reduction in report generation time and improving executive decision-making processes by 20%.

●Worked at implementing Power BI embedded in a custom organizational website.

●Design and implement product features in collaboration with business and technology stakeholders.

●Implemented Incremental refresh to take care of the large volume of data.

●Worked as the Power BI Premium capacity admin and handled all the access and permission controls.

●Clean, prepare and optimize data at scale for ingestion and consumption.

●Implement complex automated workflows and routines using workflow scheduling tools like SSIS.

●Analyze and profile data for the purpose of designing scalable solutions.

●Troubleshoot complex data issues and perform root cause analysis to proactively resolve product and operational issues.

●Lead, Mentor, and develop offshore Data Engineers in adopting best practices and delivering data products.

●Partner closely with product management to understand business requirements.

Business Intelligence Dev Lead October 2019 – January 2022

Client: Analytic Partners is a global analytics consultancy and technology company that helps optimize data, analytics, and strategic and tactical decisioning.

●Developing various dynamic visualizations. and portal interfaces using Power BI & Tableau.

●Designed reports to include visuals which will deliver the best insights to the customers while meeting WCAG guidelines.

●Developing various ETL solutions using SSIS or Azure data Factory and using Azure Blob storage and Data Lakes.

●Row level security implemented to restrict data insights by various levels of user within a same organization.

●Used bookmarks to give a smooth navigation experienced to users.

●Work as part of a high functioning team, tasked with supporting day to day operations of a busy project, analyzing and maintaining very large transactional datasets in SQL Server and Redshift.

●Undertaking development of data integration pipelines in and out of Data Lake, Data Warehouse & DataMart using a combination of SQL & Python.

●Using Amazon S3 buckets, Sharefile and other technologies to gather external data for Analytics and reporting.

●Created reports to limit visuals and data by users.

●Worked closely with web developers to implement Power BI embedded in custom applications to show reports.

●Integrated Power BI with Power Apps and Power Automate to create interactive, automated workflows, streamlining data entry and reporting processes across multiple teams.

Business Intelligence Developer January 2019 – October 2019

Client: Integra Lifesciences offers innovative solutions in orthopedic extremity surgery, neurosurgery, and reconstructive and general surgery. In the United States, Integra is a leading provider of surgical instruments to hospitals, surgery centers and alternate care sites, including physician and dental offices.

●Migrated reports from Cognos to Power BI, leveraging Power Query to clean and transform data.

●Worked on creating generic views by considering the requirements of end user reports in EDW.

●Created Stored procedures and SSIS packages to automate complex manual workflows.

●Led Power BI training sessions for over 50 business users, enabling a self-service reporting environment and reducing report request volume by 40%.

●Row level security implemented so that we can restrict the data by geographies.

●Created generic Datasets with SQL queries which can be used as self-service BI by end users.

●Implemented currency translation to show reports in local currencies.

●Worked as the capacity admin and handled all the access and permission controls.

●Scheduled automatic refreshes and alerts for the reports.

●Collaborated with marketing and finance teams to build Power BI dashboards that tracked key performance indicators (KPIs), improving interdepartmental communication and strategic planning.

●Implemented Incremental refresh for the reports.

Power BI Developer January 2018 – January 2019

Client Sapphire Digital is an online Healthcare Portal who empowers everyone to shop for their health care. Sapphire Digital leads the market with a digital health platform powered by predictive analytics, engagement and incentive designs that drive new levels of engagement. The company creates measurable and sustainable health care savings for consumers, employers and health plans.

Responsibilities

●Set up the entire Power BI environment for the company.

●Created the data warehouse on PostgreSQL.

●Installed third party data connectors to get data from PostgreSQL to Power BI.

●Created various dashboards on Financial as well as Operational data.

●The Operational dashboard along with Daily Performance dashboard and Book of Business dashboard helped the company set up proper campaigns to target new customers.

●Designed and managed SSAS OLAP cubes and tabular models for streamlined data analysis, improving reporting efficiency across departments.

●Created advanced SSRS and Power BI paginated reports, delivering detailed visualizations and dashboards that supported data-driven decision-making.

●Utilized SSAS to build complex MDX and DAX calculations, enhancing data analysis capabilities and enabling self-service BI options for business users.

●Worked as the capacity admin and handled all the access and permission controls.

●Scheduled automatic refreshes and alerts for the reports.

●Implemented Incremental refresh for the reports.

●Added Row Level Security for different Sales team, which will restrict the salesperson to access data pertaining to his geographical location only.

●Integrated Power BI reports in Organization’s internal website using Power BI embedded.

●Worked on couple of ETL projects to streamline their process of reaching out to customers, using SSIS.

●Automated various workflows using Power BI, SSIS and Microsoft SQL server.

●Co-ordinated with the users directly to understand their requirements and proposed design based on the requirements.

BI Developer March 2016 - January 2018

Client Federal-Mogul serves customers in the automotive aftermarket with maintenance, service, and performance-enhancing products and original equipment manufacturers of cars, trucks, heavy-duty vehicles, commercial vehicles, agricultural, aerospace and other industrial applications with premium products.

●Created and consulted on report user interface. Introduced latest features of reporting that would be useful to the business users.

●Created Power BI reports based on SAP BW data from Inventory and Accounts Payable.

●Worked on Azure SQL Server and Azure Analysis Services to build model and connect them with Power BI reports.

●Created Pipeline in Azure Data Factory to Transform data in Blob Storage.

●Inventory and Accounts payable views were created by joining numerous facts and dimension tables in SQL database.

●Created drill through reports in Power BI to get further insights into the data for each of the parameters on which quality was measured.

●Used custom Power BI visuals and conditional formatting of tables.

●Created many calculated columns and measures in Power BI using DAX to better evaluate quality.

●Showed currency translated values based on different currencies according to currency selected in slicer using current currency rates.

●Created executive dashboards using Power BI to visually display the data to the business users.

●Created group workspace on Power BI service to enable business users to create their own reports using existing reports.

●Tested and validated report accuracy with the business users to make sure that warehouse and report data is consistent.

●Regularly monitored reports refresh schedule and fixed any issues that hindered the performance of the reports.

●Installed and monitored Power BI gateway on the data server to enable data refresh of the reports on Power BI Service.

●Implemented incremental refresh for large data sets for efficiency.

●Implemented Power BI embedded to show reports in the organization’s own web applications.

●Co-ordinated with Microsoft support to fix issues in Power BI service.

SUN SECURITY SERVICES April 2013 - February 2016

(Business Intelligence Analyst /Data Analyst) Guwahati, India)

A leading service provider in the region with services rendered to most of the leading big names in the region. It has rendered security services to all the leading PSUs, Corporates, Banks, Universities, Educational institutions, Expos and escorts to VIPs.

Responsibilities

●Actively involved in gathering requirements from business, involved in modifying various technical and functional specifications.

●Created Dashboards with interactive views, trends and drill downs using Tableau.

●Combined visualizations into Interactive Dashboards and publish them to the web.

●Analyzing the requirement and building SQL Queries.

●Created Cascading reports in Dashboard.

●Experienced with creation of Users, Groups, Projects, Workbooks and the appropriate permission sets for Tableau Server and security checks.

●Experienced in creating Filters, quick filters, table calculations, calculated measures and parameters.

●Worked with Live and Extract connection.

●Building, publishing customized interactive reports and dashboards, report scheduling using Tableau server.

●Analyzed the data using statistical features in tableau to develop Trend Analysis reports.

TATA CONSULTANCY SERVICES December 2010 – April 2013

(Database Developer) Pune, India

An Indian multinational information technology (IT) service, consulting company. As global leaders in IT services, digital, and business solutions, TCS partner with clients to simplify, strengthen, and transform their businesses.

Responsibilities

●Understand the customer Requirements and the Technical specification Documents.

●Built data connection to the database using MS SQL Server.

●Experience querying data in T-SQL, writing reports where the data resides in databases including MS SQL Server.

●Developed and modified triggers, packages, functions and stored procedures for data conversions and PL/SQL procedures to create database objects dynamically based on user inputs.

●Wrote SQL, PL/SQL, SQL*Plus programs required to retrieve data using cursors and exception handling.

●Designed logical and physical data models for star and snowflake schemas using Erwin.

●Experience with Data flow diagrams, Data dictionary, Database normalization theory techniques, Entity relation modeling and design techniques.

●Developed Tableau Dashboards with various chart views for Visualization Solutions.

●Developing data model to create reports and dashboards.

●Created Worksheet by using calculations and aggregations.

●Created Filters, Groups, Sets on Tableau Reports.

●Publishing sheets and dashboards on server Using Tableau Desktop.

EDUCATION

PENN STATE UNIVERSITY Pennsylvania

MS, Information Science Dec 2017

GPA: 3.8/4

DIBRUGARH UNIVERSITY, JORHAT ENGINEERING COLLEGE Assam, India

Bachelor of Engineering, Computer Science Jul 2010

GPA: 81.4/100

Contact this candidate