# Raymund Pimentel > OnBase Software Engineer at Berkshire Hathaway Homestate Companies Location: San Francisco Bay Area, United States Profile: https://flows.cv/raymund I am an experienced software engineer focused on the delivery and analysis of data and documents via custom ETL processes, interactive web based applications, and business intelligence visualizations. I have worked with large Fortune 500 corporations as well as small entrepreneurial startups. My strengths include backend data engineering utilizing SQL and PL/SQL in ETL systems along with Electronic Document Management utilizing Hyland OnBase. In addition, I have experience with various Business Intelligence and Analysis tools such as Kibana, OpenText Birt, QlikView, Crystal Reports and have built custom frontend applications utilizing JavaScript and WebComponents. My core capabilities include the ability to learn quickly, proactive problem solving and ownership of projects. TECHNICAL EXPERIENCE: Oracle SQL and PL/SQL Hyland OnBase JavaScript LitElement and WebComponents Actuate Birt 4.6 Elasticsearch/Kibana 6.2.2 Crystal Reports Oracle Developer/Reports Netezza 7.2 ADDITIONAL RELEVANT WORK EXPERIENCE Oracle Corporation Quality Assurance Engineer Developer Technical Analyst Microsoft Webtv Software Test Engineer Yaya Media, Inc. Senior Database Developer & Administrator Rotor Communications Database Development Lead ## Work Experience ### OnBase Software Engineer @ Berkshire Hathaway Homestate Companies - Workers Compensation Division Jan 2025 – Present | Walnut Creek, California, United States ### Software Engineer @ JPMorganChase Jan 2023 – Jan 2025 | San Francisco, California, United States Extraction and transfer of all electronic documents from First Republic Bank (FRB) to JPMC to meet regulatory (FDIC) requirements and continuing business functionality. • Participated in design and utilization of custom application to extract and deliver over 257 million digital documents along with metadata for load into JPMC document repository. • Extensive SQL analysis of OnBase database regarding document metadata and keyword values. • Developed Bash shell script for SFTP transfer of files between FRB and JPMC. ### ECM Solutions Analyst and System Administrator @ First Republic Bank Jan 2021 – Jan 2023 | San Francisco Bay Area Subject matter expert for Statements and Notices of Core Transformation Project • Designed, developed, and managed all aspects of data file transmissions from FIS to Broadridge print vendor for print and online presentment of Deposit and Loan Statements and Notices. • Python script development for data manipulation prior to transmission to third party vendors for printing. • Worked closely with Business Analysts and third party vendors to gather and translate business requirements into technical solutions. Analyzed, designed, developed, implemented and supported the Enterprise Document/Content Management & Classification Systems (OnBase, Monarch, & Ephesoft). • Hyland OnBase development and system administration involving Workflow, Document Import Process, and Document Type/Keyword creation. • Created Unity Workflow Scripts and Windows Services written in C# for preprocessing data. • Development and maintenance of custom integration between OnBase and DocuSign via API calls to retrieve and load envelope data. • In-depth knowledge in analysis, design, prototyping, testing, security, developing/enhancing applications, production support, problem solving, including requirements gathering, estimating effort, documentation, access management, business continuity, and disaster recovery • Investigation and root cause analysis of software and system defects; resolved issues with production systems. ### Senior Software Engineer @ eMeter Corporation Jan 2013 – Jan 2020 | Foster City • Key member of both Data Analytics Engineering team and Front End User Interface development team. • Programed stored procedures in PL/SQL on Oracle 10g/11i for use in custom ETL process. • Utilized Big Data NoSQL storage such as Hadoop, Hive, and Elasticsearch with Kibana 6.2 to develop KPI dashboards for various Analytics apps (Power Quality and Asset Topology Manager). • Incorporated QlikView 11.2 reports into Analytics Equipment Load Management product. • Replaced QlikView reports with Elasticsearch/Kibana (ELK) dashboards in Equipment Load Management product. • Developed Birt 4.6 reports delivered via web server for integration into EnergyIP application that queries Hive and Oracle databases via JDBC connections. • Contributed to data modeling design involving various database technologies (SQL databases and NoSQL databases) to improve data reliability and quality along distributed systems and varied hardware. • Developed NextGen UI utilizing JavaScript and LitElement Web Components in a custom framework. • Utilized Highcharts JS for charts, Leaflet library for maps, and Vis.js library for timeline charts to deliver interactive front end web based applications employing RESTful APIs and JSON request/response. • Collaborate closely with User Experience team and Product Managers to deliver high quality code based on UI spec and within requested timeline. • Tracked bugs and stories via Jira and managed change control using Perforce in an Agile development environment. • Involved with full software development life cycle including Architecture, Unit Testing, and Documentation. • Employed Agile Methodologies with two week scrum along a Continuous Integration/Continuous Deployment (CI/CD) pipeline. ### Senior Database Developer @ EchoStar Corporation Jan 2011 – Jan 2013 • Created and maintained new reports within custom made reporting framework utilizing JAVA, XML, and SQL for Business Analytics. • Responsible for monthly financial reports and reconciliation reports delivered to internal finance department and third party partners. • Automated reports delivered via email utilizing bash shell scripting for marketing team. • Software programming of feature enhancements for custom made reporting framework. • Performed any ad-hoc query requests and data delivery on a timely basis. • Utilized Crystal Reports to develop complex and dynamic reports. ### Senior Database Developer @ Blockbuster Jan 2007 – Jan 2011 | Los Angeles, California, United States • Developed and maintained all PL/SQL procedures, shell scripts, and processes involved in daily ETL batch process for data collection, data integration, and data processing into DataMart. • Optimized and tuned all SQL code and Indexes and utilized hints for Performance Tuning and Performance Analysis. • Created new aggregate tables and procedures to populate tables in Data Warehouse to improve performance. (Acquired by EchoStar in 2011) ### Database Developer @ Movielink Jan 2003 – Jan 2007 | Los Angeles, California, United States • Developed JAVA/ANT application to query database via JDBC and upload various email lists via FTP and XML based API to third party vendor. • Integrated multiple sources of data for electronic file delivery utilizing SQL LOADER, PL/SQL and Secure FTP. • Monitored Oracle database health and planned strategy for Disaster Recovery. (Acquired by Blockbuster in 2007) ## Education ### Bachelor of Arts (B.A.) in Psychology University of California, Berkeley ### High School Diploma El Camino High School ## Contact & Social - LinkedIn: https://linkedin.com/in/raymundpimentel --- Source: https://flows.cv/raymund JSON Resume: https://flows.cv/raymund/resume.json Last updated: 2026-04-11