Nirmala Potta ac9ajw@r.postjobfree.com

614-***-****

SYNOPSIS:

** + years of experience with Emphasis on Data Analysis, ETL Cloud Computing, Big data (Hadoop), and Software/ Application Testing

Strong knowledge on Oracle Cloud MDM & Oracle Cloud ERP functional testing

Competent and result oriented professional with 10+ years of experience with Strong Data Warehouse experience in Data analysis and Quality Assurance (ETL Testing / Functional Testing)

Strong experience in Data Analysis, Data Profiling, Data Migration, Data Integration and Metadata Management Services.

Good experience in Data Modeling with expertise in creating Star & Snow-Flake Schemas, FACT and Dimensions Tables, Physical and Logical Data Modeling.

Good experience with Data governance and meta data management

Gathering Requirements from Business and preparing Functional and Technical documentation, using UML diagrams

Experience in understanding Stored Procedures, Stored Functions, Database Triggers, and Packages using PL/SQL.

Good Data Warehousing concepts including Meta data and Data Marts.

Good experience on Database (Teradata, Oracle, Hive), Functional, ETL (Informatica) and Big Data testing.

Good experience in Test Data Management

Experience in conducting Joint Application Development (JAD) sessions with end-users, Subject Matter Experts (SME's), Development and QA teams.

Have good experience in leading Projects end to end

Have good experience in giving LOE (Level of Estimations) at project and application level.

Strong Experience on Telecom and Banking domain

In-depth understanding and expertise in Testing activities:

Analyzing System Requirements

Preparation of Test Scenarios

Test Case Design & Build

Test Data preparation

Test cases execution

Defect Reporting & Tracking using Quality Centre

Participation on Defect Triage meetings

Involved in System Integration and Regression Testing

Excellent communicator focused on customer service.

Technical skills:

Operating system: Windows, UNIX

Technologies: Oracle cloud Fusion(SAAS), Siebel, SFDC, Informatica

Database: Oracle 10g,Teradata, Hadoop

Testing Tools: QC, Caliber

ETL Tools: Informatica 8.1, Abnitio, Cognos, OTBI, SQL

Tools: Dimensions, Control M, Toad, SQL Developer, Teradata SQL Assistance

Domain Exp: Manufacturing, Telecom and Banking

PROFESSIONAL EXPERIENCE Dec-04-2017 to Till Date

Project title: MDM Lead (CHUB, SHUB & PHUB)

Employer: Kee technologies

Role: Data Analyst

Environment: Oracle cloud Fusion (SAAS)

Tools used: ALM, OTBI, Toad, Putty

Project:

Master data Management (Customer, Supplier & Product) implementation with TCA architecture to maintain 360 degree view of Customers Suppliers & Products at the master org level.

Customer HUB through TCA architecture

Supplier HUB through TCA architecture

Product HUB Implemented through PIM & PD Modules

Roles: Data Analyst

Expert in writing SQL queries and optimizing the queries in Oracle,SQL

Excellent knowledge in Data Analysis, Data Validation, Data Governance, Data Verification and identifying data mismatch.

Performed data analysis and data profiling using complex SQL on various sources systems including Oracle and OTBI

Attending Workshops

Strong experience in using Excel and MS Access to dump the data and analyze based on business needs.

Excellent knowledge on Unix.

Experienced working with Excel Pivot and VBA macros for various business scenarios.

Strong experience in Data Analysis, Data Migration, Data Cleansing, Transformation, Integration, Data Import, and Data Export through the use of Oracle Cloud(SAas)

Excellent experience in analysis huge volumes of data in industries such as Finance & Manufacturing.

Excellent Software Development Life Cycle (SDLC) with good working knowledge of testing methodologies, disciplines, tasks, resources and scheduling

Excellent knowledge on creating reports on OTBI Business Objects.

Excellent knowledge in preparing required project documentation and tracking and reporting regularly on the status of projects to all project stakeholders

Extensive knowledge and experience in producing tables, reports, graphs and listings using various procedures and handling large databases to perform complex data manipulations.

Excellent experience in Data mining with querying and mining large datasets to discover transition patterns and examine financial data.

Experience in testing Business Intelligence reports generated by various BI Tools like OTBI

Excellent knowledge on creating DML statements for underlying statements.

Extensive ETL testing experience using Informatica 8.6.1/8.1 (Power Center/ Power Mart) (Designer, Workflow Manager, Workflow Monitor and Server Manager)

Have good exposure on working in offshore/onsite model with ability to understand and/or create functional requirements working with client and also have Good experience in requirement analysis and generating test artifacts from requirements docs.

Excellent in creating various artifacts for projects which include specification documents, data mapping and data analysis documents.

An excellent team player & technically strong person who has capability to work with business users, project managers, team leads, architects and peers, thus maintaining healthy environment in the project.

Project title: EIM Jun-20-2016 to Nov-30-2017

Employer: Kee technologies

Role: Data Analyst / Test Lead

Environment: Informatica 9.6.1, HP QC/ALM, Putty, UNIX.

Tools used: QC, Hadoop

Testing Technique: Data Analyst / Test Lead

Project:

Customer Data, being captured by different Systems, is distributed and duplicated. Hence there is no single view to show complete customer data. The primary goal of the project is to build Customer Hub, a single system to provide complete, clean and unique Customer Profile by mapping existing oracle data. This project is very complex in terms of the configuration, and integration with different systems.

Roles: Data Analyst / Test Lead

Gathering business requirements from the end users and management

Giving estimations (LOE) at both project and application level

Analyzing from which databases to pull the data

Data Profiling source tables, identify the relation between tables

Giving the logic to pull the data from source to target

Preparing Mapping document mapping source and target tables and columns

Extracted the business requirements for E-commerce from various sessions with business leads and maintained them using Requisite Pro, tracing them all the way to the system artifacts.

Performed extensive requirement analysis and gap analysis.

Extensively used SQL for accessing and manipulating database systems

Worked closely with QA and Developers to clarify/understand functionality, resolve issues and provided feedback to nail down the bugs.

Oct-06-2015 to May-30-2016

Project title: Commercial credit Analysis Report

Employer: Kee Technologies

Role: Data Analyst/ ETL Testing

Environment: Informatica 9.6.1, Business objects 3.1, Teradata13, HP QC/ALM, Putty, UNIX, Cognos

Tools used: QC, Teradata, SQL Assistance, Control- M, Informatica

Testing Technique: ETL Testing, BI Testing

Project:

CCAR is a data stage reporting data mart, which mainly stores the commercial customers data. This has the Probability defaulter’s data based on this rating Commercial loans will be lended to the customers.

Roles: Data Analyst / Test Lead

•Gathering Requirements from Business Analyst

•Understanding the requirements

•Analyzing the impacts of the given requirements

•Analyze the data that needs to be sourced from different systems based on the requirements.

•Performing Data Profiling to ensure if the data in the existing system can be used as is or if it needs any changes

•Performing Data mapping by Proposing design to the dev team by creating the ETL mapping documents

•Preparing ETL and BI Test Strategy and Test Plan in order to plan how and when testing should be carried out for a particular release.

•Coordinate with data warehouse architect, data warehouse developers and business analyst in the construction and execution of test scenarios for the test, and production data warehouse environments.

•Lead and mentor QA team, as well as all the dependent upstream and downstream applications.

•Coordinating between Onsite and offshore team to ensure all the tasks are going as expected

•Preparing and sending Daily Test Execution Status Report

•Designing test cases and test scripts as per ETL mappings

•Performed data validation testing writing SQL queries.

•Used Quality Center for creating and documenting Test Plans and Test Cases and register the expected results.

•Using HP Quality Center for storing, maintaining the test repository, bug tracking and reporting

•Experienced in retest the existing test cases with the different kind of source systems for different periods of data

•Preparing the Documentation for the mapping according to the designed logic used in the mapping.

•Responsible for verifying data completeness, data Transformation, data quality, integration testing, UAT & regression testing.

•Participated in weekly status meetings, and conducting internal and external reviews as well as formal walkthroughs among various teams.

•Documenting all the recurring defects and resolutions and business comments for those defects.

Tata Consultancy Services Mar-17-2014 to Sept-25-2015

Project title: BCBS- Basel Committee on Banking Supervision

Client Name: JPMorgan Chase, Dublin

Role: Data Analyst

Environment: UNIX

Tools used: QC, Teradata SQL Assistance, Control- M, Hive,Cognos

Project: The BCBS Data Migration Project was setup to address the Basel Data Aggregation & Reporting Principles issued by the Basel Committee in early 2013. The regulation aims to align standards in a banks’ ability to identify and manage bank-wide risks. All existing Globally Systemically Important Banks (G-SIBs) must implement these principles by January 2016.

Roles: Data Analyst

Involved in gathering business requirements from the end users and management

Giving estimations (LOE) at both project and application level

Preparing Test Plan and Test Strategy

Used Rational RequisitePro for Managing and Configuring the Requirement Analysis effort.

Extracted the business requirements for E-commerce from various sessions with business leads and maintained them using Requisite Pro, tracing them all the way to the system artifacts.

Performed extensive requirement analysis and gap analysis.

Analyze source tables, identify the relation between tables

Used sessions, workforce for running and loading the data from source to target data warehouse.

Extensively used SQL for accessing and manipulating database systems

Participated in Design walk-through with SME's to baseline the business architecture.

Worked closely with QA and Developers to clarify/understand functionality, resolve issues and provided feedback to nail down the bugs.

Developed Functional Specifications and Testing Requirements using Test Director to conform to user needs.

Tata Consultancy Services Mar-16-2013 to Mar-13-2014

Project title: Risk Frontier Data Stage Updates

Client Name: Huntington National Bank, Columbus

Role: Test Lead/ Data Analyst

Environment: Windows XP

Tools used: QC, SQL Server

Testing Technique: Manual/ ETL Testing

Project:ICAAP’s Risk Frontier is a complex credit risk portfolio and credit risk capital measurement tool. This project is to provide updates to the current Data Stage process and enhancements to improve the credit risk model accuracy.

Risk Frontier has a need for updated financial statement information to support an unaddressed $9 billion in commercial loans, which includes Floor Plan. It is critical to obtain meaningful economic capital results from Risk Frontier.

Roles: Test Analyst / Data Analyst

Giving estimations (LOE) at both project and application level

Collecting requirements by attending meeting conducted by Business and System Analyst

Requirement Analysis and Test Scenario design

Mapping Source tables and target tables

Preparing Mapping documents by mapping target columns with the source columns

Test Data and Test cases Preparation

Uploading and Executing Test cases in QC

Involved in System and Regression testing of the application

Preparing and sending Daily Test Execution Status Report

Defect Reporting and Tracking

Worked for entire Project Life Cycle

Tata Consultancy Services Sept-20-2012 to Mar-01-2013

Project title: Huntington Reward System

Client Name: Huntington National Bank, Columbus

Role: Test Analyst/ Data Analyst

Environment: Windows XP

Project: HNB implemented the Varicent product suite as a hosted Sales Performance Management (SPM) solution to support their Sales Incentive Plans and the overall Compensation Administration process in 2012. The goal of this solution is to improve the overall responsiveness and maintainability of HNB’s incentive compensation platform while providing broader strategic capabilities to the incentive compensation team. Some of the key business and technology drivers that the Software will address for HNB

Include:

• Increased incentive compensation plan flexibility

• Reduced time to implement new incentive plan logic

• Greater modeling and forecasting capabilities

• Better collaboration and approval controls

• Increased ability to manage complex hierarchies and incentive plan policies

• Report creation consistent across all business segments

• Contest modeling and reporting

Roles: Test Analyst / Data Analyst

Responsible for analysis and functional specifications of “As-Is” and “To-Be” business model to conduct GAP analysis in comparison to the proposed system to enhance the functionality of the application.

Involved in the meeting with Business process owners, SME (subject matter experts) and Marketing Team for Requirements gathering in Definition Stage.

Involved in the Data Movement between Systems and validated the Business Requirements.

Validating data as given in the Mapping doc to check if it fits the Business requirements.

Involved in Functionality testing during the various phases of the development

Verified the correlation between the UML diagrams and developed detailed diagrams

Validated the system End-to-End Testing to meet the Approved Functional Requirements.

Responsible for providing fiscal and economic solutions through financial modeling and cost basis analysis

Lead an entire QA Team comprising of 5 senior QA testers. Managed their activities through daily and weekly status reports

Hands-on QA Analyst, responsible for coordinating and performing functional testing.

Conducted the Final Customer Acceptance Testing (UAT).

Increased process efficiencies and reduced development cycle time across department by spearheading the implementation of the full lifecycle software development methodology.

Participated in weekly meeting and discussed modification request with management team.

Interacted with the developers to report and track bugs using ALM

Tata Consultancy Services Feb-08-2012 to Aug-17-2012

Project title: Trouble Ticket Management (TTM)

Client Name: Century Link, Denver

Role: Test Lead /Business Analyst

Environment: Windows XP

Tools used: QC

Testing Technique: Manual/ BUS Testing

Project:

Trouble Ticket Management is a part Out Region Customers of Century Link to trouble shoot all of the customer problems. There are various applications involved in TTM where in each application helps End Users and Clients to log in there problems, then it will be looked in by technicians to solve the problem and updated the same to customer.

Roles: Test Analyst

Giving estimations (LOE) at both project and application level

Collecting requirements by attending meeting conducted by Business and System Analyst

Requirement Analysis and Test Scenario design

Test Data and Test cases Preparation

Uploading and Executing Test cases in QC

Involved in System, Integration and Regression testing of the application

Preparing and sending Daily Test Execution Status Report

Defect Reporting and Tracking

Co-coordinating testing activities With Offshore

Worked for entire Project Life Cycle

Feb-08-2008 to Jan-15-2012

Project Title: Customer Hub

Client Name: QWEST Communication Inc, Denver, CO, USA

ETL Tools: Informatica 8.1

Role: Test Analyst

Environment: Windows XP, Informatica with UNIX Server, Siebel, SFDC

Tools used: QC

Testing Technique: Manual/ETL Testing

Project Description: Qwest Communications International is a large telecommunications carrier providing services in 14 western U.S states. The company sells its products and services to small businesses, governmental entities, and public and private educational institutions through various channels, including direct-sales marketing, telemarketing and partnership relations.

Customer Data, being captured by different Qwest Systems, is distributed and duplicated. Hence there is no single view to show complete customer data.

The primary goal of the project is to build Customer Hub, a single system to provide complete, clean and unique Customer Profile.

This project is very complex in terms of the configuration, and integration with different systems. This implementation has been highly appreciated due to the complexity with very stringent timelines.

My Role: Tester

Requirement Analysis and Test Scenario design

Test Data and Test cases Preparation

Executing Test cases.

Involved in System, Integration and Regression testing of the application.

Preparing and sending Daily Test Execution Status Report

Defect Reporting and Tracking

Co-coordinating testing Activities from Offshore

Project Title: Qwest CORP MSO (Marketing Strategic Organization)

Client Name: QWEST Communication Inc, Denver, CO, USA

Role: Tester

Environment: Windows XP, Oracle 9i

Tools used: QC,

Testing Technique: Manual Testing/ Database Testing

Project Description: The Qwest CORP MSO Offshore is a part of the larger MDSS (Marketing Decision Support Systems) program of Qwest, a telecom service provider in 14 states of United States of America. Qwest owns companies involved in domestic and international telecommunications, cable and wireless networks, directory publishing and interactive multimedia services. Qwest CORP MSO Offshore contributes significantly to the MDSS Groups’ marketing strategies by providing fast delivery of marketing-specific information to the clients to target and segment markets, identify market opportunities and assess competitive threats. Qwest CORP MSO Offshore includes several projects/applications

Customer Relationship Data Mart (CRDM)

Business Data Mart (BDM)

Campaign Management (CM)

Do Not Solicit (DNS)

My role: Tester

Requirement Analysis and Test Scenario design

Test Data and Test cases Preparation

Uploading and Executing Test cases in QC

Involved in System, Integration and Regression testing of the application

Preparing and sending Daily Test Execution Status Report

Defect Reporting and Tracking

Data Reconciliation (Comparing the report data and source data)

Worked for entire Project Life Cycle (This includes SDLC & Agile Methodology)

Contact this candidate