SALAMANN (Green card)

234-***-****, adl5ne@r.postjobfree.com

Professional Summary

Experienced DWH, BI Tester, API and Devops QA Analyst with strong knowledge in design, development, and support of databases and information products as well as data analysis / reporting / Testing.

Close to 9 years of IT experience in the Analysis, Design, development, testing and Implementation of ETL & Business Intelligence solutions using Data Warehouse/Data Mart Design, ETL, OLAP, Client/Server applications.

Excellent understanding and expertise in writing complex SQL (DDL, DML and DCL) queries to perform back-end testing.

Automated and scheduled the Informatica jobs using UNIX Shell Scripting and AutoSys.

Strong working experience on DSS (Decision Support Systems) applications, and Extraction, Transformation and Load (ETL) of data from Legacy systems using Informatica.

Well versed using UNIX commands for shell scripting.

Extensively used ETL methodology for supporting data extraction, transformations and loading, in a corporate-wide-ETL Solution using Data Stage, Ab initio,Informatica and SSIS.

Expertise in Testing complex Business rules by creating mapping and various transformations using Informatica.

Expertise in defects logging, tracking and managing defect life cycle using JIRA, RALLY, QC/ALM, Bugzilla, ServiceNow, Trello.

Performing Web services testing using Postman.

Experienced in API testing using Soup UI using ReadyAPI tool.

Provide support for ETL tuning, Maintain SLA, Capacity management and Performance KPI.

Experienced in working with HP Quality Center and Rational Requisite Pro and Clear Quest for Test Management and defect tracking.

Excellent experience in developing Business Intelligence Applications using Business Objects and Crystal Reports.

Hands on experience with version control systems and CI/CD tools like GitHub, Jenkins and Puppet

Good knowledge on containerization tools like Docker and Kubernettes

Experienced in Agile (Scrum) model and DevOps process and test delivery management

Extensive experience in manual testing the ETL and Business Intelligence Applications.

Developing and Delivering System Documentation and UAT Test scripts and auditing documentation for maintaining ITIL.

Excellent problem solving, interpersonal, and communication skills.

Technical Skills

ETL Tools

Informatica 8.1/7.1, Data Stage 7.5, Ab Initio

Testing Tools

Selenium,Quality Center, Load Runner, QTP, Win Runner, Rational Clear Quest

Database

Oracle 8i/9i/10g, SQL Server 2000/2005, MySQL, ODBC, DB2, TOAD, Querysurge MS Access, Teradata V2R5/V2R6,

Reporting Tools

Business Objects 5.1/XIR2, Cognos 8.0, Crystal Reports

Devops

Jenkins,Puppet,Git and Github, CI/CD,

Version control

Visual Source safe,GIT, WINCVS,PVC

Languages

HTML, XML,PL/SQL

Professional Experience

Client: Well Care, Tampa -FL

Jan 2018– Till Date

QA/API/Data/BI/Devops Test Engineer

Project: Project was to design and built a data warehouse to generate various reports and do ad-hoc analysis .

Responsibilities:

Involved in complete project software development life cycle (SDLC) and Quality Assurance Life Cycle (QALC)

Worked in a scrum/agile process for delivering the outputs on time.

Was involved in Sprint planning, Review Sessions, Scrum meetings.

Reported periodic project status and updates to the QA Lead and QA Manager

Performing Web services testing using Postman.

Tested API using Newman and wrote groovy scripts in Soup UI using ReadyAPI tool.

Analyzing test results tracked the defects and generated reports using JIRA and ALM.

Performed testing on Web Services using WSDL and SoapUI to check the communication between different services

Performed Integration Testing of different modules.

Tested the data integrity between SAP, Sales Force, JMS, HTTP, Web-Service connectors.

Logging in UNIX server for checking logs in UNIX in Production & Development environment.

Analyzed Business Requirements and Developed the Test Plan, Test Scripts and Test Cases

Identified the Test Cases to be automated and lead the effort for automating the product.

Used Quality Center to run the test scripts and to log and track defects.

Tested User Interface inconsistency and application functionality.

Developed SQL scripts to validate the data loaded into warehouse and Data Mart tables using Informatica.

Tested complex reports generated by Cognos application.

Preparation of test data for various levels of testing

Load new or modified data into back-end Netezza server.

Optimizing/Tuning several complex SQL queries for better performance and efficiency.

Worked on issues with migration from development to testing.

Designed and developed UNIX shell scripts as part of the ETL process, automate the process of loading, pulling the data.

Validated cube and query data from the reporting system back to the source system.

Tested analytical reports using Cognos Analysis Studio

Participate in scrum meeting and weekly sprints, review product and sprint backlog

Environment: Netezza Server,Sybase Server, informatica,Jira,Quality Center 9.0, DB2, Cognos Series 7.0, Oracle10g, Erwin 7.1, Windows XP, TOAD

Client: Fannie Mae, Herndon, VA

Aug 2015 –Dec 2017

ETL/BI Tester - Portfolio Management Reporting System.

Project: The system was primarily written to provide reports for the portfolio managers who could use these reports to provide the customers with the highest total rate of return consistent with their performance goal, cash flow requirements, need for liquidity, and preservation of capital.

Responsibilities:

Prepared the test plan, test strategy and test case documents with the help of BRD, FRS, HLD, LLD and other supporting documents.

