SUMMARY

• 7 years of IT experience in the Testing, Analysis, design, and Implementation of ETL & Business Intelligence solutions using Data Warehouse/Data Mart Design, ETL, UNIX & OLAP
• Experienced in BCBS quality assurance and testing in Data Warehouse.
• Expertise lies in Functional testing, Manual Testing and Automated Testing, Regression testing, User Acceptance testing (UAT), System testing, Integration testing and Black Box Testing.
• Experienced in dealing with clients to gather requirements, understanding the Business requirements, product demonstrations and providing product support.
• Experience in full Software Development Life Cycle (SDLC) (designing, debugging, testing, documentation, maintenance and enhancement).
• Highly experienced with different RDBMS such as Oracle 9i and 10g, MS SQL Server 2000, Teradata and MySql.
• Experience in testing using both manual procedures and automated testing tools, coding, implementation of mainframe, client/server and web based applications.
• Experience in data analysis and problem solving with large amounts of data
• Hands on experience with analysis of business, technical, and functional requirements and Developed, Executed & Tested the test plans, test cases and test strategies..
• Expertise in creating Test Plan documents and developing test strategy documents and preparing the Traceability Matrices.
• Expertise in designing the test scenarios and scripting the test cases in order to test the application
• Expert in Mercury Test tools (QTP) Quick Test Pro, Test Director, Quality Center, Win Runner
• Expertise in Data Warehouse, ETL Verification, BO reports and Universe testing.
• Experienced in web and client/server applications QA in manual and automated testing (Win Runner, Load Runner, Quick Test Pro, Test Director, Rational SQA Suite / SQA Manager).
• Created and implemented Autosys Scripts to schedule and monitor jobs.
• Experienced in Developing, executing and modifying the UNIX Shell scripts In VI - Editor for Data Extraction and verification.
• Used Different Defect tracking tools like Bug Tracker, Rational test manager, HP Quality Center, Test Director and Rational Clear Quest to report bugs.
• Experience in writing over night batch processing for scheduling of daily tasks using UNIX shell scripts.
• Involved in generating Test Scripts using Quick Test Pro (QTP) for different transactions to execute Functional Testing, Regression Testing and Acceptance Testing
• Expertise in QA Testing in distributed UNIX Environment and Oracle databases as back end, Performed end-to-end testing & back-end testing.
• Experience in Installing and Configuring oracle Databases and extensively used Oracle 9i utilities like SQL Loader, SQL plus, Toad and Explain plan.
• Expert in backend testing using Oracle, SQL on SQL Server databases
• A self-motivated, responsible and reliable team player with a set of strong technical skills.
• Application Data warehousing experience in Financial, Banking, Pharmaceutical and Insurance.
• Extensive experience in manual testing the ETL and Business Intelligence Applications.

TECHNICAL SKILLS

ETL Tools: Informatica 8.6/8.1/7.1./6.2/6.1/5.1, Data Stage 8.x, SSIS, Ab Initio

Testing Tools: Win Runner, Test Director, HP Quality Center, Load Runner, QTP, Manual Testing

Database Management: Oracle 8i/9i/10g, SQL Server 2005/2008, MySQL, ODBC, DB2, TOAD 8.5, MS Access, Teradata V2R5/V2R6/12.0

Reporting Tools: OBIEE, Business Objects XIR3, Cognos 8.0 Series, Hyperion, Crystal Reports

Operating Systems: Window 2003 Server, Windows 2000 Advanced Server, Windows 98, Windows XP, Linux and UNIX(AIX)

Version control: Visual Source Safe, WINCVS, PVC, Rational Clear Case

Web Programming: HTML, XML,JSP, Java Script

Programming languages: C/C++, PL/SQL, VB 6.0, ABAP, Shell Scripting, PERL

PROFESSIONAL EXPERIENCE

Confidential, Boston, MA

QA Tester

Responsibilities:

