SUMMARY:

• Over 7 years of Experience in Software Quality Assurance and Testing in different environments and platforms.
• Expertise in Automated Software Quality Testing & Manual Testing of Web based and Client - Server applications.
• Extensive experience in Data Warehouse applications testing using Informatica Power Center on multiple platforms.
• Well versed with various types Software Development methodologies- Waterfall, Agile, RUP, and Iterative.
• Extensive experience in reviewing Business Requirement Documents, Software Requirement Documents and preparing Test Cases, Test scripts and Execution.
• Experienced in DW projects ETL testing against DW testing with Informatica, Ab Initio and data stage tools.
• Extensive experience in Test Data Management, creating test data suite, tracking the results and using for regression testing
• Good Knowledge on Business intelligence, OLAP, Dimensional modeling, Star and Snowflake schema, extraction, transformation and loading (ETL) process
• Testing and migration of Informatica workflows and mappings from one Repository to another Repository.
• Involved in fine tuning SQL overrides for performance Enhancements.
• Ability to develop complicated SQL script for Data validation testing by running SQL script, procedures.
• Proficient in SQL, Shell Scripting and PL/SQL coding and experience in Performance Tuning of SQL and Stored Procedures.
• Hands on experience in Performance Tuning of mappings, identifying and resolving performance bottlenecks in various levels like sources, targets, mappings and sessions.
• Having excellent knowledge in Unit Testing, System testing, Integration, Regression, End to End Testing.
• Having knowledge in Doing Estimation and Preparing Schedule for Different phases of Test cycle.
• Excellent knowledge in preparing Test case plans and RTM.
• Excellent experience in working with Quality Center.
• Excellent knowledge in Handing Critical Defects and Production Related Defects.
• Strong technical Knowledge of UNIX Utilities, Shell Script to automate process.
• Experienced with ETL tools like Informatica, SSIS, Ab Initio and Data stage.
• Experience in testing Business Report developed in Cognos
• Experience in Black box testing with a complete QA cycle - from testing, defect logging and verification of fixed bugs
• Extensive experience in Functional testing, Integration/System testing, Regression testing and User Acceptance testing.
• Excellent team player and excellent communication skills.

TECHNICAL SKILLS:

Data Warehousing: Informatica 8.6.1/8.1/7.1/6/5.1.1/1.75, Data Stage 8.x

Reporting Tools: Business Object XI 3.1, Cognos 8.0 Suite, Crystal Reports, SSAS, SSRS, MicroStrategy 8.x

Data Modeling: Star-Schema Modeling, Snowflake-Schema Modeling, Fact and dimension tables, Pivot Tables, Erwin

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

RDBMS: Oracle 10g/9i/8i/7.x, MS SQL Server 2005/2008, UDB DB2, Sybase, Teradata V2R6, MS Access 2008

Programming:UNIX Shell Scripting, Korn Shell, C Shell, Bourne Shell, Bash, SQL, SQL*Plus, PL/SQL, TOAD, C++

Web Technologies: JavaScript, HTML 4.0, and DHTML, .NET, Java, J2EE, XML, XSD, XSLT

Environment: UNIX, MVS, IBM AIX 4.2/4.3, Hyperion, Win 3.x/95/98, NT 4.0

Databases: Netezza NPS 8050

PROFESSIONAL EXPERIENCE:

Confidential, Alpharetta, GA

ETL /QA SQL Tester

Responsibilities:

• Analyzed business requirements, system requirements, data mapping requirement specifications, and responsible for documenting functional requirements and supplementary requirements in Quality Center 10
• Tested ETL jobs as per business rules using ETL design document
• Written numerous complex SQL Scripts to query the Teradata and Oracle DB for data validation.
• Interacted with users for designing UAT Test Plans and Test Cases
• Uploaded requirements into Quality Center and responsible for assigning the tasks in the Quality Center.
• Coordinated UAT with Business Users for all releases, production defects and application enhancements.
• Created test data to satisfy the requirement needs and to identify the functionality of the transformations.
• Maintained the results of test data and performed regression testing based on the result set.
• Worked with Informatica Power Center and tested numerous mappings.
• Identified, documented additional data cleansing needs and consistent error patterns by modifying ETL code.
• Get the daily, weekly and monthly status reports from the offshore and onsite team and Provide progress and status reports to the QA manager in one to one meetings
• Participated in test plan and test scenario walkthroughs and also in the UAT Kickoff Meetings
• Assisted in creation of Test plan documents with the lead and created numerous test scripts and test case documents and Traceability matrices.
• Extensively worked on Oracle DB and queried the DB using TOAD.
• Responsible for different Data mapping activities from Source systems to Teradata.
• Queried Teradata Database and validated the data using SQL Assistant.
• Liaison between the offshore team and the onsite QA team.
• Run batch jobs for loading database tables from flat files using SQL*Loader
• Effectively communicated the requirements and helped the offshore team in understanding the requirements and arranged meetings with the business analysts
• Scheduled the jobs using Auto sys and automated the jobs to be run at specific time and automated the reports.
• Written UNIX scripts to perform certain tasks and assisting developers with problems and SQL optimization.

Environment: Informatica 9, MS SQL Server 2008, Oracle 11g, SQL, PL/SQL, IBM DB2, AGILE, Teradata 12.0, SQL *Loader, Autosys, JCL, Mainframes, Toad, UNIX Shell Scripting, Windows XP/2000, Teradata SQL Assistant, Cognos 8.4, COBOL, ALM/HP Quality Center 11.

Confidential, Wilmington, DE

ETL/BI Test Analyst

• Created test case scenarios, executed test cases and maintained defects in internal bug tracking systems
• Developed and executed various manual testing scenarios and exceptionally documented the process to perform functional testing of the application
• Managed multiple OLAP and ETL projects for various testing needs.
• Debugging the SQL-Statements and stored procedures for various business scenarios.
• Written extensive PERL and UNIX Shell scripting for data parsing and text parsing needs including archiving the old data, running backend jobs & setting up of job dependencies.
• Performed extensive Data Validation, Data Verification against Data Warehouse
• Loading Flat file Data into Teradata tables using UNIX Shell scripts.
• Tested several Cognos Reports for several business needs including Dashboards, Drill-Down, Master-Detailed, Aggregated, KPI’s and Web Reports.
• Tested and validated the Report Net reports by running similar SQL queries against the source system(s).
• Did work with SOA testing involving SOAP, XML, and REST.
• Tested data feeds from XML to Database.
• Tested SQL queries, PL/SQL scripts to validate the data and performance of the database
• Extracted data from various sources like Oracle, flat files and SQL Server
• Tested and validated the cube data, ensuring that the data is correct by comparing the data results to comparable source system reports or by querying individual transactions and forms.
• Tested several Informatica Mappings to validate the business conditions.
• Testing the source and target databases for conformance to specifications
• Conditional testing of constraints based on the business rules
• Design and execute the test cases on the application as per company standards and tracked the defects using HP Quality Center.
• Helped the testing team documenting the system requirements and testing system development. Designed and implemented basic SQL queries for QA testing and report / data validation. Set up definitions and process for test phases including Product, Integration, System and User Acceptance testing (UAT).
• Accessing Mainframes and validating the data
• Worked with SQL, PL/SQL and functions to test the database integrity (Oracle).
• Creation of automated test scripts using QTP.
• Compared query result sets from different database systems using UNIX diff command.
• Designed and prepared scripts to monitor uptime/downtime of different system components
• Preventing occurrences of multiple runs by flagging processed dates
• Written Test Cases for ETL to compare Source and Target database systems.
• Testing of records with logical delete using flags
• Analyzed and created the bug tracking reporting and summary report in the Quality Center
• Interacting with senior peers or subject matter experts to learn more about the data
• Identifying duplicate records in the staging area before data gets processed
• Extensively written test scripts for back-end validations

