Robert W. Dwier

**** ******’s Creek Court

Morrisville, NC 27560-6953

www.linkedin.com/in/RobertDwier

acvb7b@r.postjobfree.com 919-***-****

Reports Developer / Reporting Analyst

Support clients / employer in understanding their efforts by developing reports / database

and / or writing T-SQL codes as needed while ensuring data integrity and accuracy.

Accomplished Information Technology Professional especially in the areas of database programming/reports development in Federal and local government agencies. Successful career managing multiple projects while working on effective methods to improve processes and business functions. Independent worker with strong customer service and written communication skills.

Develop Complex Reports Using SQL Server Reporting Services (SSRS) and Tableau

Troubleshoot, Optimize and Deploy SQL Queries

Transact-SQL Programming

Database Development in MS SQL Server

Relational Database Concepts

Data Integrity and Validation

Extraction, Transformation and Load (ETL)

Quantitative Data Analysis

Technical Skills

4+ years’ experience in Microsoft (MS) SQL Server 2005 / 2008 using SQL Server Management Studio (SSMS), Visual Studio 2005 / 2008, Transact-SQL and SQL Server Reporting Services (SSRS) 2005 / 2008.

Completed training course in Implementing a Data Warehouse with MS SQL Server (using SQL Server Integration Services (SSIS) and Data Quality Services (DQS) tools).

Extracted, transformed and populated databases from MS Access and MS Excel files as well as flat files to MS SQL Server. Copied data tables from 1 server to another and maintained them.

4+ years’ experience designing, developing and implementing MS Access 2003 business applications with Visual Basic for Applications (VBA).

Experience in MS Word and MS Excel (up to Version 2013), including use of Pivot Tables.

Some familiarity in Tableau 8.2 (6 months experience), Crystal Reports, MS PowerPoint 2010, HTML and C#.

Worked with variety of database management systems, including Microsoft’s SQL Server, IBM’s Model 204, Oracle and Community Mental Health Center / Management Information System (CMHC / MIS).

Professional Experience

COMMUNITY CARE OF NORTH CAROLINA, Raleigh, NC 2012 – 2015

Reports Developer

Supported health care professionals and data analysts by creating report templates using MS SQL Server Reporting Services. Reports were created via different methods such as filtering, parameterized reports, sub-reports, graphics and drill-down, in efforts to cut down on Medicaid costs. Examples of reports generated are as follows:

oCreated a package of seven graphic reports to provide hospitals, doctors or health care workers their key performance indicators on patients’ pregnancy care.

oCreated a bar graphic report along with statistical table to show hospitals/practices their key performance indicators on patient discharges with an optional sub-report showing list of patients and their admit/discharge dates.

Developed and modified complex SQL queries using stored procedures / functions in SQL Server environment (using Visual Studio / SQL Server Management Studio) to assist in populating reports.

Performed SQL programming, creating result sets in order to support reports.

Robert W. Dwier acvb7b@r.postjobfree.com Page Two

Participated in and gathered business requirements from workgroup meetings. Tested report results, verifying data accuracy and / or identifying errors in logic used to create underlying data tables.

Ensured customers received latest data via reports by manually copying and maintaining latest versions of data tables in SQL Server Management Studio if not automatically updated.

Created report templates using Tableau, allowing management to review reports to determine worthiness.

CENTERPOINT HUMAN SERVICES, Winston-Salem, NC 2008 – 2012

MS SQL Report Writer 2011 – 2012

Kept local health care professionals abreast of latest behavioral patients’ status by creating and maintaining complex reports using MS SQL Server Reporting Services.

Developed complex SQL queries using views and stored procedures / functions, supporting reporting requirements and verifying data accuracy.

Presented data in multiple formats, including reports, matrices, charts, graphs, aggregates and statistical computations, providing local counties with an understanding of their behavioral patients’ population.

Computer Programmer / Analyst 2008 – 2011

Created tables and populated with data using different methods, including loading data from MS Excel.

Reconciled discrepancies in reports by validating data and support information technology applications, including database application while utilizing analytical and programming skills.

Ensured technology requirements for capture, manipulation and reporting of information related to clients are carried out.

DEPARTMENT OF THE INTERIOR / U.S. GEOLOGICAL SURVEY (USGS), Reston, VA 1987 – 2007

Information Technology Specialist 1993 – 2007

Computer Programmer / Analyst 1987 – 1993

Wrote SQL scripts and standard PL/SQL procedures, extracting data from several Oracle database applications, including Geographic Names Information System (GNIS).

Designed, tested, implemented and maintained Assets Inventory Tracking System (AITS) and Printing Tracking System (PTS) applications using MS Access with VBA for use internally, allowing employees to track assets and printed USGS topographical maps on hand.

Maintained existing The National Map Inventory MS Access database project, aiding management in research of topographical maps. Extracted data and created reports as requested.

Awards

Received monetary award for superior work performance, 2001, 2005, 2006

Received plaque in recognition of outstanding leadership and dedication, 2003

Education

Bachelor of Technology (BTech), Computer Systems, Rochester Institute of Technology, Rochester, NY

Associate of Applied Science (AAS), Data Processing, Rochester Institute of Technology, Rochester, NY

Certificate, Implementing a Data Warehouse with MS SQL Server, Raleigh, NC

Professional Development

SQL Server, Tableau, Introduction and Intermediate C# Programming, Oracle’s Procedural Language / Structured Query Language (PL/SQL) Programming, Introduction and Intermediate MS Access Hands-On Programming, Hands-On MS Access: Developing Enterprise Applications, Building Dynamic Web Application with ColdFusion and SQL, and Implementing a Data Warehouse with MS SQL Server (using SQL Server 2014)

Contact this candidate