SUMMARY

• Over Seven years of diversified experience in Quality Assurance Analyst, ETL Testing, Database testing and BI Data warehouse applications.
• Extensive Experience in testing Large scale Data Warehouse/ETL, Business Intelligence (BI) applications and writing SQL queries.
• Strong experiences of testing data warehouse/datamarts for business application with Banking and Insurance Domains.
• Proficient in Software Development and Software Testing Lifecycles; including Test Strategy preparation, Test Plan Development, Test Case Creation, Test Execution and Bug Tracking.
• Well experienced in various Test tools such as HP Quality Center (QC) Requisite Pro, Bugzilla, HP QuickTestPro(QTP), Experience in UI testing, UAT testing, Functionality testing, System Testing, Performance Testing, Database testing and report testing.
• Possess excellent analytical, presentation, interpersonal and solid communication skills and ability to work independently as well as in a team environment.
• Extensive knowledge and experience in all phases of application/software development lifecycle (SDLC) including Requirements, Analysis, Design, Development and Testing, and software testing life cycle (STLC).
• Working knowledge of Software Development life Cycle such as Waterfall, Agile (Scrum) and Rational Unified Process (RUP) methodologies.
• Professional in preparing the Requirements Traceability Matrix and mapping it to the requirements.
• Solid experience on Data warehousing, Data modeling, Data integration, Data Migration, ETL process and Business Intelligence.
• Strong Experience in all aspects of analytics/data warehousing solutions (Database issues, Data modeling, Data mapping, ETL Development, metadata management, data migration and reporting solution)
• Excellent technical and analytical skills with clear understanding of design goals of ER modeling for OLTP and dimension modeling for OLAP
• Proficient in analyzing business requirements and functional specifications to develop and execute test plans.
• Extensive experience on Microsoft Project.
• Working Experience in integration testing, system testing, and User Acceptance Testing (UAT).
• Extensively used ETL methodology for testing and supporting data extraction, transformations and loading process, in a corporate - wide-ETL Solution using DataStage and SSIS.
• Extensively used tools like Quality Center/Test Director and Clear Quest for defect tracking and change management.
• Hands-on experience on relational database management systems such as Oracle and SQL Server Management.
• Experienced in testing database tables, views, triggers, and stored procedures
• Strong knowledge in Analyzing business requirement documentations (functional and non-functional), and use case diagrams.
• Experience in testing ETL packages to validate quality of the transformed data.
• Strong knowledge of SQL Server, database design, T-SQL and Business Intelligence (SSRS, SSIS and SSAS).
• Strong understanding of Data warehouse concepts, ETL, Star Schema, Snowflake, data modeling
• Analyzed user requirement and prepared test plan and test cases for the data warehouse implementation process.
• Experience in extensive use of Web Services add-in for performing SOAP API testing for conducting UI frontend content verification with XML schema structure.
• Experience in using Functional Tester and Quick Test Professional (QTP).
• Experience in customizing and testing various ERP and CRM (Billing) modules such as Billing, HR, payroll, and financial (fixed asset, inventory, & procurement) modules.

TECHNICAL SKILLS

Testing Tools: Quality Center, Load Runner, ALM, Quick Test Professional (QTP)

ERP: CRM(Billing) and AGRESSO ERP (HR, Payroll, Financials)

Data Warehouse and Business Intelligence Tools: SQL Server Reporting Services (SSRS), SQL Server Analysis Services (SSAS), SSIS - 2005, 2008, 2008 R2, Data Stage, OBIEE.

Programming Languages: Java, VB Scripting, C#, XML and T-SQL.

Databases: SQL Server 2005/2008/R2, Oracle, MS Access.

Operating Systems: Windows Server 2003/2008/2008 R2

Browsers: MS Internet Explorer, Mozilla Firefox, Chrome, Safari, Opera

Methodologies: RUP, Waterfall, Agile

PROFESSIONAL EXPERIENCE

Confidential, Novato CA

ETL Tester

Responsibilities:

• Analyzed business requirements, system requirements, data mapping requirements, data mapping requirement specifications, and documented functional requirements in Quality Center.
• Performed backend testing and made sure the product met user requirement
• Tested the ETL Data Stage jobs and other ETL Processes (Data Warehouse Testing).
• Tested reports and ETL mappings from Source to destination
• Executed test cases in sessions and batches and tracked the defect log file for failed sessions
• Conducted Regression Testing after the developer released any updates or bug fixes.
• Verified and validated if the data format is consistent in both source and target platforms
• Used SOAPUI for checking the correct transmission of data.
• Created a job that creates the XML file, and sends the file via secure ftp.
• Created schemas, views, stored procedures, Triggers and functions for Data Migration.
• Designed the Logical and Physical databases of SQL Server.
• Load the staging environment from Excel sheet and flat files using SSIS
• Developed and maintained ETL Processes and populated various Datamarts.
• Wrote SQL queries to validate whether actual test results matched with expected results
• Tested the data loading processes, functionality of applications and reconciled back to source systems.
• Verified and validated if the data format is consistent in both source and target platforms.
• Involved in defining the source to target data mappings, business rules and data definitions.
• Performed Web Service API testing for UI content verification and validation with business logic XML schema.
• Prepared Test cases, test scripts, test scenarios and results documentation in Quality center (HP ALM Suite).
• Wrote test cases in Quality center and raised defect in QC.
• Consistently worked with Quality Center (ALM Suite) for reviewing and analyzing requirement, planning and execution of test cases, tracking defects.
• Maintained the track of defect and defect report in QC and conducted defect review meeting.
• Written manual SQL Queries and fired them on OLAP-Database to compare the results.

