Data Analyst Business

RACHELLE ROBINSON

Business Data Analyst ***********@*****.*** NY LinkedIn

SUMMARY

A business data analyst with experience working with Excel, SQL, and data visualization. My portfolio features over eight projects focused on datasets, statistical analysis and learning algorithms which showcases my in-depth knowledge of SQL. My experience working in fast-paced environments has shaped me into a communicative, quick-learning, and inquisitive team player who’s always eager for opportunities to learn and grow. With my leadership and collaborative skills I am eager to leverage previous experiences to enhance and optimize analytical processes for data-driven decision-making

SKILLS

Advanced Spreadsheets SQL Python Data Visualization (Tableau) Power BI Project Management Microsoft Suite TECH PROJECTS

NYC AirBnb 11/2024

A project in Google Sheets to analyze rental properties data and communicate findings in a way that executives can understand easily.

● Built a conversion funnel by creating pivot tables that revealed the top earned listings and revenues earned. This showed the conversion rate between stages.

● Preprocessed data by cleaning, using filters, pivot tables, and v-lookups to prepare it for analysis.

● Calculated customer retention rates and communicated results using an executive summary sheet that had information organized in a clear and concise manner. This would help business executives understand which properties are highly demanded with clear and concise detail. SQL Project 12/2024

A case study analyzing the Zuber Database to find the customer preferences and the impact of external factors on rides.

● Analyze data from competitors and test hypothesis about the impact of weather on ride frequency

● Determine if and how the duration of rides from the Loop to O'Hare International Airport changes on rainy Saturdays compared to other days of the week and other weather conditions. Data Visualization with Tableau 02/2025

Project analysis of Zomato Restaurants where we analyzed information of the most popular and highest earning restaurants which included a dashboard displaying findings

● Conducted a general analysis of Zomato’s Restaurant data that showed the most visited restaurants and city, most ordered cuisines by creating scatterplots, bar charts, and map visualizations.

● Developed an interactive dashboard and a Tableau Story that an executive could use to learn about findings. This would allow executives to change parameters in an interactive way to test different situations. EXPERIENCE

Metropolitan Transportation Authority Project Manager 03/2019 - Present New York Transportation firm that provides subway services within the tristate area

● Conduct in-depth data analysis to optimize business operations and improve financial performance.

● Manage budgets and expenditures for 25-30 construction projects, including a $200M capital project, ensuring financial compliance and adherence to contractual obligations.

● Provide insights on operational efficiency by analyzing large datasets and presenting findings to senior management.

● Schedule and facilitate project kickoff and progress meetings, preparing meeting notes and status updates. Reconcile invoices, monitor project payments, and manage timecard/job charge allocations.

● Track project progress against budgets and schedules, identifying risks and resolving project issues EDUCATION

TripleTen Business Intelligence Analysis 02/25 Main topics covered: Advanced Spreadsheets, SQL, Cohort Analysis, Data Visualization. Included 6 applied projects. Keller School Of Management MBA in Management 2014 Major in Management

Technical Institute of America, New York, NY 2018 Certificate in Comptia A+ And Network ++

Contact this candidate