Michael Forster Email & Phone Number

New York, Ny, Us

London, Gb

-Conceived and led the development of an application to allow clients to automate the process of extracting data from their existing systems and transfer the resulting data files to various Pearson applications via SFTP.-Added support into our data loading application for integration with other school system APIs to extract and send data between any number of systems.-Conceived and created an add-on to our data loading application that allows clients to create templates for mapping and loading standardized testing data from their original vendor source files, saving those templates to a reusable library for other clients to download.-Developed an API to allow clients to transmit school data directly to our staging servers.-Developed an application for transforming XML test item files from one format to another, saving the company on costs from outside contractors. -Refactoring and enhancement of our Schoolnet software’s ETL application, improving maintainability, scalability and performance.-Led the development of a series of applications used to manage the flow of all incoming client SFTP data files, transporting data to loading servers, merging data files from multiple sources and maintaining a loading queue.-Redesigned all ETL processing reports to be dynamically created as HTML reports generated from a reusable component that I created. -Developed an automated distribution process for updating our data loading application and its configuration files, allowing us the ability to remotely control a client’s extractions. -Developed new and converted old tools using the Go language for performing custom data transformations and ETL operations.-Responsible for overseeing the transition of all clients to newly developed technologies.-Wrote extensive technical and training documentation. -Developed a dashboard application for monitoring the status of data loading tasks, giving our teams quick access to essential information.

Miami, Florida, Us

• Worked on the company's primary marketing analytical tool using Silverlight 3, VB.NET, Visual Studio 2008 and SQL Server 2008. This application was developed for and sold to major consumer product and service companies to report on advertising and promotional effectiveness metrics through various charts and data grids, as well as performing some forecasting functionality.• I conceived and developed a centralized tool for importing and managing application data using Silverlight 3, C# and SQL Server2008, to address some of the company’s major data processing inefficiencies.• Integrated a .NET web application, developed in C# at our Dublin office, with the company's primary marketing analytic tool.• Used SQL Server to imported and query large datasets, numbering over 150 million records, from sources such as IRI and Neilson, for use by the company's analysis teams.• Developed a forecasting tool in Silverlight/VB.NET, using SQLServer and KDCalc on the backend.• Created detailed SSIS packages for transferring development/staging data into production.• Performing most of the DBA related work including security, backups and other scheduled maintenance.• Helped to build a better development environment, by introducing tools such as source control and creating documentation.

• Converted the company’s legacy financial reporting application from Access to SQL Server.• Led the transition to Visual Studio 2005 and the 2.0 .NET Framework.• Led the transition to SQL Server 2005 and the use of SQL Reporting Services.• Led the implementation of SQL 2005 Analysis Services, creating multiple cubes for financial and property reporting.• Installed and led the implementation of Sharepoint Services 2007, used primarily as knowledge base for the entire company.• Helped maintain the company website as well applications on its intranet and extranet.• Developed and converted various applications using Visual Basic .NET and Visual Studio 2005 including an application for generating barcodes that was used to scan documents into the company’s vast library.

• Converted the company’s legacy financial reporting application from Access to SQL Server.• Led the transition to Visual Studio 2005 and the 2.0 .NET Framework.• Led the transition to SQL Server 2005 and the use of SQL Reporting Services.• Led the implementation of SQL 2005 Analysis Services, creating multiple cubes for financial and property reporting.• Installed and led the implementation of Sharepoint Services 2007, used primarily as knowledge base for the entire company.• Helped maintain the company website as well applications on its intranet and extranet.• Developed and converted various applications using Visual Basic .NET and Visual Studio 2005 including an application for generating barcodes that was used to scan documents into the company’s vast library.

Chicago, Illinois, Us

New York, Ny, Us

New York, New York, Us

Paris, France, Fr