John Kozar Email & Phone Number

Washington, Dc

I specialize in data visualization and SQL Server programming for data exploration, testing, and program management. I work with federal, state, and local government agencies as well as private firms to design, develop and test tools to meet their data, research, and policy-making needs.• Design and develop Tableau data analytic tools to allow clients to explore data related to youth behavioral risks and child welfare/foster care• Planned and lead a series of Tableau training sessions for beginning users to grow their skillset• Develop QlikView dashboards both for clients as well as for internal labor and cost tracking• Use ArcGIS to produce county level visualizations of National Free School Lunch Program (NSLP) data for presentation to U.S. Congress• Ad hoc D3 data visualization development• SQL server programming (queries, procedures, database administration) to develop customized tools for testing and program management• Serve as task/team lead for specification development and testing cycles for web application releases• Develop program specifications for performance measurement, reporting, and functionality

I built analytic tools to examine our operations, identify areas needing increased efficiency and implement improved processes. Predictive modeling and forecasting business based on market information, historic data trends, and upcoming company initiatives. I evaluated revenue, event registration rates, and other data and brief company leaders with conclusions.• Developed models to analyze and forecast revenue, customer purchasing habits, and event registrations and calculate return on investment for potential new products and initiatives• Created interactive visualizations of data to efficiently show trends and fuel business decisions• Designed, built and automated tools to measure operating performance/trends and increase efficiency• Created annual and quarterly revenue and business forecasts• Examined buying habits to better understand customer retention• Generated weekly and monthly sales summaries for CEO and board with comparisons to forecasts• Continually identify new metrics to measure and understand the market and our business• Create new data reports and customize existing ones to meet specific needs, often ad hoc/upon request, for business analysis• Developed a series of reporting tools that enabled employees to run data reports independently and decrease a bottleneck of requests • Served as lead for 2011 project to achieve company-wide credit card security compliance

• Maintained and updated sales/customer database• Designed and implemented a system for calculating and collecting sales tax and generating and submitting tax returns to states and integrated it into existing processes• Oversaw day-to-day operations of sales and use tax collection/submission system to ensure compliance with 38 states' requirements• Managed product inventory in 3 warehouses, forecasted demand to appropriately time ordering of new materials, and coordinated receipts of new materials and transfers between locations to accommodate demand • Collected and prepared data to measure operations success and efficiency for presentation to management• Researched, prepared, and executed Voluntary Disclosure Agreements to settle owed sales tax balances for prior years in 6 states• Reconciled sales, payments received, and balances outstanding for 11 state book depositories

Alexandria, Va

Washington D.C.