Qa Analyst Etl Tester

SAGAR KANKONKAR

Email: *****.*********@*****.*** Cell:408-***-****

Software Quality Assurance professional with over 10 years of experience and expertise in Data warehouse/ETL and BI, middleware and application (Web/mobile, etc.) testing on enterprise multi-tier on-prem and cloud environments. Excellent communication skills and leadership qualities. Excellent understanding of the Software and Testing Development Life Cycle (SDLC/TDLC). Uniquely skilled in ability to identify design gaps, understand complex code and assist with troubleshooting and solutioning with the Business goal in mind. SKILLS:

Tools/Products : Sql Server (SSIS, SSRS, SSAS), Azure Suite (Devops, ADF, Synapse, DataLake), Apache Kafka, Databricks, Power BI, SAP BO, XLCubed, Visual Studio, Informatica, JIRA, Confluence, SAP Data Services, XRAY, HP Quality Center/ALM, Tableau, Aginity Workbench, Benthic Golden, Putty, vi, SharePoint, SoapUI, Postman, Amdocs Ensemble Billing, Seibel CRM, SQL Developer, Selenium Web Driver, JMeter

Languages : SQL, T-SQL, PL/SQL, Python, Shell scripting, Java, .NET, C++, SOAP, C#, Perl, XML, DHTML (CSS, JavaScript)

Database Systems : SQL Server, Oracle, Netezza, MySQL, MS Access Operating Systems : UNIX (HP-UX, Sun Solaris), Windows Methodologies : Waterfall, Agile/Scrum

EXPERIENCE:

Sr. ETL QA Engineer (Jan 2023 – Present)

World Wide Technology (Client – Edward Jones)

• Part of Operational Data Store (ODS) testing team to test data ingested to Azure SQL MI investor/investment data from various cloud applications (Salesforce, Moneyguide, etc).

• Verify ETL pipelines ingesting large datasets in JSON format into Azure SQL MI database using Informatica (IDMC) taskflows and ongoing transactional data from Salesforce via Kafka/IDMC.

• Performed Data Completeness, Data accuracy, transformation logic, functional testing by referring to Source documentation, data models, data mapping and technical documentation.

• Performance testing of large Holdings data files ingestion (~600 million records) into SQL MI.

• Test data reconciliation process between the new and legacy investment applications and the ODS

(SQL MI) platform using Databricks

• Verify Power BI dashboards for reconciliation metrics.

• Create Test Plan, Test cases and maintain Test Execution, Defect reporting in qTest. ETL/Datawarehouse QA Engineer (Dec 2021 – Sep 2022) PulteGroup, Inc

• Sole QA resource for the ODS project to migrate on prem SQL Server Datawarehouse to Azure.

• Prepared overall Test Plan, Test Cases and Test Strategy documentation.

• Created Test Plan and Test cases for testing various Data warehouse (ETL) projects, bug fixes and enhancements.

• Performed data Completeness, data accuracy, Source to target validation involving complex SQL queries, data validation, integration, system, volume, functional and end to end testing.

• Validated ETL(Azure Data Factory, SSIS) pipelines, wrote Python (PySpark) and Spark SQL scripts to validate ADLS(data lake) data

• Developed ETL test scripts based on requirements, technical specs and data mapping documents.

• Developed complex SQL scripts to extract and setup test data in source systems.

• Verify Power BI reports and cubes (XLCubed) for Financial Planning and Analysis team.

• Verify reports based on specs, prompts, drill down pages and performance.

• Defined and implemented defect management process (defined defect lifecycle, standard practices, etc.)

• Tested ODS components using Azure data factory, Azure Synapse and Azure SQL database.

• Developed reporting queries and dashboards in DevOps for test execution, defect summary and defect reporting.

Sr. EDW QA Analyst (Feb 2018 – Dec 2021)

Arby’s/Inspire Brands

• Sole QA member of the Enterprise Data Warehouse team for Arby’s.

• Led QA for Inspire Polaris project for Buffalo Wild Wings Media Mix Optimization project.

