We provide IT Staff Augmentation Services!

Senior Systems Analyst Resume

Jersey City, NJ

Summary:

  • High level IBM-certified IT professional with over 20 years of extensive experience in the SDLC (System Development Life Cycle) in the commercial data processing.
  • Designed, created and supported variety of banking, financial and insurance applications for the major institutions.
  • Strong project leadership, analytical and technical skills.
  • Great problem resolutions experience.
  • Fast learner, excellent team player.

Skills profile:

  • Hardware: IBM 360/370/3090/390, z/OS, Solaris, IBM-PC.
  • Operating systems: OS/MVS/JCL, UNIX, Windows 2000/NT/XP/Vista.
  • Languages: COBOL II / MVS COBOL, CICS (Command level), IDEAL, SQL, Perl, JavaScript, HTML, Java J2EE, FORTRAN, ALGOL.
  • Software: WebSphere MQ, TSO/ISPF, QMF, SPUFI, QMF, IDCAMS, SYNCSORT, COMPAREX, XPEDITER, INTERTEST, CEDF, OMEGAMON, TEANECK, FILE AID, LIBRARIAN, ENDEVOR, PANVALET, CHANGEMAN, INFOMAN, DYLACOR, Easytrieve, DB2 UTILITES (REORG, RUNSTATS, CHECK, LOAD, DSNTIAUL, PLATINUM), IBM Utilities (IEBGENER, IEBCOPY, IEFBR14 etc.), FTP, SQL Advantage, Aqua Data Studio, HTML, Word, Excel, PowerPoint, Visio, Adobe PhotoShop, Lotus Notes, Access, Microsoft Project, Eclipse, Apache Tomcat, TOAD Data Analyst, Toad SQL Optimizer, ERwin.
  • Databases: DB2, VSAM, DataCom, Sybase, Microsoft SQL Server.

Education:

  • PhD in Engineering.
  • MS in Engineering/Computer Sciences.
  • DB2 Universal Database V8.1 IBM Professional Certification.
  • Professional courses: WebSphere MQ, XPEDITER, DYLACOR-280, OMEGAMON, DB2, COBOL, FORTRAN, ALGOL.

Professional experience:

09/2008 - 05/2011 Confidential, Jersey City, NJ. Senior System Analyst.
Primary responsibilities.

  • Reviewed, prepared and approved technical system design documentation and technical specifications.
  • Ensured that changes to the application follow SLDC and company standards
  • Designed, developed, coded and implemented number of the new applications utilizing Perl, Java J2EE with servlets and JSP techniques, COBOL, JCL, CICS, IDEAL, and Sybase, Microsoft SQL Server, VSAM, DB2, DataCom data bases.
  • Created and implemented number of stored procedures in SQL Stored Procedure Language for DB2, Sybase and Microsoft SQL Server data manipulation.
  • Conducted maintenance and post implementation 24/7-production support with user interaction and immediate production problem resolution using home access in z/OS and UNIX environment.
  • Leading position in the conversion from the legacy database DataCom to DB2. Designed functional ETL (Extract, Transfer, Load) processing with common supporting components.
  • Participated in DB2 DWH (data warehouse) design.
  • Designed loading processes for DWH and ODS (operational data store).
  • Produced ad-hoc reports upon users' requests using COBOL, DYLACOR, QMF and IDEAL/DataCom.
  • Developed test cases for Unit, SYSI (System Integration), QA (Quality Assurance) and UA (User Acceptance) tests.
  • Prepared batch jobs and CICS programs and data for QA environment.
  • Performed coordinated with business user analyses of the test results.

Major Project.

  • Leading position in the design, coding, testing and implementation of system that produces trade activity reports over a specified date range in order to accommodate the requests of security- monitoring agencies (Blue sheets reporting). The system retrieves information from various databases according to the range of trade dates for specified accounts. The system consists of a Java-based front screens and a number of COBOL programs interfacing with VSAM, DataCom and DB2 databases.
  • Leading position in the design, coding, testing and implementation of a number of end-of-the-year accounting

Reports. The system is implemented in Perl and Java using stored procedures on the Sybase, and Microsoft SQL Server.

10/2006 - 08/2008 Confidential, New York, NY. Senior Programmer/Analyst.
Primary responsibilities.

  • Provided technical guidance and support for a team of mainframe programmers.
  • Participated in technical system design. Performed system research and analysis.
  • Created and modified CICS and batch COBOL programs with VSAM and DB2 databases and WebSphere MQ interface between web-based front-end and mainframe back-end applications.
  • Participated in the setup of the QC (Quality Control) environment.
  • Built test cases for SYSI, QA and UA test and coordinated it with user.
  • Performed analyses of the test results.

Major Project.

  • Design and creation of a Notification system for Professional Traders Services Group to send email or pager notes to a specified group of users or to start job streams in a case of specific events.

02/2006 - 09/2006. Confidential, New York, NY. Senior Programmer/Analyst.
Primary responsibilities.

  • Participated in Functional Requirements review and TSD (Technical System Design) and DD (Data Dictionary) documentation creation.
  • Translated business requirements to technical design and detailed specifications.
  • Created DFD (Data Flow Diagrams), DSD (Data Structure Diagrams) and programs specifications.
  • Prepared pseudo-codes, coded, tested and implemented a number of programs, procs and jobs to manage entitlements for all systems throughout the organization. The system is used to review and update employee's access to Citigroup's applications. The COBOL programs accessed VSAM and sequential files and DB2 database. JCL procs and jobs used IDCAMS, SYNCSORT, File Aid and standard IBM utility programs. The programs used WebSphere MQ and stored procedure capability to communicate with front-end applications.
  • Prepared test data and set up and run test jobs.

