Solution / BI Architect
CAA South Central Ontario
Designed and setup the solution infrastructure and application / Data architecture for several large to medium projects and created comprehensive documentation and presentation for the Enterprise Architecture. Initiated the Enterprise Architecture Repository for ERP project.
(Visio, Sparx EA, TOGAF, SOA, Design Patterns, CA ERwin)
Designed, Developed and implemented several Complex Data Warehouse projects in Finance, Insurance and Travel industries from Requirement gathering to conceptual design to logical design to physical design to ETL to Marts and Cubes to Complex MDX queries to Reports
(SSIS, SSAS, SSRS, MDX, SharePoint, VS 2005-2012, C#, Dimensional Modeling)
Led the technology research initiatives in adapting new design patterns and technologies to improve the architecture, reliability and speed of the existing and future systems
(SQL Server 2012, SSIS 2012, SSAS 2012, VS 2012, Window Azure, Sparx EA, Sharepoint 2013, Master Data Services)
Designed, developed, implemented and tested several parts of ESB web project utilizing latest technologies and architecture platforms and patterns
(WCF, Web Services, .NET 4.0, .NET 4.5, SOA, TOGAF)
Designed and implemented integration and migration solutions between systems. Created and setup SSIS projects, Windows Services, Application Plugins, Change Data Capture and scheduled SQL jobs
Worked in several SQL Server Infrastructure design and upgrade projects
(Infrastructure, Clustering, License Management, SAN, Server Hardware)
Led the expansion, optimization and trouble shooting of several ETL projects
Worked in several simultaneous initiatives and projects, multitasking in different teams and lines of business interacting with PMs, QAs, BAs, Developers and Business in all phases of SDLC.
Managed, Automated and Maintained Code utilizing TFS 2010, Cruise Control, Agile / Scrum / Kanban Tools