Home

Nilesh - Sr QA

[email protected]

Location: Ellicott City, Maryland, USA

Relocation: Yes

Visa: H4 EAD

Experience Summary Over 18 years experience in Testing/Data Quality (Database/ETL/Big Data/Python/AWS/Automation) including 4 years in Oracle DB Development. Domain expertise includes Child Welfare, Title IV-E, Banking and Financial Services, Investment Banking, Insurance, Healthcare (Hospital Claim Management) and Media Experience in ETL and Data testing in On prem and AWS environment Experienced in Testing ETL/Data pipelines using Python using Pandas, Boto3 Experience with Data-driven testing and writing SQL, PL/SQL and T-SQL queries for database manipulations; Performance, Query tuning. Proficient in writing SQL Queries, SQL *PLUS, PL/SQL, T-SQL stored procedures for databases like Oracle, SQL, DB2 on UNIX, Linux and Windows platforms. Strong experience in developing test scripts based on source to target mapping, dimensions/data models, Data Marts, Data Warehouse, Data Lake, MDM, Star, Snowflake schemas Hands on experience of ETL and DB concepts like 3NF, SCD, surrogate keys, aggregations, Master Data Management, Dimension and Fact tables Experienced in Data profiling, Test data management and testing masked data. Hand-on experience in testing with REST API testing using Postman and Swagger. Hands on experience in creation of Automation Test cases, development of hybrid test framework using Selenium Webdriver Experienced in using Tricentis Tosca for Test Automation Strong Analytical capacity in analysis of in all phases of Software Development Life Cycle/SDLC (Agile/Scrum and Waterfall) and Software Test life cycle/STLC (Requirement Analysis, Test Planning, Test case development, Test Environment setup, Test Execution, Test Cycle closure) and coordination with Development team Logging and Tracking Defects in all the phases. Testing Skills include creating Test Strategy, Test Plans, defining Test Scenarios, creating RTM (Requirements Traceability Matrix), Test Cases, Test Scripts and Test data management, mining and manipulating test data, executing test cases, first-level triage of defects found, and retesting of defects through resolution. Proficient in using Test Management tools such JIRA, TestRail, Rally, and HP QC (Quality Center) bug reporting tools to track test progress, execution and deliverables. Skilled in Web based testing including Automation Testing, API/WebServices Testing, GUI Testing, Regression Testing, Integration Testing, System Testing, UAT Testing, Performance Testing, Stress Testing, Functional Testing, Unit Testing, Risk based Testing, Back-end Testing, Component Testing, Smoke Testing, Sanity Testing, Positive and Negative Testing, Data Driven Testing, Software upgrade Testing, Post production shakeout Experienced in facilitating User Acceptance Testing (UAT) for go-live. Understanding and experience of working in AGILE/Scrum framework Skills ETL Tools Informatica Power center, DVO, Ab Initio, Talend, SQL Server SSIS, Data stage, AWS Glue, Python BI Tools SSRS, Tableau, MicroStrategy, Crystal Reports, Business Objects, Cognos reports, Qlik Sense reports Database/Data warehouse/Data Lake AWS S3, RDS, Athena, Redshift, Snowflake,Spark, Oracle 10g, Big data, Hive, Hadoop, MongoDB, Robomongo, Teradata, DB2, Sybase, MySQL, MS SQL Server, Data Bricks, PostgreSQL, PySpark,NumPy Database Management Toad, SQL Management Studio, SQL Developer, SQL query analyser,Teradata BTEQ Testing Tools Selenium, Tosca, QTP 9.2, BDD, Cucumber, JMeter, PyCharm, PyTest, Jupyter Notebook, Query Surge, ETL Validator Languages Python, Java,C#, SQL,PL/SQL,T-SQL,C, C++, Shell Scripting Test Management Tool JIRA, HP Quality Centre ALM, ClearQuest, Test Rail Domain Knowledge Financial Services, Investment Banking, Insurance,(Hospital Claim Management) and Media Technology / Environments Oracle, Informatica, Power center, DVO, Informatica TDM, IDQ (Informatica Data Quality), Data stage, SAP BO, UNIX, Putty, Winscp, TFS, Notepad++,Confluence, Linux, Autosys, Control-M, Citrix, Dot Net(ASP.Net, C#), Visual Studio 2017, SOAP UI, Windows, HTML,CSS,Visio, CI/CD pipelines, GitHub, Jenkins, XML, JSON, Postman, Swagger, REST-Assured, AWS, Java, Maven,GIT Professional Certifications Oracle SQL Certification ISTQB Certified Foundation Level Tester (CFTL) Certification in Software Testing NSE s Financial Markets: A Beginner's Module. Keywords: cprogramm cplusplus csharp continuous integration continuous deployment user interface business intelligence sthree database golang hewlett packard microsoft procedural language