Environment: Microsoft SQL Server 2005/2008/2012, MS Windows Server 2003/2008, SSAS, SSIS, SSRS, Visual Studio 2008, ASP.NET, T-SQL, PL/SQL, XML, IIS 6.0/7.0.,JIRA.,BI Express,HP Quality Center 10.0, Rational Clear Quest, ALM, Unix, DB2, XML Files, Teradata, Teradata SQL Assistant

Confidential, San Francisco, CA

ETL Tester

Responsibilities:

• Prepared Test Plans and Test Cases from the User Stories
• Tested ETL Mappings and flow of data from Source to Target
• Tested the load process of ETL to make sure the data is populated according to the specified data transformation rules.
• Performed end to end Data warehouse system Integration testing & test deliverables.
• • Creation of Stored procedures a
• Tested name change consistency between different Entities and Views
• Tested different forms to see whether the UI as well as the data populated are as per the User Stories.
• Prepared UAT documents for the Clients to give guidelines as to how to test and areas to be tested after migration.
• Participated in translation of business needs into technology requirements to support the company’s business objectives.
• Applied Agile SDLC methodologies
• Conducted performance, Stress and Volume Testing
• Data validity and data integrity testing of the migrated data
• Worked closely with the Developers to isolate, track and troubleshoot defects.
• Analyzed user requirement and prepared test plan and test cases for the data warehouse implementation process
• Verified test loads to confirm the correctness of data and to estimate the running time for the data load.
• Wrote SQL scripts to Insert, Update and Delete data in MS SQL database.
• Verified naming standards, data integrity and referential integrity
• Tested ETL mappings that are designed to enable the extracting, transporting and loading of the data into target tables.

Environment: Microsoft SQL Server 2005/2008/2008 R2/2012/, SSAS, SSIS, SSRS, Visual Studio 2005/2008, Microsoft SharePoint Server 2010,QTP,LoadRunner, IBM Info sphere,, Data Stage and QC, HP Quality Center 10.0, Rational Clear Quest, Unix, DB2, XML Files, OBIEE, Teradata.

Confidential, Agoura Hills, CA

ETL Tester

Responsibilities:

• Analyzed business requirements document and System requirement specification to put together a test plan.
• Documented the errors using Test Director and tracked them to completion by communicating and co-coordinating with the development as well as the support group.
• Reviewed test plans to ensure adequate testing coverage of requirements and design.
• Wrote test strategies and Reviewed with stakeholders.
• Ensured creation of test strategies and plans according to set standards.
• Designed and Documented Test Procedures and Test Cases for user acceptance, functional and integration testing.
• Developed And maintained a very healthy relationships with stakeholders, senior business leads, Project Manager and Business Analyst
• Assigned severity levels to different test cases and prioritizing them. Thereafter, performed testing in that manner using Quality center
• Performed Manual Testing for the Functionality of the application.
• Used DATASTAGE as an ETL Tool for Developing the Data Warehouse.
• Collected and analyzed test metrics and subsequently submitting reports to track the status and progress of the testing effort.
• Used Test Director for test documentation management and defect tracking.
• Wrote SQL statements to check the validity of database and to do the backend testing.
• Extensively used DataStage Tools like Infosphere DataStage Designer, Infosphere DataStage Director for developing jobs and to view log files for execution errors.
• Scheduled job runs using DataStage director, &used DataStage director for debugging and testing.
• Performed Tuning ofDataStageJobs for better performance.

Environment: Microsoft SQL Server 2005/2008/2008 R2/2012/SSAS,SSIS, SSRS, Visual Studio 2005/2008, T-SQL, PL/SQ,XML, IIS 6.0/7.0, Quality Center, Load Runner, Data stage, OBIEE, and UNIX Platform.

Confidential, Minneapolis, Minnesota

QA Analyst

Responsibilities:

