Data Test Cases

BALRAJ ALLADI

Cell:732-***-****

SUMMARY

**+ years of experience in IT as a QA Tester/Analyst with expertise in Testing, Business Analysis, Coding, and Implementation of Data warehouse, Financial Reporting, Client\Server, UNIX and Web based applications.

Experience in Financial, Healthcare and Telecommunication applications.

Expertise in Functional, Acceptance, Interface, Performance, Load, Integration, Regression, Black Box, White Box, UAT testing.

Strong working knowledge in UNIX, Java, J2EE, SSH Client, FileZilla, Putty, Toad, PL/SQL, SQL Server, SOAP, XMLs, WSDLs, DB2, Teradata, Oracle and Essbase Cubes.

Possess sound understanding of full Software development lifecycle, including designing, developing and implementing test plans, test cases and test processes fueling swift corrective actions, significant cost savings and fault-free audits.

Expertise in Data Warehousing Concepts and Dimensional Modeling (Star schema & Snowflake schema).

Expert in developing test plans for Business Intelligence environment, Hyperion Essbase and Data Warehousing.

A team player with good inter-personal communication skills and excellent documentation skills.

Experience in Scripting, Data Validation, Defect/Bug Tracking, Testing Automation.

Deft at conducting Functional Requirement Gathering, Test Strategies and Coverage’s as well as Feasibility Study / Impact Analysis; Gained expertise in preparing Automated Tests within the keyword driven automation framework.

Possess sound understanding of various QA & QC standards; Adept at conducting Backend / Web Services / Database Testing, Functional/Load/Stress Testing as well as Manual /Regression Testing.

An effective leader with proven abilities in leading, building teams during the project phase, training & guiding team members and enabling knowledge sharing among the team.

EDUCATION

Bachelors in Science (BS) from Osmania University, Hyderabad

HDSM (Higher Diploma in Software Management) from Aptech

CERTIFICATIONS & TRAINING

CIC (Certificate in Computing) from IGNOU.

SKILLS

Automation Tools

Mercury Interactive Win Runner, Quick Test Pro (QTP), Silk Test tool, Load Runner, Selenium Webdriver, Junit.

Change Management Tools

Test Director, Quality Center HP/ALM, Rational Clear Quest.

Configuration Management Tools

Concurrent Version System (CVS), TFS, Accurev, Perforce

Languages

SQLPlus, SQL, PL/SQL,VB, Bash/Ksh, Java

Web Technology

WebLogic, Apache, Tomcat, JDK, J2EE, HTML, DHTML, XML, SOAP, WSDL, HTTP, HTTPS

RDBMS

Oracle 11G, 10 and9, SQL Server, Teradata, MS Access, DB2

ETL

Informatica Power center, SSIS

Software Packages

TOAD, SQL Assistant, SQL Developer, SoapUI, MS Office, MS Project,

Database schemas

Star – Schema, Snow Flake Schema, Fact Constellation

OLAP

Hyperion (Versions 9 and 11) Reports, Hyperion Analyzer, Hyperion SmartView, Hyperion Financial Reporting, Hyperion Workspace, Hyperion Excel Add-in, Business Objects, SSRS, Essbase Cubes.

Defect tracking Tools

MS TFS, JIRA, Dev-track, VersionOne and Rational Clear Quest

Environment

MS Windows NT, XP, Unix (Linux and Solaris)

EXPERIENCE

PaySpan®, Inc, Atlanta, GA Jun 2017 to Present

Test Analyst III

Patients to conveniently make payments using Portal/Mobile applications.

Payspan’s Online Bill Pay solution allows Providers patients to conveniently make payments to their practice any time from any device. Enable patients to make online credit, debit, eCheck and HSA/FSA payments without account enrollment from any device 24/7.

Responsible for Validating functional requirements to support new/changed functionality and worked with stakeholders to obtain signoff.

Managed defects and by working with development team to provide resolutions.

Participated in Agile development processes and focused on automated regression testing to support software quality efforts.

Complies with various process controls throughout the SDLC.

Supports other teams in understanding integration and user functionality.

Supports the production release process, which includes the ability to work extended hours occasionally.

Played an integral role in the entire software development lifecycle including participation in design sessions, defining functional requirements, working with development teams, testing, and preparing code for production deployment.

