SUMMARY

• Over 11 years of IT experience in Software Testing, Analysis, design and development with Client/Server and Web applications.
• Extensive ETL testing experience usingInformatica (Power Center/ Power Mart) (Designer, Workflow Manager, Workflow Monitor and Server Manager) and SSIS and ICEDQ.
• Expertise in Data Base, Manual and automation testing with UFT(QTP), SOAP UI and good knowledge on Data Warehouse concepts.
• Expertise in writing test plans, test strategy, Test scenarios, test cases and test scripts and providing capacity and estimations.
• Experience in handling multiple projects and managing team of professionals with appropriate skills, attitudes and motivation.
• Extensively used ETL methodology for testing and supporting data extraction, transformations and loading process usingInformatica.
• Expertise in creating mock files, running SSIS packages and validating target data base.
• Expertise with test management tools HP ALM, Quality Center, Bugzilla, Req Pro, RQM, RCQ and MS WTT and Product Studio.
• Hands on experience in writing automation scripts, enhancing scripts and designing frameworks for end to end application automation.
• Expertise in validating data base objects like tables, views, Indexes, triggers, Cursors and stored procedures and Functions.
• Hands on writing complex queries using Oracle, SQL Server and DB2 data bases and validating back end data and target systems.
• Good knowledge of UNIX Shell scripting.
• Good knowledge and expertise in Health Insurance, Retail, Transportation and Logistics and Windows Operating systems
• Hands on generating reports and preparing test metrics for status updates and quality deliverables.
• Hands on experience in writing complex queries in Database and validating ETL transformations.
• Good knowledge of Installation, Repository creation, Domain Connections of Informatica, Oracle and SQL Server.
• Extensive experience in testing reporting tools like Business Objects, SSRS and Crystal reports.
• Experience and knowledge with Agile Methodology implementation.
• Good knowledge and implementation experience on Software Development Life Cycle (SDLC) and Software Testing Life Cycle (STLC) and Defect Life Cycle.

TECHNICAL SKILLS

Test Management: HP ALM, Quality Center, RQM, RCQ, Req Pro, Bugzilla, WTT and Product Studio.

Automation Tools: HP UFT, QTP, SOAP UI, Load Runner.

Data Warehousing: Informatica Power Center 9.1/8x/7x/6x,Repository Manager, Designer, Workflow Manager, workflow Monitor, SSIS, ICEDQ.

Databases: Oracle11g/10g/9i/8i/7.3,MS SQL Server 2014/2012/2008/2005, DB2, Teradata, MS Access.

Utility Tools: SQL Developer, TOAD and SQL Assistant, SQL Navigator

BI Tools: Business Objects XiR3/6.0, Crystal Reports 6.0.

Operating System: Unix, Linux, Ms - DOS, Windows ME/2000/03/07/NT/XP, Vista, Win7

Programming: Unix Shell Scripting, SQL, and PL/SQL, Java, Visual Basic, C, C++, XML, HTML.

Data Modeling: ERWIN 4.x/3.x, Ralph-Kimball Methodology, Star Schema, Snow Flake Schema, Fact Tables, Dimension Tables, Normalization, Denormalization.

PROFESSIONAL EXPERIENCE

Confidential, PA

ETL Test Analyst

Responsibilities:

• Reviewed Business requirements and Functional specifications to understand application and system functionality.
• Participated in daily meetings with Clients, stake holders and management for day today clarifications and concerns.
• Worked for multiple projects with multiple teams.
• Prepared Test Plan, Test Strategy and capacity plans for data migration from legacy systems to Target systems.
• Designed ETL test scripts based on mapping documents, reviewed scripts, prepared traceability matrix and test metrics.
• Prepared mock files, Executed SSIS packages and validated target data base to verify business rules are implemented.
• Designed rules with ICEDQ and validated target data against source legacy systems.
• Created customized reports to validate mapping rules in ICEDQ
• Created Users, Folders, Connections and Rules in ICEDQ
• Validating legacy OLTP systems with OLAP target systems.
• Validating Crystal reports and checking reports are generated as expectation.
• Designed complex queries in SQL Server to validate data loaded in target tables.
• Uploaded test cases to HP ALM, generated status reports and defects logged when deviations found in execution.
• Communicated work status on daily and weekly basis.

Confidential, Florida

Test Analyst

Responsibilities:

• Going through business requirements and use case documents to understand application.
• Preparing test plans, test strategy and capacity plans.
• Preparing test scenarios and test conditions based on use case documents.
• Designing detailed test cases and preparing test data.
• Enhancing and Running SOAP UI scripts and validating generated log files against the requirements.
• Writing complex SQL queries and tested back end data.
• Uploading test cases to HP ALM and generating status reports.
• Executing Integration, regression test cases.
• Defect reporting and working with developers in fixing the issues.
• Attending calls based on daily and weekly schedules.
• Providing status reports and notifying customer about issues and concerns.
• Supporting User acceptance testing

