Quality Assurance Tester Sample Resume Format in Word Free Download -->

Quality Assurance Tester Sample Resume Format in Word Free Download

Sample Template Example of Beautiful Excellent Professional Curriculum Vitae / Resume / CV Format with Career Objective, Job Description, Skills & Work Experience for Freshers & Experienced in Word / Doc / Pdf Free Download


Alina
ETL/Backend   Tester
Email: alina@gmail.com


·          Over 7 years of experience in end to end development of software applications using Data Warehouse methodology in various phases of IT projects such as System Analysis, Design, Coding and Testing. Extensive experience in the implementation of Data Warehouse/ Data marts for business applications with Financial, Insurance, Manufacturing, Energy, Telecom etc.
·          6+ years of strong QA (Testing) and Data Warehousing experience in building and managing various Data Warehousing / Data marts using Informatica products such as Informatica PowerCenter 8.6,7.1/7.0/6.1/6.2.1/5.1/4.7, PowerMart 6.2/5.1/4.7, PowerConnect, PowerAnalyzer, and Power Exchange tools.
·          4+ years of experience in RDBMS technologies like Oracle 8x/9x, DB2 8.0/7.0/6.0, Teradata V2R5/V2R4/V2R3, MS SQL Server 2000/7.0/6.5, Dbase, Excel and MYSQL. SQL Developer, TOAD, Quest Central for DB2.
·          Strong experience in XML, XSLT, XPath and XML Spy.
·          Extensive experience in writing SQL and PL/SQL scripts to validate the database systems and for backend database testing.
·          Experience in using Automation Tools: Quick Test Professional, Win Runner and Quality Center in Client/Server
·          Proficient in working with Rule Files to build Dynamic Dimensions, add Attribute Dimensions, modify existing Dimensions and Members, and Load Data dynamically.
·          Good understanding of Design, modify and build BSO/ASO cubes and assign member properties to them.
·          Experience in Mercury Quality Center - Design Test Steps, Requirement Mapping to Tests, Executing Tests Manually, Defect Logging, Defect Reportin
·          4+ Years of experience in Relational modeling and Dimensional modeling (Star schema and Snowflake schema with FACT & Dimensions tables using Kimball and Inmon methodologies) and experience in logical and physical data modeling with Erwin 4.5/4.0/3.5.5/3.5.2, MS Visio.
·          Extensively used SQL, PL/SQL to create complex queries, SQL override, Stored Procedures, Triggers, CA Autosys, and BMC Control M and Maestro.
·          Worked on various Operating Systems which include Windows 95/98/2000/NT/XP and Linux (RedHat), UNIX (Sun Solaris 9.0/8.0/7.0, IBM AIX, HP UX 11i v1.5/1.6/2.0).

Education:   

Tools & Skill set.

ETL Tools
Informatica PowerCenter 7.1/7.0 (Repository Manager, Designer, Workflow Manager)/6.2(Source Analyzer, warehouse designer, Mapping Designer, Workflow Manager. Repository manager administration)/5.1/4.7(Source Analyzer, Data Warehousing Designer, Mapping Designer, Mapplet Designer, Transformation developer), PowerMart 6.2/5.1/4.7/1.7
Testing Tools
QTP 8.2, WinRunner 8x, Test Director, Quality Center, Load Runner 7x
Databases
Oracle 9i/8i/7.3, MS SQL Server 2000/7.0/6.5, IBM DB2 UDB 8.0/7.0/6.0/5.0, DB2/400, Sybase, Teradata V2R5/V2R4, Sunopsis, MS-Access and MYSQL.
Job Scheduling
CA Autosys, BMC Control M, Maestro.
OLAP Tools
,Business Objects XIR2/6.5.1/6.0/5.1.x/4.0Cognos 7.3 Series
Operating System
UNIX (Sun Solaris 9.0/8.0/7.0, HP-UX 11i v1.5/1.6/2.0, IBM AIX),WINDOWS 95/98/2000/NT/XP, Linux (RedHat),MS-DOS
Languages/
Utilities
SQL, PL/SQL, SQL Developer, TOAD, XMLSpy, Quest Central for DB2,UNIX shell scripts (Cron, C), Java, Servlets, XML, HTML, DHTML, C/C++, Visual Basic
Web Technologies:
XML, XSL, X
L, HTML, CSS, JavaScript, VBScript



