SUMMARY

• 5 years of experience in Quality Assurance and Software Testing of various business applications in Client/Server environments, Web - based applications, Data-Warehousing solutions, ETL, and Business Intelligence solutions.
• Strong Knowledge of the Software Development Life Cycle (SDLC) as well as Software Testing Life Cycle (STLC).
• Expertise in translating user requirements into technical specifications and mapping the process design, and workflows for SDLC with documenting and managing business requirements using RUP. WATERFALL and AGILE methodology.
• Extensively worked on databases including Oracle, SQL Server, and DB2.
• Practiced AGILE methodology with daily meetings following the onsite-offshore model.
• Utilized JIRA and HP Quality Center to manage and keep track of testing and analysis.
• Experienced in testing Star and Snowflake Schema Dimensional Data Models.
• Experienced in end-to-end testing ofETL, Reference Data, Data Warehousing, and Business Intelligence solutions for large enterprise data.
• Experienced testing different web services using SOAP UI and Postman.
• Experienced using Informatica PowerCenter for data integration services.
• Expert in Writing, Executing and Maintaining Test Plans, Test Strategies, and Test Cases.
• Experienced in Data Analysis, Design, Development, Data Cleansing (Scrubbing), Data Validation and Verification, Data Cleaning, Data Conversion, Data Migration, and Data Mining.
• Proficient in GAP Analysis, Test plan Preparation, Test Execution, Defect Management, and Management Reporting.
• Strong working experience in production support for testing web applications.
• Experienced in performing extensive Backend Testing of the application using SQL queries. Strong command in SQL DDL to create, alter and drop the data. Hands-on DML statements to insert, delete and update the data.
• Possess excellent organizational, Interpersonal, Communication, and Documentation skills along with a remarkable ability to adapt to a new environment and meet stringent deadlines.
• Expert in using Confluence - assigning user personal space as well as providing assistance on using Confluence
• Strong analytical skills and consistent time management skills to meet client deadlines
• Experienced in designing database tables and normalizing tables. Involved in maintaining Test Matrix and Traceability Matrix and performing a GAP analysis. Conducted User Acceptance Testing (UAT).
• Proved to be strong in communication and analytical skills. Excellent documentation and writing skills. Advance level skills in Microsoft Office (Excel, Word, Access, and Powerpoint)

TECHNICAL SKILLS

Operating Systems: Windows 98/2000/XP, Windows NT/2000, UNIX, Linux

Methodologies: Agile, Waterfall

Data Warehousing: Informatica 9.x, 8.x, 7.x, Data Stage 8.x

Testing Tools: ALM, Quality Center, JIRA, SoapUI, Postman

Reporting Tools: MicroStrategy, Cognos

Databases: Oracle, MS SQL Server, MS Access

Web Technologies: HTML, XML

ETL Tools: Informatica PowerCenter

PROFESSIONAL EXPERIENCE

Confidential, Mount Laurel NJ

ETL Tester

Responsibilities:

• Worked with the quantitative research group to improve risk calculations
• Applied project management practices across all phases of software development life cycle (SDLC) as well as Software Testing Life Cycle (STLC)
• Developed and managed detailed project plans and project updates for stakeholders
• Developed Test Cases based on Requirement Specifications and Design Documents.
• Identified and resolved any conflicting design issues, seeking input from the Business Analysis Manager/Business Architect/Project Manager where necessary
• Extensively used Informatica Power center for extraction, transformation, and loading process.
• Analyzed the Requirement Traceability Matrix, daily test status reports, weekly defects report, and risk analysis, including regular communications with the business team.
• UsedJIRAfor adding issues on what is being worked on, and used ALM to create and execute test cases.
• Participated in defining and executing test strategies using agile methodology.
• Involved in Unit testing and integration testing of Informatica mappings.
• Tested the data warehouse using data mapping documents for various data feeds.
• Assisted in the preparation and execution of User Testing including Impact Analysis
• Tracked the defects, and RTM with application teams and assisted in a closure usingALM.
• Involved in backend testing for the front end of the application using SQL Queries in the Oracle database.
• Created SQL queries for data validation to verify theETLmapping rules.
• Tested and validated the Report by running similar SQL queries against the source system(s).
• Conducted elaborate manual UAT testing on test cases and provided feedback to the development team.
• Performed web-specific testing like Browser page testing, Application Testing, and Security Testing.
• Interacted with the development team to resolve and follow up on development issues.
• Worked as SME to different scrums to refine their stories and identify regression scenarios for the same.
• Utilized Quality Center as well as JIRA for defect tracking and maintained defect repository and the followed defect cycle until closed.
• Created Defect Log spreadsheet for Test Cases with TestCaseID, Desc, Preconditions, Steps to be taken, Test Data, Expected results, Actual results, Pass/Fail, ReqID.
• Worked as liaison with the development team for technical defect-related matters and follow-up.
• Participated in daily/weekly status meetings, conducted walkthroughs, and documented proceedings with the Project manager and Scrum Master.
• Assisted off-shore team members in reviewing requirements, preparing and executing test cases, and reporting software defects.
• Proactively worked with a team member in Offshore, and conducted knowledge transfer sessions.

