Prasanna Kumar Narayana Setty

acygi7@r.postjobfree.com (Cell No. : 224-***-****)

SUMMARY:

Overall 14+ years of professional experience in Banking, Finance, Insurance, Retail, HealthCare, Pharmaceuticals sales and IT Industry with specialization in Software Testing using Manual Techniques.

10+ years of experience in BI-ETL, Report Testing, Integration, Regression, UAT, Automation, DevOps – Continuous Testing, RESTful API Services Testing, ATDD, BDD Testing, Mobile Apps Testing and End to End testing (DWH/DB /DWH Migration and Functional Testing) and 3 years of Production Support and maintenance.

Well acquainted with all phases of Software Development Life Cycle (SDLC) methodologies like Waterfall, Agile and V Model, specialization in Verification and Validation.

Working knowledge in multiple areas of Software Testing life cycle including Test Project Management, Project Estimation, and Test Planning, Test Scripting, Test Execution, Bug Tracking, Review and Metrics collation.

Proficient in analyzing Business Requirements, System Requirements, Functional Requirement Specification (FRS), Design Documents, Use Case Specifications, and User Stories.

Experience in User Acceptance Testing, GUI Testing, System & Functional Testing, Ad-hoc testing, Black Box Testing, White Box Testing.

Experience in Defect management, defect analysis and defect reporting using various Defect Tracking Tools.

Experience in DevOps Continuous Integration Testing and Mobile Testing.

Experience in Data Warehouse projects specializing in ETL testing, Database testing and Reports testing.

Good exposure in writing SQL Queries to perform data driven test validation. Exposure in working with front-end and back-end testing.

Exposure working with .Net and Mainframe applications testing.

Learnt and implemented Java Cucumber framework automation and with Selenium WebDriver.

Knowledge on working with Hadoop Ecosystem stacks including HDFS, Sqoop, Pig and Hive.

Exposure working with Tool configuration & Customization Testing for E-Commerce platform.

Excellent Analytical, Problem Solving and Documentation skills including Team leadership coupled with aptitude to motivate team members towards goals, and Strong interpersonal, written & oral communication skills and capable to work on multiple project/product assignments.

Lead teams of testers from team size 10 to 20 people, Managed small to medium size projects, and have experience in interacting with offshore teams, onsite teams, clients counterparts.

Received several organizational level awards and recognitions.

Holding a valid H1-B visa.

EDUCATION:

M.Sc. Degree in Electronics, 2001 University of Mysore, Karnataka, India.

TECHNICAL SKILLS

Operating System

HP Unix, Windows 2000Professional/NT/XP, and MSDOS

BI/ETL Tools

Informatica, Ab-Initio, OBIEE, Cognos, SSRS, Netezza, MicroStrategy

Testing Tools

HP-Mercury Quality Center, JIRA, HP UFT, Cucumber - Gherkins, SOAP UI, Selenium

Version Control Tool

SharePoint, GitHub, TortiseGit

Database

ORACLE 8i/10g, SQL Server, Teradata, MongoDB

Testing Types

Black Box, Functional, Integration, System, Regression, User Interface, Database, DWH/ETL, Mobile and DevOps Continuous Integration Testing, Mobile Apps Testing

Programming Languages/Tools

Java, SQL, TOAD

Financial Planning Tool

JustEnough & T4G FP

Retail Suite

NetSuite

Agile Management Tool

VersionOne, JIRA

Analytics Tool

Actimize – Risk Case Manager (RCM)

Build Management Tool

Jenkins

WORK EXPERIENCE

Client: Deutsche Bank AG, Cary, NC June 2016 – Till Date

Role: Project Lead

Deutsche Bank AG is a German global banking and financial services company with its headquarters in the Deutsche Bank Twin Towers in Frankfurt. It has more than 100,000 employees in over 70 countries, and has a large presence in Europe, the Americas, Asia-Pacific and the emerging markets. Deutsche Bank’s core business is investment banking, which represents 50% of equity, 75% of leverage assets and 50% of profits. Services include sales, trading, research and origination of debt and equity; mergers and acquisitions (M&A); risk management products, such as derivatives, corporate finance, wealth management, retail banking, fund management, and transaction banking.

Project Summary:

