Stephen Tsoi

Etl Consultant @RBC

Toronto, ON, CA
MOBILE NUMBERS
+91 *********19

Signup · Get unlimited contacts

WORK HISTORY

Jan 2016 — Present

Etl Consultant @RBC

View department →

Data Migration Project• Migration the existing system from DOS platform to Linux platform with compatible of the software upgrade in a super tight timelines.• Moving more than 4 thousands jobs within 6 months.• Work closely with both business and technical team of both internal and external parties from senior management to technical people.• Achieve multi-tasks covering from project coordination, planning and coding.• Monitor, support and fire-fighting for production issues.Tools and environment: DataStage, Teradata, IBM OnDemand, IBM Personal Communication, Unix and all related tools.

EDUCATION

1991 — 1995

Ryerson University

Bachelor, Bachelor of Electrical and Computer Engineering

1981 — 1985

The National Taiwan Normal Univeristy

Bachelor of Science, Physics

SKILLS

Agile MethodologiesCognosMicrosoft Sql ServerData AnalysisErwinSdlcDataSoftware DevelopmentOracleBusiness IntelligenceData Warehouse ArchitectureDb2Project ManagmentPl/SqlSqlBusiness ProcessData WarehousingProject ManagementData ModelingEtlEnterprise ArchitectureInformaticaSsrs

ABOUT STEPHEN TSOI

Over 18 years in IT and 16 years focusing in data warehouse projects, experience covering from project management, architecting, analysis, design, development, testing, and implementation on multiple platforms, enterprise projects.• 7+ years experience in enterprise architecture(EA) development in application and technology domains• Acting as project manager, demonstrated strong leadership and project management skills in leading a team of both full-time and contractors successfully deliver the solutions to clients for critical projects in extremely tight time line. Strong leadership, negotiating, consensus building, and decision-making skills. • Define, design and develop the application architecture of an enterprise scope projects. Experience in information and application architecture and design (UML, multi-tier architecture, Zachman Framework etc).• Demonstrated working experience in enterprise-wide and complex IT projects like high profile projects in OPS, financial projects for the bank of China, etc.• Comprehensive understanding of the user requirements for different projects. Acted as Single Point of Contact between Clients, Business partners, Upper management and Team members.• Experienced all phases of architecture development life cycle as integrated in software development life cycle (SDLC).• Excellent communication and presentation skills with proficient relationship management, vendor negotiation skills.• Extremely strong analytical, problem-solving and decision-making skills.• Provide expertise recommendation in leading edge technologies, like Architecture solutions, Meta data management tool, BI/Data Warehouse/ETL, SOA (Cognos, Informatica, DataStage, and Hyperion) and open source, etc.• Technical documentation including BRD, specification, project plans, RFP and Proposal activity and status reports for clients, senior managements and team members to ensure the project efficiency and effectiveness.Specialties: Business Intelligence - Cognos, Brio BI suite, Hyperion Essbase, Hyperion Analyzer, MS OLAP Server, Reporting Services, ETL - Data Stage, Informatica, SyncSort, DTSDatabase - Oracle, MSSQL Server, DB2Programming Languages - VB, VBS and ADO, ASP, HTML, JavaScript, SQLOS - Windows & NT 4.0, UNIX, ftp, Telnet, VPNSoftware/Application Packages Erwin, PowerDesigner 7.5, Crystal Report, Lotus 123, MS Project, MS Powerpoint, Excel, Rational ClearCase, Test Director

This profile is compiled from publicly available professional sources. Unifers is not affiliated with or endorsed by LinkedIn. Request removal of this profile.

Stephen Tsoi — Etl Consultant at RBC in Toronto, ON, CA | Unifers