SUMMARY:

• ISTQB Certified QA Lead with expert level database testing skills, strong understanding of data architecture/design and proven ETL testing experience
• 10 years of extensive experience in the delivery of high - quality software solutions and demonstrated end-to-end IT project management skills in Mortgage and Capital Markets Domain
• Outstanding Project Management skills including scoping, estimation, planning, risk management, quality management and resource balancing with proven track record in successful implementation of end-to-end SDLC projects which have been challenging - both in terms of technical expertise and time constraints
• Proficient with Test Case Management/Defect Tracking tools Confidential ALM and good knowledge of ETL tool like Informatica and Datastage, Reporting tools like Cognos and SAP Business Objects
• Excellent knowledge and working experience in analyzing Requirement Specifications, Test Planning and Test Execution inclusive of Functional, Integration, Regression, Data Migration and System Testing
• Expert in effectively implementing Agile and Scrum methodology across Global teams
• Extensive knowledge of Autosys 4.6, jil, iXP and batch monitoring
• Collaborate with clients, Product Managers, Architects, & Analysts to develop and review requirements & design.
• Review multi-dimensional data models using star and snowflake schemas, denormalized data structures, slowly changing dimensions, etc.
• Validation of data integration tools and techniques such as ETL (Extract Transform Load), CDC (Change Data Capture), etc.
• Extensive experience in data analysis, working with ERP systems and financial systems.
• Extensive experience validating business semantic models and complex reports.
• Ability to analyze reports and interfaces, trace the metrics to data sources, and validate the logic used to create the metrics.
• Ability to construct complex SQL statements to analyze data. In-depth understanding of standard business intelligence tool like Cognos and SAP Business Objects
• Good understanding of relational data models and entity relationship diagrams
• Familiar with report scheduling, batch reporting, data-level security, report-level security.
• Excellent knowledge of Data Warehouse fundamentals like Star schema, Slowly Changing Dimensions (SCDs), Historical/Incremental loads, fact/dimension, surrogate key etc.
• Worked on different layers of Datawarehouse like staging, integration and datamarts
• Perform ETL validations like count, duplicate, CDC (Change Data Capture) and data validation between source and target destinations
• Process and validate huge data loads (in millions) from source to target
• Execute and validate ETL jobs/workflows on Datastage and Informatica
• Write complex SQLs to validate the transformation and data cleansing rules defined in data mapping documents
• Report validation and adhoc report analysis on Cognos and SAP Business Objects
• Strong Excel Skills required (Pivots, Macros, Formulas, V-Look-Up, Charting) for data manipulation/presentation
• Excellent working knowledge on UNIX environment and unix commands
• Experience of testing on heterogeneous datawarehouse environments like Oracle, SQL Server, Teradata and Netezza
• Test macros, stored procedures and triggers
• Create and run automated test scripts in UFT
• Excellent communication skills and ability to work both independently as well as in a team

TECHNICAL SKILLS:

ETL Tools: Informatica, Datastage

BI technologies: Cognos, SAP Business Objects

Computer Languages: SQL/PLSQL, Unix Shell Scripting, VBScript

Orchestration Tool: Autosys

Operating Systems: Unix and Linux

Databases: Oracle 9i/10g, SQL Server, Teradata, Netezza

Business Domains: Capital Markets, Mortgage

Testing software: HP ALM, HP UFT

Other Tools: TFS, Toad, SQL Assistant

PROFESSIONAL EXPERIENCE:

Confidential

EDW Test Lead

Responsibilities:

• As the Database Test Lead, responsible for Data Analysis, Database Architecture, Data validation and coordinating the User Acceptance Testing Cycle.
• Work closely with Program Managers for timely delivery, resource allocation and risk mitigation.
• As SME, responsible for knowledge management for on-boarding new members in the team.
• Preparing Weekly and Daily QA Status Reports along with Conducting Defect Review meetings with the Business Analysts, Project Managers and stake holders of respective project
• Participate effectively in relevant aspects of software development life cycle (SDLC) including planning, construction, testing, reviews and demonstrations.
• Collaborate with team to design, develop, test and refine deliverables.
• Collaborate with clients, Product Managers, Architects, & Analysts to develop and review requirements & design.
• Review and create system, software and functional design specifications that address requirements.
• Validation of FannieMae LAI Operational Reports, Management Analytic reports, Regulatory reports, Disclosure Reports and Ad-hoc reports
• Prepare test harness and test data around for FannieMae financial reports validation
• Built report automation regression framework on UFT
• Built Data Quality tool on excel to create test data for LAI data quality rules
• Analysis of Loan accounting Engine requirements and identifying test scenarios
• End to end validation of Loan Accounting Engine built on Java from source files to payloads to Subledger to General Ledger entries
• Analysis of Data Quality requirements and test data generation using VB script
• Validate multi-dimensional data models using star and snowflake schemas, denormalized data structures, slowly changing dimensions, etc.
• Validate data integration tools and techniques such as ETL (Extract Transform Load), CDC (Change Data Capture), etc.
• Validate analytical data models to support static and ad-hoc reports, analytics and research, dashboards, data mining, trending, creation of key performance indicators, predictive modeling, etc.
• Develop, execute and maintain test cases in ALM
• Perform EDW validations on Netezza
• Report validation on SAP Business Objects
• Write complex SQLs to validate the transformation and data cleansing or data quality rules
• Validate inbound and outbound interfaces
• Perform ETL validations like duplicate, count, incremental and data comparison between source and target
• Run and validate ETL workflows in Informatica
• Run and validate Autosys jobs used for orchestration

