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 dat all the requirements have 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 wif 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 wif the Business Analysts, development team to gain a better understanding of the Business Process and Requirements.
• Experience wif 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 - Berkeley, CA

Responsibilities:

• Interacting wif 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 have 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 wif 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 wif 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 noledge 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 wif 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 wif ALM using it as a Test Management Tool.
• Created Requirements Traceability matrix to make sure their 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 dat includes Test Metrics and status reports.
• Participated in meetings wif 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 wif the Developers, Analysts, and Architects for noledge sharing and to resolve issues during scrum sessions using Agile Methodology.
• Showed Ambiguity/doubt Analysis wif 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 wif 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 wif 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 wif developers, discussed technical problems, provided feedback concerning completeness and reported bugs.
• Participated in weekly project status meetings wif 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 wif 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 dat 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 wif 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 wif 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 wif 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 wif 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 wif 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.