Resume

Sign in

Developer Sql Server

Location:
Lawrenceville, GA
Salary:
96000
Posted:
May 21, 2020

Contact this candidate

Resume:

Douglas G. Couse

678-***-****

addc42@r.postjobfree.com

https://www.linkedin.com/in/doug-couse-8238a349/

SUMMARY OF ACCOMPLISHMENTS

Results-oriented SQL Server Developer/Business and Data Analyst/Business Intelligence Consultant. Experienced in all phases of SDLC on small to large scale software development projects in Financial / Banking, Heavy Industrial Construction, Mining, Process Control, Manufacturing, Pulp and Paper, Healthcare, Telecommunications, Fleet Management, Staffing, State Department of Public Safety and affiliated State Agencies.

Consistently delivered Reporting System additions and upgrades on time and under budget for ADP’s premier

Time and Labor Management System used in the Hospitality industry.

Analyzed, re-designed, standardized and updated the functional usability and appearance of a Clinical Assessment Reporting System for the National Health System of England, ahead of schedule.

Developed a backend administrative reporting system for the Queensland Australia Healthcare Service Provider Directory website 30 days ahead of schedule and substantially under budget.

Over a 5-week time frame, performed an in-depth analysis of a leading Management Consulting firm’s CRM (Salesforce) interface with client’s Consultant Time and Billing System, which had been consistently failing due to data migration issues. Modified the data extraction process and updated the reporting system. Prepared and presented an operational business re-engineering plan for Alexander Proudfoot’s Executive Management Team.

Co-partnered in the ETL – Data Transformation of more than 1,100 JD Edwards DB2 Accounting System reporting query scripts into SQL Server 2008 data mart table data items over a 14 - month period for Lease Plan USA.

Significantly enhanced the performance measurement process utilized by Care USA for global operations and executive reporting purposes.

Successfully developed a high-profile Marketing logistics data reporting system that correlated market saturation data with latitudinal and longitudinal coordinates for presentation via a topographical mapping system. This logistics presentation system provided critical predictive marketing information essential to a high-level business acquisition decision for Cingular Wireless.

Co-author of DICOM diagnostic image quality standard for electronically transmitted Fetal Echocardiographic images. This project led to the first successful inter-continental high-density diagnostic image transmission trials over common telephony links and one of the first practical Clinical EMR systems in the Southeast.

Seamlessly merged an existing in-house Business Objects based CRM system with MS SQL Server 2008 CRM product while maintaining regional operations integrity and functionality of the existing system for ADP.

Microsoft Dynamics GP Implementation and Support Consultant for numerous clients.

Youngest Division Manager in the history of Continental Can Company. Selected as CCC Harvard MBA candidate.

EDUCATION

BBA, Accounting, Minor D.P., Armstrong Campus of GA Southern (Armstrong State University), Savannah, GA

Completed 1 Year of MBA in Finance

EXPERIENCE

Williams Industrial Service Group, Tucker, GA Business Intelligence – SQL Developer 11 / 2018 to 7/2019

Environment: Oracle 11g, SQL Developer, Penta ERP, MS SQL Server 2016, Report Builder, MS Windows 10, MS Office 365

Provided on going SSRS, PENTA ERP Reports development and collaborated with Accounting Management to successfully bridge a Financial Statements reporting bottleneck prior to mandatory SEC filing. Archived and decommissioned numerous remote MS SQL Server Databases.

D.Couse, Lawrenceville, GA Self Employed 4 / 2017 to 11 / 2018

Time Off to Upgrade 11685 Carriage Park Lane and put on Market for Sale. Time Off to purchase new house, prepare modification drawings, submit for permitting, hire sub-contractors, prepare schedules, obtain materials, complete rough in, pass inspections start finish work.

LocumTenens.Com, Alpharetta, GA MS Dynamics Financial Data Architect ( F-T-E ) 7 / 2013 to 3 / 2017

Environment: MS SQL Server 2008, 2010, 2012, 2014, 2016, MS Visual Studio, TortoiseSVN, MS Windows 10, MS Office 365

Developed and maintained all legacy SSRS reports and managed legacy Reporting Server. Provided end user database support for MS Dynamics GP 2008, 2014, 2016. Developed an external MS Access 2016 Provider Time Sheet processing system for LT Accounting Team. Developed and published a highly successful MS C# Invoice viewing/printing applet utilized by Recruiting Sales Teams. Configured and deployed a Public SSRS Reporting web page for use by Recruiting Sales and Accounting Team staff members to review various Accounts Receivable Aging Reports.

