Ravi Chejarla

Phone No: 331-***-****

Email: adam61@r.postjobfree.com

Motivated Individual with over 11+ years of IT Experience as Sr. QA Engineer and Database Developer with focus on testing UI and Database Applications. Solid experience in executing test cases manually and automation by using multiple test automation tools like Selenium. Have experience working in industries like IT, Advertising, Educational Institute, Healthcare and E Commerce.

PROFESSIONAL SUMMARY

●Rich Experience working with all phases of Software Development Life Cycle (SDLC) and Software Testing Life Cycle (STLC) and Involved In all Phases of Bug Life Cycle.

●Extensive experience in testing several applications like UI frontend applications, Client/Server, Database applications, Data Warehouse applications, Reporting Applications and E-commerce Applications.

●Proficient in Test Management and Defect Management tools like JIRA Zephyr, Rally to track defects and created many Test Cases, Test Data

●Expertise in Requirement Analysis, creating Test Plans, Test Strategies, Test Cases, Test Scripts and Created Test data.

●Performed different types of testing such as Functional, Integration, Regression, Smoke, Positive, Negative, Data Driven, System, Integrated, Black Box/White Box Testing.

●Designed, developed and implemented manual and automated tests for Functional, Integration, Regression, Ad-hoc, Stress, Smoke, Performance, Compatibility, Cross-Platform, System, Data Driven, Data Flow and User Acceptance Testing.

●Experience in testing ETL data load and extraction various source systems and for populating base and aggregated tables.

●Expert in creating SQL scripts and stored procedures for Database and Data Warehouse Testing.

●Good in data validation testing by comparing UI components data with database and data warehouse objects.

●Good experience in automated testing using Selenium WebDriver.

●Proven ability in designing and creating automation frameworks using Selenium WebDriver, Java, Junit, TestNG, C#, NUnit, Maven, ANT, Jenkins tools.

●Experience of Creating, Modifying and Maintaining new and existing Automation Framework models (TDD, BDD, Page Object Model, Data Driven Frameworks).

●Experience in implementing the Page Object Model (POM) by creating element for each page object and reused all the objects in various scripts.

●Good in developing Behaviour Driven development by writing Gherkin language using cucumber tool, developed scenarios, scenario outlines, features and step definitions and generated cucumber reports.

●Created automated reporting using Extent Reports, SpecFlow, HTML Reports and Log4J to create logs.

●Experience in testing Web Services and API Testing using SOAP UI and REST API.

●Extensive programming experience as Database & Report Developer in Microsoft SQL Server 2012/2016 using T-SQL and Business Intelligence Data Tools.

●Extensive experience in Database design using SQL, T-SQL in Stored Procedures, Dynamic SQL, Views, Functions, Triggers, Indexes and Batch Scripts.

●Expert in Extraction, Transformation, and Loading (ETL) data from various data sources using SSIS packages.

