SUMMARY:

• 8+ years of overall IT experience in software testing process with Test Planning, Test Cases Design, Test Environment Setup, Test Data Setup, Defect Management, Test log, Test results, Test Traceability Matrix and Test Metrics
• Strong experience in Extraction, Transformation, Loading (ETL) data from various sources into Data Warehouses and Data Marts using Informatica Power Center (Designer, Workflow Manager, Workflow Monitor)
• Experience in Data Extraction, Data Profiling, Data Cleansing, Data Standardization, Data De - Duplication using Informatica Data Quality
• Created complex mappings in Power Center Designer using Aggregate, Expression, Filter, and Sequence Generator, Update Strategy, Union, Lookup, Joiner, XML Source Qualifier and Stored procedure transformations
• Created complex mappings in Informatica Data Quality using Standardizer, labeler, Keygen, Match, Consolidation, Exception, Address validator, Case, Merge and Parser Transformation
• Worked in IDQ Human Task, and IDQ data profiling using single, Multiple and Enterprise discovery Profiling
• Experience in Implementing the Informatica Data Quality solution with the appropriate DQ Rules, Metrics and projects
• Worked in DVO with single Table, Table pair, SQL view, Lookup view, Aggregator view and Set view
• Worked on IDQ integration with Informatica Power center
• Experience in Retail, Banking domains and Survey Industry
• Experienced in interacting with business users, business analysts. IT leads and developers in analyzing business requirements and translating requirements into functional and technical design specifications
• 7 years of experience across all the testing phases of Software Delivery Life Cycle
• Experience in testing on Enterprise wide applications with multiple databases like ORACLE, DB2, and MS ACCESS
• Maintaining the Traceability Matrix, Test Data Matrix and Status report related to project
• Performed feasibility, adaptability study and risk analysis to identify the business critical areas from USER perspective and supported multi-tier applications
• Expert knowledge of Business Analysis methodologies and iterative Systems Development Life Cycle (SDLC); Rational Unified Process (RUP), Agile, Scrum, Waterfall, etc
• Experienced in manual testing with the focus on Black Box testing, White Box testing Functional Testing, Regression Testing, Smoke Testing, Load Testing, End to End and System Testing
• Expertise in Documentation: Use cases, Test Plans, Test Scenarios, Test Cases, Test Matrix. Experience in Testing Web Services
• Installed and Configured Testing Testing Tools such as Quick Test Professional (QTP), HP QC 11.52, JIRA, SPIRATEST, Mobile LABS, Perfecto, JAMA, TOSCA, ITS FRAMEWORK -SELENIUM and Talend Data Quality
• Worked with different Databases like Oracle 11g/10g/9i, DB2, MS Access, Teradata, Sybase, and SQL Server 2000/2005/2008
• Experience in software engineering methodologies like Waterfall, V-Model and Agile
• Good Analytical and Communication Skills and ability to work independently with minimal supervision and perform as part of a team. Ability to work under competing deadlines

TECHNICAL SKILLS:

Databases: Oracle 11g/10g/9i, Teradata, MS SQL Server 2008/2005/2000, MS Access, IBM DB2, QMS

Data Modeling: Dimensional Data Modeling, Star Schema Modeling, Snow Flake Modeling, FACT and Dimension Tables, Forward Engineering and Reverse Engineering.

Testing Tools: MS Office Suite, Rexx, File Aid, Spufi, TSO, CICS. Strobe, Talend data quality, Quick Test Professional (QTP), HP QC 11.52, JIRA, SPIRATEST, Mobile LABS, Perfecto, JAMA, TOSCA, ITS FRAMEWORK -SELENIUM and Talend Data Quality, Excel comparator, Data generator

ETL Tools: Informatica Power Center 9.5/9.1/8.6, Informatica developer IDQ 9.1/9.5.1, TIBCO MDM, Talend etc, Informatica DVO

Environment: s: UNIX, Windows 7/XP/2000, Windows server 2003/2000, HP-Unix, Linux, Mainframe OS/390

Languages: C, C++, SQL, PL/SQL, T-SQL, Oracle, COBOL, JCL

Reporting Tools: TIBCO Spotfire, Business Intelligence Reporting 4.0/3.1, and MS SQL Server Reporting Services 2005/2008, Oracle Discoverer reporting tool, OBIEE reporting tool

PROFESSIONAL EXPERIENCE:

Confidential, MN

Senior SQA

RESPONSIBILITIES:

