Tim Bollack
Dunedin,FL
Summary
Performance-driven, high-achieving executive with eight years in SQL development and database administration and demonstrated skills in turning complex operational demands into simple end user processes. Adept at strategic planning, scoping, analytics, and SQL development, led to significantly enhanced operational efficiency and data integrity at American Power & Gas. Skilled leadership in organizational development and system optimization led to streamlined communications, increased productivity, risk mitigation, and revenue growth. Skilled in Agile methodology and database best practices, I fostered robust, results-driven solutions, contributing to a marked increase in stakeholder and employee satisfaction, system reliability and redundancy, and company profitability.
Overview
21
21
years of professional experience
1
1
Certification
Work History
Vice President of Operations
American Power & Gas
03.2020 - Current
- Applied excellent problem-solving, process development, and strategic implementation skills to streamline operations, identifying inefficiencies and implementing process improvements.
- Identified and resolved business processes that caused unmonitored financial loss, including rate management processes and early termination fees, resolving margin loss exceeding 500,000.00 annually.
- Restructured lead database models to add visibility and simplicity for data analysts, identified missed opportunities for lead campaigns that resulted in acquiring thousands of accounts and added a new operating method for Sales.
- Implemented new technologies across all business areas to automate processes, migrating legacy platforms into Blazor applications with SQL server backend, resulting in increased efficiency, reduced cost, and additional sales revenue.
- Implemented replication strategies in SQL and Azure, migrated to an availability group SQL cluster environment for data redundancy, and upgraded SQL server to 2022; ensuring disaster recovery, business continuity, and improved customer experiences.
- Managed complex T-SQL queries, views and stored procedures in multiple multi-database environments, maintaining high-quality code standards through rigorous testing and peer code reviews, minimizing potential bugs and security vulnerabilities.
- Moved the development team from a waterfall methodology to an Agile and Scrum methodology, bringing elements of DevOps ideology into business operations and bringing end users into the development life cycle; this increased development output efficiency, while ensuring user experience drives the product within the boundaries established by stakeholders.
- Optimized server resource usage by monitoring performance metrics and making necessary adjustments to SQL Server configurations, stored procedures, job maintenance, and SQL code, leading to more efficient processing times across various applications, removing deadlocks and system slows that result in diminished user experience, improving system stability.
- Provided technical support for end-users by addressing SQL and software related issues, enhancing overall user satisfaction with all applications.
- Mentored junior developers on best practices in SQL development, fostering a collaborative learning environment within the team and enhancing the value of existing staff.
- Managed database security by implementing appropriate access controls, maintaining compliance with industry regulations and company policies.
- Designed and developed customized extract, transform and load (ETL) applications per client specifications.
- Collaborated with stakeholders regarding project capabilities and limitations to deliver optimal functionality while assigning resources to projects that align with company directives.
Director of Accounts Management
American Power and Gas
07.2017 - 03.2020
- Restructured business unit by analyzing all processes for efficiency and improvement targets, then implementing operational changes.
- Mined and analyzed data from company databases to drive optimization and improvement of value proposition by assessing accuracy and identifying areas for improvement.
- Increased account enrollment KPI beyond industry standard resulting in significant additional income revenue with acceptance ratios exceeding 90% as a standard operating basis.
- Increased account monitoring KPI to a functional metric, ensuring all monitoring processes were complete and supported business direction, resulting in additional revenue streams exceeding 1,000,000.00 annually from streamlined billing opportunities and lost revenue opportunities.
- Implemented technical solutions within data processing to increase efficiency and comply with company data needs.
- Increased divisional efficiency by implementing system automation and standardized reporting metrics.
- Implemented data compliance standards, and proprietary automated algorithms, to ensure compliance with state and federal guidelines on telephone sales, eliminating all risk from potential violations.
- Increased area knowledge of industry standards and EDI communication, expanding the area to incorporate highly technical and specialized expertise, resulting in reducing account attrition by minimizing customer impact from failed communications or previous existing programming errors that needed resolution.
Securities Operations Specialist
Chase Investment Services
01.2010 - 12.2014
- FINRA registrations: Series 6, 26, 7, 24, 53, 65, 4
- Partnered with field financial advisors for complex financial product sales strategies
- Analyzed investment advisor strategies for client suitability
- Ensured regulatory compliance of investment advisor strategies and email communications
- Primary products targeted Mutual Funds, Stocks, Bonds, Variable Annuities, Options
Securities Operations Principal
Nationwide Financial
01.2004 - 01.2010
- FINRA registrations: Series 6, 26, 7, 24, 53, 65, 4
- Implemented and taught in house Series 6 registration learning classes for new staff.
- Assisted in Broker Dealer relocation from Maryland to Ohio, and implementation of business processes.
- Responsible for Independent Advisor channel throughout all of the United States
- Analyzed investment advisor strategies for client suitability
- Ensured regulatory compliance of investment advisor strategies and email communications
- Primary products targeted Mutual Funds, Advisory Services, Variable Annuities, Variable Life, and REITS
Skills
- Strategic Planning and Execution
- Process Analysis and Automation
- Operational Strategies and Implementation
- Risk Assessment and Mitigation
- Data Integrity and Management
- Agile Methodology
- System Optimization and Security
- Skilled communicator
- Data analytics and reporting
Certification
- SQL (SQL server, Azure, MySql, T-SQL, dynamic SQL)
- SQL Server Integration Services
- SQL Server Analysis Services
- SQL Server Reporting Services
- Log Shipping
- AlwaysOn Availability Groups
- Replication
- SQL Server Agent Management
- Query Optimization
- Index Maintenance
- Performance Tuning
- Disaster Recovery
- Database Design
- Database Development
- Data Modeling
- Code debugging
- SQL analytics
- SQL development
- Advanced SQL Queries
- Microsoft .Net
- Microsoft Visual Basic
- Powershell
- Blazor framework
- EDI X12 standards
- API management
- Jira, smartsheets, ticket management
Timeline
Vice President of Operations
American Power & Gas
03.2020 - Current
Director of Accounts Management
American Power and Gas
07.2017 - 03.2020
Securities Operations Specialist
Chase Investment Services
01.2010 - 12.2014
Securities Operations Principal
Nationwide Financial
01.2004 - 01.2010
- SQL (SQL server, Azure, MySql, T-SQL, dynamic SQL)
- SQL Server Integration Services
- SQL Server Analysis Services
- SQL Server Reporting Services
- Log Shipping
- AlwaysOn Availability Groups
- Replication
- SQL Server Agent Management
- Query Optimization
- Index Maintenance
- Performance Tuning
- Disaster Recovery
- Database Design
- Database Development
- Data Modeling
- Code debugging
- SQL analytics
- SQL development
- Advanced SQL Queries
- Microsoft .Net
- Microsoft Visual Basic
- Powershell
- Blazor framework
- EDI X12 standards
- API management
- Jira, smartsheets, ticket management
Similar Profiles
Gary StranskyGary Stransky
Hiring and Recruiting Manager at American Power & GasHiring and Recruiting Manager at American Power & Gas
Claudia ValdesClaudia Valdes
Customer Service Representatives at American Power and GasCustomer Service Representatives at American Power and Gas
Jannelle HaaseJannelle Haase
Customer Service Sales at American Power And GasCustomer Service Sales at American Power And Gas