SUMMARY:

• Young, energetic and result oriented professional 9 years of experience in IT industry; Extended expertise in Data Mappings documents, detailed process flows, design solutions, Bug Fixation Approach and testing: Deep understanding of technology with focus on delivering business solutions; Persuasive communicator with exceptional relationship management skills with the ability to relate to people at any level of business and management; highly ethical, trustworthy and discreet:
• Skilled Team lead with proven ability to lead and motivate teams to maximize productivity
• Leading a team, training and updating them
• Exceptional communication, analytical & inter personal and problem solving skills
• Friendly with an upbeat attitude
• Excellent decision making skills with a positive approach.

TECHNICAL SKILLS:

DB: Oracle 11g, Teradata SQL AssistiantSQL Server 2008

DW&BI Tools: Informatica 9.6.1, Datastage, Ab - initio, Business Object

Testing Management tools & Utilities: HP Application Lifecycle Management 12 (ALM)

Operating System: Windows, Unix, Linux

Agile Tool: Rally

Scheduling Tool: Autosys,Control - M

PROFESSIONAL EXPERIENCE:

Confidential

DWH /ETL Test Lead/Data Analyst

Responsibilities:

• Worked closely with the business stakeholders and end users to understand the structure and the pattern of data in the legacy system and identify the needs of the application
• Prepared data dictionary by mapping the front end fields of the application with their corresponding back end tables and columns for both the legacy and the target systems
• Performed extensive source data profiling to analyze and identify the junk data and the integrity gaps among the source tables and involved in framing the data migration requirements
• Experience in doing business analysis based on the User data/ requirements and prepare Business requirement documents.
• Analyzed the data model of the migrated version of the application and involved in framing the mapping between the source and the target data
• Validating and analyzing input files for test data preparation.
• SSIS package execution for data load in to DB2 and sub-sequent phases
• Performed extensive data validations of tables across all phases which includes count and data validations, duplicate checks, referential integrity checks, data reconciliation, data profiling and business scenarios validations
• Worked on status tracking in design and execution phases of the project and gathered Test Execution Metrics, Defect Metrics, reported the collected metrics to the project team and the clients

Healthcare DW Test Lead

Responsibilities:

• Preparing test plan and Test Execution, Defect Tracking is done in QC; once the Testing is completed; preparing the test summary and test result document and get the necessary approvals from the clients complete testing.
• Performed extensive data validations of tables across all phases which includes count and data validations, duplicate checks, referential integrity checks, data reconciliation, data profiling and business scenarios validations
• Ensure that the business, data and systems requirements are tested properly and those defects are identified and tracked.
• Perform data and business level validation on reports and data mart and perform UAT.
• Prepared and optimized technically complex queries on SQL server for validation.
• Thorough participation in the review of test cases against all the Mapping rules and creation of required test data

DW Test Lead

Responsibilities:

Opera is strategic data repository for controller’s core components architecture that is best described as the enterprise-wide framework for managing financial data that captures the front office components, such as trades, operations driven components, such as brokerage amounts and controllers driven components, such as fund allocations. This approach accomplishes a single P&L since Opera stores both front office balance sheet and a back office balance sheet simultaneously in its data model (when complete P&L data is sourced from both the front and back offices), reconciles key data elements, and applies adjustments to both. By design opera creates a consistent global view of controller's data, as it is only data source that maintains one data set containing all components.

Responsibilities:

• Adhoc Business Requirement bridge mitigation by providing analysis on the same so as narrow the gap.
• Support UAT testing for data preparation and use case testing.
• Deploying component as per release notes through COAST, NOLIO and subversion.

DW Test Lead/ Data Analyst

Responsibilities:

• Interfacing with business leaders and other application development teams; understanding of business opportunities for information sharing.
• Support UAT testing for data preparation and use case testing.
• Co-ordination with offshore testing team.
• Review test plan and test result documents for different modules and give sign off for Production move.
• Handling team of 5 offshore resources.
• Performing Smoke test in UAT along with testing team for validation of data.

DW Test Lead

Responsibilities:

• Co-ordination with offshore testing team.
• Review test plan and test result documents for different modules and give sign off for production move.
• Handled team of 4 and completed HBE 3R project successfully.
• Review test plan and test result documents for different modules and give sign off for production move.
• Handled team of 4 and completed HBE 3R project successfully.
• HBE SAS Enrollment Coverage part testing has been accomplished with coverage all business scenarios and later on post production validation for all historical load data.
• SAS enrollment historical loads tested in production successfully and jobs are running in PROD currently.

DW Test Lead

Responsibility:

• Ensure that expected data is loaded successfully from source systems to Data ware house Sec Master Area as per source to target mapping on Derivatives, Equity & Fixed income data.
• Updating the tracker used by different business users to make sure a set of data is correctly pushed ahead from one system to another.
• Handled the responsibility on offshore deliverables.
• Have taken the testing ownership on Security Master and e-Link to Datawarehouse interface testing efforts.
• Execution of pre data validations before initiating data processing into DW and verifies the in scope records to be processed.
• Execution of post validations on Green zone data, Back feed data and Sunset field validations after data loading in to DW.
• Modifying & updating the test queries according the changes in requirement done in mapping document and be prepared for next cycle.
• Analyzing the issues found and creating the new defects accordingly using HPQC and retesting the previous defects and closing whether it passes else reassigning for next cycle.

