Jon Herrin Email & Phone Number

St. Louis, Mo, Us

Minneapolis, Mn, Us

- Perform research and analysis of production and test data to determine patterns and trends within and across systems. Analyses are also used to assist in building test data subsets that mimic production data volume and associations.- Develop test data management strategies and plans to provide right sized, production like, reusable and secured test data per test data requirements.- Work closely with Business, Development, and Test Partners to deliver test data that meet defined requirements for new and existing IT solutions.- Work as a Liaison between the Environments, Testing, and Development team for test data management.- Work with the Test Engineers to capture and review test data requirements and test data provisioning techniques and plans.- Allocate and manage test data on all platforms using Test Data Management (TDM) tools.- Create and maintain a Test Data Management roadmap, Design & implementation of test data management tools & capabilities in collaboration with Test Data Management Governance.

Minneapolis, Mn, Us

* Working with the AML group to analyze and design ETL functionality for feeding several AML systems from source systems of record. Analysis includes understanding the data models of various upstream systems of record and how those systems transfer data to the corporate data landing zone, determining what corporate landing zone data is required by the AML systems, and what ETL is required between the corporate data landing zone and the AML systems.* For development efforts, use the data analysis knowledge above to document data mapping and ETL changes based on federally mandated AML risk models and end user requirements. These mappings are used as design documents by both the ETL developers and test teams.* Training and mentoring of other data analysts, covering research of data across systems of record, and learning and using the corporate standard processes for updating and maintaining data maps. This training will be the basis for a broader data testing curriculum over the long term.* Also training and mentoring data analysts in tricks and tips for quickly searching data maps and models for specific fields and data required for analysis and design.

Minneapolis, Mn, Us

* Performing data testing within the Enterprise Test Management group for the Anti Money Laundering group. Also managing some large scale validation efforts, such as end-to-end testing for related consent order projects.* Training and mentoring of data testers, in particular working with testers validating as part of the current consent order. This training will be the basis for a broader data testing curriculum over the long term.* Training and mentoring data testers in unix system operations, concentrating on commands and scripting needed to perform analysis and validation.* Long term effort to develop training courses for understanding and performing data testing and performing analysis on data movement and ETL issues.

Minneapolis, Mn, Us

* Performing data mapping for automation projects of loss mitigation and remittance projects. Efforts involve tracing data and business rules across several systems both internal and external to the bank. Additional duties include analyzing and conditioning test data and documentation of business rules.* Developing documentation for Business Elements rules engine functionality. This will be used for business line training and operations.* Long term effort to formally map mortgage data elements and ETL across multiple systems and to map to industry wide standards.

Minneapolis, Mn, Us

As an expansion of Test Lead duties below:* Work in the Enterprise Information Systems Delivery group.* Provide data analysis and design for the (IDW) warehouse, including identifying projects with impacting IDW, and communicating with upstream and downstream business and technical contacts to identify and clarify business requirements.* Provide functional design solutions within IDW, including researching and mapping data and ETL functionality, and communicating with ETL developers and warehouse Data Modelers in order to meet business requirements.* Provide data testing for several data warehouses that receive data from multiple sources and provide data extracts and reporting services. Additionally provide testing for various reporting tools and applications that use warehouse data.* Validate ETL operations across systems and databases using SQL comparisons or manual validation through various differencing utilities.* Provide support and development for Data Warehouse Application Testing, including test planning and test case creation, scheduling testing resources, test data research, and presentation of testing results and statistics.

Minneapolis, Mn, Us

* Work in the Enterprise Information Systems Delivery group.* Provide data testing for several data warehouses that receive data from multiple sources and provide data extracts and reporting services.* Additionally provide testing for various reporting tools and applications that use warehouse data.* Validate ETL operations across systems and databases using SQL comparisons or manual validation through various differencing utilities.* Provide support and development for Data Warehouse Application Testing, including test planning and test case creation, scheduling testing resources, test data research, and presentation of testing results and statistics.* Provide scheduling and training for test team resources.

