We provide IT Staff Augmentation Services!

It Consultant (systems Analyst/developer) Resume

Sacramento, CA

EXPERIENCE SUMMARY:

  • Accomplished Systems Analyst/design/developer in mainframe with 14 years of result oriented progressive experience of financial services/industry on IT multi - platform specially in Confidential mainframe with core focus in COBOL/CICS/SQL/DB2/IMS/VSAM environment, using all phases of Software Development Life Cycle (SDLC) in enterprise applications, which includes project lead, systems analysis, designing, development, implementation, system conversions and systems documentation.
  • Also have exposure to analyzing business systems and requirements.
  • Recognized for attention to detail, adherence to system standards, and meeting business objectives through creative design and efficient implementation of enterprise systems.
  • Possess strong analytical, problem solving and communication skills.
  • Demonstrated ability to interact with people on different levels in a fast-paced work environment with constantly changing priorities.

DOMAIN EXPERTISE:

  • Analysis, design, development, testing
  • Test Plan and Test Cases system functional design and Technical System design document
  • Good banking experience and knowledge
  • Database Design and Implementation
  • Data validation and Testing
  • Mainframe Programming and Procedures
  • Data Extracting, Formatting and Load
  • Production support
  • System convertion
  • Requirements documentation

TECHNICAL SKILLS:

Industry Exposure: Health Care, Banking / Finance, Telecommunication, Payroll, InventoryRetail business

Platforms: Confidential Mainframe ZOS/390, MVS, VSE, MS Windows, UNIX

Database / Access method: DB2, IMS, VSAM, Datacom, Oracle

GUI/Tools: Microsoft Office, MS Project, VISIO, Putty, Toad, MS Word, MS Excel

Languages: COBOL, Microfocus Cobol, CICS, JCL, IDEAL, CA7, DB2 stored Procedure, CLIST, SQL, PL/SQL, REXX, CLIST, Crystal report, PL1Easytrieve

Utilities: FTP, IDCAMS, VISIO, TSO, ISPF, SPUFI/QMF, RACF, DFSORT, FILE-AIDCICS-ABEND-AID, PANVALET, CHANGEMAN, Platinum, XpediterLotus Notes, Inter-test, knowledge of CSF tool, Eclipse, HTML, ToadIBM Debugger, Mainframe Express, SharePoint.

Methodology: SDLC

PROFESSIONAL EXPERIENCE:

Confidential, Sacramento, CA

IT Consultant (Systems Analyst/developer)

Responsibilities:

  • Analysis design, development, support and enhancement for Confidential system in Confidential mainframe / multi-platform environment
  • Created system functional design (SFD) and Technical System design (TSD) document for health care claim system project
  • Completed successfully code conversion project with enhancement in the existing system. In this system local codes has been replaced by national codes as standard codes like revenue codes.
  • Testing and implementing the application as per HIPAA Regulations for health care claims
  • Modification and developed programs using Enterprise COBOL in Batch and CICS environments
  • Prepared detailed test cases to verify system functionality. Development includes working with the clients to gather and identify functional requirements, designed and documented technical requirements then wrote new code and modified existing code from technical system design. Tested and implemented enhancements and /or support applications. Performed conceptual, logical and physical design to generate computer programming specifications based on user requirements. Conducted functional testing to ensure that the application could support all business requirements and meets the HIPAA regulations.
  • Use of TSO/ISPF for compiling, managing programs and configuring system
  • The SDLC methodology used throughout the project for all phases of project planning.

Environment: Confidential Z/OS, CICS, COBOL, JCL, CA7, VSAM, DB2, SQL, MVS, TSO, ISPF, Confidential Debugger, File-Manager, FTP, SharePoint, Windows-7, MS Word, Excel, Lotus Notes, Confidential Utilities

Confidential

IT Consultant (Systems Analyst/developer)

