Junior DBA
Resume:
Chung Chau
Lexington, MA *****-2427
**********@*******.***
SUMMARY OF QUALIFICATIONS
Solid understanding of Database concept, SQL Server Administration, SQL, Data Modeling and Database related products.
Over 10 years of PeopleSoft experience adept at implementing, upgrading and supporting PeopleSoft applications, including Financials and Supply Chain Management (FSCM) and Human Resource Management System (HRMS).
Solid understanding of PeopleSoft technical architecture and Tools.
TECHNICAL SKILLS
Database: SQL Server 2000, SQL Server 2008 R2, Oracle 10g and 11i, ODBC, BEA WebLogic 8.1 and 9.2, BEA Tuxedo, MS Access
Programming: SQL, T-SQL, PL/SQL, PeopleCode, SQR, PeopleSoft Query, HTML
Applications and Tools: PeopleSoft FSCM 9.0, PeopleSoft HRMS 8.9, PS Application Designer, Data Mover, nVision, Crystal Report, PeopleSoft Trace, TOAD, ftp Client, Oracle SQL Navigator, Oracle Client, SQLServer Enterprise Manager, SQLServer Management Studio, Microsoft FrontPage, Microsoft IIS, Microsoft SharePoint Designer, Telnet, Micro Focus COBOL
Platforms: Windows (all versions), Windows 2003 Server, Mac OS, HP UNIX, Linux
EXPERIENCE
Software Engineer 4/2006 - 9/2010
Analogic Corporation Peabody, MA
• Created and maintained PeopleSoft Pure Internet Architecture (PIA), including Application Server, Process Scheduler, and WebServer (UNIX and NT). Defined portal’s process scheduler, Web Service and Integration Broker as required. Created multiple Process Scheduler instances for load balancing. Administered and troubleshoot all aspect of server issue as needed. Setup COBOL, nVision environment from PeopleSoft file servers.
• Installed PeopleSoft Change Assistant and setup Environment Management Framework (EMF), and administered patches, updates and maintenance packs (MP) as required.
• Support PeopleSoft FSCM 9.0, including Billing, Account Payables, Account Receivables, Inventory, Cost Accounting and other modules. Support PeopleSoft HRMS 8.9 includes Self-Service module and ADP payroll interface.
• Responsible for PeopleSoft HRMS 8.5 to 8.9 upgrade and later assisted in UNICODE database conversion for multi-language HRMS, applied multi-language PeopleTools and Language Packs (French, Danish and Simplified Chinese). Involved in PeopleSoft Financial upgrade from 8.x to 9.0.
• Developed and modified custom pages and other components as required. Created and modified SQR, Application Engine, PeopleSoft Queries and Crystal Reports as needed. Diagnosed error process using PeopleSoft trace tools and contact Oracle ‘My Oracle Support’ as needed.
• Compiled Micro Focus COBOL as required in both Windows and UNIX environment. Installed multi-language PeopleBooks and Verity for FSCM and HRMS. Created Archive Objects and used Data Archive Manager to archive Vendor Masters, Customers and CM Accounting Line data.
• Assisted with Capacity planning, disaster recovery and load balancing activities in multi-instances environment. Created and modified Roles and Permissions as needed.
• Installed Oracle client tools and established connectivity to databases via ODBC.
Chung W. Chau
PeopleSoft Technical Analyst/Database Analyst 10/1998 - 9/2005
CrossCountry Healthcare, Inc. Malden, MA
• Created and maintained SQL Server 2000 DTS to transport PeopleSoft production data between an Informix database and an Oracle database. Performed routine DB backup/restore and monitor job streams.
• Created and maintained SQL Server Stored Procedures and Triggers to steam-line routine processes. Managed database privileges to users in various environments.
• Managed PeopleSoft installation and configuration activities, including three major PeopleSoft upgrades spanning from version 7.5 to 8.8. Communicated with the PeopleSoft Service Group to resolve HelpDesk tickets related to PeopleSoft systems.
• Developed and modified PeopleSoft Objects including PeopleCode, application engine, and user interface components. Used Application Designer to setup PeopleSoft tables. Teamed with functional analysts to develop PeopleSoft module reports using SQR, Crystal Reports, and PeopleSoft queries.
• Identified gaps between business requirements and delivered vendor applications. Proposed system redesign solutions and enhancement options to effectively close the gaps. Worked closely with Project Management Team and stakeholders to ensure successful system integration and fast issue resolution.
• Installed Oracle client and established ODBC connectivity for users.
Junior SQL Server DBA/PowerBuilder Developer 9/1996 - 10/1998
State Street Bank & Trust Company (Commercial Banking Systems) Boston, MA
• Installed and support SQL Server in development, test and production environments, established ODBC connectivity to databases and monitor system performance. Grant privileges to users to access systems and databases.
• Developed and maintained scripts for administrative tasks like backups, tuning and refreshing test databases from production periodically. Monitored server performance, database and transaction log growth and error logs.
• Running imports/export utilities, off-line backup, on-line backup various SQL server Applications utilities. Created and maintained DTS packages and used BCP utility to transfer data between SQL Server databases.
• Planned and implemented various Transact-SQL statements, cursors, stored procedures and triggers.
• Installed and maintained end user PCs with MS SQLClient 6.5 and ODBC drivers for database connectivity.
• Designed, developed, tested and deployed five major client/server applications for internal customers using PowerBuilder 4.0 and 5.0.02. Migrated PowerBuilder code for all applications from version 4 to 5, then from version 5 to 6. Conducted auditing and recoding for all PowerBuilder applications for the Y2k compliance.
QA Engineer (Contract) 5/1996 - 8/1996
State Street Bank & Trust Company Quincy, MA
EDUCATION & TRAINING
Clark University Computer Career Institute Cambridge, MA
Client/Server Development
University of Massachusetts Amherst, MA
Mechanical Engineering
Contact this candidate