Badges

55 Points
8 Years

User Activity

Over 7 years ago
Great summary - knowing the built in SCD is notoriously slow, I've built a custom type 2 template within a data flow task that is fairly versatile. I am interested to see how other ETL "canned" SCD options compare.

Comments

Over 7 years ago
Data Integration

About me

I have over 6 years of experience working in the field of Business Intelligence and Data Warehousing. Currently at American International College, I am a Data Management Support Specialist and the IT Team Lead for the Jenzabar student information system conversion project. My role involves development with the MS BI stack along with applying principles of data management and governance to ensure data quality and improve institutional reporting capabilities.

Previously, I was a Business Intelligence Engineer at Financial Partners Inc, where I developed SQL code to enhance and maintain the enterprise data warehouse.

My core skill set includes but is not limited to SQL server development (2008-2014), SSIS (2008-2014), SSIS task development in C#, integrating software systems using SSIS, normalization (and denormalization) practices in regards to reporting requirements, Tableau dashboard development, Cognos report and framework development.

I am an end-to-end BI developer - I understand how to consume flat files, data feeds, and external data, store the data in a warehouse, and then develop the reporting layer based on reporting requirements. My current research interests include integrating Azure ML algorithms with the data warehouse, developing benchmarks using internal data and "big data", and general data visualization.