Retired
Current
Jan 2024 - Present
Who is Dan Vail? Overview
A concise factual answer block for searchers comparing this professional profile.
Quick answer
Dan Vail is listed as Retired at Retired, based in Greater Seattle Area, United States, United States. AeroLeads shows a work email signal at teksystems.com and a matched LinkedIn profile for Dan Vail.
Dan Vail previously worked as Data Engineer - Business Application Platform at Microsoft and Senior SQL Server Database Consultant at Teksystems. Dan Vail holds Bachelor Of Arts, Business Administration / Computer Science from Western Washington University.
Company email context
Email format at Retired
This section adds company-level context without repeating Dan Vail's masked contact details.
{first_initial}{last}@teksystems.com
86% confidence
AeroLeads found 1 current-domain work email signal for Dan Vail. Compare company email patterns before reaching out.
Profile bio
About Dan Vail
A passionate IT technical leader with a proven track record focusing on database design, development and delivery of high impact quality complex solutions based on business needs while proactively identifying areas for improved data management and performance tuning in a collaborating team environment with the ability to broadly listen to issues and communicate resolutions to business and technical audiences.Skills and Qualifications• Create logical and physical data models • Create and maintain T-SQL scripts ( scripting ) for Database Administration and Database Maintenance• Create and maintain data warehouse ETL processes using SQL Server Integration Services ( SSIS ) and Reporting Services ( SSRS ), and Powershell, • Performed Data Migration into third party and legacy systems• Administer Microsoft SQL Server 2008 R2 and 2012, including system performance, monitoring health, and tuning and optimization (application and database engine), security setup. Plan and execute daily and disaster recovery backup/restore and database movement per policies • Some experience with other database technologies ( MongoDB )• Plan complex projects across IT teams from initiating through closing phases • Deliver project communication inside and outside IT • Set program direction from business and technical perspective• Project Management Professional (PMP) Certification – Project Management Institute
Listed skills include Microsoft Sql Server, Databases, Sql, Data Warehousing, and 25 others.
Current workplace
Dan Vail's current company
Company context helps verify the profile and gives searchers a useful next step.
9 roles
Dan Vail work experience
A career timeline built from the work history available for this profile.
Data Engineer - Business Application Platform
- Create pipelines extracting and aggregating telemetry data from BAP Applications
- Create Power BI Desktop visualizations capturing usage and trends
Nov 2022 - Aug 2023
Senior Sql Server Database Consultant
- Developing and enhancing a Mass Update tool supporting the Provider Network Management data systems in an Agile Framework.
- Designed custom sql server tables and procedures along with SSIS to support data flow from template ingestion to data validation to target table apply with logging to support troubleshooting, reporting and internal audit
- Source code was managed in Team Foundation Server utilizing Azure DevOps pipeline services for release deployment
Jan 2021 - Nov 2022
Senior Sql Server Database Consultant
- Contract SQL Developer, Kaiser Permanente Washington, Renton, WA 2020 – Current
- Focused on day to day SSIS and SQL work
- Completed a framework SSIS package messaging including data analysis and sql objects to store distribution lists and SSIS tasks to retrieve that data and use it packages.
- Created a framework for SSIS packages to perform file sweeps on folders, execute an existing stage and publish package, and manage archival.
- Performed QAT tasks on SQL changes implemented in product
- Participated in daily huddles, sprint planning, and troubleshooting session.
Aug 2020 - Dec 2020
Senior Sql Server Database Consultant
- Contract SQL Developer, Premera Blue Cross, Mountlake Terrace, WA 2019 – 2020
- Collaborated with Systems Analysts and Business Analysts in an Agile Framework to identity requirements for a Mass Update tool supporting the Provider Network Management data systems.
- Created a tabbed Excel template to provide the data source for update in place for providers and add/update/term for provider product plans processing
- Designed custom sql server tables and procedures along with SSIS to support data flow from template ingestion to data validation to target table apply with logging to support troubleshooting, reporting and internal audit
- Source code was managed in Team Foundation Server utilizing Azure DevOps pipeline services for release deployment
Sep 2019 - May 2020
Senior Database Developer
- Lead a remote team of five developers in an already in flight data migration project from Oracle source databases into legacy SQL Server point of sale database. ETL code utilized SSIS and stored procedures to stage.
- Develop framework for a one-time data load from the legacy Point of Sale system to SalesForce.Com utilizing MuleSoft/Anypoint, MongoDB, and SFDC bulk data load tool. Supported strategic movement towards cloud hosted.
- Consulted on a strategy to encrypt PII data in the legacy Point of Sale and retrofit stored procedures to handle new columns for encrypted data to reduce risk of data theft
- Created and maintain Point of Sail system code including updates for year-end processing.
- Develop and maintain T-SQL and Integration Services (SSIS) standards
Jul 2016 - Apr 2019
Senior Database Administrator
- Database Administration
- Daily and on call support for Firm databases
- Day to day support for timely resolution of IT and Business requests and maintenance of in-house developed and vendor sql databases.
- Perform troubleshooting and analysis to resolve performance issues involving database and/or server tuning (SQL Server Profiler, SQL Server Logs, Extended Events, and Windows Resource Monitor).Application Support
- Supported Partner Financial Ledger Reporting (deliver monthly financial statements for Partners) fulfilling roles from Business Analyst, Architect, Designer, Developer, Tester, and Operations Support.
Jul 2012 - Jul 2016
Senior Program Manager
- Manage Pricing and Product Program and projects exposing data from SAP
- Plan, create, and manage projects from initiating thru closing phase for complex multi-year projects across five IT teams
- Identify and manage risks and issues to project team, core team, steering committee, and sponsors and executives.
- Forecast financials and staff teams including FTE and contingent staffManage Enterprise Data Repository (Feedstore) Program and projects
- Planned and managed OS and SQL Server Platform Upgrades
- SME helping downstream applications find and access data
Aug 2006 - Jul 2012
Serior It Developer
- Dev Lead in Entertainment & Devices Division
- Design and develop SQL Server ETL supporting Supply Chain Management and Reverse Logistics for Microsoft Hardware including XBOX
- Drive strategic direction and day to day management of Development Team based upon requirements and project plan to deliver high quality solutions.
- Led Development Team to provide guidance and options for architectural design with an emphasis on performance and quality.
- Plan and coordinate developer and test tasks and plans with offshore teams
- Train and onboard new team members during system ramp up and provide ongoing mentoring to team.Data Warehousing
Nov 1999 - Aug 2008
1 education record
Dan Vail education
-
Western Washington University
FAQ
Frequently asked questions about Dan Vail
Quick answers generated from the profile data available on this page.
What company does Dan Vail work for?
Dan Vail works for Retired.
What is Dan Vail's role at Retired?
Dan Vail is listed as Retired at Retired.
What is Dan Vail's email address?
AeroLeads has found 1 work email signal at @teksystems.com for Dan Vail at Retired.
Where is Dan Vail based?
Dan Vail is based in Greater Seattle Area, United States, United States while working with Retired.
What companies has Dan Vail worked for?
Dan Vail has worked for Retired, Microsoft, Teksystems, Kaiser Permanente Washington (Brooksource), and Premera Blue Cross (Teksystems).
How can I contact Dan Vail?
You can use AeroLeads to view verified contact signals for Dan Vail at Retired, including work email, phone, and LinkedIn data when available.
What schools did Dan Vail attend?
Dan Vail holds Bachelor Of Arts, Business Administration / Computer Science from Western Washington University.
What skills is Dan Vail known for?
Dan Vail is listed with skills including Microsoft Sql Server, Databases, Sql, Data Warehousing, Integration, Enterprise Software, Data Analysis, and Software Development.
Find 750M verified contacts
Search by job title, company, industry, location, and seniority. Export verified B2B contact data when you need it.
Start free trial