Uploaded File
Fred
fredstimler@comcast.net
904-716-5453
Jacksonville, FL 32235
BI Developer
16 years experience W2
4
Recommendations
Average rating
413
Profile views
Summary

Fred is a Jacksonville (FL) developer specializing in Business Intelligence tools: SQL Server 2016, SSIS, Tabular models, SSRS, Power BI, Crystal Reports and other tools. Created complex dashboards using Tableau 9.0 - a powerful visualization tool growing rapidly.

Experience
Senior Business Intelligence Consultant
Dec 2019 - present
Jacksonville, FL
Analysis of data flows throughout the entire enrollment and Operations process, creating Power BI reports and dashboards for senior division management. Currently developing Microsoft Power Automate (Flow) objects to replace large portfolio of Nintex process flows. Contract will be successfully completed by June 30, 2020
Business Intelligence MS Power BI
Remove Skill
Business Intelligence Analyst
Healthcare
Jul 2016 - Dec 2019
Jacksonville, FL
  • Business Analyst for 2 developers charged with moving the data mart to production and replacing large report base to SSRS 2016.
  • Created data mart for Incentive Compensation business unit - capturing approx. 20 million transactions to enhance analytical reporting.
  • Utilized traditional data warehouse design and using advanced Excel to demonstrate 100 + attributes and measures of the data mart.
  • Responsible for complex mapping exercise as data is gathered from production application with hundreds of generic-named columns and the Data Mart tables use user-friendly names.

SQL Data Marts SQL Server Oracle SSRS Data Warehousing Crystal Reports BI Developer Database Design MS Power BI Data Analysis BSA Business Analysis Business Intelligence Microsoft Excel
Remove Skill
References
Average Rating

1 recommendation
Business Intelligence Analyst
Healthcare
Jul 2016 - Dec 2019
Jacksonville, FL
  • Business Analyst for 2 developers charged with moving the data mart to production and replacing large report base to SSRS 2016.
  • Created data mart for Incentive Compensation business unit - capturing approx. 20 million transactions to enhance analytical reporting.
  • Utilized traditional data warehouse design and using advanced Excel to demonstrate 100 + attributes and measures of the data mart.
  • Responsible for complex mapping exercise as data is gathered from production application with hundreds of generic-named columns and the Data Mart tables use user-friendly names.

SQL Data Marts SQL Server Oracle SSRS Data Warehousing Crystal Reports BI Developer Database Design MS Power BI Data Analysis BSA Business Analysis Business Intelligence Microsoft Excel
Remove Skill
References
Average Rating

1 recommendation
Business Intelligence Analyst
Healthcare
Jul 2016 - Dec 2019
Jacksonville, FL
  • Business Analyst for 2 developers charged with moving the data mart to production and replacing large report base to SSRS 2016.
  • Created data mart for Incentive Compensation business unit - capturing approx. 20 million transactions to enhance analytical reporting.
  • Utilized traditional data warehouse design and using advanced Excel to demonstrate 100 + attributes and measures of the data mart.
  • Responsible for complex mapping exercise as data is gathered from production application with hundreds of generic-named columns and the Data Mart tables use user-friendly names.

SQL Data Marts SQL Server Oracle SSRS Data Warehousing Crystal Reports BI Developer Database Design MS Power BI Data Analysis BSA Business Analysis Business Intelligence Microsoft Excel
Remove Skill
References
Average Rating