Responsibilities:

  • Analysis planning, design, development, production support and maintenance telecom system in Confidential mainframe / multi-platform environment.
  • Development and modification of Martens Telecom System.
  • User change requests handling and production fixes - tickets
  • Setup the Environments for QA’s and coordinate in testing
  • Created detailed functional specifications for both the batch and online programs.
  • Maintained and created programs using Enterprise COBOL/DB2/SQL, DB2 stored procedures in Batch and CICS environments
  • Prepared detailed test cases to verify system functionality. Development includes working with the clients to gather and identify functional requirements, designed and documented technical requirements then wrote new code and modified existing code from specifications as required. Tested and implemented enhancements and /or support applications. Performed conceptual, logical and physical designs to generate computer programming specifications based on user requirements. Conducted functional testing to ensure that the application could support all requirements.
  • Using System flow chart and Process flow chart using Microsoft Visio to illustrate the input data feeds from different sites and flow of processing of the front end and downstream feeds
  • Performed as the user liaison for gathering business application requirements.
  • Use of ISPF and Microfocus for compiling, managing programs and configuring system
  • Using FTP to upload and download files over the internet as the application layer protocol that handles file transfers.
  • The SDLC methodology used throughout the project for all phases of project planning.

Environment: Confidential Z/OS, CICS, COBOL, Microfocus Cobol, Mainframe Express, JCL, CA7, DB2 stored procedure, SQL, DB2, IMS, SPUFI, QMF, VSAM, MVS, TSO, ISPF, FILE-AID, FTP, VISIO, Platinum, Xpeditor, UNIX, Eclipse, HTML, Toad, Windows-7, Word, Excel, Confidential Utilities

IT Analyst/developer

Confidential

Responsibilities:

  • Tech Lead, development, modification and production support of Payment System using SWIFT.
  • Systems analysis and development of payment system having knowledge of SWIFT network
  • Co-leader of migration mainframe payment systems conversion to oracle server platform
  • Lead Mainframe reports migration to BI/ETL environment area to facilitate end users online enquiries.
  • Have knowledge about SAS and ETL.
  • Knowledge of environments (LAN/WAN, client-server, internet/intranet).
  • Managed all user change requests and added functionality enhancements to applications
  • Production support of BankTrade System of CSI (Vendor) for L/Cs and Bills.
  • Successfully re-engineered banking system of Credit Agricol corp. and Inv. Bank from Confidential system-36 to Confidential mainframe DB2 environment.
  • Created detailed functional specifications for both the batch and online programs.
  • Developed test scenarios and detailed test cases to verify system functionality. Development included working with the clients to gather and identify functional requirements, designed and documented technical requirements then wrote new code and modified existing code from specifications as required. Tested and implemented enhancements and /or support applications. Performed conceptual, logical and physical designs to generate computer programming specifications based on user requirements. Conducted functional testing to ensure that the application could support all requirements.
  • Prepared System flow chart and Process flow chart using Microsoft Visio to illustrate the input data feeds from different sites and flow of processing of the front end and downstream feeds
  • Performed as the user liaison for gathering business requirements and prepare detailed specifications for the line of business applications
  • Use of ISPF/TSO for compiling, managing programs and configuring system
  • Interfaced with various applications using FTP. Used FTP to upload and download files over the internet as the application layer protocol that handles file transfers.
  • The SDLC methodology used throughout the project for all phases of project planning.

Environment: Confidential ZOS/390, CICS, COBOL, JCL, CA7, SQL, DB2, Datacom, IDEAL, SPUFI, VSAM, MVS, TSO, ISPF, FILE-AID, FTP, VISIO, Xpeditor, Windows XP, Word, Excel, Confidential Utilities.

Confidential

IT Analyst/developer

