Sql Server Business Intelligence
Resume:
Elmer Donavan
Cincinnati, OH *****
*********@*****.***
SUMMARY
Highly motivated Business Intelligence Professional, BI Architect, Data Architect, Data Warehouse professional using SQL Server 2005, 2008, 2012, 2016 and Microsoft Technologies. Experience manipulating various data sources to support Senior Management decisions. Demonstrated leadership abilities and team work skills as well as the ability to accomplish tasks under minimal direction and supervision.
http://www.linkedin.com/in/ejdonavan
CERTIFICATIONS
PMP – Project Management institute, received 2004 expires 2017
TECHNICAL SKILLS
Microsoft Technologies:
SQL Server 2000 DTS, SQL Server 2005 Integration Services, SQL Server 2005 Analysis Services, SQL Server 2005 Reporting Services, Microsoft Office SharePoint Server 2007, Microsoft Performance Point Server, Microsoft Visio.
Databases:
MS SQL Server 2000, MS SQL Server 2005, MS SQL Server 2008, MS SQL Server 2012 R2, SQL Server 2016, Snowflake SQL
Software:
SQL Server Business Intelligence Development Studio
Databases Administration
SQL Server Enterprise Manager and VISIO, DTS, SSIS, SQL Profiler, TFS Database projects, File Group Maintenance, Execution Plan, Data Dictionary, Database Diagrams
Databases Design
SQL Server Enterprise Manager and VISIO, ERWIN, DTS, Team Foundation, ORACLE through VISIO and Toad
Databases Modeling
SQL Server Enterprise Manager, Team Foundation, ERWIN, and VISIO
Database Reporting
SQL Reporting via MS-Access, Crystal Reports, SSRS, MDX, SAS, PowerBI
Query Languages:
T-SQL, MDX, SnowSQL
Languages
Business Intelligence Architect - 8 years total,
.*SSAS Architect
*Designed Models and KPI and Hierarchy for manufacturing Cube.
-Developed CUBE based process to analyze market trends for local manufacturing company.
-Created reusable process to display many reports via single rdl based on metadata passed to report.
-Designed Market Study process for uniform manufacturer to use Dynamics AX CUBE and
corresponding SQL database.
-Designed and enhanced SSAS cubes for home construction and education companies for time and trend
based reporting.
-Defined and Created Dashboard and PowerPoint pivot tables reports for education and construction industries.
- Created design for Market Research application for National chemical company.
- Designed and created a data edit process for local meat processing company assisting in production scheduling
to process Data Mart and Cube.
*SSIS Architect
*Designed SSIS import extract process to reduce “One-Off” implementations.
-Utilized table based data driven configurable process to perform imports and extracts.
-Utilized Project parameters to allow for environment and client configuration.
-Utilized file delimiter parameter driven output and input process by format
-Designed and Developed SSIS and SSRS ETL and reporting solution for Home Construction Company.
-Defined, created and maintained DTS/SSIS ETL process for home buying and print ETL processing.
-Designed and created and maintained DTS interfaces for LAB ETL process for Dialysis software.
-Created and maintained DTS interfaces for Medical Billing ETL process for Dialysis software.
-Set-Up conversion DTS version 2000 to Universal Import process in SQL Server 2005 DTS/SSIS model.
Perl, T-SQL, and stored procedures to perform validations and transformations on the ETL.
*SSRS Architect
* Designed SSRS report rdl’s to facilitate claims processing for local insurance company.
-Designed Dashboard summary approach for reported birth-defect reporting.
-Utilized custom report formatting based on report and data ranges encountered.
- Created miniature Executive Summary reports for Weekly/Monthly dashboards.
-Designed Dashboard approach of summary reports in Pediatric research for summary level executive.
- Defined ARMR processing for monthly account reconciliation of long line business.
-Created credit analysis reporting process to assist in credit mailing analysis for National bank and credit card
corporation.
-Defined, designed, created, and maintained reporting process for internet clothing wholesaler using Dynamics AX
database and Cube
Power BI- 3 years total,
*SSRS Architect
*Designed Models and KPI and Hierarchy for manufacturing Cube.
-Developed CUBE based process to analyze market trends for local manufacturing company.
-Created dashboard reports based on metadata passed to dashboard.
-Designed Market Study process for uniform manufacturer to corresponding SQL database.
-Designed Health Care Study process for clinic patients to corresponding SQL database.
-Designed Health Care Study process for Surgery patients to corresponding SQL database.
-Assisted Real Estate process for loans and properties to corresponding SQL database.
Business Intelligence - 18 years total,
*Developed SSIS imports and created SSRS report rdl’s to facilitate claims processing for local insurance company.
*Developed SSIS imports/export process in SSIS to facilitate data needs in claims processing for local insurance
company.
*Created SSIS import ETL and developed SSRS reports to facilitate the conversion from Actuate to SSRS for local
insurance company.
*Developed CUBE based process to analyze market trends for local manufacturing company.
*Developed and designed CUBE based warehouses and data marts utilizing star schema and slow changing
dimensions for healthcare and financial applications in medical and insurances industries.
*Deployed CUBE based warehouses and data marts utilizing star schema and slow changing dimensions for
healthcare and financial applications in medical and insurances industries.
*Maintained CUBE based warehouses and data marts utilizing star schema and slow changing dimensions for
healthcare and financial applications in medical industry.
*Created reusable process to display many reports via single rdl based on metadata passed to report.
*Enhanced ETL process for pediatric data being used on research reporting sites at local research hospital.
*Enhanced report reusability for extending across multiple studies in Pediatric research at local research hospital.
*Created/Converted Market Study process for uniform manufacturer to use Dynamics AX CUBE and
corresponding SQL database.
*Developed and enhanced SSAS cubes for home construction and education companies for time period and trend
based reporting.
*Designed Dashboard approach of summary reports in Pediatric research for summary level executive
*Developed SSIS and SSRS ETL and reporting solution for Home Construction Company.
*Created and maintained DTS/SSIS ETL process for home buying and print ETL processing.
*Created Dashboard and PowerPoint pivot tables reports for education and construction industries.
*Created and maintained DTS interfaces for LAB ETL process for Dialysis software.
*Created and maintained DTS interfaces for Medical Billing ETL process for Dialysis software.
*Converted DTS version 2000 to Universal Import process in SQL Server 2005 DTS/SSIS model. Incorporated
Perl, T-SQL, and stored procedures to perform validations and transformations on the ETL.
*Created and maintained reporting process for internet clothing wholesaler using Dynamics AX database and
cube.
*Created a data edit process for local meat processing company assisting in production scheduling process.
*Completed ARMR processing for monthly account reconciliation of long line business.
*Completed Market Research application for National chemical company.
*Created credit analysis reporting process to assist in credit mailing analysis for National bank and credit card
corporation.
COBOL/MicroFocus Cobol - 12 years total,
*Created Extracts for FOCUS ARMR processing application.
*Maintained and enhanced Order processing and Order History applications for chemical and plastics company.
*Enhanced telecom circuits process used to create 800 phone numbers.
*Developed portions of local grocery chain SKOPE application.
*Converted VSAM and ISAM to COBOL Oracle process for local financial applications software company.
*Created reporting process for Fidelity Investments for reporting of conversion balances
converted into Fidelity from outside 401K providers.
*Maintained several reports and other processes in Reporting Systems for Cincinnati Financial.
SAS - 8 years total,
*Created EPA insecticide mortality study for chemical company studying LD 50 on new formulations.
*Completed Executive compensation process for local Consumer gods company for both National and
international executives.
*Created Market Study process for sales segment of consumer products corporation.
*Created and maintained FDA data edits for pharmaceutical trials covering drug efficacy,
*Created a data edit process for local drug company studying NSAID drug interactions.
*Completed ARMR processing for monthly account reconciliation of long line business.
*Completed Market Research application for National chemical company.
*Maintain production scheduling and freight management system for local chemical and plastics corporation.
PROFESSIONAL EXPERIENCE
eBusiness Colombus, OH 11/23– 1/24
DW Architect/ SSIS Architect
• Implemented SSIS Package Solution supporting ETL for three distinct sources
and load into a CRM database.
• Maintained and created Turnaround process scripts.
• Established/Converted SSIS packages from AR and GL data, and member demographics.
• Communicated project status to all levels of organization and client through written,
verbal communications
Eastman Chemical Kingsport, Tn 11/22– 8/23
BI Developer/ SSRS & SSIS Architect/DW Architect
• Implemented BI Reporting Solution and supporting Materials & Reliability ETL
and PowerBI process.
• Maintained and created Turnaround process dashboards.
• One-Off SSIS exports to OOTB Extract process.
• Established/Converted SSIS packages from AR and GL data, and member demographics.
• Develop and support SSIS import scripts for ETL activities and Cube support.
• Communicated project status to all levels of organization and client through written, verbal communications
• Developed processing Excel output to load into the Data Warehouse in Azure.
• Developed Dashboard to report from Data Warehouse for Power BI.
PhiDemissions Dallas, Texas 02/22– 07/2022
BI Developer/ SSRS & SSIS Architect/DW Architect
• Implemented BI Reporting Solution and supporting Real Estate ETL process.
• One-Off SSIS exports to OOTB Extract process.
• Established/Converted SSIS packages from AR and GL data, and member demographics.
• Develop and support SSIS import scripts for ETL activities and Cube support.
• Communicated project status to all levels of organization and client through written, verbal communications
• Developed process for Excel output to load into the Data Warehouse.
• Developed Dashboard to report from Data Warehouse.
SurgeryPartners Nashville, TN 07/21– 01/22
BI Developer/ SSRS & SSIS Architect/DW Architect
• Implemented BI Reporting Solution and supporting ETL process.
• One-Off SSIS exports to OOTB Extract process.
• Established/Converted SSIS packages from loading care plan, and member demographics.
• Develop and support SSIS import scripts for ETL activities and Cube support.
• Communicated project status to all levels of organization and client through written, verbal communications
• Developed process for Excel output to be generated from Data Warehouse.
AssureCare Cincinnati, OH 05/19– 07/21
BI Developer/ SSRS & SSIS Architect/DW Architect
• Analyzed, design, and Implemented SnowFlake Data Warehouse.
• Implemented BI Reporting Solution and supporting ETL process.
• Set-Up Cubes for use with Power BI and Share Point report distribution.
• Retrofitted 2012 SSRS reports to new data driven 2016 SSRS report process.
• One-Off SSIS exports to OOTB Extract process.
• Establish SSIS exports for flat files in load Azure Data Lake.
• Established/Converted SSIS packages from loading care plan, and member demographics.
• Converted multiple input reports to run on SSRS.
• Develop PowerBI Dashboard for ETL activities health care client support.
Develop and support SSIS import scripts for ETL activities and Cube support.
• Communicated project status to all levels of organization and client through written, verbal communications
• Developed process for Excel output to be generated from SSRS.
Kroger Technology Cincinnati, OH 10/15– 05/2019 BI SSRS, SSAS, & SSIS Architect
Implement BI Reporting Solution and supporting ETL design process.
Defined, Set-Up Development, test and production Cubes for use with Power BI and Share Point report distribution.
Redefined and retrofitted 2008 SSRS reports to new data driven 2012 SSRS report process.
Redefined SSIS Imports for flat files used in reporting.
Established/Converted SSIS packages from Pharmacy systems merging with KSP.
Designed and converted multiple input reports to run on SSRS.
Develop PowerBI Dashboard for ETL activities and Cube support.
Develop and support SSIS import scripts for ETL activities and Cube support.
Developed process for Excel output to be generated from SSRS.
Outlined and defined SSRS process for reporting KPP claims for report delivery on vendor data.
Cincinnati Financial Corp via SMART-IT Cincinnati, OH 1/14 – 5/15
BI SSRS Architect
Defined and Created BI Reporting Solution and supporting ETL process.
Set-Up Development, test and production Cubes for use with Performance Point and Share Point report distribution.
Redefined and retrofitted SSRS 2005 to new data driven 2008 process.
Redesigned and convert Actuate Reports to SSRS report RDL’s using DB2 and Flat file sources.
Define SSIS Imports for flat files used in reporting.
Design and develop and support SSIS import scripts for ETL activities and Cube support.
ED102ed##Established data drive subscriptions for report delivery.
Fechheimer Bros via Messina Management Cincinnati, OH 6/13 – 01/14
BI Developer/SSRS Architect
Develop and support SSIS import scripts for ETL activities and Cube support.
Communicated project status to all levels of organization and client through written, verbal communications
Implemented BI Reporting Solution and supporting ETL process.
Developed report tracking process for promoting of reports requested by department managers and senior management.
Set-Up, Design, Develop, test and production Cubes for use with Performance Point and Share Point report distribution.
Design conversion of Retrofit of SSRS 2005 to new data driven 2008 process.
Converted Crystal Reports to use SSRS processes.
Children’s Hospital via Partner Staffing Cincinnati, OH 9/12 – 06/13
BI Developer/Data Architect
Set-Up Development, test and production Cubes for use with Performance Point and Share Point report distribution.
Converted stored procedures and SSIS packages to run in SQL Server 2008 R2 using T-SQL for SQL Server development of replacement procedures.
Develop and support SSIS import scripts for ETL activities and Cube support.
Designed and implemented customizable meta data report attribute system to allow for data driven report variations.
Created report package snapshot versions of reports for executive summaries.
Communicated project status to all levels of organization and client through written, verbal communications
Implemented BI Reporting Solution and supporting ETL process.
Retrofitted SSRS 2005 to new data driven 2008 process.
Created and maintained SAS validation and reporting procedures for studies being introduced.
Independent Contractor Cincinnati, OH 1/12 – 9/12
BI Architect/BI Development
Develop and support SSIS import packages for DBA activities and Cube support.
Communicated project status to all levels of organization and client through written, verbal communications
Implemented BI Reporting Solution and supporting ETL process.
Converted stored procedures and DTS packages to run in SQL Server 2008 R2 using T-SQL for SQL Server development of replacement procedures.
Set-Up Development, test and production Cubes for use with Performance Point and Share Point report distribution.
EDUCATION
NorthCentral University Scottsdale, Az
PhD program for Data Analytics and Business Intelligence
Projected completion 2026
SetFocus, LLC Whippany, N.J.
Masters of Business Intelligence
Minor – Data Warehouse Architec
Thomas More College Crestview Hills, KY
Masters of Business Administration
Minor - Operations Management
Drexel University Philadelphia, PA
Bachelors of Science, Commerce & Engineering (Industrial Engineering)
Major - Management Information Systems
Mercer County Community College Trenton, N.J.
Associates of Science, Plant Science
Minor - Engineering Sciences
Contact this candidate