Manager Data
Resume:
Sai Sharan Muppidi
*****************@*****.***
QA analyst-ETL Testing/BI Testing/DW Testing Web Testing-Cognizant Technological Solutions
6+years of Experience in Software Testing in Banking Finance Services at Cognizant Technological Solutions.
Sound Knowledge of Testing concepts and Methodology with ISTQB Certification.
Involved in Conventional water fall model, V Model and Agile Methodologies.
Expertise on ETL (Extract Transform and loading), Business Intelligence Testing.
Retrospected the issues by verifying the Sessions logs.
Involved in development tasks like creating work flow mappings.
Involved in analyzing the source data coming from different Data sources such as XML, DB2, Oracle, flat files.
Worked on Banking and Finance data and extracted the data from Simple flat file, MS SQL Server and Oracle.
Proficient and diverse work experience in Manual, Automation, ETL, System (SIT), Acceptance (UAT),
Regression, Integration, Functional and Usability Testing.
Worked in Web services testing by using Soap UI and Rest
Involved in designing data warehouses and data marts using Star Schema and Snow Flake Schema.
Extensively worked on ETL process which includes data transformation, data sourcing, mapping, conversion and loading.
Experience on testing Null value,Data Integrity, data analysis, Data profiling, auditing, balancing.
Good knowledge on Power center( Informatica 9.6.1) which includes Work Flow Monitor, Manager, Designer
Knowledge on Power Exchange and Reporting tool like Business Objects.
Having sound knowledge on OLAP and OLTP Process.
Worked on SAP BO Reports like Adhoc Reports and Ammc reports
Having knowledge on Data mart etc.
Ability to understand complex requirements and there by simplifying that to the Team mates.
Experience in setting up onsite calls and involved in giving Effort Estimation and Efficient implementation of resources to the project
Good knowledge and experience in STLC model from project design to implementation phase.
Experience of Work in all the stages of testing including Requirement Analysis.
Basic knowledge and hands on in QTP Automation Testing Tool.
TECHNICAL SKILLS:
Scripting Languages
VB, SQL, Java,Unix and Linux Commands
Application Packages
Microsoft Office
Operating Systems
Windows7,10, Linux,Unix
Databases
SQL Server, Oracle,DB2, Teradata
BI,ETL tools
Power Center, Work Flow Manager, Monitor, Power Exchange, SAP BO, SSIS
Testing Tools
HP QC ALM,JIRA,HP QTP
Tools
Microsoft Server studio, Toad, SQL Developer,Putty, Soap UI,Rest
INTERNAL CERTIFICATION
Cognizant Certified Program – Software testing level-0
Cognizant Certified Program – Banking and Financial Services level– 0
Cognizant Certified Program – QA
EXTERNAL CERTIFICATION
ISTQB.
PROJECT PROFILE
Client :CREDIT SUISSE
Project 1: CREDIT SUISSE Asset management:-
Project Duration& Location:-Aug 2010-Feb2013, Hyderabad, India
Team Size:2
Technologies:-MsSQLServer,Informaica9.6.1,SAP BO,HP QC,Ms SQL Server Management Studio,Linux
Description:-
Asset Management offers a wide range of investment products and functions across asset classes and investment styles. The division manages global and regional portfolios, mutual funds, and other investment vehicles for governments, institutions, corporations and individuals worldwide.
Keystone:-
Keystone is a Software which enables the customer’s to upload a Raw flat file which in turn undergoes ETL Process and gets loaded in to Data Ware house where in,Data gets pulled for the Updated Reports using a Reporting tool called SAP Business object.
Roles and Responsibilities
- Requirement analysis and understanding the Functional Requirements based on FRS
- Worked on Complex SQL Queries like Joins and Sub queries.
- Involved in designing data warehouses and data marts using Star Schema Schema.
- Preparing Test Scenarios and Test Cases
- Working with ETL Source System and Target System ETL Mapping Document for writing test cases and test scripts.
- Test Metric Reporting.
- Verify and Analyze data mapping (ETL) that defined technical and business rules.
- Used advanced Excel functions and Formulas to generate spreadsheets and pivot tables
- Conduct peer reviews during Test Design and Execution phase
- Participate in project status calls, review meetings and status mails to Onsite Tech Manager.
- Verify and Analyze data mapping (ETL) that defined technical and business rules.
- Verify ETL mappings, mapplets and reusable transformations for daily data load.
- Writing complex queries in MS SQL Server studio to check the data from Source and Target.
- Used Excel to import and export data to a central Database
- Worked on Slowly Changing Dimensions Concepts.
- Defect logging, tracking and reporting using Track Record.
- Monitor and ensure the schedules of all the deliverables from offshore.
- Preparing daily status reports (MOM, Status mails)
- Prepared test plan and test strategy for all the projects.
Client :AMEX
Team Size:1
Project Duration:-Feb 2013-Nov 2013
Technologies:-Oracle11g,Informaica9.6.1,SAPBO,Jira,Toad,Linix,Windows7,PowerExchange,Workflow Monitor,Manager,Work flow Designer.
Project 2:- Terms and Condition Migration.
The core objective of this project is to fetch all the Content present in the Terms and Conditions section from a centralized DB with the help of service interaction. The fetching action previously was done from the xmls without any service interaction.
Roles and Responsibilities
- Requirement analysis and understanding the Functional Requirements based on FRS
- Raising Clarifications and getting it clarified from client
- Involved in designing data warehouses and data marts using Snow flake Schema Schema
- Preparing Test Scenarios and Test Cases
- Working with ETL Source System and Target System ETL Mapping Document for writing test cases and test
- Writing several SQL statements to confirm successful data transfers between source and target. scripts.
- Analyze data sources and create data migration templates.
- Worked on Complex SQL Queries like Joins and Sub queries.
- Detailed analysis of the requirements, documentation, test cases preparation, coding and testing.
- Test summary preparation, Support trouble shooting in the application.
- Perform Count Validation, Dimensional Analysis, Statistical Analysis and Data Quality Validation
- Audit peer reports and provide constructive feedback.
- Participate in project status calls, review meetings and status mails to Onsite Tech Manager.
- Defect logging, tracking and reporting using Track Record.
- Monitor and ensure the schedules of all the deliverables from offshore.
- Preparing daily status reports (MOM, Status mails)
- Prepared test plan and test strategy for all the projects.
Client : AMEX
Project 3:-Regression testing
Project Duration& Location:-Feb 2014- June 2014,Hyderabad,India
Technologies:-HP QTP, Oracle, Hp QC, Jaws, Windows 7
Project Description:
Express Apply is an enhancement of an existing web-based application for applying American Express Credit Cards. Express Apply is a sum up of Express Apply _CCSG and Express Apply _OPEN, referring to Personal Card and Business Cards respectively. The enhancements encompass a wide range of UI aspects and business logic to serve the customer with more real time and quick interaction. Most of the html pages have been upgraded to flash pages that include different animations of the card images. The apply site is currently used to help existing card members and prospective card members to find the right card to suit their needs. Express Apply provides the flexibility for the customer by the process of Instant Decision for the Cards which are either approved or rejected based on the customer details submitted. Express Apply is designed to be compatible with most of the latest web-browsers.
Roles and Responsibilities’:-
- Executed Automation Scripts.
- Updated and maintained the scripts.
- Took Owner ship and lead the team.
- created effective script which supports complex frame works.
- Requirement analysis and understanding the Functional Requirements based on FRS
- Raising Clarifications and getting it clarified from client
- Preparing Test Scenarios and Test Cases
- Conduct peer reviews during Test Design and Execution phase
- Participate in project status calls, review meetings and status mails to Onsite Tech Manager.
- Involved in System Integration testing, Regression testing, Assembly Testing and Performance testing, Automation testing.
-Preparing daily status reports MOM, Status mails
- Prepared test plan and test strategy for all the projects.
-Involved in writing Requirement Tractability
- Attend daily Sprint and Agile meetings.
Project 4: DLP
Technologies:- MsSQLServer 2008,Informaica9.6.1,SAPBO,Jira,MsSQLServer Management
Project Duration& Location:- June 2014 to May 2015,Hyderabad,India
Dynamic Landing pages:-
Dynamic Landing pages concept is common for all Business, Personal and partner cards.
In this we are dealing with Card advertisement which with get posted in a Social Networking site. Where the customer is enabled to click on the advertisement and can apply for the card. It is common across all the flows.
Team size:1
Roles and Responsibilities
- Preparation of BI QA strategies and Test Planning.
- Develop process for Data Analysis and testing Data flow.
- Retrospected the issues by verifying the Sessions logs.
- Verify Informatica ETL mappings
- Retrospected the issues by verifying the Sessions logs.
- Verified the Data in the Reports generated from Business Object.
- Mentoring and induction of new team members.
- Perform Count Validation, Dimensional Analysis, Statistical Analysis and Data Quality Validation
- Audit peer reports and provide constructive feedback.
- Working with ETL Source System and Target System ETL Mapping Document for writing test cases and test scripts.
- Writing several SQL statements to confirm successful data transfers between source and target.
- Verify ETL mappings, mapplets and reusable transformations for daily data loads.
- Verify and compare ETL Source and Target database systems.
- Mentoring and inducting new team members.
- Participate in QA build deployment, code reviews and version controls.
- Create Ad-hoc reports, AMMC reports to users in SAP Business Objects by connecting various data sources.
- Identify, analyze, and document problems with functionality, output files or tables.
Project 5(Current Project):-Risk Assessment for capital banking
Project Duration& Location:-(Aug 2016- present),Pittsburgh,USA
Client:-PNC Banking.
Risk Assessment:-
This Module is all about Analyzing the different projections and data which undergoes ETL Process and the Refined data is useful for Analyzing the Risk involved in taking the business decisions.
ACADEMIC CREDENTIALS:
Degree
College
University
Year
B.Tech
TKR College of Engineering and Technology
JNTU
University( Hyderabad, India)
2007-2011
Masters
Silicon Valley
Silicon Valley University( Sanjose, California)
2015-2017
Contact this candidate