SUMMARY:

• Software Test Engineer with over 7+ years of experience in Software Testing, IT support, Test automation development and testing ETL, Data warehouse, Client/Server and web applications.
• Expertise in Functional testing, Manual Testing and Automated Testing, Regression testing, User Acceptance testing (UAT), System testing, Integration testing and Black Box Testing.
• Extensively used HP Quality Center and Mercury Test Director for Test Estimation, Test Planning, Test Designing, Test Analysis, Test Execution, Defect Tracking and Test Result.
• Experience in ETL methodology for supporting Data Extraction, Transformations and Loading process in a corporate - wide-ETL solution using IBM Datastage8.0,7.X/6.X (Manager, Designer, Director, Administrator), Parallel Extender, Data Mining, OLTP, OLAP
• Proficient in Defect management, including Defect creation, modification, tracking, and reporting using Industry standard Tools like Quality Center, ALM, Test Director, JIRA, Clear Quest experience in Testing BI applications using OBIEE, SSRS.
• Tested several complex reports generated by Micro Strategy including Dashboards, Summary Reports, Master Detailed, Drill down.
• Good understanding about Netezza architecture.
• Open to learning and using new systems involved in Python Programming
• Experienced in SDLC (Waterfall Model, Agile Model).
• Helped create a question bank on Abintio which could be used for internal certification
• Experience in writing complex SQL, Oracle PL/SQL queries including calling stored procedures by passing parameters, functions using SQL Developer and Toad as development tools.
• Familiar with SQL Server, Oracle PL/SQL Packages, Stored Procedures, Functions & Triggers.
• Work with companies to implement Python programming and train on-site Python Programmers
• Experienced in dealing with clients to gather requirements, understanding the Business requirements, product demonstrations and providing product support.
• Involved in Testing of reports by extracting the SQL generated by Micro Strategy and executed
• Experience in full Software Development Life Cycle (SDLC) (designing, debugging, testing, documentation, maintenance and enhancement).
• Experience with software test management tool HP Quality Center/ALM.
• Experience in data analysis and problem solving with large amounts of data
• Extensively used ETL methodology for supporting data extraction, transformations and loading processing, in a corporate-wide-ETL Solution using Informatica
• Worked with all kinds of components with Ab Initio including Dedup, Denormalize, Normalize, Rollup, Scan, Reformat, Redifine, Sort, Joiner, XML Read, XML Write, FBE, Partition Components.
• Hands on experience with analysis of business, technical, and functional requirements and Developed, Executed & Tested the test plans, test cases and test strategies.
• Experience with software Test Management tools Like HP Quality center/ALM
• Familiar with the use and working of Rational RequisitePro for requirements management.
• Expertise in Data Warehouse, ETL Verification, BI reports.
• Trained on reporting tool likes Micro strategy, Business Object and Cognos
• Experienced in web and client/server applications QA testing.
• Experience in Database performance tuning and optimization.
• Expertise in QA Testing in distributed Unix Environment and Oracle databases as back end, Performed end-to-end testing & back-end testing.
• Extraction, Transaction and Loading was done using different Components and different expressions using Ab Initio to create test data.
• Expert in functional and regression testing for web services using RESTful and SOAP UI
• A self-motivated, responsible and reliable team player with a set of strong technical skills.

TECHNICAL STRENGTHS:

Testing Tools: Mercury Test Director 8.2/7.2, HP, ALM, Quality Center 10.0/9.0

Operating Systems: UNIX, Windows 98/ NT/2000/XP, AS400, MQ.

Reporting Tools: SSRS 2005/2008, OBIEE 10.0.3, Business Objects XIR3

ETL Tool: Informatics, Datastage8.0,7.X/6.X,Data Mining, OLTP, OLAP, SSIS 2005, 2008 R2, Ab Initio, Data Stage, Micro strategy.

Database: DB2 8/7/5.1, Oracle 10g/9i, SQL Server 2008/2005/2000, Teradata.

Version Management: Rational Clear Case

Programming Languages: PL/SQL, Confidential -SQL, C, C++, Java, SQL

Other tools: Remedy (ARS) Trouble Ticketing, Rational RequisitePro.

PROFESSIONAL EXPERIENCE:

Confidential, Irvine, CA

ETL/Functional Tester

