Rohit B

LinkedIn ad33ut@r.postjobfree.com +1-716-***-****

Professional Summary

Spanning over 3+ years in the domain of Healthcare and Finance as a data and business analyst, coupled with a master's degree in data science, I have honed my skills in data manipulation and analysis. My expertise includes leveraging ETL tools, SQL, Python, Snowflake, Tableau, Power BI, and MS Excel to derive insights and collaborate with stakeholders in crafting and advising on solutions that achieve business objectives while aligning with development strategies. Education

M. Sc in Engineering Science and Data Science University at Buffalo, New York June 2023 Statistical & Probabilistic Analysis, Machine Learning, Predictive Analytics, Quantitative methodologies B. Tech in Computer Science and Engineering Jawaharlal Nehru Technological University, India May 2020 Software Development, Design & Analysis of Algorithm, Data Administration, Data Mining & Data Warehousing Work Experience

Business Analyst II Philips, Georgia Nov 2023 – Present

• Conducted in-depth analysis of Security Monitoring data using SQL, Power BI and Python to identify potential security threats

• Optimized equipment maintenance cost structures, resulting in a 20% cost reduction, by conducting analysis on clinical equipment data by predicting maintenance and cost-benefit analysis

• Liaised with the billing team to enhance healthcare equipment financial transactions for accuracy and efficiency

• Analysed and recommended pricing structures aligning with industry standards and business goals for healthcare services

• Utilized DAX and macros to support data-driven decision-making and enhanced the overall accuracy through data analysis Data Scientist Fifth Third Bank, Ohio Mar 2023 – Nov 2023

• Proficient in predictive and statistical modelling through Machine Learning, constructing financial datasets from diverse sources

• Automated ETL processes across millions of operational data rows using Big Query and SQL, reducing manual workload by 50%

• Utilized Tableau for developing ad-hoc financial reports, data marts, KPIs, and charts, illustrating findings to stakeholders

• Proficient in formal project management methods, including internal documentation and external communications in Confluence

• Designed and maintained SQL queries for data analysis, identifying trends for business analysis

• Applied broad understanding of business principles to excel in cross-functional projects and initiatives Data Analytics Engineer Virtusa, India Dec 2020 – Dec 2021

• Integrated Astra Zeneca clinical data using Talend DI ETL tool to merge complex data from disparate sources

• Gathered clinical datasets from AWS S3 bucket using Athena DB, performed joins, and blended data on Tableau

• Performed data slicing and blending on Tableau and Excel for data cleaning and preprocessing and prepared SQL queries and created views in MySQL for Tableau Dashboards

• Determined business impact level for data quality issues, root cause for data quality errors, and made recommendations for solutions in the ETL process. Also performed risk analysis on product migration

• Collaborated with cross-functional teams to improve data collection and storage processes to understanding business objectives Data Analyst Magna Quest, India Jun 2019 – Dec 2020

• Conducted data preprocessing and feature engineering on dataset extracted from REST APIs for analysing using Python

• Generated reports on using SQL(CTE), Python and Tableau, visualizing model performance and predicting results

• Utilized traditional statistical modelling and machine learning algorithms, including K-Means Clustering

• Imported customer data into Python using Pandas libraries for analysis, identifying patterns that informed key decisions for the billing department and published interactive visualizations, dashboards, reports, and workbooks on Tableau server Technical Skills

Data Preparation: R, Python, Advanced Excel, Azure Data Factory, Data Bricks, Alteryx ETL Tool, Talend DI Libraries: Pandas, NumPy, SciKit-Learn, Keras, Seaborn, Tensorflow and PyTorch Data Visualization: Microsoft Excel, Power BI, Tableau, AWS Quick Sight, Qlik sense Data Science: Statistical Modelling, Linear, Logistic Regression, Clustering, Time series, Probabilistic analysis, A/B Testing Data Management: Teradata, MySQL, PgAdmin, Azure SQL, Snowflake, AWS Redshift Soft Skills: Problem-solving, Analytical skills, Critical thinking, Collaboration, Decision-making, Leadership, Management skills Certifications

• Oracle database SQL certified associate

• Microsoft Azure SQL

• CCA175 -Spark and Hadoop developer

• Coursera NLP, Machine Learning, Deep Learning

Contact this candidate