Pravallika Y Email : ad3h4c@r.postjobfree.com

Phone: 203-***-****

Summary

** + years of IT Experience as Technology/QA Analyst, Salesforce testing, Development and BI of Microsoft SQL Server in various business domains

Experience in working on Waterfall and Agile Methodologies Development and Testing lifecycle methodologies.

Expertise in using scrum agile methodology.

Aware of SDLC procedures, Change control rules, problem management and escalation procedures.

Experience working with JIRA management tools and confluence pages.

Experience in product testing which includes GUI Testing, Regression Testing, Data Driven Testing, Smoke Testing, Functional Testing, Database Testing

Experience in executing testing scenarios, validating, and documenting testing results and provided walkthrough of testing results to the business analyst team for business approvals.

Given demos coordinating with business team and stakeholders.

Experience on HP ALM for manual testing, HP UFT for automation testing and HP Load Runner for performance testing.

Experience in testing ETL applications, BI reports, Appian tool.

Worked on Appian testing to create process flows, BPM workflows, Record Types, Record dashboards etc.

Excellent SQL, T-SQL development skills to write queries involving multiple tables, great ability to develop and maintain stored procedures, triggers & user defined functions.

Experienced using ETL tools such as SSIS for creating Dynamic packages for Incremental Loads, and SSRS for creating various reports.

Worked on System, Unit and UAT testing for Salesforce application to ensure validate customizations and generate flat files.

Worked on Salesforce Admin to understand more about Salesforce basics, Implementing UI, data model, business logic, managing users, Sharing data, workflows etc.

Good knowledge in web services testing via tool SOAP UI/Restful web services.

Education and Certifications

Bachelor of Engineering, Computer Science. Anna University, India.

Worked as Teaching Assistant (TA) in my Graduation. Been Student Chairman

Secretary of the College Cultural Committee

Professional Experience

Verizon (Innova Solutions & Infosys)

Lead QA Analyst Nov 2019 till Date

Worked as QA lead analyst at Verizon on various applications, which includes manual functional testing, Selenium IDE, TestNG, Selenium Web Driver, Eclipse IDE, and Salesforce Lightning.

Served as primary point of testing contact and between Technology, product, and operations.

Managed day to day activities of the quality engineering team in a fast-paced agile software development, testing code promotion.

Worked on Point-to-Point Integration flow to verify flow of orders through Multiple Applications

Progression Tests that require End to End (E2E) flow through from source application to downstream applications beyond near neighbor applications

Progression Tests that require validation, processing, and milestone verification across more than 3 interconnect applications

Heavily involved and executed Regression test cases to certify order flow stability of a product.

Worked on functional testing on global clearance application data masking and backend data masking validation using Oracle.

Managed and executed project plans and delivery commitments of the department.

Created and verified a web services API requests, SOAP protocols.

Involved in testing REST Services using REST Assured and tested both XML and JSON formats.

Involved in creating a test environment for web services testing.

Worked on validating web-based application and created several tests scripts

Worked on Salesforce Admin and testing.

Worked on manually testing and validating Pega integration application to Salesforce.

Worked on creating functional test scripts for creating automation test scripts.

Worked on Selenium IDE and Selenium Web drivers using TestNG Java framework.

Worked on developing a framework using a design pattern page object model.

Worked on IE/Firefox/Chrome driver.

Worked on writing CSS Selector, XPATH identifying web elements.

Worked on sales cloud and service cloud.

Worked on analysis, CRM business process that included campaign management, lead management, role hierarchy in multi-tier environment.

Infosys

QA Testing Lead Analyst Nov 2016 - March 2021

Worked for Infosys clients Verizon, XPO Logistics, SunTrust, Prime Revenue, Bank of America, and Citi bank as Testing / Technology Lead Analyst. Added descriptions for individual client duties as contract positions.

XPO Logistics, Inc.

Senior Test Analyst May 2019 – Nov 2019

Working as QA lead analyst at XPO Logistics for a Client Integration project to integrate 50+ clients and various hubs into single application.

Involved in requirement gathering, preparing test strategy, preparing test scenarios and test plan, creating test cases.

Followed agile methodology for tracking Jira tickets for individual test scenarios.

Validated and did functional testing on Salesforce workflow rules, role-based page layouts, record types, approval, and assignment rules.

Knowledge data loader to insert/update and bulk import data from salesforce.com objects.

Worked on documenting mappings between multiple applications, Inbound (Orders creation, cancel, updates) and outbound process for various clients based on file types.

Worked on processing and validating various integration methods including EDI (204 - Inbound Orders, 214 - Orders Outbound, 210-Finance), API, Flat files, XML files, JSON files, etc.

Working on Dell Boomi to consolidated API calls from different clients into cloud and process bulk orders at a time into CLM.

Worked on Regression testing by using automated scripts.

SunTrust

QA Test Lead May 2018 – May 2019

