Post Job Free

Resume

Sign in

Test Cases Sql Server

Location:
Fairfax, VA
Posted:
April 02, 2018

Contact this candidate

Resume:

Sushmitha Reddy

ac4z9u@r.postjobfree.com

PROFESSIONAL SUMMARY

Overall 6+ years of IT experience including 2 years of RPA Process implementation using Blue Prism UI Path and Automation Anywhere.

Used process, objects, work queues, calculations stages to perform logical operations in Blue Prism.

Automated numerous routine tasks using Automation Anywhere, Blue Prism, and UI Path thereby reducing manual intervention.

Working on Queue Configurations, Monitoring, Internal Blue Prism Work Queue Actions, Exception handling, efficient use of stages, blocks, data types, session and environmental variables for processing of Business Process diagrams and Process flow charts using RPA tools.

Created, developed and maintained automated MI Reporting of Blue Prism processes in MS Access and Excel, also involved in running this in MS SQL Server using MS Access front-end and managing robot's workloads using Blue Prism Work Queues

Strong knowledge and experience in .Net, SQL Server, RPA, and Design patterns with proven abilities in the Software Development Life Cycle (SDLC).

Experience working on Waterfall and Agile Methodologies - Scrum.

Extensive experience in developing large-scale, performance critical applications using Microsoft Technologies like Visual Studio.Net, VB.NET, ASP.NET, Windows, C#.NET, MVC 4/5, WPF, WWF, Sync Framework 2.0, ADO.Net, Entity Framework, with SQL Server 2012, MS Access and Oracle 10g as databases.

Has very strong background in a disciplined Software Development Life Cycle (SDLC) process and has excellent analytical, programming and problem-solving skills.

