Ronald Durham Email & Phone Number

Fremont, Ca, Us

Wells Fargo Bank - Chandler, AZ- remote (APEX Consulting) 08/2020 – Business Initiative Consultant – Customer Remediation COE• Preform data analysis to determine which customers have been harmed as a result of an issue with WFB systems or processes.• Determine extent of harm and amount of the cure - using SAS + SQL. • Document the remediation approach in the Analytic Analysis document.• Provide communication to team members and customers thru proper WFB channels.

Fremont, Ca, Us

• Gathered and documented requirements criteria for marketing data scrubs. • PM for TABLEAU development of new recurring scrub lookup. • Managed the development of the lookup tool in Tableau.• Provided testing execution and tracking for unit, QA and UAT.

Chiyoda-Ku, Tokyo, Jp

Senior Business Process Analyst – IBOR-SOFR Transition Project• Preform data analysis to determine exposure – total- 1 year and 3 year• Perform manual analysis using EXCEL pivots to document exposure by organizations globally.• Participate in business review of reports.• Assist Price Waterhouse with data mapping for IQA software implementation.Senior Business Process Specialist – VENA help desk for IFR requests• Review ASKVENA emails and respond with solutions• Address adding users to groups and add groups to users.• Update matrix file needs weekly and monthly.• Attend continuous training to learn VENA and learn VENA system thru KT.

Chiyoda-Ku, Tokyo, Jp

Senior Business Process Analyst – IBOR-SOFR Transition Project• Preform data analysis to determine exposure – total- 1 year and 3 year• Perform manual analysis using EXCEL pivots to document exposure by organizations globally.• Participate in business review of reports.• Assist Price Waterhouse with data mapping for IQA software implementation.Senior Business Process Specialist – VENA help desk for IFR requests• Review ASKVENA emails and respond with solutions• Address adding users to groups and add groups to users.• Update matrix file needs weekly and monthly.• Attend continuous training to learn VENA and learn VENA system thru KT.

Bellevue, Washington, Us

San Francisco, California, Us

• Senior analyst of the SPARC team - monitoring compliance to all information security policies and procedures related to data.• Managed the “sunrise and sunset” of various applications/systems..• Assured proper ownership of several software packages.• Created FSDs and provided insights in team implementation meetings.

Rancho Dominguez, California, Us

• Worked on business improvement and resolution of long standing issues like product substitutions during order fulfilment. It was important to define the “as is” business process flow.• Provided guidance on implementation strategies of new Logistics system (TELOGIS) focused on cost containment and delivery efficiencies.• Supported the implementation of new reports for the Purchasing department to improve vendor ordering practices.• Examined the production fulfillment and delivery process in an effort to improve on time delivery and customer satisfaction. Needed to define the “to be process flow to gain acceptance from the users.• Acted as liaison for existing EDI customers and managed implementation new EDI partners.

El Segundo, Ca, Us

• Primarily worked on the implementation of a new real time inventory control process in the Oracle ERP at the new Ohio Fulfillment Center (warehouse). • Elicited requirements for the new data elements being implemented in the new WMS + Oracle ERP - documented the business rules for the new data elements and directed the business creation of source data to populate the new data elements in the Oracle ERP.• Analyzed tasks required to blend the activities and data from three different warehouses and the two different systems into the Oracle ERP. Resolved issues which arose during the E2E - IT + UAT testing. JIRA test case management tool was used for issue tracking.• Provided coordination on tasks involving the warehouse Ops staff and IC personnel participating in the UAT testing and “go live” implementation. This included implementation of the Daily Product Inventory Analysis reports in BI.Consultant with OS Technical

Glendora, California, Us

• Stayhealthy's mission was to make clinical-quality health measurement devices available to consumer service providers.• Actively elicited requirements for product development projects and documented them by completing the SDLC deliverable documents in the format required.• Performed analysis and provided input for developing the shape of the new product(s) using the existing devices and applications as a guide - included HIPAA records storage.• Used "Enterpriser Architect" to manage use cases, document requirements, provide feature definitions and process flows. This included “as is” and “to be” process flow diagrams.• Provided QA support of interfaces between dashboard system, kiosk and user departments.• Conducted meetings and interviews with the business SMEs to identify current system validations and edits. • Created SQL queries to validate key information with stakeholders to document the current as is process.

Glendale, California, Us

• Prepared and obtained approval (sign off) of business requirements• Provided BRD oversight, architecture integration and approval of the system Design Document• Coordinated and managed the QA process with DEV• Managed UAT process with UK team• Acted as project manager for the project and reported status to upper management• Conducted review and coordination meetings with offshore DEV team in India by phone nightly• Managed approval process and clarifications with the UK team during occasional morning phone callsConsultant with SATWIC

Charlotte, Nc, Us

• Provide technical direction for loan modification system changes• Develop High Level Design (HDL) documents from while working with business partners and technology teams during requirements elicitation.• Provide analysis of production issues by reviewing data in data bases with SQL server.• Work with application developers to write Low Level Design documents.• Answer questions for developers and testers as they arise during implementation.• Mercury Quality center was used to track defects.• Work with business partners during requirements definition to guide appropriate process flows.Consultant with DIversant

Brea, California, Us

• Support the Phoenix insurance system as a systems analyst and SQL developer.• Worked with ETL process for conversion of data into the BI data warehouse.• Elicited requirements for user requests by reviewing the business need and analyzing data.• Agile methodology was used during the Guidewire implementation as the SDLC.• Provide QA support of interface between legacy system and new GuideWire system.• Used MicroStrategy as a reporting tool for data analytics.• Use HP Quality Center to report and manage defects.

El Segundo, Ca, Us

• Provided end-to-end background analysis on supply chain of access cards. • Conducted meetings with key information sources and stakeholders to document the current and as is IVR process.• Led elicitation of requirements for enhancement of the dealer payment system. • Developed process flow and use case diagrams.• Defined changes to impacted finance and accounting interfaces as new BI data mart was developed. • Created the Solution Analysis Specification document after completing data analysis.. Consultant with Fujitsu

Plano, Tx, Us

• Worked in the Data Warehouse - Business Intelligence area as a BSA on a significant database update project, related to credit score “tiering”. Used Informatica as the ETL tool.• The effort included adding several new attributes to both the daily and monthly summary tables. • Provided Use Cases and test scripts to validate calculation requirements from users. • Defined and managed the process to be used to allow follow up on all reported discrepancies. • Defined strategic test scenarios for QA in the master test plan. • This included managing the execution of the project tasks, including the historical data conversion. Consultant with Volt Technical

Charlotte, Nc, Us

• Worked with various levels of the business and developers on the EDGE Loan Origination fulfillment system to provide new and enhanced capabilities in the Loan Origination process. • Wrote Functional and Technical specifications in collaboration with users and developers for .NET/Java based web environment. • Researched Loan Boarding issues on the AS400 and reviewed reports programs (RPG) to resolve problems and debug code.• Used SQL to analyze production problems.• XML was used to communicate between most systems.• Worked with developers, reviewing unit test results, to insure system readiness for QA testing. • Worked defining and documenting the proposed business process flows for the new system. • Reviewed test plans and user acceptance test criteria. • In the UAT area, define the critical components for end-to-end testing and defined the deployment and roll out process

Computer Science

Computer Science

Computer Science

Computer Science