• Participation in Requirement Gathering, drafting Business Requirements and Implementation
• Testing on Enterprise wide applications with multiple databases like ORACLE 11g, Iseries (DB2), and SQL server 2014 Management studio
• Creating Macros using UFT and ALM OTA using automate ALM tasks
• Maintaining the Traceability Matrix, Test Data Matrix and Status report related to project
• Doing the dataset up, writing job cards, Jcls and running the batch job using Mainframe and AS/400 iSeries Services
• Develop, Test, Maintain ETL and (or) Informatica mappings, workflows and optimizing them for best throughput or performance
• Test mapping, workflow session tasks using Informatica Power Center. Debug mappings using Debugger tool in Designer
• Profile the Data from the current Source systems and identify Data Quality rules for cleansing and standardization Involved in migration of the mapps from IDQ to power center
• Implement the Data Quality solution with the appropriate DQ Rules, Metrics and projects
• Implement word pattern changes, developing matching routines, configuration management using Informatica DQ
• Created complex mappings in Informatica Data Quality using Standardizer, labeler, Keygen, Match, Consolidation, Exception, Address validator, Case, Merge and Parser Transformation
• Documentation and execution of Automated and manual test scripts
• Used Quality Center / JIRA for managing the defect flow
• Responsible for UAT support Tasks like doing specific data setups and running the processes manually on users requests

Environment: Informatica Power Center 9.5/9.1, Informatica developer IDQ 9.1/9.5.1, DVO, Oracle 11g, SSRS Crystal reports, AS/400 (IBM iSeries, AS/400e, eServer iSeries/400), Redis Desktop manager ver 0.9.0.738

Confidential, NY

Senior SQA

RESPONSIBILITIES:

• Participated in initial Test effort estimation and resource planning
• Reviewed Business Requirement Documents and Technical Specification
• Responsible for defining Test Strategy and Test Plan
• Responsible for analysis of business requirements for creating test cases and scenarios
• Execute used test cases for manual testing procedures
• Prepared Test Plans and test scripts describing the features and functions to be tested
• Carried out test data for positive and negative test scenarios for functional testing
• Involved in Testing, maintaining ETL and (or) Informatica mappings, workflows and optimizing them for best throughput or Performance
• Data Analysis, cleansing, loading data, data modeling using tools and technologies such as Informatica PowerCenter, Informatica Data Quality, DVO, Informatica Analyst, Oracle 11g (and other RDBMS), Erwin (and other data modeling tools), etc
• Create user documentation and involve in training user whenever needed
• Participate in full life cycle development including requirements gathering, analysis, design, development, testing and documentation
• Oracle OBIEE 11g/12c Repository development
• Implement and modify/design the OBIEE RPD physical, business and presentation layers
• Collaborate with business and data owners to effectively design and develop BI reports using OBIEE.
• Conduct report validation efforts to ensure proper data representation.
• Manage OBIEE caching for efficient report generation.
• Knowledge of WebLogic configuration for OBIEE application hosting
• Provide technical support for OBIEE 11g/12c environment including production control activities, point release upgrades, and/or application software maintenance.
• Assist development team with building test cases to accurately test all aspects of the product. Work with the testing team to ensure test plans are executed and behave as expected
• Provide transfer of knowledge and technical training to State IT staff in support and development of OBIEE 11g/12c
• Optimize OBIEE report performance

Environment: Informatica Power Center 9.5/9.1, Informatica developer IDQ 9.1/9.5.1, Oracle 11g, Oracle Discoverer reporting tool, OBIEE reporting tool 11g/12c, Microsoft SQL server 2014 management studio ver 12.0.5000.0, HP ALM ver 12.53, VersionOne

Confidential, Tampa Bay, FL

Senior Software Quality Test Lead

RESPONSIBILITIES:

• Interact extensively with the Product Manager and Business Area Subject Matter Experts (SME’s) to understand the Business Processes thoroughly. Identified opportunities for business process improvement through various meetings with business users and developers and initiated efforts to make improvements
• Analysis of requirements, creating, and maintaining the Business Requirements Document (BRD)
• Created Requirement Description Document (RDD), Business Requirement Specification document (BRS) for the application to include the business requirements, technical requirements, non-functional requirements and error handling based on the analysis performed while creating the Process flows
• Responsible for defining the Scope of the Project, gathering Business Requirements, involved in Gap Analysis and documented them; created PowerPoint Presentations and reports for reviews with senior management
• Set up definitions and process for scoping, document test cases, and test phases including product test, integration test, system test and User Acceptance Test (UAT)
• Identified the business experts for the different modules and set up meetings with them to gather the requirements for functionality, workflow, and business rules
• Transformed business requirements to technical models using Unified Modeling Language (UML) diagrams like Use Case Diagrams, Data Flow Diagrams, Activity Diagrams and Sequence Diagrams
• Installed and Configured oracle client 11g/12 for database connectivity between application and testing tools (Both UFT/Selenium)
• Setup new framework for both UFT/Selenium projects (End to End)
• Followed Agile Methodologies for delivery

