Justin Rafiee
Bella Vista
Summary
13+ years as a Business Intelligence Developer with background in designing, developing, and maintaining BI solutions. Proficiency in data warehouse design and data mining enhances abilities in crafting effective business strategies based on data-driven insights. Strengths include strong analytical skills, problem-solving ability, and familiarity with BI technologies such as Microsoft Power BI, SQL, DAX, M, PowerQuery. Previous work has driven significant improvement in operational efficiency through implementation of robust BI systems.
Overview
13
13
years of professional experience
4
4
years of post-secondary education
1
1
Certification
Work History
Sr. Power BI Developer
Fortitude Systems - Mark Anthony
07.2024 - Current
- Create Microsoft Power BI dashboard for newly added category, Liquid Refreshment Beverage (LRB) for newly released MAS+ energy drink.
- Build entire paginated report using Power BI Report Builder using a dynamic subscription to filter data sent to specific distributors across Sam’s Club.
- Create complex DAX formulas, also utilizing Power Query to improve the semantic data model.
- Assign and prioritize projects using JIRA, bi-weekly sprints & weekly meetings with stakeholders.
Sr. Data Engineer
YRCI
04.2024 - 07.2024
- Lead the development and execution of organization’s data strategy, with a focus on enterprise data governance.
- Design and maintain scalable, reliable data infrastructure using Power Query.
- Implement and manage Microsoft Power BI visualizations and reporting, ensuring seamless data analysis.
- Collaborate with cross-functional teams to integrate data solutions across the organization.
- Work with full acquisition process life-cycle data for various branches of government (USDA, Homeland Security, DoD).
- Assign and prioritize projects using Azure DevOps, two-week sprints & daily standups.
Sr. BI Developer
Fortitude Systems - Help At Home
09.2023 - 03.2024
- Built entire Microsoft Power BI dashboard utilizing home healthcare services data, specifically for independent living caregivers.
- Implement row-level security within Power BI, protecting sensitive data and complying with global data protection regulations.
- Create over 20 audience groups for a published app / dashboard. Consisting of almost 10,000 users to control access per tab.
- Establish analysis of the time it takes for a caregiver to arrive at patients’ home, identifying problem areas geographically.
- Assign and prioritize projects using JIRA, bi-weekly sprints & weekly meetings with stakeholders.
- Help At Home
Sr. Power BI Developer
Saliense Consulting
08.2022 - 08.2023
- Built entire Microsoft Power BI dashboard utilizing survey data for the United States Army.
- Manage SQL Server tables by creating new and modification of existing.
- Create and modify Stored Procedures and Functions in SSMS.
- Create and modify existing data visualizations in Power BI for ArmyFit.
- Optimize entire dashboard to live connection from scheduled refreshing.
Sr. Power BI Developer
The Informatics Applications Group (T.I.A.G.)
03.2021 - 08.2022
- Manage data flow for King County tax data including: billing, invoicing, accounts payable, accounts receivable.
- Manage SQL Server database by maintaining existing and new ETL processes/tables via Azure Databricks.
- Create and modify existing data visualizations in Power BI for King County IT department.
Data Analyst
Espire Services
12.2020 - 12.2021
- Manage Alteryx on Azure Cloud server, along with automated workflows.
- Ingest Twitter/News feeds via API to land in Amazon (AWS) cloud S3 bucket.
- Create and modify existing data visualizations in Power BI.
- Built fully functional dashboard for Significant Activities in Afghanistan for the United States military.
- Work with Geospatial data and GeoJSON files for various mapping layers.
- Manage and prioritize backlog in Azure DevOps.
- Work with developers to transform Alteryx workflows to Azure Databricks.
Senior Manager, Analytics & Reporting
Anheuser-Busch - Walmart Customer Sales & Tech
07.2020 - 11.2020
- Develop and manage comprehensive Power BI & Tableau dashboards to show impact of sales/profit to maximize multi-channel marketing.
- Manage SQL Server database by maintaining existing and new processes/tables.
- Manage team of 2 BI developers; provide coaching and training opportunities to fill in technology gaps.
- Maintain Quarterly International Scorecard dossier by validating major KPI’s, prior to sending to Walmart.
- Act as a business intelligence product owner, as well as hands-on developer, when needed.
- Manage projects between the development team utilizing Microsoft Teams.
- Lead projects utilizing RPA, to translate natural processing language to fully automate manual processes.
- Walmart Customer Sales & Technology
Business Intelligence Manager
Tyson Foods - Walmart Sales & Analytics
08.2019 - 03.2020
- Implementing Business Intelligence strategies for Walmart Sales, Category & Omni-Channel.
- Ensuring that all BI projects are successfully delivered on time and accurately, by the required acceptance criteria.
- Working closely with key stakeholders to gain a real understanding of Tyson / Walmart projects.
- Monitoring automated processes through Cronacle, SSIS, and C# for ETL purposes.
- Lead team of three BI developers and taking over manually maintained processes by automating them to save users time.
- Managing projects using JIRA Agile, creating Scrum/Kanban boards, & setting priorities on cadence with two-week sprints.
- Reducing Tyson’s OTIF penalties by $11MM from Walmart by providing live Tableau Dashboards.
- Liaison and project manager for Atlas related tasks in need of prioritization, organize trainings and user setup.
- Walmart Sales & Omni-Channel Analytics
Database Manager
Unilever - Walmart Category Management
10.2016 - 07.2019
- Retail Link Site Administrator responsibilities including: Item Share management, creating user ID’s, managing vendor access.
- Alteryx Gallery Administrator responsibilities including: License management, promoting workflows, Alteryx scheduler for automated tasks.
- Created an automated suite of modular reports for category advisors (Tea, Ice Cream, Multicultural Hair Care, etc.) for both Walmart and Sam’s Club, pulling directly from planograms in JDA Prospace.
- Administrator on Microsoft Azure server to host Alteryx Gallery.
- Liaison and site administrator for 3rd party ETL/data providers (RSi, Atlas, etc.).
- Create complex Alteryx workflows and applications used across the organization.
- Owner of active directory groups across Sales & Category Management for daily and weekly reporting.
- Lead Omni-Channel projects by utilizing Shopper Marketing data to enable eCommerce Sales.
- Work closely with other Retail teams (CVS, Walgreens, Target, etc.) to provide best in-class strategies.
- Utilize PowerBI, Dynamics 365 & Alteryx to create/automate daily POS reporting.
- Walmart Category Management
Manager, Pharmacy Order Monitoring
Walmart - Health & Wellness Logistics
07.2015 - 08.2016
- Manage reporting and analytics initiatives for pharmacy order compliance programs (for example, suspicious order monitoring) by developing data models, methods, and processes; serving as an analytics subject matter expert.
- Utilize Tableau Professional and Server to create reports, dashboards, and heatmaps for Health & Wellness Logistics.
- Interview Pharmacists at different stores across the network as a way to monitor orders, required by the DEA.
- Support Health and Wellness Logistics distribution centers compliance program (Reddwerks) by approving orders within a reasonable timeframe.
- Run SQL queries using Teradata to pull large datasets for analysis and reporting.
- Health & Wellness Logistics
Logistics Engineer II
J.B. Hunt Transport Inc.
01.2015 - 07.2015
- Designed and create Tableau dashboards and reports utilized by internal management and external customers to make business-savvy decisions.
- Acted as a liaison with internal IT teams to capture business related metrics.
- Maintained Tableau reports & analysis and work on enhancements to existing reports or creating new reports based on business needs.
Business Intelligence Analyst
J.B. Hunt Transport Inc.
06.2012 - 01.2015
- Data Extraction, Transforming and Loading (ETL) using various tools such as SQL Server Integration Services (SSIS), Data Transformation Services (DTS), XML processes.
- Automated multiple reports using SSRS and Microstrategy Web for external and internal customers.
- Wrote complex SQL Queries, Stored Procedures, Triggers, Views, Cursors, Joins, Constraints, DDL, DML and User Defined Functions to implement the business logic and also created clustered and non-clustered indexes.
Education
Bachelor of Science - Information Technology
University of Massachusetts
Lowell, MA 08.2010 - 02.2014
Skills
- Microsoft PowerBI Desktop & PBI Report Builder
- Alteryx Designer/Server 20231
- Tableau Professional 20231/ Tableau Server
- IBM i System Operator Workshop
- Nielsen AOD/RDH Training
- IRI Unify Training
- Microsoft SharePoint, OneDrive, Microsoft Flow
- SQL Server 2024, SSIS, Azure Databricks
- Microsoft Azure ML training (Oaktree IT)
- Test 970: System i System Operator Cert v50710
- Teradata SQL Assistant, Toad for DB2, SAP Hana
- Microsoft Outlook, PowerPoint, Excel, Word
- 13 years Windows OS, Linux OS, iOS, Android OS
- Gitlab, JIRA, Azure DevOps & Microsoft Teams
- Microsoft Azure Cloud, Amazon Webservices, GCP
- Power Query Editor, Snowflake Schemas, DAX, M
Certification
- Project Management Basics – Walmart
- Global Continuous Improvement
- Certified SAFe 4 Agilist
- DP-203 - Data Engineering on Microsoft Azure 2021
Timeline
Sr. Power BI Developer
Fortitude Systems - Mark Anthony
07.2024 - Current
Sr. Data Engineer
YRCI
04.2024 - 07.2024
Sr. BI Developer
Fortitude Systems - Help At Home
09.2023 - 03.2024
Sr. Power BI Developer
Saliense Consulting
08.2022 - 08.2023
Sr. Power BI Developer
The Informatics Applications Group (T.I.A.G.)
03.2021 - 08.2022
Data Analyst
Espire Services
12.2020 - 12.2021
Senior Manager, Analytics & Reporting
Anheuser-Busch - Walmart Customer Sales & Tech
07.2020 - 11.2020
Business Intelligence Manager
Tyson Foods - Walmart Sales & Analytics
08.2019 - 03.2020
Database Manager
Unilever - Walmart Category Management
10.2016 - 07.2019
Manager, Pharmacy Order Monitoring
Walmart - Health & Wellness Logistics
07.2015 - 08.2016
Logistics Engineer II
J.B. Hunt Transport Inc.
01.2015 - 07.2015
Business Intelligence Analyst
J.B. Hunt Transport Inc.
06.2012 - 01.2015
Bachelor of Science - Information Technology
University of Massachusetts
08.2010 - 02.2014