Summary:

• Around 8 years of experience in Information Technology with Extensive experience as a Quality Assurance Engineer with exposure of regression, functional and system integration test plans and test cases for Different applications Execute tests.
• Experience in the Business Requirements Analysis, System Design, Data Modeling, and development, Testing, Implementation and Maintenance. Experience working in various domains like Banking, Insurance, Retail.
• In depth knowledge of the Business process development using Software Development Life Cycle Waterfall, AGILE and testing using Software Testing Life Cycle STLC .
• Responsible for all activities related to the development, implementation, administration and support of ETL processes for large-scale data warehouses using DataStage.
• Worked extensively with Dimensional modeling, ETL Processes.
• Experienced in writing test cases, test scripts, test plans and execution of test cases reporting and documenting the test results using Mercury Quality Center, Rational Clear Quest.
• Extensive testing ETL experience using Ab-Initio, DataStage, Informatica Power Center/ Power Mart Designer, Workflow Manager, Workflow Monitor and Server Manager .
• Extensively used ETL methodology for supporting data extraction, transformations and loading processing, in a corporate-wide-ETL Solution using Informatica DataStage.
• Experience in Dimensional Data Modeling using Star and Snow Flake Schema. Ensure appropriate processes and controls across major process areas, including but not limited to data quality, ETL and Meta data management.
• Good experience of ETL tools working with multiple data sources.
• Good knowledge of Dimensional Data Modeling, Star Schema, Snow-Flake schema, FACT and Dimensions Tables, Physical and Logical Data Modeling.
• Adept at using both Manual and Automated Testing tools to troubleshoot systems, Integration, User Acceptance, Positive and Negative, GUI and Functionality, Regression Testing
• Proficient in using Mercury Interactive and other Automated Testing tools like Win Runner, Load Runner, Rational Clear Quest and QTP, Total System TSYS , VTS Visa Simulator , Master Cards Simulator and Versa Test Simulator for credit cards processing.
• Bug reporting with Test Director, Mercury Quality Center, and
• Performing test analysis -- what to manually test vs. what to automate
• Perform back-end testing manually on the Oracle SQL Developer, DB2 and Teradata databases by writing complex SQL queries.
• Strong working Knowledge in different databases i.e. Oracle databases, SQL PL/SQL, Toad, SQL Developer, SQL Assistant for Tera Data
• Strong understanding of batch scheduling processing tools Autosys, TWS and Control M
• Strong experience with relational, dimensional database systems and Data profiling
• Strong Experience with data quality testing validating source and target database using Data mapping using Data mapping/Transformation Rules , regression Revalidate the positive test cases and acceptance testing once the system testing done
• Expert BI tester of the following BI Tools Microstrategy , Crystal Reports , Business Object . Tested reports for accuracy, and troubleshoot report issues including poor performance and bad data.

Skills:

Experience

Confidential

Sr. Business Data Quality Analyst

Project:

• Data migration from VMIS Volunteer Management Information System to VTM Volunteer Technology Management .
• DSP Driver Safety Program .

• Collect and synthesize data, review current business processes, understand end-user needs in consultation with stakeholders and explain implications of choices to all involved
• Work closely with Subject Matter Experts SMEs and Project Managers to help create Project Requirement Documents PRDs , Specification Document and use cases
• Facilitate meetings and focused groups to identify optimal solutions that create and enhance business value.
• Conduct current state assessments for existing systems. Utilizes data quality, profiling tools, and querying tools to analyze and interpret data.
• Define information requirements, workflow, logical processes, interfaces between varying systems, internal and external checks and controls, and outputs to ensure that data quality measures are appropriate and comprehensive
• Actively participate in data clean-up and validation efforts by reaching out to all business partners to ensure integrity of master data across the systems.
• Actively monitor data input processes, tools, metrics, and outcomes to ensure data accuracy and integrity
• Resolves problems, corrects discrepancies and provides additional information as needed.
• Participates in the creation of data standards, policies and procedure to ensure future data quality
• Maintains relationships with internal clients to assure requirements are understood, and to provide updates and status reports on portfolio of projects.
• Develop and manage partnerships with various functional areas in order to ensure effective project delivery and allow for collaboration and leverage of previous work.
• Educate the team and business unit on the development process, tools and key deliverables as well as potential uses of deliverables.
• Independently lead various phases of the software development life cycle, with focus on validating conceptual solutions and creating quality requirements artifacts
• Design new functional design documents by analyzing requirements constructing workflow charts and diagrams studying system capabilities writing specifications
• Create Source to target mapping documents listing efficient data transformation business rules by database elements, with clear supporting documentation and example scenarios
• Analyze large amounts of data with limited documentation or SME support to produce technical specifications and Data Quality improvement plans migration conversion requirements by analyzing source and target schema
• Write SQL queries for data analysis.
• Develop and maintain a thorough understanding of business processes within assigned areas.
• Perform database queries and analyze large data sets in support of requirements development.
• Develop and validate requirements for data conversion and migration.
• Assist Product Managers in prioritizing issues/enhancements.
• Assist Product Managers in developing assessments with high level requirements and levels of effort.
• Participate in the technical design process to ensure that business requirements are being satisfied.
• Engage in peer reviews to ensure completeness and sufficient detail of business and system requirements.

