KEITH R. CONROY
*** ****** **., *** ***, Manchester, NH 03103
***- ***-**** • firstname.lastname@example.org • 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
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
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
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.
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
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.
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.
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
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.
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