SUMMARY:

• Experience in ETL DEV, ETL Tester, Manual Tester, Hadoop tester, Web Service Tester, Performance Tester.
• Strong Experience on Payment domain Industry, Banking Industry
• Experience in ETL dev for 1.5 yrs
• Solutions - focused ETL Abinitio Lead with approx. 4 years of experience in the area of Data Warehousing and ETL projects which consists of strong knowledge and experience in SDLC and STLC layers .Strong foundation in big data, Hadoop, AB INITIO, DB2, Oracle, UNIX and Mainframe.
• Experience in Hadoop testing pig, scoop, hive, map reduce, HDFS system etc.
• Experience in Solar technology in manipulating collections and indexing data and perform search.
• Experience in Automation testing.
• Experience in batch processing using Autosys
• Strong knowledge in SQL with common RDBMS like DB2, Oracle, SQL, PL/SQL, DB2, complex Stored Procedures, Triggers.
• Experience in web-service testing using soap UI to execute automated functional, regression tests.
• Proficient in Unix Shell Scripting, Perl commands,
• Performance tuning using load runner.
• Strong Working knowledge in Ab initio Co-ops v 2.14, 2.16 & 3.0 & above.
• Experience on abinitio 24*7 Service graph, Continuos Graph and Plan
• Strong knowledge in EDW and SAS testing.
• Strong knowledge in ODS (operational data store).
• Knowledge in BI reporting.
• Expertise in test management using HP ALM. And Quality Center.
• Working Knowledge in MVS
• Leading a team of 5 members and working with business and development team to understand the business requirements and Analyzed requirements and provided work effort estimates.
• Good business knowledge in domains Electronic Payments (Banking),
• Strong hands on experience on ETL tool (Abinitio).
• Ability of leading teams with up to 10 members to ensure quality and defect free deliverables.
• Created testing specification & operational documentation.
• Familiar with Software Development Life Cycle, Software Test Life cycle and Bug Life cycle
• Involved in preparation of Requirement Traceability Matrix (RTM), SRS, Conceptual Approach, detail design, unit test documents.TestPlan, Test Case, Defect Report, and Weekly Status Reports, Checklists, Summary Reports.
• Experience in Data Analysis, Test Data generation, Data Validation, Data Cleansing, Data Verification and identifying Data Mismatch.
• Extensive experience in reviewing Business Requirement Documents, Software Requirement Documents and preparing Test Cases for unit testing, Test scripts and Execution.
• Develops test strategies, test plans, test cases, test reports and test estimates. Creates test data requests and test scripts.
• Excellent analytical, multi-tasking, problem-solving, time-management & communication skills with particular emphasis on Supported production and maintained applications.
• Experienced in bug tracking using Clear Quest for reporting the modification requests and collecting Test Metrics in order to keep track of the test progress and test execution.
• Customer value and Client satisfaction being the key focus areas
• Excellent leadership capabilities and managing vendor resources
• Excellent interpersonal and communication skills.

TECHNICAL SKILLS:

High Level Language:  C,C++,HTML,Core Java

Databases / Structures:  IBM DB2,MS SQL Server, Hadoop, HIVE,PIG,SAS, Oracle,TOAD

Methodology:  IBM Mainframe, Unix AIX

ETL Tools:  Ab-Initio- Ver-3.1.6.1 and above

Other Tools used:  Putty, Aqua studio, CQ,Soap UI,Solar, HP-ALM, Quality Center, IBM Mainframe(MVS), SAS, IBM Rational Clear Quest,autosys

Industry / Market Segment:  Electronic Payment System

Operating System:  Windows 2000/XP, Unix

SDLC Models:  Waterfall, Agile

PROFESSIONAL EXPERIENCE:

Confidential

Software engineer

Responsibilities:

• Creative web designer in designing the website as per current market trend.
• Experience in designing dynamic and static pages.
• Hands on experience of designing the newsletters, flash presentations, logos and other marketing collaterals.
• Team player with good listening skills and innovative ideas to make attractive designs.

Confidential

WEB service tester and Hadoop tester

Responsibilities:

• Effort estimation of the forecasted work based on High level scope.
• Worked as an Onsite Team lead for handling 6 team members.
• Managing effort and task distribution between team Members.
• Mentoring Team members.
• Participate and provide views in the preliminary and detail design reviews.
• Writing Test strategy, Test Plan, Test Cases and ensure coverage of entire scope.
• Presentation of the above stated deliverables to the Project and Business Teams.
• Analysis and Management of Test Data to be used for Testing across the flow.
• Analysis and fabrication of test data for testing of functional changes on VISA Dispute management product (Visa Resolve Online) and other downstream Reporting Applications.
• Conducting Functional, regression and Integration testing to ensure defect free release.
• Defect Reporting and Metric Analysis.
• Presentation of Test Results and Test findings Report to the Project and Business Teams.
• Testing of Post production change requests and emergency fixes.
• Creating Data compare and data aggregation tools for data analysis.
• Handle the service graph 24*7 in QA environment.
• Status reporting and co-ordination with customers.
• Contribution to Knowledge Management initiatives.
• Reviewing and analyzing requirement and product specifications, developing and executing test plans, test procedures and test scenarios.
• Validating the DB2 extract script and data to ensure the data is populated as per the scripts.
• Validate the ETL mappings, SQL queries and different ETL transformation.
• Perform validation on the file created on Hadoop server.
• Validation of pig script, hive script and scoop
• Works on Hadoop UI HUE.
• Perform validation on the connectivity on Hadoop and Solr Server
• Perform validation for proper indexing of file into solar Technology.
• Validation of the collection created on the solr server.
• Validation of request and response structure using SOAP UI.
• Web Service testing using SoAPUI
• Run complete test cycles for each product release monitoring and analyzing test results, collecting test metrics and conducting test reporting.
• Performing different verification, validation and end to end testing different delimiter extract files and SQL scripts.
• Coordinated with Business Analysts (both teams) to synchronize the data across various systems across the Project.
• Publishing reports and documentation for intranet knowledge server called as wiki pages.
• Writing complex SQL queries to analyze source data and communicating data quality issues to the business.
• Developed automate UNIX scripts to validate data in the extract files are same as the data in the database
• Validation of request and response structure using soap-UI thru CDISI layer

Solution Environment: Unix, Ab Initio,Db2,SQL,SAS, Clear Quest, ALM, ODS, Hadoop, HIVE, PIG

Confidential

ETL Quality Analyst

Responsibilities:

• Effort estimation of the forecasted work based on High level scope.
• Managing effort and task distribution between team Members.
• Mentoring Team members.
• Participate and provide views in the preliminary and detail design reviews.
• Writing Test strategy, Test Plan, Test Cases and ensure coverage of entire scope.
• Presentation of the above stated deliverables to the Project and Business Teams.
• Analysis and Management of Test Data to be used for Testing across the flow.
• Analysis and fabrication of test data for testing of functional changes on VISA Dispute management product (Visa Resolve Online) and other downstream Reporting Applications.
• Conducting Functional, regression and Integration testing to ensure defect free release.
• Defect Reporting and Metric Analysis.
• Presentation of Test Results and Test findings Report to the Project and Business Teams.
• Testing of Post production change requests and emergency fixes.
• Creating Data compare and data aggregation tools for data analysis.
• Status reporting and co-ordination with customers.
• Contribution to Knowledge Management initiatives.
• Reviewing and analyzing requirement and product specifications, developing and executing test plans, test procedures and test scenarios.
• Validating the DB2 extract script and data to ensure the data is populated as per the scripts.
• Validate the ETL mappings, SQL queries and different ETL transformation.
• Run complete test cycles for each product release monitoring and analyzing test results, collecting test metrics and conducting test reporting.
• Performing different verification, validation and end to end testing different delimiter extract files and SQL scripts.
• Coordinated with Business Analysts (both teams) to synchronize the data across various systems across the Project.
• Developed automate UNIX scripts to validate data in the extract files are same as the data in the database.
• Publishing reports and documentation for intranet knowledge server called as wiki pages.
• Writing complex SQL queries to analyze source data and communicating data quality issues to the business.

Solution Environment: Unix, Ab Initio,Db2,SQL,SAS, Clear Quest, ALM, ODS, Hadoop, HIVE, PIG

