Ayushi Pundir Resume

*** ******** ******, ******, *************, 02169 +1-774-***-****) ac4o12@r.postjobfree.com

Objective

Aim to work in a challenging work environment where I can utilize my expertise in resolving the problems and advocate my analytical skills towards the growth of the organization

Education

MS in Software Engineering 11/2015 BITS Pilani

Passed with 72%

Computer Science and Engineering

BCA 08/2011 Pt. Deen Dayal Upadhaya College

Passed with 75%

Computer Science application

Experience Summary

6 years 5 months experience in ETL, Database, Automation, Functional testing.

1 year 6 months experience in Axiom Controller view V7 and V9.

Experience on testing of FFIEC031, FRY9C, FRY14Q reports data sourcing, data modelling and workflow design

Good knowledge and hands on experience in software development life cycle and Software Testing Life Cycle

Experience in Regression testing, end to end testing, Manual testing, web testing.

Proficient in writing SQL queries.

Expertise in validating database mandatory checks like accuracy of data, completeness of data, Quality of data.

Valuable experience in loading the data from source file into database using shell scripts and SQL procedure

Experience in Report testing.

Experienced in writing automation scripts in selenium web driver.

Experienced in preparing Test plan, Test strategy and other testing artifacts.

Expertise in test case design and test maintenance in HP-ALM and generating graphs and reports.

Ability to work under stressful environment.

Punctual, hard-working, with quick grasping aptitude.

Effective communication and interpersonal skills

Key technologies worked on

Databases

Oracle, MySQL, Teradata

Languages

Core Java, VB Scripting, PL/SQL

Tools

SQL Developer, Toad, SQL client Teradata, HP-ALM, Selenium WebDriver, Axiom Controller view

Career Profile

Since Aug - 2011 WIPRO LTD

Period 05-10-2016 to till today

Domain Banking

Position Sr. Software Engineer

Responsibilities

Analyze business requirements, FSD and based on that design test strategy, test plan and other testing deliverable documents.

Creating tests scenarios based on requirement, develop and execute automated tests, identify and log bugs in HP ALM.

Validate Axiom SL controller view objects (Data Source, Portfolio and shorthand, Aggregation) for CCAR (FFIEC031, FRY9C and FRY14Q) Regulatory Reports.

Validate the business logics and formulas provided by Business Analyst in Axiom generated regulatory reports.

Prepare SQL scripts using Toad to validate accuracy, integrity, completeness, data quality from legacy system to Central Data Hub and the target new system.

Generate execution reports, summary reports and test matrix, progress graphs using HP ALM.

Coordinate with offshore team, guide and assign task to team and review the deliverables.

Ensure successful handover from system integration testing to user acceptance testing

Participate in Sprint planning, Iteration review, daily scrum and Retrospective meetings.

Host Defect triage, Demo meetings with Business Analyst and Development teams.

Provide daily status reports and weekly status to Client.

Coordinate with client to analyze each release task and provide testing effort estimation.

Project

Enhance regulatory reporting processes, governance, and infrastructure with the objective to pro-actively identify any gaps, incorporate required enhancements and develop a targeted re-mediation program by aligning with relevant regulatory expectations and leading industry practices.

Specific drivers include

1. Increasing number of reporting requirements, coupled with their complexity and granularity, necessitates improvements to the underlying reporting infrastructure.

2. Heightened reputational risk given as a global systemically important bank holding company (GSIB) and the increasing scrutiny of regulatory reports by external constituents including analysts and peers.

3. Increased regulatory scrutiny over filed regulatory reports with heightened consequences for non-compliance.

Tools Axiom Controller view, SQL Developer, HP ALM

Languages SQL

Quincy, Massachusetts, USA

Period 04-14-2015 to 05-10-2016

Position Sr. Software Engineer

Responsibilities

Development of SQL scripts to validate data.

Collecting, understanding and analyzing the business requirement.

Run set of shell scripting jobs and SQL stored procedures in QA region to load the data.

