Etl Qa Analyst Resume
SUMMARY:
- Expert in Java, Selenium, Cucumber, TestNG with AGILE process/DevOps.
- QA Lead/Analyst Onsite (USA), Offshore with AGILE methodologies for Java, SAP, DW/ETL, SOA, ETL & Mobile Apps.
- SOA Test9.4 / SoapUI5.0 used for WebUI, REST & Web services automation & Spring, Hibernate.
- Automated HMA UI application using Java/Selenium/Cucumber.
- Trained Java/Selenium/Cucumber interns (12) & QA’s.
- Built Automation framework with offshore & interns.
- Expert in Setup QA standards and practices like Strategy, Plans, Procedures, Approaches.
- Expert in QA Design (writing test Strategy & test plans).
- Expert in QA Development (identify scenarios, write conditions, create test cases & scripts, Trace ability matrix).
- Expert in QA Execution, Defect tracking and issue resolution.
- Expert in Data setup for QA environment for Gui/UI, backend, web services and ETL process.
- Expert in Functional, Regression, System, Integration, Smoke, black box, Backend, UAT, Penetration testing (pentest).
- Expert in GUI/UI testing, Database testing and WEB/API’s testing.
- Expert in ETL QA Process testing (source to staging to data warehouse and data marts).
- Expert in SAP R/3 development and QA, Data validations for LSMW, FI, SD, MM, HR (PA, PD, Time, Benefits, Payroll).
- Expert in Web/API Services testing using SoupUI for SOAP, HTTP protocols.
- Expert in Mobility testing for Apple IOS(iPhone/iPAD), and Android platforms.
- Expert in Java Junits for Unit, White Box and Regression testing and Automation.
- Expert in XML validations, XML Schemas, DTD, XSL, XSLT, Xpath, Xquery, XML Spy.
- Expert in Writing Shell script and java Script.
- Expert in Azure cloud testing and operational production support.
- Expert in PL/SQL development (SQL Loader/Data Loader, Procedures, Functions, Classes) data conversion.
- Expert in Data Extraction & Reporting, Data Conversion & Loading using SQL loader, Excel, VB macros.
- Expert in Data Extraction from SQLITE database for mobility Apps.
- Expert in Java, SAP R/3, Data warehouse, ETL, Mobility, Client Server, Distributed, WEB & Internet Applications.
- Experience in end to end automation using Java, Selenium WebDriver, TestNG, Maven, Cucumber, Jenkins
- Experience in design and framework, elements & xpaths, cucumber scripts, selenium steps & POM, Jenkin jobs
- Experience in CI, CD, devOps, BDD and Agile
TECHNICAL SKILLS:
Mobile devices: iPhone, iPad, Galaxy, HTC
Software/OS: Solaris, UNIX, Win, Apple IOS, Android
Languages: Java, C++/C, Shell, JavaScript, HTML, XML, WebStorm8.0, AngularJS, Jasmine, Cordova, Cloud
Database: Oracle (Pl/Sql), SQL Server, PDW, SQLITE for mobility Apps, DataStage/Teradata
App. Servers: IBM WebSphere, Eclipse, Jboss and SAP R/3, TWS scheduler
Tools: Java, Selenium, Cucumber, TestNG, Junit, CVS, PVCS, Toad, SQL Navigator, cloud, SOA/SoapUI
Others: Quality Center, ClearQuest, QTP, SSAS, SSIS, BugZilla, SPLUNK, Jenkins, TFS, ALM
PROFESSIONAL EXPERIENCE:
Confidential
ETL QA Analyst
Responsibilities:
- Validated multiple sources of data loadings to target using complex Sqls/Teradata.
- Validated daily extracts to process claims to ACC/QME/VBC engines using Sqls/Unix.
- Analyzed processed claims to identify gaps, elements and audit data.
- Validated member, provider, Rx/Lab claims, Lab data.
- Developed analytics reports on various metrics (members, providers, claims and gaps).
- Worked on data sentinel automation to validate source data and format.
- Involved in daily scrums, refinement sessions, sprint planning, demos On call support.
- Used Ralley tool to track the sprint progress, user stories, tasks and backlogs.
Environment: SQL Server/DataStage, Teradata, Unix and TWS, Ralley tool
Confidential
ETL QA Analyst
Responsibilities:
- Automated HMA UI application using Java/Selenium/Cucumber.
- Trained Java/Selenium/Cucumber to interns (12) & QA(6).
- Built Automation framework with offshore & interns.
- Worked on production issues in azure cloud application.
- Worked on oncall/operational support in production environment.
- Involved in framework design and development.
- Automated test suites using Selenium TestNg Framework.
- Implemented Page Object Model(POM) for Web UI elements and Page methods to helps code more readable, maintainable, and reusable.
- Identified web elements and its Xpaths. developed XPATH expression for identifying dynamic objects.
- Created cucumber scripts (scenarios & steps) for tests scenarios.
- Created Page object classes for Web UI elements and Page methods.
- Created Step definition files to link the cucumber script steps.
- Created multiple Suites and Runners to run tests/suite fast.
- Selenium integration with Jenkins (services/Node/slave). configured Jenkins job for Running Build.
- Executed Selenium build using Jenkins.
- Created Schedule build in Jenkins for periodic execution.
Environment: SQL Server, PDW, SSIS, Eclipse, Java, Selenium, Cucumber, TestNG, Junit, Azure cloud
Confidential
ETL QA Analyst
Responsibilities:
- Automated HMA UI application using Java/Selenium/Cucumber.
- Trained Java/Selenium/Cucumber to interns (12) & QA(6).
- Built Automation frame work with offshore & interns.
- Built Regression suite for 2 scrum teams.
- Prepared In sprint automation framework for scrum teams(10).
- Validated Load/Data in Stage and DW environment after loading data for all sources.
- Validated FACT and DIM tables for lower and upper environments.
- Validated ETL Transformations from source to stage and DW environments.
- Verified Datasets build for test, stage and prod environments.
- Verified Datasets migration from PDW to SQL.
- Validated Metadata using Custom Automation tool for env to env(110 tables) .
- Developed Custom Automation tool using Java, Junits, Eclipse, Sql & shell program.
- Validated UI Measures and Attributes using XML extractable.
- Participated in process improvement and regression strategy.
- Discuss and outlined functional scenarios with QA/BA teams.
- Prepared SIT and Regression Test plan in ALM and Rally.
- Prepared prod checkout plan for Quarterly release, service release, hot & break fixes.
- Assigned and monitored QA tasks for Tornado scrum team.
- Coordinated in QA Automation, and process improvement.
- Monitored defects in ALM for Functional, Regression, and SIT.
- Created functional test plans in Rally as a part of agile methodology.
- Participated on production support and operations oncall support.
- Participated in daily scrums, issues resolutions with SME, BA's & dev team.
Environment: SQL Server, PDW, SSIS, Eclipse, Java, Selenium, Cucumber, TestNG, Junit, Azure cloud
Confidential
ETL Lead/Automation QA
Responsibilities:
- Prepared Test approach for ETL which sync to Dev process.
- Identified scenarios, Test cases and prepared SQL Scripts.
- Automated UAT environment validation with PROD data refresh.
- Automated Test execution from Staging to Integration and Integration to LDM.
- Prepared test artifacts for QA status to management.
- Offshore QA team co - ordination.
Environment: Informatica, Oracle 11g, SQL, TOAD, ALM, Eclipse, Junit
Confidential
Automation QA
Responsibilities:
- Requirement gathering and/or converting from LINQ2 legacy system.
- Monitoring and updating change requirements.
- Manually Verified Functionality.
- Created Automated Regression (Functional) suite to Run daily.
- Manually Verified Local Language testing for EN, ES, DE, FR, IT.
- Created Automated Regression suite for Local Language testing to Run daily.
- Unit testing Linq2 Libraries (Automation).
- AngularJS(Javascript) functionality testing using Jasmine/WebStorm.
- Verified verity of reports.
Environment: Team Foundation Server (TFS), ALM, Eclipse, NetBeans8.0, WebStorm8.0, AngularJS, Jasmine, Cordova, Azure Cloud, Android, Heart device, Linq Monitor & Telemetry devices, Tablets
Confidential
Sr.QA
Responsibilities:
- Smoke testing weekly twice after deployment (UI/Rest, Web services, Loads/Batch).
- Functional, DB, XML/schema testing and Run Regression (Automation UI & Web services).
- Penetration testing (pentest) to find security weaknesses & gain access to systems & applications
- Documentation for Issues and defects opened.
- Daily standup/Scrum, Sprint planning and Rally tasks monitoring(scrum master)
- Helping Performance team for issues resolution.
- BRS review, BRS approval and Project/Task estimation.
Environment: Web UI/Rest, Web Services, Oracle, SQL, XML/Schema, Spring, Hibernate, SOA Test9.4 / SoapUI5.0, Splunk, Jenkins, CMW, QC
Confidential
QA lead/Dev
Responsibilities:
- Making Project road map, Resource planning, task allocation and tracking.
- BRS review, BRS approval and Project/Task estimation.
- Defect reviews, meetings, tracking, and issues resolution with across teams.
- Conducting Scrums, sprint/iteration planning and monitoring in AGILE environment.
- Set up QA standards, writing Strategy, Test design, Test plan and Test development.
- Designed QA standards and Test strategy and Test plan.
- Created Automated Test suite for M&G project for 14 Databases using Java/JUNITS.
Environment: Java/Junits, SQL/PLSQL, Oracle, Informatica, actuate, and XML, SOA Test9.4 / SoapUI5.0, Splunk Tool, QC
Confidential
Web Services, SQLite & UI QA lead
Responsibilities:
- Designed QA standards and Test strategy and Test plan.
- UI Functional testing, backend database testing, Regression testing, Performance testing co-operation.
- ETL testing includes full file and incremental delta file loading testing.
- API calls / Web Services testing, request response xml validations.
Environment: Apple IOS, Android, SQLite DB, SQL Server, SSIS, SSAS, ETL Process, WEB Services, QC,SoupUI Tool, XML
Confidential
PortalUI & SOA QA lead
Responsibilities:
- Designed UI, Function, Integration and E2E test cases for SOA in zephyr tool and UAT co-ordination.
- Designed and created E2E test scenarios along with test data preparation.
- Designed 8 SoapUI projects to test different web services under SOA.
- Debugging and Capturing WEB services data using custom designed debug tool for Request and Responses.
- Deployment validations or smoke test in different environments (Dev Test, Prod Test, Prod Like, Prod).
- Involved in cross applications (TUB, AS, TAS, CAP, OCIS, CIM, CA, STH, ReSA, EDW, AP, GL) interactions.
- Tracking and testing POS transactions.
- Test status reporting for all environments and defects reporting using BugZilla.
- Mentoring and assigning tasks to Off-Site QA’s
Environment: Java, .Net, Unix, SQL Server, Oracle, PHP Scripts, WEB Services, SOA/SoupUI, XML
Confidential
Datawarehouse ETL
Responsibilities:
- Designed high level test strategy for ETL testing
- Designed test plans for to staging & to datawarehouse
- Developed Java based ETL tools to process source files ( Xml, Mainframe IMS & DB2, flat files, oracle )
- Created Acceptance Tests and Tasks corresponding Business story/tech story/dev tasks in every Iteration
- Collected test reviews and feed back to discuss in every day scum meetings
- Developed Java based tools for counts and contents validation
- Designed test plan for Informatica Mappings, WorkFlows testing
- Designed test plan for Informatica B2B Transformation testing
- Involved in Informatica Mappings and WorkFlows testing ( to staging & to DW )
- Involved in Informatica B2B transformations, Parsers testing (to staging & to DW)
- Involved in data mappings XML to DB testing
- Created test data for 30 verity of contents and 14 verticles
- Created Regression suite after System and functional testing
- Defect tracking and issues resolution with dev team
- Participating in daily scrum to update defects status
- Automated to staging regression suite, using junits
- Automation to datawarehouse regression suite
Environment: Informatica, B2B workbench, Java, Oracle, Berkeley DB, IMS Mainframe, WEB Sphere, PVC Tracker
Confidential
SAP HR, Portal(ESS/MSS
Responsibilities:
- Read and understood legacy Pension system & gave high level design
- Designed data base schema & SAP transparent tables
- Designed and developed Custom Infotypes
- Designed Pension calculation engine & written technical specs
- Designed Pension disbursement, Payment modules & written technical specs
- Written functional / technical specs for interfaces & reports (18 + 40)
- Written technical specs for PA, Ben, Pay modules.
- Mentored & lead offshore IBM technical team.
- Portal Content/iview configuration & SAP R/3 integration.
- Configured iviews for personal & benefit info types.
- Customized desktop & branding for users.
- Portal development using visual composer & WebDynpro.
- Designed over all Test Strategy, Test plans.
- Identified test cases and test scenarios.
- Prepared tractability and Run risk analysis with BA’s and functional people
- Created Test data in Sand box, managed defects and reported to management.
- SAP FICO data conversions, interfaces programs and reports.
Environment: SAP ECC 6, QTP, ClearQuest, Quality center & Oracle
Confidential
QA Lead
Responsibilities:
- QA offshore resource planning, assigning tasks, monitoring & mentoring.
- Identifying & logging issues, tracking, resolving & reporting to management.
- Participated & Conduct status meetings with upstream applications.
- Created Test Strategy and Test Plans for cross over applications
- Created and implemented Test Procedure for multiple applications
- Designed and created test conditions
- Created Test Cases in Test Director
- Conducted Peer & IT/Business walkthroughs
- Created RTM, did Risk analysis & prioritized test cases
- Created test data & transferred over cross applications
- System, Regression, Integration, Performance & UAT Test Phases
- Mocked up test data for all phases of testing
- Back end Data validations and verifications.
- DB load rules, DS Framework configuration, AutoSys jobs and Shell scripts
- Load Medical and financial Claim Files, Summary Check Application Interface,
- SCICOM Application Interface, HSE Reporting UI, TOPS Application Interface,
- Scheduling UI Component (Release & Aggregate file creation), HSE UI Component, HS Document UI Component,
- Duncan Application Interface, EDSS Application Interface, & MyUHC Application Interface.
- HSE Adoption UI Component, ACIS - HSE Application Integration, CAMS - HSE CAP Application Integration,
- HSE - Duncan Application Interface & Duncan - EDSS Application Interface
Environment: Java, Ascential Data stage, Oracle, SQL server, WEB Sphere, AutoSys, ClearQuest and TestDirector
Confidential, MN
SAP FSCD QA Lead
Responsibilities:
- Attended Design meetings and REQ walk through’, Requirements review from REQPRO, Identified Test scope for entire EBI and SAP FSCD
- Written Test Strategy for EBI and SAP FSCD, Written test plans for SAP FSCD Integration, System & End to End, Identified Testing Phases, Test Environment and Test Types
- Prepared Requirement Traceability Matrix RTM, Run Risk analysis and prioritized test cases, Identified Test Scenarios & Conditions
- Designed and Prepared Test cases, Designed and prepared Test artifacts to report management.
- Created test data, Created and Reported Test results for all builds, Used Rational Test manager for test case managements
- Used ClearQuest for Incident managements and bug reporting.
Environment: SAP FSCD, FICO, HR, PEGA SYS, Java j2ee, QTP, Quality Center, WEBSphere Process Server, and ClearQuest .
Confidential, MN
QA Lead
Responsibilities:
- Requirement analysis, understanding design and functional specifications.
- Design QA Process, Procedures and standards.
- Writing test Strategy and test Plans.
- Identified Scenarios, Conditions and Prepared Test cases.
- Created Traceability document and mapped Test cases to Requirements.
- Written Complex interface testing strategy and interface Test plans.
- Reporting management Defects, issues and deadlines.
- Resolving the open issues with technical team.
- Preparing test artifacts and mentoring the team.
- Estimate and prioritize workload
- Distribute and track work in the QA environment.
- Estimates and prioritizes workload
- Data Conversion testing, batch testing and Data validation.
- Designed and developed / written Test cases for functional, regression, integration and system testing
- Created sample tests data and loaded into database using SQL, VB macros and batch files.
- Created SQL queries using SQL Navigator tool.
- Created Control documents for QC and Mentored testers.
- Submitted and documented defects using ClearQuest tool.
- Participated and explained defects & issues in the review meetings.
- Created and maintained Assignment tracker, defect tracker documents.
- Re-tested Fixed defects and closed once they resolved.
- Updated status (Defects, Issues & Resolutions) to managers’ daily basis.
- Participated and helped in UAT.
Environment: Java/J2ee, Cold fusion, PL/SQL, SQL Server, JavaScript, QTP, TestDirector, ClearQuest.
Confidential
Sr.QA Analyst
Responsibilities:
- Design QA Process, Procedures and standards for Load tests.
- Writing test strategy and test plans.
- Written test plans, Test cases for Regression, System and Performance test for Retrieval and Load services
- Design and/or understand XML DTD/Schemas, Java API's, Collections, Domains and Payloads
- Written test plans, test scenarios, test conditions and XML test scripts using Java API's.
- Used XML Spy to validate XML & Java API’s script
- Create and Set up base control files for all XML test scripts.
- Identified scenarios, conditions and Test cases.
- Created Traceability document and mapped test cases to requirements.
- Complex interface testing strategy and interface test plans.
- Data conversion testing, Batch testing and Data validation.
- Created reports on Regression, System and Performance test results.
- Involved in set up test environment for multi platforms like Win, SunOS, Lynix.
- Tested and analyzed all test scripts in multi platform environments.
Environment: Jave/J2ee, Oracle / SQL Server, DB2, SunOS, Win NT, PVCS, TestDirector, Toad
Confidential
Sr QA Analyst
Responsibilities:
- Review, understand business process and design documents for Health Match
- Written test strategy and test plans.
- Written Complex interface testing strategy and interface test plans.
- Data conversion testing, Batch testing and Data validation.
- Designed and developed / written test cases for functional, regression, integration and system testing
- Worked on Functional, Regression, Conversion and performance tests.
- Written/Modify test plans, test scenarios, test cases/scripts for above tests.
- Test data Modeling, written test data scripts (VB macros in Excel sheet) and loaded into system
- Executed test cases, reported defects or bugs using Rational Clear Quest
- Review, Analysis and Document on each test results.
- Participated in defect management Reviews, Assign/resolve/Close defects.
- Doing Analysis and retesting on Fixed or resolved bugs
- Review & Update test cases, assignment docs, issue and defect documents.
- Make changes and load test data according database schemas using SQL Loader
- Create automated test environment for regression test.
- Record the scripts and automate them for regression test.
Environment: Jave/J2ee, Oracle, WinRunner, QTP, ClearQuest, Toad, TestDirector.
Confidential
SAP HR
Responsibilities:
- Frick unemployment compensation, Exclusively yours program for tax calculations, Charitable contributions
- Garnishment bonus, Garnishment remittance, Garnishment check details, Production allowances
- Premium holiday detail report, Premium holiday summary report
- Benefits Exp. Allocation based on head count, on current cost & summary reports
- LOA employee count and expenses report, HR Personnel report
- Load ABA Bank Routing Numbers from Federal reserve WEB
- Payroll Reconciliation Report, Customized this standard report
- 3rd Party Forecasting / Reconciliation Report using ALV, amounts due by company code, vendor & due date
- Customized standard Time Sheet Report using ALV, with additional selections screen parameters
- STD / FMLA Report using ALV, lists all the FMLA & STD absence types for each case on IT082
- General Associate Information Report, extract actions, Org.unit, personal data and salary.
- Address Labels (Report), Prints address labels of All selected EE on selection screen
- Additional Payments Report using ALV grid
- Executive Information Report using ALV, extracts data from IT’s 0000, 0001, 0002, 0008, 9001
- Create 401K Saving Plans & Report List, Creates an IT0169 record for eligible employees & list with ALV
- Implemented workflow and email integration
Confidential,
SAP Java Integration
Responsibilities:
- TSR Dialog module to load sales data & update custom tables in SAP on-line
- WEB Enabling TSR transaction through ITS ( 2 way Entry )
- PC based GUI Application for off-line entry using Java Swing with validations
- Migrated customers product feed back data to SAP SD using LSMW tool
- Legacy sales data migration to SAP SD using LSMW tool
- Zload program to load TSR sales data to SAP SD in off-line using LSMW
- Reports (classical, interactive and ALV grid) on TSR Sales data
- ZMSDS program for additional logic & screen maintenance
- Loading customer and partner data to SD module using XD01, VAP1, VAP2 transactions & LSMW
Environment: SAP SD, MM, Java Swing, J2EE, UNIX, Oracle 9i, Junits.
Confidential
Service Workstation
Responsibilities:
- Customer Support: Providing support for PM, CTM, OCDM & NMSC ( Confidential &T Network Mgmt Service Center).
- S/W Maintenance: Trouble shooting, fixing problem & Deploying modified programs online.
- S/W Development: Customization, Enhancements, Modifications and adding new features.
- Fixed the problem of frequently disconnecting with Host instead of re-login, when communications fall down using direct line.
- Modified the communication daemon, which had a problem in Catch up Signaling & Emptying IPC Queues. This daemon reads setup and remote user information from the database, establishes connection to CTMRT Host via Unix UUCP (CU), receives and sends messages to the Host, sends received PCO Lines.
- Modified the communication parser daemon, which had a problem in parsing bad PCO Lines.
- Modified parser daemon to updates status & notice icon when necessary, and updates shared memory with Graphical charts dynamically every five minutes.
Environment: Sun Sparc / SPARC Server 1000,Informix 5.0, Esql, UUCP, Shell, Solaries 2.4 / SunOS 4.1.3,C++/C
