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 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.

view more

view less

• 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.

view more

view less

• 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.

view more

view less

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.

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.

(contract) SharePoint engineering Reporting and Analysis for Migration project * Engaged to create tracking and reporting for large migration project (from Open Text to SharePoint

Engaged as SQL Developer for new Data Mart and reporting site

SQL Developer/Analyst for complex tax department application using "big data" techniques

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.

• 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.

view more

view less

Maintained several complex SSIS packages for new client; also created new SQL stored procs and SSRS reports for customers within the company.

BI consultant working with Microsoft BI Suite of Products

Created data warehouse and reporting solution for Baker Distributing

(contract) Reporting Analyst * Sophisticated reporting environment demanding skills in problem analysis, SQL, and Crystal Reports

* 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

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

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