Deal with Ab-initio multi-file system for file to file and file to table validation.

Conducting knowledge transfer sessions for other teams to help them understand the new enhancements and the changes.

Providing Daily and Weekly status report to the management.

Participated in sprint planning and retrospective.

Project

This project comes under BASEL compliance and currently dealing with BASEL-II. Bank has acquired moody tool for the calculation of risk on their assets. That tool has given the name as RWA calculator. Values or data which is generated by RWA calculator are used to calculate the CAR (capital adequacy ratio) where RWA values are used in numerator. This project deals with various source systems that includes Commercial, Retail, Cards, Traded, GL and reference sources and required file to file, file to table and table to table validation based on the business requirements.

The application is installed on desktop as well handheld devices. This also takes care of the reporting requirements of the sale, return and exchange of devices. Development of application required interaction with third party applications and consuming their services, with Finance team for transaction reporting.

Tools Ab-Initio, Toad, HP ALM, Unix

Bangalore, India

Period 09-01-2014 to 04-13-2015

Domain Banking

Position Test Engineer

Responsibilities

Discussion with Project team members offshore and onsite to understand the Business Requirement and Collecting, understanding and analyzing the business requirement.

Preparing SQL Scripts in SSIS, Verification and Validation of data as per the standards given to test the process supporting System Test execution.

Load the source files with SSIS jobs to the Database and extract the files from all BALs (project applications).

Test Case writing and execution and finding Defects and possible solutions for errors encountered.

Providing Daily and Weekly status report to the management.

Project

Leading bank in Indonesia, provides banking services to its customers across 35 cities and through over 80 branches. The bank has embarked on a core banking program and is implementing Oracle FLEXCUBE. As part of this program, the Bank would like to engage additional partners with suitable experience to augment the needs of the bank on this large transformation program and is looking for a partner who can assess

the impact of a new data feed (coming from FLEXCUBE) to enable Data Integration scripts to their existing Data Warehouse, modify some of the existing reports that are developed in SAP BO and develop some new reports in OBIEE.

Tools SSIS, HP ALM

Bangalore, India

Period 08-04-2012 to 08-30-2014

Domain Insurance

Position Test Engineer

Responsibilities

Discussing with Project team members offshore and onsite to understand the Business Requirement and Functionality of the Project

Preparing Bteq Scripts in Teradata, Verification and Validation of data as per the standards given to test the process Supporting System Test execution.

Load the source files with Mload and Fload to the Database.

Providing Daily and Weekly status report to the management.

Project

Commercial Insurance data will be added to the data warehouse, and reporting functionality will be made available through the Console report builder application based on Micro Strategy software. The goal of the overall project is to integrate the reporting needs for metrics such as Direct Written Premium and Earned Premium, In Force and Retained metrics, Loss Ratio, Activity Counts, etc. at a policy, package level, and to include quote data, all within the report builder functionality provided by Console. Velocity BOP Foundation project will also introduce the addition of quote data to e-Product. The focus of this project will be to bring BOP sources into STG_CCML_DB Staging database and to bring in BOP staging data into e-Product foundation (which includes Facts table execution) database.

Tools Teradata, HP ALM

Bangalore, India

Period 11-01-2011 to 08-03-2012

Domain Retail

Position Test Engineer

Responsibilities

Discussing with Project team members offshore and onsite to understand the Business Requirement and Functionality of the Project

Preparing Test Cases based on the functionality and business requirement

Prepared Test Data for negative testing

Execute test cases in QC and defect logged.

Project

Criminal Background Check (CBC) is process of looking up criminal records of individuals. CBCs are requested by employers on new applicants before hiring. CBC is applicable to all associates, regular, temporary, full time, peak time, hourly, salaried non-exempt and salaried.

Tools HP ALM, Web testing

Bangalore, India

Declaration

I hereby affirm that the information furnished above is true to the best of my knowledge and belief. I shall be willing to furnish additional information if required.

Place : Quincy, Massachusetts Ayushi Pundir

Contact this candidate