Engineer Project
Resume:
Prakash Reddy.B
ETL & BI Tester Mail:***************@*****.***
Contact: +91-814*******
Professional Summary
Having 4 years of experience in ETL Testing and BI Reporting
Experience on Data ware house - ETL testing
Ability to adapt to new skills and technologies and dedicated to maintain high quality standards
Experience on ETL/DWH testing
Good hands on experience on db programming and SQL
Has testing experience in Informatica Power Center and Microsoft SSISand Scheduling Tools.
Hands on experience on writing, reviewing and executing the Test cases
Thorough knowledge on Data warehouse concepts like Data warehouse Architecture, Star schema, Snowflake schema, Data Marts, Dimension and Fact tables.
Highly motivated professional with integrity and commitment to quality and perfection
Good team player and strong knowledge in understanding the client requirements
Have an excellent quality of adapting to latest technology with Analytical, Logical and Innovative knowledge to provide accurate software solutions.
Professional Experience
Working as BI-Engineer for Sigmora Info Technologies Pvt Ltd, Hydrabad since Jan 9th 2012 to still date.
Worked at Keane India Pvt Ltd, Bangalore, Karnataka from Sep 5th to Jan 6th 2012.
worked at Core Logic , Bangalore, Karnataka from May 2008 to Sep 2nd 2011
Academic Qualifications:
B.Tech from Jawaharlal Nehru Technological University, Hyderabad ,A.P
Software Expertise :
ETL Tools : Informatica ,Ms-SSIS,Abinito
Databases : Oracle 9i &10g,Teradata 13.1
Languages : C, SQL .
Test Management Tool : Quality Center 9.0
Tools : TOAD, Putty
Operating Systems : UNIX, Windows XP/2003 Server.
Project Profiles :
Project #1
Title : Engineering Releases
Client : Rovi Corp
Technologies : Informatica8.6.0, Obiee
Database : Oracle 11g, Sql Server 2008
Role : QA
Project Description:
Rovi Corporation is focused on powering the discovery and enjoyment of digital entertainment by providing a set of integrated solutions that are embedded in its customers’ products and services and used by end consumers to simplify and guide their interaction with digital entertainment. The Company’s offerings include content discovery, video delivery and advertising. Content discovery solutions include interactive program guides (IPGs), recommendations, search capability, device management, media recognition technologies and licensing of its extensive database of descriptive information about television, movie, music, books and game content. Video Delivery solutions include video compression-decompression technology (codecs), the Rovi Entertainment Store video delivery solution, content authoring solutions,and content protection technologies and services.
. They are looking to implement decision support system using data warehouse for forecasting of sales, designing business model, cost and revenue analysis,Tax reports,Entiretainment store revenue for better utilization of resources. The main aim of this project is designing a data warehouse, transforming and loading data from transactional databases.
Responsibilities:
Involved in functional study of the Spec.
Running the Procedures/Workflows for ETL process
Verifying the ETL data in target database
Comparing the Day to Day reports from the two Prod databases.
Obiee Report Testing as the data reflecting as per business.
Downloading and watching of movies to check the data reflecting to
the corresponding databases.
Verified column mapping between source and target
Prepared high level test Scenarios and Test cases
Prepared test data for functional & Integration testing
Interactions with BA & Dev teams to resolve the issues.
Reporting daily testing status to Stakeholders.
Designed, Reviewed & Executed Test cases.
Identified Test cases for Regression testing
Defect Analysing and Reporting in QC
Project #2
Title : WOMS
Client : Morrisons, UK
Technologies : Informatica Power centre
Database : Oracle9i
Role : Test Engineer
Project Description:
The Warehouse Order Management System is a major component of the existing ASDA architecture.It maintains wine order details. The Wine orders are held and processed in the same database. The existing warehouse management system does not integrate direct website and grocery orders dirtectly. So the new designs loads direct and grocery orders into data warehouse along with Customer details, Orders details,Courier details ,Delivery charges etc
Responsibilities:
Involved in functional study of the Spec.
Running the jobs/Workflows for ETL process
Verifying the ETL data in target database
Verified column mapping between source and target
Prepared high level test Scenarios and Test cases
Prepared test data for functional & Integration testing
Interactions with BA & Dev teams to resolve the issues.
Reporting daily testing status to Client.
Designed, Reviewed & Executed Test cases.
Identified Test cases for Regression testing
Defect Analysing and Reporting in QC
Project #3
Project : Business Process Data Mart – II (BPDM - II)
Client : Core Logic, US
Work Location : Bangalore , India
Role : Test Engineer
Description:
BPDM-II provides the solutions for Core Logic customers in a hosted model. These solutions can be accessed via XML Channels. Core Logic has different products for mortgage and Risk Assessment Software that provides the solutions to its customers. BPDM-II provides information to evaluate the analysis of the products, products like AVM, HistoryPro, and IdentityPro so on.
Environment:
SQL Server 2005, SSIS, Hyperion Interactive reporting, Windows 2003/XP, DB
Responsibilities:
Involved in functional study of the application
Running the packages/Workflows for ETL process
Prepared high level test Scenarios and Test cases
Verifying the ETL data in target database
Verified column mapping between source and target
Prepared test data for functional & Integration testing
Interactions with BA & Dev teams to resolve the issues.
Reporting daily testing status.
Designed, Reviewed & Executed Test cases.
Identified Test cases for Regression testing
Defect Analysing and Reporting in QC
Contact this candidate