Nick Pataky Email & Phone Number

Hartford, CT

• Extracted and blended data from data warehouse using SQL to obtain data for monthly reporting to business partners
• Identified and tested specific Google analytics tags on digital platform using inspect element to create custom reports
• Automated data collection by creating a dashboard in Google Data Studio to present specific data on customer flows to help identify pain points
• Created automated Tableau dashboards based on needs from business partners

Hartford, CT

• Managed a group of 3 SMEs to validate resource tracker for financial planning purposes
• Delivered monthly scorecard with key insights of financial KPI to upper management
• Created a prototype central repository for key stakeholders to access financial data insights at a glance

Hartford, CT

• Worked closely with the customer value chain and identified pain points and bottlenecks using root cause problem solving in our quoting process.
• Increased efficiency of customer quoting process by implementing internal and external automation tools to alleviate pain points.
• Hosted a weekly meeting to communicate newly implemented changes to sales leaders. Utilized change management techniques with sales leaders to facilitate a conversation around new implementations.
• Managed a list of ideas from employees of new changes they would like to see implemented and helped getting those changes implemented.

Hartford, CT

• Maintained, managed, and improved a capability repository using VBA macros. The capability repository helps business architects identify capabilities faster, resulting in a faster road mapping process.
• Assisted integration team by maintaining an issues log to ensure that problems that arose during the integration process were being addressed and/or added to a long term project plan
• Identified solutions in a data clean up initiative of the case management system.
• Used Tableau to analyze and structure data to provide key insights on various projects.
• Helped fix various errors and added new features to CRSP SharePoint database.

Windsor, CT

• Developed a deployment process map to assist my team in rapid application development.
• Managed and communicated with various team members to manage IT related projects.
• Learned how to proficiently use Neo4j, a graph database, to analyze complex data trends and created documentation to support the data science team.

Madison, Connecticut

• Optimized server performance by organizing data structures and permissions.
• Developed a new form for HR using Excel to streamline employee time sheets.
• Drafted ideas for a system to collect time sheet data using JavaScript and HTML.

• Helped develop and manage a database using MySQL to categorize marinas across southern Connecticut.
• Educated boaters about the impact of dumping raw sewage into the ocean and offered them a free service to dispose of their waste.