Ronald Sullivan Email & Phone Number

Florida, United States

Atlanta, Georgia, Us

Boca Raton, Florida, Us

Technisource (Contracted to ADT for first 6 months)Tools used: SQL Server Management Studio, Visual Studio (SSIS, SSRS, SSAS), SQL Server (2000/2008/2016), DB2/400 (Telemar), Access (advanced), Excel, Visio, Word, PowerPoint, SharePoint, Power BI, Tableau, Qlikview, NICE Systems, Symon Display Software (RMG Networks), Avaya CMS, Aspect Workforce Management Software (data interface), LivePerson (data retrieval), Gryphon Networks (data retrieval), Salesforce.com, ODBC connections to proprietary systemLead a small data management/reporting group reporting directly to the VP of the sales center as well as other executives. * Team works closely with management throughout the company (including marketing and finance) to plan, develop and release reporting to fill needs and identify opportunities in all areas of the business.Lead reporting and analysis on new corporate sales initiatives and pilot programs. * Organize and develop reporting required for analysis of the programs. * Provide full readout and analysis of the initiatives.Develop and schedule recurring sales, distribution, and financial reporting.Tracking, auditing, and analysis of marketing campaigns. (direct mail, email, web, print media, radio, and TV) Product, reporting, and data support for internal and external clients. (partnerships and internal marketing and product programs)Custom HR attendance / compliance calculations and reporting.SQL Server Administration and Development. * Server administration and database development to support reporting needs and distribution. * Schedule and store data for reporting needs.* Interface import and format data from various systems. * Developed data storage and table/view structures used by various departments throughout the company for reporting needs. Work in close collaboration with other programmers, developers, and the IT department. Project management.

Tools used: Word, Visio, Access, Excel, SQL Queries, OmniGraffle, OmniOutliner, Google Apps for Business, Zoho Online Business ToolsPlan, develop, and consult on financial, sales, and marketing analytics for small businesses. * General business analytics that can be manageable for a small business. Help create new as well as alter current marketing programs with data analytics in mind. * Set up customer and campaign tracking to ease marketing analytics. Develop basic databases and data collection processes to allow better business analytics. * Set up customer, campaign, and products databases for basic analytics. * Develop data input methods that can be managed and maintained by a small business.Develop reporting on the data collected in formats easily accessible and viewed by various users. * Develop sales, financial, and marketing reports to give better understanding of overall business performance. * Set up access to these reports that can be altered easily for the needs of the user. * Provide reports in easily viewed formats like Excel.

Tools used: SQL Server (Data Warehouse), Access, Excel, Visio, Word, PowerPoint, SharePoint, and custom (ASP.NET) portals and applications Tracking, auditing, and analysis of marketing campaigns. * Monitor and audit the tracking of marketing campaigns using scheduled and ad hoc reporting. * Analyze and report on the production of the campaigns.Product, reporting, and data support for internal and external clients. (client services) * Support use and audit concerns of the clients through testing, reporting, and resolutions. * Develop use cases from the client feedback. * Use feedback and use cases to plan new products as well as new reports for existing programs. Test, audit, and report on new development and processes. * Develop tests and reports for the new products for audits and bug reports. * File all user stories and bugs to the development team using a web based project management tool. * Manage feedback through these tools for accurate information and task completion. Work in collaboration with programmers, database developers, and the IT department. * Manage and test databases for updates and accuracy.Development of ad hoc reporting. * General reporting for marketing performance.Work within a Scrum agile software development methodology.

Tools used: SQL Server (Data Warehouse), Oracle, Access, Excel, Visio, Word, PowerPoint, SharePoint, Crystal Reports, BusinessObjects, ACD Reports, Global Navigator Client-term, Census data, LexisNexis Tracking, auditing, and analysis of marketing campaigns. * Monitor and audit the tracking of marketing campaigns using scheduled and ad hoc reporting. * Analyze and report on the production of the campaigns including but not limited to Cost Per Inquiry (CPI) and Cost Per Order (CPO). Customer list creation for both direct and mass marketing campaigns. * Scheduled list creation with common variables and delivery methods. * Ad hoc lists for smaller projects such as custom campaigns and research. Planning, analysis, and reporting of marketing research using call centers, focus groups, as well as third party research data. * Planning based on the products and goals of the data obtained. * Report the findings of the research in textual and graphical forms. Product, reporting, and data support for internal and external clients. * Support use and audit concerns of the clients through testing, reporting, and resolutions. * Use feedback and use cases to plan new products as well as new reports for existing programs.Develop and schedule recurring sales, distribution, and financial reporting. * Reporting on departmental sales as well as individual performance. * Distribution reporting for operations. * Financial / performance analysis and reporting to assist strategic planning as well as executives. Development of ad hoc reporting. Work in collaboration with programmers, database developers, and the IT department. * Primary source for database planning and assisted creation of account database system. * Assisted with upgrade of Oracle 10 to 11i. * Test, audit, and report on new development. * File all user stories and bugs to the development team. * Manage feedback through these tools for accurate information and task completion.

Computer Aided Design

Computer Science

Computer Graphic Design