Sean Gallagher Email & Phone Number

Portland, Or, Us

Tigard

Business Analyst for Strategy department. - Work with back end developers to create in depth, thorough reporting - Analyze trends and provide solutions

Beaverton, Oregon

Gather/ articulate and analyze business requirements, generate detailed functional/ technical specifications; devise, maintain and revise SQL Server queries and databases; provide strategic guidance, leadership, testing and SME on inter-departmental projects; lead/ participate in projects to ensure compliance/ maintenance with new state, federal or company guidelines; conduct UAT on all new processes and letters for department; craft and maintain all dept reports since conversion to reduce backlog in corp reporting― Critical in the translation and transfer of data for 500K+ accounts including development of 12+ files, each with several million rows of data for the trial and final conversion events.― Appointed as one of 4 data experts to form part of the ‘SWAT’ team, accountable for our emergency response team to resolve any issues at conversion events.― Restructured entire department processes to operate on the newly implemented system, including mapping requirements and devising new data integrity checks.― Steered department through the company’s 18 month transition between servicing platforms.― Granted special permissions to develop numerous databases outside of Dev processes.

Beaverton, Oregon

Provide subject matter, analytic, testing and data mapping expertise in order to enable a smooth transition to a new loan servicing platform. Evaluate need for current processes and overhaul those still required in new platform. Design, test and implement new processes based on requirements of incoming platform. Design and present customized training classes on core processes in new platform.• Execute and validate proper transition of data for over 500,000 accounts to new platform• Evaluate need for and create custom data fields and accompanying tables for new platform• Perform post data cut balancing for each data field, verifying hundreds of millions of dollars are appropriately allocated on the new platform• Collaborate with fellow departments to optimize data dissemination and assimilation for new processes• Refurbish department processes and create or refurbish any required EUC’s for new processes

Beaverton, Oregon

Created, maintained and revised SQL Server and Access databases. Provided leadership, testing, and subject matter expertise on inter-department projects. Collaborated with other departments and companies in order to plan, execute and troubleshoot processes. Routinely updated SharePoint site based on new state, federal or company guidelines. Performed UAT on all new process and letters for department.• Worked closely with Escrow Administration to provide subject matter and analytics support • Overhauled and automated Escrow Administration processes, providing a significant boost in productivity• Built and maintained new EUC's and processes based on continuously changing rules and regulations

Beaverton, Oregon

Reviewed and maintained accounts per federal, state and company guidelines. Collaborated with other departments to ensure accuracy of tax and insurance data on accounts. Performed high volume processes on accounts.• Improved and corrected existing escrow process job-aids

Beaverton, Oregon

Ensured floor stock was filled in a timely manner. Unloaded trucks and verified proper contents. Ensured various store displays, including cameras, TV's and laptops, were secure and functional. Performed maintenance on store displays, including ordering parts for future and current requirements.• Tasked with security of displayed products, including thousands of dollars worth of laptops, digital cameras and televisions • Tasked with functionality and maintenance of all displays, routinely requiring trouble shooting of technical issues • Managed monthly budget of several hundred dollars, never going over budget