SUMMARY

• IT Consultant with excellent Business Data Analysis, Quality Analysis skills. Aiming to use my abilities to successfully fulfill the Enterprise Data analysis and Quality roles in your company
• Experience in Data Cleaning, Data Aggregation, Data Mining, Data Analysis, Application Development and EDW Reporting
• Extensive experience in test designing, test planning, test automation, functionality testing, system testing, integration testing, regression testing, load testing, performance testing, usability testing, user acceptance testing and test execution of Client Server and Web Applications.
• Proficient in Clinical, auto/property Insurance(guidewire), HCM(workday) domains
• Expertise in developing and maintain overall test methodology and strategy
• Analyze the Business Requirement Document, Functional Specification document and Design document to prepare Test Cases based on the Test Plans and Use Cases
• Experience in White Box Testing, Black Box Testing, Positive, Negative, Data Driven Testing, Performance Testing, Load Testing, Stress Testing, Regression Testing, Integration Testing, System Testing, and Functional Testing
• Understanding and knowledge with retrieving data using Web services APIs. Used SOAP UI for testing service oriented architecture. Develops, maintains, manipulates and analyzes databases for department, extracting data from other systems as necessary and developed metrics to track performance plans.
• Involved in discussion with the team to come up with logical conclusions based on test results
• Extensive experience Visio and MS office tools like Ms - Word, PowerPoint and Excel
• Generated bug reports using bug - tracking tools for business software’s and web Applications
• Ability to interact with end users, self-motivated, quick learner and team player with excellent communication skills
• Reviewed user Stories in Product Backlog and Sprint Backlog
• Created Testing Tasks of testing and monitor Testing Tasks on Daily Basis
• Attended Sprint planning meeting| Daily Scrum Meeting| Scrum of Scrums| End Meetings| Sprint retrospective Meetings
• Escalated and discussed Testing impediments to Scrum Master and Product Owner.
• Prepared validation strategy for data extraction, transformations and loading processing, in a enterprise-wise-ETL Implementation.
• Experience in Data Analysis, Data Mining, Data Mapping and Data Validation.
• Proficient in Backend Testing, Data Integrity Testing and DataMigration testing using SQLQueries.
• Thorough understanding and analysis of Advanced SQL and Stored Procedures forreport extracts and Business Intelligence reporting.
• Developed user Acceptance test Plan|Created User flow test cases for UAT|Executed test cases and analyze results.
• Provided Test Summary reports to client managers.

TECHNICAL SKILLS

Operating System: Win Vista/XP/ 2000/NT/98, UNIX, MS-DOS, MAC OS X, AIX, Linux, HP-UX

Database: MySQL, MS Access, DB2, Oracle

Web /App Server: Web logic, IIS, Tomcat-Web Server, WebSphere,JBOSS

Languages& Web Technologies: Java, HTML, XML, VBScript, JavaScript

Testing Tool: Selenium IDE, Quality Center, QTP, SoapUI, Visual Source Safe, Test Link, ITKO LISA

Defect Tracking Tool: BugZilla, TRAC, JIRA

Other: Sharepoint, Lotus notes, Informatica, Cognos, SalesForce CRM, SAS V9.1.3 / V9.2 /V9.3,SAS/BASE,SAS/STAT, SAS/SQL, SAS/MACRO,SAS/ODS, SAS/GRAPH, Informatica Powercenter,Cognos

PROFESSIONAL EXPERIENCE

Confidential, Madison, WI

Data Analyst /Quality Analyst

Responsibilities:

• Key responsibilities include data profiling, data assessment, documenting the anomalies and evaluating the discrepancies from the DB Validation report and fixing it by using SAS.
• Updated the data rules spreadsheet that will be used to update allowed values, findings and profiling results
• Identified the anomalies in business transactions data, and followed up with the SMEs to find if it is an unexpected result or an anomaly
• Attend Iteration planning meeting and finalize the user stories and estimation for the 4 weeks sprint/iteration.
• Involved in preparing high level scenarios based on Agile Methodologies for each Scrum.
• Analyzed user stories developed test plans, test cases to cover overall QA System Testing.
• PerformedFunctional,Negative,Positive, Integration,Functional, Regression,End to EndandUser Acceptance Testing.
• Attended review meetings with Business Analysts, Developers and end users to understand the requirements.
• Developed test cases for different added functionality as per the Requirement Specs and Functional specs in Quality Center test management tool.
• Defect details, assigned severity and reported defect status to the QA Prime/Manager/Scrum Master
• Performed Sanity testing in Production environment after application is deployed. This is to confirm that application is deployed correctly and working as expected.
• Handle multiple priorities and assign tasks and estimates in User Stories.
• Prepare weekly summary reports for management.
• Work with Business Analysts and Development team to close gaps in requirements definition and understanding.
• Test and validate ETL Processes as required, validating source and target tables.
• Write SQL Queries to formulate logic adhering to functional spec
• Developed and executed complex SQL Queries to perform database testing.
• Run regression and smoke test suites on a new version of the application,
• Good experience in testing web services functionality using SOAP UI and ITKO LIsa
• Analyze the automation results once Selenium scripts execution completed.

