We provide IT Staff Augmentation Services!

Senior Database Analyst Resume

IA

SUMMARYOver twenty five years as a data processing professional with responsibility for all phases of projects from conception through implementation. Experienced in both technical support as well as application projects.

TECHNICAL SKILLS

Languages:COBOL, CICS, DB2, Oracle, SQL,TSO/ISPF, VSAM, QMF, BMC CATALOG MANAGER, Platinum, DBArtisan, Toad, Erwin, CA7, CA - INSIGHT, MVS/OS JCL, SYNCSORT, DFSORT, SAS, MVS UTILITIES, FILE AID, XPEDITOR, REXX, RPGWORK EXPERIENCEConfidential, IA

Senior Database Analyst

  • Migrate Oracle databases from Solaris to Linux and upgrading database version to 11g.
  • Conversion of DB2 inventory database to Oracle database for use with Metasolv application. Installed Oracle Gateway to enable Oracle databases to communicate with DB2.
  • Create and install DB2 instances to support Siebel software.
  • Design, create, and manage DB2 database in OS/390 and UDB environments.
  • Create and install Oracle databases.
  • Schedule backups and table reorgs as necessary. Perform table recoveries on demand.
  • Application performance tuning
  • Provide assistance to development staff in all areas of database, especially SQL and utilities.
  • Create multiple DB2 instances to support test and production databases.

Confidential, IA

Software Engineer

  • Improved SQL efficiency of CICS transactions by breaking down large queries into multiple queries. For batch processing made use of working storage tables to reduce the number of SQL calls.
  • Create software to audit physical equipment with facility and equipment system.
  • Create reconciliation system for revenue stream. Design, code, and implement new system.
  • Review and redesign discounting process in billing cycle. Run time went from 4 hours to 15 minutes.
  • Provide recommendations to improve software quality and standards. Help with conversion from native RPG to SQL access. With this implement commitment control.

Confidential, IA

Senior Systems Analyst

  • Analysis, design, test, and implement order entry components to support billing of data networks.
  • Provide technical support and solutions to business partners as well as data processing colleagues.

Confidential, IA

DBA

  • Assisted development groups in design of new structures as well as modifying existing tables.
  • Setup and instructed training courses with application people on DB2 and upgrade to version 4.

Confidential , IA

Systems Analyst

  • Analysis, design, test, implement new pricing structure for operator service calls, voice mail, and other VRU functions.
  • Created new interfaces with existing MCI billing systems to bill customers on their invoices.

Confidential , IA

Application Team Manager

Confidential , IA

Programmer Analyst

Hire Now