Resume 4

Objective:

DB2 Database Administrator - Position that invite technical challenges in Database Design and Administration involving OS/390 and other platforms.

• 11 years of IT experience involving implementation of large application software solutions using Information Engineering for both commercial and government sector clients.
• 5 years Extensive DB2 Database design and administration experience on MVS OS/390 platform.
• Sound technical and functional knowledge of various business applications such as Welfare, Department of Motor Vehicle operations, Auto/Home/Life Insurance industry, Financial accounting, HR and Payroll accounting, Loan Systems and Telecommunications.
• Extensive experience in working directly with application developers and customers to define their needs and produce quality solutions on time.

• DB2 for MVS OS/390: Database Design and Administration
• Datawarehouse/Datamart/ETL Design and Implementation
• Technical Architecture Definition/Implementation N-tier, online, batch, development
• Software Configuration Management Change Control code/database, Application Environments
• Strong Systems Design/Development Abilities

Bachelor of Technology Computer Science & Engineering ,
Harcourt Butler Technological Institute, INDIA 1991

DB2 Universal Database Administration for OS/390 version 6 at IBM.
CICS Web Support/3270 Bridge for Web projects from IBM partners
Enterprise Application Integration and Middleware technologies

• Hardware: IBM ES/9000, IBM/3090, PC/LAN Environment

• Operating System: MVS OS/390, MVS/ESA, MVS/XA, UNIX, OS/2, MS-DOS, WINDOWS

• Databases: DB2, DATACOM/DB, XDB, ORACLE, FOX PRO, MS ACCESS

• Language: VS COBOL II, DATACOM/IDEAL, DATAQUERY, SQL, PL/SQL,REXX, CLIST, JCL, C

• Case Tool: TELON, ADW Key 4.0 , DESIGN/1, TURBO ANALYST

• Software: BMC TOOLS FOR DB2 CHANGE MANAGER, CATALOG MANAGER, DASD,MANAGER, RECOVERY MANAGER , ERWIN 4.0, PLATINUM TOOLS, QMF, SPUFI, VISUAL EXPLAIN, DB2 CONNECT, OMEGAMON FOR DB2/CICS/MVS, CICS TS 1.3, CWS, CSP, SDF II, TSO/ISPF, COBTEST, XPEDITER, ABEND-AID, VSAM, JCLCHECK, JES2, JES3, CA7, SDSF, FLASHER, AVERS, RACF, ABR, SYNCSORT, ADMVS, MF-WORKBENCH, ANIMATOR, INTERTEST, FILE-AID, PRO-EDIT, IMS/DC, PANAPT, PANVALET, ENDEVOR, PVCS, LOAD RUNNER stress test , WIN-RUNNER regression test , SSA, BPF 4.4.2, AFP, CICS Universal Client, VisualAge Interspace, LOTUS NOTES, MS OUTLOOK.

Client: District of Colombia Department of Motor Vehicles,
Alexandria, DC/Deloitte Consulting DMV,
Government Sector, 17 months
DB2 Database Administrator/Configuration Architect

Destiny Project :

• Logical Data modeling using ERWIN
• Physical data models using ERWIN forward-engineered into DDLs and executed on mainframe to create databases.
• Maintained create/alter/drop/grant/revoke/ re bind/free DB2 object using BMC catalog manager.
• Migration of database objects between databases and DB2 subsystems using BMC change manager.
• Performed routine database space and growth estimations using BMC DASD manager.
• Facilitated execution of load/unload/DSN1COPY of data for database conversion team. Support and enhancements to
• ETL Extract Transform Load process for Datamarts
• Measured package performance using OMEGAMON for DB2 and suggested SQL tuning and/or created index/execute DB2 utilities for better data organization and SQL performance.
• Implemented Backup and recovery procedures using BMC recovery manager.
• Configured ODBC connectivity to DB2 for MS Access/Visual Explain/Crystal reports users.
• Implemented DB2 security for online/batch application/users and software change control process.
• Designed & administered RACF user security groups & rule-sets for application security on the MF.
• Designed and implemented PEM password Expiration Management Interface for the application
• Designed, implemented and managed change control process for application and database components using CA-PANAPT models and BMC tools catalog and change manager for DB2.
• Created and managed production emergency fix process on the mainframe.
• Configuration definition and implementation of interfaces such as AAMVAnet, TCP/IP sockets, Mainframe connectivity via CICS Universal Client, FTP etc.
• Customization and testing of SSA Software Search America phonic search algorithms.
• Designed/implemented Automatic transaction scheduling for TSQ management, AAMVA extract files.
• Facilitated special printing through COBOL programs using Barcode Print Facility software
• Suggested IBM s AFP architecture for DMV outputs.
• Designed, implemented and managed JES output printing via VPS on network destinations.
• Designed and implemented application Batch Architecture using CA7.
• Generated virtual users stress load to stress test the application using Load runner software scripts.
• Conducted and documented thorough technical review of application design/code and data.
• Extensive & continued interaction with configuration support agency/software vendors/project staff.

