Data Warehouse Management

HENRY QIAN

Mississauga, ON

Tel./Fax: 289-***-****; abqbc0@r.postjobfree.com

Dec.20, 2012

Head of Human Resources Services Section

Re: The position Systems Testing QA Specialist

Thank you in advance for reviewing the enclosed resume for the position Systems Testing QA Specialist . I am qualified as an Engineer and/or Analyst in the area of the Software Engineering, Asset Management System, Database and Data Warehouse Application Systems, Wireless Internet Application System, 3rd party co-operations and solutions, Embedded real-time software, and User Interface etc. I am confident that I can make a good contribution with QA test service and automatic test solution to your company and your business.

Highlights of my qualifications include:

3 years QTP GUI automation test and both system manual and automatic test, and used QC for test case management for an Asset Management System deployed with Public-key cryptography in RIM.

Successfully worked on and implemented four data warehouse (DW) projects (DW analysis, designing, ETL processing), four NMS (Network Management System) projects.

Two and half years working experience in Financial industry for Morgan Stanley in Trading Application Integration with FIX (Financial Information Exchange protocol), and UAT and QA test in FIX and Security Lending applications.

Over eight years experience in the area Application Development and testing in a Unix and Windows environment utilizing Postgresql, Virtual Machine, Informatica, C/C++, Java, SQL, Unix Shell Scripting, Perl, awk, sed vi, and emacs. CORBA and Oracle PL/SQL), Unix/Linux and Windows and etc.

Extensive working experience in Application Integration and QA testing with various test approaches in unit, integration, V&V, stress and performance, system and regression, End-to-End certification and UAT. Trained with software QA, FTR (Formal Technical Reviews), test principle, methods and so on in professional test courses Test World, and QA etc.

Enhanced and extremely strong technical analytical and logical skills in system test analysis, design, and modelling, Research, Design and Development of Data Warehouse/Data Mart, OMC (Operational Maintenance Center) and NMS (Network Management System) Development,.

Have been trained the QTP, Project Management Professional (PMP), scrum project Process Management, and The Common Development Process for Software Engineer and V Model ; familiar with the software development life cycle utilised during several large-scale projects (more than 60 – 200 people involved to work on), Informatica Velocity methodology for DW projects, and (Rational Unified Process) RUP.

Completion of M.Sc, Computer Science and B. Eng, Electronic Engineering.

Thank you in advance for considering my application for the position. Please feel free to contact me at the phone number or email address above. Similarly, I will be following up with you in the near future to discuss the possibility of an interview.

Yours very truly

HENRY Qian

HENRY QIAN

(Canadian Citizen) Tel. /Fax: 289-***-****

Mississauga, ON abqbc0@r.postjobfree.com

M.Sc., Computer Science SW QA Test Specialist

B.Eng., Electronic Engineering Sr. SW Engineer & Consultant

SUMMARY

Meticulous, mission-driven, and proactive Systems Testing QA Specialist with a broad spectrum of work experience with prominent corporations (RIM, Motorola, Tata Consultancy Services, and Morgan Stanley etc) in diverse industries (Telecom, Retail and Financial). Adept in software engineering, development and deployment of the following:

Asset Management Systems with public-key cryptography technology Trading system integration using FIX protocol

Data Warehouse and Database application

Experience in Software Quality Assurance: 6 years in the testing areas of Functional, Regression, Integration, System, GUI, Backend, Performance, Load and UAT.Test Documentation: Test Plan, Test Strategy, Test Cases, Requirements Traceability Matrix.Kinds of Applications: Web based, Desktop applications, and Multi Tier, and infrastructure Kinds of Projects: Application Development, Application re-engineering, Legacy Migration and Data warehousing projects, Application Integration.Soft Skills: Communication skills, Time management skills, Team spirit, quick leaner and Flexibility

TECHNICAL SKILLS

Platforms:

UNIX Solaris 10, 9, 8; Linux Red Hat; Microsoft Windows 95/98/NT/2000/XP/Vista, HP / UX, VMware, Virtual Box etc.

Languages:

C, C++, Perl, Java, SQL, Shell Scripting (bash / Bourne, tcsh / csh, awk / sed), XML,html, Pro*C, Oracle PL/SQL, CGI etc.

Applications

Web service, Asset Management System deployed with Public-key cryptography technology; Trading system integration using FIX protocol, Data Warehouse and Database application, Network management system, FIX engine, various trading applications and related simulators etc.

Tools

QTP, QC, DistTest auto software testing environment, Autosys, Salesforce Eclipse, TIBCO, Informatica ETL (PowerCenter) tool, Ab Initio, Business Object Data Services (BODS), Cognos, TIBCO, SNMP, Autosys, MQ, Clearcase, Jira, Rational ClearCase and DDTS, CVS, svn, TOAD, MS Project and MS Office etc.