Worked as an Onsite coordinator and involved in creating test plans, test strategy, Test Scenario Matrix (TSM), Test Data Identification from DMO team, Change Control, Test case creation & execution, Defect Management, FIT/SIT/Regression/CAT testing.

Co-ordinated with offshore team, distributed work evenly and provided daily update to manager on testing status for various projects and test cases.

Involved in static testing for reviewing requirements with BAs & Business users across CLP applications.

Worked on creating Test plans & strategies to provide inputs related to the scope of testing for various projects under CLP.

Worked on creating TSM, to cover all possible scenarios as per requirement. In addition, identified data requirements for various scenarios.

Worked on creating Test cases to cover all TSM scenarios in ALM tool and reviewing the same with CAT team.

Executed test cases in various environments and documented the same with screenshots.

Raised defects in ALM, In case of any issues during execution. And performed thorough regression testing when issues are resolved.

Worked closely with CAT team on CAT/Regression testing and assisted in resolving any CAT related issues.

Documented all the related deliverables for testing process and updated in SharePoint for team review.

Worked on HAL tool for checking detail logs of events which are performed on CLP application.

Worked on Worked and assisted developers on preparing QA test results.

Involved in resolving defects/bugs during QA testing, pre-production, production, and post-release.

Knowledge on Application Lifecycle Management (ALM) tool, which used to log requirement, testing and defects report.

Bank of America

QA Test Analyst Nov 2016 – June 2017

Followed AGILE development Methodology for BOA OTC project to ensure teamwork, collaboration and process adaptability throughout the life-cycle of the project

Developed and maintained Database objects - Tables, Views, Functions and Procedures for implementing application functionality at the database side for performance improvement.

Participated in peer review meeting for created Test plan, test cases and analyzing various testing documents and process of testing life cycle.

Worked on writing SQL Queries to extract data from various source tables to perform database testing using SSMS and TOAD.

Worked on development of ETL Test Plans, Test Scripts, and Test Cases from use cases and executing them. Conducted backend testing using SQL command statements.

Validated the results from SQL server Transactional database to the aggregated information provided by the BI Reports at each level. Tested cloud based Appian tool to create process flows, BPM workflows, Record Types, Record dashboards etc.

Scheduling and monitoring ETL packages daily load using Autosys.

Involved in Developing, Monitoring and Deploying SSIS packages and successfully created dynamic configuration packages in SSIS

Managed work queue in support of all JIRA Helpdesk tickets through JIRA combination of problem identification, troubleshooting and resolution/ development Worked closely with BAs and business users on developing and testing objects as per need

LAVSUN Technologies Inc

SQL Developer / Analyst Dec 2015 – Oct 2016

Gather requirements and understand the specifications of wholesale access certification needs.

Designed and built prototype for access certification challenge on the wholesale end to integrate with Enterprise access certification tool.

Database migration was done from SQL Server 2005 to SQL Server 2008 to enable the applications to run better and reduce the amount of time you need to spend managing them.

Creating and maintaining Database objects - Tables, Views, and Functions and developing Procedures for implementing application functionality at the database side for performance improvement.

Actively involved in developing Complex SSRS Reports involving Sub Reports, Matrix/Tabular Reports, Charts and Graphs.

Design and document the error-handling strategy in the ETL load process using Event handlers.

Developed Tabular, Cross Tab reports, Charts reports, Parameterized, cascaded and sub-reports using SSRS.

Handled multiple tasks simultaneously, prioritized and completed Service Desk Helpdesk requests within established deadlines, not including other mini projects.

Provided daily support, troubleshooting, monitoring of jobs running on SQL Server

Provided On call support for scheduled process failures on rotation basis.

Worked with developers, DBAs, and systems support personnel in elevating and automating successful code to production.

Monitored, optimized and Performance Tuning of Regression Servers using Performance monitor, SQL Profilers, Activity Monitor.

Gobrah Management Consulting Services Pvt Ltd

SQL /MSBI developer May 2010 – June 2013

Interacted with customers to analyze business needs. Provide software product design and developed technical roadmap for the solution through the project lifecycle and beyond.

Provided IT technical support to end users.

Determined the SQL Server Installation.

Installed SQL Server Management tools using SQL Server Setup Program.

Tested the Installation of SQL Server.

Implemented Triggers for checking complex business conditions, providing security for the tables.

Physical Implementation of database into SQL Server 2005 using T-SQL.

Worked on Client/Server tools like SQL Server Enterprise Manager and Query Analyzer to administer SQL Server.

Created Database Maintenance Planner for the Performance of SQL Server, which covers Database Integrity checks, Database Statistics update and Re-indexing.

Created check constraints to maintain data integrity.

Created views to facilitate easy user interface implementation, and triggers on them to facilitate consistent data entry into the database.

Created Business-Crucial stored procedures and functions to support efficient data storage and manipulation.

Worked on DTS Package, DTS Import/Export for transferring data from heterogeneous database.

Data migration (import & export/BCP) from Text to SQL Server.

Contact this candidate