Hardware and Software: IBM/3090 OS/390 , DB2, BMC tools Catalogue Manager, Change Manager, DASD Manager, Recovery Manager , QMF, DB2I, ERWIN, CICS, VS COBOL II, JCL, TSO/ISPF, CA-PANAPT, Panvalet, Omegamon for CICS, DB2 and MVS, Abend-Aid, File-Aid, AVERS, CA7, RACF, ABR, PC workstations on LAN, Load-runner, Win-runner, SSA, BPF4.4.2, AFP, CICS Universal Client, VisualAge Interspace, Outlook Express.

Client: Mass Life Insurance Co., West Hill, Connecticut, USA
INSURANCE, Private Sector, 20 months
Project lead/Data Modeler

This system maintains customer check service accounts and draft policies under it for premium due on a given withdrawal day each month.

• Project planning, Impact on Systems and Data, Establish high level work estimates
• Business Requirements Analysis for the Daily Drafting Enhancements
• Development of Data Flow Diagrams and Entity relation Diagrams using VISIO
• Design, enhance ETL process to add/update data into DataMarts
• File, Interface, Messages and logical Database Design using ERWIN software
• Program specifications, Screen and Report layouts from user specifications.
• Development of comprehensive test plan document
• Program development, testing & implementation using DB2, DATACOM IDEAL/DB, CICS, COBOL, JCL.
• Documentation and User Training.
• Maintenance support after implementations

Hardware and Software: IBM/3090 OS/390 , PC/LAN Workstations, DB2, SQL, CICS, VS COBOL II, JCL, DATACOM IDEAL, DATACOM DB, DATAQUERY, SQL, ENDEVOR, JCL, FLASHER, TSO/ISPF, QMF, SPUFI, VISIO, ERWIN, WINDOWS, LOTUS NOTES, MS OUTLOOK.

Client: New Jersey Higher Education Service Corporation, Springfield, New Jersey
Student Load, Government Sector, 11 months
Database Administrator/Data Modeler

Student Loan System :

• Data Modeling/DB admin. support to define/modify database objects & implement DB2 security.
• Executing DB2 reports/utilities for performance/database organization & database growth analysis.
• SQL review through EXPLAIN
• Designed and Implemented Software change control for database and other application components
• Rotational On-call production DBA support

Hardware and Software: IBM/3090 MVS/XA , DB2, ERWIN, Key 4.0 ADW , Platinum for DB2, SQL, QMF, SPUFI, DB2I, JCL, JES2, JES3, TSO/ISPF, OS/2.

Client: Farmers Insurance Group, San Diego, California
INSURANCE, Private Sector, 8 months
DB2 Database Administrator

Automobile Insurance - Auto Policy Processing System APPS :

APPS is an auto insurance system that provides various processing options insurance quotes and claims related assistance to the customer. The system consists of around 2500 programs with 35 different functional areas and around 600 DB2 tables.

• Designed Logical and physical database for business transaction functionality
• Created and migrated database objects between databases and subsystems
• Implemented DB2 security for application architecture.
• DB2 Historical reporting, Database tuning, Backup & recovery procedures, Execution of DB2 utilities. Support ETL functions for Datawarehouse/DataMarts
• Rotational On-Call DBA Support

Hardware and Software: IBM/3090 MVS/XA , Key 4.0 ADW , DB2, ERWIN, File aid for DB2,Platinum for DB2,SQL, QMF, SPUFI, CICS, VS COBOL II, JCL, JES2, JES3, TSO/ISPF, OS/2.

Client: FGR Communications Inc., Willington, Iowa
TELECOMMUNICATIONS, Private Sector, 4 months
DB2 Database Administrator

New Commercial Billing System NCBS :

DB2 Database Administration support to Discount Enrollment Database system 40 DB2 tables of NCBS system. NCBS provides MCI with the means to bill large and mid-size commercial customer for use of virtual network-related services such as Vision and V-net.

• Database design considerations at Code walk-though,
• EXPLAIN for database accesses,
• Performance Analysis and tuning SQLs,
• Create & maintain DB2 objects, Create, modify, execute IMAGE COPY, RUNSTAT, REORG production jobs, Execute Data migration Jobs in test regions.
• 24 hour rotational On-call DBA support.

