Experience

First Tech Federal Credit Union

• United States
• Financial Services
• 700 & Above Employee

• Business Intelligence Analyst II

  • May 2022 - Present

  Performs research, data extraction and analysis, building data and analytical tools and providing financial modeling to support profitability. Primary Responsibilities: • Provide financial modeling specific to profitability using external and internal tools. • Write, execute and maintain code proficiently to create and produce monthly and quarterly reporting and provide recommendations based on analysis. • Research and analyze root causes of identified risk trends and validate data integrity. • Aggregate data from multiple source systems to build data and analytical tools that offer deeper insight into enterprise data, allowing for critical decision making outputs. • Design and build infrastructure for data extraction, preparation, and loading of data from a variety of sources using SQL and/or Python. • Validate data, recognize errors, and make modifications to programs to meet changing needs



CareOregon

• United States
• Insurance
• 700 & Above Employee

• Operations Data Analyst

  • Aug 2020 - Present

  • Transitioning existing reporting from MS Access into Tableau, SQL Server Reporting Services using various tools, including SQL Server Management Studio, Tableau desktop and Tableau Prep. • Designing Tableau dashboards to represent productivity of different departments based on specific criteria. • Writing queries on both ad hoc and ongoing reporting to capture productivity and aid in Operations reporting. • Improving Process on existing reporting, determining inefficiencies and working with examiner teams and supervisors to implement efficient standards.



Beacon Hill, Inc.

• United States
• IT Services and IT Consulting
• 1 - 100 Employee

• Database Engineer

  • Sep 2019 - Mar 2020

  • • Querying complex datasets and deriving conclusions including using all types of joins between multiple tables and aggregations, problem solving and debugging stored procedures. • Troubleshooting and maintenance in SSIS with focus on ETL. • Collaborating with development team to invent and analyze specs to meet business goals. • Testing and implementing new corrections and improvements with the development and analytics teams. • Participating in code reviews, providing recommendations and documenting solution steps. • Writing and executing detailed test cases and T-SQL scripts that exercise all aspects of the system under test.



Providence

• Hospitals and Health Care
• 700 & Above Employee

• Oregon Regional ED Data Analyst | Systems and Quality for Emergency Services

  • Nov 2011 - Sep 2019

  • Producing Emergency Services Medical data for nine hospital Emergency Departments across the state of Oregon. • Developing Tableau visualizations, dashboards and scorecards with data from various sources (WEBI/T-SQL/MsExcel) in support of organizational goals. • Performing expert level MS Excel analysis and delivering reports at the request of C-suite executives on a daily, weekly, monthly and ad hoc basis. • Engaging with large and complex data sets requiring advanced database interface skills including SQL Server 2018 queries and reporting. • Collaborating with regional directors and medical directors in strategic planning and reporting on progress of regional goals and directives



Charter Communications

• United States
• Telecommunications
• 700 & Above Employee

• Process Analyst/Data Analyst

  • Nov 2008 - Nov 2011

  • Providing daily, weekly, monthly, quarterly and yearly reporting requiring expert level Excel, Access and SQL Server 2007 skills to integrate large, complex data sets. • Reporting to C-suite executives on sales results, promotion tracking, and customer retention with both regularly and ad hoc reporting when necessary and managing multiple MS SharePoint sites. • Designing and reporting productivity metrics using MicroStrategy and recommending KPI improvement strategies based on data analysis.



JP Morgan FCS

• Software Development
• 300 - 400 Employee

• Process Analyst/Fraud Analyst

  • Sep 2005 - Jul 2007

  • Providing analysis using MS Excel, Crystal Reports and MS Access on fraud risk of an estimated $60 million portfolio of large corporate commercial credit accounts based on statistical trend analysis and historic predictors. • Providing analysis using MS Excel, Crystal Reports and MS Access on fraud risk of an estimated $60 million portfolio of large corporate commercial credit accounts based on statistical trend analysis and historic predictors.



Advanta

• Financial Services
• 1 - 100 Employee

• Fraud Analyst / Balance Control Analyst

  • Feb 2000 - Feb 2004

  Managing identification and case management of various forms of bad debt/check kiting accounts. Establishing new Balance Control department resulting in oversight of approximately $1.9M in monthly charge off. Managing conversion of internal corporate documentation from hard copy to searchable web directory. Designing and maintaining MS Access database (later migrated to SQL Server) and executed SQL queries against commercial card account base to identify accounts on the basis of previously identified risk factors. Collaborating with federal law enforcement, FBI and Department of Alcohol Tobacco and Firearms (ATF) as well as industry contacts to pursue fraudulent accounts and submitting Suspicious Activity Reports (SAR) in compliance with the USA PATRIOT act and Bank Secrecy Act (BSA).