• Conducted manual testing insuring that all modules performed as specified in the requirements.
• Analyzed Requirements identified test scenarios and executed test cases.
• Conducted meetings to track progress with developers concerning defect tracking.
• Performed every process of the testing life cycle including smoke testing, regression testing, functional testing and non-functional testing.
• Performed backend testing and made sure the product met user requirements.
• Used UNIX commands to extract and examine the error log.
• Actively participate in daily Scrums and project planning meetings.
• Recorded the Test cases using Automation tool QTP and checked the functionality of the application.
• Tracked and logged defects in Quality Center.
• Utilization and creation of SQL queries to gather data from SQL Server Databases.
• Verification testing in production to make sure the changes was properly installed (walk the floor to spear-head any issues that arise from releases).
• Found Defects, Tracked, Reporting using Quality Center and Bugzilla.
• Tested Reports based on user requirements.
• Used Quality Center for manual testing considering the base line of developed test plan and test cases considering both positive and negative scenarios.
• Creation/Updating test case based on Technical Specifications of the Jobs tested.
• Performed Web Services testing and validated the XML files and checked whether data is parsed and loaded to staging tables by writing SQL queries using TOAD.

Environment: MS SQL Server 2008 Enterprise Edition, SSIS, SSRS, SSAS, Visio 2005, Advanced Windows 2000 Server, IIS, XML, SOAP, Citrix, Load Runner, QC, IBM Info sphere, Informatica,DB2.

Confidential, Irvine, California

QA Analyst/ETL Tester

Responsibilities:

• Defined the test criteria and project schedules, and baselined the Test Plan with the help of project meetings, walkthroughs and Inspections.
• Used the DATA STAGE Director and its run-time engine to schedule the jobs, validating and debugging its components, and monitoring the resulting executable versions
• Involved in both manual and automated testing of the entire web application.
• Performed Web Service API testing for UI content verification and validation with business logic XML schema.
• Performed web service testing by sending API request and Response using SOAP UI.
• Prepared Taste cases and involved in system integration testing.
• Performed Web Services testing and validated the XML files and checked whether data is parsed and loaded to staging tables by writing SQL queries using TOAD.
• Created a requirements tree, detailed requirements and analyzed the requirements using QC.
• Used the Requirements tab of Test Director to document, review and analyze the requirements.
• Created customizable graphs and reports indicating the final analysis of the test plan to project requirements coverage, test readiness and overall application quality using Test Director.
• Manual testing of the modules as a part of functional testing.
• Documented and tracked the defects using Test Director.
• Conducted the Structural validation testing on source & target table structure, check field to field mapping on the Informatica Power Centre 9.1 including the check on data types, length, column names on both source and target tables, field types & formats.
• Created customizable graphs and reports indicating the final analysis of the test plan to project requirements coverage, test readiness and overall application quality using Test Director.
• Analyzed functional and non-functional requirement documentations to develop test cases

Environment: MS SQL Server 2008 Enterprise Edition, UNIX, Linux, Oracle, Crystal Report 8.5, TOAD, Oracle 11g ASP.Net, QC, Load Runner, SOAP, Data stage, OBIEE.

Confidential, Addis Ababa, Ethiopia

MS SQL Server Developer

Responsibilities:

• Responsible for planning, preparation and execution of test plan and test cases
• Tracked requirement & test case coverage through requirements traceability matrix (RTM)
• Performed various functional and non-functional testing for client-server applications Applied Waterfall and RUP SDLC methodologies
• Involved in Back end testing (stored procedures, views, & triggers)
• Involved in Designing logical and physical databases using Erwin tool.
• Created complex Stored Procedures, Functions, Triggers, Cursors, Tables, Views and SQL Join statements for several applications.
• Implemented Constraints, Rules, Defaults, User defined data types and Indexes on tables.
• Developed complex T-SQL code for data retrieval to generate reports using crystal reporting tool.
• Transferred the data to data mart from different servers using DTS packages.
• Resolved deadlocks issues with the Databases/Servers on a real-time basis.
• Developed and executed test plans, test cases with the help of Quality Center and filed the bugs with its snapshots.
• Performed Integration Testing, System Testing, and UAT for client-server and web applications.
• Development of PL/SQL and Web PL/SQL stored procedures
• Used XML while moving data from one environment to another environment.
• Providing Support to end user for both the Accounting and Billing system after implementation.
• Evaluated, tested, and deployed all software and hardware upgrades to the server infrastructure.
• Standardize overall procedures of software development from requirement analysis to deployment and feedback. performed Integration Testing, System Testing, and UAT for client-server and web applications
• Providing Support to end user for both the Accounting and Billing system after implementation.
• Successfully tested various ERP modules such as GL, AP, AR, and Fixed Asset, Budgeting, Procurement and Inventory modules at client sites.

Environment: MS SQL Server 6.5/7.0/2000, MS Windows 2003 Advance Server, Reporting Services, T-SQL, PL/SQL, Query Analyzer, SQL Profiler, MS Access, Unix, Linux, Oracle 9i/10g/11g, Crystal Reprt 8.5,TOAD.