Responsibilities:

• Thorough understanding of the QA process, test cases, test plans and bug/defect reports using JIRA
• Worked in agile environment with appropriate business and technology leads to determine the acceptable range for test results and performance.
• Good understanding of various aspects of software and executed Test cases in Quality Center / ALM - Test Lab.
• Experience assessing testing processes, creating, implementing testing strategies and SQA strategies using Agile-testing methodology
• Experience in Data Warehouse applications testing using Informatica, SSIS, Shell Scripting, PL/SQL, Informatica, Data Stage and Ab Initio on multiple platforms.
• Analyzed issues and specifications for new and developments on JD Edwards Software.
• Used Quality Centre as the test management tool for the maintenance of the test cases and JIRA to track the defects.
• Extracted Data from Teradata using Informatica Power Center ETL and DTS Packages to the target
• Speak at conferences and make presentations regarding Python as well as its applications and features
• Assigned responsibilities of identifying bugs and monitoring defect tracking systems
• Assigned the tasks of tracking defects found at software release phase and develop test data to be used in software development life cycle
• Dealt with day to day technical support issues and enhancements associated with large JDE installation.
• 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.
• Uncommon ability to mentor other team members on JDE reporting technology
• Performed responsibilities of developing and executing functional test plans and test case
• Handle responsibilities of developing functional testing plans and performing end to end phases of test execution
• Performed research regarding Python Programming and its uses and efficiency
• Worked with Data Analysts to implement Informatica Mappings and Workflows.
• Responsible for documenting functional, regression, and acceptance testing procedure
• Requirement analysis.
• Managed application development and maintenance using the JDE toolkits.
• Test case creation and execution.
• 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.
• Created Technical Specification documentation based on Functional Specification.
• Extract appropriate logs and gather diagnostic information for issues encountered during testing
• Impact analysis and testing of Change Requests.
• Performed Regression testing, Integration testing, and Negative and positive testing.
• Review of test scripts and test execution.
• Communication with Developers and Product Engineers
• Worked on XML files and Autosys Jobs
• Worked on UNIX to run jobs
• Worked on Mindmap and Hexawise to organize and generate test cases.
• Used Sybase and SQL server Management Studio for validating data.

Environment: Informatica,Teradata, HP Quality center 10.0, Teradata, SQL Server, HP Quick Test Professional, Clear Quest, HP Quality Centre, JIRA, and XML, Sybase, Autosys,Netezza,Python.

Confidential, Eden Prairie, MN

ETL/Quality Analyst

Responsibilities:

