Technical Associate - Early Career Leadership Development Program
Windsor, Connecticut
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.