SUMMARY

• A technical professional in teh areas of DB2/IMS DBA Hogan Banking Technical Architect to support IBM mainframe and PeopleSoft/SAP Application, database and system upgrading experienced, including analysis, design, implementation, maintenance and production performance monitoring and tuning including OLAP, OLTP platform.
• Confidential has been creating automatic Hogan procedures WORKBENCH wif REXX, for online banking production DBA support including MQ series, WebSphere messaging application system performance increasing and DBA production support automations.
• Very strong background of IBM Mainframe working at IBM Global Systems Division OS390, z/OS Systems and Data Warehouse systems DBA/Systems programmer support including Lead DBAs in mentoring every DBA performing task.
• Also, included mainframe upgrading z/OS 1.12 DB2 version 8, 9 and 10, IMS 10,11 (PeopleSoft Application, PeopleTools 8.49 and 8.9, 9.0, 9.1) including analysis, design, implementation, maintenance and production performance monitoring and tuning experience are in his depth skill set.
• Extensive experience wif z/OS, OS/390, MVS, AIX, UNIX, DB2 UDB/EEE, IMS/DB, IDMS, VSAM, CICS and COBOL, JCL, PL/me and Assembler, C and REXX Exec, Oracle, Ingres, Infomix, Sybase, SQL - Server, Excel, Access, Visual Basic / VBA, JAVA Eclipse-based and PeopleSoft Payroll HRMS.
• Every Disaster Recovery Plan implemented for United Airlines, Confidential Airlines, FEDEX and large Bank organization Database Management Systems.
• Confidential TEMPhas been participated DB2vendor ( Confidential Corp. and Serena Software including) product development team supported worldwide mainframe customers such as, File-Aid DB2/RDX and DB2 Change Man ZMF.

TECHNICAL SKILLS

Hardware: IBM mainframe Z9 Z800 Amdahl AS400 Tandam Teradata (DBC) Univac Facom Pyramid

Software: VM z/OS OS/390 MVS/ESA/XA DOS/VSE VTAM RACF ACF2 UNIX AIX UDB DB2 IMS, B/DC IDMS VSAM CICS JCL ORACLE INGRES SYBASE SQL-Server 2000 SAS ASSEMBLER, "C" REXX COBOL PL/me APL language Dialog Manager TMON DB2 OMEGAMON

Confidential File: AID products (DB2, MVS, IMS) CA-Platinum (Detector, INSIGHT) DBA

Supporting products: (RC- Migrator) and Erwin tool BMC DBMS support products (Change Manager and Main View monitor) DB2Connect and PeopleSoft Payroll/CRM, and Financial

Suites: GL, AP, Budgets, AM AR, Siebel IEF - CoolGen

IBM Tools: DB2 Admin, Query Monitor, Table Editor, Object Compare, SQL Performance Analyzer, Log Analysis, Omegamon XE, and OPTIM Archiving/Migrating data

PROFESSIONAL EXPERIENCE

Confidential

General Manager & Sr. Solutions Architect

Responsibilities:

• Responsible for teh providing Database Architect design and development of DB2/IMS database support systems, and create technical design specifications including functional specs.
• Coordinate physical sub-system changes of teh DB2 database objects including; coding, testing, database and production migration and performance tuning.
• Installation and configuration of PeopleSoft HR Tool upgrade to Version 8.49 tool and version 8.9 for application.
• Responsible for teh DBA resource, peer review and comparison of PeopleSoft specific application business process models, and teh establishment of business requirements.
• Participated FedEx Enterprise DB2 Software Licensing review committee - Installing and testing all teh vendors (IBM, CA, BMC) DB2 UDB products and reported evaluated each tool cost and functional benefits summary to teh board and senior management.
• DB2/IMS new Version Upgrading Specialist - DB2 QMF V10, V11 V12, IMS V13 new features consultant
• Support resources on transition on new projects (US Canada Australia client support) along wif KT plan
• Plan teh structure of teh training to be provided to up-skilling IBM DB2 Systems resources
• Initiate DB2 Sysprog training program for resources as per personalized training roadmap
• Resource skill assessment and certification - based on teh skill stratification document reviewed
• Identify technical scope of work on new accounts to be delivered by up-skilling DB2 Sysprog tasks
• Periodic review and evaluation to check progress of every resources
• Periodic review to track transition of workload to GDC

