Lead Qa Analyst/tester Resume
New York, CitY
SUMMARY
- I'm a result oriented IT professional with 7 years of corporate experience in ETL Quality Assurance,Business Analysis and Financial Asset Management, offering a full life - cycle-software management experience.
- I have undertaken complex software projects in various capacities, utilizing a wide array of tools and skills.
- I provide superior performance and can work with a sense of urgency, having advised senior management of forthcoming key trends.
- I possess exceptional communication and people skills, and a winning attitude.
- 7 years experience in Data Analysis, Modeling, Profiling, Verification, Mapping, Loading and testing the performance of the mechanicsat every stage.
- Expert experience with Data Warehousing concepts, Architecture and Design.
- Strong working experience in ETL methodology, with Data Design, Analysis, Development, implementation of Data Warehousing using Data Conversions, Data Extraction, Data Transformation and Data Loading.
- Solid Back End Testing experience by writing and executing SQL Queries
- Proficient in handling various phases of testing such as Functional, Non-Functional, GUI, Regression, Integration, Performance, and User Acceptance Testing (UAT).
- Execution of automated test scripts using HP ALM / HP QC, based on business/functional specifications.
- Excellent experience in Black box Testing and White box Testing
- Experience in Integration and extraction of data from various sources like DB2, Oracle, MS Access and Excel.
- Experienced in using Quick Test Pro for testing web browser and Windows-based automation.
- Expertise in Developing PL/SQL Packages, Stored Procedures/Functions, triggers.
- Hands on experience in end-to-end of data warehousing ETL routines, which includes working with Informatica graphs, UNIX scripts, stress testing, and ensuring data quality.
- Extensive experience in Data Analysis, Data Cleansing, Requirements gathering, Business Analysis, Data Mapping, Entity Relationship diagrams (ERD), Architectural design docs, Functional and Technical design docs, and Process Flow diagrams
- Extensive working experience in applying Relational Database concepts, Entity Relation diagrams and Normalization concepts.
- Working experience in the Agile/Scrum Process
- Participated in the development and maintenance of conceptual, logical, and physical entity/data models, in the development and deploymentof modeling standards, governance of Metadata.
- Conducted Testing on Web and Client/Server Applications and done Back-end Testing
- Have the ability to elicit, understand and articulate business requirements and perform detailed analysis to map them to technical and functional requirements.
- Strong knowledge of Business Intelligence, Data Warehousing and Business Architecture
- Experience in Dimensional Data Modeling using Star and Snow FlakeSchemas.
- Good experience in working with UNIX scripts in executing and validating logs for the issues.
- Quick in adapting to the Client's Software Development Methodologies that includes Agile, Waterfall or RUP.
TECHNICAL SKILLS
Languages: SQL, PL/SQL, JavaScript, VB Script, UNIX
Test Management Tools: HP ALM / Quality Center 10, Quick Test Pro 11
Databases & Tools: Oracle 11g, DB2, SQL Server 2005/2008, Informatica 9.x
Defect Tracking Tools: Quality Center 10/11, MS VSTF, Rational Test Manager, MS Excel
Business Intelligence Tools: Cognos 8.x
Data Analysis Tools: Informatica Data Explorer, Data Profiler
PROFESSIONAL EXPERIENCE
Confidential, New York City
Lead QA Analyst/Tester
Responsibilities:
- Spearheaded a team of 3 other ETL Specialists to develop and test the project’s central ETL system, which had been in development for 3 years.
- Singlehandedly developed an ETL Master Test Plan to address the need for a core artifact that references all facets of the testing process, from strategy, scope and timelines, to protocols and procedures.
- Automation of an in-houseGlobal Asset and Insurance Management Application using QTP.
- Closely worked with the BA and ETL Development teams to refine and consolidate requirements, business rules and dependencies surrounding the system.
- Worked on Requirement Analysis, Data Analysis and Gap Analysis of various source systems sitting and coming from multi systems. Responsible for BI Data Quality
- Conducted regular Scrums sessions to cultivate better control and fluidity in the testing process, and adjusting to the changing and adding needs of the ETL system.
- Wrote test cases and scripts, and executed them in QC in accordance with the Test Plan, alongside reviewing the test cases developed by team members.
- Worked on a number of smaller projects surrounding the ETL Framework, under development as part of a high-level strategic solution to make data management seamless.
- Wrote Master Test Plan, designed and executed Test Cases for a data validation tool called ‘Sniffer’ developed to compare heterogeneous sets of data by populating it in a single table, and comparing field values within it.
- Tested another web browser-based tool called ‘Data Refresh Analysis Tool’, using Quick Test Pro.
- Involved in planning, requirements analysis, design and development of new Cognos projects or enhancements of existing projects.
- Prepared datamapping documents specifying what data will be extracted from sources, transformed and sent to a Data Warehousing.
- Extensively used SQL Queries& PL- SQL for Backend Testing
- Extensively worked with data analysis using SQL, PL/SQL queries based on the applications.
- Extensively used TOAD to query the Oracle database and wrote scripts to validate tables.
- Involved in identifying the sensitive data in the organization.
- Written several complex SQL queries for validating/verifying the business rules for Data.
- Responsible for Data mapping by writing complex PL/SQL Queries using Query Studio
- Did extensive data analysis using SQL,and worked with Excel Macros to identify data issues.
Environment: Informatica Power Center 9.1.0, Oracle 11g (SQL, PL/SQL), TOAD for Oracle, QTP 11, Cognos 8.1, MS Access, MS Excel, VB Script, XML, FTP/SFTP Servers, Ad-hoc Reporting.
Confidential, New York City
Senior ETL QA Tester
Responsibilities:
- Extensively involved in all phases of SDLC (Software development Life cycle) and follows Agile methodology
- ValidatedMulti-Asset Class data, from over 40 sources, with data related to cash, equities, bonds and foreign exchange investments.
- Developed Test Cases and PerformedManualTesting like Positive Testing, Negative Testing and Black Box Testing
- Served as an SME on implementation of business rules, with extensive knowledge offinancial instruments such as bonds and swaps, hedging strategies, and SOX & BASEL II standards for Capital Calculations.
- Designed, developed stored procedures using PL/SQL and tuned SQL queries for better performance.
- Used QTP IDE to record, edit and debug test.
- Used QTP core to quickly record and play back the tests in the actual environment that they will run the web browser
- Used Informatica PowerCenter 8.6.1and its features extensively in migrating data from OLTP to Enterprise Data warehouse.
- Involved in testing the Business Objects performance & connectivity across different domains.
- Tested complex objects in the BO Universe to enhance report functionality.
- Extensively used SQL queries to check storage and accuracy of data in database tables.
- Written complex SQL queries for validating the data stored in different database tables.
- Helped the team in analyzing the data to be able to identify the data quality issues
- Involved in Database testing by writing & executing SQL & PL/SQL queries using TOAD to validate that data is being populated in an appropriate tables & manually comparing the results with front-end values.
- Monitored the data move process through Informatica execution flows.
- Extensively worked on handling the application response for Positive and Negative sets of data using data driven testing.
- Manually tested the application for each system build, using both negative and positive testing strategies.
- Involved in functional testing using QTP.
- Used descriptive programming in QTP for ease of testing future changes in requirements.
- Expertise in communicating with offshore teams.
- Regular communication with the financial managers for weekly status reports.
- Test execution in accordance with test strategy and test schedule, review; issue identification and data mining exercises in accordance with project plan timelines.
- Tested the ETL process for both before data validation and after data validation process. Tested the messages published by ETL tool and data loaded into various databases.
- Extensively used Informatica Debugger for testing the mapping logic during and after Unit Testing. Performed integration testing and validated results with Business Analysts and/or the managing client.
- Participated in Daily and weekly status meeting with team members and coordinated with teams (Development, Business, and QA) for the progress of the work done in application.
Environment: Informatica Power Center 9.1.0, SQL, PL/SQL,HP Quick Test Pro 10,Autosys 4.5,Unix Shell Scripting, TOAD 9.2, MVS, VSAM Files, Oracle 9.2 and 10G, HP Quality Center 10.
Confidential, Kansas City, MO
Senior DW Backend Tester
Responsibilities:
- Designed and developed Test Plans, Test Scripts and Test Cases in HP Quality Center and executed them.
- Wrote complex SQL, PL/SQL Testing scripts for Backend Testing of the data warehouse application
- Involved in writing the Test Plans based on Business Requirement and Functional Requirement documents.
- Developed SQL Stored Procedures and Queries for Back end testing
- Involved in implementation of the Test plans, Test cases and Test Scripts.
- Created Test sets in Test Lab to move all the test cases from Test plan to execute the test cases.
- Tested the data and data integrity among various sources and targets.
- Developed and involved in both Manual Testing and Automation Test Scripts based on Use cases developed.
- Tested to verify that all data were synchronized after the data is troubleshoot, and also used SQL to verify/validate my test cases.
- Provided Autosys expertise for batch processes running in the QA environment within the Enterprise Business Intelligence group.
- Involved in extensive DATA validation using SQL queries and back-end testing
- Experience with Autosys job scheduler including jil scripting, virtual machines and converted existing scheduled processes from Cron to Autosys.
- Involved in development and presentation of reporting solutions to clients using Cognos.
- Managed user accounts and security using Business Objects Supervisor.
- Tested the universes and reports in Business Objects 6.0
- Extensively used Informatica power center for ETL process.
- Prepared ETL mapping specifications.
- Worked on QTP for Regression Testing.
- Configured Quick Test Professional with Quality center.
- Executed of QTP Script for automation testing, analyzing the automation result
- Reviewed Informatica mappings and test cases before delivering to Client.
- Trained and coordinated with the offshore team members in understanding the requirements and test cases for UAT.
- Tested the ETL Informatica mappings and other ETL Processes (Data Warehouse Testing).
- Involved in ETL Mapping Design and Performance tuning to Load mapping process.
- Experienced in writing complex SQL queries for extracting data from multiple tables.
- Reviewed the test cases written based on the Change Request document.
- Testing has been done based on Change Requests and Defect Requests.
- Involved in preparation of System Test Results after Test case execution.
- Effectively coordinated with the development team.
- Created critical scenarios for each change request and defect request.
- Worked on HP Quality Center and updated defects status with appropriate information. Involved in various testing phases like Unit Testing, System Integration Testing, Validation Testing, User Acceptance Testing, Parallel Testing, Performance Testing and Regression Testing.
- Used various SQL queries to validate the test case results for back-end test cases.
- Well exposed to Software Development Life Cycle and Test methodologies.
- Hands on experience with working on Autosys jobs and MQ’s. MQ’s are used for intermediate storage where the messages are stored for temporary purpose.
- Hands on experience working with SQL Server.
Environment: Informatica Power Center 8.1,Cognos 8.1, SQL, PL/SQL, SQL Server 2000/2005, Unix Shell Scripting, XML, XML Spy 2008, XSLT, TOAD 9.2,Oracle 9.2, SOA, SOAP UI, HP Quality Center, Rational Suite, Autosys.
Confidential, Chicago, IL
ETL/SQL Tester
Responsibilities:
- Gathered user requirements from each Business Units for testing.
- Interacted with the Business users to identify the process metrics and various keys dimensions and measures.
- Designed and developed Test Plans and Test Cases and executed them.
- Involved in implementation of the Test plans, Test cases and Test scripts.
- Involved in the error checking and testing of the ETL programs using Informatica session log and workflow logs.
- Involved in ETL Mapping Design and Performance tuning to Load mapping process.
- Organized sessions in a batch to run the sessions in a batch in sequential order or start them concurrently by the server.
- Initial testing was conducted manually and later phase was executed using Mercury Tools
- Conducted the Functional, System, Regression, and Performance testing of the Web application using Mercury tools Quick Test Pro and LoadRunner.
- Worked with Quality center to document test results and validate test scripts. Used Quality Center in routing defects, defect resolution and assigning business cases to business users.
- Developed Automated Test Scripts using Win Runner.
- Designed process performance loading strategies. And also wrote the optimizing techniques to improve the process loading time within the streamline using Server Manager to load the data into the Target Database.
- Involved in writing Test cases and Test plans which are managed and controlled using HP Test Director. Also used HP Test Director to manage and track defects.
- Documented defects accurately and with sufficient information to enable developers to analyze andreproducethe defect using Test Director’s defect reporting tool.
- Involved in various testing phases like Unit Testing, System Integration Testing, Validation Testing, User Acceptance Testing and Performance Testing.
- Used various SQL queries to validate the test case results for back-end test cases.
- Well exposed to Software Development Life Cycle and Test methodologies.
- Created and published Impromptu/Report Net reports.
- Tested several complex reports generated by Cognos including Dashboard, Summary Reports, Master Detailed, Drill Down and Score Cards.
- Used Query Studio to test ad hoc reports.
- Involved in Unit Testing of all reports and packages.
- Involved in testing the Cognos reports by writing complex SQL queries.
- Developed complex queries using different data providers in the same reports.
Environment: Informatica Power Center 8, Oracle, SQL, PL/SQL, UNIX Shell Scripting, XML, TOAD, HP Quality Center, Report Net, Framework Manager, Cognos 8 B Report Studio, Cognos 8 BI Query Studio, Report Net 1.1.