DBA Resume

SUMMARY:

Analyst, Programmer and Problem Solver, providing solutions to increasingly complex business problems for over 20 years. Team Leader by example and consensus.
Heavy development, analysis, design, and leadership experience in several industries (Commercial, Insurance, Government, Telecommunications and Automotive) integrating iSeries wif multiple platforms.
Solid on - line and batch expertise in Logistics/Supply Chain, Billing, Claims and Finance.
Excellent verbal and written communication skills.
Enthusiastic Mentor and colleague trainer.

TECHNICAL SKILLS:

Hardware: System i5/ISeries/AS400, Windows PCs

Databases: DB2, UDB (DB2/400),Oracle

Languages: SQL/DB2, ILE COBOL/COBOLII, FTP, CL/400, SEQUEL, DB2 for LUW 9.1

Application Tools: Optim, DB2 Fed Svr V9.7, Rational, IFS, PDM/SEU/SDA/RLU, MS2010, ROBOT, journals/debugger, Client Access, Visio, Surveyor, Aldon CMS,RFS,DBU, iSeries Navigator, ZMOD, MKS Implementer, BMC Remedy,Control-M

Prior experience wif: IBM 30XX/43XX, ES9000,VM/CMS, MVS/TSO/ISPF, Oracle, VSAM, IMS, REXX,JCL,SEQUEL, Xedit, Ditto, Xpediter, Librarian, MQ Series, FlowCharter, Questview, Extra, Hawkeye, Turnover, Implementer, UC4, QMF

PROFESSIONAL EXPERIENCE:

Confidential

DBA

Responsibilities:

Converted legacy DDS files to DB2/created new tables,indexes for Java/Oracle compatibility.
Taught V7R1 DB2 skills; maintained multiple databases using Aldon, SQL, CL, FTP.
Modified custom V6R1 COBOL/DB2/400 programs for cross-platform JDE Oracle data access.

Confidential

Agile Development

Responsibilities:

HealthReimbursementAccount/FSA/HealthSavingsAccount/ACA: Created new Claims applications/database tables to support new insurance products using COBOL, SQL/DB2, DRDA.
Production Support: resolved problems using V6R1, SQL, Connect:Direct; trained users.
Vendor transfer: Translated business requirements into Agile environment iSeries program tasks.
Trained other senior developers on iSeries tools/intricacies, standards, conventions.

Confidential

Performance Tuning

Responsibilities:

Mined DB2 Financial databases extensively for internal and external customers..
Upgraded System i V7R1 ILE COBOL database programs using DB2/400 embedded SQL.
Created DB2 Stored Procedures, SQL Indexes using Rational, iNavigator, Visual Explain.

Confidential

Analysis/Development

Responsibilities:

Re-engineered Health Insurance eligibility using COBOL,DB2/400/SQL/CL/FTP on iSeries V5R4.
Re-built consolidated provider remittance process on short notice using direct DB2/400 SQL.
Analyzed requirements and designed multi-state health care compliance reporting.
Integrated New Client claims/eligibility history into current DB2/400 database using Aldon CMS.
Installed IBM Optim and Federated DB2/LUW software on Microsoft SQL server, designing and pioneering PHI/privacy data scrubbing across multiple iSeries DB2/400 platforms.
Trained and mentored onshore/offshore colleagues in DB2/400 SQL, COBOL, Aldon, BMC Remedy ECM; created DB2/400 Stored Procedure templates, Visio process flow diagrams..

Confidential

Supply Chain/Logistics Systems Analysis

Responsibilities:

Overhauled broken freight cost reporting from bank through operational database to General Ledger using COBOL/embedded SQL programs, FTP and CL jobs.
Launched new internal-user RFID tag sales menu option, designing and creating new DDS GUI, COBOL drivers and DB2/400 database on iSeries V5R4.
Sarbanes-Oxley compliance: created complex DB2 queries to monitor source code management.
Originated custom DB2 extracts daily to data warehouses on other platforms, using SQL and FTP.
Led team of 5 analysts (on- and off-shore) converting ROBOT job scheduling to UC4.
Extricated embedded de-licensed product from over 100 CL jobs, saving $30K annually.

We provide IT Staff Augmentation Services!

We'd love your feedback!

Resume Categories

Client Services

Job Seekers

Visa Sponsorship