Asis Ranjan Ray

Cell#+1-440-***-****

Email:ac1s3q@r.postjobfree.com

PROFESSIONAL SYNOPSIS

** **** ***** ** ******** Quality Assurance/ automation testing/Implementation experience in requirement gathering, analysis, design, develop, Testing / validating, maintaining, troubleshooting, process improvement.

Currently working with client Federal National Mortgage Association (Fannie Mae) and Freddie Mac.

Experience on Capital Markets, Corporate Finance, Mortgage& securitization, Banking, Healthcare, and Government Services.

Having good experience on Techno functional knowledge of following modules OM, & HRMS/Payroll, GL, AR.

Having good experience on the ERP E-Business suit testing Oracle(R12)

Having good experience on testing cloud (AWS) environments.

Experience on Automation Testing using RIT, Selenium, and Load Runner.

Working experience with User Stories, Use Cases, Sprint Planning, Test Cases and Test Plan in Agile environment

Having good experience on Talend OpenStudio, Informatics (Data warehousing) OLAP Testing.

Having good experience on Data Migration.

Experience on testing Oracle Application Testing Suite(OATS)

Created the End-to-End traceability with requirements, test cases, test results and defects in Quality Center.

Developed ETL test scripts based on technical specifications/Data design documents and Source to Target mappings.

Experience in Metadata and analyzed Source Systems, Staging area, Fact and Dimension tables in Target D/W.

Having experience on Oracle 9i RDBMS(Package, Function & Database trigger, View) and Oracle Developer Forms 6i/ Reports 6i, SQL Plus, PL/SQL

Reviewed the Requirements, Test Approach, Test Scenarios, Test Conditions, Test Scripts and identified gaps.

Understanding & co-ordinating customer needs/requirements and provide solution in adherence to the delivery schedule and as per the SLA.

Have experience on performing Integration, System, Functional, GUI, Regression, ERP, Data Warehouse / ETL and UAT.

Proficient in White box, Black box, Regression, APT, IPT, QA/Testing methodologies, SDLC and Agile processes.

Expertise in analyzing, designing, developing and executing Test plans, Test cases, Test scripts and Traceability Matrix from requirements/specifications.

Solid understanding of quality control best practices, automated testing, and defect management skills

Have experience working with Oracle E-Business suit (R12)

Experience with QA tools including bug/defect tracking systems, Test Management software such as Test Director, Quality Center, Test Manager, ALM, Rally, Clear Quest and automation tool- RIT.

Strong skills in RDBMS (Oracle, PL/SQL, SQL Server, DB2) backend testing, table manipulations using SQL queries, generating reports to ensure data integrity and validating business rules.

Responsible for end–2-end test management, project management and delivery, coordinate and manage testing activities across multiple projects to ensure the testing of each release meets the strategic business requirements, is completed on time, within budget, and with a high degree of quality.

TECHNICAL SKILLS

Testing Tools Test Director, Quality Center, ALM (Application Lifecycle Management), Test

Manager, Rational Clear quest, RIT, Selenium.

Languages Toad, Sqldeveloper, SQL, PL/SQL, HTML, XML

Database Oracle, SQL Server, Big Data Hadoop and DB2, Talend OpenStudio.

ETL / Reporting Tools Informatica, Business Objects, Talend OpenStudio.

Script Java Script, VB Script

GUI Form 6i, Report6i, Platinum Erwin, Oracle Apps11i & Oracle R12

Defect Tracking Tool Quality Center / Rally, Clear Quest, PVCS Tracker, Winscp, Splunk

PROFESSIONAL EXPERIENCE

Client: - Wells Fargo, Charlotte (NC)

Project Name: - 1OGL-Oracle GL Reimplementation 05/2016 – Till date

Role: - Test Lead

Project Details- Implement Oracle E-Business R12 (12.2).Identify and migrate only current data (setup/journals) that are relevant to the R11i current environment. Utilize Oracle R12 ledgers instated of SOBs (Set of Books).Convert and reconcile all Open recurring journals from R11i to R12.Ability to process recurring journals using Wells Fargo Methodology in the appropriate Ledgers. There are several modules in Wells Fargo project. We are testing following modules

