Business Analyst Information Systems

Rutvik Merai

*.*****@*****.*******.*** www.linkedin.com/in/rutvik-merai-98015321b +1-216-***-****

CAREER OBJECTIVE

Master’s student in Information Systems at Cleveland State University seeking to join KeyBank’s Enterprise Analyst Program as a Business Analyst. Skilled in data analysis, problem-solving, and business strategy, with experience building analytical dashboards, conducting simulations, and supporting decision-making processes. Passionate about using data-driven insights to support strategy, improve customer experience, and deliver measurable impact. EDUCATION

Cleveland State University, Cleveland, OH Exp Grad: May 2026 Master of Information Systems GPA : 3.61

Gujarat Technological University, Ahmedabad, Gujarat Graduated: July 2021 Bachelor’s degree in Computer Science GPA : 7.76

SKILLS

• Business & Analytical Skills: Business analysis, problem-solving, strategic thinking, process improvement, risk assessment, decision support, workflow optimization

• Data Analytics & Tools: SQL, Excel (advanced formulas, pivot tables, data modeling), Power BI, Tableau, Python (basic), Git, SAP S/4HANA (ERP – pursuing), Agile project tools (Trello, InVision, Scrum basics)

• Communication & Professional Skills: Strong verbal and written communication, professional presentations (PowerPoint), stakeholder engagement, teamwork, adaptability, leadership, resilience

• Research & Reporting: Data validation, KPI development, reporting dashboards, trend identification, forecasting, data visualization, documentation

Relevant Experience

Computer Faculty – CDAC Computer, Surat, India

July 2021 – July 2024

• Taught programming languages and guided students in applying analytical techniques to solve real-world problems.

• Developed lesson plans and assessments, strengthening communication and presentation skills for diverse learners.

• Introduced basic Git usage for version control, encouraging collaboration and workflow optimisation. Viking Safety Ambassador – Cleveland State University Aug 2024 – Present

• Provide front-line support ensuring safety and excellent customer service within the campus community.

• Collaborate with team members to address operational challenges, demonstrating adaptability and problem-solving.

• Manage incident reports and communicate effectively with supervisors and stakeholders. PROJECTS

Senior Design Project Management System Sem 8, 2021

• Project on “Cabme” in which a user can take a car for rent as per his or her convenience and the admin can manage the booking and cars. It is implemented using HTML, CSS, and PHP. To complete the project, we used the: Laravel framework of PHP with the latest stable update.

Bank Loan Report Dashboard Project Spring 2025

• Designed and developed a comprehensive analytical report to monitor loan performance using excel.

• Built 3 interactive dashboards (Summary, Overview, and Details) focused on KPIs such as Total Loan Applications, Funded Amounts, Amount Received, Interest Rate, and Debt-to-Income Ratio.

• Created Good vs Bad Loan performance metrics based on loan status, helping assess portfolio quality.

• Implemented visualizations: Line Charts (monthly trends), Maps (state-wise analysis), Donut and Bar Charts (loan purpose and term), and Tree Maps (home ownership distribution).

• Transformed raw loan data into actionable insights for strategic decision-making in banking operations. Accenture North America Data Analytics and Visualisation Job Simulation on Forage - February 2025

• Completed a simulation focused on advising a hypothetical social media client as a Data Analyst at Accenture.

• Cleaned, modelled and analysed 7 datasets to uncover insights into content trends to inform strategic decisions.

• Prepared a PowerPoint deck and video presentation to communicate key insights for the client and internal stakeholders. CERTIFICATIONS

• Udemy: The Complete SQL Masterclass (2024) – Reinforced advanced SQL querying and database management skills.

• Certificate: https://drive.google.com/file/d/1-CYTWmGNDYuPZPWNW5L9jGp1r6PcZ2qq/view?usp=sharing

Contact this candidate