Data Sql Server
Resume:
SAROJ
********@*****.***
ETL/BI/EDWH Test Analyst
PROFESSIONAL EXPERTISE:
● 6+1/2 years of diversified experience in the field of Information Technology Data warehousing using ETL Tools like Informatica, DataStage and Ab Initio.
● Experience working in various domains like Financial, Healthcare and Retail industries
● Experience in all aspects of project development life cycle especially in Agile and Waterfall methodologies.
● Expertise in designing the test scenarios and scripting the test cases in order to test the application.
● Experience in developing the Manual Test Suites and Automated test suites.
● Expertise in QA process and different levels of testing like unit, Functional, Regression, and Integration testing with business scenarios.
● Experience with integration testing of the applications using various sources like flat files, Sybase and oracle databases.
● Experience in Mercury Quality Center - Design Test Steps, Requirement Mapping to Tests, Executing Tests Manually, Defect Logging, Defect Reporting
● Experience with Integration testing of the applications using various sources like flat files, Sybase and oracle databases.
● Strong working experience in the Data Analysis, Design, Development, Implementation and Testing of Data Warehousing using Data Conversions, Data Extraction, Data Transformation and Data Loading (ETL)
● Extensive experience in writing SQL and PL/SQL scripts to validate the database systems and for backend database testing.
● Have extensive Knowledge in Microsoft tools EXCELL, ACESS ,POWERPOINT
● Extensively strong on databases including Oracle 10g/9i/8i, MS SQL Server 2000/7.0 and DB2
● Excellent experience working with ETL tools and performing testing on ETL tools like Informatica, Datastage, and AbInitio.
● Proficient in working with UNIX shell scripts using AWK on UNIX using puTTY Environment.
● Experience working with various Reporting tools and testing reports for drill down drill-up features and testing reports like cross-tab, dashboard, summary etc.
● Strong working experience in the Data Analysis, Design, and Testing of Data Warehousing using Data Conversions, Data Extraction, Data Transformation and Data Loading (ETL)
● Ability to quickly adapt to different project environments, work in teams and accomplish difficult tasks independently within time frame.
● Excellent communication skills and ability to work in-groups as well as independently.
● Initiative to learn new technologies and tools quickly.
TECHNICAL SUMMARY
ETL Tools: Datastage 9.x, Ab Initio Co>OS 2.1x, 2.13, 2.14, GDE 1.1x, EME, Informatica 8.6
BI Tools: Business Objects 5.1 /6.1/XIR2, Cognos 8.1 Series
Languages: C, C++, Visual Basic 6.0/5.0.,SQL, PL/SQL, Shell Scripting
Operating: Windows NT 4.0, MS-DOS, and UNIX 4.3.3
Databases: Oracle 9i/8i/7.x, MS SQL Server 7.0/2000/2005, TOAD, SQL*Loader, SQL*Plus
Hardware: HP UNIX, IBM AIX, SUN SOLARIS
EDUCATION:
Bachelor in Biological Science with minor in Medical Technology
Louisiana Tech University, Ruston, Louisiana, USA
EXPERIENCE:
PNC Bank/National City Corp, Cleveland, OH. Nov 2010-Till Date
ETL/DWH Test Analyst-T&A Data Mart
Responsibilities:
● Extensive experience in writing SQL and PL/SQL scripts to validate the database systems and for backend database testing
● Performed Functional Testing and Back-end Testing using the database comparable results Manually
● Tested the messages published by Informatica and data loaded into various databases
● Tested the data load process using the Informatica Power Center.
● Generated/Tested reports using free-hand SQL which had complex Business Logics for testing environment.
● Was involved in analyzing scope of testing the application.
● Test Strategy was created to test the all modules of the Data Warehouse.
● Updated the status of the testing to the QA team and accomplished tasked for the assigned work to the Project Management team regularly.
● Created the test data for interpreting positive/negative results during functional testing.
● The reports that were created in Business Objects were testing by running the SQL statements against the tables in the Oracle Database.
● Ran various Batch jobs using telnet service (Unix)
● Automated the entire Aggregation module using Win Runner, for Regression Testing.
● Used Bugzilla and HP Quality Center for Bug Reports and Defect Tracking.
● Performed Risk Analysis based on Defect Severity and Priority.
● Tested User Interface inconsistency and application functionality.
● Developed test scenarios for testing Enterprise Data warehouse and Credit Data Mart data in Oracle environment.
● Worked with Data Extraction, Transformation and Loading (ETL).
● Performed System Integration Testing and Integration Testing between different modules.
● Heavily involved in interacting with UNIX Shell scripts.
● Analyzed Business Requirements and Developed the Test Plan, Test Scripts and Test Cases
● Developed Test Plan and Test Cases for the entire module of Data mart.
● Identified the Test Cases to be automated and lead the effort for automating the product.
● Ran test cases for the warehouse in Oracle.
● Worked with drill down, prompts, hierarchies, calculations, formulas, sorts, drop down list, breaks etc in reporting and validated the same.
● Worked with business team to test the reports developed in Business Objects
● Tested whether the reports developed are as per company standards.
● Involved in testing the XML files and checked whether data is parsed and loaded to staging tables.
Environment:Informatica8.6, Oracle, SQL, PL/SQL, DB2, TOAD, ERWIN, Windows XP Professional, Business Objects, Win Runner, Bugzilla, Quality Center 10.2, XML, XSD, Unix, Shell scripting.
State Farm Insurance, Bloomington, IL Jan2009-May 2010
ETL Tester –Credit Management Data Warehouse
Responsibilities:
● Identify issues, information and behaviors during the adoption of a proprietary information management system.
● Integration Testing performed for the entire System after unit testing by executing the complete flow of the application system.
● Used the Data Stage Designer to test processes for extracting, cleansing, transforming, integrating and loading data into data warehouse database
● Wrote MACROS in Teradata to generate less channel traffic and easy execution of frequently used SQL operations and improves the performance.
● Involved in testing data mapping and data conversion in a server based data warehouse
● Expertise in data quality, data organization, metadata and data profiling
● Tested several complex reports generated by Cognos including Dashboard, Summary Reports, Master Detailed, Drill Down and Score Cards
● Worked with Development team to create necessary operational documents and transition daily support activities with Tier1 team
● Created test plan, test case and test script documents and prepared the traceability matrix, test summary report extensively.
● Well versed with SQL performance tuning techniques and suggested effective SQL scripts to DBA’s for faster retrieval of data in QA database.
● Accelerate the rate of adoption of the system, improve the quality of the data being input and generated, and promote accountability amongst the staff and users.
● Made recommendations on potential functional and technical improvements to planned or existing system components and applications.
● Supported Customer Data Integration projects through Business Intelligence and Data Warehouse system integration
● Extensively participated in walkthrough meetings with the business analysts and developers to clear requirement gaps and understand the
● Involved in testing of Universes from different data sources like Oracle/SQL Server.
● Translated written Business Requirements Documents into Test cases and test scripts executables.
● Tested the reports using Business Objects functionalities like Queries, Slice and Dice, Drill Down, Cross Tab, Master Detail and Formulae etc.
● Completed knowledge transfer to employees enabling them to prepare ETL test scripts.
● Analyzed legacy data sources, prepared data conversion approach.
● Verify data movement occurs correctly between each step (data storage) in the ODS. Data Mapping performs as defined in Mapping Specs / Use Case
● Worked with fixing the production issues for multiple projects and supported night ETL jobs/mappings/batches/procedures.
● Involved in extensive DATA validation using SQL queries and back-end testing
● Used SQL for Querying the DB2 database.
● Used TOAD Software for Querying ORACLE and Used WinSQL for Querying DB2.
● Performed periodic checks to run crosscheck against QA/SIT/PROD environments to ensure it is up and running.
Environment: Autosys, Business Objects 6.5/XIR2, Teradata V2R6, MLOAD, FLOAD, SQL Assistant 6.0, WinSQL Professional,Erwin 4.1, ETL (Datastage 8.x), Oracle, SQL Server 2008, T-SQL, DB2, TOAD 7.6, MVS Z/OS, COBOL II, Copy Books, IBM AIX 5.2, UNIX, Shell Scripting (Korn Shell Scripting), SQL Server 2005, AS 400, , Windows XP Professional, IBM AIX 5.1, MS Visio 2003.
CAPITAL GROUP, SFO, CA Mar 2008-Dec 2008
ETL/ BI TESTER-SAR DWH
Responsibilities:
● Cross-Verified business rules in ETL according to business requirements
● Extensively tested the reports generated from Data Warehouse.
● Developed unit test cases, configured environments, and prepared test data for testing.
● Wrote PL/SQL /Complex SQL queries for system testing the datawarehouse and the reports.
● Supported the extraction, transformation and load process (ETL) for a Data Warehouse from their legacy systems using Informatica and provide technical support and hands-on mentoring in the use of Informatica for testing.
● Developed numerous Test Plans and Test Cases for the entire module of Data mart.
● Identified the Test Cases to be automated and lead the effort for automating the product.
● Ran various Batch jobs using telnet service (UNIX)
● Automated the entire Aggregation module using Win Runner, for RegressionTesting.
● Created test plans and performed unit testing for the Ab Initio graphs developed using the Ab Initio validate components.
● As QA Tester, performing responsibilities with both the functionality and back end testing.
● Developed SQL scripts to validate the data loaded into warehouse and Data Mart tables using Informatica.
● Developed Reports and Graphs to present the results to the management.
● Developed several Unix Shell scripts for running the jobs.
● Performed Data Driven Testing of the Application for different users/data sets
● Preparation of test data for various levels of testing.
● Gave production support in scheduling and tested this data with the existing data.
● Tested and supported several ReportNet Reports and Powerplay cubes.
● Involved in installation of Cognos Toolset and assisted in creating users and assigning them appropriate access rights for the entire testing team.
● Tested several reports and automated using Quick Test Pro.
● Used SQL queries and custom programs to perform data validation.
● Extensively involved with backend testing by writing complex SQL queries.
● Involved in complete project software development life cycle (SDLC) and Software Testing Life Cycle (STLC).
● Reported periodic project status and updates to the QA Lead and QA Manager
● Used Test Director to organize the Win Runner Scripts and schedule test execution.
● Developed SQL scripts to validate the data loaded into warehouse and Data Mart tables using Informatica.
● Developed Reports and Graphs to present the results to the management.
● Performed Data Driven Testing of the Application for different users/data sets.
● Preparation of test data for various levels of testing.
● Gave production support in scheduling and tested this data with the existing data.
● Developed Test cases for the data warehouse in Oracle System.
● Worked on Oracle to implement the project and written the Test Plan and Test Cases for the module Sales Cycle.
Environment: ETL (Informatica), Oracle, SQL Server, DB2, Mercury Quality Center 8.2 (Test Director), Business Objects 6.5, EssBase, Maestro, TOAD, Windows XP Professional, MS Excel 2003, MS Word 2003, UNIX, Teradata.
Target Corporation, Minneapolis, MN Jan 2007-Mar 2008
QA Analyst- SRDW-Sales Reporting Data Warehouse
Responsibilities:
● Reviewed requirements documented (Mapping Document/Report Specs) by Business Analyst for thorough understanding of the application.
● Experience with Software Development Lifecycle (SDLC) and processes for software testing / quality assurance guidelines.
● Developed Test Plans, Test Scenarios, Test Cases, Traceability Matrix, Test Summary Reports and Test Execution Metrics.
● Involved in writing Complex queries using SQL.
● Participation in Requirement / Use Case analysis.
● In depth technical knowledge and understanding of Data Warehousing, Data Validations, OLAP, Oracle and ETL.
● Validating the load process of ETL to make sure the target tables are populated according the data mapping provided that satisfies the transformation rules.
● Validating Informatica mappings, workflows, sessions and Jobs.
● Actively participating in project specification reviews, writing and maintaining QA technical documentation.
● Decompose End-to-End scenarios into Business Process Components and create them in BusinessComponents Module in Quality Center.
● Understand business /transformation rules which are involved in developing the source to target mappings, write Complex SQL queries to reflect those rules and be able to validate the mappings by running these test scripts and checking if the data in target table populates correctly by writing complex SQL queries.
● Tested the ETL Informatica mappings and other ETL Processes (Data Warehouse Testing).
● Assisted in creating fact and dimension table implementation in Star Schema model based on requirements.
● Effectively communicated testing activities and findings in oral and written formats.
● Testing included Unit, System, Functional, Regression and User Acceptance testing.
● Writing SQL queries using Intersect, Minus, Sub Queries, Inline Views, and Union in Oracle.
● Experience in document traceability of requirements to tests and capture evidence of test pass/fail.
● Reported the bugs through email notifications to developers using Quality Center.
● Involved in validating the aggregate table based on the rollup process documented in the data mapping.
● Extensive Experience in working with Quality Center.
● Created Test Cases using HP Quality Center tool.
● Executed all the Test Cases in the Test Environment and maintained them and documenting the test queries and result for future references.
● Retested the modifications, once bugs are fixed after reinstalling the application.
● Developed presentation and testing implementation learning to other testing resources for cross functional training.
● Validating the Data files from source to make sure correct data has been captured to be loaded to target tables.
● Identify/debug, troubleshoot, modify, document, test the production issues and create production support schedule.
● Participated in reviews of code walkthroughs, data models, and design documents.
● Reviewing of business requirement, design documentation for completeness and testability.
● Direct hands-on experience with ad hoc query programs and automated testing tools.
Environment: Informatica 7.x, TOAD, Oracle, Mercury Quality Center 10.0, JAVA, J2EE, QTP 10.0, Web Services, Web logic, Windows XP, Encompass, Micro strategy, MS Access, Windows 7.
Credit Suisse, Jersey City, New Jersey Oct 2005- Jan 2007
QA Analyst
Responsibilities:
• Involved in testing migrated data from various heterogeneous sources like text files, XML files, SQL server, excel and Access to SQL Server using DTS as an ETL tool.
• Attender walkthrough meetings with the Business Analyst to clarify
• Extensive analysis on functional specification and technical design documents and Optimized SQL queries for improved Performance and availability.
• Monitored Strategies, Processes and created complex Procedures and functions to ensure the Data Integrity, Optimized and reduced Data Redundancy, maintained the required level of security for all production and test databases.
• Prepared numerous test cases, test scripts and test plans for every release
• Extensively used SQL for testing the ETL logic, the target data warehouse and optimized the SQL for performance tuning.
• Performed performance testing on defined SLA’s for monitoring ETL load times
• Tested for SCD Type I and Type II scenarios.
• Extensively used Mercury Quality Center for logging and tracking defects.
Environment: MS SQL Server 2000, DTS Services 2000, Query Analyzer, T-SQL, Business Object 5.1, IBM AS/400, MS Excel, Flat files, PL/SQL, SQL, Oracle 8i, SQL*Loader, Toad 7.0, Windows 2000.
Contact this candidate