Mainframe Testing First National

Sri Suganithi.V Mob.No-+91-709*******

Email:*********@*****.***

Job Objective:

To get a responsible position in an organization to utilize my skill and potential to the best of my abilities to contribute for the achievement of Organizational goals and growth and to work in an environment that provides a challenging, rewarding career ensuring a high-level job satisfaction. Personal Profile:

A result oriented software testing professional with 3.9 years of experience in Functional and Etl testing,2.5 years of relevant experience in ETL testing using Informatica tools and contribution towards team performance with strong communication and learning skills. Professional Summary:

● 3.9 years of experience with strong Web application testing, Mobile testing, Mainframe testing and SQL scripting/ETL testing skills

● Experience in Development and Design of ETL test cases, scenarios, and scripts to ensure quality in Data warehouse / BI applications.

● Experience in writing SQL queries for validating business rules using Oracle and SQL server database.

● Exposure to DB tools:MS-SQL Server /DBEAVER/ PL SQL developer and BI tools:AXIOMSL,TABLEAU and WORKVIA

● Good knowledge in understanding BRD and FRD, ETL specifications documents to ensure all the requirements are met.

● Holding Good knowledge in Test Execution, Test Results Reporting, Identifying Defects and creating artifacts and evidence of testing.

● Worked collaboratively with all QA team members, developers and business analysts to ensure good quality deliverables.

● Creation and Execution of SQL queries for backend data checking(Test data)

● Defect logging and defect analysis using HPQC, Performing Root Cause Analysis.

● Project management at team level, I was handling a team of 5 members from offshore. Dividing the work on a daily basis among them as well as prioritizing work among the team and collecting back the status after the work and reporting it back to the onsite lead.

● Reporting DSR (Daily status report) and WSR (Weekly status report).

● Performed Regression Testing, Sanity Testing, Database Testing, Mobile Testing, Cross browser Testing, Functional Testing, Smoke Testing, ETL relevant testing.

● Implemented KT document for Migration Project from start to end.

● Coordinated with the Automation Team to automate regression cases of the application.

● Working knowledge on financial services and Banking Applications.

● Experience working on Waterfall and Agile Methodology. Technical Skills:

Programming Languages PL/SQL, C, C++, Java

Test Management Tools Informatica, DVO,HPQC, JIRA, Share point Database SQL and Oracle

BI Reporting Tools AXIOMSL

DB Tools MS-SQL Server/DBEAVER/ PL SQL developer

SDLC Model Waterfall & Agile (Scrum)

Work Experience:

Capgemini Technology Services, Bangalore, India

13-September -2017 to Till Date

Project Experience:

Project -1: Online Business Banking Upgrade

Client : Associated Bank, Wisconsin, US

Role : Functional Tester

Testing involved : Functional Testing, Regression Testing, Cross Browser Testing, Mobile Testing

Tools used : Universal Online Banking Portal,MainFrame (Signature),Sauce Lab,HP ALM

Description:

NexGen is a new generation platform for Online Business Banking. It is the upgrade of the application Associated Connect with new feature enhancements and user-friendly interface. We have tested all the major functionalities in the new platform named “Universal Online Banker”. To attain 100 percent test coverage all the variations for each module have been covered. Part of the upgrade project also focused on the Customer Data Migration to the new platform. The new platform has been tested in all the smart devices with different Browser & Operating System variations. Roles and Responsibilities:

● Analyze and understand the requirements

● Prepare functional process flows and test scenarios

● Design test cases for the reviewed test scenarios

● Execute the test cases and upload the test results in Quality center

● Defect reporting and retesting

● Involved in Cross Browser testing and Mobile Testing. Project -2: Signature Upgrade

Client : Associated Bank, Wisconsin, US

Role : Functional Tester

Testing involved : Functional Testing,Regression Testing,Interface Testing Tools used : MainFrame (Signature)

Description:

Signature is an innovative, comprehensive customer-centric banking solution that serves the account processing needs of Associated Banc-Corp and this system goes through scheduled maintenance releases to support enhancements, defect fixes, upgrades etc. Bank constantly does the Signature Upgrade to meet specific business needs and increase operational efficiency. Roles and Responsibilities:

● Analyzing the functional specs document.

● Participate in reviews of requirements, test cases and defects

● Prepare Test plan and Test strategy document for the releases

● Preparation of Test Cases and Execution of Test Cases, Bug Tracking

● Performed Regression testing and Functional testing

● Involved in Review of Test cases and Reported bugs using ALM and Prepared Daily Status reports

Project -3: First National Bank Acquisition and Conversion Client : Associated Bank, Wisconsin, US

Role : ETL Tester

Testing involved : Data Validation, Functional Testing. Tools used : Oracle server, Informatica, DVO, HP Quality center, MainFrame

(Signature)

Description:

Associated Bank is acquiring Wisconsin banking franchises from First National Bank . Branches, Customers and accounts will be converted into the ASB Platforms. The data conversion and migration is in the support of FNB Account Acquisition. Review FNB products, applications, business processes etc., for integration to ASB systems and processes. This includes; however not limited to data mapping

, data health checks, Customer profiling, and migration of data to ASB systems, conversion of selected card types and online banking Enrollment.

Roles and Responsibilities:

● Understanding logical flow of the application

● Analysis of the specifications provided by the clients

● Participate in the reviews of Requirements and Design Documents

● Create Test Scenario and Test Cases to validate Source and Target data

● Traceability of requirements to test cases

● Played a key role in the developing SQL queries while preparing the test case scripts

● Proficiency in Data verification by executing SQL queries. Project -4: Reporting and Data Automation in Pillar 2 Client : MUFG

Role : ETL Tester

Testing involved : Data Validation, ETL Testing.

Tools used : AXIOMSL Tool, AWS Redshift, HIVE, Tableau, Workvia Description:

AXIOM tool generates reports which MUFG submits to Federal Reserve Bank, Project involves data integration testing of Risk reports where data flow from AWS->Tableau->Wdata->Workiva. Roles and Responsibilities:

● Preparing Test plan, Test cases according to BRD and FRD Documents.

● Written complex SQL queries to fetch data from AWS Redshift and Hive

● Verifying whether data sources, data models, workflows and reports are configured according to the requirement.

● Verifying the reports and adjustments made to the report in BI tools Axiom,Tableau and workiva.

● Prepared comprehensive reports on quality test results and present findings to the software creation team to immediately establish corrective measures. Education:

Bachelor of Computer Application

Avinashilingam University for Women Education,Coimbatore. 2014-2017

Certifications:

● Completed “ISTQB Certification” at Foundation Level.

● Completed “Agile Software Development” from Coursera.. Personal Details:

Name : Sri Suganithi

Father’s Name : Venugopal

Date of Birth : 21-11-1996

Nationality : Indian

Languages Known : Tamil, English, Telugu

Declaration:

I do hereby declare that the above information is true and complete to the Best of my knowledge and belief.

Sri Suganithi.V

Contact this candidate