Centers for Disease Control, Atlanta, GA Business Intelligence – Reports Developer and LIMS Support 11 / 2012 to 4 / 2013

Environment: MS SQL Server 2012, Crystal Reports 2011, Scanworkx QR, MS Windows, MS Office Professional

Maintained Reporting system reports for all Labs at the CDC utilizing Crystal Reports 2011 for Lab Test Results Reporting and integrated ScanworkX QR Code. Provided day to day operations communications archival and document management via MS SharePoint and VMware infrastructure.

Alexander Proudfoot, Atlanta, GA Salesforce Integration Consultant 4 / 2012 to 5 / 2012

Environment: MS SQL Server 2012, Crystal Reports 2008, MS Windows, MS Office Professional, Salesforce CRM

Analyzed baseline Crystal Report 2008 Enterprise configuration and tested various reports to ascertain cause of performance bottleneck(s) and recommend optimization solution. Modified 5 critical reports to incorporate Salesforce CRM data extraction changes.

LeasePlan USA, Alpharetta, GA Microsoft Business Intelligence Developer 9 / 2011 to 10 / 2012

Environment: Agile, MS SQL Server 2008, Crystal Reports 2011, MS Windows, MS Office Professional

Converted 550 + of 1,100 JDEdwards AS400 DB2 Showcase query and report output files to SSRS embedded data sources for SSRS reports. Provided support and mentoring to national BI reporting team in transitioning to SSRS and SQL Server 2008 from Crystal Reports 2011 and Business Objects Enterprise.

ADP Corporation, Alpharetta, GA Business Intelligence – SQL Developer - SQL Server Developer 11 / 2010 to 8 / 2011

Environment: Agile, MS SQL Server 2000, 2005, Crystal Reports 2011, MS Windows, MS Office Professional

Upgraded MS SQL Server Stored Procedures and Reports in Incident Tracking Reporting System from SQL Server 2000 to SQL Server 2005. Generated end user training and documentation materials.

Acclaim Systems, Atlanta, GA SQL Server / Crystal Reports Developer 8 / 2010 to 11 / 2010

Environment: Oracle 9i, Crystal Reports 2011, SQL Server 2008 SSRS MS Windows, MS SharePoint 2010

Converted Oracle 9i based Crystal Reports Financial Statements Reporting System to SQL Server 2008 SSRS for national mortgage lending institution. Prepared and presented MS Office Server Farms implementation plan under MS SharePoint 2010.

Black Watch Data, Alpharetta, GA SQL Server / Crystal Reports Developer 7 / 2010 to 8 / 2010

Environment: Crystal Reports 2010, SQL Server 2008 SSRS MS Windows, Xcelsius Presenter

Developed SQL Server 2008 Views, Stored Procedures and baseline Crystal Reports 2010 for initial product release. Included a framework for Key Performance Indicator aggregation in Excel for Xcelsius dashboard generation. Developed key reports and report templates in Crystal Reports 2010, SQL Server 2008 and Xcelsius Presenter.

Care, Atlanta, GA SQL Server / Crystal Reports Developer 5 / 2010 to 7 / 2010

Environment: Crystal Reports 2010, SQL Server 2008, MS Windows, MS Office Professional

Developed a SQL Server View which consolidated all tables in a Key Performance Indicator database into a singular table view which eliminated a complicated and resource intensive Microsoft Excel based reporting process. Developed key reports and report templates in Crystal Reports 2010. According to the Director of Performance Management, this process improvement significantly enhanced the performance measurement process worldwide.

ADP, Alpharetta, GA Senior Software Engineer (F-T-E) 2 / 2008 to 5 / 2010

Environment: Agile, Crystal Reports 8.5, MS Windows, MS Office Professional, C++, PHP, IBM WebSphere, VB.Net

Maintained and unit tested 300+ Windows and Web based Time and Labor Management System reports.

These reports were derived from MS SQL Server and Sybase stored procedures utilizing a C++ and VB.NET back end. PHP was used as the primary web development language.

AT&T, Atlanta, GA Business Analyst / Reports Developer 5 / 2007 to 11 / 2007

Environment: Crystal Reports 8.5, SQL Server 2000, 2005, MS Windows, MS Access 2007, MS Office

