Patrick Wenzel Email & Phone Number

Saint Paul, Mn, Us

Saint Paul, Mn, Us

Philadelphia, Pennsylvania, Us

• Developed 3 Grunt tasks in Node.js to automate processes and increase ability to meet 10-week timeline.• Created custom widgets utilizing Less.js and JavaScript to meet client's needs for studies.• Actively contribute ideas in meetings and deliver updates on deadlines, designs, and enhancements.• Leverage test-driven development methodologies to implement new features and functionality.• Carry out code reviews to ensure code quality and adherence to software engineering best practices.• Maintain high level of customer satisfaction by confirming all customer requests met while following Clario's internal quality standards.• Aided other teams by investigating tickets on post-production release studies while working with project teams to determine how to meet clients' requests.

St Paul, Mn, Us

At 3M, I served as Data Engineer & Full Stack Developer where I worked with various technologies to create data driven web applications. I was a lead developer of an application analytics dashboard where I gathered and compiled usage information from apps to deliver expert-level application insights.I created SQL tables from outside data sources by utilizing Azure Data Factory.What makes me stand out from the competition is my ability to get work done. I was the top ticket completer on the two projects I worked on and the top contributor to a repository used by all projects on the team with over 250 commits.My achievements are as follows: • Created aggregated tables in SQL databases that reduced UI load times and query times by up to 90+%. • Shortened run time of SQL stored procedure 85+% (~75 minutes) which saved money on per-query-costs. • Generated SQL table of precalculated pathways in Neo4j database containing 190M rows of data. • Top Jira ticket completer on multiple projects and the top contributor to a repository used by all projects. • Guided new hires and interns by running intern events, helping on projects, and doing informational interviews.

Chicago, Il, Us

• Established Amazon listings to acquire products into the Buy Box.• Delivered product performance insights by generating weekly reports.• Saved time in creating reports by automating data population in Excel files.

St Paul, Mn, Us

• Developed an application analytics dashboard using SQL, React.js and, Node.js to provide 15 usage metrics.• Presented to application teams after performing data analysis on why their application metrics may be low.• Automated backend processes by leveraging Azure and Azure Data Factory.• Streamlined workflow using Scrum framework in collaboration with the project team.

Ames, Iowa, Us

• Helped to start building Iowa State University’s Office of the Registrar’s new website from the ground up.• Designed process for developing locally, pushing to a stage website, and then pushing to the live site.• Collaborated with other web development teams to learn about their processes.

Ames, Iowa, Us

• Assisted students in learning computer engineering skills and helping them with their other classes.• Resolved hardware and software issues.• Meetings with the professor and other TA’s to discuss class progress, issues, planning what to do in class for the week.

St Paul, Mn, Us

• Examined sales data for insights by utilizing multiple PowerBI Reports.• Addressed all aspects of inbound customer technical questions/queries.• Facilitated sales representatives by formulating territory zone mapping.• Improved quality complaints resolution by orchestrating and implementing a process map.