Resume

Sign in

Sales Data

Location:
United States
Salary:
90 - 100k
Posted:
February 18, 2020

Contact this candidate

Resume:

Sreenivasulu Surampally

Mobile: (***) – *** **** Email ID: adbubx@r.postjobfree.com

Professional Summary:

Sreenivasulu maintains 16+ years of strong experience in Application Analysis, Design, Development, Testing and Debugging and 10+years of experience in Software Quality Assurance Testing in both Automation and Manual test of Web Based Applications and strong functional and technical expertise in various Domains & Tools including but not limited to CodedUI, UFT and Selenium. Sreenivasulu is a very good team player and adaptive in agile environments. Very good knowledge of all three layers of an application and have automated presentation, database and applications layers. Some of the key aspects that differentiates Sreenivasulu from other candidates are:

Extensively used and mastered automated testing tools like QTP/UFT, CODEDUI and Selenium for GUI testing and Functional/Regression Testing

Very good experience in design and implementation of CodedUI automation framework from scratch and Visual Studio solution setup. Experienced in designing and implementing Data Driven, Keyword Driven and Hybrid framework and Page Object Model

Experience in analysis, design, development and Creation of Test plans, Test Cases based on business, Functional and Technical requirements. Has successfully performed requirement analysis, design analysis, test execution and perform testing in maintenance and operations phase

Very good understanding of complete Software Development Life Cycle (SDLC), and Software Testing Life Cycle (STLC) and experienced in industry leading Development Methodologies such as Waterfall and Scrum (Agile)

Hands on experience with Automation Testing using Selenium Web Driver and Java as programming language. Well versed in writing test cases using element locators web driver methods, java programming features and TestNG annotations. Has familiarity with both Junit and TestNG frameworks also expertise in Cross browser Testing, Parallel testing using Selenium Grid and TestNG

Excellent understanding in using SOAP-UI Pro for testing Service Oriented Architectures (SOA) and Web Services (SOAP, WSDL).

Hands-on experience source code revision control tools GitHub, Visual Studio TFS.

Has used CI/CD tools such as Jenkins

Experienced in testing and handling different frames (frameset, Iframes) of a HTML page. Good Understanding on Selenium GUI Object and used various locators like XPath, CSS, ID, and TAGNAME to inspect the elements

.

Has very good knowledge of Section 508 and WCAG 2.0 and performed Compliance testing using Selenium IDE with Compliance Sheriff and AccVerify. Developed excel macro to compare Compliance sheriff issue with the baseline

Strong knowledge and experience in writing and executing SQL queries for database testing. Extensively involved in writing SQL, PL/SQL Stored Procedures, Functions, Packages and Triggers and Involved in query Optimization. Incorporated database technologies such as ODBC, OLEDB to interface with Oracle, MS SQL Server and MS Access for Internet/Intranet and business applications

Very Good Experience in forms Design and Development of Intranet and Internet Based Applications using VB 6.0, ADO, RDO, ASP, Visual Studio, XML, Crystal reports and Data Reports

Strong Background in Pharmacy, Manufacturing, and Finance Industry (Banking, Stock Brokerage etc.) with Fixed Income and Credit Derivatives

Requirement Analysis, Design and Development of VB forms. Strong scripting experience in .Net technology C# and VB. Generated ActiveX components in Excel to migrate data into Oracle using Excel VBA. Generated Excel and Access Macros merge Excel data with MS Excel and validate lender errors

Pennsylvania Department of Human Resources Sep ‘08 – Till Date

Deloitte LLC, Mechanicsburg, PA

Sr. Automation Tester

PA - Department of Human services offers needy citizens with different benefits like Medical Assistance, Cash, Food Stamps, Long Term Care Facility, Low Income Home Energy Assistance Programs, Home and community-based program, School meals and CHIP. Client information system which automates the process of issuing the benefits involves both the Open System and legacy to process the benefits. Processing of data collection is performed through Open systems. Eligibility determination and issuance of benefits through batches resides on both the legacy and Open systems to process different benefits.

Current incremental renewals involve modernization of the eligibility determination from legacy to open systems for some of the cash benefits, involving general assistance and temporary assistance for needy families. Modernization of issuance of some of the benefits are also moved to open systems for running of batch related programs

PPACA – The patient protection and affordable care act, commonly called “Obamacare” is the federal health care law. The implementation of ACA decreases the number of uninsured Americans and reduces overall health care costs. State of Pennsylvania successfully implemented ACA to serve the citizens of find the right insurance through state health insurance exchanges or online marketplace.