Professional Experience

Citigroup, NJ                                                                                                                 Mar10 - Present             
DWH/ Quality Assurance Tester

One of the largest financial services in the world, Citigroup is a pre-eminent financial services company in more than hundred countries is organized into three major business groups – Global Consumer, Corporate and Investment Banking, and Global Wealth. Project involved developing a reporting service using Essbase server to analyze the expenses incurred on Legal services based on different region/division. The data is obtained from disparate sources like flat files, oracle, and general ledger and Sql Sever tables.
Responsibilities:
·          Experienced in writing test cases, test scripts, test plans and execution of test cases reporting and documenting the test results using Mercury Quality Center
·          Involved in automation of test cases using QTP.
·          Used QTP for Checkpoints, Regular Expression and Accessed Data Tables for multiple applications.
·          Performed the Back-end Integration Testing to ensure data consistency on front-end by writing and executing SQL statements
·          Load new or modified data into back-end Oracle database
·          Worked with QTP for Regression Testing
·          Developed ETL Test Plan and Test Strategies for the entire Line of businesses.
·          Extensively used SQL queries for Database testing and Validation.
·          Involved in extensive backend testing.
·          Worked on Informatica Power Center tool - Source Analyzer, Data warehousing designer, Mapping & Mapplet Designer and Transformation.
·          Solid Back End Testing experience by writing and executing SQL Queries Responsible for testing Business Reports developed by Business Objects XIR2.
·          The reports that were created in Business Objects were testing by running the SQL statements
·          Tested PL/SQL statements to verify the output and compared against ETL Output.
·          Designed and developed Test Plans and Test Cases and executed them.
·          Developed Test Cases for testing the mapping designs before going to the production phase.
·          Written several UNIX Shell Scripts for cleanup, logging, file manipulation and transferring the files.
·          Involved in functional testing the Web application using Quick Test Pro.
·          Used Rational ClearQuest the defect tracking tool for retesting the CQ’s and creating the new issues using the CITRIX as webInterface
·          Extensively used Informatica power center for extraction, transformation and loading process.
·          Worked with Teradata SQL Assistant for data retrieval.
·          Vigorously worked on Manual Testing by writing the Test Cases and executing the Test Scripts for various scenarios.
·          Execution of QTP Script for automation testing, analyzing the automation result.
·          Involved in all testing phases: Unit Testing, System Testing, Regression Testing, Integration Testing, and Quality Assurance Testing.
·          Transformation of XML documents using XSLT.
·          Developed XML Schema and DTD using XML.
·          Modified the UNIX scripts for Testing purpose to check the Rollback mechanism, Restatement window logic, wrapper scripts etc.
·          Involved in executing the UNIX shell scripts for loading the data from the Source to the Datamarts.
·          Tested the data and data integrity among various sources and targets.
·          Involved in Front-end testing for the Application.
Environment: Informatica PowerCenter 7.1, Business Objects XIR2/6.5 , XML, XML Spy 2008, XSD, XPath, Oracle 10g, Flat Files, SQL, PL/SQL, SQL * Loader, UNIX(Cygwin), TOAD 9.5, Teradata SQL Assistant 6.0, Teradata V2R6 (MLOAD, FLOAD, FEXPORT, TMPUMP, BTEQ), UNIX Shell Scripting, HP Quality Center 9.2, QTP9.2, VB .NET, Rational Clear Quest, Windows 2000, MQ Series, Citrix 8.0.