Confidential

Sr. DB2/Hogan Technical Architect

Responsibilities:

• Responsible for teh providing DBA/DB2 UDB Architect infrastructure including Data Warehousing Systems, review project TFS and Strategy and Architecture analysis of project requirements.
• Main responsible for Hogan Deposits (DDA and TDA), Hogan RPM, Hogan CIS, Designed and developed DB2 database support systems and created technical design specifications including functional specs.
• Coordinated physical changes to DB2 database objects are including; coding, testing, database and production migration and performance tuning, Participated in teh full life cycle implementation of Peoplesoft CRM Discovery Plan including designing, building, configuration, testing, and implementing as a functional DBA consultant. Participated in Confidential ’s SOA (Service Oriented Architecture) Business Processes Reference which required several sessions of workshops provided by IBM, to accommodate market demand changes, workload changes, and service level upgrades.
• Implemented new applications, RTP Scalability System demands, such as, real-time processing of customer on-line transactions, ETL branch business process, was teh new architecture for business process management based on SOA.
• Participated WaMu Enterprise DB2 UDB Software Licensing review - Installing and testing all teh vendors (IBM, CA, BMC) DB2 products and reported evaluated each tool cost and functional benefits summary to senior management.

Confidential

Sr. DB2 Administrator

Responsibilities:

• Designing and implementation of a corporate IBM DB2 UDB database and provided operational support.
• Participated in developing teh quality assurance procedure and implemented efficient backup/recovery procedures including Disaster Recovery Plan.
• Designed and development database support teh PeopleSoft Production DB2 UDB Database size 1TB for Human Resources and Payroll Systems.
• Project leader participated in teh United Airlines Enterprise Data Warehouse (EDW DBMS Requirements) and reviewed RFPs from NCR Teradata and IBM Proposal for teh United Airline’s Enterprise Data Warehouse Project.
• Participated Committee and Implemented teh US Airways Database system merger and integration plan.

Confidential

DB2/IMS Software Developer

Responsibilities:

• Designed software enhancements, diagnosed and fixed software bugs, enhanced software and wrote new programs, and completed teh testing and technical documentation.
• Responsible for teh review and analysis of customer requirements, software prototypes, including designing and developing software systems and creating technical specifications.
• Formulated and designed software system using MVS VSAM, DB2/IMS DBMS and IEF - CoolGen.
• Analyzed software requirements to determine feasibility and evaluated software interface, operational, and performance requirements.
• Duties also included unit, integration, and system production regression testing.
• Evaluated user requests and consulted wif users concerning system maintenance.
• DB2/IMS/CICS Database Administrator/Systems Programmer (IMS/DB2 Systems Group).

Confidential

DB2/IMS DBA & CICS Systems Programmer

Responsibilities:

• Installed DB2/IMS software and maintained SMP/E.
• Designed and implemented a corporate application database and provided operational support to ongoing corporate application databases.
• Created data model methodology implementation handbook and AUTOMATIC workbench for ERA’s (Entity Relationship Diagram) defining or Conceptual Data Modeling and teh DMD (Data Model Diagram) or Functional Data Model.

Confidential

DB2/IMS DBA Manager & CICS Systems Programmer

Responsibilities:

• As a Project Manager, IMS/DLi and DB2 Database Administrator, designed and built up a database of financial information for entire banking institutions in Korea.
• Teh databases are fully utilized by teh Monetary Policy Board of Committee and providing principal guidance of decisions making for teh Central Bank’s policy operations.
• He participated to Central Banking Information Systems M.me.S review team, started June 24, 1985 ended Nov 23, 1985, and built up all teh pertinent information systems resting on teh basis of over-all options in teh bank.
• In a viewpoint of teh Governor and Senior Executives of teh central bank, and whole other nationwide commercial banking every institutions reporting system to teh central bank, M.me.S team created an analysis on teh jobs and behaviors on exited system delivery architectures and reviewing wif IBM BSP
• Methodology developed. (nowadays became S.O.A, Service Oriented Architecture)
• Through a camp research jobs and several rounds of meeting, identified dat 75 kinds of Business Process and 250 data classes are necessary in attaining teh purpose of teh Bank’s Information Systems.
• These BSP output became teh first methodology of data modeling architecture exploited by me.B.M and influenced to further data modeling system emerged IBM Data Dictionary system thereafter.