Enterprise Data Architect for Enterprise Data Warehouse.Technical LeadScrum MasterImplemented database and ETL standards and best practices

Lead Technical Architect for Enterprise Data Warehouse System.Team Lead/Scrum MasterLead implementation of Agile methodologyDevelop standards and best practices documents for SSIS and SSAS development.

Lead architect/developer on a new enterprise reporting system. Included staging environment, OLTP environment, ODS environment, and DW environmentCreated Analysis Services cube that contained multiple measure groups, 20+ dimensions, 100+ measures (including calculated measures), and 300 KPI’s that compared current value to prior period, Current MTD/QTD/YTD to prior MTD/QTD/YTD, current value to a user defined valueCreated SSIS packages/process’s to extract data from 1800 sharded databases and load to a central staging area. Extracted millions of rows per day

Designed and developed scalable reporting systems to enable users’ easier access to their data. Evaluated and made recommendations on new/replacement software and tools. Created specifications detailing file layouts for import and export of 3rd party data. Played key role in gathering and documenting requirements. Collaborated with users and analyzed legacy systems to identify automation opportunities. Designed and implemented new architecture for outward facing reporting system. Trained and mentored business user’s on new tools. Supported monthly data processing systems. Supported user requests for ad-hoc reports. Fulfilled enterprise administrative tasks. Established and documented standards and development practices.

Designed databases, and led database development teams in the creation of Data Warehousing systems and OLTP systems. Played a key role in the establishment of the development process utilized by the database development team. Was a member of the Enterprise Data Modeling Team and helped drive the creation and implementation of Database Modeling Standards and Guidelines. Performed data model and code reviews. Provided expertise and leadership in troubleshooting performance issues within legacy applications.