Raymond Fratus Email & Phone Number

Ventura, Ca, Us

Remote

Ventura, California, United States

As an employee, contracted out, I performed the following duties for my client:▪ Collected, analyzed, and processed digital and physical documentation about a Well’s construction and/or abandonment, logged procedures, pressure test, and maintenance records that were gathered from the client's internal databases, various regulatory websites, and Oil & Gas field locations. They were then cataloged/organized according to the client’s specifications.▪ Collected Well documentation was renamed according to the client's specified naming conventions and metadata was then applied to each record when stored in their database.▪ Project accuracy is maintained by updating individual Well project checklists, milestone spreadsheets, and databases to track the progress of each Well project.

Remote

🏠 As a Data Mapping Consultant, I converted legacy real estate data source mappings fromMicrosoft Visual Studio SSIS packages over to a proprietary real estate data mapping tool inpreparation for scripted mass migration into the AWS Cloud data pipeline with a new datamapping tool.🏠 Analyzed over 1,000+ unique legacy data dictionary fields and created translations to the National Associations of Realtors RESO data dictionary fields in preparation for an AWS cloud migration and creation of a new mapping tool and RESO Web API.

Westlake Village, Ca

🏠Created end-to-end implementations for 1000+ external data providers using proprietary and Pentaho ETL to transform highly complex real estate data into normalized datasets in a cloud-based data pipeline. 🏠 Analyzed and mapped 330K+ unique attributes from 40K+ unique fields from highly volatile data sets and transformed it into a standardized data dictionary to power Realtor.com’s core listing experience. 🏠 Implemented complex, multi-layer business rules using Pentaho ETL (Spoon) to transform and enhance real-estate listings, agent/office rosters, open houses, and building information. 🏠 Managed daily Qualtrics consumer feedback from web and mobile app users to identify opportunities to improve customer satisfaction & loyalty through improved data representation. 🏠 Participated in interviewing, hiring, and on-boarding of new team members. 🏠 Planned and created a comprehensive training program which included presentations, recorded videos, and one on one coaching. Coordinated training activities with team members. 🏠 Monitored and maintained operational efficiency of data & image collection & processing systems using AWS services, Splunk reports, dashboards, SQL, and reviewing various logs. 🏠 Leveraged a variety of tools including MS-SQL, MySQL, Splunk, Tableau, and Postman to research and resolve processing errors by performing root cause analysis, testing, and well vetted production releases. 🏠 Coordinated and communicated with internal & external teams including Engineering, Customer Support, Industry Relations, and Product Management to identify data opportunities.

Westlake Village, Ca

🏠 Managed multiple queued data processing systems and SQL databases simultaneously. 🏠 Maintained data & image aggregation to ensure that data providers were updated every 15 minutes. 🏠 Created technical documents, communications. 🏠 Provided technical support to externally and internally. 🏠 Created and updated data source system configurations for various forms of data collection and transmittance for data providers which include APIs, DMQL, FTP, HTTP, RETS, SQL, TCP/IP, Web service, and other internet protocols. 🏠 Troubleshooting and Problem-solving various data processing errors and issues in real-time to maintain Service Level Agreements (SLA).

Westlake Village, Ca

🏠 Primary liaison between Realtor.com and various third parties including hundreds of Multiple Listing Services. 🏠 Ensured account data and visuals were updated consistently on Realtor.com and affiliate websites for assigned states. 🏠 Provided technical support to externally and internally. 🏠 Coordinated and communicated with internal & external teams to onboard data providers and support existing data providers. 🏠 Used company call tracking system to log issues and interactions.

Westlake Village, Ca

🏠 Bill collector for overdue accounts. 🏠 Provided technical support to the sales team. 🏠 Use of company database to track and log calls with Real Estate Agents and Offices. 🏠 Assisted billing and product concerns for customers. 🏠 Maintain communication between Customers, Multiple listing services, sales team, Web operations, and Internal Systems department. 🏠 Use of a department phone queue system.