●Proficient in developing Advanced and Interactive Reports (Drill-Down, Charts/Graphs, sub-reports using SSRS.

EDUCATION

●Bachelors in Computer Science from Sathyabama Deemed University, India (May 2001 – May 2005) – 3.50 GPA.

●Masters in Software Engineering from the University of Stratford, Virginia (Aug 2006 – Dec 2007) – 3.70 GPA.

CERTIFICATION

●Microsoft certified professional in Querying Microsoft SQL Server 2012

●Microsoft certified professional in Implementing a Data Warehouse with Microsoft SQL Server 2012/2014

TECHNICAL SKILLS

Testing Tools

Selenium WebDriver, Junit, TestNG, Fire Path, NUnit, Postman

Web Technologies

Java, C#, HTML, CSS and REST Services, SOAPUI

Languages

Java, C#, SQL, T-SQL, PL/SQL

Test Management and Defect

Tracking Tools

JIRA, Zephyr, Rally

Build Tools

ANT, Maven, Microsoft Visual Studio, Eclipse

CI/CD Tools

Jenkins, TeamCity, Cruise Control

Version Control

GitHub, GIT, Bit Bucket, Team Foundation Server

Testing Methodologies

Agile, Waterfall, Kanban

Automation Testing Frameworks

TDD Page Objects, BDD Cucumber

Test Reports and Logs

Extent Reports, Spec Flow, HTML reports, Log4J, Log4Net

Databases

Microsoft SQL Server 2005/2008/2012/2016, Oracle 11i/10g/9i

Database Tools

Microsoft SQL Server Management Studio, SQL Server Data Tools, SQL

Server Business Intelligence Development Studio, Oracle

Business Intelligence (ETL and Reporting Tools)

SQL Server Reporting Services (SSRS), SQL Server Integration Services

(SSIS), Report Manager, Tabular Analysis, MS Excel, Safari Reporting Tool

Performance Tools

SQL Server Profiler, Database performance tuning monitor

Operating Systems

Windows 7/Vista/XP, Macintosh

PROFESSIONAL EXPERIENCE

Client: Fidelity Investments, Durham, NC May 2019 - Present

Position: Sr. Software Engineer in Test (SET) / QA Engineer

Responsibilities

●Involved in Requirement analysis and understanding, worked with Product Owners, Scrum Master, System Architects in Requirement analysis and prototyping creation for new project releases.

●Involved in Agile Scrum JIRA, Quality Centre tools and Agile Central tools for scrum planning, development and tracking burn downs.

●Participated in application code and test code reviews with rest of the Scrum team

●Collaborate with team members on improving test coverage, release velocity and production health

●Involved in defect triage calls to assign severity and criticality of defects. Performed troubleshooting and bug analysis of the assigned defects.

●Prepared automation estimates and reviews, Provided demo on automation scripts developed at the end of each sprint (cycle) and conducts retrospective meetings.

●Involved in implementing automation solution for Web applications using Java, Eclipse, Selenium WebDriver, Cucumber and TestNG.

●Maintained existing automation scripts, when a new feature is added to the application.

●Performed testing and testability to influence better software design, promote proper software engineering and bug prevention strategies and security.

●Actively participated in the development process through writing and maintain application features and automated tests including unit tests, component tests, integration tests, functional tests, performance tests, scenario tests and interoperability tests.

●Supported the team in designing reliable, portable, accurate and trustworthy tests, and in integrating them into CI/CD pipelines.

●Performed ETL and Database Testing, Created SQL database queries, advanced PL SQL test scripts to perform data validation for UI components data with base database tables.

●Tested ETL workflows of various source systems for populating base, aggregated tables. Involved in Multiple data Import and export from different data sources

Employer: Publicis Media Inc., Chicago, IL April 2014 - April 2019

Position: Sr. QA Engineer

Vivaki is the global leader in ad tech solutions, working with the world’s leading organizations to ensure every digital interaction a customer has with a client brand adds meaning and value to their day.

Project: Tested many UI Applications for the projects AODp, VOS and Investment Management. Tested many Database Applications for the data source providers like Facebook, ComScore, Marin and Kenshoo. Performed both manual and automated testing for UI applications.

Responsibilities:

●Involved in analyzing the business requirement documents (BRD), Functional specification documents to prepare the Test Plans for the Projects AODp, VOS and Denali-Investment Management

●Performed testing for both UI websites applications and also for database applications

●Analyzed the use cases and developed many Test Scenarios documents for projects

●Created many Test Cases in Rally, JIRA for the user stories

●Create different Test Cases for Functional Testing, Performance Testing and security testing

●Developed End to End Testing Testing Plan with Test Scenarios

●Created Regression Testing Plan with Test Scenarios

●Developed Smoke Testing Plan with Test Cases

●Created User Permissions Testing plan with several security test cases

●Gave continuous requirement suggestions to the business analyst and product owners

●Developed Test Scripts for the applicable stories

●Prepared many SQL queries to perform data validation for UI components data with base database tables.

●Created many Defects, bugs for stories in Rally and Jira defect management tools

●Retested the defect fixes, updated the status accordingly with proper comments and closed the defects Zephyr.

●Involved in all phases of Bug Life cycle and managed defects, logging defects, logoff defects, contacts module etc.

●Involved in all phases of Software Testing Life Cycle and tested the applications in different browsers.

●Gave QA Estimates for the release level and at the sprint stories level

●Involved in defect triage meetings with the developers and project management.

●Experienced in working with business analysts to understand the domain from client’s business perspective. Also understanding business complexity, analyzing the impact & risks and presenting the same to the client..

●Involved in logging and tracking defects in Dev Track (defect management tool) with proper severity and priority

●Developed Test Data form both UI and also at the Database Level for few stories

●Worked very closely in product releases by performing smoke testing after releases in production.

●Automated Testing:

●Involved in framework development using Selenium WebDriver and Page Object Model, TDD, BDD.

●Developed, maintanted automated test scripts using Selenium WebDriver in Eclipse IDE, Visual Studio IDE using Java and C#.

●Used Xpath, Firebug, CSS for element identification, manipulation and interrogation.

●Modified automation scripts to execute test in multiple browsers.

●Developed test frameworks using Junit, NUnit.

●Used Maven for build management.

●Generated Reports using TestNG, ExtentReports, HTML reports and SpecFlow.

●Created logs using Log4J Junit, NUnit frameworks.

●Used GitHub for code Repository.

●Integrated automation project with Jenkins for Continuous Integration.

Employer: Hawkeye Community College, Waterloo, Iowa June 2009 – March 2014

Position: Database Coordinator/Programmer

Hawkeye Community College was established in 1966 and it is one of the Comprehensive Community Colleges in Iowa. Hawkeye offers more than 52 one year and two-year programs for credit classes.

Project: Maintained Microsoft SQL Server Reporting Services (SSRS) Reporting tool using SQL Server database for Hawkeye Community College and Resolved the Data and Reporting needs for the College. I was responsible for Migration as well as Integration for few modules such as Maintaining the Database, Updating the recent records to the system and creating reports whenever required.

Responsibilities:

●Developed Test Plans, Test Scenarios, Test Cases for many UI Applications and for many database projects

●Performed Functional, Integration, Regression, Performance and Security Testing for many several applications

●Involved in analyzing the Business Requirement Documents (BRD), Functional specification documents(FSD) to prepare Test cases and Involved in creating Data Requirements.

●Prepared many SQL queries to perform data validation for UI components data with base database tables.

●Tested ETL workflows of various source systems for populating base and aggregated tables.

●Created many Defects, bugs for stories in Rally and Jira defect management tools.

●Worked closely with the team and provided Reporting Suggestions to improve the standards

●Created new tables, written stored procedures, triggers for Application Developers and some user-defined functions. Created SQL scripts for tuning and scheduling

●Created views for specific columns to maintain the privacy of the customer data.

●Involved in Multiple data Import and export from different data sources and also used SSIS

●Worked on Team Foundation Server in order to have the updated software version to everyone in the team.

●Migrated data from different sources (text based files, Excel spreadsheets, and Access) to SQL Server databases using SQL Server Integration Services (SSIS).

●Learned the existing Applications i.e. Datatel, CAST, Safari Reporting Tool and Reviewed the Business Documentations, Database Model, Data Dictionaries etc.

●Created many SQL Reports using various data sources like SQL Server 2005/2008, Oracle 10g, MS Access, Data warehouse, Analysis Services etc.

●Performed the ETL operations to support the incremental, historical data loads and transformations using SSIS.

●Involved in re-design, re-code, and deploy new data extractions using SSIS, and designed, produced documentation of data transformations for all extractions.

●Maintained Reporting Services Development and Production Environments using Business Intelligence Development Studio (BIDS), using Visual Studio and configured SQL databases 2005/2008, Reporting Services 2008.

●Converted many Safari Reports which uses Unidata Database and Re-Created all the reports in SQL Server 2008 database using SQL Server Reporting Services (SSRS).

●Gathered Report Requirements from End-Users and Given Reporting Services Training to many Departments, End-users and closely worked with end-users in User Acceptance Testing (UAT) of many SQL Reports, Data issues, formatting issues, security issues, performance issues etc.

●Created Users, Roles and maintained security settings/privileges for stored procedures and managed Security settings in Reporting Services by adding security groups, assigning privileges for Folders/Files/Reports etc.

Employer: Canvas InfoTech Inc, CA Feb 2009 to May 2009

Position: Database Developer

The Project is about Payment gateway project (E-Commerce) that uses the software developed by Commerce One, which runs on a UNIX platform. It is a product designed to provide the merchant with a financial gateway from their web site to the financial acquirer for the purpose of card authentication, authorization and settlement. It allows the merchant to perform on-line authorization and settlements with financial acquirers in a secure and reliable environment. For the purchaser, it provides a highly secure and efficient method for purchasing goods over the Internet using a card for payment.

Responsibilities:

●Developed Test Plans, Test Scenarios, Test Cases for many projects

●Performed Functional, Performance, and Security Testing for many UI Applications

●Responsible for all technical SQL Server database operation, ongoing development for various in house databases.

●Designed and developed various database objects like Tables, Stored Procedures, Rules, User Defined Data types and functions.

●Modified current database by adding tables and relationships to support online system.

●Developed the TSQL programs and Involved in optimizing stored procedures and queries for faster retrieval and Server efficiency.

●Developed SSIS packages for integrating data using OLE DB connection from many sources (Excel, CSV, Oracle, Flat file, Text format data) by using multiple tools like conditional split, Bulk insert, merge, Union All, Lookup, For Loop and For each loop container.

●Experience in developing custom reports and many types of Tabular Reports, Matrix Reports, and Drill down Reports, Parameterized, Conditional and Sub Reports using SQL Server Reporting Services (SSRS) in Business Intelligence.

●Created several tables, views using SQL Server management studio, based upon the functional specifications and primary key & foreign key constraints.

●Created Complex ETL Packages using SSIS to extract data from staging tables to partitioned tables with incremental load.

●Customized existing Reports and developed new Reports to suit client requirements. Also created the test scripts for the generated final Reports.

●Used various types of reports layout options like charts (bars, lines, pie etc….), images, graphs, sub reports, hyperlinks etc to make them more attractive and understandable.

Employer: Symmetric Business Inc, Vienna, VA Jan 2008 – Jan 2009

Client: Highmark (Blue Cross Blue Shield), Pittsburgh, PA

Database Programmer

Highmark (Blue Cross Blue Shield Health Insurance Company) is one of the Leading Health Insurance Company in the United States of America. Blue Cross Blue Shield Health Insurance Company focuses on four main areas of operation, which include claims and payment integrity, disease management, clinical and quality outcomes and health care data intelligence. The project focuses on developing tools that enable rapid health care data aggregation and validation from medical facilities for

clients that include health-insurance plans, hospitals, pharmaceutical companies and regulatory agencies.

Responsibilities:

●Implemented enhancements in existing applications using MSSQL Server, SQL, T-SQL and using Oracle Technologies, Oracle 10g/9i, Sybase 12/11.

●Created form in .NET and connect it to the SQL Server Management Studio.

●Full SDLC development of an address cleansing, name cleansing and enterprise individual/customer identification system utilizing Quality Stage for cleansing and standardization.

●Rewrite the existing code for long running queries by replacing cursors with various joins, common table expression (CTE) and indexing.

●Extensively used Joins and sub-Queries to simplify complex queries involving multiple tables and optimized the procedures and triggers to be used in production.

●Proficient in SQL Server and T-SQL (DDL and DML) in constructing Tables, Normalization techniques on database Tables.

●Created Ad Hoc Reports for the business user to analyse the existing system and to know the performance of the architecture.

●Involved in Normalization and Denormalization of existing tables for faster query retrieval.

●Installed and configured servers and clients using SQL Server 2008, Upgraded SQL databases.

●Designed the packages in order to extract data from SQL db, flat files and loaded into SQL Server database.

●Created SSIS packages to retrieve data from Legacy sources and to retrieve user data from the Flat files on daily, monthly and weekly basis.

●Created SSIS packages using for each loop transformation to load multiple files from same source folder.

●Configured XML config files (.dtsconfig files) to change properties of packages dynamically.

●Created reports for policyholders by using Excel pivot tables and SQL server Reporting service (SSRS).

●Collected data from Various Heterogeneous database/files like MS SQL, DB2, ORACLE, Flat File, Access, Sybase, EXCEL sheets, CSV format and used complex data conversions to load the data into destination databases.

●Implemented security for the reports, user tabs, report models and folders in the report manager at the application, database and the report manager level.

●Proficient in analyzing the end user requirements and converting them into efficient Technical design and technical code documents.

●Managed performance and tuning of SQL queries and fixed the slow running queries in production

Contact this candidate