SUMMARY:

• 9+ years of experience in Software Quality Analyst Seeking a position with a prestigious company in Quality Assurance focused on (ETL/DWH) to benefit the organization with informed decision - making and an understanding of technical capacity.
• Business Requirement Analysis, Customer Experience, Change Control
• Documentation: QA Test Plan/Test Cases, Test result, Defect report, Local Procedure.
• Expert in Testing CDC LOGIC (CHANGE DATA CAPTURE )
• Experience in validation of credit card and pay pal Transactions
• Knowledge of CSMs like FED, CHIPS and International payments (SWIFT) and settlement mechanism
• Extensive knowledge of the Corporate Payments domain and good working experience of Global Pay Plus High Value Product
• Verified CSMs like FED, CHIPS and International payments (SWIFT) and settlement mechanism
• Experience in Global Transaction and verifying the Global Payments
• Testing Methodology/Testing Strategy, SDLC, STLC, Regression, performance, etc
• Testing Matrix/Test Data Set Up, Testing Strategy
• Expertise in writing scripts using JMETER
• Test Execution/Defect Analysis/Tracking (Quality Center)
• QA Management, Process Improvement, Key Learning Session
• Expert in MDM
• Verified Conversant with concepts of MDM and MDM testing
• Experience in HYBRIS AND DEMANDWARE
• Expert in basic UNIX Utilities (AWK, GREP, SED, VI Editor)
• Good experience in Web Services testing using SOAP UI,XML and WSDL; and in providing required input data to request XML& get the required data from response XML & use the response data from other request XML using SOAP UI.
• Experience in writing Test Cases for Source to Target Testing, Production Validation Testing, Data Transformation Testing and Data Completeness Testing.
• Data Validation (SQL Script) in both Front End/Back End Testing
• Testing: Front End/Back End, Real-Time/Batch Process
• Internal Team, User and Business Interaction, Management Skill
• Agile Methodology, Waterfall Methodology
• System, SIT, UAT, E2E, Sanity, Pilot, Adhoc, Security, Object, Boundary, Smoke Testing

KEY COMPETENCE:

• Informatica 9.x/8.x, Data Stage, AbInitio
• Toad, SQL Navigator, Teradata SQL Assistant,Microsrategy
• SQL, PL/SQL,ORACLE ATG,Box,Testrail
• UNIX, Linux, Windows, Macintosh, MS-DOS
• Business Objects, Cognos,Alteryx
• Toad, SQL Navigator, Teradata SQL Assistant
• HP ALM 11.0/Quality Center, TFS, JIRA,OBIEE

PROFESSIONAL EXPERIENCE:

Confidential, Secaucus, NY

QA LEAD/Sr QA

Responsibilities:

