John Chandler

Background

About John Chandler

I have 20 years of experience analyzing data and providing actionable reporting to both operational and senior managers. I am an experienced business systems analyst and have worked on discovery and documentation of requirements, and development of test plans for application and database enhancements. I worked at a senior level in process redesign in support of new and upgraded software, and for streamlining processes with the goal of improved service and data quality. I have served as a trained project manager and have led successful projects for both new software products and software upgrades. Skills and Experience • Experienced in discovery of requirements and translation of requirements into a finished product • Experienced at a senior level in process analysis and redesign • Trained and experienced project manager; have led projects using Agile and Waterfall methodologies • High level data analysis and data mapping skills • Extensive database design and ETL experience (SSIS and Informatica PowerCenter) • Experienced report developer - tools include SQL Server Management Studio, T-SQL, Crystal Reports, SQL Server Reporting Services (SSRS), Tableau, Highcharts, JavaScript and Excel • Have sourced and combined data from multiple database types including MS SQL Server, Oracle, MySQL and Informix • Have worked with multiple database designs including databases used for transactional processing and data warehouses • Many years of experience writing advanced level SQL queries to support reporting and analytics Specialties: Application Development and Implementations, IT Project Management, Process Analysis and Redesign, Data Analysis, Database Design and Implementation, MS SQL Server, SQL Server Management Studio, T-SQL, SQL Server Integration Services (SSIS), Informatica PowerCenter, ETL, Crystal Reports, SQL Server Reporting Services (SSRS), Business Intelligence, Tableau, MS Office