Data Analyst

Gabriel Mesa

New York, NY 917-***-**** *************@*****.***

Fully Work Authorized No Visa Sponsorship Required

PROFESSIONAL SUMMARY

Business Data Analyst certified with 2+ years of experienced in the extraction, transformation and cleaning of data for insights on Tableau and Power BI dashboards. Experienced in Agile-Scrum methodologies, enterprise analysis, data analysis and requirements gathering in the IT sector.

Key Skills

Stakeholder requirements elicitation

Tableau/Power BI

R

Data analysis and reporting

Microsoft Office (Excel, Word and PowerPoint)

mySQL workbench/Snowflake

Data cleaning

ScrapeStorm

Agile Methodologies

PROFESSIONAL EXPERIENCE

Data Analyst (Freelance) 12/2020 – 01/2021

Night Market/Horizon Inc., Remote

Scrapped reviews, prices and sales data from multiple items from vendors like Amazon, Walmart and Target using Scrapestorm.

Executed sql queries, extracted, transformed, loaded and clean e-commerce data within CSV files.

Built multiple Tableau dashboards with views with a scorecard KPI comparison analysis between e-commerce stores.

Performed agile methodologies and business plan with deliverables to keep track on team performance and deadlines.

Built Scores, metrics and rate calculations to measure shopping customer experience performance.

Inserted SQL queries and created databases using Snowflake to analyze insights of amazon sales data

Data Analyst 06/2020 – Present

Talent Path, Los Angeles, CA

Used R, SQL and Power Query to perform data collection and cleaning of datasets or more than 1M records to analyze relations between products and categories for non-profits.

Extracted, Transformed and loaded data to build reports based on FBI crime data and showcased insights using tools like Power BI and Tableau.

Performed excel reports and presented to stakeholders

Created sales performance and real estate dashboards using Power BI

Inserted SQL queries and created databases using Snowflake to analyze insights of amazon sales data

Business Analyst 08/2019 - 06/2020

PGE (Through Cognizant), San Francisco, CA

Collaborated on large-scale project applying Agile methodologies for PG&E through sprint planning, burndown charts and development of epics for prioritization. Decreased team processing time by 25%

Trained and showcased use of systems including CC&B, SAP, Netsearch and Quantum to offshore teams in India of 3-10 staff members to process customers’ personal information

Created and implemented tracking system by elaborating an Excel table, workflow with VISIO and runbook showing process to complete sensitive requests of customer personal data. Improved quality assurance by 30%

Ensured compliance of California Consumer Privacy Act through stakeholder management

Mentored over 50+ associate consultants to land their first consulting IT projects

Jr. Business Analyst 05/2019 - 08/2019

Revature, Washington, DC

Developed business cases and user stories for prioritization using Word and Excel to document and support the easy to understand storytelling dashboards made for stakeholders

Developed and analyzed sales performance reports using SQL and Tableau for a start-up company to provide insights of the main geographical areas for product sales. Cut marketing costs by 25%

Utilized StarUML, VISIO and Balsamiq to create use-case diagrams, process models, and mock-ups to improve usability of application measuring employee performance by adding 3 new features

Elicitated, gathered, and translated business requirements to develop an insurance website through interviews, online surveys and workshops

HR Coordinator 05/2018 - 05/2019

New York Edge, New York, NY

Developed a talent pipeline by soliciting and establishing contact with more than 100+ potential candidates within university campus, professional organizations, events, and job fairs

Wrote and edited job descriptions for more than 20+ jobs, posted jobs to career boards using Monster, Linkedin, Indeed and Glassdoor. Increased applications rate by 30%

Identified and interviewed more than 150+ cross cultural applicants reducing turnover rate by 50% and improving candidates recruitment experience by cutting the amount of steps in the process from 4 interview rounds to 2

Planet Colors, Medellin, Colombia

Family owned company that provides clothing screen-printing and manufacturing services across North and South America

HR Intern 06/2017 - 12/2017

Wrote and edited more than 20 job descriptions. Posted jobs to career boards like Monster and Indeed.

Implemented and standardized interview process based on job description key skills. Reduced hiring time and turnover by 30%

Provided monthly employees performance assessments based on functions

Sales Associate 02/2017 - 05/2017

Supported development activities with the design team for clothing design plans

Collaborated with sales team to ensure wholesales with different clients

EDUCATION

Bachelor of Arts (BA), Organizational Psychology, 2017

Universidad EAFIT, Medellin, Colombia

Ranked in top 5 universities in Colombia

Undergraduate Certificate, Information Tchnology, 2021

University of Virginia, Charlottesville, VA

PROFESSIONAL DEVELOPMENT/AFFILIATIONS

International Institute of Business Analysis (IIBA), Certified Business Analyst (ECBA), 2019

Revature, Business Analyst Bootcamp, Washington, DC, 2019

Six Sigma Yellow Belt, 2019

Scrum Master Certified (SMC), 2019

English Teacher Volunteer, Explorar Kindergarten, Colombia, 2017

Speaker, The National Congress of Psychology of Colombia (ASCOFAPSI), Colombia, 2017

Contact this candidate