Professional Summary:

• Over 7 years of experience in Software Quality Assurance in Manual and Automated testing.
• More than 3+ years of IT experience in the Data Analysis, design, development, testing and Implementation of ETL & Business Intelligence solutions using Data Warehouse/Data Mart Design, ETL, OLAP, Client/Server applications.
• Managed handling multiple offshore/onsite models.
• Experienced SQL Data Analyst / Data Reporting Analyst with strong background in design, development, and support of online databases and information products as well as data analysis / reporting / processing.
• Extensive experience in ETL process consisting of data transformation, sourcing, mapping, conversion and loading
• Solid experience in preparing Test Plans, Test scenarios, test scripts and test cases.
• Hands on experience in Financial and Banking Domain - Personal, Business, IRA accounts and Investment products. Money Market, Savings, Credit cards and Loans.
• Comprehensive know-how of QA methodologies like Capability Maturity Model (CMM) & Rational Unified Process (RUP).
• Strong Skills in using testing methodologies and Functionality Testing, Integration Testing, System Testing, Business Function Testing, Performance Testing, Stress testing and Configuration Testing.
• Experience in financial applications including Asset Allocation Systems, Wealth management applications, Risk Management Systems, Trading Systems, Credit and Market Risk Portal Applications, custodian systems.
• Experienced with Actuate Reporting and Sybase ASE.
• Good understanding of ETL Test Processes and Test Methodologies.
• Proficient in Data Warehouse testing like Control Mechanism of batch loads, Error/ rejected records processing, testing of SCD implementations and process dependencies.
• Good at preparing test data using test procedure requirements
• Strong skills in preparing test cases and test reports for manual testing.
• Strong experience in writing SQL Queries for different Databases such as DB2, Oracle, Teradata and SQL server (T-SQL).
• Strong experience in using Mercury Test Director and HP Quality Center.
• Working knowledge in Rational tools.
• Well versed with Manual and Automated Testing methodologies and principles.
• Extensively worked with all phases of testing including creation of Test plans, Test Strategy, Test case specifications, Test execution, Defect tracking, Resolution, Documenting and Reporting.
• Strong Technical abilities in Analyzing and Setup Testing environments and software's.
• Experience in Performance Tuning of SQL and Stored Procedures.
• Automated and scheduled the Informatica jobs using UNIX Shell Scripting.

Work Authorization: Green Card.

Education:

Bachelor in Civil Engineering

Technical Skills:

Operating Systems: Windows 2000/NT/XP/Vista, UNIX (Linux, Sun Solaris, IBM AIX)
Databases: Oracle 8.1/9i/10g,PL/SQL,SQL Server 2000/2005/2008, Siebel, Sybase 12.3, Teradata V2R6
ETL Tools: Informatica 6.1, 7.1, 8.1/8.6, Ab Initio (GDE 1.15, Co>Op 2.15) and Data Stage 6.x/7.x/8.x
Reporting Tools: Hyperion, Actuate 9.1.3, Cognos 7.3/8.0 Series, Business Objects 5.0/6.5/XI R3/R2/R1
Query Tools: PL/SQL, Toad 7.4/8.3.6, SQL Query Analyzer, SQL Plus
Scripting Languages: XML, HTML, XHTML, Shell Scripting, PERL
Languages: C/C++, SQL, PL/SQL, JAVA 1.5, XSLT, Java Script
Application Development: Visual Basic 6.0, Oracle9i/10g
Packages: MS-Office, Visual Studio. 2005
Modeling Tools: Star-Schema & Snowflake-FACT and Dimension Tables, Erwin 4.0, ER studio
Scheduler Tools: Autosys, Appworx, Tidal, Control-M
Testing Tools: Mercury Tools (QTP 9.2 / 8.2, Win Runner 7.x/8.2 Load Runner8.0, 8.1, 9.0)
Defect Tracking & Management Tools: Test Director 7.6/8.0. Quality Center 9.0, 9.2, Clear Quest, Bugzilla, Empirix, JIRA 4.4.3, Share Point.

PROFESSIONAL EXPERIENCE

Confidential,Georgia Nov '10 - Present
QA Tester/Data Warehouse Tester - Mass Imports/ Real Estate Book, Apartment Finder

Description: Mass Imports, is the process of loading the source data in to NCI sites. The Real Estate Book is a real estate search engine that helps you find homes for sale and make smarter real estate decisions in the process. RealEstateBook.com searches thousands of homes and foreclosures and has information on thousands of real estate agents nationwide. Apartment Finder is America's fastest growing publication in the multi-family industry.

Responsibilities:

• Perform data analysis of raw data provided by client to determine usability and required load parameters.
• Responsible for monitoring data on daily basis, and check the transporter logs.
• Tested mappings for source data to target data according to business requirements.
• Wrote SQL queries on data staging tables and data warehouse tables to validate the data results.
• Schedule and monitor Informatica tasks to run on daily basis.
• Utilize Informatica for data integration to SQL Server 2008 Database.
• Validating the load process to make sure the target tables are populated according to the data mapping in ETL.
• Wrote and execute manual test scripts for Informatica mappings and transformations rules.
• Involved testing web service for accuracy and formatting of Listings in Real Estate Book.
• Tested the GUI of realestate.com and apartementfinder.com
• Used ZIRA for defect tracking, updating the bug status and discussed with developers to resolve the bugs.
• Conducted Unit testing, System testing, Integration testing and production testing of the application.
• Tested MLS Reports vs. Real Estate Book reports and Production environment reports and validated them.
• Validated the application in test and production environment to make sure they are same after deployment.
• Tested the application by writing SQL Queries and creating pivot views as to perform back-end testing.
• Utilize RETS Connector for data transfer from various MLS servers.

Environment: Informatica Power center 8.6, Informatica cloud, SQL Server 2005, 2008, Micro soft visual studio 2008, Share Point, Quality Center 9.2, JIRA, JAVA, .net 2010, File Zilla, UNIX, Shell Scripts.

PROFESSIONAL EXPERIENCE:

Confidential, New Jersey Aug 2008 - Oct 2010
QA Tester/Data Warehouse Tester - STAR Basel II

Description: The Basel II Framework sets out the details for adopting more risk sensitive minimum capital requirements for banking organizations. It seeks to improve on the existing rules by aligning regulatory capital requirements more closely to the underlying risks that banks face. In addition, the Basel II Framework is intended to promote a more forward-looking approach to capital supervision, one that encourages banks to identify the risks they may face, today and in the future, and to develop or improve their ability to manage those risks. As a result, it is intended to be more flexible and better able to evolve with advances in markets and risk management practices.

Responsibilities:

• Involved in Business analysis and requirements gathering.
• Wrote the SQL queries on data staging tables and data warehouse tables to validate the data results.
• Executed sessions and batches in Informatica and tracked the log file for failed sessions.
• Write SQL queries to validate that actual test results match with expected results
• Check the naming standards, data integrity and referential integrity.
• Responsible for monitoring data for porting to current versions.
• Analyzed and tested various Hyperion reports for Hierarchies, Aggregation, Conditions and Filters.
• Checked the reports for any naming inconsistencies and to improve user readability.
• Validated the data by reverse engineering methodology i.e. backward navigation from target to source.
• Used Quality Center for defect tracking, test cases, test plan, updating the bug status and discussed with developers to resolve the bugs.
• Validating the data files from source to make sure correct data has been captured to be loaded to target tables
• Validating the load process of ETL to make sure the target tables are populated according to the data mapping provided that satisfies the transformation rules.
• Validating the Archive process to purge the data that meet the defined business rules.
• Initiated the bi-weekly QA-Stat-Meet to discuss the intricacies involved in the application(s) being tested
• Involved in validating the aggregate table based on the rollup process documented in the data mapping.
• Written several complex SQL queries for validating and verifying the data in Oracle 10g.
• Prepared test plans/test schedules with inputs from Project manager and development team
• Responsible for reporting and escalating data issues arising from project or daily support.
• Assisted in creating test data and test cases and execute function system tests as needed.
• Performed Black box Testing, Regression and end-to-end testing.
• Developed/revised training documentation and procedure manuals.
• Responsible for running and analyzing quality check reports to ensure system is functioning properly
• Tested the application by writing SQL Queries and creating pivot views as to perform back-end testing.

Environment: Quality Center 9.2, QTP 9.2, JAVA, Peoplesoft EPM 8.8 Financials, Enterprise Warehouse, Oracle 10g, TOAD, Informatica Power Center 8.6, Application Designer, Workflow, Visio 2002 sp2, Windows XP Pro and Hyperion, UNIX, Shell Scripts.

Confidential,New Jersey May 2007 - July 2008
DWH/ETL Tester - Equity Traded System - GDW

Description: The prime Brokerage data mart is a part of Global data warehouse framework project which is to process the data into a centralized data warehouse for the Prime Brokerage business division. The data warehouse will serve as a centralized hub for all reporting & business intelligence requirements.

Responsibilities:

• Reviewed Business Requirements Documents and the Technical Specification.
• Involved in writing test plans and test strategies.
• Involved in Requirement analysis, identification and documentation of required system and functional testing efforts for all test scenario (Positive and Negative tests).
• Generated Test Cases for each specification in Requirement Specification Document corresponding to each module.
• Linked requirements to test cases for traceability in Test Director.
• Tested the database schema with help of data architects using ERWIN.
• Involved in the testing of Data Mart using Power Center.
• Effectively distributed responsibilities, arranged meetings and communicated with team members in all test phases of the project.
• Published defect reports and defect metrics on daily basis.
• Prepared release notes with help from developers for every release.
• Participated in discussions with the business owners regarding rating test cases/results.
• Used import and export facilities of the application to download/upload XMLs of failed test cases so as to re-verify.
• Involved in rebuild testing of the BI Reports from Cognos to Crystal Reports.
• Validated the data in the reports by writing simple to complex SQL queries in the transactional system
• Executed the Test cases for Crystal Reports and Cognos.
• Tested different detail, summary reports and on demand reports.
• Tested and validated the cube data, ensuring that the data is correct by comparing the data results to comparable source system reports or by querying individual transactions and forms.
• Worked in multiple source data extraction and data transition from existing production system to test environment.
• Tested the entire data reconciliation process for multiple source and target systems.
• Validated cube and query data from the reporting system back to the source system.

