Data Etl

RAMAN PILLAPPA Work Authorization: US Citizen

Las Vegas NV

469-***-**** (mobile)

adjlwj@r.postjobfree.com

Professional Summary:

** ***** ** ** **********

Software Quality Analyst : 10 years

MS SQL – ETL – Data Warehouse testing: 4 years

Domain Knowledge: Gaming, Banking and Telecom.

Software Quality Analyst (2006 –Till the Date)

Expert in QA Processes, SDLC, delivery of quality software, products, systems and applications to meet business, market and customer needs, utilizing blended onshore/offshore delivery model

MS SQL /ETL Backend testing

Worked on both Agile and waterfall methodologies

Certified Scrum Master in 2016.

Extracted data from various sources like SQL, flat files.

Prepared the Test Plan and Testing Strategies for Data Warehousing Application

Preparation of technical specifications and Source to Target mappings

Tested a number of complex ETL mappings and reusable transformations for daily data loads.

Creating test cases for ETL mappings and design documents for production support

16 Years of QA experience on end to end product Release process.

Strong background in functional and regression testing for enterprise Web and Mobile applications following iterative and agile methodologies

Ability to write detailed test cases, test plans and thoroughly document defects identified

Able to exhibit sound scientific judgment based on reasonable assumptions and available information

Ability to work with Business Analysts, Developers, Project Managers and other Team Members for complex testing projects and in the overall enhancement of software product quality

Experience in working on multiple releases in parallel, able to work well in team environment to achieve results, excellent interpersonal and communication skills, a self-starter who can deliver well as part of a team, ability to work under pressure during tight deadlines.

Knowledge in writing and executing Test Cases, Reporting and Tracking Defects.

Attended EDI-HIPAA training EDI Transactions, EDI-HIPAA Communication Mechanism, EDI-HIPAA Translators

Conversant with all phases of Project Life Cycle including Requirement gathering, Analysis, Design, Development, Implementation, Testing, Software quality standards and Configuration management.

Well versed with various test strategies like Unit, Functional, Integration, System, Regression Testing

Working Knowledge in Automation using Tools such as: UFT and Test Complete.

Excellent skills in overall Defect Management / Problem Solving including tracking bugs, reporting using Test Director and Quality Centre.

Involved in UAT testing with business & Product team.

TFS, JIRA, ALM- Quality Center, Rally Software, Octane, API test with Postman and VM Ware.

Knowledge on Clear Case, MS Visual SourceSafe, MS VISIO, Remedy, HPSD Change control, and gaming products like ACSC, LMS, CRM and Patron Management.

Knowledge in testing APIs using Postman, Web Applications, GUI Objects, Functionality and System testing including Integration, Backend and Regression Testing of Client/Server and web-based applications

Technical Proficiencies:-

Technology

Tools

Databases

SQL Server 2008,2012,2014,

Development Tools

SQL Enterprise Manager, SQL Query Analyzer, ETL, SSIS, SQL Profiler, SQL Server Integration Services, Performance tools.

Functional Areas

GAMING, TELECOM,FINANCE,INSURANCE

Automation Tools

Java Script, Test Complete, UFT

Software Engineering Methodologies/Tools/Technologies/Products

Clear Case, MS Visual SourceSafe, EDI-HIPAA, MS VISIO, Remedy, and HPSD Change control, Micros Opera ACSC, LMS, CRM and Patron Management.

Platforms

Windows 9x/NT/2000/XP/Windows 8/9/10

Testing Tools

ALM – Quality Center, Rally Software, Octane, Postman tool for API test, TFS, JIRA,

Client Profile:-

Organization: Sands Corp, Las Vegas, NV (from Jan 22nd, 2018 – Till the Date)

Designation: Software Quality Analyst (QA)

Organization: Boyd Gaming, Las Vegas, NV (from June 2017 – Contract ended by January 19th, 2018)

Designation: Software Quality Analyst (QA)

Organization: MGM International, Las Vegas, NV (from April 11th 2017 – Contract ended by June 9th, 2018)

Designation: Software Quality Analyst (QA)

Organization: International Game Technology, Las Vegas, NV (from May 2010 – Mar 2017.)

Designation: Software Quality Analyst (QA)

Organization: Capital One Finance, McLean, VA (from June 2009- Apr 2010)

Designation: MS SQL – ETL data testing

Organization: International Game Technology, Las Vegas, NV (from Jun 2008 – April 2009).

Designation: MS SQL – ETL data testing

