Test Cases Data

Location:

Tracy, CA

Posted:

June 06, 2018

Contact this candidate

Resume:

Professional Summary:

Over * years of IT experience in Analyzing the Data, Validation Client / Server, Web applications.

Experience in all phases of Software Development life cycle in Agile/Waterfall.

Good experience in Data Quality, Data Analysis, Data Validation, Data Profiling, Data Verification, Data Mapping and Data Loading.

Extensive testing ETL experience using Informatica (Power Center/ Power Mart) (Designer, Workflow Manager, Workflow Monitor and Server Manager)

Very good understanding of Data Warehousing concepts, Data Analysis, Data Warehouse Architecture and Designing.

Proficient experience in different Databases like Oracle, SQL Server, DB2 and Teradata.

Expertise in Developing PL/SQL Packages, Stored Procedures/Functions, triggers.

Expertise in utilizing Oracle utility tool SQL*Loader and expertise in Toad for developing Oracle applications.

Extensively worked on Dimensional modeling, Data cleansing and Data Staging of operational sources using ETL processes.

Application Data warehousing experience in Banking, Pharmaceutical and Insurance.

Performed Unit, Integration and System Testing.

Extensively used ETL methodology for supporting data extraction, transformations and loading processing, in a corporate-wide-ETL Solution using Informatica

Strong working experience on data warehousing applications, directly responsible for the Extraction, Transformation and Loading of data from multiple sources into Data Warehouse.

Expertise in Manual Validation/mobile application Validation, iOS, Blackberry, Android Mobile applications.

Experience in Hybrid apps and mobile apps on iOS, iPad and Android devices.

Validation using simulators also with real time devices.

Experience in using Test Automation tools UFT.

Extensively used ETL batch jobs for supporting data extraction, transformations and loading processing.

Performed ETL Validation for the data extracting from Transactional Schema to ORDB Schema.

Expertise in validation of Mapping documents, Transformation Rules and Enumerations between Expected Results and Actual Results.

Excellent Experience in Tableau 9.3 Reports Validation.

Good experience with API Validation.

Good experience in working Agile process, involved in Scrum meetings.

Experience with WAR Room work experience.

Excellent Skills in performing InSprint Validation, Hardening Sprints and Kanban.

Excellent in Coordinating with Product Owners, Scrum Masters, Development and SA teams on InSprint Issues and defects.

Worked extensively on Agile tools JIRA and Rally.

Extensive experience in Manual Validation and Quality Assurance of Client/Server and Web applications.

Performed InSprint Automation using UFT tool.

Excellent understanding and expertise in writing complex SQL/PL SQL, Store Procedures and Functions queries to perform back-end Validation.

Brought new Innovations for the projects to save budget and Manual effort in Validation and avoiding hard coded data dependencies for the automated regression.

Experience in Validation and writing SQL statements.

Experience in Manual Functional Validation with ALM and regression Validation with UFT.

Expert in writing Test Cases, Requirement Traceability Matrix, User Traceability Matrix and extensive knowledge in Regression Validation.

Created test cases from Requirements, Executed, logged defects and coordinate with cross functional and off site teams.

Good experience in working on for reviewing Business /Functional Requirements and documenting test scenarios and writing test cases accordingly.

Excellent Domain Knowledge in Mortgage and Banking Industries.

Day-to-Day responsibilities include reviewing test documentation, identifying test objectives, creating/updating change requests, fixes, defects, and executing functional and regression Validation, compatibility, security, back end and system Integration Validation (SIT).

Advanced user in using Test management tools like ALM, HP Quality Center.

Ability to quickly adapt to different project environments, work in teams and accomplish difficult tasks independently within time frame.

A Good team player with excellent written and verbal communication skills.

Excellent problem-solving skills with a strong technical background and good interpersonal skills.

Technical Skills:

OP Systems

Windows 10/8/NT/98/2000/XP/VISTA, Mac, i pad 2 and 4, Samsung tablets

Programming Languages

SQL, PL/SQL, VB Script, Shell Script, Core Java, COBOL

Databases

Oracle 12c,11g, DB2

Automation Tools

UFT/Quick Test Professional

Test Management Tool

ALM/HP Quality Center

Validation Methods

Integration, System, Smoke, Regression, Agile

Agile Tools

Rally, JIRA and TFS

Requirement Tools

Rational DOORS 9.3

ETL Tool

Informatica 9.x/10.x, SSIS, Abinitio(GDE)

Other Tools