Conversion: Script conversion from QTP 11 to CodedUI scripts using Visual studio 2010/2012/2015 and C#, TFS.

Responsibilities:

Analyze General System documents, Detailed Design system documents and Visio diagrams and estimate the effort and the total number of test cases

Converted existing QTP scripts into Visual studio Coded UI(C#)

Created data driven test by using VS2010/12/15 and MTM

Created/developed Coded UI automation framework for smoke, Regression and health check testing.

Updated the test cases using TFS which acted as repository.

Identifying various Test Data scenarios and collecting the user test data for different test regions (Dev, Acceptance and QA) before the execution starts.

Logged tracked and generated bug status report using team foundation server and Microsoft test manager.

Worked closely with business analysts and the business to ensure the products meet the expected level of quality defined by the business.

Worked closely with software development team to ensure defects are fixed and incorporated into product builds.

Proficient in Preparing Test Plans, Test Scripts, Test Scenarios and Test Cases for both Manual and Automated Testing.

Involved in Perform Integration Testing between application and external application/data sources

Performed User Acceptance Testing on the application during production launch

The testing of web-based application was focused on making the application to meet all the major Business functions.

Design and develop web services for getting Client demographic information’s or eligibility information and made enhancement to the existing web services (WSDL)

Design and develop project scenarios for testing the interface batches and tested them according to the USE Cases

Performed batch validations (Like Payment batch, Corresponding notices batch ….)

Ensures test results and metrics are collected and reported.

Improved the flexibility of the tests by parameter zing the script and ran the scripts for multiple sets of data by data driving the tests using QTP/CodedUI/Selenium.

Performed end-to-end functional regression test of the complete business process.

Reported and tracked the status of the defects with the development team and coordinated with them in retesting the existing defects after the new code deploys.

Coordinates application builds and release processes with QA Manager.

Documenting test requirements, test designs and test plans (writing and reviewing of system testing documentation for technical accuracy).

Performed page accessibility testing (ADA compliance) using Compliance Sheriff as the accessibility testing tools

Developed excel macro to compare compliance sheriff issue with baseline.

Excellent understanding in using SOAP-UI Pro for testing Service Oriented Architectures (SOA) and Web Services (SOAP, WSDL).

Performed the back-end testing to ensure data consistency by writing and executing SQL queries.

Environment: QTP 11/10.5/9.5, ASP. Net, Java Script, VB Script, C#, ADO, COM, COM+ Visual Studio 2010/2012/15 – Coded UI(C#), Team Foundation Server (TFS), Compliance Sheriff, AccVerify, Eclipse, Selenium IDE, Selenium WebDriver, MTM (Microsoft test Manager), MS Excel Reports, Oracle, Section 508, WCAG 2.0.

Pennsylvania Department of Human Resources

Deloitte LLC, Camp Hill, PA

Sr. Manual/Automation Tester

PELICAN Child Care Works Subsidized Child Care Program:

Pennsylvania’s Child Care Works helps eligible working parents for assistance for child care expenses if they meet the incoming guidelines. The subsidized child care program helps low-income families pay their child care fees. The state and federal governments fund this program, which is managed by the child care information services office located across Pennsylvania

Pre-Kinder Care Data Warehouse

The implementation of Pre-K Counts data warehouse provides the headquarter users with the ability to monitor program performance and delivery of quality service to the children of Pennsylvania.

ELN Expansion MPI ID

Early Learning Network (ELN) is the office of Child Development and Early Learning’s (OCDEL) initiative to better use integrated data to improve program quality and the lives of children and families in Pennsylvania.

Responsibilities

Involved in design, development and implementation.

Performed Optimizing and Tuning of SQL Queries.

Developed MSSQL Stored procedures, Functions and triggers for data manipulation.

Design and Develop DTS packages to download the data from other system.

Involving in Performance tuning and optimization of queries.

Responsible for Creating COM+ s for Business Logic.

Developed User Interface using ASP

Responsible for coding in VB, ASP and unit testing.

Designed and developed reports with MS-Excel, Actuate Reports.

Used ADO for robustness and scalability.

Successfully implemented business logic by developing database objects such as Stored Procedures, User Defined Functions, Triggers and using T-SQL, SQL Query Analyzer and Enterprise Manager.

Migrated data from Text files to SQL Server 2005 using DTS (Import and Export Wizard)

Generated reports using Crystal Reports 8.5.

Used Visual Source Safe (VSS) as central repository.

Created ActiveX DLLS in MS Excel Macros for loading data for branding forms.

Involved in Coding, User Acceptance Testing and client support.

Responsible for creating sample data for unit testing.

Environment: QTP 9.2/9.5, VB 6.0,ASP,VBA,Java Script, VB Script ADO,COM,COM+ Visual Studio 2005,Windows 2000, SQL Server 2005, Crystal Reports 8.5,MS Excel Reports

Verizon Business,

Silver Spring MD Dec' 07 to Sep' 08

Raps (Reconciliation and abandoned property system) Server Upgrades

VB Developer/supporting

Raps upgrade re-platform project is tech refresh project the vso-it direction for the raps application is to standardize and re-platform from HP-UX/oracle to Linex /oracle this re-platform will allow the raps application to take advantage of lower cost infrastructure, address current hardware inadequacies enhance database availability while allowing for future growth which is expected

Tech Refresh/Upgrade

The current HP-UX/Windows hardware platform is ten old and old technology OS current for this project are out of support as well as database version

Cost structure

This Move will take advantage of the lower cost associated with Linux/intel-based hardware

Increased Availability

By using Oracle RAC, the raps project will enhance the availability of the database

Responsibilities

Designed & implemented the interfaces, class objects in order to use the functionality.

Developed the Business Components, Data Access Components for the front end.

Used Crystal Reports 8.0 for designing of reports and multi grouping of data at report level as per client requirement

Created ActiveX DLLS in MS Excel Macros for loading data for Branding forms.

Created weekly ad hoc Platform Admin reports and Pivot tables using Excel Macros

Generated Excel Macros merge Excel data with MS Excel and validate lender errors

Responsible for unit testing of reports developed and deployed in the production environment

Loaded Excel reports on to web using Excel XLA and Excel Add Ins with VB

Generated ActiveX components in Excel to migrate data into Oracle using Excel VBA

Environment: VB 6.0, ADO, Oracle 9i, UNIX, Mainframes, Windows 2000/XP

Ajel Technologies, NJ Jan' 07 – Nov' 07

MRP Automation Tool

Sr. Developer

This is a manufacturing resource planning tool which is organized through four forms, namely, Inquiry, order, Obsoleting and Add & remove text. The first form, Inquiry, gives information about the stock. At this stage, information like existing stock, stock inflow and outflow can be pulled out. Ordering the parts or direct order, the second form, handles procurement process like placing the orders, the third form, and obsolete form, completes the cleaning and loading process while the last one, add and Remove text, and manages titles and other text related changes

Responsibilities

Generated front end GUI for entering Branding Form Lender details using Visual Basic and Excel GUI

Created COM components and ActiveX controls in Visual Basic for Complex mortgage calculations and Branding Form Fixed Income Derivatives

Prepare test plans and documentation

Created ActiveX DLLS in MS Excel Macros for loading data for Branding forms.

Created weekly ad hoc Platform Admin reports and Pivot tables using Excel Macros

Generated Macros in Excel, VBA to automatically email large PAOTW data to lenders

Generated Excel Macros merge Excel data with MS Excel and validate lender errors

Responsible for unit testing of reports developed and deployed in the production environment

Loaded Excel reports on to web using Excel XLA and Excel Add Ins with VB

Generated ActiveX components in Excel to migrate data into Oracle using Excel VBA

Environment: VB 6.0, VBA, ADO, VB Script, Visual Studio 6.0, Mainframes, Windows 2000/XP

GE Energy, VA Oct' 05 – Sep' 06

Designated tool for the <I> to HMI CMU process for gas turbines

Sr. Developer

It involves the conversion of bin files from <I> to HMI machine-readable files (*. DM2, *.SRC files) selection of option based upon the requirement and generating the output files accordingly this tool is used to reduce the cycle time of the <I> to HMI conversion process. The process of this tool is to automate the process of generating the Demand display file from the single unit to multi-unit configuration or vice versa this tool can be used to generate the demand files by any combinations This tool will be most often used for the CU&U upgrades where <I> are running and will be converted to HMI, however it should be noted that the tool works independently without any restrictions.

Responsibilities

Responsible for gathering the requirements from the business users and prepared technical documentation.

Involved in windows coding using VB.Net and ADO.Net.

Created ActiveX DLLS in MS Excel Macros for loading data for branding forms.

Responsible for unit testing of reports developed and deployed in the production environment

Automated end reports using VBA with Excel.

Created Front end screens with user validations in Visual Basic

Involved in review meetings and preparing technical documentation for the application.

Provided production support and maintenance for the developed modules.

Environment: VB6.0, VBA, ADO, Visual Studio 6.0, SQL Server, Excel sheet Reports, MS Office Windows 2000/XP

GE IIC, India June' 05 – Sep' 05

Salem Employees Information system

VB Programmer

This project contains three forms like associate details, search ……With these forms either we get the details of the associates or we can search for any unknown information about the associate. The details form gives all the details of an associate which include official details, personal details and passport details and also about his technical skills, hardware and software details. we can trace the associates passport details such as place of issue, date of issue, valid till and onsite visiting details etc Apart from these details, also we can get the details like eligibility of the associate for onsite, existing valid visas for him

Responsibilities

Generated front end GUI for entering Branding Form Lender details using Visual Basic and Excel GUI

Created COM components and ActiveX controls in Visual Basic for Complex mortgage calculations and Branding Form Fixed Income Derivatives

Created ActiveX DLLS in MS Excel Macros for loading data for Branding forms.

Extensively used various triggers in Visual Basic to support the calculation, navigation and estimation logic in the Application.

Used ADO data objects and DAO to connect to backend from SQL Server

Automated end reports using VBA with Excel.

Generated ActiveX components in Excel to migrate data into SQL Server using Excel VBA

Develop, install and customize Microsoft Office Tools such as MS Excel as required by various departments and conduct end-user training and support.

Environment: VB 6.0, ADO, T-SQL, VB Script, MS office, MS SQL Server 2000, Windows 2000/XP

GE IIC, India Mar' 05 to May' 05

CIM compare tool

VB Programmer

This project mainly deals with the automation of pointing error that were made during configuration or date that is overlooked

This tool is developed in reference to any configuration error done while converting old dos-based system to newly developed windows based GUI systems with advanced features this tool primarily converts data an intermediate from called semicolon separated variable the conversion consider the screen folder capture the required data about each object and then writes to text file separated semicolon.

Finally, this tool takes the intermediate file as one input and a standard excel file as other input and compare two out all the mismatches to a log file it also takes into account the data that was not all configured or configured extra considering the stranded excel files

Responsibilities

Involved in Designing of front-end, Coding and Testing.

Involved in developing reports.

Developed user-friendly forms for data entry using Visual Basic 6.0

Designing database tables with appropriate constraints.

Environment: VB 6.0, VBA, Windows 95/NT.

Suganya Pharmacy, India April' 04 – Feb' 05

VB Programmer

This project is developed for suganya pharmacy to computerize their daily transaction this system automates the transitions at both inventory and sale levels the company’s transactions include sales order from customer, purchase from C&F Agents and sales to various customers the systems prepares invoice cum delivery challan and maintain sales and purchase this system maintains area products customers and suppliers information.

Responsibilities

Involved in Designing of front-end, Coding and Testing.

Involved in developing reports.

Developed user-friendly forms for data entry using Visual Basic 6.0

Involved in creation of tables, writing stored procedures, Triggers, PL/SQL packages.

Establishing database connections using ADO controls.

Involved In Developing Active-X Control.

Environment: VB 6.0, Oracle 8i, Windows 95/NT.

Vantech Chemicals, India Aug' 03 – Mar' 04

VB Developer

The Main Objectives of this Client Server Project are to fully computerize the Purchase Production, Inventory and Sales transactions. The System is used to automate the operations carried out on day to day basis at their Depots. This would include order Processing, finished goods processing, sales invoice processing, and to generate various varieties of reports for sales and stock transfer note analysis. The system deals with different types of Sales: Stock transfer, Direct Sales, Branch Sales, Export Sales and Second Sales.

Responsibilities

Responsibility of Requirement gathering, Analysis, Coding, Implementation and unit testing

Involved in the development of sales and Accounting modules.

Developed Invoices, Sales order, Sales Returns, Receipts, Vouchers, Journal noting and credit note.

Developed reports for Trial balance, Cash book, Invoices, Sales Orders

Environment: VB 6.0, ADO, Oracle 8i, Windows 95/98/NT.

Educational summary:

Master of computer application (MCA), Osmania University, INDIA

Bachelors of Science in Computer, Osmania University, INDIA



Contact this candidate