Robert W. Staples, Iii., P.E., Mcse, Mcsa Email & Phone Number

Glen All

•Maintain, update, develop, design, test and implement SSIS ETL packages and Stored Procedures that take data from various sources and store it in the database for use by downstream application and reporting.•Maintain, update, develop, design, test and implement SSRS reports that use T-SQL queries and Stored Procedures to serve the company’s reporting needs.•Write T-SQL queries to pull data out of SQL Server databases in support of downstream uses.•Maintain, update, develop, design, test and implement Cognos Analytics reports used in our HR system.•Modify VB.Net code in a ASP.Net application to accommodate changes in source files that required different handling by the application.•Provide documentation and explanations to auditors for the SOX audit regarding the Meter Data Management (MDM) financial wholesale billing system.•Participated in interviews for a developer & DBA position and made hiring recommendations to management.

Glen Allen, Va

•Maintained, updated, developed, designed, tested, and implemented SSIS ETL packages and Stored Procedures that take data from various sources and store it in the database for use downstream.•Maintained, updated, developed, designed, tested, and implemented SSRS reports that use T-SQL queries and Stored Procedures to serve the company’s reporting needs.•Developed a C# ASP.NET MVC application from the ground up using a SQL Server 2017 database.•Developed Python code to download information from PJM MSRS and output it to CSV files.•Wrote T-SQL queries to pull data out of SQL Server databases in support of downstream uses.•Maintained, updated, developed, designed, tested, and implemented Cognos Analytics reports used in our HR system.•Created a Microsoft Access database to perform Benefits Reconciliation between two systems in HR.•Modified VB.Net code in a ASP.Net application to accommodate changes in source files that required different handling by the application.•Provided documentation and explanations to auditors for the SOX audit regarding the Meter Data Management (MDM) financial wholesale billing system.•Participated in interviews for a developer position and made hiring recommendations to management.

Richmond, Virginia Area

•Maintained, updated, developed, designed, tested, and implemented SSIS ETL packages and Stored Procedures that take data from the database and generate extracts and add information to the database.•Wrote dynamic SQL queries to perform data updates in the database to be used by the application.•Wrote SQL queries to pull data out of SQL Server databases in order to fulfill information requests and perform analysis.•Checked in and merged software code to Development, UAT and Production areas using TFS to ensure code meets SQL Server requirements and to place code in the proper location for Production releases.•Created, tracked, updated, and communicated status of tasks daily in the Rally tool and verbally in the Stand-Up for every 2-week sprint per Agile methodology.

Richmond, Virginia Area

•Maintained, updated, developed, designed, tested and implemented SQL Server Integration Services (SSIS) ETL packages that take data from Virginia Department of Transportation (VDOT) Advanced Transportation Management Systems (ATMS) systems and an Intelligent Transportation system (ITS) to make sure that our company adheres to VDOT’s Service-Level Agreements (SLAs).•Maintained, updated, developed, designed, tested and implemented SSRS reports that use both SQL Server Analysis Services (SSAS) cubes and T-SQL that serve the company’s reporting needs.•Collaborated with upper management to develop, design and implement ideas for Key Performance Indicators (KPIs).•Improved the usability and functionality of the Program Vision (VisionWaves Delta product) application by continuing to develop methods for determining incident types and to properly aliasing the raw data.•Worked with the vendor of the Program Vision application to improve the user experience of the application itself through business intelligence enhancements and vendor patch releases.•Provided training to Serco and VDOT employees on the Program Vision application.

Richmond, Virginia Area

I was part of an Agile team and acted as the liaison between the project team and the business owners. Used SQL queries to confirm data conformed to the company's standards. Performed high-level data of new information going into the system. Created defects discovered in different stages of testing. Developed test cases used by the business team to ensure deliverables by the project team were correct. Collected metadata for new information going into the system. Conducted training for Capital One end users on the new information going into the system.

United States

Wrote SQL queries to extract data out of the system. Maintained, updated, developed, designed, tested and implemented Business Intelligence (BI) reporting solutions. Created a Microsoft Access database that used Visual Basic code to track one of our department’s Key Performance Indicators (KPIs). Revised Visual Basic code in a Microsoft Excel application to meet the department's needs. Supported personnel in multiple departments regarding production data needs. Represented the department in various internal meetings to assess the impact of expected software patches on the department’s reports and the impact of projects for the department.

Taylor Tx

Wrote SQL queries to extract data out of the system. Verified and validated that the system and application are working as expected in Production after maintenance. Collected data to support external audit requirements. Conducted Daylight Savings Time (DST) testing and validation on the system I supported. Updated a department Operating Procedure to be in line with changes in best practices and to align with rule changes. Tested and documented results for new code being released into the system. Represented the department in various internal meetings to maintain awareness of upcoming software patches and reports.

Wrote SQL queries to extract data out of the system. Collected data to support external audit requirements. Conducted Daylight Savings Time (DST) testing and validation on the system I supported. Confirmed that reports and extracts visible to customers were complete and accurate. Authored a department procedure to be used by support personnel in the department.

Wrote SQL queries to extract data out of the system. Developed and implemented one set of metrics to ensure customer compliance with the rules. Created an MS Access database to calculate scores for another metric to ensure customer compliance with the rules. Analyzed historical data to determine compliance with an upcoming NERC Standard. Worked with customers to correct issues identified through measurements collected. Maintained and updated the department’s website with information and data.

Developed real-time data historian application for use by the department. Developed customized analyst displays in an application to compare customer information for use by the department. Compared Operations logs with customer report to identify rules discrepancies.

Austin, Texas, United States

Display Building using FG Builder

Austin, Texas, United States

Worked in a clean room supporting Burn-In Ovens