akki Contact
No: +919440592994
E-Mail: akhilreddyhyd@gmail.com
SUMMARY:
Having 4+ years of Software Testing experience
in which 2+ years in ETL Testing, 2.5+ years in manual testing
Professional
Experience:
·
Involved in Understanding the
business requirements
·
ETL Test Cases Preparation based on
the Business requirements and Mapping logic.
·
Testing the result by preparing SQL
queries for source and target for each scenario in functional spec.
·
Preparation of database and ETL test
cases according to assigned module.
·
Data validation using Database tools.
·
Analyze the result and log the
defects in bug tracking tool.
·
Preparing the Test Data. Involved in
validating the data.
·
Involved in System testing and
generated the source & target mismatch Reports
·
Involved in Peer-Reviews on Test
Cases prepared.
·
Involved in ETL process data quality
and testing.
·
Testing the data as per requirements
and preparing the Test data.
·
Ability to validate the completeness,
integrity and accuracy of data.
·
Good Exposure to SDLC and STLC
·
Experience in Functional and
Non-Functional (GUI Testing, Usability, Reliability and Compatibility) Testing
Types.
·
Good Exposure on Bug Life Cycle.
·
Good Knowledge in SQLServer 2005
·
Expertise on Black box Testing
Techniques, like BVA, ECP, Use Case Testing.
Education
Details:
·
MCA from Osmania University in 2008.
Software
Skills:
Software Testing : ETL Testing & Manual Testing
Operating systems : Windows 2000 Prof, XP, Win 2000 Server,
UNIX
Databases : DB2, SQL Server 2005
Test Management Tools :
Quality
Centre.
Tools & Utilities : Ms-Office
Information Discovery Tools : Toad for DB2, SQL Server Mgmt Studio.
Scheduling Tools : Control M
Experience
Details:
Working as a ETL Test Engineer for Accenture
Services Pvt Ltd from July 2012 to till date
Worked as Test Engineer in MGRM Net Ltd, Delhi from Jan 2010 to April 2012
Project
# 1
Client : STARBUCKS, USA
Domain : Retail
Environment : Informatica
8.6.0, DB2, SQL SERVER, Toad for DB2, SQL Server . Mgmt
Studio, WinScp, HP QC, Windows XP, UNIX
Duration : July 2012 to till date
Project
Description:
Starbucks Stores, Which is one of the
organization that sells various number of products. Starbucks have various
stores across USA, which maintains Sales, profits with lots of historical data.
This project was to create Sales Data Warehouse and generate reports using
Reporting services. The aim of sales data Warehouse is to analyze the sales and
profit in month wise and year wise. The data gets refreshed yearly and is
maintained historically. This Data warehouse plays a major role in enabling
various stores to view the data at a lowest level and help them to make
decision to bring more revenue to company with new policies.
Roles &
Responsibilities:
·
Involved in Understanding the
business requirements
·
ETL Test Cases Preparation based on
the Business requirements and Mapping logic.
·
Executing the test cases, Reporting
bugs and Requirement walk through Daily interaction with the client &
onshore team about status and execution plan Involved in Understanding the
requirements and preparing the test plan Performing functional, System
and Regression testing to make sure application is meeting all the requirements.
·
Running SQL Scripts to verify the
Source and target are matching
·
Testing the result by preparing SQL
queries for source and target for each scenario in functional spec.
·
Preparation of database and ETL test
cases according to assigned module.
·
Data validation using Database tools.
·
Analyze the result and log the
defects in bug tracking tool.
·
Preparing the Test Data. Involved in
validating the data.
·
Involved in System testing and
generated the source & target mismatch Reports.
·
Involved in Peer-Reviews on Test
Cases prepared.
·
Involved in ETL process data quality
and testing.
·
Testing the data as per requirements
and preparing the Test data.
·
Ability to validate the completeness,
integrity and accuracy of data.
Project
#2
Project : M-Star SES (School Expert System)
Client : paramount International
School, Navodaya high
school
Environment : VB.net, SQL
Server, Segate Crystal
Reports
Role : Test
Engineer
Duration : Jan 2011 to April 2012
Project
Description:
School Management System
focuses on all aspects
of functioning of schools and
works for all
segments of the school system - from the pre-primary to primary to middle
and then from the secondary level to higher secondary levels.
At the management level, SMS
provides a single integrated platform for all its governance requirements. Its
unique abilities lie in growing inters- user’s relationships such as school,
students, teachers, administrators, parents. In terms of flow of real benefits,
it is a real user experience.
SMS is a window within a window. User can
click and go to any window. User can plan activities and tasks. Its customized
homepages with dashboards for individual users bring in an individual focus
with high level security, its 6 Modules including Utility modules supported
through hundreds of sub-modules give over 200 Reports, including graphical,
which can be printed exported or mailed out. It can track entries done to date
or for any date. It is a platform for true e-Learning.
User can access specific information as
per any need by a variety of methods like through Information Builder, Alert
system and Query builder
Roles &
Responsibilities:
- Involved in Requirements analysis, preparing test scenarios, and test cases, implementing them and reporting defects.
- Generation of Test cases as per Test plans and BRS.
- Newly implemented functional features testing.
- Involved in functional, integration, End-to-End, performance, black box testing.
- Testing & Bug Reporting.
- Performed database testing where ever required.
- Performed Compatibility testing.
- Retesting the application for new build.
- Executing the test cases and authoring the test cases for the Adhoc bugs that are encountered.
- Study of Change Requests and authoring test cases.
- Performing Regression testing.
Project
#3
Project : Office Expert
System
Client : NDMC School, Modern international school
Environment : VB.net, SQL
Server, Segate Crystal
Reports.
Role : Test
Engineer
Duration : Jan 2010 to Dec 2010
Project
Description:
Office expert system handles all
the information for an employee is handled. It’s a complete HRMS system where
all information likes-: personal details, employment details, Grades, completed
salary structure and every month payroll. HR module is dedicated to managing
core HR functionalities and personnel activities. It is the single point entry
for all employee records, personal details like health, qualification, last
employment, accomplishments and awards, service records, self-assessment
details, retirement and resignations. Employee information can be retrieved at
a click of a button using the robust reporting capabilities. Payroll module
meets the expectations of payroll officers in generating timely and accurate
salary calculations and statutory compliances. The simple, flexible,
user-friendly module allows users to define salaries based on slabs/ a formula
integrated with employee attendance, handles ESI and PF processing and performs
payroll operations faster. Transactions such as monthly pay slip generation,
bank statements, salary register and others are done effortlessly through the
system.
Roles &
Responsibilities:
- Involved in Requirements analysis, preparing test scenarios, and test cases, implementing them and reporting defects.
- Generation of Test cases as per Test plans and BRS.
- Newly implemented functional features testing.
- Involved in functional, integration, End-to-End, performance, black box testing.
- Testing & Bug Reporting.
- Performed database testing where ever required.
- Performed Compatibility testing.
- Retesting the application for new build.
- Executing the test cases and authoring the test cases for the Adhoc bugs that are encountered.
- Study of Change Requests and authoring test cases.
- Performing Regression testing.
Date: Thank You,
Place: (akki)
No comments:
Post a Comment