What Kinds of Work Have I Done
In a professional setting I have held roles in both the Business and IT domains. In addition to this, I have spent a great deal of my own personal time honing skills outside of my day-to-day responsibilities. This all encompassing approach to my work has made me well rounded, but my typical involvements include:
- 9 years designing custom business solutions
- 7 years analyzing and improving enterprise operations
- 4 years architecting information platforms, data warehouses, and data management solutions
- 3 years running projects and programs
What Does my Day Look Like
Currently I serve as the Data Architect for an Education company. In this role I own all strategy pertaining to Data Management and work with our Data Engineers, BI Team, Development Teams, and our Business Leaders to identify the needs of the company from a Data perspective. Since May 2018 we have been implementing a Data Vault 2.0 Warehouse and have successfully loaded 5 sources as of September 2019.
Working hands on with the program we have defined our own version of the Data Vault 2.0 reference architecture, implemented an automated solution utilizing metadata from our data models to generate the warehouse DDL, and also created a in house application to manage our warehouse and deploy across environments.
I am well versed in working with cloud hosted solutions, working with As A Service offerings such as AWS RDS, and implementing custom installs of databases on AWS EC2 instances.
In addition to the work and skills mentioned above here is a sampling of key skills/tools and years of experience with them:
- Data
- Databases
- MongoDB – 2 years
- MS SQL Server – 4 years
- PostgreSQL – 2 years
- Teradata – 3 years
- RedShift – 1 year
- Snowflake – 1 year
- Oracle – 5 years
- Hadoop/Hive External – 1 year
- Data Modeling
- Erwin Data Modeler – 4 years
- Idea Data Architect – 1 year
- Lucidcharts – 2 years
- Data Quality
- Talend Open Studio for Data Quality – 2 years
- Data Integration
- Talend Open Studio – 2 years
- Talend Open Studio Big Data Edition – 2 years
- SSIS – 3 years
- Custom – 3 years
- Master Data Management
- SAP Vendor Managed Offering – 3 years
- Geocoding
- Householding
- Cleanse, Match, and Merge Tasks
- SAP Vendor Managed Offering – 3 years
- BI Tools
- Tableau – 1 year
- Power BI – 1 year
- Looker – 1 year
- Sisense – 1 year
- SSRS – 1 year
- Databases
- Programing Languages
- VBA – 9 years
- SQL Various Tools – 9 years
- Java – 2 years
- Python – 4 years
- Command Line/Bash/Zsh – 6 years
- Skills
- Data Warehousing – 5 years
- Data Modeling – 4 years
- Data Engineering – 6 years
- SDLC – 2 years
- CICD Workflows – 3 years
- Architecture
- Investigative Architecture – 3 Years
- Zachman Framework – 1 Year
- Project Management/Workflow
- Agile Development – 5 Years
- Scrum Master – 4 Years
- Product Owner – 3 years