Data Science Power Bi

PRAVAMAYA DAS

+1-216-***-**** **********@*****.***

Summary

Detail-oriented Power BI Developer with 2+ years of focused experience in creating dynamic dashboards and robust ETL pipelines. Demonstrated ability in data modeling, DAX, and Power Query to transform complex data into actionable insights. Proven track record in optimizing performance and enhancing reporting efficiency using cloud and on-premise tools.

Skills

•Data Science & Analytics: Classification, Regression, Clustering, Hypothesis Testing, Statistical Modelling, Time-series Modeling, Deep Learning, Natural Language Processing, Computer Vision

•Programming & Scripting: Oracle PL/SQL, Python, PySpark, SQL, R

•Machine Learning: Logistics Regression, Naive Bayes, Decision Tree, Random Forest, KNN, Linear Regression, Lasso, Ridge, SVM, Regression Tree, K-means, GBM, LGBM, XGBoost

•Libraries & Tools: Scikit-learn, Keras, TensorFlow, Numpy, Pandas, NLTK, Gensim, Matplotlib, ggplot2

•BI & DW Tools: POWER BI, TABLEAU

•Databases: MySQL, Oracle, MS SQL Server

•Operating Systems: Windows, Linux

•Cloud Services: AWS, Azure

Work Experience

University Hospitals Sep 2022 - Present

Cleveland, Ohio

Data Analyst / Data Engineer

•Developed, designed, and deployed end-to-end business intelligence solutions using Power BI to support strategic decision-making.

•Gathered and analyzed complex business requirements and translated them into scalable, actionable dashboards and reports.

•Utilized DAX and Power Query to design advanced measures, calculated columns, and interactive visuals, translating raw data into meaningful analytics.

•Designed and optimized data models to support advanced analytics and efficient report generation.

•Integrated data from diverse sources, including SQL Server, Excel, to build consolidated reporting solutions.

•Ensured data accuracy, consistency, and integrity across all reporting assets through data validation and QA processes.

•Identified key performance indicators (KPIs), trends, and anomalies to support performance tracking and strategic initiatives.

•Collaborated with cross-functional teams to optimize BI solutions and improve data accessibility and decision support.

•Continuously improved report performance and user experience through iterative design, testing, and feedback incorporation.

•Create, publish, and maintain Power BI reports and dashboards (PBIX files).

•Designed and developed scalable ETL pipelines in Databricks using PySpark to process and transform records daily across multiple sources, ensuring reliable data flows for BI reporting.

•Integrated Databricks with Azure Data Lake and Azure Data Factory for end-to-end data pipeline orchestration and automation to support data aggregation and summarization.

•Created and maintained Delta Lake tables for reliable, versioned data storage supporting analytics and machine learning pipelines.

•Optimized Spark jobs using caching, partitioning, and broadcast joins to enhance performance by 60%.

•Collaborated with cross-functional teams, including data scientists, business analysts, and operations to ensure data accuracy and consistency.

•Conducted data validation and hypothesis testing to ensure data accuracy, reliability, and compliance with research protocols.

•Built and optimized predictive models using Python libraries (NumPy, Pandas, Scikit-learn, XGBoost), and deployed models in Azure for scalable performance in clinical research.

HDFC Bank Nov 2014 - Jan 2021

Branch Banking Operations (Manager)

•Handling customer-centric banking operations through the Flexcube core banking system of Oracle Financial Services.

•Responsible for RTGS, NEFT, Transfers, DD, PO, cash handling, Monitoring and verifying cash transactions and fund transfers done at the branch.

•Regular Cash offload to currency chest. Processing Over Draft Loan against FD & Forex transactions like Travel card loading and off-loading, Foreign currency sell & buy, and outward remittances.

•Monitoring Cash Shortage and Cash excess and parking to the proper GL account and nullifying the GL within TAT.

•Monitoring Branch GL accounts and dummy accounts and clearing them within TAT.

Statistical Analyst

•Developed and validated statistical models to analyze complex datasets, ensuring model accuracy and reliability through rigorous testing and validation processes.

•Applied advanced statistical methods (e.g., logistic regression, linear regression, ANOVA) to derive actionable insights and support data-driven decision-making.

•Built and optimized predictive models using various statistical techniques, including regression models and time-series analysis for forecasting.

•Performed hypothesis testing and confidence interval estimation to validate statistical assumptions and improve model performance.

•Implemented statistical algorithms in Python and R to analyze datasets, applying methods such as principal component analysis (PCA), clustering, and k-means for dimensionality reduction and data segmentation.

•Monitored and evaluated model performance using statistical metrics such as R-squared, mean squared error (MSE), and area under the curve (AUC) to continuously improve accuracy and precision.

•Automated data processing and model-building pipelines to streamline the development and deployment of statistical models, reducing time-to-insight for business applications.

Data Analyst

• Built and deployed predictive models using Python and Tableau

• Visualized complex datasets with Tableau, aiding in the identification of key business trends

• Collaborated with engineering teams to integrate ML models into Tableau dashboards,

• Developed automated reporting solutions in Tableau

• Presented data findings to stakeholders using Tableau, leading to an improvement in strategic decisions.

• Analyzed user data trends and visualized findings in Tableau, contributing to increased user retention.

• We have developed interactive dashboards that allow for real-time monitoring, enhancing operational insights.

• Developed SQL queries to extract data for Tableau reports, improving data retrieval efficiency.

• Provided actionable insights using Tableau visualizations, leading to an improvement in marketing strategies.

ICICI Bank

Deputy Branch Manager

IndusInd Bank

Deputy Manager

Group 4 Facility Services Pvt Ltd

Asst. Manager

Signal and Systems India Pvt Ltd

Engineer

EDUCATION

Case Western Reserve University

MS, Biomedical Engineering with Data Science Specialization

ITM Business School

PGDM, Finance

Fakir Mohan University

BE, Electrical Engineering

Nov 2011 - Nov 2014

May 2008 - Nov 2011

Oct 2003 - Nov 2005

Sep 2001 - Oct 2003

Contact this candidate