• Lead a team of Business and Data Analysts to accomplish data discovery, analysis and profiling, developing logical and physical data models, data mapping and authoring detailed technical design documents
• Experience in Oracle ATG Tool
• Expertise in Oracle and ATG to help in businesses grow revenue, strengthen customer loyalty, improve brand value, achieve better operating results, and increase business agility.
• Validated Pay pal application transactions and pay pal accounts
• Redesigned some of the existing mappings in the system to meet new functionality.
• Validated informatica MDM migration across servers, data centers & different versions (9.x, 10.x) Prepare the architecture fitment document, migration road map, identify technical & functional risks with mitigation
• Responsibilities include GUI testing, Functional testing, Integration testing, System testing and UAT
• Reviewing Test cases and scripts based on client requirements in Quality Centre
• Reporting and tracking the defects in Quality Center/ALM
• Tested various reports developed in Business Objects
• Working with TSQL
• Designed and developed Planning applications and created ODI interfaces and Packages and configured ODI Agent.
• OBIEE 11g, the Oracle Business Intelligence Server generates queries optimized for each data source, appropriately aggregates them, Web browser via easy-to-use dashboards and reports.
• Used OBIEE to generate reports, worked in Presentation layer
• Implemented the cubes for reports on various scenarios on Actual/Budget/Forecast.
• Developed the outlines using the text file method and by using Interface tool ODI.
• Checking Err File for Dimension build as well as data load, if there is any error records exists correcting and reloading those records and making sure required Outline Structure build and data load.
• Implemented/Installed the EPM applications Essbase 11.1.1.3/9.3.1 / Planning 11.1.1.3/9.3.1 in Windows server.
• Developed Web Forms using Hyperion Planning web client for the users to input Forecast, Budget, Actual accounting changes and other variance explanations data.Work on OBIEE Essbase Reports
• Business Intelligence Projects, Analysis and Administration.
• Extensiveexperiencewith MicroStrategy 9,9.2,9.2.1,8.0,8.1, MicroStrategy Desktop, MicroStrategy Web, MicroStrategy IntelligenceServer, MicroStrategy OLAP.
• Hands-on development validating assisting users in creating and modifying worksheets and Data Visualization Dashboards.
• Expertise in Creating Adhoc and Complex Reports in Microstrategy Desktop using features like templates, custom groups and consolidations.
• Expertise in gathering requirements from business users to build future application as per defined MicroStrategystandards. Knowledge in MDM architecture and Metadata Mapping
• Wrote very complex SQL to validate several BI Reports.
• Connected to telnet to the AIX environment and download, transport test Flat files
• Share the results with Stakeholders and data assessment core team.
• Worked in Groups and provided recommendations to clean up the source data, Application System modification, perform further research if needed before the final data transformation by pop/sync (Conversion).
• Suggestions to fix the anomalies during conversion stage or DB Validation
• Executed various PL/SQL stored procedures for dropping and recreating indexes on target tables and validating the same
• Involved in testing web services of the application using an Open source SoapUI Tool
• Developed Test Plans, Test Cases, and Test Scripts for SIT.
• Created Test Cases and developed Tractability Matrix and Test Coverage reports.
• Worked on SQL scripts to load data in the tables in Test environment.
• Verifying Cognos Tool for analytics.
• Publish & Consume Web services (SOAP & REST) - Axis2, CXF and Spring Web Services
• Used SQL tools like TOAD to run SQL queries and validate the data loaded into the target tables
• Tracked the defects using HP ALM tool and generated defect summary reports.
• Validated the data movement and transformations are done correctly
• Mapping to move data from source to target database-using Stages to do the functionality
• Testing of Data Mapping documents between source and target databases as per the transformations logic
• Verified The MDM work flow and the mapping the databases
• Validated scripts using automation tool
• Executed Scripts in JMETER
• Performed regression, stress/load/volume testing along with black box and white box testing, on Web and Client-Server applications
• Develop and implement Data-Driven Framework, Keyword-Drive Framework and Hybrid Framework by using VB Script and Descriptive programming
• Performed Manual Back-End testing to map the source data to the target data to verify that the data does not get corrupted traveling from front end to the back end and vice-versa
• 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
• Sending status report and reviewing the progress with client daily and involved in preparing Test results as a QA signoff
• Train users and help in conducting UAT

Environment: Informatica 9.X, HP ALM 11.0, Oracle 11g/10g, SQL/PLSQL, Teradata V2R6, SQL, SQL Plus, UNIX, COGNOS, Rational Clear Case, DB2 8.x, IBM AIX 5.5,, Flat Files, TOAD,, SOAP UI

Confidential

Lead QA/SR ETL QA Tester

Responsibilities:

• Coordinated all QA activities and enhancements using Agile Methodology.
• Analyzed user requirement document and developed Test Plans, Test Cases and test Script.
• Prepared test data for positive and negative test scenarios for functional testing as documented in the test plan.
• Responsibilities include GUI testing, Functional testing, Integration testing, System testing and UAT
• Involved in backend testing for the front end of the application using SQL Queries in Teradata data base.
• Good experience in schema objects (Facts, Attributes, Hierarchies, and Transformations)
• Expertise in developing Application Objects (filters, prompts, metrics, Custom Groups, Consolidations, Drill Maps, Templates and Searches) developed Reports, Documents and Dashboards.
• Experience in MicroStrategy Report development, Report testing, Report tuning, Ad-hoc, scheduling report delivery and Alerts and also experienced in maintain and modify existing projects, applications andreportsasrequired.
• Experienced in Microstrategy Report Services, Dynamic Dashboards, Freeform SQL, Query Optimization, Project Schema, and Micro Strategy Server Administration.
• Conducted User Acceptance Test (UAT) with users and customers and wrote issues log based on outcome of UAT.
• Worked with SOAPUI for testing Web Services
• Responsible for communication with the users and responsible for working with the users closely during UAT and getting the required sign-off’s.
• Escalation and resolution of issues with different teams during the UAT phase, getting the re-work done in a timely manner and re-testing the same.
• Analyzed test cases for automation and used Quick Test Professional (QTP) to automate manual test scripts for Regression and Functional testing.
• Prepared Test Plan wrote Test Cases and executed test scripts as well as tracked bugs and generated defect report using Quality Center (QC).
• Experience in testing XML requests and responses of web services using SOAPUI.
• Administered Quality Center partly by creating the user groups and assigning privileges to Users.
• Hands on experience in collecting several metrics and preparation of defect reports.
• Conducted Regression testing using QTP after the bugs have been fixed by the development team.
• Performed Backend testing to validate the data using Toad, added SQL queries to the required Test cases.
• Worked with Perl and UNIX shell scripts. Worked with releasing scripts live and tested.
• Report and review the defects in Mercury Quality Center & Jira Defect tracking systems.
• Helped to create Traceability Matrix to ensure comprehensive test coverage of requirements identifies all test conditions and test data needs.
• Attended several walkthrough meeting with Business analysts, Project Manager and Developers and provided feedback accordingly.

Environment: Unix,Teradata SQL Assistant, Teradata V2R6, UNIX, Oracle9g, SQL Server 2008, SQL/ PL SQL, UML, HTML, Agile, ASP, .Net, HTML, QC 9.5, QTP 10.0

Confidential, NYC, NY

ETL QA

Responsibilities:

• Responsible for managing the development, enhancement, implementation and execution of a risk-based testing program covering the Global Banking, Foreign Exchange, and Trade Services business lines to ensure compliance with U.S. laws, regulations, policies and standards.
• Review and understand the ETL processes, functionality & identify test requirements and coverage
• Reviewing Test cases and scripts based on client requirements in Quality Centre
• Velidated Prism Workflow
• Reporting and tracking the defects in Quality Center/ALM
• Validating Small Lending Business
• Tested various reports developed in Business Objects
• Experience testing foreign exchange, financial trading or risk management
• Performed manual and automated testing in Foreign Exchange Systems.
• Reviewed including foreign exchange and inflation.
• Calculates foreign exchange differences for billing and revenue as required by corporate policies. Maintains appropriate files to log all FX language, and documents interpretations of terms for all non-standard language in contracts.
• Wrote very complex SQL to validate several BI Reports.
• Connected to telnet to the AIX environment and download, transport test Flat files
• Share the results with Stakeholders and data assessment core team.
• Worked in Groups and provided recommendations to clean up the source data, Application / System modification, perform further research if needed before the final data transformation by pop/sync (Conversion).
• Suggestions to fix the anomalies during conversion stage or DB Validation
• Executed various PL/SQL stored procedures for dropping and recreating indexes on target tables and validating the same
• Developed Test Plans, Test Cases, and Test Scripts for SIT.
• Created Test Cases and developed Tractability Matrix and Test Coverage reports.
• Worked on SQL scripts to load data in the tables in Test environment.
• Used the Informatica monitor to schedule the jobs, validating and debugging its components, and monitoring the resulting executable versions.
• Running of ETL jobs in Informatica and test data setup, Quality check for test data.-Transformation logic verification, RCA for defect found.
• Used SQL tools like TOAD to run SQL queries and validate the data loaded into the target tables
• Tracked the defects using HP ALM tool and generated defect summary reports.
• Validated the data movement and transformations are done correctly
• Mapping to move data from source to target database-using Stages to do the functionality
• Testing of Data Mapping documents between source and target databases as per the transforming logic
• 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
• Reviewing Functional Specification Document and preparing traceability matrix with the test case mapped
• Sending status report and reviewing the progress with client daily and involved in preparing Test results as a QA signoff
• Reviewing Test cases and scripts based on client requirements
• Involved in Execution of test cases to verify actual results against expected results.
• Prepared bug and defect reports
• Train users and help in conducting UAT