Confidential, Cincinnati, OH

ETL Tester

Responsibilities:

• Following Agile methodology for the overall software testing cycle.
• Extensively used HP ALM to write test cases, executing them, and to prepare the Requirement Traceability matrix.
• Defects identified in the testing environment were communicated to the developers using HP ALM.
• Tested front-end part of the application as well as the back end of all data populating in UI.
• Perform system testing, Functional testing, Regression, End-to-End, and User Acceptance Testing (UAT)
• Responsible for creating test cases/ scenarios from BRD and executing test scripts for various demands
• Created test cases and test plans for user acceptance testing and system testing based on functional specifications.
• Involved in testing the Cognos reports by writing complex SQL queries.
• JIRA is used for project tracking and bug tracking.
• Tested Informatica mappings for various ETL data conditions and mapping rules.
• Tested theETLwith XML as source and tables in the data warehouse as a target.
• Tested source data for data completeness, data correctness, and data integrity.
• Created test plans and performed unit testing for the Informatica mappings.
• Creatingtestscripts for validating data migration from Mainframes to data Center (In Oracle)
• Prepared and executed test cases and defect tracking and reporting processes using JIRA.
• Involved in testing Reports and actively worked with operations, and Release teams to resolve the production issues.
• Tested the ETL Informatica mappings and other ETL Processes (Data Warehouse Testing)
• Prepared the estimates for the test effort and negotiating with the Project teams. Preparing the work plans based on the Project timelines and implementing them
• Perform UAT testing and Signoff process and communicate with Business Partners on various issues found in production
• Assist informational needs in the mapping of Test Cases. Wrote Test Scenarios, Test cases in excel sheet and imported them to ALM

Environment: Quality Center (ALM 11),Agile, Waterfall, Informatica, Cognos, SQL, Oracle, XML and ALM, JIRA, MS SQL Server, Microsoft Excel, Microsoft Word, Windows.

Confidential, Salt Lake City, Utah

Systems QA Analyst/ ETL tester

Responsibilities:

• Worked with Business /Technical Analyst in the analysis of functional design specifications of ETL/Data warehouse applications
• Analyzed Source to Stage and Stage to Target mapping document based on Facts & Dimensions and validating the DDL, Counts, Not Nulls, Duplicates, PK & FK validation, and business rules to be applied on target tables.
• Involved in the creation of Test Plans, Test Cases, and Test Execution based on mapping specs to validate the platform data.
• Tested Full load & Incremental load by entering the sample test data to a couple of entities and making sure Inserts & Updates of loading the data are done correctly.
• Used Quality Center 10.0 as a test management tool to manage and organize Requirements Coverage, Test Cases, Test Scripts, and Creation of defects.
• Extensively used informatica for ETL process
• Used workflow Manager and workflow Monitor in informatica to run workflow and monitor the workflow log and session log as per mapping documents
• Followed Defect management life cycle and raised the defects based on priority and severity level in QC.
• Performed Functional, Negative, Smoke & Regression tests as per design specs.
• Prepared Traceability Matrix for each entity and marking down Test requirement, Test Head line, Actual result & Expected result.
• Generated reports from Cognos and validated the reports based on mapping.
• Sending day to day migration phase reports to higher management and keeping them with up-to-date information with the migration process.
• Writing complex SQL queries using Case Logic, Intersect, Minus, Sub Queries, Inline Views, and Union in Oracle.
• Conducted various management activities by analyzing and verifying test results, providing status reports
• Implemented Iterative and Incremental Agile - Scrum Methodology for rapidly changing or highly emergent requirements and following parallel development and testing.

Environment: HP ALM, Informatica Power Center, Oracle 10g, JIRA, Unix, Putty, Cognos, Agile, SQL, Windows 2000/XP, MS Office, CSV Files