Power Bi Data Analyst

Nil Ratan Saha, PH.D.

***** **** *** * +1-206-***-****

Burien, WA 98168 ********.****@*****.***

PROFESSIONAL SUMMARY

Senior data analyst and BI analyst with over 9 years of experience specializing in data analytics, business analysis, data mining, data profiling, data visualization, business metrics, and statistical analysis. Proven track record of successfully overseeing challenging reporting and analytics initiatives for multimillion-dollar companies, enabling data-driven decision-making, and converting challenging data sets into actionable strategies.

EMPLOYMENT

Senior Business Intelligence Analyst, SF FIRE Credit Union 07/2024 to present

Developed dynamic Power BI dashboards, including Monthly and Daily Membership Reports, Data Quality and Database User Permission, and Card Inventory, delivering actionable real-time insights.

Applied DAX to perform advanced data analysis and KPI calculations, while leveraging Power Query and Advanced Editor for data transformation and Power BI for efficient data modeling.

Diagnosed and optimized Power BI reports to enhance performance and user experience in SQL server and Snowflake platform.

Played a significant role in the CRM migration to Salesforce, performing comprehensive data validation and rigorously testing incremental scripts to ensure data integrity.

Provided expertise in data extraction and advanced analytics, and retrieving data from diverse SQL databases to generate insightful ad-hoc reports.

Data manipulation and visualization by different Python libraries (Pandas, NumPy, Scikit learn, Matplotlib, Seaborn, and others)

Prepare Power BI training materials and teach Power BI to other team members.

Senior Business Intelligence Analyst, Seagull Scientific Inc 05/2022 to 06/24

Led the creation of innovative Power BI dashboards (Sales, Marketing, Marketing segmentation, finance teams) to provide real-time sales insights, monitoring marketing campaign effectiveness, and tracking key metrics within HR and technical services.

Utilize the DAX language for performing complex data analysis, constructing interactive visualizations, and extracting meaningful insights from different kinds of data. Additionally, the leverage Power Query for data transformation and Power BI for data modeling.

Crafted Power BI solutions with a focus on enhancing accuracy, performance, and scalability.

Diagnosed and fine-tuned Power BI reports to enhance both performance and user experience.

Provided data-driven recommendations to senior management based on detailed analysis of customer behavior and market trends.

Oversaw the management and debugging of reports on Power BI and Tableau servers, assuming administrative duties for Power BI, Tableau, and SQL servers.

Offered expertise in data extraction and advanced analytics to inform strategic decisions leveraging multiple predictive models. Successfully retrieved data from various SQL databases.

Data Science Consultant, Accenture, USA 11/2018 – 05/2022

Developed dynamic dashboards utilizing Power BI, DAX, and various other Business Intelligence (BI) tools to facilitate comprehensive data analysis.

SQL and Python are applied for extracting, cleansing, manipulating data, and constructing models.

Performed statistical analysis on business data, generating data-driven action plans to inform strategic decision-making processes.

Offered leadership and mentorship to junior team members, fostering their professional growth and development.

Data Engineer, Kogentix Inc. (Acquired by Accenture), USA 08/2017 – 10/2018 (1 year 3 months)

Utilized SQL and Python for data extraction, manipulation, and automated machine learning.

Produced and trained computer vision models for automation and object detection.

Designed and constructed Power BI dashboards for data visualization purposes as part of a proof-of-concept initiative.

Data Analyst, Live Clinic (Consultant), USA 03/2016 – 07/2016 (5 months)

Extracted diverse types of data, analyzed, and visualized.

Prepared ICD10 codes to map with multiple SNOMED codes.

Pursued research and accumulated requirements that helped to integrate new features into the company’s virtual treatment mobile app.

Project Manager Data Analyst (Contractor), Microsoft TCS, USA 07/2015 – 02/2016 (8 months)

Offered data extraction and advanced analytic expertise to influence strategy based on multiple predictive models. Retrieved data from multiple SQL databases.

Developed dynamic reports and maintained regular updates on project status and pipeline progression.

Coordinated internal and external training sessions while overseeing the review of training materials. Analyzed post-training survey data to generate detailed reports with actionable recommendations for enhancing training effectiveness.

Staff Scientist, Benaroya Research Institute, USA 05/2004 – 06/2016 (12 years 1 month)

Independent researcher in the field of Molecular Genetics and Comperative Immunology.

Planned, executed, and monitored multiple research projects and managed team members.

Gathered research data, defined scopes, and wrote grants for external funding.

Statistical analysis of data and published research articles in world-class peer-reviewed journals.

Presented the data in both national and international conferences and symposiums.

EDUCATION

Ph.D., Aquatic Bioscience, University of Tokyo, Japan 04/2001 -03/2004 (3 years)

(Molecular Genetics and Comperative Immunology) GPA 4.0 out of 4.0

M.Sc., Aquatic Bioscience, University of Tokyo, Japan 04/1999 04/2001 (2 years)

(Comperative Molecular Immunology) GPA 4.0 out of 4.0

B.Sc., Marine Biology, Khulna University, Bangladesh 1991 – 1996 (4 years)

GPA 3.89 out of 4.0

PROFESSIONAL CERTIFICATIONS

Project Management Certification, Bellevue College, Bellevue, WA

Database Analyst Certification, Bellevue College, Bellevue, WA

Business Intelligence Analyst Certification, Bellevue College, Bellevue, WA

Python for Data Science, UC San Diego (edX, online)

Specialization with R Certification, Coursera by Duke University

Machine Learning A-Z: Hands-On Python and R in Data Science Certification, Udemy (online)

Tableau Advanced Training: Master Tableau in Data Science, Udemy (Online)

Data Visualization with Tableau Specialization, UC Davis (online)

15 days of Power BI - Complete Microsoft Power BI Bootcamp, Udemy (Online)

Clinical Data Science Specialization, University of Colorado, Coursera (online)

TECHNICAL SKILLS

SQL, T-SQL, MySQL

SSAS, SSRS, SSIS, SSMS

Tableau

Power BI

Power Point

Azure Analysis Services

Power Point

Splunk, XML

Python

Data modeling

Data Cleaning

Statistical analysis

DAX, M

Tabular Editor

Machine Learning

Power Query

Jira/Confluence

Project Management

Azure Databricks

Snowflake

LANGUAGE

English

Bengali (native)

Japanese (speaking)

URLs

LinkedIn: https://www.linkedin.com/in/nil-ratan-saha

Contact this candidate