database developer

Hong Chen “Tom”

Irving, TX

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

469-***-**** (Cell)

SUMMARY

SQL Developer with over ten years of experience in database, data warehouse, and data reporting environments. Experience in domains including Financial, Marketing, & Telecom/Mobile.

TECHNICAL SKILLS

Language: UNIX toolbox (korn shell, sed, awk, grep, etc), Perl, SQL, PL/SQL, UNIX shell, Pro*C, C, XML.

Database: MS SQL Server 2005/2008 R2, Oracle 10g, 11g, Netezza.

Tools: SSIS, SQL*Loader, Oracle SQL Developer, TOAD, SQL*Plus

Protocol: TCP/IP, SFTP, CGI, HTTP

Middleware: Tuxedo, Ethernet, ADO

Operating System: Unix/Linux, Windows, MS DOS

Application server: Netezza, Bea Weblogic server.

PROFESSIONAL EXPERIENCE

J.P. Morgan Chase (IBM Consultant), Irving, TX Mar 2012-Present

• Design a series of metrics to measure improvement and impacts based on query types. Optimized complicate SQL query.

• Use explain plan to perform code remediation, aligned and adjusted with root cause analysis.

• Analyze report process flow and automate report.

Epsilon, Irving, TX Mar 2007-Oct 2011

Senior Database developer

• Write SQL, develop and deliver numerous simple to complex queries of ad-hoc and marketing initiatives for diverse business requirements. Tuned and optimized queries by altering database design, analyzing different query options, and indexing strategies. ETL development include manage data file using sed, awk ,etc in Linux box-Neptune and use nzload to load data file from Linux box-Neptune to the table in Netezza. Move tables from Oracle to Netezza or from Netezza to Oracle by using KSH in Linux box-Neptune.

• Merge and split files using cat, paste and split in Unix/Linux for other teams and client according to the business specifications.

• Use the multiple flat files connection manager to import multiple files into SSIS.

• Design, document and develop a process, write korn shell script to generate a report table that will run on Netezza to contain 4 columns--report date, table name, row count and max update_date from 41 large Netezza tables, it also contains all of the standard logging and error handling. This process is capable of re-run each day and automatically account from 41 large Netezza tables.

• Write Korn shell scripts for automating tasks. Manage 18 KPI (Key Performance Indicators) jobs and their dependency within a schedule in Maestro. Monitor maestro jobs as well as troubleshooting in the event of any job failed.

• Analyze customer data to understand customer behavior, preferences and trends. Analysis done on data warehouse (Oracle, Linux) using SQL (SQL*Plus, Oracle SQL Developer) and Microsoft Excel.

• Employed the Database Engine Tuning Advisor to analyze the performance effects of workloads and implemented its recommendations wherever appropriate.

• Use query Analyzer for Performance tuning.

• Work closely with business system analysts and client on business requirements and functional specification, provide assistance to other team and client for all business areas to deliver timely projects.

• Participate in daily code review and provide on-call support on a rotating basis.

Cingular Wireless, Inc, Richardson, TX Jul 2006-Mar 2007

Senior Analyst

• Provided a long term solution for the existing BAN (Billing Account Number) exhaustion problem by expanding the number of digit in the sequence from 9 to 12.

• Wrote a program in PL/SQL to provide a feed from the Telegence Billing system to the Horizon commission system for any customers who combine their Cingular Wireless and AT&T land line bills.

• Ran all dealer jobs that produce extract files in dealer test environment.

• Used FOCUS data structure, procedures and various UNIX Shells to generate commission feed, extracts and reports.

CenturyTel, Inc Monroe, LA Nov 2005-Jun 2006

Senior Analyst/programmer

• Provided On Going Support (OGS) for Order Management System (OMS), Customer Service Management (CSM) application of Ensemble Amdocs Customer Care and Billing System as part of OGS-CSM team.

• Wrote and tested SQL scripts for production implementation. Wrote batch job by using Perl. Created test cases for QA test according to the requests. Created ECD and checked in/out source code through Dimension to keep changes consistence.

