PIPER L. COHN
2045 Darien Park Drive
Roswell, GA 30076
770-380-2253
CAREER PROFILE
Highly motivated and dynamic Data Architect and Senior BI Developer with a broad range of experience overseeing the performance of systems seeks to bring skills to an organization that values hard work, dedication, and results. Expertise in managing and organizing software solutions to implement has led to support for clients and business partners. Demonstrated team management, strategic planning, and technical expertise has helped exceed organizational goals and objectives.
Azure Data Factory
Azure SQL DW
Azure Data Lake
Microsoft BI Stack (SSIS, SSAS, SSRS)
Power BI & Mobile Reporting
SQL Server
Tableau
AWS
Oracle
Teradata
Microsoft Office Suite
Microsoft Windows Server Platforms
Visual Studio
Visual FoxPro
VB Net
ASP.Net
ArcView-GIS
Many other languages and software platforms..
PLC Consulting Inc. Projects (Principal Consultant):
Fortitude Systems, Falls Church, VA
July 2023 – October 2024
BI & Data Analytics Architect / Solution Architect
Created and streamlined process for the following areas in the trilogy of companies that included (Fortitude Systems, BlueROCK Consulting, and Meritus Executive Search)
Data Governance
Deployment Processes and Methodology
Change Management Processes and Methodology
Organizational Intranet including
· Operational Table of Contents
· Backlogs
· Metrics and KPI Inventory
Created analytical models for accurate reporting.
Created and Implemented Power BI Deployment plan.
Guided on Power BI and analytics best practices.
Deliver customized training.
Power BI Architect and Subject Matter Expert (SME) on security, technical best practices and configurations to build streamlined solutions.
Developed and maintained Power BI data models, dashboards and reports that were created from the ground-up.
Guided the business to get detailed requirements via supportive leading questions and authoritative guidance.
Created tabular models and Power BI templates with governance and security for self-service analytics.
Created Power BI Center of Excellence (COE)
Tanger Outlets, Greensboro, NC
June 2022 – June 2023
Senior Power BI Lead / Solution Architect
Worked with CXO Leadership to define the strategy aligning to business objectives and growth.
Collaborated with the internal BI team to migrate to Power BI from Tableau.
Migrated current analytics environments to Azure.
Created models for accurate reporting.
Created and Implemented Power BI Deployment plan.
Guided Customers on Power BI and analytics best practices
Attended business meetings with Product Owners
Worked extensively with SQL Server and Oracle database systems.
Power BI Architect and Subject Matter Expert (SME) on security, technical best practices and configurations to build streamlined solutions.
Developed and maintained Power BI data models, dashboards and reports that were created from the ground-up.
Guided the business to get detailed requirements via supportive leading questions and authoritative guidance.
Created tabular models and Power BI templates with governance and security for self-service analytics.
Created Power BI Center of Excellence (COE)
Republic National Distribution Company (RNDC), Atlanta, GA
November 2020 – June 2022
BI & Data Analytics Architect / Solution Architect
Worked with CXO Leadership to define the strategy aligning to business objectives and growth.
Collaborated with the internal BI team to deliver data/analytics solutions to the business owners.
Assessed current analytics environments.
Created analytics roadmap.
Worked with many disparate systems to consolidate data.
Worked with Cloud data tools such as Azure SQL Synapse analytics, Data Factory, Spark (Scala/python), Data bricks, Delta Lake, and others.
Worked extensively with SQL Server and Oracle database systems.
Created and Implemented Power BI Deployment plan.
Guided Customers on Power BI and analytics best practices
Deliver customized analytics training.
Attended business meetings with Product Owners
Understood & communicated scope, assumptions, and business dependencies.
Power BI Architect and Subject Matter Expert (SME) on security, technical best practices and configurations to build streamlined solutions.
Developed and maintained Power BI data models, dashboards and reports that were created from the ground-up.
Guided the business to get detailed requirements via supportive leading questions and authoritative guidance.
Created tabular models and Power BI templates with governance and security for self-service analytics.
Created Power BI Center of Excellence (COE)
Manhattan Associates, Atlanta, GA
November 2019 – October 2020
Senior Power BI Lead / Solution Architect
Worked with CXO Leadership to define the strategy aligning to business objectives and growth.
Collaborated with the internal BI team to move EDW to AZURE
Worked with Cloud data tools such as Azure SQL Synapse analytics, Data Factory, Spark (Scala/python), Data bricks, Delta Lake, and others.
Participated in the setup of Azure (SQL, AAS, Data Lake, Databricks, other needed resources)
Worked with SSIS and Azure tools to perform ETL.
Advised on Power BI infrastructure sizing.
Collaborated with the internal BI team.
Guided Customers on Power BI and analytics best practices
Determined the viability of proposed features.
Attended business meetings with Product Owner
Worked with many disparate systems to consolidate data.
Created models for accurate reporting.
Understood & communicated scope, assumptions, and business dependencies.
Created Power BI Administration Road maps with activities around environment refresh, tenant settings, integration settings, content, and app settings etc.
Developed and maintained Power BI data models, dashboards and reports that were created from the ground-up.
Trimax Americas, Princeton, NJ
February 2019 – October 2019
Senior Power BI Solution Architect
Expert on Power BI Premium infrastructure sizing.
Setting up infrastructure in a multi geographic environment.
Guided Customers on Power BI and analytics best practices
Guided Customers on Power BI security and content organization
Guided Customers on Power BI Administration Road map with activities around environment refresh, tenant settings, integration settings, content and app settings etc.
Breakthru Beverage Group, New York, NY
December 2018 – February 2019
Senior Power BI Solution Architect
Worked with the internal BI team to create Sales Tabular Model
Coded complex DAX calculations and KPI’s.
Coached internal BI team on best practices.
Setting up the complete Power BI infrastructure with dev/test/qa and prod environments.
Setting up Power BI security infrastructure both at data level (row level security) and content level.
Guided the customer on Power BI security and content organization.
Guide the customer on Power BI Administration Road map with activities around environment refresh, tenant settings, integration settings, content and app settings etc.
First Key Homes, Atlanta, GA
July 2018 – November 2018
Business Intelligence Solution Architect
Technical expert in the areas of AZURE and MS BI Stack
Worked with operations leadership including the COO to deliver accurate planning and delivery.
Expert on Power BI Premium infrastructure sizing. Setting up infrastructure in a
multi geographic environment.
Running load tests with different user, report and schedule refresh throttle.
Setting up the complete Power BI infrastructure with dev/test/qa and prod environments.
Setting up Power BI security infrastructure both at data level and content level.
Guided the customer on Power BI security and content organization.
Set up the audit and monitoring environment to keep a check on environment use and adaption.
Guide the customer on Power BI Administration Road map with activities around environment refresh, tenant settings, integration settings, content and app settings etc.
Trained in the creation of Power BI reports to provide a 360-degree view of each business unit.
Gathered requirements and worked with each business unit to deliver ROI.
Mentored the business units on data analytics best practices.
Trained users on best practices and how to use Power BI proficiently.
American Red Cross, Washington, DC
February 2018 – July 2018
Business Intelligence Architect & Data Architect - Technical Lead
I was accountable for smooth and effective coordination of development activities between on and offshore teams, clear communication of status, escalation of issues, on-time completion of tasks, completing deliverables, and reaching milestones by the agreed upon dates.
Acted as full-stack technical expert in the areas of AZURE and the MS BI Stack including Power BI
Ran the daily “Scrum” calls with on and offshore teams.
Assigned Tasks with priorities and due dates.
Owned tasks detail record keeping – clarity, consistency, clear communication.
Created/Maintained Milestone Plan
Determined viability of proposed features
Attended business meetings with Product Owner
Estimated target dates to map to releases.
Created status reports with regular cadence.
Managed risks with mitigations and contingency plans
Managed issue identification and resolution
Understood & communicated scope, assumptions, and business dependencies.
Proactively tracked down tasks and status to reports slippage.
Acuity Brands, Conyers, GA
October 2017- February 2018
Business Intelligence Architect & Data Architect
Worked with the internal BI team to move EDW to AZURE
Created Tabular Models in SSAS and coded complex DAX measures.
Worked iteratively with IT and the business users to gather requirements and perform Q/A
Achieved consistent reporting metrics and data migration with SSIS and Power BI
Worked with operations leadership including the COO to deliver accurate planning and delivery.
Expert on Power BI Premium infrastructure sizing.
Setting up Power BI security infrastructure both at data level (row level security) and content level.
Guided the customer on Power BI security and content organization.
Guide the customer on Power BI Administration Road map with activities around environment refresh, tenant settings, integration settings, content and app settings etc.
Provided in Power BI Training
TEKsystems, Jacksonville, FL
July 2017-October 2017
Senior Power BI Solution Architect
Worked through Microsoft Gold Partner to deliver multiple projects
Delivered BI assessment for large auto finance company located in Dallas TX
Current State Assessment
Future State Recommendations
Roadmap
Power BI Expert in planned and Implemented Power BI Premium enterprise deployment
Worked with operations leadership to deliver accurate planning and delivery
Expert on Power BI Premium infrastructure sizing.
Setting up infrastructure in a multi geographic environment.
Setting up the complete Power BI infrastructure with dev/test/qa and prod environments.
Setting up Power BI security infrastructure both at data level (row level security) and content level.
Guided the customer on Power BI security and content organization
Guide the customer on Power BI Administration Road map with activities around environment refresh, tenant settings, integration settings, content and app settings etc.
SSAS MDX measures and DAX measures in Power BI models
Passed Exam 70-768: Developing SQL Data Models
Porex a division of Filtration Group, Atlanta, GA
January 2017-June 2017
Senior BI Developer & Data Architect
Lead migration of the existing legacy dashboards which source SSAS Cubes to Power BI and AZURE
Power BI Expert (Data Modeling, Data Set ETL, Power BI Report development utilizing best practices)
Power BI filters & Active Directory Security Utilized
SSAS measures recreate calculated to DAX measures in Power BI models
Worked iteratively with IT and the business users to gather requirements and perform Q/A testing
Achieved consistent reporting metrics and data migration with SSIS and Power BI
Recommended MDM, and organization model for establishing a BI competency
Georgia Secretary of State, Atlanta, GA
September 2016-November 2016
Enterprise Data Architect
Leading a team of 5 including PM, BA, QA, Developer, and Myself as architect.
Utilizing SharePoint and SQL Server 2014 to automate processes that intakes payments received.
These processes created flat files to be consumed by PeopleSoft for the State Accounting Office utilizing SSIS.
The SSIS project is deployed to the SSIS catalog for operational reporting.
Worked extensively with SQL Server, Oracle, and Teradata database systems.
The process included Audit Reporting using Power BI and SSRS.
Sysco Foods, Houston, TX
August 2016-September 2016
Senior BI Developer & Data Architect
Expert Adviser tasked with leading to completion a tardy 12month project in less than 4 weeks.
Created and implemented a plan to complete and test the financial planning and analysis forecasting model.
The backend database was SQL server 2014 which sourced data from home grown systems and SAP.
The frontend application was composed of a customized SharePoint site, VB.Net, and Excel.
Lead the project to successful completion within the timeline.
ARG, Atlanta, GA
February 2016–July 2016
Enterprise Data Architect
Staffed a team of 5 FTE’s and 4 Contractors
Facilitated the establishment and execution of the roadmap and vision for information delivery and management, including the enterprise data warehouse, big data, BI & analytics, content and data management.
Hands on Power BI Expert
Skilled in Data Modeling, Data Set ETL, Power BI Report Development with best practices
Utilized Power BI filters & Active Directory Security
Worked with multiple Microsoft SME to define requirements for Azure POC including project plan and execution with (ADGILE/Waterfall) approaches.
Delivered Azure POCS
Delivered future state hybrid Azure cloud roadmap which sourced SQL Server and Oracle data with Azure Data Factory into Azure Data Lake, SQL DW, and Self-Service BI technologies.
Lead data architects and data engineers to architect and deliver the solutions that fulfill the Business information needs and align with the information vision and strategy
Applied business strategy while driving technology strategy, balancing short term and long term needs to ensure that the architecture can scale and evolve accordingly
Engaged an end-to-end approach by connecting all the pieces of data to deliver the data while leveraging all available assets
Provided advice, guidance, direction, and authorization to carry out major plans and procedures to ensure schedule attainment, product development process adherence, and performance and budget targets are met
Took an active role in the performance management process by completing goal setting, interim review, and year-end review on a timely basis and soliciting ongoing feedback
Georgia Pacific, Atlanta, GA
February 2015 – January 2016
Data Architect & Senior BI Developer
Oversaw the packaging group on Power BI, DataZen, PowerPivot, SSRS, SSIS, SSAS, MDX, and MDM to deliver robust multi-dimensional BI solutions sourced from GP’s EDW and Hadoop.
Utilized Azure cloud to correct storage and performance bottlenecks.
Developed and modified parts to accommodate data mining and reporting needs for departmental needs while managing the Power BI training to business analysts and managers
I created and maintained reporting using Power BI/DataZen
Implemented DataZen mobile BI proof of concept for Corrugated, Packaging, and Containerboard divisions.
Cricket Wireless, Atlanta, GA
September 2014–February 2015
Data Architect & Senior BI Developer
Managed the comprehensive assessment of Azure, Hadoop, DW and BI environments focusing on related data warehouse logical and physical design and implementation.
Identified and prioritized platform solution capability improvement opportunities and maintained a path of successful initiatives.
Reviewed OLAP security, partitioning, and aggregation strategies along with data acquisition processing and SSIS tuning recommendations.
Performed extensive Data Modeling to deliver recommendations for future state.
Implemented DataZen mobile BI proof of concept
Daugherty Projects (contractor):
Coca-Cola of America, Atlanta, GA
May 2014–September 2014
Data Architect & Senior BI Developer
Supported the Segmentation Analytics Director to develop a self-serve analysis and list creation tool that sources the Hadoop and Teradata EDW with summary table ETL populating several SSAS cubes.
Utilized Azure cloud to correct storage and performance bottlenecks.
Developed and managed reports utilizing Power BI, DataZen, PowerPivot, and SSRS.
Worked extensively with SQL Server, Oracle, and Teradata database systems.
Genuine Parts Company, NAPA, Atlanta, GA
March 2014–May 2014
Data Architect & Senior BI Developer
Collaborated with internal IT departments on the RPM project which replaced the existing TAMSII point-of-sale system with TOMAX for over 6,000 NAPA stores.
Utilized integration mapping between multiple source systems and TOMAX including JD Edwards, Hadoop, AS400, DB2, SQL, Oracle, and other text files.
Worked with Customer Data to create MDM standards for accurate sourcing and reporting.
The Home Depot, Atlanta, GA
July 2013–March 2014
Data Architect & Senior BI Developer
Established a BI COE while supporting the Enterprise Business Intelligence Director and assisted the internal IT department implementing Tableau deployment for business users including training and best practices.
Successfully expanded Hadoop and Teradata EDW to include new data points and surfacing to include data in Micro Strategy dashboards and reports.
Delivered future state hybrid Azure cloud roadmap which sourced SQL Server and Teradata.
Developed MDM dotcom unique SKU projects that ensured accurate gross margin reporting.
BAC Projects (contractor):
CPC, Alpharetta, GA
February 2013–July 2013
Data Architect & Senior BI Developer
Led the development of a SSRS, PerformancePoint, and SharePoint BI reporting solution for CPC’s safety group while establishing a SQL database for reporting and coded SSIS packages.
Designed and implemented SSRS and PerformancePoint custom dashboards that were utilized in the Safety SharePoint site for management reporting.
RPC INC., Atlanta, GA
September 2012–February 2013
Data Architect & Senior BI Developer
Successfully coordinated with RPC’s internal corporate IT department to develop an enterprise and end-to-end data warehouse solutions while modeling data using SQL 2012.
Managed the coding of SQL 2012 SSIS jobs for staging and the final production database and designed a 2012 logging framework using the new development model and custom logging which allowed for easier management and reporting.
Developed and managed reports utilizing Power BI, PowerPivot, and SSRS.
Gwinnett County Public Schools, Suwanee, GA
October 2010-September 2012
Data Architect & Senior BI Developer
Led the development of an operational data store while coordinating with GCPS’s internal information management team to gather data from the mainframe and store it in the ODS which helped establish useful security policies, master data, and CRUD applications to source from the ODS.
Ported DB2 EDW code to SQL 2008 and ported Data Manager code into SSIS while successfully overseeing SSIS jobs that utilized an operations database for logging, tracking and management.
Microsoft, Alpharetta, GA
September 2009–October 2010
Data Architect & Senior BI Developer
Developed a Partner Management Framework (PMF) web facing dashboard while collaborating with the Worldwide Group which provided management with partner statistics and tools.
Designed and implemented an SSIS Jos to collect data from sources to put into PMF’s data warehouse.
Provided database architecture and modeling for one of Microsoft’s databases for its integrated reporting initiative while analyzing multiple data sources to establish a single data model.
Oversaw the authoring of code to manage and correct dimensional taxonomy and business rules for efficient and accurate reporting.
Med Assets, Alpharetta, GA
July 2008 – September 2009
Data Architect & Senior BI Developer
Led the architecture and implementation of a Performance Point Planning Server application which supported billing, revenue, and adjustment schedules for revenue types while coordinating with a Microsoft gold partner.
Established custom InfoPath forms to enter parameters, PPS Excel reports to review results, and custom web parts to run SSIS ETL packages in order to load PPS models for dynamic results.
Successfully oversaw the architecture of a relational database while writing several custom SSIS ETL packages and scripts to consolidate MSCRM and Solomon data.
Microsoft, Alpharetta, GA
December 2007–July 2008
Data Architect & Senior BI Developer
Collaborated with a Microsoft Gold Partner to establish a proof-of-concept Performance Point Server for Windows 2003 and implemented the project while coordinating with Microsoft Worldwide.
Managed the installation of all software and built backend data models utilizing SSAS and PPS Data Modeler.
Configured KPI’s, reports, and scorecards for the custom SCMDM dashboard with the PPS Dashboard Designer.
Published dashboards to a customized SharePoint Site for internet delivery and document management.
Magellan Health Services, Columbia, MD
August 2007–December 2007
Data Architect & Senior BI Developer
Supported Magellan’s internal corporate IT to create and modify existing internal claims snowflake schema in order to accommodate external claims.
Designed cubes and dimensions in SSAS based on the logical data model and coded SSIS ETL packages and designed SQL Reporting Services to provide management with company metrics.
Post Properties, Atlanta, GA
May 2007–August 2007
Data Architect & Senior BI Developer
Led the development of SQL Reporting Service dashboards and reports while assisting Post Properties’ internal corporate IT department.
Authored MDX queries to pull data from analysis services cubes into temp tables for efficient reporting architectures and developed a data warehouse model with cubes and dimensions in SSAS.
Oversaw the training and development of Post Properties IT staff through careful mentoring on Reporting Services, SSAS, and SSIS for maintaining the ETL.
Microsoft, Alpharetta, GA
August 2006–May 2007
Senior Software Developer
Developed and implemented SQL Reporting Services while collaborating with Worldwide Group and US-EPG group which provided C&C Sweet Sport statistics for software licenses and real-time quote to revenue figures for sales regions and industries.
Maintained database architecture and modeling for software licenses and sales and marketing reporting for Microsoft’s integrated reporting initiative.
Provided data analysis from multiple sources to define a single model and perform transformations to derive correct dimensional taxonomy.
Automated and scheduled SSIS packages to correctly and efficiently manage Development, Quality Assurance, and Production servers.
Produced SDLC documentation and supported Microsoft IT to on-board the dashboard with a Silver Certified Application.
Georgia State Patrol, Atlanta, GA
May 2006–August 2006
Data Architect & Senior BI Developer
Directed the development of a system to modernize the delivery and storage of internal documents which converted existing Incident Report forms from Microsoft Word to Web forms
Utilized a combination of InfoPath, Windows Workflow, SharePoint 2007, and SQL Server 2005 to develop, route, approve, and catalog the new Incident Reports.
The Intellection Group, Duluth, GA
April 2005–May 2006
Senior Software Developer
Served as the primary consultant in a 2-phase project for Siemens AMD Division which expanded POS data capture and reporting systems.
Phase 1focused on migrating POS data from Microsoft Access to a SQL Server with SQL Reporting Services.
Designed a new SQL database and wrote packages and procedures to cleanse, tune, maintain integrity, and migrate all data throughout the conversion process while building a user interface in VB Net to maintain user tables, and query data.
Phase 2involved coordinating with Siemens corporate IT on project business case, requirements, coding, and gathering documentation needed to migrate POS data from the SQL Server to Siemens Oracle data warehouse.
Managed UAT testing and transitioned 65 distributors from emailing data submissions to FTP.
Trained report writers in Business Objects and reengineered the VB Net user interface to utilize ODBC connections to Siemens backend Oracle data warehouse.