Sr.Quality Analyst
Resume:
Renuka Tak
**********@*****.***
Cell No: 215-***-****
Experience Summary
OCA [Oracle Certified Associate]
Informatica 8.1.1 Mapping Designer Exam S Certified
9+ years of IT experience in testing services - ETL testing, Dataware house, Database testing, backend testing, White box & black box testing, Report Testing
5+ years of experience in Banking/Financial domain/Healthcare.
3 years of experience in Insurance domain.
2+ months of experience in Life Sciences domain.
Expertise in SQL, PL/SQL Programming and UNIX Commands.
Expertise in working on tools – Informatica, Unix, Toad, SQL navigator, Oracle 9,10g, 11.
Extensive experience and expertise in Test management tool - Quality center & JIRA.
Experience in Data ware house testing with expertise in working on Informatica.
Experience in Micro strategy BH report testing.
Experience in Informatica mapping development.
Expertise & good understanding of the Software Development Life Cycle (SDLC) in waterfall with emphasis on black box, functional, GUI, System, SIT, regression and integration testing of Web applications, window based applications & Client/Server Database Related Applications.
Exposure in agile testing.
Worked as Test lead for business users in User Acceptance testing (UAT).
7+ years of experience in software testing phases - Requirement Analysis, Test Planning, Test Analysis & Design, Test Execution and Evaluation of the exit criteria and reporting.
7+ years of experience in writing testing documentation such as Test Plan, test specification, Defect report and test summary
Experience in preparing project estimations, resource metrics, work requests and billing documents.
Extensive experience in working as testing team lead, managed multiple teams at onshore & offshore in India.
Excellent verbal, written and analytical skills with ability to work in a team as well as individually.
Ability to work with business users in analysis, requirement gathering and business process improvements.
Education and Certifications
Certifications:
• OCA [Oracle Certified Associate]
• Informatica 8.1.1 Mapping Designer Exam S Certified
Education:
• Masters in Computer Science – India
Employer Details –
NIIT – Technology
October 2016 – Till Date
Cognizant Technology Solutions – USA
August 2011 – March 2016
Capgemini India Pvt. Ltd
September 2009 – August 2011
Iflex Solution Pvt. Ltd
April 2008 – December 2008
Efficient Data Processing Pvt. Ltd
July 2006 – April - 2008
TECHNICAL SKILLS:
Operating Systems
Windows 2000/XP/Vista/7
Testing Tools
ALM, HP Quality Center (8.2, 9.0, 10), JIRA 7.2
Languages
SQL, PL/SQL, VB 6.0, VB.NET
Web Technologies
ASP, Asp.Net, AJAX, HTML, DHTML, XML, Web Services, VB Script, JAVA
Utilities
Microsoft Project plan (MPP), Visual Source Safe (VSS), Documentum, Share point
Databases & Tools:
(Oracle 8i, 9i, 10g, 11g), Teradata, TOAD, SQL
Navigator, DB2, MS Access, Informatica 8-9.0,
Octopus, Alfresco Share, Alfresco WebDave
Reporting Tools
Crystal Reports, MicroStrategy 9.0, SAS
Project Details
PROJECT TITLE
SEI IMS Workdesk
Client
SEI Investments
Duration
Oct 2016 – Jan 2017
Location
Oaks, PA
Role
SR. QA Analyst
Technology and Tools
Java, Web testing, JIRA, OCTOPUS
PROJECT DESCRIPTION:
SEI IMS Group requires a modern web-enabled self-service incident management tool that resides in the IMS Platform that utilizes SEI IMS Group’s existing implementation of JIRA. This will allow both SEI IMS Group Operation’s team to utilize their existing operational procedures; while allowing their clients to communicate an incident/request via the IMS Platform. Goal is to provide a dedicated incident management system to SEI IMS Group allowing SEI Internal Operational teams a clear communication channel with their clients. This will allow SEI Internal Operational teams the ability to leverage their existing tools and processes, while allowing their clients the same toolset in a limited fashion. This will be accomplished by enabling SEI’s current JIRA system to be client facing via the IMS Platform.
ROLES AND RESPONSIBILITIES:
Responsible for design and implementation of test strategy for project.
Responsible for analysis of functional and business requirement and develop testing methodology.
Responsible for preparing Estimates of test effort for the new requirements.
Release manager process handling.
Develop test scenarios and test scripts based on business and technical requirement.
Responsible for QA and productions environment testing
Responsible to Provide test documentation and test results to entire team
Responsible for defect triage meeting with development team.
Logging and tracking defects in JIRA.
Responsible Test cases of report testing
PROJECT TITLE
SAS ADV to Teradata Conversion Testing
Client
CareSource
Duration
Jun 2015 – March 2016
Location
Dayton, OH USA
Role
QA Analyst
Technology and Tools
Teradata, SAS
PROJECT DESCRIPTION:
The project is about SAS ADV to Teradata Conversion, The objective of this project is to create the SAS ADV dataset in Teradata. All the business rules and transformation which presents in the SAS ADV code needs to be apply in Teradata SQL.
ROLES AND RESPONSIBILITIES:
Responsible for design and implementation of test strategy for project.
Responsible for functional and business requirement analysis and develop testing methodology.
Responsible for preparing Estimates of test effort for the new requirement.
Develop test scenarios and test scripts based on business and technical requirement.
Responsible for performing various level of testing such as Integration, System Testing and CRT Testing.
Responsible to Provide test documentation and test results
Responsible for defect triage meeting with development team.
Logging and tracking defects in Quality Center.
Responsible of writing SQLs and test cases of report testing.
PROJECT TITLE
Report Testing
Client
CareSource
Duration
Sep 2014 – Apr 2015
Location
Dayton, OH USA
Role
QA Analyst
Technology and Tools
Quality Center ALM, Informatica 8.1, Oracle 11g
PROJECT DESCRIPTION:
CareSource is a leading non-profit managed care company based in Dayton, Ohio. CareSource has been meeting the needs of health care consumers for more than 25 years. The project is about micro strategy BH report testing and Dell FMS testing.
ROLES AND RESPONSIBILITIES:
Responsible for design and implementation of test strategy for project.
Responsible for functional and business requirement analysis and develop testing methodology.
Responsible for preparing Estimates of test effort for the new requirement.
Develop test scenarios and test scripts based on business and technical requirement.
Responsible for BH micro strategy reports testing with ETL testing.
Responsible for performing various level of testing such as Integration, System Testing and Regression Testing.
Responsible to Provide test documentation and test results
Responsible for defect triage meeting with business and development team.
Logging and tracking defects in Quality Center.
Responsible of writing SQLs and test cases of report testing.
PROJECT TITLE
Customer Master - CM
Client
Merck
Duration
Jun 2014 – Sep 2014
Location
West Point, PA USA
Role
QA Analyst
Technology and Tools
Quality Center ALM, Informatica 8.1, Oracle 11g
PROJECT DESCRIPTION:
The project is addressing the Gaps for ALIGN / CM gap. Such as Oscillating Party IDs that are triggered by source system updates, Merge consumption enhancements due to TIBCO CIM integration (If any merge happens on day 1 and a new record comes on same day with a loser party id, CM logic to move the incoming new record to winning party id is NOT working), Data leakage in Merge History Table, Re-design the Primary Key for SAP Account Address data
ROLES AND RESPONSIBILITIES:
Working as a QA team lead and onsite liaison of offshore team.
Responsible for design and implementation of test strategy for validated project.
Responsible for functional and business requirement analysis and develop testing methodology.
Responsible for preparing Estimates of test effort for the new requirement.
Develop test scenarios and test scripts based on business and technical requirement.
Responsible for Testing the RITS requirement to ensure all the new changes are functioning as per the Business requirement.
Worked on analysis of Source and target qualifier queries and explain and clarify to offshore teams.
Responsible for performing various level of testing such as Integration, System Testing and Regression Testing in order to validate the application.
Responsible to Provide test documentation and test results
Responsible for defect triage meeting with business and development team.
Logging and tracking defects in Quality Center.
Responsible for review SQLs and test cases of offshore team.
Responsible for leading - managing team, reporting status as per project plan.
Participating in monthly MBR & regular staffing & IT planning meetings.
PROJECT TITLE
InputDB
Client
ING North America Insurance Corporation
Duration
Jan 2013 – Jun 2014
Location
West Chester, USA
Role
QA Analyst
Technology and Tools
Quality Center ALM, Informatica 8.1, SQL Server 2008
PROJECT DESCRIPTION:
The input database project converts a manual in-force build process to new enhanced database driven, automated and Controlled IT Process. It is also part of a bigger goal to create an end-to-end automated process for future production cycles. The project, addressing all variable annuity block of business.
This automated process provides simple and sophisticated control over various file types and data handling, data storage and reporting in form of inforce files for VANET and Model Point Files for Prophet Application.
ROLES AND RESPONSIBILITIES:
Responsible for design and implementation of test strategy
Responsible for functional and business requirement analysis and develop testing methodology.
Responsible for preparing Estimates of test effort for the new requirement.
Develop test scenarios and test scripts based on business and technical requirement.
Responsible for Testing the RITS requirement to ensure all the new changes are functioning as per the Business requirement.
Worked on analysis of Source and target qualifier queries and explain and clarify to offshore teams.
Responsible for performing various level of testing such as Integration, System Testing and Regression Testing in order to validate the application.
Responsible to Provide test documentation and test results
Responsible for defect triage meeting with business and development team.
Logging and tracking defects in Quality Center.
Responsible for review SQLs and test cases of offshore team.
Responsible for leading - managing team, reporting status as per project plan.
Participating in monthly MBR & IT planning meetings.
PROJECT TITLE
.Net RITS Testing & Project DAWN
Client
ING North America Insurance Corporation
Duration
August 2011 – Dec 2012
Location
West Chester, USA
Role
QA Analyst
Technology and Tools
Quality Center ALM, Informatica 8.1, SQL Server 2008
PROJECT DESCRIPTION:
ING offers products and services to retail and institutional clients, including retirement services, annuity, life insurance, employee benefits, mutual funds and financial planning. RETAIL ANNUITY QA support as part of 'ING Annuity QA' contract involves end to end testing and release testing process for the ING Annuity Policy
Administration and its integrated supporting downstream business system.
ROLES AND RESPONSIBILITIES:
Responsible for design and implementation of test strategy
Responsible for functional and business requirement analysis and develop testing methodology.
Responsible for preparing Estimates of test effort for the new requirement.
Develop test scenarios and test scripts based on business and technical requirement.
Responsible for Testing the RITS requirement to ensure all the new changes are functioning as per the Business requirement.
Worked on analysis of Source and target qualifier queries and explain and clarify to offshore teams.
Responsible for performing various level of testing such as Integration, System Testing and Regression Testing in order to validate the application.
Responsible to Provide test documentation and test results
Responsible for defect triage meeting with business and development team.
Logging and tracking defects in Quality Center.
Responsible for review SQLs and test cases of offshore team.
Responsible for leading - managing team, reporting status as per project plan.
Participating in monthly MBR & IT planning meetings.
PROJECT TITLE
Financial Management External Reporting (FMER)
Client
Branch, Bank and Trust Corp (BB&T Bank)
Duration
July 2010 – Aug 2011
Location
Pune, India
Role
DW QA Analyst
Technology and Tools
Quality Center ALM, Informatica 8.1, Toad, Unix
PROJECT DESCRIPTION:
Decision Support Services (DSS), in partnership with Financial Management External Reporting (FMER), will build the foundation for business analytic and reporting capabilities associated with the Regulatory Reporting process for all lines of business. These capabilities will feed from the Enterprise Data Warehouse (EDW) into a FMER specific Data Mart (DM). It will be designed to provide staff with current, consistent and credible facts about the organizations Deposits, Loans and Investment portfolio and a flexible and easy to use reporting application. The results of this effort provides a foundation upon which FMER will build a business-driven analytical and reporting environment to allow users to analyze timely, integrated information from multiple source systems in an intuitive manner to support regulatory reporting requirements such as the Quarterly Call Report.
ROLES AND RESPONSIBILITIES:
Responsible for all deliverables to onsite for System testing, Regression testing,
Develop UNIX scripts that execute/verify the Informatica mapping and the load scripts.
Resolving issues encountered during the execution of the project.
Review of test cases preparation, execution and logged defects.
Validation of email templates and email processing.
UAT support to business
Create Test planning and co-ordinate in test cases development.
Identification of SIT scenarios and creation of test scripts.
Develop Execution plan for test cases for functional and system testing
Defect tracking and report generation
Maintained test suits in Quality center by writing SQL queries in manual test cases.
PROJECT TITLE
CCRM (Corporate Credit Risk Management)
Client
Branch, Bank and Trust Corp (BB&T Bank, USA)
Duration
Sep 2009 - June 2010
Location
Pune, India
Role
QA Analyst
Tools
Quality Center ALM, Informatica 8.1, DB2, Unix
PROJECT DESCRIPTION:
The BB&T Corporation is one of America's largest banks, offering full-service commercial and retail banking services along with other financial services like insurance, investments, retail brokerage, mortgage, corporate finance, consumer finance, payment services, international banking, leasing and trust.
This engagement is for providing a Corporate Credit Risk Reporting and Analytics Assessment and Roadmap service for BB&T. The resulting work from this Roadmap will enable the client develop a credit risk business intelligence data warehousing solution. The current centralized data repository for CCRM is called LGRED (Lending Group Risk Exposure Data) which has been developed in SAS. The critical concern with LGRED is its lack of scalability to respond to increased business needs which will constrain the current environment and limit the variety of analytics which can be done.
The first phase of the engagement involves migrating History SAS datasets into DB2 based credit risk mart and replace current monthly SAS programs with Informatica code.
ROLES AND RESPONSIBILITIES:
Responsible for all deliverables to onsite for System testing, Regression testing,
Resolving issues encountered during the execution of the project.
Review of test cases preparation, execution and logged defects.
UAT support to business
Create Test planning and co-ordinate in test cases development.
Identification of SIT scenarios and creation of test scripts.
Develop Execution plan for test cases for functional and system testing
Defect tracking and report generation
Develop UNIX scripts that execute/verify the Informatica mapping and the load scripts.
Perform unit testing & bug fixing
Resolving issues encountered during the execution of the project.
PROJECT TITLE
Time Deposit (TD)
Client
Shinsei Bank, Japan
Duration
Apr 2008 - Dec 2008
Location
Mumbai, India
Role
QA Analyst
Tools
Quality Center ALM, Informatica 8.1, Sql Server 2005, Unix
PROJECT DESCRIPTION:
Time Deposit is a functionality provided by the bank to various corporate to inquire about their deposits along with the facility to transfer funds. Time deposit Module was a new and core development mainly based on Oracle technology. This module contains different types of deposit like structure deposit. We provided maintenance and enhancement of Informatica mappings for the bank which maintains global information across the Lines of Business. There are different types of lines of business like Time Deposits, Loans, & ATM’s.
ROLES AND RESPONSIBILITIES:
Responsible for all deliverables to onsite for System testing, Regression testing,
Resolving issues encountered during the execution of the project.
Review of test cases preparation, execution and logged defects.
UAT support to business
Create Test planning and co-ordinate in test cases development.
Identification of SIT scenarios and creation of test scripts.
PROJECT TITLE
Asset Management System
Client
Efficient Data Processing Pvt ltd.
Duration
Sep 2006 - March 2008
Location
Mumbai, India
Role
Software Engineer
Tools
VB 6.0,Oracle 9i,Crystal Report9
PROJECT DESCRIPTION:
There are different types of lines of business like Time Deposits, Loans, & ATM’s.
BSE uses the Asset Management System for printing barcode for Assets. It’s allows User to maintain its assets as per the department & place. The software provides a feature by which user to download data from DCU and compare it with the data entered in the application and can get the stock reconciliation statement. The backend of Asset Management System is Oracle 9i. In Asset Management System includes 6 tables, which relates to master tables (Location Master, Company Master, Item Master) as well as Asset type, DCU Barcode, Item history etc.
ROLES AND RESPONSIBILITIES:
Responsible for all deliverables for System testing, Regression testing,
Resolving issues encountered during the execution of the project.
Test cases preparation, execution and logged defects.
Create Test planning and co-ordinate in test cases development.
Identification of SIT scenarios and creation of test scripts.
Contact this candidate