SUMMARY

• 30 years of Data processing experience, 20 years DBA experience specialized on performance tuning, convert from Oracle to UDB.
• Extensive knowledge of Confidential functionality and underlying table setup. 8 years of Confidential Financial.

TECHNICAL SKILLS

LANGUAGES: SQL, SQR, PeopleCode, COBOL2, CLIST, JCL, 'C', UNIX shell, PL/1, EXEC

OPERATING SYSTEM : Z/OS, OS/390, MVS/ESA/TSO/SPF, VM/CMS, AIX, Linux, HPUX,Windows 10

PROFESSIONAL EXPERIENCE

Confidential

DB2 DBA, Z/OS

Install and upgrade Confidential General Ledger, Account payable Financial modules, including provide on - going production support 24/7 to the user community. Utilize confidential suite of monitors. Capacity planing. Run Explain on long running SQL the determine cause. a manage a wide range of file and data management capabilities using Fileaid for DB2 on MVS/TSO/MF hardware. the Utilities the IBM suite of database tools and utilities, SPUFI, QMF, DB2 PM batch and on-line, and the EZ DB2 suite of tools . Analyze Confidential customization and platform differences. Develop an infrastructure plan. Development Confidential Application customization utilizing Application Designer, PeopleCode, Application Engine. Migrate Confidential from Oracle/UNIX to DB2/ZOS. Analyze the fixes for present and future environments. Determine list of fix are required for both O/S and database. Use existing test scenarios for functional tests. Determine how to do exception cleanup on the source Confidential database (using DDDAUDIT and SYSAUDIT to ensure the database is in sync with the PeopleTools tables). Develop plans for print migration, batch migration, backup and recovery on DB2, testing, migration of data, change management, Database monitoring, performance tuning(omegamon and explain), planning and executing the test migration plan.

Upgrade version and apply patch, using both the delivered application engine process and customized database utilities to transform database. Modify SQR and SQL batch jobs. Development and implement custom functionality. Document known errors or workarounds in WIKI server.

Confidential

Confidential Developer

Applying fixes/patches, providing fit gap analysis and retro fitting required code/configuration. defining, configuring and implementing CRM 8.9 workflow and business policies. Defines business requirements for enhancements. Evaluates vendor installation instructions for software packages. Understands the business rules related to the application data. Develops and evaluates the current business process flows. Understands the existing application environment and infrastructure. Determines the impact to existing application programs, interfaces, the technical infrastructure and the business area when considering various solutions. Develops business knowledge of assigned applications. Recommends operational efficiency including automated and manual solutions.

Confidential

Project Leader

Report directly to Confidential CIO and MIS, Vice President. Main responsibilities are to study and evaluate all process and procedures in database department, in particular UDB. Manage development team to develop a portion of Confidential quoting system. Design, maintain and review development plan and resource allocation plan. Review parallel development strategies with multiple projects, multiple development teams. Confidential has the largest number of concurrent versions of the UDB database. I design a process to improve database migration efficiency. Automate and track database change request. Enhance accuracy of structure rollback due to development issues.

Confidential

DBA

Migrate CA:CoolGen encyclopedia from C4 to C6. Upgrade Oracle from 7i to 8i on AIX.

Report directly to MIS Director on project status and issues. Work with project management to establish deadlines for completion of certain phases of the project and communicate plans. Manage a migration team of 5 members. Coordinate migration task with various departments to set up environment, i.e. System Administrator, Users, and management. Design and implement test plan to test the entry SFS including users acceptance to resolve all unknown complication. The system consists of 200 screens, 200+ tables, and 200+ programs. Employ WinRunner scripts to automate system testing. Write program to extract completed set of data from production database with all constrain and relationship. Modify code to be comparable with new version. Run parallel test on both new and old machines.

Confidential

Confidential - DB2 DBA

In charge of all aspect of Confidential on DB2/UDB. Review SQL with development team to ensure optimum performance. Turn database. Automate backup and reorg. This process will analyze tablespaces and index space to automatically increase and decrease as needed. Write SQL report to monitor database status. Install and implement Confidential A/P, A/R and Asset Management components. Alter tree design and structure to reduce tree build process from 70 hours to 2 hours. Alter and modify database structure with Application Designer. Install and configure application server to enable 3-tier architecture.

Resolve DB2 performance issues on Query, SQR, and Application Engine. Debug Process Scheduler to return process status back to Process Monitor.