Recurring Journal

Open/Close Period

GLM

Eagle

Accounts

Company

Revaluation & Translation.

Rates & Currency.

Journal Import and Posting.

Responsibilities:

Involved in review / analyze the business requirements.

Developed test plan, test cases for Finacial module based on business requirements.

Reviewed the test cases with SME and Business.

Modified and enhanced the test cases based on SME and Business directions.

Data conversion inbound and out bound of program.

Preparation of Packages for validation of data from Created data for UAT

Created daily/weekly test cases metrics to provide status to management

Worked with SME and business and cross functional teams in fixing and closing defects.

Developed SQL Queries for Back end validations.

Developed test scripts for Functional and Regression testing.

Tool & Environment: Sqldeveloper, Oracle, SQL, TOAD, Rally, XMLspy, ALM, WinSCP,Talend openStudio (ETL),

Client: - CSP (Fannie Mae), Washington DC

Project Name: - Common Securitization Platform 04/2015 – 05/2016

Role: - Test Lead

Project Details- Common Securitization Platform Supply the future infrastructure for the mortgage-backed securities market. Security – A financial instrument that represents a creditor relationship with a governmental body or corporation each security is given a unique identifier called a CUSIP (Committee on Uniform Securities Identification Procedures).CUSIPs are unique, assigned by the Federal Reserve Bank of New York (FRBNY or Fed), federally registered, and managed by Standard and Poor’s (S&P). Securities can be either assets (investments) or debt (expenses). Interfaces are the mechanism for outside parties to utilize the CSP. Each of the interfaces facilitates an event-triggered entity-state transition and publishes the results of that transition, or an exception as needed. Interfaces will begin the process of validating a request submitted by an Issuer to the Platform by performing schema validation’s architecture is built on event-driven service oriented architecture (ED SOA) Event notifications are used to drive business functionality within a system.

There are several modules in Common Securitization Solution (CSS) project. We are testing following modules.

Interface

Bond Administration

Data Acceptance

Issuance

Disclosure

MasterServiceing

Data Mart8.Wire

IDS

Responsibilities:

Involved in requirements review, analysis and gap analysis of the applications

Involved in scum meeting and Amigo review.

Involved with ETL test data creation for all the ETL mapping rules.

Worked as ETL Tester responsible for the requirements / ETL Analysis, ETL Testing and designing of the flow and the logic for the Data warehouse project.

Involved in Data Migration.

Preparation of Packages for validation of data from Staging Tables to Interface Tables.

Drafted and Developed test plan and test cases test scripts for Functional, Integration and regression testing

Reviewed Test plan and test cases with business, developers and management.

Executed Functional and Regression test cases and test scripts for Organizational and Vendor management tools

Involved in Application Product Testing, Integration Product Testing and UAT.

Identified and Created defects in Rally and worked with developers to resolve.

Prepared lesions learned and flow / process documents

Tested UI design, flows, screens and navigation to all modules of applications.

Prepared daily, weekly and monthly metrics to management

Extensively developed / used SQL queries to validate backend tables and database integrity.

Tool & Environment: Sqldeveloper, Oracle, SQL, TOAD, Rally, XMLspy, ALM, WinSCP,Talend openStudio (ETL),

Client: - Fannie Mae, Washington DC

Project Name: - Bank_CSP Testing 10/2014 – 03/2015

Role: - Test Lead

Fannie Mae- Federal National Mortgage association is a US government sponsored enterprise to provide liquidity. Stability & affordability to US housing and mortgage markets. Fannie Mae purchases mortgage loans and mortgage related securities for its mortgage portfolio.

The CSP is designated to be a platform that Securitizes mortgages, and perform all the functions associated with turning a mortgages loan into a mortgage-backed security. There are 13 sprints in year. Each sprint having 3weeks of time.