Coordinated administrative and maintenance services on several distinct Management Report web sites including: Purchasing, Budgeting, Human Resources / Organization Structure Management Systems. These Reporting web sites were based on Oracle 9i and SQL Server 2000 / 2005 databases. Reporting was via Crystal Reports 8.5. Source data was accessed via ODBC connections, Stored Procedures, Views and T-SQL queries. In addition, data sources were regularly consolidated into Excel 2007 pivot tables. Access databases were populated via DTS for further analysis and summarization. ETL.

Manheim Corporation, Atlanta, GA Business Analyst / Reports Developer 2 / 2007 to 5 / 2007

Environment: Agile, Crystal Reports 10, Oracle 9i, Remedy 6.0, Remedy 7.0, MS Windows, MS Office

Developed or updated Management and Operations Reports for Oracle 9i based Service Management System - Remedy. This effort was part of an upgrade of Remedy 6.0 to Remedy 6.0 integrated with Crystal Reports 10. Interviewed end users and key stakeholders to ascertain needs. Prepared design specifications and user acceptance testing criteria.

Ross Systems, Atlanta, GA Systems Analyst / Reports Developer 9 / 2006 to 12 / 2006

Environment: Crystal Reports 10, SQL Server 2000, 2005, MS Windows, MS Office

Upgraded Executive Management Dashboard Reporting System to include dynamic runtime parameter selection lists via ASP rendered XML data sources. All Reports were web deployed using SharePoint and Crystal Reports 10 against SQL Server 2000 OLTP database, T-SQL Queries, Stored Procedures and Views developed via SMS. Provided Systems Analyst services in reviewing and evaluating outside vendor submissions for new Ad Hoc Reporting system software tools.

CAS Services, Duluth, GA Systems Analyst / SQL Server Developer 2 / 2005 to 8 / 2006

Environment: Crystal Reports 10, SQL Server 2005, MS Windows, MS Office

Standardized, created and/or upgraded 160+ Clinical Assessment System reports derived from MS SQL Server Stored Procedures and Crystal Reports 10. These reports were part of a Clinical Information System that was the backbone for Call Center and Walk in Center Clinical Assessment processing for the entire Public Healthcare system of Great Britain. Acted as stateside Business Analyst in developing state-of-the-art web based Clinical Service Provider Directory and Clinical Knowledge Base Content Management System for the territorial government of Queensland, Australia.

BellSouth, Atlanta, GA Reports Analyst and System Administrator LMS 7 / 2004 to 2 / 2005

Environment: Crystal Reports 8.5, SQL Server 2005, Oracle 8i, MS Windows, MS Office

Administered the BellSouth University Learning Management System Reporting Server. This system environment serviced in excess of 1,000 active users throughout the Southeast. The majority of the reports were deployed on a version 8.5 Crystal Enterprise Web based Scheduler / Server accessing an Oracle 8i database. Daily tasks included all Log-in Security Maintenance and Reports Server Administration, creating and executing ad hoc reports, rewriting of data extraction queries, updating parameters and deploying reports onto the Crystal eportfolio enterprise web site. Functioned as BellSouth internal Project Analyst and Liaison with external vendor in deployment of new Business Objects LMS Reporting System. Translated existing Stored Procedures and assisted outside developers with database ETL process. Tuned numerous complex Stored Procedures for faster execution. Actively participated in setting the standards for Docent LMS Based reports. Provided guidance / assistance to Reporting System Users.

Cingular Wireless, Atlanta, GA Visual Basic Systems Analyst / Developer 10 / 2003 to 5 / 2004

Environment: MS Access 2002, MS Windows, MS Office

Developed a Cell Site Tower Management System using MS Access 2000. This system was used to assist in the management of roaming access for 140,000 cellular transmission towers throughout the United States.

Interviewed stakeholders and developed specification documents for Cell Site Tower Management System.

Developed testing and implementation plans. Prepared end user documentation. Successfully implemented Cell Site System ahead of original plan schedule. Successfully salvaged a WAN based system for monitoring and tracking engineering testing, implementation and network operations statistics for worldwide Inter Carrier Voice and Data transmission.

Georgia State Patrol, Atlanta, GA Visual Basic & SQL Server Analyst / Developer 12 / 1997 to 9 / 2003

Environment: MS Access 7.0, 97, 2000, SQL Server 2000, MS Windows, MS Office

