SUMMARY

• Over 10 years of professional experience in Information Technology with emphasis in quality assurance and automation testing, data analytics, ETL, reporting.
• 6 years of experience in automating Web Service test cases using Java Script in Postman and UI test cases using Selenium and Katalon Studio for Web and Mobile testing.
• Experienced in working with Linear, Modular, Data - Driven and Keyword Automation Test Frameworks using Selenium and Katalon Studio
• 3+ years of experience in Data Analytics, creating ETL packages using SSIS and Reports using SSRS and MS Access Report Developer
• Contributed to team growth by participating in User Story estimation, planning and daily stand-up meetings in an Agile/Scrum environment alongside Business owners, Project managers, Developers and Testers.
• Over 4 years of experience in tracking, documenting, reporting and closing defects and issues using VersionOne project management tool.
• 3 years of experience in tracking, documenting, reporting and closing issues using JIRA project management tool
• Strong communication, presentation, analytical, problem-solving and inter-personnel skills with ability to handle multiple tasks effectively.
• Experience in testing Supply Chain Logistics, Finance, Online Advertising and Marketing Technology domain applications.

PROFESSIONAL EXPERIENCE

Confidential

Quality Assurance Engineer

Responsibilities:

• Responsible for developing and maintaining web UI, web services, mobile test plans and test scripts for a supply chain logistics client ( Confidential ).
• Saved 19 hours of dev resource time per sprint by automating and executing 45% of Hub Connect Web based application Regression and Smoke test cases using Katalon Studio
• Lead manual and automation testing of the clients Customer and Supplier apps for Web, and mobile devices (Android and iOS)
• Perform backend testing using Katalon Studio and SQL queries on NoSQLBooster for Mongo DB
• Automated REST API test cases collection runs using Postman monitors
• Tracked and documented test results and defects identified during testing in Jira

Environment: Java, Java Script, Katalon Studio, Postman, Jira, and Mongo DB

Confidential, Overland Park, KS

Quality Assurance Engineer/Web Development

Responsibilities:

• Lead and trained the QA team on new automation roll out for webservices using Postman and Web UI testing using Katalon Studio and Selenium WebDriver.
• Acted as key point of contact for all web development QA services.
• Worked directly with CEO and CTO on migration of critical web UI projects that generates 40 percent of the company’s revenue.
• Reduced turned around time and improved web UI product quality significantly by integrating Katalon Studio and Selenium WebDriver test cases with cloud-based web and mobile Testing Plattform
• Developed and maintained test plans and test scripts for desktop, web UI applications, web services, SQL Server Business Intelligence and other non-UI applications
• Automated UI and Functional & Web UI test cases by creating test artifacts like test cases, test suites, test suite collections and executed the same across multiple desktop and mobile browsers and test environments in Katalon Studio and Selenium WebDriver using TestNG framework.
• Automated REST API test cases to validate lead submission and delivery using JavaScript with Postman API Chaining and Data driven framework.
• Performed functional testing in Dynamics AX/365 for Finance & Operations modules by adding and updating client’s information, generating invoices, processing and validated credit card payments.
• Retrieved data from multiple data sources using stored procedures, performed data validation testing and delivered the reports to the clients by creating subscriptions in SSRS server.
• Actively contributed to team agile management project practices by participating in sprint estimation, planning and daily scrum/stand-up meetings.
• Tracked, documented, reported and closed issues in VersionOne project management tool.
• Automated test cases for Web UI applications built on top of vue.js

Environment: Java, Java Script, Katalon Studio, Appium, Postman, Selenium WebDriver, TestNG, BrowserStack, MS SQL Server, SSRS, Dynamics AX/365 and VersionOne

Confidential, Chicago, IL

QA Analyst

Responsibilities:

• Analyzed business requirements for JPMC proprietary investment banking compliance application and produced technical specifications to the development team.
• Conducted SIT and UAT on daily client money computation application for EMEA and North America regions to sign off on migration to the PROD environment.
• Maintained change control process for Daily client money computation application by identifying, documenting, validating and authorizing changes before any production release in Jira.
• Created SQL regression test scripts to compare data and identify offsets across multiple DB2 database environments.
• Documented business process flow for various critical in-house regulatory modules using Microsoft Visio and AS400 system commands.

Environment: AS400/OS400 - System commands, DB2, SQL, MS Visio and JIRA

Confidential, Chicago, IL

ETL Tester

Responsibilities:

• Worked closely with several stakeholders both internal and external to gather and document database requirements and specification for inhouse “Ed-Fi Data Standard” reporting application.
• Developed ETL packages, SQL scripts to import and transform data from multiple databases using SSIS and SQL Management Studio.
• Analyzed the underlying dataflow and developed mappings for a number of front-end interfaces to corresponding backend tables and developed E2E data lineage by working with several system and process owners.
• Generated various test cases for the application using in-house test generation tool “ETL Unit Test Data Manager”.

Environment: MS SQL Server, SSIS and JIRA

Confidential, Chicago

Analytics Associate

Responsibilities:

• Developed SQL procedures to initiate mortgage complaints for various customer overcharging scenarios for a multi-national lender.
• Performed inventory analysis by calculating inventory values by stores and product categories for a large retail health care client.
• Analyzed inventory value using Retail Accounting and Cost Accounting methods.

Environment: MS SQL Server and SSIS

Confidential, Chicago, IL

Analytics Associate

Responsibilities:

• Developed SQL scripts to identify users with multiple access levels and credentials across systems as part of an identity and access management effort.
• Performed data loading, normalization, mapping, data completeness and outlier testing of financial data from JD Edwards database to a common data model to enable execution of standardized fraud analytics.
• Performed targeted collection and processing of transactional data utilizing SSIS packages to extract data from client’s mainframe systems related to overdraft fees and electronic debit items.
• Created data import accuracy tests on Homestead tax exemptions client data, performed fraud analytics and reported findings using SQL Server and MS Access report developer

Environment: VB.Net, MS SQL Server, SSIS and MS Access

Confidential, Plymouth, MI

IT Intern

Responsibilities:

• Identified and documented the underlying Microsoft Dynamics GP backend tables impacted by various front-end actions like “sales authorization”, “post authorization”, “sales”, “void/return” and “credit”.
• Worked on database replication process and synchronized tables across databases (“Publisher” & “Subscriber”) residing in different servers to enable disconnected architecture.
• Developed T-SQL stored procedures to execute data migration scripts that migrated data from the legacy CCE system tables to the e-Payment system tables.
• Developed a web page using ASP.Net to display Product images and description. Integrated the web page with a third-party application to provide users the ability to read and write product reviews.

Environment: ASP.Net, Dynamics GP and MS SQL Server