Environment: SQL, Teradata V2R6, WinSQL, SQL Server 2008, QTP, HP Quality Center 10.0, Informatica 8.6.1/8.1, XML, XSLT, PERL, DTS, T-SQL, TOAD, Mainframes, Teradata SQL Assistant 6.0, Oracle 9i/10g, PL/SQL, MVS, IBM DB2, SAS, Cognos ReportNet8.0, MS Access/Excel/Visio, UNIX Shell Scripting

Confidential, Chicago, IL

ETL QA

Responsibilities:

• Extensively involved in Business Analysis and Requirements Gathering
• Analyzed business requirements and interfaced with vendors for development and enhancement of a system to support multiple business areas including Asset Management, portfolio management and risk management.
• Involved in gathering, analyzing, distilling and clearly conveying complex information to business and project team members through JAD sessions
• Involved in analyzing the requests for new, enhanced, and modified systems, against user and business requirements using RUP methodology
• Conducted interviews and facilitate requirements gathering, process analysis, and application design sessions with company staff across all levels and functions
• Developed Korn Shell Scripts and Perl Scripts to create fixed width files from flat file sources, to wrap Informatica Mappings and SQL code, and to validate/test the load process.
• Produced documents for business requirements (requirements matrix), design requirements, gap analysis, solution recommendations, test cases, test plans and guides
• Coordinated system walk through,, User Acceptance Testing (UAT) and facilitate issue resolution
• Written several shell scripts using UNIX Korn shell for file transfers, error log creations and log file cleanup process.
• 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.
• Performed Data Driven Testing of the Application for different users/data sets
• Preparation of test data for various levels of testing
• Gave production support in scheduling and tested this data with the existing data.
• Developed Test cases for the data warehouse in Oracle System
• Worked on Oracle to implement the project and written the Test Plan and Test Cases for the module Sales Cycle
• Extensively used SQL programming in backend and front-end functions, procedures, packages to implement business rules and security
• Developed detailed System test plan including test procedures and test cases
• Conducted Integration testing, Performance testing, Functional testing and Load testing to ensure that the application meets the requirements and to ensure usability readiness
• Developed test automation scripts for Regression and Performance testing
• Identified and resolved many application bugs and bottlenecks
• Verified all the functional and load requirements are met

Environment: SQL, PL/SQL, SQL Server 2005/2008, UNIX, Shell Scripting, Toad, Informatica Power Center 8.1, VBScript, Windows NT, Sun Solaris, Oracle 9i, Business Objects

Confidential

ETL Test Engineer - EDWH

Responsibilities:

• Tested all the DataStage jobs and ETL flow for data validation.
• Did data reconciliation for all the DataStage jobs for testing needs.
• Wrote test cases based on ETL mapping document for testing the entire ETL job.
• Involved in understanding of business processes to learn business requirements.
• Validated the data extracted from different systems into Source.
• Defined and implemented approaches to load and extract data from database using DataStage.
• Used Erwin for data modeling (i.e. modifying the staging and SQL scripts on Oracle and MS Access Environments).
• Conducted System testing for each phase of the application.
• Involved in preparing Test Scripts and Test cases based on the functional specifications.
• Executed backend testing of the application by writing SQL queries.
• Used Defect Tracking System Rational Clear Quest to report bugs found in different testing stages.
• Executed Test Procedures and documented Test Results
• Extensively used stages available to redesign Data Stage jobs for performing the required integration.
• Designed and developed UNIX shell scripts as part of the ETL process, automate the process of loading, pulling the data
• Executed jobs through sequencer for better performance and easy maintenance.
• Involved in unit, performance and integration testing of Data Stage jobs.
• Used Data Stage Director to run and monitor the jobs for performance statistics.
• Involved in performance tuning of the jobs.
• Used T-SQL for validating the data generated at OLAP server.

Environment: Oracle 8.0, Data Stage 6.x, SQL*Plus, SQL, Rational Clear Quest, Clear Case, SQL Server 2000, PL/SQL, Visual Basic 6.0, Windows 95, Test Director, XML, XSD, XSLT, Java and UNIX, Korn Shell scripting