Business Analyst Los Angeles

Ryan Mehdian

***********@*****.***, 818-***-****, Montrose, CA

LinkedIn: https://www.linkedin.com/in/ryan-mehdian-37045a169/ Github: https://github.com/FLCL4LIFE?tab=repositories EXPERIENCE

TruConnect May 2023-August 2024

Business Analyst Los Angeles, CA

• Led a cross-functional team to develop SQL queries, enabling data-driven business decisions. Increased data reporting efficiency by 30%, resulting in more timely and actionable insights for senior leadership.

• Managed large datasets in Excel, optimizing data manipulation processes and reducing analysis time by 25%, leading to more informed decision-making within the marketing department.

• Collaborated with stakeholders to analyze and refine business requirements, contributing to a 20% improvement in project delivery time and client satisfaction by ensuring alignment with business objectives. 777 Partners May 2022-April 2023

Business Analyst Irvine, CA

• Developed and enhanced software solutions with a focus on efficiency, improving internal process automation and reducing manual intervention by 40%, contributing to cost savings.

• Designed and implemented a backend compensation model that resulted in 100% accuracy in bi-weekly payments across 200+ employees, reducing payroll discrepancies and enhancing operational efficiency.

• Facilitated team collaboration that led to a 35% faster resolution of critical software issues, minimizing downtime, and ensuring consistent delivery of services.

• Guided the software development lifecycle, reducing deployment times by 15% through streamlined processes and clearer requirement documentation.

PROJECTS

Data Modeling

• Directed a team of six to develop and implement a payment system for distributors, streamlining the process and reducing calculation times by weeks, while significantly improving output accuracy.

• Initially designed using a SQL backend, the solution was later upgraded with a Salesforce front-end interface, allowing for seamless payment modifications and improved user accessibility. Full Stack Development:

• Developed and implemented full stack solutions, utilizing both front-end and back-end technologies to create scalable, user-friendly applications. Spearheaded the redesign of a backend compensation model, improving accuracy and efficiency in bi-weekly payments by reducing processing time.

• Collaborated with cross-functional teams throughout the software development lifecycle, implementing key improvements such as streamlined workflows and faster bug resolution, ensuring smooth functionality and continuous product enhancement.

• Directed website testing, identifying, and resolving over 50 critical bugs, which improved website functionality by 15%

EDUCATION

California State Polytechnic University, Pomona June 2021 BS in Computer Information Systems-Business Intelligence Dean’s List Spring 2020 - Spring 2021, President’s List Spring 2020 - Spring 2021 SKILLS

• Data Analytics & Visualization: Data analysis, data cleaning, SQL, Python, R, Excel, Tableau, Power BI, Looker, ETL, A/B testing, big data (Hadoop, Spark)

• Business & Project Management: Business analysis, stakeholder management, project management (Agile, Scrum), KPI tracking, requirements gathering (BRD), documentation, UAT, process improvement, Salesforce, Business Systems Analysis, Sprint Planning, Backlog Management, Collaboration Tools, Agile Methodologies

Contact this candidate