Data and BI Platform Engineer

Perry D. Lazenby

Data Modeler Data Analyst Snowflake Medallion Architect Power BI Architect SQL Data Visualization AWS Azure

**** ********** ***** ****, ********, GA 30038 Phone: 407-***-**** Email: *****.*******@*****.*** Open to Relocation

LinkedIn: https://www.linkedin.com/in/perry-l-b863262/

Authorized to work in the US for any employer

Summary

I have 10+ years of direct development, architecture, and leadership experience delivering enterprise on-premises/cloud data warehouse and data lake reporting environments, engaging and partnering with cross functional teams, authoring source-to-target data mappings, designing data models, collaborating with data engineers on the implementation/orchestration of ETL/ELT capabilities, authoring BI capability maturity models, developing/validating SQL code, leading the migration of legacy to cloud environments, authoring reports/dashboards, creating BI semantic models, migrating reports/dashboards to other BI platforms, developing data architecture designs, creating enterprise data warehouse bus matrix, gathering/documenting requirements, translating requirements into technical specs, facilitating SCRUM meetings, updating/managing Kanban Boards, creating/updating tasks in JIRA, creating/updating documents in Confluence, managing the overall development process (SDLC), updating/maintaining technical roadmaps, and leading data and reporting technical teams across the public, private, and state/federal government sectors.

Education

●Tennessee Wesleyan University, Athens, Tennessee

Bachelor’s degree in business management

●Edmondson Junior College of Business, Chattanooga, TN

Associate degree in Computer Science

Technical Skills

●Big Data Technology: Data Lake, Hadoop, HDFS, Hive SQL

●Cloud Technology: AWS Quicksight, Snowflake, dbt, Microsoft Azure (Azure SQL Server, Power BI Services, Common Data Model, Azure Data Flows, Azure Machine Learning, Azure DevOps)

●BI Tools: Microsoft Fabric, Oracle SQL Developer, Microsoft Power BI Desktop and Report Server, MicroStrategy, Tableau, Cognos Analytics; SSRS, SSAS, and T-SQL; Qlik; SAS Studio (Base SAS), R Studio

●Data Science Tools & Libraries: Python, R, Jupyter Notebook, Numpy, NuPandas, Scikit-Learn

●Marketing Analytics Tools: Google Analytics, Adobe Reports and Analytics (Omniture), UNICA

●Database Management and Query Tools: PostgreSQL, Teradata, SQL Server, ORACLE, IBM DB2, Sybase, Informix, MS Access; TOAD, SQL Developer, Oracle PL/SQL, IBM IMS Database

●ETL Tools: Pentaho PDI, SSIS, Cognos Data Manager, Alteryx

●Other Software: VS Code, Docker, Airtable, Alation, GitHub, Miro, SharePoint Online, Confluence, JIRA

●Operating Systems: Windows, MVS, OS2, AS400, UNIX Solaris, UNIX AIX, Linux, Apple Mac

●Office Tools: Microsoft Office (Word, Excel, PowerPoint, Access, Visio)

Professional Experience

TEKsystems

Disney World, Orlando, FL July 2024 to Present

Data Architect/BI Consultant (Contract)

Collaborated with Data Product Managers and Data Engineers on the design and development of conceptual, logical, and physical data models for the Snowflake Bronze/Silver Layers and led the design/development of conceptual, logical, and physical star schema data models for the Gold Layer to support data liquidity, reduce redundancy, improve data quality, and improve reconciliation across multiple business domains throughout Disney.

Partnered/collaborated with the data architecture team to develop/update DBT code to materialize incremental/non-incremental data models in the Silver and Gold Layers in Snowflake.

Updated epics/stories in JIRA and attended daily Sprint Meetings.

Created, updated, and published data model designs using Miro.

Participated in daily online work sessions with the Lead Data Engineer and Lead QA Tester.

As required, built reports and dashboards in Tableau, Power BI, and MicroStrategy using the data models in the Snowflake Silver and Gold Layers.

University of Texas MD Anderson Cancer Center, Houston, TX Apr 2024 to June 2024

Project Lead/Lead Power BI Consultant (Contract)

●Served as the Project Leader and Lead Power BI Consultant responsible for gathering requirements, transformed functional specs, led client meetings, created/updated JIRA tickets, participated in daily Scrum Meetings, managed Power BI Administration, developed Machine Learning ML models with Python, and developed operational and executive-level dashboards in Power BI for the HR, finance, and clinical divisions of the University of Texas MD Anderson Cancer Center.

●Led the design and development of star schema data models in Microsoft Fabric and Power BI, built/orchestrated ETL dataflows in Microsoft Fabric, created/tested PL/SQL and SQL code using Oracle SQL Developer, developed calculated measures using DAX, built M Language to transform data, developed visual calculations in Power BI Visuals, published dashboards to Power BI Online, applied data/object security, and deployed dashboards to Power BI Apps.

ITility, Inc Chantilly, VA Jan 2023 to Mar 2024

Manager, Data Management and Business Intelligence Reporting

●After successfully serving as the Project Leader and Lead Business Intelligence Developer of the Power BI/SQL Server to AWS Cloud migration project, promoted to Manager of Data Management and Reporting.

●Led and managed a team of analysts and reporting professionals; facilitated and participated in meetings with the client and various project teams; gathered user requirements; transformed business requirements into technical specs; participated in team collaboration; performed project management; created/tracked/updated tasks in JIRA; and created/updated documentation in Confluence.

●Developed/supported efficient, scalable SSIS pipelines and shared Power BI semantic models in the clients on-premises legacy environment.