Instigation Common Securitization platform (CSP) is transformational undertaking that will help Fannie Mae support housing finance reform, refine and simplify our complex technology landscape and redesign process and operation.

There are several modules in Common Securitization Solution (CSS) project. We are testing following modules.

Interface

Bond Administration

Data Acceptance

Issuance

Disclosure

MasterServiceing

Data Mart

Wire and 9.IDS

Responsibilities:

Involved in requirements review, analysis and gap analysis of the applications

Involved in scum meeting and Amigo review.

Involved with ETL test data creation for all the ETL mapping rules.

Worked as ETL Tester responsible for the requirements / ETL Analysis, ETL Testing and designing of the flow and the logic for the Data warehouse project.

Preparation of Packages for validation of data from Staging Tables to Interface Tables.

Drafted and Developed test plan and test cases test scripts for Functional, Integration and regression testing

Reviewed Test plan and test cases with business, developers and management.

Executed Functional and Regression test cases and test scripts for Organizational and Vendor management tools

Involved in Application Product Testing, Integration Product Testing and UAT.

Identified and Created defects in Rally and worked with developers to resolve.

Prepared lesions learned and flow / process documents

Tested UI design, flows, screens and navigation to all modules of applications.

Prepared daily, weekly and monthly metrics to management

Extensively developed / used SQL queries to validate backend tables and database integrity.

Tool & Environment: Sqldeveloper, Oracle, SQL, TOAD, Rally, XMLspy, ALM, WinSCP, Splunk, RIT, ETL

Avery Dennison, Mentor, OH 09/2013 – 10/14

Test Lead

Avery Dennison Corporation is a global manufacturer and distributor of pressure-sensitive adhesive materials, apparel branding labels and tags. It is a leading provider of service for bar code thermal and industrial printers. Our field service technicians are strategically located throughout the world. We offer retailers, manufacturers, suppliers and logistics providers the best in multiple vendor printer repair, maintenance and technical support.

Responsibilities:

Involved in requirements review, analysis and gap analysis of the applications

Preparation of Packages for validation of data from Staging Tables to Interface Tables

Worked as ETL Tester responsible for the requirements / ETL Analysis, ETL Testing and designing of the flow and the logic for the Data warehouse project.

Drafted and Developed test plan and test cases test scripts for Functional, Integration and regression testing

Reviewed Test plan and test cases with business, developers and management.

Executed Functional and Regression test cases and test scripts for Organizational and Vendor management tools

Involved in Application Product Testing, Integration Product Testing and UAT.

Validated organizational process, project management and employee management like employee payroll and benefits based on employee grades.

Identified and Created defects in Quality Center and worked with developers to resolve.

Prepared lesions learned and flow / process documents

Tested UI design, flows, screens and navigation to all modules of applications.

Prepared daily, weekly and monthly metrics to management

Extensively developed / used SQL queries to validate backend tables and database integrity.

Environment: Oracle Apps, Oracle, SQL, TOAD, Quality Center, Windows, MS-Office Suite.

Enterprise Best buy Account, Minneapolis, MN 01/2013 – 11/2013

Role: -SR.QA

We are maintaining internal employees of Best Buy. There are few modules like Paid Loa; new hire of Taleo candidates and also short term Disability has been enhanced.Taleo is the third party who supplies us with the employee in formations and then we upload it into the Base table.

Responsibilities:

Analyze and identify the gaps on business requirements - BRD, HLD of the applications

Developed ETL test scripts based on technical specifications/Data design documents and Source to Target mappings.

Extensively used and developed SQL scripts/queries in backend testing of Databases.

Tested a number of complex ETL mappings, applets and reusable transformations for daily data loads.

Extracted data from various sources like Oracle.

Resolve the gaps and draft a test plan based on requirements

Develops test cases and test scripts for Functional, Integration and regression testing

Reviews Test plan and test cases with internal teams and external teams

Updated test plan, test cases and scripts based on feedback from teams and business, and loaded test cases in to Quality Center / ALM

Executed Functional, Integration (End to End) and Regression test cases and test scripts for Work Request.