Written automated tests for web applications (Selenium Webdriver).

Validating design to support system and integration testing strategies.

Walks between Development and Testing to assist in helping the teams increased test coverage.

Continuously reviewing open source tools for continuous improvement in our test approach and strategies.

Performed extensive Database testing by testing the Front End, inserting Database Checkpoints to query data using SQL queries.

Environment: SQLServer, SQL, Testing Tools: Selenium WebDriver, HP Quality Center, JIRA, Confluence, Zephyr, JUnit, TestNG and JMeter; Languages: Java, C++, JavaScript, XML, and HTML 5

Digital Insight, NCR, Atlanta, GA May 2016 to Jun 2017

Sr. Software Engineer – QA

Digital Insight, NCR- Portal/Mobile applications for Payments.

Banks and credit unions turn to Digital Insight for innovative online and mobile banking that drives growth.

For nearly 30 years, Digital Insight’s leading solutions have helped financial institutions engage more meaningfully and more profitably.

Digital Insight customer data. Percentage represents a comparison between highly engaged Web and mobile customers versus the typical customers. Financial institutions whose customers use Digital Insight' Internet Banking with Bill Pay for payments, FinanceWorks™ and eBills.

Responsible for Design, develop, execute and maintain QA test plans and cases to ensure high quality IT solutions.

Record all defects encountered during testing process and coordinate resolution of those issues with proper resources.

