SUMMARY

• Over 7 + years of Professional Experience in Software Quality Assurance and Testing in different environments and platforms including Data Warehousing, Client - Server and Legacy Mainframe applications.
• Extensive experience in reviewing Business Requirement Documents, Software Requirement Documents and preparing Test Cases, Test scripts and Execution.
• Experience in Black box testing with a complete QA cycle - from testing, defect logging and verification of fixed bugs.
• Very good understanding of Data Warehousing concepts, Data Analysis, Data Warehouse Architecture and Designing
• Coordinate and tested the deployment procedure for MicroStrategy changes to the Production
• Done heavy batch testing using AUTOSYS and data validation using SQL and Toad
• Worked on different versions of Cognos for Report testing.
• Excellent Communication, Analytical and Interpersonal skills.
• Worked with IT Operations to ensure test environment readiness.
• Experience in UNIX shell scripting and configuring cron-jobs for Informatica sessions scheduling
• Experienced in working in Agile Scrum, Agile XP, Waterfall, RUP, RAD and SDLC methodology environments
• Good Testing experience in developing reports using SQL Server (SSRS)
• Extensive experience in Functional testing, Integration/System testing, Regression testing and User Acceptance testing.
• Proficient in quality assurance testing by manually and using Automation tools (QTP, ALM/Quality Center and TestDirector).
• Automated and scheduled the Informatica jobs using UNIX Shell Scripting.
• Well versed in GUI application testing, Database testing and Front-end testing.
• Experience in Financial, Banking, Brokerage, and Securities industries.
• Extensively used ETL methodology for testing and supporting data extraction, transformations and loading processing, in a corporate-wide-ETL Solution using Informatica.
• Experience in Dimensional Data Modeling using Star and Snow Flake Schema.
• Experience in testing and writing SQL and PL/SQL statements.
• Experience with Agile Methodology.
• Experience in testing Data Marts, Data Warehouse/ETL Applications developed in Informatica and Ab Initio using Oracle, DB2, Teradata and UNIX.
• Ability to interact with developers and product analysts regarding testing status and to maintain detailed QA documentation.
• Has expertise in Test Case Design, Test Tool Usage, Test Execution, and Defect Management.
• Experience in UNIX shell scripting and configuring cron-jobs for Informatica sessions scheduling.
• Experience in testing XML files and validating the data loaded to staging tables.
• Experience in Performance Tuning of SQL

TECHNICAL SKILLS

OPERATING SYSTEMS: Windows 95/98/2000/NT/XP and Linux (RedHat), HP UX 11i v1.5/1.6/2.0)

LANGUAGES: C, PL/SQL, SQL*Plus

RDBMS: Teradata V2R6 (MLOAD, FLOAD, FAST EXPORT, BTEQ), Oracle, MS SQL Server

REPORTING TOOLS: SSRS, Micro Strategy, Cognos 6.5/7.0, IBM Cognos 8

DATAWAREHOUSING: Informatica 9 / 8.6.1, OLTP, OLAP, Data Stage 8.x,, DataMart, SQL*Loader, TOAD

TESTING TOOLS: MS Project Test Scheduling, Test Director, Quality Center, QTP

PROFESSIONAL EXPERIENCE

Confidential, Woonsocket, Rhode Island

ETL Tester

Responsibilities:

• Responsible for Business analysis and requirements gathering.
• Responsible for coordinating testing throughout both systems ODS and EDW which were two different teams.
• Involved in backend testing for the front end of the application using SQL Queries in Teradata data base.
• Wrote UNIX shells scripts (Korn Shell) to generate data, extracts test data, and load data to Oracle database using SQL*Loader
• Tested SQL to extrapolate data from the autosys database to populate a spreadsheet
• Promoted Unix/Informatica application releases from development to QA and to UAT environments
• Wrote Test cases in ALM and Defect report generation using ALM (Application Life cycle Management)
• Conducted Data Migration and Data Cleansing
• Tested different reports including detail, summary reports and on demand reports developed by SSRS Report Studio
• Used Agile Test Methods to provide rapid feedback to the developers significantly helping them uncover important risks.
• Hands on experience in Automation testing using QTP
• Responsible for leading team and co-coordinating with offshore team.
• Designed and kept track of Requirement Traceability Matrix
• Quality Center updates and test cases loadingand writing Test Plan and executing Test Cases and printing status report for the team meetings.
• Involved in Integrating and Functional System Testing for the entire Data Warehousing Application.
• Used Quality Center for defect tracking.
• Performed data quality analysis using advanced SQL skills.
• Performed data analysis and data profiling using SQL and Informatica Data Explorer on various sources systems including Oracle and Teradata
• Tuned ETL jobs/procedures/scripts, SQL queries, PL/SQL procedures to improve the system performance.
• Wrote Test cases in ALM and Defect report generation using ALM (Application Life cycle Management)
• Tested reports based on the statistical analysis of the data from various time frame and division using SQL Server Reporting Services (SSRS)
• Worked on Autosys which involved in creation of Autosys jobs, execution
• Involved in data warehouse testing by checking ETL procedures/mappings
• Implemented and maintained tools required to support data warehouse testing.
• Performed all aspects of verification, validation including functional, structural, regression, load and system testing
• Tested several data migration application for security, data protection and data corruption during transfer
• Tested data migration to ensure that integrity of data was not compromised
• Created and Developed Reports and Graphs using ALM.
• Responsible to help testing team on creating test cases to make sure the data originating from source is making into target properly in the right format.
• Involved in Data Extraction from Teradata and Flat Files using sql assistant.