PNC Financial Services, Pittsburgh, PA                                                                                                 Mar08 – Feb10              
ETL /BI  Tester
PNC Financial Services is a U.S.-based financial services corporation, with assets (as of December 31, 2008) of approx. $291 billion. PNC operations include a regional banking franchise operating primarily in eight states and the District of Columbia, specialized financial businesses serving companies and government entities, and leading asset management and processing businesses. PNC is America's 5th largest bank by deposits and is the third largest bank off-premise ATM provider in the country
Responsibilities:
·          Interacted with the Business users to identify the process metrics and various keys dimensions and measures.
·          Worked on a   Business Intelligence reporting system that was primarily functioning on Oracle Applications OLTP environment with Business Objects for Business Intelligence reporting
·          Well exposed to Software Development Life Cycle and Test methodologies.
·          Extensively involved in writing Test Plan, Test Cases, based on Business Requirement Documents, Functional Requirement Specifications, and Design Specification document generated and executed Test Scripts.   
·          Extensively used SQL programming in backend and front-end functions, procedures, packages to implement business rules and security
·          Experience in ETL Data Warehousing, database testing using DataStage for Workflow process.
·          Developed complex queries using different data providers in the same report.
·          Developed test scripts using QTP for Functionality and Regression Testing
·          Tested the reports using Business Objects functionalities like Queries, Slice and Dice, Drill Down, Cross Tab, Master Detail and Formulae etc.
·          Heavily interacted with ETL team for testing data Quality and data Validation.
·          Written several backend SQL queries and was involved in enhancing the performance by tuning the SQL queries.
·          Was involved in design part for Extracting data from different source systems into the target database using Datastage Server 7.1.
·          Involved in creating Test Matrix for various work streams for traceability purposes.
·          Involved in writing Test cases for all the links and various data files based on ETL Mapping document.
·          Wrote test procedures for back end validation via functional specifications
·          Prepared SQL scripts for test data preparation for Back End functionality testing
·          Performed back up project management duties
·          Conducted the Functional, System, Regression, and Performance testing of the Web application using Mercury tools Quick Test Pro and LoadRunner.
·          Extensively used PL/SQL queries to perform operations like joins in the databases
·          Worked with several sources for understanding the business needs for performing both positive and negative testing.
·          Transformed the XML documents into various form using XSLT.
·          Extensively involved in testing the XML files and checked whether data is parsed and loaded to staging tables.
·          Executed UNIX Shell Scripts for Batch Job Execution.
·          Written several UNIX scripts for running test loads for regression testing purpose.
·          Responsible for weekly status Reports, Performed functional, Integration, Regression testing.

Environment: Ascential Data stage 7.1, DB2 9, Business Objects XIR2/6.5.1/6.0/,MS SQL Server 2000, QTP ,SQL, Win SQL Professional, XML, XML Spy 2008, XSD, XPath, l, Novell client 4.91, IBM AIX 5.1, MS Visio 2003,MS Excel 2003, Lotus notes 6, PeopleSoft 8, Oracle10g, Erwin 4.0, Toad.










Credit Suisse, New York, NY                                                                                                             Jan07–Feb08             
QA /SQL Analyst

Credit Suisse is a diversified financial services company advising clients in all aspect of private and investment banking solutions. Project required maintenance of multi-dimensional databases for its budgeting, sales forecasting, marketing analysis and reporting using their Cognos and BI Tools suite. Reports were delivered via the Excel Add-in and Cognos.

Responsibilities:
·          Worked on Informatica PowerCenter – Source Analyzer, Data warehousing designer, Mapping Designer & Mapplet, and Transformations.
·          Test Automation using Mercury Winrunner, provided hands on mentoring in architecting and building a fully Automated Testing Framework for regression tests and repeatable system test cases.
·          Used most of the Transformations such as the Source qualifier, Aggregators, lookups, Filters & Sequence, Joiner, and Expression as per the Business requirement.
·          Creating and running Sessions & Batches using Server Manager to load the data into the Target Database.
·          Used various checkpoints in the Informatica designer to check the data being transformed
·          Performed User Acceptance Testing and Regression testing.
·          Created Jobs to Schedule multiple reports in Cognos Connection.
·          Detailed repeatable end to end test cases for application, interviewed developers to gain detailed information on complex calculations and backend exception processing in order to validate the back end utilizing SQL Plus
·          Involved in Manual Testing, Functional testing (Black Box Testing), Regression and Automated testing of the application using Mercury Interactive Test Suite.
·          Organized sessions in a batch to run the sessions in a batch in sequential order or start them concurrently by the server.
·          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 the error checking and testing of the ETL procedures and programs Informatica session log.
·          Moving Data into Target using Sessions and Batches.
·          Developed and involved in both Manual Testing and Automation Test scripts based on Use cases developed.
·          Wrote automated test scripts using WinRunner.
·          Involved in implementation of the Test plans, Test cases and Test scripts
·          Involved in system Integration testing (SIT), System Verification Testing (SVT) and User Acceptance Testing (UAT).
·          Application was updated twice a week, so that all the Test Procedures created as Baseline can be played back to perform Regression Testing Reported and tracked bugs using Mercury Test Director
·          Involved in various testing phases like Unit Testing, Integration Testing, Validation Testing and Performance Testing
·          Developed test reports, which compare the sources and the desired targets.