Environment: Oracle 11g, SQL Server 2008 , Crystal Reports, SSRS, Flat Files, and Windows server 2003/2000, TIBCO Master Data Managemet / Oracle, UFT, Selenium webdriver 2.0, Java, Log4j, TIBCO BW - EMS, Mainframe - IMS / DB2, Perfecto, Mobile LABS, Mainframe OS/390, File Aid, Spufi, TSO, CICS. Strobe

Confidential, TX

Software Quality Analyst

RESPONSIBILITIES:

• Requirement gathering and Understanding of the Functional Business processes and Requirements given by the Business Analyst.
• Involved in Designing High level Technical Documentation based on specification provided by the Manager.
• Participated in initial Test effort estimation and resource planning
• Reviewed Business Requirement Documents and Technical Specification
• Responsible for defining Test Strategy and Test Plan
• QTP Automation Framework
• Developed QTP 9.2 Scripts using Programmatic Descriptions
• Executed QTP Scripts in Quality Center
• Responsible for analysis of business requirements for creating test cases and scenarios
• Execute used test cases for manual testing procedures
• Prepared Test Plans and test scripts describing the features and functions to be tested
• Carried out test data for positive and negative test scenarios for functional testing
• Actively participated in creating requirements tractability matrices, and test plans
• Wrote test cases using QC 11.52
• Performed functionality testing, GUI testing, regression testing manually
• Carried out System testing, integration testing
• Conducted backend testing on the MDM database using SQL queries to ensure integrity and consistency of data
• Regression tests were performed after every bug fix and system enhancements using Automation tool ITS Framework Selenium
• Documented the testing procedures testing results for future reference
• Ensured the application conformed to QA guidelines during life cycle testing
• Executed Test Cases and generated error logs, tracked bugs and created reports
• Used Quality Center / JIRA for managing the defect flow
• Responsible for UAT support Tasks like doing specific data setups and running the processes manually on users requests

Environment: s: Informatica Power Center 8.1/8.6, Oracle 10g/9i, SQL Server 2000/2005, SSIS, PL/SQL, SQL, UFT, Selenium webdriver 2.0, Java, Log4j, Visio 2003, UNIX, TOAD, Clear Quest, MS Project 2007, MS Visio 2007

Confidential, Schaumburg, IL

Software Quality Analyst

RESPONSIBILITIES:

• Responsible for gathering Business Requirements, Functional Requirements and Design Documents
• Performed Functional, Negative, Positive, Integration, Regression, End to End and User Acceptance Testing
• Extensively involved in writing and designing templates for the Test Plans and Test cases
• Identified the Test Cases and documented them in Quality Center
• Worked with the Developers and the Test Lead to verify the Test Cases
• Designed and Analyzed Test case design document basing on the Functional Requirement Specifications to implement through testing process
• Analyzed and Developed Test Plan, Test Cases, Test Scripts, Expected Test Results and Test Procedure from functional requirement for different modules in SAP
• Involved in creating the Traceability matrix based on Functional requirement in each module
• Base-line and Regression tests were scheduled and performed on every Release and build
• Supported End-to-end testing for downstream systems
• Worked with batch jobs, monitoring and scheduling jobs using CNTRL-M
• Creation of Test Data for Member data’s according to the scenarios
• Loaded the Test Data into the HPQC to prepare for the execution of Test Cases
• Involved in Task Creation, Task Estimation, Task Distribution, Task Prioritization and Communication among Onsite and Offshore Team Members
• Regularly followed up with the development team to discuss the defects identified during Testing
• Involved with Test Coverage Metrics and Defect metrics such as Defect Density, Delivered Defect Density, Defects by Severity, Number of Defects, and Defects per build, Defect Fix Rate, Test Case Utility, Test Effort and various other measurements
• Interact with end users and investigate issues related to the QA
• Participated in status meetings to report issues. Communicated with developers through all phases of testing to prioritize bug resolution using Quality Center
• Prepared and Presented weekly and monthly QA Defect and Status Reports to the different Stake holders of the project using Quality Center

Environment: Informatica Power Center 8.6.1/8.1.1, SQL Server 2000/05, DB2, Flat Files, Unix, Windows Server 2003/2000