• Used the SQL Server Profiler tool to monitor the performance of SQL Server – particularly to analyze the performance of the stored procedures.

• Developed process layer and data layer procedures on Unix/Oracle Platform. Created and Implemented procedures transfer business data between database and front-end application Using varies tools such as SQL, Oracle Pro*C and C through TUXEDO.

• Performed analysis and research on current production issues. Provided technical solution for any CSM application related issues, including program debugging programming, testing code fixes and coordinating the change release using SQL, Pro*C and C.

• Worked closely with other teams such as QA team, table team, SQL, PL/SQL script review team, etc to ensure all critical issues were resolved by timely fashion.

• Provided On-Call support.

HP Invent, Plano, TX Apr 2005-Sep 2005

Software Tester

• Executed test cases by manual testing web-based software products-HP OpenView Select Identity- A Context-Based Approach to Identity Management on Java application platform-WebLogic.

• Integration testing on different components such as audit and configuration report, admin function, resource, connector and attribute management for different User Interface in Window environment.

• Loaded test for new application, Set up application and load servers. Validated that the sites and systems meet design specifications and requirement. Create clear, concise detail oriented reports on bugs or quality issues based upon test plans and test cases.

• Reviewed and reports on test case results to team lead, as well as, cross-functional team members regarding any potential quality issues per build/release. Reported defects and verified defect fixes through QUIX Team track tool.

• Participated as part of the team in delivering a high quality product to customers.

Novus Real Estate, Inc., Richardson, TX May. 2002-Mar. 2005

Developer

• Using UNIX Environment and Shell Scripts, Oracle SQL, Identifying general code issues and data issues. Providing data analysis, design and maintenance for company system.

• Analyzing real estate application. Developing for processing of the inputting, retrieving, updating data such as property’s address, date that property were built from business database.

• Participating application processing, testing, investigation and correction of error conditions and verification that processing complies with new standards.

Cingular Wireless, Inc., Richardson, TX 2000-2002

Analyst

• Provided system and production support, worked on numerous SERF (System Error Request Form) and Defect, provided timely solutions to meet market needs using Pro*C, Shell Scripts, SQL.

• Developed new functionality for the Client Server based systems in support of Telegence Billing and Customer Care telecommunications products using Pro*C, Shell Scripts, SQL .

• Created scripts, shells and Perl program. Developed process layer and data layer procedures on Unix/Oracle Platform. Wrote function calls transferring business data between database and front-end application through TUXEDO Using C and Oracle Pro*C, SQL. Implemented function calls to TUXEDO Middleware transferring business data to back-end application

• Provided detail design of system solutions, custom development, quality assurance, documentation, deployment, and production support, this also include business and technical requirement analysis, Transferred business data into table values, front-end and back-end application through TUXEDO Middleware.

• Maintained and enhanced Billing and Customer Care applications, Telegence API. Duties included application processing, coding, testing, test plan preparation, testing verification, program debugging, and development of job flow, implementation and coordination of program releases, investigation and correction of error message or application discrepancies, looked at CSM data layer and verified items that can be used to improve Telegence performance.

• Appointed as manager's first contact to do market upgrade spot check for different versions by using Telegence on-line test.

• Worked closely with Telegence QA team, CC team, ECA group and Amdocs CSM team in Israel etc., to resolve problems, provided On-Call support to application upgrade and market roll-out.

EDUCATION

Texas A&M University, Commerce, TX

Master of Computer Science - 2000

PROFESSIONAL TRAINING

• Unica training – IBM Unica Enterprise, Boston (Aug. 2009)

• Amdocs Billing System-“Ensemble” training -Amdocs Training Department (Jan.2001)

• Telegence Training- SBC Services, Inc (Feb.2001)

• UNIX and Shell Programming Training - HP, Inc (Jun. 2001)

• Six-month JAVA 2 Certificate Training - Infinite Technology Training Center, Richardson, TX (Sep.1999-Mar.2000)

Contact this candidate