Database

DB2, SQL Server, Postgresql, MySQL, Netezza, Oracle, Sybase, Teradata, Informatix

others

OOD (UML) Modeling, Rational Rose and Erwin database schema and DW Dimensional modeling, Database Modeling, Framework of Project (PMBOK) and Process Management, Software Engineering and system specification, FIX (Financial Information Exchange protocol) Integration. Quality Standards: ISO 9000, CMM, ITIL

PROFESSIONAL EXPERIENCE

Data warehouse Consultant, Adastra corp Oct. 2011 - current

Adastra project for BMO Limited, CIDS (Customer Insights & Decision Support) department, DWM (Data Warehouse Management,), Toronto Ontario

The mission of the Customer Insights and Decision Support Services (CIDS) department within BMO is to provide the integration of knowledge management into Personal and Commercial Banking (P&C), e.g., Credit Card (CC) and Every Day Banking (EDB) business, by leveraging the use of advanced analytical techniques and tools for the purposes of maximizing shareholder value.

Environment:

Unix/Linux, Ab Initio 3.0.3, AB Initio EME (Enterprise Meta Environment), Sybase IQ/15.2.0.5615, DbVisualizer Personal 8.0.2, ODBC Data Source Administrator, Tectia –SSH terminal, VBA, UltraEdit professional Text/Hex Editor, Share point, VSTS Bug Tracking System, Window XP, WinScp, etc.

Responsibilities:Set up and integrated test environment for testing ETL processes and DW applications for credit cards applicationReviewed Business requirement and developer’s technical documents to prepare and implement correspondent test cases, test data, test plan, test scripts and execute tests Reported and maintained defects and conducted correspondent sanity tests and verification/validation for correspondent defect fixes Communicated with business analysts, database administrators, developers, system administrators, and management team for work progress, questions, quality issues and suggestions. Signoff release to meet schedule for deliverables

Adastra project for Shoppers Drug Mart, Front Shop Sales – Store Inventory Analytics project

Environment:

DB2 8.2, Oracle 11g, Informatica 9.1, IBM Data Studio 3.1, Unix, toad, share point, QTP 10.0 and QC 10.0, Netezza, Micrstrategy, ERWin Data Modeller r7, etc.

Responsibilities:

Implemented SQL script to load source data into data warehouse based on Source Target Mapping requirement and run QTP/test script to test the data loaded with Informatica

Set up QA test environment, test data and database tables

Analyzed work scope, issue and test strategy and estimated correspondent schedule to report to management team.

Adastra project for Loblaw Limited, Enterprise Data Warehousing ETL, Brampton, Ontario

Environment:

The largest SAP (System Application Program) data warehouse in retail industry in the world with 75 TB historical data. Working environment: AIX/Unix/Linux, Teradata SQL Assistant 12.0 for DW and Oracle for Business Object Data Services (BODS) local depository, Business Object XI 3.1, IBM Rational Team Concert (RTC) 2.0.0.2 for version control, SAP, Share point, Window XP, WinScp, putty etc.

Responsibilities:Set up test environment for testing ETL processes; Prepared and executed test cases and test plan. Integrated ETL interfaces into system test environment.Reviewed ETL process program codes.Reported and maintained defects and conducted correspondent sanity tests and verification/validation for correspondent defect fixes Updated and reported to project management team with work progress, quality issues and suggestions for improvement; Meet schedule for deliverables

CERTICOM, a Subsidiary of Research in Motion Limited, Mississauga, Ontario 2008 – 2011

Software Test Specialist

AMS (Asset Management System) and BSIS (BlackBerry Secure Identity Services) is a system solution ensuring identity of each BlackBerry and customer device assets are secure, allowing RIM to manufacture secure devices in any manufacturing location and leverage a RIM Certificate

Working environment: SOA implemented with Web Service/SOAP/WSDL, Linux/Unix, Windows, C/C++/Java/Perl/shall, HP QTP 10.0 /QC, VBscript, postgresql, RPM, Apache Tomcat, ANT, Cygwin, BugZilla, XML, SVN, CVS, VMware, HSM, SQL Server, Selenium, etc.

Responsibilities: Involved in the review of requirements specifications to analyze function, performance, reliability, scalability, testability, usability, security and compliance requirements and detected good bugs earlier.Developed and migrated detailed Test Cases in Quality Center.Evaluated Selenium automation test solution and implemented prototype for our testDeveloped test plans, test cases, testing resource requirements and overall scheduling of testing activity.Developed automation test solutions and improved test efficiency through proposal, design, implementation and execution of system test and automation using QTP, java, C, Perl, and shell scripts.Collaborated with QA testers and developers for test execution, bug fixes and release.Performed both manual and automation Regression, Integration, system performance, scalability, and load and stress, Migration, End-to-End test cases and tests, also enhanced and maintained them in compliance to the changing requirements to validate the new or enhanced functionality. Improved efficiency through procedural analysis and ongoing quality improvement recommendations. Facilitated presentation of RIM Test Automation Conference 2009 and QTP solution to Certicom 60 staff.Participated in Risk Assessment meetings and developed the risk analysis for the testing effort.