Directed a contractor development team that designed, developed and implemented a statewide Vehicle Crash Reporting System. This system used MS Access 95 / 97 / 2000 as a feeder application at remote sites to input crash report data. Remote data subsequently downloaded and imported into a SQL Server 2000 backend database used by other State and Federal agencies for analysis purposes. System included a complex report design that incorporated CAD images merged with report text. These UI forms had to be identical to existing report forms mandated by the State legislature. In the Business Systems Analyst role, performed user needs and workflow analyses, developed RFPs and reviewed vendor software/hardware submissions for Crash Reporting Documents Management System. Developed Internal/External provider project integration plan. Provided state wide training and support for Fleet Anywhere Vehicle Management Software. Monitored vendor and internal IT developers’ project performance.

Children’s Heart Center, Atlanta, GA Director of IT & Clinic Research Coordinator (F-T-E) 5 / 1994 to 8 / 1996

Environment: MS Access 7, Novell 4.0 Network, MS Windows, MS Office

Responsible for building a 4-person team to develop and manage a Networked Clinical Information System.

Assisted the Technical Clinical Research Group and assisted in preparation of grant submissions.

Successfully transitioned front-end MS Access 7.0 patient access, clinical assessment and back end office operating environments from MS DOS based to MS Windows Network based environments. Functioned as Clinical Systems Analyst / Lead Developer in analyzing business, functional and user requirements. Developed project test, implementation and strategic IT plans. Created design documents and evaluated outside sourcing for implementation of Clinical Patient Record EMR that included Radiographic, Catheterization lab and Echocardiographic Video captured images.

TECHNICAL SKILLS:

MS SQL Server 2016, 2014, 2012, 2008 R2, 2005. 2000, 7.0 - 20 Years

MS Access 2016, 2010, 2007, 2003, 2002, 2000, 97, 7.0, 2.0, 1.0 - 20 Years

T-SQL - 20 Years

MS Winforms UI - 10 Years

MS Visual Studio 2015, 2013, 2010 - 10 Years

MS BIDS - 12 years

MS SQL Server Reporting Services (SSRS) 2016, 2014, 2012, 2008, 2005 - 12 Years

MS SQL Server Integration Service (SSIS) - 5 Years

MS SQL Server Analysis Service (SSAS) - 2 Years

MS Quick Basic Ez Forms Maker - 10 years

Microsoft Forms 365 - 1 Year

MS Windows 95, 98, ME/ NT/ 2000/ XP/7/ 8/ 10 - 20 Years

AutoCAD - 3 Years

MS Visio - 6 Years

MS Visual Basic, MS VB.Net - 12 Years

MS Report Builder - 5 Years

TortoiseSVN, Subversion - 3 Years

Visual SourceSafe - 8 Years

MS C#, C++ - 3 Years

VBA Macros \ VBA Scripting - 10 Years

XML /HTML /HTML4 - 5 Years

PHP - 2 Years

MS Power Pivot (Excel) - 5 Years

Oracle 11g/ 9i/ 8i - 10 Years

PL/SQL -5 Years

SQL Developer - 5 Years

IBM DB2 – 3 Years

Crystal Reports 14/12/11/10/9/8.5 - 15 Years

Adobe Acrobat - 10 Years

FoxIt - 2 Years

PDFelement 2 - Years

MS Team Foundation Server (TFS) 2012 - 3 Years

MS PowerPivot 2016/ 2012/ 2010 – 8 Years

Power BI – 1 Year

MS PowerBuilder 12 -

Salesforce CRM - 3 Years

MS Dynamics GP 2016, 2015, 2013, 2010 - 6 Years

MS Dynamics NAV 2016, 2015, 2013 - 3 Years

MS Dynamics CRM 2016, 2015, 2013 -3 years

MS SharePoint 2016, 2013, 2010 - 5 Years

MS Office 2013, 2010, 2007, 2003 - 10 Years

MS Office 365 - 3 Years

JD Edwards AS400 ERP 2 - Years

PENTA ERP 1 -Year

Relational databases - 20 Years

ASP and ASP.net - 13 Years

Object Oriented Analysis and Design (OOAD) - 10 Years

SDLC Methodologies Agile and Scrum - 10 Years

Milestones PM, Microsoft PM, CA Super Project PM, Workflow Analysis - 15 Years



Contact this candidate