John Corfield Email & Phone Number

Roanoke, Virginia Area

JC Initiatives provides Project Management, Business Analysis, Data Analysis, and Analytics consulting services in IT Application Development, Business Intelligence (BI), Data Warehousing (EDW), Location Intelligence, and Data Integration and Conversion.Partnered with The Anthony Group, Inc. to provide a Business Intelligence Assessment for The Branch Group, Inc. (holding company and 4 subsidiary regional infrastructure construction companies)Interviewed the CEO, CFO, business unit presidents, the finance, and IT teams to assess the corporation’s strategies, goals and business intelligence capabilitiesIdentified gaps in software, process, technology, and alignment of existing BI solutions with business requirements.Recommended actions needed to fill gaps in data architecture, tools, and solutions and provided high-level road map for implementation.

Roanoke

Contract through Information Technology Group, LLCThe remote assignment involved working as a key member of a large team working on a multi-million dollar migration and consolidation of circuit, network, and equipment data from multiple OSS systems into single inventory system.Scrum Master for a conversion development team delivering in 2 week sprintsDesigned transformation solutions and integration of multiple, concurrently developed subject areasElicited conversion requirements, analyzed source system data to devise solution, and provided functional requirements and guidance to development teamUsed advanced SQL skills to transform source data into loadable target system format and conducted quality assurance testingManaged conversion data model in Erwin, creating tables, views, keys, indices, constraints, triggers, sequences and generating DDLUnderstanding of complex relationships found in telecommunications data between circuits, networks, and equipmentEffective full-time remote contribution with multiple contract extensions

Roanoke, Va

Advance Auto Parts is a Fortune 300 company with a valuation of $12.5 billion, over 5,300 stores, and $10 billion in annual revenue. It is the largest aftermarket auto parts retailer in the country.Certified Scrum Master for 2 concurrent business intelligence development streams and scrum teams.Evangelized Agile SDLC methodology within Business Intelligence Systems department to efficiently develop, deploy, and deliver incremental value to the business every 4 weeks. Through the adoption of Agile SDLC we were able to shorten the delivery timeline significantly and maximize the value of business intelligence products for the businessSuccessfully delivered several projects and dozens of product releases on-time and on-budget expanding the business intelligence (BI) and Enterprise Data Warehouse (EDW) capabilitiesUtilized agile estimation techniques like planning poker and affinity estimation to work with product owners and scrum teams to develop estimates for product backlog itemsWorked with the product owners and stakeholders from Finance, Store Operations, Ecommerce, HR, Merchandising, and IT to set prioritization of product backlog based on estimated value, risk, and effortManaged and coached a team of business and IT resources, consultants, and 3rd party vendors through development process, collaboration, and issue resolutionTrained, mentored, and supported the BI Systems business analysts in data analysis, requirements gathering, documentation, and quality assurance testingReported development progress to management, business partners, and stakeholdersManaged projects in a matrix environment of functional and product managementIdentified, communicated, and mitigated risks and issues that arose with the development team and business partners

Roanoke, Va

Scrum Master for a Business Intelligence development scrum teamConducted source system data analysis, data profiling, and quality assurance testing through extensive use of SQLInterviewed business and IT partners to gather and document business process, systems process, source to target mappings, business and functional requirements Worked with data from several disparate data sources in different database environments such as Oracle, DB2, AS400, and SQL Server.Served as the subject matter expert on Enterprise Data Warehouse dataConducted root cause analysis and resolved issues with the support team, business, and IT partnersCollaborated in the architectural design of the dimensional and fact table data model and product solutions in OBIEE, and Business Objects

Roanoke, Va

Elicited and documented business, system, data security, and functional requirements from Business and IT partnersProfiled and conducted data analysis on source system dataDeveloped mock-ups of dashboards and prototyped SQL for data transformationWorked with developers to ensure that requirements are understood and questions are answeredConducted data quality assurance testing to ensure that requirements were met.

Roanoke, Virginia Area

