SUMMARY

• 9+ years of total work experience with 5+ yearsinonshorein ETL Informatica testing, Big Data Testing in Hadoop using Pyspark & Unix, working on Quality assurance and Software testing methodologies. Also having anexposure of software development and business data analysis.
• Analytical skills comprising of analyzing PL/SQL Queries to derive the root cause analysis for complex data marts and derive a data relationship based out of Data Warehouse Fact and Dimension tables.
• Develop and execution of PL/SQL Queries (Select, Union, Joins, Minus, Rank, Analytic functions to name a few) and Oracle Functions/Procedures and Packages used in the data marts.
• Test Hadoop - Bigdata using pyspark, hive ql, python scripting, and Unix shell scripts.
• Good Knowledge in ETL (Extraction, Transform and Load) process for Data warehouse tools using Informatica v9+loading data in Oracle Database.
• Tableautestingexperience and reporting skills.
• QA processes and standards, Software Testing Methodologies, Development of Test Cases, Design and Execution of strategic Test Plans and Test Scenarios.
• Test Automation in QA phase, knowledge in Selenium& production monitoring.
• As an Onshore Test Lead, involved in preparing Baseline estimations for the projects using Agile based Planning Poker methodology.
• Defect management using Agile Central /ALM Quality center.
• Working in SAFe AGILE environment, creating user stories, facilitating Sprint planning & retrospective.
• Test Automation using ACT (Automated Control Testing) and helped building framework for Hadoop Automated testing.
• Being an interface between business teams and the design, development, QA stakeholders.
• Hands on experience in business consulting, sql analytics and application development with excellent skills in client interfacing, requirement gathering, gap analysis, Regression testing, functional testing, user support, user interface designing, quality assurance, problem solving, and documentation.
• Prepare the Test Requirement Analysis, Test Strategy/Plan document, Requirement Traceability Matrix, Test Case Design, Test script preparation, performed functional testing, Test Results and conducted Test review with the stakeholders.
• Code Development and debugging experience using C and Java in Visual Studio and Eclipse.
• Excellent conceptual and working knowledge of Software Development Life Cycle such as Agile, Scrum, Waterfall and (Unified Modeling Language) UML Methodologies.
• White box testing, database testing, backend testing, SQL, XML.
• HP ALM Quality Centre, Agile Central, Tortoise SVN, Clearcase, Subversion, Atlassian JIRA.
• Experienced in creating and maintaining high quality documents - Business Requirements Document (BRD), Functional and Technical Specification Documents, Requirements Traceability Matrix (RTM), Data Mapping and Transformation logic documents, Change Control document, RACI Matrix etc.
• Unit testing, Functional testing, User Acceptance Testing, Integration testing, System testing, Performance testing, Sanity testing, Exception testing, Compatibility testing & Security testing.
• Analysis and troubleshooting of data oriented issues reported on Informatica and UNIX servers.
• Strong interpersonal skills, highly adept at diplomatically facilitating discussions and negotiations with stakeholders.
• Experience in Customization and QA in Siemens PLM tool Teamcenteras well.
• Worked on business critical projects to deliver solutions within tight deadlines.
• Performing UAT (User Acceptance Testing) to make sure that all the user requirements are catered by the application.
• Experience in XML, XSL/XSLT, TCL scripts for data transfer and transformation.
• Positive team player with good interpersonal skills and the ability to work in team.
• Ability to rapidly learn new concepts with excellent interpersonal and problem solving analytical skills.

TECHNICAL SKILLS

Tools: Toad for Oracle/ Hadoop, SQL Developer, Putty, Informatica v9.6/10, HP-Quality Center, AGILE Central (Rally) Teamcenter, Visual Studio, Eclipse, SQL Server.

Technology, Computer Languages: PL\SQL, hive ql, C, Java, XSLT. TCL, Batch Scripting, XML.

Version Control System: Clear case, Mercurial, Tortoise SVN, Source Tree.

Others: SAFe AGILE certified, Windows 2007, 2010, XP, SCRUM based project, MS-Visio, MS-Project, MS-Word, MS-Excel, Microsoft SharePoint.

PROFESSIONAL EXPERIENCE

Confidential, CT

QA Lead

Responsibilities:

