SUMMARY

• To seek a challenging career as an QA/ETL//Backend Tester and implement SQA Principles in Software Development in areas of Data warehousing, Data Mining, Data Loading, Client Server technology, Object Oriented Development, Web applications, eCommerce and B2B solutions.
• 7 + years of diversified experience in, Development, Analysis & Software Quality Assurance testing.
• Involved in Manual and Automated Testing of applications on UNIX and Windows Environment for both Server side and Data warehousing Applications.
• Experienced in Automation testing using the WinRunner, Quick Test and Load Runner.
• Experience with QA Methodology to ensure the Quality Assurance Control.
• Excellent skills in TeraData, DB2, SQL Server and Oracle 9i/8i RDBMS..
• Strong in Analyzing Business spec Requirements & Develop comprehensive test Spec & execute them.
• Experienced in testing Web applications and client/server applications
• Experience in testing and writing SQL and PL/SQL statements.
• Experienced in all phases of Systems Development Life Cycle (SDLC), including requirements analysis/design, development and testing
• Extensive testing ETL experience using Informatica 8.5/ 8.1/7.1/6.2/5.1 (Power Center/ Power Mart) (Designer, Workflow Manager, Workflow Monitor and Server Manager).
• Expert in PERL, UNIX Shell Scripting
• Performed backend database testing by writing SQL and PL/SQL scripts to verify data integrity
• Experience in writing System test plans, defining test cases, developing and maintaining test scripts according to the business specification given.
• Experience in testing and writing complex SQL, T - SQL and PL/SQL statements.
• Experience in using Automated Tools like WinRunner, Test Director, Load Runner and JTest in Client /Server, Web, Database, API and GUI Testing.
• Extensive experience in writing SQL and PL/SQL scripts to validate the database systems and for backend database testing
• Experience in Web and Object Oriented Technologies
• Ability to interact with developers and product analysts regarding testing status
• Expertise in Problem solving and Tracking Bug Reports using Bug tracking Tools.
• Exposure to different operating systems like Windows 95/98/00 and NT and UNIX.
• Responsible for mentoring resources technically and training other QA Team Members.
• Knowledge in Networking Protocols like TCP/IP, HTTP, and SMTP & Network Routers & Data switches.
• Performed backend testing using SQL Queries and UNIX SHELL SCRIPT
• Expertise in Developing Client/Server applications using Visual Basic, Active Server Pages, Oracle 8i

TECHNICAL SKILLS

Testing Tools: Quick Test Pro, Win Runner, Test Director, Load Runner, Visual Test, Silk Application Stress Tool (WAS)

Languages/GUI tools: C/C++, Java, SQL, HTML, Java Script, Visual C++, Visual Basic and Visual Café.

ETL tools: Informatica 8.5/ 8.1/7.1/6.2/5.1 (Power Center/ Power Mart)

Databases: SQL Server, Sybase, Oracle and MS Access 97

Web Servers: MS-IIS 5.0, Apache 1.3.9, MS Commerce Server 2000

Application Servers: JRun 2.33, Web Logic 7.x, Web Sphere 6.xOperating Systems MS-DOS, UNIX, Windows 95/98/ NT/2000, Win2K Advanced Server, Novell NetWare

Configuration Tools: CVS, PVCS, Rational Clear Case, MS Visual Source safe

Knowledge: RS-232 Comm. Protocols, COM/DCOM, TCP/IP

PROFESSIONAL EXPERIENCE

Confidential, Richmond, VA

SQL/Web/BackendTester

Responsibilities:

• Worked on Data Reconciliation for multiple feeds using Infogix tool.
• Performed Functional Testing and Back-end Testing using the database comparable results Manually.
• Tested the Front-End Web Applications developed in J2EE for data portal for matching
• Worked on Execution Tracker, Test Design Tracker & Defect Metrics.
• Did complex data validation using SQL queries.
• Independently designed and developed project document templates based on SDLC methodology.
• Written several complex SQL queries for data verification and data quality checks.
• Implemented Database Checkpoints for Back-end Testing
• Performed the Back-end Integration Testing to ensure data consistency on front-end by writing and executing SQL statements.
• Tuned ETL jobs/procedures/scripts, SQL queries, PL/SQL procedures to improve the system performance.
• Worked with Compatability Testing for Browser, Operating, Mobile & Printing options for Web Apps
• Extensively used T-SQL to verify and validate the data loaded to the SQL Server 2005
• Written several shell scripts using UNIX Korn shell for file transfers, error log creations and log file clean up process.
• Experience in working independently and multi task without negative impact to timelines or quality.
• Strong Knowledge on the phases of Software Development Life Cycle (SDLC) Methodology.
• Wrote complex SQL, PL/SQL Testing scripts for Backend Testing of the data warehouse application
• Tested Functionality Testing, Usability testing and Interface testing for mulitiple Web Applications created in Java
• Load new or modified data into back-end Oracle database.
• Review the test cases written based on the Change Request document.
• Testing has been done based on Change Requests and Defect Requests.
• Preparation of System Test Results after Test case execution.
• Experienced in writing UNIX script
• Tested the SAS jobs in batch mode through UNIX shell scripts
• Tested and Automated SAS jobs running on a daily, weekly and monthly basis using Unix Shell Scripting.
• Involved in the design of web application using HTML, DHTML, Cascading style Sheets Java script and ASP.
• Involved in developing Unix Korn Shell wrappers to run various Ab Initio Scripts.
• Experience in preparing the traceability matrix, test scenarios and test cases.
• Worked as ETL Test Analyst and responsible for the requirements / ETL Analysis, ETL Testing and designing of the flow and the logic for the Data warehouse project.
• Perform defect Tracking and reporting with strong emphasis on root-cause analysis to determine where and why defects are being introduced in the development process.
• Used/Tested ADO.NET for the storage and the retrieval of data from the database
• Tested data migration to ensure that integrity of data was not compromised.
• Experienced in writing complex SQL queries for extracting data from multiple tables.
• Review the test cases written based on the Change Request document.

Environment: Ab Initio, (GDE 1.14, Co>Op 2.14), MS SQL 2008/2005, HTML, .NET, ASP.NET, VB.NET, Oracle 9i, Perl and UNIX Shell Scripting, TOAD 7.0,, SAS/SQL, UDB DB2,, Rational Clear Case,J2EE, Java, XML, XSD, SQL, PL/SQL

Confidential

Backend/WEB/SQL Tester

Responsibilities:

• Performed Black-box testing, White-box testing, System Testing, Data Integrity Testing, Sanity, Regression and end-end testing
• Developed business process models in RUP to document existing and future business processes for the data warehousing.
• Developed and documented data Mappings/Transformations, and Informatica sessions as per the business requirement. Involved in the development of Informatica Mappings and also tuned them for better performance
• Experience in UNIX Shell Scripting and Python scripting
• Solid testing experience in working with SQL Stored Procedures, triggers, views and worked with performance tuning of complex SQL queries.
• An extensively used Complex SQL statement for retrieving data using TOAD and it is used in TSL scripts.
• Extensively worked on the Console application and to bring the output of the console application to in corporate in to the web application.
• Tested the outgoing links from all the web pages from specific domain.
• Worked with Python control structures & Regular Expressions for substitutions based on matches.
• Tested all the internal links and tested links jumping on the same Web page
• Worked with Python for file manipulations
• Collected user requirements from various stake-holders for the data warehouse.
• Very strong SQL skills and experience with OLAP. Expertise in data-driven testing, drill down applications, writing test cases and test scripts
• Used T-SQL for Querying the SQL Server database for data validation and data conditioning Experienced in data analysis using SQL, PL/SQL and many other queries based applications.
• Tested to check if there are any orphan pages and tested all the validations on each field.
• Involved in the error checking and testing of the ETL procedures and programs Informatica session log.
• Tested existing Data web application from classic ASP and VB6.0 to VB.NET, ASP.NET, C# (.NET Framework 3.5), SQL Server 2005.
• Strong ability in developing advanced SQL queries to extract, manipulate, and/or calculate information to fulfill data and reporting requirements including identifying the tables and columns from which data is extracted
• Prepared SQL scripts for test data preparation for Back End functionality testing
• Performed back up project management duties.
• Tested Cookies for all user machines and maintained the session for login sessions.
• Tested the ETL Informatica mappings and other ETL Processes (Data Warehouse Testing Involved in extensive DATA validation using SQL queries and back-end testing
• Used SQL for Querying the DB2 database in UNIX environment
• Tested the Oracle Applications and Portals like Executive Dashboard, CIE Portal built on Oracle. Used TOAD Software for Querying ORACLE.
• Created, Modified and Debugged the test Scripts and Performed data Driven Testing. Tested Analytical Data Mart (ADM) of Oracle system and Stored Procedures
• Prepared and ran regression scripts, shell scripts and performed sanity tests and end-end testing.

Environment: Informatica Powercenter 8.1,Tibco Business Works, IBM ODS/DWL, J2EE, XML, HTML, XSD, Java Script, AIX, Mercury Quality Center 8.2 (Test Director), DB2,Quick Test Pro 8.2, IBM DB2, Autosys, Oracle 10g, Rational Clear Case, Mercury ITG Governance, HTML, .NET, ASP.NET, VB.NET, C++, Oracle Warehouse Builder, Discoverer, Data Profiler

Confidential, Charlotte, North Carolina

QA ETL /Analyst

Responsibilities:

• Tested the data coming through various lines of business of Bank of New York such as Capital Funding, Venture Capital, Trust Accounting System, Bank Owned Life Insurance etc.
• Coordinated component, system testing with the appropriate technical groups and Release Management and documented test procedures and findings.
• Reconciled test results from different tests and different groups. Assessed readiness and deviation of product/project performance based upon test results and product specifications.
• Validated the data of reports by writing SQL queries in PL/SQL Developer against ODS.
• Worked on profiling the data for understanding the data and mapping document.
• Extensively used ETL methodology for testing and supporting data extraction, transformations and loading processing in a corporate-wide-ETL Solution using Informatica
• Performed the tests in both the SIT, QA and contingency/backup environments
• TOAD is used to perform manual test in regular basis. UNIX and Oracle are using in this project to write Shell Scripts and SQL queries
• Converted SQL queries results into PERL variable and parsed the same for multiple reasons.
• Developer Regular Expressions using PERL for parsing needs.
• Extracted certain column of data from a number to files using PERL
• As QA Tester, performing responsibilities with both the functionality and back end testing.
• Wrote complex SQL, PL/SQL Testing scripts for Backend Testing of the data warehouse application.
• Involved in extensive DATA validation using SQL queries and back-end testing
• Used SQL for Querying the DB2 database in UNIX environment
• Responsible to design, develop and test the software (Informatica, PL SQL, UNIX shell scripts) to maintain the data marts (Load data, Analyze using OLAP tools).
• Used various checkpoints in the Informatica designer to check the data being transformed
• Prepared and ran regression scripts, shell scripts and performed sanity tests and end-end testing.
• Wrote SQL queries for each Test case and executed in SQL Plus to validate the data between Enterprise Data Warehousing and Data Mart Staging Tables.
• Performed backend database testing by writing SQL and PL/SQL scripts to verify data integrity.
• Tracked all testing results for management, categorizing issues and created/distributed trouble reports and managing defect listings
• Worked with Business Objects Reports for validating the data. Compared results against backend.
• Developed manual and automated test cases and Quick Test scripts to test the functionality of the applications and generated Test Scripts and automated it for future use in Quick Test.
• Written Test Plans for Various Applications on the Portal.
• Created Source Management Documentation.
• Tested in Development, Staging and Production Environments.
• Automated Apps using Quick Test.

Environment: ETL (Informatica 7.1, Power Center/Power Mart), XML, Perl and UNIX Shell Scripting SQL, PL/SQL, TOAD, WinSQL, Tibco Business Works, IBM ODS/DWL, Unix, Linux, AIX, Mercury Test Director 7.x, DB2, HTML, .NET, ASP.NET, VB.NET, C++, Oracle 10g, .NET, VB.NET, Rational Clear Case.

Confidential

Responsibilities:

• Designed Test scripts and test cases in Test Director and MS-word.
• Generated automated test cases on first build of the module using Win Runner, Rational Tools.
• Involved in the design and development of the web application.
• Participated in design reviews, Involved in making recommendations where appropriate.
• Participated in development and validation of entrance and exit criteria for each phase of testing of applications.
• Responsible for developing test plans and test cases using standards defined by the project.
• Performed backend testing using SQL queries and various other tests such as user acceptance, integration, system and regression testing on the new build of the application.
• Documented the modification requests for all the bugs detected and tracking the bug fixing process until they were closed.