Nicholas Vitale

Experience

• 

  American Auto Sales

  Aug 2007 - Jul 2015

  Manager

  - Managed all dealership operations including customer service, sales, support, state filings and advertising- Drove consistent growth, grossing sales of $1M+ while creating and maintaining a positive work environment- Managed the repair facility including quoting, scheduling and coordinating repairs

• 

  Ridgepoint Technology

  Jan 2010 - Aug 2011

  Technician

  - Managed online orders across the country including assembling, configuring, and shipping- Constructed and imaged a variety of different computer models, including laptops and desktops (mainly enterprise-class Dell and HP models)- Solved customer service or product issues including troubleshooting, diagnosing and repairing computers- Oversaw online advertisements and web postings

• 

  The Hartford

  Jul 2015 - Sept 2022

  - Managed a team of 13 high performing PL/SQL data engineers- Successfully executed multiple complex multi-million-dollar projects in critical development, consultation and process improvement capacities- Efficiently forecasted team’s capacity and work queue using Tableau dashboards, while also mentoring and building leadership skills- Served as application owner and technical lead for all regulatory reporting and reserving applications solving complex data requirements from many different sources- Oversaw all data engineering of enterprise regulatory reporting apps and the Actuarial reserving calculation of IBNR and other metrics Show less Excelled in a competitive early career program for high performers. Rotated through various challenging roles including the following:Data Modeler - Enterprise Data Modeling Team- Led upgrade of infrastructure & software for ERwin Data Modeler. Improved application performance by over 300% resulting in large capacity lift for enterprise data modeling team.- Administrator for ERwin DM. Profile, user and permission administration and license monitoring. Maintained both prod and dev environments.- Used ERwin DM to model app databases and dimensional DW environments (forward & reverse engineering - multiple environments SQL Server, Oracle, Hadoop etc). Maintain a repository of master data models using ERwin Model Mart.- Alteryx/Trillium for various data cleansing, data wrangling and data profiling activities.Change Agent - Middle Market Operations- Worked with process owners, tech leads and business leads to collect key data points to allow visibility into various MM initiatives.- PowerPivot data model, PowerView to create robust operations dashboards. Automated data refresh using VBA to pull from various sources and update the model.- Adobe Captivate to create tutorials for dashboards.Developer - Web Delivery Team- Some of our initiatives included a custom work management tool, SharePoint administration, .net application development, SQL Server 2013 administration.- SQL Server 2008/2013, SharePoint 2007, 2010, 2013, security and access management, relational database design and configuration, workflows, content management, CA configuration, InfoPath 2013- Created a custom form that automated application audit intake. Saved a total of 40 hours annually of non-value added time for 10 app owners. Show less

  • Manager, Data Engineering

    Oct 2020 - Sept 2022

  • Senior Data Engineer

    Feb 2020 - Oct 2020

  • Data Engineer

    Sept 2017 - Feb 2020

  • Technical Associate - Early Career Leadership Development Program

    Jul 2015 - Sept 2017
• 

  Aetna, a CVS Health Company

  Sept 2022 - Jan 2024

  Lead Director, Data Engineering

  - Manage offshore data engineering team to prioritize high impact initiatives- Responsible for primary data refreshes completed through batch scripting, stored procedures and SSIS packages- Serve as technical lead/engineer for a multi-faceted competitive intelligence project, integrating pricing information with Salesforce data to provide the Sales team with a more insightful level of competitive analysis.- Introduced new collaboration tools to significantly improve shared team documentation and visibility into workflows and priorities Show less

• 

  The Hartford

  Jan 2024 - now

  Director, Data Engineering

  - Leading a team of talented data engineers aligned to Actuarial- Modernizing and consolidating our legacy portfolio- Working with a wide variety of technologies including:Oracle ExadataPythonSnowflakeAWSLinuxCI/CD Pipeline and more..