Environment: Quality Center, Informatica Power Center7.2/6.1,Cognos 7.3, Toad 7.0, Oracle 9.2, Sunopsis, MS SQL Server 2000, IBM Mainframes, Mercury Interactive WinRunner ,DB2 8.1.8, COBOL II, XML 1.1, PL/SQL, SQL, SQL Plus, IBM), HTML, VB Script, Windows 2000











Komastu American International, Rolling Meadows, IL                                                                Nov05 –Dec06
ETL QA Analyst
    
Komatsu is the second-largest, fully-integrated manufacturer and supplier of construction equipment in the world, from the smallest compact construction size to the largest mining size. It has a network of manufacturing plants and parts distribution centers in North America with approximately 2000 employees. Komatsu integrated enterprise solutions across Hyperion Essbase and used Hyperion Reports to generate analytical reports
Responsibilities:
·          Designer for mappings and coding it using reusable mapplets using from various sources involving flat files and DB2 tables.
·          Scheduling the session’s tasks comprising of different mappings in order to load data into DB2 database Tables.
·          Extracted Data from Teradata using Informatica Power Center ETL and DTS Packages to the target database including SQL Server and used the data for Reporting purposes
·          Involved in installation and migration of Hyperion modules for better performance.
·          Involved in Regression and Automated testing of the application using Mercury QTP
·          Worked extensively with complex mappings using expressions, aggregators, filters, lookup and procedures to develop and feed in Data Warehouse.
·          Major involvement in tuning the mappings, to perform maximum efficiency and performance complete knowledge of session properties in server manager.
·          Involved in the error checking and testing of the ETL procedures and programs Informatica session log.
·          UNIX scripts were written at various situations like job scheduling etc. Wrote different stored procedures for Pre-Load and Post-Load Jobs.
·          Coordinated with QA Testing Team to test various test scenarios involving Test Plans, Test Cases, and Test Scripts.
·          Transformation of XML documents using XSLT.
·          Worked with XML feeds from multiple sources systems and loaded the same into Enterprise data warehouse
·          Involved in Manual Testing of the application.
·          Involved in Unit, Functional, Regression and System testing.
·          Extremely involved in using Test Director for identifying the bugs with the help of SQL queries.

Environment: Informatica Power Center 6.1/6.2, Informatica Power Connect, MS Visio 2002, Oracle 8i/9i, Systems MS SQL Server7/2000, IBM DB2/400, IBM AS/400, Teradata V2R5, MS Excel 97, Flat files, PL/SQL, SQL, Toad 7.0, Windows 2000, MQ Series ,Transact-SQL, SQL*Loader Mercury QTP, Windows 2000, HP-UX 11.x Unix (ksh) Shell


Radian Group Inc, Philadelphia, PA                                                                                                   Dec04 –Oct05
ETL QA Analyst

