Senior Mainframe And Etl Tester Resume
3.00/5 (Submit Your Rating)
SUMMARY
- With around 8+ years of professional experience in IT in the areas of Software Application Development, Maintenance and Support of systems, requirements Gathering, Analysis, Design, Testing, Implementation and lead IT projects. With functional and technical knowledge that I have gained till this period and keeping same approach to learn and grow, I believe myself to be capable of handling a team and delivering with continued excellence.
- Executed enhancement projects with significant contribution in all phases of project life cycle.
- Good knowledge of quality processes followed as part of CMM level 5 procedures.
- Project Development experience in both waterfall and agile mode.
- Extensive experience in job flows in production using CA - 7.
- Having knowledge in IBM MQ series
- Handling Job abends and resolving them with in SLA time. Perform root cause analysis and implement permanent fix.
- Extensive experience in Designing business applications, preparing test cases, typical build activities including delivery of source code, test results and implementing the changes in production.
- Execute testing, analyze the results and report the execution status Exploring and Analyzing new business opportunities
- Driving team meetings, implement best practices, Knowledge Management and trainings. Identify repeated tasks, prepare documentations on repeated tasks, reduction of manual efforts and bring automation ideas to avoid manual work.
- Good Team player with excellent oral and written communication skills.
- Clear, concise and effective written and verbal communication skills Extensive experience in Job flows scheduling/running in production/System Test/Unit Test using Scheduling tools like Jobtrac and CA-7.
- Identify data requirements for testing; prepare selection criteria to identify data, Identify test data, securing test environments for testing.
- Productive team member, capable of working independently. Communication with the client and management reporting on day-to-day basis.
- Good knowledge in writing SQL queries in SPUFI and QMF
- Experience in understanding new business requirements, existing applications, Impact Analysis, Design, Maintenance, Unit Testing, Functional, Integration and Regression Testing.
- Excellent knowledge of both Batch and Online systems running on Mainframe.
- Worked on all phases of project starting from technical designing to post implementation support.
- Experience in solving the production abends and fixing the defects or issues in the production.
- Effective interpersonal skills to co-ordinate and participate in a team environment.
- Good at risks management.
- Worked on development of innovative concepts to bring system stability and cost saving.
TECHNICAL SKILLS
- Operating Systems: Z/OS, MVS, Windows
- Languages: C, COBOL, JCL, COBOL Assembler, SQL, HTML
- Tools/Utilities Used: CHANGEMAN, File - Aid, File-Manager, Xpediter, CA-7, NDM, FTP, MQ-Series, TSO-ISPF, IBM Utilities, JCL Utilities, HP QLM
- Software Controls: VSAM, CICS, DB2, Basic SAS, Mainframe Batch Processor Teamforge, Quality center, GSD(Global Service Desk).
PROFESSIONAL EXPERIENCE
Confidential
Senior Mainframe and ETL tester
Technologies - Unix, JCL, JOBTRAC, ETL datastage, Rapid sqI,DB2,IMSDB,Datavan, Autosys
Responsibilities:
- Developed Test Plan and Test Cases based on the requirements and design documents.
- Extensively used HPALM for test planning, bug tracking and reporting.
- Reviewed Unit Test results and performed smoke test to decide credibility of the build in order to initiate manual testing and regression.
- Performed Smoke testing on new environments and new databases.
- Performed Regression tests on SAS 9.4 upgrade and Mainframe z/OS 2.2 upgrade
- Managing a project that is intended to generate change the reports from every 15 th of month to first day to last calendar day of the month.
- Worked on Parent and Child segments of IMS system to bring in data from IMS to DB2D and then to the target tables.
- Used Datavan tool extensively to query IMS database.
- Perform DML (ISRT, DLET, REPL) on IMS DB using datavan tool and DCU(Data correction utility).
- Execute Autosys jobs in UNIX environment to generate reports between source and target (Positive testing, Negative testing, 1000 exception)
- Worked on Data propagator project where the data from IMS is replicated to IBM DB2 through informatica workflow.
- Maintenance of SAS programs that retrieve data from IBM DB2 and writes in to a mainframe file.
- Executed mainframe jobs that called different programs such as COBOL,SAS to load different tables.
- Written Jcl from scratch
- Modification Of SAS Programs
- Used Fileaid tool to query and differentiate data using copybooks.
- Developed basic and complex SQL queries to test the database values for data integrity
- Execute ETL DataStage jobs from Autosys in UNIX box(Putty)
- Analyze DataStage job logs in case of any fatal errors while testing.
- Deployment of new DDLs in the Databases(IBM DB2)
- Conducting meeting with business to understand requirements
- Execution of test cases
- Extensive work in rapid sql for running queries
- JCl, SAS program analysis for test execution
Confidential
Application developer
Responsibilities:
- End-to-End estimation and Resource planning for the Project.
- Worked on various web application interface
- Worked on Production tickets
- Involved in analyzing the requirements and preparing technical specification document i.e. Design document.
- Involved in Initial Analysis of existing COBOL Programs and Processes.
- Preparation of Impact Analysis Documents.
- Identified the all programs that are required to be changed
- Coding from scratch online CICS programs handling messages from TDQ and MQ.
- Responsible for troubleshooting and debugging. Assist the junior programmers in developing and testing codes.
- Worked with the team to perform unit testing and checked for flaws in process.
- Responsible for reviewing deliverables with respect to functional and business check list.
- Prepared daily/weekly project status report and published to project manager to give status report to client.
- Prepared detailed implementation plan and executed in production without any issue.
- Creating reports using SAS, easytrieve.
- Worked with Scrum Team
Programmer analyst
Confidential
Responsibilities:
- End-to-End estimation and Resource planning for the Project.
- Involved in analyzing the requirements and preparing technical specification document i.e. Design document.
- Involved in Initial Analysis of existing COBOL Programs and Processes.
- Preparation of Impact Analysis Documents.
- Identified the all programs that are required to be changed
- Responsible for troubleshooting and debugging. Assist the junior programmers in developing and testing codes.
- Worked with the team to perform unit testing and checked for flaws in process.
- Responsible for reviewing deliverables with respect to functional and business check list.
- Prepared daily/weekly project status report and published to project manager to give status report to client.
- Prepared detailed implementation plan and executed in production without any issue.
- Involved in writing business rules for existing ICON RE
- Responsible for induction & Training of new resources in this area, this comprises of creation of their KT plan and monitoring their KT progress.
Team Member/Task lead
Confidential
Environment/Skills Microfocus Cobol, Unix Putty
Responsibilities:
- Working on onsite-offshore model for requirement understanding and transferring the knowledge to the team
- Conducting Impact Analysis of the code changes for System investigation requests.
- Analyzing, coding, testing and reviewing of the modules which contain the business logic.
- Resolving the system investigation requests for different clients which involves analysis, debugging and enhancements of the core inventory.
Team member
Confidential
Environment/Skills JCL, COBOL 85, DB2, CICS, Endevour, Quality Center.RPG,AS400
Responsibilities:
- Involved in initial analysis of delivered code and informed client about major and complex changes.
- Responsible for preparation of high-level design document based on requirement.
- Developed new batch COBOL programs and test plans as part of the new enhancements and designs.
- Coordinating with team to complete design, coding on time.
- Involved in review of design document, code and unit test plan prior to deliver to client.
- Involved in Test Management Activities like Review of Deliverables with onsite coordinator, deliverable maintenance, Project Status.
- Single point of contact (POC) for answering queries from team, tracking the schedule, tracking the quality of deliverables and resolving team concerns.
- Assistance in quality assurance testing.
- Worked on analysis of QA defects and documented test defects in the QA Test Mgmt tool (Quality Center).
- Involved in Unit, Integration, System and Regression testing of batch programs, Implementation and post Implementation support.
- Preparation of project closure document post release of project.