TECHNICAL SKILLS:

Object Oriented Technology and Modeling: Rational Rose Model with UML Technology, Microsoft Visio,OOAD, UML

Programming Language: Microsoft Visual Basic, C, C++, Java and C#, PHP, Java Script

Development Tools: Microsoft Visual Studio, Rational Development Studio, and Microsoft Visual Studio .Net, Microsoft Office Suite, Rational Unified Process, Scripting Languages. Eclipse. (Hibernate, Spring, JUnit)

ERP (Enterprise Resource Planning): Siebel CRM, Miva - Merchant Commerce Server,Sales Force, DSO-Velocity and some SAP(Material Management)

Software QA: Test Planning, Designing, Test Script, Automation Tools - Rational Test Studio Suite (Purify, Pure Coverage and Quantify), Visual Test and HP Quality Center, Selenium some WinRunner

OS: Microsoft Windows, .Net Server, Apple Mac OS, Linux and some UNIX

Database/Data warehouse/Reporting Technology: Enterprise Date Modeling and Database Design, Oracle, Microsoft SQL Server, Microsoft Access, IBM DB2 and MySQL, Business Objects, Quest Toad, Actuate Report, Talend, Crystal report(Limited)

Software Configuration Management: Visual Source Safe, Microsoft SLM (Source Library Manager), Rational ClearCase, APEX, Sharepoint and CVS.

Bug Tracking Software: Microsoft RAID (Internal Tool), Bugzilla, HP Quality Center and Rally

PROFESSIONAL EXPERIENCE:

Confidential

MMBST (Material Management Business System Transformation)

Responsibilities:

• Functional Analyst / SQL Developer
• Develop functional specifications (business rules, UI)
• Work with System Architecture and Functional Analyst
• Interpret and translate complex transformation rules into functional specification
• Analyze Oracle database model (using SQL Developer, Visio, TOAD)
• Design and Develop SQL Query codes for Business Transformation Rules of Data Migration/ Integration (Using Qwest TOAD, Oracle SQL Developer)
• Use Oracle APEX Development Environment
• Develop and validate system functionality
• Develop lineage and data-flow diagram
• Ensure code delivered properly tested and meet the business requirements and timeline
• Perform unit testing and support Integration testing as required
• Configure/Create Outbound Tables/Queries (Oracle) to map for SAP Objects (Material, Bill of Materials, Classifications, …)

Confidential, Washington

System/Data Analyst

• Software Quality Assurance Engineering, Integration / functional testing (Agile Development)
• CDW PMVIEW (Oracle Database Views)
• Execute SQL Script to validate CR Views in multiple environment
• Compile Test Harness
• Test Automation
• Create/Execute test harness in Quality Center/Quick test Pro
• Execute automation test, analyze and report

Confidential, Washington

Web Site Developer

Responsibilities:

Using HTML/DHTML, Java script, JQuery and PHP on LAMP

Confidential, Washington

Sr. Software QA Engineer

• Quality Assurance
• Develop Test Plan, Test Architecture, Test Cases against product
• Data Warehouse
• Develop a data warehouse document (artifacts), metadata
• Design test cases with embedded SQL scripts
• Develop a DTS (Data transformation tool) for data migration
• Work with Google, Yahoo and MSN API Search Engine for click and impression (Lead Generation)
• Web UI testing
• Develop test plan and test cases (presentation layer)
• Use automation testing (using Selenium and some ruby)
• Perform JMeter Reporting
• Validate data quality using Actuate Report against transaction and aggregated data.
• Agile Methodology for Data Migration
• Develop data migration document
• Work with Business Analyst to compile data sources from the legacy System
• Develop SQL script, Java code for the target database
• Create a data migration method, test plan,
• Create a data mapping template
• Work with Talend /MySQL/ Toad to validate data discrepancy

Confidential, Washington

Sr. Software QA Engineer