siWorker is a replacement for the Report Generator/Actuate components that is designed to handle commodity CSV, PDF, XLS/XLSX files without costly Actuate licenses. The siWorker is a Java/Spring Integration application that uses configuration (metadata) to define a report rather than coding in VBA as is done with Actuate now. The siWorker processes run in parallel to the Report Generator/Actuate processes and in time will completely replaces the Report Generator/Actuate processes.

The Report Generator system is responsible for coordinating the batch report generation for the Prime Brokerage at the bank. Its main responsibility is to create the reports for each business day, verify if the data is available for each report, and then coordinate the report generation with the system Actuate for batch reporting. An additional responsibility of the Report Generator is to coordinate the report distribution such as Email, FTP, SFTP and Fax.

Responsibilities:

Regular Interaction with client and business users to understand the requirement and set up quality process translation in Software implementation.

Involved in preparing Test Plan, Test Cases, execution of Test Cases and Timelines for the projects and conditioning test data.

Learning and implementing Java Cucumber framework automation for the report generation testing.

Involved in writing features files using Gherkins to automate the report generation for Continuous Integration Regression Testing.

Building the reports with parameters and running through Jenkins

Worked on RESTful API web services testing.

Worked in Acceptance Test Driven Development testing.

Defining the Scope of testing within the context of each Sprint release / delivery.

Identifying Issues/defects and tracking them till the resolution, Root Cause Analysis and possible solutions for errors encountered and Preparing Status Report.

Providing testing statistics and metrics to Client and to the project Management.

Co-coordinating with offshore team and multiple vendor Development team.

Client: Bank of the West, San Ramon, CA Nov 2015 – April 2016

Role: Project Lead

Bank of the West is a diversified financial services holding company, headquartered in San Francisco, California. It is a subsidiary of BNP Paribas. It has more than 700 branches in the Midwest and Western United States. It is one of the nation's largest banks, yet it preserves its local feel and its award-winning style of relationship banking that ensures superior customer service website: www.bankofthewest.com.

Project Summary:

Hello bank! US was established as a means to identify and define a path for organic growth through the digital

channel. Specifically, the project objective is to define a digital bank concept that would transform and grow BNPP's presence in the U.S.

Responsibilities:

Participate in Requirement Gathering meeting and provide inputs to business teams on testing approach and feasibility.

Lead Test Estimation, test design, test execution with respect to testing standards, tools and platforms.

Design and modify test plan, test strategy other test life cycle documents.

Involved in writing SQL queries using TOAD/SQL developer to validate the data mapping.

Create traceability matrix between requirements and test cases.

Coordinate with other teams for issue resolution and clarification.

Develop test summary report based on the defined template to close testing phase on the project.

Participate in the release control process (when the application is transferred from the build team to the test team) to ensure that solutions meet business requirements.

Work on innovative solutions and process improvements ideas.

Onsite team management, customer coordination and interaction.

Worked on Team Work plan and resource management.

Provided value propositions in terms of existing capabilities and new technologies.

Proactive identification of newer opportunities in & around the current engagements.

Client: Capital One, Richmond, VA Feb 2014 – Oct 2015

Role: QA Lead

Capital One Financial Corporation is a U.S.-based bank holding company specializing in credit cards, home loans, auto loans, banking and savings products. In terms of total assets and deposits, Capital One is the eighth largest bank holding company in the United States as of 2012. The bank has 963 Capital One Bank Branches including 9 café style locations for their Capital One 360 brand and 2,000 ATMs. Capital One Financial is a member of the Fortune 500, and also conducts business in Canada and the United Kingdom. The company helped pioneer the mass marketing of credit cards in the 1990s, and it is now the fourth-largest customer of the United States Postal Service

Project Summary:

The U.S. Patriot Act requires that financial institutions have an ongoing Anti-Money Laundering (AML) program to monitor, detect, and investigate potential money laundering activities. This project is being undertaken to provide an automated enterprise-w ide solution to identify, monitor, and report suspicious financial activity. Terrorist financings and money laundering are two major types of suspicious activities to be identified. The source data is loaded in to the AML-IF database. As part of AML surveillance, AIS (Actimize Intelligence Server) using the AML module (collectively "Alert Engine") will apply multiple techniques, including its built-in intelligence and customizable scenarios to monitor and detect unusual financial activities. Any unusual activity will be flagged as an alert and worked in the RCM (AMLCase Manager).

This project also involves data migration from SQL Server to Oracle Database.

Responsibilities:

