• Supported data pipelines using AWS Redshift and AirFlow• Supported data model for reporting environment

• QBTime Data Steward, coordinating data integrations with other Data Stewards• Led sprint team coordinating work and focusing on priorities• As a Lead engineer spearheaded the migration of all QBTime data pipelines from Matillion to utilizing Glue / PySpark

• Promoted to Staff Data Engineer• Created enterprise Data Warehouse in AWS Environment • Created Enterprise Metrics Data Mart for Financial Forecasting• Led data integration with TSheets data warehouse and Intuit• Led data engineer for Time Tracking Segment - mentoring other engineers on the team

Re-Branded to Intuit• Created enterprise Data Warehouse in AWS Environment • Created Enterprise Metrics Data Mart for Financial Forecasting• Led data integration with TSheets data warehouse and Intuit• Led data engineer for Time Tracking Segment - mentoring other engineers on the team

• Integrated International Financial Data with US Financial Data for Global Financial Forecasting Model • Developed and maintained SQL Analytics Services environment• Mentored junior Data Engineers

• Maintained and modified proprietary development tool used to create healthcare metrics• Created healthcare metrics using a proprietary development tool • Modified and created reports for healthcare analytics• Integrate data from new and existing data sources into existing data model• Create and Maintain data loading, processing and presentation for healthcare metrics

Maintain and create datawarehouse environment. Including importing data from multiple sourcesand modeling the data in star schema. Assist with query performance issues and database architecture.• Integrated API data sources into existing Data Warehouse model• Maintained Analysis Services environment, improving cube processing and data retrieval times

Create and maintain teleHealth (eICU) data used for grant reporting.

Maintain and create datawarehouse environment. Including importing data from multiple sourcesand modeling the data in star schema. Assist with query performance issues and database architecture. • Created Analysis Services Cubes for analyzing 10 - 15 million daily hits. These cubes are now used to make business decisions for marketing and merchandising in order to increase conversion rates.• Created multiple data models for business analysis, working with business and technical experts.• Improved processing efficiencies for data models and Analysis Services reporting cubes, resulting in quickerdata availability.

Support the reporting needs of all internal business units. Provide database, data migration and reporting expertise to specialized projects. • Created Data Warehouse solution for Web Utilization information for Healthwise Content and Client Information. Including data modeling, data migration, data cube processing and report presentation. Which was showcased at an all employee staff meeting.• Created data migration to new meta data service used to create contextual search of Healthwise content.• Created data reporting solution for content mapping to UMLS data source. Including data model creation, data migration, analytic cube processing, and report presentation.• Created multiple reports to support business needs.

Maintain existing SQL database environment. Oversee all design, development and installationof new database in the existing environment. Provide technical expertise on database managementsystems to clients, management and IT personnel.• Designed and Developed MS SQL Database to house transaction level datahoused in multiple databases for reporting to Western States Land Commissionerpilot reporting program.• Designed and Developed MS SQL Database and helped develop programmingspecifications for a Web Portal for multiple state’s to submit data forWestern States Land Commissioner Pilot reporting program.• Redesigned Financial database for recording timber sales and helped developedprogramming standards for system upgrades.• Created multiple SQL Server Integration Services (SSIS) packages for importingdata from timber scaling handheld computers to a custom databaseused for integration with Financial database.

Administration of all aspects of the event ticketing system, including show and event records; tablemaintenance; user groups and event lists ;and user accounts and group profiles. Providedata reporting services, utilizing Crystal Reports and MS SQL.•Increased reporting capabilities of ticketing system by creating custom reportsutilizing Crystal Reports and MS Query Analyzer.• Created custom SQL scripts to monitor system activity and resolve majorissues with ticketing system.• Increased web sales by resolving work flow problems and automating themonitoring of event availability.

Database Administration for Oracle 8i and SQL 7 and 2000. Maintained and monitored database backup and restore procedures. Assisted and consulted with database design and implementation. Assisted developers with PL/SQL and T/SQL statements on development and production systems. Designed and developed integration between Oracle and MS-SQL databases. Managed high availability energy trading database requiring uptime of 24 / 7 with minimal downtime. Migrated IdaCorp Energy from Idaho Power’s infrastructure to a newly created infrastructure with zero downtime. Successfully implemented new database systems for payroll, accounting, help desk and energy trading. Installed, managed and maintained Oracle 8i databases residing on Linux and Unix Servers. Installed, managed and maintained SQL 7 and 2000 databases on Windows 2000 servers. Established monitoring and maintenance programs for all databases. Managed developer utilization of databases, consulting on database design and implementation. Designed and developed integration between Oracle and MS-SQL databases. Installed and setup Windows 2000 on Compaq Servers.

Database Administration for MS SQL 7.0. Maintained and monitored database backup and restore procedures. Assisted and consulted with database design and implementation for MS SQL 7.0 databases. Diagnosed and resolved complex network connectivity, server, and printing problems on Local and Wide-Area Network. Configured and installed Cisco routers and switches. Maintained and supported Web Applications and IIS Servers. Migrated current web databases from Access to SQL. Assisted vendors in setup / installation of SQL based applications.

Assisted with the installation and administration of BuySite 4.0 deployment. Including IIS configuration, SQL database configuration and workstation testing and configuration. Resolved hardware and software problems on computers and peripheral systems. Configured, tested and installed computers and LAN and WAN-based hardware systems. Scheduled problem resolution, projects and administrative functions under constantly shifting priorities. Consulted with vendor service departments, engineers and other support professionals to expedite problem resolution. Installed computer applications software on a wide variety of operating systems and hardware platforms. Assisted with the maintenance and installation of network infrastructure components. Used a variety of network analysis and telecommunications test equipment for troubleshooting problems. Promoted 3 times in 4 years. Received 5 monetary performance awards in 4 years. Implemented new installation procedures resulting in fewer support calls after product upgrades. Saving time and money. Consolidated database versions reducing company’s total cost of ownership and simplifying database administration. Managed and maintained file shares utilizing quota server. Selected to provide remote support of IdaCorp Subsidiary via Citrix Terminal Server, involving onsite evaluation and ongoing support. Acted as backup Exchange Administrator.

Supervised programming and quality assurance of custom software package. Relayed information from client to programmer in order to complete custom software package. Conducted in-house training for PC communications, troubleshooting PC, and functionality of custom software package. Developed batch programs, script programs and configurations programs. Developed robotic typing programs for PC communicating to mainframe emulators using Visual Basic and Micro script developer’s package. Performed on-site installation, troubleshooting and education of custom software package.Responsible for on-site installation of customized financial software for hospitals. Developed and documented procedures for support of each custom installation. Conducted in-house training for PC communications, troubleshooting PC, and functionality of custom software package. Developed batch programs, script programs and configurations programs. Developed robotic typing programs for PC communicating to mainframe emulators using Visual Basic and Micro script developer’s package. Performed on-site installation, troubleshooting and education of custom software package.

Solicit wholesale mortgage loans from mortgage brokers. Educate mortgage brokers on Washington Mutual Loan products. Supply mortgage brokers with current loan interest rates and pricing. Established Washington Mutual Wholesale Department for the state of Idaho. Solicited mortgage loans from mortgage brokers via a tenacious direct sales effort. Increased wholesale loan closings from 0 in April 1995 to $1,000,000 in September 1995. Increased number of approved brokers from 4 in April, 1995 to over 20 by September, 1995. Educated brokers on specifics of Washington Mutual products and relayed information concerning Washington Mutual products to administrative levels.