Travis E. Johnson

Travis E. Johnson Email and Phone Number

SQL and ETL Developer - "Dig Deeper"
Travis E. Johnson's Location
Spokane-Coeur d'Alene Area, United States
Travis E. Johnson's Contact Details

Travis E. Johnson personal email

n/a
About Travis E. Johnson

Business and Data Analyst with experience across a variety of industries including: insurance, communications, software, healthcare, manufacturing, municipal services and marketing. Experienced with data transformation & migration across a dozen projects/workplaces. Proven ability to craft actionable business intelligence solutions for technical & non-technical consumers alike. Accomplished solution developer dedicated to improving data quality, strengthening internal systems and reporting the clearest findings valuable to readers at every level.

Travis E. Johnson's Current Company Details

SQL and ETL Developer - "Dig Deeper"
Travis E. Johnson Work Experience Details
  • Umpqua Bank
    Integration Engineer
    Umpqua Bank Mar 2022 - Dec 2023
    Spokane, Washington, United States
    Using SQL and Talend, developed scripts and ETL packages for the Data Integrity & Governance team, in preparation and then assisting in getting through the merger of Umpqua Bank and Columbia bank. Assisted in data remediation efforts, training of Remediators, and troubleshooting of complex data-flow issues.Accomplishments: Tripled the speed of 125 SQL queries that tracked Key Data Element (KDE) outliers Doubled the number of Talend jobs Developed a technique to block, then slowly release at the team’s discretion, the effects of Columbia’s incoming outliers on those 125 KDEs. Developed a technique to quietly ‘Auto-Resolve’ (removing them from the Remediator’s Talend campaign screens) any outliers that were found to have been corrected, saving about 30 people hours of wasted time each week. Applications: Talend Dev Consol, MS-SQL 2016, AWS Azure, Power BI, Azure DevOpsLanguages: SQLCommunication: Microsoft Teams, Outlook, SharepointSkills Used: Ad-Hoc Querying, SQL Coding, ETL Development, Talend Administrator
    View
  • Providence St. Joseph'S Hospital
    Sr Data Engineer
    Providence St. Joseph'S Hospital Mar 2020 - Mar 2021
    Beaverton, Oregon, United States
    Created and edited Informatica workflow packages for the clients of Providence Healthcare Intelligence. These extracts served the data & analysis needs of a variety of external vendors, billing companies, hospitals and clinics. Provided coding review & troubleshooting for this entirely remote team.Applications: Informatica PowerCenter, MS-SQL, Oracle SQL DeveloperLanguages: SQLCommunication: Microsoft Teams, OutlookSkills Used: Ad-Hoc Querying, SQL Coding, Informatica PowerCenter
    View
  • Amazon
    Data Engineer Iii
    Amazon May 2019 - Oct 2019
    Seattle, Wa
    On a two person team, created ETL pipelines for Amazon’s most highly secured data – Diversity Analytics. With such attributes as gender, ethnicity & salaries, only a handful of Amazonians have access to this data. Using ETL tool Cradle, created source to target ETL packages for datasets like Headcount, Starts, Terminations & Recruitment. After populating Andes tables, I subscribed such tables to a secured data warehouse, RedShift. Applied row level security models so various consumers would be able to access dashboards & visualizations in Quicksight only applicable to their departments.Applications: MS-Word, MS-ExcelLanguages: T-SQL, postGREs, Redshift, SparkAWS Applications: Redshift (Big Data Tool), QuickSight (BI & Dashboarding)Other Tools: Cradle (Internal Amazon ETL tool), SQL Workbench/J, EDX (Big Data - Elastic Data eXchange), Andes/HOOT (Amazon Big Data agnostic data store)Communication: Amazon ChimeSkills Used: Ad-Hoc Querying, SQL Coding, Sprint Planning
    View
  • Providence Health Plans
    Software Developer
    Providence Health Plans Feb 2019 - May 2019
    Beaverton, Or
    With the Providence Health Plans Finance agile team (HPF), worked on several initiatives, notably, reworking existing SQL procedures and SSIS packages into Informatica workflows for the Accounting department’s general ledger. Wrote new SQL scripts and functions to adapt the team’s ASO line of business funding process. Remediated existing code in preparation for upgrade to Facets 5.5. Created various analytical tools & DBA scripts. Held lecture series on SQL coding for department. Responsible for code performance optimization.
  • Diamond Resorts International
    Data Analyst
    Diamond Resorts International Oct 2018 - Dec 2018
    Las Vegas, Nevada Area
    For the Human Resources Analysis team, translated SQL and Excel VBA scripts into R. Wrote SQL stored procedures, R-scripts, and created data flow documentation. Analyzed loans, properties and customer data.
  • Oregon Health Administration | Objectwin
    Sr. Database Developer
    Oregon Health Administration | Objectwin Jun 2018 - Jul 2018
    Salem, Oregon
    For Integrated Eligibility project, reviewed T-SQL code for this database transfer solution. Built tools, reports and strategies using SQL 2014 & 2016. Optimized stored procedures and indexing strategies. Built custom scripts for transposing JSON files to SQL & Excel. Mentored junior developers.
  • Kaiser Permanente
    Sr Database Developer
    Kaiser Permanente Aug 2017 - Nov 2017
    Portland, Oregon Area
    For Provider Information Technology Systems, created SQL databases, relational models, stored procedures and scripts to help with data migration from legacy to cloud machines. Wrote scripts to clean data and schema for new environment. Created dozens of SSRS reports and a searchable technical documentation database. Staffing via ProKarma USA.
    View
  • Intel Corporation
    Sr Software Developer
    Intel Corporation Feb 2017 - May 2017
    Portland, Or
    On MVE (Manufacturing Validation Engineering) Team, used Spark and Scala to develop scripts. On this new R&D project, created scripts to pull data from Hadoop cluster. Developed data flows and analytical tools to populate Hive tables for consumption by the application. Developed an algorithm to deterministically anonymize data for security purposes. Developed Spark scripts to generate dynamic SQL statements for input CSV files.
    View
  • Next It
    Sr. Sql Developer
    Next It Mar 2015 - Jan 2016
    Spokane Valley, Wa
    Created stored procedures, SQL jobs and a new data archival process. Tuned indexes, procedures, data storage. Created new SSRS reports and improved speed of existing reports by at least 50%. Reviewed other teams’ SQL scripts for quality. Used SQL CMD scripts to deploy new databases and hotfixes. Improved knowledge of advanced DBA work.
    View
  • Intel Corporation
    Sql Database Developer
    Intel Corporation Sep 2014 - Dec 2014
    Hillsboro, Or
    SQL DATABASE DEVELOPER – EPS TOOLS TEAM, INTEL CORP, A REMOTE CONTRACT THROUGH US TECH SOLUTIONSOn EPS Tools team, created stored procedures, SQL jobs and architected new processes for a redesign of DVOnline and IntelDistrib databases. Created automation and analysis tools. Work performed in Spokane, remote to Hillsboro.
    View
  • Idic Designs
    Database Developer, Freelance Consultant
    Idic Designs Jul 2012 - Aug 2014
    Spokane, Wa
    Worked with owner on various projects involving MS-Access, MS-SQL. - Created new UI for Positive Life Radio's campaign-tracking application.- Upsized Kiemle & Hagood's MS-Access database to SQL, converting VBA scripts to T-SQL equivalent.
    View
  • Hewlett Packard
    Remote Data Analyst, Through Eteam Llc.
    Hewlett Packard Nov 2013 - Feb 2014
    Spokane, Washington Area
    For the Client Conversion Team, Global Data Management, Hewlett Packard. Working from Spokane WA, I connected to remote HP databases in a large-scale data quality analysis and conversion project. Used Excel power-pivot, advanced queries to investigate and clean large sets of internal HP client records stored in a variety of Oracle databases. Performed investigation across a variety of HP systems combined with extensive internet research.
    View
  • Daverci Llc
    Tier 2 Sql Analyst
    Daverci Llc Jul 2013 - Sep 2013
    Hillsboro, Or
    A contract through Everest Consulting LLC:Troubleshoot Tier 2 support tickets related to Tocarre, a mobile device application servicing Long-Term Care facilities across the country. Import data from SQL Compact Edition to SQL 2008. Create technical documentation on data-flow processes, stored procedures. Create tools to navigate and display the relationships and complexities of their processes.
    View
  • Spokane Mental Health (Frontier Behavior Health)
    Crystal Report Analyst
    Spokane Mental Health (Frontier Behavior Health) Aug 2012 - Dec 2012
    Spokane, Washington Area
    Created Crystal Reports, stored procedures, SQL queries in a 1000+ table database. Created T-SQL script by which the shortest path between 2 or more tables could be discovered - reducing query-writing time by 80%.
  • Razorfish
    Production Operations Engineer Iii
    Razorfish Sep 2011 - Jul 2012
    Tier III support of SQL databases and ETL flows. Create spreadsheets, SSIS packages, and a database to monitor client data flowing into Razorfish/VivaKi. Work with EC2 Instances in Amazon cloud. Use of Cloudberry to move 100+ GB and terabyte level databases, cube and backups to S3 storage. Backup, recovery and mid-level DBA duties in SQL. Other programs used: JIRA bug tracking & various Google applications like Sites & Docs.* Created monitoring process that alerted team about growing problems early - often solving data processing issues before the customer was even aware.* Created Tableau reports for the clients' Business Analysts, empowering them to improve customer relations by giving them insights into Prod/Ops.
    View
  • Vivaki Nerve Center & Razorfish Llc
    Production Operations Engineer Iii
    Vivaki Nerve Center & Razorfish Llc May 2010 - Sep 2011
    Tier III support of SQL databases and ETL flows. Create spreadsheets, SSIS packages, and a database to monitor client data flowing into Razorfish/VivaKi. Work development and test team to transition legacy systems to AWS Cloud. Deployment of new client databases and cube to the cloud. Use of Cloudberry to move 100+ GB and terabyte level databases, cube and backups to S3 storage. Backup, recovery and mid-level DBA duties in SQL. Other programs used: JIRA bug tracking & various Google applications like Sites & Docs.
  • Microsoft | Aditi | The Arnold Group
    Sr. Data Analyst
    Microsoft | Aditi | The Arnold Group Mar 2010 - Apr 2010
    Bellevue, Wa
    Subcontracting for 'The Arnold Group', for the Online Services Division of Microsoft Corp.Drawing from a variety of departmental sources, I created a SQL database to join data covering $300 million vendor purchase orders & invoices. Working closely with a Principle Consultant from the Arnold Group, I created a SQL 2008 database, generating raw extracts and Excel pivots & graphs for use in Power Point presentations to Microsoft business unit owners. For future users, I created an Access front-end that allows for flexible re-categorization and analysis of the existing data. Through my work, I helped to generate about $50 million in savings opportunities.
  • Accenture
    Data Analyst
    Accenture Feb 2010 - Mar 2010
    Staffed through The Upper Ranch Co, I joined a team of Accenture vendors, as they created a VBA-driven BI tool in Excel. The client was Microsoft Consulting Services (MCS), and this tool was to be used for weekly pace of business meetings. It tracked changes in the sales pipeline for hundreds of open MCS development projects. I created a SQL 2008 database as an ETL, data cleansing and data storage area, working closely with another VBA developer to integrate the SQL into a complex and time-sensitive process.
    View
  • Wellpoint
    Data Analyst / Developer
    Wellpoint Sep 2009 - Oct 2009
    Performing BSA and database architect duties, I am cleaning, validating and analyzing data for the Over 65 Marketing division. Developed Access data mart that expands the reporting capabilities of the web UI, discovers hidden discrepancies, and joins to data exported from other departments. I interface with subject matter experts from around the country to refine datasources that are used for nationwide marketing materials for Wellpoint’s insurance products and Medicare/Medicaid. (Staffed through Teksystems, Inc of Engelwood, CO)
    View
  • Siemens Its
    Bsa 3 - Cross-Network Analyst Team
    Siemens Its Mar 2008 - Mar 2009
    This Siemens contract begins at a point of transition for this Microsoft group. My duties involve using SQL 2005 to perform ad-hoc analysis on a Mobile Datamart. Analyzing text & instant messaging, internet browsing & various Microsoft services of over 2 billion anonymized records, I provide business intelligence to internal Microsoft customers. Additionally, I work with another department, Syndication Central, to learn, configure and then train others to use a third party analysis website, Omniture.
    View
  • Eagle River Water And Sanitation District
    Data Analyst
    Eagle River Water And Sanitation District Dec 2007 - Jan 2008
    Vail, Co
    In this quasi-municipal organization’s newly created IT department, my projects oriented around converting the company’s legacy systems and work processes. I converted a Paradox database and some Excel spreadsheets to start, into Access 2007, in preparation for upsizing to SQL 2008. I created a project evaluation and tracking application, performed ETL activities on several spreadsheets, and created a business intelligence and scheduling tool for their field operations workforce.
    View
  • Sopheon
    Data Analyst
    Sopheon Oct 2007 - Nov 2007
    General Motors consolidated several of its department-based, legacy systems into a single, enterprise-wide architecture. Using its flagship database/web-tool, “Accolade”, Sopheon partnered with Hewlett Packard to build and deliver a successful project to the auto manufacturer. It was a high-energy, constantly fluctuating process, and my skills with Windows XP, Windows Vista, SQL 2005, MS-Excel, Visual SourceSafe and Mercury Quality Center, improved daily.Reporting Team – My duties involved the building of VBA driven Excel workbooks.Migration Team – In Sopheon’s SQL Server 2005 database, I wrote T-SQL functions to extract GM project information from disparate tables, concatenate, then load user-friendly project names, replacing true but difficult-to-navigate-by ID numbers.Testing Team – Navigate through GM and Sohpheon systems, testing and validating the correctness of the migration data, noting discrepancies in Mercury.
    View
  • Verizon Business
    Business System Analyst
    Verizon Business May 2007 - Jun 2007
    For a rapidly growing team, staffed primarily with contractors and outsource workers, I created an Access database, “BA/SA Coordinator”, to unify the teams' activity. It records and tracks the earliest phases of a projects lifecycle for the Business & Systems Analysts – where clear planning and frequent communication is the most critical. I also created a collection of Word documents, Visio diagrams and Access databases designed to help future contractors get up to speed as quickly as possible.
    View
  • Guardian Life Insurance
    Sr. Business/Technology Analyst
    Guardian Life Insurance Feb 1999 - Oct 2006
    Perform Business Analysis, then create custom applications to automate workflows, improve staff productivity, reduce hand-offs, security quality results and generate clear reports for all user-levels. Mentor Field Support in the use of their PCs and software via one-on-one and small-group training. Identify and suggest business-enhancing projects using new technologies or upgrades. Supply ad-hoc reporting, project work & troubleshooting to other departments & individuals.Technologies used: Access, Word, Excel user-interfaces for SQL Server databases.
    View

