Brian Blackburn Email & Phone Number

Corvallis, Oregon, United States

Portland, Oregon, United States

Work in conjunction with multiple teams to develop and support organization-wide reporting. Assist with development of business and functional requirements for reports.Responsibilities consist of:· Design, develop, test and implement reports as necessary to fulfill business requirements.· Serve as a subject matter expert for reporting across the organization and assist users with reporting and analysis activities and tools, including ad-hoc reporting.· Support user training, testing, documentation, and roll-out of reports and end-user reporting tools.· Construct reusable reports based on common reporting requests using available tools.· Contribute and develop insights into leveraging collected data to improve operational performance and customer experience.· Assist in the evaluation and implementation of data integration between operational processes, as necessary.· Document sources of reports and steps necessary to generate complex reports.· Utilize business intelligence tools to design, construct, test, and deploy self-service reports and visualizations.· Provide support as required to ensure the availability and performance of developed reports and dashboards.· Provide technical assistance and cross training to other team members.· Knowledge of SQL including creating view, tables and stored procedures for reporting purposes.· Knowledge of SQL SSRS reporting design and structure.· Experience translating business questions / requirements into meaningful reports.· Ability to communicate effectively, both orally and in writing, with all levels of staff and outside vendors.· Ability to listen to end users’ needs and provide innovative and proficient reporting solutions· Ability to work with frequent interruptions and changes in priorities.

Beaverton, Oregon, United States

Assisted in developing SQL scripts. Built SQL SSRS reports, BI dashboards and a majority of the benefit plans and policies for the organization, while contributing to other projects within the IT department.• Built 8 dashboards for the National Advisory Team (NAT). The dashboards allowed NAT to be able to track the most current data with automated updates.• Built multiple automated SQL Server Reporting Service (SSRS) reports for the Marketing and Sales department, for the purpose of keeping track of Provider recruiting.• Built all of the organizations Benefit Plans and Policies, used by the Claims department.• Evaluated proposed workload and flow to ensure production effectiveness and run times were optimal.• Diagnosed and assessed new/unique error messages as they were presented to me. If programming was necessary, I would develop a solution plan, taking into account the impact of all possible changes. • I tracked and reported issues, assessing the severity for escalation to my SQL developer.• Developed project schedules, resolving any conflicts during the development and testing phases. I also scheduled work, with an eye to adjusting the schedule, when needed. I would work with and keep the client updated of any changes.• I did technical documentation of any system I designed or maintained.• I built databases to store and access datasets. I would assess software program compatibility, identify conflict issues and develop solutions.• I worked primarily by myself, keeping my team and director informed of my status and progress, as well as any issues that needed to be escalated or would affect a deadline.• I worked multiple projects simultaneously, keeping track of my progress to ensure all deadlines were met, using organizational best practices.• I have developed strong partnerships and relationships with my teams, coworkers, clients and management. I enjoy working as a team member, and am also comfortable working independently.

Lake Oswego, Oregon, United States

Conducted intake interviews with business and development teams for the purpose of onboarding new projects and funding approval of application support. I did this while maintaining the stability of healthcare applications in multiple regions and facility sites. • Developed use case with Unified Modeling Language (UML) for new product functionality.• Designed new workflow processes and updated Standing Operating Procedures (SOPs) to reflect the changes.• Conducted intake interviews with business partners and application teams to collect data for onboarding requests that require funding for annual support; assisted with creating the estimates and seeing them through the approval process to meet the deadline for their go-live date.• Prioritized outstanding defects and system problems, ensuring accuracy and deadlines were met.• Interfaced with business users to prepare and update Business Process Requirements (BPR) and Software System Requirements (SSR). Created test cases and test scripts.• I would keep all clients and appropriate stakeholders updated on the status of all projects I was working on.• I did technical documentation of any system I designed or maintained.• Maintained Vendor software, working directly with the Vendor to resolve conflicts within the system.• Kept abreast of new applications, techniques and skill sets, as well as using best practices and technology solutions. • I worked in a Systems/Business Analytic Team keeping my team members and director informed of my status and progress, as well as any issues that needed to be escalated or affect a deadline.• I handled multiple projects simultaneously, keeping track of my progress to ensure all deadline were met on time, using organizational best practices.• I have developed strong partnerships and relationships with my teams, coworkers, ancillary staff, clients and management.

Lake Oswego, Oregon, United States

Created a database schema map in preparation to export archived data from the existing incident database in Lotus Notes into SharePoint. For the purpose of being used as a prototype solution for a new repository document-share system for migration purposes. • Developed a migration plan and top three migration risks for moving data from old repository to a new repository using SOX best practices.• Followed UML based methods using Visio to create activity diagrams; assisted developers in creating sequence diagrams and collaboration diagrams.• Created a UML style schema to map out the database tables in order to capture archived data.• Data mined archived data from a Meta-Data repository for exporting it into in a new repository.• Collaborated with the Mainframe Development Leads to develop new repository schema.• Used Tableau to report data to the Mainframe Development Leads and Managers.• Setup a homepage in the groups MS SharePoint site and designed it to be ready to store data.

Tigard, Oregon, United States

Lead technician supporting a medical staff of six technicians and four front desk receptionists. Directly assisted the doctors in various medical procedures, helping out in the pharmacy and lab. Responsible for ordering medical supplies and medications on a weekly basis.• Created documentation for training the clinic staff members on the clinics medical practices, policies and guidelines.• Trained new technicians on all medical procedures, including running tests in the lab and filling patient’s prescriptions.• Trained the front desk receptionists on all policies and procedures for checking in a patient and billing out a patient after their appointment.• Assisted the clinic manager and lead doctor in hiring new staff members.• Wrote the schedule for all medical technicians and front desk receptionists.• Worked directly with vendors when medical equipment had issues that needed to be fixed or if specific lab work needed to be ordered for a patient.• Responsible for ordering medical supplies on a weekly basis, including performing a routine weekly check on medications that were running low and needed to be re-ordered.

Bachelor Of Science Degree, Computer Information Technology/Health Informatics

Associate Of Applied Science, Computer Information Systems/Health Informatics