Quality Control Assurance

Quality Control Software Engineering Data Analysis

Profile

. Quality Control of software products, contract requirements, and

company standards.

. Quality support of software, systems, hardware and test engineers.

. Hands-on experience in DW architecture, ETL process, ERWIN data

modeling, and database architecture.

. Proven ability to solve business and product issues while

mitigating risks and delivering on time.

Experience

Quest Software - Aliso Viejo, CA

March 2008 - Jan 2010

Quality Control - SQL Database Specialist

. Designed and implemented test cases for Engine components for SQL

Server and Oracle based products.

. Established quality processes and procedures for customer

requirements.

. Provided product version control and SF build implementation

scheduling.

. Managed defects-entry for Engine module, including defect tracking.

. Recommended development process improvements and technical

solutions to a wide range of problems.

. Developed SQL queries and scripts, extended stored procedures as a

part of validation cycle.

. Test cases for clusters, Tivoli Storage, Virtual machine

performance tasks.

. Tested new implemented functionalities of product and documented

them.

. Worked with application developers and Engine teams to coordinate,

track and migrate changes to production applications.

. Customer support and issue escalation for defects and enhancements.

. Maintained product version control and implementation schedule

using Agile/SCRUM model.

. Iteration planning, release notes and implementation handling.

. Implemented Quality Assurance activities of company software per

contract requirements, documented plans, and standards.

White Cap contract - Costa Mesa CA.

Jul 2007 - Feb 2008

DW/QA Specialist.

. Established quality process and procedures, business requirements

implementation of database design.

. Test cases design for inventory, sales, PO, marketing

applications.

. Performed DW data architecture and strategy standards

implementation.

. Analyze design and specifications for testing criteria.

. SQL queries design and implementation for system tests.

. Responsible for job scheduling and implementation of a version

control toolset.

. Test plans for ETL data transformation and documentation.

. Maintained problem identification and reporting process.

. Provided technical direction to business users.

. Developed logical and physical model documents, conceptual

diagrams, data flows, and work plans.

. Data analysis and production support of the Decision Support

Systems.

Capital Groups contract - Brea CA.

Feb 2006 - Jul 2007.

System Architect

. Implemented quality assurance procedures of Financial applications.

. Authored test plans of financial application components and process

improvement recommendations.

. Coordinated development and test team efforts for Segregation of

duties project .

. SQL queries review and unit tests for production implementation.

. Provided quality support for software systems, hardware, and test

engineers.

. Maintained Open Window operation for automated job control.

Performed SOX Audit and governor compliance check-list maintenance.

. File transformation quality control using FTP, BCP, command-line

utilities.

. Company standards maintenance, work prioritizing to meet customer

needs.

PowerCenter Workflow maintenance, folder migration, and user

account documentation.

. Customer requests and escalation procedure with tracking

application.

PacifiCare PHS - Cypress, CA

Jun 2005 - Feb2006.

System Analyst..

. Designed of Company security standards, database administration,

backup/restore and replication strategies for underwriting

applications.

. Performed quality control activities per documented plans, contract

requirements and enterprise standards.

. Database architecture documentation and SQL server specifications

for the small insurance groups.

. Data transformation and load strategy of Data Warehouse and

reporting systems.

. Documents data marts EDW design and data flow of pricing and

marketing.

. Supported production after hours job schedules and error handling.

. Third party application transfer documentation and it's production

support maintenance.

. Implemented file share security standards and coordinated

activities with the application teams, user communities, and 3-rd

party vendors.

. Performed version control of production implementation and

iteration scheduling.

. Problem identification and management team report design.

Healthcare Partners Medical Group - Torrance, CA

Nov 2000 - Jue 2005.

Database Analyst

. Performed quality control and data analysis of eligibility

applications.

. Designed and implemented business requirements of Enterprise data

marts.

Database modeling, user access documentation, implementation

schedule.

. Data Warehouse multidimensional model design and implementation.

. SQL scripts for DW data cleansing and data validation.

. User and developer team liaison to ensure Data warehouse

requirements implementation.

. Server capacity planning and specifications for decision support

applications.

. Data transformation design for Health Care applications and

management reports.

. Supported Business Objects universes, Crystal Reports and user's

accesses.

. End users feedback on specifications and defect tracking report

design.

. Work around procedures and processes quality control and

implementation.

. HIPAA compliances to ensure privacy and security of patients'

information and standards for electronic data transition.

Southern California Edison - Covina, CA

Mar 1998 - Nov 2000 Oracle/SQL Server Developer

. Designed and implemented database stored procedures, functions,

triggers for the deregulated price market applications.

. Designed and coded UNIX K shell scripts for the database backup and

recovery.

. Supported Oracle databases on UNIX and NT platforms.

AAA club of Southern California - Costa Mesa, CA

Oct 1996 - Mar 1998

Programmer/Analyst in a DB2, CICS, JCL environment.

. Developed and supported emergency service applications, coordinated

activities with the user community.

. Designed, implemented and tested ACCESS to DB2 database conversion.

. Supported and maintained the customer online request application

for the insurance system.

Skills

Databases: SQL Server, Oracle, Sybase, UDB, Access, etc.

Languages, scripts: SQL, PL/SQL, HTML/DHTML, UNIX Shell, XML/XSLT, VB,

Cobol/JSL, CICS, ActivX.

Operating Systems: Linux, Unix, TSO/ISPF, Windows

Tools: ERWIN, Informatica, ER/Studio, DataStage Websphere Designer, Data

Center, StarTeam, Tivoli, Lab Manager, SQL*Plus, OSQL, TOAD, Visio,

Hummingbird, DTS, VisionExplorer, FTP, BCP, EXCEL, SharePoint, Crystal

Reports, MS Analysis, HP OpenView, SQL MIIS, Project among others.

Education

MS, Civil Engineering.

Oracle DBA certification.

Contact this candidate