Confidential

ETL Tester

Responsibilities:

• Participate in Reviews, Walkthroughs and Meetings to understand system requirement specifications and documentation.
• Prepare test plans, test strategy and estimations
• Prepared Test scenarios and test cases based on ETL mapping documents.
• Running Informatica work flows and monitoring job logs and analyzing results.
• Validating that Null and Duplicate values are not loaded, unique and primary keys are maintained without breaking the relation of the columns.
• Ensure compliance to test scripts, maintenance procedures and quality standards.
• Writing SQL queries to validate Prepare the Test Cases/Test Scenarios besides performing basic queries required to edit and update data within the database including fields and tables.
• Validated Business object reports for format, structure, data quality, fonts, headers & cosmetic
• Performance of front-end GUI validation and back-end database verification in SQL.
• Involved in tracking & reporting functional defects, conducting functional and user interface testing for the application.
• Organize the status meetings and send the Status Report (Daily, Weekly etc.) to the Client
• Attend the regular client call and discuss the daily and weekly status with the client.

Confidential, Portland OR

Test Analyst

Responsibilities:

• Involved in gathering the business requirements and Usecase documents to understand the application.
• Identified test scenarios for automation.
• Established an automated test environment for UI and data base testing.
• Configured tool settings for Object identification and globalization.
• Developed and enhanced test scripts using Keyword driven methodology.
• Developed test scripts using descriptive programming.
• Reviewed test scripts and enhance the scripts based on requirement
• Involved in creating the automation framework, defining standards, defining testing practices, creating functions and project documentation
• Managed centralized project repository of function libraries, QTP scripts, and test objects
• Executed automation scripts to report test results and logs
• Defect reporting and intimating development team.
• Supported in preparation of frameworks, POC document and test strategy.
• Created reusable scripts and maintained object repository.
• Generated detailed test status reports, script log reports and graphical charts for management.

Confidential

ETL Tester

Responsibilities:

• Analyze the business requirements and specifications
• Designing test plan, test strategy and providing the estimations.
• Translating the requirements to appropriate test cases based on the business rules and ETL mapping documents
• Running work flows and monitoring job logs and analyzing results.
• Validating that Null and Duplicate values are not loaded, unique and primary keys are maintained without breaking the relation of the columns.
• Written complex queries in Teradata SQL assistant to check the data from Source and Target.
• Validated Informatica transformation to confirm data is extracted and loaded as per business rules.
• Validated target system with unwanted data, rejected records and cleansing data.
• Created 'mock' test data when production data is not available.
• Track and resolve issues identified in testing
• Document, update and organize all testing artifacts according to defined procedures and standards
• Requesting the production data load before execution of the jobs.
• Validating the Crystal Reports after execution of the batch jobs.
• Running the Unix batches to move the data from upstream to downstream systems
• Verifying the server log files for the database errors on daily basis.
• Tracking and reporting the status to business and Project Managers
• Providing test Metrics and deliverables to the business

Confidential

Retail Tester

Responsibilities:

• Going through the business requirements and specifications
• Prepared test scenarios and test conditions based on use cases
• Prepared test scripts and test cases based on the test conditions
• Prepared foundation data to validate business requirements
• Involved in functional and integration testing with RMS, RPM and SIM
• Writing SQL queries to validate foundation in data base.
• Validating back end system for inserts and updating of the data.
• Reviewing the defects logged by the team
• Validating Items maintenance, Price management and Stock maintenance to target whole sale and retail market.
• Involved in data base testing like verifying the foundation data
• Running the Unix batches to move the data from upstream to downstream systems.
• Preparing weekly and monthly status reports

Confidential, Redmond

Test Engineer

Responsibilities:

• Understand the requirements and specifications
• Creating work plans and mentoring and reviewing the work
• Participate in weekly t-cons and in-sync with off-shore and onsite team
• Prepare test bed as per the requirement
• Design and execute test cases for all the test passes as per the test plans.
• Participated in WAR meetings which conducted by MS
• Involve in Database Testing using SQL Server.
• Participate in debugging the applications.
• Develop automation scripts using .net frame work
• Involve in Regression testing, Sanity, Ad-Hoc and Exploratory testing.
• Involve in application compatibility testing.
• Defect reporting and tracking the status
• Update work status daily and weekly basis.
• Preparing in consolidated reports and sharing with client

Confidential, NH

Test Engineer

Responsibilities:

• Understanding the business requirements and specifications
• Involved in designing the scripts using record and play back.
• Executing automation test scripts for every regression.
• Debugging and running the scripts and generating logs.
• Logging defects and updating the status to leads.
• Involve in preparing test data.
• Co-operating the team to provide timely deliverables.