(Azure data lake, Talend, ADF, Delta Lake tables, Snowflake, Databricks, Airflow)

• Created Test Plan, Test cases, Test scripts and Weekly Project reports.

• Performed Data Completeness, Data accuracy, transformation logic, functional testing by referring to Source documentation, data models, data mapping and technical documentation.

• Performed thorough Source to target validation by writing complex SQL queries.

• Validated ETL pipelines, wrote Python (PySpark) and Spark SQL scripts to validate ADLS(data lake) data.

• Assist Dev and DA teams with analysis, suggest fixes and design improvements.

• Perform regression testing for PAR Brink (POS) releases in EDW (on premise SQL Server)

• Tested various projects for Arby’s, Sonic and BWW – FreeFood calculation, Aloha to Brink migration, Franchisee migration, Audit Fact, Kitchen Bump, Learning Management System, Legacy POS EDW Integration, Comp Sales, Oracle EBS to Cloud migration, Sales System, etc.

• Created stored procedures in SQL Server to standardize regression test cases

• Performed testing of ETL process and Type1 and type 2 slowly changing dimensions

• Validated EDW data/views against various reports in source systems like PAR Brink portal, Cornerstone portal to validate data accuracy.

• Created documentation for ETL process for various projects for handover to offshore teams.

• Tested Mulesoft API projects – tested System, Process and Experience layer APIs, setup data, automated in Soap UI and created automation suite. Data warehouse QA Analyst (March 2017 – Dec 2017)

Intercontinental Exchange, Atlanta, GA

• Part of a small team of Data warehousing QA to test various SAP BO reports and ETL processes. Day to day activities included reviewing Business Requirement Documents, Design Documents, developing Test Plan and Test scripts, Test Execution and Defect management.

• Extensively used SQL developer for Oracle and Aginity workbench for Netezza to validate data against source systems.

• Maintain test artifacts and bugs in JIRA. Introduced a “Handover QA document” for Business team with details like environment, BO report location, data to be used, high level test cases and any known issues and observations.

• Write complex SQL queries to perform data level (count validation, null checks, duplicate check, data type validation) and functional testing within the data warehouse. Perform Source to target validations based on BRD and Design documents

• Validate newly requested exception BO reports, production fixes of existing reports and troubleshoot data quality issues.

• Testing of mandatory and optional prompts, mandatory columns, data types. Tested scheduled reports.

• Perform testing of BO reports to verify reports produce accurate results upon execution of different prompt values and filters, exporting of data, etc.

• Testing of dev generated flat files for ad hoc Business data requests by using Unix shell scripts

• Perform regression testing of reports for successive SAP BO releases.

• Automate validation within ICE DQ, inspect failures and report defects for the source systems for version upgrades.

• Created JIRA tickets for updating BRDs and Design documents to ensure accurate documentation. Systems Analyst – ITTStar (Feb 2016 – Feb 2017)

Client – T-Mobile, Atlanta, GA

• Prepare Offers Requirements Document and conduct review meetings with all Business, downstream application System Analysts, development and testing teams

• Validate all Price Plan changes in staging and day of deployment via SQL scripts against oracle database

• Design, overview and approve Test plans and assist with testing, defect triaging and resolution. Assist with UAT testing efforts.

• Troubleshoot data discrepancies, perform data analysis to identify subscriber impacts and cross verify scripts developed by operational teams applying discounts or adjustments for ongoing offers

• Developed complex SQL scripts/queries in backend testing of Oracle Databases

• Performed Count Validation, Statistical Analysis and Data Quality Validation in Data Migration

• Verify reports against databases by constructing SQL queries and work with Business on reporting requirements (Source systems like Billing, SalesForce, etc).

• Maintained Test Plans, Execution and defects in HP Quality Center (ALM). Generated daily defect reports based on criticality and severity

QA Analyst – July 2013- Jan 2016

