Anthony Lipinski Email & Phone Number

• Administered the creation and optimization of large multi-tenant Azure SSAS Tabular data models utilizing syndicated data such as Nielsen and NABCA
• Architected new model functionality allowing clients to quickly perform critical cross-product analysis which previously required running and manually combining multiple reports
• Optimized very complex DAX formulas running against hundreds of millions of rows of model fact data to allow reports to render within an acceptable time to meet client expectations
• Utilized SQL programming knowledge to troubleshoot and resolve data harmonization irregularities in Snowflake source system
• Created dynamic report attribute slicers to allow for quick and seamless analysis and report updates
• Authored Azure runbooks with PowerShell code to facilitate model updates and refreshes

Providing Power BI consulting services to businesses seeking expert advice and guidance on getting the most out of their data.

Orlando, Florida Area (Remote)

• Formerly Food Services of America (11/2014 to 9/2019)
• Spearheaded enterprise-wide migration to Microsoft Power BI. Create dashboards, scorecards and apps within the application for various corporate departments across organization
• Created new large SQL Server Analysis Services (SSAS) tabular models and migrated Powerpivot models to SSAS tabular across all business aspects with emphasis on financial data and systems
• Wrote complex Data Analysis eXpression (DAX) code for customized measures and metrics in Power BI and SSAS tabular to create KPIs and facilitate the creation of actionable analytics
• Authored new intricate multidimensional data cubes involving the scripting of complex MDX statements including numerous scope expressions and custom measures to facilitate correct reporting of specialized time.
• Worked closely with multiple teams to understand, document and implement report requirements

Maitland, FL

• Helped coordinate the upgrade of JD Edwards financial system to most current version
• Performed data migration from old system to updated system
• Administered JD Edwards system and handled user requests for changes and improvements

Maitland, FL

• Created the company's first data mart by single-handedly creating a dimensional model of the underlying business processes and constructing the required database using surrogate keys, slowly changing dimensions and.
• Developed new ETL process using SSIS to populate the data mart using advanced features of the product such as fuzzy grouping, checkpoints/package restartablility, and incremental data loading as well as customized.
• Designed new data analysis cube using SSAS to faciliate crucial complex data analysis never before done by the organization
• Migrated vital DTS (SQL Server 2000) packages to SQL Server 2008R2 Integration Services to ensure data critical to the business would continue to be available going forward (DTS packages are no longer supported by the.
• Converted existing crystal reports to SQL Server 2008R2 Reporting Services, enhancing the reports with drill-through and drill-down capabilities
• Rewrote existing SQL stored procedures to improve underlying logic and dramatically shorten query run times

Maitland, FL

B.S./M.B.A., Accounting, Business, Law

Jd, Law