SUMMARY:

• Over 7 years of Experience in teh IT industry wif emphasis on Software Quality Assurance and Data validation, ETL validation, Business Intelligence and Testing using SQL Server, Oracle Databases.
• Worked in all phases of SDLC Design, Development, and Deployment BI Projects.
• Good Understanding of ETL tools like Informatica, SSIS and reporting tools like SSRS, Cognos.
• Experience and understanding of RDBMS and Data warehousing data models.
• Experience in Data Analysis, Data Validation, Data Modeling, Data Cleansing, Data Verification and identifying data mismatch.
• Complete understanding and experience wif Software development Life Cycle (SDLC), Testing Life Cycle (TLC) and QA methodologies
• Experience in analyzing requirements - Business requirements, Functional requirements and Technical specifications
• Experience in developing Test plans, designing Test Cases, developing Test Cases and Test Procedures.
• Strong skills in performing Functional testing, GUI testing, System testing, Integration testing, End-to-end testing, Regression testing, Data-driven testing, Smoke testing, Sanity testing, User Acceptance testing, Cross-browser testing and Backend testing
• Experience in Backend Testing and in executing SQL commands.
• Experience of working on Unix platform.
• Experience in defect and test management tools like Fogbugz, & Quality Center
• Excellent communication skills along wif verbal and written skills.
• Ability to master new technologies, new methodologies quickly.
• Good Coordination and Interpersonal skills. Comfortable working wif large teams and small teams.
• Specialized in Web based and Data Management Projects. Also extensive experience in Manufacturing, Financial applications as an ETL Tester.

TECHNICAL SKILLS:

Operating Systems: Windows

Testing Software: HP Quality Center, Fogbugz, Visual Studio Team System

Databases: Sql Server, Oracle

ETL: Informatica, Datastage, SQL skills, DW and BI skills, TOADPL/SQL, Cognos, DVO( Data Validation Tool).

PROFESSIONAL EXPERIENCE:

Confidential, Des Moines, IA

QA Tester

Responsibilities:

• Reviewed functional and design specifications to ensure full understanding of individual deliverables.
• Developed, documented and maintained functional test cases and other test artifacts like teh test data, data validation, harness scripts and automated scripts.
• Involved in BackendDatabasetestingin MicrosoftSQLenvironment.
• Understanding teh Revenue database.
• Testing teh XML scripts and schemas as per teh requirements.
• Designing test plan and test case for Data migration project.
• Designing and executing test cases for server upgrade.
• Gathering requirements for test scripts through regular discussion wif team members.
• Maintaining proper communication and follow up to speed up teh process.
• Generated data when needed to fit particulartestingsituationsthrough excel and SQL.
• Logging defects in scripts and reporting to teh developer.
• Actively involved in initiating meetings to clear teh changes in requirements and make sure test cases are changed accordingly.
• Designing test plans, test strategy, and identifying test data.
• Executing XML scripts to retrieve form data and analyze teh data returned.
• Executed and evaluated manual test cases and reported test results.

Confidential, Des Moines, IA

Data Analyst/ETL Tester

Responsibilities:

• Functional and Technical understanding of teh Sales domain to validate teh data obtained from teh business.
• Aggregated teh data at source and compared wif teh Target to validate Transformations.
• Used Sql Developer client tools for Querying ORACLE Databases.
• Documented and identified teh test requirements.
• Good Exposure to Data Warehousing concepts validating OLTP and OLAP databases and meeting business needs.
• Hands on experience in writing and executing SQL Queries.
• Having Extensive noledge on Verification and Validation process.
• SQL Report Validation and identifying GAPS in Reports and in Database.
• Validated data connections from application tier to data layer, identified mismatch and reported to developers logging teh defects identified.
• Validated reports and SQL Stored Procedures.
• Involved in testing all teh reports dat were generated comparing in Source and Target systems..
• Tested teh format of teh reports according to teh specifications provided and also compared teh data in teh reports wif teh backend datamart through SQL.
• Validated data connections from application tier to data layer, identified mismatch and reported to developers logging teh defects identified.
• Co-ordinated and taken regular follow up wif development team to assure testing procedures are in pace.
• Gap Analysis between different OLTP and OLAP systems (SQL SERVER and ORACLE).

Confidential, Bloomington, IL

QA Analyst/ETL Tester

Responsibilities:

• Reviewed requirements for testability and usability, and consulted development staff wif regards to system functionality.
• Followed up wif standard software testing life cycle (STLC) to perform different types of testing for teh projects.
• Working on defining mapping requirements sources systems used by Confidential to populate data mart.
• Tested teh flow of data from front end to backend databases.
• Tested teh real time updates happening in teh databases through web services using SOAP UI.
• Tested teh ETL processes dat ran to load teh data into teh central repository.
• Executed unix commands while working wif flat files.
• Develop, maintain and execute manual test cases.
• Performed smoke testing, Functionality testing, Integration testing, and Regression testing.
• Participated in review meetings for creating Test plan and test results summary.
• Executed backend data-driven test efforts wif a focus on data transformations between various systems and a data warehouse.
• Created various PL/SQL stored procedures for dropping and recreating indexes on target tables.
• Used TOAD & SQL Navigator GUI tools for Querying Database.
• Performed functional test and load test on SQL queries, store procedures and forms.
• Performed smoke, functional, integration, system, regression, retesting, performance and User Acceptance Testing.
• Validated archived jobs using DVO.
• Involved in Unit testing and integration testing of Informatica mappings
• Analyze data using SQL, Excel & data testing tools. Review SQL code.
• Analyzing business and functional requirement to design SIT and UAT Test Cases
• Supported UAT testing, re-verified teh bugs by reproducing, documenting teh steps and coordinated teh team for resolution based on prioritization.
• Participated in teh meetings wif business users to present future functionality of teh application, gather information from them to no about their need and send this information to test manager.

Confidential, Wichita, KS

Database Designer / Data Analyst

Responsibilities:

• Involved in Data Analysis and Database Designing.
• Used MS Visio to develop teh database design.
• Extensively involved in developing Data Dictionary.
• Troubleshooting, resolving and escalating data related issues and validating data to improve data quality.
• Involved in performing validation of datasets, tables and triggers by performing White Box Testing and code walk-through.
• Performed Data Profiling to improve search abilities by using tags and aliases.
• Dynamically adjusted price breaks in accordance wif client pricing groups and allowed editing/addition of customer information to rapidly assemble on-screen, printed and database-recorded quotes.
• Involve wif Design and Development team to implement teh requirements.
• Performed execution of test cases manually to verify teh expected results.
• Involved in creation of tables, writing stored procedures and Triggers.
• Developed user interface screens using VB, ADO to connect to backend and stored procedures to manipulate data.
• Handling user defined exceptions.
• Supported team in resolving SQL Reporting services and T-SQL related issues and Proficiency in creating different types of reports.
• Transformed data from one server to other servers using tools likeBulk Copy Program(BCP), and SQL Server Integration Services(SSIS) (2008)

Confidential

Intern

Responsibilities:

• Involved in documenting teh requirements.
• Worked under teh guidance of Project Lead to design and document requirements.
• Gathered hands on experience as a SQL programmer.
• Assisted in determining best prospects for new clients through constant communication via letters and emails.
• Utilized appropriate software to run reports and queries for various monthly processes.
• Analyzed revenues and expenses associated wif sales on monthly basis.
• Assisted in creating presentations for teh monthly review.