SUMMARY

• Having 9+ Years of experience in the field of IT, Specializing in Software QA/QC & Testing on Client/Server, Web Based, E - Commerce, ERP/CRM, DW/ETL, BI based applications.
• As a QA Analyst, responsible for understanding/reviewing business requirements, developing/documenting Test Scripts, Test Case Designing, Test Scenarios, Test Plans, Test Data, Test Results and other Test Artifacts.
• Experience in interacting with Business Analysts, Developers, and Technical Support to help them base line the requirement specifications.
• Experienced in all phases of Testing Lifecycle with expertise in the Integration and Functional, Input domain, User Interface, Sanity testing, Regression and Re-testing.
• Complete Software Development Lifecycle (SDLC) experience from business analysis to development, testing, deployment, documenting, maintaining and user training.
• Worked with Database migration Testing experience in different versions of Informatica
• Expertise in black box, functional, regression, integration, Interface, Ad-hoc Testing, and User Acceptance Testing(UAT).
• Experience in Testing Datamarts, Migration, ETL, OLAP, Reporting, ETL(Informatica, Data stage and Abinito), Cognos, Business Object and documentation.
• Extensively tested the Micro strategy reports by running the SQL queries on the database by understanding the Reports requirement documentation.
• Experience in software requirement analysis, Modeling, Configuration Management and Change Management using Agile(Scrum/Sprint) Methodology.
• Experience with Data profiling, Data Validation and Data Integrity and Data Cleansing and ETL processes using Informatica
• Database experience includes Oracle, SQL Server and Teradata, writing SQL queries, joins, unions etc with Strong Database testing ex perience.
• Experience on Data profiling, ETL Data Validation and Complex SQL Queries
• Issue verification and closure. Manages build tests. Follow bug descriptions, identify bugs, research bugs, reproduce bugs, indicate if a bug is/is not reproducible and find the Workarounds.
• Having 1+ Years of exp. as a QA Lead Consultant, Onshore/Offshore Lead activities.

TECHNICAL SKILLS

QA Testing Tools: Mercury Quality Center, Test Director, JIRA

Quality Methods: Agile/Sprint/Scrum Methodology, ISO, CMM/I

ETL-DW, BI-BO Tools: Informatica, Data Stage, Ab Initio, SAP BI, Cognos, Microstrategy

DBMS/RDBMS: Oracle, SQL Server, TeraData, DB2, TOAD

Functional Test Tools: WinRunner, QTP

ERP/CRM: SAP, Sales Force/Cloud

Configuration Tools: MS Visual Source Safe, Rational Clear Case

Scripting Languages: VB Script, Java Script, UNIX Shell Scripting, Perl

Languages: C, C++, SQL/PLSQL, Java

Web Technologies: HTML, ASP, JSP, EJB, Servlets, DHTML, and XML

Web Servers: IIS, Web Sphere, Web Logic

Operating Systems: Ms-Dos, Window NT to Windows 7, Unix, Linux

GUI Tools: Visual Basic 5.0/6.0, Developer 2000, Power Builder, Front Page

Web Browsers: IE Explorer, Chrome, Netscape Browser, Fire fox and AOL

MS-Suite: MS Word, Excel, PowerPoint, Outlook

PROFESSIONAL EXPERIENCE

ETL QA Analyst

Confidential - Redwood City, CA

Responsibilities:

• Understanding of Business Requirement Specifications and System Requirement Specifications.
• Prepared Test Cases based on Functional Requirement Specification Document, Use Cases, and Low Level Design document, Test Scripts, Test Data.
• Worked on Data profiling, Data Validation, Data Integrity, Data Cleansing and ETL processes using Informatica.
• Perform the data load activities based on mapping specification document and data load from source System to Target system.
• Daily/weekly interactions with the Business Analysts to evaluate/escalate issues with respect to the mapping documents.
• Validated the data thru various stages of data movement from staging to Data Store to Data Warehouse tables.
• Extensively use SQL queries for data validation and backend testing.
• Involved in Data base testing, Data Migration Testing, Functionality, Interface, Regression testing, Systems Testing and Business Objects reports testing by writing Test Cases/Test Scripts for each phase of software testing.
• Involved in full end to end ETL testing using Informatica ETL tool.
• Provided flexible & high quality support to wider Testing strategies on key regular deliverables & ad-hoc reporting issues.
• Extensively tested the Micro strategy reports by running the SQL queries on the database by understanding the Reports requirement documentation.
• Validated the reporting objects in the reporter against the design specification document.
• Validated the data files from source to make sure correct data has been captured to be loaded to target tables.
• Validated the load process of ETL to make sure the target tables are populated according the data mapping providing it satisfied the transformation rules.

