SUMMARY

• Detailed - oriented professional with 7+ years of IT experience in the Healthcare, technology and Banking domain. Very passionate about analysis and validation of data and decoding the business requirements; translate them into clear and concise test cases. Always ready to learn new skills and knowledge for the development and progress of the self and to the benefit organization.
• Utilized business intelligence tools to include OLAP (Online Analytical processing), data warehousing, reporting, querying tools and excel.
• Experience in Data Analysis and ETL techniques for loading enormous amounts of data.
• Extensive experience using advanced SQL coding in Oracle, Teradata, MS SQL server and MYSQL using TOAD, Teradata SQL Assistant and MS SQL server management studio. Wrote SQL queries in order to retrieve pertinent information from DBMS.
• Identified data issues when reports are created from several and complex data sources.
• Elaborate understanding of various data modelling techniques like Dimensional Modeling, Star Schema, Snow-Flake, Fact and Dimension Table, Physical and Logical Data Modeling.
• Hands on experience in validating data from Flat files,Excel spreadsheets and externalRDBMS.
• Strong ability to write SQL queries to test ETL process and PL SQL.
• Performed pre and post validation of data files using vi editor commands on Unix.
• Possess strong computer and office administration skills with a good knowledge of Microsoft Office Suite (Word, Excel, PowerPoint, Access, and Visio).
• Excellent knowledge and usage of reporting tools such as Crystal report, Business objects and Cognos.
• Great understanding of SDLC methodologies such as Waterfall and Agile (specifically SCRUM).
• Possess a strong ability to adapt and learn new technologies and new business lines rapidly.
• Experienced in actively using QC / ALM for creating test cases / defects
• Excellent team player with demonstrated experience of working diplomatically and collaboratively with all levels of staff to ensure successful implementation of assignments.

TECHNICAL SKILLS

Databases: MS SQL Server 2008/2012, Teradata 12/13, MySQL 5.2, Oracle 10g, 11g, DB2

ETL/Other Tools: Informatica Power Center 9, Abintio, SSIS(Visual Studio 2010 Shell)

Test Tools: HP Quality Center 10 / 11 ALM

Querying Tools: SQL Management Studio 2008/2012, Teradata SQL Assistant, SQL Plus, SQL Developer, Teradata-BTEQ

Business Intelligence Tools: OBIEE, Crystal Reports, Business Object xi3.1

PROFESSIONAL EXPERIENCE

Confidential, EDEN PRAIRIE, MN

Sr. QA Analyst

Responsibilities:

• Prepared the test plan, test strategy and test case documents with the help of BRD, FRS, HLD, LLD and other supporting documents.
• Coordinated in full end-to-end testing processes including planning, testing, and production certification of software applications in a multi-Operating System and network environment, creating test strategy, test plans and test cases for application testing
• Attended walkthrough meetings with the Business Analysts and DEV team to get a clear understanding of the business and the applications being used in house.
• Developed and Designed Test Cases based on the Business Rules and Mapping Documents.
• Validated the source data coming from various databases using complex SQL queries.
• Aggregated the data at source and compared with the Target to validate Transformations.
• Prepared Traceability Matrices to track the requirements with the test cases and make sure none of them have been missed.
• Worked with Microsoft Share point for accessing the documents.
• Logged defects using HP ALM, linked defects with requirements and generated Defect Reports in ALM.
• Monitored the session logs/log files in Informatica Workflow Monitor.
• Tested UNIX Shell Scripts and SQLs to get data from Oracle tables before executing Informatica workflows.
• Worked with other members of the QA and Development teams and managed efforts with offshore team in improving the processes, methods, effectiveness and efficiency.
• Attended daily status call with Offshore to review assigned tasks and solve any impediments.
• Used Oracle SQL developer tools for Querying source Database.
• Create Test scripts by using T-SQL. Programming elements include control-of-flow techniques, local and global variables, functions, and error handling techniques
• Participated in walkthrough and defect report meetings periodically.
• Documented and reported various bugs during the Testing process.
• Written SQL Queries to define identify and validate the code written for the data movement into the database tables, fine-tuned the queries for better performance.
• Retesting the resolved defects/issues after the developers fix the defects.
• Provided the UAT and Production support for End to End Test Script execution and Defect retest.
• Involved in preparing test data/ Test script for UAT and participated in UAT signoff
• Updated the status of the testing to the QA manager, and accomplished tasked for the assigned work to the Project Management team regularly.