Created defects in Quality Center / ClearQuest and works with development team and business to resolve defects

Prepared lesions learned and process improvement documents

Data conversion inbound and out bound of Taleo.

Data conversion of Short term Disability.

Involved in ongoing support like Data Creation, execution support and resolve issues for (UAT) User Acceptance Testing.

Involved creating customer using ERP(Oracle Apps) Front End Environment, and Created Work Request Prepared weekly metrics to management

Extensively developed / used SQL queries to validate backend tables.

Environment: ERP (Oracle Apps), Oracle, SQL, TOAD, Quality Center (ALM), Clear Quest, UNIX, Agile scum.

Revenue Assurance - Commissions (Oracle Financial) 04/2012 – 12/2012

Role: -SR.QA

Revenue Assurance - Commissions: The existing Market place interface requires change in order to make it generic and be able to accept transactions from various source systems. This should enable BBY Open’s invoices to flow through Oracle system the same way Market place invoices do at present. The new architecture should ensure re-usability and addition of new sources in future should involve minimal changes

Responsibilities:

Involved in review / analyze the business requirements.

Developed test plan, test cases for Inventory module based on business requirements.

Reviewed the test cases with SME and Business.

Modified and enhanced the test cases based on SME and Business directions.

Developed ETL test scripts based on technical specifications/Data design documents and Source to Target mappings.

Used Quality Center for Test cases management and Defects management.

Data conversion inbound and out bound of Taleo

Preparation of Packages for validation of data from Created data for UAT

Tested a number of complex ETL mappings, applets and reusable transformations for daily data loads.

Created daily/weekly test cases metrics to provide status to management

Worked with SME and business and cross functional teams in fixing and closing defects.

Developed SQL Queries for Back end validations.

Environment: ERP (Oracle Apps), Oracle, SQL, TOAD, Quality Center (ALM), Clear Quest, UNIX, Agile scum.

Best Buy, MN 12/2011– 03/2012

Test Lead

RMS Tax code Integration

The ETC - Vertex RMS PIM Code Phase 1 Delivery project will deliver an update to the tax driver solution currently leveraged by Point of Sale when calculating tax. Today, the global product classification code (GPC) is used as the tax driver in the US. The code is initially set by the vendor selling the item to Best Buy and then regularly reviewed/updated by Best Buy tax. As part of FDM R3, tax will no longer be able to update the GPC code assigned to a SKU.

Responsibilities:

Involved in requirements and gap analysis

Involved in APT,IPT and UAT

Preparation of Packages for validation of data from

Developed test cases, test plan based on requirements and user stories; executed test cases

Worked on setting up the test beds for different configurations

Involved in daily standups, scrum meetings, triage / defect meetings

Tracked and maintained user stories in Rally and test cases in TFS / Test Manager

Developed test scripts for Functional and Regression testing.

Performed Functional, Regression, Security, Boundary, Scalability, Stress and SST.

Used TCPMon to get request and response xml data

Worked on complete defect life cycle.

Environment: Oracle Apps (R12) UNIX, SQL, SQL Server, MS-Office Suite.

TMS to AP (For Best buy Account) 03/2010 – 12/2010

Test Lead

TMS is used to create vouchers. The scope of this solution is to insert/upload these transactions into Best Buy Oracle AP which ultimately goes to Best Buy Oracle GL system. The TMS's input files will be extracted and feed into AP Staging table, and from the staging table there are existing jobs at GL side which will feed to the GL base tables.

Responsibilities:

Leading Oracle Apps Team.

Involved in APT,IPT and UAT

Preparation of Packages for validation of data from Staging Tables to Interface Tables.

Worked with developers, business and cross functional teams in fixing and closing defects.

Performed Back end validations using SQL Queries and UNIX commands.

Environment: Oracle Apps, UNIX, DOS, SQL, Oracle, TOAD, Agile, MS-Office Suite.

Best Buy (Vertex) 08/2007 – 12/2009

Sr. QA Analyst