• Developing Test Strategy, develop test scripts in Oracle.
• Functional, Regression and Production Checkout validation in SQL and Hadoop - Bigdata.
• Validating DDL, Count, Not Null, ReferentialIntegrity, Data Check.
• Validating the code built in Hadoop using Python, Pyspark& Unix.
• Test Automation using ACT (Automated Control Testing) and helped building framework for Hadoop Automated testing.
• Reporting and tracking defects using HP Quality Center and AGILE Central.
• DataModel changes to match the user requirement.
• Gathering business requirements from business users and the product owner.
• Understanding the code/logic for the old system logic and creating mapping logic to replicate them into new system.
• Creation of Functional Specification Document (FSD), Source to Target Mapping documents for Data modeling and development purpose.
• Working in analyzing the data, functionality and relation between fact/dimension layers.
• Data profiling while analyzing the data for legacy systems.
• Writing and managing user stories in Rally.
• Scrum planning meetings to coordinate between Clients, Product Owner, Development and QA teams.
• Coordinate with the stewardship team for the data model changes.
• Guiding the team in documenting the current AS-IS process and identifying business use cases.

Environment: SAFE AGILE-SCRUM based project, Tableau, Toad for Oracle / Toad for Hadoop, Putty, AGILE CENTAL (Rally) Microsoft SharePoint, and Oracle 12c, PL/SQL, SVN, HP Quality Center.

Confidential, CT

QA Lead

Responsibilities:

• Developing Test Strategy & Test plan.
• Working on Functional Testing by writing test use cases and sql scripts.
• Testing of metadata, constrains, duplicate, null, orphan, data check etc.
• Reporting and tracking defects using HP Quality Center.
• Review the test scenarios and Test script developed by offshore team.
• Work with BDA and Developers to resolve critical issues found during QA phase
• Managing Defect Triage calls.
• Working on Daily job run, Informatica power center workflow monitoring and feed generation.
• Data analysis and Test Tableau reports.
• Coordinate between multiple teams (Functional Team / Delivery/ QA) and hosting daily calls to resolve the issues for the Linkage /E2E Testing.
• Involved into Test Automation.
• Working with business users to understand the requirement and analyzing the data, functionality, relation.
• Gathering requirements from business users.
• Creation of System Requirements Specifications (SRS), mapping document with Source to Target Mapping.
• Managing requirement change workflows like Change Request arising due to critical bugs.

Environment: Toad, Informatica Power center, Autosys, PL/SQL, Tableau, MS-Visio, MS-Project, MS-Word, MS-Excel, Microsoft SharePoint, and Oracle 11 g, HP Quality Center

Confidential, NY

Sr. ETL Tester

Responsibilities:

• Responsible for understanding the requirement and creating test scenarios.
• Creating test cases and test script using PL/SQL.
• Responsible for front end testing, web services using SOAP UI and ensuring data integrity between various communicating APIs.
• Review test cases/ scripts from offshore team member.
• Reporting and tracking defects using HP Quality Center and atlassian JIRA.
• Managing a team of 4 at offshore (in India), which involves planning, task creation and allocation and reporting current status to all stakeholders.
• Creation of System Requirements Specifications (SRS), Data Requirements (DRD) Source to Target Mapping (STTM) documents for Data modeling and Data Lineage purposes.
• Writing Business Requirement Document (BRD).
• Working with business users to understand the requirement.
• Working in analyzing the data, functionality and relation.
• Data Model changes to match the user requirement.
• Guiding the team in documenting the current AS-IS process and identifying business use cases.
• Single point of contact (SPOC) for Onshore-Offshore Coordination involving test planning, monitoring and task allocation.

Environment: Waterfall, MS-Visio, MS-Project, MS-Word, MS-Excel, Microsoft SharePoint, and Oracle 11 g, PL/SQL, JIRA, Tortoise SVN,HP Quality Center

Confidential, MI

IT QA Analyst

Responsibilities:

• Responsible for understanding the business process and documenting business process flow diagrams
• Responsible for developing test cases & test scripts
• Responsible for Functional,Integration, End to End regression, Smoke & Production check out testing.
• Planning, managing and leading the Quality Assurance activities.
• Reviewing QA use cases and test scenarios before execution.
• Conducting peer review sessions for Development, Testing, User Interface and Business team for approval, suggestions and sign off.
• Interface / connectivity testing, performance testing, security testing, UAT test documentation and production certification test documentation.
• Daily and Weekly Status Reporting and Live Presentations to clients for Project Status Review and Risk Analysis.
• Conducting JAD (Joint Application Development) sessions with the development team to define the technical solutions.
• Handling defect management. I.e. Defect Reporting, Verification and Defect Analysis Reports using Quality Center.
• Coaching junior team members (developers, QA team members) on User experience/ Usability best practices.

