We provide IT Staff Augmentation Services!

Sr. Bi Consultant Resume

SUMMARY

  • Recent assignments (over the past 5 - 6 years) have used my skills with Power BI (reports and dashboards) Most reporting involves numerous data sources, but I have expanded my SQL Server skills on Datamarts and on production environments. At Allstate I spent 4-5 months creating complex Power Apps (Automate/Flow) scripts to replace Nintex flows. I have also worked with Tableau for several projects.

PROFESSIONAL EXPERIENCE

Confidential

Sr. BI consultant

Responsibilities:

  • SQL development of data warehouse views for a complex Power BI report file for the Aviation group. Aided in the importation of data from several databases at the FAA website.
  • Created Power BI reports and dashboards connected to data warehouse objects imported from ERP application. Other data sources included SharePoint, complex SQL (CTEs and UNION) and spreadsheets.

Confidential

Sr. BI consultant

Responsibilities:

  • Created portfolio of Power BI reports and dashboard pointing to production data processing new applications and renewals. Helped set up Power BI portal.
  • Converted portfolio of Nintex flows to Power Automate over 5-month period.
 

Confidential

Sr. BI consultant

Responsibilities:

  • Engaged to create tracking and reporting for large migration project (from Open Text to SharePoint 2013/2016 and other applications). Created SharePoint objects for migration specialists including lists, pages, web parts, views, and SSRS reports with hyperlinks to filtered SharePoint pages.
  • Created underlying SQL Server data mart this tracking, including direct link/download from SharePoint Lists (SSIS and C#) and uploading enhanced data to SharePoint. Comprehensive synchronization established between SQL data and SharePoint lists.

Confidential

SQL Developer

Responsibilities:

  • Created data mart for Incentive Compensation business unit - capturing approx. 20 million transactions to enhance analytical reporting.
  • 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

Confidential

SQL Developer

Responsibilities:

  • Import, transform, manipulate and analyze "big data" files from financial institutions (hundreds of millions of records) using SSIS.
  • Create multi-million record tax refund requests for State taxing authorities.

Confidential

BI Advanced Reporting / SQL Developer

Responsibilities:

  • 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

Confidential

Reporting Specialist

Responsibilities:

  • Expanded and modified existing portfolio of Business Objects and SSRS reports
  • Mastered Business Objects and SSRS reporting environments with thousands of reports

Hire Now