Organization: Verizon Telecom, Richardson, TX (from Sep 2006 – June 2008.)

Designation: MS SQL – ETL data testing

Organization: Capital One Auto Finance, Dallas, TX (from Jan 2006 - Sep 2006.)

Designation: MS SQL – ETL data testing

Work Profile: -

Sands Corp Las Vegas, NV 2017 – Till the Date

Senior Quality Analyst

Sands Corporation is a global Casino Resort specializing in Hospitality, Gaming and Entertainment. Worked on ACSC, LMS, CRM (MS 365 - customer Relation Management), POS (Point of Sales), Loyalty Web Application and many internal projects related to Data Warehousing.

Here I worked on LMS, ACSC, CRM, POS - Micros Opera (Oracle Symphony), and many other projects Like MDM – master data management with Data Cleansing validations.

IView Project ( patron can see his player card balances - available points, comps and details from the slot machine based on the configuration in ACSC system) based on Configuration on tier levels.

Tested some other third party tools, PlayerSoft, (new wave - Evari), IDRetrival. Worked on HotSos, FourWinds, EBMS – Event Based Management System

Also Worked on Venetian Loyalty Web site –

Extracted data from various sources like SQL, flat files.

Prepared the Test Plan and Testing Strategies for Data Warehousing Application

Preparation of technical specifications and Source to Target mappings

Tested a number of complex ETL mappings and reusable transformations for daily data loads

REST APIs – tested with Postman tool. The front end was not ready so we tested the APIs using this tool.

Responsible for preparing the Test Plans for Application and executed Test Plans, test cases based on SRS documents and verified expected and actual results

Worked on Agile – Scrum methodology.

Conduct Functionality test and UAT with Product Test Group and report to Release Management

Interacted with developers to analyze the Business Requirements and functional specifications.

Prepared test data for the Enter and Exit criteria in Integration testing

Execution of Client/Server and web-based applications including Functional, Regression, System Integration testing.

Involved in writing SQL queries for Data Validations.

Involved in backend testing (Data Validation Testing) by writing SQL queries.

Executing, Maintaining Test Scripts and Updating as and when the business rules change.

Provided support for any product related questions from GLI/BMM.

International Game Technology (IGT), NV

Enterprise Gaming System - Advantage Casino System May 2010 – Mar 2017

Senior Quality Analyst

International Game Technology (IGT) is a global gaming company specializing in the design, manufacture, and marketing of electronic gaming equipment and systems products. Worked on Patron Management, Intelligence bonusing, Gift Points and third-party applications LMS, InfoGenesis through ADI.

Responsible for preparing the Test Plans for Application and executed Test Plans, test cases based on SRS documents and verified expected and actual results

Conduct Functionality test, Performance test and UAT with Product Test Group and report to Release Management

REST APIs – tested with Postman tool. The front end was not ready so we tested the APIs using this tool.

End to end cross functional experience on Patron Management with Third-party Systems through ADI.

Interacted with developers to analyze the Business Requirements and functional specifications.

Prepared test data for the Enter and Exit criteria in Integration testing

Execution of Client/Server and web-based applications including Functional, Regression, System Integration testing.

Involved in writing SQL queries.

Involved in backend testing (Data Validation Testing) by writing SQL queries.

Executing, Maintaining Test Scripts and Updating as and when the business rules change.

Provided support for any product related questions from GLI/BMM.

Capital One Bank

McLean, VA (Capital One Corporate office) From Aug 2009 – May 2010

Senior Quality Analyst – ETL Back End Testing

Developed complex SQL queries for querying data against different data bases for data verification process.

Prepared the Test Plan and Testing Strategies for Data Warehousing Application

Developed ETL test scripts based on technical specifications/Data design documents and Source to Target mappings.

Extensively interacted with developers, business& management teams to understand the project business requirements and ETL design document specifications.

Extensively used and developed SQL scripts/queries in backend testing of Databases.

Prepared daily status reports with details of executed, passed, and failed test cases and defect status.

Tested a number of complex ETL mappings and reusable transformations for daily data loads.

Creating test cases for ETL mappings and design documents for production support

Setting up, monitoring and using Job Control System in Development/QA/Prod

Extensively worked with flat files and excel sheet data sources. Wrote scripts to test the flat files data in the databases,

Scheduling and automating jobs to be run in a batch process

Effectively communicate testing activities and findings in oral and written formats

Extracted data from various sources like SQL, flat files.

