Data Analyst Analysis

Loba Quasem

E: ********@*****.*** C: 650-***-**** Bay Area, CA

Summary

Certified Data Analyst with successful history developing an end-to-end understanding of Data & Analytics. Skilled in delivering clear data analysis and visualization to internal stakeholders, interacting with cross-functional teams, and understanding modern B2B marketing. Proven ability in using business intelligence for operational effectiveness and making recommendations based on data findings. Expertise in SQL queries with Tableau analysis and visualizations. Highly analytical and detailed with documented track record in business health, sales metrics and product success with efficiency in devising plans for business requirements.

Skills

MS Office with Excel & Macros

Jira & Confluence

Growth & Product Marketing

SQL, ERD, ETL

Big Data Analysis with SQL

EMR, Hadoop Hive

SuperGlue

Data Structures, Mining, MDM Data Modeling

Marketing Channel Optimization

Metrics & Dashboarding, Tableau

Data Scaling & Integration with Python

Adobe & Google Analytics

Snowflake, Databricks

Salesforce, Marketo integrations

Experience

TECHNICAL DATA ANALYST 09/2023 to Current

Intuit – Mountain View, CA

• Leveraged data analysis skills to build and optimize sales funnels to identify customer drop-off points and inform data-driven decision making • Building and optimizing complex SQL queries for extracting and transforming large volumes of clickstream data from various sources • Conducted statistical analysis of logged customer events through A/B testing for QBO conversions • Design, develop, and deploy dashboards using Tableau for A/B Testing experiments • Contributed to the launch of new IXP metrics with standardized definitions, improving data consistency and reducing discrepancies across teams • Possessed deep expertise in data sources and origins, ETL processes, and data quality, serving as the primary point of contact for all data-related questions and challenges • Effectively communicate project needs and deliverables with strategic partners in cross-functional teams across Intuit (product development, marketing, engineering)

SENIOR DATA ANALYST 07/2022 to Current

JPMorgan Chase/ First Republic Bank - San Francisco, CA

• Integrating First Republic Bank's data assets into JPMorgan Chase infrastructure, with a focus on data cleansing and validation • Enhanced data quality by creating flattened tables using SQL from Marketo, MDM, Preqin, and Sales databases to achieve accurate and consistent identity resolution .• Built a new Prospect database by gathering data from disparate sources to create one stitched identity for individual prospects

• Built Dashboard connecting Snowflake to Tableau for Salesforce Migration Data Quality Errors and made sure the whole dashboard read like a story • Researched data from key business systems, assessed data quality, mapped requirements to available data, architected data models and data pipelines, and designed end-to-end business intelligence solutions to support the Enterprise Data & Clients Insights team• Run a daily Scrum meeting that monitors and reports project status to identify and mitigate risks and to ensure quality and timely deliverables.

DATA ANALYST 01/2021 to 07/2022

Intuit – Mountain View, CA

• Develop lead generation with market partners for paid media analytics to provide ongoing recommendations to leadership utilizing complex data and strategic assumptions • Create complex (EMR Hadoop Hive) SQL queries and collaborate with campaign managers and product developers to ensure solutions are scalable, repeatable and effective • Built dashboards in Tableau to visualize and identify patterns for the global market and provided recommendations to marketing, design, and finance teams • Worked with stakeholders to get a deep understanding of their requirements, deep dive into KPIs by helping them optimize ROI by channel and see their effect on brand health • Technical coordinator for multiple agencies & Engineering teams for bringing in data for development of my (Python) API scripts which automated media monitoring analytics • Maintain outstanding written and verbal communication skills to effectively tell the story of Marketing data and Staying up-to-date with modern marketing trends

DATA ANALYST 09/2019 to 12/2020

Articus Finance – Berkeley, CA

• Increased ROI by 10% by creating Intelligent ML algorithms to forecast sales prices which enabled strategic decision making on purchases

• Identified areas of opportunity and suggested projects to help increase online acquisitions • Collect demographic and user behavior data to author reports & use statistical models to help support insights • SQL data modeling on data segmentation and create automation to scale current and future processes • Incorporate Google Analytics and other suite of tools to identify new trends and present them in interactive dashboards on Tableau • Taking leads on projects to define the KPIs and produce root cause analysis reports on whether the metric goals were reached or not • Created Attribution model and advised team where to spend advertising dollars

DATA PROJECT MANAGER 11/2018 to 05/2019

Bright Horizons – Boston, MA

• Create optimization for multi-media promotions to provision new strategic insights • Collaborate with business partners across multiple business lines using Agile Project management tools such as Jira to launch projects • Facilitate Agile Ceremonies – daily stand-up, refinement, sprint planning and retrospectives • Lead the team to bring in Salesforce CRM by leveraging data and analytics to optimize the best possible options for the new project • Measure and monitor results of applied recommendations and present adjustments • Serve as a much-needed bridge between the business needs and the technical capabilities of our team

FINANCIAL SERVICES ANALYST 10/2016 to 10/2018

CIBC - Vancouver, Canada

• Query big data with modern distributed SQL engines & Created documentation in Tableau outlining query findings for use by project managers to make accurate decisions about future plans • Analyzed A/B test results with complex SQL queries to measure the metrics and present stats on the outcome • Report insightful data for account opening stage, engagement, usage, fraud and attrition by tracking behavior to provide insights to and recommend course of action • Presented QBR with metrics improving quarter-on-quarter while also being able to determine whether (or not) what was committed the previous quarter was accomplished the following quarter • Identify trends, create leads in the designated ‘visitor click Map’ area in Adobe Analytics and present ad-hoc reports from site overview reports

Education and Training

UC Berkeley - Berkeley, CA Certification

Data Analytics

American InterContinental University - London, UK MBA

International Business Management & Finance

Richmond, The American International University in - London, UK Bachelor of Arts

Business Administration, Marketing & Management

Accomplishments

Drove strategic initiatives throughout the BI lifecycle, resulting in user-centric solutions that significantly improved data accessibility and decision-making capabilities

Recruited by a different team within the same company due to exceptional performance in developing and implementing Tableau dashboards.

Initiated a culture of collaboration that lead the team to target a different segment of clients and achieved a higher conversion rate

Created a supportive environment where everyone feels comfortable contributing

Websites, Portfolios, Profiles

https://www.linkedin.com/in/lobaquasem

https://github.com/lquasem

https://public.tableau.com/profile/loba8789#!/

Contact this candidate