PROFESSIONAL SUMMARY:

• Over 5 Years of IT experience in ETL Testing, Data Analysis, QA Testing of software systems in Data Warehouse, Client Server and Web-based environments
• Conversant with all phases of Software Testing Life Cycle (STLC), Software Development Life Cycle (SDLC) likeRequirement gathering, Analysis, Design, Development, Implementation, Testing and also with Methodologies like Waterfall and V-model
• Strong Quality assurance skills in the areas of ETL testing, manual testing, automated testing
• Knowledge of Informatica tool and transformations and ERwin Data modeler
• Extracted data from various data sources such as Oracle, MS SQL Server, and Flat files
• Strong knowledge of SQL, PL/SQL (Stored Procedures, packages, functions and triggers)
• Performed Manual, Unit, Integration, Functional, Regression and Acceptance Testing
• Experienced in writing test scripts, preparing test data and creating SQL scripts using stored procedures, functions, PL/SQL
• Extensive knowledge in using tools like Selenium and Load Runner
• Knowledge of Data warehouse concepts
• Performed backend database testing by writing SQL and PL/SQL scripts to verify data integrity
• Strong Knowledge of Data Warehouse Architecture and Designing Star Schema, Snow flake Schema, FACT and Dimensional Tables, Physical and Logical Data Modeling
• Experienced in running SQL queries using Toad, SQL developer and SQL Server query analyzer
• Comprehensive acquaintance in version control tools like Quality Center
• Tested reports generated using CRYSTAL reports
• Ability to work both independently and in team. Versatile team player with strong analytical and problem solving skills and excellent communication/inter personal skills.
• Tested the mappings for Slowly Changing Dimensions
• Well versed in GUI / Front-end testing and Database testing
• Good team player with excellent work history as regards with work ethics, dependability and willingness to go an extra mile

TECHNICAL SKILLS:

• Database: Oracle 11,10g, Oracle 9i, SQL Server, MS Access
• Programming Tools: SQL *Plus, TOAD 10.X, SQL Developer 1.2.1, SQL query
• Analyzer, ERwin Data modeler
• Languages: SQL, PL/SQL, core Java, SQL loader
• Platforms: Windows XP, Windows 7, UNIX
• Version Control: Quality Center, Test Director
• Methodologies: Waterfall model, V-model
• Testing Tools: Selenium, Load Runner, QTP
• Scripting Tools: HTML, XML
• Office Tools: MS Excel, MS word

EDUCATION/CERTIFICATION:

Bachelor of Engineering (BE) in Electronics & Communications Engineering

PROJECT DETAILS:

Confidential, PAOct10- Till date
QA Analyst/Tester
Confidential, is one of the largest health care companies providing quality health, dental, vision, Pharmacy and behavioral health coverage for customers and their families.

Responsibilities:

• Conducted source-system data analysis to understand current state, quality and availability of existing data.
• Designed & Created Test Cases based on the Business requirements.
• Involved in extensive DATA validation using SQL queries and back-end testing
• Used TOAD for testing the application
• Created MS Excel templates to upload the test cases directly to Quality Center using the built-in tools
• Involved in various kinds of testing like Integration testing, Regressions Testing, and User acceptance Testing
• Involved with Design and Development team to implement the requirements.
• Developed and Performed execution of Test Scripts manually to verify the expected results.
• Extensively involved with ETL procedures/mappings/jobs and the testing of front-end reports
• Tested several Informatica Mappings to validate the business conditions
• Validated that design meets requirements and function according to technical and functional specifications.
• Used HP Quality Center to state requirements, business components, test cases, and test runs for every iteration. Also link defects with requirements
• Tested many stored procedures for backend loading of ETL process
• Used SQL* loader to load data from flat files to the database tables
• Involved in recording change requests on the Change Request Form
• Performed extensive Backend Testing using SQL
• Performed all aspects of verification and validation
• Worked with other members of the QA and Development teams and offshore team in improving the processes, methods, effectiveness and efficiency