1 recommendation
Senior BI/SQL Developer
Jul 2019 - Nov 2019
Jacksonville, FL
Assigned to support Johnson & Johnson R&D group – updating SQL applications and support issues and perform ad-hoc requests using SQL (Oracle) and Tableau 2019.
Oracle SQL SQL Developer Tableau
Remove Skill
SharePoint / reporting developer
Apr 2018 - Jun 2019
Jacksonville, FL
Developed task planning tool in SharePoint for major project to migration of 30 Terabytes of documents from text platform to SharePoint. Utilized SharePoint development tools and SSRS reports for navigation and control.
MS SharePoint SSRS
Remove Skill
Information Technology
Jun 2019 - Jun 2019
(contract) SharePoint engineering Reporting and Analysis for Migration project * Engaged to create tracking and reporting for large migration project (from Open Text to SharePoint
No skills were added
Remove Skill
SQL Developer / BI expert
Jul 2016 - Jan 2018
Jacksonville, FL
Engaged as SQL Developer for new Data Mart and reporting site
Data Marts SQL SQL Developer
Remove Skill
Tax Consultant (SQL Developer)
Nov 2015 - Apr 2016
SQL Developer/Analyst for complex tax department application using "big data" techniques
SQL
Remove Skill
Developer- Business Intellegence Group
Dec 2013 - Oct 2015
Creating analytical solutions both for client departments and a new JaxScore 2.0 effort. Working with all the Microsoft BI tools (PowerPivot, PowerView and SharePoint 2013 for BI. Also taught myself Tableau 8.2 to create 630-City dashboards for the public.
No skills were added
Remove Skill
Business Intelligance Developer/Analyst
Government
Dec 2013 - Oct 2015
Jacksonville, FL
  • Created complex TABLEAU reports using SQL data sources and utilizing interactive maps, grids and charts for top corporate user. Published to the public via City website.
  • Structural Analysis of City’s Accounting system (FAMIS) SQL database to aid the creation of Tabular model and modifications to current complex Cube
  • Analyzed the call and work order records of the CARE 630-City application, using Tableau version 9.0 for the visualization dashboards
  • Created Lien Tracking data analyzed using Tabular database and Power View reports, leading to recovery of $95,000 from city-based university
  • Analyzed specifications for the Public Works PAMO project which aimed to reduce the city's under-utilized properties; worked with GIS group and development group to build application for tracking. Created complex Tabular model to support SSRS and Power View reporting objects.
SQL SSRS Tableau SSIS SQL Developer Data Analysis BI Developer Business Intelligence BSA GIS
Remove Skill
References
Average Rating

1 recommendation
Software Developer
Jan 2013 - May 2013
Jacksonville, FL
Maintained several complex SSIS packages for new client; also created new SQL stored procs and SSRS reports for customers within the company.
SQL SSIS SSRS
Remove Skill
MIS Analyst
Sep 2011 - Jan 2013
Jacksonville, FL
BI consultant working with Microsoft BI Suite of Products
No skills were added
Remove Skill
Consultant
Dec 2011 - Dec 2011
No skills were added
Remove Skill
Manager - Business Intelligence
Apr 2010 - Sep 2011
Jacksonville, FL
Created data warehouse and reporting solution for Baker Distributing
Business Intelligence Data Warehousing
Remove Skill
Sep 2009 - Apr 2010
Jacksonville, FL
(contract) Reporting Analyst * Sophisticated reporting environment demanding skills in problem analysis, SQL, and Crystal Reports
No skills were added
Remove Skill
Contractor to help data conversion
Jul 2008 - Aug 2009
Lake Mary, FL
* Developed functional specifications to support the conversion of 40+ desktop applications
• Application areas included purchase order, inventory management (including planning), and restocking orders placed from fairs
• Worked heavily with Crystal Reports to replace significant number of Access reports
Crystal Reports Data Conversion
Remove Skill
Banking/Financial
Jun 2006 - Jul 2008
Jacksonville, FL
Independent BI contacts - Served as reporting specialist in sophisticated BI group
• Body Central - Designed and created a data warehouse and financial reporting system (6-million records of AS400 data), using SQL Server 2005 and Crystal Reports XI
• Beeline/MPS Group
• Reporting Specialist, developing reports, complex stored procedures Tools included Business Objects XI (including Enterprise), Crystal Reports, and SQL Server
No skills were added
Remove Skill
Project Lead and lead analyst
Jan 2006 - Jan 2006
a Citibank private banking reporting team for branch and regional managers
• Mapped data from 10 different mainframe feeds
• Created sophisticated profitability reports on lending and investment products at the manager level and tracked cross-selling activities
Project Management Product Management
Remove Skill
Edit Skills
Non-cloudteam Skill
Education
Finance/Accounting
The Ohio State University
Business Administration
The Ohio State University
Finance and Accounting
John Carroll University
Certifications
Advanced Professional Certification, Information Technology New York University's Stern Graduate Bus
Skills
SQL
2021
21
BSA
2021
16
SQL Server
2021
15
Data Warehousing
2021
14
SSRS
2021
12
Crystal Reports
2021
11
SQL Developer
2019
10
Business Intelligence
2021
9
SSIS
2015
8
Data Analysis
2021
7
Data Marts
2021
7
Stored Procedure
2013
7
ETL
2013
6
Microsoft Excel
2021
6
Requirements Gathering
2009
6
MS Power BI
2021
5
BI Developer
2021
3
Business Objects
2008
3
Database Design
2021
3
Oracle
2021
3
GIS
2015
2
SSAS
2016
2
SSMS
2008
2
Big Data
2016
1
Business Analysis
2021
1
Business Requirements
2009
1
Data Conversion
2009
1
MS SharePoint
2019
1
Requirement Analysis
2009
1
System Design
2011
1
Tableau
2019
1
Data Mapping
0
1
Data Modeling
0
1
ETL Developer
2013
1
Microsoft SMS Server
0
1
mSQL
0
1
Product Management
2006
1
Project Management
2006
1
T-SQL
0
1
Visual Studio
0
1