Travis E. Johnson Skills

Microsoft Sql Server Databases Business Intelligence T Sql Data Warehousing Visio Business Analysis Sql Amazon Web Services Cloud Computing Access Tableau Integration Ssis Sharepoint Opswise Testing Sql Server Amazon Cloud Microsoft Excel Ms Excel Pivot Tables Crystal Reports T Sql Stored Procedures Database Administration Microsoft Office Microsoft Word Vba Ssrs System Monitoring Cloudberry Amazon S3 Database Architecture Cross Functional Team Building Functional Requirements Employee Training Large Scale Data Analysis

Travis E. Johnson Education Details

Frequently Asked Questions about Travis E. Johnson

What is Travis E. Johnson's role at the current company?

Travis E. Johnson's current role is SQL and ETL Developer - "Dig Deeper".

What is Travis E. Johnson's email address?

Travis E. Johnson's email address is tr****@****msn.com

What is Travis E. Johnson's direct phone number?

Travis E. Johnson's direct phone number is +180144*****

What schools did Travis E. Johnson attend?

Travis E. Johnson attended New Horizons Computer Learning Centers, George Fox University.

What are some of Travis E. Johnson's interests?

Travis E. Johnson has interest in Science Fiction, Writing Poetry, Fantasy, Tanka.

What skills is Travis E. Johnson known for?

Travis E. Johnson has skills like Microsoft Sql Server, Databases, Business Intelligence, T Sql, Data Warehousing, Visio, Business Analysis, Sql, Amazon Web Services, Cloud Computing, Access, Tableau.

Not the Travis E. Johnson you were looking for?

  • Travis E. Johnson

    Travis E. Johnson
    Hotel Sales Professional Making Both Professional And Personal Connections Through Networking And Civic Engagement.
    Raleigh-Durham-Chapel Hill Area
    4
    gmail.com, yahoo.com, gmail.com, thelimited.com
View similar profiles

Free Chrome Extension

Find emails, phones & company data instantly

Find verified emails from LinkedIn profiles
Get direct phone numbers & mobile contacts
Access company data & employee information
Works directly on LinkedIn - no copy/paste needed
Get Chrome Extension - Free

Aero Online

Your AI prospecting assistant

Download 750 million emails and 100 million phone numbers

Access emails and phone numbers of over 750 million business users. Instantly download verified profiles using 20+ filters, including location, job title, company, function, and industry.