Environment: Quality Center & ALM 11.0, SQL, PL/SQL, SSRS, Informatica 9.0, MainFrame Flat Files, Agile, UNIX, Autosys, QTP,Teradata SQL Assistant, data migration, unix, Oracle 10G, DB2, TOAD9.7

Confidential, Richmond VA

ETL Tester

Responsibilities:

• Responsible for Business analysis and requirements gathering.
• I have imparted and organized training to newcomers in the team regarding different technologies like SQL
• Tested various operational Drill-through and Drill-down reports using SSRS
• Involved in Manual and Automated testing using QTP and Quality Center
• Written various Autosys JIL Scripts to activate the UNIX scripts in production.
• Promoted Unix/Informatica application releases from development to QA and to UAT environments
• Attending Client calls for Business understanding and Clarifications.
• Designed and developed UNIX shell scripts as part of the ETL process to automate the process of loading, pulling the data for testing ETL loads
• Worked in an Agile technology with Scrum
• Tuned ETL jobs/procedures/scripts, SQL queries, PL/SQL procedures to improve the system performance
• Designed and developed UNIX shell scripts as part of the ETL process to automate the process of loading, pulling the data for testing ETL loads.
• Wrote SQL and PL/SQL scripts to perform database testing and to verify data integrity.
• Reported bugs and tracked defects using Quality Center
• Running SQL queries and extracting data from Oracle and DB2 for data migration. Used DB Visualize
• Involved in extensive DATA validation by writing several complex SQL queries and Involved in back-end testing and worked with data quality issues.
• Written several shell scripts using UNIX Korn shell for file transfers and clean-up process
• Managed and executed the test process, using Agile Methodology
• Involved in data warehouse testing by checking ETL procedures/mappings.
• Performed the tests in both the SIT, QA and contingency/backup environments
• Performed all aspects of verification, validation including functional, structural, regression, load and system testing
• Involved in backend testing for the front end of the application using SQL Queries in Teradata data base.
• Tested several data migration application for security, data protection and data corruption during transfer
• Involved in Data Extraction from Teradata and Flat Files using sql assistant.
• Performed data analysis and data profiling using SQL and Informatica Data Explorer on various sources systems including Oracle and Teradata
• Strong ability in developing advanced SQL queries to extract, manipulate, and/or calculate information to fulfill data and reporting requirements including identifying the tables and columns from which data is extracted
• Executed the Test cases for SSRS
• Involved in creating source target mappings based on the Technical Design requirements.
• Involved in Manual and Automated testing using QTP and Quality Center.

Environment: Informatica 8.6.1/8.1, data migration, SSRS,SQL,Toad, PL/SQL, unix, Quality Center 11.0, MS Excel, Teradata 13 Agile, QTP,Teradata SQL Assistant, XML, Autosys & Putty

Confidential, Glen Allen, VA

ETL Tester

Responsibilities:

• Interacted with end-users and functional analysts to identify and develop business requirements and transform it into technical requirements.
• Involved in requirements analysis by interacting with analysts for the creation of Data marts using Informatica.
• Worked with data reconciliation for the entire data migration project for both target system and rejected re-cords.
• Worked on complete SDLC from Extraction, Transformation and Loading of data using Informatica.
• Wrote shell scripts (Korn Shell) to automate and migrate data from operational data source to datawarehouse.
• Used SQL for Querying the DB2 database in UNIX environment.
• Created and executed QTP scripts by using descriptive programming.
• Tested data migration to ensure that integrity of data was not compromised.
• Involved in designing the Data Mart model with Erwin using Star Schema methodology.
• Creating dimensions and facts in the physical data model.
• Design and Development of pre-session, post-session routines and batch execution routines using Informatica Server to run Informatica sessions.
• Tuning of SQL queries for better performance.

Environment: Informatica Power Mart 8.4, data migration, Oracle 8.1.1/9i,QTP, Windows, UNIX, Excel, SQL Server 7.0/2000, Erwin, Visio, TOAD, unix, Business Objects.

Confidential, Charlotte NC

QA Analyst

Responsibilities:

• Created Test Plan and Test Scripts and analyzed the user/business requirements. Functional specs, Use Case documents and created the Test Plans, Test cases for System testing.
• Executed of generated Test Cases Manually in QC.
• Created the Regression Test cases and automated them for the purpose of regression testing using QTP.
• Developed and maintained automated test scripts to support regression testing and participated actively in system testing and regression testing.
• Developed and maintained the regression test bed.
• Complete responsible for manual testing of the Web Site.
• Attended project meetings, release meetings, and QA status meetings.
• Conducting user interviews at both in-house and client locations, gathering and analyzing requirements using Requisite Pro RUP.
• Perform Gap analysis by identifying existing technologies, documenting the enhancements to meet the end state requirements.
• Conduct workflow, process diagram and gap analyses to derive chuck for existing systems enhancements
• Assist with user testing of systems (UAT), developing and maintaining quality procedures, and ensuring that appropriate documentation is in place.

Environment: SQL Server 2005, Oracle 8i, MS Excel, SQL, QTP, Quality Center 8.2, Windows NT, Web Logic Server 7.0, UNIX, J2EE, Oracle 8i, EJB 2.0.