Joseph Dempsey Email & Phone Number

Matthews, Nc, Us

Dublin , Ca, Us

Dublin , Ca, Us

Dublin , Ca, Us

• Responsible for the architecture and development of the internal department data warehouse.• Continually explore and implement best practices to improve performance of the SDLC, team and code development.• Collaborate with business stakeholders in ensuring data warehouse architecture development and utilization.• Develop working relationships with Business, Information and Technology Architects to facilitate collaboration.• Create database objects like tables, views, procedures, triggers, and functions using T-SQL to provide definition, structure and to maintain data efficiently.• Build, publish customized interactive reports and dashboards, report scheduling using Tableau Desktop.• Create action filters, parameters and calculated sets for preparing dashboards and worksheets in Tableau.• Develop Tableau visualizations and dashboards using Tableau Desktop.• Provide Tableau support to Tableau users with in the department.

Stamford, Ct, Us

• Design and perform various testing procedures to ensure that Nestor is set up properly and functioning as intended.• Reconcile journal entries, payments, interfaces and reporting generated from Nestor against expected results.• Develop, audit, implement, and manage installations and upgrades for Nestor and Medea applications. • Set up and maintain financial terms for programming contracts in Nestor.• Read, analyze and interpret legal documents.• Possess an attitude of perseverance in problem solving and utilizing analytical skills.• Effective use of Microsoft's SSRS, T-SQL/Excel/Access and TWC's statistical tracking software• Assist with programmer license fee audit process - communicate with necessary parties to gather and analyze relevant subscriber and license fee data to ensure completeness, appropriateness and accuracy.• Gather and analyze relevant data to completely, accurately and timely assess the validity of programmer license fee audit claims.• Maintain detailed records of correspondence and status related to programming audits.

Creates custom reports using SSRS - SQL Server Business Intelligence Development Studio and deployingthem to SharePoint.• Experienced in converting DTS packages into SSIS Packages.• Working knowledge of SSAS packages and ability to deploy them.• Designs, implements and manages interfaces between multiple applications using SSIS - Business IntelligenceDevelopment Studio.• Developing, auditing, implementing, and managing installations and upgrades of software and hardware atfacility locations throughout the United States.• Coordination all aspects and resources involved in the installation process includes education, software,hardware vendors, third-party subcontractors and end users.• Software issues such as; implementing new software solutions, configuration changes, interfaces, defining andtesting new processes, security administration, new user profiles, training new users, writing system queriesand end user support.• Creates and manages insurance carrier files using SSIS as an ETL Methodology.• Project Management functions include managing the project, resources and the people involved with theproject from inception to completion.• Ensure best practices are applied and integrity of data is maintained through security, documentation, andchange management.• Plan, design, and implement application database code objects, such as stored procedures and views.• Build and maintain SQL scripts, indexes, and complex queries for data analysis and ETL operations.• Performs security and systems audits in accordance with SOX regulations.• System administrator for Great Plains, Lawson, Kronos, ReqLogic, Panatracker, and Sage FAS systems.• Manages the benefits open enrollment data uploads into Lawson.• Provides client support for all financial systems, Lawson, Sage FAS, and Kronos.

Founder Senior Pastor of Zion Christian Ministries. We were a non-denomination church. During the 5 years I organized events that including volunteering for the Thanksgiving dinner at the Johnston YMCA. We also tutored for a year at the Salvation Army Women's shelter.

Responsible for educating over 200 children in using MS word, excel and access.• Create and utilize teacher work plans.

Responsible for evaluating and implementing new ministries.

Manager of the accounting department that covered payroll, GL, and AP.Project lead for the Great Plains upgrade from the DOS version to Windows.

Masters, Divinity

Bachelor'S Of Science, Accounting