Conceptualized, designed, and developed Advance Auto Parts automated sales forecasting methods and market optimization systems used in the evaluation of nearly 800 sites annually and nearly doubling Research team’s forecast productionDeveloped competitor and sister-store sales impact estimation applications which allowed the company to maximize the revenue generated from the store networkRegularly used statistical analysis (correlation, regression, time series analysis, ANOVA, and CHAID) to identify patterns in sales and customer behavior, customer profiling, competitive impact, and forecast model developmentManaged the analytical support staff and projects of the departmentManaged and negotiated vendor resources and data and software contractsPresented analytical results to senior managementRegularly contributed to strategic corporate initiatives (such as the launch of the Commercial Sales and Custom Mix Initiatives) and strategic planningDeveloped and managed the Real Estate project tracking and reporting database greatly enhancing communication of status within the Real Estate Department and saving significant resource timeProvided analytical support to various business units of the company including Marketing, Merchandising, Operations, Human Resources, and Commercial SalesManaged the company’s GIS (Geographic Information Systems) capabilities and programmed customizationsDeveloped and managed the corporate competitive database and reporting

Seattle, Wa

Washington Mutual was the largest thrift in the country operating 2,600 banking storesDeveloped methodology for proactively identifying and determining network fit of acquisition candidatesBuilt a predictive model for forecasting new branch depositsContributed to the development of the company’s 2007 new store plan including market prioritization and analysis of existing real estate pipeline and communicated it to the management teamPartnered with the Finance team to develop a financial model used to estimate new store performance and return on investment

Roanoke, Va

Conceptualized, designed, and developed Advance Auto Parts automated sales forecasting methods and market optimization systems used in the evaluation of nearly 800 sites annually and nearly doubling Research team’s forecast productionDeveloped competitor and sister-store sales impact estimation applications which allowed the company to maximize the revenue generated from the store networkRegularly used statistical analysis (correlation, regression, time series analysis, ANOVA, and CHAID) to identify patterns in sales and customer behavior, customer profiling, competitive impact, and forecast model developmentManaged the analytical support staff and projects of the departmentManaged and negotiated vendor resources and data and software contractsPresented analytical results to senior managementRegularly contributed to strategic corporate initiatives (such as the launch of the Commercial Sales and Custom Mix Initiatives) and strategic planningDeveloped and managed the Real Estate project tracking and reporting database which greatly enhanced communication of status within the Real Estate Department and saved significant resource timeProvided analytical support to various business units of the company including Marketing, Merchandising, Operations, Human Resources, and Commercial SalesManaged the company’s GIS (Geographic Information Systems) capabilities and programmed customizationsDeveloped and managed the corporate competitive database and reporting

Ann Arbor, Mi

Thompson Associates was a leading consulting company specializing in retail strategic planning, expansion, and location analysis. My clients included The Home Depot, Kohl’s, Don Pablos, Avenue, Krystal Hamburgers, and others.Management of statistical research and forecast systems development projectsDeveloped store maturity and sales trending tools and methods, as well as conducted analysisUsed statistical methodologies and techniques in customer profile development and sales forecastingPresented analytical results to clients in group management sessions

Ann Arbor, Mi

Forecasted sales projections for existing and future retail developmentsConducted cannibalization and competitive transfer analysisCompiled market data obtained through fieldwork, market vendors, and sourcesWrote market analysis reports providing sales forecasts and recommendations

Norton Shores, Mi

Horizon Group is a real estate investment trust specialized in the ownership and management of outlet centers and other retail properties throughout the United States.Coordinated and managed market and consumer research efforts for all real estate propertiesAuthored customer intercept surveys, interviewed customers, and presented analytical findings to executive staffAcquired, implemented, and managed company’s GIS systemConducted site selection analysis and fieldwork of proposed marketsProvided analytic support to various business units including Marketing, Real Estate. Leasing, Operation, and Investor RelationsProduced customized leasing packages for different types of prospective retail tenants