Jason Loera Email & Phone Number

Orange County, California Area

Analyze source data and identify/address problems that may impact the mapping process.Develop/adjust Visual Basic (VB) code to transform raw data formats into consumable data.Setup automated download, load processes to extract, transform, and load (ETL) in multiple environments using internal applications tools. Created and used automated scripts to return any unmapped data elements verify data elements were correctly translated.Supported data transfer into multiple databases through multiple ETL processes for assigned data feeds.Monitor various internal dashboards to ensure timely data updates, resolved failed data loads, and stale feeds.Provided a high level of customer service by logging and reporting data issues in JIRA, Communicated with clients, escalating urgent items, and followed up on outstanding issues within the company defined service level agreement (SLA)Create Structured Query Language (SQL) queries for data quality testing and reporting.Interfaced with team lead, project management, account management, developers, DBA, customer support team, and team members as needed for projects and supportDocumented processes, workflows, and trouble issues in Confluence.Adjusted XSLT and XML files for custom implementations, projects, or addressing customer concerns.

Design & Implement MLS Portal, Broker, and Agent websites & custom pages Build Reports from Stored Procedures Provided customer support to several different clients.Identified, troubleshoot, and fixed code bugsSkills Used:HTML/CSS/JavaScript/JQueryTools used:ElementTool, Microsoft TFS, Microft Report Builder

I am part of RED's Technical Support Group. I serve as support and the in between for our clients and development and product teams. My team's main purpose is to resolve client issues and requests without pulling the development team from what they are working on.I am exposed to all sides of the RED platform environment: Desktop Forms & CMA software, website administration and configuration, website design, CRM and application support for clients and agents.Daily activities include:• Assisting agents installing software and fixing issues• Editing web pages and sites via HTML and CSS sometimes Javascript • Editing Flash website intros• Using our ELEMETTOOL ticketing system for dev related projects and bugs• Responding to clients via email, phone, tickets submitted• Report/log call and email notesApplications Used:ClientelMicrosoft Office SuitePhotoshopFlashIllustrator

La Habra, Ca

Los Angeles, Ca

As, Graphic Design

General Education, General Studies

Architecture & Design Academy

Web/Multimedia Management And Webmaster