KEITH R. CONROY

*** ****** **., *** ***, Manchester, NH 03103

***- ***-**** • addc37@r.postjobfree.com • LinkedIn

Business Intelligence Data Analyst

Highly expert at developing productivity reports and providing analytical support

Technically expert analytical professional with 18+ year experience in analyzing business intelligence and detailed reports. Proven track record in designing, developing, and maintaining of Tableau dashboards and functional SSRS reports based on user requirements to quickly create interactive visualizations. Skilled at implementing quality control and quality assurance checks at various points in data processing to improve production range. Managed development, maintenance, and deployment of SSIS packages to perform broad range of data migration tasks.

Data Analysis / SQL Reporting / Data Security & Privacy/ Data Analytics

Data Migration/ Tableau Functional Reports/ Testing & Troubleshooting

TECHNICAL PROFICIENCIES

Platforms:

Microsoft SQL Server, Tableau Desktop 2019.3.2, Business Objects, IntelliApp, IntelliCred, Oracle 9i, and Tableau Prep. Portfolio™ Enterprise Donor Management, synTelate®, Business Objects, Crystal Reports, SQL Profiler, PL/SQL, NoSQL

Tools:

Microsoft Office Suite, SQL Server, Microsoft BI Stack (SSIS, SSRS), Visual Studio 2017, Allscripts®, ED Pace, Nextgen 5.6/5.8, JIRA and Cherwell, Query / Store Procedure Optimization

EXPERIENCE

LogixHealth

Business Intelligence Data Analyst March 2015 – April 2020

Support operations team, develop productivity reports, and provide analytical support to understanding problems and analyzing situation for viable solutions. Collect and analyze data using tableau and SQL to procure data from database structure and to report and provide solutions on timely manner. Design, developed, and maintain Tableau functional reports based on user requirements to quickly create interactive visualizations.

Key Achievements:

Created Tableau dashboards developing visual data models to help spot trends and identify issues for internal operational and coding teams.

Created stored procedures, queries, and views necessary to support both SSRS reports and Tableau dashboards.

Gathered business requirements and converted it into SQL stored procedures for database specific projects

Built different kind of reports using SSRS like parameterized reports, Ad hoc reports, Drilldown reports and Drill through report.

Communicated internal business requirements by constructing easy- to-understand data and process documentation

Intellisoft Group

Contractor - Data Conversion Specialist October 2014 – March 2015

Analyzed customer data and applied to summary level data matrix to monitor trends and spikes in client’ data. Learned proprietary Contract Logix Contract Management Software (CMS) to support contract management, contract lifecycle management. Assisted in functionality testing on IntelliCred v14.2 to ensure reliability of program.

Key Achievements:

Created update SQL statement to help clients manage data in QA environment.

Created of OLAP, data analysis, data processing, cleansing, and transferring of data, mappings creation, debugging, optimization, and comparison of mappings

AdvantEdge Healthcare Solutions

Reporting Specialist June 2013 – October 2014

Upgraded Stored procedures and automated jobs for nextgen upgrade 5.6 to 5.8 to provide better security to data. Automated SQL reports using stored procedures in visual basic program and utilizing SQL server agent to output results to excel for internal use or too external FTP sites. Performed SQL database tuning for developers to enhance query performance by rebuilding indexes in tables within a specific SQL database.

Key Achievements:

Created SSIS packages using columns, joins, execute SQL task, data flow task, and execute package tasks in SQL server integration services.

Managed the AHS Portland office SQL server automated reports via JIRA ticketing system

Trained to learn SQL Database Tuning for Developers to enhance query performance by rebuilding indexes (clustered & non-clustered) in tables within a specific SQL database

Amergent

Data Production Analyst October 2010 – December 2012

Supported reporting team in preparing reports and analysis to ensure information retained on mail files and data integrity maintained. Implemented quality control checks at various points in processing and prior to releasing data for print production to improved production range. Managed development and deployment of SSIS packages to perform broad range of data migration tasks.

Key Achievements:

Created small repository of instructional documents for being and back-end of mailing process.

Improved readability of client data by converting into standard Amergent format.

Ensured effective program planning and prompt resolution of specific issues in collaboration with account team.

Utilized Microsoft Excel to convert raw data from databases to create reports for presentation to management

6 months straight of ETL work at Intellisoft group import raw files into SQL and then into Contract Logix Contract Management Software

EDUCATION AND TRAINING

Associates of Computer Science and Electronics, ITT TECHNICAL INSTITUTE, Woburn, MA, 2004

Bachelor of History/Secondary Education, WESTFIELD STATE UNIVERSITY, Westfield, MA, 1996

Contact this candidate