Data Science Database Engineer

Jonathan R. Nhou

***** ***** ** *** *** Woodland Hills, CA 91367

Mobile: 818-***-**** E-mail: ******@*****.***

Summary

Highly accomplished data leader with over 20 years of progressive experience in architecting, developing, and leading data-centric solutions that drive significant business value. Proven track record of building and managing high-performing data science and engineering teams. Strong foundation as a seasoned Database Engineer, with expertise in data warehousing, data modeling, ETL pipelines, and database optimization. Demonstrated ability to foster a culture of innovation and collaboration to solve complex business problems.

Experience

SVP Enterprise DBA PENNYMAC LLC (Agoura Hills, CA) June 2016 - March 2025 As a data leader promoted from four different data positions ranging from hands-on manager/data architect to product owner and data administration, I lead my team(s) in data strategy, data modeling, data workflow, data processing and data cleansing. Our efforts lead to over $10 millions in operational cost savings and reduction in incident bridge calls.

● Strategically optimized database storage and processing best practices to help save over $5 millions in operation cost on year 1 and $10 million over all.

● Successfully spearheaded development/design and adoption of Capital Market’s Master Data Management (MDM) System.

● Developed strategy to adopt and deploy CI/CD for databases, streamlining deployments and improving data delivery speed and reliability.

● Board committee member to build and define Data Governance.

● Successfully led migration project of AWS EC2 windows 2012/MS SQL 2016 server instance to AWS EC2 Windows 2022/MS SQL 2019.

● Spearheaded the adoption of data virtualization and data masking using Delphix engine, enhancing data security and compliance.

● Led the transformation of the data engineering and analytics teams, fostering a data-driven culture and driving innovation.

● Architected and led the AWS migration from on-premises infrastructure, significantly reducing costs and improving scalability.

● Managed SOX audits and remediation, ensuring data integrity and regulatory compliance.

● Successfully redesigned funding workflow, improving processing time from 1 hour to less than 10 seconds for a set of 1000 loans.

● Optimized SQL performance, achieving over 200% improvement in data read speeds.

● Optimize database underperforming processes

● Successfully redesigned reporting system for accuracy and performance.

● Managed day-to-day operational support for revenue-generating systems. Senior Database Engineer Health Data Vision, Inc (Burbank, CA) 9/1/2014 to 6/2016 I lead our data team to provide accurate claims data from third party vendors/health services. I am part of the sprint planning process and task breakdown of each user story. I have an active role developing and architecting data storage and transformation from raw file to a relational format. I also have an active role to discover and acquire accurate clean ICD9/10, HCC/ICD mappings and HCC RAF scores.

● Work with HDVI engineers to implement best practices and patterns for data.

● Plan/Design/Developed complex data mapping of third party health data.

● Developed data aggregation workflow of third party health data.

● Provide architecture solutions for HDVI corporate SaaS software.

● Provide guidance and mentor other data engineers.

● Perform/implement optimization of SaaS transaction database.

● Build in-memory OLTP prototype of HDVI SaaS analytic.

● Manage data and data requests to improve the accuracy of our data and decisions.

● Optimize SQL performance, providing over 200% data read improvement

● Technology environment: SQL 2008R2/2012/2014, C#.net, Tableau, TFS Sr. Database Engineer CHLA, Contractor (Los Angeles) 5/2014 to 9/1/2014 As a Senior Database Consultant for CHLA, I was responsible for all database modeling, schema, ETL, and BI implementation.

● Data project led for migration from ICD 9 to ICD 10.

● Determine the best BI tool to help hospitals optimize care.

● Design/model physician repository.

● Data governing chair board member for CHLA IT.

● Developed standardized best practice for SQL 2008R2.

● Developed physician matching algorithm using jaro-winkler .net class.

● Technology environment: SQL 2008R2, C#.net, Tableau, TFS. Sr. Database Engineer YP.com, Contractor (Glendale, CA) 11/2013 to 5/2014 As a Senior Database Consultant for YP.com, I support and develop reports and ETL from our data warehousing mart to produce a sales matrix for our sales team.

● Aggregate and report on business impression/click data for executive summary.

● Performed MS SQL optimization.

● Facilitated open discussion on replication vs ETL, provided guidance for optimal usage.

● Developed standardized best practice for SQL 2008

● Technology environment: SQL 2008, C#.net, JIRA, Splunk, Subversion Database Architect XYPRO Technology Corp, Contractor (Simi Valley, CA) 6/2013 to 12/2013

I lead, designed and developed data aggregation/repository systems for XYPRO Compliance Pro software.

