SUMMARY:

• Around 7+ years of experience in the field of Software Quality Assurance and Testing for various kinds of applications and domains.
• Excellent in analyzing the data by utilizing SQL skills. About 7 years of experience in writing SQL.
• Expert in backend/database testing
• Great automation testing experience using Selenium
• Great experience in Data Profiling, Data validation, Data Quality check, and Data integration.
• Excellent knowledge in transforming Business Functional requirements into Test Plan, Test Scenarios and Test Case documents.
• Great familiarity and understanding of importance of CI/CD
• Implemented automation frameworks to test large datasets resulting in 50% reduction of testing effort and time.
• Worked on full life cycle of GDPR from design, requirements gathering, implementation, and testing.
• Excellent technical hands on experience of Hadoop eco system and its components.
• Extensively involved in all phases of Software Development Life Cycle (SDLC) and Testing Life Cycle including R egression, System, Functional, Integration testing.
• Hands on experience skills in using Manual testing techniques on Web based, Client/Server, database, Windows and UNIX environments.
• Hands on experience in various testing methods Sanity, Smoke, GUI, Functional, System, Integration, End to End, Adhoc, Cross Browser, Cross Platform, Regression, Database, and User Acceptance Testing.
• Experience in performing backend testing to verify Data integrity and Data validation of client server and web based applications using SQL, HQL.
• Ability to work in a team oriented, collaborative environment, and customer - oriented environment.
• Excellent communication, organization and planning skills.

TECHNICAL SKILLS:

Programming Languages: JAVA, JAVA Script, UNIX, ASP, SQL, PL/SQL, TSQL, HTML, PIG Latin, HQL Teradata, SQL Server, ORACLE, Postgres, MS Access, Progress DB

Tools: Selenium,Alteryx, Mapreduce, Hive, PIG, Oozie, Ambari, Kafka, Informatica, SSIS, SSRS, SSMS, Quality Center ALM, Quick Test Pro (UFT), Cognos, MS Office, MS-Visio & MS-Project, FTP, Visual Studio, Oracle SQL Developer, Teradata management Studio, MS Test Manager

Environment: Windows 7, Windows 10, Vista, XP, 2000, 98, Server 2008, 2003 & UNIX.

PROFESSIONAL EXPERIENCE:

Confidential, Dearborn, MI

Software Engineer Developer and Test

• Groomed, designed, and developed Teradata, File-based (CSV, ASCII, EBCDIC, GDG) Oracle, SQL server sources to replicate in Hadoop landing zone.
• Developed and deployed Selenium automation frameworks to test backend data quality and validation.
• Developed in the Hortonworks Hadoop environment to land data from multiple sources to Hadoop cluster using the home-grown Data Ingestion Framework (DIF) tool
• Designed test plans and testcases in ALM for the local and overseas testing team to follow and execute
• Developed and landed multiple sources from design to deployment phase in Production on Ford Hadoop cluster
• Utilized Jenkins and Eclipse for deployment on test servers for continuous integration/continuous delivery(CI/CD).
• Worked extensively with GDI&A data operations team on daily basis to gather requirements and design documents before landing
• Great understanding of Hadoop and its components like map reduce, Hive, Kafka, Oozie, Hbase, Pig.
• Excellent SQL writing skills
• Alteryx certified
• Created test plans for the upper management to review the testing strategy of the QC team
• Understand Ford business processes like CDIT, SPII data, ACRs.
• Great understanding of Attunity (data ingestion tool) its features and limitations
• Created complex SQL queries for accurate data verification and comparison

Confidential

Software Engineer in ETL/Backend/Automation Tester

• Performed data analytical testing for BI systems.
• Validated data transformations and perform end to end data validation
• Developed, maintained executed Automation Test Scripts using Selenium
• Wrote SQL queries extensively, queried database and generated test reports.
• Helped SSIS,SSRS developers by writing SQL queries which were used to create ETLs and reports
• Executed and edited stored procedures to check security of the application.
• Created complex SQL queries to validate calculation results generated by the developed code.
• Reviewed Business and Functional requirements and give appropriate feedback on identified gaps.
• Developed test cases to validate new and existing functionalities and identify software quality issues.
• Actively assisted in functional, regression, system testing and successfully met deadlines every time.

Environment: SQL Server 2008, Quality Center, MS Office, ETL, SQL, T-SQL, .NET, C#

Confidential, Grand Rapids, MI

Software Quality Assurance Analyst

• Worked on a mobile and web based ecommerce solution.
• Created test cases for the front end user to examine the functionality of each object in the application.
• Tested the data tables for the purpose of debugging and defect traceability using SQL.
• Presented a demonstration of Microsoft Visual Studio and Microsoft Test Manager to the team members to help them understand the usability and functionality of the tool resulting in higher efficiency.
• Documented test cases and defects using Microsoft Test Manager.
• Collected numerous undocumented requirements by interviewing end users, Business Analyst, and the development team.
• Attended meetings involving end users to review open issues and discuss the new concerns/requirements.
• Designed queries using SQL to perform backend testing

Environment: Java, Microsoft SQL Server, SQL Developer, TFS, Microsoft Test Manager

Confidential, Madison, WI

Quality Assurance Analyst/ Business Analyst

• Involved in meetings with Business process owners, SME (subject matter experts) and other stakeholders for Requirements gathering and refining in definition stage.
• Gathered the information and requirements from the user. Derived Business Requirement document (BRD), and Functional Specification Document (FSD)
• Facilitate JAD (Joint application development) sessions
• Developed a Test Plan and communicated to all team members.
• Validated the data collection phase by testing the “Coverage Calculator Transformations”. This involved validation of file extracts created by Informatica mappings.
• Created test data for verifying the proper functioning of the SQL scripts that calculate coverage.
• Extensive use of complex SQL for data validations. Used advanced SQL functions and also tested PL/SQL functions and procedures.
• Developed Process Model and detailed Business Policies and modified the business requirement document.
• Validated the document generation both manually and through the application Intelledox.
• At the backend, validated the processes involved in validating the SBC document. Benchmarked the generated document against the templates provided by the Government.
• Created test cases and test scripts for the front end web pages, for the validation of the newly added functionality that makes the SBC document easily accessible to the consumers.
• Reported defects using HP Quality Center, also verified fixes and closed bugs during regression testing. This testing was done to ensure proper application functionality, data entry, processing, and interface stability with an established baseline for future tests.
• Developed various test cases for data validation and business function validation of UAT.
• Pulled source data for UAT validation.
• Extensively involved in meetings and reviews to resolve issues related to open issue.
• Developed Test Metrics on the weekly basis for senior management.

Environment: JAVA, Flex, Oracle, Beyond Compare, MS-Office, QC and SQL Developer.