Printing tool Download PDF

Frank Goortani


Work experience

Oct 2014Present

Manager, BI Development

Jun 2014Present

College Instructor

George Brown College
Developed new comprehensive course outline and material for Business Intelligence using SQL Server 2012 Incorporated field experience and technical knowledge into learner-centered presentations emphasizing interactive, hands-on practice. Course offered : Business Intelligence COMP3065 at Casa Loma Campus
Jun 2014Present

Course Instructor

Learning Tree International
Provided online and in class courses in multiple Learning Tree Education Centers in North America including Washington, DC and Toronto, ON. Course offered : Designing an effective Data Warehouse SQL Server, Oracle
Nov 2013Oct 2014

Sr. Application Architect

Led multiple Integration and BI projects in Architecture and Development in Phone and Mobile channels (SQL Server, SSIS, SSAS, SSRS, MDX, .NET 4.5, VS 2013, ASP.NET MVC4, TIBCO, Momentum, Cognos) Led the troubleshooting of BI legacy systems, developed and implemented fixes and prepared risk assessment, maintenance plans and recommendations in upgrading systems Created and Managed the technical documentation of ongoing projects from ABP, Business Case, SRS, SDS, BRD, NFRW, Control Design, data mapping to Change Proposal and Project Detailed plan Contributed to the Phone Channels Group Strategy by applying the deep understanding of the enterprise architecture in TD organization through the ongoing projects. Held training sessions for Coop team members Acted as the interface between EIM and business applications (e.g. analytics, reporting, BI) Oversaw offshore project coordination, monitoring product development and quality and system integration. Assumed Project Management for mid-size integration and BI projects Led multiple project development using Code repository, Code Deployment and Service Desk tools such as JIRA, CA SDM, TFS, SourceTree and Stash
Apr 2012Nov 2013

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 (Windows Server 2008-2012, Active Directory, SQL Server 2008-2012, SSIS, C#, JavaScript, JQuery) 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
Jul 2011Mar 2012

Application & Database Developer (Asset & Investment management)

Felcom Data Services
Successfully designed, developed and implemented several new, existing and ongoing Web Project Components such as SLO Reporting system in IT Portal on time. (Visual Studio 2003 - 2010, SQL Server 2005 & 2008, C#, ASP.NET, Crystal Reports, ADO.NET, MS Project, Conceptual, Logical and Physical Data Modeling) Worked in a challenging fast paced in-production financial environment with several Servers, live websites and users across Canada and US. Developed and supported Applications, Databases and Websites used in Jovian Group of Companies, utilizing various thin clients, virtual platforms, cloud infrastructure and portfolio management enterprise solutions and technologies. Designed, Developed and implemented queries, stored procedures, SSIS packages and maintenance plans for deploying, integrating and maintaining databases. (SQL Server 2005 & 2008) Refactored & implemented OOP and Design Patterns on new and existing projects Developed and implemented unit tests and regression tests and debugged web applications in both Server-Side and Client-Side code. (NUnit, R#, MS Test, HTTP Watch, FireBug, Fiddler) Held Internal teaching sessions for new technologies and domain knowledge for new team members Created and utilized comprehensive architectural documents for existing and ongoing projects (Business Process Models and Use Case to Class and Data Models using Enterprise Architect, Visio, OODM, UML, IDEF1X) Completed comprehensive maintenance and training documentation on various Web Projects.



CSC Course

CSI Institute

Enterprise Architecture Using TOGAF 9.1 Level 1 & 2

Metaplexity Associates
This course was offered by Kirk Hansen from Metaplexity Associates

Agile Project Management Strategy and Analysis

Mind Leaders

Data Warehousing Management

Mind Leaders

Certified Business Analysis Professional Course

Mind Leaders

OWASP Course

Security Compass

PM Course

Ryerson University

MDSD Course

DPI Institute

MCSE course

Industrial Management Institute

MCSE Course

Industrial Management Institute


Amirkabir University of Technology - Tehran Polytechnic

High school Diploma

Allameh Helli High school


Business Intelligence
Data Science
SQL Azure
Windows Azure
Big Data
Project Management
Enterprise Architecture
Full Stack Development
Data Warehouse Architecture
Microsoft SQL Server
Agile Methodologies
Code Repositories
Web Apps and APIs
Business Analysis


MCTS .NET Framework 4, Service Communication Applications

MCTS .NET Framework 4, Data Access

MCTS SQL Server 2008, Database Development

MCTS .NET Framework 4, Web

MCITP - Database Developer 2008

MCPD - Web Application Development 2008

PMP Certified

TOGAF Certified