Troy Ascher Email & Phone Number

Madison, Wisconsin, United States

• Developed Snowflake streams, pipes, procedures, and tasks to migrate Unix, Teradata, and DataStage pipelines to Snowflake and Azure.• Aligned data model designs with business requirements through close collaboration with end-users.• Collaborated with the data architect to close security gaps and ensure HIPAA compliance by designing and implementing a PoC for row and column level security in Snowflake.• Achieved HITRUST re-certification by collaborating with internal auditors and stakeholders to close data governance and data security gaps.• Reduced Snowflake credit usage and increased performance by applying SQL tuning and data modeling concepts.• Advocated for increased compute resources with a performance testing script using Snowpark's Python API, resulting in a 38% reduction in Snowflake credit usage for a key process.• Provided on-call support for both Teradata and Snowflake data stacks to ensure operational KPIs are met, and data integration is seamless.

Austin, Texas, United States

For my second rotation I worked as a Data Warehouse developer moving an existing on-prem DW to Snowflake on Azure.Highlights:- I researched best practices for column level security and designed and implemented a re-useable model to be used on our Snowflake tables.- I developed a re-useable set of data validation queries and test cases to validate tables and tasks are executing and being populated correctly from Azure to Snowflake.

Minneapolis, Minnesota, United States

During my first rotation I developed and deployed SQL packages to UHC's provider and claims databases. I wrote three new procedures to assist with ETL that were successfully deployed to production. I also worked on two defects where I deployed a solution that also tuned the existing queries, and I made multiple deployments on table structure changes.Highlights:- I increased the number of records being processed per second in an existing package by ~21%. While building a stored procedure in Oracle I found an issue with the package my procedure would be a child to, corrected the issue, and the runtime was improved.- I reduced the time it takes to do a particular routine request by 81% by building three re-useable procedures in Oracle. A job that would normally have taken thirty-two billable hours can now be done in six.

Greater Minneapolis-St. Paul Area

Security module owner | Requirement gatherer | UAT Tester

Greater Minneapolis-St. Paul Area

HR Benefits and Technology Analyst | Recruiting Coordinator| Barista

Master Of Science - Ms, Computer Information Systems, Business Intelligence And Database Management, 3.8 Gpa

I learned to model data, manage databases and data warehouses, build ETL processes, perform statistical analysis, use machine learning.

Bachelor'S Degree, International Business And Chinese Language, Upper Second Class Honors

Activities and Societies: Student Staff Liaison Committee (SSLC) RepresentativeFirst Class Honors on Final Year Thesis.

Associate Of Science (A.S.), Management Information Systems, 4.0

Activities and Societies: Dean's List 2015 - 2016