John Jensen Email & Phone Number

San Diego, Ca

Greater San Diego Area

People Leader of a team of Business Systems Analysts

Sacramento, California Area

Lead Business Systems Analyst on the CondoSafe product, starting from its initial roll-out in 2014, after being personally recruited for the position.* Performing Ad-Hoc Data Analysis to support and inform the business over a variety of topics, including Market and Client Opportunity Sizing, Operational Performance, Impact Analysis, Vendor Costing, and more.* Created a multitude of recurring Reporting jobs to proactively inform the Business about key metrics* Built, maintained, and enhanced Informatica ETL processes to integrate data with Billing and Accounts Payable systems, as well as Enterprise Data Assets and Research & Development data warehouses.* Provide direction and oversight to team member* Monitor and maintain quality and integrity of the data asset, in concert with business partners* Collaborate with Software Development partners to ensure quality and accuracy of data design and content.* Proficient in SQL (Oracle, Microsoft SQL Server, MySQL), Excel, and Informatica.

Sacramento, California Area

Responsible for creation, maintenance, and automation of ETL processes supporting primarily the Fraud line of CoreLogic Products, ensuring prompt and timely data content.* Designed, developed, implemented, and productionalized a multitude of ETL processes predominantly using Informatica and MySQL, as well as SSIS with Microsoft SQL Server.* Led offshore ETL development team by creating software development requirements, providing architectural guidelines, project managing implementations, created reusable functional testing methodology, performing code reviews, and validating development solution. Integrated solutions into CONTROL-M workload automation software to minimize hands-on operations work.* Subject Matter Expert for a significant number of company data assets. “Go-to” guy for many business segments regarding data inquiries, analysis, and troubleshooting of these assets. Led initiative to convert many data load processes from unsupported architecture to industry-standard architecture, with significant data comparison analysis for re-engineering the new datasets with higher quality data.* Adept at understanding how products use data, recommending best ways to structure data for product consumption and reporting, and converting product and business requirements into database content.* Single Point of Contact for numerous Agile Scrum teams for data enhancements the suite of ETL jobs* Skilled in database query tuning, resolving many production application issues.

Sacramento, California Area

* Quality Assurance lead of other team members’ county data files versions. Trained and mentored other team members, holding them to a high standard of data consumption and conversion.* Published multi-million-record MySQL tables for consumption by company products. Maintained individual MySQL tables of county data produced by the team. Coordinated punctual updates of data refreshes. * Research and document disparate county property information data files for conversion to standard company database.* Write complex scripts in Python to perform data conversions.* Maintain structure and documentation of company’s standard property information database.

Student Assistant in the Large Systems Capacity and Performance Planning unit at the Health and Human Services Data Center* Programming in SAS and using JCL in a mainframe environment – modifying, maintaining, developing and testing complex programs that quantitatively analyze and interpret Large Systems utilization and performance data.* Performing recurring tasks in which batch jobs are run and reports are distributed and stored for customers.* Analyze customer requirements for ad hoc research and reporting.* Support data analysis in response to customer inquires.* Document system procedures. Provide technical guidance to other team members.* Perform trend analysis using Excel.* Attend SAS Users Group, keeping abreast of latest developments.

B.A., Psychology

Associates, Computer Science