Jorge Torres Perez Email & Phone Number

San Francisco, California, US

Brooklyn, New York, US

• Developed custom Airflow operator to transfer data from Postgres to S3 utilizing airflow.
• Documented and updated 3 dags that streamline data into snowflake.
• Managed routine data transfers from snowflake into DOMO for visualization.
• Redesigned a YouTube API airflow hook for team use to extract dimension tables.
• Collaberated in migrating code from EC2 to ECS utilizing container code practices.
• Restructured Salesforce data warehouse using a snowflake schema for easier ad-hoc analysis for the Analytics team.

San Francisco, CA, US

• Designed and automated a scalable ETL process for spend data across campaigns on Airflow.
• Managed sparsed data sources by creating and streaming a single source of truth into a data studio dashboard to provide insight to stakeholders.
• Modeled and created normalized central database for social partners to reduce data redundancy using BigQuery and Airflow.
• Documented procedures, data flow diagrams and data dictionaries for accessing the centralized databases and querying data sets.
• Project management and designed a data ecosytem in collaboration with client services to collect, structure data and communicate metrics in a dashboard for both client and internal use.
• Rapid prototyped a full functional web app hosted on g-cloud that rolled out for global internal and client facing use utilizing Python Flask, Html/CSS, JS/jQuery and CloudSQL for the database connection.

San Francisco, CA, US

• Lead media performance reporting initiatives across multiple seasonal campaigns.
• Collaborated with internal planning teams in matters of campaign measurement and optimization.
• Created, maintained and automated g-sheet, excel and data studio dashboards.
• Used python to scrape and clean Nielson data for a market-mix modeling project.
• Leveraged data from DV360, 1st party data, MOAT and AdWords to provide campaign data insights to NBCE.

North Hollywood, California, US

• Supervised and coordinated work for 21 direct reports.
• Cultivated direct report engagement by initiating one on one meetings, department surveys and department meetings for increased communication.
• Implemented rotational training program to refocus warehouse on cross-functionality.
• Updated and redesigned a professional develop checklist program for every direct report and fostered transparency with warehouse growth requirements.
• Documented 10 standard operating procedures for warehouse functions.
• Created timecards and analyzed individual efficiency to establish metrics and achievable goals.

North Hollywood, California, US

• Managed 3 different territories (Southern, Northeastern and Western) with different pricing strategies to increase market share.
• Collected, cleaned and analyze data for VP of International Sales on various SKU pricing variations for International sales strategy.
• On boarded three field analyst and updated training documentation for holistic training overview.
• Overhauled automate tools to increase efficiency on tedious excel reports.
• Conducted field visits to better understand customer demands and overall industry market in the Southern U.S Territory.

Los Angeles, California, US

• Coordinated and managed the first expansion program at Pomona in collaboration with Bright Prospect.
• Successfully fundraised $4,350 and sold out on merchandise over a three hour period during a six hour event.
• Coached 8 groups in market discovery-methods for data collection over 4 weeks to deliver data-driven apps.
• Researched, rapid prototyped and tested a 40-page curriculum aimed at mentoring teachers in design thinking for in class use.

Los Angeles, CA, US

• Organized an HTML5/CSS3 introduction tutorial for those interested in Web Applications.
• Aided in debugging Occidental's media wall to ensure no visual or systematic glitches on the media platform.
• Fostered a digital media approach to social justice in a selfie project that involved 50 incoming first- years.

Seattle, WA, US

• Collaborated on solving modern problems of growing companies at Essence Digital.
• Analyzed qualitative and quantitative data from customer discovery research to centralize insights.
• Assessed Design thinking methods, rapid prototyping and personal effectiveness to provide solutions.
• Presented insights and solutions to executives at Essence.

Madrid, Comunidad De Madrid, ES

• Employed search engine optimization marketing with Adword to boost presence online.
• Published 15+ listings options to appeal to all sorts of potential and diverse buyers.
• Applied Google map tools to customize territorial marketing strategies for different neighborhoods.
• Edited and uploaded 13 iMovie videos for advertising purposes.

Los Angeles, CA, US

• Collaborated with the Title IX office translating documents from English to Spanish.
• Translated 3 pamphlets and 1 power point with legal information pertaining to sexual assault/misconduct.
• Researched sexual assault terminology from Spanish speaking countries for accuracy.
• Bolstered marketing material to be assessable to non-English speakers.

Los Angeles, CA, US

• Oversaw 49 incoming first year students from diverse backgrounds and fostered a community for discussions with regards to diversity.
• Programmed events and facilitated 16 presentations to enhance classroom material on subjects of diversity and communal learning.
• Mediated conversations between professors and students.

Bachelor Of Arts, Mathematics & Spanish

Data Streaming

Intro To Machine Learning Tensorflow

Data Engineering Nanodegree, Data Modeling/Warehousing And Database Administration

Spanish Language And Literature