PRAVEEN SR KONDURI
Phone - +91-970*******
adlrvd@r.postjobfree.com
OBJECTIVE
I am a responsible for ensuring the accuracy and completeness of data which is extracted, transformed, and loaded to new systems. Duties involve performing data validation tests, analyzing reports and results, and developing solutions to port data without errors or losses. and where I can put my skills to effective use.
EXPERIENCE SUMMARY
4.2 Years of total IT experience in ETL Testing.
Extensive Experience in Database Testing, Data Migration Testing, ETL Testing, Data warehouse.
Proficient experience in Database Oracle 11g
Experience of creating flow chart based on business process understanding.
Created Packages to load sequences of Interfaces
Based on server agent scheduled the interfaces which needs to be run fortnightly basis.
Implemented performance tuning strategies for fast data loads.
Implemented Change data capture techniques with slowly growing target
Data modeling like tables creation and sequence generations.
Experience in writing the Technical Design Document.
Involved in Designing application Front end & Back end database.
Good knowledge of implementing various Transformations in Mappings.
Creating Source Definitions, design targets, mapping using designer & develop transformations.
Creating different transformations for loading the data into oracle database.
EMPLOYMENT PROFILE
Working as Test associate and Test Engineer with Artha Net Support Centre Pvt. Ltd from Nov 7 2016 to till date.
EDUCATION
Master’s degree (M-Tech) from Gitam University recognized by Gitam University Visakhapatnam.
Bachelor degree (B-Tech) from pydah college of Engineering and technology recognized by JNTU kakinada.
Project #1
Project :Dynamic Data Masking
Position :Database,ETL testing & Report testing
Client :Informatica
Duration : November 2016 - oct 2019
The application user sends the request to the database through Dynamic Data Masking(DDM). Once the incoming request is intercepted by DDM, it matches the request with configured rule sets and modifies it accordingly if a match is found. After DDM applies matched rules, it forwards the request to the database and the database executes the incoming request and sends the response back to the application user directly. For application users.
Roles and Responsibilities:
Effectively interacted with the end users for requirement gathering and defined requirement specifications document
Identifying requirements by establishing personal rapport with potential and actual clients and with other persons in a position to understand Business reporting requirements.
Documenting the identified requirements properly as Business requirement documents (BRD’s),
followed by analyzing and coming up with Functional specification and Technical design documents.
Involved in installation, configuration and maintenance of Cognos Administration tool 10.2.1
Involved in installation, configuration and maintenance of Tableau 9.3
Involved in installation, configuration and maintenance of OBIEE 11.2.1.
Implemented Data level and object level security in Cognos & OBIEE.
Implemented Dynamic Data masking for Netezza, Green plum, SQLServer and Oracle through ODBC and JDBC connection.
Involved in functional Database testing for DDM tool.
Extensively used Joins and sub-Queries to simplify complex queries involving multiple tables and also optimized the procedures and triggers to be used in production.
Involved in installation, configuration and maintenance of DDM Server.
Participation in Test Planning Process and developing Test Plan.
Preparing Build Verification Test (BVT),Check list and other testing documents.
Creating, Managing and Executing Test Cases.
Performing Functional testing, Usability testing and Browser Compatibility testing during different phases of application development Logging Bug Details in Scarab, generating bug report and reporting details to development team for follow up.
Performing Regression testing and executing Build Verification Test (BVT) for ensuring the stability of the application before release for every enhancement or changes.
Project #2
Project : Date warehousing
Position: Database,ETL testing & Report testing
Client : Informatica
Duration : Dec 2017 - Feb 2018
At a time when data warehousing is gaining importance in management's decision making, tools helping automated Extraction, Transformation and loading of data from different databases to a single platform gained significance. Experts in ETL tools have huge demand nowadays and it will increase constantly as more and more business houses started data warehousing to segregate different data to make analysis easier.
Roles and Responsibilities:
Perform file management system for storage and retrieval
System will store data in logical manner
Strong in ETL data validation developed using Informatica
Exposure to DB tools: SQL developer/SQL Plus
Strong in SQL preparation in Oracle 11g express edition
Strong knowledge on ETL and BI processes
Gathered user requirements from each Business Units for test.
Interacted with the Business users to identify the process metrics and various keys dimensions and measures.
Designed and developed Test Plans and Test Cases and executed them.
Involved in ETL Mapping Design and Performance tuning to Load mapping process.
Expertise in Manual testing,ETL testing,BI testing
Project #3
Project : load data from multiple source to target database.
Position: ETL tester
Client : Informatica
Duration: Jan 2020 to Nov -2020
Move all data from past data to target database. Here target database is oracle database. Extraction can be performed from legacy systems. Transformation can be performed using ETL tool informatica and loading into datawarehouse
Roles and Responsibilities:
Identify the source table and import source data.
Connect to target database and create target table.
Create one to one mapping.
Establish the connection
Create the session and assign the map to the session.
Create the workflow.
Run the process.
Monitor the process.