ETL Tester

Responsibilities:

• ETL error Log reporting, analysis and validations after loading the data by running ab-inito graphs
• Landing daily transactional data through UNIX scripts.
• Transformation and Cleansing.
• Expected data is loaded successfully from source systems to target as per source to target mapping.
• ETL application correctly rejects substitutes default values, ignores and reports invalid data.
• Restartability of scripts
• Regression testing

IDM Quotes Overview:

Responsibilities:

• All expected data is loaded. Comparing record counts between source data, data loaded to the warehouse and rejected records.
• All data is transformed correctly according to design specifications.
• Validate correct processing of ETL-generated fields such as surrogate keys.
• Validate that data types in the warehouse are as specified in the design and/or the data model.
• Test plan and Test cases preparation using requirement documents.
• Input Test data verification.
• Verification of data while processing input files through graph at Component level.

ETL Tester

Responsibilities:

• Assist in developing the test strategy by identifying appropriate testing strategies based on project quality and testing goals.
• Create or assist creation of the test approach for the release items.
• Creating test plan, test results to the Project/ Release Manager for Final Acceptance Test sign off purpose.
• Create test data for testing in QA environment provided if production data is not available.
• Execute test conditions/ plans.
• May serve as defect manager and perform activities as opening issues, monitoring defect status, communicating status, retesting and closing defects.
• Ensure that expected data is loaded from warehouse to New Agency Data Mart.
• Ensure that ETL application correctly rejects, substitutes default values, ignores and reports invalid data.
• ETL error Log reporting, analysis and validations.

ETL Tester

Responsibilities:

• Analyzing the Functional Requirement Documents and High Level Design Documents to provide the testing effort involved. Also Involved in the designing activities to understand the data flow of a project and plan the test effort accordingly
• Creating Test Plan document and present to client to get the approvals for the testing effort estimated; further analyzing the Data Architecture Specification document and preparing the Test cases in HP Quality Center 10
• Preparing test plan and Test Execution, Defect Tracking is done in QC; once the Testing is completed; preparing the test summary and test result document and get the necessary approvals from the clients complete testing.
• Participation in walkthroughs with the Business Analysts.
• Understanding the test requirements and functionality.
• Creation of test strategy and test cases based on Business Requirements and High Level Requirements.
• Peer review of test scenarios with respect to Business and High Level Requirements.
• Execution of test cases and generation of Test Result and Test Summary documents and sending them to the client.
• Generation of daily execution report and sending it to the client.
• Interaction with the development team.

ETL Tester

Responsibilities:

• Coordinated with developers and prepared and implemented test plans.
• Evaluated all requirements of business, systems and developed test plans according to needs.
• Documented and reviewed all test cases and procedures in Unit Test reviews with senior management.
• Organized all results and specifications and developed and implemented QA test scripts.
• Analyzed tests results and identified areas where regression tests could be conducted.
• Assisted operations and development teams and prepared various testing issues.
• Managed problem tracker and resolved all issues as identified in system.
• Ensured that all documents and products were in compliance with quality standards.

  Involved in testing process such as Analyzing Testing requirements, Designing SQL Test Script, Test cases, Analyzing Test data, Execute Test runs, gathering test execution results.

• Prepared and executed integration and system test cases using Quality Center.
• Defect Reporting & Retesting, Performed Regression testing using Quality Center.
• Performed DW Testing by Analyzing the Source and Target data using data validation, Constraint testing, Record count, Field to field testing.
• Verified Mappings and data stored in Source as well as destination database using SQL Queries.
• Test Execution, Defect Tracking is done in QC; once the Testing is completed; preparing the test summary and test result document and get the necessary approvals from the clients complete testing

DATA Analyst

Responsibilities:

• Writing optimized SQL queries to extract data from data warehouse as per business user requirement.
• Design and code query/report script.
• Interacting with the business users and understanding the requirement.
• Create scripts to retrieve, process and present data for the business users.
• To analyze over all business figures for Confidential circles in India.
• Responsible for complete Data Extraction, Reporting and Analysis.

ETL Developer

Responsibilities:

• Created the data model structure and E-R modeling with all related entities and relationship with each entities based on the rules provided by the business manager using Visio2003.
• Designed various mappings for extracting data from various sources involving flat files and relational tables.
• Extracting data from different sources and load into staging area and Load data from staging area to Dimensions and Facts.
• Used Designer to create source definitions, target definitions, reusable transformations, reusable mapplets and mappings.
• Used different transformations for loading the data into Oracle database e.g. Source Qualifier, Joiner transformation, Update Strategy, Lookup transformation, Rank Transformations, Expressions, Aggregator, and Sequence Generator.
• Developed and Monitored Tasks and Workflows using Informatica Workflow Manager.