Sql Server Quality Assurance

Kristine M. Tiongson

********.********@*****.***

* ********* ******, ** *****

Cell: 714-***-**** Home: 949-***-****

Summary

A Senior Consultant specializing in data warehousing, systems integration,

database administration, and Java web development. Strong technical and

business knowledge gained from experiences in the industries of aerospace

and defense, financial, software, hardware, and telecommunications. A Sun

Certified Java Programmer and an IBM SOA Fundamentals certified.

Knowledge

Programming Languages: Java/J2EE, JSP, Struts, JDBC, HTML, XML, XSLT, SQL,

Oracle PL/SQL, Shell scripting

Integration: ETL, Web Services, JMS Queues, SOAP, WSDL, SOA, Asynchronous

Messaging

Databases: Oracle, SQL Server, MySQL, DB2, Acess, PostgreSQL

Systems: UNIX, Linux, Windows 98/2000/XP/Server 2003

Software: Microsoft SQL Server Integration Services (SSIS), Microsoft SQL

Server Management Studio, Eclipse Java IDE, SAP Exchange Infrastructure

(XI) 3.0, Sun's e*Gate Seebeyond 4.5.3, Altova MapForce, Altova XMLSpy,

ErWin Data Modeler, Toad, Oracle SQL*Plus, Putty, SAP Front End, Apache

Axis, TortoiseSVN, PVCS, AnthillPro, MS Office, MS Project, MS Virtual PC,

MS Visio

Work Experience

Hitachi Consulting

Senior Consultant

May 2006 - Present

Wells Fargo Project

Dec 2009

- Jan 2010

ETL designer and developer for an Analytical Data Mart in Wells Fargo's

National Business Banking Center. Validated the logical data model, created

the source to target mappings, and generated a physical model for the data

mart. Developed ETL processes using Microsoft SQL Server Integration

Services (SSIS) 2005 with Oracle, Teradata, and SQL Server as the source

databases and SQL Server 2005 as the target database. Identified business

rules, setup staging tables and target tables, and assisted with testing

and QA.

Raytheon Space and Airborne Systems

May 2006 - Nov 2009

Lead systems integrator, database administrator, and Java developer in a

web-based application project from the development stage to maintenance.

Designed and developed integration architectures, data migration processes,

and application enhancements. Mentored consultants and senior consultants.

Systems Integration Responsibilities:

. Integrated the application to various systems via Web Services,

SOAP/HTTP, JMS Queues, ETL, and FTP using the following middleware

technologies: SAP XI 3.0, Sun's e*Gate Seebeyond 4.5.3, and Altova

MapForce

. Developed Shell scripts for the ETL legacy feeds

. Maintained the cronjobs, disk space usage, and directory structure of

the UNIX servers

Database Administration Responsibilities:

. Managed the Oracle 10g database objects using SQL queries and the

ErWin Data Modeler

. Optimized PL/SQL stored procedures, packages, and functions

. Wrote SQL database deployment scripts using SQL*Plus and Toad for

Oracle

Java Web Development Responsibilities:

. Performed enhancements and defect remediation to the application using

Java/J2EE 5.0, JSP, Struts, Spring, and JDBC

. Created builds and deployed the ear file using AnthillPro

Quest Software

QC Analyst Aug 2005 - April 2006

Implemented automation testing for all database platforms of Toad using

Delphi and Test Complete. Performed extensive software testing for all

database platforms of Toad. Authored detailed test cases and test results.

Rockefeller Group Technology Solutions

IT Intern Sept 2004 - Aug 2005

Configured routers, Voice/Fax Over IP gateways, and IP phones for the data

center. Designed the circuit order process and the inventory process for

the Santa Ana office. Managed server backups, circuit orders, and

maintained the inventory system.

ID Technologies

Junior Programmer July 2003 - Sept 2004

Implemented a receiving inspection client-server application using Visual

Basic 6 as front end and SQL Server 2000 as backend. Performed engineering

testing for barcode, magnetic stripe, and smart card readers. Performed

quality assurance and technical support to customers.

Education

B.S. Information and Computer Science, University of California Irvine

Graduated Cum Laude

Certifications

Sun Certified Programmer for Java 2 Platform Standard Edition 5.0, Sun

Microsystems

IBM SOA Fundamentals Certified, IBM

Training

Knowledge Product SAP Exchange Infrastructure (XI) 3.0 - Course ID: OXI30S

SAP Exchange Infrastructure (3.0) - Course ID: BIT400

SAP Exchange Infrastructure Mapping - Course ID: BIT460

SAP Exchange Infrastructure Development - Course ID: BIT450

SAP Exchange Infrastructure ccBPM in Business Process Management - Cource

ID: BIT430

Contact this candidate