• Quality Assurance / Testing
• Develop Test Plan, Test Cases against product specification, use cases.
• Prepare FMEA (Failure Mode and Effective analysis) for multiple projects
• Develop product configuration tool for automation and regression test using Java programming
• Perform Back-end testing via Quest Toad validating data integrity, writing SQL scripts against Oracle and MySql databases.
• Perform regression, system testing of Integrated Clustered Environment (Web-Service SOAP, Application Server and Database Tier) in BEA WebLogic and Apache/Tomcat platform
• Create a program defect, track till is fixed
• Mentor fellow new test engineers
• Perform Data Migration, Report Analysis and Payment Processor testing with 3rd party application (CyberSource)

Confidential 

Software Data Analyst

• Develop a front-end Microsoft Access and backend Oracle database application To validate loaded professional and institutional claims and generate a report for medical definition code and claim billed amount.
• Data Cleansing/Quality/Migration
• Migrate a large volume of legacy claims (OCPS, CATS) to Diamond System
• Identify, Cleanse Data Split the data into Professional, Institutional Claim and Detail Tables and Apply Business Rules
• Create a CFF format based on the tables relationship
• Load the claims in CFF Generator
• Run MCL (Manage Claim Load) to Diamond System
• Verify the claims via TOAD
• Generate report for analysis (Ad-Hoc)
• Record Count/Comparison Tool
• System Test/Integration
• Ownership/Execution of specific interface systems
• Legacy Billing
• EPIC Health System (Billing System)
• Report (Business Objects)
• Use Quest TOAD to validate and trouble-shoot loaded claims
• Use Mercury Test Director to keep test results
• Use Unix Shell Script /Command for executing various interfaces
• Diamond Client/Server (Perot-Systems healthcare)
• Member Eligibility
• Benefits for Claims
• Claim Adjudication
• RCA (Reject Claim Administration)
• Troubleshooting rejected claims, modifying data and resubmission of claims to Diamond System

Confidential 

Software Test Analyst

• Test Analysis and Design
• Perform regression, functional, implementation and tests for Siebel
• based application.
• Design test cases based on business uses and business rules
• File bugs into bug database in reproducible manner and track until they are resolved
• Work with Rational Test Director, Rational ClearCase, Rational
• ClearQuest
• Perform regression analysis on Core and Boundary Systems applications

Confidentia, Bellevue WA

Software QA Analyst

• Reconcile data from generated report using Microsoft SQL Server, Oracle, and SQL Navigator, Quest Toad
• Create and execute SQL query script for data analysis (Oracle SQL Plus and Microsoft Query Analyzer)
• Report difference before and after file reports
• Configure and maintain flat files on Unix Box
• Work with Business Object to validate data difference from Reports and Universes
• Use Crystal report to analyze data in limited basis
• Develop Bug Tracking System using Microsoft Access for in-house usage.

Confidential

Software Engineer

System Configuration

• Install and configure the latest Windows 2003 Advanced, Data Center Server
• Create and configure domain controller Active Directory Service
• Configure Net work Setting, IIS (Internet Information Server) and ODBC settings and Work with NT Kernel debugger

QA/Analysis

• Create Test Case Outlines, Test Cases, Test Case Matrix
• Prepare Installation Flow Charts and Business diagrams
• Analyze program defect and report bugs in a reproducible manner
• Work with Microsoft SQL Server, IBM DB2 Universal Database (Install,
• Configure, populate data with SQL Scripts), validate data using scripts
• Communicate with Software vendor to resolve external bugs
• Siebel Enterprise Server (Gateway, Database, Siebel dedicated web clients)
• Miva Merchant Commerce Server (Single Site, Multiple Sites), Novell GroupWise System

Confidential, WA

Application Software Developer 

• Custom-Made Dispatch oriented application with Microsoft Access 2000 / Visual Basic
• Gather system requirements from the users and management
• Perform feasibility analysis and present for the customer.
• Design business process, functional decomposition models.
• Co-develop, test and implement the system
• Maintain the system as needed

Confidential, WA

Senior Software QA Engineer

• Service End testing
• Create Store Procedures, Triggers using (Oracle SQL Plus) and JUnit Testing
• Configuration of Apache Server (Linux), Database.Conf and XML files.
• Deployment of the final test build
• Validate Automation Tools: Rational Test Studio, Mercury WinRunner, RSW E-Test and Parasoft Web King
• Quality Assurance
• Software Analysis
• Report Testing