Retired from Bank of America on April 28th, 2017, sold my house in California, and moved to North Central Idaho, in the banana belt, where winters are mild and summers are still much milder than Central California. We now live right on the Clearwater River, with great salmon fishing, on 53 acres that supports plenty of wildlife, including whitetail deer and possible elk. We get up when we feel like it, sit in our sunroom watching the deer, pheasant and eagles in one of our meadows, then finally start our day somewhere around 10am.

Research, analyze and resolve data integrity issues. Design technology solutions for business requirement changes. Analyze and make recommendations for new data to be added to warehouse. Test and analyze data anomalies for major data warehouse enhancement, enhancing data warehouse from Secondary Marketing focus to enterprise focus. Primary support resolving questions and issues from line of business and other applications using the data warehouse. Key member of data design standards committee and primary 'gatekeeper' ensuring column names, definitions, datatypes and location of columns are appropriate and follow the standards.

Supporting a data warehouse for the Secondary Marketing business areas.

Looking for opportunities to exercise my analytical abilities, in either IT or the business areas, at a company local to my new home. My preferred range of locations is within 50 miles of Visalia.

Provide expert, in-depth analysis and presentation of complex data for management and decision support. Provide consultation for application development teams in business architecture activities such as business process modeling and functional design. Perform feasibility studies and impact analysis for proposed projects.Created a business process model crossing several lines of business, resulting in the first complete and accurate model.Facilitated all-day workshops with key business leaders to validate the business process model. Workshop attendees reported that the sessions greatly enhanced their own understanding of the overall business process.Researched and documented poorly understood, complex data flow requirements through multiple systems. As a result, developers were able to design more accurate programs with better functionality.Selected repeatedly for ‘swat team’ activities such as rescuing delayed or troubled projects, gathering and preparing information for lawsuits, providing management or analysis for time-critical events.Managed all aspects of project management for enhancements, vendor system installation, and new in-house developed systems.Repeatedly chosen for 'swat team' activities such as rescuing delayed or troubled projects, gathering and preparing information for class action suite, providing management or analysis for time-critical events.

Gathered and analyzed business requirements and authored project documentation such as project proposals, requirements, and system designs, working closely with business users and technical staff. Analyzed new products and regulatory changes for impact to the business and systems.Analyzed and determined process flow for joint venture feasibility study. With the information provided, the business changed to a more cost effective approach.Implemented automation which eliminated 95% of the manual processes for a high-risk, manually intensive product.Analyzed business requirements, tested and implemented the front end and data for over 150 reports converting from legacy mainframe system to new client server system. In-house clients expressed tremendous satisfaction with both the quality and timeliness of the work.

Led a team of six (6), responsible for the requirements, logical data modeling, physical database design, data definitions, data mapping, and system testing to implement a new multi-million row DB2 decision support data warehouse for loan asset information. Integrated data from several legacy input systems throughout all of the project phases. Analysis and design of a multi-dimensional database and data presentation using a UNIX(AIX) / Novell-LAN based front end application tool (pcExpress/Express Analyzer), which consolidated five separate databases and front-end tools.Worked closely with clients and senior management from several business departments, as well as data analysts, data base administrators, and programmers, to develop the requirements, specifications, and testing scenarios. Business leaders reported excitement to be so involved.Provided management and consultation for vendor-supplied analysts to bridge the gap between their knowledge of the vendor product and our knowledge of the business.Project was on a very tight time schedule and was delivered on-time and within budget, despite many complications related to the vendor product.Created user groups and led presentations to aid clients and programmers in understanding relational databases, as well as various methods of obtaining data from the database. Attendees reported a much higher comfort level and satisfaction with the database.

Responsible for the requirements, analysis, design, develoment, testing and implementation of all maintenance and enhancements to the Secondary Marketing system, including: Required changes for a 3-billion dollar loan sale, new Loan Application inventory tracking system, Conversion to a new Loan Servicing System as a source for data.