Frank Goortani

  • Toronto, Canada Area, CA ON

Work History

Work History
Oct 2014 - Present

Manager, BI Development

Jun 2014 - Present

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 2014 - Present

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 2013 - Oct 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 2012 - Nov 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 2011 - Mar 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.


2014 - 2014

CSC Course

CSI Institute
2013 - 2013

Enterprise Architecture Using TOGAF 9.1 Level 1 & 2

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

Agile Project Management Strategy and Analysis

Mind Leaders
2013 - 2013

Certified Business Analysis Professional Course

Mind Leaders
2013 - 2013

Data Warehousing Management

Mind Leaders
2012 - 2012

OWASP Course

Security Compass
2010 - 2010

PM Course

Ryerson University
2002 - 2002

MDSD Course

DPI Institute
2002 - 2002

MCSE course

Industrial Management Institute
2002 - 2002

MCSE Course

Industrial Management Institute
1997 - 2001


Amirkabir University of Technology - Tehran Polytechnic
1993 - 1997

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