[var] => cut_url
<pre>Array ( [var] => cut_url ) </pre> Resume for Frank W. for Consultant / Computer & IT Services in Montreal, Canada. Search More Resumes for Consultant on #HUQGUL29S

Search Resumes

Post Jobs

Job Seekers:
Post Your Resume


Resume for Frank W. for Consultant / Computer & IT Services in Montreal, Canada

Occupation: Consultant Industry: Computer & IT Services
Country: Canada City: Montreal
State: Quebec ZIP: H3A 3T2

View Complete Resume   Download Resume [
    [name] => cut_url
Share Share

< Back to search results Preview: For the complete resume and contact info please download it.

    [var] => content
    [type] => preview
    [var] => cut_url

Frank W.    


Telephone:      Email:  


To seeking a challenging position as an ETL developer/data warehouse/BI specialist. 

Personal Strengths:

  • Developed strong Database analysis, Data warehouse/mart architecture, ETL developing, report creation skills through years of work experiences in the telecommunication, information technology, insurance, retail, medical industries.
  • Extensive experience in database analysis: years of data warehouse/mart/DB analysis, years of ETL including years of Informatica Powercenter ../././., . year of SSIS, . year of Datastage. and year of report creation with BO, Microstrategy and Cognos. 
  • Rich experience in the whole lifecycle development of data warehouse/Mart including data warehouse/mart starschema designing, Data profiling, data cleansing, data modelling, ETL mapping specification, coding, data flow, error handling, recovery and performance tuning.
  • Implemented Conceptual/Logical and Physical Data Modeling of RDBMS, Data Warehouses and Data Marts using Erwin, Visio and MicroStrategy.
  • Solid experience in PL/SQL, TSQL, Teradata SQL programming and + years experience in various enterprise application systems development lifecycle.
  • Rich experience and solid knowledge of DML, DDL, SQL, Java, Unix Shell Script, etc.
  • Good team player and selfmotivated worker, quick learning and hard working.
    Development Tools : ETL: Informatica Powercenter ./././.., DataStage, Datastage PX, SSIS, OWB;

    Report: Business Objects, Microstategy, Cognos, SSRS, SSAS;

    DB architecture: PowerDesigner, ER/WIN, Visio;

    DB clients: Toad, SQL Detective, Teradata SQL Assistant, SQL developer

    UNIX Shell Scripting, Oracle Forms i/i, Oracle Reports i, PL/SQL, TSQL

    Operating Systems : UNIX, Windows NT///, Linux
    Databases : Oracle i/i/g/G, SQL Server ///, TeraData
    Methodologies: Waterfall and agile. 
    . Specialized Master in Computer Science University of Montreal Ecole Polytechnique, Montreal, Quebec, Canada
    Bachelor’s degree in Engineering Beijing University of Aeronautics and Astronautics, Beijing, China
    English, Mandarin and French.
  • Informatica Certified Developer .x
  • Informatica Certified Administrator .x
  • MCITP for SQL server Business Intelligent
  • MCITP for SQL server Database Developer
  • Pass Oracle OCP i exams
  • MCSE for windows NT/


         TEKsystems Jan. – to Present

    Yale University DWH Support and Enhansement  
    Title: ETL developer
    Montreal, CA 
    Jun.. present

    Project Highlights:  Provided support and enhancement to the DWH of Yale University.

    Accomplishments:  Quickly master knowledge of complex DWH and transfer to India.

    Environment:  Windows , Informatica .., AIX ., Linux, Oracle G, Autosys

    Responsibilities and Duties:

  • Master knowledge of ETL process of DWH, including hundreds of Oracle PL/SQL packages, tens of Informatica workflows, hundreds of Autosys jobs, and transfer them to India support team;
  • Follow the current standards to create new or enhance existing PL/SQL packages and Informatica mappings, workflows for the new issues found.
  • Oncall support for the process of ETL during night.
  • Rewriting System Design Documentation for current ETL process;
  • Fully documented every PL/SQL package, mapping and workflow process following the standards of Yale University.
    AFC Data Warehouse – Adesa 
    Title: ETL developer
    Montreal, CA 
    Nov. Jun. months

    Project Highlights:  Provided an improved solution for AFC data warehouse for Adesa.

    Accomplishments:  The client was very satisfied with the performance and robustness of the enhanced ETL processes.

    Environment:  Windows , Informatica .., Oracle G

    Responsibilities and Duties:

  • Improved current mapping by adding PCM Process Control Manage with a concurrent implementation of CDC Change Data Capture logic to enhance performance.
  • Separated extremely large FACT load mappings to facilitate developing, testing & debugging.
  • Improved existing workflows by integrating auditing, notification and reconciliation logic.
  • Fully documented mappings and workflows.
    Content Builder & Loader – McKesson 
    Title: ETL architect/lead and DBA
    Montreal, CA 
    Jun. Dec. months

    Project Highlights:  Provided an improved ETL solution to replace current ETL process for McKesson.

    Accomplishments:  The client was satisfied with a dramatic % performance improvement of the critical ETL load, which saw overall execution time drop from hours down to ;

    Environment:  Windows , Oracle G.

    Responsibilities and Duties:

  • Redesigned the ETL architecture to improve the current ETL process.
  • Made name convention, store procedure template for other ETL developers.
  • Configured and created Development, QA and production environment databases.
  • Created Oracle PL/SQL stored procedures and packages to extract, transform and load data;
  • Performed performance tuning on SQL scripts, configured database and hardware platform;
  • Revised team ETL developer’s PL/SQL scripts to ensure compliance to corporate standards and to improve performance;
    Pay Stub Portal – First Data Corp. FDC 
    Title: Database developer and DBA
    Montreal, CA 
    Mar. Dec. months

    Project Highlights:  Created a new Pay Stub Portal for First Data Corporation.

    Accomplishments:  Client was very satisfied and extended the project several times to add new functionality.

    Environment:  Windows , Oracle G, Eclipse.

    Responsibilities and Duties:

  • Created Logical Data Model;
  • Implemented the Physical Data Model;
  • Created Stored Procedures, PL/SQL procedures/packages for JAVA developers;
  • Assisted JAVA developers in solving Oracle database problems they were encountering.  
  • MAS  for University of Rochester 
    Title: ETL Architect/developer
    Montreal, CA 
    Mar. Dec. months

    Project Highlights:  Developed ETL processes for Medical Advance System for University of Rochester.

    Accomplishments:  The client was very satisfied with the cleansed, normalized and consolidated data.

    Environment: Solaris , Oracle G.

    Responsibilities and Duties:

  • Designed handcoded complex ETL process flows with full features of ETL auditing, checkpoint, recovery, data validation, error logging, error handling.
  • Created consolidation workflow to merge data amongst patient and guarantor.
  • Developed UNIX Ksh scripts to feed flat files into, and extract from, third party server,
  • Developed Oracle packages, stored procedures, sequences and functions to audit ETL process,
  • Cleansed, transformed and consolidated data from flat files into staging area tables that were subsequently loaded into target tables.
  • Deployed code from DEV to QA and provided completely documented the ETL process. 

         CGI Nov. – Dec.

    PSPDataMart  Bell Canada 
    Title: DataMart architect, ETL and report developer
    Montreal, CA 
    May. Dec. – months

    Accomplishments:  Functionally designed Datamart architecture, developed ETL code and created Datamart reports.

    Environment:  Informatica Powercenter ., Oracle G, Teradata, Sybase PowerDesigner , MicroStrategy .., SQL Detective

    Responsibilities and Duties:

  • Adhering to business requirements, designed a starschema DataMart for Bell’s Voice Degradation system that included dimension tables & fact tables PowerDesigner.
  • Worked through whole ETL development lifecycle in Informatica Powercenter mapping environment: extracting source to staging area, transforming integration layer data to datamart, error handling etc.
  • Authored ETL mapping specifications from source to staging area database, DataMart, and aggregation tables.
  • Created SQL queries to profile the data in from different of sources and created several stored procedures to cleanse data and to populate the date dimension tables.
  • Developed ETL code with a Changed Data Capture CDC process, that performed both an initial load and incremental load with Powercenter . for dimension tables, fact tables.
  • Created temporary report with SQL query from the DataMart for the purpose of validation.
  • Created schema objects of attributes, facts, metrics, and hierarchies with MicroStrategy.  Subsequently MicroStrategy reports were created to meet the customer’s requirements.
  • Involved in performance tuning and error handling processing for Powercenter and Oracle database. 

  • Cancel
    Not Enough Credits
    Sorry, but you don't have enough credits to download this resume.

    Purchase more credits
    Not Available
    Sorry but this resume is not available for download. Please choose another!

    Confirm Download

    Would you like to download  for 1 credit?

    You have  credits left.

    Yes No 

    Don't ask me again
    Confirm View Complete Resume

    Would you like to view  for 1 credit?

    You have  credits left.

    Yes No 

    Don't ask me again