Aarti Sharma (acvvrt@r.postjobfree.com) Tel: 609-***-****

Summary

Over 9 years of Software Quality Assurance (QA)/ BA experience testing Data Warehouse, Database (ETL & BI), Web and Client-Server Systems and Applications for Banking, Healthcare, Financial, Wireless, and Retail Industries.

Certified Scrum Master.

Expertise in Writing, Executing and Maintaining Test Plans, Test Strategy, Test Procedures, Use Cases and Test cases.

Excellent working knowledge of System Development Life Cycle (SDLC), Software Testing Life Cycle (STLC), Agile and Scrum Methodology. Expert in Manual Testing and Back End Testing.

Very good understanding of Data Warehousing concepts, Data Analysis, Data Warehouse Architecture and Designing.

Experience in ETL Testing, Web application Testing and Client Server application testing.

Created Use case Diagrams and flow Charts in MS Visio.

Experience in Testing Business Intelligence (BI) reporting tools using Cognos, BO & Microstrategy. Have tested several complex reports including dashboards, Packages, Cubes

Knowledge of creating Product backlogs in Sprint, Pointing and Ranking the user stories, Sprint Planning, daily Scrum meetings.

Ability to collaborate with peers in both business and technical areas, to deliver optimal business process solutions in line with corporate priorities.

Possess good communication skills, self-motivated, proactive, task oriented, quick learner of new technologies, mentor for team members, lead and coordinated different groups, trained new recruits with Business process and methodologies.

Technical Skills:

ETL Tools : Informatica Power 9.0, Power Connect, Power Analyzer, and Power

Exchange tools

BI Tools : Cognos connection 10.2.1, Business Objects, and Microstrategy

Languages : SQL, PL/SQL, JCL, COBOL

Databases : Oracle SQL Developer, MS Access, SQL Server, Teradata

Testing Tools : Quality Center 10, Jira, Bugzilla and Test Director

Professional Experience:

Synchronoss Bridgewater New Jersey April 2013– Present

Sr. Reporting Quality Analyst

Environment: Cognos 10.2.1, Oracle SQL developer, PL/SQL, Oracle 11gR2, Bugzilla, Jira, Confluence, AtTask(Workfront)

Hadoop(Hive)

Responsibilities:

Tested several complex reports generated in Cognos including Dashboard.

Written complex SQL Queries for Interacting with data bases to validate Reports.

Involved in Design and development of test plans and test cases based on high level and detailed designs.

Developed User-Acceptance Test cases and assisted users in conducting UAT

Involved in ETL Testing, creating test data and test cases.

Conducted Daily status call and helped offshore team in understanding business requirement and created document.

Used Oracle SQL developer tool to connect to Oracle DB to validate the data that was populated by ETL applications.

Tested Cubes and packages in Analysis studio and Query studio in Cognos.

Responsible for complete manual testing and PPV (Post Production Validation).

Tested reports generated for Cloud data and Mobile Content Transfer.

Used Issue tracker Tool Jira, Bugzilla for Bug Reporting and Tracking for application.

Performed End to end testing starting from the source to the report.

Performed Data Analysis to find Data gaps

Involved in Big Data Testing from Count.ly - Hadoop-Data base.

Wrote query on Hive to compare the data with Data Mart.

Performed Mobile Device Testing such as Application/Feature/Function/Wi-Fi Aggregation/Network user Trail

Personal Cloud data upload and download on various devices such as Android/ iPhone /Win phone.

Verizon Wireless Warren, New Jersey June 2012 – Mar 2013

Sr. Quality Assurance Analyst/BA

Environment: Microstrategy 9.2.1, SQL, PL/SQL, SQL Server 2008, Red Hat Linux 5,Teradata 12, Oracle 11gR2, HP Quality Center 10, QTP 11.

Responsibilities:

Attended Daily Scrum meetings, Defect review meetings. Executed tasks proficiently meeting crucial deadlines

Participate in scoping and requirements discussions with the client

Developed Technical and Business documents, business process flows, and business process models.

Participated in preparing Test Plan from the BRD and Functional Specification.

Developed Test Cases for the Functional/GUI Verification, ETL Data Validation, Metric Verification and Report Testing.

Validated ETL processes and made sure that the data from source to target tables are loaded correctly. Created and executed complex SQL queries to validate the flow of data. Tracked and reported the bugs with HP Quality center.

Validated the front end reporting components created using Microstrategy and Web Intelligence reports as well as Back End testing, making sure that the correct data for a specific report are being pulled out from the Data Warehouse.

Performed regression testing after every enhancements, build installation and releases.

Responsible for functional testing, user interface testing and user acceptance testing.

Testing both Manual & Automation in with HP tool- QTP

Experienced in HP’s ALM (Quality Center) application management

Ran Automation scripts and performed Regression Testing on various builds.

