Rahul Surve

ad4g34@r.postjobfree.com 551-***-**** www.linkedin.com/in/rsurve

EDUCATION

Stevens Institute of Technology Hoboken, USA

Master of Science, Business Intelligence and Analytics August 2021 – May 2023 Honours: Beta Gamma Sigma, Provost Masters Fellowship GPA: 3.97 Relevant Courses: Data Integration, Supply Chain Analytics, Data Mining, Marketing Analytics, Machine Learning and AI Technologies, Financial Accounting, Social Network Analytics, Information Management Ramrao Adik Institute of Technology (RAIT), University of Mumbai Mumbai, India Bachelor of Engineering, Electronics August 2017 – June 2021 SKILLS

• Programming Languages: SQL, Python (Pandas, Numpy, Sklearn, Matplotlib, Seaborn, PySpark), R

• Softwares: Epic, Cerner, Dataiku, Microsoft Excel (Index-Match, Lookups, Pivot Table, Macros), Tableau, Microsoft Power BI, Alteryx, Erwin, Oracle, Jira, Confluence, Visio, SharePoint, Microsoft Office, SAS, SAP

• Strengths: Data Analytics, Trend Analysis, Data Visualization, Data Cleaning, Mathematics

• Certifications: Epic Advanced Reporting, Dataiku Core Designer, Python Programming by Microsoft Technology Associate, Data Science and Visualization Foundations Specialization by IBM WORK EXPERIENCE

RWJBarnabas Health Newark, NJ

Data Analyst June 2023 – Present

• Programmed VBA macros in Microsoft Excel to automate creation of hospital dashboard, providing real time overview of bed utilization and reducing existing computation time by 90%

• Calculated scope of improvement of 250 MDs across 500 diagnoses related groups on EPIC Cogito Analytics by utilizing Key Performance Indicators (KPI) to increase operational efficiency and resource optimization

• Developed staffing dashboard in Tableau for 200 departments, comprising of 3000 employees, streamlining human resource allocation and leading to 10% reduction in total working hours

• Analyzed 3 months of electronic medical records on Cerner database using SQL to identify patterns linked to extended patient stays and generated actionable recommendations through literature review and benchmarking analysis

• Facilitated seamless migration from Cerner to EPIC systems, focusing on ensuring data quality and addressing data management challenges taking into account data compliance policies

• Performed ad hoc analysis on EPIC to address evolving challenges within organization Johnson & Johnson Titusville, NJ

Data Analyst Intern May 2022 – August 2022

• Trained an agile and scalable ETL pipeline utilizing Python and PySpark in Dataiku, resulting in 40% reduction in data processing time for Commercial Excellence team's analytical initiatives

• Proposed and collaborated on business rules with market research team to categorize 60k Health Care Professionals (HCP) depending upon prescribing habits and potential sales revenue based on 1200 attributes across 4 datasets

• Led a team of 3 members to track HCP movement across stages over time and created opportunity group hypothesis for implementing precision marketing to maximize sales Stevens Institute of Technology Hoboken, NJ

Teaching Assistant August 2021 – December 2022

• Coached undergraduate students of technology and business majors to use analytical and visualization tools of Microsoft Excel and Tableau

• Collaborated with 4 Teaching Assistants to develop a comprehensive curriculum for 220 students to incorporate knowledge of these tools

• Evaluated student performance through hands-on assignments and provided feedback by verbal and written communication to improve class participation ACADEMIC PROJECTS

Stevens Institute of Technology Hoboken, NJ

Glassdoor Analytics November 2022

• Extracted data regarding 2000+ job listings from Glassdoor website using Beautiful Soup

• Predicted salaries with 90% accuracy across different states based on user inputs by leveraging Random Forest, Linear Regression, Lasso Regression and Ensemble Modeling

Contact this candidate