Charter Global (July 2013 – June 2015), Insight Global (June 2015 – Jan 2016) Client - Landis+Gyr, Alpharetta, GA

• Quality Assurance Analyst for various projects for migration and upgrade of the Energy metering software for various utilities (Electric, Water & Gas) across North America.

• Create Test Plan, test cases & Test Data needs. Maintain and update regression test suites.

• Sole QA resource from North America team to test the new consolidated tool for handheld tablets being built for field technicians to troubleshoot the 1 and 2 way electric and gas meters over RF. Part of the core team to perform gap analysis and refine requirements.

• Execute and oversee Test Design, Execution and Defect resolution between offshore and onshore Software QA (SQA) team members.

• Perform regression testing after each upgrade to ensure that data is received, calculated, stored and reported per customized customer needs.

• Utilize Source to Target mapping documents to verify ETL processes to load date into Data Warehouse.

• Verify different Business Reports to validate accurate reporting of Customer and usage patterns.

• Perform extensive testing of existing processes in Unix environment. Update shell scripts for scenario simulation; batch processing of fixed length and csv files, verify log files to troubleshoot and fix issues

• Maintain test cases and defects in Microsoft TFS (Team Foundation Server) and Test Manager.

• Effectively communicate testing status to higher management with Project health, risks, mitigation plan and present improvement strategies.

Sr. QA Analyst – Jan 2011 – July 2013

Paradigm Infotech, Inc (Jan 2011 – May 2012) Charter Global (May 2012- July 2013) Client – T-Mobile, USA

• Led several projects for GoSmartMobile(Web), MyTmobile.com, Order Management (SAP), Prepaid and Customer Hub (Siebel CRM) Application at T-Mobile.

• Perform backend (SQL, ETL validations) testing of data load into Oracle (Siebel) from different source systems, Web services testing (Soap UI), Shakeout, Functional, Regression, End to End

(Integration) and Night of Deployment testing.

• Develop Test plans, prepare QA Testing Environment and test data requirements and/or setup based on the applications and testing needs, create estimates for testing resources and timelines.

• Manage defects in Quality Center, generate daily execution summary reports.

• Co-ordinate between the test teams, internal development and third party vendors for data

/environment setup, set test expectations and resolve issues by scheduling lifeline meetings.

• Train, oversee and coordinate testing efforts between several offshore test resources.

• Develop SQL queries for testing ETL initial data load in CHUB. Verify one time and delta loads. Verify against STL mapping documents, and perform various validations for data cleansing, data de-duplicating, etc. against various source systems.

• Testing of provisioning, mediations, billing, MW calls through ESOA/TIBCO, analyze logs., prepare Unix files for mediation testing

• Verify BI reports against Teradata for production issues in reporting.

• Perform validations in production on day of deployment. Create Deployment report with Root Cause Analysis and ‘Lessons learnt’ and Exit Report QA Analyst – Paradigm Infotech, Inc (April 2008 – Dec 2010) Client - Amdocs

• Production testing support at Amdocs for testing all hot production defect fixes on a weekly basis.

• QA lead for Samson billing for Family Mobile project,plan sold at 2500 Walmart stores.

• Analyze Change forms, develop testing level-of-effort, create Test Plans and detailed Test cases

• Create/set up or identify specific data from production for testing. Develop complex SQL queries to identify and extract test data from production

• Ran Unix jobs and create/update shell scripts to edit and process usage and billing.

• Develop and execute Test cases in Quality Center using Business Process testing approach

• Support and guide Business and UAT testing by setting up data for usage/billing testing.

• Tested same day critical production break fixes by developing testing strategy, arranging for test environments, setting up data, testing and sending out the results for approval by various stakeholders

• Part of a small testing team of 4 to test migration of Suncom Wireless to T-Mobile. EDUCATION:

Bachelor of Engineering (1999)

Mechanical Engineering, Mumbai University

Master of Science (2003)

Computer Sciences, California State University (Completed all coursework, GPA 3.3) WORK AUTHORIZATION:

U.S. Citizen

Contact this candidate