Joe J.

*Designed and built a replacement data warehouse following industry best practices. *Gathered detailed requirements from business users. *Implemented database that would facilitate a self-service BI portal and allow for longitudinal queries and reproduction of historical reports *Used SSIS to extract data and as orchestrator for Oracle PL/SQL procedures that handled more complex data processing. *Managed offshore team and worked hand in hand with BI Lead in determining technical needs. *Improved existing DW by removing redundant layers, promoting incremental loads and reducing the volume of tables. *Designed tying queries to ensure that source data aggregates matched the destination DW. *Guided Enterprise Architect and C-level executives on best practices and the fastest implementation path to production *Lead two massive data conversions *Ran team of 5 onshore developers with 22 offshore team members *Enhanced custom .NET application and downstream webservice integration with DuckCreek *Created SQL job which uses LogParser to import IIS Logs into a searchable DB table *Built MVC styled .NET web forms application following the traditional 3-tiered approach *Utilized AOP via PostSharp for logging, caching and a MiniProfiler implementation *Built multiple MySql DBs for the application and their supporting stored procedures, triggers, and views *Integrated with Paypal and Constant Contact