SUMMARY:

• 8 years of IT excellent experience in managing software testing efforts for Banking, Health Care and Online Retail domain applications. 
• Expertise in testing Data Warehousing jobs (Informatica, Informatica Data Qualiy (IDQ), SSIS, DataStage) and applications, Business Intelligence reports (OBIEE, SSRS, MicroStrategy, Cognos), Java based applications, Quality Assurance and management, Risk, Compliance, Data management, Internal audit and Enterprise risk management projects and programs. 
• Experience with testing various EDI transactions. 
• Extensively done Data Centric Testing (data testing requiring data to be moved, copied from source to target systems correctly and completely, Checksum comparison, checking quality of data) 
• Expertise testing health care related data like Claims, Medical, Risk, Prevention data. Experienced working with HIPAA, ICD9 and ICD10 codes, Health care Facets. 
• Extensively used IDQ to clean the data regardless of size, data format, platform while validating and improving the information, profiling and cleansing the business data or implementing the data governance practice. 
• Extensively tested OLAP applications and good knowledge on end to end testing of OLAP databases. 
• Tested OLAP cubes for various business calculations and written MDX for validating the same including working with different MDX data types like Scalar, Dimension, Hierarchy, Level, Member, Tuple and Set. 
• Sound understanding on Project Management Life Cycle (PMLC), waterfall and Agile models and iterative model and associated artifacts starting Business Case, ROI, Design, Test and Implement. 
• Involved in the Process changes like Change Management (CM), Change Request (CR) and implementing industry best practices using tool like Clear Quest. 
• Excellent knowledge on the CRM Web UI and good understanding of the head end, MDM, and SAP. 
• Working knowledge on basic billing scenarios and restrictions on Budget Customers. 
• Excellent knowledge on the Customer/Meter Data model in SAP (Contract Account, Contract, Installation, Meter/Meter Read. 
• Comfortable with SAP ECC navigation as well as familiar with Move - In/Move-Out Scenarios. 
• Experienced in Test Life Cycle, Reviewing requirements using DOORS, Planning tests, Documentation, Execution and Defects 
• Experienced in planning and executing Smoke, Functional, Integration, Regression, User Acceptance Testing, Compatibility Testing for Java and .net based web application, Data Warehouse Application; UNIX based applications and Client Server applications. 
• Excellent working knowledge on Oracle Data Integrator (ODI) while working on data integration - high volume, high performance batch loads, to event-driven and trickled-feed integration processes. Experience testing ETL, PL/SQL, UNIX batch jobs using scheduling tools such as Autosys. 
• Very good experience working with UNIX commands and UNIX Shell Scripting. 
• Experienced in writing detailed Test Plans, Test Strategy, Test Data Management Plan and maintained Test Readiness Reviews (TRR) for large releases, application enhancements, maintenance releases and defect fixes for various applications. 
• Expertise with all ODI tools - Topology, Security Manager, Designer and Operator and familiar with ODI interfaces. 
• Knowledge in creating Business Scenarios, Test Scenarios, Test Cases for System, Integration, Regression using HP Quality Center and User Acceptance Testing. 
• Maintained and updated Requirements Traceability matrix (RTM) having Business Requirements, Technical Requirements, Test Scenarios and Test Cases for test completeness 
• Ability to independently develop, maintain and execute Test plans and Test scripts. 
• Managed all testing artifacts in HP Quality Center, TFS (Team Foundation Server), utilized the same for test execution and reporting. 
• Expert in writing Complex SQL quires for backend testing and created several queries on the fly for user specific requirements for trouble shooting day-to-day production issues to identify root cause. 
• Experienced in analyzing Data Flow Diagram (DFD) and Data Model, Entity relation shop diagrams. 
• Performed well under stress, working with multiple applications testing concurrently, coordinating QA activities with various teams and supported project management teams in release activities. 
• Coordinated Release management for Application Maintenance Releases and Production Defects fixes. 
• Ensured SDLC standards and application quality goals met by Quality Assurance Testing strategy. 
• Excellent communication, coordination and interpersonal skills. 
• Experienced in managing Software Testing projects and expert in coordinating testing effort between Onshore and Offshore teams.

TECHNICAL SKILLS:

Databases: Teradata 13/14, Oracle12c/11g/10g/8i, SQLServer2005/2008, DB2, AS400.

Languages: SQL, PL/SQL, C++, C, Java.

ETL Tools: Informatica Power Center, Data Stage, Ab-initio, Big Data - Talend Studio.

Utility tools: Toad, SQL Assistant, SQL Server Management Studio, CDBS Studio, SQL plus, SQL Developer, DB visualizer

Reporting Tools: Business Objects, Cognos, Micro Strategy

Defect Tracking Tools: ALM, Quality Center, Jira, Clear Quest, Rally

MS Office: Excel, Outlook, Access, Word, PPT, Project, Expression Encoder

Operating Systems: Windows/Linux/UNIX

SDLC Methodologies: Agile, Waterfall, Kanban.

PROFESSIONAL EXPERIENCE:

Confidential, Ada, MN

Sr. ETL QA Tester

Responsibilities: 

• Extensively involved in testing the application developed in Agile Methodology and detailed designs. 
• Analyzed and optimized the use cases and created the Test cases based on them for Change Requests. 
• Executed all Test cases in different phases of testing like Smoke, Regression and System testing of the application. 
• Validated SSIS and SSRS packages according to business and functional specification documents. 
• Have tested scheduler scenario on Autosys. 
• Validated the Informatica workflows according to business requirement documents. 
• Used Informatica workflow monitor to run the workflow and verify their status and logs. 
• Validated the SSAS cubes for various dimensions. 
• Validated the Data Warehouse (DWH) Table structure part of ETL testing. 
• Executed batch processing and verify the ETL jobs status and data in database tables 
• Validated parameter-driven ETL processes to map source systems to target data warehouse with Informatica complete source system profiling. 
• Tested all the rules implemented during ETL job and data move from source to target Data Warehouse (DWH) 
• Developed complex SQL queries to test ETL jobs from source to target Data Warehouse (DWH) 
• Involved in defining Test Scenarios for the applications and performed manual testing in HP Quality Center. 
• Extensively tested OLAP applications and good knowledge on end to end testing of OLAP databases. 
• Tested OLAP cubes for various business calculations and written MDX for validating the same including working with different MDX data types like Scalar, Dimension, Hierarchy, Level, Member, Tuple and Set. 
• Created and executed different types of test cases for the Change Request and existing functionality of the application. 
• Responsible for checking data in database by writing and executing SQL statements. 
• Involved in meetings with Automation team for Development of Automation Scripts for Change requests to run along with regression tests suites of business priorities on Loan Application. 
• Assisted load testing team with functional scenarios of the final mortgage application. 
• Involved in backend testing using UNIX commands. 
• Used MicroStrategy Web to offer interactive reporting to the end users 
• Validated various MicroStrategy reports such as ad hoc, grids, graphs. 
• Have coordinated small offshore team to develop Test Plan and Test Script. 
• Involved in Design and development of test plans based on high-level documents (BRD & FRS). 
• Involved in writing and implementing the Test plan, Test cases, Test Procedures, Test sets using Use cases and requirement specifications. 
• Extensively used IDQ to clean the data regardless of size, data format, platform while validating and improving the information, profiling and cleansing the business data or implementing the data governance practice. 
• Excellent knowledge on the CRM Web UI and good understanding of the head end, MDM, and SAP. 
• Working knowledge on basic billing scenarios and restrictions on Budget Customers. 
• Excellent knowledge on the Customer/Meter Data model in SAP (Contract Account, Contract, Installation, Meter/Meter Read. 
• Comfortable with SAP ECC navigation as well as familiar with Move-In/Move-Out Scenarios. 
• Analyzed customer and business needs to determine business and functional requirements. 
• Gathered and documented business requirements for system gaps that require development in credit card project. 
• Participated in functional requirement reviews and code reviews. 
• Analyzed existing business processes and provided recommendations for improvements and efficiencies in credit card project. 
• Involved in Data centric testing using various approaches such as checksum approach to discover errors, identifying records with MD5 
• Worked with Business Analyst and Developer to resolve the defects. 
• Designed and developed Use Cases, Use Cases diagrams, Activity Diagrams, Sequence Diagrams. 

Environment: HP Quality Center ALM, Oracle 11g, Informatica Power Center 9.1, IDQ, SQL Server 2012, SSIS, SSRS, SSAS, Autosys 10.0, Toad 10.0, OLAP, WinSCP, MicroStrategy 9, Putty, OBIEE, Oracle ODI, Informatica Web Services, SQL, PL/SQL, CRM, Web UI, Java, XML

Confidential, Farmington, CT

Responsibilities 

• Writing the test scripts for Manual/Automation testing. 
• Analyzed business process workflows and assisted in the development of ETL procedures for moving data from source to target systems. 
• Extensively used SQL programming in backend and front-end functions, procedures, packages to implement business rules and security 
• Creating test scripts using Quality Center and performing regression testing on new versions of the software. 
• Used Quality Center for bug reporting. 
• Defect Reporting & Defect Tracking using Quality Center. 
• Strong testing Quality Assurance experience within agile environment 
• Good understanding of agile software development lifecycle (iterative and incremental) 
• Performed tests on various features of agile development process 
• Used Mercury ALM to maintain test cases and execute test scenarios, log defects 
• Experienced using database query tools for Oracle, SQL and UNIX such as TOAD and SQL Plus 
• Responsible for migration of extensive databases to MS Access utilizing tables, queries, forms, reports, macros, and modules. 
• Identify business rules for data migration and Perform data administration through data models and metadata 
• Experience in integration of various data sources with Multiple Relational Databases like Oracle, SQL 
• Load new or modified data into back-end Oracle database. 
• Reviewed Informatica mappings and test cases before delivering to Client. 
• Extensively used Informatica power center for extraction, transformation and loading process. 
• Performed backend database testing by writing SQL and PL/SQL scripts to verify data integrity 
• Worked with ETL group for understating for data loading for both dimensions and facts. 
• Created various PL/SQL stored procedures for dropping and recreating indexes on target tables. 
• Worked on issues with migration from development to testing. 
• Designed and developed UNIX shell scripts as part of the ETL process, automate the process of loading, pulling the data 
• Involved in creating the design and technical specifications for the ETL process of the project. 
• Prepared extensive set of validation test cases to verify the data 
• TOAD is used to perform manual test in regular basis. Involved in user training sessions and assisting in UAT (User Acceptance Testing). 
• Strong ability in developing advanced SQL queries to extract, manipulate, and/or calculate information to fulfill data and reporting requirements including identifying the tables and columns from which data is extracted 
• Involved in Writing Detailed Level Test Documentation for reports and Universe testing.

Environment: Informatica Power Center, Sybase, Cognos, SQL Server 2000/2005, Oracle 9i/10g, UNIX, Windows, ALM 11.0

Confidential, Houston, TX

ETL / DWH / BI/ UAT Tester/ Data Analyst

Responsibilities: 

• Reviewed requirements document such as BRD, DMS and design document and other artifacts to better understand the process, its underlying data. 
• Actively reviewed business requirement to identify ambiguous and unclear requirements, worked with clarify those items. 
• Utilized and managed the requirements from DOORS. 
• Created detailed test cases independently to test web application created using java for internal and external purpose. 
• Validated various SSIS and SSRS packages. 
• Experienced working with HIPAA, ICD9 and ICD10 codes. 
• Conducted Smoke testing, Regression testing, System testing, and End to end testing and User Acceptance Testing. 
• Validated the SSIS packages and the transformations in data and control flow tasks. 
• Validated Autosys batch schedule jobs which schedule PL/SQL, ETL jobs. 
• Performed cross browser testing for this web application with Safari, Opera, Chrome, Firefox, Internet Explorer and Mobile browsers (different versions). 
• Coordinated with business analyst and business users to conduct user acceptance testing. 
• Customized critical test cases for business user execution during the UAT. 
• Created test case result document for all the testing. 
• Validated SSRS reports according to report specifications. 
• Validated XML files as part of system testing and compared the data with database. 
• Identified defects in system testing, end to end testing, regression testing logged these defects using Rational ClearQuest with proper severity and priority and performed defect life cycle. 
• Worked with automation team to develop automation regression testing framework and automation regression testing PL/SQL scripts. 
• Performed database testing using SQL queries with joins, unions, arithmetic and aggregate functions. 
• Extracted requirement for enhancements using DOORS. 
• Created test status reports, summary reports and communicated accurate progress to stakeholders.

Environment: HP Quality Center 10, Oracle 10g, Toad, SQL, PL/SQL, Autosys, Windows XP, SQL Server 2008, SSIS, SSRS, SSAS, Rational ClearQuest, Microsoft SharePoint, Unix Scripts, Unix, Agile

Confidential

ETL QA Analyst / UAT Tester / Back

Responsibilities: 

• Reviewed Business, Systems, Design and Technical specification and identified gaps and ambiguous points, coordinated with respective team to fix the gaps. 
• Defined testing activities for three major releases with concurrent monthly maintenance releases. 
• Created Test data analysis from the Functional, System and Design specification. 
• Interacted with Business Users, BA, Dev teams to understand the business process and technical flows and created detailed End-to-End test cases based on the processes and business flows. 
• Created test plan, test cases, test scripts and test steps for every release and stored in Microsoft- TFS 
• Created Requirements Traceability Matrix (RTM) for test coverage analysis and test completeness 
• Created System test scenarios and User acceptance test scenarios to test all mortgage application releases. 
• Reviewed Use cases test critical areas of application. 
• Created test cases for Smoke testing, System testing and Regression testing. 
• Created Risk Assessment matrix document based on defects identified and risks associated in system/production environment. 
• Incorporated Integration within System Test plans, which adequately exercise functioning of the system and its various components. 
• Validated various DataStage jobs according to Business Requirements and Functional Specifications. 
• Created manual Test cases and utilized QTP to automate test scripts for Regression Testing. 
• Integrated the Automation test scripts in Quality Center and created baselines. 
• Wrote queries on Oracle and DB2 database for data validation, tested the Java web interface application with the legacy Mainframe programs. 
• Validated various Cognos reports for data quality and layouts. 
• Validated the custom reports developed in Cognos Report studio, validated the adhoc reports in Cognos Query studio, and multi-dimensional cubes in Cognos Analysis studio. 
• Involved in validating various Informatica workflows, mappings, and tasks. 
• Extensively developed SQL Queries using Rapid SQL to test the business process of financial accounting modules to PeopleSoft. 
• Created RTM between Quality Center and DOORS 
• Coordinated the Testing efforts during Integration, System and User Acceptance Testing phases. 
• Manage defects through Rational ClearQuest Defect Tracking. Assign defect priority, analyze follow up and retest defects over builds.

Environment: Microsoft-TFS, DataStage, Oracle 9i, Toad, SQL, PL/SQL, DB2, CDW, Autosys, Windows XP, QTP, SQL Server2005, Crystal Reports, Cognos, Rational Clear Quest, Rational Clear Case, MS Office, VISIO and Project

Confidential, Chicago, IL

ETL / Report / QA Analyst/ Data Migration

Responsibilities: 

• Analyze functional and technical requirements for Data Warehouse Migration from Oracle to Teradata project to ensure precise translation of business requirements into technical solutions. 
• Create / Design ETL specifications based on business requirements. 
• Provided expert knowledge in the development and maintenance of system checks and balances to ensure data integrity and consistency. 
• Designed templates for Source to target mappings, gap analysis and use case acceptance testing for structured execution of project tasks. 
• Responsible for creating Test plan, development of test scripts, execution and validate Test results and document test evidence. 
• Executed test cases, and test scenarios for User Acceptance (UAT), Functional and Regression test cases. 
• Created user acceptance testing documents and reviewed them with the customer. 
• Tested ETL jobs as per data mapping requirements. 
• Involved in validating various Business objects reports for data quality and the lay out. 
• Involved in communicating with support, business and development teams to resolve issues during test execution. 
• Conducted reviews of test plans, test cases, and prepared test results. 
• Effectively communicate testing activities and findings in oral and written formats. 
• Extensively used SQL programming in backend and front-end functions, procedures, packages to test business rules and security. 
• Performed periodic checks to run crosscheck against QA/SIT/PROD environments to ensure it is up and running. 
• Provided status reports on test execution, and defects identified during testing. 

Environment: DataStage, SQL, PL/SQL, Oracle, Toad, Teradata, Teradata SQL Assistant, SQL Navigator, Database Management Studio, Business Objects XI, Share point, UC4, UNIX, Putty, HP Quality Center.

Confidential

QA Manual/Automation tester

Responsibilities:

• Analyzed user requirements and functional specifications to create test cases. 
• Preparing the Test Scenarios and Test cases. 
• Execution of test cases for all the releases. 
• Performed Smoke Testing. 
• Involved in executing Functional and Regression Testing for all releases. 
• Defect logging and tracking in various stages. (#define) 
• Preparation of Regression test cluster. 
• Preparing the traceability matrix. 
• Involved in identifying automated test cases. 
• Wrote test scripts using QTP and Executing test cases in Quality Center. 
• Involved in integrating the unit level scripts with the framework. 
• Analyzing test results and reporting bugs. 
• Carried out Impact Analysis on the existing test cases due to new functionality changes. 
• Participated in UAT Testing. 
• Participated in daily status meeting. 

Environment: Java, .Net, Java Script, HTML, Unix, SQL Server, Quick Test Professional, Quality Center, Windows 2003 server.