Bi&data Warehouse Resume
Indianapolis, IN
Accomplished BI Data Architect and Certified Microsoft Database Developer, with extensive experience developing Data Warehouse and Business Intelligence solutions. Master developer in Microsoft BI tools (SSIS, SSAS, SQL Server), Oracle PL/SQL, Cognos, Business Objects, and Pentaho BI. Serving as Team Lead – providing leadership through the entire design& developmentprocess. Currently residing in Indianapolis; will be married in July to a Boston native, and relocating to the East Coast to start a family.
Professional Experience
Confidential– Indianapolis, IN BI&Data Warehouse Architect October 2009 – Present Currently residing as the BI Data Architect at Daniels Associates, where I am the Team Lead for all Data Warehouse and Business Intelligence development for clients in Indianapolis. I work with clients to define specs for new solutions, and lead teammates through the design, development, implementation, and end-user training.
- Provides guidance on how clients can successfully incorporate BI into their corporate culture
- Designed & Developed multiple large DW & BI solution using Microsoft BI (SSAS, SSIS, SharePoint, Excel Services):
- Led the design, development and implementation of each solution
- Developed using an AGILE approach – iterative deployment with users involved through the entire SDLC
- Provided end-user training, and continue to provide tips & tricks to users
- Currently leading a team of six through the data conversion initiatives of a PeopleSoft ERP implementation
Confidential– West Lafayette, IN Data Architect & Database Developer Dec 2004 – October 2009 Previously served as Data Architect & Developer at PEFCU. Designed and developed BI/DW solutions to measure corporate goals, and worked closely with end-users to integrate BI into day-to-day routines. Winner of the 2008 Best Practice award for the “Sales and Goals” BI/DW design and implementation (from CUNA Technology Council).
- Designed & Developed a plethora of Data Warehousing solutions from the ground-up:
- All solutions were developed via SSIS, PL/SQL, T-SQL, and Pentaho KETTLE
- Worked closely with Management Team to define all solutions in vast detail
- Examples include “Sales and Goals”, “Membership Segmentation”, “Credit Card Transactional Portfolio”, “ATM Profitability”, “Marketing Tracking”, “VISA Fraud Detection”
- Led the Business Intelligence initiative
- Served as the primary designer & developer of BI solutions across the organization
- Developed solutions in Microsoft SSAS, SSIS, Cognos, and Pentaho
- Integrated information from an array of MSSQL and Oracle data sources (including aforementioned data warehouses)
- Provided end-user training to integrate BI into the day-to-day lifestyle of the organization
Education& Certifications
B.S. in Industrial Management
Minor in Management Information Systems (MIS)
Certified “MCDBA – Database Developer”