SUMMARY

• Over 7+ years of Software testing experience in Banking and Financial services domain and currently working with Cognizant Technology Solutions.
• Possess Strong knowledge of Software Testing Life Cycle (STLC), QA Methodologies and deep analytical skills.
• Proficient in ensuring the accuracy, completeness, timeliness and consistency of Data elements used in Compliance decision - making and reporting and timely communication to key stakeholders
• Extensive work experience on Data Management in large-scale data environments in Financial Services.
• Proficient in Capital Markets products and the use of reference data and market data inventory
• Proficient in Functional testing, System testing, Regression Testing, Web Testing, Database / ETL testing, and Validation testing, UAT support and coordination in UAT activity.
• Highly conversant in Data analysis capability with ORACLE/SQL queries and possess basic knowledge in DB2 and Unix shell scripting and Big Data, Hadoop.
• Extensive hands-on experience in Web applications and delivering the product.
• Involved in various phases of a testing life cycle like Estimation, Requirement Analysis, Design, Test Plan Preparation, System testing and Test Reporting.
• Experienced in using the Test Management tool Quality Center/ HP ALM
• Extensive background in the Capital Markets domain, primarily focusing on Commodities trading related research data.

TECHNICAL SKILLS

Technologies: ETL Testing with data warehousing tool Informatica,UNIX shell scripting, Functional Testing, System Testing, Web Testing, Database Testing with tool Rapid SQL,PL\SQL Developer

Operating Systems: Windows 98/XP, Windows NT 4.0, Windows 2000 and Linux

Databases: Oracle, SQL, DB2

Tools: Informatica PowerCenter, SQL developer, TOAD,ALM QTP, Business Objects XI3, Cognos Reporting,OBIEE

PROFESSIONAL EXPERIENCE

Test Lead

Confidential, Enfield, CT

Responsibilities:

• Analyzing requirements and preparing test plan, effort estimation for Teradata and OBIEE up gradation of large extent projects.
• Preparation and Review of Test Scenarios and Test Cases.
• Handled Capital Markets products and the use of reference data and market data in large data warehouse applications.
• Coordinated UAT to ensure that developed systems satisfied the needs of business clients as specified in the functional requirements.
• Understanding UAT scope, criteria and entry/exit strategy and coordinating the UAT defects with Dev team and worked for generating UAT testing metrics
• Assisted clients and team in producing high-quality applications.
• Created and Processed transactions to create test data.
• As part of this assignment, performed Functional, Regression testing and End to End testing.
• ETL Testing with data warehousing tool Informatica.
• Run Informatica jobs using workflow monitor and validated the output datasets.
• Validate each stage on processing transaction to ensure that it’s as per the requirements and customer’s expectation.
• Test Execution and reporting of issues/defects in HP ALM
• Preparation of Test summary report.
• Handled oracle database (PL/SQL developer)test execution as team player
• Handled UNIX shell scripts to check the process logs.
• Interacted with Clients on a frequent basis to get the inputs and status reporting.
• Lead a team working in multiple locations.

Environment: Informatica PowerCenter, Teradata,SQL developer, ALM, QTP, Business Objects XI3, OBIEE Reporting.

Test Lead

Confidential, New York, NY

Responsibilities:

• Analyzing the requirements and preparation of Database ETL Test Plan/Design documents.
• Estimating and monitoring SIT execution phases
• UAT activity support and coordination, test data preparation for UAT.
• Play efficient data analyst role with respect to business context and requirements for UAT testing purposes
• Conducting meeting with UAT and stakeholders and met all project timelines and UAT deadlines.
• ETL Testing with data warehousing tool Informatica.
• Performed Data Validation testing by using simple to complex SQL queries which involves fields with calculations / functions
• Handled UNIX shell scripts and commands to check the process logs and data loading activities.
• Experience on handling XML messages in database of web applications
• Involved in Test data preparation and data migration
• Analyzing requirements and preparing test plan, effort estimation for upcoming projects.
• Preparation and Review of Test Scenarios and Test Cases.
• Test Execution and reporting of issues/defects in QC
• Preparation of Test summary report.

Environment: Informatica PowerCenter, SQL developer, TOAD,ALM QTP, Business Objects XI3, Cognos Reporting.

Data Analyst

Confidential

Responsibilities:

• Analyzing requirements and preparing test plan.
• Assisted UAT activities.
• ETL Testing with data warehousing tool Informatica.
• Involved in Test data preparation and data validation through oracle database testing
• Preparation and Review of Test Scenarios and Test Cases in QC.
• Performed Smoke Testing, Functional testing, Regression testing, and also System integration testing on need basis.
• Involved in creating SQL and Unix scripts to validate the output datasets and results produced to ensure that it’s as per the requirements and customer’s expectation.
• Validated slowly changing dimensions like Type 1 and 2 effectively to handle the delta Loads.
• Handled projects individually throughout the testing life cycle.
• Conducted Training on domain knowledge within team.
• Reporting of issues/defects in QC
• Preparation of Test summary report.

Environment: Informatica PowerCenter, SQL developer, TOAD,ALM, QTP, Business Objects XI3, Cognos Reporting.