Environment: Unix, Oracle, Netezza, MS SQL, TWS, Shell Scripts, SAS, Java, , Informatica, SSRS, Microstrategy, MS office, UNIX.

Confidential

Sr. ETL Tester

Role Responsibilities:

• Developed Test Plans, Test Cases, and Test Scripts for SIT and support for UAT tests.
• Review Test Plans to ensure adequate testing coverage of requirements and design provide feedback.
• Created Test Cases and developed Tractability Matrix and Test Coverage reports.
• Managed and conducted System testing, Integration testing and Functional testing.
• Tracked the defects using Quality Center tool and generated defect summary reports.
• Worked with Data Warehousing developers who extensively used DATASTAGE, to design mapping to move data from source to target database using Stages to do the functionality.
• Prepared status summary reports with details of executed, passed and failed test cases.
• Interacted with developers, Business Management Teams and End Users.
• Participated in regular project status meetings related to testing.
• Write Test Strategies and review with stakeholders obtain sign -off
• Ensure that Functional Testing executed meets documented testing standards.
• Ensure that all various vendor interfaces using SOAP/UI calls Regression and smoke test scripts maintenance using QTP.
• Agile Management and Software Development. Strong testing Quality Assurance experience within agile environment. Good understanding of agile software exceptions to standards follows the documented exception process.
• Campaign data validation for effects of various promo offers on cells as well as end to end validation in TSYS
• Advise on removal of features from release relative to testing completion and operational risk.
• Responsible for Business analysis and requirements gathering.
• Coordinated with the Developers regarding the Defects raised and Retested them against the application.
• Tracking and analyzing the defects and recording the variation between the expected and actual results.
• 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 collected requirements and tested several business reports.
• Extensively used the Control M jobs for the entire project.
• Validate Control-M and IBM Data Stage jobs for success of data load into tables residing in QWARE,CIF and each layer of the warehouse staging to ADS
• Used the Designer to develop processes for extracting, cleansing, transforming, integrating and loading data into data warehouse database.
• Written Complex SQL queries to validate the data conditions for ETL and BI group.
• Worked on SQL scripts to load data in the tables.
• Tuning considerations for PL/SQL code against the warehouse for bottleneck analysis from pre pod environment.
• Designed and developed UNIX shell scripts as part of the ETL process, automate the process of loading, pulling the data.
• Tested ETL feeds and written complex SQL queries to validate the data based on ETL mapping rules.
• Prepared extensive set of validation test cases to verify the data
• Consumed existing web services for the retrieval of business logic data from web sphere. Developed automated test scripts from manual test cases for Regression testing based on the requirement documents.
• Extensively test the reports for data accuracy and universe related errors.
• Created and Tested event based schedules of the reports and built an emailing mechanism to indicate success/failure of the schedule.
• Perform functional, integration, regression, volume and performance testing and preparing the test reports using rational clear quest and rational clear case is using as repository to maintain new and modified test cases.

Environment: Quality Center, Oracle SQL Server, Teradata, TSYS, Data stage, Java, Control M. WINSCP, Microstrategy, Versa Test Simulator, PUTTY.

Confidential

Sr. QA Analyst

Responsibilities

