Andrew Dugan

**** *. ***** ** *** B*** Pompano Beach, Florida 33069 561-***-**** acwu4s@r.postjobfree.com

Languages and Technologies

•T-SQL

•SSRS

•SQL Server Management Studio

•Business Intelligence Studio

•Microsoft Excel

•Visual Studio

•ActiveDocs

•Microsoft Word

•BPA Automate

•XML

•MySQL

•Team Foundation Server

•SysAid

•Remote Desktop

•Microsoft Outlook

•Microsoft OneNote

•Windows XP, Vista, 7, 10

•VBscript

Work Experience

September 2014- Presently, Report Developer

Qology Direct Margate Florida

•Managed SSRS Report System

•Created and Modified Reporting Stored Procedures

•Created and modified SSRS reports as requested by users

•Designed report layouts in Visual Studio

•Designed report mockups in Excel

•Created report subscriptions as requested

•Mentored other BI developers in creating SSRS reports

•Wrote ad-hoc queries as needed

•Implemented multiple company Dashboard reports Including

•A call volume and sales Dashboard measured against prior days

•A Dashboard that Displays how the sales agents time is being utilized

•A Dashboard that scores agents based how well they are following their script.

•Met with C level executives and Directors to gather requirements of operational reports

•Perform Quality assurance for reports

February 2014 - September 2014, Data Analyst

Cruise Planners - Coral Springs Florida

•Managed user requested reports

•gathered requirements from the accounting department primarily

•wrote the query or stored proc as requested

•placed the results into an excel spreadsheet, generally a pivot table was used

•manipulated the data using formulas like vlookup

•created visual representations of the data using charts

•Developed goal system

•developed system with reporting that shows how close the Cruise Planners overall sales are to the goal set by each cruise line, which if exceeded the company receives a bonus

•This allows the marketing team to focus their efforts in order to bring in more revenue

2012 - 2014, Report Developer

Choice Legal Group P.A. - Fort Lauderdale Florida

•Managed SSRS reports

•Created and modified SSRS reports as requested by users

•Designed report layouts in Business Intelligence Studio and Excel

•Wrote ad-hoc queries and views for users

•Gathered report requirements from users through SysAid or via telephone

•Created report subscriptions as requested

•Managed the firm's ActiveDocs document system.

•Wrote and updated stored Procedures that retrieve data to be inserted into a document

•Created and updated Active Microsoft Word templates based on an attorney's request

•Cleared a backlog of over 80 user requests

•Reduced document compilation time by approximately 30%

•Created batches of 500 plus XML documents using VBScript in an Excel Macro Enabled Workbook

•Monitored system for errors to ensure maximum availability

•Assisted users with Excel functions and creating pivot tables

•Investigated and designed solutions to user issues within the firm's Content Management System(CMS)

•Implemented a process using BPA Automate and SQL which automatically retrieves court docket information and store it into the firms' CMS. This process saved the firm $1 for every docket retrieved this way.

Education

•B.S., Computer Science, University of Central Florida

Contact this candidate