| | | 20,000+ Fresh Resumes Monthly | |
|
|
| |
Click here or scroll down to respond to this candidateCandidate's Name
Cincinnati, OH Street Address
PHONE NUMBER AVAILABLEEMAIL AVAILABLESUMMARYHighly 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://LINKEDIN LINK AVAILABLECERTIFICATIONSPMP Project Management institute, received 2004 expires 2017TECHNICAL SKILLSMicrosoft 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 SQLSoftware:SQL Server Business Intelligence Development StudioDatabases AdministrationSQL Server Enterprise Manager and VISIO, DTS, SSIS, SQL Profiler, TFS Database projects, File Group Maintenance, Execution Plan, Data Dictionary, Database DiagramsDatabases DesignSQL Server Enterprise Manager and VISIO, ERWIN, DTS, Team Foundation, ORACLE through VISIO and ToadDatabases ModelingSQL Server Enterprise Manager, Team Foundation, ERWIN, and VISIODatabase ReportingSQL Reporting via MS-Access, Crystal Reports, SSRS, MDX, SAS, PowerBIQuery Languages:T-SQL, MDX, SnowSQLLanguagesBusiness 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 andcorresponding SQL database.-Designed and enhanced SSAS cubes for home construction and education companies for time and trendbased 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 schedulingto 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 rdls 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 cardcorporation.-Defined, designed, created, and maintained reporting process for internet clothing wholesaler using Dynamics AXdatabase and CubePower 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 rdls to facilitate claims processing for local insurance company.*Developed SSIS imports/export process in SSIS to facilitate data needs in claims processing for local insurancecompany.*Created SSIS import ETL and developed SSRS reports to facilitate the conversion from Actuate to SSRS for localinsurance company.*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.*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 andcorresponding SQL database.*Developed and enhanced SSAS cubes for home construction and education companies for time period and trendbased 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. IncorporatedPerl, 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 andcube.*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 cardcorporation.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 balancesconverted 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 andinternational 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 EXPERIENCEeBusiness Colombus, OH 11/23 1/24DW Architect/ SSIS Architect Implemented SSIS Package Solution supporting ETL for three distinct sourcesand 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 communicationsEastman Chemical Kingsport, Tn 11/22 8/23BI Developer/ SSRS & SSIS Architect/DW Architect Implemented BI Reporting Solution and supporting Materials & Reliability ETLand 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/2022BI 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/22BI 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/21BI 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 ArchitectImplement 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/15BI SSRS ArchitectDefined 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 RDLs 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/14BI Developer/SSRS ArchitectDevelop and support SSIS import scripts for ETL activities and Cube support.Communicated project status to all levels of organization and client through written, verbal communicationsImplemented 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.Childrens Hospital via Partner Staffing Cincinnati, OH 9/12 06/13BI Developer/Data ArchitectSet-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 communicationsImplemented 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/12BI Architect/BI DevelopmentDevelop and support SSIS import packages for DBA activities and Cube support.Communicated project status to all levels of organization and client through written, verbal communicationsImplemented 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.EDUCATIONNorthCentral University Scottsdale, AzPhD program for Data Analytics and Business IntelligenceProjected completion 2026SetFocus, LLC Whippany, N.J.Masters of Business IntelligenceMinor Data Warehouse ArchitecThomas More College Crestview Hills, KYMasters of Business AdministrationMinor - Operations ManagementDrexel University Philadelphia, PABachelors of Science, Commerce & Engineering (Industrial Engineering)Major - Management Information SystemsMercer County Community College Trenton, N.J.Associates of Science, Plant ScienceMinor - Engineering Sciences |
