Uploaded File
Frederick
fredstimler@comcast.net
904-716-5453
Jacksonville, FL 32224
BI Developer
16 years experience W2
2
Recommendations
Average rating
384
Profile views
Summary

Experience
Business Intelligence Analyst
Healthcare
Jul 2016 - present
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
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 to create Oracle-based Data Mart
Information Technology
Jul 2016 - Jan 2018
(contract)
• 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.
• Setting up SQL Server 2016 / SSRS so analysts can query data mart by Agencies, Agents, Products, etc.
• Managing two resources charged with moving the data mart to production and replacing large report base to SSRS 2016 and Power BI
Data Marts Data Warehousing Database Design Oracle SQL SQL Developer SQL Server SSRS MS Power BI Microsoft Excel
Remove Skill
Nov 2015 - May 2016
(contract for major law firm tax department) SQL Developer
• Import, transform, manipulate and analyze "big data" files from financial institutions (hundreds of millions of records)
• Create multi-million record tax refund requests for State taxing authorities and consult with auditors
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
Dec 2013 - Oct 2015
Jacksonville, FL
BI Advanced Reporting / SQL Developer
• 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.
No skills were added
Remove Skill
Sep 2011 - Jan 2013
Jacksonville, FL
(employee) Reporting Specialist
• Expanded and modified existing portfolio of Business Objects and SSRS reports
• Mastered Business Objects and SSRS reporting environments with thousands of reports
• For finance / accounting, designed the process to help redistribute fees to business lines and customers for billing / costing purposes
No skills were added
Remove Skill
Banking/Financial
Apr 2010 - Sep 2011
Jacksonville, FL
(employee) Reporting and Data consultant
• Managed several projects including complex BI implementation at $2 Billion hard goods distributor
• Created mapping document to organize data flow between a financial system (orders, inventory and other financial data) into the data warehouse
• Designed and implemented over 150 dynamic SSRS reports
• Created reporting specifications for offshore programmer to replace full sales reporting system, design data warehouse (facts, dimensions, etc.), and load inventory tables for inventory reporting
No skills were added
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
18
BSA
2021
16
SQL Server
2021
15
Data Warehousing
2021
13
Crystal Reports
2021
11
SSRS
2021
11
SQL Developer
2018
8
SSIS
2015
8
Data Analysis
2021
7
Stored Procedure
2013
7
Business Intelligence
2021
6
ETL
2013
6
Microsoft Excel
2021
6
Requirements Gathering
2009
6
Data Marts
2021
5
BI Developer
2021
3
Business Objects
2008
3
Database Design
2021
3
MS Power BI
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
Requirement Analysis
2009
1
System Design
2011
1
Tableau
2015
1
Data Mapping
0
1
ETL Developer
2013
1
Product Management
2006
1
Project Management
2006
1
T-SQL
0
1