●Developed, enhanced, and maintained SQL, reports, and dashboards.

●Led the design of Power Query extracts, M Language code, and DAX measures in Power BI.

●Developed source-to-target mappings to support data integration capabilities.

●Performed and published to the client a comparative analysis between the following COTS, Cloud, and open-source BI tools: Power BI (on-premises and cloud), Cognos BI, AWS Quicksight, Grafana, OBIEE, and Tableau.

22nd Century Technologies (University of Central Florida), Orlando, FL Nov 2021 to Nov 2022

Lead BI Consultant (Contract)

●Served as a Lead BI Consultant responsible for Power BI Administration and Development, facilitating remote/onsite meetings, gathering requirements, transforming business requirements into technical specs, create/update Power Query and M Script code to import/transform data into Power BI, create explicit measures/calculated columns using DAX to derive and display data in Power BI reports and dashboards.

●Enhanced and supported existing Tableau dashboards published to the Tableau Server.

●Reverse engineered and migrated an extensive number of Tableau and SAS Analytics dashboards to Power BI.

●Architected data models in Power BI, built Azure Data Factory pipelines to load local data files into Azure Data Warehouse, and developed custom data exploration, interactive dashboards.

Deloitte, Lake Mary, FL Jan 2021 to Nov 2021

Solution Manager/Architect

Served as the managing consultant and senior developer on the Deloitte Data Warehouse Reporting and Analytics Team responsible for leading and managing the transition from an on-premises legacy data warehouse to a modern cloud-based Snowflake Data Warehouse for the State of FL Medicaid Office. Directly accountable for daily task coordination, developing/tracking action items, project management, development of the Cognos Analytics portal/report solution, interviewing/hiring potential candidates, managing workstreams, meeting/confirming requirements with the client, creating/managing development schedules, managing/tracking project deliverables, and serving as an individual contributor (when necessary) for portal/report development. Led a team of consultants responsible for the delivery of the State of FL Medicaid Office– CMS Data Warehouse Reporting Solution.

TEKsystems (Advent Health), Orlando, FL Mar 2020 to Jan 2021

Lead BI/Analytics Engineer (Contract)

Led the development and architecture of advanced Power BI operational and executive level dashboards to support state/federal reporting requirements. Trained and transferred knowledge to other junior developers.

Satcom Direct, Melbourne, FL Oct 2019 to Mar 2020

Manager, Data Analytics

Led the development and architecture of SSRS Datasets and Paginated Reports; SSAS Tabular Models; Power BI Models, Data Flows, and Dashboards using Microsoft On-Premises and Azure Cloud technology (Power BI Services, Common Data Model, Azure Data Flow, Azure Machine Learning, Azure DevOps).

Insight Global (Leidos), Orlando, FL Apr 2019 to Oct 2019

Visualization and Analytics Solution Architect (Contract)

Led the development of operational and executive level reports/dashboards and ML models using the following BI Stacks and technologies: Python, TOAD, Cognos Analytics v11.0.3.0, Tableau v2019, MicroStrategy, and Power BI Desktop. In addition, I also led the architecture and development of on-premises Power BI and Microsoft Azure Cloud (Power BI Services, Azure Data Flows, Azure Machine Learning Models) solutions as well as creating and updating technical documents in SharePoint.

Data Dimensions, Lake Mary, FL Nov 2017 to April 2019

Lead Microsoft BI Developer/Architect

Led the development/architecture of interactive dashboards and reports against normalized (SQL Server OLTP) and de-normalized data sources (SQL Server Data Warehouse) using the toolset within the Microsoft BI stack (Power BI, SSRS, SSAS, Report Builder, and T-SQL)

TEKsystems (Disney World), Orlando, FL May 2017 to Nov 2017

Sr Marketing Data Analytics Consultant (Contract)

Served as the lead marketing data and analytics developer responsible for harvesting, analyzing, and visualizing Disney Parks and Resorts data using a combination of Google Analytics, business intelligence, and other web analytic tools to support the development and optimization of website traffic and marketing campaigns. Created operational and executive level dashboards in Tableau and published dashboards to the Tableau Server.

University of Florida College of Pharmacy, Orlando, FL Dec 2016 to May 2017

Data Management Analyst III

Served as the lead data manager and report developer responsible for sourcing and transforming provided data using Pentaho, storing data in SQL Server, and developing reports.

Cricket Wireless, Atlanta, GA Jul 2016 to Dec 2016

Sr Sales Operations Reporting Manager

Served as the technical leader in a team of six developers responsible for using TOAD to extract, analyze, and compile sales operations and point-of-sales data. Used Power BI and Excel PowerPivot to develop insightful, visually compelling reports and analytics used for executive leadership consumption.

Hilton Grand Vacations, Orlando, FL Nov 2015 to Jul 2016

Lead BI and Analytics Developer/Architect

Served as the technical lead responsible for the architecture and delivery of insightful analytics, reporting, and dashboard solutions for the Sales, Finance, and Marketing Divisions of Hilton Grand Vacations. Responsible for managing software license/entitlements, maintaining the BI Roadmap, and staying abreast of emerging technology throughout the industry.

SunTrust Bank, Atlanta, GA Feb 2015 to Nov 2015

Marketing Analytics Architect/Developer (Contract)

Provided direct leadership on the architecture and development of all marketing reporting and analytic solutions used to support the enterprise marketing team’s ability to monitor and track the effectiveness of website traffic and marketing campaign performance across multiple channels.

Contact this candidate