Environment: Windows XP, QTP, J2EE, Oracle, IBM Web Sphere, Quality Center, Selenium, RTC, SQL Developer, SOAP UI, Mainframes and Agile Methodologies, TIBCO, SAS, ITKO LISA

Confidential, Madison, WI

Data Analyst/Quality Analyst

Responsibilities:

• Responsible for supporting the successful implementation of the Workday solution while providing product, implementation and test expertise.
• Responsible for developing key testing work products like Master Test Plan, System Test Plan, Test Report and Detailed Test Plan based on risks and acceptance criteria agreed with the Client.
• Participate in the requirements gathering sessions along with Business Analysts with the Business stakeholders, to make sure that the requirements are testable in terms of Quality Assurance stand point.
• Provide Test Estimation based on the complexity of the requirements and schedule/project plan of the Client.
• Preparation of Checklist (For which test case needs to be automated)
• Logging the expected failure of script against defect
• Coordinated the testing efforts of an offshore team of three testers.
• Automated Regression Test suite using QTP 10.0.
• Performed webservices Testing using SOAP UI and ITKO Lisa
• Gathering Student data information and preparing data requirements.
• Preparing Data Assessment, Data profiling and identified anomalies spread sheet according to the requirements.
• Identify the data elements to be assessed.
• Compare the data elements according to source allowed values.
• Documented the data assessment findings
• Document anomalies found in Identified anomalies sheet.
• Share the results with Stakeholders and Data assessment core team

Environment: Windows XP, QTP, J2EE, EJB,XML,MQ Series, Oracle, IBM Web Sphere, Quality Center, Selenium, RTC, SQL Developer, SOAP UI, Mainframes and Agile Methodologies, TIBCO, ITKO LIsa

Confidential, CA

Business Quality Analyst

Responsibilities:

• Customized the Automation framework for the project and executed it all through the lifecycle.
• Performed GUI testing on various screens and validated Guide Wire-Policy Center work flows: Policy Submissions, Policy Changes, Policy Renewals, Policy Cancellations, Policy Reinstatements, Policy Rewrites and Policy Audits
• Prepared Test Cases for Functional and Regression Testing of Policy Center.
• Validated Policy Center Integration with DMV(Department of motor vehicles)/VIN Service/Vendor Management System/Address Normalization Services and credit rating Systems
• Performed ETL validation of downstream datawarehousing layers.
• Executed Functional and Regression Test Cases for modules.
• Created traceability Matrix between requirements and Test Cases in Quality Center.
• Prepared Defects and Test Status Reports in Defect Tracking Tool (JIRA).
• Involved in preparing Test Data, Testing environment and Test Metrics.
• Conducted Defect Review Meetings.
• Used PL/SQL to query the database
• Identified and Automated Regression Test suite using QTP 10.0.
• Worked on Enhancement of scripts by adding datasets for parameterization, CheckPoints and Reporting Functions.
• Written VB Scripts and created reusable functions.
• Participated in Peer Reviews of automation scripts and documented review comments
• Interacted daily with the project team resolved issues to make enhancements based on the change requests.
• Conducted User Acceptance Testing (UAT) and verified performance, reliability and fault tolerance issues.
• Involved in weekly walkthroughs and assessment meetings to verify the status of testing effort and the project as a whole.

Environment: Quality Center, Load Runner, UML, Visio 2003, Informatica 8.6, WIN CVS, MS Project, MS Office Suite, Microsoft SharePoint 2007, SQL Server 2005, Toad, Guide wire Policy Center, QTP and iOS, Android

Confidential, Louisville, KY

Data Analyst/Test Engineer

Responsibilities:

• Created business requirement documents for variety of data quality projects and liaison between business users and technical development teams for the remediation of the issues.
• Writing SQL queries using SAS to create end-user reports and perform data-mining.
• Performed source, target validation as part of Extraction Transformation Loading (ETL) testing
• Used MS Excel, with proficiency using formulas and PivotTables.
• Prepared Test Strategy and Test Plan Documents.
• Distributed and assigned tasks to the team members.
• Prepared Functional Test Cases from requirements document.
• Worked on Test Data Setup for all complex business Test cases.
• Worked on Change Requests and updated Existing Test cases and conditions based on that.
• Followed software testing life cycle (STLC) to perform various kinds of testing such as Functional, Regression, System, Exploratory, Compatibility and Ad-hoc testing.
• Created and executed regression test cases that complement phase wise development of entire system.
• Involved in UAT Testing.

Environment: Quality Center, Load Runner, UML, Visio 2003, Informatica power center, WIN CVS, MS Project, MS Office Suite, Microsoft SharePoint 2007, SQL Server 2005, Toad, QTP