• Experience with the Testing of Credit card authorization techniques and process, payments, refunds and settlements.
• Tested the whole systems and workflows of payments, refunds and settlements in Issuer, Acquirer and merchant prospective.
• Worked on credit cards Authorization process to make sure all transactions go through ADE Auth Decision Engine .
• Used TSYS, VTS Visa Test Simulator , Master Card Simulator, Tandem to run the credit card Authorization process.
• Validate Credit Cards Authorizations by using TSYS Screens and Teradata for Backend testing.
• Tested whole Transaction Processing Facility to validate whole Authorization system is working correctly.
• Working on the process that divides the control zones of credit card customer, and validate that the control zone application works as expected.
• Worked on the migration of all the processes, from ADS previous DB to Teradata New Version .
• Worked on the Credit line Decrease CLD and Credit Line Increase CLI , and Fraud, processes to ensure the correct migration.
• Working on scheduling the batch processes in new scheduler namely TWS.
• Scripting the test cases for component and UAT using HP Quality Center.
• Logging the defects in HP Quality Center and verifying all the cycles of the defect that I am responsible for.
• Performing UAT, Positive, Negative and Boundary testing using the approved test cases.
• Using the complex SQL queries in Oracle and Teradata in Data Warehousing environment
• Using SQL developer, Teradata SQL Assistant, PSFTP during the testing
• Validating the Shell scripts and the related Java functions in all the processes.
• Running the process manually using UNIX commands.
• Using Unix Navigation commands, attribute change command as CHMOD, FTP commands
• Validating the log files after the process run.
• Using Traceability matrix to map the test plans/cases with the business requirements.

Environment: Unix, Oracle, Teradata, ADS, ODS, HP Quality center, MS SQL, TWS, Shell Scripts, SAS, Java, VTS Visa Simulator Total Systems TSYS , Ab-initio, MS office, UNIX, TPF/zTPF.

Confidential

BI/ETL Data Analyst Microstrategy Business Intelligence Reports Tester

Responsibilities

• Performed the complete functional as well as data validation testing back end Testing of all internal dashboards reports, external reports, PDF reports, internal external reports builders from global level, Region level, Priority market level, country level down to the client level for all Issuers , Acquirers, Merchants and processers reports developed by using Micro strategy BI Business Intelligence tool.
• Performed Validation of Data Translation from Source HRFA to Target EDW,SDW CDIMI data mart using Data mapping/Transformation Rules
• Validated the system end-to-end testing to meet the approved functional requirements
• Create detailed test plans and test cases based on functional requirements and software design documents
• Involved in writing Test scenarios, Generic tests cases, detail Positive and negative test cases for ETL also Preparing ETL and SQL routines/code for performing ETL testing system and integration testing and Documenting the test results
• Perform functional testing and prepare regression test scripts for ETL processes and Involved in Executing test scripts per defined ETL testing processes
• Involved to create client s profiles and performed data validation testing from client prospective for Issuer, ACQR and merchant prospective.
• Analyzed Business Requirement Documents to get a better understanding of the system on both technical and business perspectives
• Prepare weekly DR Summery report and distributed to the Test Coordinator, Director of testing team, Test Team, Development Lead, Project Manager, Release Manager, then Project Manager share the DR Information with Client Visa USA, Visa International and the Regions .
• Set up internal and external Review meetings for Test scenarios and Test scripts

• Lead all the activities and work and conduct walk through meetings to coordinate with off shore teams in India and Singapore.
• Performed extensive Manual Testing of the application and Executed Test Cases manually to verify the expected results.
• Performed Configuration testing of the application and utilized, Mercury Quality Center, Rational Clear Quest as the Bug Tracking Tool.
• Work closely with UAT team to perform UAT testing.
• Performed the complete functional as well as data validation testing back end Testing .
• Verified report layout Attributes/Metrics positions , Naming conventions, Totals Grand Totals, Validated the Sql query.
• Validated Drilling options - Simple Advanced, Prompts, Prompt ordering, Prompt Defaults and Verified Metric Calculations, Drill Maps, Security filters.
• Tested Export/Print functionality, Formatting Properties like alignment, scroll bar, decimal places.

Environment: Oracle, UNIX, ETL, Informatica Power Center 860, Power Center Workflow Monitor, Java, J2EE, HTML, IE, Windows, Data mart, Quality Center, Rational Clear Quest, MS Project, MS Office, Micro Strategy Reports, PL/SQL Developer, IBM DB2.

Confidential

Report Analyst DW Tester

Responsibilities