Rational Clear Quest 7.1.1, Rational Clear Case, BMC Remedy 7.1, Smart Bear Soap UI, Secure Crt, MDM HUB, Informatica IDD, Control M

WINSCP, ACMS, Autosys, Toad, Humming Bird Exceed, JCL, Tableau 9.3

Employer: - Mphasis Corporation

Address of Employer: - 460 Park Avenue South, Suite 1101, New York, NY, 10016

Visa Status : H1B

Education : Bachelor of Technology, Telangana, India.

LinkedIn : https://www.linkedin.com/in/vikram-reddy-91991019

Professional Experience:

First Republic Bank May 2016 – Till Date

Role: Senior ETL/QA Lead

California.

Description: First Republic is an ultra-high-touch bank that provides extraordinary client service. We believe that one-on-one interactions build lasting relationships. We move quickly to serve our clients’ needs so that their financial transactions are handled with ease and efficiency. Client trust and security are paramount in our line of business. Ultimately, our goal is unsurpassed client satisfaction which will lead to personal referrals – our number one source of new business.

Responsibilities:

Analyzed business requirements, system requirements, data mapping requirement specifications interacting with client, developers and QA team.

Involved in rigorous meetings with offshore testing team and DWH Lead to plan and implement the testing efforts

Performed Regression testing for every modification in the application .

Created and Configured Workflows, Work lets, and Sessions to transport the data to target using Informatica Workflow Manager.

Functioned as Project Lead to implement an effective and efficient test regression test bed.

Responsible to design, develop and test the software (Informatica, PL SQL, UNIX shell scripts) to maintain the data marts (Load data, analyze using OLAP tools).

Writing complex SQL queries for data validation for verifying the ETL Mapping Rules.

Extensively test the reports for data accuracy and universe related errors

Took part in Triage Meetings with the required parties after defect analysis to prioritize defect resolution.

Tested several dashboards and deployed them across the organization to monitor the performance.

Used SQL tools to run SQL queries and validate the data loaded in to the target tables

Validated the data of reports by writing SQL queries in PL/SQL Developer against ODS.

Involved in user training sessions and assisting in UAT (User Acceptance Testing).

Strong ability in developing advanced SQL queries to extract, manipulate, and/or calculate information to fulfill data and reporting requirements including identifying the tables and columns from which data is extracted.

Performed validation tests to ensure that the developed functionality meets the specifications prior to UAT testing.

Promoted Unix/Informatica application releases from development to QA and to UAT environments as required

Experience testing data conversions and migrations in cross platform scenarios Informatica power center.

Functioned as the Onsite / Offshore coordinator and Team Lead

Implemented SDLC, QA methodologies and concepts in the Project

Experience in creating UNIX scripts for file transfer and file manipulation.

Created and executed Test scripts for system validation and user acceptance testing (UAT)

Created ETL execution scripts for automating jobs.

Involved in extensive DATA validation using SQL queries and back-end testing

Performed front-end testing on CIE Portal and Executive Dashboard portal

Tested Analytical Data Mart (ADM) of Oracle system and Stored Procedures

Tested Operation Data Store process of ODS/DWL product

Used workflow manager for session management, database connection management and scheduling of jobs.

Environment: Informatica PowerCenter 9.x,10.x, SQL, Perl, SQL Server, Microsoft TFS, MDM, IDD,IDQ

T-SQL,SQL, TOAD, Oracle SQL Developer, Oracle 11g/12c, PL/SQL, Microsoft Visio, SSIS, Flat Files.

Fannie Mae April 2014 – April 2016

Role: Senior ETL/QA Analyst

Virginia.

Description: Fannie Mae serves as the leading source of residential mortgage credit in the U.S. secondary market; it is supporting today’s economic recovery and laying the foundation for a better housing finance system. Fannie Mae guarantees and purchases loans from mortgage lenders to ensure families can buy homes, refinance, or rent a good home. Fannie Mae implemented SIR application for its lender, servicers and investors to manage the Payments, Financial Services on daily basis to monthly basis. Servicer Investor Reporting (SIR) application was outsourced to HP and had received complete and sufficient mentoring from Fannie Mae to provide ongoing support in Validation this application. File Transfer Portal application supports exchange of data between Fannie Mae internal and external partners.

Responsibilities:

Involved in Business analysis and requirements gathering.

Involved in System Validation of SIR (Servicer Investor Reporting) modules like SIR system calculations catalogue.