* Stood up and implemented Rational Quality Manager and Rational Functional Tester for use by one of the development groups that is retooling an existing application. Testing involved both legacy and new components of the system.* Provided guidance and training for SQA and testing concepts in general and Rational Functional Test and Rational Quality Manager specifically.* Provided justification, status and schedules to management for the implementation and roll-out of Rational Quality Management and Functional Tester including demos and samples of Functional Tester code.* Developed automated test cases for one application as a proof of concept for Rational Functional Tester.

St. Louis, Mo, Us

* Working in the Global Systems Delivery - Data Warehouse Authorization group. * Perform planned data quality analysis and ad hoc reporting for both scheduled implementations and non-scheduled requests from various groups across the company.* Provide support and development for Data Warehouse Application Testing, including test case creation, scheduling testing resources, test data research, requesting and managing test data and test files from upstream data processing groups.* Review requirements and design for Data Warehouse and upstream groups as related to Authorization projects. Also coordinate design and delivery of test data across product groups to allow testing of cross group code.* Provide scheduling and training for test team resources in both the US and India.* Improving the test environment in cooperation with the Test Environment management group.* Working on formalization and automation of testing through development of new test tools and test methods. Environments/Applications/Tools – Windows NT/2000/XP/Server2000/Server2003, Microsoft Office, IBM AIX, Oracle, Netezza, HP Quality Center, various in-house and third party editing, management and access tools such as TOAD, PuTTY and Hummingbird Exceed.

Arlington, Va, Us

* Worked in the Integrated Defense Systems Maintenance Information Systems group. * Provided support and development for Application Testing and Configuration Management and Change Management tools used as part of the tool set for development of aircraft maintenance software. * Improved the test environment for Software Development, Product Support and Testing groups through hardware acquisition, test bed standardization, and system virtualization tools. * Worked on formalization and automation of testing for internal and third party aircraft maintenance applications. * Also participated in process working groups for Configuration Management, Problem Reporting, and Quality Management for the development of CMM level 5 processes. Environments/Applications/Tools – Windows NT/2000/XP/Server2000/Server2003, Microsoft Office, VMWare, Rational ClearCase, Rational ClearQuest, Rational Robot, Rational SQA Basic, Visual Basic 6.0/.NET, Perl, Microsoft Visual SourceSafe, WinCVS, Sybase, Oracle, various performance tools.

St. Louis, Mo, Us

* Returned to Monsanto to perform manual and automated testing on applications supporting seed breeding. * Researched, developed, maintained and executed automated and manual test scripts for web based statistical analysis and reporting tools. * Verified reference data in Oracle and SQLServer databases using various SQL query tools and comparison tools. * Worked with the application design team on design decisions, analysis and trouble shooting for new portions of the application. * Acted as 'third line' support, performing data and defect analysis for problems found in the field. * Contributed to the production of user documentation and presented modifications to the Deployment and Support staff.Environments/Applications/Tools - Windows 2000, Microsoft Office, Microsoft VBA, Rational RequisitePro, Rational TestManager, Rational Robot, Rational SQA Basic, TeamShare TeamTrack, Visual Basic 6.0, Perl, Microsoft Visual SourceSafe, WinCVS, Microsoft SQLServer, Oracle including SQL*Plus and PL/SQL, TOAD and MS Query Analyzer.

* Worked on a four person team developing a corporate-wide SQA organization within A.G. Edwards Information Technology group. * Developed questionnaires to assess the current state of Software Quality Assurance practices. * Performed interviews with a selected cross section of employees. Assessed and reported on the state of the organization, based on the employee interviews and examination of current projects. * Developed training materials on the general functions and activities of SQA. * Assisted in selecting candidates for the proposed SQA organization. * Developed mentoring programs for SQA candidates. * Functioned as Rational tool smith for the SQA assessment team.Environments/Applications/Tools - Windows NT 4, Microsoft Office, Microsoft VBA, Rational Unified Process, Rational RequisitePro, Rational TestManager, Rational Robot, Rational SQA Basic, Rational ClearCase.

St. Louis, Mo, Us