Environment: HP ALM, Rally, SQL, SQL Server, Business Object, UNIX, Informatica, Autosys, Microsoft SQL Management Studio 2012, Microsoft Visual Studio 2012

Confidential, Rochester, NY

QA Tester

Responsibilities:

• Developing and maintaining Test Strategy and Test Plans across multi project fast paced environment.
• Providing draft Test Estimates and Test Schedules to the project team.
• Reporting testing status to Project Management and Project Stakeholder resources.
• Responsible for leading a team of testers by providing Business understanding and inputs related to test strategy.
• Design and execute the test cases on the application as per company standards and tracked the defects using HP Quality Center 10
• Involved in entire QA Life Cycle, which includes Designing and Developing and Execution of the entire QA Process and Documentation of Test Plans, Test Cases, Test Procedures and Test Scripts.
• Coordinated with Multiple teams of System Testers, UAT Testers, Developers, Business Analysts, Team Leads, Release Managers and Business Executives to derive quick and quality solutions to achieve short-term and long-term project goals.
• Create Test cases in HP Quality Center to write test cases, analyzed the results, track defects in QC.
• Responsible for different Data mapping activities from Source systems to Teradata.
• Ensuring a high level of quality in all testing deliverables, including conducting QA reviews
• Identifying and reporting project risks logged against Clarity
• Extensively executed T-SQL queries in order to view successful transactions of data and for validating data in Sql Server Database.
• Wrote Complex SQL queries and PL/SQL subprograms to support the test case results, SQL performance tuning.
• Ability to manage change during the test process.
• Communicated with Users, Managers and business analyst along with Team Leader for understanding the business and database flow.
• Performed Teradata SQL Queries, creating Tables, and Views by following Teradata Best Practices.
• Administration of test control and statistics collection (i.e. problem reporting, defect tracking) in Quality center.
• Performed front end web application testing and verified and validated defects using SQL to retrieve data from database.
• Wrote SQL scripts in TOAD for Oracle and Teradata SQL Assistant for Teradata
• Supported onsite/offshore team coordination for all fast paced projects.
• Responsible to ensure successful data load from several sources systems into appropriate targets.
• Responsible to verify SQL’s for the data validation transformations by guiding the team of testers.
• Responsible for the validation of various front end report applications.

Environment: Abinitio, MS SQL Server 2012, PL/SQL, Teradata 13, Teradata SQL Assistant, Oracle Database, Unix, HP Quality Center 10, OBIEE, Toad.

Confidential, NYC, NY

Test Analyst

Responsibilities:

• Understood the cleansing and deduplication process from complex set of documents including the Mapping, FRDs, business rules and mapping document.
• Created and populated patient data using advanced SQL queries and also performed Teradata SQL performance tuning
• Involved in preparing Test Plans and Test cases based on the business requirements Document in the Quality Center.
• Involved in Integration, System, functional, GUI, Regression and User acceptance Testing.
• Involved in writing the test cases based on Requirements, Executing the test cases, Defect Reporting.
• Involved in writing Test Scripts for Manual Testing.
• Opened Defects in Quality Center and tracked the status until defect is closed.
• Performed data quality checking to ensure integrity and consistency of master data.
• Tested reports in the form graphs and charts used to present medical findings
• Maintained consistency of data variables between different systems like SAS formats and RDBMS datasets and flat files.
• Performed Teradata SQL Queries, creating Tables, and Views by following Teradata Best Practices.
• Tested medical claims data to support the company’s predictive modeling tools
• Tested metadata of the application by double checking the Informatica mappings using transformations like Source Qualifier, Aggregator, Expression, Lookup, Router, Filter, Update strategy, Joiner, Normalizer, Union, Store procedure and XML transformations
• Tested routine Clinical Documentation on Electronic Medical Record Software
• Performed numerous data tests to validate the extraction requests involving SQL scripts and UNIX
• Tested drill down analysis reports using SQL server reporting services
• Tested data dictionary for the clinical aberrancy rules
• Tested the final analysis of the Facets claims processing application in order to gather requirements to comply with HIPAA 5010
• Tested HIPAA 4010 and 5010 standards for 837P EDI X12 transactions related to providers, payers, subscribers and other related entities