TATA CONSULTANCY SERVICES (TCS) CANADA LTD., Mississauga, Ontario 2005 – 2008

Project Team Leader; Senior QA Consultant

Toronto FIX Client Connectivity Integration project (CRM) for the client at Dept. of Global FIX (Financial Information Exchange protocol) Integration, Morgan Stanley (New York, US). Working environment: Sun Solaris UNIX, Linux, Perl, ksh, Sybase, XML, Autosys, Salesforce, ISQL, Relationship Darwin, ErWin, C/C++, Informatica, Oracle, DBArtisan 8.0, Sybase SQL Advantage 11.5, Eclipse 3.3.1, FIX engine, various trading applications and related simulators, etc.

Responsibilities: Led project activities on trading application and infrastructure E-to-E integration and test Guided Quality Assurance Engineers in writing test cases, test scripts preparation activities. Successfully designed, implemented and applied several UNIX based automation tools into production environment for integration verification, historical data analysis and extraction, and product migration to reduce costs and improved test and integration efficiency.Developed documentation on FIX Integration Process for US Markets to guide and improve integration process an got excellent remarks from a VP in Morgan. Facilitated seminar on FIX Connectivity Integration in TCS global team, with presentation material thereafter incorporated into TCS Skillport Course Library .Successfully completed numerous global FIX Client Connectivity Integrations and client End-to-End certification UAT tests with various trading applications and trading order flows, which are Algorithms (BXS), SORT, CASH/OMWP (Order Management Workstation Program), PASSPORT, Swaps, Options, and Futures using various OM and network vendors’ products (incl. Bloomberg, Charles River ) etc., for global markets in New York, London, and Asia. Created test plans/test cases, bug tracking/defect management and reports Provided production technical support for the clients of the FIX trading applications and infrastructures.

QA and Test Team Leader, Morgan Stanley (US) project of Security Lending IT

Working environment: Sun Solaris UNIX, Linux, Jira, Perl, CGI, ksh, Sybase, Java and Java XML Broker (JXB), XML, Web Server, HTML, Autosys, MQ, DistTest auto software testing environment, DBArtisan 8.0, Eclipse 3.3.1, JDK 1.6, Sybase SQL Advantage etc.

Responsibilities: Planned long term project work for Toronto team; set up a project team home page for on-line plan monitoring and work status updates, test strategy, test glossary and term, and technical info reference.Developed, managed, tested automatic searching engine tool project for quick search of operational data so that it improved dramatically productivity with production data search accuracy and efficiency.Set up DistTest software auto testing environment; implemented test scripts to run with auto testing tools.Executed system and application test for different programs and applications production release/turnover

ROGERS CABLE & WIRELESS LTD, Data Warehouse Division, Toronto, ON 2005

Senior Software Consultant (Independent Contractor)

The Rogers Wireless is the largest wireless service career in Canada, and has a very successful Data Warehouse application system for CDR (Call Detail Records) of billing application system. The working environments are: HP/UX, Korn shell, Perl, Netezza Performance Server data warehouse, XML, Informatica and Webfocus.Implemented and tested data ETL processes for CDR (Call Detail Records) data extraction of billing application on raw records from TDMA switches to staging area of Data Warehouse, load and transformed from staging area into data mart server with Informatica PowerCenter solutions. Hosting approximately 300GB.

The Rogers Cable has been the No.1 biggest service provider for cable TV technologies in Canada. The DHT (Docsis HMS Transponder) Power Supply Management System is a critical component in the HFC/CMTS cable networks for reliable operations as well as for its Data Warehouse data collection as well. The working environments are: Sun UNIX, .NET_SNMP5 libraries, TIBCO libraries and daemon for inter-process communications, SNMP 1/2c/3, GNU C/C++, Oracle PL/SQL, Informatica and Cognos. Designed, implemented and tested Fault Surveillance System and architecture with three major components for DHT (Docsis HMS Transponder) Power Supply Management System: Master Controller for task assignments, Data Collector for data collections via SNMP polls, and Data Handler for delta-data distribution for Remedy system and Data Warehouse ETL process

NCR CANADA 2004

Teradata Demand Change Management (DCM) Data warehouse division, Toronto, ON

Senior Software Consultant (Independent Contractor)

The NCR Teradata Data warehouse has been the most proven and powerful database for data warehousing in the world. The Teradata Data warehouse application for Demand Change Management (DCM) has been well known and has been widely used in retail industry.

