Author Image

Hi, I'm Dan

Dan Rowe

Automation Solution Architect at OmnicomMediaGroup

As an Automation Solutions Architect at OmnicomMediaGroup, I have designed and implemented several successful automation projects that have improved efficiency, productivity, and cost-effectiveness for clients. I have developed Robotic Process Automation (RPA) solutions that automate manual processes, integrated data sources to streamline data collection, and implemented cloud flows to manage remittance notifications. Additionally, I have designed and implemented features for previously built in-house applications. I bring to the table extensive experience in RPA, cloud computing, and agile methodology.

Collaboration
Project Management
Self Directed

Skills

Experiences

1
Automation Solution Architect
OmnicomMediaGroup.com

April 2022 - Present, San Francisco

Marketing and Advertising

Responsibilities:
  • Designed and implemented successful automation projects that improved efficiency, productivity, and cost-effectiveness through collaboration with internal stakeholders.
  • Developed Robotic Process Automation (RPA) and Power Automate cloud flows to automate manual processes, integrate data sources, and streamline data collection.
  • Designed and built a proof of concept RPA that inputs data into a legacy platform, which was used as a basis for an enterprise-wide automation solution.
  • Designed, developed, and implemented automation to streamline data collection for company-wide reporting and manage remittance notifications through RPA and Power Automate Cloud Flows.
  • Built new PowerApps and maintained/enhanced existing ones to develop and deploy custom business applications that streamline processes and improve overall efficiency.
Senior Systems Engineer
Obayashi North America

October 2020 - April 2022, North America

Civil Engineering and Construction

Responsibilities:
  • Evaluate and implement new technologies and platforms.
  • Collaborate across departments to deliver technology solutions.
  • Gather requirements, design, build, and deliver automations using PowerShell, Power Platform, or other technologies.
  • Worked with Payroll Department to automate a manual file process. Reduced work effort by 60 hours annually.
  • Developed a SMS notification platform with PowerApps. Reduced spend on a SMS notification platform by $5000 annually.
  • Developed a PowerApp Travel Request app.
  • Manage O365/Azure/Okta/Mimecast/Valimail environments.
2
3
Systems Administrator
OmnicomMediaGroup

January 2019 - October 2020, San Francisco

Marketing and Advertising

Responsibilities:
  • Automate IT Processes using PowerShell.
  • Project Lead for OMG’s ProofPoint migration.
  • Technical Team member for OMG’s O365 tenant consolidation project.
Support Specialist
OmnicomMediaGroup

Feburary 2015 - December 2018, San Francisco

Marketing and Advertising

Responsibilities:
  • O365 Exchange Administrator
  • ProofPoint Email Protection Product Manager
  • Managed File Transfer (MFT) Product Manager
  • C-Level Execetive Support
4

Accomplishments

Microsoft Certified: Power Platform Fundamentals
Microsoft November 2021

Earners of the Power Platform Fundamentals certification are users who aspire to improve productivity by automating business processes, analyzing data to produce business insights, and acting more effectively by creating simple app experiences.

View Certificate
Microsoft Certified: Azure Fundamentals
Microsoft April 2021

Foundational knowledge of cloud concepts, Azure Services, Azure workloads, security, privacy, pricing, and support.

View Certificate
AWS Certified Cloud Practitioner
AWS June 2019

Earners of this certification have a fundamental understanding of IT services and their uses in the AWS Cloud. They demonstrated cloud fluency and foundational AWS knowledge. Badge owners are able to identify essential AWS services necessary to set up AWS-focused projects.

View Certificate

Education
Concord University
1993-1997
Bachelor of Arts (BA), Psychology
City College of San Francisco
2017-2018
Computer Science
Taken Courses
  • Data Structures and Algorithms
  • Java Programming Fundamentals

Recent Posts

Card image cap
NewTime-Span

I was investigating an issue with our identity provider and out of date passwords the other day. I needed to do a date comparison to find accounts with expired passwords. In the past I’d used (Get-Date).AddDays() and done an evaluation. It works, but to me the code is hard to read. I stumbled on the New-Timespan cmdlet which creates a timespan object. Creating a timespan object and referencing the days property is so much easier to read when you look at the code.

March 24, 2022 Read
Card image cap
Delegation

I’ve been working on a canvas app to track and manage major IT projects. The app uses a SharePoint list as a datasource. Our executives also use the app and the PowerBI dashboard to review projects that require executive approval in the form of what we call our Change Advisory Board (CAB). I recieved feedback from a member of our CAB. “It would be nice to separate out the completed projects from all the other projects.

March 13, 2022 Read
Card image cap
Hiding a Button

Problem You only want certain people to use a button on an app. The button can be for navigation, or an action. It doesn’t matter. Solution Use an Azure Active Directory group to control who can use see the button. This makes managing permissions for the button very easy. You don’t need to change the app, change the group membership. Components Azure AD Group with members Azure AD Group Object ID Some onStart code A button you only want certain people to see Office 365 Groups Connector Office 365 Users Connector Azure AD Create an Azure AD Group Add members Make a note of the ObjectID Sample Group

February 1, 2022 Read