ETL Test Lead,SQL Server,Oracle,Informatica,MS Bi, Toad,Ssms,QC,Alm
Resume:
Sravan Kumar Dunna
******.*****@*****.***
PROFESSIONAL SUMMARY
Seasoned Testing/QA Professional having 16+ years of experience and track record of providing testing solutions and delivering complex testing programs in Global delivery model and Matrix structures.
Testing Professional with passion for quality and passion for research assesses technology and industry trends, evaluating their possible value and applicability.
Extensive experience in planning and executing strategy for testing the Database, DWH, ETL, Data Migration and Data porting projects.
Having more than 8 years development experience using SQL Server, Oracle, Sybase, .Net and Java.
Very good experience in SQL Server Administration, PL/SQL and performance tuning of data base applications.
Excellent hands on experience in scripting, analyzing,debugging,reviewing and performance tuning of complex SQL Queries, PL/SQL code and Stored Procedures and functions.
Good exposure to ETL tools like Informatica, Data Stage and Microsoft BI.
Expert in functional Testing with an end user mind set to add value to the business.
Excellent data Analysis skills and the ability to track a data element from source through transformation to target.
Very strong with ETL data validation using ETL environments (Informatica/ ODI /Data stage/SSIS).
Exceptional in End-to-End data validation for ETL & BI systems.
Expert in preparation of SIT/UAT and Regression test strategy for complex ETL Architectures.
Exposure to various ETL testing tools like SQL Server Utilities, Informatica DV, Denoda, Query Surge and also developing internal ETL testing Utilities.
Expert experience in Test Plan, Test Strategy preparation, Test Environment planning,Test Data Preparation, Test Scenarios /Cases preparation and Test case execution for complex ETL Projects .
Very good exposure to Guidewire and experience in preparation testing solution for Guidwire Data migration and testing.
Excellent hands on experience on all popular Test Management/Defect Management tools which includes open source and licensed s/w.
Expertise in understanding business data requirements and formulate the various scenarios and identifying the test scenarios and Test Cases accordingly.
Expert in estimating the testing efforts for applications using various effort estimation techniques based on technology and business complexity.
Proven experience in optimizing the testing efforts without compromising on test coverage using various techniques like Risk Based techniques.
Excellent knowledge in SDLC and STLC with experience in manual testing and exposure to Automation testing.
Excellent problem solving and analytical skills, excellent verbal and written communication skills; ability to function in a demanding environment; quality proponent; ability to assume the perspective of customers and their users and serve as their advocates.
EDUCATIONAL QUALIFICATIONS
Degree
Institution
Year of Completion
M.C.A (Master of computer applications)
Osmania University, India
1998
M.B.A (Master of Business Administration)
Alagappa university, India
2012
TECHNICAL SKILL SET
Operating System : Windows 95/98/2000/NT/XP/Windows 7 and UNIX
Environment : Client Server, Web Based, Mobile Apps Data warehouse, BI and Mainframes
Database : SQL SERVER, ORACLE, Sybase, DB2
ETL Tools : Informatica, MS BI & Data Stage
Internet Tools : HTML, Perl, VB Script, Java Script
Languages : SQL, PL/SQL, Java
Other : SAP MM and SD, Ramco he enterprise series (Marshall), MS-Office Suite,
MS-VSS, Crystal reports, Erwin and Toad
Software Testing : Functional and Non Functional, Database/ETL/BI/Data Migration testing
and Data Warehouse Testing
Test Management Tools : HP ALM, Microsoft Test Manager (MTM),
Rational Clear Quest, JIRA, MS Team Foundation Server (VSTF), SharePoint
Test Automation : VSTF, Selenium, UFT and Load Runner, Microsoft Test Manager
Methodologies : Agile, LEAN and Waterfall
CERTIFICATIONS
1.ISTQB Foundation Level (International Software Testing Qualification Board)
2.Microsoft Certified IT Professional SQL Server 2005
3.Microsoft Certified IT Professional SQL Server 2008
4.Certified Scrum Master
WORK EXPERIENCE
S .No
COMPANY
CLIENT/PROJECT
PERIOD
ROLE
1
Capgemini India Pvt. Ltd
AIA - Philam Life
Aug 2015 – Sep 2017
ETL UAT Test Lead
2
Farmers Insurance
Jun 2014 – May 2015
Test Architect
3
AIG
Jan 2014 – May 2014
ETL Test Lead
4
Euroclear
Aug 2012 – Dec 2013
Testing SME
5
RBS
Nov 2011 – Aug 2012
ETL Test Lead
6
Microsoft India Pvt. Ltd
Microsoft Corporation
Mar 2008 – Oct 2011
Test Lead - BI
7
Wipro Technologies
British Petroleum
Aug 2007 – Mar 2008
Project Lead
8
Microsoft Corporation
April 2005 – Aug 2007
Sr. Software Engineer
9
Ramco Systems
Marks and Spencer’s
Jan 2004 – Mar 2005
Systems Analyst
10
Ramco i Enterprise Series
Feb 2001 – Dec 2003
Design Engineer
TRAININGS & SEMINARS
SAP MM and SD
SQl Server DBA
Oracle 8i
TSP/PSP
Effective communications, Precision Questioning and Answering
Non functional Testing
Negotiation Skills/Effective Decision making
4 Days Work shop on Database/DWH/ETL/BI testing
PUBLISHINGS/PRESENTER
Published white paper on Data Quality in Microsoft Corporation.
Published white paper on DWH/ETL Testing in Microsoft Corporation.
Brown Bag sessions in Microsoft Corporation on Data Quality.
Seasoned facilitator for Insurance Domain training in Capgemini India.
Seasoned facilitator Test effort Estimations work shop for laterals in Capgemini.
Seasoned facilitator 1 week testing fundamentals session for fresher.
Seasoned SQL Trainer within and outside organization .
Member of ETL/DWH and BI Testing CoE in Capgemini and contributor for creating internal testing tools.
Seasoned Facilitator for ETL Testing Sessions to experienced associates in Capgemini.
Member of Microsoft Student partner training program @Microsoft India.
Volunteered in conducting orientation courses for college graduates.
PROJECT DETAILS
#1 Client: AIA Philam Life – Philippines Aug 2015 - Sep 2017
Role: UAT Test Lead
Project Name: EDEN
Employer: Capgemini
Description: EDEN is the EDW project to integrate the data available in multiple business applications and legacy applications to build data platform for the new applications developed part legacy modernization.
Responsibilities:
Collaborated with business and development teams to drive business data requirements and developed seamless ETL architecture.
Participation in requirements meetings and data mapping sessions to understand business needs.
Understand the systems from which data needs to be sourced and prepare the strategy to extract required data and convert to store in Data warehouse.
Validate source to target mappings using a variety of tools, including Business Objects Data Services/BODI
Recommend data standardization and usage to ensure data integrity to the business.
Collaborated with developers and performance engineers to enhance supportability and identify performance bottlenecks.
Preparation of Test Plans and Test startegy for Functional, ETL testing projects.
Testing metrics collection and reporting.
Preparation daily and Weekly status reports .
Track requirements coevrage, Defects and execution progress in ALM .
Estimating the testing efforts and loading the resources to align with project schdules.
Propsosing and deploying the accelarators and tools which can increase the testing productivity to provide value addition to the customers .
Tools/Skills: HP ALM, Erwin, SQL Server, CDC, Informatica (IDQ,PWC,PWX), DB2, AS400 and Tableau
#2 Client: Farmers Insurance-US Jun 2014 – May 2015
Role: Test Architect
Project Name: DATA LAKE
Employer: Capgemini
Description: Data Lake is to collect all the data from various insurance function in Farmers insurance and create DWH and Data marts which can be used to create reports for business for crucial decision making.
Responsibilities:
Analyzed the business requirements and identify the testing requirements.
Interacted with Program manger and Business analyst to understand the business requirements for each release.
Identified test project risks, Issues and other dependencies and discuss with stake holders for mitigation plan.
Prepared high level test estimations and High level test scenarios to base line the release.
Prepared test plan and strategy for each Minor/major release.
Did the walk through of Test Plan and Test strategy with stake holders.
Participated in Test scenario and Test case reviews.
Scheduled and participated defect triage meetings.
Prepared and circulated daily and weekly status reports.
Coordinated with Design, Development, BA, Deployment, Test Data team and business for reviews, Clarifications and other issues.
Prepared test closure report and perform test closure activities.
Support the developers by creating complex SQL Queries, PL/SQL code, Stored Procedures and functions for re usability.
Written complex SQL Queries to retrieve the data from application program.
Tools/Skills: HP ALM, TOAD, SQL Server, Oracle, HADOOP, Informatica and Tableau
#3 Client: AIG – US Jan 2014 – May 2014
Role: ETL Test Lead
Project Name: ODS (Operational Data Source)
Employer: Capgemini
Description: ODS is intended to maintain homogenous data coming from various legacy systems developed in different technologies to enable the users to retrieve the data from one place with ease.
Responsibilities:
Involved in the design of product and project requirements - identify test approach - test coverage gaps and risks. Writes detailed test strategy and plans.
Written complex SQL Queries to retrieve the data from application program.
Support project managers - raise quality issues through established channels.
Experience converting the User Stories, Technical Implementation and Business Requirements to Test Plan- Scenarios and Test Cases.
Collaborate with business teams, system analysts and Development Team to understand business, Design, technical functional requirements and Technical Implementation.
Maintain documentation of test results.
Analyzes test results to ensure existing functionality and recommends corrective action.
Ability to review technical requirements with data warehouse and business intelligence terminology to produce test strategies, test scenarios, and test cases for the data warehouse team.
Assist with data architecture and data modeling
Interacts with development engineers, business analysts and support groups.
Tools/Skills: Quality Center, Sybase, Data Stage, Business Objects
#4 Client: Euroclear-Brussels Aug 2012 – Dec 2013
Role: Testing SME
Project Name: Easyway SQL
Employer: Capgemini
Description: TANDEM is a legacy system for settlements, Easyway SQL is a data migration program to move all the data from TANDEM to SQL Server to develop new generation applications.
Responsibilities:
Develop test plans, test scenarios, test cases, test data and test scripts for different types of testing activities.
Perform execution of test cases, test scripts, captures test results, test metrics and reports them.
Identify and tracks system defects, Performs root cause analysis of the defects and works with the development team to resolve them.
Written complex SQL Queries to retrieve the data from application program.
Performs and coordinates system verification and validation test activities utilizing various tools such as HP Quality Center/Application lifecycle Management.
Contributes to improvements in unit testing coverage, design test framework, develop test suites, expand automated testing harness and automate scenarios/cases
Logs defects and make recommendations to address defects
Tools/Skills: HP Quality Center, SSMS, SQL Server, MSBI
#5 Client: Royal Bank of Scotland -UK Nov 2011 – Aug 2012
Role: ETL Test Lead
Project Name: RISK – BASEL II
Employer: Capgemini
Description: RISK DB is used for RISK Analysis by RBS and it went through the change to implement the Basel II standards.
Responsibilities:
Work with our project teams and business users to understand business requirements to develop effective test plans
Assist with data architecture and data modeling
May conduct performance and scalability testing
Become expert in source systems and data, through data profiling and analysis efforts using SQL or other tools
Assist in requirement design and validation.
Develop and execute software test plans.
Performs and coordinates system verification and validation test activities utilizing various tools such as HP Quality Center/Application lifecycle Management.
Logs defects and make recommendations to address defects
Tools/Skills: Jira, Oracle and Informatica
#6 Client: Microsoft Corporation- US Mar 2008 – Oct 2011
Role: Test Lead - BI
Project Name: Volume Licensing Repository
Employer: Microsoft
Description: Volume licensing repository is to maintain all the licensing details of the MS Products sold and it will be used to Auto Renewal of license and generating the invoices.
Responsibilities:
Develops test plans, cases, scenarios and scripts to thoroughly understand the impact and test new solutions development and maintenance projects.
Isolate, replicate, and report defects and verify defect fixes. Analyzes and troubleshoot erroneous results, determine the root causes and help is resolving the issues.
Validates data integrity by creating and executing relatively complex queries. Perform functional and regression testing to include data validation /verification.
Design and develop test plans to validate our data warehouse processes and business intelligence applications
Conduct thorough testing of ETL code changes to ensure quality of data produced
Analyzes and writes test standards and procedures.
Conducts Manual Testing, and uses strong Exploratory Testing to uncover weaknesses in test approaches
Tools/Skills: MS VSS, MTM,SQL Server CDC,SQL Server, MSBI
#7 Client: British Petroleum –UK Aug 2007 – Mar 2008
Role: Test Lead
Project Name: MOFT (Middle office Fast Track)
Employer: Wipro Technologies
Description: Middle office Fast track is middle office application to support the traders for Oil trading. This collects the data from various systems and converts as per user requirements for direct query.
Responsibilities:
Managed testing cycles, including test plan creation, development of scripts and co-ordination of user acceptance testing.
Participated in Functional/Technical specification documents review and performed Static /White box testing.
Define business goals to determine systems requirements and certify the developed product before delivery.
Confirm that the software delivers the correct data every time and in time.
Implemented user acceptance testing with a focus on documenting defects and executing test cases.
Performed regression and system-level testing to verify software quality and function before it was released.
Tools/Skills: Jira, Sybase,DB2,Mainframe,SQL,PL/SQL
#8 Client: Microsoft Corporation-US April 2005 – Aug 2007
Role: Sr. Software Engineer
Project Name: Pay Common DB & HR Common DB
Employer: Wipro Technologies
Description: Pay common and HR common databases integrate with MS SAP system and will porting the data changes to SAP systems to enable SAP to generate payroll with latest information.
Responsibilities:
Worked effectively with design teams to ensure software solutions elevated client side experience.
Confirm that the software delivers the correct data every time and in time.
Performed dog food testing before introducing the Microsoft product in to the market.
Performed data profiling whenever new source system added to the architecture and suggested the data standardization.
Participated in Functional/Technical specification documents review and performed Static /White box testing.
Performed regression and system-level testing to verify software quality and function before it was released.
Built automated test suites and deployed scalable, highly available and modular software products in to development and UAT environments.
Tools/Skills: MTM,SQL Server, MSBI (SSAS,SSIS and SSRS), SQL,PL/SQL
#9 Client: Marks and Spencer’s - UK Jan 2004 – Mar 2005
Role: Systems Analyst
Project Name: COFS – Customer Ordering Financial System
Employer: Ramco Systems
Description: COFS is an order processing system which is integrated with Financial system developed in Mainframes .Financial systems will be updated based on the Orders processed in COFS.COFS is the Sales Order module in Ramco ERP.
Responsibilities:
Understand product requirements from Business analyst and convert them to Technical requirements
Customization of ERP product based on customer business requirements.
Contributed to the automated deployment of software on multiple virtual machines.
Developed PL/SQL blocks, Stored Procedures and Function to address the complex business requirements.
Wrote SQL stored procedures, PL/SQL codes to address complex business calculations.
Implemented the customized product at client locations and participated in User acceptance testing.
Written complex SQL Queries to retrieve the data from application program.
Tools/Skills: Quality Center, SQL Server, Oracle, BizTalk, DB2, Mainframes, SQL, PL/SQL
#10 Client: Ramco Feb 2001 – Dec 2003
Role: Design Engineer
Project Name: Ramco i Enterprise Series
Employer: Ramco Systems
Description: Ramco i Enterprise Series is a web based ERP system developed by Ramco Systems using Ramco Virtual works frame work.
Responsibilities:
Design and developed ERP application using RVW Framework using Oracle, SQL Server and Visual Basic software.
Collaborated with requirements group to understand industry standards and change the design and code.
Engineered configuration server in RVW to reconfigure Ramco i Enterprise series.
Developed shared central authentication system in for intranet applications.
Monitored and updated back-end data by inter-communicating between RVW and Data base.
Contributed to the automated deployment of software on multiple virtual machines.
Oracle and SQL Server Database administration.
Code migration from SQL Server to Oracle Data base.
Leading a group of 40 engineers in the design and development of SQL Server and Oracle -based ERP Applications.
Developed and evolved the consumer-facing, multi-channel roadmap for desktop and web applications.
Data modeling using ERWIN and creating the database objects in SQL Server, Oracle servers.
Written complex SQL Queries to retrieve the data from application program.
Developed /customized the interfaces between external and internal applications using Java and .Net.
Tools/Skills: SQL Server, ERWIN, Oracle, Ramco Virtual Works, SQL, PL/SQL
Contact this candidate