Environment: Informatica, Oracle, Netezza, SAP Buisness Objects, Autosys, ALM, SQL/PLSQL, Unix

ETL Test Lead

Responsibilities:

• Tested the installation and connectivity of Vertica with other infrastructure- Qlik View, Informatica, WebLogic, Oracle, Autosys, Cognos, Actuate in all environments (DEV/SIT/QA/PROD)
• Created the temporary process to fetch all Production feeds for QA Environment Readiness
• Executed QA batch on daily basis and reconciled numbers against the Production database.
• Verified end to end from data validations, batch process, performance till the reporting plaforms ( Compass, Qlik View, Cognos, Actuate, Downstreams)
• Work closely with Program Managers for timely delivery, resource allocation and risk mitigation.
• Preparing Weekly and Daily QA Status Reports along with Conducting Defect Review meetings with the Business Analysts, Project Managers and stake holders of respective project.
• Managing, coordinating & delegating the testing activities with offshore team (3 team members).
• Develop, execute and maintain test cases in QC
• Write complex SQLs to validate the transformation and data cleansing or data quality rules in Datawarehouse
• Validate data mapping, selection criteria, aggregations, sorting, lookups, transformations, data loads
• Process and validate trade feeds from source to Oracle to Netezza trade tables
• Perform ETL validations like duplicate, count, incremental and data comparison between source and target
• Run and validate ETL workflows in Informatica
• Batch monitoring using Autosys
• Test, schedule and run autosys jobs
• Tested management reports by querying the Database and understanding the Business Requirement Documents.
• Run and validate Cognos reports
• Preparation of daily testing report
• Test and defect Management using Confidential Quality Center

Environment: Informatica, Netezza, Cognos, Oracle, Autosys, Quality Center, SQL/PLSQL, Unix

ETL Tester

Responsibilities:

• Develop, execute and maintain test cases in QC both manual and automated
• Write complex SQLs to validate the transformation and data cleansing rules in Datawarehouse
• Validate data mapping, selection criteria, aggregations, sorting, lookups, transformations, data loads
• Process and validate data loads from flat files and DB tables
• Perform different ETL validations like data-data, data-file, file-file based on source and target
• Perform duplicate, count, CDC(Change Data Capture) data checks on source and target
• Creation and Execution of automated test cases based on established framework in VBScript on QTP
• Run and validate ETL jobs in Informatica
• Create Test Strategy, Test Plan
• Preparation of daily testing report
• Test and defect Management using Mercury Quality Center
• Design and implement SDLC policy and procedures. Conduct gap analysis of the SDLC

Environment: Datastage, Teradata, Quality Center, QTP 10.0, SQL/PLSQL, VBScript, Unix/Linux

ETL Tester

Responsibilities:

• Develop, execute and maintain test cases in QC both manual and automated
• Perform ambiguity reviews of business requirements and technical design documents
• Write test SQL scripts for different ETL validations
• Perform different ETL validations like data-data, data-file, file-data based on source and target
• Perform duplicate, count, incremental data checks on source and target
• Process and validate huge data loads (in millions) from flat files and DB tables
• Test macros, stored procedures and triggers
• Creation and Execution of automated test cases based on established framework in VBScript on QTP
• Run and validate Informatica workflows
• Run and validate reports on Cognos
• Preparation of daily testing report
• Test and defect Management using Mercury Quality Center
• Create Test Strategy, Test Plan

Environment: Informatica, Teradata, Cognos, Quality Center, QTP 10.0, SQL/PLSQL, VBScript, Unix/Linux

Database Tester

Responsibilities:

• Develop, execute and maintain test cases
• Write complex SQL queries and inserts scripts.
• Test inbound and outbound interfaces (Stored Procedures)
• Test triggers
• Performance testing of interfaces
• Create tables and views if required
• Preparation of daily testing report.
• Test and defect Management using Mercury Quality Center

Environment: MS SQL Server 2005, Biztalk Server, Quality Center, SQL/PLSQL

QA

Responsibilities:

• Plan of test cases in Quality Center
• Develop, executing and maintaining test cases
• Assign task to testers.
• Preparation of daily testing report.
• Defect Management.
• Interact with developers and discussed technical problems and Bug Tracking.
• Prepare weekly status report to report the test progress in a timely fashion to the client
• Carry out the smoke and sanity testing on new build releases
• Carry out the regression test cycles for weekly/monthly builds
• Carry out the system testing after regression test cycles
• Utilize QC by making test sets and streamlining requirements coverage
• Functional testing for the on-going product
• Enhance knowledge on SAN environment.
• Responsible to make efficient and effective communication with Israel counterparts

Environment: Confidential Quality Center, Navisphere, Web Tools, EMC Control center

ETL Tester

Responsibilities:

• Prepare test cases
• Testing (System, Regression, Report, Performance)
• Handle Team Communication
• Ensure end to end Data Consistency and Integrity across different layers of Datawarehouse (DRA-Data Reception Area, DSA- Data Staging Area, ODW- Orbit Datawarehouse & ALD-Aggregate Layer Datamart) making use of ETL tool OWB
• Perform duplicate, count, incremental data checks on source and target
• Run ETL jobs on Informatica
• Write complex SQLs to validate the transformation and data cleansing rules in Datawarehouse
• Train project team members on technologies implemented & business functionalities in the project

Environment: Informatica, Oracle, Toad, SQL/PLSQL, Confidential Quality Center, Unix