Shudong (Frank) Fan

***** ** ******** 514-***-****

Pierrefonds, Qubec H9K 0A2, Canada acuk01@r.postjobfree.com

SUMMARY 9 years experience on Team/Project management. 15 years experience on database

Systems development and administration (.Net; Ms. SQL server; DW/SSIS/SSRS). An

Active AGILE methodology practitioner on database systems development and

Management, being passionate and efficient on problems solving with proactive

Approaches.

TECHNICAL Database: SQL Server, Oracle, MySQL, NoSQL

SKILLS Language: T-SQL, PL/SQL, VB/VB.Net, C#, XML,

ASP/ASP.Net/MVC.net, DHTML.

Service & API: DTS, SSIS, SSRS, IIS, ADO/ADO.Net

Tool: Visio, OneNote, ER/Studio, Jira, Red Gate, TFS, Tableau, GIT.

Platform: Windows, Linux, Scrum

Certificate: Scrum master Certified

PROFESSIONAL Vigilant Global, Montreal, Canada 03/2007 Present

EXPERIENCE Sr. Database Architect/Administrator, Team Leader

Build a cooperative and productive encouraging team environments -

transparent; fairness; open-minded.

Apply agile methodologies effectively in project management and database system

development - adapting to changes under ambiguous environments to ensure

systems expanding easily with minimal efforts.

Collect requirements actively and accurately from stakeholders and translate to

Tech-requirements, providing conceptual and logical data architecture.

Coordinate projects among business stakeholders, tech teams to deliver on time.

Define and design data maintenance processes (flow) to improve data quality for

divisional data domains to improve operational efficiency and to mitigate risk.

Lead and manage central data management systems (MDM) design to ensure

data integrity and integration among different systems.

Ensure that database systems reflect leading industry practices.

Contribute to the development and execution of the core data strategy that enables

the most effective use of the data assets.

Manage multiple data/database projects in parallel, making full use of

limited resources efficiently and effectively.

Lead database projects (.Net; SQL Server) on system migrations (company

merging) and upgrading.

~~

Provide technical leadership and direction on enterprise data strategies building up

in full life cycle including business requirements collecting and analysis, data

architecture and data governance design (integrity; availability and security).

Experience on ER data modeling in logical and physical design.

Provide Data warehouse full life cycle design, including ETL and BI reporting.

Provide security design and administrate data/database security in production

operations.

Lead and build middleware framework architecture (MVC.Net; ASP.Net; SQL

Server) to ensure to follow best practices, writing core components (.Net).

Build data modeling standard and mentor teams/developers to apply cross-team.

Build data architecture and provide supports on data model applications (tiers; API

etc.) in BI systems development life cycle.

Provide data/database solution on production performance tuning, optimization

and troubleshooting.

Provide support on data solutions for developers, testers and end-users.

Administrate and manage both development and production database

environments, capacity and security design.

Administrate and build database systems with SQL Server 2005~2012 from

ground up crossing both OLTP and OLAP.

Excellent in TSQL programming in DB objects (SP; Function; Triggers etc.).

Assist with BI reports (SSIS/SSRS/Tableau) development and deployment.

Mentor and train junior and intermediate level SQL developers.

SQL Server infrastructure design in SQL Clustering environment.

PSL Group Consulting, Montreal, Canada 03/2006 03/2007

SQL Server DBA/Developer

Involved in projects development life cycle at fast-paced team working

environment, providing database support to programmers, PM and BA.

Admin SQL Server in both development and production environment (mainly with

development). Backup/Restore, Security, Replication, DTS.

Responsible for database projects development, from analysis, design to

implementation, dealing with large size database and tables manipulation,

preparing design documentation.

Autoland, Montreal, Canada 09/2002 05/2006

SQL Server Developer/DBA/Programmer

Installed SQL Sever 2000, Service Packages and Hot fixes under windows

2000/2003 environment.

SQL Server 2000 security design and admin at server and database levels.

Performance monitoring with Profiler, Performance and Query analyzer. Solving

performance bottlenecks in server and database level respectively. Optimization of

database structure with proper internal indexing, transactions and locks

maintenance.

Web sites and IIS administrating with six web sites based on ASP and two web

sites based on ASP.Net (C#, ADO.Net).

Data analysis and modeling under ambiguous business requirements. RDBMS ER

design with Visio 2003 and Erwin 4.0.

Wiremagic.com Corporation, Montreal, Canada 12/2000 08/2002

SQL Server Developer/Programmer

Installed and upgraded SQL Server 7.0 (to 2000); installed SP and hot fixes.

Administrated Ms. Access 2000 databases and sync data between Ms. Access and

SQL Server.

Administrated SQL Server 7.0 in replication, performance monitoring.

Migrated Ms. Access database to SQL Server 2000. Migrated Ms. Access based

application to SQL 2000 based web application.

Database Backup/Recovery plan design and administration.

Conducted data modeling and database design based on the requirement of

vehicle parts wholesale/retail business.

MEMBERWORKS, Montreal, Canada 05/2000 11/2000

SQL Server Developer

Conducted RDBMS database design with SQL Server 7.0 for call center internal

management process.

GUI designed and programmed with Ms. Access VBA. Created dynamic reports

with Ms. Access as front.

EDUCATION Business Analysis 2013

McGill University, Montreal

Project Management 2009

McGill University, Montreal

Graduate Diploma, Computer Science 2001-2004

Concordia University, Montreal

AEC, Computer Science 1999-2000

OSullivan College, Montreal

B.S, Hydro-electrical Engineering 1985-1989

Tianjin University, China

Contact this candidate