Eric Ochoa Email & Phone Number

New York, NY, US

New York, New York, US

New York, NY, US

- Developed framework for ongoing ingestion of transaction level data from various blockchains to support blockchain reconciliation process after losing legacy data vendor- Manage the blockchain reconciliation process for the finance team by utilizing dbt to create data models to verify the balances of all exchange wallets on various blockchains match that.

Chicago, IL, US

- Created and sustained various data models utilizing dbt in conjunction with a Snowflake database to meet internal stakeholder analytical needs- Maintained daily dbt data warehouse execution via Prefect orchestration tool, focused on optimizing the job through parallelization as well as fine tuning the SQL being used in data models themselves- Developed.

New York, NY, US

• Automate repetitive tasks such as database querying and other data operations for the Client Operations team by creating Python scripts accessible via an internal Flask application or by configuring AWS Lambdas saving.
• Provide last mile customizations for clients both into and out of our products through ETL of datasets containing up to billions of rows by utilizing AWS, Pandas, Hive, and Presto technologies
• Support all production products by analyzing and validating large datasets primarily through Jupyter Notebooks and communicating conclusions with our client facing teams upon request
• Maintain and optimize JIRA instance for our US based teams by creating projects, workflows, screens, fields etc.
• Responsible for bi-weekly sprint planning to prioritize the work to be done, in addition also responsible for assigning tasks to operations team members based on their strengths and bandwidth
• Manage Github repo containing our internal Flask application code by reviewing and releasing pull requests

El Segundo, California, US

• Troubleshot and managed various client-side technical issues daily for some of the biggest online publishers in the world
• Spearheaded the development and growth of publisher facing technical roles in the New York office
• Developed Python scripts for various internal projects, such as outputs of SQL queries from csv inputs and data parsing
• Built framework for monitoring publisher adoption of adstxt initiative through automation of a Python script and SQL queries which uploaded to a Domo dashboard
• Created base structure for integration between Salesforce, Zendesk, Domo, and Delighted applications for publisher operations, eventually used department wide for tracking of KPIs
• Assisted in the modernizing of our API documentation by writing sample Python code and auditing for outdated information

El Segundo, California, US

• Resolved 40+ customer technical issues daily relating to our software via live chat service and ZenDesk ticketing system
• Collaborated with engineering & product teams using JIRA to help isolate software issues in order to improve product
• Created internal troubleshooting guide to help non-support employees understand common issues and their resolutions

Los Angeles, California, US

• Taught 5 physics classes and 1 advisory class resulting in over 120 9th grade students
• Instructed diverse student body including ESL, SDP, and RSP students with differentiated lessons to help scaffold learning
• Logged behavioral and academic information into PowerSchool to assist administration with targeted student interventions

Los Angeles, CA, US

• Presided over weekly general body meetings with 22 member organizations and managed E-Board with 14 members
• Managed $57K budget for event programming during the school year and oversaw all organizational activities
• Averaged $5.98 cost per head for all events with total overall attendance upwards of 9000 for 2014-2015 academic year
• Presented spending and attendance data monthly to undergraduate senate using visualizations to convey clarity

Armonk, New York, NY, US

• Made recurring reports more efficient and systematic through the use of Excel pivot tables and macros
• Created Principal Investigator handbook to highlight roles and responsibilities related to Business Controls
• Assisted Business Controls Team in variety of projects such as fixed asset testing and separation of duty analysis

Culver City, CA, US

• Analyzed key performance metrics for executives by creating visualizations using Excel, Service-Now, and Business Objects
• Facilitated the contract renewal process for consultants by compiling approvals from various managers
• Restructured SharePoint website to optimize efficiency and clarity for future interns in Finance Optimization

Los Angeles, CA, US

• Responded to phone calls and address over 50 in-person inquiries weekly, improving communication skills
• Arranged 40-100 packages from several postal services each day for efficient distribution
• Assisted in installing new fingerprint security system for entire residential building

CN

• Assisted in product testing and comple reports on the quality of the products
• Taught bi-weekly English lessons to group of 12 interested co-workers
• Reviewed official documents to ensure grammar and intent are not lost in translation from Mandarin to English

City Of Industry, CA, US

• Managed bank account of $1500 for organization, and monitored all expenses
• Collaborated with committee to coordinate activities for 250 high school students for Discover Engineering Day
• Attended Regional Leadership Development Conference and presented idea to raise student interest in STEM fields

Bachelor Of Science (Bs), Industrial And Systems Engineering (Information Systems)

Front End Web Development Certification, Computer Software Engineering

Bachelor’S Degree, Industrial Engineering (Study Abroad)