Business Intelligence Change Management

KAM CHAN

Vancouver, WA ad621b@r.postjobfree.com 503-***-****

ANALYTICAL ORGANIZED DETAIL-ORIENTED

PROFESSIONAL SUMMARY

Experienced database administrator manager with a strong background in team leadership, strategic vendor partnerships, and data migration. Skilled in database administration, data analysis, and visualization, with expertise in business intelligence reporting and change management. Proven ability to oversee complex migration projects, optimize operations, and drive high availability solutions while ensuring seamless performance and platform resilience.

AREAS OF EXPERTISE

Team Leadership Strategic Vendor Partnerships Data Migration & Integration Database Administration

Data Analysis & Visualization Business Intelligence Reporting Change Management Project Management

WORK EXPERIENCE

DBA MANAGER 2018 - 2024

OnPoint Community Credit Union

Spearheaded and managed a multidisciplinary team comprising skilled professionals such as database administrators, data engineers, and business intelligence report writers, fostering a collaborative environment focused on achieving strategic data management goals.

Established and nurtured strategic partnerships with third-party vendors, leveraging their expertise to optimize data management processes and enhance operational efficiency.

Demonstrated exceptional leadership in maintaining a remarkable 99.5% uptime by implementing and effectively utilizing SQL Server availability groups, ensuring continuous data availability and system reliability.

Orchestrated the operations for Oracle RAC support, overseeing seamless performance and high availability of critical databases to meet business requirements and operational demands.

Successfully managed and executed various migration projects, including the transition of the On-Premises SQL Server Data Warehouse to Microsoft Synapse, migration of the Credit Union Core from XP2 to DNA, and the migration of Crystal Reports to SSRS, ensuring smooth and efficient transitions with minimal disruption to operations.

Played a pivotal role in the design and implementation of over 300 custom PowerBI reports, providing valuable insights and analytics to stakeholders. Additionally, developed more than 200 data pipelines to streamline data processing and enhance decision-making capabilities within the organization.

DBA ORACLE/SQL 2012 - 2018

Kimpton Hotel and Restaurant Group, Inc.

Developed an automated ETL process using SSIS to extract data from diverse database servers, encrypting, compressing, and uploading data to a secure FTP site.

Managed Oracle, SQL Servers, and MySQL database servers, ensuring their smooth operation and performance.

Implemented VEEAM backup, restore, and replication to DR site, resolving production issues, optimizing performance, and ensuring data recovery.

Provided database support for various applications including Opera, Delphi, JDE, BPC, Salesforce, and Epitome.

Conducted installations, upgrades, capacity planning, and migrations across multiple data centers and servers.

Orchestrated High Availability and Disaster Recovery solutions to enhance platform resilience during outages.

Led technical projects adhering to change management and project guidelines.

Demonstrated expertise in DB Tools/Utilities such as Enterprise Manager, RMAN, VEEAM, SSIS, and SSRS.

Collaborated within the Enterprise System Team, delivering 24x7 support to Kimpton IT.

WORK EXPERIENCE (CONT’D)

DBA/SOFTWARE ENGINEER 2005 - 2012

Renaissance Learning, Inc.

Managed SQL Server Databases across three locations, overseeing maintenance tasks such as index tuning, DTS Package management, security enhancements, and SQL Server Reporting Services utilization. Proficient in T-SQL, triggers, data analysis, data warehousing, and relational database creation.

Automated ETL processes, implemented version control, managed builds, and facilitated continuous integration and deployment.

Executed installations, upgrades, capacity planning, and migrations across various data centers and database server architectures to ensure optimal performance and scalability.

EDUCATION

Bachelor of Science: Computer Science Portland State University – Portland, Oregon

COMPUTER LANGUAGES

Database Languages (SQL, Transact-SQL) Data Integration and Processing (SSIS, Synapse Pipeline)

Programming Languages (C#, C, C++, Perl, CGI, JavaScript, Assembly, Prolog, Small Talk)

Web Development Languages (HTML) Automation and Scripting (VBA, VB.Net, Shell Scripting)

Contact this candidate