Ananda Shatty (ETL Tester)
Email: ac4i5z@r.postjobfree.com
Mobile: +91-855*******, +91-974*******.
Career Objective
Seeking a challenging career to work in dynamic organization that extends opportunities for extensive learning and skill enhancement in Software Testing (ETL, DWH Testing) and Quality Assurance Engineering where my abilities as Software Test Engineer can be effectively utilized.
Professional Summary
Presently working as a Software Engineer in HCS Technologies Pvt Ltd, Bengaluru from Aug - 2015 to till Date.
Summary
Having around 3 Years of Experience in Software testing which includes ETL/DWH Testing and Web application testing.
Hands on Experience in ETL/DWH testing.
Hands of experience with HP ALM/QC.
Good Exposure to Data Warehousing concepts using Fact tables, Dimension tables, star schema and Snowflake schema Modelling.
Hands on experience in writing and executing SQL Queries.
Expertise in testing initial and delta loads.
Extensively used Workflow manager & Workflow monitor in Informatica ETL Tool.
Experience in testing surrogate keys and slowly changing dimensions.
Have Knowledge on understanding & creating source and target definitions, Mappings, Sessions, Workflows and Transformations.
Experience in the ETL (Extraction, Transformation & Load) techniques, Dimensional Schema Models (Star, Snow-Flake).
Extensive experience in reviewing Business Requirement Documents, Software Requirement Documents and preparing Test Cases and Execution.
Involved in the Designing, Preparing, Execution and Maintenance of the test cases.
Having knowledge on UINIX.
Having knowledge on Defect Life Cycle.
Education Profile
B.E (ISE) from JSS Academy of Technical Education, Bengaluru with an aggregate of 61.16%.
Diploma from Govt, Polytechnic College, Raichur with an aggregate of 69.23%.
SSCL from Govt. High School, Raichur Dist, With an aggregate of 70.88%.
Technical Skills
Software Testing : ETL/DWH testing & Manual Testing.
ETL Tool : Informatica Power Center 9.5
Languages : SQL Plus, MS SQL.
Test Management Tool : Quality Center/HP ALM 11.0.
Database : Oracle 10g, Oracle 11g
Operating systems : Windows, Unix
Data Access Tool : TOAD 9.7.2.5, Oracle SQL Developer 4.0.
Reporting Tool : QlikView 11.0
Project Details
Project # 2 :
Project Name : BooksBeka
Client : Booksbeka Online Solutions Pvt Ltd.
Period : Dec-2016 to till date
Team size : 8
Role : ETL Tester
Environment : Oracle 11g, Informatica 9.5, Toad, ALM, QlikView, Windows.
Description
This online bookstore application that acts as a central database containing various books in stock along with their title, author, cost, description and etc., this project is website application that acts as central book store. This web project is developed using java scripting languages and SQL as a back-end. The user may select desired book and view its price. The user may even search for specific books on the website. Once the user selects a book, he then has to fill in a form and book is booked for the user. The database stores various book related information/details. The aim of sales data Warehouse is to analyse the sales and profit in Quarterly wise and yearly wise. The data gets refreshed yearly and is maintained historically. This Data warehouse plays a major role in enabling BA to view the data at a lowest level and help them to make decision to bring more revenue to company with new policies.
Responsibilities
Requirement Analysis
Worked with HP ALM/QC for test case uploading and mapping them to test lab and executing test cases
Involved in functional study of the application
Test case documentation.
Test Data preparation to validate all possible Test scenarios/Test cases
Running the Jobs/Workflow for ETL process in Informatica Power Center
Verifying the ETL data in target database
Verified column mapping between source and target
Interacted with BA & Development teams to resolve the issues
Reporting daily testing status
Defect Analyzing, Preparing test plan documentation and Reporting in QC/HP ALM.
Project #1:
Project Name : Asset Management System
Client : Microchip Pvt ltd.
Period : Aug - 2015 to Nov – 2016
Team size : 8
Role : Tester
Environment : Oracle 11g, Informatica, Toad, HP ALM, Windows.
Description:
Asset management, broadly defined, refers to any system that monitors and maintains things of value to an entity or group or ethnic groups. Asset management is a systematic process of deploying, operating, maintaining, upgrading, and disposing of assets cost-effectively. Finance Department is responsible to maintain Master Data related to Products, Suppliers and Manufacturers, Employee and their level of authority information. The goal of the project is to develop strong database technology that will extract and transform the data collected and load into DWH .For decision in each level with proper data.
Responsibilities:
Analysed Requirement Specification documents
Prepared Test Scenarios & Test cases and executed Test cases
Involved in System Testing.
Running the Jobs/Workflow for ETL process in Informatica Power Center
Verifying the ETL data in target database
Source and Target data Mapping
Interactions with BA & Development teams to resolve the issues.
Defect Analyzing, Preparing test plan documentation and Reporting in QC/HP ALM.
Personal Details
Date of Birth : 18-Oct-1992
Languages Known : English, Hindi, Kannada, and Telugu.
Address : RajajiNagar 2nd Block, Shivanagar, Bengaluru-10.
I hereby declare that the above Information given by me is true to the best of my knowledge.
Date:
Place: Bengaluru.
(Ananda Shatty).