SUMMARY:

• Over 7 years of Experience in the IT industry with 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 with 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 with verbal and written skills.
• Ability to master new technologies, new methodologies quickly.
• Good Coordination and Interpersonal skills. Comfortable working with 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 the test data, data validation, harness scripts and automated scripts.
• Involved in BackendDatabasetestingin MicrosoftSQLenvironment.
• Understanding the Revenue database.
• Testing the XML scripts and schemas as per the 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 with team members.
• Maintaining proper communication and follow up to speed up the process.
• Generated data when needed to fit particulartestingsituationsthrough excel and SQL.
• Logging defects in scripts and reporting to the developer.
• Actively involved in initiating meetings to clear the 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 the 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 the Sales domain to validate the data obtained from the business.
• Aggregated the data at source and compared with the Target to validate Transformations.
• Used Sql Developer client tools for Querying ORACLE Databases.
• Documented and identified the 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 knowledge 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 the defects identified.
• Validated reports and SQL Stored Procedures.
• Involved in testing all the reports that were generated comparing in Source and Target systems..
• Tested the format of the reports according to the specifications provided and also compared the data in the reports with the backend datamart through SQL.
• Validated data connections from application tier to data layer, identified mismatch and reported to developers logging the defects identified.
• Co-ordinated and taken regular follow up with 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 with regards to system functionality.
• Followed up with standard software testing life cycle (STLC) to perform different types of testing for the projects.
• Working on defining mapping requirements sources systems used by State Farm Insurance to populate data mart.
• Tested the flow of data from front end to backend databases.
• Tested the real time updates happening in the databases through web services using SOAP UI.
• Tested the ETL processes that ran to load the reference data into the central repository.
• Executed unix commands while working with 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 with 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 the bugs by reproducing, documenting the steps and coordinated the team for resolution based on prioritization.
• Participated in the meetings with business users to present future functionality of the application, gather information from them to know 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 the 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 with client pricing groups and allowed editing/addition of customer information to rapidly assemble on-screen, printed and database-recorded quotes.
• Involve with Design and Development team to implement the requirements.
• Performed execution of test cases manually to verify the 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)
• Involved in documenting the requirements.
• Worked under the 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 with sales on monthly basis.
• Assisted in creating presentations for the monthly review.