Assistant Manager Business Analyst

Mitali Roy

******.****@*****.*** +1-501-***-**** LinkedIn: Mitali Roy

Professional Summary

Aspiring Business Analyst with a strong foundation in data visualization, process optimization, and stakeholder management. Experienced in business analysis, reporting, and workflow streamlining with proficiency in SQL, Power BI, Tableau, and Excel. Skilled at translating business needs into technical requirements and optimizing operations to enhance decision-making. Seeking a Business Analyst role to leverage analytical and problem-solving skills in a dynamic environment.

Skills & Expertise

Business Analysis & Reporting: Data visualization using Power BI, Tableau, SQL, and Excel.

Process Optimization: Experience in improving banking operations and workflow efficiency.

Stakeholder Engagement: Collaborated with cross-functional teams to gather requirements and enhance service delivery.

Agile & Documentation: Proficient in Use Case Diagrams, UML, ER Diagrams, Process Flowcharts, and Wireframing (Figma).

Regulatory Compliance: Experience with AML/KYC policies in the banking sector.

Professional Experience

First Security Bank, Little Rock, AR, USA

Retail Banker 2021 – 2022

Managed customer accounts, ensured compliance, and maintained service standards.

Built a robust client communication framework, ensuring transparency and trust, which led to a stronger client-bank relationship.

Strengthened compliance by adhering to Anti-Money-Laundering (AML) and Know Your Customer (KYC) protocols.

Union Bank of India, Hyderabad, India

Assistant Manager 2012 – 2018

Led data-driven process optimizations, reducing operational bottlenecks by 20%.

Developed reports in Excel & SQL for transaction analysis, aiding risk assessment strategies

Acted as a liaison between teams to streamline banking operations and customer interactions.

Served as the escalation contact for operational issues, reinforcing team trust.

Academic Project Experience

Capstone Project: ABC Pantry Enhancement:

Developed Tableau reports and Figma wireframes to improve engagement and sales.

Established documentation and generated flow charts, focusing on designing a structured implementation plan based on clear requirements for the ABC Pantry section.

Built Tableau templates to facilitate management reporting on total sales, category performance, and geographic insights, facilitating data-driven decisions that strengthened customer engagement and sales strategies across multiple zones.

Created wireframes using Figma to support user-friendly navigation and accessibility, displaying key products in logically organized categories to meet household consumption needs and improve customer engagement.

Integrated non-intrusive advertising placements, special offers, and a versatile shopping cart that accommodates both essential and non-essential products, effectively driving repeat sales and boosting revenue.

CBAP: Hospital Management System for Mayo Clinic:

Compiled stakeholder list with roles and responsibilities.

Developed system workflow to outline key processes and user interactions.

Documented in-scope and out-of-scope features using Use Case Diagram (UML) to set clear boundaries.

Defined functional requirements for system features to guide design and development.

Created ER and dataflow diagrams to map data structure and information flow.

Mapped patient admission process with a flowchart using Microsoft Visio.

Designed wireframes and mock screens in Figma for UI/UX representation.

Tableau: Comparison of Region based on Sales:

Designed a tableau dashboard to analyze and compare sales performance across different regions of an organization to make necessary improvements.

Excel: Predicting restaurant tips using Predictive Analytics on Excel:

Built Predictive model using Linear Regression model to calculate Actual and Predicted Tip values of a restaurant. Performed data cleaning, calculated RMSE and basic arithmetic functions.

Power BI: Data Manipulation and Reporting with Power BI:

Constructed a consolidated and interactive Power BI report to assess business performance of a restaurant aggregation and meal delivery service provider.

Education

Master of Business Administration in Finance

Heritage Institute of Technology, India (2009-2011)

Bachelor of Commerce in Accounting & Finance

Calcutta University, India (2005-2008)

Certifications

Post Graduate Program in Business Analysis

Purdue University, online (2024)

PG BA Certification in

Microsoft Excel, SQL, Power BI, Tableau, Agile Scrum Master

Design Leadership, Digital Thinking, AI Automation & Emerging Technology

Technical & Soft Skills

Tools: SQL, Power BI, Tableau, Microsoft Excel, Salesforce, Figma, Visio

Soft Skills: Stakeholder Communication, Problem-Solving, Critical Thinking, Time Management, Collaboration

Contact this candidate