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)