Franklin, Tennessee, United States
Scott Wetzel is experienced in Data Warehouse Development, BI technology (Qlikview, PowerPivot, Tableau, Web-Focus), Enterprise Analytics, Banking, Transportation Logistics, Payment Technology, and Technology Sales. Scott has taken on significant leadership roles on large transformational projects including; consolidating development teams, aligning work with new senior leadership direction, coaching old business units to utilize new BI and reporting methods, and creating a culture of analytics by bringing together the analytics community. Tailoring what needs to be communicated to an audience at all levels is one of Scott's strengths as well as the ability to facilitate teams through tough culture change by executing a strategic vision. In addition, he has extensive experience working alongside executive leadership teams (C/VP); helping drive fact based decisions in a heavy analytic environment. He is perceptive to a team’s 'pulse' and can easily motivate and help guide coworkers through a high tempo work environment. He leads by example and take pride in developing talent on a team and growing coworkers personal career paths. Scott’s career objectives include building a company’s overall strategy through: - Creating a culture of providing exceptional value - Integrated with a high standard of customer focused service - By giving clear direction by means of motivating through the heart. His goal is to work with a dynamic executive team that optimally draws upon his wide-ranging set of skills.
Managed a scrum team to deliver security features on the allianzlife.com secure site responsible for a 1.5mm budget. This included integrating the Forgerock platform (OpenAM & OpenDJ modules) for Multi-factor authentication and dynamic risk decisioning at login as well as integrating Twilio services to enable a SMS delivery option for Multi-factor authentication. - Implemented different website risk states to dynamically disable high profile transactions when security features were unavailable. - Purchased, integrated and implemented a review process using the Threatmetrix SaaS tool at login and at cash withdraws. This enabled various teams to review digital identities and digital journeys of our users to identify and prevent fraudulent behavior. - Developed a POC using MongoDB to serve up data faster and more accurate to the website layer. This included integrating a new Linux server stack using docker containers
Strategy - Led the development and implementation of a new CoE within the global HR function, focused on digital workforce transformation for ~160k employees. This included developing a SWP methodology and implementation strategy containing a 3-year roadmap and governance structure. - Assembled diverse international project teams to deliver workforce transformation, including C-suite proposals with required resource, budget, and operationalization structure recommendations to deliver the aligned solutions - Created bi-monthly strategic vision / storylines to senior executives for an executive committee. This was to align strategy among global leaders and to focus decisions needed / yearly progress. Execution - Implemented strategic workforce planning in 3 Allianz entities for a 5 year horizon incorporating digital initiatives, strategic direction and business strategy. - Led a small, global team to take on a large amount of intake from many international stakeholders while keeping strategic vision aligned.
- Department leader in bridging the IT side of the business with 6 different business partners by establishing weekly prioritization meetings and bi-weekly development cycles. This enabled senior management on both sides to align on critical work which increased development deliverables and business value by over 300%. - Designed Agile project framework across multiple teams by implementing the use of backlogs, sprint & release planning and product roadmaps. In addition, engaged and coached Sr. management (IT and the Business) to adopt this framework and facilitate the change management amongst the teams. Key Projects - Lead and assembled an emergency 4-person SWAT team to save high profile projects which were failing to meet internal operational standards. This included restructuring a departmental team of +50 people and creating a .net web application for their data entry process of around 2K entries per day. - Lead a team to convert a InfoPath/Access solution to an automated SharePoint solution supporting over 300 different business units submitting 200 requests per day. Enterprise Data Warehouse Experience: - Lead consultant to our ETL & Database team in conceptualizing large ETL processes/packages - Worked with senior data architects to identify and replace 100+ poor and inefficient ETL processes - Implemented data marts/fact tables and multi-dimensional cubes to improve report speeds, refresh times and overall usability
Analysis Achievements - Developed and maintained a critical daily operational dashboard for executive C and VP level leadership. This included working with the executive team to identify key metrics, create a One-Page deliverable and ensure 100% accuracy on a daily basis. - Used Qlikview and Microsoft PowerPivot BI tools to create analysis which portrayed customer landscape around Net Revenue and Shipment Volume to develop “Go-to-Market” account strategies at an enterprise level. - Lead senior BI developers to create an enterprise reporting suite in Qlikview, replacing hundreds of outdated crystal reports and Excel spreadsheets into a reporting portal enterprise wide. - This included engaging multiple leadership parties to agree on a project roadmap with specific accountabilities as well as teaching/coaching BI developers how to utilize their own creative and cutting edge data visualization techniques to deliver on the enterprise needs. Enterprise Data Warehouse Experience - Lead Product Owner for Data Warehouse development to prioritize executive projects with IT leadership, making sure data architecture was in line with strategic reporting goals to enable proactive analytics rather than managing work-arounds and data discrepancies. - This alignment produced the foundation for accurate data storage related to business priorities thus enabling BI reporting which could be created quickly and accurately without data roadblocks. Agile Experience - Became the lead Agile-Scrum development team and primary Agile coach. This entailed teaching other development teams how to execute work and how to work closely with business users to drastically reduce development cycles and increase tangible business value. - Leader in pushing prescriptive analytics. Very passionate on stimulating leadership to what questions need answers by asking the 5 Why’s. These discussions elevated employee’s skillsets and grew the ability to quickly express analytic needs for strategic goals.
- Developed and implemented enterprise wide billing and payment tracking system - Improved finance and billing operations by re-designing process flow and closing known gaps - Reviewed and approved all customer billings maximizing revenue - Purchased and fully implemented Small Business Server 2008 and Exchange 2007 - Managed weekly payroll for over 55 employees - Reconciled accounts receivable on a monthly basis - Trained employees on proper file-management and IT practices on a daily basis
Lead Project manager for a federally funded, multi-million dollar electronic mass transit project in downtown Minneapolis installing over 50 digital, real-time electronic bus departure displays. I also facilitated internal and external meetings with government officials covering the project charter, stakeholder mgmt, resource allocation, scope management and communicating risk awareness. - Completed project within budget, scope, and timeline, while adhering to government requirements - Coordinated with project management teams, general contractors, subcontractors and vendors - Supervised custom internal fabrication for product accuracy and cost-effectiveness - Managed 4 field project managers to ensure a smooth installation schedule with other contractors