SUMMARY:

• 10+ years of solid working experiences on implementing, testing and maintaining software systems.
• Strong relational database, multi - tier applications development and testing experiences.
• Database/BI Data warehouse and Cube fundamental and testing development.
• Excellent analytical and problem-solving skills.
• Self-motivated team player with excellent management and communication skills.
• Strong understanding and knowledge of financial / accounting system, 7 years of experience with banking system.
• Familiar with testing methodologies and Agile/Scrum SDLC testing.
• White box, black box and grey box testing; manual and automated testing; unit testing, system integration testing, regression testing, end-to-end testing, UAT and performance testing.
• Passionate about data and analytics.

TECHNICAL SKILLS:

Databases and servers/networks: SQL-Server 2008/2010/2012, Netezza, Teradata, Sybase, My SQL, Ingres, Oracle and Informix, IBM mainframe, Novell.

Programming Language & Tools: T-SQL, PL/SQL, SQL, MDX, C#, Informatica, IBM DataStage, IBM CognosSSIS,SSAS, SSRS, Unix shell, Cobol, C/C++, Visual Studio 2008/2010/2012, SharePoint, Excel Pivot, Google Docs,: Amazon Web Services, Lotus Notes, Visual SourceSafe, SVN, Hadoop. Agility, WinSQL.

Operation System: Amazon Cloudyberry S3, MS Windows, MS Windows servers, Unix, Linux

Test Tools: HP Quality Center,Jira, Rally, TFS, Microsoft product Studio, Symantec Ghost, Compuware TestPartner/TestRecord/QADirector.

PROFESSIONAL EXPERIENCE:

Confidential, Mountlake Terrance, WA

Software Test Engineer III

Responsibilities:

• Design, develop and execute test plans and detailed test cases to ensure system functionality and data integrity from multiple, complex source systems on multiple platforms into Integrated Data Source.
• Analyze business and technical requirements to understand the ETL process and ensure that deliverable are fully realized.
• Design and write complex SQL to perform data validation and data analysis.
• Standardize test automation for BI QA team.
• Record testing results, troubleshooting, bug reporting, bug triage and validate bug fixes.
• Communicate with Project management, analysts and developers to address project requirements, deliverables and any potential road blocks.
• Mentor other test engineers.

Confidential, Seattle, WA

Data Quality Analyst

Responsibilities:

• Design, develop and execute robust data quality test plans and detailed test cases to ensure system functionality and data integrity from multiple, complex source systems on multiple platforms into enterprise data warehouse and universes.
• Analyze business and technical requirements to understand the ETL process and ensure that deliverable are fully realized.
• Write SQL to create test automation scripts and perform data analysis.
• Record testing results, troubleshooting, bug reporting and validate bug fixes.
• Cooperate with project Management, business analysts, and development staffs toward the reporting and resolution of errors with agile scrum methodology.

Confidential Seattle, WA

QA Software Engineer

Responsibilities:

• Review and analyze requirements, design and implement test plan/cases with different client BI projects.
• Data quality for large scale ETL, data warehouse, Cube and reports.
• Front end / back end testing for Web UI.
• Writing SQL, MDX scripts and C# to implement test automation.
• Execute test cases, record results, identify and track back end code issues, bug reporting and validate bug fixes and troubleshooting.
• Work closely with Project Management, Technical Architects, and Development staff toward the reporting and resolution of errors with agile scrum methodology.
• Design and implement test plan/cases on Microsoft Clearview Web UI application.
• Develop new QC application and test automation framework for AOD (Audience on Demand).
• Finish clients’ migration from local Sql Server system to AWS cloudy system.

Confidential, Seattle, WA

Senior Software Test Engineer

Responsibilities:

• Review and analyze requirements, design and implement test cases.
• Test Automation in C# enhancement, debugging and troubleshooting.
• Create test documentations, such as test guide and quick start.
• Execute test cases, record results, identify and track back end code issues, and validate bug fixes and troubleshooting BizTalk.
• Work closely with project team drive issues/triage to resolution with agile scrum methodology.

Confidential, Sammamish, WA,

SDETII

Responsibilities:

• Participate in analysis, design and development of test plans, test cases under deadline pressure.
• Design and document test cases for software release projects based on functional and technical specification documents.
• Create test documentation including master test plan and some test related documentation.
• Create and execute manual and automated test cases, record results, identify and track back end code issues, and validate bug fixes.
• Work closely with project team drive issues/triage to resolution with agile scrum methodology.
• Prepare appropriate test environments for software release projects.

Confidential

Software Tester

Responsibilities:

• Design and run both manual and automated tests.
• Analyze and communicate test results.
• Review design and requirements specifications to determine testing requirements.
• Work with software developers to resolve software defects.
• Work with customer support personnel to analyze issues and determine if they represent software defects.
• Assist in preparing and enhancing test processes.

Confidential, Richmond

Software Support / Integrator

Responsibilities:

• Tested and deployed new releases of the dispatch system, which is a GPS-based taxi dispatching.
• Provided technical support for data dispatch application software and Ingres RDBMS.
• Tracked and debugged system problems using Census Defect Tracking software.
• Resolved complex hardware, application software and database problems.
• Designed and Implemented complex geographic map databases using MapInfo.

Confidential

Software System Engineer

Responsibilities:

• Analyzed, developed applications.
• Built and managed backend large relational databases/data warehouse.
• Developed, maintained and updated databases for ATM real-time banking System .
• Developed financial application using C/C++ with Embedded SQL program to achieve banking transactions (deposit, withdraw, change password and check balance, etc.)
• Developed and executing test plans, test cases for the banking and financial systems.
• Developed and maintained the reporting engine with Informix -4GL.