My professional experiences below showcase my ability to bring ideas to life, whether it’s creating MVPs from scratch or launching brand-new projects within established companies. From initial concept to building and leading teams around these initiatives, I have consistently delivered results that drive impact. While these examples highlight my capabilities in professional settings, my personal projects offer an even deeper glimpse into my creativity and passions.
Brickfish • Senior Database Information Engineer & Analyst • 2008
Brickfish was a startup that provided social media marketing campaigns for high-profile clients such as Coach, Kodak, and Nike, primarily focusing on Facebook, but also including other social media platforms of the time. Integrating with Facebook in its early days presented significant challenges due to the evolving and immature APIs and tools. I was brought in to manage the substantial volume of data generated by these campaigns—so much data, in fact, that one of our SQL Server database tables contained over a million rows, making reporting very difficult. To address this, I implemented a hypercube using MS OLAP Server (Analysis Services), which greatly improved reporting performance. Though my time at the company was brief (six months) it had a lasting impact. Unfortunately, the company faced funding challenges, which ultimately led to my departure.
High-Performance Reporting: Built an OLAP data warehouse and business analytics dashboard to report key performance indicators. Enhanced the performance of key client reports, reducing processing time from 15 minutes to 20 seconds. Result: Enabled daily business intelligence, allowing for better decision-making and saving 6 hours per week of analyst time.
Business Intelligence: Designed and implemented reports for user acquisition, conversion, and retention. Analyzed the effectiveness of user acquisition channels, evaluated the impact of UI changes on conversion, and identified key user actions driving retention.
Digital Marketing: Led SEO efforts, including keyword identification, content adjustments, sitemap creation, and URL submissions. Result: Increased search engine ranking from #14 to #5 for a key target keyword.
Cost Reductions: Automated the migration of attachments from Quickbase to network drives. Saved $5,400 annually in storage costs.
Query Optimization: Optimized slow-performing stored procedures and SQL queries. Improved database server CPU efficiency by 24%.
Technologies: MSSQL, Analysis Services, OLAP, MDX, XML/A, IIS, ASP.NET, C#, JavaScript, Web Services.
