Sql Developer Resume Profile
SUMMARY: Experience of 9 years working in all the phases of SDLC Requirement Analysis, functional and technical specification designing, development, testing, implementation and Production Support of Mainframe Applications Development Project Designed Functional Specifications on the basis of Business Requirement documents and Client's interaction. Designed Technical documents on the basis of Functional specifications that form the basis of future coding. Designed various test documents on the basis of business requirement, functional and technical design documents that form the basis of unit, integration and User Acceptance testing phases of Project Designing and Updating Architectural framework and DB2 Database Structure. Used Expeditor, INTERTEST for debugging/testing. Well-versed with most DB2 Interactive utilities like SPUFI SQL Processor Using File Inputs , QMF Query Management Facility , PLATINUM/DB2 Relational Tools. Provided 24X7 on call rotation for production and test environments Strong knowledge in performance tuning for the batch and online applications. Expertise in CICS Online/ Batch applications designing and coding Performed analysis of current functionality and recommend process improvements for enhancement. Expertise in knowledge acquisition, system study, architecture analysis documentation. Developed JCL's and PROC's to execute COBOL Codes and also prepared Production version JCL'S Developed programs with COBOL, DB2, CICS and VSAM combination. Performed and led the teams responsible for various phases of testing through the course of the project: Unit Testing of Codes on the basis of developed Unit Test Documents. Integration testing that tested functionality as well as compatibility of the developed Mainframe application with interfacing systems. Involved in User Acceptance Testing to test the overall functionality against Business Requirement document Involved in pre-implementation activities like developing deployment plan, develop Job scheduling, acquiring necessary accesses and developing disaster recovery and roll back plan. Involved in Implementation phase of the project Involved in Post- Production support that included defect trouble shooting and implementing planned deployments. Conversant with all phases of project Life Cycle including Requirement gathering, Analysis, Design, Development, Implementation, Testing, Software quality standards and configuration management and change management and Quality procedures. Proficient in Software Development Life Cycle SDLC , CMM, CMMI processes An individual with proven leadership, administrative, communication, organizational skills. Have a good combination of technical, communication and interpersonal skills, which provide the ability to be an effective mediator between programmers, end-users and clients. Highly motivated with the ability to work effectively in teams as well as independently Involved in Quality Assurance activities like defect logging, defect analysis and developing checklists and defect reduction techniques like standardization of codes.
Technical Skills
- Operating Systems: Win9x. Win 2000, UNIX, z/OS, OS/390, MVS/ESA
- Languages: VS COBOL-II, COBOL 370, MS-COBOL, CICS, JCL, SQL, Easytrieve,
- HTML, JavaScript
- Database DB2, IMS-DB, IDMS , VSAM, MS Access
- Project Management and
- Version Control tools: ChangeMan, Endevor, Panvalet, Librarian, PowerPoint MS Project.
- Others: XPEDITER, FILE-AID, FILE MANAGER, SUPERC, TSO ISPF/PDF,
- QMF, SPUFI, WEBAWARE, INSYNC, PLATINUM/DB2, BMC tools, ABEND-AID, RACF, SDF2, Fault Analyser, Dump Master, SYNCSORT, DFSORT, PROJCL, INTERTEST, CA-7, CA-11, Job track, HTML, JavaScript, Compare-X, MS-Visio, MS-Office, and Lotus Notes, Business Objects.
PROJECTS:
Confidential
Role Responsibilities
- Prepared BRD specification of modules and processes.
- Worked with DBA's Design create new tables.
- Data Load to various Test Regions and reformatting data depending on the requirement using DB2 Load utilities.
- Wrote Batch COBOL, DB2, and VSAM programs.
- Involved in DB2 Performance tuning, rewritten several legacy Systems SQL queries to get optimal performance.
- Wrote the DB2 subroutines, to access the DB2 tables and to display the data on the WebPages.
- Set up batch cycle Running Test Cycles for end to end testing.
- Tested the programs in different testing phases like Unit, Integration and System Testing.
- Understood business requirements, preparing technical specifications document, Code changes in batch COBOL programs, Testing and Debugging
- Customizing the existing COBOL programs while debugging the code for any issues.
- Done Code Migration and Deployment to system test environment.
- Prepared Test results based on the execution of test cases.
- Fixed bugs those are identified as a result of QA Testing.
- Discussed the systems problem with managers and users to determine its exact nature.
- Involved in Post Production Support and Maintenance.
Confidential
Role Responsibilities
- Prepared HLD, LLD, BLD specification of modules and processes.
- Worked with DBA's Design create new tables.
- Data Load to various Test Regions and reformatting data depending on the requirement using DB2 Load utilities.
- Wrote Batch COBOL, DB2, and VSAM Interface programs to communicate between Cool-Gen Mainframe Systems.
- Wrote the DB2 subroutines, to access the DB2 tables and to display the data on the WebPages.
- Set up batch cycle setup test JCL Running Test Cycles for end to end testing.
- Tested the programs in different testing phases like Unit, Integration and System Testing.
- Understood business requirements, preparing technical specifications document, Code changes in batch COBOL programs, Testing and Debugging
- Discussed the systems problem with managers and users to determine its exact nature.
- Peer review of the Code, design documents, test plans and test results.
- Involved in Post Production Support and Maintenance.
Confidential
Role Responsibilities
- Prepared HLD, LLD, BLD specification of modules and processes.
- Worked with DBA's Design create new tables.
- Data Load to various Test Regions and reformatting data depending on the requirement using DB2 Load utilities.
- Wrote online JAVASCRIPT, CICS, COBOL, DB2, WEB-AWARE and VSAM Interface programs to communicate between Java Templates and Mainframe Systems.
- Wrote the DB2 subroutines, to access the DB2 tables and to display the data on the WebPages.
- Set up batch cycle setup test JCL Running Test Cycles for end to end testing.
- Tested the programs in different testing phases like Unit, Integration and System Testing.
- Understood business requirements, preparing technical specifications document, Code changes in CICS online batch COBOL programs, Testing and Debugging
- Discussed the systems problem with managers and users to determine its exact nature.
- Peer review of the Code, design documents, test plans and test results.
- Met with clients to discuss system requirements, specifications, costs and timelines, analyse user's needs and Plan, design and co-ordinate the development, installation, integration and operation of other interface systems.
- Involved in Post Production Support and Maintenance.
Confidential
Role Responsibilities
- Prepared HLD, LLD, BLD specification of modules and processes.
- Wrote new/changes to complex COBOL, CICS, and JCL programs to add multiple billing functionality.
- Worked with DBA's Design create new tables
- Wrote COBOL Common I/O modules to support DB2 database calls for COBOL Programs.
- Data Load to various Test Regions and reformatting data depending on the requirement using DB2 Load utilities.
- Coded and Running the Emergency Data fixes in SPUFI/WinSQL DB2- Queries .
- Database cleanup in test environments using DB2 Load/Update SQL's.
- Set up batch cycle setup test JCL Running Test Cycles for end to end testing.
- Created SPUFI/QMF SQL reports as per clients Adhoc need for business.
- Carried out unit testing, integration testing, performance testing, load testing, regression testing and System testing.
- Understood business requirements, preparing technical specifications document, Code changes in CICS online batch COBOL programs, Testing and Debugging.
- Ran Test Cycles based on client Request.
- Fixed bugs those are identified as a result of QA Testing.
- Discussed the systems problem with managers and users to determine its exact nature.
- Diagnosed problems, recommend solutions, determine whether program requirements have been met.
- Identified and communicated technical problems, processes and solutions.
- Wrote detailed test plans and test requirements hierarchy.
- Peer review of the Code, design documents, test plans and test results.
- Discussing the systems problem with managers and users to determine its exact nature.
- Met with clients to discuss system requirements, specifications, costs and timelines, analyse user's needs and Plan, design and co-ordinate the development, installation, integration and operation of other interface systems.
- Involved in knowledge acquisition, system study, architecture analysis and documentation.