Test Cases Data
Resume:
Priyatham Jakkula
Kansas City,MO
acz6kx@r.postjobfree.com
PROFEESIONAL SUMMARY:
Around 7 Years of experience in Performance Testing, Stress Testing, Load Testing, Functionality Testing, Integration Testing, System Testing, Regression Testing.
Created and Published Test Cases, Test Plans, Automated and Manual Test Scripts,
Test Metrics, Defect Reports and Test Results.
Experienced in identifying scenarios, analyzing large data, creating test data, maintaining test cases, developing automation test scripts, performance testing, manual test execution and presenting test results.
Created and Published Test Cases, Test Plans, Automated and Manual Test Scripts, Test Metrics, Defect Reports and Test Results.
Performed data centric backend testing of applications using UNIX and SQL scripts.
Experience in UNIX Shell Programming for scheduling, file manipulation etc.
Involved conducting usability sessions on the existing version of the intranet and testing the existing enterprise portal design or website.
Working experience in Microsoft SQL Server Reporting Services (SSRS), Microsoft SQL Server Analysis Services (SSAS) and Integration Services (SSIS).
Experienced in testing requirements that were developed in ETL and BI tools and reviewed scripts for positive and negative test scenarios, and prepared test summary reports.
Skilled in utilizing Test Automation and Test Management tools such as QTP, Win Runner, Load Runner, Test Director and Quality Center (QC) and experienced in performing White Box&Black Box Testing.
Good experience in performing and supporting Unit testing, System Integration testing, UAT and production support for issues raised by application users.
Experience in Data Warehousing/ ETL Testing within the environment of Oracle, SQL Server, and Informatics Power Center, Power art (Repository Manager, Server manager, and Mapping Designer, Mapplet Designer, Transformation Developer and Warehouse designer).
Experience mostly involved in ETL design & development using MSBI suit SSIS, SSRS & SSAS, Informatica Power Center.
Good understanding of business intelligence concepts and concepts related to reporting tools such as SSRS, WebFOCUS and Tableau.
Experienced in identifying scenarios, analyzing large data, creating test data, maintaining test cases, developing automation test scripts, performance testing, manual test execution and presenting test results.
Experienced in Functional, Integration, Regression, System and Performance Testing
Experience in working with Siemens Soarian Financials.
Provided expertise in Software Configuration Management (SCM) practices to manage software builds (internal or external) and releases using VSS.
Excellent T-SQL development skills to write complex queries involving multiple tables, great ability to develop and maintain stored procedures, triggers, user defined functions.
Experience in QA and Manual Testing in Mobile handset and GSM/GPRS/3G/CDMA WAP Applications.
Experience with unit testing, Integration testing and system testing for iphone.
EDUCATION:
B.Tech in Computer Science.
Technical SKILLS:
Operating systems
Win 95, 98, 2000, XP,NT, Sun Solaris, AS 400, VSAM,MS-DOS,UNIX
Languages
C, C++, HTML, DHTML, XML,ASP.NET
Testing Tools
Load Runner, Winrunner Rational Clear Quest, QTP, Selenium WebDriver, TestNG, Selenium IDE.
Test Management Tools
HP Quality Center, Rational Test Manager, PVCS Tracker
Databases
SQL Server, Oracle, Sybase, DB2UDB, PL/SQL, Oracle 8.x,9.x,10.x, DB2, SQL Server, Ms Access
Web/App Servers
Apache, Web Logic, Web Sphere and IIS
Scripting
VBScript, JavaScript, ShellScript, VuGen Scripting
Others
Shell Scripts, MS Office, TOAD.
PROFESSIONAL EXPERIENCE:
Client: BlueCross BlueShield April 2016 – Till Date
Location: Kansas City, MO
Role: QA/ETL Tester
Responsibilities:
Responsible for creating complete test cases, test plans, test data, and reporting status ensuring accurate coverage of requirements and business processes.
Worked with Business Analysts to define testing requirements to satisfy the business objectives.
Tested the ETL Informatica mappings and other ETL Processes (Data Warehouse Testing).
Experience in SDLC and Agile methodologies such as SCRUM.
Gathering business requirements from the Business team and generating system workflows Involved in creating the targeted questionnaire for SMEs and Business users for elaborating requirements.
Preparing Test Strategy, developing Test Plan, Detailed Test Cases, writing Test Scripts by decomposing Business Requirements, and developing Test Scenarios to support quality deliverables.
Expertise in Data Warehouse, ETL Verification, BI reports.
Experience in working with Software Development team in resolving Defects, presenting the Defect Status reports, resolving requirement, and observed design inconsistencies.
Involving in Functional Testing & Regression Testing.
Creating test cases for ETL mappings and design documents for production support.
Developed SQL queries /scripts to validate the data such as checking duplicates, null values, truncated values and ensuring correct data aggregations.
Performed Count Validation, Dimensional Analysis, Statistical Analysis and Data Quality Validation in Data Migration.
Created Datastage jobs using different stages like Transformer, Aggregator, Sort, Join, Merge, Lookup, Data Set, Funnel, Remove Duplicates, Copy, Modify, Filter, Change Data Capture, Change Apply, Sample, Surrogate Key, Column Generator, Row Generator, Etc.
Used the DataStage Designer to develop processes for extracting, cleansing, transforming, integrating and loading data into staging tables.
Extensively involved in testing Facets Member/Subscriber, Billing, Medical Plan, Dental Plan modules.
Extensive SQL querying on Staging, Datawarehouse andDataMarts.
Prepared daily status reports with details of executed, passed, and failed test cases and defect status.
Excellent Knowledge in Ms-Office (Word, Excel, PowerPoint), Ms-Access, MS Visio.
Worked on projects independently and also managed a Facets testing effort.
System Integration testing for Facets core modules with external systems.
Tested Subscribers/Providers and claims in Facets.
As a QA Tester for BCBS of KS, Involved in testing Facets / Membership and Claims applications.
Involved in loading data to staging area and into Warehouse tables using SQL Loader.
Experience in Data Analysis, Data Validation, Data Cleansing, Data Verification and identifying data mismatch.
Understands data models and excels at transformations.
Extensively tested several MicroStrategy Reports for data quality, fonts, headers, footers, and cosmetics.
Involved in testing Facets for Group Information, Enrolling Subscribers, adding members, Related Entities, Class/Plan definition, Premium Rate Tables and all.
Executed test cases and test scripts for manual and automation testing. Defects are raised in the HP Quality Center/HP ALM for logging, tracking and reporting bugs in the application.
Validated XML files that was sent from blueshield to benfitfocus.
Validated EDI files from benfitfocus to blueshield for the membership data.
Performed adjudication of Medical and Hospital claims for Network Rules testing to validate members get correct benefit for in Network and Out of network with the Plan Network set and correct Provider.
Create PCP claims to validate the members get correct benefits in In-Network and Out of Network with network rules apply.
Managed multiple migration projects switching BI technologies to improve efficiencies and
increase cost savings. Business Objects, WebFocus, MSBI, Tableau are some of the BI tools we use.
Uploading applications to handsets using Mac mini- configuration utility for Native. App can be accessed on Mobile, Mobile browser and web browser.
Worked on Android, Windows Mobile platforms to qualify applications.
Performed functional testing of individual modules (Accounts, Trading, Quotes and More) of the Application on iOS, Android.
Tested the Network, Network area, Network group in Facets.
Environment: MS SQL Server 2005/2008,MS Access, Word, PPT, Excel and Visio,FACETS 4.31/4.51, HP Quality Center, QTP.
Client: Worthington Industries Nov 2015 – March 2016
Location: Columbus, Ohio
Role: QA/Automation Tester
Description: Worthington Industries is a global diversified metals manufacturing company with 2013 fiscal year sales of $2.6 billion. The Ohio based company is a steel processor and manufacturer of pressure cylinder, such as propane, oxygen and helium tanks, hand torches, refrigerant and industrial cylinders, camping cylinders, exploration, recovery and production products for global energy markets; scuba tanks, and compressed natural gas storage cylinders; custom-engineered open and enclosed cabs and operator stations for heavy mobile equipment; framing systems for mid-rise buildings; steel pallets and racks for shipping. In addition to its three primary business units (steel processing, pressure cylinders and engineered cabs), the company’s approximately 10 joint ventures also focus on metals-related markets.
Responsibilities:
Responsible for creating Test Plans based on Functionality and Business rules, generated Test Cases and reported bugs using Quality Center and executed Test Scripts in QTP.
Responsible for back-end testing/database testing, which was done using SQL queries.
Closely working with dev team to get the issues\bugs resolved and Performance testing for I-phone Applications.
QA team to create test data, test cases and provide test strategy and transactions.
Provide Test Plan, Defect reports and QA status.
Involved in Performing Back-End Testing by writing SQL queries to extract the data from database.
Responsible for production Defects tracking, reviewing and working with various teams for setting up roadmap for the defect fixing.
Interacted with customers and managers for enhancements and providing QA estimates and results.
Tracked software bugs using Quality Center and communicated the same to developers to resolve technical issues.
Worked on the performance tuning of the MicroStrategy reports.
Performed Data Driven Tests to validate the same scenario with different test data using Quick Test Professional.
Created SSRS Report Model Projects in MSBI studio and created, modified and managed various.
Tested the application on I Phone when the operating system was unveiled and made sure the application was enhanced to be compatible with the Android devices.
Used Master Data Management (MDM) technology, tools to create and maintain consistent and accurate lists of Master.
Designed, developed and executed Quick Test Pro scripts for Functional, Regression Testing, and callable scripts.
Conducted appropriate requirement analysis, documentation and communication so that risks could easily be identified and monitored.
Identified Real World Scenarios and Day in Life Performance Tests.
Wrote complex queries in Teradata SQL assistant to check the data from Source and Target.
Performed functional testing byexecuting the QTP Scripts from Test Director. Used Python to launch QTP scripts from command line for continuous integration testing.
Performed Black Box,White Box, Performance testing, Regression, and Validation testing during the testing life cycle of the product release.
Executed test cases and test scripts for manual and automation testing. Defects are raised in the HP Quality Center/HP ALM for logging, tracking and reporting bugs in the application.
Configured Selenium WebDriver, Testing, Maven tool and created selenium automation scripts in java using testing prior to agile release.
Developed and Implemented automation using Selenium WebDriver and Java. Used Eclipse IDE to develop & debug the code.
Involved in troubleshooting MicroStrategy Prompts, Filters, Templates, Consolidations, and Custom groups in an enterprise data warehouse team environment.
Developed test scripts for mobile applications on Android, Apple, BREW, RIM & WinM platforms using Device Anywhere.
Configured Selenium WebDriver, TestNG, Maven tool and created selenium automation scripts in java using TestNG prior to agile release.
Actively involved in QA Testing (UI and API), and collaborating with off-shore QA personnel on current projects and documenting and reporting defects and test results in JIRA.
Environment: Automation Testing, Quality,Center 8.0, Oracle, Java Script, Agile/Scrum, JIRA, Windows XP/2000, UNIX, Linux, Visual Studio, Windows Server 2003 and XML, XAML, HTML, SQL server.
Client: Fifth Third bank Feb 2015-October 2015
Location: Cincinnati, Ohio
Role:QA/ETL Tester
Responsibilities:
Interaction with Users to understand the business requirements and prepare Business Requirement Document.
Test plan, Test case preparation and building Requirement Traceability matrix.
Monitored the autologs and session logs through Informatica DVO Workflow Monitor and tested the ETL Informatica mappings and other ETL processes.
Attended IT Lunch and Learn Meetings for various topics like HLA, Big Data.
Create new SSIS packages to ETL data from Salesforce to SQL Server and vice versa.
Validation of saving the new securities and new contracts for Options and futures to Golden copy.
Verification SAC specific SECCODE for the new securities while saving to GC.
Validation of posting securities to downstream applications Pane and Geneva.
Tested Complex Reports in OBIEE functionalities like Slice and Dice Drill down Functions Cross Tabs Master/Detail and Formulae.
Estimated the time taken for the workflows to be migrated from the Informatica to the DMExpress.
Executed the workflows as batches of DMExpress through Informatica server.
Develop parameter driven ETL process to map source systems to target data warehouse with Informatica complete source system profiling.
MSBI, collected update telemetry data, filtered and created report for management.
Extensively involved in testing PL/SQL stored procedures in Netezza database.
Experienced in creating and maintaining detailed Test Plans in “Quality Center” and establishing Mapping between Requirements, Test Cases and Defects.
Processed a query to update a field in an Oracle database, to ensure that debt payments are allocated.
Testing of the chat conversations, Send Receive Picture messages, MMS, sending sms from the chat, calling from the conversation.
Comprehensive knowledge of ERP software, testing process, and techniques.
Experience testing distributed systems, including testing on the Hadoop platform and user-level Hadoop configuration and administration skills.
Defects were tracked, reviewed, analyzed and compared using Quality Center.
Validation of data loaded in Microsoft Enterprise Cache and expiration of the cache.
Performed Data Analysis and developed Data Mapping documents for ETL (SSIS) projects.
Expertise in Data Warehouse, ETL Verification, BI reports.
Worked on Testing of City for Citi Payment Web Application which uses Restful Web services, XML, DOM, JSON and AJAX features.
Created recurring SSIS Jobs and scheduled Packages using SQL Server Management Studio for the Load.
Extensively worked with backend activities for testing several reports developed by BI tools. Written several complex SQL queries.
Teradata SQL Conversion to Hadoop and Data validation .
Worked on the performance tuning of the MicroStrategy reports.
Writing complex SQL queries for data validation for verifying the SSIS Packages and SSRS for reporting.
Developed SQL Queries/Scripts and similar Artifacts to validate the Completeness, Integrity and Accuracy of Data within an ETL process testing cycle.
Hands on built four environments including development testing staging and production using Aqualogic Enterprise Security/Oracle Entitlement Server ALES/OES 10g for entitlements.
Experience in ETL methodology for supporting Data Extraction, Transformations and Loading process in a corporate-wide-ETL solution using Informatica& SQL Server Integration Services (SSIS 2005,2008,2008R2).
Generated periodic reports based on the statistical analysis of the data from various time frame and division using SQL Server Reporting Services (SSRS).
Developed multiple Map Reduce programs for analyzing the insurance data of the customer and produce summary results from Hadoop to downstream systems.
Involved in running Hadoop jobs for processing millions of records of text data.
Experience in Testing BI applications using OBIEE, SSRS.
Designed and developed test scripts for manual testing of the entire module.
Created manual Test Cases in HP QC/HP ALM for various User Stories based on Release and Sprint Plan.
Created design and implementation artifacts using Oracle Entitlement Server 10g.
Responsible for generating Financial Business Reports using SAS Business Intelligence tools (SAS/BI) and also developed ad-hoc reports using SAS Enterprise Guide.
Wrote SAS programs in UNIX platform.
Created some macros in Teradata to load the test data in to Target tables.
Monitored test scripts and status using Rational Functional Tester and Manual.
Environment:VBScript, DMExpress -6.5 6.9,Shell Script, Oracle EBS R12, HP Quality Center,Crystal Reports, Quality Center, Excel, SSIS, SSRS, Access, Windows Server 2003, T-SQL,UNIX and Linux.
Client: Healthcare Reforms (HCR) Sep 2014 - Jan 2015
Location: Walnut creek, CA.
Role: ETL Tester
Description: Health Care Reforms (HCR) is the project related to Patient Protection and Affordable Care Act (PPACA) which aims primarily for Access, Quality and Cost. Under this act, the way how Healthcare is delivered and paid for is completely regulated. This increased the federal government role in all aspects of healthcare system. Blue Shield of California offers HCR plans. As part of HCR project, plans are being developed for implementing of HCR line of Business in the Shield Advance solution and the associated Business Readiness activities. This project is delivered successfully. As some requirement changes and new requirements are needed for HCR plans implementation in different modules. HCR Stabilization project is to implement the changes to HCR project.
Responsibilities:
Involved in design and development of test plans based on high-level and detailed designs and analyzing business requirements.
Used informatica DVO to do data validation to count in huge number of source and target to perform the unit testing.
Provided Production support to Tableau users and Wrote Custom SQL to support business requirements.
Traveling throughout regional offices to provide support and training to end users as an SME (Subject Matter Expert) in Claims processing & management, mentored & trained entry levels.
Conducted extensive analysis on migration and conversion of Provider and Member data, Group configurations, plan codes, benefit set-ups, fee schedules, provider pricing, capitation set-ups, etc from Legacy system (Amysis) to FACETS (Client Server based system).
Worked on facts, attributes, hierarchies, reports, filters, metrics and templates using MicroStrategy Desktop and Architect and added them to MicroStrategy Project which was created using Project Builder.
Extensively developed SQL scripts on Oracle for validating test cases.
Performed other ERP testing related tasks as assigned.
Validated each and every Business Logic incorporated in Target state Data Warehouse (Teradata) when the scheduled job is completed.
Involved in doing manual testing and created test data for functional testing
Performed Functional, Smoke, End-to-end and User acceptance testing.
Involved in validating various SSIS and SSRS packages according to functional requirements.
Experienced in data analysis using SQL, PL/SQL and many other queries based applications.
Extensively used ETL to load data from Flat files to Oracle.
Did theforward and backward data mappingbetween the fields in mainframe and FACETS.
Tested the Integration between different applications and Reported software defects in Quality Center.
Worked closely with the developers to resolve technical issues (bugs).
Extensively worked withNestezzadatabase to implement data cleanup, performance tuning techniques.
Coordinated, tested and validated Soarian’s latest product releases.
Tested the reports using SSRS reports.
Executed test cases and test scripts for manual and automation testing. Defects are raised in the HP Quality Center/HP ALM for logging, tracking and reporting bugs in the application.
Experience in Bug Tracking and Reporting using Test Director/ HP Quality Center.
Hands on knowledge of Soarian inpatient and outpatient orders application with implementation experience.
Involved in the team meetings to discuss the issues and problems.
Generated reports using SSRS. Identified the Data Source and defined them to build the Data Source Views.
Strong knowledge of Performance Testing, Regression Testing Adhoc Testing, and Integration testing.
Tested customized and OBIEE reports with Metrics and Filters for Business analysis using Desktop intelligence with features of Drilling options [drill up, drill down and drill anywhere].
Reviewed the application’s Specifications, and then built test cases for system testing
Environment: Siemens Soarian Financials, Oracle, HP QTP 10.x,MS SQL Server,Soarian Clinical, Quality Center, Toad, Java, Manual Testing, Windows NT and MS Office Products, Netezza4.x, OBIEE 10.1.3, T-SQL, SSIS, SSRS.
Client: Humana June 2013 - August 2014
Location: Louisville, KY
Role:QA/ETL Tester
Responsibilities:
Interaction with Users to understand the business requirements and prepare Business Requirement Document.
Test plan, Test case preparation and building Requirement Traceability matrix.\
Responsible for Extraction, Transformation, Loading (ETL) data from various sources into various targets using Informatics Power Center (Repository Manager, Designer, Workflow Manager).
Validation of the ETL process which process maintenance files from Bloomberg and Reuters and save the changes to Vendor copy.
Responsible for interaction with business stake holders, gathering requirements and managing the delivery, covering the entire Tableau development life cycle.
Developed and Tested Various Reusable ETL Transformations which facilitate Daily, Weekly & Monthly Loading of Data.
Wrote complex SQL to validate the Data with legacy Reports in Oracle and Teradata environment.
Tested data models and data maps (extract, transform and load analysis - ETL analysis) of the Data Mart's and feeder systems in the aggregation effort.
Experience in creating UNIX scripts for file transfer and file manipulation.
Wrote data conversion and data migration scripts for ETL process.
Worked on FACETS Data tables and created audit reports using queries. Manually loaded data in FACETS and have good knowledge on FACETS business rules.
Automation of posting Options from Paladyne to downstream application, when new contracts are traded
Validation of all processes that are retrieving data from Bloomberg terminal, as they are being changed to retrieve data from Back office files and PerSecurity.
Validation of data loaded in Microsoft Enterprise Cache and expiration of the cache
Bugs are reported through SAC JIRA tool.
Managed enterprise resource planning software for HRMS.
Used Toad and SQL Plus for testing execution of ETL Processes' PL/SQL procedures, packages for business rules.
Create shell scripts to run Data Stage jobs.
Defect prevention,productivity improvement and knowledge management activities
Preparing metrics and reports
Environment: UNIX, ShellScript, CSS, AJAX, SOAP, XML, Quality Center, QTP, LoadRunner, IIS, Excel, Access, UML on Windows Server 2003 and UNIX.
Client: Godrej & Boyce Mfg Co Ltd Jan 2010 - May 2013
Location: India
Role: Manual Tester
Description: Godrej, a prestigious company, is mainly a consumer goods manufacturing company. Being such a large company, it had a very large customer database. Maintenance of an inventory system covering purchases requests, purchase orders, Goods Received Notes, returns, Stock Maintenance of raw materials, packing materials and miscellaneous.
Responsibilities:
Performed GUI Testing of the Web-application using Win Runner Web test add-in on Windows platform.
Performed Manual Testing of the web application on Solaris/Unix Platforms.
Developed Test Plans and Test Cases.
Documented the Test cases, Test results and Test procedure.
Performed in both Manual and Automated testing using LoadRunner.
Used Test Director for Manual Testing.
Implementing Regression tests for every modified build.
Interacted with end users to obtain specific system requirements and for User Acceptance Tests (UAT).
Defects are managed in Clear Quest.
Involved in configuring new versions in Clear case.
Performed Positive and Negative Testing.
Reported the defects to Developers using Test Director.
Participated in Walkthroughs and Defect report meetings periodically.
Conducted Distributed and Multi-User Testing.
Tracked the issues Build, versions management by using VSS.
Summarize Detail Test Reports with error logs and send them to developers.
Work closely with developers and other staff members to form a unified team.
Environment: Agile Methodology, Mainframes OS 390, UNIX (Sun Solaris), SQL Server, Oracle, .net framework 2.0, asp.net, vb.net, c#, JavaScript, VBScript, Visual Source Safe, Test Director, WinRunner, LoadRunner.
Contact this candidate