email@example.com 205-***-****) Alabama
Over 5 years of IT experience in Quality Assurance and Data Analysis of various business applications in Client/Server environments, Web-based applications and Data Warehousing solutions with strong business and functional knowledge.
I would like to associate with growing organizations which lets me to grow into technology and career.
●Good understanding of Software Development life Cycle (SDLC) and importance of QA in Development/ Enhancement and Maintenance of software applications.
●Expertise in Manual and Automated Testing in different testing methodologies like Agile, Scrum, Waterfall.
●Participated in requirement review meetings, analyzing requirements, developing test plan and test cases, Requirement Traceability Matrix, Defect management, Reporting and tracking.
●Executed QTP/ HP UFT automation scripts for regression Testing.
●Very good knowledge in HP UFT – object repository, checkpoints, Actions, Functions, parameterization, transactions, object spy, function library.
●Having Knowledge in Automating Web Application Testing using Selenium.
●Knowledge in Java Programming, Selenium WebDriver and TestNG Framework.
●Good understanding of Data Modeling, Data Analysis and creating Mappings in informatica by using different transformations like aggregator, Router, filter, joiner and Lookup.
●Extensively worked on ETL (Extract-Transform-Load) using informatica.
●Good experience on Data warehousing concepts, Familiarity with Mapping documents, OLAP, OLTP, database schemas, Star schema, Snowflake schema, data marts, dimension tables, fact tables.
●Experience in Data Analysis, Data Validation, Data Cleansing and Data Verification.
●Experience in RDBMS, Oracle, MS Access and associated SQL Programming Knowledge.
●Proficiency in Structured Query Language (SQL), Joins, PL/SQL stored procedures
●Experience in design, development and implementation of MS Excel /VBA based Applications.
●Experience in Advanced Excel and its features like Pivot Tables, Charts, Functions, etc.
●Having knowledge on diagramming tool MS Visio.
●Good Understanding on SharePoint to build solutions for a wide variety of business process.
●Practical knowledge with Quality center/HP ALM to develop Test plan, test cases, executing test cases in Test lab, and creating and tracking defects in defect modules.
●Expertise in using Tools Mercury/HP Quality Center, and JIRA.
●Have good working experience in UNIX, shell scripts and ftp using WinSCP.
●Having knowledge on SOAPUI tool to test the Web Services request and response XML and validated the data.
●Good Analytical, Interpersonal and communication skills, result oriented, committed and hardworking with a quest to learn new technologies and undertake challenging task.
HP ALM/Quality Center (QC), JIRA
Test Automation Tools
HP UFT 11.5/QTP 11/10, Selenium.
VB, Java, SQL, HTML, VBScript, VBA MS Excel
Oracle 9i/10g, MS SQL Server, MS Access
Apps/Web servers and other tools
HTML, XML, Web Services, ETL (informatica), MS Visio, SharePoint 2013, BI Reporting.
Windows 95/98/NT/XP and UNIX
Bachelor of Engineering in JNT University.
PNC Bank, Pittsburgh, PA Aug 2016 – Sep 2019.
●Worked in Agile environment, attended daily stand up meetings, SCRUM meetings.
●Reviewed business requirements (User Stories) with Business Analyst and Project manager, Team lead, technical architects and developers.
●Developed Test plan and Test cases based on the requirements.
● Used JIRA for issue tracking and project management.
●Involved in Data warehouse testing while integrating data from existing legacy system to Oracle and reviewed mapping document and creates mappings between systems.
●Involved in ETL testing, executed SQL queries to validate the data in target database and familiarity with fact tables, dimension tables, star schema and snowflake schema.
●Performed testing to make sure the data is sorted, validating count, and totals, average of the data stored in the table.
●Created SQL compare statements to validate Actual results with the Expected Results and written complex SQL queries for validating Reports.
●Verified ETL logs and reject/discard files for errors and reported them to development team
●Check for accuracy, completeness (missing data, invalid data) and inconsistencies.
●Worked on Informatica Workflow Manager to run the workflows and monitored the status and logs in Workflow Monitor
●Detected defects, communicated to the developers using Bug Reporting Tool and tracking the Defects using JIRA with Zephyr.
●Executed shell scripts in Unix.
●Involved in complete QA Life Cycle.
Informatica PowerCenter 9.5, Flat files, oracle 11g, Toad, MS office, Unix, JIRA, power BI.
NOVANT HEALTH, CHARLOTTE, NC Mar 2015- July 2016
●Worked in Agile-Scrum Methodology and attended sprint planning meetings.
●Participated in daily Scrum and reviewed User Stories.
●Developed and executed test cases in Quality Center.
●Performed Functional, Regression, User Acceptance Testing, System Testing.
●Preparing Test Data with the use of Boundary Value Analysis (BVA) and Equivalence Class Partitioning (ECP).
●Performed Smoke, Sanity, Positive and Negative Testing manually.
●Performed Backend Testing to ensure the authentic retrieval of data from a database.
●Performed manual testing for each system built.
●Extensively used Quality Center (QC) for test planning, bug tracking and Reporting.
●Upload Business requirements, test cases and defects to Quality Center
●Generated detailed Bug Report and Documented defects using Quality Center.
●Automated test scenarios for GUI functionality using Quick Test Pro (QTP).
●Worked with other team members in developing automation scripts in QTP for Regression testing.
ENVIRONMENTS: Quality Center, Quick Test Professional, Java, Windows XP/2000, Oracle.
LAASYAM TECHNOLOGIES, Stamford, CT OCT 2013 - Feb 2015
●Develop and maintain MS Office applications, and handle both frontend and backend development procedures.
●Analyze the data and manipulating according to the business.
●Developed Macros for data automation and reporting.
●Implemented several built-in excel functions and formulas.
●Implemented pivot tables and charts in Excel for summarizing data.
●Imported data into excel from flat files.
●Used Excel VBA/Macros, MS Access and SQL queries to make reports in different styles and then distributed them as PowerPoint slides to various level of management.
●Performed testing, maintenance, debugging and documentation for every process.
ENVIRONMENTS: Visual Basic 6.0, MS Access, MS Excel, VBA, Windows, SQL Server, power BI.