Develop and implementation comprehensive revenue assurance initiative with the objective or creating an enterprise wide capable to manage vertex calculation performs revenue audits resulting 3rd party service.

Responsibilities:

Involved in Integration testing (End to End) from customer creation, Developed Test plan and executed Test cases based on FD .

Extract data file from vertex tool and upload it Unix

Run SQL loader program

Extract employee from different state in USA and run Quick pay

Involved in APT,IPT and UAT

We are giving Techno function support

Preparation and validation for Oracle Package, Procedure, Function and view.

Involved in ongoing support like Data Creation, execution support and resolve issues for (UAT) User Acceptance Testing.

Online transaction processing, inventory management and etc.

Extensively used defect tracking tools like Quality Center, ALM, Rally / Clear Quest etc.

Client: - Cummins

Project Name: - Data Conversion

Cummins Inc. a global power leader is corporation that design, manufacture, distribute and service engines.

Headquartered in coulombs, Indiana (USA), Cummins serves customer in more than 160 countries through its network of 550 company –owned and independent distributed facilities.

Responsibilities:

Involved in Integration testing (End to End) from customer creation, Developed Test plan and executed Test cases based on FD .

Extract data from legacy system and upload to Oracle Base Table.

Run SQL loader program

Extract employee from different state in USA and run Quick pay

Involved in APT,IPT and UAT

We are giving Techno function support

Preparation and validation for Oracle Package, Procedure, Function and view.

Involved in ongoing support like Data Creation, execution support and resolve issues for (UAT) User Acceptance Testing.

Online transaction processing, inventory management and etc.

Extensively used defect tracking tools like Quality Center, ALM, Rally / Clear Quest etc.

Tool & Environment: Sqldeveloper, Oracle, SQL, Talend openStudio, TOAD, Rally, XMLspy, ALM, WinSCP, Splunk, RIT

Client: MHRM Sentinel

Project Name: - MHRA

QA Analyst 07/2005 – 07/207

Medical and health care product regulatory agency is government agency which is responsible for ensuring that medicine and medical device work and acceptably safe. We keep watch over medicine and devices and we take any necessary action to protect public promptly if there is problem.

Responsibilities:

Involved in Integration testing (End to End) from customer creation, Developed Test plan and executed Test cases based on FD .

Extract data file from diffrent source and load to source table

Run SQL loader program

Involved in Data cleanse.

Involved in APT,IPT and UAT

We are giving Techno function support

Preparation and validation for Oracle Package, Procedure, Function and view.

Involved in ongoing support like Data Creation, execution support and resolve issues for (UAT) User Acceptance Testing.

Online transaction processing, inventory management and etc.

Extensively used defect tracking tools like Quality Center, ALM, Rally / Clear Quest etc.

Tool & Environment: Sqldeveloper, Oracle, SQL, Talend openStudio (ETL), TOAD, Rally, MySQL, ALM, WinSCP.

Client: - Agilent Technologies

Project Name: - Oracle Manufacturing

Agilent is manufacturing semiconductor and supplying to worldwide customer. This project deep level logistic functional support. Process includes planning shipments, releaseiseing sales order picking then using WMS rules engine to create allocation and dispatch picking task then process ship confirmation.

.

Responsibilities:

Involved in Integration testing (End to End) from customer creation, Developed Test plan and executed Test cases based on FD .

Extract data from legacy system and upload to Oracle Base Table.

Run SQL loader program

Extract data file from diffrent source and load to source table

Involved in Data cleanse.

Involved in APT,IPT and UAT

We are giving Techno function support

Preparation and validation for Oracle Package, Procedure, Function and view.

Involved in ongoing support like Data Creation, execution support and resolve issues for (UAT) User Acceptance Testing.

Online transaction processing, inventory management and etc.

Extensively used defect tracking tools like Quality Center, ALM, Rally / Clear Quest etc.

Tool & Environment: Sqldeveloper, Oracle, SQL, Talend openStudio (ETL), TOAD, Rally, Oracle Apps (11.5.0), ALM.

Contact this candidate