• Using Mercury Quality Center manually doing the testing of business object scripts.
• Design test cases scenarios and test scripts performed manual testing on UNIX Window platform.
• Principles in an agile or test driven methodology environment UNIX shell scripting.
• Find out bugs and issues developed and executed test plans test strategies scenarios scripts.
• Using Toad check the SQL of Our Source and Destination database Backend was Oracle database .
• Find out the bugs, Report the bugs in Quality center and send back to the Lead developer to resolve the issues and once it done from developer side retest the system after load the data ETL process end of the weekend .
• Responsible of testing the classless, objects, data in a tables and check the formatting of reports.
• Responsible for designing, building, testing Reports through Business Objects Xir2, Perl.
• Migrating components from Development to Test and Test to Production.
• Manually wrote complex SQL queries to check the integrity of data.
• Created reports for various Portfolios using the various data Providers like Free Hand SQL, Stored Procedures, and VB procedures.
• Created the reports using Business Objects functionality's like Queries, Slice and Dice, Drill Down, Cross Tab, Master Detail and Formulae's etc.
• Created reports using Info View and ZABO for distribution to users.
• Created Schedulers to monitor Broadcast Agent
• Built full client and WEBI reports.
• Analyzes, develops, tests, and implements segments of automated systems. Recommends and initiates system changes.
• Colleting Requirements from the IVR team, Analyzing, Documenting, Building, exporting Universe to Repository, building OLAP and Crystal Report in Info view and testing reports.
• Efficient in Optimizing, Debugging and testing SQL queries, views and Stored.
• Constantly tested SQL for joins and contexts for new object creation. Using Rapid SQL conducted functional testing in the SQL of existing objects.
• Created and tested classes and objects to organize the universe.
• Tested reports for accuracy, and troubleshoot report issues including poor performance and bad data.
• Worked with the IT team to bring in the data required into Business Objects Universe so as to make available for super users to create Adcock reports.
• Interacted with Business Users and Business Owners to know their Business views in developing and modifying Universes and Reports accordingly.
• Involved in the designing and Building of Universes, Classes and objects.
• Involved in the troubleshooting of universe schema with loops, chasm and fan traps, and cardinality problems.
• Created and tested classes and objects to organize the universe.

• Used SOAP request in XML to extract the data from CORE System to generate CLD Letter to the customers

Environment: Mercury Quality Center, Oracle 9i,Toad, Java, Java Script, C , Business Objects XI/6.5, Web focus, Power Builder Sybase, UNIX Shell Scrip Perl Technical skills, Central Management Console, Designer, Web Intelligence, Info View, Supervisor, BCA, ZABO, Informatica Power Center, Crystal Report XIs, Perl XML, HTML.

Confidential

QA Analyst/ Validation Analyst

Responsibilities

• Involved in Test planning, test case development, test script development, test script execution and defect tracking using Test Director.
• Involved in wiring Test scenarios, Generic tests cases, detail Positive and negative test cases for ETL
• Perform functional testing and prepare regression test scripts for ETL processes
• Involved in Executing test scripts per defined ETL testing processes
• Manually performed integration and Regression testing, documented bugs and worked with development team to resolve issues
• Involved in backend validation testing for Oracle database using Toad test SQL of Source and destination using latest data mapping
• Wrote Shell Scripts to back up daily test data
• Participate in the design, development, implementation and maintenance of an on-going enterprise-wide Data Factory program
• Involved in data analysis in support of different business data requirements definition, user acceptance testing and training activities
• Assist in the translation of other business data requirements into conceptual, logical, and physical data models
• Involved in identification of data sources for the required data attributes
• Developed data maps to document data attributes to data sources also data targets, including identification and documentation of data transformation algorithms
• Maintain different knowledge of data relationships and system interfaces
• Assist in knowledge transfer to other technical staff members on business data processes
• Evaluate potential expansion projects, also provide data requirements and design for new releases, as necessary
• Conducted Daily Status Meetings with the PMO Project Leads during the test execution

Environment: UNIX, IIS, Java, Oracle, and Test Director, Bugzilla, BEA Web Logic 8.2, Manual Testing, Test Director, Windows 2000

Confidential

QA Tester

Responsibilities:

• Involved in creating plan and also write automated test cases that map to specific product UI features and end-to-end UI flows.
• Manually test each and every module of the application and verify against expected results.
• Performed Smoke Testing of the application manually after each build.
• Performed rigorous Manual Testing before a release.
• Manually tested the application for IE and Netscape browsers.
• Also involved in performing User Acceptance Testing, creating and executing UAT test scripts.
• Manually performed Back-End Testing of the application for SQL-Server 2000, DB2 and Oracle databases.
• Involved in writing numerous SQL queries to check the data integrity.
• Kept track of all the defects opened by UAT execution using Test Director.
• Perform ad-hoc tests to uncover defects and log them.
• Involved in testing web application across multiple browsers - Internet Explorer, Mozilla Firefox, and Apple Safari.
• Testing involved across Content Management System CMS .
• Validated Data Relation by compiling and executing complex queries.
• Conducted result analysis and interacted with developers to resolve bugs.
• Participated in the project meetings.
• Used Test Director for error reporting and communicating between developers, product support and test team members.
• Reported and Tracked bugs using Test Director.

Environment: Load Runner, Win Runner, Test Director, Bugzilla, BEA Web Logic 8.2, Windows 2000, Oracle, HTML, and IIS