Todd K.
Director of Data Analytics at University Support Services (USS)- Claim this Profile
Click to upgrade to our gold package
for the full feature experience.
Topline Score
Bio
Rich McQuillen
I've had the privilege of working with Todd at two different companies. He is very dedicated and hardworking. He has a passion for numbers and data analysis. He has had exposure to multiple different IT systems, and is always coming up with new and better ways to expand and grow his systems and environment. He is very personable and a team-player, and easy to get along with. I can't say enough good things about Todd.
Scott Barrie
Todd is bright and articulate, thorough in his analysis of situations and a team player. In his B2B sales/business development role attention to detail was a strong attribute he displayed. Todd demonstrated an enthusiastic attitude and would be an asset to any organization.
Rich McQuillen
I've had the privilege of working with Todd at two different companies. He is very dedicated and hardworking. He has a passion for numbers and data analysis. He has had exposure to multiple different IT systems, and is always coming up with new and better ways to expand and grow his systems and environment. He is very personable and a team-player, and easy to get along with. I can't say enough good things about Todd.
Scott Barrie
Todd is bright and articulate, thorough in his analysis of situations and a team player. In his B2B sales/business development role attention to detail was a strong attribute he displayed. Todd demonstrated an enthusiastic attitude and would be an asset to any organization.
Rich McQuillen
I've had the privilege of working with Todd at two different companies. He is very dedicated and hardworking. He has a passion for numbers and data analysis. He has had exposure to multiple different IT systems, and is always coming up with new and better ways to expand and grow his systems and environment. He is very personable and a team-player, and easy to get along with. I can't say enough good things about Todd.
Scott Barrie
Todd is bright and articulate, thorough in his analysis of situations and a team player. In his B2B sales/business development role attention to detail was a strong attribute he displayed. Todd demonstrated an enthusiastic attitude and would be an asset to any organization.
Rich McQuillen
I've had the privilege of working with Todd at two different companies. He is very dedicated and hardworking. He has a passion for numbers and data analysis. He has had exposure to multiple different IT systems, and is always coming up with new and better ways to expand and grow his systems and environment. He is very personable and a team-player, and easy to get along with. I can't say enough good things about Todd.
Scott Barrie
Todd is bright and articulate, thorough in his analysis of situations and a team player. In his B2B sales/business development role attention to detail was a strong attribute he displayed. Todd demonstrated an enthusiastic attitude and would be an asset to any organization.
Experience
-
University Support Services, an affiliate of St. George's University
-
United States
-
Higher Education
-
1 - 100 Employee
-
Director of Data Analytics
-
Jul 2022 - Present
-
-
-
Arise
-
United States
-
Outsourcing and Offshoring Consulting
-
700 & Above Employee
-
Sr. Manager, Business Intelligence
-
Apr 2021 - Jul 2022
• Grew a team of 7 developers to 21 developers, BI Specialists, and Data Scientists that specialize in building reporting infrastructure and scalable enterprise reporting solutions focusing on high business value impacting projects using the agile methodology and Kanban • Responsible for all dept road mapping, prioritization, production, maintenance, governance, enablement, consultation and documentation of reporting • Established a development process complete with operational rigor… Show more • Grew a team of 7 developers to 21 developers, BI Specialists, and Data Scientists that specialize in building reporting infrastructure and scalable enterprise reporting solutions focusing on high business value impacting projects using the agile methodology and Kanban • Responsible for all dept road mapping, prioritization, production, maintenance, governance, enablement, consultation and documentation of reporting • Established a development process complete with operational rigor, development rules, meeting sequences, job descriptions, and process documentation to ensure transparency • Oversees the transformation from an OLAP architecture to a self-service BI Architecture by creating reporting suites by functional area that include 50+ reports, 200+ pages, and over 5000+ views per month using Power BI, Anaplan, and R Scripts • Groomed and developed resources to share a collective set of values that transformed the group from several sub-teams with little interaction, to one large organization that is tightly knit. • Assisted in the implementation and reporting for enterprise Data Governance program and an initiative to kill the excel spreadsheet. My skillset includes the following •Project Queue Management •Documentation Management •Business Case development •Agile/Scrum Management •Data Integration •Reporting Estate Management •Requirements Management •Content Management •Knowledge of BI Reporting Tools •Complex Problem Solving •Resource Allocation •Data Governance Reporting Tools in use: Azure Cloud Power BI Anaplan
-
-
Senior Analyst BI/Anaplan Developer
-
May 2016 - Apr 2021
• Architected and developed multidimensional Anaplan models for Forecasting, KPI Scorecarding, and Call Center Planning • Set up automation frameworks, tools and methodology to streamline automation using Anaplan Connect and a series of batch files. • Created work estimates and functional designs based on requirements focusing on ROI and solutioning for a well-defined business case • Created a support ticketing system for support requests to allow users to submit tickets within each… Show more • Architected and developed multidimensional Anaplan models for Forecasting, KPI Scorecarding, and Call Center Planning • Set up automation frameworks, tools and methodology to streamline automation using Anaplan Connect and a series of batch files. • Created work estimates and functional designs based on requirements focusing on ROI and solutioning for a well-defined business case • Created a support ticketing system for support requests to allow users to submit tickets within each multidimensional cube • Organized and led monthly roundtables with multiple teams to drive adoption of the platform • Translated business goals, feature concepts and customer needs into prioritized product requirements and use cases.
-
-
-
KeyDMS
-
Software Development
-
Operations and Development Manager
-
Jun 2013 - Nov 2015
• Managed a team of 5 designers (User Experience Specialist, Graphic Artist and 2 UI Developers) as well as managed offshore 3rd party development team for integration or web application to database layer(s), also including business analysts, application configuration, product testing, software delivery, system installation and change management • Created the process workflow for our web-based application which allowed customers to facilitate a real estate transaction from start to finish… Show more • Managed a team of 5 designers (User Experience Specialist, Graphic Artist and 2 UI Developers) as well as managed offshore 3rd party development team for integration or web application to database layer(s), also including business analysts, application configuration, product testing, software delivery, system installation and change management • Created the process workflow for our web-based application which allowed customers to facilitate a real estate transaction from start to finish and collaborate with all types of real estate professionals in real time • Created application within Amazon Web Services (AWS) cloud including heavy involvement in creation of the entire production server • Created over 150+ digital documents which allows users to automate submission of forms online within the web application • Integrated a 3rd party Signature software with their APIs as well as several other customized APIs in order to best utilize systems • Responsible for managing all aspects of delivery, including managing scope, budget and plan against contract Show less • Managed a team of 5 designers (User Experience Specialist, Graphic Artist and 2 UI Developers) as well as managed offshore 3rd party development team for integration or web application to database layer(s), also including business analysts, application configuration, product testing, software delivery, system installation and change management • Created the process workflow for our web-based application which allowed customers to facilitate a real estate transaction from start to finish… Show more • Managed a team of 5 designers (User Experience Specialist, Graphic Artist and 2 UI Developers) as well as managed offshore 3rd party development team for integration or web application to database layer(s), also including business analysts, application configuration, product testing, software delivery, system installation and change management • Created the process workflow for our web-based application which allowed customers to facilitate a real estate transaction from start to finish and collaborate with all types of real estate professionals in real time • Created application within Amazon Web Services (AWS) cloud including heavy involvement in creation of the entire production server • Created over 150+ digital documents which allows users to automate submission of forms online within the web application • Integrated a 3rd party Signature software with their APIs as well as several other customized APIs in order to best utilize systems • Responsible for managing all aspects of delivery, including managing scope, budget and plan against contract Show less
-
-
-
Citrix
-
United States
-
Software Development
-
700 & Above Employee
-
Senior Operations Analyst-Technical Escalation
-
Sep 2012 - Jun 2013
Responsible for gathering data, managing data, providing technical analysis, and implementation for reporting solutions utilizing the SQL Server 2008 Reporting Services. Responsibilities: Analyze and develop reporting solutions to fulfill business requirements for projects of significant scope and complexity. Support delivery and deployment of defined technical solutions. Communicate accurate and timely project status, issues, risks and scope changes to the Project Managers. Provide… Show more Responsible for gathering data, managing data, providing technical analysis, and implementation for reporting solutions utilizing the SQL Server 2008 Reporting Services. Responsibilities: Analyze and develop reporting solutions to fulfill business requirements for projects of significant scope and complexity. Support delivery and deployment of defined technical solutions. Communicate accurate and timely project status, issues, risks and scope changes to the Project Managers. Provide effort estimation, status reporting, and conduct design reviews. I facilitate data to Operations Analysts via SQL Server to replace the current process of data pulls in a more efficient manner. I am also a large contributor to the building of a data warehouse that will contain all Operations Data to serve multiple departments. Currently I am building that SQL Server to host the data required to deliver it to multiple users, using Tableau Desktop and Tableau Sever as well as access for SQL querying. I am currently the owner of these DB's as we move towards a production environment and the Administrator of Tableau. I am responsible for the all data and performance of this server. Show less Responsible for gathering data, managing data, providing technical analysis, and implementation for reporting solutions utilizing the SQL Server 2008 Reporting Services. Responsibilities: Analyze and develop reporting solutions to fulfill business requirements for projects of significant scope and complexity. Support delivery and deployment of defined technical solutions. Communicate accurate and timely project status, issues, risks and scope changes to the Project Managers. Provide… Show more Responsible for gathering data, managing data, providing technical analysis, and implementation for reporting solutions utilizing the SQL Server 2008 Reporting Services. Responsibilities: Analyze and develop reporting solutions to fulfill business requirements for projects of significant scope and complexity. Support delivery and deployment of defined technical solutions. Communicate accurate and timely project status, issues, risks and scope changes to the Project Managers. Provide effort estimation, status reporting, and conduct design reviews. I facilitate data to Operations Analysts via SQL Server to replace the current process of data pulls in a more efficient manner. I am also a large contributor to the building of a data warehouse that will contain all Operations Data to serve multiple departments. Currently I am building that SQL Server to host the data required to deliver it to multiple users, using Tableau Desktop and Tableau Sever as well as access for SQL querying. I am currently the owner of these DB's as we move towards a production environment and the Administrator of Tableau. I am responsible for the all data and performance of this server. Show less
-
-
-
Imperial Brands PLC
-
United Kingdom
-
Manufacturing
-
700 & Above Employee
-
Technical Data Analyst
-
Nov 2011 - Jun 2012
• Developed and Maintained Pricing Database that held pricing data for all of 2011 and 2012 by week. • Created Sql queries from multiple systems to pull data on a daily, weekly, and monthly timeframe • Converted C-SQL to T-SQL to work in new Microsoft SQL Server 2 • Optimized and automated queries to run faster for large data pulls from data warehouses located all over the world. • Completed analysis for pricing and distribution in a multitude of ways from Pricing in certain… Show more • Developed and Maintained Pricing Database that held pricing data for all of 2011 and 2012 by week. • Created Sql queries from multiple systems to pull data on a daily, weekly, and monthly timeframe • Converted C-SQL to T-SQL to work in new Microsoft SQL Server 2 • Optimized and automated queries to run faster for large data pulls from data warehouses located all over the world. • Completed analysis for pricing and distribution in a multitude of ways from Pricing in certain states, competitive pricing analysis, Competitive Program Analysis, Distribution Analysis, Weighted Average pricing analysis, and Worldwide Geographic Analysis, etc. • Invloved in a team that created a new Hierarchy and table structure for a new SSIS database housed in the US. Show less • Developed and Maintained Pricing Database that held pricing data for all of 2011 and 2012 by week. • Created Sql queries from multiple systems to pull data on a daily, weekly, and monthly timeframe • Converted C-SQL to T-SQL to work in new Microsoft SQL Server 2 • Optimized and automated queries to run faster for large data pulls from data warehouses located all over the world. • Completed analysis for pricing and distribution in a multitude of ways from Pricing in certain… Show more • Developed and Maintained Pricing Database that held pricing data for all of 2011 and 2012 by week. • Created Sql queries from multiple systems to pull data on a daily, weekly, and monthly timeframe • Converted C-SQL to T-SQL to work in new Microsoft SQL Server 2 • Optimized and automated queries to run faster for large data pulls from data warehouses located all over the world. • Completed analysis for pricing and distribution in a multitude of ways from Pricing in certain states, competitive pricing analysis, Competitive Program Analysis, Distribution Analysis, Weighted Average pricing analysis, and Worldwide Geographic Analysis, etc. • Invloved in a team that created a new Hierarchy and table structure for a new SSIS database housed in the US. Show less
-
-
-
Sun Sentinel Media Group
-
United States
-
Newspaper Publishing
-
300 - 400 Employee
-
Database Marketing Analyst
-
Jun 2008 - May 2012
• Developed and Maintained 200+ SQL queries and Business Object Reports that ran Daily, Monthly, Quarterly, and Annually, showing subscriber Acquisition and Retention trends for the Sun Sentinel and Orlando Sentinel. • Responsible for 40+ Automated and Independent Weekly Reports, their Accuracy, Construction and Maintenance for Management Team. • Re-Created and Maintained a Collections Reporting Database and Program that processed Daily Payments, Disputes and Write offs of entire… Show more • Developed and Maintained 200+ SQL queries and Business Object Reports that ran Daily, Monthly, Quarterly, and Annually, showing subscriber Acquisition and Retention trends for the Sun Sentinel and Orlando Sentinel. • Responsible for 40+ Automated and Independent Weekly Reports, their Accuracy, Construction and Maintenance for Management Team. • Re-Created and Maintained a Collections Reporting Database and Program that processed Daily Payments, Disputes and Write offs of entire Collections program as well as giving full YOY analysis. • Database Analyst for the Marketing Mobile Team to develop ways to monetize the paper through mobile media and the newest technology coming out, up and including tablets and phones. • Re-structured Collections 3rd party Contract that resulted in substantial savings from January 1, 2009 to June 27, 2011, profitability increased from Collections Program by 40.5% in 2009 to 148% increased profitability in 2011. • Worked with key Circulation Managers to define database marketing analysis of Sun Sentinel Subscribers to identify subscriber trends and recommend programs to address emerging trends that provided useful marketing decision-support information. • Coordinated all aspects of targeted Subscriber Acquisition programs generated from all sources. • Developed prospect lists based on analysis, and defined output requirements to ensure quality contact list. • Developed effective Creative and Response Analysis process to measure campaign success for both the Sun Sentinel and Orlando Sentinel. • Provided mapping and modeling services to circulation division using the latest software tools and techniques available. • Provided maps to circulation showing geographic subscriber trends and used modeling software to identify best customers that should be targeted for increased sales and longer retention. • Acted as liaison between circulation and database marketing communicating project status, priorities and upcoming events. Show less • Developed and Maintained 200+ SQL queries and Business Object Reports that ran Daily, Monthly, Quarterly, and Annually, showing subscriber Acquisition and Retention trends for the Sun Sentinel and Orlando Sentinel. • Responsible for 40+ Automated and Independent Weekly Reports, their Accuracy, Construction and Maintenance for Management Team. • Re-Created and Maintained a Collections Reporting Database and Program that processed Daily Payments, Disputes and Write offs of entire… Show more • Developed and Maintained 200+ SQL queries and Business Object Reports that ran Daily, Monthly, Quarterly, and Annually, showing subscriber Acquisition and Retention trends for the Sun Sentinel and Orlando Sentinel. • Responsible for 40+ Automated and Independent Weekly Reports, their Accuracy, Construction and Maintenance for Management Team. • Re-Created and Maintained a Collections Reporting Database and Program that processed Daily Payments, Disputes and Write offs of entire Collections program as well as giving full YOY analysis. • Database Analyst for the Marketing Mobile Team to develop ways to monetize the paper through mobile media and the newest technology coming out, up and including tablets and phones. • Re-structured Collections 3rd party Contract that resulted in substantial savings from January 1, 2009 to June 27, 2011, profitability increased from Collections Program by 40.5% in 2009 to 148% increased profitability in 2011. • Worked with key Circulation Managers to define database marketing analysis of Sun Sentinel Subscribers to identify subscriber trends and recommend programs to address emerging trends that provided useful marketing decision-support information. • Coordinated all aspects of targeted Subscriber Acquisition programs generated from all sources. • Developed prospect lists based on analysis, and defined output requirements to ensure quality contact list. • Developed effective Creative and Response Analysis process to measure campaign success for both the Sun Sentinel and Orlando Sentinel. • Provided mapping and modeling services to circulation division using the latest software tools and techniques available. • Provided maps to circulation showing geographic subscriber trends and used modeling software to identify best customers that should be targeted for increased sales and longer retention. • Acted as liaison between circulation and database marketing communicating project status, priorities and upcoming events. Show less
-
-
-
Bayview Financial
-
United States
-
Financial Services
-
200 - 300 Employee
-
Business Developement
-
2006 - 2008
• Successfully established a new client base independently as an outside representative. • Managed territories consisting of all mortgage companies in Broward and Palm Beach County. • Executed business plans and maintained production goals. • Taught Marketing and Ad campaigns for mortgage companies to solicit commercial loans through direct mail, creation of collateral, canvassing and other marketing techniques. • Submitted loans for pre-approval and managed a… Show more • Successfully established a new client base independently as an outside representative. • Managed territories consisting of all mortgage companies in Broward and Palm Beach County. • Executed business plans and maintained production goals. • Taught Marketing and Ad campaigns for mortgage companies to solicit commercial loans through direct mail, creation of collateral, canvassing and other marketing techniques. • Submitted loans for pre-approval and managed a pipeline. • Contributed in closing commercial loans. • Assisted in the production of Business Building, Sales, and Marketing Seminars. Show less • Successfully established a new client base independently as an outside representative. • Managed territories consisting of all mortgage companies in Broward and Palm Beach County. • Executed business plans and maintained production goals. • Taught Marketing and Ad campaigns for mortgage companies to solicit commercial loans through direct mail, creation of collateral, canvassing and other marketing techniques. • Submitted loans for pre-approval and managed a… Show more • Successfully established a new client base independently as an outside representative. • Managed territories consisting of all mortgage companies in Broward and Palm Beach County. • Executed business plans and maintained production goals. • Taught Marketing and Ad campaigns for mortgage companies to solicit commercial loans through direct mail, creation of collateral, canvassing and other marketing techniques. • Submitted loans for pre-approval and managed a pipeline. • Contributed in closing commercial loans. • Assisted in the production of Business Building, Sales, and Marketing Seminars. Show less
-
-
-
US Army
-
United States
-
Armed Forces
-
700 & Above Employee
-
54B Chemical Operations Specialist
-
Nov 1999 - Apr 2001
I was in charge of the Chemical, Biological, and Nuclear Equipment and Training for 3 Transportation Units located in MD, VA, and PA. I trained all Ranks in BIO, Chemical, and Nuclear Detection, Decontamination, Protection. I ran all training and conducted inventory for support of all 3 units. I also had the equivalent of a CDL to drive oversized vehicles and was the Captains driver of my main transportation unit. I was in charge of the Chemical, Biological, and Nuclear Equipment and Training for 3 Transportation Units located in MD, VA, and PA. I trained all Ranks in BIO, Chemical, and Nuclear Detection, Decontamination, Protection. I ran all training and conducted inventory for support of all 3 units. I also had the equivalent of a CDL to drive oversized vehicles and was the Captains driver of my main transportation unit.
-
-
Education
-
Montgomery College