SUMMARY:

• 12+ years of Strong experience Testing(Automation Functional, Integration, Data Ware House and ETL testing, Regression testing and UAT based) in Enterprise applications with multiple technologies .
• Good Knowledge in Hadoop Technologies including HDFS, Pig, Hive, SQOOP,HBASE, Oozie, FLUME, and MapReduce jobs etc..
• 3 + years of Strong experience in Created Automation Project, built operations, binding components, created test scripts, parameterized the inputs, built Test Suites in Rational Integrated Tester(previously known as Green Hat Tester) and SOAP UI.
• 2+ years of Hands on Experienced in ETL testing for the project developed using Data Stage tool.
• Involved in writing complex multi level join queries, used query optimizing techniques and sub queries for faster and better retrieval of data.
• Involved in Requirements testing, Build verification testing, Data completeness testing, Data transformation testing, Data migration testing,, Web services testing, End2End testing, Performance testing, Continues Integration Testing (using Jenkins) and Regression testing.
• Identifying and testing documenting issues and participates in defect remediation Following test case standards and guidelines in ALM.
• Expertise in EW, Banking(Retail and Card), Telecom and Ecommerce domains.
• Participated in JAD Sessions, Estimations and in building best practices for TCOE and across multiple verticals across organization.

TECHNICAL SKILLS:

ETL Tools: Data Stage 8.5

Main Frames: VSAM, GDG, FLAT files, JCLs, ISPF,FMDB,QMF

Testing Tools: Rational Integration Tester, QTP 9.5, QC ALM 11.00, SOAP UI

RDBMS: Oracle 11g, MySQL, DB2

Scripting: VB Script, shell, groovy

Operating Systems: Solaris, Red Hat Linux, Ubuntu, CentOS, Suse Linux, IBM AIX, WINDOWS 8.0

Web Technologies: Websphere6.1, Apache Tomcat, SUNONE, BEA Web logic

Domain Knowledge: EW, Network Adapters, CCM, Telecom, MS Learning, Banking

Management Tools: Confidential Excel, Power point, Visio and Project, Ralley, Visio, SSH Techa

PROFESSIONAL EXPERIENCE:

Confidential

Test Lead

Environment: TSYS, SOPAUI, Rational Integration Tester

Responsibilities:

• Created Automation Projects, built operations, binding components, created test scripts, parameterized the inputs(with test data), built test suites in Rational Integrated Tester( reviously known as Green Hat Tester) and SOAPUI.
• Provided Estimations, budgeting of my modules, requirement capturing and participated in Triage calls.
• Written Test plan, Test cases, Execution, updating of Regression Test suite, execution of smoke test etc.
• Built Strong Banking Domain Knowledge on Credit Cards and Deposit Modules.
• Used SVN to create and update the project though Check out and Check in the changes.
• Involved in Estimations, requirement capturing and budgeting of my modules.
• Conducted onshore/offshore meetings and tracked project progress, issues, captured lessons learned and worked towards defect resolution.
• Perform responsibilities of developing test scripts by using SOA test tools.

Confidential

QA Manager/ Sr. Analyst

Environment: Data Stage 8.5, Mainframe JCLs, Autosys Mainframe DB2 tables and NonDB2 file.

Responsibilities:

• Involved in functional study of the application and Running the jobs/Workflows for ETL process.
• Prepared Test plan and Test approach documents .
• Involved in Designed, Reviewed & Executed Test cases.
• Prepared and ran SQL queries to verify Dimensional and Fact tables. Verifying the data in target database by ETL process
• Verified column mapping between source and target
• Prepared test data for functional & Integration testing and Interactions with BA & Dev teams to resolve the issues.
• Involved in Requirements testing, Data completeness testing, Data transformation testing, Incremental load testing, BI testing, system integration testing, Load and performance testing and Regression testing
• Defect Analyzing and Reporting in QC
• Executed back - end data-driven test efforts with a focus on data transformations between various systems and a data warehouse.
• Took ownership to get technical trainings (Data Stage and Mainframes) required for project.
• Able to work effectively with multi-disciplined teams and across departments to Identify and formulate strategies customized to specific needs and requirements.
• Built sequential jobs and configured them in Autosys to schedule the jobs.
• Conducted onshore/offshore meetings and tracked project progress, issues, captured lessons learned and worked towards defect resolution.

Confidential

Languages: ASP.net, VB.net

Database: SQL Server 2005

Tools: MS .NET, C#, VB6.0 and ASP.NET,SQL Server 2005.

Responsibilities:

• Involved in preparation of Project Plan, Design documents and submitted for successful sign off.
• Involved in preparation of Estimates and worked closely with client team in resolving any Issues.
• Coded the requirements in .Net environment and uploaded the scripts in VSS environment.
• Worked with Onsite team/business users to validate the system testing and integration testing results.
• Maintained all the documentation in the IT Project management documentation database.
• Prepare and maintain Lessons learnt and best practice documents.
• Conducting final review of the project for successful closure

Confidential

Languages: JAVA and SOA

Database: Oracle10g

Tools: QTP9.5, QC9.0

Responsibilities:

• I traveled to UK for Knowledge transfer, finalizing the requirements and getting their Sign Off. Built Automation Framework using QTP, Prepared Test Plan, Test scripts, Conditioned Test Data,
• Executed Test scripts, Reported Defects, participated in triage calls and got test signoff
• Involved in preparation of Estimates and worked closely with onsite team in resolving discrepancies.
• Identified the Risks (Technical, Process and People) and suggested mitigation for the same.
• Involved in preparation of Test Approach and Test Plan documents and submitted for successful sign off.
• Established Project administrative bench marks and standards.
• Maintained good relationship with client and LOB’s at onshore.
• Got recognition as SMART team lead Award.

Confidential

Languages: Java

Database: Oracle9i, Ingres, SQL Server 2005

Tools: Java, Unix (Sun, HP, AIX) Linux (SuSe, RedHat) Oracle9i &10g, SQL Server 2005, Ingres Websphere6.1, Apache Tomcat, SUNONE, BEA Web logic, QTP 9.1, QC 9.0

Responsibilities:

• Involved in identifying, Automation tool, Automation Scripts.
• Involved in Gap Analysis, and developed an automation effort estimation process that was used by the entire team.
• Build a Functional Decomposition framework from scratch.
• Automated & Executed Scripts in QTP 9.0 from QC and Reported defects.