Proficient in developing applications using Object Oriented (OOP's) programming concepts.

Installed and Expertise in Blue prism V5, V4.2 Enterprise Edition and Automation Anywhere, UI Path studio.

Involved in the Analysis, design, testing and Implementation of Business Intelligence (Business Objects) solutions using Data Warehouse/Data Mart Design, ETL, OLAP, Client/Server applications.

Worked with different querying tools like SQL Assistant, TOAD, and Oracle SQL Developer.

Implemented various Test cases for the Functional Testing, smoke testing, re-testing, Regression Testing, Configuration Testing, Performance Testing, Back-End and User Acceptance testing (UAT).

TECHINICAL SKILLS:

RPA Tools

Blue Prism V4.2, 5.0, UiPath, Automation Anywhere 9.0

Databases

SQL, PL/SQL, SSIS, MS-SQL Server, 2008, 2012, MS- Access, DB2, oracle 10G / 9i, MS-Excel

Methodologies

Waterfall, Agile, Scrum

Web Technologies

ASP, XML, JSON, DHTML, HTML, XHTML, CSS, XSLT, AJAX,VB Script, JavaScript, JQuery, Angular JS, Web Services (SOAP and WSDL).

Languages

Apex, Java, Java Script# and VB6.0, VBScript, UML, HTML, XML, XHTML, DHTML, SQL.

Operating Systems

Windows XP/7/8/10, UNIX/LINUX

EDUCATION:

Bachelor’s in computer science, Jawaharlal Nehru Technological University, Hyderabad 2011

Master’s in information systems, Virginia International University 2017

PROFESSIONAL EXPERIENCE

Fannie Mae – RPA Developer (Blue Prism / UI Path)

Herndon, VA Sep 2016 to Feb 2018

Roles & Responsibilities:

Involved in End to End development of Business Process using Robotic Process Automation.

Performed requirement analysis by gathering both functional and non-functional requirements based on interactions with process owners, stakeholders, and designing, Coding, Testing, Debugging, Documentation and Implementation of Business Process Solutions.

Using Excel VBO object to perform operations in excel sheet while taking excel sheet data as input.

Used process, objects, work queues, calculations stages to perform logical operations in Blue Prism.

Supporting existing processes and implementing change requirements as part of a structured change control process.

Interacting with windows application and created object and interacted all the objects in process studio and created work queues and running processes.

Worked on different adapters like Application and Web to login to websites, searching in website, submitting web forms, or updating records on a website.

Well Versed with UIpath studio, UIpath robot, UIpath Orachestrator.

Created database connections using connect activity and .net framework Data Provider to fetch the data and automated the process to arrange data with UiPath.

Created POC's using Blue prism and UIpath for tool comparison.

Used in various actions like Conditions and Loops, User prompts, Error Logging and commands like Object Cloning, OCR, Key Strokes etc., for coding the automation process.

Communicating with Blue Prism on software related issues, suggested improvements and participating with other users in the Blue Prism community.

Worked on Integrating applications like (Web, Services, MS Office, GUI, Outlook etc.) using workflow, automation tools (Blue Prism).

Environment: RPA, Blue Prism V4.2, V5.0, UiPath, Windows, .NET, VBA, HTML, XML, CSS, JavaScript, Bootstrap, SQL Server 2012, Visual Studio.

Evolent health care – RPA Developer (AA, Blue Prism)

Arlington, VA Jan 2016 to AUG 2016

Roles & Responsibilities:

Developed the object and workflow for client requirement.

Designed the workflow documents and allocates the objects to automation developers.

Actively participated in Test plan preparation, validated the Client requirements and identified the various Scenarios for Automation Development.

Developed and configured automation processes as per the technical design document (TDD) to meet the defined requirements.

Participate in RPA deployment into production and support production issues

Developed robotic bots using automation anywhere to automate process which was done using manual interference.

Data Extraction using Automation Anywhere.

Worked on Automating Web portal, Excel, PDF, TXT and Email automations.

Gather and understand the requirements, build the work flow process and create Mapping documents for flows of the application.

Performed task scheduling using Automation Anywhere like Schedule Manager, Task Editor, Data Drive Tasking.

Business process were reviewed and issues were fixed using UI path.

Supported Business users during UAT and Demo the RPA process for each component.

Developed robots using Automation Anywhere

Utilized the BOT framework and contribute towards enhancing it.

Coded error handlers to catch and log errors.

Extensively worked with commands like object cloning, web recorder; Terminal Emulator.

Setup bots in the Control room.

Environment: ASP.Net, C#, Automation Anywhere 9.0, UI path, Internet explorer PDF Converter, .NET, OCR, MS-Excel, HTML, Internet B, Perl, WPS

Dr.Reddy's Laboratories - Manual Tester

Hyderabad, India Jan 2015 to Nov 2015

Roles & Responsibilities:

Understanding the business requirements and develop test cases to test the complete functionality of the application.

Maintain Traceability Matrix to ensure all conditions are covered in the Test Cases.

Executed Test cases and analyze the test results.

Responsible for performing Ad-hoc, Sanity testing, Functional testing and Regression testing.

Coordinating with onsite persons regarding documents, requirements and discussions about the functionality.

Analyzed test specifications and converted them into Manual Test Cases.

Performed regression testing for each new built.

Involved as part of automation team using QTP, developed test scripts.

Used Quality Center to analyze and maintain test cases, which satisfy both Verification and Validation and Track bugs.

Environment: Quality Center, Manual Testing, Selenium, JAVA, QTP, UNIX, SQL Server 2012, Power Builder, Windows, MS-Excel.

Satyam India, Client: - New York Life Insurance - Manual Tester

Hyderabad, India Nov 2013 to Dec 2014

Roles & Responsibilities:

Involved in White Box, Black Box, Functionality, and User Acceptance Testing.

Generation of test data for execution of Test cases.

Generate test records, modify scripts to do regression test.

Developed and submitted viable test plans to test accuracy of data conversion.

Developed SQL scripts and stored procedures, triggers, views and tables using PL/SQL..

Actively attend meetings with fellow testers and other groups to evaluate the progress and Performance of the application.

Well versed with complete life cycle of Manual Testing process with both Agile methodology.

Experience in leading a Manual Testing assignment and successfully tracked progress of Manual testing effort

Used Quality Centre for preparing the Test Plans, manual Test scripts and defect Tracking and defect reporting

Created data driven script to be used with various data / test cases for positive and negative testing of the application

Tested the ETL (SSIS) mappings and other ETL Processes (DW Testing) using Microsoft Visual Studio

Involved in Identifying business requirements, Test Planning, designing test cases and test data, Test execution and bug reporting, Summarizing reports and Test closure

Performed Production Validation Testing, Source to Target Testing, Application Upgrade, Data Completeness Testing Data Transformation Testing, Data Completeness Test

Environment: Oracle 9i, HTML, Quality Center, Manual testing, SQL, PL/SQL, Agile, SSIS (ETL), Microsoft Visual Studio.

Satyam India, Client: - COX Denver, CO -Manual Tester

Hyderabad, India Sep 2011 to Oct 2013

Roles & Responsibilities:

Manually perform Functional testing that includes Security, System testing, Smoke testing and Back-end testing.

Reviewed the Test Cases written for Unit and Integration level.

Created and executed automated software test plans, cases & scripts and performed manual testing.

Project is developed using Waterfall Methodology.

Involved in preparing the Test Plan and Test Cases based on the business and functional specifications.

Coordinated and worked closely with business analysts and stake holders during gathering requirements for the product and documented test cases.

Reviewed database test cases per assigned requirements to validate reports by retrieving data with complex SQL queries from SQL Server.

Worked on SQL statements in checking the validity of the Backend.

Expertise of testing the application developed using various mobile technologies including J2ME, Blackberry, Android, Symbian, .Net Technology etc.

Attended Weekly Status Meetings, discussed and interacted with team members.

Performed End to End Testing and involved in User Acceptance Testing.

Used Quality Center (HP QC) as a bug tracking tool.

Environment: Manual testing, Quality Center, JAVA, XML, HTML, MS SQL Server 2008, SQL, Android, UNIX and Windows.



Contact this candidate