Environment: & Technologies: HP ALM, Informatica, SQL Server, Oracle, Microstrategy, SAP BO, QTP, Windows, J2EE, XML, JSF, Spring, Hibernate, UML, Web Services, SOAP, SOA, Unix, Shell Scripting.

Sr. QA Consultant Analyst

Confidential, San Rafael, CA

Responsibilities:

• As a Sr. QA Consultant role for all Systems Testing, SIT, End-End Testing and User Acceptance Testing for major project interfacing with many areas, including Client, Senior Management, Business Analysts, SME’s, Dev, Database & Test Teams for all the Projects.
• Responsible for various aspects QA deliverables of Testing Viz Test Management & Methodology Test Case Schedule /Planning, Test Case/Scenario’s preparation, Test Case review, Test Execution, Quality Assurance, Defect Management, UAT Coordination, Regression Testing, Test Data preparation, Test Results and all other Test Artifacts.
• Responsible for Issue Verification and closure, follow bug descriptions, identify bugs, research bugs, reproduce bugs, indicate if a bug is/is not reproducible and find the Workarounds to make sure to deliver reports in time.
• Responsible for creating & executing test cases and raise the defects by using the defect tracking tool Mercury Quality Center 10.0.
• Validate the DW/ETL daily jobs using the Informatica Power Center tool to monitor the job execution process raise the defects accordingly if any failures after analyze the root cause.
• Worked and tested on Informatica Designer tools - Source Analyzer, Data warehousing designer, Mapping Designer, and Transformations, Repository manager, Workflow manager and Workflow monitor.
• Validated the Mappings Using Transformations like Expression, Router, Filter, Normalizer, Sequence Generator, Joiner, Lookup, Sorter and Aggregator.
• Involved in test planning, writing test cases/scripts and test execution.
• Familiar with defect management systems
• Read and understood data model.
• Participated in Full Lifecycle Development on large projects.
• Understood Unit, Functional, System, Performance, Technical and Operational testing and the tools utilized.
• Knowledge of software development life cycle principles and awareness of Agile practices.
• Experienced with data migration testing, data validation testing.
• Validations of the feeds (HR and Transactional) to and in the Commissions DB.
• Validating the SAP HR/Workday feeds to Comms DB by using SSIS Packages and then to SFDC by using Informatica jobs. Also HR Feeds to Relay server by using SSIS Jobs.
• Create and validate the different scenarios of SFDC TTS’s and verify the SFDC to ASIMS extracts.
• Validations for the IA project implementation - Territory Tool data.
• BO need to be validated and the marts, the sources for the transactional data to Comms DB.
• Validate the SAP Business Objects reports which load from different data marts.
• Create & Validate the SAP Sales Orders.
• Generate the Attainment, Transactional & VCP reports on Quarterly basis.
• Experience in working with scripting test automation using Java, Perl/Unix Scripting.
• Generated the Sales Reports by using the XL-Pivot functionality upon customer request on Daily/ Monthly/Quarterly/Yearly Vs GEO/Products wise reports. Having Knowledge on Validating the QlikView Dashboard Reports.

Environment: & Technologies: Agile Methodology, Quality Center, Sales Force/Cloud(SFDC), Siebel, Workday, SAP HR/FICO, SAP SD, ETL & Informatica, SQL Server, Oracle, SAP BO/BI, Mainframes, QTP, Windows, Unix and other related technologies.

Sr. QA Consultant Analyst

Confidential, Emeryville, CA

Responsibilities:

• Understanding of Functional Requirement Specifications and System Requirement Specifications.
• Gathering the requirements and preparing the case generation.
• Provide review comments on Test Scenarios and Test Cases based on Functional Requirement Specifications.
• Preparation of Test Plan, Test Scenario and Test Cases based on Functional Specification Document.
• Preparation of Requirement Traceability Matrix, Test Metrics and Deployment manual.
• Perform Sanity Testing, Data Driven Testing & Ad-hoc Testing when required.
• Perform system testing to ensure the validity of the requirements and mitigation of risks prior to formal acceptance.
• Actively Participating in the Sprint Planning with core team, and Provides the Sprint Sign off the Sprint Cycles for every two weeks.
• Experience with n-tier web architected solutions.
• As part of the MDM, Validated the Customer Data Manipulation, Claims Process, Account & Administration Process, etc..
• Experience with Data profiling, Data Validation and Data Integrity and Data Cleansing and ETL processes using Informatica.
• Performed Interface and Integration(SIT) Testing.
• Perform User Acceptance Testing with UAT test scenarios.
• Extensively use SQL queries for data validation and backend testing.
• Working with Data base testing Involved in Data Migration Testing and preparing documents. Functionality, Interface, and Regression testing.
• Execution of Test Cases and Test Scripts. Perform end to end ETL testing using Informatica ETL tool.
• Find and report defects and subsequently validating the fix, repeating the process until done.
• Track Sheet Maintenance and map the use case to requirement.
• Build deployment activities and participate in design (spec) reviews with the Core team.
• Evaluate and suggest improvements to the software development process.
• Monitor Testing Activities within the team and report regular progress to the Test Manager.
• Conduct Project Domain and Internal Project Functionality Training Sessions.
• Work closely with the software engineers to ensure successful, high quality releases.
• Understand Business Requirement Specifications and System Requirement Specifications.
• Perform the data load activities based on mapping specification document and data load from source System to Target system.
• Extract data from different source systems using Data Services tools.
• Validate the ETL load process to make sure the target tables are populated according the data mapping from Source(ODS) to target, validation Field to Field verification.
• Perform end to end ETL testing using Informatica ETL tool.
• Experienced at testing ETL's and flat file data transfers.
• Proficiency in customization & implementation of ETL processes and Web applications.
• Hands on expertise in Data ware housing concepts and tools. Involved in the ETL processes where in the organizations were using Informatica.
• Involved in BA walkthroughs and ETL Specification Document.
• Create the universe based on the Reporting specification document.
• Prepare the SQL Server 2008 queries to fetch the data from databases.
• Experienced on working Flat files, File Extraction and Data loading and validation, Inbound and outbound file handing experience. Experience in working with Unix shell Scripting.
• Sound Knowledge on Property and Casualty insurance operations including Underwriting, Premium billing, Claims, Reinsurance, and Finance/accounting.
• Extensive experience working on Web based/Website testing with different type of Cross-browsers like IE, Mozilla, Safari, etc.. Testing the Browser Independence, Check printed pages, Switch JavaScript off, Switch plug-ins off, Switch images off, etc..
• Good understanding of SOA architecture, Experience creating Web Services Test Scenarios / Test Cases.
• Expertise Testing the Web services using the WSDL or SOAP requests (or any other formats, as required).
• Expertise validating Request messages are per the Message contracts, Expertise in inspecting the response SOAP messages.
• Experience in validating the response messages in case of Abstract Web services.
• Expertise on analyzing services and its relationships, Experience analyzing Web services schema and namespace.
• Experience of testing XML based (files/editors) Web services in complex systems, integration environment consisting of Web, Application, and Database servers.
• Experience on testing and XML files generation and manipulation and proficient in working with XSLT.

Environment: & Technologies: Different Testing Tools/Techniques, Agile/Sprint Methodology, Rally, Quality Center 10, Sales Force/Cloud, J2SE and J2EE, JAX-WS, JPA, XML, JSF, Spring, Hibernate, UML, Web Services, SOAP, SOA, Unix, Perl & Shell Scripting, Oracle, DB2, SQL Server, SSIS, ETL & Informatica, Cognos, Windows, AIX, Linux.

QA Consultant

Confidential, West Point, PA

Responsibilities:

• Understanding of Business Requirement Specifications and System Requirement Specifications.
• Prepared Test Cases based on Functional Requirement Specification Document, Use Cases, and Low Level Design document.
• Prepared Test Scripts and Test Data based on Functional Requirement Specification Document.
• Performed data migration activities in Informatica one version to another version
• Performed System, Functional, Interface and Integration Testing.
• Performed Regression and Retesting
• Validated the data Source (CARES system) to Target (EDH system).
• Source to target data validation Field to Field verification.
• Performed end to end ETL testing using Informatica ETL tool.
• Involved in BA walkthroughs and ETL Specification Document.
• Created SQL queries to fetch and verify the data from Source and Target (Teradata).
• Conducted on the ODS data testing and Knowledge on XML.
• Loaded the data into Teradata.
• Involved in Build deployment activities and ran UNIX scripts.
• Prepared of Test Scenarios, Deployment manual and Test Metrics.
• Performed Sanity Testing, Data Driven Testing & Ad-hoc testing.
• Verified outperform, generated file feed, formatted and compared with cares data.
• Checked the control table data, verified report data with source.
• Ran the ETL process from CARES to EDH (Teradata) in UNIX environment.
• Designed the Requirement Traceability Matrix document based on the Functional Requirement document and Test Cases document.
• Provided daily status to Test Lead.
• Defect Logging and Verifying resolved bugs and reported regular progress to the Test Manager.
• Conducted peer review of test cases and provided comments.
• Defect logging in bug tracking tool (QC) and Verifying resolved bugs.
• Worked closely with the Developer and BA to ensure successful, high quality releases
• Verified report data with source.
• Field level data verification.

Environment: & Technologies: JSP, J2EE, Struts, Sun JDK, HTML, Web Portal, XML, Web Services, SOAP, JavaScript, .NET Framework 3.0, C#, ADO.net, MS IIS, ASP, ActiveX, VB Script, Visual Source Safe, Apache/Tomcat, Oracle 10g, DB2, WinSQL, T-SQL, Win 2K/XP, UNIX, COBOL, MF CICS, ETL, Abinitio, Cognos Reports, Documentum, Quality Center 9.2, Agile Methodology, Manual Testing.

Sr. QA Analyst

Confidential, Chicago, IL

Responsibilities:

• Involved in participating in the full software life cycle for testing activities - from test planning, writing test cases, test execution to test monitoring, status reporting, documentation and data validation.
• Validated the data thru various stages of data movement from staging to Data Store to Data Warehouse tables.
• Created Test Cases using the SDLC procedures and reviewed them with the Test lead.
• Validated the external data source by connecting through Oracle heterogeneous services and joining them to existing tables and reporting the anomalies in the data.
• Tests included System Testing, Regression and Business Objects reports testing.
• Provided flexible & high quality support to wider Testing strategies on key regular deliverables & ad-hoc reporting issues.
• Extensively tested the Business Objects report by running the SQL queries on the database by reviewing the report requirement documentation.
• Validated the reporting objects in the reporter against the design specification document.
• Validated the data files from source to make sure correct data has been captured to be loaded to target tables.
• Validated the load process of ETL to make sure the target tables are populated according the data mapping providing it satisfied the transformation rules.
• Validated the Archive process to purge the data that met the defined business rules.
• ETL validation, Data Model Validation.
• Involved in validating the aggregate table based on the rollup process documented in the data mapping.
• Performed data migration activities in DataStage one version to another version
• Retested the modifications, once bugs were fixed after reinstalling the application.
• Reported the bugs through email notifications to developers using Mercury Quality Center.
• Generated Problem Reports for the defects found during execution of the Test Cases and reviewed them with the Developers. Worked with Developers to identify and resolve problems.
• Developed presentation and testing implementation learning to other testing resources for cross functional training.

Environment: & Technologies: JSP, J2EE, HTML, Web Portal, XML, WebServices, SOAP, JavaScript, WebLogic 8.x, Oracle 10g, DB2, Win 2K/XP, UNIX, Perl Scripting, COBOL, MF CICS, Rational Clear Quest, ODS/ETL Techniques, DataStage, Cognos Reports, Agile Methodology, Manual Testing.