I am a data architect and consultant with over ten years of experience in data management, specifically focused on data architecture, ETL, data warehousing, and reporting. I am available for consulting engagements anywhere in the United States.
Among the consulting services I offer:
Data Warehouse Consulting
Building a single, centralized source of truth for business decision-making requires careful attention to all of the moving parts: creating the right data model, moving and transforming data, applying business rules, and information delivery. This exercise requires a blend of excellent technical skills, an analytical mindset, and risk awareness. As a consultant, I’ve helped scores of clients build out successful data warehouse infrastructures. I can provide architectural guidance, hands-on development, and/or advisory services to assist in your data warehouse project.
Moving data quickly, securely, and with a high degree of accuracy requires significant experience using enterprise ETL tools. I have worked in data management for over 10 years, with most of that spent as a business intelligence and SSIS consultant. I’ve worked with clients to create ETL processes from small to very large and simple to extraordinarily complex. For some clients that do not have the staff to build ETL processes, I offer end-to-end services, from inception to design and delivery. For others who need architectural guidance, I can serve as a trainer, mentor, and unbiased advisor during the ETL development process. In addition, I am highly skilled at automating the SSIS build process by using Biml, which can often shorten the SSIS development cycle by weeks or months.
Reporting and Analytics
ETL and data warehousing is typically the internal plumbing of an information solution, and reporting and analytics represent the “faucet” for getting data to the right people in the right format. To round out a proper data warehouse solution, I can provide guidance and/or hands-on development in the reporting and analytics space.
Why work with me?
There are a number of consultants working in this space, many of whom are available for much cheaper rates than I charge. So what sets me apart from other consultants? Three things: experience, initiative, and integrity.
I have been working in the IT industry since 2000, and have been building data solutions since 2003. I came up through the ranks in the IT industry, starting off as a humble systems technician. I worked hard to learn as much as I could during my early days, volunteering to take on new responsibilities to build skills in programming, systems administration, security, and data management. A few years into my IT career, I discovered that I had a passion and a talent for the data side of the house – database management, data modeling, reporting, and business intelligence (BI). As I grew my experience, I found that I particularly enjoyed solving BI problems, and it is in that area that I’ve been focused for the past decade.
In my time working in SQL Server business intelligence, I have deployed scores of successful BI solutions for employers and clients, ranging from small reporting projects to large, from-scratch data warehouse solutions. If you are looking for a business data problem solver, you’ll find few with more depth and breadth of experience than I have.
Simply put, I solve data problems. Although I have utilities and design patterns I use on many projects, every consulting engagement is customized for the client. You won’t get a generic “consultant in a box”. When we meet, I’ll ask a lot of questions, some of which might seem out of place for the topic at hand. I do this for a reason: I want to fully understand your pain points to see if I can help.
Experience and initiative are meaningless if you can’t trust the partner you hire to solve your business problems. Having a reputation as an honest businessman is even more important to me than being a recognized technical expert. To preserve that trust, I stand firmly on the following promises:
- I will only take on projects where I am sure I can deliver value
- I will be fair and transparent in my billing, only charging for time spent devoted to client business
- I will maintain a clear and consistent line of communication with clients during the project
If you have any questions about my consulting or training services, you can contact me here.