Hardware and Software: IBM/3090 MVS/XA , DB2, SQL, QMF, DB2I, SPUFI, CICS, JCL Endevor, COBOL II, OS/2, PVCS Version Manager.

Client: Department of Workforce Development, Addison, Wisconsin, USA
WELFARE, Government Sector, 11 months
Systems Analyst/Module Lead

Wisconsin Client Assistance for Re-employment & Economic Support CARES System :

CARES is a large scale computerized welfare application automated for public assistance for the State of Wisconsin with Aid to families with dependent children AFDC , Food Stamps, Medicaid and JOBs programs.

• Maintenance of Application Entry/Self-Sufficiency First/Pay for Performance subsystems.
• Requirements Analysis, Design, Construction and Production Implementation of Eligibility budgets calculations module for welfare client.
• Requirements gathering of Wisconsin Works W2 pilot initiative for Department of workforce development, State of Wisconsin.
• Defining Data flow views and development of mini-spec for W2 pilot using ADW
• Development of Structure Charts and Module Action Diagrams using ADW
• Program Development and Unit testing using TELON, ADMVS, MF WORKBENCH/MF COBOL, ANIMATOR, and XDB in LAN environment.
• System Testing and Integration with other modules using DB2, VSAM, REXX, JCL, FILE-AID, PRO-EDIT.
• Monitored DB2 SQLs using STROBE
• Performed historical reporting on DB2 performance data

Hardware and Software: IBM 3090/IBM ES/9000, PC Workstations on LAN, MVS/ESA. IMS/DC, TELON, DB2, VSAM, FILE-AID, PRO-EDIT, REXX, SQL, QMF, SPUFI, PLATINUM TOOLS, STROBE, CICS, VS COBOL II, JCL, TSO/ISPF, ENDEVOR, OS/2, MF WORKBENCH, XDB, ADMVS, ADW, ANIMATOR.

Employer: Finance Division of United Nations, Florence, Italy
FINANCE, Government Sector, 34 months
Systems Analyst/Module Lead

Financial and Personnel Systems FINSYS/PERSYS :

FINSYS/PERSYS is a computerized system that provides personnel management and multi-currency financial, budgetary and payroll accounting support to FAOs staff, Vendors, Food programs and Projects all over the world. The application supports subsystems like General Ledger, Payment Authorization, Budgets, Treasury, Personal Accounts, Personnel Management, Payroll Accounting and Reports/Inquiries.

• Personal account subsystem review to assure database quality and apply database corrections.
• Construction and testing of Personal account database assurance program using DATACOM IDEAL language, JCL to assure system functionality and quality of personal account data.
• List discrepancies from Database Assurance report to review and further analyze data quality and system functionality. Log discrepancies into problem tracking & reporting system.
• Suggest, design, construct and apply amendments to online/batch system functionality, database and Interface to
• General ledger, Treasury and payroll accounting subsystems using DATACOM IDEAL, VS COBOL II, CICS, DATACOM DB, DB2 and JCL tools.
• Maintenance support to Personal Account PA system.
• Functional review and feasibility study to replace the system with a new packaged technology

Hardware and Software: IBM 3090/IBM ES/9000, IBM PC/LAN Workstations, MVS/ESA. DATACOM/IDEAL, DATACOM/DB, DATAQUERY, DB2, CICS, SDF-II, COBOL, JCL, VSAM, TSO/ISPF, MS WINDOWS FOR WORKGROUPS.

Employer: Larsen & Tutti Limited, Bombay, India
FINANCE, Private Sector, 21 months
Programmer/Analyst & Lead Analyst

Financial Applications of L&T :

A comprehensive accounting system that handles posting of accounting transactions to the general ledger in batch and printing books and ledgers on a daily, weekly and monthly, quarterly basis, passing information to the supplier, payroll accounting and management performance and control subsystems MPCS for downstream processing.

• Requirements gathering and analysis for General ledger posting, interface and module processing for suppliers, Management performance and control, and travel expense subsystem
• Development of database design ER diagrams , Dataflow Diagrams DFD , program specifications, screen and reports layout and system prototyping using CSP
• Development of Unit and System Integration Test Plans
• Program construction, Testing and Implementation using CICS, DB2, VSAM, SDF II, and COBOL.
• Development of Interactive Job submission facility using REXX procedures and JCL
• System Documentation and User Training

Hardware and Software: IBM ES/9000, IBM PC/AT Compatible Machines, MVS/ESA. CICS, DB2, SDF-II, VS COBOL II, JCL, COBTEST, VSAM, REXX, CLIST, TSO/ISPF, FILE-AID, INTERTEST, DESIGN/1, TURBO ANALYST, ORACLE, PL/SQL, FOX PRO.