Data Analyst Project
Resume:
Nirmala Potta *******.*****@*****.***
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