Worked on issues with migration of Data from development to QA-Test Environment

Extensively tested several SSRS Reports and Dashboards to validate the reports the data and cosmetics of the report.

Responsible for preparing the Test Plans for Application and executed Test Plans, test cases based on SRS documents and verified expected and actual results

Worked on Agile – Scrum methodology.

Conduct Functionality test and UAT with Product Test Group and report to Release Management

International Game Technology Las Vegas

Senior Quality Analyst – ETL Back End Testing June 08 – July 09.

Data Migration Project SQL Server 2000 to SQL Server 2005

International Game Technology (IGT) is a global gaming company specializing in the design, manufacture, and marketing of electronic gaming equipment and systems products

Project: IGT Migrated the Mariposa application from SQL Server 2005 to SQL Server 2008.

Worked closely with Business user in Understanding designing and documenting the Functional testing plan and then Writing, executing, documenting the results and Logging Written ETL test specifications including test source data preparation, writing test cases to test Data Completeness, Data Transformations, Data quality, Performance and scalability, Data aggregations− match aggregated data against staging tables and/or ODS, and Granularity of data is as per specifications

Created detail Test cases for each test phase to ensure complete coverage. Test Cases were incorporated both positive and negative test conditions.

Maintained Traceability Matrix to track the requirements to the test cases to ensure complete test coverage.

Involved in designing and Preparing Test Scenarios, Test Plans, Test Cases and Test Data.

Worked with IT Development team to ensure feasibility of design and clarify user requirements.

Developed SQL Queries/Scripts and similar Artifacts to validate the Completeness, Integrity and Accuracy of Data within an ETL process testing cycle.

Performed Data Analysis and developed Data Mapping documents for ETL (SSIS) projects.

Developed Test Cases and SQL Queries to perform various Validations.

Performed Count Validation, Source Isolation, Dimensional Analysis, Statistical Analysis and Data Quality Validation in Data Migration.

Performed Unit Testing, Integration Testing, User Acceptance Testing and Requirement Testing.

Executed Test Cases with respect to Source and Target database tables.

Written SQL queries to validate reports against the database.

Extensive SQL querying on Staging, Data warehouse and Data Marts.

Used Agile Test Methods to provide rapid feedback to the developers significantly helping them uncover important risks.

Validated reports based on Functional Requirements.

Verizon, Richardson, TX

Senior Quality Analyst – ETL Back End Testing Sep 06 – June 08

The Executive Dashboard Portal project is an Intranet site for Verizon executives. The dashboard provides key metrics on how the organization is performing across the following business segments: Finance, Sales, Operations, Customer experience, Information Technology and Human Resource.

The Verizon Executive Dashboard reporting tool provides organized and valuable information to Verizon Executives in order to support business decisions, Transparency of information, Slicing and dicing information. Dashboard connects to different data sources in order to centralize Verizon business as well as Verizon Partner Solutions (VPS) information. Dashboard data feed is automated allowing to display real time, daily, weekly and monthly information, depending on the nature of metrics

Develop test plans based on test strategy. Created and executed test cases based on test strategy and test plans based on ETL mapping document

Written complex SQL queries for querying data against different data bases for data verification process

Designed the data flow diagrams using VISIO

Prepared the Test Plan and Testing Strategies for Data Warehousing Application

Preparation of technical specifications and Source to Target mappings

Extensively used SQL programming in backend and front-end functions, procedures, packages to implement business rules and security

Written test cases to test the application manually in Quality Center

Defects identified in testing environment where communicated to the developers using defect tracking tool Mercury Test Director

Developed scripts, utilities, simulators, data sets and other programmatic test tools as required executing test plans

Tested a number of complex ETL mappings, mapplets and reusable transformations for daily data loads

Creating test cases for ETL mappings and design documents for production support

Setting up, monitoring and using Job Control System in Development/QA/Prod

Extensively worked with flat files and excel sheet data sources. Wrote scripts to convert excel to flat files

Scheduling and automating jobs to be run in a batch process

Effectively communicate testing activities and findings in oral and written formats

Worked with ETL group for understating mappings for dimensions and facts

Extracted data from various sources like Oracle, flat files and SQL Server

Worked on issues with migration from development to testing

Organization: Capital One Auto Finance, Dallas, TX (from Jan 2006 - Sep 2006.)

Designation: MS SQL – ETL data testing

Involved many internal databases related projects.

Educational Qualification: Bachelor of engineering from Bangalore University, India

Contact this candidate