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.•Documented operators and hooks on Confluence, mapped DFDs of databases and collaborated on sprints using Jira.

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. •Designed a data workflow to streamline web app data into visuals for internal and client facing use.•Automated client service processes using app script saving 10 hours of rigorous work a week.•Automated data pipeline extracting data from various structured and unstructured sources to report on brand-lift across all social partners for the client reducing labor by ~40 hours per quarter•Managed technical specifications and created a gcloud serverless function to process data into BigQuery for team access.•Automated a centralized learning library database for knowledge sharing on projects across North America Analytics to reduce redundant labor and improve on best practices across research projects.

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.•Fostered an environment that cares about Safety and Quality.•Coached a charter team through ideation stages to rearrange a safer and optimal space in the warehouse and reduce bottleneck to booster productivity.•Skillfully handled personal issues in order to maintain team-work, positive outlook and stability on the floor.•Successfully merged receiving and shipping team and trained a coordinator to report to a warehouse lead.•Surveyed tedious labor required on special mirror packing and reduced labor by 20 minutes per mirror.

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