SUMMARY

• Dynamic creative and result driven professional. With full systems development life - cycle (SDLC), maintenance and support experience
• Highly motivated, versatile z/OS DB2 developer and database administrator with extensive experience in database administration; such as data provision, develop physical and logical database model, objects physical structure creation, modification, data refresh, data move, backup, recovery and performance tuning and etc...
• Also, with rich clients and project management experiences. Translating client’s business needs into IT requirements, deliver quality services to clients across the globe
• Excellent service mindset, problem-solving, team building, cross-functional leadership and presentation skills. Fast to establish and maintain good relationship with internal and external customers. Good communication and interpersonal skills. Fast learner and work well under pressure. With over 25 years z/OS DB2 DBA experience; including Retail, Telecommunication, Hospitality, IT Service, Airline, Manufactures and Banking industries.

PROFESSIONAL EXPERIENCE

Confidential, Cincinnati, OH

Principal DB2 Database Administrator

Responsibilities:

• Coordinate and prioritize works from different line of business (LOB) and application teams. Ensure all application runs smoothly without any performance impact in the overall bank environment. include data integration between major applications; such as Enterprise Customer Information Facility (ECIF/MDM), Value Proposition System (VPS), Awesome Customer Experience (ACE), Book of Business (BOB), One View and etc
• Improving overall customer experience with the bank. Also, provide 7x24 customer support, environmental setup, problem determination/solving, performance tuning, database changes, maintenance

Environment: z/OS DB2 data sharing sysplex

Confidential

Senior Consultant z/OS DB2 DBA

Responsibilities:

• Work with the Enterprise Data Management group in Confidential . To familiar with their business and provide consultation & support include 7x24 customer support, environmental setup, problem determination/solving, performance tuning, database changes, maintenance, migration and recovery; on DB2 data sharing sysplex environment.
• Senior Consultant z/OS DB2 DBA Work on site at Bank of Communications in Shanghai. Major responsibilities include DB2 performance tuning, best practice suggestion and mentor junior DBAs
• Primary works are done on Core Banking, Credit Card and ECIF

Environment: DB2 data sharing sysplex

Confidential

Manager and Service Line Owner

Responsibilities:

• 50+ members for mainframe and DBDC systems. Manage data management (DM) service line in China with over 110 members.
• Work with counterparts across global and local teams to establish standard process procedures and tools for DM service line
• Regular tasks include managing Key Performance Indicators (KPIs), supply group Center of Excellence (CoE), project negotiation, transition, hiring, training and motivation of team members to achieve department and company goals. Also, manage through complex business & client challenges and collaborate in developing and implementing solutions.
• Manager Transition Manager for the US Lab project to support Confidential global training environments. Work closely with US and China management and SMEs to build a team from the ground up. Facilitate project meetings, recruiting, training, problem resolution and customer support. Build and lead a 20+ member team with new technology; completed knowledge transfer and take over daily tasks within 6 months.

Confidential

Lead Database Analyst

Responsibilities:

• Include 7x24 customer support, environmental setup, problem solving, performance tuning, database changes, maintenance, migration and recovery. Provide DB2, IMS and UDB database

  Expertise in support of various applications to include Marriott Rewards, Yield Management, Marriott.com, Payroll, LDAP, OnDemand and other systems. Introduced the online reorg to Marriott. Implemented BMC Recovery Manager for database backup and restore process. Setup threshold and alert to monitor space usage

  Migrated DB2 LOB tables and application from z/OS to Linux. Most systems run on

Environment: COBOL, z/OS, Os/390, AIX; some HP UNIX and Linux

Confidential

Infrastructure Specialist/ COBOL Programmer

Responsibilities:

• Included 7x24 supports to include environmental setup, database changes, database recovery, tuning, migration and maintenance. Provided DB2 & IMS database expertise in support of various applications to include National Commercial Billing System (NCBS), Mass Market Billing (MMB), New Tax Facility (NTF), Rates and Incentive and Promotion Discount System (Rapids)

Environment: COBOL, os/390, z/OS and AIX; some UNIX and Windows.

Confidential

Software Systems Engineer IV /Corporate DBA

Responsibilities:

• Provided DB2 and IMS database expertise in support of the National Commercial Billing System (NCBS). Responsibilities to include 7x24 support of environmental setup, database changes, database recovery, tuning, migration and maintenance.
• The Automated Corporate Relocation System, the KODAK Automated Data Retrieval System, Human Resource, Treasury Service and the Payroll System
• Coordinate internal and external communications with customers, users, and other MCI interfaces to assure the smooth flow of projects from user definition through implementation and maintenance
• Included analysis, design, programming and maintenance duties on a variety of assignments. Applications included Accounts Payable, KODAK Automated Data Retrieval System and Automated Corporate Relocation System.
• Above systems were COBOL II with Command Level CICS, VSAM and DB2 on Confidential mainframe running MVS. User Analysis/Statistics reports was written using SPUFI and QMF

Environment: MVS and os/390; some UDB using Windows

Confidential

Senior Systems Analyst

Responsibilities:

• Included analysis, design, programming and maintenance duties on a variety of client assignments. Applications included Warehouse Inventory Control/Management System and Daily Sales Record Process

Environment: COBOL CICS, IMS DB and DB2 on an Confidential 3090 running MVS. Reports written using QMF

Confidential

Project Lead

Responsibilities:

• Included design through implementation. Managed a staff of 20 programmers during a large - scale re-engineering effort.
• Analysis, design, and programming duties on a variety of assignments.

Environment: OS/MVS written in Cobol CICS and on an Confidential 3081 written in COBOL and IDEAL using DATACOM DB

Confidential

Program Manager

Responsibilities:

• Develop a Supply and Maintenance System for the confidential. The system was developed using ALC, COBOL, CICS and VSAM on an Confidential 4381 OS/MVS. Managed 35 members team, also responsible for end user training.
• Included analysis, design, programming and maintenance duties on a variety of ON - LINE CICS and Batch COBOL System.

Environment: ALC, COBOL, CICS and VSAM and OS/MVS.