Nahid Gorji
Email: **********@*****.***
Systems Analyst /DBA with more than 20 years of progressive experience in Application and Database Design, Development, and maintenance
SUMMARY OF SKILLS
Databases & File systems : DB2 UDB,VSAM, DB2 utilities & Commands, IMS/DB
Operating systems : MVS, WINDOWs, Z/OS
Operating environments : MVS / TSO,ISPF, MVS/JCL and Procedures, RACF
Programming Languages : PL/I, COBOL,Assembler, Embedded SQL, DB2 stored procedures &
triggers, CICS command-level programming, MQ Series
OLTP : CICS, IMS
Database Connectivity Tools : DRDA, ODBC,JDBC
Productivity Tools : MS WORDS, Endevor, FileAid, CICS Debugging tools
Networks & Protocols : TCP/IP, SNA
Monitoring systems : Tivoli Omegamon for DB2, CICS TS, CICS TG, ZOS
PROFESSIONAL EXPERIENCE
ISC Co. (banking sector) 2008 – Feb. 2017
Application Support/Developer
Participated in analysis, Coding, Implementation of the new requirements.
Participated in analysis and development of enhancement requests.
Finalized Documentation of applications and led a team for creating user’s guides
Improved clients Legacy systems performance developed with COBOL/CICS/DB2/IMS
Helped Database group with the design, implementation and testing the required tables.
Defined CICS resources using RDO
Debugged Application with CICS EDF
Developed DB2 stored procedures
Improved SQL statement performance for applications accessing DB2
Created DB2 triggers
Ran several courses on DB2, CICS and COBOL
Installed Omegamon for DB2 and CICS to Monitor DB2 & CICS
Installed IBM DataStdio to create & deploy DB2 Stored Procedures
Used IBM datastudio explain to improve the performance of SQL statelements
Embedded in applications
Mellat Bank IT Corporation 2004 - 2007
Application DBA
- Developed a COBOL /embedded SQL system for Replicating Operational
Database to another instance of DB2 used for back office reports.
- Developed DB2 Stored Procedures for Java clients accessing DB2 databases
- Participated in design and implementation of a database for a banking payment Switch
- Developed An archiving system utilizing COBOL/DB2
Telus Enterprise Solutions (Canada, Vancouver) Jan 2000 - Aug 2002
Senior DB2 DBA
- Maintained DB2 databases under VM and MVS for TES’ clients
- Developed new MVS PROCs for DB2 utility jobs and minimized operator interventions
- Helped TES’ clients with database designs and physical storage estimations
- Attended major releases for Telus-BC applications and managed database changes
- Attended DBA forums and meetings with TES’ Clients
- Improved the performance of SQL statement
- Participated in annual DRP test
Data Processing Iran Company Oct 1985 – Aug 1999
(Ex. IBM Branch )
DB2 DBA 1994-1999
Systems Support Department
- Attended Courses for DB2 Administrations
- Participated in design and development of new Databases for DPI & DPI customers
- Performed regular DBA jobs for DB2 Databases (Backup, restore, Reorg
Information Systems Department :
Senior Designer & Programmer : 1991-1994
Designer and Programmer : 1990-1991
First Assistant Designer and Programmer 1985-1990
- Performed Function / Data analysis and developed SRSs for programmers
- Led 5 developers for 3 year to implement the "Integrated Customer Services"
system for PC section of DPI Company, in COBOL/DB2/CICS,
composed of several sub-systems (Maintenance,Contracts, Sales, Billings…)
- Attended DB2 application programming courses
- Participated in Design and Implementation of the listed Batch systems To Online
System deploying COBOL/CICS/ VSAM :
- OEI ( Online Equipment Information ) system
- Spare parts Inventory
- Customer Information System
- Supply System
- Finalized Documentation of applications and led a team for creating user’s guides
- Managed a group of users to test applications before final delivery
Software Trainee : (6 month): 1985
- As the preparation stage, attended several courses held by DPI education center
Educations :
- Bachelor in Computer Sciences and Engineering, Engineering Faculty
International Shiraz (ex. Pahlavi) University, Shiraz-Iran.
- Master studies : Operational Research, Isfahan Institute of Technology (incomplete)
- Further Trainings : Several professional courses in DPI and IBM Education centers
Such as :
- CICS, IMS,VSAM
- DB2 for Z/OS
- MVS JCL & PROCs
- TSO/ISPF
- COBOL, Assembler, PL/1