Responsibilities:

  • Tech Lead/ Systems analysis and production support of Inventory system.
  • Designed, analyzed, developed and deployed Depot Shipping subsystem of Supply and maintenance Inventory System (SMI) using SDLC (System Development Life Cycle) Methodology.
  • Analysis, development, and implementation and production support of Nissan auto vehicle project.
  • Development included working with the clients to gather and identify functional requirements, design and document technical requirements, then write new and modify existing code from specifications, test and implement enhancements and /or support applications. Wrote SQL queries using SPUFI to examine output results.
  • Acted as the user liaison roll for gathering business requirements and prepare detailed specifications for the line of business applications
  • Assignment includes analysis, Investigation, fixing online and batch programs.
  • Developed test strategy and test cases to verify system functionality for all of the phases of the software development life cycle.
  • Created and modified files and JCLs in order to test the accuracy of System modifications and running the jobs in test region before uploading to production.
  • Prepared detailed functional specifications for both the batch and online programs.
  • Use of ISPF for compiling, managing programs and configuring system.
  • Participated in the on call production support periodical rotation.
  • Reports for weekly progress of all the activities.
  • Preparation of analysis and creation of data flow diagram.
  • Documented project details and status reports.

Environment: Confidential 390, CICS, COBOL, SQL, DB2, SPUFI, VSAM, JCL, MVS, TSO, ISPF, FILE-AID, VISIO, XPEDITER, Word, Excel, Windows, Confidential Utilities.

Confidential

Sr. Analyst/developer

Responsibilities:

  • Development of 416 Overlay project (replacement of compressed NPA (Number Plan Area) by full NPA i.e. Increase from 7 digits to 10 digits Phone number)
  • Development of CDMA (Code Division Multiple Access) application and resolved systems problems faced by the end user.
  • Analyzed user requirements and developed reports from SOF Print (Service Order Feed), PIC/CARE (Primary Interchange Carrier/ Customer Account Record Exchange) System.
  • Managed all user change requests and added functionality enhancements to applications.
  • Coordinated in the process of migration of Applications from PANVALET to CHANGEMAN environment.
  • Enhanced, maintained programs using Enterprise COBOL/DB2/SQL, DB2 stored procedures in Batch and CICS environments
  • Developed, coded, enhanced, unit tested (wrote unit test plans using Excel and word), supported and maintained structured DB2 COBOL programming code. Batch tested programs for insertion of data into a DB2 database using COBOL for all of the phases of the software development life cycle. The SDLC methodology used throughout the project for all phases of project planning was in-house developed.
  • Created and modified files and JCLs in order to test the accuracy of System modifications and running the jobs in test region before uploading to production.
  • Used TSO/ISPF to set up DB2/SQL queries using SPUFI to set up test data.
  • FTP was used to transfer departmental files for testing and SPUFI to examine the output results on the DB2 database tables.
  • Debug and test the programs with XPEDITER after making changes for expected results.
  • Provided support for RACF in the test environment.
  • Reporting for weekly progress of all the activities.

Environment: Confidential 390, CICS, COBOL, SQL, DB2, SPUFI, VSAM, JCL, DB2 stored procedure, MVS, TSO, ISPF, FILE-AID, VISIO, XPEDITER, Changeman, RACF, Windows, Word, Excel

Confidential

IT Developer/Analyst

Responsibilities:

  • Responsible for systems analysis, batch and on-line programming, testing and documenting of financial and accounting systems. These systems were developed using COBOL, CICS, and VSAM.
  • Analyzed, developed and deployed a customized solution for Financial/Accounts using SDLC (Systems Development Life Cycle) methodology.
  • Developed and deployed online inquiries for end-users to monitor profit variations.
  • Coded the new conversion program using Cobol II that handled input, editing, updating, output, and reporting alone and yet remained simple so that it would be used as a template for future conversions. A walk through confirmed correctness and an adherence to coding standards.
  • Prepared employees payroll stub and employees payroll reports and inquiries.
  • Established unit and system test plans that were comprehensive and used to allow functional and path testing of the conversion part as well as other parts of the main batch system that were changing as a result of the conversion effort. Due to the complexity, automation tools such as File-Aid were used in the analysis of test.
  • Created ad-hoc reports as required.
  • Created and modified files and JCLs in order to test the accuracy of System modifications and running the jobs in test region before uploading to production.
  • Used IDCAMS for various operations on VSAM datasets for faster access.
  • Provide weekly progress report of all the activities.

Environment: Confidential 390, CICS, COBOL, VSAM, JCL, Easytrieve, FILE-AID, MVS, TSO, ISPF, VISIO, MS Windows, MS Word, MS Excel

Hire Now