Environment: Test Director 8.0, Oracle 9i, SQL, Teradata V2R5,PL/SQL, Informatica Power Center 6.2/7.x, Ab Initio (GDE 1.12, Co>Op 2.12), EME, Flat files, Erwin 4.0, MS SQL Server 2005, Business Objects 6.5, COBOL , UTL_FILE, TSO, ISPF, JCL, Mainframes, Toad, Unix Shell Scripting, Windows XP/2000, Actuate ERD Pro v8.0, Actuate Active Portal.

Confidential,VA Jan 2006 - Apr 2007
QA Engineer - Federal Procurement Desktop (FPD), Contract Information Management System (CIMS)

Description: The Finance and Procurement Desktop (FPD) and the Contract Information Management System (CIMS) are used by the USCG, TSA and FAMS to provide financial management and internal controls related to simplified acquisition, funds management, contract writing, and budgeting.
FPD and CIMS offer the Coast Guard, TSA and FAMS an easy-to-use procurement system that offers real-time integration between accounting, asset management, and other systems outside of DHS, most notably FPDS-NG and CCR.

Responsibilities:

• Identifying the testable requirements from the system requirements to arrive at the scope of both functional and system testing.
• Conducted the Functional, Regression, System and Integration Testing of the application.
• Wrote and executed manual test scripts.
• Used reusable scripts in QTP extensively by creating a library of scripts and used in different test scripts.
• Execution of Test Cases/Scripts and analysis of the results.
• Generated automated test scripts using QTP 8.2.
• Performed Database Testing with SQL queries.
• Prepared Traceability Matrix between requirements and Test scripts/cases.
• Extensively worked with Test Directorand tracked the defects with it
• Ensured that the System Testing and Test Plan were compliant with the Test Services Department Standard Operating Procedure and Test Strategy.

Environment: Test Director 7.6, QTP 8.2,Oracle, Java, J2/EE, HTML. SQL Server 2000, XML,

Confidential,MD Jan 2005 - Dec 2005
QA Tester

Description: Electronic Bill Presentation and Payment: The purpose of this project is to provide a web based Application for Docucorp's customers to view their bills, pay bills, check their payments, electronic bill enrollment, generating consolidated bills, sort their bills and Print the bills in PDF format.

Responsibilities:

• Developed comprehensive test plans based on defect and business scenarios.
• Participated in test case execution; Created, maintained and executed test scripts from Test Director.
• Recorded Load Runner HTTP scripts.
• Improved the flexibility of the tests by Parameterizing the entire test, inserted checkpoints.
• Designed, developed and executed Quick Test Pro & VB scripts for functional, regression testing, and callable scripts.
• And also involved in regression testing if any defects were found in UAT or Production.
• Recorded Load Runner Vuser scripts implementing parameterization by data driven wizards in Virtual UserGenerator.
• Worked closely with users and program developers to ensure that the application development met the user expectations. Partially involved in performing User Acceptance Testing.
• Tracked and Reported software defects and interacted with developers to resolve technical issues

Environment: Test Director 7.6, Quick Test Pro 8.0, Load runner 7.8,SQL, HTTP, Java, PL/SQL, Windows.NET/2000, Web Sphere Application Server.

Confidential, Vienna, VA May 2004 - Dec 2004
Jr. QA Tester

Project: ixTools 5.0
Description: ixTools 5.0 is a web-based solution that provides analysis and reporting on traffic, rates, and destinations almost as quickly as the calls move across the global network. Telecommunication carriers commonly interconnect with other carriers in the course of delivering services. IxTools helps telecommunication carriers to interconnect with other carriers more efficiently. IxTools analyzes carrier interconnect business data and transforms it to business intelligence. This business intelligence allows carriers to tune network interconnect operations to achieve optimal profitability.

Responsibilities:

• Developed Test plan & Test Cases design documents.
• Conducted the Functional, Regression, System and Integration Testing of the application.
• Automated Suite of acceptance tests to validate daily software builds.
• Wrote and executed manual test scripts using SQL.
• Created automated test scripts in WinRunner for data integrity, data validation and functionality Testing.
• Performed Data-Driven testing using WinRunner.
• Performed Database Testing with SQL queries.
• Involved in the database validations to check whether the code is extracting the required data from the database.
• Prepared Test Summary reports on a release basis using TestDirector.

Environment: Test Director 7.6, WinRunner, SQL Server, ASP, XML, VB.Net, (D) HTML.