We provide IT Staff Augmentation Services!

Data Warehouse Consultant Resume

SUMMARY:

  • Meticulous, mission - driven, and proactive QA Consultants with a broad spectrum of work experience with prominent corporations 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
  • Network management system
  • Experience in Software Quality Assurance: 6 years in the testing areas of Functional, Regression, Integration, System, GUI, Backend, Performance, Load and UAT.
  • Test Plan, Test Strategy, Test Cases, Requirements Traceability Matrix.
  • Web based, Desktop applications, and Multi Tier, and infrastructure
  • Application Development, Application re-engineering, Legacy Migration and Data warehousing projects, Application Integration.
  • 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, Confidential, 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

Confidential

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 application
  • Reviewed 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

Confidential

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.

Confidential

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

Confidential

Software Test Specialist

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, Confidential, 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 test
  • Developed 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 Confidential 60 staff.
  • Participated in Risk Assessment meetings and developed the risk analysis for the testing effort.

Confidential

Project Team Leader; Senior QA Consultant

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 Confidential global team, with presentation material thereafter incorporated into Confidential “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, Confidential 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

Confidential

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

Confidential

Senior Software Consultant

Responsibilities:

  • 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.
  • 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

Confidential

Senior Software Consultant

Responsibilities:

  • 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.

Confidential

Software Consultant

Responsibilities:

  • 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), Confidential (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.

Confidential

Senior Software Engineer

Work environment: Unix, Red Head Linux, C/C++, XML, Java, ClearCase, DDTS, Informaix, Oracle, Windows NT, Rational Rose etc.

Responsibilities:

  • 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.

Hire Now