• Strong knowledge of Software Development Life Cycle (SDLC - Feasibility Requirements Analysis, Design, Testing, Implementation, Support).
• Clearly communicated and documented test results and defect resolutions during all phases of testing.
• Tested Ab Initio graphs and used Ab Initio as an ETL tool to load the final loads.
• Simulated several production cycles. Worked with data validation, constraints, record counts, and source to target, row counts, random sampling and error processing.
• Performed Functional Testing, Data Integrity Testing and end to end testing
• Involved in Developing Test Plans and Developed Test Cases/Test Strategy with input from the assigned Business Analysts
• Tested the ETL Informatica mappings and other ETL Processes (Data Warehouse Testing Involved in extensive DATA validation using SQL queries and back-end testing
• Worked with appropriate business and technology leads to determine the acceptable range for test results and performance.
• Involved in adding Clients, Groups, members and processed claims in Trizetto Facets.
• Tested the Inbound / Outbound Interfaces to Facets and populated XML files.
• Tested the Data warehouse ETL process for both before data validation and after data validation process. Tested the messages published by ETL tool and data loaded databases
• Worked on profiling the data for understanding the data in source and mapping document.
• Written PL/SQL procedure and functions to test certain patterns in data and then to update the data as per business rules
• Tested database & UNIX Scripts needed to meet the system requirements.
• Optimized SQL queries for better performance during testing.
• Performed the tests in both the SIT, QA a nd contingency/backup environments
• Written several UNIX scripts for invoking data reconciliation.
• Involved in extensive data validation using SQL queries and back-end testing
• Used SQL for Querying the DB2 database in UNIX environment
• Prepared and ran regression scripts, shell scripts and performed sanity tests and end-end testing.
• Developed test plans based on test strategy. Created and executed test cases based on testand test plans based on ETL Mapping document
• Processed claims from different applications like 837 Transaction, Portal application, Legacy application and Trizetto Facets front end screens and verified claims processed correctly in Trizetto Facets.
• Involved in understanding the ETL mapping document and source to target mappings.
• Prepared the test plans and test cases for different functionalities involved in the application.
• Used Quality Centre as the test management tool for the maintenance of the test cases and to track the defects.
• Involved in testing NCPDP pharmacy claims and verified whether the Pharmacy claims routed to Trizetto Facets.
• Executed Test cases in Quality Center / ALM - Test Lab.
• Executed SQL Queries for testing integrity of data in database (Backend Testing).
• Tested the ETL mappings and other ETL Processes (Data Warehouse Testing).
• Performed the Smoke, Functional testing, Ad Hoc testing and Regression testing of the application.
• Developed different parsers scripts using python to handle bulk data
• Executed SQL Queries for testing integrity of data in database (Backend Testing).
• Analyzed and dissected system requirements and technical specifications to create and execute test cases for large business initiatives
• Ability to write test cases and execute testing within a web service environment and product test and driving defect resolution.
• Extensive experience in developing SQL scripts to validate the databases tables and reports data for backend database testing.
• Assisted business users in defining User Acceptance Testing, test cases and planning
• Co-ordinate testing efforts between onsite and offshore teams.
• Performed SQL validation to verify the data extracts and record counts in the database tables by writing complex SQL minus queries.
• Experience in manual testing which involves web-based application testing for provider and claims system.
• Actively involved in User Acceptance Testing (UAT) and Training of the end users. Participated in cross-functional teams to reengineer and improve business processes.
• Executed test cases and test scripts for manual and automation testing. Defects are raised in the HP Quality Center/HP ALM for logging, tracking and reporting bugs in the application.
• Tested a number of complex ETL mappings and extensively worked with flat files and excel sheet data sources. Wrote scripts to convert excel to flat files
• Scheduled and automated jobs to be run in a batch process
• Worked on issues with migration from development to testing
• Responsible for designing, developing and testing the software (PL SQL, UNIX shell scripts) to maintain the data marts (Load data, Analyze using OLAP tools).

Environment: INFROMATICA 8.1/7.1/6.2/5.1, AB Initio, HP Quality center 10.0, Teradata SQL Assistant 7.0, SQL Server 2005/2008, Micro strategy, SQL *Loader, SSIS, Oracle 9i, Erwin 3.5, Python,Windows 2000, TOAD 7, Shell Scripting, PERL, IBM AIX 5.2, TOAD, WinSQL, SQLPlus, XSD, XML, ALM,Netezza.

Confidential

ETL/DATA Centric Tester

Responsibilities:

• Developed test plans based on test strategy. Created and executed test cases based on test and test plans based on ETL Mapping document
• Involved in understanding the ETL mapping document and source to target mappings.
• Prepared the test plans and test cases for different functionalities involved in the application.
• Used Quality Centre as the test management tool for the maintenance of the test cases and to track the defects.
• Executed Test cases in Quality Center / ALM - Test Lab.
• Tested the ETL Informatica mappings and other ETL Processes (Data Warehouse Testing).
• Performed the Smoke, Functional testing, Ad Hoc testing and Regression testing of the application.
• Executed SQL Queries for testing integrity of data in database (Backend Testing).
• Performed backend and database testing: Oracle, MS-SQL Server, MS Access databases.
• Used PRISM for to get the HLD (High Level Design Document) AID (Application Interface Design Document) and Mapping Document.
• Used Web Services to subscribed, unsubscribed request, created alarms, created tickets to clear the alarms and close the tickets for cleared alarms.
• Performed functional testing and validated request and responses of Web Services.
• Used Quality Center for store the requirements, test cases, and execute the test cases and bug reporting.
• Tested different detail, summary reports and on demand reports.
• Performed backend testing for the front end of the application using SQL Queries in SQL Server database.
• Created manual Test Cases in HP QC/HP ALM for various User Stories based on Release and Sprint Plan.
• Responsible for designing, developing and testing the software (Informatica, PL SQL, UNIX shell scripts) to maintain the data marts (Load data, Analyze using OLAP tools).
• Used all the Informatica power center 9.1.0 client components like Designer, Workflow Manager, and Workflow Monitor.
• Used Informatica Power Center 8.6.1forextraction, loading and transformation (ETL) of data in the data warehouse.
• Optimized/Tuned 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.
• Tested UNIX shell scripts as part of the ETL process, automate the process of loading, pulling the data.
• Participated Weekly Team Meetings, Test Case review meetings and to updated the Weekly Status Report to Team Lead.

Environment: INFROMATICA 8.1/7.1/6.2/5.1, AB Initio, HP QTP 10.0, HP Quality center 10.0, Teradata SQL Assistant 7.0, SQL Server 2005/2008, Micro strategy, SQL *Loader, SSIS, Oracle 9i, Erwin 3.5, Windows 2000, TOAD 7, Shell Scripting, PERL, IBM AIX 5.2, TOAD, ALM,Netezza.

Confidential, Bradford, CT

ETL/SQL Tester

Responsibilities:

• Design and Development of QA documentation like Test Cases and Test scenarios from business and functional requirements.
• Identified the requirements and arranged peer reviews, walkthroughs and sign off meetings.
• Used HP Quality Center 9.0 for Test Estimation, Test Planning, Test Designing, Test Analysis, Test Execution, Defect Tracking and Test Result.
• Co-ordinate testing efforts between onsite and offshore teams.
• Performed SQL validation to verify the data extracts and record counts in the database tables by writing complex SQL minus queries.
• Experience in manual testing which involves web-based application testing for provider and claims system.
• Executed test cases and test scripts for manual and automation testing. Defects are raised in the HP Quality Center/HP ALM for logging, tracking and reporting bugs in the application.
• Promoted Unix/Informatica application releases from development to QA and to UAT environments
• Writing complex SQL queries for data validation for verifying the SSIS Packages and business Rules.
• Used the Data Stage Director and its run-time engine to schedule running the solution, testing and debugging its components, and monitoring the resulting executable versions.
• Experience in ETL Data Warehousing, database testing using DataStage for Workflow process.
• Create various test Batch jobs to run and monitor group of jobs with DataStage Director.
• Written test cases for checking the populated data correctly into fact and dimension tables.
• Created Test Case documents in MS Excel template from the Test Plan and the Business Requirements documents.
• Designed policies, standards and procedures for testing life cycle for the data warehouse and datamarts.
• Used Control-M scheduler to schedule the ETL processes
• Prepared test cases by understanding the business requirements Data Mapping documents and technical specifications.
• Used TOAD Software for Querying ORACLE. And Used Teradata SQL Assistant for Querying Teradata.
• 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.
• Tested reports using SSRS functionality like Queries, Slice and Dice, Drill down, @Functions, Formulae etc.
• Responsible for different Data mapping activities from Source systems to Teradata
• Extensively used Informatica power center for extraction, transformation and loading process.
• Wrote and implemented manual automated test scripts for Risk Warehouse decision support system using HP Quality Center.
• Extracted Data from Teradata using Informatica Power Center ETL and DTS Packages to the target
• Coordinated with development team in system integration test and services level unit testing.
• Responsible for identifying and defining the Key Performance Indicators in SSAS 2008.
• Exported Manual Test Cases from MS Excel template directly to HP Quality Center/ALM and executed all the Test Cases in Quality Center with Pass/Fail/Blocked status.
• Extensively worked with backend activities for testing several reports developed by BI tools. Written several complex SQL queries.
• Tested SSRS reports based on SSAS Cubes and OLTP with drill through and drill down capability to confirm with production reports run in Business objects/Crystal reports for cross verification
• Experience in testing SOA and Web services using tool tools like: REST and SOAP UI/XML Spy
• Published and Tested SSAS Cubes to Upfront by using Power play Enterprise Server
• Extensively used SQL Queries to verify and validate the Database Updates.
• Actively participated in creating requirements Traceability matrices and Test plans
• Prepared test requirements, test plan approach document and test cases.
• Performed Unit and functional testing for all the Mappings and Sessions.
• Tested Complex Reports in OBIEE functionalities like Slice and Dice Drill down Functions Cross Tabs Master/Detail and Formulae.

Environment: IBM Web sphere Data Stage 8.5/ 8.0.1/8.0/7.5/7.1, ALM, HP Quality center 10.0, QTP 10.0, OBIEE10.1.3, Oracle 10g, Teradata V2R6, SQL server SSIS (2008), SQL server SSRS (2008), SSAS, PL/SQL, Toad, XML, XSD, PERL 5.12.1,SOAP-UI, REST, XML Spy, Micro strategy, Excel, Ms PowerPoint, Autosys, UNIX, IBM AIX 6.1, Shell Scripting, Windows server,Talend.

Confidential, Buffalo, NY

Sr.QA/Manual Tester

Responsibilities:

• Verified the Online Services application to ensure that the requirements, artifact from each phase, and the final product--are complete and correct.
• Identified the requirements and arranged peer reviews, walkthroughs and sign off meetings.
• Defining and performing the Test strategies and associated scripts for the verification and validation of the application and ensuring that it meets all defined business requirements and associated functionality.
• Monitor security batch processing jobs in multi-platform shop via Control-M & Tidal Schedulers.
• Interacting with the Offshore Team members about the project status thru Conference calls and need to prepare a Teams of Memorandum for the same.
• Create Data Stage Parallel Jobs to extract, transformation and loading of the data using Data Stage design toll in the parallel processing mode.
• Used Data Stage to move data to the warehouse using the stored Procedure thereby enabling faster moment of data.
• Used the Data Stage Director and its run-time engine to schedule running the solution, testing and debugging its components, and monitoring the resulting executable versions.
• Performed the Unit and functional testing which validate the data is mapped correctly which provides a qualitative check of overall data flow up and deposited correctly in Target Tables
• Tested the application for web functionality, and verified the online modules for broken links.
• Experience with web technologies HTML, XML, X-PATH and Web Services
• Performed SQL validation to verify the data extracts and record counts in the database tables.
• Designed policies, standards and procedures for testing life cycle for the data warehouse and data marts.
• Performed usability testing frequently to ensure continuous availability of online services to personal clients.
• Expertise in Cube designing in Business Intelligence Development Studio ( SSAS ) to edit various properties of a cube, including the measure groups and measures, cube dimensions and dimension relationships, calculations.
• Created complicated reports using SSRS, SSAS to display key performance indicators and upload to Teradata tables using Teradata utilities FASTLOAD. Extensively written Teradata SQL Queries, creating Tables and Views by following Teradata Best Practices.
• Attended the Requirements reviews, Design reviews, Code reviews to understand the overall process flow and Source to Target Mappings.
• TOAD is used to test various ETL process flow graphs to meet the Business rules and Technical Requirements.
• Writing SQL Queries to retrieve data from data base.
• Responsible for testing packages using SSIS (ETL) to verify data completeness, data transformation, data quality, integration testing, UAT & regression testing.
• Divided the graphs into various phases and used checkpoints to avoid Dead locks.
• Extensively worked on debugging ETL process graphs.
• Used Rational ClearCase to maintain the versioning and change management for the test document repository.
• Developed and tested transformation functions and record formats for various input data files.
• Tested all formats of SSRS reports including Excel, PDF, CSV, XML, TIFF and many other
• Tested the SSRS report functionalities like Queries, Slice and Dice, Drill Down, Cross Tab, Master Detail and Ad hoc, Dashboards etc.
• Performed Data validation to verify the data extracts and record counts in the database tables.
• Conducted weekly batch testing to in corporate changes in new builds.
• Provided the management with weekly QA documents like test metrics, reports, and schedules.
• Experience in testing Web Services using SOA and tools like:- REST, SOAP UI/XML Spy.

Environment: IBM Websphere DataStage 8.5/ 8.0.1/8.0/7.5/7.1, ALM,HP Quality center9.2, QTP 9.2 Oracle 9i/10g, PL\SQL, OBIEE 10.1.3, SQL server SSIS (2005), SQL server SSRS (2005), SSAS, Teradata V2R6, Windows 2000, SQL, SQL Plus, UNIX, Rational Clear Case,, DB2 8.x, IBM AIX 5.5, MVS, ISPF, VSAM Files, Flat Files, XML Files, Shell Scripting, PERL, XML, XQuery, XPath XSD, TOAD, WinSQL