SUMMARY:

• An accomplished, versatile, highly organized self - starter with outstanding career track known throughout the industry with 9+ years expertise in all aspects of Testing in Data Warehousing from the source systems data extractions, data transformations, data staging, movement and aggregation. Exceptional communicator with problem solving capabilities and taking initiatives in supporting management policies and objectives quickly and effectively.
• 9+ years of focused experience in Information Technology with a strong background in Database and Data warehousing, ETL and Reporting testing
• Extensively worked with large Databases in QA and UAT Environments.
• Validating data after processing to implementing Data Mart applications, mainly transformation processes using ETL tools.
• Lead the project throughout the SDLC, involving onsite and offshore resource coordination
• Designing test cases and test data for ETL data conversions from wide variety of source system.
• Extensive work in ETL process consisting of data transformation, data sourcing, mapping, conversion and loading and knowledge in Data Modeling.
• Leading a five member team in DVO for creating Automated Regression Test Suit
• Extensive experience in reviewing Business Requirement Documents, Software Requirement Documents and preparing Test Cases, Test scripts and Execution.
• 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.
• Worked on Informatica DVO tool for Regression Testing.
• 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
• Extensively worked with Metrics, Filters, Transformations, Custom Groups, and Consolidations using Micro Strategy tools
• Used SQL for Querying the Oracle database
• 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 loading and 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.
• Executed the Test cases for Micro Strategy
• 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 automated data tests using InformaticaDVO
• Used TOAD&SQL Navigator GUI tools for Querying Database.
• Tested several data migration application for security, data protection and data corruption during transfer
• 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.

TECHNICAL SKILLS:

Operating Systems: Windows 95/98/2000/NT/XP, Unix

Data Modelling:: CA Erwin 4.0, Star-Schema Modeling, Snowflake Schema Modeling, FACT & Dimension Tables

ETL/BI:: Informatica Power Center 9.6.1

Databases:: DB2,Teradata ODBC 12.0.0.3,IMSDB, TABLEBASE

Programming:: SQL, TOAD Transact SQL, UNIX commands,COBOL,JCL

Tools: Informatica DVO, ETAT,Teradata SQL Assistant,CHANGEMAN, File Aid,File Manager, SAR,CTM, Main view,Super C, Hive, Query surge,JIRA

Defect management tool: IBM Rational Clear Quest,Rational Quality Manager,RTC

PROFESSIONAL EXPERIENCE:

Confidential

Sr. Test Analyst/Test Lead

• Involved in Manual and Automated testing using QTP and Quality Center.
• Promoted Unix/Informatica application releases from development to QA and to UAT environment
• Tested the Oracle SQL testing programs and tested the Oracle Applications and Portals like Executive Dashboard, lookup built on Oracle.
• 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
• Involved in testing Micro strategy reports including conditional formatting testing and threshold testing
• Executed the Test Scripts in TOAD and documented the results in RTM.
• Worked in an Agile technology with Scrum
• Tuned ETL jobs/procedures/scripts, SQL queries, PL/SQL procedures to improve the system performance
• Wrote SQL and PL/SQL scripts to perform database testing and to verify data integrity.
• Reported bugs and tracked defects using Quality Center
• Involved in extensive DATA validation by writing several complex SQL queries and Involved in back-end testing and worked with data quality issues.
• 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.
• 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
• Tested Micro strategy reports for Report layout, Attributes/Metrics, positions,Totals& Grand Totals, Drilling options, Metric Calculations, Drill Maps, and Secure files.
• Involved in Manual and Automated testing using QTP and Quality Center.
• Involved in creating source target mapping based on the Technical Design requirement.

Environment: Informatica 8.6.1/8.1, Micro Strategy, Unix, Oracle 10g, SQL, PL/SQL, HP Quality Center 10, MS Excel, Teradata 13 Agile, Toad, QTP,Teradata SQL Assistant, XML, Autosys& Putty

Confidential

• Involved in study of the Functional Specifications and Transferring design for Development of use case.
• Involved in the High level JAD sessions, Analysis and Design of the application.
• Involved implementation of SOAP based web services using Spring and JAX-WS.
• Involved in developing DAO module in business layer using Hibernate framework.
• Involved in developing UI layer to provide data dashboards using Spring MVC and JQuery libraries. Java, Java script, Angular JS, Spring
• Code and functionality review and Development of the HGLM Server side code
• Functionality testing of pages and Bug fixing during user acceptance testing.
• Involved in Quality analysis of the defects.

Environment: Confidential Web Server, Struts Framework, Servlet, JSP, JSTL, Java Script, HiRDB, HBase, Eclipse 3.2