* Performed manual and automated testing on various applications supporting seed breeding. * Researched, developed, maintained and executed test scripts for all areas of the application. * Worked as part of an eight-person test team involving large amounts of coordination and information sharing. * Also researched, developed and executed test scripts for support functions for the application including a reference data management tool and a web based statistical analysis and reporting tool. * Verified reference data in Oracle and SQLServer databases using various SQL query tools and comparison tools. * Initiated creation of a test lab to be shared by several development teams.* Acquired, and maintained systems for the test lab, operating as systems manager for the test lab environment.Environments/Applications/Tools - Windows 95, NT 4 and 2000, Microsoft Office, Microsoft VBA, Rational RequisitePro, Rational TestManager, Rational Robot, Rational SQA Basic, TeamShare TeamTrack, Visual Basic 6.0, Perl, Microsoft Visual SourceSafe, WinCVS, Microsoft SQLServer, Oracle including SQL*Plus and PL/SQL, TOAD and MS Query Analyzer.

St Louis, Missouri, Us

* Developed and implemented Quality Assurance processes for the application development and production support groups. * Additionally developed Configuration Management and testing policies, processes and procedures for both groups. * Development tools included the full Rational Corporation tool set, including the Rational Unified Process. * Data systems included Informix, Sybase and Oracle running on NCR MP-RAS, Linux and Windows NT systems. * Tool smith activities included development of utilities to extract, organize and report log file data tracking application patches and installs and further development of issue tracking tools begun at previous jobs.Environments/Applications/Tools - Windows NT 4 and 2000, Microsoft Office, Microsoft VBA, Rational RequisitePro, Rational TestManager, Rational Robot, Rational SQA Basic, Rational ClearQuest, Rational ClearCase, Perl, NCR MP/RAS, Sun/Solaris, Red Hat Linux, Visual Basic 6.0, Microsoft Visual SourceSafe.

Us

Testing and Quality Assurance* Provided technical and administrative support to multiple software development teams for the creation and maintenance of system test plans. * Acted as temporary Testing and Quality Assurance Technical Officer for the development of corporate policies and standards for testing based on SEI CMM standards of practice. * Supported test planning and execution for European Monetary Unit (EMU) and Y2K across five core business applications. * Developed and maintained test data for various systems. Data systems included Sybase, Oracle, and DB2. Also executed tests as required depending on development units needs. * Functioned as Q/A tool smith, development problem tracking and requirements data repositories for overall project use. * Also provided technical assistance with office automation products on an ad hoc basis.Environments/Applications/Tools - Windows NT 3.51 and 4, Microsoft Office, Microsoft VBA, Rational TestManager, Rational Robot, Rational SQA Basic, Segue SilkTest, Visual Basic 5.0, Microsoft Visual SourceSafe, Sybase SQL Anywhere and ISQL, Oracle including SQL*Plus and PL/SQL, TOAD, MVS.

Dublin 2, Ie

* Provided technical and administrative direction to a team of programmers assigned to interface and data conversion development for Air Force systems on the Maintenance Planning and Execution (MP&E) development project. * Team lead for designing data interfaces with other military maintenance systems for an application development cycle. * Focused on data mapping between systems, developing data query solutions within MP&E and proving data service designs utilizing SQLPlus, SQLNavigator and similar querying tools. * Interface design also included development of Unix scripts, C program code and Oracle stored procedures. * Team member and team lead during a previous development cycle for conversion and loading of data from existing Air Force systems into MP&E. * Conversion and loading tools were developed utilizing Unix scripts, C program code and Oracle SQL Loader. * As part of conversion, developed analysis, profiling and reconciliation processes for converted data utilizing Oracle SQLPlus, Microsoft Access, and Datawatch Monarch report extraction tools. * Previously a CMM Q/A team member, focusing on developing and implementing Q/A checks and audits across the software development process. * Functioned as Q/A tool smith, developing problem tracking and requirements data repositories for overall project use utilizing Microsoft Access, Excel and other common office tools. * Also provided technical assistance with office automation products, including Microsoft Office97, on an ad hoc basis.Environments/Applications/Tools - Windows 95, Microsoft Office, Microsoft VBA Mercury XRunner, HP 9000/HP-UX, Sun/Solaris, CMS, Oracle including SQL*Plus and PL/SQL, TOAD.

St. Louis, Missouri, Us

Chancellor'S Certificate, Microcomputing

Bachelor, Interior Architecture