Programmer Analyst Resume
Dallas, TX
PROFESSIONAL SUMMARY:
- 4 years of IT experience as Test Analyst in Data Warehousing Testing projects in Banking and Financial services and Media Domain.
- High contribution in all phases of a Data warehouse testing that includes Requirement Gathering, Analysis, Design, Test Data Preparation, Functional Testing, and Regression Testing.
- Excellent understanding of the Data Warehouse principles using Fact Tables, Dimension Tables, Dimensional Data Modelling - Star Schema and Snow Flake Schema.
- Thorough knowledge of Requirement Understanding, Test Strategy, Test Planning, Effort Estimation, Test Design, Test Execution, Defect Tracking, Defect Reporting and preparing Test Summary Reports for ETL and Report Testing.
- Extensive experiencein implementation ofData Analysis, Data Cleanup procedures,transformations Scripts,Triggers,Stored Proceduresandexecution of test plansfor loading the data successfully into thetargets
- Sound awareness of various ETL and Reporting tools like Informatica, Data Stage, Abinitio, Control-M, Autosys, Microstrategy, OBIEE, Cognos, and Business Objects Crystal Reports.
- Extensive learning of writing complex SQL queries in Oracle 9i, 10g, and DB2, Teradata, SQL Server, Teradata, Unix, shell scripts and creating automated scripts to create test data.
- Worked on Test management tools like HP Quality Center, Clear Quest.
- Good experience in Defect Triage process and coordinating the testing activities with development team.
- Engaged in giving to the new team members in the Project and assigning them the tasks to handle.
- Analytical and problem-solving skills coupled with initiative and accountability and concise verbal, written and interpersonal skills.
- Have good experience in interacting with various stakeholders such as Data Architect, Database Administrators, Business Analysts, Application Developers and Senior Management.
TECHNICAL SKILLS:
Operating System: Windows 98/XP/2000, Windows 8,10
Programming Languages: C, SQL
Databases: Oracle 10g, DB2, SQL server, Teradata.
Tools: Informatica Power Center 8.5.1, Data stage 8.1.0, Microstategy, Cognos, OBIEE.
Test Management Tools: Quality center 10.0, Clear Quest 7.1sqldeveloper-2.1.0, TOADDb2 client
Other Utilities: WinSCP V 3.7.5, Putty R0.8
PROFESSIONAL EXPERIENCE:
Confidential, Dallas, TX
Tools: & utilities:Informatica Power Center 8.5.1, HP Quality Center, WinSCP V 3.7.5, Microstrategy, Oracle SQL.
Responsibilities:
- Tested various Reusable ETL Transformations which facilitate Daily, Weekly & Monthly Loading of Data.
- Tested the performance bottlenecks at sources, targets, mappings, and sessions and employed required measures.
- Extensively worked on Mapping Variables, Mapping Parameters, Workflow Variables and Session Parameters to extract only the additional data added during that period.
- Used Data Driven Testing methodology to test the application with multiple sets of data.
- . Tracking the defects in QC, Analyzing the defects for RCA (root cause analysis).
Environment: Abnitio, Windows 7, 2003, UNIX, Oracle 10g, Teradata, SQL Server 2008, Word, Excel, PowerPoint, Outlook, MS Visio, WINSCP, Toad, HP Quality Center
Confidential
Tools: & utilities:DB2 Client, Informatica Power Center 8.5.1, HP Quality Center, WinSCP V 3.7.5, Microstrategy.
Responsibilities:
- Understanding and analysis of the business requirements and Design Specification documents.
- Involving in preparing Test Plan and Test Estimation and identifying test scenarios, preparing functional Test Case documents, generating test queries based on requirement and mapping documents, preparing test data and executing the test cases.
- Performing Integration, Functional, Regression and System testing.
- Reviewing test case results identified and analyzed the root cause of the defects, logged defects in defect tracking tool like HP Quality center, involving in defect triage calls and tracking the issues to closure.
- Conducting status calls with onsite coordinators for sharing Test Design, Test Execution and Defects status with them.
- Providing Knowledge Transition about the project to the new team members.
Confidential
Tools: & utilities:DB2 Client, Informatica Power Center 8.5.1, HP Quality Center, WinSCP V 3.7.5, Microstrategy.
Responsibilities:
- Understanding and analysis of the business requirements and Design Specification documents.
- Involving in preparing Test Plan and Test Estimation and identifying test scenarios, preparing functional Test Case documents, generating test queries based on requirement and mapping documents, preparing test data and executing the test cases.
- Testing large volumes of History data in the preliminary analysis.
- Performing Integration, Functional, Regression and System testing.
- Reviewing test case results identified and analyzed the root cause of the defects, logged defects in defect tracking tool like HP Quality center, involving in defect triage calls and tracking the issues to closure.
- Involved in testing of the Microstrategy reports thoroughly and retest the defects raised and following them to closure.
- Attending status calls with onsite coordinators for sharing Test Design, Test Execution and Defects status with them.
Confidential
Tools: & utilities:TOAD, Clear Quest 7.1, Data stage 8.1.0, OBIEE
Responsibilities:
- Analyzing Business requirement and data mapping documents.
- Understanding the data model in different layers like Landing, Integration and Semantic and performed ETL Testing between different layers (Source and Landing/Staging, Landing and Integration, Integration and Semantic layer) to ensure Source data is extracted, transformed and loaded as per defined rules.
- Developing test scripts, test data and test cases based on the rules written in the Data mapping and Business requirement documents. The test cases are mostly SQL statements wrapped in to scripts to verify the transformations of data between different layers of the data warehouse and she also performed data validation checks.
- Providing Knowledge Transition about the project to the new team members.
- Loading data from files to database tables using SQL Loader.
- Involving in defect reporting, retesting and tracking the defects to closure in Clear Quest.