Major Project.

  • Information Security Fast Track Project

07/2005 - 01/2006 Confidential, Montvale, NJ. Senior Programmer/Analyst.
Primary responsibilities.

  • Provided technical guidance and support for a team of mainframe programmers.
  • Translated business requirements to technical design and detailed specifications.
  • Created Physical Data Base Design documentation.
  • Coded and tested online CICS - DB2 - WebSphere MQ Inquiry and Update servers for interface between front-end and back-end applications using stored procedure. Produced all programs documentation.
  • Worked with DBA for performance evaluation.
  • Performed VSAM and DB2 development databases performance tuning and maintenance using DB2 UTILITES (REORG, RUNSTATS, CHECK, LOAD, DSNTIAUL, PLATINUM),
  • Coordinated development, QA and user groups activity
  • Built test cases for SYSI, QA and UA test and coordinated it with user.
  • Prepared all documentation for production migration. Coordinated production migration. Major Project.
  • Therapeutic Center Protocols for Clinical Strategy.

02/2005 - 06/2005 Confidential, New York, NY. Business Analyst.
Primary responsibilities.

  • Provided technical guidance and support for a team of software testers.
  • Made requirements for the system replacement project.
  • Performed programs source business and technical analysis and enhancement (COBOL/CICS/DB2/VSAM).
  • Created detailed test plans for unit, integrated unit, and systems testing.
  • Investigated issues arising during testing phase using business guidelines and communicated them to development teams and business users.
  • Handled additional requests supplied by business users during integrated unit testing and systems testing.
  • Participated in analyses of the test results.

Major Project.

  • Broker-Dealer applications conversion project. The main goal of the project was to convert broker-dealer business applications with client personal and tax-related information from the MONY company standards to AXA Financial company standards after MONY acquisition by. AXA Financial.

09/2004 - 12/2004 Confidential, Columbia, MD. Lead COBOL engineer.
Primary responsibilities.

  • Provided technical guidance and support for a team of mainframe programmers.
  • Produced business requirements gathering and analysis, Created specifications for COBOL-CICS-DB2-VSAM program modules
  • Worked closely with other teams to ensure compatibility between front-end and back-end systems, provided interface between business analysts group and a technical team.
  • Designed, coded, tested and implemented a general driver for databases interface. COBOL-CICS module received data from web-based front-end via WebSphere MQ and performed updates on DB2 and VSAM databases.
  • Designed, coded, tested and implemented DB2 stored procedures for database inquiry and update.

Major Project.

  • Provider Information & Credential Automation for Provider Information Management System. The main goal of the project was to develop user-friendly web-based system interface instead of CICS interface.

09/1995 - 07/2004 Confidential, New York, NY. Senior Programmer/Analyst.
Primary responsibilities.

  • Occupied a leading position in the full life cycle of the development and implementation of the Domestic (ASP) and Global (GSP) Automated Securities Processing Systems (VISTA, COBOL, CICS, DB2 with stored procedure capability, VSAM, WebSphere MQ, SWIFT). Resolved technical issues on System development and maintenance with respect to Rapid Application Development (RAD).
  • Provided technical guidance and support for a group of 3-5 team members.
  • Gathered and analyzed business requirements in order to segment the requirements into programmable parts.
  • Designed detailed specifications for program modules.
  • Performed VSAM and DB2 databases performance tuning and maintenance using DB2 UTILITES (REORG, RUNSTATS, CHECK, LOAD, DSNTIAUL, PLATINUM),
  • Coded and tested program modules in accordance with specifications.
  • Developed unit tests, concurrency, integration, regression system tests and user acceptance tests with strong user interface.
  • Prepared modules and documentation for production implementation.
  • Conducted post implementation 24/7-production support with user interaction and immediate production problem resolution using home access.
  • Analyzed production problems and provided recommendations for non-recurrence of such problems.
  • Provided maintenance of CICS test regions.

Major Projects.

  • Permanent responsibility for maintenance of ASP and GSP Security Master Files (SMF) and Account Master Files (AMF) inquiry and update on-line programs and all related batch reports. The programs utilized VISTA System, COBOL, CICS, VSAM, DB2 with stored procedure capability and WebSphere MQ.
  • Permanent responsibility for Tax Reporting System of the Securities Processing Department update and upgrade to incorporate tax low changes introduced by Congress and Internal Revenue Service (IRS). The Tax Reporting System extracts information from the Securities Processing Systems and produces magnetic tape report for IRS. The report provides information about position and account details to support U.S. federal tax disclosure requirements.
  • Enhancement of the Auto-Add process in ASP and GSP systems for the processing of various money market instruments such as Bank Notes, Discount Notes etc. in order to have CUSIP on the Security Master File and to move a trade. Clients have the capabilities of viewing which trades have been settled.
  • Expansion of ASP and GSP SMF and AMF in order to comply with new business requirements.
  • Enhancement of data warehouse using DB2 Utilities (REORG, RUNSTATS, CHECK, LOAD, DSNTIAUL) and IDCAMS.

1981-1994 Leading IT positions in the business and scientific organizations.

Hire Now