Environment: MS-Word, MS-Excel, Microsoft SharePoint, and Oracle 11 g, Toad, PL/SQL, Quality Center, ClearCase, Sourcetree, XML

Confidential, TX

Sr. QA Analyst

Responsibilities:

• QA processes and standards, Software Testing Methodologies.
• Development of Test Cases, Design and Execution of strategic Test Plans and Test Scenarios.
• Reporting and tracking defects using HP Quality Center and JIRA.
• Performing cross browser, functional performance and smoke testing during testing phase.
• Helped in UAT (User Acceptance Testing) of the new system.
• Analyzing and coordinating multiple projects from the initiation to the deployment.
• Working in ETL - Data warehouse tool - Informatica - Backend testing.
• Desktop application Testing.
• Managing a QA team of 3 at onshore 2 at offshore.
• Managing scrum events such as sprint planning, task creation, retrospective.
• Worked in preparing planning documents and reports.
• Scrum planning meetings to coordinate between Clients, Product Owner, Development and QA teams.
• Involvement in requirement gathering from client, creating and executing test scenarios and test cases.
• UML - Use case Diagrams, Activity Diagrams, Sequence Diagrams and Class Diagrams.
• Interacted with fellow developers, UI designers and UX to make sure that application is being built according to user/client expectation and made sure of the timely software delivery.
• Involvement in complete software development life cycle documentation; from requirement gathering to post production launch of the application.
• Trained business users to learn the new functionalities.
• Helped in Server side and Client Side code development, writing utilities in PLM platform using C, C++, Java.
• Worked in MS Office (MSWord, MS Excel, PowerPoint etc.)

Environment: SCRUM based project, MS-Access, MS-Project, MS-Word, MS-Excel, Microsoft SharePoint, and Oracle 11 g, PL/SQL, ClearCase, JIRA, Sub-version, HP Quality Center, C, and Java SWT, ETL - Informatica.

Confidential

Systems Engineer

Responsibilities:

• Involved in gathering requirements from client.
• Responsible for writing and executing test cases.
• Helped in UAT (User Acceptance Testing) and resolve the Issues for UAT users.
• Helped in developing and run the Migration utility using C, ITK to migrate data into production system.
• Preparing Documents (User Manuals, Test documents etc.)
• Post migration, verification & testing of the migrated data in Teamcenter.
• Provided Technical support and trained end users. creating use case diagrams, business process flow diagrams, activity/state diagrams using MS Visio so that developers and other stakeholders can understand the business perspective
• Use case Diagrams, Activity Diagrams, Sequence Diagrams and Class Diagrams.

Confidential

Developer/ Tester

Responsibilities:

• QA processes and standards, Software Testing Methodologies, Development of Test Cases, Design and Execution of strategic Test Plans and Test Scenarios.
• White box testing, database testing, backend testing, SQL, XML.
• Involved in full project life cycle involving Requirement Analysis, Design, Coding, Testing and Implementation phases.
• Preparing Requirement document, Use Case diagram, System Design Document.
• Prepared other documents like User Manual etc.
• Responsible for the coding/ development of new systems and usability enhancements, Data Model changes.
• Involved in Deployments of code and binaries to the new system.
• Development of PDF Report using XSL (Extensible Stylesheet Language).
• Bug Fixing and providing technical support.
• Attending Onsite and client calls for daily /weekly status updates.
• Actively involved in Software Test Life Cycle processes throughout the tenure; developed user interfaces and server side programming using c, Java SWT.

Confidential

Developer/ Tester

Responsibilities:

• Performed Unit testing and Integration testing.
• Customer interaction to get the requirements.
• Preparing Design documents for small implementation and other docs such as User manual.
• Provided Support to Users.
• Involved in writing test scripts and executing the test cases.
• Portal Customization and bug fixing.
• Code server side (using C, ITK, Java) customizations.
• Run though the workflow processes to support users.
• Create standalone procedures to execute the validation checks.
• Coordinating with onsite team, client & status reporting & timely documentation of the process.