SUMMARY

• Over 5+ years of experience Software Quality Assurance.
• Experience testing Data Warehouse (ETL & BO), Database, Web, Client - Server Systems Applications in Finance, Insurance & Retail Domains.
• Handled multiple roles ETLQAAnalyst,QATester.
• Expertise in Analyzing Business Requirement, Functional Requirement, Design specification and Developed Test plan, Test Scenarios & Test Cases in every release on all phases of SDLC, STLC.
• Experience in software development methodologies like Water fall and Agile development model.
• Experience in working in Agile-scrum methodology having understanding ofQAprocess in agile environment.
• Responsible for requirement gathering from the Business Analyst's and for preparing the test scenarios using Agile Methodology (SCRUM).
• Experience on System Integration, Functional, Regression UAT and Migration Testing of various Web ETL Applications.
• Experience in using Eclipse, Pycharm, Visual Studio, Pyscripter and SublimeText while developing different application in python.
• Created Traceability matrix to ensure that all the requirements has been covered.
• Experience in testing of Data Warehouse/ETL Applications tested in Informatics, Data stage, SSIS using SQL Server, Oracle, Linux.
• Expertise in testing several Obiee, BO Reports for several business needs including Dashboards, Drill-Down, and Master-Detailed.
• Experience in Validated the end-to-end business intelligence solution by Testing metadata and OBIEE Analytics Repository consisting of three layers (Physical Layer, Business Model & Presentation Layer).
• Extensively used Automated Test Tools such as Quick Test Professional (QTP), Win Runner, Load Runner, and HP ALM.
• Expertise the Application Structures and Functionality for White Box and Black Box testing Usage of Trackers / Bug Reports, HP Quality Centre,HP ALM& Rational Clear Quest.
• Familiar with concepts of SQL queries ranging from DML, DDL and DCL.
• Worked on various range of platforms such as flavors of UNIX, Linux, AIX, Solaris and Dos.
• Active participation in decision making andQAmeetings and regularly interacted with the Business Analysts, development team to gain a better understanding of the Business Process and Requirements.
• Experience with Design, code, and debug operations, reporting, data analysis and web applications utilizing Python.
• Good communication, interpersonal skills, self-motivated, quick learner & team player.

TECHNICAL SKILLS

Programming Languages: C++,Java,C, T-Sql, PL/SQL

UI Technologies: Winforms, WPF, Jquery UI, Kendo UI

IDE Tools: Visual Studio 2013/2010/2008, Sql Server Management Studio

Frameworks Springs: Qt, VC++, MFC, QML

Databases: MS SQL SERVER 2008R2/2005,MSAccess 2010/2007,Oracle10g/9i

Reporting Tool: Sql Server Reporting Services, Crystal Reports 2010/9.

Modeling Tools: UML,MS Visio

Operating Systems: Windows, UNIX, Linux.

Version Control Tools: Visual SourceSafe, Sub-Version, Team Foundation Server

Middleware: WCF, MSMQ, Web Services, Enterprise Library 5.0/4.0/3.1

Servers: Windows Server 2008/2003,Microsoft IIS(7.0/6.0)

PROFESSIONAL EXPERIENCE

ETL/QA Tester

Confidential, CA

Responsibilities:

• Interacting with Business Analysts and Development teams to understand the business requirements and giving the estimates from testing prospectus
• Test plan preparation, preparing daily status reports and defect reports.
• Involved in prioritizing the requirements according to business needs and putting all the requirements in QC.
• Create custom built reports from the Control-M batch server.
• Involved in writing and executing the test cases and involved in Defect reporting and verification.
• Involved in identifying the cause of Defect and reporting the same to developers.
• Validating the data between Oracle Tables and SQL Server Tables by using SQL Statements.
• Testing the data present in fact tables and dimensions tables.
• Involved in User Interface Testing and Web Services Testing using Soap
• Involved in HUT (Hard unit testing), SIT (System Integration Testing) and WIL (Week in Live Testing) Testing.
• Used SQL Teradata Assistant for data retrieval from Teradata.
• SOA testing was done on top down approach basis.
• Used QTP for Checkpoints, Regular Expression and Accessed Data Tables for multiple applications.
• Involved in writing test scripts and functions in Test Script Language using QTP for automated testing.
• Tested all the entities like customer records, payment records has been loaded target database according to its own table structure during the migration process.
• Tested database integrity referential integrity and constrains during the database migration testing process
• Attending defect triage meetings.
• Control-M agent accounts, and trouble-shooting Control-M production errors and coordinating with vendor when necessary.
• Wrote PL/SQL /Complex SQL queries for system testing.
• Performed data quality test to determine whether processed data is correctly extracted, transformed and loaded.
• Used reusable actions with utilizing the flexible functionalities in Quick Test professional
• Extensively executed SQL queries in order to view successful transactions of data and for validating data.
• Written complex SQL queries for validating the data against different kinds of reports generated by Business Objects XIR2
• Tested the Business Objects Universe and validated Business Objects Reports using backend testing
• Responsible for reporting and escalating data issues arising from project or daily support.
• Involved in Defect prevention, productivity improvement and knowledge management activities
• Preparing metrics and reports.
• Documenting test procedures, test plans, test cases and test results.
• Wrote complex SQL syntax using case, having, connect by etc

Environment: HP Quality Center, HP QTP, Oracle 10g, SQL, PL/SQL, SSIS, SQL Server 2008, Quality Center, Business Objects, MVS, ISPF, VSAM Files, Flat Files, XML Files, SOAP, SOAPUI, Web Services, Shell Scripting, PERL, XML, XSD, TOAD, Win SQL.