• Conducted source-system data analysis to understand current state, quality and availability of existing data.
• Designed & Created Test Cases based on the Business requirements.
• Involved in extensive DATA validation using SQL queries and back-end testing
• Used SQL for Querying the database in UNIX environment for testing the business rules imposed on data movement.
• Involved with Design and Development team to implement the requirements.
• Developed and Performed execution of Test Scripts manually to verify the expected results.
• Validated dat design meets requirements and function according to technical and functional specifications.
• Used HP Quality Center to state requirements, business components, test cases, and test runs for every iterations, defects. Also link defects with requirements.
• Involved in recording change requests on the Change Request Form (Remedy) Participated in meetings.
• Performed all aspects of verification and validation
• Worked with other members of the QA and Development teams and offshore team in improving the processes, methods, effectiveness and efficiency
• Designed Source to Targets mapping.
• Used Clear Quest to track and report system defects and bug fixes. Written modification requests for the bugs in the application and halped developers to track and resolve the problems.
• Data Quality Analysis to determine cleansing requirements
• Coordinating with source system owners, day-to-day ETL progress monitoring, Data warehouse target schema Design (Star Schema) and maintenance.
• Generate data requirements and system specifications in an organized fashion for business solutions and for the developers to follow on.
• Used TOAD & SQL Navigator GUI tools for Querying Database.
• Participated in walkthrough and defect report meetings periodically.
• Documented and reported various bugs during Manual Testing.
• Involved in running the ETL loads in development server
• Written SQL Queries to define, Identify and validate the code written for the data movement into the database tables.
• Reported software bugs to the development team using Rational Clear Quest
• Developed PL/SQL procedures & triggers.
• Retesting the resolved defects/issues after the developers fix the defects
• Involved in preparing test data for UAT and participated in UAT signoff
• Created Logical Data Model as a blended configuration of Conceptual Model elements along with material deemed essential and/or useful from the source-system analysis.
• Developed the strategies for analyzing the data for ETL Team
• Updated the status of the testing to the QA team, and accomplished tasked for the assigned work to the Project Management team regularly.

Environment: MVS, ISPF, OS/390, JCL, COBOL II, VSAM Files, CA Erwin, Test Cases, Test Scripts, Test Plan, Copy Books,Oracle 10g, Teradata 12.0, Teradata SQL Assistant, SQL Server 2008, Flat files, XML Files, XSD, XML Spy 2010, Clear Quest, PL/SQL, TOAD, SQL, UNIX, Maestro 8.0 (Tivoli Work Scheduler), Quality Center 10.0, IBM AIX 5.3, Cognos 8.0 Series

Confidential, Wilmington, DE

QA Consultant

Responsibilities:

• Understanding of Business Logic and data flow.
• Participated in reporting summary documents reviews.
• Wrote MACROS in Teradata to generate less channel traffic and easy execution of frequently used SQL operations and improves the performance
• Developed Test Cases and Test Scripts for System and UAT Testing
• Worked closely with developers and report planners/analysts to insure dat an acceptance criterion is complete and accurate for desired report capability.
• Involved in preparing Test plans based on user requirement documents.
• Created test scenarios and test cases for the functionality, integration testing of the ETL,DDL,SQL and Unix scripts for User Acceptance
• Involved in installing and maintaining MS SQL Server 2000
• Participated in preparation of test cases for some reports to do the unit testing.
• Preparation of test scripts and test data.
• Used Clear Quest for repository, reporting bugs, tracking bugs and updates on resolved bugs.
• Used Mercury Quality center to manage the requirements, test cases and also defects.
• Executing the test scripts.
• Worked with understanding the COBOL Copy books for translating the test data from EBCDIC to ASCII format.
• Evaluate & Communicate test results.
• Scheduling and monitoring the ETL packages for daily load in SQL Server job Agent
• Preparation of defect log with screen shots.
• Responsible for different Data mapping activities from Source systems to Teradata
• Preparation of Defect Reports daily base.
• Frequently updated the requirement and defect status as per the current status of the testing project in the Clear Quest.
• Prepared Testing Plans and facilitated Functional testing, System testing and UAT. Prepared testing strategy, testing schedule, test cases for system testing and verified results to ensure dat they are aligned with the business objectives. Worked with the users to run the UAT process smoothly. Provided technical support and training to users
• Developed detailed Test Plans and Test Cases in Quality center and executed them.
• Follow up on bug fix with the developer.
• Ran all the UNIX scripts, ETL Workflows, BO reports and PL/SQL Packages as part of Regression testing.
• Integration Testing performed for the entire System after unit testing by executing the complete flow of the application system.
• Involved in indenting and CVS of all the views in the new database.
• Populated data into tables as part of other teams testing.

Environment: JCL Mainframes, Teradata SQL Assistant 6.0, SQL Server 2005,Teradata V2R6, Clear Quest, Oracle 10g/9i, Mercury QC, COBOL II, Micro strategy, SQL Server, SQL, PL/SQL, TOAD, UNIX, Windows XP, CITRIX.

Confidential, Newark, NJ

QA Analyst

Responsibilities:

