Douglas G. Couse
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.
BBA, Accounting, Minor D.P., Armstrong Campus of GA Southern (Armstrong State University), Savannah, GA
Completed 1 Year of MBA in Finance
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.
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