Attended walkthrough meetings with the Business Analysts and DEV team to get a clear understanding of the business and the applications being used in house.

Developed and Designed Test Cases based on the Business Rules and Mapping Documents.

Validated the source data coming from various databases using complex SQL queries.

Aggregated the data at source and compared with the Target to validate Transformations.

Prepared Traceability Matrices to track the requirements with the test cases and make sure none of them have been missed.

Logged defects using HP Quality Center 10, linked defects with requirements and generated Defect Reports in QC.

Participated in change review meetings and suggested on the testability of the CRs.

Worked with other members of the QA and Development teams and managed efforts with offshore team in improving the processes, methods, effectiveness and efficiency.

Attended daily status call with Offshore to review assigned tasks and solve any impediments.

Used Oracle SQL developer tools for Querying source Database.

System was implemented using Informatica and the Warehouse in Teradata. Fast-Load, MultiLoad, BTEQ & Fast-Export were the Teradata utilities used

Performed Report Testing using Crystal Reports by writing SQL queries to validate the data on the report and compare with the DWH data.

Participated in walkthrough and defect report meetings periodically.

Documented and reported various bugs during the Testing process.

Written SQL Queries to define identify and validate the code written for the data movement into the database tables, fine tuned the queries for better performance.

Retesting the resolved defects/issues after the developers fix the defects.

Involved in preparing test data/ Test script for UAT and participated in UAT signoff

Updated the status of the testing to the QA manager, and accomplished tasked for the assigned work to the Project Management team regularly.

Environment: MVS, Informatica 9.0, Oracle 10g, AutoSys, Teradata V2R5 Teradata SQL Assistant, PL/SQL, TOAD 8.0, SQL, UNIX, Quality Center 10.0, Crystal Reports 12.0

Client: Wells Fargo, Charlotte, North Carolina

Jan 2013 – July 2015

ETL SQL Test Analyst- Credit DataMart

Responsibilities:

Involved in Business analysis and Requirements gathering.

Data migration – Includes migration of data from legacy environment to Oracle System.

Involved in Data Validation using SQL queries.

Used the Data Stage Designer to develop processes for extracting, cleansing, transforming, integrating, and loading data into data warehouse database.

Extensively used Data Stage manager to migrate code to various project environments.

Utilized Access database to collect data from multiple database sources using ODBC methods. Developed procedures for exporting information in Excel format in development server.

Consolidated numerous scripts and revised validation logic to conform to data jobs and client data integrity requirements. Created user defined functions to dynamically validate data specific to clients.

Processed transactions from system entry to exit. Tested functionality across applications and workflows.

Worked with UNIX shell scripts for scheduling and running the required jobs.

Worked with appropriate business and technology leads to determine the acceptable range for test results and performance

Tested the ETL process for both before data validation and after data validation process.

Coordinated component, system testing with the appropriate technical groups and Release Management and documented test procedures and findings.

Reconciled test results from different tests and different groups. Assessed readiness and deviation of product/project performance based upon test results and product specifications.

Reported bugs and tracked defects using Rational Clear Quest.

Used of ETL Automation tool Query Surge to create query pairs using SQL queries.

Used TOAD Software for Querying ORACLE and Used Win SQL for Querying DB2

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

Created critical scenarios for each change request and defect request.

Environment: IBM Data Stage 7.5, Windows NT, UNIX Shell Scripting, IBM AIX, Control-M, Oracle8i, SQL, PL/SQL, SQL*Loader, Query surge, Business Objects XIR2, Rational Clear Quest, IBM DB2

Client: Foremost Insurance, Caledonia MI

March 2012– Dec 2012

QA / Data Analyst

Project: Foremost Insurance is a specialty insurance company providing insurance choices to more than 40 states around the US. I was involved in a part of a project that was a Pricelist and Quoting application to provide quotations for various products like AUTO, HOME, Mobile Home, Rental and Vacation Home, Trailers, Boat etc. The application is supposed to be used by their local office agents around the US to give insurance quotations based on customer requirements and eligibility.

Responsibilities:

Involved in Data Analysis and Database Designing.

Involved in identifying data from BRD to Develop LDM, PDM by studying Data Flow diagrams and State Transition Diagrams.

Used MS Visio to develop the database design.

Extensively involved in developing Data Dictionary.

Created tables and various database objects.

Troubleshooting, resolving and escalating data related issues and validating data to improve data quality.

Involved in performing validation of datasets, tables and triggers by performing White Box Testing and code walk-through.

Performed Data Profiling to improve search abilities by using tags and aliases.

Dynamically adjusted price breaks in accordance with client pricing groups and allowed editing/addition of customer information to rapidly assemble on-screen, printed and database-recorded quotes.

Developed test reports and participated in testing prioritization and archived test results and user signoff

Involve with Design and Development team to implement the requirements.

Performed execution of test cases manually to verify the expected results.

Involved in creation of tables, writing stored procedures and Triggers.

Developed user interface screens using VB, ADO to connect to backend and stored procedures to manipulate data.

Handling user defined exceptions.

Involved in testing, implementation & maintenance.

Environment: MS Visio, Crystal Reports 9.0, Metadata Repository, Visual Basic 6.0, SQL Server 2000, SQL, T-SQL, UNIX and Windows NT

Education

Bachelor of Engineering

Osmania University, Hyderabad, India

Contact this candidate