Develop, implement and maintain QA automated infrastructure to enable execution of unit and regression test suites using Selenium WebDriver (Java/TestNG/JUnit for API and web-based applications.

Testing for delivery of products and enhancements and to assure products meet product requirements and quality standards, partnering with Product Management, Project Management, Engineering, and Operations teams.

Maintain flexibility to react quickly to changes in priorities or circumstances to meet the needs of the business. ;

Performed extensive Database testing by testing the Front End, inserting Database Checkpoints to query data using SQL queries.

Agile methodology in all phases of the iterative software development lifecycle.

Environment: UNIX, Oracle PL/SQL, SQL, WebLogic, Apache, OpenLDAP and Incident management (Pivotal), Testing Tools: Selenium WebDriver, HP Quality Center, JIRA, Confluence, Zephyr, JUnit, TestNG and JMeter; Languages: Java, C++, JavaScript, XML, and HTML 5

AT&T Finance, Atlanta, GA Jan 2015 to Apr 2016

Sr.QA Tester

BI One Stop- Portal/Mobile applications.

BI One stop portal provides a single entry point to structured BI data using centralized data governance and integration with BI tools. Users can personalize, customize and collaborate in real time.

BI OneStop Mobile Roadmap Provides an effortless customer experience in accessing BI reports and documents.

Responsible for Full Software Test Life Cycle, preparing Test Strategy, Test Planning, Test Cases and Execution, Defect tracking and analysis.

Responsible for translating requirements into traceable test suite, automated test infrastructure to enable execution of unit and regression test suites using Selenium WebDriver(Java/TestNG/JUnit for API and web-based applications.

Generated detailed reports on the test results, various test metrics and provide the status to the client stakeholders.

Handled the daily responsibilities of supporting the build and release into the QA and Staging environments.

Working closely with development and infrastructure teams on problem isolation and resolution.

Environment: UNIX, Oracle, Teradata, OBIEE, Micro strategy, Hyperion Essbase, Toad, Hyperion Suite of products, WebLogic, Apache, OpenLDAP; Testing Tools: Selenium WebDriver, HP Quality Center, Rally, JUnit, TestNG, JMeter; Languages: Java,, C++, JavaScript, XML, HTML 5

GE (Synchrony Financial), Atlanta, GA Jul 2014 to Jan 2015

Sr.QA Analyst

GE Capital Retail Finance project is an Essbase Wing to Wing application which is designed as part of Lift and Shift process where existing GE CAP Essbase Applications are shifted to new Synchrony Financial applications in new environment and latest versions. Retail Finance is splitting from GE to Synchrony Financial and therefore need to own and run its own Hyperion environment consisting of a Essbase, HFM and Planning applications.

Validation of Metadata and data that is sourced from the Oracle R12 General Ledger (GL).Wing to Wing Automation is provided by Application Manager to execute Metadata and data type of jobs. Data is sourced into staging area in Oracle db. Source data and target data comparisons and validations are performed.

Tested the extraction of the data from Oracle R12 General Ledger (GL) source systems, modification and also tested the data loaded into the target Staging/Target database, Verified Logical Data Mappings (source to target mappings).Designed, Implemented and Maintained Java-Based Test Automation Framework using the Selenium Web driver with JUnit for Dialog web-based online information applications.

Environment: UNIX, Oracle, Oracle R12 General Ledger (GL), Hyperion Essbase, Toad, Hyperion Suite of products; Testing Tools: Selenium WebDriver, HP Quality Center, JUnit, TestNG, JMeter; Languages: Java, XML, HTML 5

Verizon Wireless, Atlanta, GA Mar 2013 to Jul 2014

Sr.QA Analyst

Usage Broker (UB) routes usage traffic that it receives from Data Mediation to the appropriate downstream systems. Usage files can be of the types 4G Data, 3G Data, Messaging and Voice. Currently, DM sends 26 different usage files to Usage Broker and the files are usually sent every 2 minutes. Usage Broker will validate the files, check for duplicates, and use information in the record to send this data to VISION, RSS, OPC, SOCO, Fraud Plus, and Revo.

Creation of the New EVF (Enrich, Validate & Filter) (JITR) Processing Workflow that picks up and processes data usage records (UB Super layout) or recycled records within Usage Broker (UB).Migrated all filters, validations, enrichments and exception rules from downstream billing systems (Vision, RSS & OPC) and the existing UB rules within the JITR Processing Workflow for data usage.

Errors are established in a hierarchical order based on the ordering of the rules (so that certain errors only occur before other errors, allows RA to ‘see’ record progress). This process error on the first record/error encountered and sends the record/error to EHS to be processed accordingly. The JITR Processing Workflow will split out the data usage records (UB Super layout) by JITR Instance into the appropriate files for JITR.

Worked on projects of medium size with an average level of complexity ensuring the Usage Broker software implemented in production meets company standards, business user requirements and audit requirements.

Performed different types of testing using Usage Broker application, back end testing on the database, front-end testing, GUI testing (field and object specific) and regression testing execution of test cases.

Reported bugs (defects) found in the code while execution of test cases, working/meeting with Development on fixes and retesting of failed test cases. Reported defects in Quality Center/ALM.

Responsible for maintenance and updating of the existing automation framework using Selenium and JUnit.

Environment: UNIX, Oracle, Hyperion Essbase, Toad, Hyperion Suite of products; Testing Tools: Selenium WebDriver, HP Quality Center, JUnit, TestNG, JMeter; Languages: Java, XML, HTML 5

AT&T Finance, Atlanta, GA May 2010 to Mar 2013

Sr.QA Tester

Responsible for end-to-end testing and defect resolving, systems engineering, testing, scripting and production support functions. Successfully tested and managed ten major Application releases. The web applications –Mercury and AERP portals - were running on WebLogic container, using high performance Oracle Solaris and Red-hat Linux platforms.

Reviewed business, functional requirements and validating CFO-certified data sourced from BID (Business Intelligence Development Warehouse) into the Hyperion Suite of products.

Reporting test outcomes by collecting, analyzing, interpreting, summarizing and displaying data recommending software change and documenting test results in Quality Center/ALM.

Developed & tested management reports, which include Weekly Activity Reports, Daily and Monthly Subscriber Reports, Churn reports, Graphs and other critical financial reports.

Performed Data Driven Tests to validate same scenario with different test data using Quick Test Professional (QTP).Back-end testing using SQL queries to make sure that data entered correctly into the Oracle Database.

Designed and develop Unix Shell scripts (bash and ksh) and wrote SQL queries for downloading test data from various servers using FTP.

Environment: Oracle, Teradata, Hyperion Essbase, Hyperion Suite of Products, Tomcat/ Apache, TOAD, MS SQL Server Management Studio; Testing Tools: Quick Test Professional (QTP), Quality Center/ALM; Languages: Java, JavaScript, XML

Kronos Inc, Atlanta, GA May 2008 to Jan 2010

SQA Engineer III

Kronos® Workforce Analytics™ for Healthcare is an add-on product to the Workforce Analytics product which is used to collate the data from Kronos® Workforce Timekeeper™, as well as payroll, agency and volume (billing) systems to the Workforce Analytics data mart; This system in cooperates four additional healthcare analytics cubes & facilitates the availability of daily & pay period productivity statistics in dashboards, scorecards & interactive reporting of Workforce Analytics.

Designed test plans collaboratively with developers and business users early in the iteration so as to guide development by Test Driven Development process.

Developed automation tests, database scripts, and batch files to validate data in various phases in both SQL Server 2005 and Oracle 10g databases; managed work entailing agile development and testing in SCRUM framework.

Precisely reported defects by following the company’s defined defect management process (JIRA, Dev track and VersionOne tool);

Created & executed test plans & test cases using Silk Test; scripted & executed automated functional tests using Silk Test; Automated Test scenarios for GUI, Functionality, Security, Database and Regression Testing using Quick Test Professional; developed parameterize test scripts to test same functionality with multiple sets of data using Quick Test Professional; designed structured Automated Test Cases and Test Suites for reusability using Quick Test Professional.

Environment: Linux, SQL Server 2005(SSIS, SSRS, cubes), Oracle 9I/10G, Oracle SQL Developer, Tomcat/ Apache, TOAD, MS SQL Server Management Studio; Testing Tools: Silk Test, Quick Test Professional (QTP), Test Director, VersionOne; Languages: Java, JavaScript, XML

Cingular Wireless Finance, Atlanta, GA Jun 2006 to May 2008

QA Tester

Project Mercury is a management reporting tool which can be utilized to streamline the reporting processes within Cingular. The project was executed to facilitate in delivering accurate information to the Customer Telephone Number (CTN) level.

Conducted End to End validation ensuring correct transformation of data from the various layers from the following checkpoints: Source to ODBC/ODBC to Dimensions/Dimensions to Fact and Fact to Cubes. Tested the extraction of the data from different OLTP source systems, modification and also tested the data loaded into the target Staging/Target database, Verified Logical Data Mappings (source to target mappings).Verified various Data Transformations using slowly Changing Dimensions; Verified and tested the final output in the form of Reports and Hyperion Essbase Cubes.

Environment: Oracle, Teradata, Hyperion Essbase, Hyperion Suite of Products, Tomcat/ Apache, TOAD, MS SQL Server Management Studio; Testing Tools: Quick Test Professional (QTP), Quality Center/ALM; Languages: Java, JavaScript, XML

Cingular Wireless Finance, Atlanta, GA Sep 2004 to Jun 2006

QA Tester

MaRS (Management Reporting System) was developed to facilitate in pulling reports entailing production numbers for sales thereby assessing the metrics of Revenue, Margin, Expenses, Supporting Accounts, ROA, and more at the store group reporting level (Return on Operations).

Identified the critical test cases in the initial stage of the project and facilitated the transition of software from the development environment to the test environment.

Extracted processes and received data from different source systems; validated the data, loaded it to staging environments using UNIX and SQL Loader. Created KSH scripts to automate parts of regression tests.

Conducted manual testing of data integration/migration from various source systems into the Data Warehouse environment.

BSNF Rail Road, Ft Worth, TX Jul 2003 to Dec 2003

QA Tester

This was an OLAP system called the TouchFree dashboard used for budgetary analysis of all financial Departments using drilldown, charts, attached narratives, predictive alerting, etc. It will be the main tool used by the senior management team to explain the operating results, audit issues, process breaks, headcount metrics, etc of their respective organizations.

Developed test cases & stored test scripts in a Central Repository and Version Control applied using Clear Case.

Designed and developed Test Plans and Test cases for Acceptance, Functional and Integration Testing using Test Director.

Optimized QTP scripts for Regression testing of the application with various data sources and data types.

Coordinated & controlled testing projects at various step of the Quality Cycle from Test Planning through Execution to Defect Management; monitored all phases of Testing process, Test Schedules & its Execution, and Communicated Project Information; performed extensive Database testing by testing the Front End, inserting Database Checkpoints to query data.

Environment: Windows NT 4.0/2000, UNIX, Oracle, TOAD, Hyperion Essbase, Excel Add-in; Testing Tools: Test Director; Languages: Java, JavaScript

Contact this candidate