QA Tester

Confidential, Pittsburgh, PA

Responsibilities:

• Analyzed the Functional Specifications by interacting with business analysts and developers.
• Analyzing the Test Plan based on Business Requirements, which describes the testing scope, strategy, test requirements and necessary resources.
• Involved in developing detailed test cases based on use cases for manual tests as well as automated tests.
• Involved in developing test cases, test scripts, test data, executing the scripts and logging the defects.
• Involved in Functional, Integration, Regression and User Acceptance Testing (UAT).
• Responsible in developing Test Cases with ALM using it as a Test Management Tool.
• Created Requirements Traceability matrix to make sure there is no gap between requirements and test coverage.
• Extensively performed backend database testing for data integrity.
• Used TOAD to write complex SQL queries for validating data in the reports based on each and every business rule.
• On a daily basis, used UNIX commands for activities such as transferring files between directories, executing scripts, checking log files etc.
• Extensively used ALM for Test Planning, Bug tracking and Reporting.
• Provided a weekly project report that includes Test Metrics and status reports.
• Participated in meetings with developers to discuss enhancements and Modifications.

Environment: Java, Oracle 11g, Windows 8/XP, UNIX, XML, TOAD, JIRA, ALM, Quick Test Pro.

QA Tester

Confidential, Dallas, TX

Responsibilities:

• Worked closely with the Developers, Analysts, and Architects for knowledge sharing and to resolve issues during scrum sessions using Agile Methodology.
• Showed Ambiguity/doubt Analysis with Business Analyst and Development Team and Business.
• Monitored and tracked defects and managed through resolution using ALM/Quality Center.
• Executed the transactions manually and verify the back end functionalities and data exploitation.
• Wrote complex queries for data validation/justification using SQL statements.
• Developed Web Service Test with Soap UI to test SOA platform.
• Execute written test case scenarios, including manual, automated, and data-driven regression testing, and GUI verification by using Quick Test Professional (QTP).
• Involved in Mobile Computing testing with Windows OS, iPhone, iPad and Android Essentials including cross-browser testing.
• Maintained the GUI objects in the shared object repository by using Object Repository Manager in QTP and performed compatibility testing
• Used JIRA bug tracking tool to analyze & capture bugs, track and manage dashboard any type of updates for project release.
• Performed browser compatibility and configuration testing on various operating systems such as Blackberry OS, Android OS, and IOS etc.
• Managed and led the testing process to meet project release deadlines.
• Interacted with developers, discussed technical problems, provided feedback concerning completeness and reported bugs.
• Participated in weekly project status meetings with the management team and walkthroughs.

Environment: QTP/UFT, Quality Center (QC), Mainframe, Android, IOS, HP/ALM, IBM DB2, Emulator, Jira, TFS (Team Foundation Server), MTM, Visual Studio Test Manager.

ETL Test Engineer

Confidential

Responsibilities:

• Understanding the specifications for Data Warehouse ETL Processes and interacting with the data analysts and the end users for informational requirements.
• Involved in preparation of Test Plan and test strategy for DWH testing.
• Prepared Manual Test Suites for various modules data validation.
• Focused on Data Quality issues / problems that include completeness, conformity, consistency, accuracy, duplicates, and integrity.
• Written SQL queries, stored procedures in order to data validation in migration as part of backend testing.
• Tested stored procedures & views in Toad using SQL/PLSQL.
• Worked with Data Completeness, Data Transformation, Data Quality and Integration Testing for different line of feeds.
• Prepared test cases for data validations between Data Mart to data cubes.
• Involved in extensive DATA validation using SQL queries and back-end testing
• Worked with developing advanced SQL queries to extract, manipulate, and/or calculate information to fulfil data and reporting requirements including identifying the tables and columns from which data is extracted.
• Used FTP and Telnet protocols in order to migrate files to heterogeneous Operation systems like UNIX, Linux and windows.
• Worked with UNIX scripts in executing and validating logs for the issues.
• Involved in KT sessions for new joiners to ramp up them.
• Validated all the jobs and successfully system tested the jobs
• Involving in Functional testing, End to End testing and Regression Testing.
• Preparing and supporting the QA and UAT test environments.

Environment: Informatica power center 8.X, Quality Center, MS Excel2003/7, SQL/PLSQL, UNIX, Windows, Oracle 9i, Teradata, TOAD, Flat files.

QA/Tester

Confidential

Responsibilities:

• Analyzed the top-level requirements for software functions for each Business Process.
• Worked with Business Analysts and Developers to understand the business needs and functional requirements.
• Involved in different phases of the project life cycle.
• Developed test plans and written test cases as per the business and technical requirements.
• Developed and maintained Requirement Traceability Matrix (RTM).
• Involved in both Back-End and Front-End testing.
• Primary Role in maintaining Test Plans.
• Developed Regression test cases.
• Reviewed and validated newly added functional test cases.
• Clarified test strategy and data reuse strategy.
• Responsible to conduct Smoke Test and Regression Test in different Environments.
• Prepared testing reports.
• Supported and coordinated overall testing efforts.
• Used JIRA application to create and modify defects, change requests, enhancements.
• Used Quality Center for Test Plans and Test Cases.
• Involved in daily walkthroughs and inspection meetings, to verify the status of the testing effort and the project as a whole with the Requirements team, Development team and Project Management team.

Environment: Oracle 10g, Windows XP, Atlanssian JIRA, Microsoft Access, Microsoft Excel, Putty, XML Viewer, Quality Center.