Confidential

ETL Quality Analyst

Responsibilities:

• Effort estimation of the forecasted work based on High level scope.
• Managing effort and task distribution between team Members.
• Mentoring Team members.
• Participate and provide views in the preliminary and detail design reviews.
• Writing Test strategy, Test Plan, Test Cases and ensure coverage of entire scope.
• Presentation of the above stated deliverables to the Project and Business Teams.
• Analysis and Management of Test Data to be used for Testing across the flow.
• Analysis and fabrication of test data for testing of functional changes on VISA Dispute management product (Visa Resolve Online) and other downstream Reporting Applications.
• Conducting Functional, regression and Integration testing to ensure defect free release.
• Defect Reporting and Metric Analysis.
• Presentation of Test Results and Test findings Report to the Project and Business Teams.
• Testing of Post production change requests and emergency fixes.
• Creating Data compare and data aggregation tools for data analysis
• Status reporting and co-ordination with customers.
• Contribution to Knowledge Management initiatives.

Solution Environment: Unix, Ab Initio,Db2,SQL,SAS, Clear Quest, ALM, ODS, BI reporting

Confidential

ETL Quality Analyst 

Responsibilities:

• Effort estimation of the forecasted work based on High level scope.
• Handle the service graph 24*7 in QA environment.
• Participate and provide views in the preliminary and detail design reviews.
• Writing Test strategy, Test Plan, Test Cases and ensure coverage of entire scope.
• Presentation of the above stated deliverables to the Project and Business Teams.
• Analysis and Management of Test Data to be used for Testing across the flow.
• Conducting Functional, regression and Integration testing to ensure defect free release.
• Defect Reporting and Metric Analysis.
• Presentation of Test Results and Test findings Report to the Project and Business Teams.
• Testing of Post production change requests and emergency fixes.
• Creating Data compare and data aggregation tools for data analysis
• Status reporting and co-ordination with customers.
• Contribution to Knowledge Management initiatives.

Solution Environment: Unix, Ab Initio,Db2, SQL, Clear Quest, ALM

Confidential

ETL Quality Analyst

Responsibilities:

• Effort estimation of the forecasted work based on High level scope.
• Participate and provide views in the preliminary and detail design reviews.
• Writing Test strategy, Test Plan, Test Cases and ensure coverage of entire scope.
• Presentation of the above stated deliverables to the Project and Business Teams.
• Analysis and Management of Test Data to be used for Testing across the flow.
• Analysis and fabrication of test data for testing of functional changes on VISA Dispute management product (Visa Resolve Online) and other downstream Reporting Applications.
• Conducting Functional, regression and Integration testing to ensure defect free release.
• Defect Reporting and Metric Analysis.
• Presentation of Test Results and Test findings Report to the Project and Business Teams.
• Testing of Post production change requests and emergency fixes.
• Creating Data compare and data aggregation tools for data analysis
• Status reporting and co-ordination with customers.
• Contribution to Knowledge Management initiatives.

Solution Environment: Unix, Ab Initio,Db2, SQL, Clear Quest, ALM,MVS

Confidential

ETL Developer

Responsibilities:

• Effort estimation of the forecasted work based on High level scope.
• Participate and provide views in the preliminary and conceptual design reviews.
• Writing detail design and ensure coverage of entire scope.
• Presentation of the above stated deliverables to the Project and Business Teams.
• Analysis and Management of Test Data to be used for unit testing across the flow.
• Develop a code to satisfy business requiremnt.
• Develop an efficient and reliable code for multipurpose.
• Develop a plan which can be used for multiple platforms to be used for their data loading purpose.
• Give review to the project team for optimal utilization of CPU.
• Provide KT to QA team.
• Provide resolution for query raised by QA team.
• Provide KT to support team.
• Helps in installation of project.
• Handles post production defects on urgent basis.
• Provide resolution for defect raised by QA team .Defect
• Status reporting and co-ordination with customers.
• Contribution to Knowledge Management initiatives.
• Gain good exposure to mainframe technology

Solution Environment: Unix, Ab Initio,Db2, SQL, ALM,MVS