Working as Test Lead and onsite co-coordinator for two PODS in the project, involved in prioritizing multiple tasks between two PODS and ensuring task completion within the assigned sprint.

Involved in preparing Test Strategy, Test Approach document for all releases.

Involved in performing analysis for Business Requirements, functional and system requirements. Involved in designing detailed test cases for System and Integration testing phases.

Managing end to end testing requirements and involved in performing System Testing, Integration Testing, User Acceptance Testing and Regression Testing for all the releases.

Defining the Scope of testing within the context of each release / delivery.

Involved in writing SQL queries using TOAD/SQL developer to validate the data mapping.

Worked on RESTful API/SOAP web services testing.

Worked in Acceptance Test Driven Development testing.

Involved in writing shell script to automate standard Alert Ingestion of Redesigned Rules.

Involved in setting up UAT environment and assist business users on the test execution by preparing test scenarios, identifying test data and performing test execution.

Identifying Issues/defects and tracking them till the resolution, Root Cause Analysis and possible solutions for errors encountered and Preparing Status Report.

Co-coordinating with offshore team and multiple vendor Development team.

Client: TJX Companies Inc, Framingham, MA July2012 – Feb 2014

Role: QA Lead

TJX Companies Inc is the largest international apparel and home fashions off-price department store chain in the United States. Based in Framingham, Massachusetts, the company originally evolved from the Zayrediscount department store chain, founded in 1956, which opened its first branch of T.J. Maxx in 1976 and its first BJ's Wholesale Club in 1984. In 1988, Zayre sold their own nameplate to Ames, a rival discount department store chain, and the company renamed itself to The TJX Companies, Incorporated.

Project Summary:

The project involves initiation of the E-Commerce platform for TJX Companies. The main concentration of the assignment centers around the Procure to Buy module of the E-Commerce program, with the implementation of JustEnough, a Demand Forecasting and Planning solution tool and NetSuite as an order/ inventory management and Financial solution Suite for E-Commerce Platform

Responsibilities:

Regular Interaction with client and business users to understand the requirement and set up quality process translation in Software implementation.

Involved in review of all documentation (BRD, SRS) relating to the given Project.

Involved in preparing Test Plan, Test Cases, execution of Test Cases and Timelines for the projects and conditioning test data.

Involved in documentation and validation of issues and defects found during testing via HP ALM Quality Center.

Written and executed SQL scripts to validate the requirements related to database validation.

Involved in identifying and conducting Regression Testing scope by interacting with the project management teams.

Worked on RESTful API/SOAP web services testing.

Involved in working with Integration and identifying End to End testing scope by interacting with the project management teams.

Anchoring & coordinating with the Project Management/ business team on the Daily status and deliverable Walk-throughs.

Supporting users/business for UAT to ensure defect free deployment.

Providing testing statistics and metrics to Client and to the project Management.

Client: Bluestem Brands, Eden Prairie, MN Feb2012 – July2012

Role: QA Lead

Bluestem Brands is one of the largest direct marketers uses catalogs to offer products with three distinctive brands under one roof like Fingerhut.com,Gettington.com and PayCheck Direct.

Project Summary:

Gator project is all about end to end order processing and to calculate appropriate taxes for customers across the United States dynamically. This system would also assist sales activities, accepting PCD Orders fromemployees in states beyond the original four states and also minimize the impact of changes on customers, vendors and employees. Also implementation of the Security Groups at appropriate level for data access to the appropriate end user in the appropriate environment.

MicroStrategy project is the key component for the implementation of common objects to support Merchandising Assortment Planning in bringing enterprise wide consistency to reporting and analysis.

Responsibilities:

Worked on Project estimation and project timelines.

Worked as onsite coordinator and SPOC for all the projects.

Involved in creating Test Plans and designed test cases as per the requirements related to BRD and design documents.

Manage & Coordinate with a team of 5 persons at offshore and multiple vendor Development team.

Involved in conducting walkthrough of test deliverables with Client and business users.

Involved in regular interaction with Business Analysts and Design team and project Developers on the test execution.

Involved in technical requirement analysis and participated in discussions with Developers on producing valid test scenarios and test cases.

Written and executed SQL scripts to validate the requirements related to database validation.

Involved in identifying and conducting Regression Testing scope by interacting with the project management teams.

Responsible for executing the project using Agile Scrum methodologies.

Used Issue Tracker to track and report system defects and bug fixes and coordinated with the development teams for closing defects.

