Data Analyst, Quality analyst, data developer

Rajya Konduru

*******.*******@*****.*** 205-***-****) Alabama

SUMMARY:

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.

Professional Experience:

●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.

TECHNICAL SKILLS:

Testing tools

HP ALM/Quality Center (QC), JIRA

Test Automation Tools

HP UFT 11.5/QTP 11/10, Selenium.

Languages

VB, Java, SQL, HTML, VBScript, VBA MS Excel

Databases

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.

Operating Systems

Windows 95/98/NT/XP and UNIX

EDUCATION:

Bachelor of Engineering in JNT University.

WORK EXPERIENCE:

PNC Bank, Pittsburgh, PA Aug 2016 – Sep 2019.

Data Analyst

RESPONSIBILITIES:

●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.

Environment:

Informatica PowerCenter 9.5, Flat files, oracle 11g, Toad, MS office, Unix, JIRA, power BI.

NOVANT HEALTH, CHARLOTTE, NC Mar 2015- July 2016

QA Analyst

RESPONSIBILITIES:

●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

Excel Developer

RESPONSIBILITIES:

●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.

Contact this candidate