Excellus BCBS, Rochester, New York Aug ’2010 – May 2012

Sr. ETL QA /Business Analyst

Environment: Informatica 8.6.1, BO XIR3, SQL, PL/SQL, SQL Server 2008, Unix Shell Scripting, JCL, TSO, COBOL Files, TOAD 9.2, Teradata, Oracle 10g, Mainframe, HP Quality Center 10, MQ Series, Microsoft Visio, Web Focus reports,UNIX

Responsibilities:

Worked as a liaison between technology and the business clients to improve business process and support critical business strategies.

Worked closely with UAT Team to understand their needs and issues.

Responsible for verifying of data integration/migration from various distributors systems into the Data Warehouse environment and maintaining the Informatica Repository.

Assisted the development team in the source to target mapping for ELT design.

Created Use Cases and business process flowcharts on which the actual system architecture would be based.

Involved in Database testing by writing & executing SQL queries using TOAD to validate that data is being populated in an appropriate tables & manually comparing the results with front-end values.

Worked as ETL Tester responsible for the requirements / ETL Analysis, ETL Testing. Involved in Regression, load, UAT and Functional Testing.

Tested ad hoc, dashboard, canned, web application and client server reports.

Coordinate Test Data Preparation with business users covering all necessary features for securities.

Generated tractability Metrics to ensure that all the requirements are covered by the test cases.

Designed and developed Test Plans, Test Scripts and Test Cases in HP Quality Center and executed them based on Business Requirement (BRD), User Requirement Document (URD) and Functional Requirement documents (FRD).

Providing testing inputs to the Project team (Project manager, Planner and the Development lead) during the Planning sessions to finalize the Work Breakdown structure (WBS).

Bank of America Jan ’2009 – Jul ‘2010

Sr. QA/ETL Tester

Environment: Informatica Power Center 8.1, Business Objects XIR2/6.5.1,SQL, PL/SQL, SQL Server 2000/2005, Teradata, TOAD 9.2, Oracle 9.2, UNIX and HP Quality Center

Responsibilities:

Designed and developed Test Plans, Test Scripts and Test Cases based on Business Requirement and Functional Requirement documents.

Used various SQL queries to validate the test case results for back-end test cases.

Developed and involved in both Manual Testing and Automation Testing.

Tested Reports that were created in BO by running SQL.

Worked as ETL Tester responsible for the data verification/validation and ETL Testing.

Experienced in writing complex SQL queries for extracting data from multiple tables.

Performed UI testing, Regression Testing, UAT and Functional Testing

Citigroup Sep ’2007 – Dec ‘2008

Data/SQL Tester

Environment: Informatica Power Center 8, SQL Server 2000/2005, SQL, PL/SQL, Erwin 4.0, XML, JCL, TSO, TOAD, HP Quality Center, Teradata, Report Net, Mainframe,, Cognos 8 B Report Studio, Cognos 8 BI Query Studio, Report Net 1.1

Responsibilities:

Gathered user requirements from each Business Units for test.

Interacted with the Business users to identify the process metrics and various keys dimensions and measures.

Designed and developed Test Scripts and Test Cases and executed them.

Used Teradata SQL Assistant extensively to work with Teradata Database.

Documented defects accurately and with sufficient information to enable developers to analyze and reproduce the defect using Test Director’s defect reporting tool. Used Query Studio to test ad hoc reports.

Used various SQL queries to validate the test case results for back-end test cases.

Tested several complex reports generated by Cognos including Dashboard, Summary Reports, Master Detailed, Drill Down and Score Cards.

Involved in Regression, UAT, Integration and Load Testing.

Developed complex queries using different data providers in the same report.

Sears Holdings, Chicago, IL Nov ‘2006 – Aug ‘2007

Data Tester/ETL/SQL

Environment: Informatica Power Center 7.1, Oracle, MS Excel, Flat Files, SQL, PLSQL, SQL Server, Erwin 4.0, Unix Shell Scripting.

Responsibilities:

Used Informatica Power Center for Extraction, Loading and Transformation (ETL) of data into the Data Warehouse.

Involved in developing and writing the Test Cases, Test Plans and Test Scripts using the Business Requirement

Involved in Manual Testing, positive testing and Negative testing of the Application.

Created the test data & Coordinating with Developers/Leads in resolving bugs.

Completely involved in developing Test Plans, Test Cases/Test Strategy with input from the Business Analysts

Extensively involved in the UAT and Performance testing of the programs.

Coordinated with QA Testing Team to test various test scenarios involving Test Plans, Test Cases and Test Scripts.

Used various SQL queries to validate the test case results for back-end test cases.

Certification: CSM - Certified Scrum Master

Education: Bachelor of Science (Bombay University, INDIA)

Work Status: US Citizen

Contact this candidate