Monitored project activities and advised on issues to the team members to ensure and meet project deliverables in time which resulted in high customer satisfaction.

Regular interactions with the project members were conducted to Motivate, inspire, and encourage them and to resolve project issues.

Involved in reporting team discussions and have provided valid clarifications for the issues faced and also used to highlight the risks and concerns to the key stake holders.

Involved in regular day to day work allocation process, effective tracking, managing test activities and monitoring the progress of the work.

Client: CVS Caremark, Richardson, TX May2011 – Feb2012

Role: QA Lead

CVS Caremark Corporation is an American drug retailing company with a U.S. pharmacy chain. CVS Caremark provides pharmacy services through its over 7,000 CVS/pharmacy and Longs Drugs stores; its pharmacy benefit management, mail order and specialty pharmacy division, Caremark Pharmacy Services; its retail-based health clinic subsidiary, Minute Clinic; and its online pharmacy, CVS.com. CVS Caremark Corporation is chartered in Delaware, and is headquartered in Woonsocket, Rhode Island, where its pharmacy business is also headquartered.

Project Summary:

CVS Caremark is an outcome of the various mergers over the period of time. Each merger brought along with them their own claim adjudication system. It has the claim adjudication system RxClaim based on AS400, RECAP based on the MVS Mainframe, Quantum Leap (QL) based on Mainframe. It has CDW and ZEUS data warehouse environments on DB2 UDB databases running on UNIX platform. Since every merger and acquisition has brought a new adjudication system to a new Data warehouse system, it has become very difficult and expensive to maintain multiple systems. In order to optimize the performance and to provide the efficient and effective services to the various client applications, CVS Caremark has decided to migrate some of the data warehouses.

Responsibilities:

Worked on project forecasting, estimation, project timelines in coordination with project SME, Client and QA Manager.

Worked as onsite coordinator and SPOC for EDW projects.

Involved in creating Test Plan, test cases for multiple releases.

Involved in conducting walkthrough of test deliverables with Client and project SMES.

Involved in regular interaction with business Analysts and Design team and project developers.

Attended regular walkthrough sessions conducted by Business teams.

Involved in technical requirement analysis and participated in discussions with Developers on producing valid test scenarios and test cases.

Written and executed SQL scripts to validate the requirements related to database validation.

Used Quality Center to track and report system defects and bug fixes. Also involved in creating modification requests for the bugs which helped developers to track and resolve the problems.

Effectively coordinated with the development teams for closing a defect.

Monitored project activities and advised on issues to the team members to ensure and meet project deliverables in time which resulted in high customer satisfaction.

Regular interactions with the project members were conducted to Motivate, inspire, and encourage them and to resolve project issues.

Involved in reporting Team discussions and have provided valid clarifications for the issues faced ad also used to highlight the risks and concerns to the key stake holders.

Involved in regular day to day work allocation process, effective tracking, managing test activities and monitoring the progress of the work.

Client: Wal-Mart, India Apr2010 – April2011

Role: QA Lead

Wal-Mart Stores, Inc. is branded as Walmart since 2008 and Wal*Mart before then, is an American multinational retailer corporation that runs chains of large discount department stores and warehouse stores. The company is the world's 18th largest public corporation.

Project Summary:

Wal-Mart is implementing a Multi-Tenant e-Commerce (MTEP) Platform. ASDA, the UK subsidiary is the first customer for the MTE platform. The platform will also host a Data Warehouse to cater to analytical and historical reporting of the data that resides in or is related to the platform. The Data Warehouse will be extendable as and when new customers (tenants) are added to the MTE platform, hence making it a Multi-Tenant e-Commerce Data Warehouse. Wal-Mart intends to extend this MTE platform to US Groceries named as TITAN implementation. As part of this implementation both customer facing and associate facing applications viz. e-Store, CSC, Fatwire, OMS and Reporting will be developed and localized for USA

Responsibilities:

Developed test plan and Test Scripts covering business requirements and conducted reviews with the QA Manager.

Involved in highlighting the risks and providing status reports to the key stake holders

Involved in work allocation process, effective tracking, controlling the test activities and monitoring the progress of the work.

Involved in writing SQL queries using TOAD/SQL developer to validate the data mapping.

Executed test scripts to validate the reports generated through Oracle BI Reports.

Executed test scripts to check the data flow from Source tables to Staging Tables and Staging to Data Warehouse tables.

