Scott Newby Email & Phone Number

Mclean, Virginia, Us

Glen Allen, Virginia, Us

Solutions Architect at Markel Corporation.Utilizing technologies such as ELK - elastic / logstash / kibana for bdd & devops intelligence. Developing business solutions using; node.js, Ruby, JavaScript, SQL server & postgreSQL.

Project - Eagle-I (Environment for Analysis of Geolocated Energy Information). Technology - PostgreSQL, python, GIT, Microsoft SQL Server 2008 R2 - 2016, SSAS, SSRS, SSIS, T-SQL, ESRI ArcGIS, C#, JavaScript, IIS.Responsibilities - Responsible for improvements and ongoing maintenance of Eagle-I. Introduced OLAP star schema based data warehousing and reporting using SSAS and SSRS. Improved population coverage by 12%, and ETL performance by 40% by improving spatial query logic. Recently participated in migration from SQL Server to PostgreSQL database, along with migrating from SSIS packages to Python scripting for key components.

Project - Regulatory ReportingTechnology - Microsoft SQL Server 2012Responsibilities - On this short-term assignment, I was primarily responsible for designing databases and analyzing reports for federal reporting by the company. I also participated in data governance meetings and creating requirements for required reports.

Richmond, Va, Us

Project - TREDS (Traffic Records Electronic Data System)Technology - Microsoft SQL Server 2005, SSAS, SSIS, SSRS, T-SQL, ArcGIS, C#, JavaScript, IIS.Responsibilities - Introduced OLAP star schema data warehousing and reporting using SSAS and SSRS. Created many ETL routines for the import and export of system related data. Improved self-service access to data using SSRS Report Builder and semantic models, along with pre-defined parameterized reports. Incorporated ArcGIS to enhance geographic reporting within TREDS.

While working as a consultant for HMC through TEK Systems I was assignedtwo primary responsibilities; operational support of ongoing business processes using existing SSIS packages, and improving the SSIS packages used in those business processes.

Madison, Wi, Us

My initial responsibility at Ultratec was to redesign their billing system usingSQL Server. I redesigned the billing system using a Star Schema and working from business specifications provided by my manager. The system handled millions of rows of data, with greatly improved data access time to call detail records.I also completed a data warehouse project using Analysis Services in SQL Server 2000. This information was deployed through Excel using pivot tables.In 2006 I participated in our SQL Server 2005 migration. My role in this project was to ensure all functionality was duplicated in SQL Server 2005. I migrated DTS scripts into Integration Services (SSIS), Reporting Services and reports, and migrated our email notifications from using CDONTS to the new database mail component in SQL Server 2005.At the end of the migration I recreated our data warehouse database using SQL Server 2005 Analysis Services (SSAS). I also migrated our ETL processes from DTS to SSIS. System accounted for fourteen million rows of data spanning four years of call history information. Data warehouse data is quickly accessible using Excel pivot tables and Reporting Services for analysis.In late 2006, early 2007 I developed a new interface for captioned telephoneservice called Web CapTel. This new service gained FCC approval inDecember of 2006. The product uses a standard browser to provide captions to a hearing-impaired person, with the telephony provided by standard phone lines. I designed and developed the application using AJAX and ASP. I developed the interface, database, and underlying architecture for this new product using SQL Server 2005. Much of the development centered around using Windwws Mobile devices so the service could be delivered over a Smart Phone or PDA type device using Pocket Internet Explorer.

Detroit, Mi, Us

Technology Used: VB.NET, SQL, and SQL Server 2000Industry: Warehouse managementResponsibilities: Working from specifications provided by an EDCI project manager, my responsibilities included developing a Windows desktop application and redefining the SQL Server database table structure. I also created the stored procedures, business logic, and user interface for the database maintenance portion of the warehouse management system.

Madison, Wi, Us

Technology Used: ASP, VB, SQL, and Oracle 8iIndustry: AccountingResponsibilities: While working for the University I was responsible for application enhancements and maintenance. The enhancements were completed using ASP, VB, SQL, and Oracle 8i. During my employment I also participated in a large data migration project that involved heavy use of Informatica and Oracle 8i.

Technology Used: ASP, VB, and SQL ServerIndustry: E-commerce, SecurityResponsibilities: During my employment with Optimator I participated in projects as an application developer and team lead. I worked on Earthlogo.com as an application developer, developing ASP pages, business layer objects, and stored procedures. I was also responsible for the creation of use-case scenarios for the Earthlogo.com project. I also worked in a team lead capacity on a project for Risk Management Planning (RMP). In this capacity I was responsible for creating application specifications, technical specifications, prototyping application functionality, and directing the work of a small team.

Technology Used: VB, VBA, and AccessIndustry: Financial ServicesResponsibilities: While working for Prove IT, I was responsible for developing the first version of their ROI calculation software. I developed the application and managed the application installation process.

Technology Used: VB, VBA and AccessIndustry: Financial ServicesResponsibilities: While working at Merrill I was responsible for developing enhancements to their mutual fund reporting software. I developed and implemented enhancements to the system and managed the installation process using InstallShield. I also traveled to client sites to assist in the installation process and provide onsite assistance and trouble-shooting.

Technology Used: VB, Access, and SQL Server, Desktop applicationsIndustry: General BusinessResponsibilities: As a consultant for TTG I worked on general business applications. I developed two credit card application processing applications, one to work with John Deere Credit and another to work with Discover. These systems were developed using VB and Microsoft Access and interfaced with the respective companies. I also developed a sales force automation application for Mycogen Seed Company using VB and SQL Server.

Technology Used: VB, and Access, Desktop applicationIndustry: GovernmentResponsibilities: While working for the USDA I learned Visual Basic and Access, and was able to create an economic cost calculator using those technologies. I was also responsible for testing the application being developed.