Environment: Informatica 9.X, HP ALM 11.0, Oracle 11g/10g, SQL/PLSQL, Teradata V2R6, SQL, SQL Plus, UNIX, COGNOS, Rational Clear Case, DB2 8.x, IBM AIX 5.5,, Flat Files, TOAD,, SOAP UI

Confidential

Etl /QATester

Responsibilities:

• Analyzed business requirements, system requirements, data mapping requirement specifications, and responsible for documenting functional requirements and supplementary requirements in Quality Center 10.0
• Involved in developing detailed test plan, test cases and test scripts using Quality Center for Functional and Regression Testing.
• Involved in Data mapping specifications to create and execute detailed system test plans. The data mapping specifies what data will be extracted from an internal data warehouse, transformed and sent to an external entity.
• Involved in Teradata SQL Development, Unit Testing and Performance Tuning
• Develop and initiate more efficient data collection procedures.
• Analyze the mapping specification to understand the business logic.
• Tested Complex ETL Mappings and Sessions based on business user requirements and business rules to load data from source flat files and RDBMS tables to target tables.
• Created the test environment for Staging area, loading the Staging area with data from multiple sources.
• Extraction of test data from tables and loading of data into SQL tables.
• 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..
• Developed and Tested UNIX shell scripts as part of the ETL process, automate the process of loading, pulling the data.
• Written several complex SQL queries for validating Cognos Reports.
• Tested several stored procedures.
• Tested the ETL process for both before data validation and after data validation process. Tested the messages published by ETL tool and data loaded into various databases
• Experience in creating UNIX scripts for file transfer and file manipulation.
• Validating the data passed to downstream systems.
• Involved in testing data mapping and conversion in a server based data warehouse.
• Worked with business team to test the reports developed in Cognos
• Tested whether the reports developed in Cognos are as per company standards.
• Used Quality Center to track and report system defects
• Involved in testing the XML files and checked whether data is parsed and loaded to staging tables.

Environment: Informatica 8.6.1/8.1, SQL Assistant 7.0, Oracle 9i, SQL, PL/SQL, DB2, Java, Cognos 8.0 Series, XML, XSTL, XSD,UNIX,, Quality Center 9.2, VSAM Files, MVS

Confidential

Data base tester

Responsibilities:

• Developed Test cases, Test scripts from the data mapping documents, functional Specification documents.
• Mapped the test cases with the requirements for generating the Requirement Traceability Matrix (RTM).
• Worked on all the stages of SDLC for this project and designed and executed Functional, Integration, Regression, and System (End to End), UI Testing, Browser Compatibility, Backend (Database) Testing.
• Developed and executed test cases and test scripts.
• Involved in testing the UI screens, reports which was used by the internal business team.
• Prepared Test Scenarios by creating Mock data based on the different test cases.
• Involved in testing the functionality of Ab Initio Graphs.
• Tested the PL/SQL procedures, functions, packages according to the requirements.
• Involved in testing the batch programs by using the Autosys tool.
• Exclusively tested the inbound and outbound batch jobs.
• Involved in writing as well as testing the UNIX shell scripts.
• Used HP Quality Center as test management tool.
• Tested Business Objects Reports according to the business requirements.
• Prioritized the test cases based on the projected metrics and project deadlines.
• Worked with Developers on Defects until the test case is passed.
• Extensively written SQL to confirm the data transfer from source to target.
• Verified test results (viewing the log files using VI editor, querying the database using the SQL) documenting
• Attended Bi-Weekly Defect Review and Defect Status meetings. Provided updates to Team Lead on testing

Environment: Ab Initio2.x, HP Quality Center, Business Objects, Rational Clear Case, Clear Quest, TOAD, JCL, Web Logic, MS Access, Oracle 9i, SQL, PL/SQL, UNIX, Putty