Involved in Report import check, Layout check, Graph check and Data check Involved in Report business rules and functionality check.

Involved in defects logging, tracking it until closure by validating once the defect is fixed, Root Cause analysis via HP Quality Centre.

Extensively involved in Test Data Preparation.

The Daily Status Reports are sent to the stakeholders showcasing the summary, status and issues.

Involved in Manual Testing, Integration Testing, System Testing, Regression Testing, and Functional Testing.

Employer: Symphony Marketing Solutions

Client: IMS Health, India June2008 – March2010

Role: Senior Consultant

IMS Health is a global company that provides information, services and technology for the healthcare industry. IMS’s products and services are used by companies to develop commercialization plans and portfolio strategies, to select relevant patient and physician populations for specific therapies, and to measure the effectiveness of pharmaceutical marketing and sales resources.

Project Summary:

The main aim of the project is to provide pharmaceutical sales data to the business team of the Pharmaceutical companies. The sales data provided to business team helps them to analyze, plan for further growth. This project involves in developing enterprise data warehouse in oracle as database to view day to day sales and growth rate in the Pharmaceutical business. The operational data is transformed into business requirements and loaded into Oracle data warehouse using Informatica. This project is to provide a single source of reporting for managing pharmaceutical sales data using data warehousing ETL Informatica.

Responsibilities:

Involved in analyzing business model and customer requirements

Involved in walkthrough of Test Plans, functional Specifications with project stakeholders.

Involved in ETL Testing.

Involved in Preparing and executing test cases.

Involved in writing and executing SQL queries.

Involved in documentation & validation of problems & defects found during testing.

Follow up with the developers and ensure the Bugs/errors have been fixed with in the turn-around time.

Involved in status call, discussing defects found with Offshore and Onsite Team.

Submit testing statistics and metrics to Client and to the Management.

Employer: Dr Reddy’s Labs, India Apr2005 – June2008

Role: Area Sales Manager

Dr. Reddy's Laboratories Ltd. is an integrated pharmaceutical company focused on providing medicines through its three business segments: Global Generics segment, Pharmaceutical Services and Active Ingredients (PSAI) segment and Proprietary Products segment.

Project Summary:

Sales Analysis document validation, Customer database updation and maintenance, Tracking Prescription Trend, Increase the market share by generating sales analysis reports.

The main aim of the project is to create and maintain sales data in the database on the analysis of the daily and weekly sales trend generated from business sales report. The project had scope in identifying sales target and generating reports for the sales target for monthly, quarterly and yearly based on the location and geography. The project had scope in validating generated sales report against the data on the database which would help the business team to analyze the sales trend and plan for the sales improvement plan.

Responsibilities:

Worked as database admin and involved in creating, maintaining database as per business requirements.

Involved in providing production support and Maintenance of databases on production server.

Involved in preparing, creating database and loading business data into the databases received from different sources.

Generating business reports from the database for product sold as per the field research and market research analysis provided by the business teams.

Involved in validating the data present in the database against the business requirements.

Involved in maintaining and generating prescription trend from the database for a given product from the specific area and geography.

Involved and maintained customer information based on the Retail chemist prescription audit trend.

Involved in updating and maintaining Product database by gathering research information on the product using various sources.

Involved in generating product availability tracker from the database which provides business team to identify and request stocks based on the market demand.

Employer: Dr Reddy’s Labs, India Oct2001 – March2005

Role: Professional Sales Representative

Project Summary:

Pharma Marketing & Sales Analysis, generate prescription and Increase the market share. The main aim of the role is to conduct walkthrough meetings with the sales and marketing teams to analyze the marketing trend and to plan and implement strategy to increase the product sales in the market. The work has scope in identifying market trends of each product and to track sold records of each product from the sales analysis reports. The task also involved in generating and tracking competitor’s product sales.

Responsibilities:

Involved in Market Research for identifying product sale trend for each type of product.

Involved in generating reports for product sold in the market using field research and existing documentations.

Involved in Planning and implementation of Sales Improvement Plans.

Develop strategy to improve the sales of the product after sufficient research.

Involved in providing calculation by conducting research on availability of the products to ensure sufficient stocking of products available across the geography.

Involved in gathering Retail chemist prescription audit on the sales.

Involved in conducting sales walkthrough to the management on the sales trend.

Contact this candidate