Environment: Oracle 10g, PL/SQL, Windows XP, MS Office, TOAD

Confidential, charlotte, NC Jun09 - Oct 10
ETL/SQL Tester
Confidential, is one of the Nation\'s largest chemical Companies. Any Organization or distributor, which purchases or influences the purchase of Clariant chemicals, is a Customer in Clarian parlance. This customer data is stored in various internal systems of Clariant in various formats. Clariant Standard Customer Repository is aimed at providing a unique, clean and consistent customer data obtained from sources like IMS to be used by all internal systems of Clariant.

Responsibilities:

• Worked with user groups and business analysts in defining requirements
• Created specifications for the mappings based on the business requirements.
• Prepared Master Detail ETL and BI Test Plan for the Project.
• Developed Test Plans based on the Test Strategies and Developed scripts, simulators, data sets and other programmatic test tools as required to execute Test Plans
• Created MS Excel templates to upload the test cases directly to Quality Center using the built-in tools
• Developed testing strategy for all upcoming data feeds for both ETL and BI areas.
• Prepared traceability matrix for point requirements from the completed test cases.
• Extensively involved with ETL procedures/mappings/jobs and the testing of front-end reports.
• Involved with extraction routines to verify all the required data loaded into target systems.
• Performed unit testing on the objects to make sure the objects are defined as per report requirements
• Extensively used SQL* loader to load data from flat files to the database tables
• Checked for object compatibilities while using aggregate tables.
• Performed sanity checks on the reports.
• Worked closely with the ETL team to test whether the data mappings have been defined correctly.
• Tested reports generated using Crystal reports and created trend graphs according to the test plan.
• Executed test cases and documented test results in excel spreadsheet

Environment: Oracle 10g, PL/SQL, Informatica 8.1,Windows XP, MS Office, TOAD

Confidential,, NY Mar 08-Apr 09

Customer Relationship Management site for having reviews, quick poll and feedback with Compliance rules to avoid inside trading and to have standardization of various advisors across the global sectors.

Responsibilities :

• Worked individually and as a team to develop Automation framework for selenium
• Prepared layout plans for QA process implementation to target both mid-term and long term releases.
• Review functional and design specification documents
• Identify test conditions, ambiguities, conflicts, and risks
• Design and execute test cases and use cases
• Reported defects and communicated with the development team
• Performed functional, GUI, regression, system integration, user acceptance testing
• Maintained the bug analysis reports and tracked the status
• Scripting, maintenance and reporting of the daily build installation and BVT execution.
• Work with business analysts, developers, and content department to resolve issues
• Define entrance/exit criteria for every midterm release and provide continual Risk Assessments to Senior Management
• Define ambiguities with the business and functional requirements. Work with business analysts to clarify ambiguities

Environment: MS Office, Mozilla Firefox, Eclipse, Selenium

Confidential, Philadelphia Jan 07-Feb08
ETL Tester
Confidential, is a leader in investment banking, financial services for consumers, small business and commercial banking, financial transaction processing, asset management, and private equity

Responsibilities:

• Reviewing Business/Functional requirements and technical specifications of the application
• Analyzing the test requirements and writing new Test Cases as per the requirements
• Performed Manual Testing of some of the sub modules/components of the application as per the Requirements
• Involved in various kinds of testing like Regressions Testing, Functional Testing and User acceptance Testing
• Involved in preparing the Design document
• Used Test Director for Test Planning, Test execution and Defect Tracking.
• Tested the Functionality of the application manually
• Used TOAD for testing the application
• Used Test Director for bug tracking and reporting and updated the bug status, and re-tested the fixed issues
• Written SQL Queries and Procedures to perform database testing
• Performed extensive Backend Testing using SQL
• Interacted with developers in fixing unknown exceptions
• Application errors were reported to the test leads, depending on the severity of the bug
• Participated in status and defect tracking meetings and responsible for maintaining bug log

Environment: SQL Server, PL/SQL, MS Office, TOAD