Environment: Informatica 9.x, Oracle 11g, XML, Toad for Oracle, Quality Center, Business objects XI, UNIX, Teardata 13

Confidential, Knoxville, TN

Test Analyst

Responsibilities:

• Wrote complex SQL queries using advanced SQL concepts like Aggregate functions, Group By on data warehouse to compare the data between source and target
• Performed as and to-be scenarios on ad-hoc reporting by manipulate complex data on MS SQL server.
• Wrote complex SQL queries to retrieve data from disparate tables utilizing Joins, Sub-queries and also used concepts like Explain, Stats, Cast and volatile tables on SQL server
• Analyzed duplicate data or errors in data to provide appropriate inter-departmental communication and monthly reports.
• Tested numerous Permanent tables, Volatile tables and Global Temporary tables
• Wrote standard SQL Queries to perform data validation and created excel summary reports (Pivot tables and Charts)
• Used Quality Center as a Test management and defect tracking tool.
• Involved with metadata testing activity that was carried on to make sure that data warehouse design was scalable and maintainable
• Involved in requirements gathering, source data analysis and identified business rule for data migration and for developing data warehouse/data mart
• Monitored and maintained user container space and suggested improvements in table creation to users who had skewed numbers
• Planned, analyzed and designed Universes using SAP Business Objects as per business needs
• Used UNIX automation scripts to run report scripts during off-peak periods
• Created and maintained view within Teradata for Business Analysts
• Used Crystal report and SAS for reporting at different times per Business Analysts request
• Used and updated data models on CA Erwin Data modeler

Environment: Business Objects, MS SQL Server 2008, SSIS and SSRS, CA Erwin

Confidential, Fremont, CA

QA Tester

Responsibilities:

• Involved in analyzing the existing system process.
• Designed and created Documentation for the proposed system by creating Technical documentation, mapping documents, based on detailed FRDs.
• Tested the feeds from Legacy Technical Specifications to meet the Enhanced System specs.
• Understood the data model represented in logical and physical enterprise data warehouse schemas.
• Tested data loaded to Star schema - Fact Tables (Rebate Utilization, AMP Utilization Table, to the staging tables).
• Analyzed and tested testing all data issues used SQL scripts to get issues resolved.
• Experienced in writing complex SQL queries for testing data in oracle targets.
• Worked on issues with migration from development to testing.
• Used Informatica Workflow Monitor to monitor workflows and review session log.
• Designed, developed and deployed new Data Marts along with modifying existing support additional business requirements
• Performed Regression Testing as and when the Bugs got fixed and check whether the application is free from builds.
• Wrote test plans to in corporate the testing needs of the data warehouse using Test Director.
• Wrote test cases for the data extracts to make sure the vendors are sending the correct data files.
• Maintained Source definitions, Transformation rules and Target definitions.
• Improved Performance for complex jobs by using Transformations Source Qualifier, Aggregator.
• Involved in developing and maintaining Modeling standards, Operation procedures and new development areas.
• Implemented Scheduled jobs in UNIX Environment and EDW scheduler.
• Worked on testing with Complex Mappings by importing Procedures/functions to build business rules to load data.
• As a testing process created Database scripts, Procedures, Database Constraints.
• Designed developed and tested processes for validating and conditioning data and maintained test documents (UAT), System Testing and integration Testing.

Environment: Crystal reports, Informatica Power Center 8.x, HTML, DB2, SQL Server 2005, UNIX, Windows, SQL Enterprise Manager, Query Analyzer Control Center