systems engineer Resume profile

A senior-level systems engineer and data systems architect with more than 30 years experience in data processing including extensive experience in all phases of relational database and system design troubleshooting performance tuning in standalone data warehouse and client-server environments. Additional experience in distributed and database-enabled web development and administration.

Technology

Mainframe

DB2/zOS DB2/UDB QMF ISPF/TSO REXX MVS z/OS JES2 Omegamon DB2PM BMC Catalog/Change/DASD Manager and utilities DB2 utilities Data Propagator DataJoiner CICS IBM Assembler

Client-Server Web

DB2/UDB Active Server Pages ASP HTML VBScript Visual Basic VBA DB2 Connect Windows

Architecture Design

Documentation Tools

Microsoft Excel Word Powerpoint FrontPage Access Adobe Acrobat Photoshop Premiere FrameMaker

Industry Experience Banking Brokerage Insurance ReInsurance Software development

Employment History

confidential

Topics included SQL coding management of data sharing systems recovery management and performance tuning.

confidential

Analysis modeling and deployment and administration of financial data warehouse and major actuarial reporting systems on DB2/zOS.

Capacity planning analysis leading to documentation and recommendations for architectural changes to the existing DB2 data warehouse to accommodate newly acquired business to improve performance and to take advantage of release changes in DB2 V8 V9. The warehouse includes approximately 350 DB2 tables largest of which was 650 million rows.

Architect for the development and documentation of an actuarial forecasting systems accessing data in the newly redesigned data warehouse. Working with corporate actuaries to expand the features and capacity of their existing systems and developing financial projections using complex multi-dimensional mathematical formulas.

As the project DBA modeled using ERWin and implemented the redesigned databases to allow multiple concurrent processing streams including partitioning locking strategies SQL query analysis and tuning and taking advantage of the parallel sysplex and data sharing environments.

As the production DBA responsible for audit DB2 object maintenance and migration using BMC Catalog Manager and Change Manager.

Performance tuning of over 250 queries and procedures using DB2 explain and Omegamon/DB2. Extensive use of DB2 and BMC utilities including cursor-based load as a substitute for query-based insert/update processing to eliminate locking and logging. Documented tuning procedures guidelines presented seminars on tuning.

Analysis non-standard user data to coordinate and develop ETL procedures to input data. Cross-platform query development. Development of an Excel-VBA-ODBC based reporting application automating download of DB2 data and pivot table formatting of results.

We provide IT Staff Augmentation Services!

We'd love your feedback!

Resume Categories

Client Services

Job Seekers

Visa Sponsorship