Performed User Interface Validation of SIR application upon upgrading Java and Web logic versions. This involved Validation the data displayed, Validation the layouts of the screens and views. Experience in using Test Automation tools QTP, UFT.

Good Experience in Business process Validation (BPT framework).

Good experience in working Agile process, involved in scrum meetings.

Excellent Skills in performing InSprint Validation and Hardening Sprints.

Extensively used ETL batch jobs for supporting data extraction, transformations and loading processing.

Performed ETL Validation for the data extracting from Transactional Schema to ORDB Schema.

Expertise in validation of Mapping documents, Transformation Rules and Enumerations between Expected Results and Actual Results.

Excellent Experience in Tableau 9.3 Reports Validation.

Creating Automation Test Framework using UFT/QTP.

Involved in Dynamic Validation Framework using UFT to reduce hardcoded data for regression suite.

Automating ETL batch execution using UFT and Humming Bird.

Fixed the current Automation scripts which are having issues due to requirements changes.

Automating UI and backend test cases using BPT and Data Driven frameworks.

Excellent in Coordinating with Product Owners, Scrum Masters, Development and SA teams on InSprint Issues and defects.

Expert in writing Test Cases, Requirement Traceability Matrix, User Traceability Matrix and extensive knowledge in Regression Validation.

JIL generation and JIL loading into Autosys R11

Worked extensively on Agile tools JIRA and Rally.

Extensive experience in Manual Validation and Quality Assurance of Client/Server and Web applications.

Performed InSprint Automation using UFT tool.

Excellent understanding and expertise in writing complex SQL/PL SQL, Store Procedures and Functions queries to perform back-end Validation.

Brought new innovations for the projects to save budget and Manual effort in Validation and avoiding Hard coded data dependencies for the automated regression.

Connected to UNIX servers using PUTTY and ran the Autosys batch jobs to move response files to Portal file repository.

Involved in Business analysis and requirements gathering.

Involved in System Validation of SIR (Servicer Investor Reporting) modules like SIR system calculations catalogue.

Performed User Interface Validation of SIR Application upon upgrading Java and Web logic versions. This involved Validation the data displayed, Validation the layouts of the screens and views.

Tuned ETL jobs/procedures/scripts, SQL queries, PL/SQL procedures to improve the system performance.

Wrote SQL and PL/SQL scripts to perform database Validation and to verify data integrity.

Written SQL statements and executed them using TOAD to validate the metadata of the response file saved in Database.

Involved in extensive DATA validation by writing several complex SQL queries and Involved in back-end Validation and worked with data quality issues.

Extensively used SQL programming in backend and front-end functions, procedures, packages to implement business rules and security

Involved in the requirements review meeting and prepared the test cases based on the requirements document and Solution Specification documents.

Created detail Test cases which incorporated both positive and negative test conditions.

Created Test data for performing System Test with different type of test scenarios.

Extensively written test scripts for back-end validations.

Performed Real-time Interface Validation with downstream applications to the S/IR.

Participated in regular sessions and team meetings to discuss the issues arising out of Validation and interacted with developers and project managers to deal with any issues found during Validation.

Involved in debugging the Job failures from log files which were executed using automated scheduling through ALM/Quality Centre.

Extensively used ALM/Quality Center for test execution and used Clear case for version control and file management.

Extensively used Rational Doors for managing system requirement documents and generated Requirement Traceability Matrix (RTM) and User Traceability Matrix (UFT).

Extensively used Rational Clear Quest for bug tracking and followed up with development team to verify bug fixes.

Extensively used BMC Remedy for submitting request for DBA teams and Middleware teams for any test environment issues, upgrades and code deployments.

Environment: ALM, Quality Center 10.0, Rational DOORS 9.3, Rational Clear Quest 7.1.1, Rational Clear Case, BMC Remedy 7.1, Putty, WINSCP, ACMS, Autosys, JCL, COBOL, Windows XP, UFT, QTP 9.0, TOAD 9.5, Oracle 12c, DB2 SQL, MS Office, Rally, JIIRA, Tableau 9.3, Abinitio(GDE).

Hewlett Packard Enterprise March 2013 – March 2014

Role: Senior QA Analyst

Michigan.

Responsibilities:

Involved in Business analysis and requirements gathering.

Involved in System Validation of SIR (Servicer Investor Reporting) modules like SIR system calculations catalogue.

Performed User Interface Validation of SIR application upon upgrading Java and Web logic versions. This involved Validation the data displayed, Validation the layouts of the screens and views.