SUMMARY:

• Over 13 years of experience in Software Quality Assurance in Manual and Automated testing.
• Expertise in Data Analysis, and testing of Client/Server applications, ETL & Business Intelligence solutions applications, OLAP, API.
• Strong Experience in testing point of sales (POS) applications (Perform Transactions using credit cards, debit cards, gift cards, EBT cards through ECRs, and also API)
• Strong Skills in using testing methodologies and Functionality Testing, Integration Testing, System Testing, Business Function Testing, Performance Testing, Stress testing and Configuration Testing.
• Solid experience in preparing Test Plans, Test scenarios, test scripts and test cases.
• Comprehensive know - how of QA methodologies like Capability Maturity Model (CMM) & Rational Unified Process (RUP).
• Managed handling of multiple offshore/onsite models.
• Extensive experience in ETL process consisting of data transformation, sourcing, mapping, conversion and loading
• 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.
• 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 experience in writing SQL Queries for different Databases such as DB2, Oracle, Teradata and SQL server (T-SQL).
• Strong experience in using SmartBear Tools ALM (QAComplete/ALMComplete10.1, TestComplete 9.3), 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 SQLs and Stored Procedures.
• Automated and scheduled the Informatica jobs using UNIX Shell Scripting.
• Experience in SQL Data Analysis / Data Reporting Analysis.
• Hands on experience in Financial and Banking Domain - Personal, Business, IRA accounts and Investment products. Money Market, Savings, Credit cards and Loans.

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/2012 , 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, VB Script

Application Development: Visual Basic 6.0, Oracle9i/10g

Packages: MS-Office, Visual Studio. 2005, 2010

Modeling Tools: Star-Schema & Snowflake-FACT and Dimension Tables, Erwin 4.0, ER studio

Scheduler Tools: Autosys, Appworx, Tidal, Control-M

Testing Tools : SmartBear Tools (QAComplete/ALMComplete10.1, TestComplete 9.3), 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, ALM Complete 10.0 / QA Complete

PROFESSIONAL EXPERIENCE:

Confidential, Georgia

Sr. QA Analyst

Responsibilities:

• Perform hardware and software checkouts for Point of Sales (POS), with wireless capable systems or network wired via TCP/IP.
• Perform Transactions using credit cards, debit cards, gift cards, EBT cards through ECRs, and also API.
• Responsible for monitoring transaction data and check the UNIX server logs.
• Tested transaction logs, request and response according to business requirements.
• Wrote SQL queries on Primary, and Secondary database tables to validate the data results.
• Created HTML web pages, and also GUI apps to interact with the API.
• Tested transaction request and response using CLibrary Functions, and CLibrary tools.
• Performed Security Testing, while the data is being processed in the network from client to server.
• Wrote and executed manual test scripts for validating the web applications, and hardware applications.
• Involved testing Sterling Bridge for different types of transactions, payment methods, and Reports.
• Used ALM Complete for defect tracking, updating the bug status and discussed with developers to resolve the bugs.
• Conducted Unit testing, System testing, Integration testing and regression testing of the application.
• Tested ECR Transactions vs. Sterling MPP Admin Transactions, and Sterling Bridge Transactions and validated them.
• Tested ECR Reports vs. Sterling MPP Admin Reports, and Sterling Bridge Reports and validated them.
• Tested the GUI of Sterling Virtual Terminal, Administration tool, and Sterling Bridge.
• Validated the application in test, QA 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.
• Performed Smoke Testing and Regression Testing if any defects were found in UAT or Production.
• Worked closely with users and program developers to ensure that the application development met the user expectations.
• Created automated test scripts in Test Complete for data integrity, data validation and functionality Testing.
• Performed Data-Driven testing and Parameterization using Test Complete.
• Designed, developed and executed in Test Complete & VB scripts for functional, regression testing, and callable.
• Tracked and Reported software defects and interacted with developers to resolve technical issues.

Environment: SQL Server 2008, 2012, Micro soft visual studio 2008, Share Point, ALM Complete 10.0, Test Complete 9.3, 10.0, 11.0. JAVA, .net 2010, File Zilla, UNIX, Shell Scripts.

PROFESSIONAL EXPERIENCE:

Confidential, Georgia

QA Tester/Data Warehouse Tester

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 JIRA 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

QA Tester/Data Warehouse Tester

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

DWH/ETL Tester - Equity Traded System

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.