• Involved in Business analysis and requirements gathering.
• Data migration - Includes migration of data from legacy environment to Oracle System.
• Involved in Data Validation using SQL queries.
• Responsible for creation of data extracts, data structures, reports, graphs, and other reporting objects.
• Identify issues, information and behaviors during the adoption of a proprietary information management system.
• Utilized Access database to collect data from multiple database sources using ODBC methods. Developed procedures for exporting information in Excel format in development server.
• Inserted charts dat displayed trends, historical inventory and sales levels in the Access application in real time.
• Clearly communicated and documented test results and defect resolutions during all phases of testing.
• Stimulated several production cycles. Worked with data validation, constraints, record counts, and source to target, row counts, random sampling and error processing.
• Performed Black-box testing, White-box testing, System Testing, Data Integrity Testing and end to end testing
• Implemented SDLC, QA methodologies and concepts in the Project
• Involved in Developing Test Plans and Developed Test Cases/Test Strategy with input from the assigned Business Analysts
• Developed UNIX batch jobs.
• Developed test scripts based upon business requirements and processes. Processed transactions from system entry to exit. Tested functionality across applications and workflows.
• Involved in developing Unix Shell wrappers to run various SQL Scripts.
• Extensively created UNIX shell scripts for scheduling and running the required jobs.
• Involved in testing the designing and development of data warehouse environment.
• Worked with appropriate business and technology leads to determine the acceptable range for test results and performance
• Tested the ETL Data Stage jobs and other ETL Processes (Data Warehouse Testing)
• 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
• Coordinated component, system testing with the appropriate technical groups and Release Management and documented test procedures and findings.
• Reconciled test results from different tests and different groups. Assessed readiness and deviation of product/project performance based upon test results and product specifications.
• Written several Korn Shell Scripts for performing various tasks like error loggin, archiving, cleanup move and add new data.
• Worked on profiling the data for understanding the data and mapping document.
• Reported bugs and tracked defects using Quality Center 8.0
• Performed the tests in both the SIT, QA and contingency/backup environments
• Involved in extensive DATA validation using SQL queries and back-end testing
• Used TOAD Software for Querying ORACLE and Used WinSQL for Querying DB2.
• Effectively coordinated with the development team.
• Created critical scenarios for each change request and defect request.
• Used the DataStage Designer to develop processes for extracting, cleansing, transforming, integrating, and loading data into data warehouse database.
• Extensively used Datastage manager to migrate code (dsx) to various project environments.

Environment: DataStage 7.0/6.1, Windows NT, UNIX Shell Scripting, IBM AIX 5.1, Oracle 9i/8i, SAS, SQL, PL/SQL, SQL*Loader, Business Objects XIR2, IBM UDB DB2, Crystal Reports, XML, MVS, COBOL, Flat Files, Test Plan, Test Script, ETL, XML Spy 2008, SAS

Confidential 

Software Test Engineer

Responsibilities:

• Involved in Business analysis and requirements gathering.
• Assisted in creating fact and dimension table implementation in Star Schema model based on requirements.
• Involved in complete project software development life cycle (SDLC) and Quality Assurance Life Cycle (QALC)
• Reported periodic project status and updates to the QA Lead and QA Manager
• Performed Integration Testing of different modules.
• Heavily involved in interacting with UNIX Shell scripts.
• Analyzed Business Requirements and Developed the Test Plan, Test Scripts and Test Cases
• Developed Test Plan and Test Cases for the entire module of Data mart.
• Identified the Test Cases to be automated and lead the effort for automating the product.
• Used Test Director to organize the Win Runner Scripts and schedule test execution.
• Ran various Batch jobs using telnet service (Unix)
• Automated the entire Aggregation module using Win Runner, for Regression Testing.
• Used Test Director for Bug Reports and Defect Tracking.
• Performed Risk Analysis based on Defect Severity and Priority.
• Tested User Interface inconsistency and application functionality.
• Developed test scenarios for testing Enterprise Data warehouse and Credit Data Mart data in DB2 environment.
• Developed SQL scripts to validate the data loaded into warehouse and Data Mart tables using Informatica.
• Developed Reports and Graphs to present the results to the management.
• Developed several Unix Shell scripts for running the jobs.
• .Performed Data Driven Testing of the Application for different users/data sets
• Preparation of test data for various levels of testing
• Performed segmentation to extract data and create lists to support direct marketing mailings and marketing mailing campaigns.
• Load new or modified data into back-end Oracle database.
• Optimizing/Tuning several complex SQL queries for better performance and efficiency.
• 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.
• Validated cube and query data from the reporting system back to the source system.
• Tested analytical reports using Analysis Studio

Environment: SQL, PL/SQL, Sybase 12.3, Informatica Power Center 7.1 (Power Center Designer, workflow manager, workflow monitor), Test Director, DB2, SQL *Loader, Cognos 7.0 Series, Oracle8i, SQL Server 2000, Erwin 3.5, Windows 2000, TOAD 7, IBM AIX 5.1, XML Files, VSAM Files, MVS, JCL