● Facilitate product discovery session for corporate proprietary software.

● Lead Technical engineer for product development.

● Major contributor during product development life cycle.

● Technology environment: JAVA, SQL2008R2, HP NonStop SQL/MX, JIRA MySQL Database Contractor Dashbox, Inc. (Santa Monica, CA) 4/2013 to 6/2013 I provided architect/development support to the business music licensing database.

● Lead all MySQL development/architect efforts.

● Document and analyze current MySQL database needs and optimization opportunities.

● Define and create a plan to standard current MySQL implementation.

● Analyzing reporting needs and developing stored procedures to help deliver requirements.

● Technology environment: JavaScript, PHP, MySQL, MS SQL 2008R2 Lead Database Architect Great American Group (Woodland Hills, CA) 10/2009 - 2/2013 I implemented guidelines for engineering workflow and communication. I was responsible for all in-house/outsourced development work. My division is responsible for all day to day reporting systems, and applications (third party/in-house). We develop and manage the company’s online auction application and an asset valuation system (automatically valuation assets based on results searches).

● Slashed payroll/benefits administration cost by designing and implement off-shore strategy

● Stakeholder of implementing all software development and integration.

● Facilitate corporate change management committee.

● Implement policy for database best practices and standards.

● Developed monitoring alerts and nightly SQL optimization.

● Position reports to CFO

● Position is responsible for filling in as a Database Engineer 30% and mid-tier engineer, which includes SSIS, SSRS development and C#.net

● Technology environment: SQL 2008R2, C#.net, jQuery, MVC, TFS Senior Database Engineer Move Inc (Westlake Village, CA) 5/2007 - 10/2009 I was responsible for over 300 million images on move.com, realtor.com, welcomewagon.com and homebuilder.com. I was the subject matter expert for all image processing at Move. As a mentor, I provided guidance to data processing workflow and design.

● Project Lead for aggregation of real estate Foreclosure data to be displayed on Realtor.com.

● Developed CLR for SQL 2005.

● Developed statistical structure for imaging analysis.

● Data model and developed database web application data.

● Converted SQL 2000 database and corresponding objects to SQL 2005.

● Create database schema using ER Studio and Visio.

● Make sure that all database design adheres to corporate best practices and standardization.

● Technology environment: SQL 2000/2005/2008, C#.net, MySQL Senior Programmer Analysts HealthNet (Woodland Hills, CA) 2004 - 2007

● Design and developed flat file/xml converter to accommodate gaps of 3rd party vendor application.

● Integrated 3rd party windows application with corporate IT system.

● Design, develop and deploy .Net web services to aggregate data from Host servers.

● Design, develop and deploy normalization of SQL 2000 database for JSP web front end.

● Developed XSL templates to transform xml format to html for the new HCFA and UB claims form.

Senior Programmer Analysts Aames Financial Corp (Los Angeles, CA) 2002 - 2004 While working at Aames Financial Corp, I developed a lead tracking and credit aggregation system to help Aames increase lead conversion.

● Help increase higher loan leads/funding by speeding up Credit reporting from 30 minutes down to 4 seconds during credit pulling.

● Incorporated financial MISMO specification, C#.net and MS SQL to help provide accurate and efficient credit aggregation from the credit bureau.

● Design database model to hold XML Credit (MISMO).

● Created web services to aggregate MISMO data.

● Create DTS packages to transform/import data from Access to MS SQL. Manager of Data Services Homestore, Inc (Thousand Oaks, CA) 1998 - 2002 The Data Service team was responsible for updating over 5 million listings and 10 million images daily. I lead my team in developing an efficient tracking system to help us identify all trouble spots within our workflow and reduce licensing fees by $1.2 million.

● Project Manager to consolidate data storage.

● Project Manager to upgrade internal servers from WINNT4.0/SQL6.5 to WIN2K/SQL2K.

● Developed internal operating policies and procedures and ensured they are well documented.

● Directly responsible for maintaining over 850 missions critical data feeds from external partners.

● Directly responsible for all data/image downloads and processes from separate vendors.

● Directly responsible for developing standardized procedures for Maintenance Programmers.

● Directly responsible for providing accurate high quality data to realtor.com EDUCATION

California State Polytechnic University, Pomona, CA Bachelor of Science in Mathematics

Technical Skills

AWS migration Vendor Application integration Code Repository Strategic Planning Vendor Management Database Management Software Development Database Architect Data Modeling MS SQL Off-Shore Management Product Development

Product Management C#.NET IT Budgeting/Planning

Contact this candidate