Radian is a leading provider of credit enhancement for the global financial and capital markets. Project had Oracle and flat files as sources and Oracle as the warehouse database. The modern trends of data warehousing and relational database management were methodically adopted for developing an efficient database. Hyperion analyzer was effectively used on this database for reporting system. Equally validated and updated data was available to the users, though restricted by their authorized access levels.
Responsibilities:
·          Worked on Informatica Power Center 6.1 tool (Workflow Monitor, Workflow Manger, Mapping & Mapplet Designer and Transformation Developer) to transform data mainly from DB2 and Flat Files and load that data to Oracle.
·          PL/SQL queries were written to perform operations like joins in the source database.
·          Involved in Unit, Functional, Regression and System testing.
·          Documented and reported various bugs during Manual Testing.
·          Designed and created various Test Plans, Test Cases and Test Scripts based on the application requirements.
·          Analyze business requirements (e.g., business logic, Process specs, process flows). Developed test plans and test cases based on the business requirements.
·          Used various SQL queries to validate the test case results for back-end test cases. Written SQL Queries to define, Identify and validate the code written for the data movement into the database tables.
·          Used various regressions testing on front-end and back-end test cases. Performed various load testing using Load Runner.
·          Designed and developed Test Plans and Test Cases and executed them.
·          Documented Defects found during test on the Test Director system and communicated, recorded problems to the responsible QA or development personnel.
·          Interact with analyst, system staff, business user and developers. Provide input and documentation to System Level Test Plan and facilitated project deliverables
·          Development of Unit Test Plans, Integrated and System test plans
·          Stored data in the Data Warehouse about Customers, Accounts. The loads were scheduled (Daily and weekly) depending on the frequency of source data.
·          Participated in walkthrough and defect report meetings periodically.

Environment: Informatica Power Mart 5.1, Oracle 8, MS SQL Server, IBM Mainframes, DB2, COBOL, XML, PL/SQL, SQL Plus, SQL, Transact-SQL, SQL*Loader, , UNIX, QTP, Windows NT.








Patni Computer Systems, India                                                                                    Jan03- Nov04   
Role: Oracle developer
Patni Computer Systems is a leading provider of information technology services and business solutions. Project involved creating packages, function and procedures and implements them to various stages of software development life cycle.
·          Coordinated with users to define and design needs, developed technical solutions ensuring technical integrity.
·          Extensively developed PL/SQL procedures, functions and Packages.     
·          Developed database Triggers to enforce security. 
·          Load data into tables and schemas with the help of SQL * Loader Utility.
·          Created views to resolve complex query.
·          Involved in tuning SQL using Explain Plan.
·          Coordinated with other team members in testing new implementation and bug fixing.
·          Prepared user manual and technical support manual. 



Download Resume Format 

0 comments:

Post a Comment

Resumes By Categories

1-5 Years Experienced CV 10-15 Years Experienced CV 10th Standard 12th Standard CV 15-20 Years Experienced CV 20-25 Years Experienced CV 30+ Years Experienced CV 5-10 Years Experienced CV Accounts CV Aeronautical CV Automobile Engineer B Com CV B Pharma CV B.Tech CV BA CV BA Philosophy CV Banking CV BBA CV BCA CV BDS CV Beautiful CV Bio Technology CV BMS CV BPO Call Center CV BSC CV BSC IT CV Business Analyst CV CA CV Cashier CV CEO CV CFA CV Chemical CV Civil Engineering CV Commercial CV Cook CV Cover Letter for Resume CS CV D Pharma CV Diploma CV Doctor CV draff Economist CV Electrical CV Electronics CV Engineer CV Fashion Designer CV Films CV Finance CV Foreign Resume Format Fresher CV GM CV Hotel Management Housekeeping CV HR CV ICWAI CV Import Export CV Instrumentation CV Insurance CV IT CV ITI CV journalist CV LLB CV M Com CV M Pharma CV M Phil CV M Sc Computer Science CV M Tech CV M.Tech MA CV Manager CV Marketing CV Mass Communication CV MBA CV MBA Event Management MBA Finance MBA Hospitality CV MBA HR CV MBA IB cv MBA Marketing MBA Production MBA Quality MBA SCM CV MBA System MCA CV Mechanical CV Medical Representative CV Mining CV MMS CV MSC CV Over 25 Years Experienced CV Paint Technology CV Pharmacy CV Phd CV Philosophy CV Project Manager CV Psychology CV Purchase CV Quality Engineer Real Estate CV SAP ABAP CV SAP Basis SAP BI CV SAP BO CV SAP CRM CV SAP CV SAP FICO CV SAP HR CV SAP MM CV SAP PP CV SAP SD CV SAP Security Six Sigma CV Special Resume System Administrator CV Teacher CV Textile CV Treasury CV USA Resume Web Designer CV