The Allocation application module of DCM is to be created with three methods: Pre-Allocation, Purchase Order, and Distribution Center for improving companies’ inventory productivity and service levels. The background batch process environments for the data warehouse are: Teradata and data warehouse, SQL, Pro*C, UNIX, Informatica PowerCenter ETL tools, Korn shell, and C/C++ etc.Successfully completed system analysis and design for database schema architecture enhancement with Erwin and batch backend process based on requirements gathered from business users for new release.Successfully implemented and tested the system application with 5 different method calculations for Demand Chain Management and integrated with Data Warehouse and front On-Line Web based GUI.

SIEMENS, Chantry Networks, Mississauga, ON 2003

Software Consultant (Independent Contractor)

The BeaconMaster controller is a high performance Operation, Administration, Maintenance and Provisioning (OAM&P) platform and mission-critical application that provides centralized intelligence for Chantry’s WLAN solution. Work environment: Unix, Red Head Linux, Java, AdventNet compiler and C etc. Helped company launched 1st Beta product on time by having designed and implemented a critical component on SUM (Software Upgrade Manager) of BeaconMaster controller for WLAN on the Linux platform with employing GCC, Bash script, RPM (Red Hat Package Manager), CVS (Concurrent Versions System), gdb and MySQL to debug and develop the solutions for software download, installation, upgrade, backup, recovery, restore, designed and executed system and integration tests. Specified the hierarchy on the CLI (Command Line Interface) as an alternative User Interface of OAMP, and implemented the solution with Java, AdventNet compiler and C editor tools on Linux platform.

TDC (Toronto Design Centre), Motorola Canada, Markham, ON 2000 – 2002

Senior Software Engineer

Work environment: Unix, Red Head Linux, C/C++, XML, Java, ClearCase, DDTS, Informaix, Oracle, Windows NT, Rational Rose etc.Successfully designed the database managed objects architecture with Rational Rose, completed the related database system programming and co-ordinated system tests for the project of Network Management System (NMS) with SQL and XML for Astro 25.Designed, implemented, integrated and tested the system performance test simulator tool – Topoloder tool for new OMC-R system release. Set up and integrated the network test environment, performed system performance and regression testing.Successfully led, implemented and tested new critical features with SNMP for the OMC-R FM (Fault Management) and EMS (Element Management System), correlation mechanism for collecting and distributing the events to the right NMS components. Verified, validated and tested the system features. Delivered the features on time which were critical and on demand for the release (US $2M contract) Edited SRS (Software Requirement Specification) documentation and effectively provided a guideline for design and development and resulted in successful completion of a US $2M contract.

BELL LABS (Wireless Innovation Labs), Lucent Technologies Canada, Mississauga, ON. 1997 – 2000

Application Software Engineer

Work environment: Unix, Red Head Linux, C/C++, Java, Oracle, Windows NT, 5ESS Assessed and analyzed business requirements. Deigned, architected, implemented, integrated and tested the AFT+ (Application Front-Data Transformation) proxy n-tier distributed Server application software solution; solved some IPC (Inter Process Communication) performance issues. Captured change data and replicated CDC to data warehouse staging area. The AFT+ was recognized for far beyond the original requirement in the aspects of robustness, response time performance, and exception handling. AFT+ tool had been commercialised and launched into marked with the price US$+150k. The server had been ready for a scheduled business show that determined the success of the MIG product.Successfully evaluated several 3rd party solutions for Data Mining, Data Marts and Data Warehouse. Designed and implemented a UNIX and Java based CDR (Call Detailed Record) for billing data/accounting management feature in OA&M for MIG (Mobile Internet Gateway) system Initialised and edited FDD (Functional Definition Document) for MIG system software development team.

NOKIA MOBILE PHONES AND TELECOMMUNICATIONS LTD., Finland

Software Engineer

EDUCATION AND PROFESSIONAL DEVELOPMENT

M.Sc. in Computer Science Specializing in Software Engineering, Artificial Intelligence and Parallel Computing, bo Akademi University, Turku, FinlandB.Eng. in Electronic Engineering Specialising in Radio, Wireless Technology, and Electronic Engineering., Beijing Institute of Posts & Telecommunications, Beijing, China

Training: SQL Server, QTP, Software Testing and Quality Assurance, Scrum in Agile, Financial Electronic Trading System, FIX protocol, Financial knowledge, Professional Managers Program (PMP), Data Modelling with Erwin, ETL process with Informatica. Cogons, ITIL (Information Technology Infrastructure Library), Rational Rose and UML. Database Modelling and Programming. Advanced Programming In Java. Java Web Programming. UNIX Inter-process Communications. XML. Sybase SQL and System. Advanced C++ Languages. Etc.

CERTIFICATES

ITIL (Information Technology Infrastructure Library) foundation, Certificate, 2007

Brainbench Informatica PoerrMart/PolwerCenter 6.2.1 assessment

Contact this candidate